Community Forum

Topic Replies Activity
TK
Example: Freeform sheet reference embedded in modular formula... by Tarjei Kirkesaether Normal topic
I finally figured out how to embed freeform sheet data in modules (which is useful when embedding SAP and other live...
0 5y
MH
Language settings by Manuel Hernandez Normal topic
Hi all, Do you know how to change Language settings in Excel so that it applies =TEXT() in English? I'm using a...
1 5y
AK
Building model through a Template vs Modano by Anurag Kushwaha Normal topic
Hi, I saw in one of the blogs at chandoo.org where Michael mentions that templates don't work. I'm not sure, if I...
3 5y
AL
Build Tab by Anton Lezhja Normal topic
I'm new to Modano. I downloaded Modano X, but did not see the Build Tab as indicated in the on-line manuals. Also...
2 5y
Office Fund Example Model by James Longden Normal topic
The attached is the fund model from the Australia Unity Office Fund Example build. Requires the PROPERTY library...
0 5y
JB
Time Series error when inserting new module (after update to Modano... by Jos Bollen Normal topic
Today I update to Modano X. When I try to Insert a new module , a time-series error occurred ( see attached files)....
1 5y
AS
Combine time series by Anthony Stevens Normal topic
Hi - I am struggling to combine two different types of assumptions - annual based and monthly based. I have different...
1 5y
RS
Revolving Debt Facility by Ryan Shoemaker Normal topic
Is there a sample debt module that includes a revolving debt facility? Looking to include a revolving facility that...
3 5y
RW
Need more instruction on ways to customize financial statements.... by bob way Normal topic
I'm scared if i erase the wrong block, the world blows up.
5 5y
TK
Using "Exit" rather then "Close" in Excel 2016... by Tarjei Kirkesaether Normal topic
I'm not sure if this is a universal problem but on my setup closing any individual workbook in Office 2016 takes a...
1 5y
Monte Carlo Simulator - 2018 World Cup by James Longden Normal topic
It's back! Modano's World Cup Monte Carlo Simulator. The only spreadsheet in the world that will predict all the...
4 5y
AB
Modifying income statement presentation by Amadeo Bejec 1 Normal topic
I am trying to build a  budgeting and planning model using the Financial Model Wizard.  However, I would like to make...
0 5y
AK
Unable to use free modules for certification by Anshul Kuthiala Normal topic
Hi, I have being doing the Modano certification course using the community edition of Modano. I was able to download...
0 5y
Stretching out Dashboards by James Longden Normal topic
With clients working with the monthly content, we often get asked how to take something like the Financial Summary and...
0 5y
Linking new asset and liability type to financial statements by Josh B Normal topic
Hi All We have a client that has factoring revenue (buys other businesses debtors for a fee). The issue I'm facing is...
5 5y
ND
Targetting capital structure by Neal Davies Normal topic
what is the preferred best practice approach to modeling a target capital structure in Modano. In some instances...
2 5y
Dashboard Modules - Print Area by Jun Yan Normal topic
Hi all, Quick one around dashboarding. Anyone have experience setting up dashboard modules with default print areas...
2 5y
WM
Category block total on top - want to move to bottom by Winthrop Morgan Normal topic
Hello Fellow Modanoers! Hope you can help me with what should be a simple fix, but isn't for me.  I have one category...
2 5y
SB
How to adjust for scrap/ resale value for capital assets by Sonabh Bubna Normal topic
Every capital asset that is bought has a fixed life and generally some resale value at the end of its life. And the...
1 5y
WM
Error checks number of decimals by Winthrop Morgan Normal topic
Can anyone help me avoid having an error check flag a discrepancy of 0.00000001 between two dollar amounts?  My error...
1 5y
TK
Non- Modano specific - Excel to PowerPoint add-in by Tarjei Kirkesaether Normal topic
Hi all, Does anyone have any good recommendations for an easy to use Excel to PowerPoint add-in (which must work with...
0 5y
TK
Split Component? by Tarjei Kirkesaether Normal topic
Is there a way of splitting a component? I need to add Categories Layout Section to a section in the middle of a large...
2 5y
NO
Free Form Formulas versus Links Again by Nick Ogle Normal topic
Hello Team, I cannot get away from this ongoing problem. It probably me, but.... I am going around and around in...
2 5y
Ch
How to delete cell block by Chun hoe tan Normal topic
Hi Team, How do you go about deleting a cell block that is currrently referenced to other components within the active...
3 5y
NO
Module Content Report - Partially Linked Module Warning by Nick Ogle Normal topic
Hello Team I am running simultaneously as AS IS and Target Operating Model (TOM) case for 8 companies. Each Company...
1 5y

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 Sheetconversion factorcopy and pasteCopy Pastecost of goods soldCover SheetcrashingCreating ModulescreditorsCreditors CategorycustomCustom Formulascustom modulescustom themesDashboardsDataData TablesdatabaseDays TermsDCFdebtdebt interestDebtor Daysdebtorsdenominationdiscussiondividendsdocument management systemsDrop 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 & wagesScenario 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 AssumptionstranslationUI Runtime ErrorValuationVariable DriversVariance AnalysisVBAVersion Controlweeklyweekly cash flowsweekly cashflowweekly time seriesWindows 11Windows DefenderWorkbook 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