{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","User Instructions","Budget Data","Module2","Module3","Module4","Monthly Category Budget Chart"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Module2","index":3,"reason":"part_missing"},{"sheet":"Module3","index":4,"reason":"part_missing"},{"sheet":"Module4","index":5,"reason":"part_missing"}],"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":"1904"}

{"sheet":"Introduction","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"SalesPlanner Plus+ Approach"]
[]
[null,"Sales Planner Plus+ allow you to develop a monthly sales revenue plan for up to three years.  The sales plan incorporates features such as product or market groups with revenue subtotals, an unlimited number of products within each group and up to 20 seasonal sales patterns that can be customised and applied individually to each product/revenue line.  Direct sales costs can be applied to the revenue plan to calculate gross margin and percentage gross margin for each month. "]
[]
[null,"Sales Planner Plus+ also incorporates a sensitivity analysis feature whereby a + or —  percentage change can be applied to each line item for each of the three years and the revenue and gross margin projections are recalculated. Thus, \"What If\" analysis can be done on scenarios where a particular revenue stream (product or market) is, say, 20% less, while another revenue stream is, say, 5% higher."]
[]
[null,"Each monthly revenue figure is calculated by taking the current annual sales for that line item applying the entered annual percentage change (+ or — ) to get future years' total.  Each monthly sales revenue value is calculated by applying one of up to 20 totally customisable monthly sales patterns to the annual total."]
[]
[null,"See the attached User Instructions.  Enjoy!!"]

{"sheet":"User Instructions","index":1,"n_rows":24,"n_cols":256,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Marketing Budget Template"]
[]
[]
[null,"A comprehensive User Guide can be downloaded from "]
[null,"http://www.businesstoolsstore.com/pages/User-Guides.html "]
[]
[]
[]
[]
[]
[]
[null,"Copyright © 2011 The Business Tools Store."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month","The Revenue Projection for each Product for each month"]

{"sheet":"Budget Data","index":2,"n_rows":68,"n_cols":68,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,1,3],[3,0,8,3],[17,1,21,3]]}
["Marketing Budget Template",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WORK AREA Do NOT Delete"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Dec",31]
["Copyright © 2011 The Business Tools Store.",null,null,null,null,"Seasonal Expenditure Patterns",null,null,null,null,null,null,null,{"$f":"$B$23","v":"The Big Software Co. Ltd"},null,null,null,null,null,null,null,null,1,"Jan",31,1]
["The Marketing Budget template allows one to create a marketing budget taking into account current year expenditure, growth factors and seasonal expenditure patterns.  The budget is displayed in tabular and graphic formats.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Seasonal Expenditure Patterns\"","v":"Seasonal Expenditure Patterns"},null,null,null,null,null,null,null,null,2,"Feb",28,32]
[null,null,null,null,null,"Pattern No.","Pattern Description",{"$f":"$H$29","v":"1904-01-02"},{"$f":"$I$29","v":"1904-02-02"},{"$f":"$J$29","v":"1904-03-04"},{"$f":"$K$29","v":"1904-04-04"},{"$f":"$L$29","v":"1904-05-05"},{"$f":"$M$29","v":"1904-06-05"},{"$f":"$N$29","v":"1904-07-06"},{"$f":"$O$29","v":"1904-08-06"},{"$f":"$P$29","v":"1904-09-06"},{"$f":"$Q$29","v":"1904-10-07"},{"$f":"$R$29","v":"1904-11-07"},{"$f":"$S$29","v":"1904-12-08"},"TOTAL",null,null,3,"Mar",31,61]
[null,null,null,null,null,1,"Flat Expenditure",{"$f":"1/12","v":8.3333333333333329E-2},{"$f":"1/12","v":8.3333333333333329E-2},8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,{"$f":"SUM(H6:S6)","v":1},{"$f":"IF((T6)<>1,\"Seasonal Factors not = 100%\",\"\" )","v":""},null,4,"Apr",30,92]
[null,null,null,null,null,2,"Quarterly Lumps",0,0.25,0,0,0.25,0,0,0.25,0,0,0.25,0,{"$f":"SUM(H7:S7)","v":1},{"$f":"IF((T7)<>1,\"Seasonal Factors not = 100%\",\" \")","v":" "},null,5,"May",31,122]
[null,null,null,null,null,3,"Steady Growth",2.5000000000000001E-2,3.5000000000000003E-2,0.05,0.06,7.0000000000000007E-2,0.08,0.09,0.1,0.11,0.12,0.125,0.13500000000000001,{"$f":"SUM(H8:S8)","v":1},{"$f":"IF((T8)<>1,\"Seasonal Factors not = 100%\",\"\")","v":""},null,6,"Jun",30,153]
[null,null,null,null,null,4,"2nd Qtr Start",0,0,0,0.05,0.06,0.08,0.11,0.12,0.13,0.14000000000000001,0.15,0.16,{"$f":"SUM(H9:S9)","v":1},{"$f":"IF((T9)<>1,\"Seasonal Factors not = 100%\",\"\")","v":""},null,7,"Jul",31,183]
[null,null,null,null,null,5,"Half Year Start",0,0,0,0,0,0,0.05,0.09,0.14000000000000001,0.19,0.24,0.28999999999999998,{"$f":"SUM(H10:S10)","v":1},{"$f":"IF((T10)<>1,\"Seasonal Factors not = 100%\",\"\")","v":""},null,8,"Aug",31,214]
[null,"Set Up/Data Entry","Print",null,null,6,"Declining ",0.11,0.11,0.1,0.1,0.09,0.09,0.08,0.08,7.0000000000000007E-2,7.0000000000000007E-2,0.05,0.05,1,"",null,9,"Sep",30,245]
["                    Macro to change currency ",null,null,null,null,7,"Pattern 7",{"$f":"1/12","v":8.3333333333333329E-2},8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,"",null,10,"Oct",31,275]
["symbol has been disabled ",null,null,null,null,8,"Pattern 8",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,"",null,11,"Nov",30,306]
["in the Demo version",null,null,null,null,9,"Pattern 9",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,"",null,12,"Dec",31,336]
[null,null,null,null,null,10,"Pattern 10",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
[null,null,null,null,null,11,"Pattern 11",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
[null,null,null,null,null,12,"Pattern 12",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
[null,"In the demo version the cells in RED are locked and cannot be edited. This restriction does not apply to the Full version which can be downloaded from The Business Tools Store at www.businesstoolsstore.com ",null,null,null,13,"Pattern 13",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
[null,null,null,null,null,14,"Pattern 14",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
[null,null,null,null,null,15,"Pattern 15",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
[null,null,null,null,null,16,"Pattern 16",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
[null,null,null,null,null,17,"Pattern 17",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
["Budget Title:","The Big Software Co. Ltd",null,null,null,18,"Pattern 18",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
["Start Year:",2012,null,null,null,19,"Pattern 19",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,1,""]
["Start Month (1-12):",1,null,null,null,20,"Pattern 20",8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,{"$f":"SUM(H25:S25)","v":1},{"$f":"IF((T25)<>1,\"Seasonal Factors not = 100%\",\"\")","v":""}]
[{"$f":"VLOOKUP($B$25,Calender,4)","v":1},null,{"$f":"IF(B25=1,B24,B24+1)","v":2012}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$23","v":"The Big Software Co. Ltd"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Marketing Budget for Year Ended \"&VLOOKUP($B$25-1,Calender,3)&\" \"&VLOOKUP($B$25-1,Calender,2)&\" \"&$C$26","v":"Marketing Budget for Year Ended 31 Dec 2012"}]
["EXPENDITURE CATEGORIES",null,null,null,null,null,{"$f":"$A$29","v":"EXPENDITURE CATEGORIES"},{"$f":"A26","v":"1904-01-02"},{"$f":"H29+31","v":"1904-02-02"},"1904-03-04","1904-04-04","1904-05-05","1904-06-05","1904-07-06","1904-08-06","1904-09-06","1904-10-07","1904-11-07","1904-12-08","TOTAL","Yearly % Change"]
[]
[null,"Current "," % change.","Seasonal Expenditure",null,null,{"$f":"$A$31","v":0}]
["PERSONNEL"," Annual Expenditure","Pos./Neg."," Pattern",null,null,{"$f":"$A$32","v":"PERSONNEL"}," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
["Column1","Column2","Column3","Column6","Column5","Column58","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22","Column23","Column24","Column25","Column26"]
["Salaries, wages",5000,0.1,1,null,null,{"$f":"$A$34","v":"Salaries, wages"},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,1)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,2)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,3)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,4)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,5)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,6)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,7)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,8)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,9)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,10)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,11)","v":458.33333333333331},{"$f":"($B34*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D34,12)","v":458.33333333333331},{"$f":"SUM(H34:S34)","v":5499.9999999999991},{"$f":"IF(B34<>0,(T34-B34)/B34,0)","v":9.9999999999999811E-2}]
["Benefits",8000,0.1,1,null,null,{"$f":"$A$35","v":"Benefits"},733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,733.33333333333326,8799.9999999999982,9.999999999999977E-2]
["Commissions & Bonuses",9650,0.1,3,null,null,{"$f":"$A36","v":"Commissions & Bonuses"},265.375,371.52500000000003,530.75,636.9,743.05000000000007,849.2,955.34999999999991,1061.5,1167.6500000000001,1273.8,1326.875,1433.0250000000001,{"$f":"SUM(H36:S36)","v":10614.999999999998},9.9999999999999811E-2]
["Recruitment",3000,0,5,null,null,{"$f":"$A37","v":"Recruitment"},0,0,0,0,0,0,150,270,420.00000000000006,570,720,869.99999999999989,3000,0]
["Expenses",15000,0.05,6,null,null,{"$f":"$A38","v":"Expenses"},1732.5,1732.5,1575,1575,1417.5,1417.5,1260,1260,1102.5,1102.5,787.5,787.5,15750,0.05]
["Travel ",12000,0.1,1,null,null,{"$f":"$A39","v":"Travel "},1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,{"$f":"SUM(H39:S39)","v":13200},0.1]
["Motoring",6000,0,1,null,null,{"$f":"$A40","v":"Motoring"},500,500,500,500,500,500,500,500,500,500,500,500,6000,0]
[" ","Current "," % change.",null,null,null,"Group Total",{"$f":"SUM(H34:H40)","v":4789.5416666666661},4895.6916666666666,4897.4166666666661,5003.5666666666666,4952.2166666666672,5058.3666666666668,5157.0166666666664,5383.1666666666661,5481.8166666666666,5737.9666666666662,5626.0416666666661,5882.1916666666666,62864.999999999993,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
["OFFLINE MARKETING"," Annual Expenditure","Pos./Neg.",null,null,null,{"$f":"$A42","v":"OFFLINE MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null," ",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
["Column1","Column2","Column3","Column6","Column5","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22","Column23","Column24","Column25","Column26"]
["Public Relations",24000,0,1,null,null,"Public Relations",{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,1)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,2)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,3)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,4)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,5)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,6)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,7)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,8)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,9)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,10)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,11)","v":2000},{"$f":"($B44*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D44,12)","v":2000},{"$f":"SUM(H44:S44)","v":24000},{"$f":"IF(B44<>0,(T44-B44)/B44,0)","v":0}]
["Print Advertising",2000,0,2,null,null,"Print Advertising",{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,1)","v":0},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,2)","v":500},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,3)","v":0},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,4)","v":0},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,5)","v":500},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,6)","v":0},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,7)","v":0},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,8)","v":500},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,9)","v":0},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,10)","v":0},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,11)","v":500},{"$f":"($B45*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D45,12)","v":0},{"$f":"SUM(H45:S45)","v":2000},{"$f":"IF(B45<>0,(T45-B45)/B45,0)","v":0}]
["Tradeshows",1500,0,2,null,null,{"$f":"$A46","v":"Tradeshows"},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,1)","v":0},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,2)","v":375},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,3)","v":0},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,4)","v":0},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,5)","v":375},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,6)","v":0},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,7)","v":0},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,8)","v":375},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,9)","v":0},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,10)","v":0},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,11)","v":375},{"$f":"($B46*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D46,12)","v":0},{"$f":"SUM(H46:S46)","v":1500},{"$f":"IF(B46<>0,(T46-B46)/B46,0)","v":0}]
["Seminars/events",1000,0,5,null,null,"Seminars/events",{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,1)","v":0},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,2)","v":0},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,3)","v":0},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,4)","v":0},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,5)","v":0},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,6)","v":0},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,7)","v":50},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,8)","v":90},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,9)","v":140},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,10)","v":190},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,11)","v":240},{"$f":"($B47*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D47,12)","v":290},{"$f":"SUM(H47:S47)","v":1000},{"$f":"IF(B47<>0,(T47-B47)/B47,0)","v":0}]
["Telemarketing Fees",2400,0,1,null,null,"Telemarketing Fees",{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,1)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,2)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,3)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,4)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,5)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,6)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,7)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,8)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,9)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,10)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,11)","v":200},{"$f":"($B48*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D48,12)","v":200},{"$f":"SUM(H48:S48)","v":2400},{"$f":"IF(B48<>0,(T48-B48)/B48,0)","v":0}]
[" ","Current "," % change.",null,null,null,"Group Total",{"$f":"SUM(H44:H48)","v":2200},3075,2200,2200,3075,2200,2250,3165,2340,2390,3315,2490,30900,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
["ONLINE MARKETING"," Annual Expenditure","Pos./Neg.",null,null,null,{"$f":"$A50","v":"ONLINE MARKETING"},null,null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"IF(B50=0,T50/B50,0)","v":0}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
["Column1","Column2","Column3","Column6","Column5","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22","Column23","Column24","Column25","Column26"]
["Website development/redesign",2400,0,2,null,null,{"$f":"$A52","v":"Website development/redesign"},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,1)","v":0},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,2)","v":600},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,3)","v":0},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,4)","v":0},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,5)","v":600},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,6)","v":0},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,7)","v":0},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,8)","v":600},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,9)","v":0},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,10)","v":0},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,11)","v":600},{"$f":"($B52*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D52,12)","v":0},{"$f":"SUM(H52:S52)","v":2400},{"$f":"IF(B52<>0,(T52-B52)/B52,0)","v":0}]
["SEO",3600,0,1,null,null,{"$f":"$A$54","v":"PPC Advertising"},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,1)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,2)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,3)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,4)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,5)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,6)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,7)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,8)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,9)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,10)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,11)","v":300},{"$f":"($B53*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D53,12)","v":300},{"$f":"SUM(H53:S53)","v":3600},{"$f":"IF(B53<>0,(T53-B53)/B53,0)","v":0}]
["PPC Advertising",6000,0,1,null,null,{"$f":"$A$54","v":"PPC Advertising"},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,1)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,2)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,3)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,4)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,5)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,6)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,7)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,8)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,9)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,10)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,11)","v":500},{"$f":"($B54*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D54,12)","v":500},{"$f":"SUM(H54:S54)","v":6000},{"$f":"IF(B54<>0,(T54-B54)/B54,0)","v":0}]
["Webinars",1200,0,2,null,null,{"$f":"$A55","v":"Webinars"},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,1)","v":0},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,2)","v":300},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,3)","v":0},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,4)","v":0},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,5)","v":300},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,6)","v":0},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,7)","v":0},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,8)","v":300},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,9)","v":0},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,10)","v":0},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,11)","v":300},{"$f":"($B55*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D55,12)","v":0},{"$f":"SUM(H55:S55)","v":1200},{"$f":"IF(B55<>0,(T55-B55)/B55,0)","v":0}]
["eMail Marketing",3000,0.25,3,null,null,{"$f":"$A56","v":"eMail Marketing"},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,1)","v":93.75},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,2)","v":131.25},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,3)","v":187.5},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,4)","v":225},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,5)","v":262.5},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,6)","v":300},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,7)","v":337.5},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,8)","v":375},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,9)","v":412.5},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,10)","v":450},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,11)","v":468.75},{"$f":"($B56*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D56,12)","v":506.25000000000006},{"$f":"SUM(H56:S56)","v":3750},{"$f":"IF(B56<>0,(T56-B56)/B56,0)","v":0.25}]
[" ","Current "," % change.",null,null,null,"Group Total",{"$f":"SUM(H52:H56)","v":893.75},1831.25,987.5,1025,1962.5,1100,1137.5,2075,1212.5,1250,2168.75,1306.25,16950,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
["OVERHEAD & ADMINISTRATION "," Annual Expenditure","Pos./Neg.",null,null,null,{"$f":"$A$58","v":"OVERHEAD & ADMINISTRATION "},null,null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"IF(B58=0,T58/B58,0)","v":0}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
["Column1","Column2","Column3","Column6","Column5","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22","Column23","Column24","Column25","Column26"]
["PCs & Office Equipment ",1800,0,1,null,null,{"$f":"$A60","v":"PCs & Office Equipment "},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,1)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,2)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,3)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,4)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,5)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,6)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,7)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,8)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,9)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,10)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,11)","v":150},{"$f":"($B60*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D60,12)","v":150},{"$f":"SUM(H60:S60)","v":1800},{"$f":"IF(B60<>0,(T60-B60)/B60,0)","v":0}]
["Telephone Charges",5000,0.1,3,null,null,{"$f":"$A61","v":"Telephone Charges"},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,1)","v":137.5},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,2)","v":192.50000000000003},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,3)","v":275},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,4)","v":330},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,5)","v":385.00000000000006},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,6)","v":440},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,7)","v":495},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,8)","v":550},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,9)","v":605},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,10)","v":660},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,11)","v":687.5},{"$f":"($B61*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D61,12)","v":742.5},{"$f":"SUM(H61:S61)","v":5500},{"$f":"IF(B61<>0,(T61-B61)/B61,0)","v":0.1}]
["Postage",500,0,2,null,null,{"$f":"$A62","v":"Postage"},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,1)","v":0},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,2)","v":125},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,3)","v":0},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,4)","v":0},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,5)","v":125},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,6)","v":0},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,7)","v":0},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,8)","v":125},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,9)","v":0},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,10)","v":0},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,11)","v":125},{"$f":"($B62*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D62,12)","v":0},{"$f":"SUM(H62:S62)","v":500},{"$f":"IF(B62<>0,(T62-B62)/B62,0)","v":0}]
["Office charges",10000,0.2,1,null,null,{"$f":"$A63","v":"Office charges"},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,1)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,2)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,3)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,4)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,5)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,6)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,7)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,8)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,9)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,10)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,11)","v":1000},{"$f":"($B63*(1+Growth1))*INDEX(Seasonal_Pattern_YR1,$D63,12)","v":1000},{"$f":"SUM(H63:S63)","v":12000},{"$f":"IF(B63<>0,(T63-B63)/B63,0)","v":0.2}]
[null,null,null,null,null,null,"Group Total",{"$f":"SUM(H60:H63)","v":1287.5},1467.5,1425,1480,1660,1590,1645,1825,1755,1810,1962.5,1892.5,19800,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["TOTAL EXPENDITURE",null,null,null,null,null,{"$f":"$A$66","v":"TOTAL EXPENDITURE"},{"$f":"H41+H49+H57+H64","v":9170.7916666666661},11269.441666666666,9509.9166666666661,9708.5666666666657,11649.716666666667,9948.3666666666668,10189.516666666666,12448.166666666666,10789.316666666666,11187.966666666667,13072.291666666666,11570.941666666666,130515,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," "," ",null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "," "," "," ",null,null,null," ",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]

{"sheet":"Monthly Category Budget Chart","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}