Read with openpyxl from sheet 03_Cleaned_Dataset (L=Sales, M=TotalCost, N=Profit, O=Margin).
| Row | L Sales | M TotalCost (formula) | N Profit | O Margin (formula) |
|---|---|---|---|---|
| 2 | 16.448 | =L2-N2 | 5.5512 | =IF(L2=0,"—",N2/L2) |
| 3 | 11.784 | =L3-N3 | 4.2717 | =IF(L3=0,"—",N3/L3) |
| 4 | 272.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