03 — Live Excel formulas actually stored in FCA_Accounting_Data.xlsx

Read with openpyxl from sheet 03_Cleaned_Dataset (L=Sales, M=TotalCost, N=Profit, O=Margin).

RowL SalesM TotalCost (formula)N ProfitO Margin (formula)
216.448=L2-N25.5512=IF(L2=0,"—",N2/L2)
311.784=L3-N34.2717=IF(L3=0,"—",N3/L3)
4272.736=L4-N4-64.7748=IF(L4=0,"—",N4/L4)

Totals row 9996: L==SUM(L2:L9995) M==SUM(M2:M9995) N==SUM(N2:N9995) O==N9996/L9996

07_KPI_Summary: B4=='03_Cleaned_Dataset'!L9996 B5=='03_Cleaned_Dataset'!M9996 B6=='03_Cleaned_Dataset'!N9996 B7=='03_Cleaned_Dataset'!O9996