← Asset-finance pricing calculatorWorkbook map: pricing_calculator.xlsx
Generated by Power Migrate 0.1.0a1. SHA-256 d2a7b89598fa1cf428dd9b55a51598c73cba8749b6527613cf279f1d8c2f4f0e.
At a glance
| Measure |
Value |
| Sheets |
6 (0 hidden) |
| Populated cells |
846 |
| Formula cells |
641 |
| Logic blocks (formula patterns) |
52 |
| Input cells (constants read by formulas) |
139 |
| Output cells (formulas nothing else reads) |
97 |
| Defined names |
8 (0 broken) |
| Distinct functions used |
30 |
| Feature flags raised |
19 |
Sheets
| Sheet |
State |
Cells |
Formulas |
Blocks |
Inputs |
Outputs |
| Inputs |
visible |
37 |
6 |
6 |
10 |
4 |
| RateCard |
visible |
57 |
4 |
4 |
45 |
0 |
| Schedule |
visible |
661 |
578 |
13 |
73 |
73 |
| Economics |
visible |
27 |
13 |
13 |
0 |
12 |
| Sensitivity |
visible |
47 |
32 |
8 |
11 |
2 |
| Summary |
visible |
17 |
8 |
8 |
0 |
6 |
Sheet by sheet
- Inputs: 37 populated cells; 6 formulas in 6 blocks (6 single); 10 input cells read by formulas; 4 final outputs. Feeds: Economics, RateCard, Schedule, Sensitivity, Summary. Flags: hard_coded_literal (1).
- RateCard: 57 populated cells; 4 formulas in 4 blocks (4 single); 45 input cells read by formulas. Reads from: Inputs. Feeds: Economics, Schedule, Sensitivity, Summary. Flags: hard_coded_literal (2).
- Schedule: 661 populated cells; 578 formulas in 13 blocks (9 column, 4 single); 73 input cells read by formulas; 73 final outputs. Reads from: Inputs, RateCard. Feeds: Economics, Summary.
- Economics: 27 populated cells; 13 formulas in 13 blocks (13 single); 0 input cells read by formulas; 12 final outputs. Reads from: Inputs, RateCard, Schedule. Feeds: Summary. Flags: hard_coded_literal (8), cached_error (1).
- Sensitivity: 47 populated cells; 32 formulas in 8 blocks (7 single, 1 table); 11 input cells read by formulas; 2 final outputs. Reads from: Inputs, RateCard. Flags: hard_coded_literal (6).
- Summary: 17 populated cells; 8 formulas in 8 blocks (8 single); 0 input cells read by formulas; 6 final outputs. Reads from: Economics, Inputs, RateCard, Schedule. Flags: hard_coded_literal (1).
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["Inputs"]
S1["RateCard"]
S2["Schedule"]
S3["Economics"]
S4["Sensitivity"]
S5["Summary"]
S3 -->|10| S0
S3 -->|4| S1
S3 -->|5| S2
S1 -->|2| S0
S2 -->|578| S0
S2 -->|215| S1
S4 -->|30| S0
S4 -->|30| S1
S5 -->|1| S3
S5 -->|6| S0
S5 -->|2| S1
S5 -->|3| S2
Functions used
| Function |
Uses |
Converted |
| IF |
577 |
yes |
| PMT |
103 |
yes |
| EDATE |
75 |
yes |
| PPMT |
72 |
yes |
| IPMT |
71 |
yes |
| MATCH |
2 |
yes |
| COUNTIF |
2 |
yes |
| TEXT |
2 |
yes |
| ROUND |
1 |
yes |
| NETWORKDAYS |
1 |
yes |
| WORKDAY |
1 |
yes |
| DATEDIF |
1 |
yes |
| YEARFRAC |
1 |
yes |
| INDEX |
1 |
yes |
| XLOOKUP |
1 |
yes |
| SUM |
1 |
yes |
| SUMPRODUCT |
1 |
yes |
| MAXIFS |
1 |
yes |
| NPV |
1 |
yes |
| IRR |
1 |
yes |
| RATE |
1 |
yes |
| PV |
1 |
yes |
| FV |
1 |
yes |
| NPER |
1 |
yes |
| MIN |
1 |
yes |
| IFS |
1 |
yes |
| SWITCH |
1 |
yes |
| TEXTJOIN |
1 |
yes |
| AND |
1 |
yes |
| AVERAGEIF |
1 |
yes |
Defined names
| Name |
Scope |
Refers to |
Status |
| APR |
workbook |
RateCard!$B$12 |
ok |
| AssetCost |
workbook |
Inputs!$B$3 |
ok |
| Balloon |
workbook |
Inputs!$B$17 |
ok |
| Financed |
workbook |
Inputs!$B$16 |
ok |
| Hurdle |
workbook |
Inputs!$B$12 |
ok |
| MonthlyRate |
workbook |
RateCard!$B$13 |
ok |
| StartDate |
workbook |
Inputs!$B$7 |
ok |
| TermMonths |
workbook |
Inputs!$B$5 |
ok |
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.
| Feature |
Count |
What it means |
Examples |
| hard_coded_literal |
18 |
Numbers typed into formulas rather than held in input cells |
Inputs!B20 (12), RateCard!B12 (10000), RateCard!B13 (12), and 15 more |
| cached_error |
1 |
Cell showed an Excel error when the workbook was saved |
Economics!B5 (#VALUE!) |