Community Forum

Topic Replies Activity
Disposal of fixed assets Normal topic
Hi all What is the best way of incorporating the disposal of fixed assets into a Modano model?  I have included the...
3 8y
New Link type Normal topic
Hi Modano I've created a new Link called "Net VAT", which I have been able to successfully Link Out from the line item...
3 8y
Visual identification of link-ins and link-outs Normal topic
Quick query about link-ins and link-outs. Is there a feature, similar to cell block shading, that would allow me to...
2 8y
Import assumptions tool - default header and data column? Normal topic
How do I set up my source workbook so that the import assumptions tool automatically picks up the correct header column...
1 8y
Change "Mixed" Formatting Normal topic
Hi, I want to change the formatting of "Mixed" cells (containing formulas and hardcoded strings or values) from green...
9 8y
Reverse Chronological Order Normal topic
The way the current modano time series works is left to right (i.e. 2011 - 2016). Is it possible to reverse this so...
6 8y
Custom Fonts in Module Normal topic
Hi guys, Is there anyway to add custom fonts to modular areas? There are custom corporate fonts that I would like to...
3 8y
Change Tab Colour Normal topic
Hi everyone, After I developed a modular spreadsheet with the Financial Model Wizard, I changed the colours of the...
2 8y
Looking For A Sample Manufacturing Model Normal topic
Does anyone have a sample manfufacturing model they would be willing to share? I'm interested is seeing how modules...
2 8y
Cell & Sheet Naming Conventions Normal topic
Can we have Naming conventions used  (LU_TS_Mth, DD_TS_Fin_Yr_End_Mth, WC_Ann_TO, HL_DEBTORS_OUT) with description in...
2 8y
What is the difference between US, UK, AU, and NZ (countries) versio... Normal topic
What is the difference between US, UK, AU, and NZ (countries) versions of Modano Models ?
1 8y
2D categories and then transposing horizontal categories block to ve... Normal topic
I have a model with Time Series module and want to add a kind of allocation matrix for working hous for roles to the...
4 8y
Column Width Normal topic
Hi guys Watching videos at your channel at YouTube - great learning tool! Have a minor question - when I am trying to...
10 8y
Dynamically adjusted number of categories Normal topic
Hi guys Not sure if that was discussed before, looked at forum and at learning stuff, didn't find it. So what I am...
0 8y
Spin Off Category Block error Normal topic
When I try to spin off a category block I get the following error I don't really understand what it means....
1 8y
Modano broken on Excel 2010 by Windows Update (KB3178690) Normal topic
The latest Windows update appears to have broken Modano on my computer (Windows 10 + Excel 2010). Has anyone else...
8 8y
Multiple Workbooks & Export Modules Normal topic
Currently I'm learning to consolidate using the multiple workbooks feature, and if I'm not mistaken the available...
2 8y
Optimise workbook (not Modano-specific) Normal topic
I have a Modano model that has grown a rather large memory footprint. Now, I have upraded my computer to 64bit and...
3 8y
GANTT Chart in Modano? Normal topic
Is there any way to produce a GANTT chart in Excel using Modano?    
8 8y
Categories within Categories Normal topic
Hello.  I wanted to see if there was a way or a workaround to have categories within category sections. What I'm...
1 8y
Password Protection on File Normal topic
I have been looking at some of your workbooks on the website, but when I open them they have password protection on....
5 8y
New Time Series set Restrictions Normal topic
Does anyone know what the actual restrictions on modifying time series are in Modano? I'm building a model using...
3 8y
Capital IQ Normal topic
Hi Modanoers, Before I go and develop capital IQ modules or customise existing historical financials has anyone got an...
0 8y
Error & Alert Checks inside category layout sections (within cat... Normal topic
Hi all, Has anyone got a good way of creating an error or alert check flag within a categories layout section? It...
4 8y
Moving Folders with Linked Workbooks Normal topic
Hi Modano, I tried copying some folders with linked files in them from my company shared drive to my C drive. I found...
1 8y

Pages

Tags

32-bit64-bitalert checksAmounts & Growth RatesAnnual BudgetAnnual OutputsAPIArray FormulasAsset RevaluationsAsset SalesATPauditingauto-recoverbackupBalance Sheetbowtiebudget balance sheetBudget Income Statementbudget variance analysisBusiness UnitsCalendar YearCapexCapital IQCapital structurecareers in modellingCash Flow Statementcash payment delaysCash SweepCategoriescategories within categoriesCategory Blockscategory layout sectionCell BlocksChange Versionchart of accountsChartscircular referencesclassifications Multi Business UnitsClientscluster IDCo-AuthoringCOGSCollaborationcolorsColumn WidthCommunity EditioncompatibilityConsolidationsContentContents Sheetcontrolsconversion factorcopy and pasteCopy Pastecost of goods soldCover SheetcrashingCreating ModulescreditorscustomCustom Formulascustom modulescustom themesDashboardsDataData SourcingData TablesdatabaseDays TermsDCFdebtdebt interestDebtor Daysdebtorsdenominationdividendsdocument management systemsdrop down box bugDuplicatedynamic textEquityerror checksExample ModelsExcel File FormatsExcel PerformanceexportExport Modulesfactoringfailure to openfilteringFinancial Modeling World CupFixed AssetsFontsforecastformulasFreeformfreeform formulasFreeze PanesFund Managementfunds managementGANTTGantt ChartgearingGraphics AccelerationGraphsGridlinesGroupinghardwareheadingsHide ColumnsHistorical Data MappingHyperlinksImport Assumptionsincome statementInputsInsert ColumnInvalid PrecedentsinventoryIRRkeyslaptopsLarge FilesLarge WorkbooksLBOLearning & AssessmentlibrariesLinked WorkbookslinksListed companiesLookup TableslookupsM&AMacMacromanufacturingMappingmemoryMirrormirroringModano XModule componentsModule Content ReportModule LinksModule Namesmodulesmodules as categoriesMove AssumptionsMulti Business UnitsMulti-Business Unit PerformanceMulti-WindowMultiple Periodicitiesmultiple time seriesMultiple Workbooksnon-financeOneDriveOptimizingother expensesother revenueOther Revenuesoutline levelsOutputsOverview SheetPanel Boardpartially linked modulesperiodicitiespinch pointPowerQueryPrepaid ExpensesPresentationsProject ManagementPropertyProperty FeasibilityProperty Feasibility assumptionsProtected SheetsProtectionrange namesRange Namingrecover filesredundant categoriesRegionsRelease Excel Workbookrelease workbookRevenue DebtorsRevenue driversReverse Time Seriesreviewrevolverrolluprough calculationssalaries & wagesScalingScenario AnalysisScenariossearch & repairSeasonalitySensitivitiesSharePointSharingSheet NamesSheet Namingshort term assetshort term liabilitysimple taxspecificationsStart-UpstylessubtotalstabstaxTeamsthemestime framestime seriesTime Series AssumptionsTime Series Sheet Columnstime series; monthlyTop 5 Expenses DashboardTotal Row On TopTrackingtracking categoriesTransfer AssumptionsTraverseValuationVariance AnalysisVBAVersion Controlweeklyweekly cash flowsweekly time seriesWindows 11Windows DefenderWindows UpdatesWorkbook StructureWorkbook ThemeWorking CapitalWorking Capital; Creditors Category; drop down box bugXeroXLSBXML metadata write error
New posts
No new posts
Hot topic with new posts
Hot topic without new posts
Sticky topic
Locked topic
Subscribe to RSS - Community Forum