{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,20,10,26]]}
[null,"FY 12-13 Est","% of Sales","FY 13-14 Bud","% of Sales","GR %","FY 12-13 Est","% of Sales","FY 13-14 Bud","% of Sales","GR %","FY 12-13 Est","% of Sales","FY 13-14 Bud","% of Sales","GR %"]
["Sales",0,{"$f":"IF(ISERROR((+B2/B$10)),0,(+B2/B$10))","v":0},0,{"$f":"IF(ISERROR((+D2/D$10)),0,(+D2/D$10))","v":0},{"$f":"IF(ISERROR((IF(OR(B2<0,D2<0),0,(D2/B2-1)))),0,(IF(OR(B2<0,D2<0),0,(D2/B2-1))))","v":0},0,{"$f":"IF(ISERROR((+G2/G$10)),0,(+G2/G$10))","v":0},0,{"$f":"IF(ISERROR((+I2/I$10)),0,(+I2/I$10))","v":0},{"$f":"IF(ISERROR((IF(OR(G2<0,I2<0),0,(I2/G2-1)))),0,(IF(OR(G2<0,I2<0),0,(I2/G2-1))))","v":0},0,{"$f":"IF(ISERROR((+L2/L$10)),0,(+L2/L$10))","v":0},0,{"$f":"IF(ISERROR((+N2/N$10)),0,(+N2/N$10))","v":0},{"$f":"IF(ISERROR((IF(OR(L2<0,N2<0),0,(N2/L2-1)))),0,(IF(OR(L2<0,N2<0),0,(N2/L2-1))))","v":0}]
["Less :- Cost of Sales",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"Sub Macro1()"]
["Gross Profit",{"$f":"IF(ISERROR((+B2-B3)),0,(+B2-B3))","v":0},0,{"$f":"IF(ISERROR((+D2-D3)),0,(+D2-D3))","v":0},0,0,{"$f":"IF(ISERROR((+G2-G3)),0,(+G2-G3))","v":0},0,{"$f":"IF(ISERROR((+I2-I3)),0,(+I2-I3))","v":0},0,0,{"$f":"IF(ISERROR((+L2-L3)),0,(+L2-L3))","v":0},0,{"$f":"IF(ISERROR((+N2-N3)),0,(+N2-N3))","v":0},0,0,null,null,"'"]
["Staff Costs",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"' Macro1 Macro"]
["Owner's Remuneration",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"'"]
["Rent",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Administrative Expenses",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"'",null,"Problem"]
["Selling & Promotion Expenses",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"    Range(\"C2:C27\").Select",null,"Range(2:27) should be selected automaticaly  for each col heading \"% to sales\""]
["Total Operating Expenses",{"$f":"IF(ISERROR((SUM(B5:B9))),0,(SUM(B5:B9)))","v":0},0,{"$f":"IF(ISERROR((SUM(D5:D9))),0,(SUM(D5:D9)))","v":0},0,0,{"$f":"IF(ISERROR((SUM(G5:G9))),0,(SUM(G5:G9)))","v":0},0,{"$f":"IF(ISERROR((SUM(I5:I9))),0,(SUM(I5:I9)))","v":0},0,0,{"$f":"IF(ISERROR((SUM(L5:L9))),0,(SUM(L5:L9)))","v":0},0,{"$f":"IF(ISERROR((SUM(N5:N9))),0,(SUM(N5:N9)))","v":0},0,0,null,null,"    Selection.NumberFormat = \"0.0%\""]
["Operating Profit",{"$f":"IF(ISERROR((+B4-B10)),0,(+B4-B10))","v":0},0,{"$f":"IF(ISERROR((+D4-D10)),0,(+D4-D10))","v":0},0,0,{"$f":"IF(ISERROR((+G4-G10)),0,(+G4-G10))","v":0},0,{"$f":"IF(ISERROR((+I4-I10)),0,(+I4-I10))","v":0},0,0,{"$f":"IF(ISERROR((+L4-L10)),0,(+L4-L10))","v":0},0,{"$f":"IF(ISERROR((+N4-N10)),0,(+N4-N10))","v":0},0,0,null,null,"    Range(\"E2:E27\").Select"]
["Interest & Fin. Charges-Local",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"    Selection.NumberFormat = \"0.0%\""]
["Interest & Fin. Charges-Corp",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"    "]
["Cash Profit",{"$f":"IF(ISERROR((+B11-B12-B13)),0,(+B11-B12-B13))","v":0},0,{"$f":"IF(ISERROR((+D11-D12-D13)),0,(+D11-D12-D13))","v":0},0,0,{"$f":"IF(ISERROR((+G11-G12-G13)),0,(+G11-G12-G13))","v":0},0,{"$f":"IF(ISERROR((+I11-I12-I13)),0,(+I11-I12-I13))","v":0},0,0,{"$f":"IF(ISERROR((+L11-L12-L13)),0,(+L11-L12-L13))","v":0},0,{"$f":"IF(ISERROR((+N11-N12-N13)),0,(+N11-N12-N13))","v":0},0,0,null,null,"End Sub"]
["Depreciation / Pre-operative",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Provision for stock Obs.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Debits & Credits",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Misc. (Income) / Expenditure",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal",{"$f":"IF(ISERROR((SUM(B15:B18))),0,(SUM(B15:B18)))","v":0},0,{"$f":"IF(ISERROR((SUM(D15:D18))),0,(SUM(D15:D18)))","v":0},0,0,{"$f":"IF(ISERROR((SUM(G15:G18))),0,(SUM(G15:G18)))","v":0},0,{"$f":"IF(ISERROR((SUM(I15:I18))),0,(SUM(I15:I18)))","v":0},0,0,{"$f":"IF(ISERROR((SUM(L15:L18))),0,(SUM(L15:L18)))","v":0},0,{"$f":"IF(ISERROR((SUM(N15:N18))),0,(SUM(N15:N18)))","v":0},0,0]
["Territory Common Apportioned",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Warehouse Common Apportioned",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Regional Common Apportioned",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Profit before Tax & Corp OH",{"$f":"IF(ISERROR((+B14-B19-B20-B21-B22)),0,(+B14-B19-B20-B21-B22))","v":0},0,{"$f":"IF(ISERROR((+D14-D19-D20-D21-D22)),0,(+D14-D19-D20-D21-D22))","v":0},0,0,{"$f":"IF(ISERROR((+G14-G19-G20-G21-G22)),0,(+G14-G19-G20-G21-G22))","v":0},0,{"$f":"IF(ISERROR((+I14-I19-I20-I21-I22)),0,(+I14-I19-I20-I21-I22))","v":0},0,0,{"$f":"IF(ISERROR((+L14-L19-L20-L21-L22)),0,(+L14-L19-L20-L21-L22))","v":0},0,{"$f":"IF(ISERROR((+N14-N19-N20-N21-N22)),0,(+N14-N19-N20-N21-N22))","v":0},0,0]
["Corporate Overhead",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Corporate CRM Expense",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Provision for Taxation",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Net Profit After Tax & Corp OH",{"$f":"IF(ISERROR((+B23-B24-B25-B26)),0,(+B23-B24-B25-B26))","v":0},0,{"$f":"IF(ISERROR((+D23-D24-D25-D26)),0,(+D23-D24-D25-D26))","v":0},0,0,{"$f":"IF(ISERROR((+G23-G24-G25-G26)),0,(+G23-G24-G25-G26))","v":0},0,{"$f":"IF(ISERROR((+I23-I24-I25-I26)),0,(+I23-I24-I25-I26))","v":0},0,0,{"$f":"IF(ISERROR((+L23-L24-L25-L26)),0,(+L23-L24-L25-L26))","v":0},0,{"$f":"IF(ISERROR((+N23-N24-N25-N26)),0,(+N23-N24-N25-N26))","v":0},0,0]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}