Community Forum

Topic Replies Activity
Days vs Terms Modeling by James Longden Normal topic
You might see reference to "days" versus "terms" in reference to working capital.  The following example illustrates...
3 4y
How can We Remove blanks from a drop down list? Normal topic
This one has me tearing my hair out.   I have a category group of 32 items.  The user can select a check box next to...
3 4y
Dynamic Module Name Based on Categories Normal topic
Hi Everyone, I noticed in the Template Consolidated models, the individual module names are dynamically linked to the...
1 4y
Misalignment of controls after insertion or categories addition... Normal topic
For some reason the categories-based controls within some of my modules are not in line after module insertion, such as...
4 4y
Contra Revenue / Discounts and Bad Debt Normal topic
Noobie here.  I'm exploring building a model that will involve presentation and analysis of Contra Revenue (expected...
0 4y
Pinch Point / Bowtie Models Normal topic
Does anyone have an example of a "Pinch point" or "Bowtie" model that they would be willing to share?  I am analyzing...
0 4y
Add Sensitivity Factors to Dashboards by James Longden Normal topic
Another question that came through support recently: How can I add a sensitivity factor to a dashboard, so that the CFO...
0 4y
How do you add a new classification for a multi unit business model... Normal topic
Hi  I have the two in-built business unit classifications, but I would like to make a third one e.g title would be "...
0 4y
Adding Opex to Multi-Business Unit by James Longden Normal topic
A questions came up on a support call the other day, asking how to insert a head office opex module into the Multi-...
0 4y
Using data from google sheets into modano Normal topic
Hi Modano team, What is the most efficient way to connect data from google sheets into modano? Lets say I'm building a...
0 4y
Other Revenue/Expenses outputs Normal topic
Can anyone explain how to make the outputs from the ‘other revenue and expenses’ module link in to a different section...
3 4y
PowerQuery Integration Normal topic
Hi all! Wanted to see whether anyone has toyed around with combining Power Query into a modular workbook. We've...
0 4y
Feasibility and sell Normal topic
Hi Everyone!. If I want to do a model with the property feasibility portion but I am not gonna hold for rent but sell...
0 4y
Error in Scenario Data Tables Normal topic
Hi Modano team, I'm trying to understand the scenario manager module from the available example model, but it shows...
2 4y
IRR % Normal topic
Hi All Does anyone understand why the OO output doesn´t calculate IRR profiles??  I´m probably not using the right...
2 4y
Multi-Business Unit - size limitations Normal topic
Looking for some advice from others who have developed using the Multi-Business Unit Model. I have created a simple 5yr...
3 4y
Naming duplicated/mirrored modules setting Normal topic
Hi, Is there a setting in Modano that will bring up the Module Naming dialog box when duplicating or mirroring modules...
5 4y
Supplier Due Diligence Normal topic
Morning, I am working on a Public Sector Procurement. Various suppliers are being considered. ITTs (invitations to...
1 4y
R&D Tax Incentive Normal topic
Hi Has anyone added in calculations for the Australian R&D Tax Incentive into the corporate tax module? Would be...
4 4y
Monthly model during investment phase, switching to semi-annual duri... Normal topic
Hi, Is there a way of having two separate time series within the same model, so that some inputs and outputs are...
4 5y
How to automatically align the time series of independent modular wo... by Michael Hutchens Normal topic
Hi Guys, We've had some of our more advanced users ask if there's any way to automatically align the time series...
0 5y
Import Assumptions into single Category Block without overwriting un... Normal topic
I'm hitting an issue with an Import from xls -> Modano model, where I have a single category block that I don't want...
2 5y
Break up large model into multiple linked workbooks Normal topic
Does anyone have any experience in breaking up large workbooks into smaller, linked workbooks (i.e. creating a Project...
4 5y
Funds Management - Geared Module Normal topic
Hi, do you have a module to add to the funds management template to allow gearing? Or a template with gearing already...
1 5y
Easy conversion from weekly to monthly or annual financial statement... Normal topic
Hello, is there an easy way to convert from weekly to monthly or annual financial statements? Maybe someone can send...
0 5y

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