{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Input","Data Preperation","Dashboard","Charts","Financial Records"],"not_rendered":{"charts":20,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[25,1,25,4],[24,1,24,4],[7,1,7,18],[1,1,1,18],[3,1,3,6],[4,1,4,6],[5,1,5,6],[3,7,3,11],[4,7,4,11],[5,7,5,11],[6,1,6,6],[44,1,44,4],[36,1,36,4],[37,1,37,4],[43,1,43,4],[6,7,6,11],[27,1,27,18],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[23,1,23,4],[26,1,26,4]]}
[]
[null,"Data Input"]
[]
[null,"Enter your Business name",null,null,null,null,null,null,null,null,null,null,null,null,null,"Off","Today's Date",null,{"$f":"TODAY()","v":"2025-09-02"}]
[null,"Enter the next financial year-end date (dd/mm/yyyy)",null,null,null,null,null,"2025-09-01"]
[null,"Enter any 'extra' KPI's you want to measure in the spare lines below"]
[null,"Enter the month you are reporting on in the Dashboard (dd/mm/yyyy)",null,null,null,null,null,{"$f":"IF(COUNTA(G10:R10)=0, G9, LOOKUP(2, 1/(G10:R10<>\"\"), G9:R9))","v":"2024-10-01"}]
[]
[null,null,{"$f":"EDATE(D9,-12)","v":"2022-09-01"},{"$f":"EDATE(E9,-12)","v":"2023-09-01"},{"$f":"EDATE($H$5,-12)","v":"2024-09-01"},null,{"$f":"EDATE($H$5,-11)","v":"2024-10-01"},{"$f":"EDATE($H$5,-10)","v":"2024-11-01"},{"$f":"EDATE($H$5,-9)","v":"2024-12-01"},{"$f":"EDATE($H$5,-8)","v":"2025-01-01"},{"$f":"EDATE($H$5,-7)","v":"2025-02-01"},{"$f":"EDATE($H$5,-6)","v":"2025-03-01"},{"$f":"EDATE($H$5,-5)","v":"2025-04-01"},{"$f":"EDATE($H$5,-4)","v":"2025-05-01"},{"$f":"EDATE($H$5,-3)","v":"2025-06-01"},{"$f":"EDATE($H$5,-2)","v":"2025-07-01"},{"$f":"EDATE($H$5,-1)","v":"2025-08-01"},{"$f":"EDATE($H$5,0)","v":"2025-09-01"},"YTD"]
[null,"Turnover",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G10:R10)","v":0}]
[null,"Cost of Sales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G11:R11)","v":0}]
[null,"Gross Profit",null,null,null,null,{"$f":"IF(G10=\"\",\"\",G10-G11)","v":""},"","","","","","",{"$f":"IF(N10=\"\",\"\",N10-N11)","v":""},"","","","",0]
[null,"GP%",null,null,null,null,{"$f":"IF(G10=\"\",\"\",G12/G10)","v":""},"","","","","","",{"$f":"IF(N10=\"\",\"\",N12/N10)","v":""},"","","","",{"$f":"IF(OR(S10=\"\",S10=0),\"\",S12/S10)","v":""}]
[null,"Overheads",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G14:R14)","v":0}]
[null,"Net Profit",null,null,null,null,{"$f":"IF(G10=\"\",\"\",G12-G14)","v":""},"","","","","","",{"$f":"IF(N10=\"\",\"\",N12-N14)","v":""},"","","","",0]
[null,"NP%",null,null,null,null,{"$f":"IF(G10=\"\",\"\",G15/G10)","v":""},"","","","","","",{"$f":"IF(N10=\"\",\"\",N15/N10)","v":""},"","","","",{"$f":"IF(OR(S10=\"\",S10=0),\"\",S15/S10)","v":""}]
[null,"Breakeven Sales",null,null,null,null,{"$f":"IFERROR(G14/G13,\"\")","v":""},{"$f":"IFERROR(H14/H13,\"\")","v":""},"","","","","","","","","","",{"$f":"SUM(G17:R17)","v":0},"KPI Format"]
[null,"KPI1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G18:R18)","v":0},"Number"]
[null,"KPI2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G19:R19)","v":0},"Number"]
[null,"KPI3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Number"]
[null,"KPI4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Number"]
[null,"KPI5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G22:R22)","v":0},"Number"]
[null,"KPI6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Number"]
[null,"Turnover Forecast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Cumulative",null,null,null,null,{"$f":"G24","v":0},{"$f":"SUM($G24:H24)","v":0},{"$f":"SUM($G24:I24)","v":0},{"$f":"SUM($G24:J24)","v":0},{"$f":"SUM($G24:K24)","v":0},{"$f":"SUM($G24:L24)","v":0},{"$f":"SUM($G24:M24)","v":0},{"$f":"SUM($G24:N24)","v":0},{"$f":"SUM($G24:O24)","v":0},{"$f":"SUM($G24:P24)","v":0},{"$f":"SUM($G24:Q24)","v":0},{"$f":"SUM($G24:R24)","v":0}]
[null,"Net Profit Forecast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G26:R26)","v":0}]
[null,"Cumulative",null,null,null,null,{"$f":"G26","v":0},{"$f":"SUM($G26:H26)","v":0},{"$f":"SUM($G26:I26)","v":0},{"$f":"SUM($G26:J26)","v":0},{"$f":"SUM($G26:K26)","v":0},{"$f":"SUM($G26:L26)","v":0},{"$f":"SUM($G26:M26)","v":0},{"$f":"SUM($G26:N26)","v":0},{"$f":"SUM($G26:O26)","v":0},{"$f":"SUM($G26:P26)","v":0},{"$f":"SUM($G26:Q26)","v":0},{"$f":"SUM($G26:R26)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"'Financial Records'!C7","v":"00:00:00"},{"$f":"'Financial Records'!D7","v":"00:00:00"},{"$f":"'Financial Records'!E7","v":"00:00:00"},{"$f":"'Financial Records'!F7","v":"00:00:00"},{"$f":"'Financial Records'!G7","v":"00:00:00"},{"$f":"'Financial Records'!H7","v":"00:00:00"},{"$f":"'Financial Records'!I7","v":"00:00:00"},{"$f":"'Financial Records'!J7","v":"00:00:00"},{"$f":"'Financial Records'!K7","v":"00:00:00"},{"$f":"'Financial Records'!L7","v":"00:00:00"},{"$f":"'Financial Records'!M7","v":"00:00:00"},{"$f":"'Financial Records'!N7","v":"00:00:00"},{"$f":"'Financial Records'!O7","v":"00:00:00"}]
[null,"Last year's Turnover",null,null,null,null,{"$f":"'Financial Records'!C8","v":0},{"$f":"'Financial Records'!D8","v":0},{"$f":"'Financial Records'!E8","v":0},{"$f":"'Financial Records'!F8","v":0},{"$f":"'Financial Records'!G8","v":0},{"$f":"'Financial Records'!H8","v":0},{"$f":"'Financial Records'!I8","v":0},{"$f":"'Financial Records'!J8","v":0},{"$f":"'Financial Records'!K8","v":0},{"$f":"'Financial Records'!L8","v":0},{"$f":"'Financial Records'!M8","v":0},{"$f":"'Financial Records'!N8","v":0},{"$f":"'Financial Records'!O8","v":0}]
[null,"Cumulative",null,null,null,null,{"$f":"G30","v":0},{"$f":"SUM($G30:H30)","v":0},{"$f":"SUM($G30:I30)","v":0},{"$f":"SUM($G30:J30)","v":0},{"$f":"SUM($G30:K30)","v":0},{"$f":"SUM($G30:L30)","v":0},{"$f":"SUM($G30:M30)","v":0},{"$f":"SUM($G30:N30)","v":0},{"$f":"SUM($G30:O30)","v":0},{"$f":"SUM($G30:P30)","v":0},{"$f":"SUM($G30:Q30)","v":0},{"$f":"SUM($G30:R30)","v":0},{"$f":"'Financial Records'!O260","v":0}]
[null,"Cost of Sales",null,null,null,null,{"$f":"'Financial Records'!C9","v":0},{"$f":"'Financial Records'!D9","v":0},{"$f":"'Financial Records'!E9","v":0},{"$f":"'Financial Records'!F9","v":0},{"$f":"'Financial Records'!G9","v":0},{"$f":"'Financial Records'!H9","v":0},{"$f":"'Financial Records'!I9","v":0},{"$f":"'Financial Records'!J9","v":0},{"$f":"'Financial Records'!K9","v":0},{"$f":"'Financial Records'!L9","v":0},{"$f":"'Financial Records'!M9","v":0},{"$f":"'Financial Records'!N9","v":0},{"$f":"'Financial Records'!O9","v":0}]
[null,"Gross Profit",null,null,null,null,{"$f":"'Financial Records'!C10","v":0},{"$f":"'Financial Records'!D10","v":0},{"$f":"'Financial Records'!E10","v":0},{"$f":"'Financial Records'!F10","v":0},{"$f":"'Financial Records'!G10","v":0},{"$f":"'Financial Records'!H10","v":0},{"$f":"'Financial Records'!I10","v":0},{"$f":"'Financial Records'!J10","v":0},{"$f":"'Financial Records'!K10","v":0},{"$f":"'Financial Records'!L10","v":0},{"$f":"'Financial Records'!M10","v":0},{"$f":"'Financial Records'!N10","v":0},{"$f":"'Financial Records'!O10","v":0}]
[null,"GP%",null,null,null,null,{"$f":"'Financial Records'!C11","v":0},{"$f":"'Financial Records'!D11","v":0},{"$f":"'Financial Records'!E11","v":0},{"$f":"'Financial Records'!F11","v":0},{"$f":"'Financial Records'!G11","v":0},{"$f":"'Financial Records'!H11","v":0},{"$f":"'Financial Records'!I11","v":0},{"$f":"'Financial Records'!J11","v":0},{"$f":"'Financial Records'!K11","v":0},{"$f":"'Financial Records'!L11","v":0},{"$f":"'Financial Records'!M11","v":0},{"$f":"'Financial Records'!N11","v":0},{"$f":"'Financial Records'!O11","v":0}]
[null,"Overheads",null,null,null,null,{"$f":"'Financial Records'!C12","v":0},{"$f":"'Financial Records'!D12","v":0},{"$f":"'Financial Records'!E12","v":0},{"$f":"'Financial Records'!F12","v":0},{"$f":"'Financial Records'!G12","v":0},{"$f":"'Financial Records'!H12","v":0},{"$f":"'Financial Records'!I12","v":0},{"$f":"'Financial Records'!J12","v":0},{"$f":"'Financial Records'!K12","v":0},{"$f":"'Financial Records'!L12","v":0},{"$f":"'Financial Records'!M12","v":0},{"$f":"'Financial Records'!N12","v":0},{"$f":"'Financial Records'!O12","v":0}]
[null,"Last Year Net Profit",null,null,null,null,{"$f":"'Financial Records'!C13","v":0},{"$f":"'Financial Records'!D13","v":0},{"$f":"'Financial Records'!E13","v":0},{"$f":"'Financial Records'!F13","v":0},{"$f":"'Financial Records'!G13","v":0},{"$f":"'Financial Records'!H13","v":0},{"$f":"'Financial Records'!I13","v":0},{"$f":"'Financial Records'!J13","v":0},{"$f":"'Financial Records'!K13","v":0},{"$f":"'Financial Records'!L13","v":0},{"$f":"'Financial Records'!M13","v":0},{"$f":"'Financial Records'!N13","v":0},{"$f":"'Financial Records'!O13","v":0}]
[null,"Cumulative",null,null,null,null,{"$f":"G36","v":0},{"$f":"SUM($G36:H36)","v":0},{"$f":"SUM($G36:I36)","v":0},{"$f":"SUM($G36:J36)","v":0},{"$f":"SUM($G36:K36)","v":0},{"$f":"SUM($G36:L36)","v":0},{"$f":"SUM($G36:M36)","v":0},{"$f":"SUM($G36:N36)","v":0},{"$f":"SUM($G36:O36)","v":0},{"$f":"SUM($G36:P36)","v":0},{"$f":"SUM($G36:Q36)","v":0},{"$f":"SUM($G36:R36)","v":0},{"$f":"'Financial Records'!O265","v":0}]
[null,"NP%",null,null,null,null,{"$f":"'Financial Records'!C14","v":0},{"$f":"'Financial Records'!D14","v":0},{"$f":"'Financial Records'!E14","v":0},{"$f":"'Financial Records'!F14","v":0},{"$f":"'Financial Records'!G14","v":0},{"$f":"'Financial Records'!H14","v":0},{"$f":"'Financial Records'!I14","v":0},{"$f":"'Financial Records'!J14","v":0},{"$f":"'Financial Records'!K14","v":0},{"$f":"'Financial Records'!L14","v":0},{"$f":"'Financial Records'!M14","v":0},{"$f":"'Financial Records'!N14","v":0},{"$f":"'Financial Records'!O14","v":0}]
[null,"Breakeven Sales",null,null,null,null,{"$f":"'Financial Records'!C15","v":0},{"$f":"'Financial Records'!D15","v":0},{"$f":"'Financial Records'!E15","v":0},{"$f":"'Financial Records'!F15","v":0},{"$f":"'Financial Records'!G15","v":0},{"$f":"'Financial Records'!H15","v":0},{"$f":"'Financial Records'!I15","v":0},{"$f":"'Financial Records'!J15","v":0},{"$f":"'Financial Records'!K15","v":0},{"$f":"'Financial Records'!L15","v":0},{"$f":"'Financial Records'!M15","v":0},{"$f":"'Financial Records'!N15","v":0},{"$f":"'Financial Records'!O15","v":0}]
[null,{"$f":"B18","v":"KPI1"},null,null,null,null,{"$f":"'Financial Records'!C16","v":0},{"$f":"'Financial Records'!D16","v":0},{"$f":"'Financial Records'!E16","v":0},{"$f":"'Financial Records'!F16","v":0},{"$f":"'Financial Records'!G16","v":0},{"$f":"'Financial Records'!H16","v":0},{"$f":"'Financial Records'!I16","v":0},{"$f":"'Financial Records'!J16","v":0},{"$f":"'Financial Records'!K16","v":0},{"$f":"'Financial Records'!L16","v":0},{"$f":"'Financial Records'!M16","v":0},{"$f":"'Financial Records'!N16","v":0},{"$f":"'Financial Records'!O16","v":0}]
[null,"KPI2",null,null,null,null,{"$f":"'Financial Records'!C17","v":0},{"$f":"'Financial Records'!D17","v":0},{"$f":"'Financial Records'!E17","v":0},{"$f":"'Financial Records'!F17","v":0},{"$f":"'Financial Records'!G17","v":0},{"$f":"'Financial Records'!H17","v":0},{"$f":"'Financial Records'!I17","v":0},{"$f":"'Financial Records'!J17","v":0},{"$f":"'Financial Records'!K17","v":0},{"$f":"'Financial Records'!L17","v":0},{"$f":"'Financial Records'!M17","v":0},{"$f":"'Financial Records'!N17","v":0},{"$f":"'Financial Records'!O17","v":0}]
[null,"KPI3",null,null,null,null,{"$f":"'Financial Records'!C18","v":0},{"$f":"'Financial Records'!D18","v":0},{"$f":"'Financial Records'!E18","v":0},{"$f":"'Financial Records'!F18","v":0},{"$f":"'Financial Records'!G18","v":0},{"$f":"'Financial Records'!H18","v":0},{"$f":"'Financial Records'!I18","v":0},{"$f":"'Financial Records'!J18","v":0},{"$f":"'Financial Records'!K18","v":0},{"$f":"'Financial Records'!L18","v":0},{"$f":"'Financial Records'!M18","v":0},{"$f":"'Financial Records'!N18","v":0},{"$f":"'Financial Records'!O18","v":0}]
[null,"KPI4",null,null,null,null,{"$f":"'Financial Records'!C19","v":0},{"$f":"'Financial Records'!D19","v":0},{"$f":"'Financial Records'!E19","v":0},{"$f":"'Financial Records'!F19","v":0},{"$f":"'Financial Records'!G19","v":0},{"$f":"'Financial Records'!H19","v":0},{"$f":"'Financial Records'!I19","v":0},{"$f":"'Financial Records'!J19","v":0},{"$f":"'Financial Records'!K19","v":0},{"$f":"'Financial Records'!L19","v":0},{"$f":"'Financial Records'!M19","v":0},{"$f":"'Financial Records'!N19","v":0},{"$f":"'Financial Records'!O19","v":0}]
[null,"KPI5",null,null,null,null,{"$f":"'Financial Records'!C20","v":0},{"$f":"'Financial Records'!D20","v":0},{"$f":"'Financial Records'!E20","v":0},{"$f":"'Financial Records'!F20","v":0},{"$f":"'Financial Records'!G20","v":0},{"$f":"'Financial Records'!H20","v":0},{"$f":"'Financial Records'!I20","v":0},{"$f":"'Financial Records'!J20","v":0},{"$f":"'Financial Records'!K20","v":0},{"$f":"'Financial Records'!L20","v":0},{"$f":"'Financial Records'!M20","v":0},{"$f":"'Financial Records'!N20","v":0},{"$f":"'Financial Records'!O20","v":0}]
[null,"KPI6",null,null,null,null,{"$f":"'Financial Records'!C21","v":0},{"$f":"'Financial Records'!D21","v":0},{"$f":"'Financial Records'!E21","v":0},{"$f":"'Financial Records'!F21","v":0},{"$f":"'Financial Records'!G21","v":0},{"$f":"'Financial Records'!H21","v":0},{"$f":"'Financial Records'!I21","v":0},{"$f":"'Financial Records'!J21","v":0},{"$f":"'Financial Records'!K21","v":0},{"$f":"'Financial Records'!L21","v":0},{"$f":"'Financial Records'!M21","v":0},{"$f":"'Financial Records'!N21","v":0},{"$f":"'Financial Records'!O21","v":0}]

{"sheet":"Data Preperation","index":1,"n_rows":97,"n_cols":14,"rows_kept":97,"cut":false,"hidden":true,"merged":[]}
[null,"NOTE: THE ONLY CHANGES REQUIRED IN THIS WORKSHEET ARE THE FORMAT VALUES FOR THE KPI'S, NO ADDITIONAL CHANGES ARE REQUIRED"]
[null,null,"Revenue Actual VS Target YTD"]
[]
[null,null,{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,"Actual YTD",{"$f":"Input!G10","v":0},{"$f":"Input!H10","v":0},{"$f":"Input!I10","v":0},{"$f":"Input!J10","v":0},{"$f":"Input!K10","v":0},{"$f":"Input!L10","v":0},{"$f":"Input!M10","v":0},{"$f":"Input!N10","v":0},{"$f":"Input!O10","v":0},{"$f":"Input!P10","v":0},{"$f":"Input!Q10","v":0},{"$f":"Input!R10","v":0}]
[null,"Previous YTD",{"$f":"Input!G30","v":0},{"$f":"Input!H30","v":0},{"$f":"Input!I30","v":0},{"$f":"Input!J30","v":0},{"$f":"Input!K30","v":0},{"$f":"Input!L30","v":0},{"$f":"Input!M30","v":0},{"$f":"Input!N30","v":0},{"$f":"Input!O30","v":0},{"$f":"Input!P30","v":0},{"$f":"Input!Q30","v":0},{"$f":"Input!R30","v":0}]
[null,"BreakEven Sales",{"$f":"Input!G17","v":""},{"$f":"Input!H17","v":""},{"$f":"Input!I17","v":""},{"$f":"Input!J17","v":""},{"$f":"Input!K17","v":""},{"$f":"Input!L17","v":""},{"$f":"Input!M17","v":""},{"$f":"Input!N17","v":""},{"$f":"Input!O17","v":""},{"$f":"Input!P17","v":""},{"$f":"Input!Q17","v":""},{"$f":"Input!R17","v":""}]
[]
[null,null,"Breakeven Sales YTD"]
[]
[null,null,{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,"Actual YTD",{"$f":"Input!G10","v":0},{"$f":"Input!H10","v":0},{"$f":"Input!I10","v":0},{"$f":"Input!J10","v":0},{"$f":"Input!K10","v":0},{"$f":"Input!L10","v":0},{"$f":"Input!M10","v":0},{"$f":"Input!N10","v":0},{"$f":"Input!O10","v":0},{"$f":"Input!P10","v":0},{"$f":"Input!Q10","v":0},{"$f":"Input!R10","v":0}]
[null,"BreakEven Sales",{"$f":"Input!G17","v":""},{"$f":"Input!H17","v":""},{"$f":"Input!I17","v":""},{"$f":"Input!J17","v":""},{"$f":"Input!K17","v":""},{"$f":"Input!L17","v":""},{"$f":"Input!M17","v":""},{"$f":"Input!N17","v":""},{"$f":"Input!O17","v":""},{"$f":"Input!P17","v":""},{"$f":"Input!Q17","v":""},{"$f":"Input!R17","v":""}]
[]
[null,null,"Gross Profit Current and Previous"]
[null,null,{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,"Current Year",{"$f":"Input!G12","v":""},{"$f":"Input!H12","v":""},{"$f":"Input!I12","v":""},{"$f":"Input!J12","v":""},{"$f":"Input!K12","v":""},{"$f":"Input!L12","v":""},{"$f":"Input!M12","v":""},{"$f":"Input!N12","v":""},{"$f":"Input!O12","v":""},{"$f":"Input!P12","v":""},{"$f":"Input!Q12","v":""},{"$f":"Input!R12","v":""}]
[null,"Previous Year",{"$f":"Input!G33","v":0},{"$f":"Input!H33","v":0},{"$f":"Input!I33","v":0},{"$f":"Input!J33","v":0},{"$f":"Input!K33","v":0},{"$f":"Input!L33","v":0},{"$f":"Input!M33","v":0},{"$f":"Input!N33","v":0},{"$f":"Input!O33","v":0},{"$f":"Input!P33","v":0},{"$f":"Input!Q33","v":0},{"$f":"Input!R33","v":0}]
[null,"Forecast",{"$f":"Input!G26","v":0},{"$f":"Input!H26","v":0},{"$f":"Input!I26","v":0},{"$f":"Input!J26","v":0},{"$f":"Input!K26","v":0},{"$f":"Input!L26","v":0},{"$f":"Input!M26","v":0},{"$f":"Input!N26","v":0},{"$f":"Input!O26","v":0},{"$f":"Input!P26","v":0},{"$f":"Input!Q26","v":0},{"$f":"Input!R26","v":0}]
[]
[null,null,"Net Profit Current and Previous"]
[null,null,{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,"Current Year",{"$f":"Input!G15","v":""},{"$f":"Input!H15","v":""},{"$f":"Input!I15","v":""},{"$f":"Input!J15","v":""},{"$f":"Input!K15","v":""},{"$f":"Input!L15","v":""},{"$f":"Input!M15","v":""},{"$f":"Input!N15","v":""},{"$f":"Input!O15","v":""},{"$f":"Input!P15","v":""},{"$f":"Input!Q15","v":""},{"$f":"Input!R15","v":""}]
[null,"Previous Year",{"$f":"Input!G36","v":0},{"$f":"Input!H36","v":0},{"$f":"Input!I36","v":0},{"$f":"Input!J36","v":0},{"$f":"Input!K36","v":0},{"$f":"Input!L36","v":0},{"$f":"Input!M36","v":0},{"$f":"Input!N36","v":0},{"$f":"Input!O36","v":0},{"$f":"Input!P36","v":0},{"$f":"Input!Q36","v":0},{"$f":"Input!R36","v":0}]
[null,"Forecast",{"$f":"Input!G26","v":0},{"$f":"Input!H26","v":0},{"$f":"Input!I26","v":0},{"$f":"Input!J26","v":0},{"$f":"Input!K26","v":0},{"$f":"Input!L26","v":0},{"$f":"Input!M26","v":0},{"$f":"Input!N26","v":0},{"$f":"Input!O26","v":0},{"$f":"Input!P26","v":0},{"$f":"Input!Q26","v":0},{"$f":"Input!R26","v":0}]
[]
[null,null,"GP margin % and NP margin %"]
[null,null,{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,"Gross Profit %",{"$f":"Input!G13","v":""},{"$f":"Input!H13","v":""},{"$f":"Input!I13","v":""},{"$f":"Input!J13","v":""},{"$f":"Input!K13","v":""},{"$f":"Input!L13","v":""},{"$f":"Input!M13","v":""},{"$f":"Input!N13","v":""},{"$f":"Input!O13","v":""},{"$f":"Input!P13","v":""},{"$f":"Input!Q13","v":""},{"$f":"Input!R13","v":""}]
[null,"Net Profit %",{"$f":"Input!G16","v":""},{"$f":"Input!H16","v":""},{"$f":"Input!I16","v":""},{"$f":"Input!J16","v":""},{"$f":"Input!K16","v":""},{"$f":"Input!L16","v":""},{"$f":"Input!M16","v":""},{"$f":"Input!N16","v":""},{"$f":"Input!O16","v":""},{"$f":"Input!P16","v":""},{"$f":"Input!Q16","v":""},{"$f":"Input!R16","v":""}]
[]
[null,"Breakeven Sales",{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,{"$f":"UPPER(Input!B17)","v":"BREAKEVEN SALES"},{"$f":"Input!G17","v":""},{"$f":"Input!H17","v":""},{"$f":"Input!I17","v":""},{"$f":"Input!J17","v":""},{"$f":"Input!K17","v":""},{"$f":"Input!L17","v":""},{"$f":"Input!M17","v":""},{"$f":"Input!N17","v":""},{"$f":"Input!O17","v":""},{"$f":"Input!P17","v":""},{"$f":"Input!Q17","v":""},{"$f":"Input!R17","v":""}]
[null,"PREVIOUS YEAR",{"$f":"'Financial Records'!C105","v":0},{"$f":"'Financial Records'!D105","v":0},{"$f":"'Financial Records'!E105","v":0},{"$f":"'Financial Records'!F105","v":0},{"$f":"'Financial Records'!G105","v":0},{"$f":"'Financial Records'!H105","v":0},{"$f":"'Financial Records'!I105","v":0},{"$f":"'Financial Records'!J105","v":0},{"$f":"'Financial Records'!K105","v":0},{"$f":"'Financial Records'!L105","v":0},{"$f":"'Financial Records'!M105","v":0},{"$f":"'Financial Records'!N105","v":0}]
[]
[null,"KPI 1",{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,{"$f":"UPPER(Input!B18)","v":"KPI1"},{"$f":"Input!G18","v":0},{"$f":"Input!H18","v":0},{"$f":"Input!I18","v":0},{"$f":"Input!J18","v":0},{"$f":"Input!K18","v":0},{"$f":"Input!L18","v":0},{"$f":"Input!M18","v":0},{"$f":"Input!N18","v":0},{"$f":"Input!O18","v":0},{"$f":"Input!P18","v":0},{"$f":"Input!Q18","v":0},{"$f":"Input!R18","v":0}]
[null,"PREVIOUS YEAR",{"$f":"Input!G40","v":0},{"$f":"Input!H40","v":0},{"$f":"Input!I40","v":0},{"$f":"Input!J40","v":0},{"$f":"Input!K40","v":0},{"$f":"Input!L40","v":0},{"$f":"Input!M40","v":0},{"$f":"Input!N40","v":0},{"$f":"Input!O40","v":0},{"$f":"Input!P40","v":0},{"$f":"Input!Q40","v":0},{"$f":"Input!R40","v":0}]
[]
[null,"KPI 2",{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,{"$f":"UPPER(Input!B19)","v":"KPI2"},{"$f":"Input!G19","v":0},{"$f":"Input!H19","v":0},{"$f":"Input!I19","v":0},{"$f":"Input!J19","v":0},{"$f":"Input!K19","v":0},{"$f":"Input!L19","v":0},{"$f":"Input!M19","v":0},{"$f":"Input!N19","v":0},{"$f":"Input!O19","v":0},{"$f":"Input!P19","v":0},{"$f":"Input!Q19","v":0},{"$f":"Input!R19","v":0}]
[null,"PREVIOUS YEAR",{"$f":"Input!G41","v":0},{"$f":"Input!H41","v":0},{"$f":"Input!I41","v":0},{"$f":"Input!J41","v":0},{"$f":"Input!K41","v":0},{"$f":"Input!L41","v":0},{"$f":"Input!M41","v":0},{"$f":"Input!N41","v":0},{"$f":"Input!O41","v":0},{"$f":"Input!P41","v":0},{"$f":"Input!Q41","v":0},{"$f":"Input!R41","v":0}]
[]
[null,"KPI 3",{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,{"$f":"UPPER(Input!B20)","v":"KPI3"},{"$f":"Input!G20","v":0},{"$f":"Input!H20","v":0},{"$f":"Input!I20","v":0},{"$f":"Input!J20","v":0},{"$f":"Input!K20","v":0},{"$f":"Input!L20","v":0},{"$f":"Input!M20","v":0},{"$f":"Input!N20","v":0},{"$f":"Input!O20","v":0},{"$f":"Input!P20","v":0},{"$f":"Input!Q20","v":0},{"$f":"Input!R20","v":0}]
[null,"PREVIOUS YEAR",{"$f":"Input!G42","v":0},{"$f":"Input!H42","v":0},{"$f":"Input!I42","v":0},{"$f":"Input!J42","v":0},{"$f":"Input!K42","v":0},{"$f":"Input!L42","v":0},{"$f":"Input!M42","v":0},{"$f":"Input!N42","v":0},{"$f":"Input!O42","v":0},{"$f":"Input!P42","v":0},{"$f":"Input!Q42","v":0},{"$f":"Input!R42","v":0}]
[]
[null,"KPI 4",{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,{"$f":"UPPER(Input!B21)","v":"KPI4"},{"$f":"Input!G21","v":0},{"$f":"Input!H21","v":0},{"$f":"Input!I21","v":0},{"$f":"Input!J21","v":0},{"$f":"Input!K21","v":0},{"$f":"Input!L21","v":0},{"$f":"Input!M21","v":0},{"$f":"Input!N21","v":0},{"$f":"Input!O21","v":0},{"$f":"Input!P21","v":0},{"$f":"Input!Q21","v":0},{"$f":"Input!R21","v":0}]
[null,"PREVIOUS YEAR",{"$f":"Input!G43","v":0},{"$f":"Input!H43","v":0},{"$f":"Input!I43","v":0},{"$f":"Input!J43","v":0},{"$f":"Input!K43","v":0},{"$f":"Input!L43","v":0},{"$f":"Input!M43","v":0},{"$f":"Input!N43","v":0},{"$f":"Input!O43","v":0},{"$f":"Input!P43","v":0},{"$f":"Input!Q43","v":0},{"$f":"Input!R43","v":0}]
[]
[null,"KPI 5",{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,{"$f":"UPPER(Input!B22)","v":"KPI5"},{"$f":"Input!G22","v":0},{"$f":"Input!H22","v":0},{"$f":"Input!I22","v":0},{"$f":"Input!J22","v":0},{"$f":"Input!K22","v":0},{"$f":"Input!L22","v":0},{"$f":"Input!M22","v":0},{"$f":"Input!N22","v":0},{"$f":"Input!O22","v":0},{"$f":"Input!P22","v":0},{"$f":"Input!Q22","v":0},{"$f":"Input!R22","v":0}]
[null,"PREVIOUS YEAR",{"$f":"Input!G44","v":0},{"$f":"Input!H44","v":0},{"$f":"Input!I44","v":0},{"$f":"Input!J44","v":0},{"$f":"Input!K44","v":0},{"$f":"Input!L44","v":0},{"$f":"Input!M44","v":0},{"$f":"Input!N44","v":0},{"$f":"Input!O44","v":0},{"$f":"Input!P44","v":0},{"$f":"Input!Q44","v":0},{"$f":"Input!R44","v":0}]
[]
[null,"KPI 6",{"$f":"Input!G9","v":"2024-10-01"},{"$f":"Input!H9","v":"2024-11-01"},{"$f":"Input!I9","v":"2024-12-01"},{"$f":"Input!J9","v":"2025-01-01"},{"$f":"Input!K9","v":"2025-02-01"},{"$f":"Input!L9","v":"2025-03-01"},{"$f":"Input!M9","v":"2025-04-01"},{"$f":"Input!N9","v":"2025-05-01"},{"$f":"Input!O9","v":"2025-06-01"},{"$f":"Input!P9","v":"2025-07-01"},{"$f":"Input!Q9","v":"2025-08-01"},{"$f":"Input!R9","v":"2025-09-01"}]
[null,{"$f":"UPPER(Input!B23)","v":"KPI6"},{"$f":"Input!G23","v":0},{"$f":"Input!H23","v":0},{"$f":"Input!I23","v":0},{"$f":"Input!J23","v":0},{"$f":"Input!K23","v":0},{"$f":"Input!L23","v":0},{"$f":"Input!M23","v":0},{"$f":"Input!N23","v":0},{"$f":"Input!O23","v":0},{"$f":"Input!P23","v":0},{"$f":"Input!Q23","v":0},{"$f":"Input!R23","v":0}]
[null,"PREVIOUS YEAR",{"$f":"Input!G45","v":0},{"$f":"Input!H45","v":0},{"$f":"Input!I45","v":0},{"$f":"Input!J45","v":0},{"$f":"Input!K45","v":0},{"$f":"Input!L45","v":0},{"$f":"Input!M45","v":0},{"$f":"Input!N45","v":0},{"$f":"Input!O45","v":0},{"$f":"Input!P45","v":0},{"$f":"Input!Q45","v":0},{"$f":"Input!R45","v":0}]
[]
[null,"Data "]
[]
[null,"Revenue +/- last year",{"$f":"IFERROR(IF(F72>G72,\"▲\",\"▼\")&TEXT(((F72/G72)-1),\"0%;(0%)\"),\"N/A\")","v":"N/A"}]
[null,"GP +/- last year",{"$f":"IFERROR(IF(F75>G75,\"▲\",\"▼\")&TEXT((F75-G75),\"0%;(0%)\"),\"N/A\")","v":"N/A"}]
[null,"NP +/- last year",{"$f":"IFERROR(IF(F78>G78,\"▲\",\"▼\")&TEXT((F78-G78),\"0%;(0%)\"),\"N/A\")","v":"N/A"}]
[null,"Actual - Target",{"$f":"Input!S10-C80","v":0}]
[]
[]
[]
[null,{"$f":"\"INCOME STATEMENT FOR \"&UPPER(TEXT(Input!H7,\"MMM-YY\"))","v":"INCOME STATEMENT FOR OCT-24"}]
[null,null,"Current\nMonth","Previous\nYear","PM +/-","Current YTD","Previous YTD","PY +/-"]
[]
[null,"Revenue",{"$f":"HLOOKUP(Input!H7,Input!G9:R17,2,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!H7,-12),Input!G29:R44,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C72>D72,\"▲\",\"▼\")&TEXT(((C72/D72)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G10, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))","v":0},{"$f":"IF(D72<>\"\",SUM(OFFSET(Input!G30, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F72>G72,\"▲\",\"▼\")&TEXT(((F72/G72)-1),\"0%;(0%)\"),\"\")","v":""}]
[null,"COS",{"$f":"HLOOKUP(Input!H7,Input!G9:R17,3,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!H7,-12),Input!G29:R44,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C73>D73,\"▲\",\"▼\")&TEXT(((C73/D73)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G11, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))","v":0},{"$f":"IF(D73<>\"\",SUM(OFFSET(Input!G32, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F73>G73,\"▲\",\"▼\")&TEXT(((F73/G73)-1),\"0%;(0%)\"),\"\")","v":""}]
[null,"Gross Profit",{"$f":"HLOOKUP(Input!H7,Input!G9:R17,4,FALSE)","v":""},{"$f":"IFERROR(HLOOKUP(EDATE(Input!H7,-12),Input!G29:R44,7,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C74>D74,\"▲\",\"▼\")&TEXT(((C74/D74)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G12, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))","v":0},{"$f":"IF(D74<>\"\",SUM(OFFSET(Input!G33, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F74>G74,\"▲\",\"▼\")&TEXT(((F74/G74)-1),\"0%;(0%)\"),\"\")","v":""}]
[null,"GP%",{"$f":"HLOOKUP(Input!H7,Input!G9:R17,5,FALSE)","v":""},{"$f":"IFERROR(HLOOKUP(EDATE(Input!H7,-12),Input!G29:R44,6,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C75>D75,\"▲\",\"▼\")&TEXT((C75-D75),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G13, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))/(1+(DATEDIF(Input!G9, Input!H7, \"m\")))","v":0},{"$f":"IF(D75<>\"\",SUM(OFFSET(Input!G34, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))/(1+(DATEDIF(Input!G9, Input!H7, \"m\"))),\"\")","v":""},{"$f":"IF(D75<>\"\",IFERROR(IF(F75>G75,\"▲\",\"▼\")&TEXT((F75-G75),\"0%;(0%)\"),\"\"),\"\")","v":""}]
[null,"Overheads",{"$f":"HLOOKUP(Input!H7,Input!G9:R17,6,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!H7,-12),Input!G29:R44,7,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C76>D76,\"▲\",\"▼\")&TEXT(((C76/D76)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G14, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))","v":0},{"$f":"IF(D76<>\"\",SUM(OFFSET(Input!G35, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F76>G76,\"▲\",\"▼\")&TEXT(((F76/G76)-1),\"0%;(0%)\"),\"\")","v":""}]
[null,"Net Profit",{"$f":"HLOOKUP(Input!H7,Input!G9:R17,7,FALSE)","v":""},{"$f":"IFERROR(HLOOKUP(EDATE(Input!H7,-12),Input!G29:R44,8,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C77>D77,\"▲\",\"▼\")&TEXT(((C77/D77)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G15, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))","v":0},{"$f":"IF(D77<>\"\",SUM(OFFSET(Input!G36, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F77>G77,\"▲\",\"▼\")&TEXT(((F77/G77)-1),\"0%;(0%)\"),\"\")","v":""}]
[null,"NP%",{"$f":"HLOOKUP(Input!H7,Input!G9:R17,8,FALSE)","v":""},{"$f":"IFERROR(HLOOKUP(EDATE(Input!H7,-12),Input!G29:R44,10,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C78>D78,\"▲\",\"▼\")&TEXT((C78-D78),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G16, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))/(1+(DATEDIF(Input!G9, Input!H7, \"m\")))","v":0},{"$f":"IF(D78<>\"\",SUM(OFFSET(Input!G38, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))/(1+(DATEDIF(Input!G9, Input!H7, \"m\"))),\"\")","v":""},{"$f":"IF(D78<>\"\",IFERROR(IF(F78>G78,\"▲\",\"▼\")&TEXT((F78-G78),\"0%;(0%)\"),\"\"),\"\")","v":""}]
[null,"Breakeven Sales",{"$f":"HLOOKUP(Input!H7,Input!G9:R17,9,FALSE)","v":""},{"$f":"IFERROR(HLOOKUP(EDATE(Input!H7,-12),Input!G29:R44,11,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C79>D79,\"▲\",\"▼\")&TEXT(((C79/D79)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G17, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\")))))","v":0},{"$f":"IF(D79<>\"\",SUM(OFFSET(Input!G39, 0, 0, 1, (1+(DATEDIF(Input!G9, Input!H7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F79>G79,\"▲\",\"▼\")&TEXT(((F79/G79)-1),\"0%;(0%)\"),\"\")","v":""}]
[null,"Turnover Forecast Cumulative",{"$f":"HLOOKUP(Input!H7,Input!G9:R27,16,FALSE)","v":0},null,{"$f":"IFERROR(IF(C80>D80,\"▲\",\"▼\")&TEXT(((C80/D80)-1),\"0%;(0%)\"), \"\")","v":""},{"$f":"HLOOKUP(Input!H7,Input!G9:R27,17,FALSE)","v":0},{"$f":"IF(D80<>\"\",SUM(OFFSET(Input!G40, 0, 0, 1, (1+(DATEDIF(Input!G10, Input!H8, \"m\"))))),\"\")","v":""}]
[null,"NP Forecast Cumulative",{"$f":"HLOOKUP(Input!H7,Input!G9:R27,18,FALSE)","v":0},null,{"$f":"IFERROR(IF(C81>D81,\"▲\",\"▼\")&TEXT(((C81/D81)-1),\"0%;(0%)\"), \"\")","v":""},{"$f":"HLOOKUP(Input!H7,Input!G9:R27,19,FALSE)","v":0},{"$f":"IF(D81<>\"\",SUM(OFFSET(Input!G41, 0, 0, 1, (1+(DATEDIF(Input!G11, Input!H9, \"m\"))))),\"\")","v":""}]
[null,{"$f":"Input!B18","v":"KPI1"},{"$f":"HLOOKUP(Input!$H$7,Input!$G$9:$R$22,10,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!$H$7,-12),Input!$G$29:$R$44,12,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C82>D82,\"▲\",\"▼\")&TEXT(((C82/D82)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G18, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\")))))","v":0},{"$f":"IF(D82<>\"\",SUM(OFFSET(Input!G40, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F82>G82,\"▲\",\"▼\")&TEXT(((F82/G82)-1),\"0%;(0%)\"),\"\")","v":""}]
[null,{"$f":"Input!B19","v":"KPI2"},{"$f":"HLOOKUP(Input!$H$7,Input!$G$9:$R$22,11,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!$H$7,-12),Input!$G$29:$R$44,13,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C83>D83,\"▲\",\"▼\")&TEXT(((C83/D83)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G19, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\")))))","v":0},{"$f":"IF(D83<>\"\",SUM(OFFSET(Input!G41, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F83>G83,\"▲\",\"▼\")&TEXT(((F83/G83)-1),\"0%;(0%)\"),\"\")","v":""}]
[null,{"$f":"Input!B20","v":"KPI3"},{"$f":"HLOOKUP(Input!$H$7,Input!$G$9:$R$22,12,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!$H$7,-12),Input!$G$29:$R$44,14,FALSE),\"\")","v":""},"",{"$f":"SUM(OFFSET(Input!G20, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\")))))","v":0},{"$f":"IF(D84<>\"\",SUM(OFFSET(Input!G42, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\"))))),\"\")","v":""},""]
[null,{"$f":"Input!B21","v":"KPI4"},{"$f":"HLOOKUP(Input!$H$7,Input!$G$9:$R$22,13,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!$H$7,-12),Input!$G$29:$R$44,15,FALSE),\"\")","v":""},"",{"$f":"SUM(OFFSET(Input!G21, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\")))))","v":0},{"$f":"IF(D85<>\"\",SUM(OFFSET(Input!G43, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\"))))),\"\")","v":""},""]
[null,{"$f":"Input!B22","v":"KPI5"},{"$f":"HLOOKUP(Input!$H$7,Input!$G$9:$R$22,14,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!$H$7,-12),Input!$G$29:$R$44,16,FALSE),\"\")","v":""},"",{"$f":"SUM(OFFSET(Input!G22, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\")))))","v":0},{"$f":"IF(D86<>\"\",SUM(OFFSET(Input!G44, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\"))))),\"\")","v":""},""]
[null,{"$f":"Input!B23","v":"KPI6"},{"$f":"HLOOKUP(Input!$H$7,Input!$G$9:$R$23,15,FALSE)","v":0},{"$f":"IFERROR(HLOOKUP(EDATE(Input!$H$7,-12),Input!$G$29:$R$45,17,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(C87>D87,\"▲\",\"▼\")&TEXT(((C87/D87)-1),\"0%;(0%)\"),\"\")","v":""},{"$f":"SUM(OFFSET(Input!G23, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\")))))","v":0},{"$f":"IF(D87<>\"\",SUM(OFFSET(Input!G45, 0, 0, 1, (1+(DATEDIF(Input!$G$9, Input!$H$7, \"m\"))))),\"\")","v":""},{"$f":"IFERROR(IF(F87>G87,\"▲\",\"▼\")&TEXT(((F87/G87)-1),\"0%;(0%)\"),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Drop Down List"]
[null,"Number"]
[null,"Sterling"]
[null,"Percentage"]

{"sheet":"Dashboard","index":2,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[26,2,26,8]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"H32","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"H36","v":""},null,null,null,{"$f":"H40","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Current Month",null,"Previous Year","Current YTD",null,"Previous YTD"]
[]
[null,null,"Sales",{"$f":"'Data Preperation'!C72","v":0},{"$f":"'Data Preperation'!E72","v":""},{"$f":" 'Data Preperation'!D72","v":""},{"$f":"'Data Preperation'!F72","v":0},{"$f":"'Data Preperation'!H72","v":""},{"$f":"'Data Preperation'!G72","v":""}]
[null,null,"COS",{"$f":"'Data Preperation'!C73","v":0},{"$f":"'Data Preperation'!E73","v":""},{"$f":" 'Data Preperation'!D73","v":""},{"$f":"'Data Preperation'!F73","v":0},{"$f":"'Data Preperation'!H73","v":""},{"$f":"'Data Preperation'!G73","v":""}]
[]
[null,null,"Gross Profit",{"$f":"'Data Preperation'!C74","v":""},{"$f":"'Data Preperation'!E74","v":""},{"$f":"'Data Preperation'!D74","v":""},{"$f":"'Data Preperation'!F74","v":0},{"$f":"'Data Preperation'!H74","v":""},{"$f":"'Data Preperation'!G74","v":""}]
[null,null,"GP%",{"$f":"'Data Preperation'!C75","v":""},{"$f":"'Data Preperation'!E75","v":""},{"$f":"'Data Preperation'!D75","v":""},{"$f":"'Data Preperation'!F75","v":0},{"$f":"'Data Preperation'!H75","v":""},{"$f":"'Data Preperation'!G75","v":""}]
[null,null,"Overheads",{"$f":"'Data Preperation'!C76","v":0},{"$f":"'Data Preperation'!E76","v":""},{"$f":"'Data Preperation'!D76","v":""},{"$f":"'Data Preperation'!F76","v":0},{"$f":"'Data Preperation'!H76","v":""},{"$f":"'Data Preperation'!G76","v":""}]
[]
[null,null,"Net Profit",{"$f":"'Data Preperation'!C77","v":""},{"$f":"'Data Preperation'!E77","v":""},{"$f":"'Data Preperation'!D77","v":""},{"$f":"'Data Preperation'!F77","v":0},{"$f":"'Data Preperation'!H77","v":""},{"$f":"'Data Preperation'!G77","v":""}]
[null,null,"NP%",{"$f":"'Data Preperation'!C78","v":""},{"$f":"'Data Preperation'!E78","v":""},{"$f":"'Data Preperation'!D78","v":""},{"$f":"'Data Preperation'!F78","v":0},{"$f":"'Data Preperation'!H78","v":""},{"$f":"'Data Preperation'!G78","v":""}]
[]
[null,null,"Breakeven",{"$f":"'Data Preperation'!C79","v":""},{"$f":" 'Data Preperation'!E79","v":""},{"$f":"'Data Preperation'!D79","v":""},{"$f":"'Data Preperation'!F79","v":0},{"$f":"'Data Preperation'!H79","v":""},{"$f":"'Data Preperation'!G79","v":""}]
[]
[]
[null,null,{"$f":"'Data Preperation'!B82","v":"KPI1"},{"$f":"'Data Preperation'!C82","v":0},{"$f":"'Data Preperation'!E82","v":""},{"$f":"'Data Preperation'!D82","v":""},{"$f":"'Data Preperation'!F82","v":0},{"$f":"'Data Preperation'!H82","v":""},{"$f":"'Data Preperation'!G82","v":""}]
[null,null,{"$f":"'Data Preperation'!B83","v":"KPI2"},{"$f":"'Data Preperation'!C83","v":0},{"$f":"'Data Preperation'!E83","v":""},{"$f":"'Data Preperation'!D83","v":""},{"$f":"'Data Preperation'!F83","v":0},{"$f":"'Data Preperation'!H83","v":""},{"$f":"'Data Preperation'!G83","v":""}]
[null,null,{"$f":"'Data Preperation'!B84","v":"KPI3"},{"$f":"'Data Preperation'!C84","v":0},{"$f":"'Data Preperation'!E84","v":""},{"$f":"'Data Preperation'!D84","v":""},{"$f":"'Data Preperation'!F84","v":0},{"$f":"'Data Preperation'!H84","v":""},{"$f":"'Data Preperation'!G84","v":""}]
[null,null,{"$f":"'Data Preperation'!B85","v":"KPI4"},{"$f":"'Data Preperation'!C85","v":0},{"$f":"'Data Preperation'!E85","v":""},{"$f":"'Data Preperation'!D85","v":""},{"$f":"'Data Preperation'!F85","v":0},{"$f":"'Data Preperation'!H85","v":""},{"$f":"'Data Preperation'!G85","v":""}]
[null,null,{"$f":"'Data Preperation'!B86","v":"KPI5"},{"$f":"'Data Preperation'!C86","v":0},{"$f":"'Data Preperation'!E86","v":""},{"$f":"'Data Preperation'!D86","v":""},{"$f":"'Data Preperation'!F86","v":0},{"$f":"'Data Preperation'!H86","v":""},{"$f":"'Data Preperation'!G86","v":""}]
[null,null,{"$f":"'Data Preperation'!B87","v":"KPI6"},{"$f":"'Data Preperation'!C87","v":0},{"$f":"'Data Preperation'!E87","v":""},{"$f":"'Data Preperation'!D87","v":""},{"$f":"'Data Preperation'!F87","v":0},{"$f":"'Data Preperation'!H87","v":""},{"$f":"'Data Preperation'!G87","v":""}]

{"sheet":"Charts","index":3,"n_rows":123,"n_cols":13,"rows_kept":123,"cut":false,"hidden":false,"merged":[[116,12,116,13],[117,12,117,13],[119,12,119,13],[120,12,120,13],[122,12,122,13],[18,12,18,13],[20,12,20,13],[21,12,21,13],[93,12,93,13],[23,12,23,13],[36,12,36,13],[34,12,34,13],[42,12,42,13],[45,12,45,13],[46,12,46,13],[56,12,56,13],[33,12,33,13],[85,12,85,13],[72,12,72,13],[74,12,74,13],[30,12,30,13],[0,1,0,13],[17,12,17,13],[4,12,4,13],[7,12,7,13],[5,12,5,13],[8,12,8,13],[9,12,9,13],[11,12,11,13],[12,12,12,13],[31,12,31,13],[96,12,96,13],[106,12,106,13],[107,12,107,13],[59,12,59,13],[60,12,60,13],[69,12,69,13],[103,12,103,13],[61,12,61,13],[82,12,82,13],[57,12,57,13],[41,12,41,13],[43,12,43,13],[47,12,47,13],[109,12,109,13],[54,12,54,13],[55,12,55,13],[58,12,58,13],[66,12,66,13],[67,12,67,13],[70,12,70,13],[79,12,79,13],[80,12,80,13],[83,12,83,13],[90,12,90,13],[91,12,91,13],[94,12,94,13],[104,12,104,13]]}
[null,{"$f":"Input!H4","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Sales YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F72","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous Year YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G72","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H72","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"BreakEven Sales"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!C79","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total GP YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F74","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous Year YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G74","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H74","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total NP YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F77","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous Year YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G77","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H77","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"GP % YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F75","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H75","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"NP % YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F78","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H78","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F82","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G82","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H82","v":""}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F83","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G83","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H83","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F84","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G84","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H84","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F85","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G85","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H85","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F86","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G86","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H86","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Year to Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!F87","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Previous YTD"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!G87","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data Preperation'!H87","v":""}]

{"sheet":"Financial Records","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}