{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Revenues (sales)","Cost of sales","Expenses"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Revenues (sales)","index":0,"n_rows":14,"n_cols":31,"rows_kept":14}
[{"$nulls":30}," "]
[null,"COMPANY NAME"]
[]
[null,"PROFIT & LOSS PROJECTION"]
[]
[null,"REVENUES (SALES)","TREND","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YEARLY","IND %","JAN %","FEB %","MAR %","APR %","MAY %","JUN %","JUL %","AUG %","SEP %","OCT %","NOV %","DEC %","YEAR %"]
[null,"Revenue 1",null,{"v":186,"d":"$186.00"},{"v":108,"d":"$108.00"},{"v":92,"d":"$92.00"},{"v":122,"d":"$122.00"},{"v":190,"d":"$190.00"},{"v":71,"d":"$71.00"},{"v":21,"d":"$21.00"},{"v":37,"d":"$37.00"},{"v":24,"d":"$24.00"},{"v":178,"d":"$178.00"},{"v":92,"d":"$92.00"},{"v":97,"d":"$97.00"},{"$f":"SUM(Revenue[[#This Row],[JAN]:[DEC]])","v":{"v":1218,"d":"$1,218.00"}},{"v":0.12,"d":"12%"},{"$f":"IFERROR(Revenue[[#This Row],[JAN]]/Revenue[[#Totals],[JAN]],\"-\")","v":{"v":0.2980769230769231,"d":"30%"}},{"$f":"IFERROR(Revenue[[#This Row],[FEB]]/Revenue[[#Totals],[FEB]],\"-\")","v":{"v":0.14673913043478262,"d":"15%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAR]]/Revenue[[#Totals],[MAR]],\"-\")","v":{"v":0.11219512195121951,"d":"11%"}},{"$f":"IFERROR(Revenue[[#This Row],[APR]]/Revenue[[#Totals],[APR]],\"-\")","v":{"v":0.19967266775777415,"d":"20%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAY]]/Revenue[[#Totals],[MAY]],\"-\")","v":{"v":0.23399014778325122,"d":"23%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUN]]/Revenue[[#Totals],[JUN]],\"-\")","v":{"v":0.12283737024221453,"d":"12%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUL]]/Revenue[[#Totals],[JUL]],\"-\")","v":{"v":0.035175879396984924,"d":"4%"}},{"$f":"IFERROR(Revenue[[#This Row],[AUG]]/Revenue[[#Totals],[AUG]],\"-\")","v":{"v":0.054814814814814816,"d":"5%"}},{"$f":"IFERROR(Revenue[[#This Row],[SEP]]/Revenue[[#Totals],[SEP]],\"-\")","v":{"v":0.03225806451612903,"d":"3%"}},{"$f":"IFERROR(Revenue[[#This Row],[OCT]]/Revenue[[#Totals],[OCT]],\"-\")","v":{"v":0.26138032305433184,"d":"26%"}},{"$f":"IFERROR(Revenue[[#This Row],[NOV]]/Revenue[[#Totals],[NOV]],\"-\")","v":{"v":0.12449255751014884,"d":"12%"}},{"$f":"IFERROR(Revenue[[#This Row],[DEC]]/Revenue[[#Totals],[DEC]],\"-\")","v":{"v":0.09300095877277086,"d":"9%"}},{"$f":"IFERROR(Revenue[[#This Row],[YEARLY]]/Revenue[[#Totals],[YEARLY]],\"-\")","v":{"v":0.14064665127020784,"d":"14%"}}]
[null,"Revenue 2",null,{"v":15,"d":"$15.00"},{"v":16,"d":"$16.00"},{"v":198,"d":"$198.00"},{"v":44,"d":"$44.00"},{"v":25,"d":"$25.00"},{"v":68,"d":"$68.00"},{"v":43,"d":"$43.00"},{"v":119,"d":"$119.00"},{"v":37,"d":"$37.00"},{"v":118,"d":"$118.00"},{"v":29,"d":"$29.00"},{"v":171,"d":"$171.00"},{"$f":"SUM(Revenue[[#This Row],[JAN]:[DEC]])","v":{"v":883,"d":"$883.00"}},{"v":0.18,"d":"18%"},{"$f":"IFERROR(Revenue[[#This Row],[JAN]]/Revenue[[#Totals],[JAN]],\"-\")","v":{"v":0.02403846153846154,"d":"2%"}},{"$f":"IFERROR(Revenue[[#This Row],[FEB]]/Revenue[[#Totals],[FEB]],\"-\")","v":{"v":0.021739130434782608,"d":"2%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAR]]/Revenue[[#Totals],[MAR]],\"-\")","v":{"v":0.24146341463414633,"d":"24%"}},{"$f":"IFERROR(Revenue[[#This Row],[APR]]/Revenue[[#Totals],[APR]],\"-\")","v":{"v":0.07201309328968904,"d":"7%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAY]]/Revenue[[#Totals],[MAY]],\"-\")","v":{"v":0.03078817733990148,"d":"3%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUN]]/Revenue[[#Totals],[JUN]],\"-\")","v":{"v":0.11764705882352941,"d":"12%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUL]]/Revenue[[#Totals],[JUL]],\"-\")","v":{"v":0.07202680067001675,"d":"7%"}},{"$f":"IFERROR(Revenue[[#This Row],[AUG]]/Revenue[[#Totals],[AUG]],\"-\")","v":{"v":0.17629629629629628,"d":"18%"}},{"$f":"IFERROR(Revenue[[#This Row],[SEP]]/Revenue[[#Totals],[SEP]],\"-\")","v":{"v":0.04973118279569892,"d":"5%"}},{"$f":"IFERROR(Revenue[[#This Row],[OCT]]/Revenue[[#Totals],[OCT]],\"-\")","v":{"v":0.17327459618208516,"d":"17%"}},{"$f":"IFERROR(Revenue[[#This Row],[NOV]]/Revenue[[#Totals],[NOV]],\"-\")","v":{"v":0.03924221921515562,"d":"4%"}},{"$f":"IFERROR(Revenue[[#This Row],[DEC]]/Revenue[[#Totals],[DEC]],\"-\")","v":{"v":0.16395014381591563,"d":"16%"}},{"$f":"IFERROR(Revenue[[#This Row],[YEARLY]]/Revenue[[#Totals],[YEARLY]],\"-\")","v":{"v":0.10196304849884527,"d":"10%"}}]
[null,"Revenue 3",null,{"v":166,"d":"$166.00"},{"v":185,"d":"$185.00"},{"v":89,"d":"$89.00"},{"v":170,"d":"$170.00"},{"v":131,"d":"$131.00"},{"v":70,"d":"$70.00"},{"v":50,"d":"$50.00"},{"v":149,"d":"$149.00"},{"v":179,"d":"$179.00"},{"v":104,"d":"$104.00"},{"v":119,"d":"$119.00"},{"v":187,"d":"$187.00"},{"$f":"SUM(Revenue[[#This Row],[JAN]:[DEC]])","v":{"v":1599,"d":"$1,599.00"}},{"v":0.19,"d":"19%"},{"$f":"IFERROR(Revenue[[#This Row],[JAN]]/Revenue[[#Totals],[JAN]],\"-\")","v":{"v":0.266025641025641,"d":"27%"}},{"$f":"IFERROR(Revenue[[#This Row],[FEB]]/Revenue[[#Totals],[FEB]],\"-\")","v":{"v":0.2513586956521739,"d":"25%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAR]]/Revenue[[#Totals],[MAR]],\"-\")","v":{"v":0.10853658536585366,"d":"11%"}},{"$f":"IFERROR(Revenue[[#This Row],[APR]]/Revenue[[#Totals],[APR]],\"-\")","v":{"v":0.27823240589198034,"d":"28%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAY]]/Revenue[[#Totals],[MAY]],\"-\")","v":{"v":0.16133004926108374,"d":"16%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUN]]/Revenue[[#Totals],[JUN]],\"-\")","v":{"v":0.12110726643598616,"d":"12%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUL]]/Revenue[[#Totals],[JUL]],\"-\")","v":{"v":0.08375209380234507,"d":"8%"}},{"$f":"IFERROR(Revenue[[#This Row],[AUG]]/Revenue[[#Totals],[AUG]],\"-\")","v":{"v":0.22074074074074074,"d":"22%"}},{"$f":"IFERROR(Revenue[[#This Row],[SEP]]/Revenue[[#Totals],[SEP]],\"-\")","v":{"v":0.24059139784946237,"d":"24%"}},{"$f":"IFERROR(Revenue[[#This Row],[OCT]]/Revenue[[#Totals],[OCT]],\"-\")","v":{"v":0.1527165932452276,"d":"15%"}},{"$f":"IFERROR(Revenue[[#This Row],[NOV]]/Revenue[[#Totals],[NOV]],\"-\")","v":{"v":0.16102841677943167,"d":"16%"}},{"$f":"IFERROR(Revenue[[#This Row],[DEC]]/Revenue[[#Totals],[DEC]],\"-\")","v":{"v":0.17929050814956854,"d":"18%"}},{"$f":"IFERROR(Revenue[[#This Row],[YEARLY]]/Revenue[[#Totals],[YEARLY]],\"-\")","v":{"v":0.18464203233256352,"d":"18%"}}]
[null,"Revenue 4",null,{"v":21,"d":"$21.00"},{"v":113,"d":"$113.00"},{"v":83,"d":"$83.00"},{"v":17,"d":"$17.00"},{"v":130,"d":"$130.00"},{"v":26,"d":"$26.00"},{"v":167,"d":"$167.00"},{"v":102,"d":"$102.00"},{"v":82,"d":"$82.00"},{"v":33,"d":"$33.00"},{"v":88,"d":"$88.00"},{"v":193,"d":"$193.00"},{"$f":"SUM(Revenue[[#This Row],[JAN]:[DEC]])","v":{"v":1055,"d":"$1,055.00"}},{"v":0.11,"d":"11%"},{"$f":"IFERROR(Revenue[[#This Row],[JAN]]/Revenue[[#Totals],[JAN]],\"-\")","v":{"v":0.03365384615384615,"d":"3%"}},{"$f":"IFERROR(Revenue[[#This Row],[FEB]]/Revenue[[#Totals],[FEB]],\"-\")","v":{"v":0.15353260869565216,"d":"15%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAR]]/Revenue[[#Totals],[MAR]],\"-\")","v":{"v":0.10121951219512196,"d":"10%"}},{"$f":"IFERROR(Revenue[[#This Row],[APR]]/Revenue[[#Totals],[APR]],\"-\")","v":{"v":0.027823240589198037,"d":"3%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAY]]/Revenue[[#Totals],[MAY]],\"-\")","v":{"v":0.16009852216748768,"d":"16%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUN]]/Revenue[[#Totals],[JUN]],\"-\")","v":{"v":0.04498269896193772,"d":"4%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUL]]/Revenue[[#Totals],[JUL]],\"-\")","v":{"v":0.2797319932998325,"d":"28%"}},{"$f":"IFERROR(Revenue[[#This Row],[AUG]]/Revenue[[#Totals],[AUG]],\"-\")","v":{"v":0.1511111111111111,"d":"15%"}},{"$f":"IFERROR(Revenue[[#This Row],[SEP]]/Revenue[[#Totals],[SEP]],\"-\")","v":{"v":0.11021505376344086,"d":"11%"}},{"$f":"IFERROR(Revenue[[#This Row],[OCT]]/Revenue[[#Totals],[OCT]],\"-\")","v":{"v":0.048458149779735685,"d":"5%"}},{"$f":"IFERROR(Revenue[[#This Row],[NOV]]/Revenue[[#Totals],[NOV]],\"-\")","v":{"v":0.11907983761840325,"d":"12%"}},{"$f":"IFERROR(Revenue[[#This Row],[DEC]]/Revenue[[#Totals],[DEC]],\"-\")","v":{"v":0.1850431447746884,"d":"19%"}},{"$f":"IFERROR(Revenue[[#This Row],[YEARLY]]/Revenue[[#Totals],[YEARLY]],\"-\")","v":{"v":0.12182448036951501,"d":"12%"}}]
[null,"Revenue 5",null,{"v":70,"d":"$70.00"},{"v":160,"d":"$160.00"},{"v":125,"d":"$125.00"},{"v":84,"d":"$84.00"},{"v":191,"d":"$191.00"},{"v":97,"d":"$97.00"},{"v":52,"d":"$52.00"},{"v":45,"d":"$45.00"},{"v":173,"d":"$173.00"},{"v":136,"d":"$136.00"},{"v":144,"d":"$144.00"},{"v":167,"d":"$167.00"},{"$f":"SUM(Revenue[[#This Row],[JAN]:[DEC]])","v":{"v":1444,"d":"$1,444.00"}},{"v":0.2,"d":"20%"},{"$f":"IFERROR(Revenue[[#This Row],[JAN]]/Revenue[[#Totals],[JAN]],\"-\")","v":{"v":0.11217948717948718,"d":"11%"}},{"$f":"IFERROR(Revenue[[#This Row],[FEB]]/Revenue[[#Totals],[FEB]],\"-\")","v":{"v":0.21739130434782608,"d":"22%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAR]]/Revenue[[#Totals],[MAR]],\"-\")","v":{"v":0.1524390243902439,"d":"15%"}},{"$f":"IFERROR(Revenue[[#This Row],[APR]]/Revenue[[#Totals],[APR]],\"-\")","v":{"v":0.13747954173486088,"d":"14%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAY]]/Revenue[[#Totals],[MAY]],\"-\")","v":{"v":0.23522167487684728,"d":"24%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUN]]/Revenue[[#Totals],[JUN]],\"-\")","v":{"v":0.16782006920415224,"d":"17%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUL]]/Revenue[[#Totals],[JUL]],\"-\")","v":{"v":0.08710217755443886,"d":"9%"}},{"$f":"IFERROR(Revenue[[#This Row],[AUG]]/Revenue[[#Totals],[AUG]],\"-\")","v":{"v":0.06666666666666667,"d":"7%"}},{"$f":"IFERROR(Revenue[[#This Row],[SEP]]/Revenue[[#Totals],[SEP]],\"-\")","v":{"v":0.2325268817204301,"d":"23%"}},{"$f":"IFERROR(Revenue[[#This Row],[OCT]]/Revenue[[#Totals],[OCT]],\"-\")","v":{"v":0.19970631424375918,"d":"20%"}},{"$f":"IFERROR(Revenue[[#This Row],[NOV]]/Revenue[[#Totals],[NOV]],\"-\")","v":{"v":0.19485791610284167,"d":"19%"}},{"$f":"IFERROR(Revenue[[#This Row],[DEC]]/Revenue[[#Totals],[DEC]],\"-\")","v":{"v":0.1601150527325024,"d":"16%"}},{"$f":"IFERROR(Revenue[[#This Row],[YEARLY]]/Revenue[[#Totals],[YEARLY]],\"-\")","v":{"v":0.16674364896073904,"d":"17%"}}]
[null,"Revenue 6",null,{"v":61,"d":"$61.00"},{"v":99,"d":"$99.00"},{"v":70,"d":"$70.00"},{"v":162,"d":"$162.00"},{"v":28,"d":"$28.00"},{"v":163,"d":"$163.00"},{"v":101,"d":"$101.00"},{"v":103,"d":"$103.00"},{"v":78,"d":"$78.00"},{"v":33,"d":"$33.00"},{"v":162,"d":"$162.00"},{"v":159,"d":"$159.00"},{"$f":"SUM(Revenue[[#This Row],[JAN]:[DEC]])","v":{"v":1219,"d":"$1,219.00"}},{"v":0.1,"d":"10%"},{"$f":"IFERROR(Revenue[[#This Row],[JAN]]/Revenue[[#Totals],[JAN]],\"-\")","v":{"v":0.09775641025641026,"d":"10%"}},{"$f":"IFERROR(Revenue[[#This Row],[FEB]]/Revenue[[#Totals],[FEB]],\"-\")","v":{"v":0.13451086956521738,"d":"13%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAR]]/Revenue[[#Totals],[MAR]],\"-\")","v":{"v":0.08536585365853659,"d":"9%"}},{"$f":"IFERROR(Revenue[[#This Row],[APR]]/Revenue[[#Totals],[APR]],\"-\")","v":{"v":0.265139116202946,"d":"27%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAY]]/Revenue[[#Totals],[MAY]],\"-\")","v":{"v":0.034482758620689655,"d":"3%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUN]]/Revenue[[#Totals],[JUN]],\"-\")","v":{"v":0.2820069204152249,"d":"28%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUL]]/Revenue[[#Totals],[JUL]],\"-\")","v":{"v":0.16917922948073702,"d":"17%"}},{"$f":"IFERROR(Revenue[[#This Row],[AUG]]/Revenue[[#Totals],[AUG]],\"-\")","v":{"v":0.15259259259259259,"d":"15%"}},{"$f":"IFERROR(Revenue[[#This Row],[SEP]]/Revenue[[#Totals],[SEP]],\"-\")","v":{"v":0.10483870967741936,"d":"10%"}},{"$f":"IFERROR(Revenue[[#This Row],[OCT]]/Revenue[[#Totals],[OCT]],\"-\")","v":{"v":0.048458149779735685,"d":"5%"}},{"$f":"IFERROR(Revenue[[#This Row],[NOV]]/Revenue[[#Totals],[NOV]],\"-\")","v":{"v":0.21921515561569688,"d":"22%"}},{"$f":"IFERROR(Revenue[[#This Row],[DEC]]/Revenue[[#Totals],[DEC]],\"-\")","v":{"v":0.15244487056567593,"d":"15%"}},{"$f":"IFERROR(Revenue[[#This Row],[YEARLY]]/Revenue[[#Totals],[YEARLY]],\"-\")","v":{"v":0.1407621247113164,"d":"14%"}}]
[null,"Revenue 7",null,{"v":105,"d":"$105.00"},{"v":55,"d":"$55.00"},{"v":163,"d":"$163.00"},{"v":12,"d":"$12.00"},{"v":117,"d":"$117.00"},{"v":83,"d":"$83.00"},{"v":163,"d":"$163.00"},{"v":120,"d":"$120.00"},{"v":171,"d":"$171.00"},{"v":79,"d":"$79.00"},{"v":105,"d":"$105.00"},{"v":69,"d":"$69.00"},{"$f":"SUM(Revenue[[#This Row],[JAN]:[DEC]])","v":{"v":1242,"d":"$1,242.00"}},{"v":0.1,"d":"10%"},{"$f":"IFERROR(Revenue[[#This Row],[JAN]]/Revenue[[#Totals],[JAN]],\"-\")","v":{"v":0.16826923076923078,"d":"17%"}},{"$f":"IFERROR(Revenue[[#This Row],[FEB]]/Revenue[[#Totals],[FEB]],\"-\")","v":{"v":0.07472826086956522,"d":"7%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAR]]/Revenue[[#Totals],[MAR]],\"-\")","v":{"v":0.19878048780487806,"d":"20%"}},{"$f":"IFERROR(Revenue[[#This Row],[APR]]/Revenue[[#Totals],[APR]],\"-\")","v":{"v":0.019639934533551555,"d":"2%"}},{"$f":"IFERROR(Revenue[[#This Row],[MAY]]/Revenue[[#Totals],[MAY]],\"-\")","v":{"v":0.1440886699507389,"d":"14%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUN]]/Revenue[[#Totals],[JUN]],\"-\")","v":{"v":0.14359861591695502,"d":"14%"}},{"$f":"IFERROR(Revenue[[#This Row],[JUL]]/Revenue[[#Totals],[JUL]],\"-\")","v":{"v":0.2730318257956449,"d":"27%"}},{"$f":"IFERROR(Revenue[[#This Row],[AUG]]/Revenue[[#Totals],[AUG]],\"-\")","v":{"v":0.17777777777777778,"d":"18%"}},{"$f":"IFERROR(Revenue[[#This Row],[SEP]]/Revenue[[#Totals],[SEP]],\"-\")","v":{"v":0.22983870967741934,"d":"23%"}},{"$f":"IFERROR(Revenue[[#This Row],[OCT]]/Revenue[[#Totals],[OCT]],\"-\")","v":{"v":0.11600587371512482,"d":"12%"}},{"$f":"IFERROR(Revenue[[#This Row],[NOV]]/Revenue[[#Totals],[NOV]],\"-\")","v":{"v":0.14208389715832206,"d":"14%"}},{"$f":"IFERROR(Revenue[[#This Row],[DEC]]/Revenue[[#Totals],[DEC]],\"-\")","v":{"v":0.06615532118887824,"d":"7%"}},{"$f":"IFERROR(Revenue[[#This Row],[YEARLY]]/Revenue[[#Totals],[YEARLY]],\"-\")","v":{"v":0.14341801385681294,"d":"14%"}}]
[null,"TOTAL SALES",null,{"$f":"SUBTOTAL(109,Revenue[JAN])","v":{"v":624,"d":"$624.00"}},{"$f":"SUBTOTAL(109,Revenue[FEB])","v":{"v":736,"d":"$736.00"}},{"$f":"SUBTOTAL(109,Revenue[MAR])","v":{"v":820,"d":"$820.00"}},{"$f":"SUBTOTAL(109,Revenue[APR])","v":{"v":611,"d":"$611.00"}},{"$f":"SUBTOTAL(109,Revenue[MAY])","v":{"v":812,"d":"$812.00"}},{"$f":"SUBTOTAL(109,Revenue[JUN])","v":{"v":578,"d":"$578.00"}},{"$f":"SUBTOTAL(109,Revenue[JUL])","v":{"v":597,"d":"$597.00"}},{"$f":"SUBTOTAL(109,Revenue[AUG])","v":{"v":675,"d":"$675.00"}},{"$f":"SUBTOTAL(109,Revenue[SEP])","v":{"v":744,"d":"$744.00"}},{"$f":"SUBTOTAL(109,Revenue[OCT])","v":{"v":681,"d":"$681.00"}},{"$f":"SUBTOTAL(109,Revenue[NOV])","v":{"v":739,"d":"$739.00"}},{"$f":"SUBTOTAL(109,Revenue[DEC])","v":{"v":1043,"d":"$1,043.00"}},{"$f":"SUBTOTAL(109,Revenue[YEARLY])","v":{"v":8660,"d":"$8,660.00"}},{"$f":"SUBTOTAL(109,Revenue[IND %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[JAN %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[FEB %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[MAR %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[APR %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[MAY %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[JUN %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[JUL %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[AUG %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[SEP %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[OCT %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[NOV %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[DEC %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,Revenue[YEAR %])","v":{"v":1,"d":"100%"}}]

{"sheet":"Cost of sales","index":1,"n_rows":15,"n_cols":31,"rows_kept":15}
[{"$nulls":30}," "]
[null,{"$f":"Company_Name","v":"COMPANY NAME"}]
[]
[null,{"$f":"Wksht_Title","v":"PROFIT & LOSS PROJECTION"}]
[]
[null,"COST OF SALES","TREND","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YEARLY","IND %","JAN %","FEB %","MAR %","APR %","MAY %","JUN %","JUL %","AUG %","SEP %","OCT %","NOV %","DEC %","YEAR %"]
[null,"Cost 1",null,{"v":61,"d":"$61.00"},{"v":78,"d":"$78.00"},{"v":65,"d":"$65.00"},{"v":29,"d":"$29.00"},{"v":125,"d":"$125.00"},{"v":49,"d":"$49.00"},{"v":14,"d":"$14.00"},{"v":26,"d":"$26.00"},{"v":14,"d":"$14.00"},{"v":129,"d":"$129.00"},{"v":60,"d":"$60.00"},{"v":65,"d":"$65.00"},{"$f":"SUM(CostofSales[[#This Row],[JAN]:[DEC]])","v":{"v":715,"d":"$715.00"}},{"v":0.12,"d":"12%"},{"$f":"D7/D$14","v":{"v":0.23018867924528302,"d":"23%"}},{"v":0.21910112359550563,"d":"22%"},{"v":0.20634920634920634,"d":"21%"},{"v":0.12033195020746888,"d":"12%"},{"v":0.3132832080200501,"d":"31%"},{"v":0.15705128205128205,"d":"16%"},{"v":0.046822742474916385,"d":"5%"},{"v":0.11504424778761062,"d":"12%"},{"v":0.033816425120772944,"d":"3%"},{"v":0.4708029197080292,"d":"47%"},{"v":0.22727272727272727,"d":"23%"},{"v":0.1434878587196468,"d":"14%"},{"v":0.18727082242011525,"d":"19%"}]
[null,"Cost 2",null,{"v":7,"d":"$7.00"},{"v":5,"d":"$5.00"},{"v":69,"d":"$69.00"},{"v":32,"d":"$32.00"},{"v":11,"d":"$11.00"},{"v":30,"d":"$30.00"},{"v":27,"d":"$27.00"},{"v":32,"d":"$32.00"},{"v":10,"d":"$10.00"},{"v":41,"d":"$41.00"},{"v":13,"d":"$13.00"},{"v":105,"d":"$105.00"},{"$f":"SUM(CostofSales[[#This Row],[JAN]:[DEC]])","v":{"v":382,"d":"$382.00"}},{"v":0.18,"d":"18%"},{"v":0.026415094339622643,"d":"3%"},{"v":0.014044943820224719,"d":"1%"},{"v":0.21904761904761905,"d":"22%"},{"v":0.13278008298755187,"d":"13%"},{"v":0.02756892230576441,"d":"3%"},{"v":0.09615384615384616,"d":"10%"},{"v":0.0903010033444816,"d":"9%"},{"v":0.1415929203539823,"d":"14%"},{"v":0.024154589371980676,"d":"2%"},{"v":0.14963503649635038,"d":"15%"},{"v":0.04924242424242424,"d":"5%"},{"v":0.23178807947019867,"d":"23%"},{"v":0.1000523834468308,"d":"10%"}]
[null,"Cost 3",null,{"v":99,"d":"$99.00"},{"v":95,"d":"$95.00"},{"v":51,"d":"$51.00"},{"v":90,"d":"$90.00"},{"v":21,"d":"$21.00"},{"v":34,"d":"$34.00"},{"v":30,"d":"$30.00"},{"v":24,"d":"$24.00"},{"v":109,"d":"$109.00"},{"v":16,"d":"$16.00"},{"v":21,"d":"$21.00"},{"v":52,"d":"$52.00"},{"$f":"SUM(CostofSales[[#This Row],[JAN]:[DEC]])","v":{"v":642,"d":"$642.00"}},{"v":0.19,"d":"19%"},{"v":0.37358490566037733,"d":"37%"},{"v":0.26685393258426965,"d":"27%"},{"v":0.1619047619047619,"d":"16%"},{"v":0.37344398340248963,"d":"37%"},{"v":0.05263157894736842,"d":"5%"},{"v":0.10897435897435898,"d":"11%"},{"v":0.10033444816053512,"d":"10%"},{"v":0.10619469026548672,"d":"11%"},{"v":0.2632850241545894,"d":"26%"},{"v":0.058394160583941604,"d":"6%"},{"v":0.07954545454545454,"d":"8%"},{"v":0.11479028697571744,"d":"11%"},{"v":0.1681508643268727,"d":"17%"}]
[null,"Cost 4",null,{"v":13,"d":"$13.00"},{"v":28,"d":"$28.00"},{"v":15,"d":"$15.00"},{"v":8,"d":"$8.00"},{"v":84,"d":"$84.00"},{"v":12,"d":"$12.00"},{"v":54,"d":"$54.00"},{"v":72,"d":"$72.00"},{"v":49,"d":"$49.00"},{"v":24,"d":"$24.00"},{"v":60,"d":"$60.00"},{"v":39,"d":"$39.00"},{"$f":"SUM(CostofSales[[#This Row],[JAN]:[DEC]])","v":{"v":458,"d":"$458.00"}},{"v":0.11,"d":"11%"},{"v":0.04905660377358491,"d":"5%"},{"v":0.07865168539325842,"d":"8%"},{"v":0.047619047619047616,"d":"5%"},{"v":0.03319502074688797,"d":"3%"},{"v":0.21052631578947367,"d":"21%"},{"v":0.038461538461538464,"d":"4%"},{"v":0.1806020066889632,"d":"18%"},{"v":0.3185840707964602,"d":"32%"},{"v":0.11835748792270531,"d":"12%"},{"v":0.08759124087591241,"d":"9%"},{"v":0.22727272727272727,"d":"23%"},{"v":0.08609271523178808,"d":"9%"},{"v":0.11995809324253535,"d":"12%"}]
[null,"Cost 5",null,{"v":34,"d":"$34.00"},{"v":78,"d":"$78.00"},{"v":43,"d":"$43.00"},{"v":30,"d":"$30.00"},{"v":77,"d":"$77.00"},{"v":54,"d":"$54.00"},{"v":26,"d":"$26.00"},{"v":13,"d":"$13.00"},{"v":56,"d":"$56.00"},{"v":30,"d":"$30.00"},{"v":40,"d":"$40.00"},{"v":63,"d":"$63.00"},{"$f":"SUM(CostofSales[[#This Row],[JAN]:[DEC]])","v":{"v":544,"d":"$544.00"}},{"v":0.2,"d":"20%"},{"v":0.12830188679245283,"d":"13%"},{"v":0.21910112359550563,"d":"22%"},{"v":0.1365079365079365,"d":"14%"},{"v":0.12448132780082988,"d":"12%"},{"v":0.19298245614035087,"d":"19%"},{"v":0.17307692307692307,"d":"17%"},{"v":0.08695652173913043,"d":"9%"},{"v":0.05752212389380531,"d":"6%"},{"v":0.13526570048309178,"d":"14%"},{"v":0.10948905109489052,"d":"11%"},{"v":0.15151515151515152,"d":"15%"},{"v":0.1390728476821192,"d":"14%"},{"v":0.14248297537978,"d":"14%"}]
[null,"Cost 6",null,{"v":33,"d":"$33.00"},{"v":61,"d":"$61.00"},{"v":42,"d":"$42.00"},{"v":43,"d":"$43.00"},{"v":19,"d":"$19.00"},{"v":94,"d":"$94.00"},{"v":46,"d":"$46.00"},{"v":15,"d":"$15.00"},{"v":55,"d":"$55.00"},{"v":15,"d":"$15.00"},{"v":37,"d":"$37.00"},{"v":89,"d":"$89.00"},{"$f":"SUM(CostofSales[[#This Row],[JAN]:[DEC]])","v":{"v":549,"d":"$549.00"}},{"v":0.1,"d":"10%"},{"v":0.12452830188679245,"d":"12%"},{"v":0.17134831460674158,"d":"17%"},{"v":0.13333333333333333,"d":"13%"},{"v":0.17842323651452283,"d":"18%"},{"v":0.047619047619047616,"d":"5%"},{"v":0.30128205128205127,"d":"30%"},{"v":0.15384615384615385,"d":"15%"},{"v":0.06637168141592921,"d":"7%"},{"v":0.13285024154589373,"d":"13%"},{"v":0.05474452554744526,"d":"5%"},{"v":0.14015151515151514,"d":"14%"},{"v":0.19646799116997793,"d":"20%"},{"v":0.14379256155055004,"d":"14%"}]
[null,"Cost 7",null,{"v":18,"d":"$18.00"},{"v":11,"d":"$11.00"},{"v":30,"d":"$30.00"},{"v":9,"d":"$9.00"},{"v":62,"d":"$62.00"},{"v":39,"d":"$39.00"},{"v":102,"d":"$102.00"},{"v":44,"d":"$44.00"},{"v":121,"d":"$121.00"},{"v":19,"d":"$19.00"},{"v":33,"d":"$33.00"},{"v":40,"d":"$40.00"},{"$f":"SUM(CostofSales[[#This Row],[JAN]:[DEC]])","v":{"v":528,"d":"$528.00"}},{"v":0.1,"d":"10%"},{"v":0.06792452830188679,"d":"7%"},{"v":0.03089887640449438,"d":"3%"},{"v":0.09523809523809523,"d":"10%"},{"v":0.03734439834024896,"d":"4%"},{"v":0.15538847117794485,"d":"16%"},{"v":0.125,"d":"13%"},{"v":0.3411371237458194,"d":"34%"},{"v":0.19469026548672566,"d":"19%"},{"v":0.2922705314009662,"d":"29%"},{"v":0.06934306569343066,"d":"7%"},{"v":0.125,"d":"13%"},{"v":0.08830022075055188,"d":"9%"},{"v":0.13829229963331588,"d":"14%"}]
[null,"TOTAL COST OF SALES",null,{"$f":"SUM(D7:D13)","v":{"v":265,"d":"$265.00"}},{"v":356,"d":"$356.00"},{"v":315,"d":"$315.00"},{"v":241,"d":"$241.00"},{"v":399,"d":"$399.00"},{"v":312,"d":"$312.00"},{"v":299,"d":"$299.00"},{"v":226,"d":"$226.00"},{"v":414,"d":"$414.00"},{"v":274,"d":"$274.00"},{"v":264,"d":"$264.00"},{"v":453,"d":"$453.00"},{"$f":"SUM(CostofSales[[#This Row],[JAN]:[DEC]])","v":{"v":3818,"d":"$3,818.00"}},{"$f":"SUM(Q7:Q13)","v":{"v":1,"d":"100%"}},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
[null,"GROSS PROFIT",null,{"$f":"'Revenues (sales)'!D14-D14","v":{"v":359,"d":"$359.00"}},{"$f":"'Revenues (sales)'!E14-E14","v":{"v":380,"d":"$380.00"}},{"$f":"'Revenues (sales)'!F14-F14","v":{"v":505,"d":"$505.00"}},{"$f":"'Revenues (sales)'!G14-G14","v":{"v":370,"d":"$370.00"}},{"$f":"'Revenues (sales)'!H14-H14","v":{"v":413,"d":"$413.00"}},{"$f":"'Revenues (sales)'!I14-I14","v":{"v":266,"d":"$266.00"}},{"$f":"'Revenues (sales)'!J14-J14","v":{"v":298,"d":"$298.00"}},{"$f":"'Revenues (sales)'!K14-K14","v":{"v":449,"d":"$449.00"}},{"$f":"'Revenues (sales)'!L14-L14","v":{"v":330,"d":"$330.00"}},{"$f":"'Revenues (sales)'!M14-M14","v":{"v":407,"d":"$407.00"}},{"$f":"'Revenues (sales)'!N14-N14","v":{"v":475,"d":"$475.00"}},{"$f":"'Revenues (sales)'!O14-O14","v":{"v":590,"d":"$590.00"}},{"$f":"'Revenues (sales)'!P14-P14","v":{"v":4842,"d":"$4,842.00"}}]

{"sheet":"Expenses","index":2,"n_rows":27,"n_cols":31,"rows_kept":27}
[{"$nulls":30}," "]
[null,{"$f":"Company_Name","v":"COMPANY NAME"}]
[]
[null,{"$f":"Wksht_Title","v":"PROFIT & LOSS PROJECTION"}]
[]
[null,"EXPENSES","TREND","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YEARLY","IND %","JAN %","FEB %","MAR %","APR %","MAY %","JUN %","JUL %","AUG %","SEP %","OCT %","NOV %","DEC %","YEAR %"]
[null,"Salary expenses "," ",{"v":10,"d":"$10.00"},{"v":18,"d":"$18.00"},{"v":13,"d":"$13.00"},{"v":8,"d":"$8.00"},{"v":22,"d":"$22.00"},{"v":18,"d":"$18.00"},{"v":8,"d":"$8.00"},{"v":17,"d":"$17.00"},{"v":20,"d":"$20.00"},{"v":8,"d":"$8.00"},{"v":4,"d":"$4.00"},{"v":12,"d":"$12.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":158,"d":"$158.00"}},{"v":0.12,"d":"12%"},{"$f":"D7/D$26","v":{"v":0.0423728813559322,"d":"4%"}},{"$f":"E7/E$26","v":{"v":0.08780487804878048,"d":"9%"}},{"$f":"F7/F$26","v":{"v":0.05220883534136546,"d":"5%"}},{"$f":"G7/G$26","v":{"v":0.03065134099616858,"d":"3%"}},{"$f":"H7/H$26","v":{"v":0.08560311284046693,"d":"9%"}},{"$f":"I7/I$26","v":{"v":0.06569343065693431,"d":"7%"}},{"$f":"J7/J$26","v":{"v":0.03007518796992481,"d":"3%"}},{"$f":"K7/K$26","v":{"v":0.07234042553191489,"d":"7%"}},{"$f":"L7/L$26","v":{"v":0.08695652173913043,"d":"9%"}},{"$f":"M7/M$26","v":{"v":0.03088803088803089,"d":"3%"}},{"$f":"N7/N$26","v":{"v":0.013513513513513514,"d":"1%"}},{"$f":"O7/O$26","v":{"v":0.05194805194805195,"d":"5%"}},{"$f":"P7/P$26","v":{"v":0.05268422807602534,"d":"5%"}}]
[null,"Payroll expenses "," ",{"v":23,"d":"$23.00"},{"v":11,"d":"$11.00"},{"v":7,"d":"$7.00"},{"v":14,"d":"$14.00"},{"v":12,"d":"$12.00"},{"v":19,"d":"$19.00"},{"v":19,"d":"$19.00"},{"v":4,"d":"$4.00"},{"v":7,"d":"$7.00"},{"v":13,"d":"$13.00"},{"v":25,"d":"$25.00"},{"v":5,"d":"$5.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":159,"d":"$159.00"}},{"v":0.09,"d":"9%"},{"v":0.09745762711864407,"d":"10%"},{"v":0.05365853658536585,"d":"5%"},{"v":0.028112449799196786,"d":"3%"},{"v":0.05363984674329502,"d":"5%"},{"v":0.04669260700389105,"d":"5%"},{"v":0.06934306569343066,"d":"7%"},{"v":0.07142857142857142,"d":"7%"},{"v":0.01702127659574468,"d":"2%"},{"v":0.030434782608695653,"d":"3%"},{"v":0.05019305019305019,"d":"5%"},{"v":0.08445945945945946,"d":"8%"},{"v":0.021645021645021644,"d":"2%"},{"v":0.05301767255751917,"d":"5%"}]
[null,"Outside services"," ",{"v":23,"d":"$23.00"},{"v":20,"d":"$20.00"},{"v":3,"d":"$3.00"},{"v":16,"d":"$16.00"},{"v":10,"d":"$10.00"},{"v":5,"d":"$5.00"},{"v":20,"d":"$20.00"},{"v":7,"d":"$7.00"},{"v":4,"d":"$4.00"},{"v":22,"d":"$22.00"},{"v":13,"d":"$13.00"},{"v":14,"d":"$14.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":157,"d":"$157.00"}},{"v":0.02,"d":"2%"},{"v":0.09745762711864407,"d":"10%"},{"v":0.0975609756097561,"d":"10%"},{"v":0.012048192771084338,"d":"1%"},{"v":0.06130268199233716,"d":"6%"},{"v":0.038910505836575876,"d":"4%"},{"v":0.01824817518248175,"d":"2%"},{"v":0.07518796992481203,"d":"8%"},{"v":0.029787234042553193,"d":"3%"},{"v":0.017391304347826087,"d":"2%"},{"v":0.08494208494208494,"d":"8%"},{"v":0.04391891891891892,"d":"4%"},{"v":0.06060606060606061,"d":"6%"},{"v":0.05235078359453151,"d":"5%"}]
[null,"Supplies (office and operating)"," ",{"v":19,"d":"$19.00"},{"v":4,"d":"$4.00"},{"v":7,"d":"$7.00"},{"v":14,"d":"$14.00"},{"v":22,"d":"$22.00"},{"v":10,"d":"$10.00"},{"v":22,"d":"$22.00"},{"v":5,"d":"$5.00"},{"v":4,"d":"$4.00"},{"v":12,"d":"$12.00"},{"v":18,"d":"$18.00"},{"v":24,"d":"$24.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":161,"d":"$161.00"}},{"v":0.08,"d":"8%"},{"v":0.08050847457627118,"d":"8%"},{"v":0.01951219512195122,"d":"2%"},{"v":0.028112449799196786,"d":"3%"},{"v":0.05363984674329502,"d":"5%"},{"v":0.08560311284046693,"d":"9%"},{"v":0.0364963503649635,"d":"4%"},{"v":0.08270676691729323,"d":"8%"},{"v":0.02127659574468085,"d":"2%"},{"v":0.017391304347826087,"d":"2%"},{"v":0.04633204633204633,"d":"5%"},{"v":0.060810810810810814,"d":"6%"},{"v":0.1038961038961039,"d":"10%"},{"v":0.05368456152050684,"d":"5%"}]
[null,"Repairs and maintenance"," ",{"v":11,"d":"$11.00"},{"v":11,"d":"$11.00"},{"v":17,"d":"$17.00"},{"v":12,"d":"$12.00"},{"v":2,"d":"$2.00"},{"v":14,"d":"$14.00"},{"v":12,"d":"$12.00"},{"v":10,"d":"$10.00"},{"v":18,"d":"$18.00"},{"v":11,"d":"$11.00"},{"v":23,"d":"$23.00"},{"v":11,"d":"$11.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":152,"d":"$152.00"}},{"v":0.03,"d":"3%"},{"v":0.046610169491525424,"d":"5%"},{"v":0.05365853658536585,"d":"5%"},{"v":0.06827309236947791,"d":"7%"},{"v":0.04597701149425287,"d":"5%"},{"v":0.007782101167315175,"d":"1%"},{"v":0.051094890510948905,"d":"5%"},{"v":0.045112781954887216,"d":"5%"},{"v":0.0425531914893617,"d":"4%"},{"v":0.0782608695652174,"d":"8%"},{"v":0.04247104247104247,"d":"4%"},{"v":0.0777027027027027,"d":"8%"},{"v":0.047619047619047616,"d":"5%"},{"v":0.050683561187062354,"d":"5%"}]
[null,"Advertising"," ",{"v":2,"d":"$2.00"},{"v":16,"d":"$16.00"},{"v":6,"d":"$6.00"},{"v":13,"d":"$13.00"},{"v":11,"d":"$11.00"},{"v":22,"d":"$22.00"},{"v":21,"d":"$21.00"},{"v":3,"d":"$3.00"},{"v":12,"d":"$12.00"},{"v":7,"d":"$7.00"},{"v":17,"d":"$17.00"},{"v":20,"d":"$20.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":150,"d":"$150.00"}},{"v":0.15,"d":"15%"},{"v":0.00847457627118644,"d":"1%"},{"v":0.07804878048780488,"d":"8%"},{"v":0.024096385542168676,"d":"2%"},{"v":0.04980842911877394,"d":"5%"},{"v":0.042801556420233464,"d":"4%"},{"v":0.08029197080291971,"d":"8%"},{"v":0.07894736842105263,"d":"8%"},{"v":0.01276595744680851,"d":"1%"},{"v":0.05217391304347826,"d":"5%"},{"v":0.02702702702702703,"d":"3%"},{"v":0.057432432432432436,"d":"6%"},{"v":0.08658008658008658,"d":"9%"},{"v":0.050016672224074694,"d":"5%"}]
[null,"Car, delivery and travel"," ",{"v":8,"d":"$8.00"},{"v":17,"d":"$17.00"},{"v":11,"d":"$11.00"},{"v":11,"d":"$11.00"},{"v":21,"d":"$21.00"},{"v":9,"d":"$9.00"},{"v":20,"d":"$20.00"},{"v":3,"d":"$3.00"},{"v":14,"d":"$14.00"},{"v":22,"d":"$22.00"},{"v":16,"d":"$16.00"},{"v":12,"d":"$12.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":164,"d":"$164.00"}},{"v":0.12,"d":"12%"},{"v":0.03389830508474576,"d":"3%"},{"v":0.08292682926829269,"d":"8%"},{"v":0.04417670682730924,"d":"4%"},{"v":0.0421455938697318,"d":"4%"},{"v":0.08171206225680934,"d":"8%"},{"v":0.032846715328467155,"d":"3%"},{"v":0.07518796992481203,"d":"8%"},{"v":0.01276595744680851,"d":"1%"},{"v":0.06086956521739131,"d":"6%"},{"v":0.08494208494208494,"d":"8%"},{"v":0.05405405405405406,"d":"5%"},{"v":0.05194805194805195,"d":"5%"},{"v":0.05468489496498833,"d":"5%"}]
[null,"Accounting and legal"," ",{"v":5,"d":"$5.00"},{"v":13,"d":"$13.00"},{"v":6,"d":"$6.00"},{"v":15,"d":"$15.00"},{"v":19,"d":"$19.00"},{"v":10,"d":"$10.00"},{"v":12,"d":"$12.00"},{"v":9,"d":"$9.00"},{"v":15,"d":"$15.00"},{"v":16,"d":"$16.00"},{"v":4,"d":"$4.00"},{"v":9,"d":"$9.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":133,"d":"$133.00"}},{"v":0.09,"d":"9%"},{"v":0.0211864406779661,"d":"2%"},{"v":0.06341463414634146,"d":"6%"},{"v":0.024096385542168676,"d":"2%"},{"v":0.05747126436781609,"d":"6%"},{"v":0.07392996108949416,"d":"7%"},{"v":0.0364963503649635,"d":"4%"},{"v":0.045112781954887216,"d":"5%"},{"v":0.03829787234042553,"d":"4%"},{"v":0.06521739130434782,"d":"7%"},{"v":0.06177606177606178,"d":"6%"},{"v":0.013513513513513514,"d":"1%"},{"v":0.03896103896103896,"d":"4%"},{"v":0.04434811603867956,"d":"4%"}]
[null,"Rent"," ",{"v":8,"d":"$8.00"},{"v":4,"d":"$4.00"},{"v":23,"d":"$23.00"},{"v":25,"d":"$25.00"},{"v":10,"d":"$10.00"},{"v":24,"d":"$24.00"},{"v":22,"d":"$22.00"},{"v":5,"d":"$5.00"},{"v":12,"d":"$12.00"},{"v":24,"d":"$24.00"},{"v":24,"d":"$24.00"},{"v":12,"d":"$12.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":193,"d":"$193.00"}},{"v":0.01,"d":"1%"},{"v":0.03389830508474576,"d":"3%"},{"v":0.01951219512195122,"d":"2%"},{"v":0.09236947791164658,"d":"9%"},{"v":0.09578544061302682,"d":"10%"},{"v":0.038910505836575876,"d":"4%"},{"v":0.08759124087591241,"d":"9%"},{"v":0.08270676691729323,"d":"8%"},{"v":0.02127659574468085,"d":"2%"},{"v":0.05217391304347826,"d":"5%"},{"v":0.09266409266409266,"d":"9%"},{"v":0.08108108108108109,"d":"8%"},{"v":0.05194805194805195,"d":"5%"},{"v":0.06435478492830944,"d":"6%"}]
[null,"Telephone"," ",{"v":25,"d":"$25.00"},{"v":2,"d":"$2.00"},{"v":12,"d":"$12.00"},{"v":25,"d":"$25.00"},{"v":10,"d":"$10.00"},{"v":24,"d":"$24.00"},{"v":3,"d":"$3.00"},{"v":20,"d":"$20.00"},{"v":3,"d":"$3.00"},{"v":9,"d":"$9.00"},{"v":20,"d":"$20.00"},{"v":18,"d":"$18.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":171,"d":"$171.00"}},{"v":0.01,"d":"1%"},{"v":0.1059322033898305,"d":"11%"},{"v":0.00975609756097561,"d":"1%"},{"v":0.04819277108433735,"d":"5%"},{"v":0.09578544061302682,"d":"10%"},{"v":0.038910505836575876,"d":"4%"},{"v":0.08759124087591241,"d":"9%"},{"v":0.011278195488721804,"d":"1%"},{"v":0.0851063829787234,"d":"9%"},{"v":0.013043478260869565,"d":"1%"},{"v":0.03474903474903475,"d":"3%"},{"v":0.06756756756756757,"d":"7%"},{"v":0.07792207792207792,"d":"8%"},{"v":0.05701900633544515,"d":"6%"}]
[null,"Utilities"," ",{"v":16,"d":"$16.00"},{"v":19,"d":"$19.00"},{"v":9,"d":"$9.00"},{"v":16,"d":"$16.00"},{"v":13,"d":"$13.00"},{"v":2,"d":"$2.00"},{"v":4,"d":"$4.00"},{"v":24,"d":"$24.00"},{"v":16,"d":"$16.00"},{"v":22,"d":"$22.00"},{"v":7,"d":"$7.00"},{"v":18,"d":"$18.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":166,"d":"$166.00"}},{"v":0.01,"d":"1%"},{"v":0.06779661016949153,"d":"7%"},{"v":0.09268292682926829,"d":"9%"},{"v":0.03614457831325301,"d":"4%"},{"v":0.06130268199233716,"d":"6%"},{"v":0.05058365758754864,"d":"5%"},{"v":7.2992700729927005E-3,"d":"1%"},{"v":0.015037593984962405,"d":"2%"},{"v":0.10212765957446808,"d":"10%"},{"v":0.06956521739130435,"d":"7%"},{"v":0.08494208494208494,"d":"8%"},{"v":0.02364864864864865,"d":"2%"},{"v":0.07792207792207792,"d":"8%"},{"v":0.05535178392797599,"d":"6%"}]
[null,"Insurance"," ",{"v":12,"d":"$12.00"},{"v":9,"d":"$9.00"},{"v":16,"d":"$16.00"},{"v":19,"d":"$19.00"},{"v":25,"d":"$25.00"},{"v":17,"d":"$17.00"},{"v":20,"d":"$20.00"},{"v":14,"d":"$14.00"},{"v":5,"d":"$5.00"},{"v":14,"d":"$14.00"},{"v":5,"d":"$5.00"},{"v":2,"d":"$2.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":158,"d":"$158.00"}},{"v":0.01,"d":"1%"},{"v":0.05084745762711865,"d":"5%"},{"v":0.04390243902439024,"d":"4%"},{"v":0.0642570281124498,"d":"6%"},{"v":0.07279693486590039,"d":"7%"},{"v":0.09727626459143969,"d":"10%"},{"v":0.06204379562043796,"d":"6%"},{"v":0.07518796992481203,"d":"8%"},{"v":0.059574468085106386,"d":"6%"},{"v":0.021739130434782608,"d":"2%"},{"v":0.05405405405405406,"d":"5%"},{"v":0.016891891891891893,"d":"2%"},{"v":8.658008658008658E-3,"d":"1%"},{"v":0.05268422807602534,"d":"5%"}]
[null,"Taxes (real estate, etc.)"," ",{"v":16,"d":"$16.00"},{"v":13,"d":"$13.00"},{"v":10,"d":"$10.00"},{"v":7,"d":"$7.00"},{"v":13,"d":"$13.00"},{"v":3,"d":"$3.00"},{"v":13,"d":"$13.00"},{"v":17,"d":"$17.00"},{"v":9,"d":"$9.00"},{"v":4,"d":"$4.00"},{"v":22,"d":"$22.00"},{"v":18,"d":"$18.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":145,"d":"$145.00"}},{"v":0.14,"d":"14%"},{"v":0.06779661016949153,"d":"7%"},{"v":0.06341463414634146,"d":"6%"},{"v":0.040160642570281124,"d":"4%"},{"v":0.02681992337164751,"d":"3%"},{"v":0.05058365758754864,"d":"5%"},{"v":0.010948905109489052,"d":"1%"},{"v":0.04887218045112782,"d":"5%"},{"v":0.07234042553191489,"d":"7%"},{"v":0.0391304347826087,"d":"4%"},{"v":0.015444015444015444,"d":"2%"},{"v":0.07432432432432433,"d":"7%"},{"v":0.07792207792207792,"d":"8%"},{"v":0.048349449816605536,"d":"5%"}]
[null,"Interest"," ",{"v":3,"d":"$3.00"},{"v":2,"d":"$2.00"},{"v":19,"d":"$19.00"},{"v":21,"d":"$21.00"},{"v":13,"d":"$13.00"},{"v":9,"d":"$9.00"},{"v":7,"d":"$7.00"},{"v":13,"d":"$13.00"},{"v":3,"d":"$3.00"},{"v":6,"d":"$6.00"},{"v":10,"d":"$10.00"},{"v":13,"d":"$13.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":119,"d":"$119.00"}},{"v":0.06,"d":"6%"},{"v":0.012711864406779662,"d":"1%"},{"v":0.00975609756097561,"d":"1%"},{"v":0.07630522088353414,"d":"8%"},{"v":0.08045977011494253,"d":"8%"},{"v":0.05058365758754864,"d":"5%"},{"v":0.032846715328467155,"d":"3%"},{"v":0.02631578947368421,"d":"3%"},{"v":0.05531914893617021,"d":"6%"},{"v":0.013043478260869565,"d":"1%"},{"v":0.023166023166023165,"d":"2%"},{"v":0.033783783783783786,"d":"3%"},{"v":0.05627705627705628,"d":"6%"},{"v":0.039679893297765924,"d":"4%"}]
[null,"Depreciation"," ",{"v":8,"d":"$8.00"},{"v":7,"d":"$7.00"},{"v":6,"d":"$6.00"},{"v":7,"d":"$7.00"},{"v":7,"d":"$7.00"},{"v":6,"d":"$6.00"},{"v":15,"d":"$15.00"},{"v":23,"d":"$23.00"},{"v":21,"d":"$21.00"},{"v":16,"d":"$16.00"},{"v":19,"d":"$19.00"},{"v":7,"d":"$7.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":142,"d":"$142.00"}},{"v":0.01,"d":"1%"},{"v":0.03389830508474576,"d":"3%"},{"v":0.03414634146341464,"d":"3%"},{"v":0.024096385542168676,"d":"2%"},{"v":0.02681992337164751,"d":"3%"},{"v":0.027237354085603113,"d":"3%"},{"v":0.021897810218978103,"d":"2%"},{"v":0.05639097744360902,"d":"6%"},{"v":0.09787234042553192,"d":"10%"},{"v":0.09130434782608696,"d":"9%"},{"v":0.06177606177606178,"d":"6%"},{"v":0.06418918918918919,"d":"6%"},{"v":0.030303030303030304,"d":"3%"},{"v":0.047349116372124044,"d":"5%"}]
[null,"Other expenses (specify)"," ",{"v":14,"d":"$14.00"},{"v":4,"d":"$4.00"},{"v":24,"d":"$24.00"},{"v":6,"d":"$6.00"},{"v":20,"d":"$20.00"},{"v":14,"d":"$14.00"},{"v":21,"d":"$21.00"},{"v":20,"d":"$20.00"},{"v":22,"d":"$22.00"},{"v":3,"d":"$3.00"},{"v":14,"d":"$14.00"},{"v":6,"d":"$6.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":168,"d":"$168.00"}},{"v":0.01,"d":"1%"},{"v":0.059322033898305086,"d":"6%"},{"v":0.01951219512195122,"d":"2%"},{"v":0.0963855421686747,"d":"10%"},{"v":0.022988505747126436,"d":"2%"},{"v":0.07782101167315175,"d":"8%"},{"v":0.051094890510948905,"d":"5%"},{"v":0.07894736842105263,"d":"8%"},{"v":0.0851063829787234,"d":"9%"},{"v":0.09565217391304348,"d":"10%"},{"v":0.011583011583011582,"d":"1%"},{"v":0.0472972972972973,"d":"5%"},{"v":0.025974025974025976,"d":"3%"},{"v":0.056018672890963656,"d":"6%"}]
[null,"Other expenses (specify)"," ",{"v":14,"d":"$14.00"},{"v":7,"d":"$7.00"},{"v":24,"d":"$24.00"},{"v":10,"d":"$10.00"},{"v":7,"d":"$7.00"},{"v":24,"d":"$24.00"},{"v":2,"d":"$2.00"},{"v":11,"d":"$11.00"},{"v":21,"d":"$21.00"},{"v":19,"d":"$19.00"},{"v":19,"d":"$19.00"},{"v":20,"d":"$20.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":178,"d":"$178.00"}},{"v":0.01,"d":"1%"},{"v":0.059322033898305086,"d":"6%"},{"v":0.03414634146341464,"d":"3%"},{"v":0.0963855421686747,"d":"10%"},{"v":0.038314176245210725,"d":"4%"},{"v":0.027237354085603113,"d":"3%"},{"v":0.08759124087591241,"d":"9%"},{"v":0.007518796992481203,"d":"1%"},{"v":0.04680851063829787,"d":"5%"},{"v":0.09130434782608696,"d":"9%"},{"v":0.07335907335907337,"d":"7%"},{"v":0.06418918918918919,"d":"6%"},{"v":0.08658008658008658,"d":"9%"},{"v":0.059353117705901966,"d":"6%"}]
[null,"Other expenses (specify)"," ",{"v":11,"d":"$11.00"},{"v":8,"d":"$8.00"},{"v":25,"d":"$25.00"},{"v":11,"d":"$11.00"},{"v":9,"d":"$9.00"},{"v":24,"d":"$24.00"},{"v":13,"d":"$13.00"},{"v":14,"d":"$14.00"},{"v":19,"d":"$19.00"},{"v":24,"d":"$24.00"},{"v":15,"d":"$15.00"},{"v":7,"d":"$7.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":180,"d":"$180.00"}},{"v":0.01,"d":"1%"},{"v":0.046610169491525424,"d":"5%"},{"v":0.03902439024390244,"d":"4%"},{"v":0.10040160642570281,"d":"10%"},{"v":0.0421455938697318,"d":"4%"},{"v":0.03501945525291829,"d":"4%"},{"v":0.08759124087591241,"d":"9%"},{"v":0.04887218045112782,"d":"5%"},{"v":0.059574468085106386,"d":"6%"},{"v":0.08260869565217391,"d":"8%"},{"v":0.09266409266409266,"d":"9%"},{"v":0.05067567567567568,"d":"5%"},{"v":0.030303030303030304,"d":"3%"},{"v":0.06002000666888963,"d":"6%"}]
[null,"Misc. (unspecified)"," ",{"v":8,"d":"$8.00"},{"v":20,"d":"$20.00"},{"v":11,"d":"$11.00"},{"v":11,"d":"$11.00"},{"v":11,"d":"$11.00"},{"v":20,"d":"$20.00"},{"v":12,"d":"$12.00"},{"v":16,"d":"$16.00"},{"v":5,"d":"$5.00"},{"v":7,"d":"$7.00"},{"v":21,"d":"$21.00"},{"v":3,"d":"$3.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":145,"d":"$145.00"}},{"v":0.02,"d":"2%"},{"v":0.03389830508474576,"d":"3%"},{"v":0.0975609756097561,"d":"10%"},{"v":0.04417670682730924,"d":"4%"},{"v":0.0421455938697318,"d":"4%"},{"v":0.042801556420233464,"d":"4%"},{"v":0.072992700729927,"d":"7%"},{"v":0.045112781954887216,"d":"5%"},{"v":0.06808510638297872,"d":"7%"},{"v":0.021739130434782608,"d":"2%"},{"v":0.02702702702702703,"d":"3%"},{"v":0.07094594594594594,"d":"7%"},{"v":0.012987012987012988,"d":"1%"},{"v":0.048349449816605536,"d":"5%"}]
[null,"TOTAL EXPENSES",null,{"$f":"SUM(D7:D25)","v":{"v":236,"d":"$236.00"}},{"v":205,"d":"$205.00"},{"v":249,"d":"$249.00"},{"v":261,"d":"$261.00"},{"v":257,"d":"$257.00"},{"v":274,"d":"$274.00"},{"v":266,"d":"$266.00"},{"v":235,"d":"$235.00"},{"v":230,"d":"$230.00"},{"v":259,"d":"$259.00"},{"v":296,"d":"$296.00"},{"v":231,"d":"$231.00"},{"$f":"SUM(tblExpenses[[#This Row],[JAN]:[DEC]])","v":{"v":2999,"d":"$2,999.00"}},{"$f":"SUM(Q7:Q25)","v":{"v":1,"d":"100%"}},{"$f":"D26/D$26","v":{"v":1,"d":"100%"}},{"$f":"E26/E$26","v":{"v":1,"d":"100%"}},{"$f":"F26/F$26","v":{"v":1,"d":"100%"}},{"$f":"G26/G$26","v":{"v":1,"d":"100%"}},{"$f":"H26/H$26","v":{"v":1,"d":"100%"}},{"$f":"I26/I$26","v":{"v":1,"d":"100%"}},{"$f":"J26/J$26","v":{"v":1,"d":"100%"}},{"$f":"K26/K$26","v":{"v":1,"d":"100%"}},{"$f":"L26/L$26","v":{"v":1,"d":"100%"}},{"$f":"M26/M$26","v":{"v":1,"d":"100%"}},{"$f":"N26/N$26","v":{"v":1,"d":"100%"}},{"$f":"O26/O$26","v":{"v":1,"d":"100%"}},{"$f":"P26/P$26","v":{"v":1,"d":"100%"}}]
[null,"NET PROFIT",null,{"$f":"'Cost of sales'!D15-D26","v":{"v":123,"d":"$123.00"}},{"$f":"'Cost of sales'!E15-E26","v":{"v":175,"d":"$175.00"}},{"$f":"'Cost of sales'!F15-F26","v":{"v":256,"d":"$256.00"}},{"$f":"'Cost of sales'!G15-G26","v":{"v":109,"d":"$109.00"}},{"$f":"'Cost of sales'!H15-H26","v":{"v":156,"d":"$156.00"}},{"$f":"'Cost of sales'!I15-I26","v":{"v":-8,"d":"-$8.00"}},{"$f":"'Cost of sales'!J15-J26","v":{"v":32,"d":"$32.00"}},{"$f":"'Cost of sales'!K15-K26","v":{"v":214,"d":"$214.00"}},{"$f":"'Cost of sales'!L15-L26","v":{"v":100,"d":"$100.00"}},{"$f":"'Cost of sales'!M15-M26","v":{"v":148,"d":"$148.00"}},{"$f":"'Cost of sales'!N15-N26","v":{"v":179,"d":"$179.00"}},{"$f":"'Cost of sales'!O15-O26","v":{"v":359,"d":"$359.00"}},{"$f":"'Cost of sales'!P15-P26","v":{"v":1843,"d":"$1,843.00"}}]