{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["2015 Reserve Cost Estimates","2015 Budget & Fee Analysis","2015 Budget","Notes - keep!","Instructions","Tables & References","RESERVE Cost Estimates","GENERAL FUND Estimates","Calculations","Costs by Unit 1270","Costs by Unit 1272","Costs by Unit 1274","Costs by Unit 1276","Costs by Unit 1278","Calculated Budget Report","Published Budget Report","Sheet1"],"not_rendered":{"charts":0,"images":9,"macros":0,"external_links":0,"defined_names":18,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2015 Reserve Cost Estimates","index":0,"n_rows":105,"n_cols":12,"rows_kept":105,"cut":false,"hidden":true,"merged":[]}
["Roofing",null,null,null,null,null,null,null,"2015 Est. Inflation Factor","2015 Material / Labor Cost Increases","Total 2015 Est. Cost Increase","Total 2015 Est. Cost"]
["every 20 or \n30 years","2009 Budget with Quotes","Total 2014 Est. Cost",null,null,null,null,null,0,0.02,{"$f":"SUM(I2:J2)","v":0.02}]
["8-Plex",{"$f":"47400","v":47400},58650.390711,null,null,null,null,null,null,null,null,{"$f":"(C3*(1+$K$2))","v":59823.39852522}]
[1272,{"$f":"23300","v":23300},28830.255349499999,null,null,null,null,null,null,null,null,{"$f":"(C4*(1+$K$2))","v":29406.860456490002}]
[1274,{"$f":"25675","v":25675},31768.961635125001,null,null,null,null,null,null,null,null,{"$f":"(C5*(1+$K$2))","v":32404.340867827501}]
[1276,{"$f":"(6.58*1825)*2","v":24017},29717.435310254998,null,null,null,null,null,null,null,null,{"$f":"(C6*(1+$K$2))","v":30311.784016460097}]
[]
[]
["Road Repair","2012 Actual Cost","2014 Estimate"]
["every 3 years",null,null,null,null,null,null,null,"Road Repair",null,null,"2015 Estimate"]
[null,2800,3529.5409177875003,null,null,null,null,null,null,null,null,{"$f":"(C11*(1+$K$2))","v":3600.1317361432502}]
[]
[]
[]
[]
["Painting"]
["every 5 years","2009 Actual Costs","2014 Estimate"]
[]
[null,null,null,null,null,null,null,null,"Painting",null,null,"2015 Estimate"]
["8-Plex",1848,2147.0636879999997,"note - there was an error in original 2013 estimate",null,null,null,null,null,null,null,{"$f":"(C20*(1+$K$2))","v":2190.0049617599998}]
[1272,{"$f":"2464/2","v":1232},1431.375792,"and it was based on 2009 actual instead of 2012 est.",null,null,null,null,null,null,null,{"$f":"(C21*(1+$K$2))","v":1460.0033078400002}]
[1274,{"$f":"2464/2","v":1232},1431.375792,null,null,null,null,null,null,null,null,{"$f":"(C22*(1+$K$2))","v":1460.0033078400002}]
[1276,{"$f":"2464/2","v":1232},1431.375792,null,null,null,null,null,null,null,null,{"$f":"(C23*(1+$K$2))","v":1460.0033078400002}]
[]
[]
["Deck Repair"]
["decks last approx. 20 years, but only approx. 10 years left","2014 Quote - Brandt (see Notes sheet)","2014 Estimate","note - a new deck repair reserve fund was "]
[null,null,null,"considered for 2013, but not implemented until 2014"]
[null,null,null,null,null,null,null,null,"Deck/Patio Replace/Repair",null,null,"2015 Estimate"]
["8-Plex",{"$f":"'Notes - keep!'!K12","v":4480},4480,null,null,null,null,null,null,null,null,{"$f":"(C30*(1+$K$2))","v":4569.6000000000004}]
[1272,{"$f":"'Notes - keep!'!K13","v":4915},4915,null,null,null,null,null,null,null,null,{"$f":"(C31*(1+$K$2))","v":5013.3}]
[1274,{"$f":"'Notes - keep!'!K14","v":3340},3340,null,null,null,null,null,null,null,null,{"$f":"(C32*(1+$K$2))","v":3406.8}]
[1276,{"$f":"'Notes - keep!'!K15","v":4200},4200,null,null,null,null,null,null,null,null,{"$f":"(C33*(1+$K$2))","v":4284}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Two charts below were copied 11/5/2011 for 2012 estimates:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Two charts below copied 10/27/12 for 2013 estimates",null,null,null,null,"! see below for 2014",null,"and 2015"]
[]
["U.S. Inflation Rate"]
["Past Trend Present Value & Future Projection"]
["YoY Change In CPI. Percent."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["</body>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Two charts below copied 10/13/13 for 2014 estimates",null,null,null,null,null,null,null,null,"Two charts below copied 11/17/14 for 2015 estimates"]
[]
["U.S. Inflation Rate",null,null,null,null,null,null,null,null,"U.S. Inflation Rate"]
["Past Trend Present Value & Future Projection",null,null,null,null,null,null,null,null,"Past Trend Present Value & Future Projection"]
["YoY Change In CPI. Percent.",null,null,null,null,null,null,null,null,"YoY Change In CPI. Percent"]

{"sheet":"2015 Budget & Fee Analysis","index":1,"n_rows":96,"n_cols":19,"rows_kept":96,"cut":false,"hidden":true,"merged":[[5,18,8,18],[77,18,80,18],[66,18,69,18],[5,15,8,15],[5,7,8,7],[5,8,8,8],[5,9,8,9],[5,10,8,10]]}
["Hilary Heights Condominium Owners' Association",null,null,null,null,null,null,null,null,"Revised 11/2014"]
["2015 Budget and Fee Analysis"]
["Prepared by: Deb Ryan, Mary Sands, Carol Jacobs, Jared Clemetsen, Charlie Mohr"]
["E X P E N S E S",null,null,null,null,null,null,"F E E    A N A L Y S I S"]
[]
[null,null,null,null,null,null,null,"1270 Monthly Total Per Unit","1272 Monthly Total Per Unit","1274 Monthly Total Per Unit","1276 Monthly Total Per Unit",null,null,null,null,"Reserve Fund Totals Per Type of Unit Thru",null,null,"Reserve Fund Totals for All Units Per Month Thru"]
["Roofing",30]
["Recurrence in Years",20]
["Address","No. Units","Cost","Cost / Unit","Cost / Unit / Year","Cost / Unit / Month",null,null,null,null,null,"Check: Total Annual Contribution Per Address"]
[1270,8,{"$f":"'2015 Reserve Cost Estimates'!L3","v":59823.39852522},{"$f":"C10/B10","v":7477.9248156525},{"$f":"D10/$B$8","v":373.896240782625},{"$f":"E10/12","v":31.15802006521875},null,{"$f":"F10","v":31.15802006521875},null,null,null,{"$f":"E10*B10","v":2991.169926261},"for 8 units",null,null,null,null,null,"2014-12-01"]
[1272,2,{"$f":"'2015 Reserve Cost Estimates'!L4","v":29406.860456490002},{"$f":"C11/B11","v":14703.430228245001},{"$f":"D11/$B$8","v":735.17151141225008},{"$f":"E11/12","v":61.264292617687509},null,null,{"$f":"F11","v":61.264292617687509},null,null,{"$f":"E11*B11","v":1470.3430228245002},"for 2 units"]
[1274,2,{"$f":"'2015 Reserve Cost Estimates'!L5","v":32404.340867827501},{"$f":"C12/B12","v":16202.17043391375},{"$f":"D12/$B$8","v":810.1085216956875},{"$f":"E12/12","v":67.50904347464062},null,null,null,{"$f":"F12","v":67.50904347464062},null,{"$f":"E12*B12","v":1620.217043391375},"for 2 units"]
[1276,2,{"$f":"'2015 Reserve Cost Estimates'!L6","v":30311.784016460097},{"$f":"C13/B13","v":15155.892008230048},{"$f":"D13/$B$7","v":505.19640027433496},{"$f":"E13/12","v":42.099700022861249},null,null,null,null,{"$f":"F13","v":42.099700022861249},{"$f":"E13*B13","v":1010.3928005486699},"for 2 units"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H10,I11,J12,K13)","v":202.03105618040811},{"$f":"P15/P41","v":0.65144279178191866},null,{"$f":"H10*8+I11*2+J12*2+K13*2","v":591.01023275212879}]
["Road Repair"]
["Recurrence in Years",3]
["Address","No. Units","Cost","Cost / Unit","Cost / Unit / Year","Cost / Unit / Month"]
["All Units",14,{"$f":"'2015 Reserve Cost Estimates'!L11","v":3600.1317361432502},{"$f":"C19/B19","v":257.15226686737503},{"$f":"D19/$B$17","v":85.717422289125011},{"$f":"E19/12","v":7.1431185240937509},null,{"$f":"F19","v":7.1431185240937509},{"$f":"F19","v":7.1431185240937509},{"$f":"F19","v":7.1431185240937509},{"$f":"F19","v":7.1431185240937509},{"$f":"E19*B19","v":1200.0439120477502},"for 14 units",null,null,{"$f":"SUM(H19:K19)","v":28.572474096375004},{"$f":"P19/P41","v":9.2131044827275951E-2},null,{"$f":"H19*8+I19*2+J19*2+K19*2","v":100.00365933731251}]
[]
["Painting"]
["Recurrence in Years",5]
["Address","No. Units","Cost","Cost / Unit","Cost / Unit / Year","Cost / Unit / Month"]
[1270,8,{"$f":"'2015 Reserve Cost Estimates'!L20","v":2190.0049617599998},{"$f":"C24/B24","v":273.75062021999997},{"$f":"D24/$B$22","v":54.750124043999996},{"$f":"E24/12","v":4.562510337},null,{"$f":"F24","v":4.562510337},null,null,null,{"$f":"E24*B24","v":438.00099235199997},"for 8 units"]
[1272,2,{"$f":"'2015 Reserve Cost Estimates'!L21","v":1460.0033078400002},{"$f":"C25/B25","v":730.00165392000008},{"$f":"D25/$B$22","v":146.00033078400003},{"$f":"E25/12","v":12.166694232000003},null,null,{"$f":"F25","v":12.166694232000003},null,null,{"$f":"E25*B25","v":292.00066156800006},"for 2 units"]
[1274,2,{"$f":"'2015 Reserve Cost Estimates'!L22","v":1460.0033078400002},{"$f":"C26/B26","v":730.00165392000008},{"$f":"D26/$B$22","v":146.00033078400003},{"$f":"E26/12","v":12.166694232000003},null,null,null,{"$f":"F26","v":12.166694232000003},null,{"$f":"E26*B26","v":292.00066156800006},"for 2 units"]
[1276,2,{"$f":"'2015 Reserve Cost Estimates'!L23","v":1460.0033078400002},{"$f":"C27/B27","v":730.00165392000008},{"$f":"D27/$B$22","v":146.00033078400003},{"$f":"E27/12","v":12.166694232000003},null,null,null,null,{"$f":"F27","v":12.166694232000003},{"$f":"E27*B27","v":292.00066156800006},"for 2 units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H24,I25,J26,K27)","v":41.062593033000013},{"$f":"P28/P41","v":0.13240504083360008},null,{"$f":"H24*8+I25*2+J26*2+K27*2","v":109.50024808800002}]
[]
["Deck Repair"]
["Recurrence in Years",15]
["Address","No. Units","Cost","Cost / Unit","Cost / Unit / Year","Cost / Unit / Month"]
[1270,8,{"$f":"'2015 Reserve Cost Estimates'!L30","v":4569.6000000000004},{"$f":"C33/B33","v":571.20000000000005},{"$f":"D33/$B$31","v":38.080000000000005},{"$f":"E33/12","v":3.1733333333333338},null,{"$f":"F33","v":3.1733333333333338},null,null,null,{"$f":"E33*B33","v":304.64000000000004},"for 8 units"]
[1272,2,{"$f":"'2015 Reserve Cost Estimates'!L31","v":5013.3},{"$f":"C34/B34","v":2506.65},{"$f":"D34/$B$31","v":167.11},{"$f":"E34/12","v":13.925833333333335},null,null,{"$f":"F34","v":13.925833333333335},null,null,{"$f":"E34*B34","v":334.22},"for 2 units"]
[1274,2,{"$f":"'2015 Reserve Cost Estimates'!L32","v":3406.8},{"$f":"C35/B35","v":1703.4},{"$f":"D35/$B$31","v":113.56},{"$f":"E35/12","v":9.4633333333333329},null,null,null,{"$f":"F35","v":9.4633333333333329},null,{"$f":"E35*B35","v":227.12},"for 2 units"]
[1276,2,{"$f":"'2015 Reserve Cost Estimates'!L33","v":4284},{"$f":"C36/B36","v":2142},{"$f":"D36/$B$31","v":142.80000000000001},{"$f":"E36/12","v":11.9},null,null,null,null,{"$f":"F36","v":11.9},{"$f":"E36*B36","v":285.60000000000002},"for 2 units"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L19:L36)","v":3665.6268891037494},null,null,null,{"$f":"SUM(H33,I34,J35,K36)","v":38.462499999999999},{"$f":"P37/P41","v":0.1240211225572054},null,{"$f":"H33*8+I34*2+J35*2+K36*2","v":95.965000000000003}]
[]
[]
[]
[null,null,null,null,null,null,"Total Reserve Fund Rounded Up To Nearest Whole Dollar",{"$f":"ROUNDUP(SUM(H10,H19,H24,H33),0)","v":47},{"$f":"ROUNDUP(SUM(I11,I19,I25,I34),0)","v":95},{"$f":"ROUNDUP(SUM(J12,J19,J26,J35),0)","v":97},{"$f":"ROUNDUP(SUM(K13,K19,K27,K36),0)","v":74},{"$f":"(SUM(H41*8)+SUM(I41:K41)*2)*12","v":10896},"Total Reserve Annual",null,null,{"$f":"SUM(P15,P19,P28,P37)","v":310.12862330978311},{"$f":"SUM(Q15,Q19,Q28,Q37)","v":1},null,{"$f":"SUM(S15,S19,S28,S37)","v":896.47914017744131}]
[null,null,null,null,null,null,null,null,null,null,null,null,"  after Rounding Applied"]
[]
[]
["General Operating Fund, ALL Addresses (Annual)"]
["Recurrence in Years",1]
["Expense",null,"2014 Annual Cost","2015 Annual Cost?"]
["Administration Fee",null,10,10]
["Building Maintenance",null,2000,2000,"*increased in 2013 due to lack of additional reserve fund, decreased in 2014 due to new deck maintenance reserve fund"]
["Dues and Subscriptions",null,114,114]
["Electric House Meter",null,125,125]
["Electric House Meter 2",null,220,220]
["Electric House Meter 3",null,null,null,"*there is no third meter"]
["Grounds Improvement",null,300,300]
["Landscaping Repayment",null,600,600]
["Insurances",null,3000,3300]
["Lawn Care",null,3500,3500]
["Legal-Professional Fees",null,500,500]
["Snow Removal",null,3000,3100]
["Internet",null,420,420]
["Supplies",null,200,200,null,null,null,null,null,null,null,"Check: Total Annual Contribution Per Address"]
["Water and Hydrant Systm",null,280,280,null,null,null,null,null,null,null,{"$f":"D65","v":14669},"Total Gen Fund Annual"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L41+L62)","v":25565},"Total Gen Fund plus Reserve (before rounding up)"]
["Total General Fund Costs",null,{"$f":"SUM(C48:C62)","v":14269},{"$f":"SUM(D48:D62)","v":14669}]
[]
["Address","No. of Units","General Operating Fund","Cost / Unit","Cost / Unit / Year","Cost / Unit / Month",null,null,null,null,null,null,null,null,null,null,null,null,"General Fund Totals Per Month Thru"]
["All Units",14,{"$f":"D65","v":14669},{"$f":"C68/B68","v":1047.7857142857142},{"$f":"D68/B46","v":1047.7857142857142},{"$f":"E68/12","v":87.31547619047619},null,{"$f":"F68","v":87.31547619047619},{"$f":"F68","v":87.31547619047619},{"$f":"F68","v":87.31547619047619},{"$f":"F68","v":87.31547619047619}]
[]
[null,null,null,null,null,null,"Monthly Totals (General Operating + Reserves) For Annual Budget",{"$f":"SUM(H68,H33,H24,H19,H10)","v":133.35245845012201},{"$f":"SUM(I68,I34,I25,I19,I11)","v":181.81541489759078},{"$f":"SUM(J68,J35,J26,J19,J12)","v":183.5976657545439},{"$f":"SUM(K68,K36,K27,K19,K13)","v":160.6249889694312}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S10","v":"2014-12-01"}]
[null,null,null,null,null,null,"General Operating Fund Rounded Up To Nearest Whole Dollar",{"$f":"ROUNDUP(H68,0)","v":88},{"$f":"ROUNDUP(I68,0)","v":88},{"$f":"ROUNDUP(J68,0)","v":88},{"$f":"ROUNDUP(K68,0)","v":88},null,null,null,null,null,null,null,{"$f":"H72*8+I72*2+J72*2+K72*2","v":1232}]
[]
[]
[null,null,null,null,null,null,"Address","1270","1272","1274","1276"]
[null,null,null,null,null,null,"2015 Total Monthly Fee Distribution Per Unit (using rounded)",{"$f":"SUM(H41,H72)","v":135},{"$f":"SUM(I41,I72)","v":183},{"$f":"SUM(J41,J72)","v":185},{"$f":"SUM(K41,K72)","v":162}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BANK DEPOSITS SCHEDULE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fund Distribution from Fees Per Month thru"]
[null,null,null,null,null,null,"Total Monthly Fee Distribution Break-Down:"]
[null,null,null,null,null,null,"Reserve Fund",{"$f":"H41","v":47},{"$f":"I41","v":95},{"$f":"J41","v":97},{"$f":"K41","v":74}]
[null,null,null,null,null,null,"General Fund",{"$f":"H72","v":88},{"$f":"I72","v":88},{"$f":"J72","v":88},{"$f":"K72","v":88}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S71","v":"2014-12-01"}]
[null,null,null,null,null,null,"Total Monthly General Fund Contribution base on analysis",{"$f":"H81*14","v":1232},{"$f":"H83/(H83+H84)","v":0.57570093457943927},null,null,null,null,null,null,null,null,"General Fund",{"$f":"S72","v":1232}]
[null,null,null,null,null,null,"Total Monthly Reserve Fund Contribution base on analysis",{"$f":"H80*8+I80*2+J80*2+K80*2","v":908},{"$f":"H84/(H83+H84)","v":0.42429906542056073},null,null,null,null,null,null,null,null,"Roofing Fund",{"$f":"S15","v":591.01023275212879}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Road Repair",{"$f":"S19","v":100.00365933731251}]
[null,null,null,null,null,null,"2012 Prior Year Fee",120,155,160,137,null,null,null,null,null,null,"Painting",{"$f":"S28","v":109.50024808800002}]
[null,null,null,null,null,null,"2013 Prior Year Fee",129,165,171,147,null,null,null,null,null,null,"Deck Repair",{"$f":"S37","v":95.965000000000003}]
[null,null,null,null,null,null,"2014 Fee Analysis",131,178,180,157,null,null,null,null,null,null,"Total",{"$f":"SUM(S83:S87)","v":2128.4791401774414}]
[null,null,null,null,null,null,"2015 Fee Analysis",{"$f":"H76","v":135},{"$f":"I76","v":183},{"$f":"J76","v":185},{"$f":"K76","v":162}]
[null,null,null,null,null,null,"% Change",{"$f":"(H89-H88)/H88","v":3.0534351145038167E-2},{"$f":"(I89-I88)/I88","v":2.8089887640449437E-2},{"$f":"(J89-J88)/J88","v":2.7777777777777776E-2},{"$f":"(K89-K88)/K88","v":3.1847133757961783E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounding (Surplus)",{"$f":"S92-S88","v":11.520859822558577}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check (Fees Totals)",{"$f":"H89*8+I89*2+J89*2+K89*2","v":2140}]
[]
[null,null,null,null,null,"Board Assigned General Fund Contribution",null,{"$f":"SUM((H76*8)*I83)+(I76*2*I83)+(J76*2*I83)+(K76*2*I83)","v":1232},{"$f":"H94/H96","v":0.58286597584420607},null,null,null,null,null,null,null,null,"Check (Per Month totals)",{"$f":"S72+S41","v":2128.4791401774414}]
[null,null,null,null,null,"Board Assigned Reserve Fund Contribution",null,{"$f":"(H88*8*I84)+(I88*2*I84)+(J88*2*I84)+(K88*2*I84)","v":881.69345794392507},{"$f":"H95/H96","v":0.41713402415579409}]
[null,null,null,null,null,"Total",null,{"$f":"SUM(H94:H95)","v":2113.6934579439248}]

{"sheet":"2015 Budget","index":2,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":true,"merged":[[0,1,1,3]]}
[null,"Hilary Heights Condominium Owners' Association \n2015 Operating Budget                                                                        "]
[]
[null,"Category / Account","Annual Budget Average per Month","Yearly Total"]
[null,"Business Income",null,""]
[null,"Business Income - Other",0,0]
[null,"Account Adjustment Credit",0,0]
[null,"Association Dues"]
[null,"1270 - 8 units total",{"$f":"(('2015 Budget & Fee Analysis'!H76)*8)","v":1080},{"$f":"C8*12","v":12960}]
[null,"1272 - 2 units total",{"$f":"('2015 Budget & Fee Analysis'!I76)*2","v":366},{"$f":"C9*12","v":4392}]
[null,"1274 - 2 units total",{"$f":"('2015 Budget & Fee Analysis'!J76)*2","v":370},{"$f":"C10*12","v":4440}]
[null,"1276 - 2 units total",{"$f":"('2015 Budget & Fee Analysis'!K76)*2","v":324},{"$f":"C11*12","v":3888}]
[null,"Other Income",null,""]
[null,"Income - Other",{"$f":"D13/12","v":0},0]
[null,"Interest Income",{"$f":"D14/12","v":0},0]
[null,"All Income Sub-Total",{"$f":"SUM(C5:C14)","v":2140},{"$f":"SUM(D5:D14)","v":25680},"<- this is after rounding up "]
[null,"Business Expenses",null,""]
[null,"Business Expenses - Other",{"$f":"D17/12","v":0},0]
[null,"Account Adjustment Debit",0,0]
[null,"Administration Fee (Federal Filing Fee)",{"$f":"D19/12","v":0.83333333333333337},{"$f":"'2015 Budget & Fee Analysis'!D48","v":10}]
[null,"Dues and Subscriptions (CAI)",{"$f":"D20/12","v":9.5},{"$f":"'2015 Budget & Fee Analysis'!D50","v":114}]
[null,"Insurances",{"$f":"D21/12","v":275},{"$f":"'2015 Budget & Fee Analysis'!D56","v":3300}]
[null,"Legal - Professional Fees",{"$f":"D22/12","v":41.666666666666664},{"$f":"'2015 Budget & Fee Analysis'!D58","v":500}]
[null,"Supplies, Business",{"$f":"D23/12","v":16.666666666666668},{"$f":"'2015 Budget & Fee Analysis'!D61","v":200}]
[null,"Business Expenses Sub-Total",{"$f":"SUM(C17:C23)","v":343.66666666666669},{"$f":"SUM(D17:D23)","v":4124}]
[null,"Discretionary",null,""]
[null,"Discretionary - Other",{"$f":"D26/12","v":0},0]
[null,"Building Maintenance",166.66666666666666,{"$f":"'2015 Budget & Fee Analysis'!D49","v":2000}]
[null,"Grounds Improvement",25,{"$f":"SUM('2015 Budget & Fee Analysis'!D54)","v":300}]
[null,"Lawn Care",291.66666666666669,{"$f":"'2015 Budget & Fee Analysis'!D57","v":3500}]
[null,"Landscaping Repayment",50,{"$f":"'2015 Budget & Fee Analysis'!D55","v":600}]
[null,"Internet",35,{"$f":"'2015 Budget & Fee Analysis'!D60","v":420}]
[null,"Misc",0,0]
[null,"Snow Removal",258.33333333333331,{"$f":"'2015 Budget & Fee Analysis'!D59","v":3100}]
[null,"Discretionary Sub-Total",826.66666666666663,{"$f":"SUM(D26:D33)","v":9920}]
[null,"Mandatory Expenses",null,""]
[null,"Mandatory Expenses - Other",{"$f":"D36/12","v":0},0]
[null,"Bank Charge",{"$f":"D37/12","v":0},0]
[null,"Electric House Meters",{"$f":"D38/12","v":28.75},{"$f":"SUM('2015 Budget & Fee Analysis'!D51:D53)","v":345}]
[null,"Water and Sewer (1270 8-Plex Outdoor Faucets)",{"$f":"D39/12","v":23.333333333333332},{"$f":"'2015 Budget & Fee Analysis'!D62","v":280}]
[null,"Mandatory Expenses Sub-Total",{"$f":"D40/12","v":52.083333333333336},{"$f":"SUM(D36:D39)","v":625}]
[]
[null,"Total Expenses - General Fund",{"$f":"C40+C34+C24","v":1222.4166666666667},{"$f":"D40+D34+D24","v":14669},null,{"$f":"'2015 Budget & Fee Analysis'!$L$62","v":14669},"<- Check total for General Operating Fund from prior page"]
[null,null,null,null,null,{"$f":"$C$42*12","v":14669},"<- Check total General monthly * 12 should equal yearly"]
[null,"Reserve ROOFING Accrual",{"$f":"'2015 Budget & Fee Analysis'!S15","v":591.01023275212879}]
[null,"Reserve ROAD REPAIR Accrual",{"$f":"'2015 Budget & Fee Analysis'!S19","v":100.00365933731251}]
[null,"Reserve PAINTING Accrual",{"$f":"'2015 Budget & Fee Analysis'!S28","v":109.50024808800002}]
[null,"Reserve DECK REPAIR Accrual",{"$f":"'2015 Budget & Fee Analysis'!S37","v":95.965000000000003}]
[null,"Reserve Surplus Accrual",0]
[null,"Total Reserve Bank Account Deposit (Rounded up to nearest whole dollar)",{"$f":"ROUNDUP(SUM(C44:C48),0)","v":897},{"$f":"C49*12","v":10764}]
[]
[null,"Total Inflows (Income)",{"$f":"C15","v":2140},{"$f":"D15","v":25680}]
[null,"Total Outflows (Expenses+Reserve Deposit)",{"$f":"SUM(C40,C34,C24,C49)","v":2119.416666666667},{"$f":"SUM(D24,D34,D40,D49)","v":25433}]
[null,"Adjustment for Round-Up and Averaging",{"$f":"C51-C52","v":20.58333333333303},{"$f":"D51-D52","v":247}]
[null,"Difference (Must Equal Zero to Balance)",{"$f":"C51-(C52+C53)","v":0},{"$f":"D51-(D52+D53)","v":0}]

{"sheet":"Notes - keep!","index":3,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,"2013 Notes:"]
[]
[1,"Should road repair be based off of 2012 estimate or off of actual?"]
[2,"1276 dues are $20 less per month due to their roof set at 30 years - is this accurate with tree overhang?"]
[]
[]
[null,"2014 Notes:"]
[1,"The 2014 budget formulas were adjusted to bring in the correct painting reserve accrual.   "]
[2,"The new deck repair reserve fund was based on the following estimates:"]
[]
[null,null,"# Posts","Post Total Estimate","# 14 foot Deck Boards","# 16 foot Deck Boards","Deck Board Estimate","# 8 foot Handrails","# 12 foot Handrails","Hand Rail Estimate","Building Total Estimate"]
[null,1270,{"$f":"3*4","v":12},{"$f":"C12*$B$20","v":600},{"$f":"13*4","v":52},0,{"$f":"(E12*$B$21)+(F12*$B$22)","v":2600},4,4,{"$f":"(H12*$B$23)+(I12*$B$24)","v":1280},{"$f":"D12+G12+J12","v":4480},"Note - Budget uses these numbers as base"]
[null,1272,19,{"$f":"C13*$B$20","v":950},37,13,{"$f":"(E13*$B$21)+(F13*$B$22)","v":2565},10,0,{"$f":"(H13*$B$23)+(I13*$B$24)","v":1400},{"$f":"D13+G13+J13","v":4915},null,"do not delete!"]
[null,1274,{"$f":"4*2","v":8},{"$f":"C14*$B$20","v":400},42,0,{"$f":"(E14*$B$21)+(F14*$B$22)","v":2100},{"$f":"3*2","v":6},0,{"$f":"(H14*$B$23)+(I14*$B$24)","v":840},{"$f":"D14+G14+J14","v":3340}]
[null,1276,0,{"$f":"C15*$B$20","v":0},{"$f":"21+21+21+21","v":84},0,{"$f":"(E15*$B$21)+(F15*$B$22)","v":4200},0,0,{"$f":"(H15*$B$23)+(I15*$B$24)","v":0},{"$f":"D15+G15+J15","v":4200}]
[]
[]
[null,"Estimates for replacement of deck elements (includes labor) "]
[null,"from Brandt Construction in August 2013"]
[null,50,"4x4 post "]
[null,50,"14 foot deck board"]
[null,55,"16 foot deck board"]
[null,140,"8 foot handrail (assumes spindles and footboard - replaced as a unit)"]
[null,180,"12 foot handrail (assumes spindles and footboard - replaced as a unit)"]
[]
[null,"note:  1276 has metal handrails and posts"]
[null,"note:  1272 does not include ground level deck added on after construction"]

{"sheet":"Instructions","index":4,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[[20,1,20,10],[24,1,24,10],[26,1,26,10],[28,1,28,10],[5,1,5,10],[17,2,17,10],[19,1,19,10]]}
[null,"Hilary Heights Condominium Owners' Association"]
[null,"Annual Operating Budget"]
[]
[null,"Notes and Instructions for completing"]
[]
[null,"This Excel Workbook was a complete re-design of the workbook used for the 2015 year budget.  It was however generated from the 2015 budget year workbook.  Those worksheets for the 2015 budget are preserved in this new workbook; they are hidden at the front end of this new workbook and can be referenced or viewed by using the unhide command.  All the worksheets in this new budget workbook are PROTECTED without a password.  Only the YELLOW UNLOCKED data INPUT cells can be selected.  The author of this workbook is Richard Rooker (920-207-4471)."]
[]
[null,"Cell Color Legend:"]
[]
[null,"Sampe","Reference Information"]
[]
[null,"Sample","Date Input cells.  These are the only unlocked cells"]
[]
[null,"Sample","Calculated"]
[]
[null,"Sample","Calculated"]
[]
[null,"Sample","These are considered fixed input data, changeable by the Board of Directors at any time."]
[]
[1,"Before Inputing any data for the NEW budget year (labeled \"Current Budget Year\"), be sure to print out a PDF record of the \"Budget Report\" if you haven't done so already."]
[null,"If you wish to keep a copy of this complete workbook for a particular budget year, then create and save that copy for the record before inputing any data for the new (\"Current\") budget year."]
[]
[2,"Fill in the Input information on the \"Tables & References\" worksheet."]
[]
[3,"Fill in the INPUT (YELLOW Cells) information on the \"RESERVE Cost Estimates\" worksheet.  If you do NOT have actual quotes for the specific cost item, the worksheet will calculate an estimate for you using the previous year's estimate and the inflation and construction cost factors.  If you DO have a quote for the specific cost item, enter it into the appropriate cell.  A quoted cost will always take precedent over an estimated cost in the calculations."]
[]
[4,"Fill in the INPUT (YELLOW cells) information on the \"GENERAL FUND Estimates\" worksheet.  As you will most likely be putting together the new budget prior to the end of the past year, it will be necessary to make a combination of either extrapolated values from your Quicken cost reports and/or your best guesses."]
[]
[5,"The \"Calculations\" worksheet will automatically make all the necessary calculations to generate the \"Budget Report\", including the new current year Unit Dues."]

{"sheet":"Tables & References","index":5,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,1,38,2],[1,6,1,7],[2,1,2,2],[7,1,7,3],[17,1,17,2],[30,1,30,2]]}
[]
[null,null,null,null,null,null,"General Fund Expenses",null,null,"Reserve Funds"]
[null,"BUDGET YEAR",null,null,null,null,"Category","Type",null,"Roofing Accrual"]
[null,"Current (New) Budget Year",2019,null,null,null,"Dues and Subscriptions","Business",null,"Road Maintenance Accrual"]
[null,"Previous Budget Year",{"$f":"IF(C4=\"\",\"\",C4-1)","v":2018},null,null,null,null,null,null,"Painting/Power Washing Accrual"]
[null,null,null,null,null,null,"Supplies, Business","Business",null,"General Building Maintenance Accrual"]
[null,null,null,null,null,null,"Bank Charge","Business",null,"Insurance Accrual"]
[null,"UNIT INFORMATION",null,null,null,null,"Business, Other","Business",null,"Legal-Profession Fees Accrual"]
[null,"Unit #","No. Units","Year Built",null,null,"Grounds Improvement","Business"]
[null,null,null,null,null,null,"Landscaping Repayment","Discretionary",null,"General Fund Expense Types"]
[null,1270,8,2000,null,null,"Lawn Care","Discretionary",null,"Business"]
[null,1272,2,2001,null,null,"Snow Removal","Discretionary",null,"Discretionary"]
[null,1274,2,2003,null,null,"Wireless Internet","Discretionary",null,"Mandatory"]
[null,1276,2,2010,null,null,"Discretionary, Other","Discretionary",null,"Other"]
[null,1278,2,2016,null,null,"Electric House Meter 1","Discretionary"]
[null,null,null,null,null,null,"Electric House Meter 2","Mandatory"]
[null,null,null,null,null,null,"Water and Sewer","Mandatory"]
[null,"RESERVE COST FREQUENCIES IN YEARS",null,null,null,null,"Mandatory, Other","Mandatory"]
[]
[null,"Roof Replacement 1270, 1272, 1274",20]
[null,"Roof Replacement 1276",30]
[null,"Roof Replacement 1278",30]
[]
[null,"Road Repair and Sealing",3]
[null,"Painting",6,"Changed from 5 for 2019"]
[null,"General Maintenance",1]
[null,"Insurance",1]
[null,"Legal Fees",1]
[]
[]
[null,"CONSTRUCTION COSTS"]
[null,"Material & Labor Cost Increase for this budget",0.04]
[]
[]
[]
[]
[]
[]
[null,"INFLATION RATE"]
[null,"Inflation Rate used for this budget",2.9000000000000001E-2]

{"sheet":"RESERVE Cost Estimates","index":6,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,4,3,5],[3,6,5,6],[3,7,5,7],[2,3,2,7]]}
[]
[]
[null,null,null,"HHCOA Estimated Reserve Costs"]
[null,null,null,"Previous Budget Year","Current Budget Year",null,"Precedent Value: An actual Quote value will override any Estimate value.  It is this value that will be used in the calculations","Cost Per Year"]
[null,null,null,{"$f":"previous_budget_year","v":2018},{"$f":"current_budget_year","v":2019},{"$f":"current_budget_year","v":2019}]
[null,null,null,"Estimate","Calculated Estimate","From Quote or New Estimate"]
[null,{"$f":"'Tables & References'!J3","v":"Roofing Accrual"}]
[null,1270,null,54907.678,{"$f":"IF(D8=\"\",\"\",D8+(D8*(inflation_rate+construction_cost_increase)))","v":58696.307782000003},{"$f":"AVERAGE(D8:E8)","v":56801.992891000002},{"$f":"IF(AND(E8=\"\",F8=\"\"),\"\",IF(F8=\"\",E8,F8))","v":56801.992891000002},{"$f":"G8/roofing_recurrence_A","v":2840.09964455},"Latest Quote is from 2016"]
[null,1272,null,27413.567999999999,29305.104191999999,{"$f":"AVERAGE(D9:E9)","v":28359.336095999999},{"$f":"IF(AND(E9=\"\",F9=\"\"),\"\",IF(F9=\"\",E9,F9))","v":28359.336095999999},{"$f":"G9/roofing_recurrence_A","v":1417.9668047999999}]
[null,1274,null,29600,31642.400000000001,30621.200000000001,30621.200000000001,{"$f":"G10/roofing_recurrence_A","v":1531.06}]
[null,1276,null,26150,27954.35,27052.174999999999,27052.174999999999,{"$f":"G11/roofing_recurrence_B","v":901.73916666666662}]
[null,"1278*",null,26150,27954.35,27052.174999999999,27052.174999999999,{"$f":"G12/roofing_recurrence_B","v":901.73916666666662}]
[null,null,null,"","",null,""]
[null,"*Estimated for 2018",null,"","",null,""]
[null,null,null,null,null,null,null,{"$f":"SUM(H8:H14)","v":7592.6047826833328}]
[null,{"$f":"'Tables & References'!J4","v":"Road Maintenance Accrual"}]
[null,"All Units",null,6000,{"$f":"IF(D17=\"\",\"\",D17+(D17*(inflation_rate+construction_cost_increase)))","v":6414},null,6414,{"$f":"G17/road_recurrence","v":2138},"2016 $2,940 for crack sealing plus $3,600 quoted sealing for this year"]
[]
[null,{"$f":"'Tables & References'!J5","v":"Painting/Power Washing Accrual"}]
[null,1270,null,0,{"$f":"IF(D20=\"\",\"\",D20+(D20*(inflation_rate+construction_cost_increase)))","v":0},2615,2615,{"$f":"G20/painting_recurrence","v":435.83333333333331},"1270 was painted in 2017 need to renew accrual for 2019"]
[null,1272,null,1700,1817.3,null,1817.3,302.88333333333333]
[null,1274,null,1000,1069,null,1069,178.16666666666666]
[null,1276,null,800,855.2,null,855.2,142.53333333333333]
[null,1278,null,600,641.4,null,641.4,106.89999999999999]
[null,null,null,"","",null,""]
[null,null,null,null,null,null,null,{"$f":"SUM(H20:H25)","v":1166.3166666666668}]
[null,{"$f":"'Tables & References'!J6","v":"General Building Maintenance Accrual"}]
[null,1270,null,2000,{"$f":"IF(D28=\"\",\"\",D28+(D28*(inflation_rate+construction_cost_increase)))","v":2138},null,2138,{"$f":"G28/maintenance_recurrence","v":2138}]
[null,1272,null,750,801.75,null,801.75,801.75]
[null,1274,null,750,801.75,null,801.75,801.75]
[null,1276,null,750,801.75,null,801.75,801.75]
[null,1278,null,200,213.8,null,213.8,213.8,"This was budgeted at 200 last year because it was brand new.  There is 6 years difference between the age of 1276 and 1278.  I think we should bump this number up $100 each year until it reaches the same number as 1276."]
[null,null,null,"","",null,""]
[null,null,null,null,null,null,null,{"$f":"SUM(H28:H33)","v":4757.05}]
[null,{"$f":"'Tables & References'!J7","v":"Insurance Accrual"}]
[null,"All Units",null,6500,{"$f":"IF(D36=\"\",\"\",D36+(D36*(inflation_rate+construction_cost_increase)))","v":6948.5},5800,{"$f":"IF(AND(E36=\"\",F36=\"\"),\"\",IF(F36=\"\",E36,F36))","v":5800},{"$f":"G36","v":5800},"Insurance is at the rate including 1280.  BODs on 10/07/2017 meeting decided to keep the $6,500 cost to cover $1,000 deductible."]
[null,null,null,null,null,null,null,null,"2019 Budget: No indication that 1280 will be built yet so keep at 6500"]
[null,"Legal-Professional Fees Accrual",null,null,null,null,null,null,"7/22/2018  There is a $1,300 balance in Insurance Accrual after the second payment for 2018, which will cover the $1,000 deductible.  So for the coming 2019 Budget, budget for only the cost of insurance."]
[null,"All Units",null,500,{"$f":"IF(D39=\"\",\"\",D39+(D39*(inflation_rate+construction_cost_increase)))","v":534.5},1200,{"$f":"IF(AND(E39=\"\",F39=\"\"),\"\",IF(F39=\"\",E39,F39))","v":1200},{"$f":"G39","v":1200}]
[]
[]
[]
[null,null,null,"Total",{"$f":"SUM(E8:E39)","v":198589.46197400001},"Total",{"$f":"SUM(G8:G39)","v":195055.82898699996},{"$f":"SUM(H15,H17,H26,H34,H36,H39)","v":22653.97144935}]

{"sheet":"GENERAL FUND Estimates","index":7,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,4,1,5],[0,1,0,5],[1,1,3,1],[1,2,3,2]]}
[null,"HHCOA Estimated General Fund Costs"]
[null,"Expense Category","Expense Type","Previous Budget Year","Current Budget Year",null,null,null,null,"Parms Combo Plan",null,"Original Budget"]
[null,null,null,{"$f":"previous_budget_year","v":2018},{"$f":"previous_budget_year","v":2018},{"$f":"current_budget_year","v":2019},"Notes",null,"Lawn Care",{"$f":"945*7+(955)","v":7570},null,7367]
[null,null,null,"Budget","Actual:  Last 12 months by category per Quicken Reports.","Budget","2017-2018 Actual taken from the PAST 12 MONTHS Spending By Category report in QUICKEN as of 7/10/2018",null,"Snow",{"$f":"945*5","v":4725},null,4250]
[null,"Administration Fee","Business",12,10,10,null,null,null,{"$f":"SUM(J3:J4)","v":12295},null,{"$f":"SUM(L3:L4)","v":11617}]
[null,"Dues and Subscriptions","Business",130,167,170,"Includes Annual Quicken Renewal for Mary",null,null,null,"Difference:",{"$f":"J5-L5","v":678}]
[null,null,null,null,null,null,null,null,"Remove plastic edging"]
[null,"Supplies, Business","Business",150,284,300,null,null,1500,1270,null,{"$f":"678/12/16","v":3.53125}]
[null,"Bank Charge","Business",0,0,10,null,null,1330,1272]
[null,"Business, Other","Business",0,0,100,null,null,1330,1274]
[null,"Grounds Improvement","Discretionary",500,229,500,null,null,1330,1276,null,"Daun's Lawn Care Estimate 2017"]
[null,"Landscaping Repayment","Discretionary",600,600,600,null,null,{"$f":"SUM(I8:I11)","v":5490},null,null,null,"Cost Each","Times per Season","Total/Year","Total/Month"]
[null,"Lawn Care","Discretionary",3500,9838,7570,"$945/mnth x 7 mnths + $955 for mulching and edging and aeration",null,"2019 Snow removal",null,null,"Spring Clean Up",350,1,{"$f":"M13*N13","v":350},{"$f":"O13/12","v":29.166666666666668}]
[null,"Snow Removal","Discretionary",3000,3994,4725,"$945/mnth x 5 months",null,"5 years",14442,null,"Cut and Trim",150,{"$f":"4*6","v":24},{"$f":"M14*N14","v":3600},{"$f":"O14/12","v":300}]
[null,"Wireless Internet","Discretionary",500,0,0,null,null,null,null,null,"Weed Control (manual)",null,null,{"$f":"M15*N15","v":0},{"$f":"O15/12","v":0}]
[null,"Discretionary, Other","Discretionary",0,353,250,null,null,"Average Per Year",{"$f":"J14/5","v":2888.4},null,"Fertilizing/Chem Weed Ctrl",160,4,640,53.333333333333336]
[null,"Electric House Meter 1","Mandatory",215,194,200,null,null,"Leave at 3,000?",null,null,"Prunning ($45/hr)",650,1,650,54.166666666666664]
[null,"Electric House Meter 2","Mandatory",330,258,260,null,null,"Add some repair work from Jason $945",null,null,"Mulching@$50/yd",500,0.5,250,20.833333333333332]
[null,"Water and Sewer","Mandatory",250,214,250,null,null,null,null,null,"Edging",225,0.5,112.5,9.375]
[null,"Mandatory, Other","Mandatory",0,0,100,null,null,null,null,null,"Fall Clean Up",350,1,350,29.166666666666668]
[null,null,null,null,null,null,null,null,null,null,null,"Aeration",300,1,300,25]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Retention Pond Cutting",275,1,275,22.916666666666668]
[]
[null,"Total",null,{"$f":"SUM(D5:D24)","v":9187},{"$f":"SUM(E5:E24)","v":16141},{"$f":"SUM(F5:F24)","v":15045},null,null,null,null,null,"Total Lawn Care",null,null,{"$f":"SUM(O13:O23)","v":6527.5},{"$f":"SUM(P13:P23)","v":543.95833333333337}]

{"sheet":"Calculations","index":8,"n_rows":44,"n_cols":46,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,23,43,25],[3,1,3,6],[16,19,16,21],[33,19,33,20],[3,16,3,17],[3,7,3,8],[17,19,17,20],[18,19,18,20],[19,19,19,20],[20,19,20,20],[32,19,32,21],[21,19,21,20],[28,16,30,16],[3,11,3,15],[3,19,3,21],[34,19,34,20],[35,19,35,20],[36,19,36,20],[13,26,14,27],[25,25,27,25],[16,23,16,25],[17,23,17,24],[18,23,18,24],[19,23,19,24],[20,23,20,24],[21,23,21,24],[22,19,22,20],[3,23,3,25],[22,23,22,24],[40,23,40,25],[41,23,41,25],[42,23,42,25]]}
[]
[]
[]
[null,"Reserve Costs Distributions",null,null,null,null,null,"Total Reserve Costs",null,null,null,"General Fund Costs Distributions",null,null,null,null,"Total Fund Costs",null,null,"Association Dues",null,null,null,"Income",null,null,null,null,null,null,null,null,null,null,null,null,null,"CHECK"]
[null,null,null,"Cost / Building","Cost per Unit","Cost per Unit/Year","Cost per Unit/Month","Total Cost per Year","Total Cost per Month",null,null,null,null,"Annual Cost","Cost per Unit/Year","Cost per Unit/Month","Total Cost per Year","Total Cost per Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESERVE COSTS / Unit / Month",null,null,null,null,null,"GENERAL COSTS / Unit / Month",null,"TOTAL COSTS / Unit /Month"]
[null,{"$f":"IF('RESERVE Cost Estimates'!B7=\"\",\"\",'RESERVE Cost Estimates'!B7)","v":"Roofing Accrual"},null,null,null,null,null,null,null,null,null,"Category","Type",null,null,null,null,null,null,"Unit","Monthly Calculated Fee","Monthly Fee (Rounded Up)",null,"Unit","Unit Fee/Month","Unit Fee/Year",null,null,null,null,null,null,null,null,null,null,null,"Roofing","Road Repair","Painting & Power Wash","General Maintenance","Insurance","Legal-Prof. Fees"]
[null,{"$f":"IF('RESERVE Cost Estimates'!B8=\"\",\"\",'RESERVE Cost Estimates'!B8)","v":1270},null,{"$f":"IF('RESERVE Cost Estimates'!G8=\"\",\"\",'RESERVE Cost Estimates'!G8)","v":56801.992891000002},{"$f":"IF(D7=\"\",\"\",D7/'Tables & References'!C11)","v":7100.2491113750002},{"$f":"IF(E7=\"\",\"\",E7/roofing_recurrence_A)","v":355.01245556875},{"$f":"IF(F7=\"\",\"\",F7/12)","v":29.584371297395833},{"$f":"IF(F7=\"\",\"\",F7*'Tables & References'!C11)","v":2840.09964455},{"$f":"IF(H7=\"\",\"\",H7/12)","v":236.67497037916667},null,null,{"$f":"IF('GENERAL FUND Estimates'!B5=\"\",\"\",'GENERAL FUND Estimates'!B5)","v":"Administration Fee"},{"$f":"IF('GENERAL FUND Estimates'!C5=\"\",\"\",'GENERAL FUND Estimates'!C5)","v":"Business"},{"$f":"IF('GENERAL FUND Estimates'!F5=\"\",\"\",'GENERAL FUND Estimates'!F5)","v":10},{"$f":"IF(N7=\"\",\"\",N7/SUM('Tables & References'!$C$11:$C$16))","v":0.625},{"$f":"IF(O7=\"\",\"\",O7/12)","v":5.2083333333333336E-2},{"$f":"IF(O7=\"\",\"\",O7*SUM('Tables & References'!$C$11:$C$16))","v":10},{"$f":"IF(Q7=\"\",\"\",Q7/12)","v":0.83333333333333337},null,{"$f":"IF('Tables & References'!B11=\"\",\"\",'Tables & References'!B11)","v":1270},{"$f":"IF(T7=\"\",\"\",SUM(G7,G16,G19,G27,G35,G38,P28))","v":182.34826018628473},{"$f":"IF(U7=\"\",\"\",ROUNDUP(U7,0))","v":183},null,{"$f":"T7","v":1270},{"$f":"IF(X7=\"\",\"\",V7*'Tables & References'!C11)","v":1464},{"$f":"IF(X7=\"\",\"\",Y7*12)","v":17568},null,null,null,null,null,null,null,null,null,null,1270,{"$f":"G7","v":29.584371297395833},{"$f":"$G$16","v":11.135416666666666},{"$f":"G19","v":4.5399305555555554},{"$f":"G27","v":22.270833333333332},{"$f":"$G$35","v":30.208333333333332},{"$f":"$G$38","v":6.25},{"$f":"$P$28","v":78.359375},null,{"$f":"SUM(AL7:AR7)","v":182.34826018628473}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B9=\"\",\"\",'RESERVE Cost Estimates'!B9)","v":1272},null,{"$f":"IF('RESERVE Cost Estimates'!G9=\"\",\"\",'RESERVE Cost Estimates'!G9)","v":28359.336095999999},{"$f":"IF(D8=\"\",\"\",D8/'Tables & References'!C12)","v":14179.668048},{"$f":"IF(E8=\"\",\"\",E8/roofing_recurrence_A)","v":708.98340239999993},{"$f":"IF(F8=\"\",\"\",F8/12)","v":59.081950199999994},{"$f":"IF(F8=\"\",\"\",F8*'Tables & References'!C12)","v":1417.9668047999999},{"$f":"IF(H8=\"\",\"\",H8/12)","v":118.16390039999999},null,null,{"$f":"IF('GENERAL FUND Estimates'!B6=\"\",\"\",'GENERAL FUND Estimates'!B6)","v":"Dues and Subscriptions"},{"$f":"IF('GENERAL FUND Estimates'!C6=\"\",\"\",'GENERAL FUND Estimates'!C6)","v":"Business"},{"$f":"IF('GENERAL FUND Estimates'!F6=\"\",\"\",'GENERAL FUND Estimates'!F6)","v":170},{"$f":"IF(N8=\"\",\"\",N8/SUM('Tables & References'!$C$11:$C$16))","v":10.625},{"$f":"IF(O8=\"\",\"\",O8/12)","v":0.88541666666666663},{"$f":"IF(O8=\"\",\"\",O8*SUM('Tables & References'!$C$11:$C$16))","v":170},{"$f":"IF(Q8=\"\",\"\",Q8/12)","v":14.166666666666666},null,{"$f":"IF('Tables & References'!B12=\"\",\"\",'Tables & References'!B12)","v":1272},{"$f":"IF(T8=\"\",\"\",SUM(G8,G16,G20,G28,G35,G38,P28))","v":231.0614640888889},{"$f":"IF(U8=\"\",\"\",ROUNDUP(U8,0))","v":232},null,{"$f":"T8","v":1272},{"$f":"IF(X8=\"\",\"\",V8*'Tables & References'!C12)","v":464},{"$f":"IF(X8=\"\",\"\",Y8*12)","v":5568},null,null,null,null,null,null,null,null,null,null,1272,{"$f":"G8","v":59.081950199999994},{"$f":"$G$16","v":11.135416666666666},{"$f":"G20","v":12.620138888888889},{"$f":"G28","v":33.40625},{"$f":"$G$35","v":30.208333333333332},{"$f":"$G$38","v":6.25},{"$f":"$P$28","v":78.359375},null,{"$f":"SUM(AL8:AR8)","v":231.0614640888889}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B10=\"\",\"\",'RESERVE Cost Estimates'!B10)","v":1274},null,{"$f":"IF('RESERVE Cost Estimates'!G10=\"\",\"\",'RESERVE Cost Estimates'!G10)","v":30621.200000000001},{"$f":"IF(D9=\"\",\"\",D9/'Tables & References'!C13)","v":15310.6},{"$f":"IF(E9=\"\",\"\",E9/roofing_recurrence_A)","v":765.53},63.794166666666662,{"$f":"IF(F9=\"\",\"\",F9*'Tables & References'!C13)","v":1531.06},127.58833333333332,null,null,{"$f":"IF('GENERAL FUND Estimates'!B7=\"\",\"\",'GENERAL FUND Estimates'!B7)","v":""},{"$f":"IF('GENERAL FUND Estimates'!C7=\"\",\"\",'GENERAL FUND Estimates'!C7)","v":""},{"$f":"IF('GENERAL FUND Estimates'!F7=\"\",\"\",'GENERAL FUND Estimates'!F7)","v":""},{"$f":"IF(N9=\"\",\"\",N9/SUM('Tables & References'!$C$11:$C$16))","v":""},"",{"$f":"IF(O9=\"\",\"\",O9*SUM('Tables & References'!$C$11:$C$16))","v":""},"",null,{"$f":"IF('Tables & References'!B13=\"\",\"\",'Tables & References'!B13)","v":1274},{"$f":"IF(T9=\"\",\"\",SUM(G9,G16,G21,G29,G35,G38,P28))","v":230.57715277777777},231,null,1274,{"$f":"IF(X9=\"\",\"\",V9*'Tables & References'!C13)","v":462},5544,null,null,null,null,null,null,null,null,null,null,1274,63.794166666666662,11.135416666666666,7.4236111111111107,33.40625,{"$f":"$G$35","v":30.208333333333332},6.25,78.359375,null,230.57715277777777]
[null,{"$f":"IF('RESERVE Cost Estimates'!B11=\"\",\"\",'RESERVE Cost Estimates'!B11)","v":1276},null,{"$f":"IF('RESERVE Cost Estimates'!G11=\"\",\"\",'RESERVE Cost Estimates'!G11)","v":27052.174999999999},{"$f":"IF(D10=\"\",\"\",D10/'Tables & References'!C14)","v":13526.0875},{"$f":"IF(E10=\"\",\"\",E10/roofing_recurrence_B)","v":450.86958333333331},37.572465277777773,{"$f":"IF(F10=\"\",\"\",F10*'Tables & References'!C14)","v":901.73916666666662},75.144930555555547,null,null,{"$f":"IF('GENERAL FUND Estimates'!B8=\"\",\"\",'GENERAL FUND Estimates'!B8)","v":"Supplies, Business"},{"$f":"IF('GENERAL FUND Estimates'!C8=\"\",\"\",'GENERAL FUND Estimates'!C8)","v":"Business"},{"$f":"IF('GENERAL FUND Estimates'!F8=\"\",\"\",'GENERAL FUND Estimates'!F8)","v":300},{"$f":"IF(N10=\"\",\"\",N10/SUM('Tables & References'!$C$11:$C$16))","v":18.75},1.5625,{"$f":"IF(O10=\"\",\"\",O10*SUM('Tables & References'!$C$11:$C$16))","v":300},25,null,{"$f":"IF('Tables & References'!B14=\"\",\"\",'Tables & References'!B14)","v":1276},{"$f":"IF(T10=\"\",\"\",SUM(G10,G16,G22,G30,G35,G38,P28))","v":202.87072916666665},203,null,1276,{"$f":"IF(X10=\"\",\"\",V10*'Tables & References'!C14)","v":406},4872,null,null,null,null,null,null,null,null,null,null,1276,37.572465277777773,11.135416666666666,5.9388888888888891,33.40625,{"$f":"$G$35","v":30.208333333333332},6.25,78.359375,null,202.87072916666665]
[null,{"$f":"IF('RESERVE Cost Estimates'!B12=\"\",\"\",'RESERVE Cost Estimates'!B12)","v":"1278*"},null,{"$f":"IF('RESERVE Cost Estimates'!G12=\"\",\"\",'RESERVE Cost Estimates'!G12)","v":27052.174999999999},{"$f":"IF(D11=\"\",\"\",D11/'Tables & References'!C15)","v":13526.0875},{"$f":"IF(E11=\"\",\"\",E11/roofing_recurrence_c)","v":450.86958333333331},37.572465277777773,{"$f":"IF(F11=\"\",\"\",F11*'Tables & References'!C15)","v":901.73916666666662},75.144930555555547,null,null,{"$f":"IF('GENERAL FUND Estimates'!B9=\"\",\"\",'GENERAL FUND Estimates'!B9)","v":"Bank Charge"},{"$f":"IF('GENERAL FUND Estimates'!C9=\"\",\"\",'GENERAL FUND Estimates'!C9)","v":"Business"},{"$f":"IF('GENERAL FUND Estimates'!F9=\"\",\"\",'GENERAL FUND Estimates'!F9)","v":10},{"$f":"IF(N11=\"\",\"\",N11/SUM('Tables & References'!$C$11:$C$16))","v":0.625},5.2083333333333336E-2,{"$f":"IF(O11=\"\",\"\",O11*SUM('Tables & References'!$C$11:$C$16))","v":10},0.83333333333333337,null,{"$f":"IF('Tables & References'!B15=\"\",\"\",'Tables & References'!B15)","v":1278},{"$f":"IF(T11=\"\",\"\",SUM(G11,G16,G23,G31,G35,G38,P28))","v":176.88809027777776},177,null,1278,{"$f":"IF(X11=\"\",\"\",V11*'Tables & References'!C15)","v":354},4248,null,null,null,null,null,null,null,null,null,null,1278,37.572465277777773,11.135416666666666,4.4541666666666666,8.9083333333333332,{"$f":"$G$35","v":30.208333333333332},6.25,78.359375,null,176.88809027777776]
[null,{"$f":"IF('RESERVE Cost Estimates'!B13=\"\",\"\",'RESERVE Cost Estimates'!B13)","v":""},null,{"$f":"IF('RESERVE Cost Estimates'!G13=\"\",\"\",'RESERVE Cost Estimates'!G13)","v":""},{"$f":"IF(D12=\"\",\"\",D12/'Tables & References'!C16)","v":""},{"$f":"IF(E12=\"\",\"\",E12/roofing_recurrence_d)","v":""},"",{"$f":"IF(F12=\"\",\"\",F12*'Tables & References'!C16)","v":""},"",null,null,{"$f":"IF('GENERAL FUND Estimates'!B10=\"\",\"\",'GENERAL FUND Estimates'!B10)","v":"Business, Other"},{"$f":"IF('GENERAL FUND Estimates'!C10=\"\",\"\",'GENERAL FUND Estimates'!C10)","v":"Business"},{"$f":"IF('GENERAL FUND Estimates'!F10=\"\",\"\",'GENERAL FUND Estimates'!F10)","v":100},{"$f":"IF(N12=\"\",\"\",N12/SUM('Tables & References'!$C$11:$C$16))","v":6.25},0.52083333333333337,{"$f":"IF(O12=\"\",\"\",O12*SUM('Tables & References'!$C$11:$C$16))","v":100},8.3333333333333339,null,{"$f":"IF('Tables & References'!B16=\"\",\"\",'Tables & References'!B16)","v":""},{"$f":"IF(T12=\"\",\"\",SUM(G12,G16,G24,G32,G35,G38,P28))","v":""},"",null,"",{"$f":"IF(X12=\"\",\"\",V12*'Tables & References'!C16)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,"",null,"",""]
[null,{"$f":"IF('RESERVE Cost Estimates'!B15=\"\",\"\",'RESERVE Cost Estimates'!B15)","v":""},null,null,null,null,"Total",{"$f":"SUM(H7:H12)","v":7592.6047826833328},{"$f":"SUM(I7:I12)","v":632.71706522361103},null,null,{"$f":"IF('GENERAL FUND Estimates'!B11=\"\",\"\",'GENERAL FUND Estimates'!B11)","v":"Grounds Improvement"},{"$f":"IF('GENERAL FUND Estimates'!C11=\"\",\"\",'GENERAL FUND Estimates'!C11)","v":"Discretionary"},{"$f":"IF('GENERAL FUND Estimates'!F11=\"\",\"\",'GENERAL FUND Estimates'!F11)","v":500},{"$f":"IF(N13=\"\",\"\",N13/SUM('Tables & References'!$C$11:$C$16))","v":31.25},2.6041666666666665,{"$f":"IF(O13=\"\",\"\",O13*SUM('Tables & References'!$C$11:$C$16))","v":500},41.666666666666664]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('GENERAL FUND Estimates'!B12=\"\",\"\",'GENERAL FUND Estimates'!B12)","v":"Landscaping Repayment"},{"$f":"IF('GENERAL FUND Estimates'!C12=\"\",\"\",'GENERAL FUND Estimates'!C12)","v":"Discretionary"},{"$f":"IF('GENERAL FUND Estimates'!F12=\"\",\"\",'GENERAL FUND Estimates'!F12)","v":600},{"$f":"IF(N14=\"\",\"\",N14/SUM('Tables & References'!$C$11:$C$16))","v":37.5},3.125,{"$f":"IF(O14=\"\",\"\",O14*SUM('Tables & References'!$C$11:$C$16))","v":600},50,null,"Total Monthly Fee",null,{"$f":"V7*8+(SUM(V8:V11)*2)","v":3150},null,"Checks",{"$f":"SUM(Y7:Y13)","v":3150},{"$f":"SUM(Z7:Z12)","v":37800},{"$f":"IF(Z14=Z15,\"Checks Agree\",\"Error:Checks Do Not Agree\")","v":"Checks Agree"}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B16=\"\",\"\",'RESERVE Cost Estimates'!B16)","v":"Road Maintenance Accrual"},null,null,null,null,null,null,null,null,null,{"$f":"IF('GENERAL FUND Estimates'!B13=\"\",\"\",'GENERAL FUND Estimates'!B13)","v":"Lawn Care"},{"$f":"IF('GENERAL FUND Estimates'!C13=\"\",\"\",'GENERAL FUND Estimates'!C13)","v":"Discretionary"},{"$f":"IF('GENERAL FUND Estimates'!F13=\"\",\"\",'GENERAL FUND Estimates'!F13)","v":7570},{"$f":"IF(N15=\"\",\"\",N15/SUM('Tables & References'!$C$11:$C$16))","v":473.125},39.427083333333336,{"$f":"IF(O15=\"\",\"\",O15*SUM('Tables & References'!$C$11:$C$16))","v":7570},630.83333333333337,null,null,null,null,null,null,null,{"$f":"Y14*12","v":37800}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B17=\"\",\"\",'RESERVE Cost Estimates'!B17)","v":"All Units"},null,{"$f":"IF('RESERVE Cost Estimates'!G17=\"\",\"\",'RESERVE Cost Estimates'!G17)","v":6414},{"$f":"IF(D16=\"\",\"\",D16/SUM('Tables & References'!C11:C16))","v":400.875},{"$f":"IF(E16=\"\",\"\",E16/road_recurrence)","v":133.625},{"$f":"IF(F16=\"\",\"\",F16/12)","v":11.135416666666666},{"$f":"IF(F16=\"\",\"\",F16*SUM('Tables & References'!C11:C16))","v":2138},{"$f":"IF(H16=\"\",\"\",H16/12)","v":178.16666666666666},null,null,{"$f":"IF('GENERAL FUND Estimates'!B14=\"\",\"\",'GENERAL FUND Estimates'!B14)","v":"Snow Removal"},{"$f":"IF('GENERAL FUND Estimates'!C14=\"\",\"\",'GENERAL FUND Estimates'!C14)","v":"Discretionary"},{"$f":"IF('GENERAL FUND Estimates'!F14=\"\",\"\",'GENERAL FUND Estimates'!F14)","v":4725},{"$f":"IF(N16=\"\",\"\",N16/SUM('Tables & References'!$C$11:$C$16))","v":295.3125},24.609375,{"$f":"IF(O16=\"\",\"\",O16*SUM('Tables & References'!$C$11:$C$16))","v":4725},393.75]
[null,{"$f":"IF('RESERVE Cost Estimates'!B18=\"\",\"\",'RESERVE Cost Estimates'!B18)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF('GENERAL FUND Estimates'!B15=\"\",\"\",'GENERAL FUND Estimates'!B15)","v":"Wireless Internet"},{"$f":"IF('GENERAL FUND Estimates'!C15=\"\",\"\",'GENERAL FUND Estimates'!C15)","v":"Discretionary"},{"$f":"IF('GENERAL FUND Estimates'!F15=\"\",\"\",'GENERAL FUND Estimates'!F15)","v":0},{"$f":"IF(N17=\"\",\"\",N17/SUM('Tables & References'!$C$11:$C$16))","v":0},0,{"$f":"IF(O17=\"\",\"\",O17*SUM('Tables & References'!$C$11:$C$16))","v":0},0,null,"Monthly Accrual (Reserve) Funds",null,null,null,"Monthly Deposits"]
[null,{"$f":"IF('RESERVE Cost Estimates'!B19=\"\",\"\",'RESERVE Cost Estimates'!B19)","v":"Painting/Power Washing Accrual"},null,null,null,null,null,null,null,null,null,{"$f":"IF('GENERAL FUND Estimates'!B16=\"\",\"\",'GENERAL FUND Estimates'!B16)","v":"Discretionary, Other"},{"$f":"IF('GENERAL FUND Estimates'!C16=\"\",\"\",'GENERAL FUND Estimates'!C16)","v":"Discretionary"},{"$f":"IF('GENERAL FUND Estimates'!F16=\"\",\"\",'GENERAL FUND Estimates'!F16)","v":250},{"$f":"IF(N18=\"\",\"\",N18/SUM('Tables & References'!$C$11:$C$16))","v":15.625},1.3020833333333333,{"$f":"IF(O18=\"\",\"\",O18*SUM('Tables & References'!$C$11:$C$16))","v":250},20.833333333333332,null,{"$f":"'Tables & References'!J3","v":"Roofing Accrual"},null,{"$f":"I13","v":632.71706522361103},null,{"$f":"T18","v":"Roofing Accrual"},null,{"$f":"ROUNDUP(V18,0)","v":633}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B20=\"\",\"\",'RESERVE Cost Estimates'!B20)","v":1270},null,{"$f":"IF('RESERVE Cost Estimates'!G20=\"\",\"\",'RESERVE Cost Estimates'!G20)","v":2615},{"$f":"IF(D19=\"\",\"\",D19/'Tables & References'!C11)","v":326.875},{"$f":"IF(E19=\"\",\"\",E19/painting_recurrence)","v":54.479166666666664},{"$f":"IF(F19=\"\",\"\",F19/12)","v":4.5399305555555554},{"$f":"IF(F19=\"\",\"\",F19*'Tables & References'!C11)","v":435.83333333333331},{"$f":"IF(H19=\"\",\"\",H19/12)","v":36.319444444444443},null,null,{"$f":"IF('GENERAL FUND Estimates'!B17=\"\",\"\",'GENERAL FUND Estimates'!B17)","v":"Electric House Meter 1"},{"$f":"IF('GENERAL FUND Estimates'!C17=\"\",\"\",'GENERAL FUND Estimates'!C17)","v":"Mandatory"},{"$f":"IF('GENERAL FUND Estimates'!F17=\"\",\"\",'GENERAL FUND Estimates'!F17)","v":200},{"$f":"IF(N19=\"\",\"\",N19/SUM('Tables & References'!$C$11:$C$16))","v":12.5},1.0416666666666667,{"$f":"IF(O19=\"\",\"\",O19*SUM('Tables & References'!$C$11:$C$16))","v":200},16.666666666666668,null,{"$f":"'Tables & References'!J4","v":"Road Maintenance Accrual"},null,{"$f":"I16","v":178.16666666666666},null,{"$f":"T19","v":"Road Maintenance Accrual"},null,{"$f":"ROUNDUP(V19,0)","v":179}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B21=\"\",\"\",'RESERVE Cost Estimates'!B21)","v":1272},null,{"$f":"IF('RESERVE Cost Estimates'!G21=\"\",\"\",'RESERVE Cost Estimates'!G21)","v":1817.3},{"$f":"IF(D20=\"\",\"\",D20/'Tables & References'!C12)","v":908.65},151.44166666666666,{"$f":"IF(F20=\"\",\"\",F20/12)","v":12.620138888888889},{"$f":"IF(F20=\"\",\"\",F20*'Tables & References'!C12)","v":302.88333333333333},{"$f":"IF(H20=\"\",\"\",H20/12)","v":25.240277777777777},null,null,{"$f":"IF('GENERAL FUND Estimates'!B18=\"\",\"\",'GENERAL FUND Estimates'!B18)","v":"Electric House Meter 2"},{"$f":"IF('GENERAL FUND Estimates'!C18=\"\",\"\",'GENERAL FUND Estimates'!C18)","v":"Mandatory"},{"$f":"IF('GENERAL FUND Estimates'!F18=\"\",\"\",'GENERAL FUND Estimates'!F18)","v":260},{"$f":"IF(N20=\"\",\"\",N20/SUM('Tables & References'!$C$11:$C$16))","v":16.25},1.3541666666666667,{"$f":"IF(O20=\"\",\"\",O20*SUM('Tables & References'!$C$11:$C$16))","v":260},21.666666666666668,null,{"$f":"'Tables & References'!J5","v":"Painting/Power Washing Accrual"},null,{"$f":"I25","v":97.193055555555546},null,"Painting/Power Washing Accrual",null,98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dues Comparisons to Previouos Year of:",{"$f":"previous_budget_year","v":2018}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B22=\"\",\"\",'RESERVE Cost Estimates'!B22)","v":1274},null,{"$f":"IF('RESERVE Cost Estimates'!G22=\"\",\"\",'RESERVE Cost Estimates'!G22)","v":1069},{"$f":"IF(D21=\"\",\"\",D21/'Tables & References'!C13)","v":534.5},89.083333333333329,7.4236111111111107,{"$f":"IF(F21=\"\",\"\",F21*'Tables & References'!C13)","v":178.16666666666666},14.847222222222221,null,null,{"$f":"IF('GENERAL FUND Estimates'!B19=\"\",\"\",'GENERAL FUND Estimates'!B19)","v":"Water and Sewer"},{"$f":"IF('GENERAL FUND Estimates'!C19=\"\",\"\",'GENERAL FUND Estimates'!C19)","v":"Mandatory"},{"$f":"IF('GENERAL FUND Estimates'!F19=\"\",\"\",'GENERAL FUND Estimates'!F19)","v":250},{"$f":"IF(N21=\"\",\"\",N21/SUM('Tables & References'!$C$11:$C$16))","v":15.625},1.3020833333333333,{"$f":"IF(O21=\"\",\"\",O21*SUM('Tables & References'!$C$11:$C$16))","v":250},20.833333333333332,null,{"$f":"'Tables & References'!J6","v":"General Building Maintenance Accrual"},null,{"$f":"I33","v":396.42083333333329},null,"General Building Maintenance Accrual",null,397,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"increase"]
[null,{"$f":"IF('RESERVE Cost Estimates'!B23=\"\",\"\",'RESERVE Cost Estimates'!B23)","v":1276},null,{"$f":"IF('RESERVE Cost Estimates'!G23=\"\",\"\",'RESERVE Cost Estimates'!G23)","v":855.2},{"$f":"IF(D22=\"\",\"\",D22/'Tables & References'!C14)","v":427.6},71.266666666666666,5.9388888888888891,{"$f":"IF(F22=\"\",\"\",F22*'Tables & References'!C14)","v":142.53333333333333},11.877777777777778,null,null,{"$f":"IF('GENERAL FUND Estimates'!B20=\"\",\"\",'GENERAL FUND Estimates'!B20)","v":"Mandatory, Other"},{"$f":"IF('GENERAL FUND Estimates'!C20=\"\",\"\",'GENERAL FUND Estimates'!C20)","v":"Mandatory"},{"$f":"IF('GENERAL FUND Estimates'!F20=\"\",\"\",'GENERAL FUND Estimates'!F20)","v":100},{"$f":"IF(N22=\"\",\"\",N22/SUM('Tables & References'!$C$11:$C$16))","v":6.25},0.52083333333333337,{"$f":"IF(O22=\"\",\"\",O22*SUM('Tables & References'!$C$11:$C$16))","v":100},8.3333333333333339,null,{"$f":"'Tables & References'!J7","v":"Insurance Accrual"},null,{"$f":"I35","v":483.33333333333331},null,{"$f":"T22","v":"Insurance Accrual"},null,{"$f":"ROUNDUP(V22,0)","v":484},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS20","v":2018},2019]
[null,{"$f":"IF('RESERVE Cost Estimates'!B24=\"\",\"\",'RESERVE Cost Estimates'!B24)","v":1278},null,{"$f":"IF('RESERVE Cost Estimates'!G24=\"\",\"\",'RESERVE Cost Estimates'!G24)","v":641.4},{"$f":"IF(D23=\"\",\"\",D23/'Tables & References'!C15)","v":320.7},53.449999999999996,4.4541666666666666,{"$f":"IF(F23=\"\",\"\",F23*'Tables & References'!C15)","v":106.89999999999999},8.9083333333333332,null,null,{"$f":"IF('GENERAL FUND Estimates'!B21=\"\",\"\",'GENERAL FUND Estimates'!B21)","v":""},{"$f":"IF('GENERAL FUND Estimates'!C21=\"\",\"\",'GENERAL FUND Estimates'!C21)","v":""},{"$f":"IF('GENERAL FUND Estimates'!F21=\"\",\"\",'GENERAL FUND Estimates'!F21)","v":""},{"$f":"IF(N23=\"\",\"\",N23/SUM('Tables & References'!$C$11:$C$16))","v":""},"",{"$f":"IF(O23=\"\",\"\",O23*SUM('Tables & References'!$C$11:$C$16))","v":""},"",null,{"$f":"'Tables & References'!J8","v":"Legal-Profession Fees Accrual"},null,{"$f":"I38","v":100},null,{"$f":"T39","v":"Total Monthly General Funds"},null,{"$f":"V14-(SUM(Z18:Z22))","v":1359},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1270,159,{"$f":"V7","v":183},{"$f":"(AQ23-AP23)/AP23","v":0.15094339622641509},"2018 ZERO Budget for Painting"]
[null,{"$f":"IF('RESERVE Cost Estimates'!B25=\"\",\"\",'RESERVE Cost Estimates'!B25)","v":""},null,{"$f":"IF('RESERVE Cost Estimates'!G25=\"\",\"\",'RESERVE Cost Estimates'!G25)","v":""},{"$f":"IF(D24=\"\",\"\",D24/'Tables & References'!C16)","v":""},"","",{"$f":"IF(F24=\"\",\"\",F24*'Tables & References'!C16)","v":""},"",null,null,{"$f":"IF('GENERAL FUND Estimates'!B23=\"\",\"\",'GENERAL FUND Estimates'!B23)","v":""},{"$f":"IF('GENERAL FUND Estimates'!C23=\"\",\"\",'GENERAL FUND Estimates'!C23)","v":""},{"$f":"IF('GENERAL FUND Estimates'!F22=\"\",\"\",'GENERAL FUND Estimates'!F22)","v":""},{"$f":"IF(N24=\"\",\"\",N24/SUM('Tables & References'!$C$11:$C$16))","v":""},"",{"$f":"IF(O24=\"\",\"\",O24*SUM('Tables & References'!$C$11:$C$16))","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1272,212,{"$f":"V8","v":232},{"$f":"(AQ24-AP24)/AP24","v":9.4339622641509441E-2}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B26=\"\",\"\",'RESERVE Cost Estimates'!B26)","v":""},null,null,null,null,"Total",{"$f":"SUM(H19:H24)","v":1166.3166666666668},{"$f":"SUM(I19:I24)","v":97.193055555555546},null,null,{"$f":"IF('GENERAL FUND Estimates'!B24=\"\",\"\",'GENERAL FUND Estimates'!B24)","v":""},{"$f":"IF('GENERAL FUND Estimates'!C24=\"\",\"\",'GENERAL FUND Estimates'!C24)","v":""},{"$f":"IF('GENERAL FUND Estimates'!F23=\"\",\"\",'GENERAL FUND Estimates'!F23)","v":""},{"$f":"IF(N25=\"\",\"\",N25/SUM('Tables & References'!$C$11:$C$16))","v":""},"",{"$f":"IF(O25=\"\",\"\",O25*SUM('Tables & References'!$C$11:$C$16))","v":""},"",null,"Total Monthly Accrual Funds",null,{"$f":"SUM(V18:V23)","v":1887.8309541124997},null,"Check",null,{"$f":"ROUNDUP(SUM(Z18:Z23),0)","v":3150},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1274,211,231,9.4786729857819899E-2]
[null,{"$f":"IF('RESERVE Cost Estimates'!B27=\"\",\"\",'RESERVE Cost Estimates'!B27)","v":"General Building Maintenance Accrual"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('GENERAL FUND Estimates'!F24=\"\",\"\",'GENERAL FUND Estimates'!F24)","v":""},{"$f":"IF(N26=\"\",\"\",N26/SUM('Tables & References'!$C$11:$C$16))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z25=V14,\"Agrees with Fees\",\"ERROR: Does Not Agree With Fees\")","v":"Agrees with Fees"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,1276,184,203,0.10326086956521739]
[null,{"$f":"IF('RESERVE Cost Estimates'!B28=\"\",\"\",'RESERVE Cost Estimates'!B28)","v":1270},null,{"$f":"IF('RESERVE Cost Estimates'!G28=\"\",\"\",'RESERVE Cost Estimates'!G28)","v":2138},{"$f":"IF('RESERVE Cost Estimates'!G28=\"\",\"\",'RESERVE Cost Estimates'!G28/'Tables & References'!C11)","v":267.25},{"$f":"IF(E27=\"\",\"\",E27/maintenance_recurrence)","v":267.25},{"$f":"IF(F27=\"\",\"\",F27/12)","v":22.270833333333332},{"$f":"IF(F27=\"\",\"\",F27*'Tables & References'!C11)","v":2138},{"$f":"IF(H27=\"\",\"\",H27/12)","v":178.16666666666666},null,null,{"$f":"IF('GENERAL FUND Estimates'!B29=\"\",\"\",'GENERAL FUND Estimates'!B29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1278,160,177,0.10625]
[null,{"$f":"IF('RESERVE Cost Estimates'!B29=\"\",\"\",'RESERVE Cost Estimates'!B29)","v":1272},null,{"$f":"IF('RESERVE Cost Estimates'!G29=\"\",\"\",'RESERVE Cost Estimates'!G29)","v":801.75},{"$f":"IF('RESERVE Cost Estimates'!G29=\"\",\"\",'RESERVE Cost Estimates'!G29/'Tables & References'!C12)","v":400.875},400.875,33.40625,{"$f":"IF(F28=\"\",\"\",F28*'Tables & References'!C12)","v":801.75},{"$f":"IF(H28=\"\",\"\",H28/12)","v":66.8125},null,null,"Total",null,{"$f":"SUM(N7:N27)","v":15045},{"$f":"SUM(O7:O27)","v":940.3125},{"$f":"SUM(P7:P27)","v":78.359375},{"$f":"SUM(Q7:Q25)","v":15045},{"$f":"SUM(R7:R25)","v":1253.75}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B30=\"\",\"\",'RESERVE Cost Estimates'!B30)","v":1274},null,{"$f":"IF('RESERVE Cost Estimates'!G30=\"\",\"\",'RESERVE Cost Estimates'!G30)","v":801.75},{"$f":"IF('RESERVE Cost Estimates'!G30=\"\",\"\",'RESERVE Cost Estimates'!G30/'Tables & References'!C13)","v":400.875},400.875,33.40625,{"$f":"IF(F29=\"\",\"\",F29*'Tables & References'!C13)","v":801.75},66.8125,null,null,{"$f":"IF('GENERAL FUND Estimates'!B31=\"\",\"\",'GENERAL FUND Estimates'!B31)","v":""},null,null,null,null,{"$f":"IF(Q28='GENERAL FUND Estimates'!F25,\"Agrees With Estimate\",\"Error: Does Not Agree With Estimate\")","v":"Agrees With Estimate"}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B31=\"\",\"\",'RESERVE Cost Estimates'!B31)","v":1276},null,{"$f":"IF('RESERVE Cost Estimates'!G31=\"\",\"\",'RESERVE Cost Estimates'!G31)","v":801.75},{"$f":"IF('RESERVE Cost Estimates'!G31=\"\",\"\",'RESERVE Cost Estimates'!G31/'Tables & References'!C14)","v":400.875},400.875,33.40625,{"$f":"IF(F30=\"\",\"\",F30*'Tables & References'!C14)","v":801.75},66.8125,null,null,{"$f":"IF('GENERAL FUND Estimates'!B32=\"\",\"\",'GENERAL FUND Estimates'!B32)","v":""}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B32=\"\",\"\",'RESERVE Cost Estimates'!B32)","v":1278},null,{"$f":"IF('RESERVE Cost Estimates'!G32=\"\",\"\",'RESERVE Cost Estimates'!G32)","v":213.8},{"$f":"IF('RESERVE Cost Estimates'!G32=\"\",\"\",'RESERVE Cost Estimates'!G32/'Tables & References'!C15)","v":106.9},106.9,8.9083333333333332,{"$f":"IF(F31=\"\",\"\",F31*'Tables & References'!C15)","v":213.8},17.816666666666666,null,null,{"$f":"IF('GENERAL FUND Estimates'!B33=\"\",\"\",'GENERAL FUND Estimates'!B33)","v":""}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B33=\"\",\"\",'RESERVE Cost Estimates'!B33)","v":""},null,{"$f":"IF('RESERVE Cost Estimates'!G33=\"\",\"\",'RESERVE Cost Estimates'!G33)","v":""},{"$f":"IF('RESERVE Cost Estimates'!G33=\"\",\"\",'RESERVE Cost Estimates'!G33/'Tables & References'!C16)","v":""},"","",{"$f":"IF(F32=\"\",\"\",F32*'Tables & References'!C16)","v":""},""]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H27:H32)","v":4757.05},{"$f":"SUM(I27:I32)","v":396.42083333333329},null,null,null,null,null,null,null,null,null,null,"Monthly General Funds"]
[null,{"$f":"IF('RESERVE Cost Estimates'!B35=\"\",\"\",'RESERVE Cost Estimates'!B35)","v":"Insurance Accrual"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tables & References'!J11=\"\",\"\",'Tables & References'!J11)","v":"Business"},null,{"$f":"SUMIF(M7:M26,T34,P7:P26)*SUM('Tables & References'!C11:C16)","v":49.166666666666671}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B36=\"\",\"\",'RESERVE Cost Estimates'!B36)","v":"All Units"},null,{"$f":"IF('RESERVE Cost Estimates'!G36=\"\",\"\",'RESERVE Cost Estimates'!G36)","v":5800},{"$f":"IF(D35=\"\",\"\",D35/SUM('Tables & References'!C11:C16))","v":362.5},{"$f":"IF(E35=\"\",\"\",E35)/Insurance_recurrence","v":362.5},{"$f":"IF(F35=\"\",\"\",F35/12)","v":30.208333333333332},{"$f":"IF(F35=\"\",\"\",F35*SUM('Tables & References'!C11:C16))","v":5800},{"$f":"IF(H35=\"\",\"\",H35/12)","v":483.33333333333331},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tables & References'!J12=\"\",\"\",'Tables & References'!J12)","v":"Discretionary"},null,{"$f":"SUMIF(M7:M26,T35,P7:P26)*SUM('Tables & References'!C11:C16)","v":1137.0833333333333}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B37=\"\",\"\",'RESERVE Cost Estimates'!B37)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tables & References'!J13=\"\",\"\",'Tables & References'!J13)","v":"Mandatory"},null,{"$f":"SUMIF(M7:M26,T36,P7:P26)*SUM('Tables & References'!C11:C16)","v":67.5}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B38=\"\",\"\",'RESERVE Cost Estimates'!B38)","v":"Legal-Professional Fees Accrual"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tables & References'!J14=\"\",\"\",'Tables & References'!J14)","v":"Other"},null,{"$f":"SUMIF(M8:M27,T37,P8:P27)*SUM('Tables & References'!C12:C17)","v":0}]
[null,{"$f":"IF('RESERVE Cost Estimates'!B39=\"\",\"\",'RESERVE Cost Estimates'!B39)","v":"All Units"},null,{"$f":"IF('RESERVE Cost Estimates'!G39=\"\",\"\",'RESERVE Cost Estimates'!G39)","v":1200},{"$f":"IF(D38=\"\",\"\",D38/SUM('Tables & References'!C11:C16))","v":75},{"$f":"IF(E38=\"\",\"\",E38)/Legal_Fees_recurrence","v":75},{"$f":"IF(F38=\"\",\"\",F38/12)","v":6.25},{"$f":"IF(F38=\"\",\"\",F38*SUM('Tables & References'!C11:C16))","v":1200},{"$f":"IF(H38=\"\",\"\",H38/12)","v":100}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Monthly General Funds",null,{"$f":"SUM(V34:V37)","v":1253.75}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H13,H16,H25,H33,H35,H38)","v":22653.97144935},{"$f":"SUM(I13,I16,I25,I33,I35,I38)","v":1887.8309541124997},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1270","1272",null,null,null,null,null,null,"1274"]
[null,null,null,null,null,null,null,{"$f":"IF(H40='RESERVE Cost Estimates'!H43,\"Agrees With Estimate\",\"Error: Does Not Agree With Estimate\")","v":"Agrees With Estimate"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Previous Fees for\",\" \",previous_budget_year)","v":"Previous Fees for 2018"},null,null,137,187,null,null,null,null,null,null,189]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Fees for Current Budget Year of\",\" \",current_budget_year)","v":"Fees for Current Budget Year of 2019"},null,null,{"$f":"V7","v":183},{"$f":"V8","v":232},null,null,null,null,null,null,{"$f":"V9","v":231}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase",null,null,{"$f":"(AA42-AA41)/AA41","v":0.33576642335766421},{"$f":"(AB42-AB41)/AB41","v":0.24064171122994651},null,null,null,null,null,null,0.22222222222222221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Increase",null,null,{"$f":"AA42-AA41","v":46},{"$f":"AB42-AB41","v":45},null,null,null,null,null,null,42]

{"sheet":"Costs by Unit 1270","index":9,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,4]]}
["Hilary Heights Condominium Owners Association"]
["A Cost & Fee Analysis by Unit",null,null,"for the budget year of",{"$f":"current_budget_year","v":2019},"Unit",1270]
[null,null,null,"This Budget was approved by the Board of Directors on:",{"$f":"Approval_Date","v":"Sept 8th, 2018"}]
[]
["General Fund Expense (Shared by ALL Units)","Total Annual Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"'GENERAL FUND Estimates'!B5","v":"Administration Fee"},{"$f":"'GENERAL FUND Estimates'!F5","v":10},1,{"$f":"B7/C7","v":10},{"$f":"D7/12","v":0.83333333333333337},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E7/F7","v":5.2083333333333336E-2}]
[{"$f":"'GENERAL FUND Estimates'!B6","v":"Dues and Subscriptions"},{"$f":"'GENERAL FUND Estimates'!F6","v":170},1,{"$f":"B8/C8","v":170},{"$f":"D8/12","v":14.166666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E8/F8","v":0.88541666666666663}]
[{"$f":"'GENERAL FUND Estimates'!B7","v":0},{"$f":"'GENERAL FUND Estimates'!F7","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B8","v":"Supplies, Business"},{"$f":"'GENERAL FUND Estimates'!F8","v":300},1,300,25,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.5625]
[{"$f":"'GENERAL FUND Estimates'!B9","v":"Bank Charge"},{"$f":"'GENERAL FUND Estimates'!F9","v":10},1,10,0.83333333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},5.2083333333333336E-2]
[{"$f":"'GENERAL FUND Estimates'!B10","v":"Business, Other"},{"$f":"'GENERAL FUND Estimates'!F10","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[{"$f":"'GENERAL FUND Estimates'!B11","v":"Grounds Improvement"},{"$f":"'GENERAL FUND Estimates'!F11","v":500},1,500,41.666666666666664,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},2.6041666666666665]
[{"$f":"'GENERAL FUND Estimates'!B12","v":"Landscaping Repayment"},{"$f":"'GENERAL FUND Estimates'!F12","v":600},1,600,50,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},3.125]
[{"$f":"'GENERAL FUND Estimates'!B13","v":"Lawn Care"},{"$f":"'GENERAL FUND Estimates'!F13","v":7570},1,7570,630.83333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},39.427083333333336]
[{"$f":"'GENERAL FUND Estimates'!B14","v":"Snow Removal"},{"$f":"'GENERAL FUND Estimates'!F14","v":4725},1,4725,393.75,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},24.609375]
[{"$f":"'GENERAL FUND Estimates'!B15","v":"Wireless Internet"},{"$f":"'GENERAL FUND Estimates'!F15","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B16","v":"Discretionary, Other"},{"$f":"'GENERAL FUND Estimates'!F16","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B17","v":"Electric House Meter 1"},{"$f":"'GENERAL FUND Estimates'!F17","v":200},1,200,16.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.0416666666666667]
[{"$f":"'GENERAL FUND Estimates'!B18","v":"Electric House Meter 2"},{"$f":"'GENERAL FUND Estimates'!F18","v":260},1,260,21.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3541666666666667]
[{"$f":"'GENERAL FUND Estimates'!B19","v":"Water and Sewer"},{"$f":"'GENERAL FUND Estimates'!F19","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B20","v":"Mandatory, Other"},{"$f":"'GENERAL FUND Estimates'!F20","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[]
["Total Shared General Funds",{"$f":"SUM(B7:B22)","v":15045},null,{"$f":"SUM(D7:D22)","v":15045},{"$f":"SUM(E7:E22)","v":1253.75},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"SUM(G7:G22)","v":78.359375}]
[]
["Reserve Fund","Total Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"CONCATENATE('RESERVE Cost Estimates'!B7,\" *\")","v":"Roofing Accrual *"},{"$f":"'RESERVE Cost Estimates'!G8","v":56801.992891000002},{"$f":"roofing_recurrence_A","v":20},{"$f":"B28/C28","v":2840.09964455},{"$f":"D28/12","v":236.67497037916667},{"$f":"'Tables & References'!$C$11","v":8},{"$f":"E28/F28","v":29.584371297395833}]
[{"$f":"'RESERVE Cost Estimates'!B16","v":"Road Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G17","v":6414},{"$f":"road_recurrence","v":3},{"$f":"B29/C29","v":2138},{"$f":"D29/12","v":178.16666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E29/F29","v":11.135416666666666}]
[{"$f":"'RESERVE Cost Estimates'!B19","v":"Painting/Power Washing Accrual"},{"$f":"'RESERVE Cost Estimates'!G20","v":2615},{"$f":"painting_recurrence","v":6},435.83333333333331,36.319444444444443,{"$f":"'Tables & References'!$C$11","v":8},4.5399305555555554]
[{"$f":"'RESERVE Cost Estimates'!B27","v":"General Building Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G28","v":2138},{"$f":"maintenance_recurrence","v":1},2138,178.16666666666666,{"$f":"'Tables & References'!$C$11","v":8},22.270833333333332]
[{"$f":"'RESERVE Cost Estimates'!B35","v":"Insurance Accrual"},{"$f":"'RESERVE Cost Estimates'!G36","v":5800},{"$f":"Insurance_recurrence","v":1},5800,483.33333333333331,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},30.208333333333332]
[{"$f":"'RESERVE Cost Estimates'!B38","v":"Legal-Professional Fees Accrual"},{"$f":"'RESERVE Cost Estimates'!G39","v":1200},{"$f":"Legal_Fees_recurrence","v":1},1200,100,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},6.25]
[]
["Total Reserve Funds",{"$f":"SUM(B28:B34)","v":74968.992891000002},null,{"$f":"SUM(D28:D34)","v":14551.932977883334},{"$f":"SUM(E28:E34)","v":1212.6610814902776},{"$f":"'Tables & References'!$C$11","v":8},{"$f":"SUM(G28:G33)","v":103.98888518628472}]
[]
["Total Monthly Fee (Rounded Up)",null,null,null,null,null,{"$f":"ROUNDUP(SUM(G24,G35),0)","v":183}]
[]
["* The \"normal\" roofing replacement is calculated based on a \"30-year\" roof.  However, since the accrual fund for this expense was not estabished until several years after the building of 1270, 1272, and 1274, these units are calculated as \"20-year\" roofs to \"catch up\" to those years where no monies were accrued."]

{"sheet":"Costs by Unit 1272","index":10,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,4]]}
["Hilary Heights Condominium Owners Association"]
["A Cost & Fee Analysis by Unit",null,null,"for the budget year of",{"$f":"current_budget_year","v":2019},"Unit",1272]
[null,null,null,"This Budget was approved by the Board of Directors on:",{"$f":"Approval_Date","v":"Sept 8th, 2018"}]
[]
["General Fund Expense (Shared by ALL Units)","Total Annual Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"'GENERAL FUND Estimates'!B5","v":"Administration Fee"},{"$f":"'GENERAL FUND Estimates'!F5","v":10},1,{"$f":"B7/C7","v":10},{"$f":"D7/12","v":0.83333333333333337},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E7/F7","v":5.2083333333333336E-2}]
[{"$f":"'GENERAL FUND Estimates'!B6","v":"Dues and Subscriptions"},{"$f":"'GENERAL FUND Estimates'!F6","v":170},1,{"$f":"B8/C8","v":170},{"$f":"D8/12","v":14.166666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E8/F8","v":0.88541666666666663}]
[{"$f":"'GENERAL FUND Estimates'!B7","v":0},{"$f":"'GENERAL FUND Estimates'!F7","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B8","v":"Supplies, Business"},{"$f":"'GENERAL FUND Estimates'!F8","v":300},1,300,25,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.5625]
[{"$f":"'GENERAL FUND Estimates'!B9","v":"Bank Charge"},{"$f":"'GENERAL FUND Estimates'!F9","v":10},1,10,0.83333333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},5.2083333333333336E-2]
[{"$f":"'GENERAL FUND Estimates'!B10","v":"Business, Other"},{"$f":"'GENERAL FUND Estimates'!F10","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[{"$f":"'GENERAL FUND Estimates'!B11","v":"Grounds Improvement"},{"$f":"'GENERAL FUND Estimates'!F11","v":500},1,500,41.666666666666664,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},2.6041666666666665]
[{"$f":"'GENERAL FUND Estimates'!B12","v":"Landscaping Repayment"},{"$f":"'GENERAL FUND Estimates'!F12","v":600},1,600,50,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},3.125]
[{"$f":"'GENERAL FUND Estimates'!B13","v":"Lawn Care"},{"$f":"'GENERAL FUND Estimates'!F13","v":7570},1,7570,630.83333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},39.427083333333336]
[{"$f":"'GENERAL FUND Estimates'!B14","v":"Snow Removal"},{"$f":"'GENERAL FUND Estimates'!F14","v":4725},1,4725,393.75,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},24.609375]
[{"$f":"'GENERAL FUND Estimates'!B15","v":"Wireless Internet"},{"$f":"'GENERAL FUND Estimates'!F15","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B16","v":"Discretionary, Other"},{"$f":"'GENERAL FUND Estimates'!F16","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B17","v":"Electric House Meter 1"},{"$f":"'GENERAL FUND Estimates'!F17","v":200},1,200,16.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.0416666666666667]
[{"$f":"'GENERAL FUND Estimates'!B18","v":"Electric House Meter 2"},{"$f":"'GENERAL FUND Estimates'!F18","v":260},1,260,21.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3541666666666667]
[{"$f":"'GENERAL FUND Estimates'!B19","v":"Water and Sewer"},{"$f":"'GENERAL FUND Estimates'!F19","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B20","v":"Mandatory, Other"},{"$f":"'GENERAL FUND Estimates'!F20","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[]
["Total Shared General Funds",{"$f":"SUM(B7:B22)","v":15045},null,{"$f":"SUM(D7:D22)","v":15045},{"$f":"SUM(E7:E22)","v":1253.75},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"SUM(G7:G22)","v":78.359375}]
[]
["Reserve Fund","Total Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"CONCATENATE('RESERVE Cost Estimates'!B7,\" *\")","v":"Roofing Accrual *"},{"$f":"'RESERVE Cost Estimates'!G9","v":28359.336095999999},{"$f":"roofing_recurrence_A","v":20},{"$f":"B28/C28","v":1417.9668047999999},{"$f":"D28/12","v":118.16390039999999},{"$f":"'Tables & References'!C12","v":2},{"$f":"E28/F28","v":59.081950199999994}]
[{"$f":"'RESERVE Cost Estimates'!B16","v":"Road Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G17","v":6414},{"$f":"road_recurrence","v":3},{"$f":"B29/C29","v":2138},{"$f":"D29/12","v":178.16666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E29/F29","v":11.135416666666666}]
[{"$f":"'RESERVE Cost Estimates'!B19","v":"Painting/Power Washing Accrual"},{"$f":"'RESERVE Cost Estimates'!G21","v":1817.3},{"$f":"painting_recurrence","v":6},302.88333333333333,25.240277777777777,{"$f":"'Tables & References'!C12","v":2},12.620138888888889]
[{"$f":"'RESERVE Cost Estimates'!B27","v":"General Building Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G29","v":801.75},{"$f":"maintenance_recurrence","v":1},801.75,66.8125,{"$f":"'Tables & References'!C12","v":2},33.40625]
[{"$f":"'RESERVE Cost Estimates'!B35","v":"Insurance Accrual"},{"$f":"'RESERVE Cost Estimates'!G36","v":5800},{"$f":"Insurance_recurrence","v":1},5800,483.33333333333331,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},30.208333333333332]
[{"$f":"'RESERVE Cost Estimates'!B38","v":"Legal-Professional Fees Accrual"},{"$f":"'RESERVE Cost Estimates'!G39","v":1200},{"$f":"Legal_Fees_recurrence","v":1},1200,100,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},6.25]
[]
["Total Reserve Funds",{"$f":"SUM(B28:B34)","v":44392.386096000002},null,{"$f":"SUM(D28:D34)","v":11660.600138133334},{"$f":"SUM(E28:E34)","v":971.71667817777779},{"$f":"'Tables & References'!$C$11","v":8},{"$f":"SUM(G28:G33)","v":152.7020890888889}]
[]
["Total Monthly Fee (Rounded Up)",null,null,null,null,null,{"$f":"ROUNDUP(SUM(G24,G35),0)","v":232}]
[]
["* The \"normal\" roofing replacement is calculated based on a \"30-year\" roof.  However, since the accrual fund for this expense was not estabished until several years after the building of 1270, 1272, and 1274, these units are calculated as \"20-year\" roofs to \"catch up\" to those years where no monies were accrued."]

{"sheet":"Costs by Unit 1274","index":11,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,4]]}
["Hilary Heights Condominium Owners Association"]
["A Cost & Fee Analysis by Unit",null,null,"for the budget year of",{"$f":"current_budget_year","v":2019},"Unit",1274]
[null,null,null,"This Budget was approved by the Board of Directors on:",{"$f":"Approval_Date","v":"Sept 8th, 2018"}]
[]
["General Fund Expense (Shared by ALL Units)","Total Annual Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"'GENERAL FUND Estimates'!B5","v":"Administration Fee"},{"$f":"'GENERAL FUND Estimates'!F5","v":10},1,{"$f":"B7/C7","v":10},{"$f":"D7/12","v":0.83333333333333337},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E7/F7","v":5.2083333333333336E-2}]
[{"$f":"'GENERAL FUND Estimates'!B6","v":"Dues and Subscriptions"},{"$f":"'GENERAL FUND Estimates'!F6","v":170},1,{"$f":"B8/C8","v":170},{"$f":"D8/12","v":14.166666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E8/F8","v":0.88541666666666663}]
[{"$f":"'GENERAL FUND Estimates'!B7","v":0},{"$f":"'GENERAL FUND Estimates'!F7","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B8","v":"Supplies, Business"},{"$f":"'GENERAL FUND Estimates'!F8","v":300},1,300,25,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.5625]
[{"$f":"'GENERAL FUND Estimates'!B9","v":"Bank Charge"},{"$f":"'GENERAL FUND Estimates'!F9","v":10},1,10,0.83333333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},5.2083333333333336E-2]
[{"$f":"'GENERAL FUND Estimates'!B10","v":"Business, Other"},{"$f":"'GENERAL FUND Estimates'!F10","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[{"$f":"'GENERAL FUND Estimates'!B11","v":"Grounds Improvement"},{"$f":"'GENERAL FUND Estimates'!F11","v":500},1,500,41.666666666666664,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},2.6041666666666665]
[{"$f":"'GENERAL FUND Estimates'!B12","v":"Landscaping Repayment"},{"$f":"'GENERAL FUND Estimates'!F12","v":600},1,600,50,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},3.125]
[{"$f":"'GENERAL FUND Estimates'!B13","v":"Lawn Care"},{"$f":"'GENERAL FUND Estimates'!F13","v":7570},1,7570,630.83333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},39.427083333333336]
[{"$f":"'GENERAL FUND Estimates'!B14","v":"Snow Removal"},{"$f":"'GENERAL FUND Estimates'!F14","v":4725},1,4725,393.75,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},24.609375]
[{"$f":"'GENERAL FUND Estimates'!B15","v":"Wireless Internet"},{"$f":"'GENERAL FUND Estimates'!F15","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B16","v":"Discretionary, Other"},{"$f":"'GENERAL FUND Estimates'!F16","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B17","v":"Electric House Meter 1"},{"$f":"'GENERAL FUND Estimates'!F17","v":200},1,200,16.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.0416666666666667]
[{"$f":"'GENERAL FUND Estimates'!B18","v":"Electric House Meter 2"},{"$f":"'GENERAL FUND Estimates'!F18","v":260},1,260,21.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3541666666666667]
[{"$f":"'GENERAL FUND Estimates'!B19","v":"Water and Sewer"},{"$f":"'GENERAL FUND Estimates'!F19","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B20","v":"Mandatory, Other"},{"$f":"'GENERAL FUND Estimates'!F20","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[]
["Total Shared General Funds",{"$f":"SUM(B7:B22)","v":15045},null,{"$f":"SUM(D7:D22)","v":15045},{"$f":"SUM(E7:E22)","v":1253.75},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"SUM(G7:G22)","v":78.359375}]
[]
["Reserve Fund","Total Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"CONCATENATE('RESERVE Cost Estimates'!B7,\" *\")","v":"Roofing Accrual *"},{"$f":"'RESERVE Cost Estimates'!G10","v":30621.200000000001},{"$f":"roofing_recurrence_A","v":20},{"$f":"B28/C28","v":1531.06},{"$f":"D28/12","v":127.58833333333332},{"$f":"'Tables & References'!C13","v":2},{"$f":"E28/F28","v":63.794166666666662}]
[{"$f":"'RESERVE Cost Estimates'!B16","v":"Road Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G17","v":6414},{"$f":"road_recurrence","v":3},{"$f":"B29/C29","v":2138},{"$f":"D29/12","v":178.16666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E29/F29","v":11.135416666666666}]
[{"$f":"'RESERVE Cost Estimates'!B19","v":"Painting/Power Washing Accrual"},{"$f":"'RESERVE Cost Estimates'!G22","v":1069},{"$f":"painting_recurrence","v":6},178.16666666666666,14.847222222222221,{"$f":"'Tables & References'!C13","v":2},7.4236111111111107]
[{"$f":"'RESERVE Cost Estimates'!B27","v":"General Building Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G30","v":801.75},{"$f":"maintenance_recurrence","v":1},801.75,66.8125,{"$f":"'Tables & References'!C13","v":2},33.40625]
[{"$f":"'RESERVE Cost Estimates'!B35","v":"Insurance Accrual"},{"$f":"'RESERVE Cost Estimates'!G36","v":5800},{"$f":"Insurance_recurrence","v":1},5800,483.33333333333331,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},30.208333333333332]
[{"$f":"'RESERVE Cost Estimates'!B38","v":"Legal-Professional Fees Accrual"},{"$f":"'RESERVE Cost Estimates'!G39","v":1200},{"$f":"Legal_Fees_recurrence","v":1},1200,100,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},6.25]
[]
["Total Reserve Funds",{"$f":"SUM(B28:B34)","v":45905.95},null,{"$f":"SUM(D28:D34)","v":11648.976666666666},{"$f":"SUM(E28:E34)","v":970.74805555555554},{"$f":"'Tables & References'!$C$11","v":8},{"$f":"SUM(G28:G33)","v":152.21777777777777}]
[]
["Total Monthly Fee (Rounded Up)",null,null,null,null,null,{"$f":"ROUNDUP(SUM(G24,G35),0)","v":231}]
[]
["* The \"normal\" roofing replacement is calculated based on a \"30-year\" roof.  However, since the accrual fund for this expense was not estabished until several years after the building of 1270, 1272, and 1274, these units are calculated as \"20-year\" roofs to \"catch up\" to those years where no monies were accrued."]

{"sheet":"Costs by Unit 1276","index":12,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,4]]}
["Hilary Heights Condominium Owners Association"]
["A Cost & Fee Analysis by Unit",null,null,"for the budget year of",{"$f":"current_budget_year","v":2019},"Unit",1276]
[null,null,null,"This Budget was approved by the Board of Directors on:",{"$f":"Approval_Date","v":"Sept 8th, 2018"}]
[]
["General Fund Expense (Shared by ALL Units)","Total Annual Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"'GENERAL FUND Estimates'!B5","v":"Administration Fee"},{"$f":"'GENERAL FUND Estimates'!F5","v":10},1,{"$f":"B7/C7","v":10},{"$f":"D7/12","v":0.83333333333333337},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E7/F7","v":5.2083333333333336E-2}]
[{"$f":"'GENERAL FUND Estimates'!B6","v":"Dues and Subscriptions"},{"$f":"'GENERAL FUND Estimates'!F6","v":170},1,{"$f":"B8/C8","v":170},{"$f":"D8/12","v":14.166666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E8/F8","v":0.88541666666666663}]
[{"$f":"'GENERAL FUND Estimates'!B7","v":0},{"$f":"'GENERAL FUND Estimates'!F7","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B8","v":"Supplies, Business"},{"$f":"'GENERAL FUND Estimates'!F8","v":300},1,300,25,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.5625]
[{"$f":"'GENERAL FUND Estimates'!B9","v":"Bank Charge"},{"$f":"'GENERAL FUND Estimates'!F9","v":10},1,10,0.83333333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},5.2083333333333336E-2]
[{"$f":"'GENERAL FUND Estimates'!B10","v":"Business, Other"},{"$f":"'GENERAL FUND Estimates'!F10","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[{"$f":"'GENERAL FUND Estimates'!B11","v":"Grounds Improvement"},{"$f":"'GENERAL FUND Estimates'!F11","v":500},1,500,41.666666666666664,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},2.6041666666666665]
[{"$f":"'GENERAL FUND Estimates'!B12","v":"Landscaping Repayment"},{"$f":"'GENERAL FUND Estimates'!F12","v":600},1,600,50,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},3.125]
[{"$f":"'GENERAL FUND Estimates'!B13","v":"Lawn Care"},{"$f":"'GENERAL FUND Estimates'!F13","v":7570},1,7570,630.83333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},39.427083333333336]
[{"$f":"'GENERAL FUND Estimates'!B14","v":"Snow Removal"},{"$f":"'GENERAL FUND Estimates'!F14","v":4725},1,4725,393.75,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},24.609375]
[{"$f":"'GENERAL FUND Estimates'!B15","v":"Wireless Internet"},{"$f":"'GENERAL FUND Estimates'!F15","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B16","v":"Discretionary, Other"},{"$f":"'GENERAL FUND Estimates'!F16","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B17","v":"Electric House Meter 1"},{"$f":"'GENERAL FUND Estimates'!F17","v":200},1,200,16.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.0416666666666667]
[{"$f":"'GENERAL FUND Estimates'!B18","v":"Electric House Meter 2"},{"$f":"'GENERAL FUND Estimates'!F18","v":260},1,260,21.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3541666666666667]
[{"$f":"'GENERAL FUND Estimates'!B19","v":"Water and Sewer"},{"$f":"'GENERAL FUND Estimates'!F19","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B20","v":"Mandatory, Other"},{"$f":"'GENERAL FUND Estimates'!F20","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[]
["Total Shared General Funds",{"$f":"SUM(B7:B22)","v":15045},null,{"$f":"SUM(D7:D22)","v":15045},{"$f":"SUM(E7:E22)","v":1253.75},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"SUM(G7:G22)","v":78.359375}]
[]
["Reserve Fund","Total Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"CONCATENATE('RESERVE Cost Estimates'!B7,\" *\")","v":"Roofing Accrual *"},{"$f":"'RESERVE Cost Estimates'!G11","v":27052.174999999999},{"$f":"roofing_recurrence_B","v":30},{"$f":"B28/C28","v":901.73916666666662},{"$f":"D28/12","v":75.144930555555547},{"$f":"'Tables & References'!C14","v":2},{"$f":"E28/F28","v":37.572465277777773}]
[{"$f":"'RESERVE Cost Estimates'!B16","v":"Road Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G17","v":6414},{"$f":"road_recurrence","v":3},{"$f":"B29/C29","v":2138},{"$f":"D29/12","v":178.16666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E29/F29","v":11.135416666666666}]
[{"$f":"'RESERVE Cost Estimates'!B19","v":"Painting/Power Washing Accrual"},{"$f":"'RESERVE Cost Estimates'!G23","v":855.2},{"$f":"painting_recurrence","v":6},142.53333333333333,11.877777777777778,{"$f":"'Tables & References'!C14","v":2},5.9388888888888891]
[{"$f":"'RESERVE Cost Estimates'!B27","v":"General Building Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G31","v":801.75},{"$f":"maintenance_recurrence","v":1},801.75,66.8125,{"$f":"'Tables & References'!$C$14","v":2},33.40625]
[{"$f":"'RESERVE Cost Estimates'!B35","v":"Insurance Accrual"},{"$f":"'RESERVE Cost Estimates'!G36","v":5800},{"$f":"Insurance_recurrence","v":1},5800,483.33333333333331,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},30.208333333333332]
[{"$f":"'RESERVE Cost Estimates'!B38","v":"Legal-Professional Fees Accrual"},{"$f":"'RESERVE Cost Estimates'!G39","v":1200},{"$f":"Legal_Fees_recurrence","v":1},1200,100,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},6.25]
[]
["Total Reserve Funds",{"$f":"SUM(B28:B34)","v":42123.125},null,{"$f":"SUM(D28:D34)","v":10984.022499999999},{"$f":"SUM(E28:E34)","v":915.3352083333333},{"$f":"'Tables & References'!$C$11","v":8},{"$f":"SUM(G28:G33)","v":124.51135416666666}]
[]
["Total Monthly Fee (Rounded Up)",null,null,null,null,null,{"$f":"ROUNDUP(SUM(G24,G35),0)","v":203}]
[]
["* The \"normal\" roofing replacement is calculated based on a \"30-year\" roof.  However, since the accrual fund for this expense was not estabished until several years after the building of 1270, 1272, and 1274, these units are calculated as \"20-year\" roofs to \"catch up\" to those years where no monies were accrued."]

{"sheet":"Costs by Unit 1278","index":13,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,0,38,4]]}
["Hilary Heights Condominium Owners Association"]
["A Cost & Fee Analysis by Unit",null,null,"for the budget year of",{"$f":"current_budget_year","v":2019},"Unit",1278]
[null,null,null,"This Budget was approved by the Board of Directors on:",{"$f":"Approval_Date","v":"Sept 8th, 2018"}]
[]
["General Fund Expense (Shared by ALL Units)","Total Annual Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"'GENERAL FUND Estimates'!B5","v":"Administration Fee"},{"$f":"'GENERAL FUND Estimates'!F5","v":10},1,{"$f":"B7/C7","v":10},{"$f":"D7/12","v":0.83333333333333337},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E7/F7","v":5.2083333333333336E-2}]
[{"$f":"'GENERAL FUND Estimates'!B6","v":"Dues and Subscriptions"},{"$f":"'GENERAL FUND Estimates'!F6","v":170},1,{"$f":"B8/C8","v":170},{"$f":"D8/12","v":14.166666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E8/F8","v":0.88541666666666663}]
[{"$f":"'GENERAL FUND Estimates'!B7","v":0},{"$f":"'GENERAL FUND Estimates'!F7","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B8","v":"Supplies, Business"},{"$f":"'GENERAL FUND Estimates'!F8","v":300},1,300,25,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.5625]
[{"$f":"'GENERAL FUND Estimates'!B9","v":"Bank Charge"},{"$f":"'GENERAL FUND Estimates'!F9","v":10},1,10,0.83333333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},5.2083333333333336E-2]
[{"$f":"'GENERAL FUND Estimates'!B10","v":"Business, Other"},{"$f":"'GENERAL FUND Estimates'!F10","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[{"$f":"'GENERAL FUND Estimates'!B11","v":"Grounds Improvement"},{"$f":"'GENERAL FUND Estimates'!F11","v":500},1,500,41.666666666666664,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},2.6041666666666665]
[{"$f":"'GENERAL FUND Estimates'!B12","v":"Landscaping Repayment"},{"$f":"'GENERAL FUND Estimates'!F12","v":600},1,600,50,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},3.125]
[{"$f":"'GENERAL FUND Estimates'!B13","v":"Lawn Care"},{"$f":"'GENERAL FUND Estimates'!F13","v":7570},1,7570,630.83333333333337,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},39.427083333333336]
[{"$f":"'GENERAL FUND Estimates'!B14","v":"Snow Removal"},{"$f":"'GENERAL FUND Estimates'!F14","v":4725},1,4725,393.75,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},24.609375]
[{"$f":"'GENERAL FUND Estimates'!B15","v":"Wireless Internet"},{"$f":"'GENERAL FUND Estimates'!F15","v":0},1,0,0,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0]
[{"$f":"'GENERAL FUND Estimates'!B16","v":"Discretionary, Other"},{"$f":"'GENERAL FUND Estimates'!F16","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B17","v":"Electric House Meter 1"},{"$f":"'GENERAL FUND Estimates'!F17","v":200},1,200,16.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.0416666666666667]
[{"$f":"'GENERAL FUND Estimates'!B18","v":"Electric House Meter 2"},{"$f":"'GENERAL FUND Estimates'!F18","v":260},1,260,21.666666666666668,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3541666666666667]
[{"$f":"'GENERAL FUND Estimates'!B19","v":"Water and Sewer"},{"$f":"'GENERAL FUND Estimates'!F19","v":250},1,250,20.833333333333332,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},1.3020833333333333]
[{"$f":"'GENERAL FUND Estimates'!B20","v":"Mandatory, Other"},{"$f":"'GENERAL FUND Estimates'!F20","v":100},1,100,8.3333333333333339,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},0.52083333333333337]
[]
["Total Shared General Funds",{"$f":"SUM(B7:B22)","v":15045},null,{"$f":"SUM(D7:D22)","v":15045},{"$f":"SUM(E7:E22)","v":1253.75},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"(SUM(G7:G22))","v":78.359375}]
[]
["Reserve Fund","Total Budgeted Expense","Recurrence in Years","Cost per Year","Cost per Month","No. Units","Cost per Unit per month"]
[]
[{"$f":"CONCATENATE('RESERVE Cost Estimates'!B7,\" *\")","v":"Roofing Accrual *"},{"$f":"'RESERVE Cost Estimates'!G12","v":27052.174999999999},{"$f":"roofing_recurrence_c","v":30},{"$f":"B28/C28","v":901.73916666666662},{"$f":"D28/12","v":75.144930555555547},{"$f":"'Tables & References'!C15","v":2},{"$f":"E28/F28","v":37.572465277777773}]
[{"$f":"'RESERVE Cost Estimates'!B16","v":"Road Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G17","v":6414},{"$f":"road_recurrence","v":3},{"$f":"B29/C29","v":2138},{"$f":"D29/12","v":178.16666666666666},{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},{"$f":"E29/F29","v":11.135416666666666}]
[{"$f":"'RESERVE Cost Estimates'!B19","v":"Painting/Power Washing Accrual"},{"$f":"'RESERVE Cost Estimates'!G24","v":641.4},{"$f":"painting_recurrence","v":6},106.89999999999999,8.9083333333333332,{"$f":"'Tables & References'!C15","v":2},4.4541666666666666]
[{"$f":"'RESERVE Cost Estimates'!B27","v":"General Building Maintenance Accrual"},{"$f":"'RESERVE Cost Estimates'!G32","v":213.8},{"$f":"maintenance_recurrence","v":1},213.8,17.816666666666666,{"$f":"'Tables & References'!C15","v":2},8.9083333333333332]
[{"$f":"'RESERVE Cost Estimates'!B35","v":"Insurance Accrual"},{"$f":"'RESERVE Cost Estimates'!G36","v":5800},{"$f":"Insurance_recurrence","v":1},5800,483.33333333333331,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},30.208333333333332]
[{"$f":"'RESERVE Cost Estimates'!B38","v":"Legal-Professional Fees Accrual"},{"$f":"'RESERVE Cost Estimates'!G39","v":1200},{"$f":"Legal_Fees_recurrence","v":1},1200,100,{"$f":"SUM('Tables & References'!$C$11:$C$16)","v":16},6.25]
[]
["Total Reserve Funds",{"$f":"SUM(B28:B34)","v":41321.375000000007},null,{"$f":"SUM(D28:D34)","v":10360.439166666667},{"$f":"SUM(E28:E34)","v":863.36993055555558},{"$f":"'Tables & References'!$C$11","v":8},{"$f":"(SUM(G28:G33))","v":98.528715277777764}]
[]
["Total Monthly Fee (Rounded Up)",null,null,null,null,null,{"$f":"ROUNDUP(SUM(G24,G35),0)","v":177}]
[]
["* The \"normal\" roofing replacement is calculated based on a \"30-year\" roof.  However, since the accrual fund for this expense was not estabished until several years after the building of 1270, 1272, and 1274, these units are calculated as \"20-year\" roofs to \"catch up\" to those years where no monies were accrued."]

{"sheet":"Calculated Budget Report","index":14,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,1,0,3],[2,1,2,3]]}
[null,"CONDOMINIUM OWNERS' ASSOCIATION"]
[]
[null,{"$f":"CONCATENATE(\"Annual Operating Budget for the Year of\",\" \",current_budget_year)","v":"Annual Operating Budget for the Year of 2019"}]
[null,"Category/Account","Month","Year"]
[]
[null,"GENERAL FUND (Checking - Cleveland State Bank)"]
[]
[null,"Income"]
[null,"Business Income",null,null,null,"Year Check"]
[null,"Association Dues"]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T7,\" \",\"(Dues per Unit @\",\" \",\"$\",ROUNDUP(Calculations!U7,0),\")\")","v":"Building 1270 (Dues per Unit @ $183)"},{"$f":"Calculations!Y7","v":1464},{"$f":"Calculations!Z7","v":17568},null,{"$f":"C11*12","v":17568},{"$f":"IF(F11=D11,\"OK\",\"ERROR\")","v":"OK"}]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T8,\" \",\"(Dues per Unit @\",\" \",\"$\",ROUNDUP(Calculations!U8,0),\")\")","v":"Building 1272 (Dues per Unit @ $232)"},{"$f":"Calculations!Y8","v":464},{"$f":"Calculations!Z8","v":5568},null,{"$f":"C12*12","v":5568},{"$f":"IF(F12=D12,\"OK\",\"ERROR\")","v":"OK"}]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T9,\" \",\"(Dues per Unit @\",\" \",\"$\",ROUNDUP(Calculations!U9,0),\")\")","v":"Building 1274 (Dues per Unit @ $231)"},{"$f":"Calculations!Y9","v":462},{"$f":"Calculations!Z9","v":5544},null,5544,"OK"]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T10,\" \",\"(Dues per Unit @\",\" \",\"$\",ROUNDUP(Calculations!U10,0),\")\")","v":"Building 1276 (Dues per Unit @ $203)"},{"$f":"Calculations!Y10","v":406},{"$f":"Calculations!Z10","v":4872},null,4872,"OK"]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T11,\" \",\"(Dues per Unit @\",\" \",\"$\",ROUNDUP(Calculations!U11,0),\")\")","v":"Building 1278 (Dues per Unit @ $177)"},{"$f":"Calculations!Y11","v":354},{"$f":"Calculations!Z11","v":4248},null,4248,"OK"]
[null,null,{"$f":"Calculations!Y12","v":""},{"$f":"Calculations!Z12","v":""}]
[null,null,null,null,null,0,"OK"]
[null,"Total Income",{"$f":"SUM(C11:C17)","v":3150},{"$f":"SUM(D11:D17)","v":37800},null,37800,"OK"]
[null,null,null,null,null,0,"OK"]
[null,"Expenses",null,null,null,0,"OK"]
[null,null,null,null,null,0,"OK"]
[null,"Business Expense",null,null,null,0,"OK"]
[null,{"$f":"Calculations!L7","v":"Administration Fee"},{"$f":"Calculations!R7","v":0.83333333333333337},{"$f":"Calculations!Q7","v":10},null,10,"OK"]
[null,{"$f":"Calculations!L8","v":"Dues and Subscriptions"},{"$f":"Calculations!R8","v":14.166666666666666},{"$f":"Calculations!Q8","v":170},null,170,"OK"]
[null,{"$f":"Calculations!L9","v":""},{"$f":"Calculations!R9","v":""},{"$f":"Calculations!Q9","v":""},null,null,"OK"]
[null,{"$f":"Calculations!L10","v":"Supplies, Business"},{"$f":"Calculations!R10","v":25},{"$f":"Calculations!Q10","v":300},null,300,"OK"]
[null,{"$f":"Calculations!L11","v":"Bank Charge"},{"$f":"Calculations!R11","v":0.83333333333333337},{"$f":"Calculations!Q11","v":10},null,10,"OK"]
[null,{"$f":"Calculations!L12","v":"Business, Other"},{"$f":"Calculations!R12","v":8.3333333333333339},{"$f":"Calculations!Q12","v":100},null,100,"OK"]
[null,"Sub-Total Business Expenses",{"$f":"SUM(C23:C28)","v":49.166666666666671},{"$f":"SUM(D23:D28)","v":590},null,590,"OK"]
[null,null,null,null,null,0,"OK"]
[null,"Discretionary",null,null,null,0,"OK"]
[null,{"$f":"Calculations!L13","v":"Grounds Improvement"},{"$f":"Calculations!R13","v":41.666666666666664},{"$f":"Calculations!Q13","v":500},null,500,"OK"]
[null,{"$f":"Calculations!L14","v":"Landscaping Repayment"},{"$f":"Calculations!R14","v":50},{"$f":"Calculations!Q14","v":600},null,600,"OK"]
[null,{"$f":"Calculations!L15","v":"Lawn Care"},{"$f":"Calculations!R15","v":630.83333333333337},{"$f":"Calculations!Q15","v":7570},null,7570,"OK"]
[null,{"$f":"Calculations!L16","v":"Snow Removal"},{"$f":"Calculations!R16","v":393.75},{"$f":"Calculations!Q16","v":4725},null,4725,"OK"]
[null,{"$f":"Calculations!L17","v":"Wireless Internet"},{"$f":"Calculations!R17","v":0},{"$f":"Calculations!Q17","v":0},null,0,"OK"]
[null,{"$f":"Calculations!L18","v":"Discretionary, Other"},{"$f":"Calculations!R18","v":20.833333333333332},{"$f":"Calculations!Q18","v":250},null,250,"OK"]
[null,"Sub-Total Discretionary Expenses",{"$f":"SUM(C32:C37)","v":1137.0833333333333},{"$f":"SUM(D32:D37)","v":13645},null,{"$f":"C41*12","v":200},{"$f":"IF(F38=D41,\"OK\",\"ERROR\")","v":"OK"}]
[null,null,null,null,null,{"$f":"C38*12","v":13645},{"$f":"IF(F39=D38,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Mandatory",null,null,null,{"$f":"C39*12","v":0},{"$f":"IF(F40=D39,\"OK\",\"ERROR\")","v":"OK"}]
[null,{"$f":"Calculations!L19","v":"Electric House Meter 1"},{"$f":"Calculations!R19","v":16.666666666666668},{"$f":"Calculations!Q19","v":200},null,{"$f":"C40*12","v":0},{"$f":"IF(F41=D40,\"OK\",\"ERROR\")","v":"OK"}]
[null,{"$f":"Calculations!L20","v":"Electric House Meter 2"},{"$f":"Calculations!R20","v":21.666666666666668},{"$f":"Calculations!Q20","v":260},null,{"$f":"C42*12","v":260},{"$f":"IF(F42=D42,\"OK\",\"ERROR\")","v":"OK"}]
[null,{"$f":"Calculations!L21","v":"Water and Sewer"},{"$f":"Calculations!R21","v":20.833333333333332},{"$f":"Calculations!Q21","v":250},null,{"$f":"C43*12","v":250},{"$f":"IF(F43=D43,\"OK\",\"ERROR\")","v":"OK"}]
[null,{"$f":"Calculations!L22","v":"Mandatory, Other"},{"$f":"Calculations!R22","v":8.3333333333333339},{"$f":"Calculations!Q22","v":100},null,{"$f":"C44*12","v":100},{"$f":"IF(F44=D44,\"OK\",\"ERROR\")","v":"OK"}]
[null,{"$f":"Calculations!L23","v":""},{"$f":"Calculations!R23","v":""},{"$f":"Calculations!Q23","v":""}]
[null,"Sub-Total Mandatory Expenses",{"$f":"SUM(C41:C45)","v":67.5},{"$f":"SUM(D41:D45)","v":810},null,{"$f":"C46*12","v":810},{"$f":"IF(F46=D46,\"OK\",\"ERROR\")","v":"OK"}]
[null,null,null,null,null,0,"OK"]
[null,null,null,null,null,0,"OK"]
[null,"Total Expenses - General Fund",{"$f":"SUM(C29,C38,C46,C48)","v":1253.75},{"$f":"SUM(D29,D38,D46,D48)","v":15045},null,{"$f":"C49*12","v":15045},{"$f":"IF(F49=D49,\"OK\",\"ERROR\")","v":"OK"}]
[null,null,null,null,null,0,"OK"]
[null,"RESERVE FUND (Savings - Cleveland State Bank)",null,null,null,{"$f":"C51*12","v":0},{"$f":"IF(F51=D51,\"OK\",\"ERROR\")","v":"OK"}]
[null,"Roofing Accrual",{"$f":"Calculations!I13","v":632.71706522361103},{"$f":"Calculations!H13","v":7592.6047826833328},null,7592.6047826833328,"OK"]
[null,"Road Maintenance Accrual",{"$f":"Calculations!I16","v":178.16666666666666},{"$f":"Calculations!H16","v":2138},null,2138,"OK"]
[null,"Painting/Power Washing Accrual",{"$f":"Calculations!I25","v":97.193055555555546},{"$f":"Calculations!H25","v":1166.3166666666668},null,1166.3166666666666,"OK"]
[null,"General Building Maintenance Accrual",{"$f":"Calculations!I33","v":396.42083333333329},{"$f":"Calculations!H33","v":4757.05},null,4757.0499999999993,"OK"]
[null,"Insurance Accrual",{"$f":"Calculations!I35","v":483.33333333333331},{"$f":"Calculations!H35","v":5800},null,5800,"OK"]
[null,"Legal-Professional Fees Accrual",{"$f":"Calculations!I38","v":100},{"$f":"Calculations!H38","v":1200},null,1200,"OK"]
[null,null,null,null,null,0,"OK"]
[null,"Total Reserve Fund",{"$f":"SUM(C52:C57)","v":1887.8309541124997},{"$f":"SUM(D52:D57)","v":22653.97144935},null,22653.971449349996,"OK"]
[null,null,null,null,null,0,"OK"]
[null,"Total Inflows (Income)",{"$f":"C18","v":3150},{"$f":"D18","v":37800},null,37800,"OK"]
[null,"Total Outflows (Expenses & Reserve Deposits)",{"$f":"SUM(C59,C49)*-1","v":-3141.5809541125},{"$f":"SUM(D59,D49)*-1","v":-37698.97144935},null,-37698.97144935,"OK"]
[null,"Surplus ( From Fee Round-Up)",{"$f":"C61+C62","v":8.4190458875000331},{"$f":"(D61+D62)","v":101.0285506500004},null,101.0285506500004]
[null,"Budget Balance",{"$f":"C61+C62-C63","v":0},{"$f":"D61+D62-D63","v":0},null,0,{"$f":"IF(F64=D64,\"OK\",\"ERROR\")","v":"OK"}]

{"sheet":"Published Budget Report","index":15,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,1,0,3],[2,1,2,3]]}
[null,"CONDOMINIUM OWNERS' ASSOCIATION"]
[null,null,"Board Approval Date","Sept 8th, 2018"]
[null,{"$f":"CONCATENATE(\"Annual Operating Budget for the Year of\",\" \",current_budget_year)","v":"Annual Operating Budget for the Year of 2019"}]
[null,"Category/Account","Month","Year"]
[]
[null,"GENERAL FUND (Checking - Cleveland State Bank)"]
[]
[null,"Income"]
[null,"Business Income"]
[null,"Association Dues"]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T7,\" \",\"(Dues per Unit @\",\" \",\"$\",(Calculations!V7),\")\")","v":"Building 1270 (Dues per Unit @ $183)"},{"$f":"Calculations!Y7","v":1464},{"$f":"Calculations!Z7","v":17568}]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T8,\" \",\"(Dues per Unit @\",\" \",\"$\",(Calculations!V8),\")\")","v":"Building 1272 (Dues per Unit @ $232)"},{"$f":"Calculations!Y8","v":464},{"$f":"Calculations!Z8","v":5568}]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T9,\" \",\"(Dues per Unit @\",\" \",\"$\",(Calculations!V9),\")\")","v":"Building 1274 (Dues per Unit @ $231)"},{"$f":"Calculations!Y9","v":462},{"$f":"Calculations!Z9","v":5544}]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T10,\" \",\"(Dues per Unit @\",\" \",\"$\",(Calculations!V10),\")\")","v":"Building 1276 (Dues per Unit @ $203)"},{"$f":"Calculations!Y10","v":406},{"$f":"Calculations!Z10","v":4872}]
[null,{"$f":"CONCATENATE(\"Building\",\" \",Calculations!T11,\" \",\"(Dues per Unit @\",\" \",\"$\",(Calculations!V11),\")\")","v":"Building 1278 (Dues per Unit @ $177)"},{"$f":"Calculations!Y11","v":354},{"$f":"Calculations!Z11","v":4248}]
[null,null,{"$f":"Calculations!Y12","v":""},{"$f":"Calculations!Z12","v":""}]
[]
[null,"Total Income",{"$f":"SUM(C11:C17)","v":3150},{"$f":"SUM(D11:D17)","v":37800}]
[]
[null,"Expenses"]
[]
[null,"Business Expense"]
[null,{"$f":"Calculations!L7","v":"Administration Fee"},{"$f":"Calculations!R7","v":0.83333333333333337},{"$f":"Calculations!Q7","v":10}]
[null,{"$f":"Calculations!L8","v":"Dues and Subscriptions"},{"$f":"Calculations!R8","v":14.166666666666666},{"$f":"Calculations!Q8","v":170}]
[null,{"$f":"Calculations!L9","v":""},{"$f":"Calculations!R9","v":""},{"$f":"Calculations!Q9","v":""}]
[null,{"$f":"Calculations!L10","v":"Supplies, Business"},{"$f":"Calculations!R10","v":25},{"$f":"Calculations!Q10","v":300}]
[null,{"$f":"Calculations!L11","v":"Bank Charge"},{"$f":"Calculations!R11","v":0.83333333333333337},{"$f":"Calculations!Q11","v":10}]
[null,{"$f":"Calculations!L12","v":"Business, Other"},{"$f":"Calculations!R12","v":8.3333333333333339},{"$f":"Calculations!Q12","v":100}]
[null,"Sub-Total Business Expenses",{"$f":"SUM(C23:C28)","v":49.166666666666671},{"$f":"SUM(D23:D28)","v":590}]
[]
[null,"Discretionary"]
[null,{"$f":"Calculations!L13","v":"Grounds Improvement"},{"$f":"Calculations!R13","v":41.666666666666664},{"$f":"Calculations!Q13","v":500}]
[null,{"$f":"Calculations!L14","v":"Landscaping Repayment"},{"$f":"Calculations!R14","v":50},{"$f":"Calculations!Q14","v":600}]
[null,{"$f":"Calculations!L15","v":"Lawn Care"},{"$f":"Calculations!R15","v":630.83333333333337},{"$f":"Calculations!Q15","v":7570}]
[null,{"$f":"Calculations!L16","v":"Snow Removal"},{"$f":"Calculations!R16","v":393.75},{"$f":"Calculations!Q16","v":4725}]
[null,{"$f":"Calculations!L17","v":"Wireless Internet"},{"$f":"Calculations!R17","v":0},{"$f":"Calculations!Q17","v":0}]
[null,{"$f":"Calculations!L18","v":"Discretionary, Other"},{"$f":"Calculations!R18","v":20.833333333333332},{"$f":"Calculations!Q18","v":250}]
[null,"Sub-Total Discretionary Expenses",{"$f":"SUM(C32:C37)","v":1137.0833333333333},{"$f":"SUM(D32:D37)","v":13645}]
[]
[null,"Mandatory"]
[null,{"$f":"Calculations!L19","v":"Electric House Meter 1"},{"$f":"Calculations!R19","v":16.666666666666668},{"$f":"Calculations!Q19","v":200}]
[null,{"$f":"Calculations!L20","v":"Electric House Meter 2"},{"$f":"Calculations!R20","v":21.666666666666668},{"$f":"Calculations!Q20","v":260}]
[null,{"$f":"Calculations!L21","v":"Water and Sewer"},{"$f":"Calculations!R21","v":20.833333333333332},{"$f":"Calculations!Q21","v":250}]
[null,{"$f":"Calculations!L22","v":"Mandatory, Other"},{"$f":"Calculations!R22","v":8.3333333333333339},{"$f":"Calculations!Q22","v":100}]
[null,{"$f":"Calculations!L23","v":""},{"$f":"Calculations!R23","v":""},{"$f":"Calculations!Q23","v":""}]
[null,"Sub-Total Mandatory Expenses",{"$f":"SUM(C41:C45)","v":67.5},{"$f":"SUM(D41:D45)","v":810}]
[]
[]
[null,"Total Expenses - General Fund",{"$f":"SUM(C29,C38,C46,C48)","v":1253.75},{"$f":"SUM(D29,D38,D46,D48)","v":15045}]
[]
[null,"RESERVE FUND (Savings - Cleveland State Bank)"]
[null,"Roofing Accrual",{"$f":"Calculations!I13","v":632.71706522361103},{"$f":"Calculations!H13","v":7592.6047826833328}]
[null,"Road Maintenance Accrual",{"$f":"Calculations!I16","v":178.16666666666666},{"$f":"Calculations!H16","v":2138}]
[null,"Painting/Power Washing Accrual",{"$f":"Calculations!I25","v":97.193055555555546},{"$f":"Calculations!H25","v":1166.3166666666668}]
[null,"General Building Maintenance Accrual",{"$f":"Calculations!I33","v":396.42083333333329},{"$f":"Calculations!H33","v":4757.05}]
[null,"Insurance Accrual",{"$f":"Calculations!I35","v":483.33333333333331},{"$f":"Calculations!H35","v":5800}]
[null,"Legal-Professional Fees Accrual",{"$f":"Calculations!I38","v":100},{"$f":"Calculations!H38","v":1200}]
[]
[null,"Total Reserve Fund",{"$f":"SUM(C52:C57)","v":1887.8309541124997},{"$f":"SUM(D52:D57)","v":22653.97144935}]
[null,null,null,null,null,null,null,null,null,null," "]
[null,"Total Inflows (Income)",{"$f":"C18","v":3150},{"$f":"D18","v":37800}]
[null,"Total Outflows (Expenses & Reserve Deposits)",{"$f":"SUM(C59,C49)*-1","v":-3141.5809541125},{"$f":"SUM(D59,D49)*-1","v":-37698.97144935}]
[null,"Surplus ( From Fee Round-Up)",{"$f":"C61+C62","v":8.4190458875000331},{"$f":"(D61+D62)","v":101.0285506500004}]
[null,"Budget Balance",{"$f":"C61+C62-C63","v":0},{"$f":"D61+D62-D63","v":0}]

{"sheet":"Sheet1","index":16,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Roofing Estimates"]
[null,null,null,"Kaltenbrun Quote","HHCOA Budget","Kaltenbrun Quote","Kaltenbrun Quote"]
[null,null,null,2008,2010,2012,2016,null,null,null,null,null,"2010 Budget"]
[null,null,null,"Timberline 40 year Shingles",null,"Timberline Lifetime Shingles","Timberline Lifetime Shingles",null,null,null,null,null,"Roofing"]
[null,null,1270,47000,47000,46650,48077,null,null,null,null,null,"8-Plex",47000]
[null,null,1272,23300,23000,23325,2400,null,null,null,null,null,1272,23000]
[null,null,1274,25675,25700,23325,2600,null,null,null,null,null,1274,25700]
[null,null,1276]
[null,null,1278]