{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["START","PLANNED EXPENSES","ACTUAL EXPENSES","EXPENSE VARIANCES","EXPENSE ANALYSIS"],"not_rendered":{"charts":2,"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"START","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[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,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[3,17,12,19],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["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.",{"$nulls":14}," "]
["Enter Company Name in cell at right and Logo in cell N2. Title of this worksheet is in cell K2.","Company Name",{"$nulls":8},"Detailed Expense Estimates",null,null,"Logo placeholder is in this cell."]
["Tip is in cell K3.",{"$nulls":9},"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",{"v":85000,"d":"$85,000.00"},{"v":85000,"d":"$85,000.00"},{"v":85000,"d":"$85,000.00"},{"v":87500,"d":"$87,500.00"},{"v":87500,"d":"$87,500.00"},{"v":87500,"d":"$87,500.00"},{"v":87500,"d":"$87,500.00"},{"v":92400,"d":"$92,400.00"},{"v":92400,"d":"$92,400.00"},{"v":92400,"d":"$92,400.00"},{"v":92400,"d":"$92,400.00"},{"v":92400,"d":"$92,400.00"},{"$f":"SUM(C6:N6)","v":{"v":1067000,"d":"$1,067,000.00"}}]
[null,"Benefits",{"$f":"C6*0.27","v":{"v":22950,"d":"$22,950.00"}},{"v":22950,"d":"$22,950.00"},{"v":22950,"d":"$22,950.00"},{"v":23625,"d":"$23,625.00"},{"v":23625,"d":"$23,625.00"},{"v":23625,"d":"$23,625.00"},{"v":23625,"d":"$23,625.00"},{"v":24948,"d":"$24,948.00"},{"v":24948,"d":"$24,948.00"},{"v":24948,"d":"$24,948.00"},{"v":24948,"d":"$24,948.00"},{"v":24948,"d":"$24,948.00"},{"$f":"SUM(C7:N7)","v":{"v":288090,"d":"$288,090.00"}}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,EmployeePlan[Jan])","v":{"v":107950,"d":"$107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Feb])","v":{"v":107950,"d":"$107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Mar])","v":{"v":107950,"d":"$107,950.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Apr])","v":{"v":111125,"d":"$111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[May])","v":{"v":111125,"d":"$111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Jun])","v":{"v":111125,"d":"$111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Jul])","v":{"v":111125,"d":"$111,125.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Aug])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Sep])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Oct])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Nov])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[Dec])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeePlan[YEAR])","v":{"v":1355090,"d":"$1,355,090.00"}}]
[]
["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",{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"$f":"SUM(C11:N11)","v":{"v":117600,"d":"$117,600.00"}}]
[null,"Gas",null,{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":400,"d":"$400.00"},{"v":400,"d":"$400.00"},{"v":2300,"d":"$2,300.00"}]
[null,"Electric",{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"},{"v":3600,"d":"$3,600.00"}]
[null,"Water",{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":40,"d":"$40.00"},{"v":480,"d":"$480.00"}]
[null,"Telephone",{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"},{"v":3000,"d":"$3,000.00"}]
[null,"Internet access",{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":2160,"d":"$2,160.00"}]
[null,"Office supplies",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":2400,"d":"$2,400.00"}]
[null,"Security",{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":7200,"d":"$7,200.00"}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,OfficePlan[Jan])","v":{"v":11370,"d":"$11,370.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Feb])","v":{"v":11770,"d":"$11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Mar])","v":{"v":11770,"d":"$11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Apr])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[May])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Jun])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Jul])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Aug])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Sep])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Oct])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Nov])","v":{"v":11770,"d":"$11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[Dec])","v":{"v":11770,"d":"$11,770.00"}},{"$f":"SUBTOTAL(109,OfficePlan[YEAR])","v":{"v":138740,"d":"$138,740.00"}}]
[]
["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",{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"$f":"SUM(C22:N22)","v":{"v":6000,"d":"$6,000.00"}}]
[null,"Web site updates",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":1000,"d":"$1,000.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":1000,"d":"$1,000.00"},{"v":4000,"d":"$4,000.00"}]
[null,"Collateral preparation",{"v":5000,"d":"$5,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":5000,"d":"$5,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":5000,"d":"$5,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":5000,"d":"$5,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":20000,"d":"$20,000.00"}]
[null,"Collateral printing",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":2400,"d":"$2,400.00"}]
[null,"Marketing events",{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":5000,"d":"$5,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":5000,"d":"$5,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":5000,"d":"$5,000.00"},{"v":33000,"d":"$33,000.00"}]
[null,"Miscellaneous expenses",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":2400,"d":"$2,400.00"}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,MarketingPlan[Jan])","v":{"v":8100,"d":"$8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Feb])","v":{"v":3100,"d":"$3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Mar])","v":{"v":3100,"d":"$3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Apr])","v":{"v":11100,"d":"$11,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[May])","v":{"v":3100,"d":"$3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Jun])","v":{"v":3900,"d":"$3,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Jul])","v":{"v":8100,"d":"$8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Aug])","v":{"v":6100,"d":"$6,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Sep])","v":{"v":3100,"d":"$3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Oct])","v":{"v":8100,"d":"$8,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Nov])","v":{"v":3100,"d":"$3,100.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[Dec])","v":{"v":6900,"d":"$6,900.00"}},{"$f":"SUBTOTAL(109,MarketingPlan[YEAR])","v":{"v":67800,"d":"$67,800.00"}}]
[]
["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",{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"$f":"SUM(C31:N31)","v":{"v":24000,"d":"$24,000.00"}}]
[null,"Training-related travel costs",{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"},{"$f":"SUM(C32:N32)","v":{"v":24000,"d":"$24,000.00"}}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Jan])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Feb])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Mar])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Apr])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[May])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Jun])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Jul])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Aug])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Sep])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Oct])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Nov])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[Dec])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelPlan[YEAR])","v":{"v":48000,"d":"$48,000.00"}}]
[]
["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":{"v":131420,"d":"$131,420.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Feb]]+MarketingPlan[[#Totals],[Feb]]+OfficePlan[[#Totals],[Feb]]+EmployeePlan[[#Totals],[Feb]]","v":{"v":126820,"d":"$126,820.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Mar]]+MarketingPlan[[#Totals],[Mar]]+OfficePlan[[#Totals],[Mar]]+EmployeePlan[[#Totals],[Mar]]","v":{"v":126820,"d":"$126,820.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Apr]]+MarketingPlan[[#Totals],[Apr]]+OfficePlan[[#Totals],[Apr]]+EmployeePlan[[#Totals],[Apr]]","v":{"v":137695,"d":"$137,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[May]]+MarketingPlan[[#Totals],[May]]+OfficePlan[[#Totals],[May]]+EmployeePlan[[#Totals],[May]]","v":{"v":129695,"d":"$129,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Jun]]+MarketingPlan[[#Totals],[Jun]]+OfficePlan[[#Totals],[Jun]]+EmployeePlan[[#Totals],[Jun]]","v":{"v":130495,"d":"$130,495.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Jul]]+MarketingPlan[[#Totals],[Jul]]+OfficePlan[[#Totals],[Jul]]+EmployeePlan[[#Totals],[Jul]]","v":{"v":134695,"d":"$134,695.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Aug]]+MarketingPlan[[#Totals],[Aug]]+OfficePlan[[#Totals],[Aug]]+EmployeePlan[[#Totals],[Aug]]","v":{"v":138918,"d":"$138,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Sep]]+MarketingPlan[[#Totals],[Sep]]+OfficePlan[[#Totals],[Sep]]+EmployeePlan[[#Totals],[Sep]]","v":{"v":135918,"d":"$135,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Oct]]+MarketingPlan[[#Totals],[Oct]]+OfficePlan[[#Totals],[Oct]]+EmployeePlan[[#Totals],[Oct]]","v":{"v":140918,"d":"$140,918.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Nov]]+MarketingPlan[[#Totals],[Nov]]+OfficePlan[[#Totals],[Nov]]+EmployeePlan[[#Totals],[Nov]]","v":{"v":136218,"d":"$136,218.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[Dec]]+MarketingPlan[[#Totals],[Dec]]+OfficePlan[[#Totals],[Dec]]+EmployeePlan[[#Totals],[Dec]]","v":{"v":140018,"d":"$140,018.00"}},{"$f":"TrainingAndTravelPlan[[#Totals],[YEAR]]+MarketingPlan[[#Totals],[YEAR]]+OfficePlan[[#Totals],[YEAR]]+EmployeePlan[[#Totals],[YEAR]]","v":{"v":1609630,"d":"$1,609,630.00"}}]
[null,"TOTAL Planned Expenses",{"$f":"SUM($C$36:C36)","v":{"v":131420,"d":"$131,420.00"}},{"$f":"SUM($C$36:D36)","v":{"v":258240,"d":"$258,240.00"}},{"$f":"SUM($C$36:E36)","v":{"v":385060,"d":"$385,060.00"}},{"$f":"SUM($C$36:F36)","v":{"v":522755,"d":"$522,755.00"}},{"$f":"SUM($C$36:G36)","v":{"v":652450,"d":"$652,450.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782945,"d":"$782,945.00"}},{"$f":"SUM($C$36:I36)","v":{"v":917640,"d":"$917,640.00"}},{"$f":"SUM($C$36:J36)","v":{"v":1056558,"d":"$1,056,558.00"}},{"$f":"SUM($C$36:K36)","v":{"v":1192476,"d":"$1,192,476.00"}},{"$f":"SUM($C$36:L36)","v":{"v":1333394,"d":"$1,333,394.00"}},{"$f":"SUM($C$36:M36)","v":{"v":1469612,"d":"$1,469,612.00"}},{"$f":"SUM($C$36:N36)","v":{"v":1609630,"d":"$1,609,630.00"}}]

{"sheet":"ACTUAL EXPENSES","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["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.",{"$nulls":14}," "]
["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"},{"$nulls":8},{"$f":"worksheet_title","v":"Detailed Expense Estimates"},null,null,"Logo placeholder is in this cell."]
["Tip is in cell K3.",{"$nulls":9},"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",{"v":85000,"d":"$85,000.00"},{"v":85000,"d":"$85,000.00"},{"v":85000,"d":"$85,000.00"},{"v":88000,"d":"$88,000.00"},{"v":88000,"d":"$88,000.00"},{"v":88000,"d":"$88,000.00"},{"$nulls":6},{"$f":"SUM(C6:N6)","v":{"v":519000,"d":"$519,000.00"}}]
[null,"Benefits",{"$f":"C6*0.27","v":{"v":22950,"d":"$22,950.00"}},{"v":22950,"d":"$22,950.00"},{"v":22950,"d":"$22,950.00"},{"v":23760,"d":"$23,760.00"},{"v":23760,"d":"$23,760.00"},{"v":23760,"d":"$23,760.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"SUM(C7:N7)","v":{"v":140130,"d":"$140,130.00"}}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,EmployeeActual[Jan])","v":{"v":107950,"d":"$107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Feb])","v":{"v":107950,"d":"$107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Mar])","v":{"v":107950,"d":"$107,950.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Apr])","v":{"v":111760,"d":"$111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[May])","v":{"v":111760,"d":"$111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Jun])","v":{"v":111760,"d":"$111,760.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Jul])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Aug])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Sep])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Oct])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Nov])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[Dec])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeActual[YEAR])","v":{"v":659130,"d":"$659,130.00"}}]
[]
["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",{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"v":9800,"d":"$9,800.00"},{"$nulls":6},{"$f":"SUM(C11:N11)","v":{"v":58800,"d":"$58,800.00"}}]
[null,"Gas",{"v":4,"d":"$4.00"},{"v":430,"d":"$430.00"},{"v":385,"d":"$385.00"},{"v":230,"d":"$230.00"},{"v":87,"d":"$87.00"},{"v":88,"d":"$88.00"},{"$nulls":6},{"v":1224,"d":"$1,224.00"}]
[null,"Electric",{"v":288,"d":"$288.00"},{"v":278,"d":"$278.00"},{"v":268,"d":"$268.00"},{"v":299,"d":"$299.00"},{"v":306,"d":"$306.00"},{"v":290,"d":"$290.00"},{"$nulls":6},{"v":1729,"d":"$1,729.00"}]
[null,"Water",{"v":35,"d":"$35.00"},{"v":33,"d":"$33.00"},{"v":34,"d":"$34.00"},{"v":36,"d":"$36.00"},{"v":34,"d":"$34.00"},{"v":36,"d":"$36.00"},{"$nulls":6},{"v":208,"d":"$208.00"}]
[null,"Telephone",{"v":224,"d":"$224.00"},{"v":235,"d":"$235.00"},{"v":265,"d":"$265.00"},{"v":245,"d":"$245.00"},{"v":245,"d":"$245.00"},{"v":220,"d":"$220.00"},{"$nulls":6},{"v":1434,"d":"$1,434.00"}]
[null,"Internet access",{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"v":180,"d":"$180.00"},{"$nulls":6},{"v":1080,"d":"$1,080.00"}]
[null,"Office supplies",{"v":256,"d":"$256.00"},{"v":142,"d":"$142.00"},{"v":160,"d":"$160.00"},{"v":221,"d":"$221.00"},{"v":256,"d":"$256.00"},{"v":240,"d":"$240.00"},{"$nulls":6},{"v":1275,"d":"$1,275.00"}]
[null,"Security",{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"v":600,"d":"$600.00"},{"$nulls":6},{"v":3600,"d":"$3,600.00"}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,OfficeActual[Jan])","v":{"v":11387,"d":"$11,387.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Feb])","v":{"v":11698,"d":"$11,698.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Mar])","v":{"v":11692,"d":"$11,692.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Apr])","v":{"v":11611,"d":"$11,611.00"}},{"$f":"SUBTOTAL(109,OfficeActual[May])","v":{"v":11508,"d":"$11,508.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Jun])","v":{"v":11454,"d":"$11,454.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Jul])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Aug])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Sep])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Oct])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Nov])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[Dec])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,OfficeActual[YEAR])","v":{"v":69350,"d":"$69,350.00"}}]
[]
["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",{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},{"$nulls":6},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"$3,000.00"}}]
[null,"Web site updates",{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":200,"d":"$200.00"},{"v":1500,"d":"$1,500.00"},{"$nulls":6},{"v":2500,"d":"$2,500.00"}]
[null,"Collateral preparation",{"v":4800,"d":"$4,800.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":5500,"d":"$5,500.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$nulls":6},{"v":10300,"d":"$10,300.00"}]
[null,"Collateral printing",{"v":100,"d":"$100.00"},{"v":500,"d":"$500.00"},{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"},{"v":600,"d":"$600.00"},{"v":180,"d":"$180.00"},{"$nulls":6},{"v":1580,"d":"$1,580.00"}]
[null,"Marketing events",{"v":1800,"d":"$1,800.00"},{"v":2200,"d":"$2,200.00"},{"v":2200,"d":"$2,200.00"},{"v":4700,"d":"$4,700.00"},{"v":1500,"d":"$1,500.00"},{"v":2300,"d":"$2,300.00"},{"$nulls":6},{"v":14700,"d":"$14,700.00"}]
[null,"Miscellaneous expenses",{"v":145,"d":"$145.00"},{"v":156,"d":"$156.00"},{"v":123,"d":"$123.00"},{"v":223,"d":"$223.00"},{"v":187,"d":"$187.00"},{"v":245,"d":"$245.00"},{"$nulls":6},{"v":1079,"d":"$1,079.00"}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,MarketingActual[Jan])","v":{"v":7545,"d":"$7,545.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Feb])","v":{"v":3556,"d":"$3,556.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Mar])","v":{"v":3123,"d":"$3,123.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Apr])","v":{"v":11223,"d":"$11,223.00"}},{"$f":"SUBTOTAL(109,MarketingActual[May])","v":{"v":2987,"d":"$2,987.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Jun])","v":{"v":4725,"d":"$4,725.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Jul])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Aug])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Sep])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Oct])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Nov])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[Dec])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,MarketingActual[YEAR])","v":{"v":33159,"d":"$33,159.00"}}]
[]
["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",{"v":1600,"d":"$1,600.00"},{"v":2400,"d":"$2,400.00"},{"v":1400,"d":"$1,400.00"},{"v":1600,"d":"$1,600.00"},{"v":1200,"d":"$1,200.00"},{"v":2800,"d":"$2,800.00"},{"$nulls":6},{"$f":"SUM(C31:N31)","v":{"v":11000,"d":"$11,000.00"}}]
[null,"Training-related travel costs",{"v":1200,"d":"$1,200.00"},{"v":2200,"d":"$2,200.00"},{"v":1400,"d":"$1,400.00"},{"v":1200,"d":"$1,200.00"},{"v":800,"d":"$800.00"},{"v":3500,"d":"$3,500.00"},{"$nulls":6},{"$f":"SUM(C32:N32)","v":{"v":10300,"d":"$10,300.00"}}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Jan])","v":{"v":2800,"d":"$2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Feb])","v":{"v":4600,"d":"$4,600.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Mar])","v":{"v":2800,"d":"$2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Apr])","v":{"v":2800,"d":"$2,800.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[May])","v":{"v":2000,"d":"$2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Jun])","v":{"v":6300,"d":"$6,300.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Jul])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Aug])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Sep])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Oct])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Nov])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[Dec])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelActual[YEAR])","v":{"v":21300,"d":"$21,300.00"}}]
[]
["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":{"v":129682,"d":"$129,682.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Feb]]+MarketingActual[[#Totals],[Feb]]+OfficeActual[[#Totals],[Feb]]+EmployeeActual[[#Totals],[Feb]]","v":{"v":127804,"d":"$127,804.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Mar]]+MarketingActual[[#Totals],[Mar]]+OfficeActual[[#Totals],[Mar]]+EmployeeActual[[#Totals],[Mar]]","v":{"v":125565,"d":"$125,565.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Apr]]+MarketingActual[[#Totals],[Apr]]+OfficeActual[[#Totals],[Apr]]+EmployeeActual[[#Totals],[Apr]]","v":{"v":137394,"d":"$137,394.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[May]]+MarketingActual[[#Totals],[May]]+OfficeActual[[#Totals],[May]]+EmployeeActual[[#Totals],[May]]","v":{"v":128255,"d":"$128,255.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Jun]]+MarketingActual[[#Totals],[Jun]]+OfficeActual[[#Totals],[Jun]]+EmployeeActual[[#Totals],[Jun]]","v":{"v":134239,"d":"$134,239.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Jul]]+MarketingActual[[#Totals],[Jul]]+OfficeActual[[#Totals],[Jul]]+EmployeeActual[[#Totals],[Jul]]","v":{"v":0,"d":"$0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Aug]]+MarketingActual[[#Totals],[Aug]]+OfficeActual[[#Totals],[Aug]]+EmployeeActual[[#Totals],[Aug]]","v":{"v":0,"d":"$0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Sep]]+MarketingActual[[#Totals],[Sep]]+OfficeActual[[#Totals],[Sep]]+EmployeeActual[[#Totals],[Sep]]","v":{"v":0,"d":"$0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Oct]]+MarketingActual[[#Totals],[Oct]]+OfficeActual[[#Totals],[Oct]]+EmployeeActual[[#Totals],[Oct]]","v":{"v":0,"d":"$0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Nov]]+MarketingActual[[#Totals],[Nov]]+OfficeActual[[#Totals],[Nov]]+EmployeeActual[[#Totals],[Nov]]","v":{"v":0,"d":"$0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[Dec]]+MarketingActual[[#Totals],[Dec]]+OfficeActual[[#Totals],[Dec]]+EmployeeActual[[#Totals],[Dec]]","v":{"v":0,"d":"$0.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[YEAR]]+MarketingActual[[#Totals],[YEAR]]+OfficeActual[[#Totals],[YEAR]]+EmployeeActual[[#Totals],[YEAR]]","v":{"v":782939,"d":"$782,939.00"}}]
[null,"TOTAL Actual Expenses",{"$f":"SUM($C$36:C36)","v":{"v":129682,"d":"$129,682.00"}},{"$f":"SUM($C$36:D36)","v":{"v":257486,"d":"$257,486.00"}},{"$f":"SUM($C$36:E36)","v":{"v":383051,"d":"$383,051.00"}},{"$f":"SUM($C$36:F36)","v":{"v":520445,"d":"$520,445.00"}},{"$f":"SUM($C$36:G36)","v":{"v":648700,"d":"$648,700.00"}},{"$f":"SUM($C$36:H36)","v":{"v":782939,"d":"$782,939.00"}},{"$f":"SUM($C$36:I36)","v":{"v":782939,"d":"$782,939.00"}},{"$f":"SUM($C$36:J36)","v":{"v":782939,"d":"$782,939.00"}},{"$f":"SUM($C$36:K36)","v":{"v":782939,"d":"$782,939.00"}},{"$f":"SUM($C$36:L36)","v":{"v":782939,"d":"$782,939.00"}},{"$f":"SUM($C$36:M36)","v":{"v":782939,"d":"$782,939.00"}},{"$f":"SUM($C$36:N36)","v":{"v":782939,"d":"$782,939.00"}}]

{"sheet":"EXPENSE VARIANCES","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["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.",{"$nulls":14}," "]
["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"},{"$nulls":8},{"$f":"worksheet_title","v":"Detailed Expense Estimates"},null,null,"Logo placeholder is in this cell."]
["Tip is in cell K3.",{"$nulls":9},"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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":-500,"d":"($500.00)"}},{"$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":{"v":-500,"d":"($500.00)"}},{"$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":{"v":-500,"d":"($500.00)"}},{"$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":{"v":87500,"d":"$87,500.00"}},{"$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":{"v":92400,"d":"$92,400.00"}},{"$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":{"v":92400,"d":"$92,400.00"}},{"$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":{"v":92400,"d":"$92,400.00"}},{"$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":{"v":92400,"d":"$92,400.00"}},{"$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":{"v":92400,"d":"$92,400.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":548000,"d":"$548,000.00"}}]
[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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":-135,"d":"($135.00)"}},{"$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":{"v":-135,"d":"($135.00)"}},{"$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":{"v":-135,"d":"($135.00)"}},{"$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":{"v":23625,"d":"$23,625.00"}},{"$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":{"v":24948,"d":"$24,948.00"}},{"$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":{"v":24948,"d":"$24,948.00"}},{"$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":{"v":24948,"d":"$24,948.00"}},{"$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":{"v":24948,"d":"$24,948.00"}},{"$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":{"v":24948,"d":"$24,948.00"}},{"$f":"SUM(EmployeeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":147960,"d":"$147,960.00"}}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,EmployeeVariances[Jan])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Feb])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Mar])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Apr])","v":{"v":-635,"d":"($635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[May])","v":{"v":-635,"d":"($635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Jun])","v":{"v":-635,"d":"($635.00)"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Jul])","v":{"v":111125,"d":"$111,125.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Aug])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Sep])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Oct])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Nov])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[Dec])","v":{"v":117348,"d":"$117,348.00"}},{"$f":"SUBTOTAL(109,EmployeeVariances[YEAR])","v":{"v":695960,"d":"$695,960.00"}}]
[]
["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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":9800,"d":"$9,800.00"}},{"$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":{"v":9800,"d":"$9,800.00"}},{"$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":{"v":9800,"d":"$9,800.00"}},{"$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":{"v":9800,"d":"$9,800.00"}},{"$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":{"v":9800,"d":"$9,800.00"}},{"$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":{"v":9800,"d":"$9,800.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":58800,"d":"$58,800.00"}}]
[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":{"v":-4,"d":"($4.00)"}},{"$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":{"v":-30,"d":"($30.00)"}},{"$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":{"v":15,"d":"$15.00"}},{"$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":{"v":-130,"d":"($130.00)"}},{"$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":{"v":13,"d":"$13.00"}},{"$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":{"v":12,"d":"$12.00"}},{"$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":{"v":100,"d":"$100.00"}},{"$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":{"v":100,"d":"$100.00"}},{"$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":{"v":100,"d":"$100.00"}},{"$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":{"v":100,"d":"$100.00"}},{"$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":{"v":400,"d":"$400.00"}},{"$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":{"v":400,"d":"$400.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":1076,"d":"$1,076.00"}}]
[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":{"v":12,"d":"$12.00"}},{"$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":{"v":22,"d":"$22.00"}},{"$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":{"v":32,"d":"$32.00"}},{"$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":{"v":1,"d":"$1.00"}},{"$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":{"v":-6,"d":"($6.00)"}},{"$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":{"v":10,"d":"$10.00"}},{"$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":{"v":300,"d":"$300.00"}},{"$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":{"v":300,"d":"$300.00"}},{"$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":{"v":300,"d":"$300.00"}},{"$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":{"v":300,"d":"$300.00"}},{"$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":{"v":300,"d":"$300.00"}},{"$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":{"v":300,"d":"$300.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":1871,"d":"$1,871.00"}}]
[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":{"v":5,"d":"$5.00"}},{"$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":{"v":7,"d":"$7.00"}},{"$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":{"v":6,"d":"$6.00"}},{"$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":{"v":4,"d":"$4.00"}},{"$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":{"v":6,"d":"$6.00"}},{"$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":{"v":4,"d":"$4.00"}},{"$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":{"v":40,"d":"$40.00"}},{"$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":{"v":40,"d":"$40.00"}},{"$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":{"v":40,"d":"$40.00"}},{"$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":{"v":40,"d":"$40.00"}},{"$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":{"v":40,"d":"$40.00"}},{"$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":{"v":40,"d":"$40.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":272,"d":"$272.00"}}]
[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":{"v":26,"d":"$26.00"}},{"$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":{"v":15,"d":"$15.00"}},{"$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":{"v":-15,"d":"($15.00)"}},{"$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":{"v":5,"d":"$5.00"}},{"$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":{"v":5,"d":"$5.00"}},{"$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":{"v":30,"d":"$30.00"}},{"$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":{"v":250,"d":"$250.00"}},{"$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":{"v":250,"d":"$250.00"}},{"$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":{"v":250,"d":"$250.00"}},{"$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":{"v":250,"d":"$250.00"}},{"$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":{"v":250,"d":"$250.00"}},{"$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":{"v":250,"d":"$250.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":1566,"d":"$1,566.00"}}]
[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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":180,"d":"$180.00"}},{"$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":{"v":180,"d":"$180.00"}},{"$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":{"v":180,"d":"$180.00"}},{"$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":{"v":180,"d":"$180.00"}},{"$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":{"v":180,"d":"$180.00"}},{"$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":{"v":180,"d":"$180.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":1080,"d":"$1,080.00"}}]
[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":{"v":-56,"d":"($56.00)"}},{"$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":{"v":58,"d":"$58.00"}},{"$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":{"v":40,"d":"$40.00"}},{"$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":{"v":-21,"d":"($21.00)"}},{"$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":{"v":-56,"d":"($56.00)"}},{"$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":{"v":-40,"d":"($40.00)"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":1125,"d":"$1,125.00"}}]
[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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":600,"d":"$600.00"}},{"$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":{"v":600,"d":"$600.00"}},{"$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":{"v":600,"d":"$600.00"}},{"$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":{"v":600,"d":"$600.00"}},{"$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":{"v":600,"d":"$600.00"}},{"$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":{"v":600,"d":"$600.00"}},{"$f":"SUM(OfficeVariances[[#This Row],[Jan]:[Dec]])","v":{"v":3600,"d":"$3,600.00"}}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,OfficeVariances[Jan])","v":{"v":-17,"d":"($17.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[Feb])","v":{"v":72,"d":"$72.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Mar])","v":{"v":78,"d":"$78.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Apr])","v":{"v":-141,"d":"($141.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[May])","v":{"v":-38,"d":"($38.00)"}},{"$f":"SUBTOTAL(109,OfficeVariances[Jun])","v":{"v":16,"d":"$16.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Jul])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Aug])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Sep])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Oct])","v":{"v":11470,"d":"$11,470.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Nov])","v":{"v":11770,"d":"$11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[Dec])","v":{"v":11770,"d":"$11,770.00"}},{"$f":"SUBTOTAL(109,OfficeVariances[YEAR])","v":{"v":69390,"d":"$69,390.00"}}]
[]
["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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":500,"d":"$500.00"}},{"$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":{"v":500,"d":"$500.00"}},{"$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":{"v":500,"d":"$500.00"}},{"$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":{"v":500,"d":"$500.00"}},{"$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":{"v":500,"d":"$500.00"}},{"$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":{"v":500,"d":"$500.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":{"v":3000,"d":"$3,000.00"}}]
[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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":-500,"d":"($500.00)"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":1000,"d":"$1,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":{"v":1500,"d":"$1,500.00"}}]
[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":{"v":200,"d":"$200.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":-500,"d":"($500.00)"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":5000,"d":"$5,000.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":5000,"d":"$5,000.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$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":{"v":0,"d":"$0.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":{"v":9700,"d":"$9,700.00"}}]
[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":{"v":100,"d":"$100.00"}},{"$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":{"v":-300,"d":"($300.00)"}},{"$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":{"v":100,"d":"$100.00"}},{"$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":{"v":100,"d":"$100.00"}},{"$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":{"v":-400,"d":"($400.00)"}},{"$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":{"v":20,"d":"$20.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":{"v":820,"d":"$820.00"}}]
[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":{"v":200,"d":"$200.00"}},{"$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":{"v":-200,"d":"($200.00)"}},{"$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":{"v":-200,"d":"($200.00)"}},{"$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":{"v":300,"d":"$300.00"}},{"$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":{"v":500,"d":"$500.00"}},{"$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":{"v":-300,"d":"($300.00)"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":5000,"d":"$5,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":5000,"d":"$5,000.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":{"v":18300,"d":"$18,300.00"}}]
[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":{"v":55,"d":"$55.00"}},{"$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":{"v":44,"d":"$44.00"}},{"$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":{"v":77,"d":"$77.00"}},{"$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":{"v":-23,"d":"($23.00)"}},{"$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":{"v":13,"d":"$13.00"}},{"$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":{"v":-45,"d":"($45.00)"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$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":{"v":200,"d":"$200.00"}},{"$f":"SUM(MarketingVariances[[#This Row],[Jan]:[Dec]])","v":{"v":1321,"d":"$1,321.00"}}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,MarketingVariances[Jan])","v":{"v":555,"d":"$555.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Feb])","v":{"v":-456,"d":"($456.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[Mar])","v":{"v":-23,"d":"($23.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[Apr])","v":{"v":-123,"d":"($123.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[May])","v":{"v":113,"d":"$113.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Jun])","v":{"v":-825,"d":"($825.00)"}},{"$f":"SUBTOTAL(109,MarketingVariances[Jul])","v":{"v":8100,"d":"$8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Aug])","v":{"v":6100,"d":"$6,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Sep])","v":{"v":3100,"d":"$3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Oct])","v":{"v":8100,"d":"$8,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Nov])","v":{"v":3100,"d":"$3,100.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[Dec])","v":{"v":6900,"d":"$6,900.00"}},{"$f":"SUBTOTAL(109,MarketingVariances[YEAR])","v":{"v":34641,"d":"$34,641.00"}}]
[]
["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":{"v":400,"d":"$400.00"}},{"$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":{"v":-400,"d":"($400.00)"}},{"$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":{"v":600,"d":"$600.00"}},{"$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":{"v":400,"d":"$400.00"}},{"$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":{"v":800,"d":"$800.00"}},{"$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":{"v":-800,"d":"($800.00)"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Jan]:[Dec]])","v":{"v":13000,"d":"$13,000.00"}}]
[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":{"v":800,"d":"$800.00"}},{"$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":{"v":-200,"d":"($200.00)"}},{"$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":{"v":600,"d":"$600.00"}},{"$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":{"v":800,"d":"$800.00"}},{"$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":{"v":1200,"d":"$1,200.00"}},{"$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":{"v":-1500,"d":"($1,500.00)"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$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":{"v":2000,"d":"$2,000.00"}},{"$f":"SUM(TrainingAndTravelVariances[[#This Row],[Jan]:[Dec]])","v":{"v":13700,"d":"$13,700.00"}}]
[null,"Subtotal",{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Jan])","v":{"v":1200,"d":"$1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Feb])","v":{"v":-600,"d":"($600.00)"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Mar])","v":{"v":1200,"d":"$1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Apr])","v":{"v":1200,"d":"$1,200.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[May])","v":{"v":2000,"d":"$2,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Jun])","v":{"v":-2300,"d":"($2,300.00)"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Jul])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Aug])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Sep])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Oct])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Nov])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[Dec])","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUBTOTAL(109,TrainingAndTravelVariances[YEAR])","v":{"v":26700,"d":"$26,700.00"}}]
[]
["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":{"v":1738,"d":"$1,738.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Feb]]+MarketingVariances[[#Totals],[Feb]]+OfficeVariances[[#Totals],[Feb]]+EmployeeVariances[[#Totals],[Feb]]","v":{"v":-984,"d":"($984.00)"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Mar]]+MarketingVariances[[#Totals],[Mar]]+OfficeVariances[[#Totals],[Mar]]+EmployeeVariances[[#Totals],[Mar]]","v":{"v":1255,"d":"$1,255.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Apr]]+MarketingVariances[[#Totals],[Apr]]+OfficeVariances[[#Totals],[Apr]]+EmployeeVariances[[#Totals],[Apr]]","v":{"v":301,"d":"$301.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[May]]+MarketingVariances[[#Totals],[May]]+OfficeVariances[[#Totals],[May]]+EmployeeVariances[[#Totals],[May]]","v":{"v":1440,"d":"$1,440.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Jun]]+MarketingVariances[[#Totals],[Jun]]+OfficeVariances[[#Totals],[Jun]]+EmployeeVariances[[#Totals],[Jun]]","v":{"v":-3744,"d":"($3,744.00)"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Jul]]+MarketingVariances[[#Totals],[Jul]]+OfficeVariances[[#Totals],[Jul]]+EmployeeVariances[[#Totals],[Jul]]","v":{"v":134695,"d":"$134,695.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Aug]]+MarketingVariances[[#Totals],[Aug]]+OfficeVariances[[#Totals],[Aug]]+EmployeeVariances[[#Totals],[Aug]]","v":{"v":138918,"d":"$138,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Sep]]+MarketingVariances[[#Totals],[Sep]]+OfficeVariances[[#Totals],[Sep]]+EmployeeVariances[[#Totals],[Sep]]","v":{"v":135918,"d":"$135,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Oct]]+MarketingVariances[[#Totals],[Oct]]+OfficeVariances[[#Totals],[Oct]]+EmployeeVariances[[#Totals],[Oct]]","v":{"v":140918,"d":"$140,918.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Nov]]+MarketingVariances[[#Totals],[Nov]]+OfficeVariances[[#Totals],[Nov]]+EmployeeVariances[[#Totals],[Nov]]","v":{"v":136218,"d":"$136,218.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[Dec]]+MarketingVariances[[#Totals],[Dec]]+OfficeVariances[[#Totals],[Dec]]+EmployeeVariances[[#Totals],[Dec]]","v":{"v":140018,"d":"$140,018.00"}},{"$f":"TrainingAndTravelVariances[[#Totals],[YEAR]]+MarketingVariances[[#Totals],[YEAR]]+OfficeVariances[[#Totals],[YEAR]]+EmployeeVariances[[#Totals],[YEAR]]","v":{"v":826691,"d":"$826,691.00"}}]
[null,"TOTAL Actual Expenses",{"$f":"SUM($C$36:C36)","v":{"v":1738,"d":"$1,738.00"}},{"$f":"SUM($C$36:D36)","v":{"v":754,"d":"$754.00"}},{"$f":"SUM($C$36:E36)","v":{"v":2009,"d":"$2,009.00"}},{"$f":"SUM($C$36:F36)","v":{"v":2310,"d":"$2,310.00"}},{"$f":"SUM($C$36:G36)","v":{"v":3750,"d":"$3,750.00"}},{"$f":"SUM($C$36:H36)","v":{"v":6,"d":"$6.00"}},{"$f":"SUM($C$36:I36)","v":{"v":134701,"d":"$134,701.00"}},{"$f":"SUM($C$36:J36)","v":{"v":273619,"d":"$273,619.00"}},{"$f":"SUM($C$36:K36)","v":{"v":409537,"d":"$409,537.00"}},{"$f":"SUM($C$36:L36)","v":{"v":550455,"d":"$550,455.00"}},{"$f":"SUM($C$36:M36)","v":{"v":686673,"d":"$686,673.00"}},{"$f":"SUM($C$36:N36)","v":{"v":826691,"d":"$826,691.00"}}]

{"sheet":"EXPENSE ANALYSIS","index":4,"n_rows":14,"n_cols":16,"rows_kept":14,"merged":[[1,1,2,3],[1,5,1,6],[2,4,2,6],[11,1,11,5],[13,1,36,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. ",{"$nulls":5}," ",{"$nulls":8}," "]
["Company Name is auto updated in cell at right. Enter Logo in cell F2.",{"$f":"'PLANNED EXPENSES'!B2:D3","v":"Company Name"},{"$nulls":3},"Logo placeholder is in this cell."]
["Title of this worksheet is in cell E3. Next instruction is in cell A5.",{"$nulls":3},{"$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":{"v":1355090,"d":"$1,355,090.00"}},{"$f":"EmployeeActual[[#Totals],[YEAR]]","v":{"v":659130,"d":"$659,130.00"}},{"$f":"C6-D6","v":{"v":695960,"d":"$695,960.00"}},{"$f":"E6/C6","v":{"v":0.5135895032802249,"d":"51%"}}]
[null,{"$f":"'PLANNED EXPENSES'!B10","v":"Office Costs"},{"$f":"OfficePlan[[#Totals],[YEAR]]","v":{"v":138740,"d":"$138,740.00"}},{"$f":"OfficeActual[[#Totals],[YEAR]]","v":{"v":69350,"d":"$69,350.00"}},{"$f":"C7-D7","v":{"v":69390,"d":"$69,390.00"}},{"$f":"E7/C7","v":{"v":0.5001441545336601,"d":"50%"}}]
[null,{"$f":"'PLANNED EXPENSES'!B21","v":"Marketing Costs"},{"$f":"MarketingPlan[[#Totals],[YEAR]]","v":{"v":67800,"d":"$67,800.00"}},{"$f":"MarketingActual[[#Totals],[YEAR]]","v":{"v":33159,"d":"$33,159.00"}},{"$f":"C8-D8","v":{"v":34641,"d":"$34,641.00"}},{"$f":"E8/C8","v":{"v":0.510929203539823,"d":"51%"}}]
[null,{"$f":"'PLANNED EXPENSES'!B30","v":"Training/Travel"},{"$f":"TrainingAndTravelPlan[[#Totals],[YEAR]]","v":{"v":48000,"d":"$48,000.00"}},{"$f":"TrainingAndTravelActual[[#Totals],[YEAR]]","v":{"v":21300,"d":"$21,300.00"}},{"$f":"C9-D9","v":{"v":26700,"d":"$26,700.00"}},{"$f":"E9/C9","v":{"v":0.55625,"d":"56%"}}]
[null,{"$f":"'PLANNED EXPENSES'!B35","v":"TOTALS"},{"$f":"'PLANNED EXPENSES'!O36","v":{"v":1609630,"d":"$1,609,630.00"}},{"$f":"'ACTUAL EXPENSES'!O36","v":{"v":782939,"d":"$782,939.00"}},{"$f":"C10-D10","v":{"v":826691,"d":"$826,691.00"}},{"$f":"E10/C10","v":{"v":0.5135907009685455,"d":"51%"}}]
[]
["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."]