{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["START","PLANNED EXPENSES","ACTUAL EXPENSES","EXPENSE VARIANCES","EXPENSE ANALYSIS"],"not_rendered":{"charts":2,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"START","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this Business Expense Budget workbook to track Planned and Actual Expenses and Variances."]
[null,"Fill in Company Name and add Logo."]
[null,"Enter details in tables in Planned Expenses worksheet and Actual Expenses worksheet."]
[null,"Tables are auto updated in Expense Variances worksheet and charts in Expense Analysis worksheet"]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in each worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font color."]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT"]

{"sheet":"PLANNED EXPENSES","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,17,12,19],[1,13,2,14],[1,10,1,12],[33,1,33,2],[28,1,28,2],[19,1,19,2],[8,1,8,2],[1,1,2,3],[2,10,2,12]]}
["Enter Planned Employee Costs, Office Costs, Marketing Costs, and Training or Travel Cost in respective tables in this worksheet. Totals are auto calculated. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Enter Company Name in cell at right and Logo in cell N2. Title of this worksheet is in cell K2.","Company Name",null,null,null,null,null,null,null,null,"Detailed Expense Estimates",null,null,"Logo placeholder is in this cell."]
["Tip is in cell K3.",null,null,null,null,null,null,null,null,null,"Shaded cells are calculations."]
["Planned Expenses label is in cell at right, months in cells C4 through N4, Year label in O4, and How to use this template instructions in cell R4.","PLANNED EXPENSES","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YEAR",null,null,"Tip: HOW TO USE THIS TEMPLATE\nInput data in the white cells on the PLANNED EXPENSES and ACTUAL EXPENSES worksheets, and the EXPENSE VARIANCES and EXPENSE ANALYSIS will be calculated for you.  If you add a row on one sheet, the other sheets need to match."]
["Enter Employee Costs in Employee Plan table starting in cell at right. Next instruction is in cell A10.","Employee Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Wages",85000,85000,85000,87500,87500,87500,87500,92400,92400,92400,92400,92400,{"$f":"SUM(C6:N6)","v":1067000}]
[null,"Benefits",{"$f":"C6*0.27","v":22950},22950,22950,23625,23625,23625,23625,24948,24948,24948,24948,24948,{"$f":"SUM(C7:N7)","v":288090}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,EmployeePlan[Jan])","v":107950},{"$f":"SUBTOTAL(109,EmployeePlan[Feb])","v":107950},{"$f":"SUBTOTAL(109,EmployeePlan[Mar])","v":107950},{"$f":"SUBTOTAL(109,EmployeePlan[Apr])","v":111125},{"$f":"SUBTOTAL(109,EmployeePlan[May])","v":111125},{"$f":"SUBTOTAL(109,EmployeePlan[Jun])","v":111125},{"$f":"SUBTOTAL(109,EmployeePlan[Jul])","v":111125},{"$f":"SUBTOTAL(109,EmployeePlan[Aug])","v":117348},{"$f":"SUBTOTAL(109,EmployeePlan[Sep])","v":117348},{"$f":"SUBTOTAL(109,EmployeePlan[Oct])","v":117348},{"$f":"SUBTOTAL(109,EmployeePlan[Nov])","v":117348},{"$f":"SUBTOTAL(109,EmployeePlan[Dec])","v":117348},{"$f":"SUBTOTAL(109,EmployeePlan[YEAR])","v":1355090}]
[]
["Enter Office Costs in Office Plan table starting in cell at right. Next instruction is in cell A21.","Office Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Office lease",9800,9800,9800,9800,9800,9800,9800,9800,9800,9800,9800,9800,{"$f":"SUM(C11:N11)","v":117600}]
[null,"Gas",null,400,400,100,100,100,100,100,100,100,400,400,2300]
[null,"Electric",300,300,300,300,300,300,300,300,300,300,300,300,3600]
[null,"Water",40,40,40,40,40,40,40,40,40,40,40,40,480]
[null,"Telephone",250,250,250,250,250,250,250,250,250,250,250,250,3000]
[null,"Internet access",180,180,180,180,180,180,180,180,180,180,180,180,2160]
[null,"Office supplies",200,200,200,200,200,200,200,200,200,200,200,200,2400]
[null,"Security",600,600,600,600,600,600,600,600,600,600,600,600,7200]
[null,"Subtotal",{"$f":"SUBTOTAL(109,OfficePlan[Jan])","v":11370},{"$f":"SUBTOTAL(109,OfficePlan[Feb])","v":11770},{"$f":"SUBTOTAL(109,OfficePlan[Mar])","v":11770},{"$f":"SUBTOTAL(109,OfficePlan[Apr])","v":11470},{"$f":"SUBTOTAL(109,OfficePlan[May])","v":11470},{"$f":"SUBTOTAL(109,OfficePlan[Jun])","v":11470},{"$f":"SUBTOTAL(109,OfficePlan[Jul])","v":11470},{"$f":"SUBTOTAL(109,OfficePlan[Aug])","v":11470},{"$f":"SUBTOTAL(109,OfficePlan[Sep])","v":11470},{"$f":"SUBTOTAL(109,OfficePlan[Oct])","v":11470},{"$f":"SUBTOTAL(109,OfficePlan[Nov])","v":11770},{"$f":"SUBTOTAL(109,OfficePlan[Dec])","v":11770},{"$f":"SUBTOTAL(109,OfficePlan[YEAR])","v":138740}]
[]
["Enter Marketing Costs in Marketing Plan table starting in cell at right. Next instruction is in cell A30.","Marketing Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Web site hosting",500,500,500,500,500,500,500,500,500,500,500,500,{"$f":"SUM(C22:N22)","v":6000}]
[null,"Web site updates",200,200,200,200,200,1000,200,200,200,200,200,1000,4000]
[null,"Collateral preparation",5000,0,0,5000,0,0,5000,0,0,5000,0,0,20000]
[null,"Collateral printing",200,200,200,200,200,200,200,200,200,200,200,200,2400]
[null,"Marketing events",2000,2000,2000,5000,2000,2000,2000,5000,2000,2000,2000,5000,33000]
[null,"Miscellaneous expenses",200,200,200,200,200,200,200,200,200,200,200,200,2400]
[null,"Subtotal",{"$f":"SUBTOTAL(109,MarketingPlan[Jan])","v":8100},{"$f":"SUBTOTAL(109,MarketingPlan[Feb])","v":3100},{"$f":"SUBTOTAL(109,MarketingPlan[Mar])","v":3100},{"$f":"SUBTOTAL(109,MarketingPlan[Apr])","v":11100},{"$f":"SUBTOTAL(109,MarketingPlan[May])","v":3100},{"$f":"SUBTOTAL(109,MarketingPlan[Jun])","v":3900},{"$f":"SUBTOTAL(109,MarketingPlan[Jul])","v":8100},{"$f":"SUBTOTAL(109,MarketingPlan[Aug])","v":6100},{"$f":"SUBTOTAL(109,MarketingPlan[Sep])","v":3100},{"$f":"SUBTOTAL(109,MarketingPlan[Oct])","v":8100},{"$f":"SUBTOTAL(109,MarketingPlan[Nov])","v":3100},{"$f":"SUBTOTAL(109,MarketingPlan[Dec])","v":6900},{"$f":"SUBTOTAL(109,MarketingPlan[YEAR])","v":67800}]
[]
["Enter Training and Travel Costs in Training and Travel Plan table starting in cell at right. Next instruction is in cell A35.","Training/Travel","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Training classes",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,{"$f":"SUM(C31:N31)","v":24000}]
[null,"Training-related travel costs",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,{"$f":"SUM(C32:N32)","v":24000}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Jan])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Feb])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Mar])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Apr])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[May])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Jun])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Jul])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Aug])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Sep])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Oct])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Nov])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Dec])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[YEAR])","v":48000}]
[]
["Totals are auto calculated in Planned Total table starting in cell at right.","TOTALS","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year"]
[null,"Monthly Planned Expenses",{"$f":"TrainingAndTravelPlan[[#Totals],[Jan]]+MarketingPlan[[#Totals],[Jan]]+OfficePlan[[#Totals],[Jan]]+EmployeePlan[[#Totals],[Jan]]","v":131420},{"$f":"TrainingAndTravelPlan[[#Totals],[Feb]]+MarketingPlan[[#Totals],[Feb]]+OfficePlan[[#Totals],[Feb]]+EmployeePlan[[#Totals],[Feb]]","v":126820},{"$f":"TrainingAndTravelPlan[[#Totals],[Mar]]+MarketingPlan[[#Totals],[Mar]]+OfficePlan[[#Totals],[Mar]]+EmployeePlan[[#Totals],[Mar]]","v":126820},{"$f":"TrainingAndTravelPlan[[#Totals],[Apr]]+MarketingPlan[[#Totals],[Apr]]+OfficePlan[[#Totals],[Apr]]+EmployeePlan[[#Totals],[Apr]]","v":137695},{"$f":"TrainingAndTravelPlan[[#Totals],[May]]+MarketingPlan[[#Totals],[May]]+OfficePlan[[#Totals],[May]]+EmployeePlan[[#Totals],[May]]","v":129695},{"$f":"TrainingAndTravelPlan[[#Totals],[Jun]]+MarketingPlan[[#Totals],[Jun]]+OfficePlan[[#Totals],[Jun]]+EmployeePlan[[#Totals],[Jun]]","v":130495},{"$f":"TrainingAndTravelPlan[[#Totals],[Jul]]+MarketingPlan[[#Totals],[Jul]]+OfficePlan[[#Totals],[Jul]]+EmployeePlan[[#Totals],[Jul]]","v":134695},{"$f":"TrainingAndTravelPlan[[#Totals],[Aug]]+MarketingPlan[[#Totals],[Aug]]+OfficePlan[[#Totals],[Aug]]+EmployeePlan[[#Totals],[Aug]]","v":138918},{"$f":"TrainingAndTravelPlan[[#Totals],[Sep]]+MarketingPlan[[#Totals],[Sep]]+OfficePlan[[#Totals],[Sep]]+EmployeePlan[[#Totals],[Sep]]","v":135918},{"$f":"TrainingAndTravelPlan[[#Totals],[Oct]]+MarketingPlan[[#Totals],[Oct]]+OfficePlan[[#Totals],[Oct]]+EmployeePlan[[#Totals],[Oct]]","v":140918},{"$f":"TrainingAndTravelPlan[[#Totals],[Nov]]+MarketingPlan[[#Totals],[Nov]]+OfficePlan[[#Totals],[Nov]]+EmployeePlan[[#Totals],[Nov]]","v":136218},{"$f":"TrainingAndTravelPlan[[#Totals],[Dec]]+MarketingPlan[[#Totals],[Dec]]+OfficePlan[[#Totals],[Dec]]+EmployeePlan[[#Totals],[Dec]]","v":140018},{"$f":"TrainingAndTravelPlan[[#Totals],[YEAR]]+MarketingPlan[[#Totals],[YEAR]]+OfficePlan[[#Totals],[YEAR]]+EmployeePlan[[#Totals],[YEAR]]","v":1609630}]
[null,"TOTAL Planned Expenses",{"$f":"SUM($C$36:C36)","v":131420},{"$f":"SUM($C$36:D36)","v":258240},{"$f":"SUM($C$36:E36)","v":385060},{"$f":"SUM($C$36:F36)","v":522755},{"$f":"SUM($C$36:G36)","v":652450},{"$f":"SUM($C$36:H36)","v":782945},{"$f":"SUM($C$36:I36)","v":917640},{"$f":"SUM($C$36:J36)","v":1056558},{"$f":"SUM($C$36:K36)","v":1192476},{"$f":"SUM($C$36:L36)","v":1333394},{"$f":"SUM($C$36:M36)","v":1469612},{"$f":"SUM($C$36:N36)","v":1609630}]

{"sheet":"ACTUAL EXPENSES","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,13,2,14],[1,10,1,12],[2,10,2,12],[33,1,33,2],[28,1,28,2],[19,1,19,2],[8,1,8,2],[1,1,2,3]]}
["Enter Actual Employee Costs, Office Costs, Marketing Costs, and Training or Travel Cost in respective tables in this worksheet. Totals are auto calculated. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Company Name is auto updated in cell at right. Title of this worksheet is in cell K2. Enter Logo in cell N2.",{"$f":"'PLANNED EXPENSES'!B2:D3","v":"Company Name"},null,null,null,null,null,null,null,null,{"$f":"worksheet_title","v":"Detailed Expense Estimates"},null,null,"Logo placeholder is in this cell."]
["Tip is in cell K3.",null,null,null,null,null,null,null,null,null,"Shaded cells are calculations."]
["Actual Expenses label is in cell at right, months in cells C4 through N4, and Year label in O4.","ACTUAL EXPENSES","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YEAR"]
["Enter Employee Costs in Employee Actual table starting in cell at right. Next instruction is in cell A10.","Employee Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Wages",85000,85000,85000,88000,88000,88000,null,null,null,null,null,null,{"$f":"SUM(C6:N6)","v":519000}]
[null,"Benefits",{"$f":"C6*0.27","v":22950},22950,22950,23760,23760,23760,0,0,0,0,0,0,{"$f":"SUM(C7:N7)","v":140130}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,EmployeeActual[Jan])","v":107950},{"$f":"SUBTOTAL(109,EmployeeActual[Feb])","v":107950},{"$f":"SUBTOTAL(109,EmployeeActual[Mar])","v":107950},{"$f":"SUBTOTAL(109,EmployeeActual[Apr])","v":111760},{"$f":"SUBTOTAL(109,EmployeeActual[May])","v":111760},{"$f":"SUBTOTAL(109,EmployeeActual[Jun])","v":111760},{"$f":"SUBTOTAL(109,EmployeeActual[Jul])","v":0},{"$f":"SUBTOTAL(109,EmployeeActual[Aug])","v":0},{"$f":"SUBTOTAL(109,EmployeeActual[Sep])","v":0},{"$f":"SUBTOTAL(109,EmployeeActual[Oct])","v":0},{"$f":"SUBTOTAL(109,EmployeeActual[Nov])","v":0},{"$f":"SUBTOTAL(109,EmployeeActual[Dec])","v":0},{"$f":"SUBTOTAL(109,EmployeeActual[YEAR])","v":659130}]
[]
["Enter Office Costs in Office Actual table starting in cell at right. Next instruction is in cell A21.","Office Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Office lease",9800,9800,9800,9800,9800,9800,null,null,null,null,null,null,{"$f":"SUM(C11:N11)","v":58800}]
[null,"Gas",4,430,385,230,87,88,null,null,null,null,null,null,1224]
[null,"Electric",288,278,268,299,306,290,null,null,null,null,null,null,1729]
[null,"Water",35,33,34,36,34,36,null,null,null,null,null,null,208]
[null,"Telephone",224,235,265,245,245,220,null,null,null,null,null,null,1434]
[null,"Internet access",180,180,180,180,180,180,null,null,null,null,null,null,1080]
[null,"Office supplies",256,142,160,221,256,240,null,null,null,null,null,null,1275]
[null,"Security",600,600,600,600,600,600,null,null,null,null,null,null,3600]
[null,"Subtotal",{"$f":"SUBTOTAL(109,OfficeActual[Jan])","v":11387},{"$f":"SUBTOTAL(109,OfficeActual[Feb])","v":11698},{"$f":"SUBTOTAL(109,OfficeActual[Mar])","v":11692},{"$f":"SUBTOTAL(109,OfficeActual[Apr])","v":11611},{"$f":"SUBTOTAL(109,OfficeActual[May])","v":11508},{"$f":"SUBTOTAL(109,OfficeActual[Jun])","v":11454},{"$f":"SUBTOTAL(109,OfficeActual[Jul])","v":0},{"$f":"SUBTOTAL(109,OfficeActual[Aug])","v":0},{"$f":"SUBTOTAL(109,OfficeActual[Sep])","v":0},{"$f":"SUBTOTAL(109,OfficeActual[Oct])","v":0},{"$f":"SUBTOTAL(109,OfficeActual[Nov])","v":0},{"$f":"SUBTOTAL(109,OfficeActual[Dec])","v":0},{"$f":"SUBTOTAL(109,OfficeActual[YEAR])","v":69350}]
[]
["Enter Marketing Costs in Marketing Actual table starting in cell at right. Next instruction is in cell A30.","Marketing Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Web site hosting",500,500,500,500,500,500,null,null,null,null,null,null,{"$f":"SUM(C22:N22)","v":3000}]
[null,"Web site updates",200,200,200,200,200,1500,null,null,null,null,null,null,2500]
[null,"Collateral preparation",4800,0,0,5500,0,0,null,null,null,null,null,null,10300]
[null,"Collateral printing",100,500,100,100,600,180,null,null,null,null,null,null,1580]
[null,"Marketing events",1800,2200,2200,4700,1500,2300,null,null,null,null,null,null,14700]
[null,"Miscellaneous expenses",145,156,123,223,187,245,null,null,null,null,null,null,1079]
[null,"Subtotal",{"$f":"SUBTOTAL(109,MarketingActual[Jan])","v":7545},{"$f":"SUBTOTAL(109,MarketingActual[Feb])","v":3556},{"$f":"SUBTOTAL(109,MarketingActual[Mar])","v":3123},{"$f":"SUBTOTAL(109,MarketingActual[Apr])","v":11223},{"$f":"SUBTOTAL(109,MarketingActual[May])","v":2987},{"$f":"SUBTOTAL(109,MarketingActual[Jun])","v":4725},{"$f":"SUBTOTAL(109,MarketingActual[Jul])","v":0},{"$f":"SUBTOTAL(109,MarketingActual[Aug])","v":0},{"$f":"SUBTOTAL(109,MarketingActual[Sep])","v":0},{"$f":"SUBTOTAL(109,MarketingActual[Oct])","v":0},{"$f":"SUBTOTAL(109,MarketingActual[Nov])","v":0},{"$f":"SUBTOTAL(109,MarketingActual[Dec])","v":0},{"$f":"SUBTOTAL(109,MarketingActual[YEAR])","v":33159}]
[]
["Enter Training or Travel Costs in Training and Travel Actual table starting in cell at right. Next instruction is in cell A35.","Training/Travel","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Training classes",1600,2400,1400,1600,1200,2800,null,null,null,null,null,null,{"$f":"SUM(C31:N31)","v":11000}]
[null,"Training-related travel costs",1200,2200,1400,1200,800,3500,null,null,null,null,null,null,{"$f":"SUM(C32:N32)","v":10300}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Jan])","v":2800},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Feb])","v":4600},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Mar])","v":2800},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Apr])","v":2800},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[May])","v":2000},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Jun])","v":6300},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Jul])","v":0},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Aug])","v":0},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Sep])","v":0},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Oct])","v":0},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Nov])","v":0},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Dec])","v":0},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[YEAR])","v":21300}]
[]
["Total Actual Expenses are auto calculated in Total Actual table starting in cell at right.","TOTAL Planned Expenses","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year"]
[null,"Monthly Actual Expenses",{"$f":"TrainingAndTravelActual[[#Totals],[Jan]]+MarketingActual[[#Totals],[Jan]]+OfficeActual[[#Totals],[Jan]]+EmployeeActual[[#Totals],[Jan]]","v":129682},{"$f":"TrainingAndTravelActual[[#Totals],[Feb]]+MarketingActual[[#Totals],[Feb]]+OfficeActual[[#Totals],[Feb]]+EmployeeActual[[#Totals],[Feb]]","v":127804},{"$f":"TrainingAndTravelActual[[#Totals],[Mar]]+MarketingActual[[#Totals],[Mar]]+OfficeActual[[#Totals],[Mar]]+EmployeeActual[[#Totals],[Mar]]","v":125565},{"$f":"TrainingAndTravelActual[[#Totals],[Apr]]+MarketingActual[[#Totals],[Apr]]+OfficeActual[[#Totals],[Apr]]+EmployeeActual[[#Totals],[Apr]]","v":137394},{"$f":"TrainingAndTravelActual[[#Totals],[May]]+MarketingActual[[#Totals],[May]]+OfficeActual[[#Totals],[May]]+EmployeeActual[[#Totals],[May]]","v":128255},{"$f":"TrainingAndTravelActual[[#Totals],[Jun]]+MarketingActual[[#Totals],[Jun]]+OfficeActual[[#Totals],[Jun]]+EmployeeActual[[#Totals],[Jun]]","v":134239},{"$f":"TrainingAndTravelActual[[#Totals],[Jul]]+MarketingActual[[#Totals],[Jul]]+OfficeActual[[#Totals],[Jul]]+EmployeeActual[[#Totals],[Jul]]","v":0},{"$f":"TrainingAndTravelActual[[#Totals],[Aug]]+MarketingActual[[#Totals],[Aug]]+OfficeActual[[#Totals],[Aug]]+EmployeeActual[[#Totals],[Aug]]","v":0},{"$f":"TrainingAndTravelActual[[#Totals],[Sep]]+MarketingActual[[#Totals],[Sep]]+OfficeActual[[#Totals],[Sep]]+EmployeeActual[[#Totals],[Sep]]","v":0},{"$f":"TrainingAndTravelActual[[#Totals],[Oct]]+MarketingActual[[#Totals],[Oct]]+OfficeActual[[#Totals],[Oct]]+EmployeeActual[[#Totals],[Oct]]","v":0},{"$f":"TrainingAndTravelActual[[#Totals],[Nov]]+MarketingActual[[#Totals],[Nov]]+OfficeActual[[#Totals],[Nov]]+EmployeeActual[[#Totals],[Nov]]","v":0},{"$f":"TrainingAndTravelActual[[#Totals],[Dec]]+MarketingActual[[#Totals],[Dec]]+OfficeActual[[#Totals],[Dec]]+EmployeeActual[[#Totals],[Dec]]","v":0},{"$f":"TrainingAndTravelActual[[#Totals],[YEAR]]+MarketingActual[[#Totals],[YEAR]]+OfficeActual[[#Totals],[YEAR]]+EmployeeActual[[#Totals],[YEAR]]","v":782939}]
[null,"TOTAL Actual Expenses",{"$f":"SUM($C$36:C36)","v":129682},{"$f":"SUM($C$36:D36)","v":257486},{"$f":"SUM($C$36:E36)","v":383051},{"$f":"SUM($C$36:F36)","v":520445},{"$f":"SUM($C$36:G36)","v":648700},{"$f":"SUM($C$36:H36)","v":782939},{"$f":"SUM($C$36:I36)","v":782939},{"$f":"SUM($C$36:J36)","v":782939},{"$f":"SUM($C$36:K36)","v":782939},{"$f":"SUM($C$36:L36)","v":782939},{"$f":"SUM($C$36:M36)","v":782939},{"$f":"SUM($C$36:N36)","v":782939}]

{"sheet":"EXPENSE VARIANCES","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,13,2,14],[1,10,1,12],[2,10,2,12],[33,1,33,2],[28,1,28,2],[19,1,19,2],[8,1,8,2],[1,1,2,3]]}
["Expense Variance are auto calculated in this worksheet for Employee Costs, Office Costs, Marketing Costs, and Training or Travel Cost in respective tables in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started.",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Company Name is auto updated in cell at right. Title of this worksheet is in cell K2. Enter Logo in cell N2.",{"$f":"'PLANNED EXPENSES'!B2:D3","v":"Company Name"},null,null,null,null,null,null,null,null,{"$f":"worksheet_title","v":"Detailed Expense Estimates"},null,null,"Logo placeholder is in this cell."]
["Tip is in cell K3.",null,null,null,null,null,null,null,null,null,"Shaded cells are calculations."]
["Expense Variances label is in cell at right, months in cells C4 through N4, and Year label in O4.","EXPENSE VARIANCES","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEPT","OCT","NOV","DEC","YEAR"]
["Variance in Employee Costs is auto calculated in Employee Variances table starting in cell at right. Next instruction is in cell A10.","Employee Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Wages",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jan]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jan]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jan]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jan]],EmployeeActual[#Headers],0))","v":0},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Feb]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Feb]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Feb]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Feb]],EmployeeActual[#Headers],0))","v":0},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Mar]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Mar]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Mar]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Mar]],EmployeeActual[#Headers],0))","v":0},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Apr]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Apr]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Apr]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Apr]],EmployeeActual[#Headers],0))","v":-500},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[May]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[May]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[May]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[May]],EmployeeActual[#Headers],0))","v":-500},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jun]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jun]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jun]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jun]],EmployeeActual[#Headers],0))","v":-500},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jul]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jul]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jul]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jul]],EmployeeActual[#Headers],0))","v":87500},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Aug]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Aug]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Aug]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Aug]],EmployeeActual[#Headers],0))","v":92400},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sep]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sep]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sep]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sep]],EmployeeActual[#Headers],0))","v":92400},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Oct]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Oct]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Oct]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Oct]],EmployeeActual[#Headers],0))","v":92400},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Nov]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Nov]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Nov]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Nov]],EmployeeActual[#Headers],0))","v":92400},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Dec]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Dec]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Dec]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Dec]],EmployeeActual[#Headers],0))","v":92400},{"$f":"SUM(EmployeeVariances[[#This Row],[Jan]:[Dec]])","v":548000}]
[null,"Benefits",{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jan]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jan]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jan]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jan]],EmployeeActual[#Headers],0))","v":0},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Feb]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Feb]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Feb]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Feb]],EmployeeActual[#Headers],0))","v":0},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Mar]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Mar]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Mar]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Mar]],EmployeeActual[#Headers],0))","v":0},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Apr]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Apr]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Apr]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Apr]],EmployeeActual[#Headers],0))","v":-135},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[May]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[May]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[May]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[May]],EmployeeActual[#Headers],0))","v":-135},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jun]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jun]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jun]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jun]],EmployeeActual[#Headers],0))","v":-135},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jul]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jul]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Jul]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Jul]],EmployeeActual[#Headers],0))","v":23625},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Aug]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Aug]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Aug]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Aug]],EmployeeActual[#Headers],0))","v":24948},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sep]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sep]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Sep]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Sep]],EmployeeActual[#Headers],0))","v":24948},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Oct]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Oct]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Oct]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Oct]],EmployeeActual[#Headers],0))","v":24948},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Nov]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Nov]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Nov]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Nov]],EmployeeActual[#Headers],0))","v":24948},{"$f":"INDEX(EmployeePlan[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Dec]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Dec]],EmployeePlan[#Headers],0))-INDEX(EmployeeActual[],MATCH(INDEX(EmployeeVariances[],ROW()-ROW(EmployeeVariances[[#Headers],[Dec]]),1),INDEX(EmployeePlan[],,1),0),MATCH(EmployeeVariances[[#Headers],[Dec]],EmployeeActual[#Headers],0))","v":24948},{"$f":"SUM(EmployeeVariances[[#This Row],[Jan]:[Dec]])","v":147960}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,EmployeeVariances[Jan])","v":0},{"$f":"SUBTOTAL(109,EmployeeVariances[Feb])","v":0},{"$f":"SUBTOTAL(109,EmployeeVariances[Mar])","v":0},{"$f":"SUBTOTAL(109,EmployeeVariances[Apr])","v":-635},{"$f":"SUBTOTAL(109,EmployeeVariances[May])","v":-635},{"$f":"SUBTOTAL(109,EmployeeVariances[Jun])","v":-635},{"$f":"SUBTOTAL(109,EmployeeVariances[Jul])","v":111125},{"$f":"SUBTOTAL(109,EmployeeVariances[Aug])","v":117348},{"$f":"SUBTOTAL(109,EmployeeVariances[Sep])","v":117348},{"$f":"SUBTOTAL(109,EmployeeVariances[Oct])","v":117348},{"$f":"SUBTOTAL(109,EmployeeVariances[Nov])","v":117348},{"$f":"SUBTOTAL(109,EmployeeVariances[Dec])","v":117348},{"$f":"SUBTOTAL(109,EmployeeVariances[YEAR])","v":695960}]
[]
["Variance in Office Costs is auto calculated in Office Variances table starting in cell at right. Next instruction is in cell A21.","Office Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Office lease",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficeActual[#Headers],0))","v":9800},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficeActual[#Headers],0))","v":9800},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficeActual[#Headers],0))","v":9800},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficeActual[#Headers],0))","v":9800},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficeActual[#Headers],0))","v":9800},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficeActual[#Headers],0))","v":9800},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":58800}]
[null,"Gas",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficeActual[#Headers],0))","v":-4},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficeActual[#Headers],0))","v":-30},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":15},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficeActual[#Headers],0))","v":-130},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":13},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficeActual[#Headers],0))","v":12},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficeActual[#Headers],0))","v":100},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficeActual[#Headers],0))","v":100},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficeActual[#Headers],0))","v":100},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficeActual[#Headers],0))","v":100},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficeActual[#Headers],0))","v":400},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficeActual[#Headers],0))","v":400},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":1076}]
[null,"Electric",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficeActual[#Headers],0))","v":12},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficeActual[#Headers],0))","v":22},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":32},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficeActual[#Headers],0))","v":1},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":-6},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficeActual[#Headers],0))","v":10},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficeActual[#Headers],0))","v":300},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficeActual[#Headers],0))","v":300},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficeActual[#Headers],0))","v":300},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficeActual[#Headers],0))","v":300},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficeActual[#Headers],0))","v":300},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficeActual[#Headers],0))","v":300},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":1871}]
[null,"Water",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficeActual[#Headers],0))","v":5},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficeActual[#Headers],0))","v":7},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":6},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficeActual[#Headers],0))","v":4},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":6},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficeActual[#Headers],0))","v":4},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficeActual[#Headers],0))","v":40},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficeActual[#Headers],0))","v":40},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficeActual[#Headers],0))","v":40},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficeActual[#Headers],0))","v":40},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficeActual[#Headers],0))","v":40},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficeActual[#Headers],0))","v":40},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":272}]
[null,"Telephone",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficeActual[#Headers],0))","v":26},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficeActual[#Headers],0))","v":15},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":-15},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficeActual[#Headers],0))","v":5},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":5},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficeActual[#Headers],0))","v":30},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficeActual[#Headers],0))","v":250},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficeActual[#Headers],0))","v":250},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficeActual[#Headers],0))","v":250},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficeActual[#Headers],0))","v":250},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficeActual[#Headers],0))","v":250},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficeActual[#Headers],0))","v":250},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":1566}]
[null,"Internet access",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficeActual[#Headers],0))","v":180},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficeActual[#Headers],0))","v":180},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficeActual[#Headers],0))","v":180},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficeActual[#Headers],0))","v":180},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficeActual[#Headers],0))","v":180},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficeActual[#Headers],0))","v":180},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":1080}]
[null,"Office supplies",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficeActual[#Headers],0))","v":-56},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficeActual[#Headers],0))","v":58},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":40},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficeActual[#Headers],0))","v":-21},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":-56},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficeActual[#Headers],0))","v":-40},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficeActual[#Headers],0))","v":200},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficeActual[#Headers],0))","v":200},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficeActual[#Headers],0))","v":200},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficeActual[#Headers],0))","v":200},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficeActual[#Headers],0))","v":200},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficeActual[#Headers],0))","v":200},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":1125}]
[null,"Security",{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jan]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jan]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Feb]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Feb]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Mar]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Mar]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Apr]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Apr]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[May]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[May]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jun]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jun]],OfficeActual[#Headers],0))","v":0},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Jul]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Jul]],OfficeActual[#Headers],0))","v":600},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Aug]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Aug]],OfficeActual[#Headers],0))","v":600},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Sep]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Sep]],OfficeActual[#Headers],0))","v":600},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Oct]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Oct]],OfficeActual[#Headers],0))","v":600},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Nov]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Nov]],OfficeActual[#Headers],0))","v":600},{"$f":"INDEX(OfficePlan[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficePlan[#Headers],0))-INDEX(OfficeActual[],MATCH(INDEX(OfficeVariances[],ROW()-ROW(OfficeVariances[[#Headers],[Dec]]),1),INDEX(OfficePlan[],,1),0),MATCH(OfficeVariances[[#Headers],[Dec]],OfficeActual[#Headers],0))","v":600},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":3600}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,OfficeVariances[Jan])","v":-17},{"$f":"SUBTOTAL(109,OfficeVariances[Feb])","v":72},{"$f":"SUBTOTAL(109,OfficeVariances[Mar])","v":78},{"$f":"SUBTOTAL(109,OfficeVariances[Apr])","v":-141},{"$f":"SUBTOTAL(109,OfficeVariances[May])","v":-38},{"$f":"SUBTOTAL(109,OfficeVariances[Jun])","v":16},{"$f":"SUBTOTAL(109,OfficeVariances[Jul])","v":11470},{"$f":"SUBTOTAL(109,OfficeVariances[Aug])","v":11470},{"$f":"SUBTOTAL(109,OfficeVariances[Sep])","v":11470},{"$f":"SUBTOTAL(109,OfficeVariances[Oct])","v":11470},{"$f":"SUBTOTAL(109,OfficeVariances[Nov])","v":11770},{"$f":"SUBTOTAL(109,OfficeVariances[Dec])","v":11770},{"$f":"SUBTOTAL(109,OfficeVariances[YEAR])","v":69390}]
[]
["Variance in Marketing Costs is auto calculated in Marketing Variances table starting in cell at right. Next instruction is in cell A30.","Marketing Costs","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Web site hosting",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingActual[#Headers],0))","v":500},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingActual[#Headers],0))","v":500},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingActual[#Headers],0))","v":500},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingActual[#Headers],0))","v":500},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingActual[#Headers],0))","v":500},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingActual[#Headers],0))","v":500},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":3000}]
[null,"Web site updates",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingActual[#Headers],0))","v":-500},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingActual[#Headers],0))","v":1000},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":1500}]
[null,"Collateral preparation",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingActual[#Headers],0))","v":-500},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingActual[#Headers],0))","v":5000},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingActual[#Headers],0))","v":5000},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingActual[#Headers],0))","v":0},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingActual[#Headers],0))","v":0},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":9700}]
[null,"Collateral printing",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingActual[#Headers],0))","v":100},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingActual[#Headers],0))","v":-300},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":100},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingActual[#Headers],0))","v":100},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":-400},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingActual[#Headers],0))","v":20},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingActual[#Headers],0))","v":200},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":820}]
[null,"Marketing events",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingActual[#Headers],0))","v":-200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":-200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingActual[#Headers],0))","v":300},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":500},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingActual[#Headers],0))","v":-300},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingActual[#Headers],0))","v":2000},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingActual[#Headers],0))","v":5000},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingActual[#Headers],0))","v":2000},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingActual[#Headers],0))","v":2000},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingActual[#Headers],0))","v":2000},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingActual[#Headers],0))","v":5000},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":18300}]
[null,"Miscellaneous expenses",{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jan]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jan]],MarketingActual[#Headers],0))","v":55},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Feb]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Feb]],MarketingActual[#Headers],0))","v":44},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Mar]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Mar]],MarketingActual[#Headers],0))","v":77},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Apr]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Apr]],MarketingActual[#Headers],0))","v":-23},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[May]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[May]],MarketingActual[#Headers],0))","v":13},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jun]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jun]],MarketingActual[#Headers],0))","v":-45},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Jul]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Jul]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Aug]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Aug]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Sep]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Sep]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Oct]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Oct]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Nov]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Nov]],MarketingActual[#Headers],0))","v":200},{"$f":"INDEX(MarketingPlan[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingPlan[#Headers],0))-INDEX(MarketingActual[],MATCH(INDEX(MarketingVariances[],ROW()-ROW(MarketingVariances[[#Headers],[Dec]]),1),INDEX(MarketingPlan[],,1),0),MATCH(MarketingVariances[[#Headers],[Dec]],MarketingActual[#Headers],0))","v":200},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":1321}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,MarketingVariances[Jan])","v":555},{"$f":"SUBTOTAL(109,MarketingVariances[Feb])","v":-456},{"$f":"SUBTOTAL(109,MarketingVariances[Mar])","v":-23},{"$f":"SUBTOTAL(109,MarketingVariances[Apr])","v":-123},{"$f":"SUBTOTAL(109,MarketingVariances[May])","v":113},{"$f":"SUBTOTAL(109,MarketingVariances[Jun])","v":-825},{"$f":"SUBTOTAL(109,MarketingVariances[Jul])","v":8100},{"$f":"SUBTOTAL(109,MarketingVariances[Aug])","v":6100},{"$f":"SUBTOTAL(109,MarketingVariances[Sep])","v":3100},{"$f":"SUBTOTAL(109,MarketingVariances[Oct])","v":8100},{"$f":"SUBTOTAL(109,MarketingVariances[Nov])","v":3100},{"$f":"SUBTOTAL(109,MarketingVariances[Dec])","v":6900},{"$f":"SUBTOTAL(109,MarketingVariances[YEAR])","v":34641}]
[]
["Variance in Training or Travel Costs is auto calculated in Training and Travel Variances table starting in cell at right. Next instruction is in cell A35.","Training/Travel","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YEAR"]
[null,"Training classes",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jan]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jan]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jan]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jan]],TrainingAndTravelActual[#Headers],0))","v":400},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Feb]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Feb]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Feb]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Feb]],TrainingAndTravelActual[#Headers],0))","v":-400},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Mar]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Mar]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Mar]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Mar]],TrainingAndTravelActual[#Headers],0))","v":600},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Apr]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Apr]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Apr]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Apr]],TrainingAndTravelActual[#Headers],0))","v":400},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[May]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[May]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[May]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[May]],TrainingAndTravelActual[#Headers],0))","v":800},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jun]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jun]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jun]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jun]],TrainingAndTravelActual[#Headers],0))","v":-800},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jul]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jul]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jul]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jul]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Aug]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Aug]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Aug]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Aug]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sep]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sep]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sep]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sep]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Oct]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Oct]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Oct]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Oct]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Nov]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Nov]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Nov]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Nov]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Dec]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Dec]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Dec]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Dec]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Jan]:[Dec]])","v":13000}]
[null,"Training-related travel costs",{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jan]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jan]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jan]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jan]],TrainingAndTravelActual[#Headers],0))","v":800},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Feb]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Feb]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Feb]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Feb]],TrainingAndTravelActual[#Headers],0))","v":-200},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Mar]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Mar]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Mar]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Mar]],TrainingAndTravelActual[#Headers],0))","v":600},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Apr]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Apr]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Apr]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Apr]],TrainingAndTravelActual[#Headers],0))","v":800},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[May]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[May]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[May]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[May]],TrainingAndTravelActual[#Headers],0))","v":1200},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jun]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jun]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jun]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jun]],TrainingAndTravelActual[#Headers],0))","v":-1500},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jul]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jul]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Jul]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Jul]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Aug]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Aug]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Aug]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Aug]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sep]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sep]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Sep]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Sep]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Oct]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Oct]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Oct]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Oct]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Nov]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Nov]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Nov]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Nov]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"INDEX(TrainingAndTravelPlan[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Dec]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Dec]],TrainingAndTravelPlan[#Headers],0))-INDEX(TrainingAndTravelActual[],MATCH(INDEX(TrainingAndTravelVariances[],ROW()-ROW(TrainingAndTravelVariances[[#Headers],[Dec]]),1),INDEX(TrainingAndTravelPlan[],,1),0),MATCH(TrainingAndTravelVariances[[#Headers],[Dec]],TrainingAndTravelActual[#Headers],0))","v":2000},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Jan]:[Dec]])","v":13700}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Jan])","v":1200},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Feb])","v":-600},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Mar])","v":1200},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Apr])","v":1200},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[May])","v":2000},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Jun])","v":-2300},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Jul])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Aug])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Sep])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Oct])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Nov])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Dec])","v":4000},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[YEAR])","v":26700}]
[]
["Expense Variances are auto calculated in Total Variance table starting in cell at right.","TOTALS","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Year"]
[null,"Monthly Actual Expenses",{"$f":"TrainingAndTravelVariances[[#Totals],[Jan]]+MarketingVariances[[#Totals],[Jan]]+OfficeVariances[[#Totals],[Jan]]+EmployeeVariances[[#Totals],[Jan]]","v":1738},{"$f":"TrainingAndTravelVariances[[#Totals],[Feb]]+MarketingVariances[[#Totals],[Feb]]+OfficeVariances[[#Totals],[Feb]]+EmployeeVariances[[#Totals],[Feb]]","v":-984},{"$f":"TrainingAndTravelVariances[[#Totals],[Mar]]+MarketingVariances[[#Totals],[Mar]]+OfficeVariances[[#Totals],[Mar]]+EmployeeVariances[[#Totals],[Mar]]","v":1255},{"$f":"TrainingAndTravelVariances[[#Totals],[Apr]]+MarketingVariances[[#Totals],[Apr]]+OfficeVariances[[#Totals],[Apr]]+EmployeeVariances[[#Totals],[Apr]]","v":301},{"$f":"TrainingAndTravelVariances[[#Totals],[May]]+MarketingVariances[[#Totals],[May]]+OfficeVariances[[#Totals],[May]]+EmployeeVariances[[#Totals],[May]]","v":1440},{"$f":"TrainingAndTravelVariances[[#Totals],[Jun]]+MarketingVariances[[#Totals],[Jun]]+OfficeVariances[[#Totals],[Jun]]+EmployeeVariances[[#Totals],[Jun]]","v":-3744},{"$f":"TrainingAndTravelVariances[[#Totals],[Jul]]+MarketingVariances[[#Totals],[Jul]]+OfficeVariances[[#Totals],[Jul]]+EmployeeVariances[[#Totals],[Jul]]","v":134695},{"$f":"TrainingAndTravelVariances[[#Totals],[Aug]]+MarketingVariances[[#Totals],[Aug]]+OfficeVariances[[#Totals],[Aug]]+EmployeeVariances[[#Totals],[Aug]]","v":138918},{"$f":"TrainingAndTravelVariances[[#Totals],[Sep]]+MarketingVariances[[#Totals],[Sep]]+OfficeVariances[[#Totals],[Sep]]+EmployeeVariances[[#Totals],[Sep]]","v":135918},{"$f":"TrainingAndTravelVariances[[#Totals],[Oct]]+MarketingVariances[[#Totals],[Oct]]+OfficeVariances[[#Totals],[Oct]]+EmployeeVariances[[#Totals],[Oct]]","v":140918},{"$f":"TrainingAndTravelVariances[[#Totals],[Nov]]+MarketingVariances[[#Totals],[Nov]]+OfficeVariances[[#Totals],[Nov]]+EmployeeVariances[[#Totals],[Nov]]","v":136218},{"$f":"TrainingAndTravelVariances[[#Totals],[Dec]]+MarketingVariances[[#Totals],[Dec]]+OfficeVariances[[#Totals],[Dec]]+EmployeeVariances[[#Totals],[Dec]]","v":140018},{"$f":"TrainingAndTravelVariances[[#Totals],[YEAR]]+MarketingVariances[[#Totals],[YEAR]]+OfficeVariances[[#Totals],[YEAR]]+EmployeeVariances[[#Totals],[YEAR]]","v":826691}]
[null,"TOTAL Actual Expenses",{"$f":"SUM($C$36:C36)","v":1738},{"$f":"SUM($C$36:D36)","v":754},{"$f":"SUM($C$36:E36)","v":2009},{"$f":"SUM($C$36:F36)","v":2310},{"$f":"SUM($C$36:G36)","v":3750},{"$f":"SUM($C$36:H36)","v":6},{"$f":"SUM($C$36:I36)","v":134701},{"$f":"SUM($C$36:J36)","v":273619},{"$f":"SUM($C$36:K36)","v":409537},{"$f":"SUM($C$36:L36)","v":550455},{"$f":"SUM($C$36:M36)","v":686673},{"$f":"SUM($C$36:N36)","v":826691}]

{"sheet":"EXPENSE ANALYSIS","index":4,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,36,5],[1,1,2,3],[2,4,2,6],[1,5,1,6],[11,1,11,5]]}
["Annual Planned and Actual Expenses, Expense Variances, and Variance Percentage are auto updated for each Expense Category in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow down to get started. ",null,null,null,null,null," ",null,null,null,null,null,null,null,null," "]
["Company Name is auto updated in cell at right. Enter Logo in cell F2.",{"$f":"'PLANNED EXPENSES'!B2:D3","v":"Company Name"},null,null,null,"Logo placeholder is in this cell."]
["Title of this worksheet is in cell E3. Next instruction is in cell A5.",null,null,null,{"$f":"worksheet_title","v":"Detailed Expense Estimates"}]
[]
["Planned Expenses, Actual Expenses, Expense Variance, and Variance Percentage are auto calculated in Analysis table starting in cell at right. Next instruction is in cell A12.","Expense Category","Planned Expenses","Actual Expenses","Expense Variances","Variance Percentage"]
[null,"Employee Costs",{"$f":"EmployeePlan[[#Totals],[YEAR]]","v":1355090},{"$f":"EmployeeActual[[#Totals],[YEAR]]","v":659130},{"$f":"C6-D6","v":695960},{"$f":"E6/C6","v":0.5135895032802249}]
[null,{"$f":"'PLANNED EXPENSES'!B10","v":"Office Costs"},{"$f":"OfficePlan[[#Totals],[YEAR]]","v":138740},{"$f":"OfficeActual[[#Totals],[YEAR]]","v":69350},{"$f":"C7-D7","v":69390},{"$f":"E7/C7","v":0.50014415453366012}]
[null,{"$f":"'PLANNED EXPENSES'!B21","v":"Marketing Costs"},{"$f":"MarketingPlan[[#Totals],[YEAR]]","v":67800},{"$f":"MarketingActual[[#Totals],[YEAR]]","v":33159},{"$f":"C8-D8","v":34641},{"$f":"E8/C8","v":0.51092920353982296}]
[null,{"$f":"'PLANNED EXPENSES'!B30","v":"Training/Travel"},{"$f":"TrainingAndTravelPlan[[#Totals],[YEAR]]","v":48000},{"$f":"TrainingAndTravelActual[[#Totals],[YEAR]]","v":21300},{"$f":"C9-D9","v":26700},{"$f":"E9/C9","v":0.55625000000000002}]
[null,{"$f":"'PLANNED EXPENSES'!B35","v":"TOTALS"},{"$f":"'PLANNED EXPENSES'!O36","v":1609630},{"$f":"'ACTUAL EXPENSES'!O36","v":782939},{"$f":"C10-D10","v":826691},{"$f":"E10/C10","v":0.51359070096854553}]
[]
["Planned Expenses pie chart is in cell at right and Actual Expenses pie chart in cell D12. Next instruction is in cell A14.","Pie chart showing planned expenses on various categories is in this cell."]
[]
["Chart showing Planned, Actual, and Variance in Monthly Expenses is in cell at right."]