Workbook map: fpna_month_end.xlsx

Generated by Power Migrate 0.1.0a1. SHA-256 1ee4a1f3e378e3e9629e9c64f2b1f7b1decc29c9301882895eb365abbcd5c2bb.

At a glance

Sheets

Sheet by sheet

• Assumptions: 22 populated cells; 1 formulas in 1 blocks (1 single); 9 input cells read by formulas; 1 final outputs. Feeds: Costs, Orders, P&L, Revenue. Flags: formula_like_text (1), volatile_function (1).
• Lookups: 48 populated cells; no formulas (data or lookup sheet); 42 input cells read by formulas. Feeds: Orders. Flags: merged_cells (1).
• Orders: 3612 populated cells; 2099 formulas in 8 blocks (8 column); 1206 input cells read by formulas; 301 final outputs. Reads from: Assumptions, Lookups. Feeds: Dashboard, Revenue. Flags: cached_error (8).
• Revenue: 211 populated cells; 193 formulas in 8 blocks (3 row, 2 table, 2 column, 1 single); 12 input cells read by formulas; 16 final outputs. Reads from: Assumptions, Orders. Feeds: Dashboard, P&L. Flags: cached_error (3).
• Costs: 66 populated cells; 59 formulas in 5 blocks (5 row); 1 input cells read by formulas. Reads from: Assumptions. Feeds: Dashboard, P&L. Flags: hard_coded_literal (1).
• P&L: 133 populated cells; 116 formulas in 12 blocks (9 row, 2 column, 1 single); 4 input cells read by formulas; 9 final outputs. Reads from: Assumptions, Costs, Revenue. Feeds: Dashboard. Flags: hard_coded_literal (1).
• Scratch: 5 populated cells; no formulas (data or lookup sheet); 1 input cells read by formulas. Feeds: Dashboard. Flags: hidden_sheet (1). Sheet is hidden.
• Dashboard: 19 populated cells; 9 formulas in 9 blocks (9 single); 0 input cells read by formulas; 8 final outputs. Reads from: Costs, Orders, P&L, Revenue, Scratch.

How the sheets connect

Arrows point from the sheet doing the reading to the sheet being read; the number is how many formulas make that read.

graph LR
    S0["Assumptions"]
    S1["Lookups"]
    S2["Orders"]
    S3["Revenue"]
    S4["Costs"]
    S5["P&L"]
    S6["Scratch"]
    S7["Dashboard"]
    S4 -->|36| S0
    S7 -->|1| S4
    S7 -->|1| S2
    S7 -->|5| S5
    S7 -->|2| S3
    S7 -->|1| S6
    S2 -->|599| S0
    S2 -->|600| S1
    S5 -->|12| S0
    S5 -->|24| S4
    S5 -->|24| S3
    S3 -->|1| S0
    S3 -->|156| S2

Functions used

Defined names

Features and risks found

Everything here is detected deterministically. Items marked as stubbed appear as UNSUPPORTED in the generated code and as not converted in the reconciliation report.