Generated by Power Migrate 0.1.0a1. Workbook SHA-256 1ee4a1f3e378e3e9629e9c64f2b1f7b1decc29c9301882895eb365abbcd5c2bb. Generated package fpna_month_end.
2470 of 2476 checkable formula cells reconciled (99.8%). 6 mismatched, 1 were not converted (listed below with reasons), 0 had no stored value to check against.
| Status | Formula cells | Share of all | Final outputs |
|---|---|---|---|
| Match | 2470 | 99.7% | 333 |
| Mismatch | 6 | 0.2% | 1 |
| Not converted (stub) | 1 | 0.0% | 1 |
| No reference value | 0 | 0.0% | 0 |
| Total | 2477 | 100% | 335 |
The generated code was run on the workbook's own input values (1275 input cells) and every formula cell was compared with the value Excel stored in the file. Numbers match when |actual - expected| <= max(1e-09, 1e-09 * max(|actual|, |expected|)); text must match exactly; error values must have the same code. Run time 1.0s.
6 of the matches hold only under policies the target declares: 6 where Excel #N/A is NULL in this target. Excel shows an error or an empty string in those cells; the generated code shows NULL.
This report shows tested equivalence on the inputs it ran, not a guarantee for other inputs. Generated input variations are not yet part of this version.
| Sheet | Formulas | Match | Mismatch | Not converted | No reference | Match rate |
|---|---|---|---|---|---|---|
| Assumptions | 1 | 1 | 0 | 0 | 0 | 100.0% |
| Orders | 2099 | 2097 | 2 | 0 | 0 | 99.9% |
| Revenue | 193 | 190 | 3 | 0 | 0 | 98.4% |
| Costs | 59 | 59 | 0 | 0 | 0 | 100.0% |
| 'P&L' | 116 | 115 | 1 | 0 | 0 | 99.1% |
| Dashboard | 9 | 8 | 0 | 1 | 0 | 100.0% |
6 cells. Every one is listed.
| Cell | Output? | Formula | Excel stored | Generated code | Difference | Note |
|---|---|---|---|---|---|---|
| Orders!J59 | =IF(I59>Assumptions!$B$11,I59*Assumptions!$B$12,0) |
#N/A | 0 | Excel shows #N/A; the generated code computed a value because errors are NULL in this target and aggregates skip them | ||
| Orders!J213 | =IF(I213>Assumptions!$B$11,I213*Assumptions!$B$12,0) |
#N/A | 0 | Excel shows #N/A; the generated code computed a value because errors are NULL in this target and aggregates skip them | ||
| Revenue!G16 | =SUMIFS(Orders!$K:$K,Orders!$F:$F,G$2,Orders!$G:$G,$A16) |
#N/A | 34867.84 | Excel shows #N/A; the generated code computed a value because errors are NULL in this target and aggregates skip them | ||
| Revenue!L16 | =SUMIFS(Orders!$K:$K,Orders!$F:$F,L$2,Orders!$G:$G,$A16) |
#N/A | 46972.34 | Excel shows #N/A; the generated code computed a value because errors are NULL in this target and aggregates skip them | ||
| Revenue!N16 | yes | =SUM(B16:M16) |
#N/A | 631313.53 | Excel shows #N/A; the generated code computed a value because errors are NULL in this target and aggregates skip them | |
| 'P&L'!B6 | =IFERROR(B5/B3,"n/a") |
"n/a" | (blank) | Excel shows text where the generated column is numeric (a fallback such as "n/a"); it is NULL in this target |
1 cells are, or depend on, something the rules could not convert. Grouped by root cause:
Formula cells that nothing else in the workbook reads: the numbers people actually look at.
| Cell | Formula | Excel stored | Generated code | Status |
|---|---|---|---|---|
| Assumptions!B14 | =TODAY() |
46304 | 46304 | match |
| Orders!L2 | =TEXT(B2,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L3 | =TEXT(B3,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L4 | =TEXT(B4,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L5 | =TEXT(B5,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L6 | =TEXT(B6,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L7 | =TEXT(B7,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L8 | =TEXT(B8,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L9 | =TEXT(B9,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L10 | =TEXT(B10,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L11 | =TEXT(B11,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L12 | =TEXT(B12,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L13 | =TEXT(B13,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L14 | =TEXT(B14,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L15 | =TEXT(B15,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L16 | =TEXT(B16,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L17 | =TEXT(B17,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L18 | =TEXT(B18,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L19 | =TEXT(B19,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L20 | =TEXT(B20,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L21 | =TEXT(B21,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L22 | =TEXT(B22,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L23 | =TEXT(B23,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L24 | =TEXT(B24,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L25 | =TEXT(B25,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L26 | =TEXT(B26,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L27 | =TEXT(B27,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L28 | =TEXT(B28,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L29 | =TEXT(B29,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L30 | =TEXT(B30,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L31 | =TEXT(B31,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L32 | =TEXT(B32,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L33 | =TEXT(B33,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L34 | =TEXT(B34,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L35 | =TEXT(B35,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L36 | =TEXT(B36,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L37 | =TEXT(B37,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L38 | =TEXT(B38,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L39 | =TEXT(B39,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L40 | =TEXT(B40,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L41 | =TEXT(B41,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L42 | =TEXT(B42,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L43 | =TEXT(B43,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L44 | =TEXT(B44,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L45 | =TEXT(B45,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L46 | =TEXT(B46,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L47 | =TEXT(B47,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L48 | =TEXT(B48,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L49 | =TEXT(B49,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L50 | =TEXT(B50,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L51 | =TEXT(B51,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L52 | =TEXT(B52,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L53 | =TEXT(B53,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L54 | =TEXT(B54,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L55 | =TEXT(B55,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L56 | =TEXT(B56,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L57 | =TEXT(B57,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L58 | =TEXT(B58,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L59 | =TEXT(B59,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L60 | =TEXT(B60,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L61 | =TEXT(B61,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L62 | =TEXT(B62,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L63 | =TEXT(B63,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L64 | =TEXT(B64,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L65 | =TEXT(B65,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L66 | =TEXT(B66,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L67 | =TEXT(B67,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L68 | =TEXT(B68,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L69 | =TEXT(B69,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L70 | =TEXT(B70,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L71 | =TEXT(B71,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L72 | =TEXT(B72,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L73 | =TEXT(B73,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L74 | =TEXT(B74,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L75 | =TEXT(B75,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L76 | =TEXT(B76,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L77 | =TEXT(B77,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L78 | =TEXT(B78,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L79 | =TEXT(B79,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L80 | =TEXT(B80,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L81 | =TEXT(B81,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L82 | =TEXT(B82,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L83 | =TEXT(B83,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L84 | =TEXT(B84,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L85 | =TEXT(B85,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L86 | =TEXT(B86,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L87 | =TEXT(B87,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L88 | =TEXT(B88,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L89 | =TEXT(B89,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L90 | =TEXT(B90,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L91 | =TEXT(B91,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L92 | =TEXT(B92,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L93 | =TEXT(B93,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L94 | =TEXT(B94,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L95 | =TEXT(B95,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L96 | =TEXT(B96,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L97 | =TEXT(B97,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L98 | =TEXT(B98,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L99 | =TEXT(B99,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L100 | =TEXT(B100,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L101 | =TEXT(B101,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L102 | =TEXT(B102,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L103 | =TEXT(B103,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L104 | =TEXT(B104,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L105 | =TEXT(B105,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L106 | =TEXT(B106,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L107 | =TEXT(B107,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L108 | =TEXT(B108,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L109 | =TEXT(B109,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L110 | =TEXT(B110,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L111 | =TEXT(B111,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L112 | =TEXT(B112,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L113 | =TEXT(B113,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L114 | =TEXT(B114,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L115 | =TEXT(B115,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L116 | =TEXT(B116,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L117 | =TEXT(B117,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L118 | =TEXT(B118,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L119 | =TEXT(B119,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L120 | =TEXT(B120,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L121 | =TEXT(B121,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L122 | =TEXT(B122,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L123 | =TEXT(B123,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L124 | =TEXT(B124,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L125 | =TEXT(B125,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L126 | =TEXT(B126,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L127 | =TEXT(B127,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L128 | =TEXT(B128,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L129 | =TEXT(B129,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L130 | =TEXT(B130,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L131 | =TEXT(B131,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L132 | =TEXT(B132,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L133 | =TEXT(B133,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L134 | =TEXT(B134,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L135 | =TEXT(B135,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L136 | =TEXT(B136,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L137 | =TEXT(B137,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L138 | =TEXT(B138,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L139 | =TEXT(B139,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L140 | =TEXT(B140,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L141 | =TEXT(B141,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L142 | =TEXT(B142,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L143 | =TEXT(B143,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L144 | =TEXT(B144,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L145 | =TEXT(B145,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L146 | =TEXT(B146,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L147 | =TEXT(B147,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L148 | =TEXT(B148,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L149 | =TEXT(B149,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!J150 | =IF(I150>Assumptions!$B$11,I150*Assumptions!$B$12,0) |
0 | 0 | match |
| Orders!L150 | =TEXT(B150,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L151 | =TEXT(B151,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L152 | =TEXT(B152,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L153 | =TEXT(B153,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L154 | =TEXT(B154,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L155 | =TEXT(B155,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L156 | =TEXT(B156,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L157 | =TEXT(B157,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L158 | =TEXT(B158,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L159 | =TEXT(B159,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L160 | =TEXT(B160,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L161 | =TEXT(B161,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L162 | =TEXT(B162,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L163 | =TEXT(B163,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L164 | =TEXT(B164,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L165 | =TEXT(B165,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L166 | =TEXT(B166,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L167 | =TEXT(B167,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L168 | =TEXT(B168,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L169 | =TEXT(B169,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L170 | =TEXT(B170,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L171 | =TEXT(B171,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L172 | =TEXT(B172,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L173 | =TEXT(B173,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L174 | =TEXT(B174,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L175 | =TEXT(B175,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L176 | =TEXT(B176,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L177 | =TEXT(B177,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L178 | =TEXT(B178,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L179 | =TEXT(B179,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L180 | =TEXT(B180,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L181 | =TEXT(B181,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L182 | =TEXT(B182,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L183 | =TEXT(B183,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L184 | =TEXT(B184,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L185 | =TEXT(B185,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L186 | =TEXT(B186,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L187 | =TEXT(B187,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L188 | =TEXT(B188,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L189 | =TEXT(B189,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L190 | =TEXT(B190,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L191 | =TEXT(B191,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L192 | =TEXT(B192,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L193 | =TEXT(B193,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L194 | =TEXT(B194,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L195 | =TEXT(B195,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L196 | =TEXT(B196,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L197 | =TEXT(B197,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L198 | =TEXT(B198,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L199 | =TEXT(B199,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L200 | =TEXT(B200,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L201 | =TEXT(B201,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L202 | =TEXT(B202,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L203 | =TEXT(B203,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L204 | =TEXT(B204,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L205 | =TEXT(B205,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L206 | =TEXT(B206,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L207 | =TEXT(B207,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L208 | =TEXT(B208,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L209 | =TEXT(B209,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L210 | =TEXT(B210,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L211 | =TEXT(B211,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L212 | =TEXT(B212,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L213 | =TEXT(B213,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L214 | =TEXT(B214,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L215 | =TEXT(B215,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L216 | =TEXT(B216,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L217 | =TEXT(B217,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L218 | =TEXT(B218,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L219 | =TEXT(B219,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L220 | =TEXT(B220,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L221 | =TEXT(B221,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L222 | =TEXT(B222,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L223 | =TEXT(B223,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L224 | =TEXT(B224,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L225 | =TEXT(B225,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L226 | =TEXT(B226,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L227 | =TEXT(B227,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L228 | =TEXT(B228,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L229 | =TEXT(B229,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L230 | =TEXT(B230,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L231 | =TEXT(B231,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L232 | =TEXT(B232,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L233 | =TEXT(B233,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L234 | =TEXT(B234,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L235 | =TEXT(B235,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L236 | =TEXT(B236,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L237 | =TEXT(B237,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L238 | =TEXT(B238,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L239 | =TEXT(B239,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L240 | =TEXT(B240,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L241 | =TEXT(B241,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L242 | =TEXT(B242,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L243 | =TEXT(B243,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L244 | =TEXT(B244,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L245 | =TEXT(B245,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L246 | =TEXT(B246,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L247 | =TEXT(B247,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L248 | =TEXT(B248,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L249 | =TEXT(B249,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L250 | =TEXT(B250,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L251 | =TEXT(B251,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L252 | =TEXT(B252,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L253 | =TEXT(B253,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L254 | =TEXT(B254,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L255 | =TEXT(B255,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L256 | =TEXT(B256,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L257 | =TEXT(B257,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L258 | =TEXT(B258,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L259 | =TEXT(B259,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L260 | =TEXT(B260,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L261 | =TEXT(B261,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L262 | =TEXT(B262,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L263 | =TEXT(B263,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L264 | =TEXT(B264,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L265 | =TEXT(B265,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L266 | =TEXT(B266,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L267 | =TEXT(B267,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L268 | =TEXT(B268,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L269 | =TEXT(B269,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L270 | =TEXT(B270,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L271 | =TEXT(B271,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L272 | =TEXT(B272,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L273 | =TEXT(B273,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L274 | =TEXT(B274,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L275 | =TEXT(B275,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L276 | =TEXT(B276,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L277 | =TEXT(B277,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L278 | =TEXT(B278,"yyyy-mm") |
"2026-11" | "2026-11" | match |
| Orders!L279 | =TEXT(B279,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L280 | =TEXT(B280,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L281 | =TEXT(B281,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L282 | =TEXT(B282,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L283 | =TEXT(B283,"yyyy-mm") |
"2026-07" | "2026-07" | match |
| Orders!L284 | =TEXT(B284,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L285 | =TEXT(B285,"yyyy-mm") |
"2026-09" | "2026-09" | match |
| Orders!L286 | =TEXT(B286,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L287 | =TEXT(B287,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L288 | =TEXT(B288,"yyyy-mm") |
"2026-10" | "2026-10" | match |
| Orders!L289 | =TEXT(B289,"yyyy-mm") |
"2026-03" | "2026-03" | match |
| Orders!L290 | =TEXT(B290,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L291 | =TEXT(B291,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L292 | =TEXT(B292,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L293 | =TEXT(B293,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L294 | =TEXT(B294,"yyyy-mm") |
"2026-05" | "2026-05" | match |
| Orders!L295 | =TEXT(B295,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L296 | =TEXT(B296,"yyyy-mm") |
"2026-02" | "2026-02" | match |
| Orders!L297 | =TEXT(B297,"yyyy-mm") |
"2026-04" | "2026-04" | match |
| Orders!L298 | =TEXT(B298,"yyyy-mm") |
"2026-08" | "2026-08" | match |
| Orders!L299 | =TEXT(B299,"yyyy-mm") |
"2026-12" | "2026-12" | match |
| Orders!L300 | =TEXT(B300,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Orders!L301 | =TEXT(B301,"yyyy-mm") |
"2026-06" | "2026-06" | match |
| Revenue!N12 | =SUM(N3:N11) |
1505175.47 | 1505175.47 | match |
| Revenue!N15 | =SUM(B15:M15) |
460360.365 | 460360.365 | match |
| Revenue!N16 | =SUM(B16:M16) |
#N/A | 631313.53 | mismatch |
| Revenue!N17 | =SUM(B17:M17) |
413501.575 | 413501.575 | match |
| Revenue!B19 | =COUNTIF(Orders!$F:$F,B$2) |
0 | 0 | match |
| Revenue!C19 | =COUNTIF(Orders!$F:$F,C$2) |
23 | 23 | match |
| Revenue!D19 | =COUNTIF(Orders!$F:$F,D$2) |
27 | 27 | match |
| Revenue!E19 | =COUNTIF(Orders!$F:$F,E$2) |
33 | 33 | match |
| Revenue!F19 | =COUNTIF(Orders!$F:$F,F$2) |
23 | 23 | match |
| Revenue!G19 | =COUNTIF(Orders!$F:$F,G$2) |
16 | 16 | match |
| Revenue!H19 | =COUNTIF(Orders!$F:$F,H$2) |
27 | 27 | match |
| Revenue!I19 | =COUNTIF(Orders!$F:$F,I$2) |
35 | 35 | match |
| Revenue!J19 | =COUNTIF(Orders!$F:$F,J$2) |
30 | 30 | match |
| Revenue!K19 | =COUNTIF(Orders!$F:$F,K$2) |
26 | 26 | match |
| Revenue!L19 | =COUNTIF(Orders!$F:$F,L$2) |
27 | 27 | match |
| Revenue!M19 | =COUNTIF(Orders!$F:$F,M$2) |
33 | 33 | match |
| 'P&L'!M9 | =L9+M8 |
-915336.3123 | -915336.3124 | match |
| 'P&L'!B13 | =SUMIFS($B$3:$M$3,$B$10:$M$10,$A13) |
242204.81 | 242204.81 | match |
| 'P&L'!C13 | =SUMIFS($B$8:$M$8,$B$10:$M$10,$A13) |
-311295.19 | -311295.19 | match |
| 'P&L'!B14 | =SUMIFS($B$3:$M$3,$B$10:$M$10,$A14) |
403440.835 | 403440.835 | match |
| 'P&L'!C14 | =SUMIFS($B$8:$M$8,$B$10:$M$10,$A14) |
-187627.5897 | -187627.5897 | match |
| 'P&L'!B15 | =SUMIFS($B$3:$M$3,$B$10:$M$10,$A15) |
524168.065 | 524168.065 | match |
| 'P&L'!C15 | =SUMIFS($B$8:$M$8,$B$10:$M$10,$A15) |
-102275.2927 | -102275.2926 | match |
| 'P&L'!B16 | =SUMIFS($B$3:$M$3,$B$10:$M$10,$A16) |
335361.76 | 335361.76 | match |
| 'P&L'!C16 | =SUMIFS($B$8:$M$8,$B$10:$M$10,$A16) |
-314138.24 | -314138.24 | match |
| Dashboard!B3 | =SUM(Revenue!B12:M12) |
1505175.47 | 1505175.47 | match |
| Dashboard!B5 | =INDEX('P&L'!B2:M2,MATCH(MAX('P&L'!B8:M8),'P&L'!B8:M8,0)) |
46234 | 46234 | match |
| Dashboard!B6 | =INDEX('P&L'!B2:M2,MATCH(MIN('P&L'!B8:M8),'P&L'!B8:M8,0)) |
46053 | 46053 | match |
| Dashboard!B7 | =COUNTIF('P&L'!B8:M8,"<0") |
10 | 10 | match |
| Dashboard!B8 | =AVERAGEIF('P&L'!B6:M6,">0") |
0.2304816407 | 0.2304816407 | match |
| Dashboard!B9 | =AVERAGE(Costs!B3:M3) |
46.83333333 | 46.83333333 | match |
| Dashboard!B10 | =COUNTIF(Orders!H:H,"#N/A") |
2 | #UNSUPPORTED | not_converted |
| Dashboard!B12 | =CONCATENATE("Net result ",TEXT(B4,"#,##0")," GBP across ",COUNTA(Revenue!B2:... |
"Net result -913,836 GBP across 12 months" | "Net result -913,836 GBP across 12 months" | match |