Community Forum

Topic Replies Activity
TK
Modano Version number as cell value by Tarjei Kirkesaether Normal topic
Is there a way of extracting the Modano version number as a cell value (i.e 1.1.1.0) ideally without using VBA?  I'm...
3 6d
Intercompany Dividend Eliminations by James Longden Normal topic
Attached is a workbook that steps through the eliminations required for removing intercompany dividends between a...
3 6d
Cash Bridge Chart Module by James Longden Normal topic
We recently had a client looking to get a better visual representation of their forecast closing cash and key movements...
2 1w
AZ
Total Monthly Figures to Quarter and Year by Aaron Zhou Normal topic
I have the Modano spreadsheets built by month, from Jan 2019 to Dec 2024, 60 months. I want at the end of each quarter...
4 1w
HC
ChatGPT by Hengjia Chen Normal topic
As a holiday project I created a custom GPT named Ask Modano. I am trying to use it to answer questions like a FAQ...
2 2m
MT
Revenue & Expense Modelling around School Terms by matt.tapps Normal topic
Hey all, I'm wondering if anyone has any module examples for modelling revenue that is generated on a school term...
1 2m
BM
Weekly cash flow forecast for a monthly time series historical and f... by blakem Normal topic
A while back I am sure James posted about Monthly to weekly cash flow forecasting?  What was the name of the post -...
5 2m
GM
Changing Multiple Allocations at once by gmajor Normal topic
Hi All, Is there a shortcut way of changing (say) all the Expenses Allocations for Creditors from "None (Cash)" to "...
2 2m
Wi
Change the Color of Historical Data by William Thomson 1 Normal topic
How does one change the color of historical data...for example, how can I change the color of the text circled in red.....
3 3m
Export financials in database format table by Josh B Normal topic
Hi I have only just started using Modano and already see massive benefits. I was able to build a 3-way model in hours...
9 4m
YS
Best way to add custom named range by Yury Suturin Normal topic
What is the best way to add custom non Modano Named range defined in memory? Name Manager in Modano book is replaced...
2 4m
HC
Multi workbook and Memory Consumption by Hengjia Chen Normal topic
I bump into a problem this week with a multi workbook setup 14 workbooks, three tiers with parent, child and grandchild...
3 4m
CT
Forecasting assumptions is yearly but need monthly for modelling... by Cornell Tsiang 1 Normal topic
Hello I am using the single entity model (COA4) with budgeting and scenario. Historical data is very limited, only 2...
3 4m
CFO Dashboards by James Longden Normal topic
Hi Team. This content is aimed at reporting for CFOs, key stakeholders and decision-makers.  The aim of a CFO...
6 4m
YS
Learning material questions by Yury Suturin Normal topic
Since I am going through the training modules - thought it may be useful to discuss some items which look to me like...
0 4m
FP
Running Modano files with Oracle Crystal Ball [ex. Monte-Carlo simul... by Filipe Aguiar P... Normal topic
Hi Community Forum, Can anyone tell me how to use a Modano file with a spreadsheet-based application like Oracle...
3 4m
NO
Fixed Asset Disposal Proceeds - Fixed Asset Module / Capital Expendi... by Nick Ogle Normal topic
Observation : The Fixed Asset Module does not appear to make provision for disposal proceeds or the end date of the...
5 4m
HG
IRR % by Halldór Gunnlaugsson Normal topic
Hi All Does anyone understand why the OO output doesn´t calculate IRR profiles??  I´m probably not using the right...
3 4m
WH
Monthly model during investment phase, switching to semi-annual duri... by Will Harrison-Cripps Normal topic
Hi, Is there a way of having two separate time series within the same model, so that some inputs and outputs are...
5 4m
HC
Troubleshoot module as category by Hengjia Chen Normal topic
I am looking for method to troubleshoot an existing error from module as category setup. The category is the summary...
9 4m
DS
Filtering and Name ranges in Modular worksheets by David Shi Normal topic
HI all, Great to see the Modano Forum up and running. This will be game changer in creating a community. I just wish...
11 4m
WM
Should I install Windows 11? Will it affect Modano? by Winthrop Morgan Normal topic
I keep getting the "Upgrade to Windows 11 is ready on your PC" message. Will it play well with Modano?
6 5m
SM
Cashflow impact on historical working capital movements by Sajid Mafahir Normal topic
Hello Modano Members, I'm struggling to understand how the cashflow works for working capital movements. For example...
0 5m
Roll up of enitre category block to another category by Josh B Normal topic
Hi I am attempting to roll up a category block total to a single category in another category block. The example I...
5 5m
Managing AutoSave when using Modano modular workbooks by Michael Hutchens Normal topic
AutoSave is one of the most confusing and frustrating features of Microsoft Excel, primarily because most people don't...
6 6m

Pages

Tags

32-bit64-bitAccruals vs. Cashalert checksAmounts & Growth Ratesannual assumptionsAnnual BudgetAPIAsset RevaluationsAsset Salesassumption stylesATPauditingauto-recoverAutoSavebackupBalance SheetBeginnerbowtiebudget balance sheetBudget Income Statementbudget variance analysisBusiness UnitsCalendar YearCapexCapital IQCapital structurecareers in modellingCash Flow StatementCash Forecastcash payment delaysCash SweepCategoriescategories within categoriesCategory Blockscategory layout sectionCell BlocksChange Versionchart of accountsChartscircular referencesclassifications Multi Business Unitscluster IDCo-AuthoringCOGSCollaborationcolorsColumn WidthcompatibilityConsolidationsContentContents Sheetcontrolsconversion factorcopy and pasteCopy Pastecost of goods soldCover SheetcrashingCreating ModulescreditorsCreditors CategorycustomCustom Formulascustom modulescustom themesDashboardsDataData SourcingData TablesdatabaseDays TermsDCFdebtdebt interestDebtor Daysdebtorsdenominationdiscussiondividendsdocument management systemsdrop down box bugDrop Down Boxesdrop downsDuplicatedynamic textEliminationsEquityerror checksExample ModelsExcel File FormatsExcel PerformanceexportExport Modulesfactoringfailure to openfilteringFinancial Modeling World CupFixed AssetsFontsforecastformulasFreeformfreeform formulasFreeze PanesFund Managementfunds managementGANTTGantt ChartgearingGraphics AccelerationGraphsGridlineshardwareheadingsHide ColumnsHistorical Data MappingHyperlinksImport Assumptionsincome statementInputsInsert ColumnInsert CommentIntercompanyInvalid PrecedentsinventoryIRRkeyslanguagelaptopsLarge FilesLarge WorkbooksLast historical monthLBOLearning & AssessmentlibrariesLinked WorkbookslinksListed companiesLookup TableslookupsM&AMacMacromanufacturingMappingmemoryMemory LimitsMirrormirroringModano XModule As CategoryModule componentsModule Content ReportModule LinksModule Namesmodulesmodules as categoriesMove AssumptionsMulti Business UnitsMulti-Business Unit PerformanceMulti-WindowmultilingualMultiple Periodicitiesmultiple time seriesMultiple WorkbooksNamed Formulasnon-financeOneDriveOptimize ModanoOptimizingother expensesother revenueOther RevenuesOutputsOverview SheetPanel Boardpartially linked modulesperiodicitiespinch pointPowerQueryPrepaid ExpensesPresentationsProject ManagementPropertyProperty FeasibilityProperty Feasibility assumptionsProtected Sheetsrange namesRange Namingrecover filesredundant categoriesRegionsRevenue DebtorsRevenue driversReverse Time SeriesreviewrevolverRibbonrolluprough calculationsSaaSsalaries & wagesScalingScenario AnalysisScenariossearch & repairSeasonalitySensitivitiesSharePointSharingSheet NamesSheet Namingshort term assetshort term liabilitysimple taxsimulationspecificationsStart-Upstylessubtotalstabstaxteam membersTeamsthemestime framestime seriesTime Series AssumptionsTime Series Sheet Columnstime series; monthlyTop 5 Expenses DashboardTotal Row On TopTrackingtracking categoriesTransfer AssumptionstranslationTraverseUI Runtime ErrorValuationVariable DriversVariance AnalysisVBAVersion Controlweeklyweekly cash flowsweekly cashflowweekly time seriesWindows 11Windows DefenderWindows UpdatesWorkbook StructureWorkbook ThemeWorking CapitalXeroXLSBXML metadata write errorYtd
New posts
No new posts
Hot topic with new posts
Hot topic without new posts
Sticky topic
Locked topic
Subscribe to RSS - Community Forum