{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Period Summary","Recap","YearToDate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Period Summary","index":0,"n_rows":56,"n_cols":23,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Kalamazoo Count Accommodation Summary Report"]
[null,null,null,"Collections for Month","Dec 2016"]
[]
["Location","Reporting Period","Transaction Date","Total Revenue","Transient Guest","Net Revenue","Fines","Interest","Adjustments","Tax","Note",null,null,null,null,null,null,null,null,null,null,null,"Dec 2016"]
["40 Winks Motel","Oct 2016","2016-11-16",5776.7,0,5776.7,0,0,0,288.83999999999997,null,null,null,null,null,null,null,null,null,null,null,null,"Nov 2016"]
["Airport Inn","Oct 2016","2016-11-07",387,0,387,0,0,0,19.350000000000001,null,null,null,null,null,null,null,null,null,null,null,null,"Oct 2016"]
["American Hotel / Kal. Hampton Inn / GIA Hosp group","Oct 2016","2016-11-14",40809.47,0,40809.47,0,0,0,2040.47,null,null,null,null,null,null,null,null,null,null,null,null,"Sep 2016"]
["Baymont Inn & Suites/Kalamazoo Superior/ 11TH ST","Oct 2016","2016-11-15",83449.240000000005,0,83449.240000000005,0,0,0,4172.46,null,null,null,null,null,null,null,null,null,null,null,null,"Aug 2016"]
["Best Western Suite Kalamazoo/11th st/","Oct 2016","2016-11-09",90032.75,0,90032.75,0,0,0,4501.6400000000003,null,null,null,null,null,null,null,null,null,null,null,null,"Jul 2016"]
["Candlewood Suites","Oct 2016","2016-11-17",129576.8,0,129576.8,0,0,0,6478.84,null,null,null,null,null,null,null,null,null,null,null,null,"Jun 2016"]
["Clarion fka Bestwestern/Vaidehi Inc. Court St./DEVI HOSP.","Oct 2016","2016-11-18",66784.649999999994,0,66784.649999999994,0,0,0,3339.23,null,null,null,null,null,null,null,null,null,null,null,null,"May 2016"]
["Clarion Hotel  kna Four Points","Oct 2016","2016-11-16",119413.49,0,119413.49,0,0,0,5970.48,null,null,null,null,null,null,null,null,null,null,null,null,"Apr 2016"]
["Comfort Inn Kalamazoo / Reesha Property LLC DBA","Oct 2016","2016-11-15",129328.5,0,129328.5,0,0,0,6466.43,null,null,null,null,null,null,null,null,null,null,null,null,"Mar 2016"]
["Country Inn & Suites / On Shree Assoc LLC","Oct 2016","2016-11-22",62217,0,62217,0,0,0,3111,null,null,null,null,null,null,null,null,null,null,null,null,"Feb 2016"]
["Econo Lodge / VA Investments","Oct 2016","2016-11-16",52110.93,0,52110.93,0,0,0,2605.5500000000002,null,null,null,null,null,null,null,null,null,null,null,null,"Jan 2016"]
["Fairfield Inn Inc Kalamazoo Field Hotel/Cork Baymont Inn","Oct 2016","2016-11-16",77074.490000000005,0,77074.490000000005,0,0,0,3853.72]
["Fairfield Inn West - Kalamazoo / HRC Hotels","Oct 2016","2016-11-16",124149.46,0,124149.46,0,0,0,6207.47,"paid Nov 16, 2016 Revenue=$23872.00      5%=$1193.60\r\npaid Nov 17, 2016 Revenue=$100277.46    5%=$5013.87"]
["Festive West Bed & Breakfest","Oct 2016","2016-11-15",1634,0,1634,0,0,0,81.7]
["Gull Lake Inn / Fore W Inc","Oct 2016","2016-11-17",8971.06,0,8971.06,0,0,0,448.55]
["Gull Lake View Golf Club","Oct 2016","2016-11-17",83399.509999999995,0,83399.509999999995,0,0,0,4169.9799999999996]
["Henderson Castle B & B","Oct 2016","2016-11-07",10929.89,0,10929.89,0,0,0,546.49]
["Holiday Inn West /Greenleaf Ventures Inc","Oct 2016","2016-11-22",396269,0,396269,0,0,0,19813.46]
["Holiday Motel","Oct 2016","2016-11-14",1479.86,0,1479.86,0,0,0,73.989999999999995]
["Inn of Kalamazoo / HRC Hotels LLC","Oct 2016","2016-11-16",231932.6,0,231932.6,0,0,0,11596.63]
["John Wickstrom B & B","Oct 2016","2016-11-17",1554.05,0,1554.05,0,0,0,77.7]
["Kalamazoo Holiday Inn Express / Sophia Hospitality","Oct 2016","2016-11-16",100611.34,0,100611.34,0,0,0,5030.57]
["Kalamazoo Hotel 2,dba Hampton Inn 2610 Airview Blvd","Oct 2016","2016-11-15",229835.78,0,229835.78,0,0,0,11491.79]
["Kalamazoo House B & B","Oct 2016","2016-11-08",35720.800000000003,0,35720.800000000003,0,0,0,1786.04]
["Kalamazoo Inn Motel ","Oct 2016","2016-11-10",2971.86,0,2971.86,0,0,0,148.59]
["Karas Kottages LLC","Oct 2016","2016-11-15",14890.75,0,14890.75,0,0,0,744.53]
["Knights Inn","Oct 2016","2016-11-10",8179.46,0,8179.46,0,0,0,408.89]
["Microtel Inn & Suites","Oct 2016","2016-11-29",97688.6,0,97688.6,0,0,0,4884.43]
["nka Days Inn/America's Best Value Inn & Suites (fka Lee's Inn)","Oct 2016","2016-11-14",18790.41,0,18790.41,0,0,0,939.52]
["Peninsula Hotel Group, LLC (aka Staybridge Suites)","Oct 2016","2016-11-15",214112.73,0,214112.73,0,0,0,10705.64]
["Portage Courtyard","Oct 2016","2016-11-15",329848.43,0,329848.43,0,0,0,16492.419999999998]
["Portage Homewood Suites","Oct 2016","2016-11-15",268362.19,0,268362.19,0,0,0,13418.11]
["Quality Hotel / Krishna Co","Oct 2016","2016-11-10",38611.300000000003,0,38611.300000000003,0,0,0,1930.57]
["Radisson Plaza Hotel / Greenleaf Ventures Inc","Oct 2016","2016-11-15",1239179.3999999999,0,1239179.3999999999,0,0,0,61958.97]
["Red Roof Inn #25 / R-Roof 6 LLC - 10025/MICHIGAN","Oct 2016","2016-11-22",94349.54,0,94349.54,0,0,0,4717.4799999999996]
["Residence Inn   /  ANR Kalamazoo","Oct 2016","2016-11-15",215704.16,36709.980000000003,178994.18,0,0,0,8949.7099999999991]
["Stuart Avenue Inn","Oct 2016","2016-11-15",8344.82,0,8344.82,0,0,0,417.24]
["Sunstar Kalamazoo Inc / Motel 6 # ","Oct 2016","2016-11-16",84146.43,31791.94,52354.49,0,0,0,2617.7199999999998]
["SUPER 8/RGA Corp. of Kalamazoo","Oct 2016","2016-11-29",39368.99,7513.97,31855.02,0,0,0,1592.75]
["Towne Place Suites","Oct 2016","2016-11-16",162127.6,0,162127.6,0,0,0,8106.38]
["Woodspring Suites","Oct 2016","2016-11-15",113815.21,0,113815.21,0,0,0,5690.76]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",null,null,{"$f":"SUBTOTAL(109,Table1[Total Revenue])","v":5033940.25},{"$f":"SUBTOTAL(109,Table1[Transient Guest])","v":76015.89},{"$f":"SUBTOTAL(109,Table1[Net Revenue])","v":4957924.3599999994},{"$f":"SUBTOTAL(109,Table1[Fines])","v":0},{"$f":"SUBTOTAL(109,Table1[Interest])","v":0},{"$f":"SUBTOTAL(109,Table1[Adjustments])","v":0},{"$f":"SUBTOTAL(109,Table1[Tax])","v":247896.09000000003}]

{"sheet":"Recap","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Kalamazoo Count Accommodation Tax Distribution"]
[null,null,null,"Collections for Period:","Jun 2016"]
[]
[null,"Taxes","Fines","Interest","Adjustments","Collected","Distribution","Notes"]
["Forward",16673.14,0,0,0,311861.37400000001,{"$f":"F5","v":311861.37400000001}]
["Kalamazoo County Admin Fee (2016)",null,null,null,null,null,6250]
["Net",null,null,null,null,null,{"$f":"G5-G6","v":305611.37400000001}]
[]
["Discover Kalamazoo",null,null,null,null,null,{"$f":"G7*0.71","v":216984.07553999999}]
[]
["Parks Promotion",null,null,null,null,null,2166.67]
[]
["Kalamazoo County",null,null,null,null,null,{"$f":"G7-G9-G11","v":86460.628460000022}]
[]
[null,null,null,null,"Total",null,{"$f":"SUM(G9:G13,G6)","v":311861.37400000001}]

{"sheet":"YearToDate","index":2,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,4,1,7]]}
["Kalamazoo County Accommodation Taxes"]
[null,null,null,null,"Year to Date Collections by Month",null,null,null,null,null,null,null,null,"Update"]
[]
["Location","Jan 2016","Feb 2016","Mar 2016","Apr 2016","May 2016","Jun 2016","Jul 2016","Aug 2016","Sep 2016","Oct 2016","Nov 2016","Dec 2016","Totals"]
["40 Winks Motel",192.72,224.27,271.83999999999997,305.33999999999997,280.58,255.34,303.39999999999998,259.39,283.5,253.89,288.83999999999997,286.41000000000003,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":3205.5199999999995}]
["Airport Inn",53.5,68.25,37.4,82.45,14.2,36.5,95.25,172.5,191.9,115.75,19.350000000000001,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":887.05}]
["American Hotel / Kal. Hampton Inn / GIA Hosp group",975.48,758.33,1955.97,1468.7,1983.25,0,5308.38,2827.5,2645.06,1134.47,2040.47,1289.52,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":22387.130000000005}]
["Baymont Inn & Suites/Kalamazoo Superior/ 11TH ST",2351.31,2003.05,3942.81,3434.72,4659.01,4499.1899999999996,4860.79,5076.8599999999997,5706.25,5386.58,4172.46,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":46093.030000000006}]
["Best Western Suite Kalamazoo/11th st/",3978.51,2337.66,3733.52,3939.38,3550.68,3946.08,5936.34,5943.86,6394.87,5601.07,4501.6400000000003,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":49863.61}]
["Candlewood Suites",2849.56,3707.82,5013.66,5065.21,4952.2,6900.38,7372.02,5079.6000000000004,6509.72,5943.05,6478.84,4428.17,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":64300.23000000001}]
["Clarion fka Bestwestern/Vaidehi Inc. Court St./DEVI HOSP.",2377.83,2057.62,2400.8200000000002,8058.63,3219.68,3836.21,3750,3885.09,4010.18,3828.15,3339.23,2658.92,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":43422.36}]
["Clarion Hotel  kna Four Points",7019.71,5274.66,5624.82,5779.57,5952.27,6115.22,6352.49,6986.51,6902.92,6500.22,5970.48,5879.96,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":74358.83}]
["Comfort Inn Kalamazoo / Reesha Property LLC DBA",2884.25,3157.23,4368.25,3595.32,4590.79,5114.6499999999996,5995.86,5995.86,6187.25,5628.56,6466.43,3121.62,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":57106.07}]
["Comstock Motor Court ",110.47,78.22,85.57,62.13,33.299999999999997,0,5.31,63.6,81.67,74.19,null,88.94,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":683.40000000000009}]
["Country Inn & Suites / On Shree Assoc LLC",2463,2126,4278,3097,null,9154.1,6314,5049,null,11106,3111,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":46698.1}]
["Econo Lodge / VA Investments",1293.19,1586.82,2182.33,2079.77,2385.42,2955.69,3488.13,3798.44,3528.75,3046.94,2605.5500000000002,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":28951.03}]
["Fairfield Inn Inc Kalamazoo Field Hotel/Cork Baymont Inn",1660.56,1648.84,2878.6,2060.8000000000002,2570.13,3850.37,4823.93,4284.08,5018.03,4677.16,3853.72,3527.21,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":40853.43}]
["Fairfield Inn West - Kalamazoo / HRC Hotels",2979.22,2955.67,4457.18,4367.71,4976.6400000000003,6194.85,6798.44,6633.88,7060.75,6203.57,6207.47,4117.24,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":62952.619999999995}]
["Festive West Bed & BreakFest",null,null,null,null,null,null,null,18.350000000000001,19.649999999999999,102.94,81.7,34.880000000000003,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":257.52}]
["Gull Lake Inn / Fore W Inc",0,0,0,0,0,1352.91,3224.87,2358.94,2912.27,2000.85,448.55,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":12298.39}]
["Gull Lake View Golf Club",345.13,167.87,350.57,179.75,3454.85,9956.8799999999992,23148.28,21977.119999999999,19993.509999999998,22625.23,4169.9799999999996,168.54,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":106537.70999999998}]
["Henderson Castle B & B",532.92999999999995,512.80999999999995,0,0,1583.96,0,981.91,0,1145.4000000000001,0,null,484.11,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":5241.12}]
["Holiday Inn West /Greenleaf Ventures Inc",11091.72,10486.25,15914.19,18465.05,17518,19054.97,22034,22196,23178,20639,19813.46,15481.1,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":215871.74}]
["Holiday Motel",80.06,61.81,66.08,105.31,81.900000000000006,84.08,81.56,91.59,94.58,105.31,73.989999999999995,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":926.27}]
["Inn of Kalamazoo / HRC Hotels LLC",5972.12,5759.51,8759.18,7998.95,8783.52,9789.0499999999993,11978.23,10664.38,12033.18,10524.11,11596.63,8174.81,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":112033.67}]
["John Wickstrom B & B",41.9,0,0,0,0,50.63,123.38,11.13,0,102.66,77.7,118.33,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":525.73}]
["Kalamazoo Holiday Inn Express / Sophia Hospitality",4759.72,4155.18,4419.76,4674.78,4700.57,4761.96,5001.74,5529.72,5419.73,5159.7299999999996,5030.57,5093.7299999999996,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":58707.19}]
["Kalamazoo Hotel 2,dba Hampton Inn 2610 Airview Blvd",5569.23,6382.65,9271.0300000000007,10292.549999999999,9382.1,11654.23,12472.97,12068.22,12063.03,10902.43,11491.79,8953.77,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":120504.00000000001}]
["Kalamazoo House B & B",1035.28,1053.4100000000001,1567.7,1056.67,1123.6400000000001,1640.7,1557.98,1580.06,1561.43,1295.8,1786.04,1149.3800000000001,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":16408.09}]
["Kalamazoo Inn Motel ",132.44999999999999,123.59,148.56,148.56,132.49,132.09,117.34,206.56,148.59,165.48,148.59,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":1604.3}]
["Karas Kottages LLC",371.78,252.1,341.06,382.78,496.12,759.46,732.4,645.37,760.32,621.23,744.53,579.1,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":6686.2500000000009}]
["Knights Inn",301.55,401.56,418.01,419.51,611.53,569.08000000000004,416.3,618.51,660.54,433.99,408.89,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":5259.47}]
["MCR Tenant 2",4193,4118.05,4525.3999999999996,5103.45,4913.8999999999996,5642.85,5690.25,6003.5,4376.55,0,null,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":44566.95}]
["Microtel Inn & Suites",2678.25,2495.7199999999998,3523.58,2240.85,0,9579.99,0,13357.17,null,11814.17,4884.43,3628.58,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":54202.74}]
["nka Days Inn/America's Best Value Inn & Suites (fka Lee's Inn)",631.5,841.53,969.53,1019.5,919.52,1324.58,1184.53,2063.0300000000002,1835.92,1390.08,939.52,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":13119.24}]
["Peninsula Hotel Group, LLC (aka Staybridge Suites)",6063.83,7061.57,7197.21,7966.81,8629.09,9497.67,10256.39,11648.64,11396.76,10866.77,10705.64,8622.7800000000007,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":109913.15999999999}]
["Portage Courtyard",9806.15,11066.64,13791.77,13135.43,13441.63,14207.22,15699.56,14454.84,16104.88,14842.29,16492.419999999998,12856.35,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":165899.18000000002}]
["Portage Homewood Suites",8922.84,9303.83,14176.46,14670.72,13312.7,13417.92,13513.74,13637.24,15746.74,14536.89,13418.11,13269.33,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":157926.51999999999}]
["Quality Hotel / Krishna Co",1187.83,1241.57,1624.48,1548.3,1871.27,2515.65,2795.21,3400.84,3173.38,2540.56,1930.57,1211.25,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":25040.91}]
["Radisson Plaza Hotel / Greenleaf Ventures Inc",39171.660000000003,37458.870000000003,52382.59,46271.62,0,110311.17,59578.62,52445.13,58356.51,51510.02,61958.97,49638.57,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":619083.73}]
["Red Roof Inn #03 / R-Roof 6 LLC - 10003/CORK",2371.06,null,2312.81,3138.48,3132.2,3719.93,4604.87,10072.280000000001,4766.2,4531.62,null,8737.24,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":47386.689999999995}]
["Red Roof Inn #25 / R-Roof 6 LLC - 10025/MICHIGAN",3530.13,2548.9499999999998,3383.78,4190.25,4561.66,5689.09,6226.13,7815.29,6202.53,5786.57,4717.4799999999996,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":54651.86}]
["Residence Inn   /  ANR Kalamazoo",6290.72,6142.04,6899.49,6906.3,8021.6,9987.42,10506.91,10739.64,10297.6,8101.67,8949.7099999999991,7904.25,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":100747.35}]
["Stuart Avenue Inn",139.5,159.43,236.11,222.71,111.75,428.83,469.22,242.3,473.21,226.11,417.24,206.41,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":3332.8199999999997}]
["Sunstar Kalamazoo Inc / Motel 6 # ",1402.83,1593.19,2023.59,2350.9499999999998,2268.8200000000002,2270.65,2967.29,3818.24,1483.35,2394.65,2617.7199999999998,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":25191.279999999999}]
["SUPER 8/RGA Corp. of Kalamazoo",1256.42,1203.8,1409.18,1424.72,1234.5,2441.59,2418.84,1140.3900000000001,2256.5700000000002,2256.5700000000002,1592.75,null,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":18635.330000000002}]
["Towne Place Suites",4945.74,3835.73,5708.78,5086.09,5565.45,8162.07,9000,9229.7900000000009,8643.51,8051.75,8106.38,6564.2,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":82899.490000000005}]
["Woodspring Suites",null,null,null,null,null,null,null,null,1719.24,5890.24,5690.76,5403.3,{"$f":"SUM(Table2[[#This Row],[Jan 2016]:[Dec 2016]])","v":18703.54}]
["Total",{"$f":"SUBTOTAL(109,Table2[Jan 2016])","v":154014.63999999998},{"$f":"SUBTOTAL(109,Table2[Feb 2016])","v":146412.10000000003},{"$f":"SUBTOTAL(109,Table2[Mar 2016])","v":202651.66999999995},{"$f":"SUBTOTAL(109,Table2[Apr 2016])","v":202396.81999999998},{"$f":"SUBTOTAL(109,Table2[May 2016])","v":155020.92000000001},{"$f":"SUBTOTAL(109,Table2[Jun 2016])","v":311861.25000000012},{"$f":"SUBTOTAL(109,Table2[Jul 2016])","v":288186.85999999987},{"$f":"SUBTOTAL(109,Table2[Aug 2016])","v":294090.44},{"$f":"SUBTOTAL(109,Table2[Sep 2016])","v":281344.03000000003},{"$f":"SUBTOTAL(109,Table2[Oct 2016])","v":278918.32},{"$f":"SUBTOTAL(109,Table2[Nov 2016])","v":247349.60000000003},{"$f":"SUBTOTAL(109,Table2[Dec 2016])","v":183678},{"$f":"SUBTOTAL(109,Table2[Totals])","v":2745924.65}]