{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["収益 (売上)","売上原価","経費"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"収益 (売上)","index":0,"n_rows":12,"n_cols":30,"rows_kept":12}
[null,"12 か月",{"$nulls":27},"会社名"]
[null,"損益予測",{"$nulls":25},"会計年度の開始:","1 月",{"$f":"YEAR(TODAY())","v":2017}]
[{"$nulls":3},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo,1),\"yyyy 年 m 月\"))","v":"2017 年 1 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+1,1),\"yyyy 年 m 月\"))","v":"2017 年 2 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+2,1),\"yyyy 年 m 月\"))","v":"2017 年 3 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+3,1),\"yyyy 年 m 月\"))","v":"2017 年 4 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+4,1),\"yyyy 年 m 月\"))","v":"2017 年 5 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+5,1),\"yyyy 年 m 月\"))","v":"2017 年 6 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+6,1),\"yyyy 年 m 月\"))","v":"2017 年 7 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+7,1),\"yyyy 年 m 月\"))","v":"2017 年 8 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+8,1),\"yyyy 年 m 月\"))","v":"2017 年 9 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+9,1),\"yyyy 年 m 月\"))","v":"2017 年 10 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+10,1),\"yyyy 年 m 月\"))","v":"2017 年 11 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+11,1),\"yyyy 年 m 月\"))","v":"2017 年 12 月"},"年次","インデックス %",{"$f":"IF(RIGHT(D3,4)>\"0\",RIGHT(D3,4),RIGHT(D3,3))&\" %\"","v":"1 月 %"},{"$f":"IF(RIGHT(E3,4)>\"0\",RIGHT(E3,4),RIGHT(E3,3))&\" %\"","v":"2 月 %"},"3 月 %","4 月 %","5 月 %","6 月 %","7 月 %","8 月 %","9 月 %","10 月 %","11 月 %","12 月 %","年 %"]
[null,"収益 (売上)","トレンド","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年次","インデックス %","1 月 %","2 月 %","3 月 %","4 月 %","5 月 %","6 月 %","7 月 %","8 月 %","9 月 %","10 月 %","11 月 %","12 月 %","年 %"]
[null,"収益 1",null,{"v":18600,"d":"¥18,600"},{"v":10800,"d":"¥10,800"},{"v":9200,"d":"¥9,200"},{"v":12200,"d":"¥12,200"},{"v":19000,"d":"¥19,000"},{"v":7100,"d":"¥7,100"},{"v":2100,"d":"¥2,100"},{"v":3700,"d":"¥3,700"},{"v":2400,"d":"¥2,400"},{"v":17800,"d":"¥17,800"},{"v":9200,"d":"¥9,200"},{"v":9700,"d":"¥9,700"},{"$f":"SUM(収益[[#This Row],[1 月]:[12 月]])","v":{"v":121800,"d":"¥121,800"}},{"v":0.12,"d":"12%"},{"$f":"IFERROR(収益[[#This Row],[1 月]]/収益[[#Totals],[1 月]],\"-\")","v":{"v":0.2980769230769231,"d":"30%"}},{"$f":"IFERROR(収益[[#This Row],[2 月]]/収益[[#Totals],[2 月]],\"-\")","v":{"v":0.14673913043478262,"d":"15%"}},{"$f":"IFERROR(収益[[#This Row],[3 月]]/収益[[#Totals],[3 月]],\"-\")","v":{"v":0.11219512195121951,"d":"11%"}},{"$f":"IFERROR(収益[[#This Row],[4 月]]/収益[[#Totals],[4 月]],\"-\")","v":{"v":0.19967266775777415,"d":"20%"}},{"$f":"IFERROR(収益[[#This Row],[5 月]]/収益[[#Totals],[5 月]],\"-\")","v":{"v":0.23399014778325122,"d":"23%"}},{"$f":"IFERROR(収益[[#This Row],[6 月]]/収益[[#Totals],[6 月]],\"-\")","v":{"v":0.12283737024221453,"d":"12%"}},{"$f":"IFERROR(収益[[#This Row],[7 月]]/収益[[#Totals],[7 月]],\"-\")","v":{"v":0.035175879396984924,"d":"4%"}},{"$f":"IFERROR(収益[[#This Row],[8 月]]/収益[[#Totals],[8 月]],\"-\")","v":{"v":0.054814814814814816,"d":"5%"}},{"$f":"IFERROR(収益[[#This Row],[9 月]]/収益[[#Totals],[9 月]],\"-\")","v":{"v":0.03225806451612903,"d":"3%"}},{"$f":"IFERROR(収益[[#This Row],[10 月]]/収益[[#Totals],[10 月]],\"-\")","v":{"v":0.26138032305433184,"d":"26%"}},{"$f":"IFERROR(収益[[#This Row],[11 月]]/収益[[#Totals],[11 月]],\"-\")","v":{"v":0.12449255751014884,"d":"12%"}},{"$f":"IFERROR(収益[[#This Row],[12 月]]/収益[[#Totals],[12 月]],\"-\")","v":{"v":0.09300095877277086,"d":"9%"}},{"$f":"IFERROR(収益[[#This Row],[年次]]/収益[[#Totals],[年次]],\"-\")","v":{"v":0.14064665127020784,"d":"14%"}}]
[null,"収益 2",null,{"v":1500,"d":"¥1,500"},{"v":1600,"d":"¥1,600"},{"v":19800,"d":"¥19,800"},{"v":4400,"d":"¥4,400"},{"v":2500,"d":"¥2,500"},{"v":6800,"d":"¥6,800"},{"v":4300,"d":"¥4,300"},{"v":11900,"d":"¥11,900"},{"v":3700,"d":"¥3,700"},{"v":11800,"d":"¥11,800"},{"v":2900,"d":"¥2,900"},{"v":17100,"d":"¥17,100"},{"$f":"SUM(収益[[#This Row],[1 月]:[12 月]])","v":{"v":88300,"d":"¥88,300"}},{"v":0.18,"d":"18%"},{"$f":"IFERROR(収益[[#This Row],[1 月]]/収益[[#Totals],[1 月]],\"-\")","v":{"v":0.02403846153846154,"d":"2%"}},{"$f":"IFERROR(収益[[#This Row],[2 月]]/収益[[#Totals],[2 月]],\"-\")","v":{"v":0.021739130434782608,"d":"2%"}},{"$f":"IFERROR(収益[[#This Row],[3 月]]/収益[[#Totals],[3 月]],\"-\")","v":{"v":0.24146341463414633,"d":"24%"}},{"$f":"IFERROR(収益[[#This Row],[4 月]]/収益[[#Totals],[4 月]],\"-\")","v":{"v":0.07201309328968904,"d":"7%"}},{"$f":"IFERROR(収益[[#This Row],[5 月]]/収益[[#Totals],[5 月]],\"-\")","v":{"v":0.03078817733990148,"d":"3%"}},{"$f":"IFERROR(収益[[#This Row],[6 月]]/収益[[#Totals],[6 月]],\"-\")","v":{"v":0.11764705882352941,"d":"12%"}},{"$f":"IFERROR(収益[[#This Row],[7 月]]/収益[[#Totals],[7 月]],\"-\")","v":{"v":0.07202680067001675,"d":"7%"}},{"$f":"IFERROR(収益[[#This Row],[8 月]]/収益[[#Totals],[8 月]],\"-\")","v":{"v":0.17629629629629628,"d":"18%"}},{"$f":"IFERROR(収益[[#This Row],[9 月]]/収益[[#Totals],[9 月]],\"-\")","v":{"v":0.04973118279569892,"d":"5%"}},{"$f":"IFERROR(収益[[#This Row],[10 月]]/収益[[#Totals],[10 月]],\"-\")","v":{"v":0.17327459618208516,"d":"17%"}},{"$f":"IFERROR(収益[[#This Row],[11 月]]/収益[[#Totals],[11 月]],\"-\")","v":{"v":0.03924221921515562,"d":"4%"}},{"$f":"IFERROR(収益[[#This Row],[12 月]]/収益[[#Totals],[12 月]],\"-\")","v":{"v":0.16395014381591563,"d":"16%"}},{"$f":"IFERROR(収益[[#This Row],[年次]]/収益[[#Totals],[年次]],\"-\")","v":{"v":0.10196304849884527,"d":"10%"}}]
[null,"収益 3",null,{"v":16600,"d":"¥16,600"},{"v":18500,"d":"¥18,500"},{"v":8900,"d":"¥8,900"},{"v":17000,"d":"¥17,000"},{"v":13100,"d":"¥13,100"},{"v":7000,"d":"¥7,000"},{"v":5000,"d":"¥5,000"},{"v":14900,"d":"¥14,900"},{"v":17900,"d":"¥17,900"},{"v":10400,"d":"¥10,400"},{"v":11900,"d":"¥11,900"},{"v":18700,"d":"¥18,700"},{"$f":"SUM(収益[[#This Row],[1 月]:[12 月]])","v":{"v":159900,"d":"¥159,900"}},{"v":0.19,"d":"19%"},{"$f":"IFERROR(収益[[#This Row],[1 月]]/収益[[#Totals],[1 月]],\"-\")","v":{"v":0.266025641025641,"d":"27%"}},{"$f":"IFERROR(収益[[#This Row],[2 月]]/収益[[#Totals],[2 月]],\"-\")","v":{"v":0.2513586956521739,"d":"25%"}},{"$f":"IFERROR(収益[[#This Row],[3 月]]/収益[[#Totals],[3 月]],\"-\")","v":{"v":0.10853658536585366,"d":"11%"}},{"$f":"IFERROR(収益[[#This Row],[4 月]]/収益[[#Totals],[4 月]],\"-\")","v":{"v":0.27823240589198034,"d":"28%"}},{"$f":"IFERROR(収益[[#This Row],[5 月]]/収益[[#Totals],[5 月]],\"-\")","v":{"v":0.16133004926108374,"d":"16%"}},{"$f":"IFERROR(収益[[#This Row],[6 月]]/収益[[#Totals],[6 月]],\"-\")","v":{"v":0.12110726643598616,"d":"12%"}},{"$f":"IFERROR(収益[[#This Row],[7 月]]/収益[[#Totals],[7 月]],\"-\")","v":{"v":0.08375209380234507,"d":"8%"}},{"$f":"IFERROR(収益[[#This Row],[8 月]]/収益[[#Totals],[8 月]],\"-\")","v":{"v":0.22074074074074074,"d":"22%"}},{"$f":"IFERROR(収益[[#This Row],[9 月]]/収益[[#Totals],[9 月]],\"-\")","v":{"v":0.24059139784946237,"d":"24%"}},{"$f":"IFERROR(収益[[#This Row],[10 月]]/収益[[#Totals],[10 月]],\"-\")","v":{"v":0.1527165932452276,"d":"15%"}},{"$f":"IFERROR(収益[[#This Row],[11 月]]/収益[[#Totals],[11 月]],\"-\")","v":{"v":0.16102841677943167,"d":"16%"}},{"$f":"IFERROR(収益[[#This Row],[12 月]]/収益[[#Totals],[12 月]],\"-\")","v":{"v":0.17929050814956854,"d":"18%"}},{"$f":"IFERROR(収益[[#This Row],[年次]]/収益[[#Totals],[年次]],\"-\")","v":{"v":0.18464203233256352,"d":"18%"}}]
[null,"収益 4",null,{"v":2100,"d":"¥2,100"},{"v":11300,"d":"¥11,300"},{"v":8300,"d":"¥8,300"},{"v":1700,"d":"¥1,700"},{"v":13000,"d":"¥13,000"},{"v":2600,"d":"¥2,600"},{"v":16700,"d":"¥16,700"},{"v":10200,"d":"¥10,200"},{"v":8200,"d":"¥8,200"},{"v":3300,"d":"¥3,300"},{"v":8800,"d":"¥8,800"},{"v":19300,"d":"¥19,300"},{"$f":"SUM(収益[[#This Row],[1 月]:[12 月]])","v":{"v":105500,"d":"¥105,500"}},{"v":0.11,"d":"11%"},{"$f":"IFERROR(収益[[#This Row],[1 月]]/収益[[#Totals],[1 月]],\"-\")","v":{"v":0.03365384615384615,"d":"3%"}},{"$f":"IFERROR(収益[[#This Row],[2 月]]/収益[[#Totals],[2 月]],\"-\")","v":{"v":0.15353260869565216,"d":"15%"}},{"$f":"IFERROR(収益[[#This Row],[3 月]]/収益[[#Totals],[3 月]],\"-\")","v":{"v":0.10121951219512196,"d":"10%"}},{"$f":"IFERROR(収益[[#This Row],[4 月]]/収益[[#Totals],[4 月]],\"-\")","v":{"v":0.027823240589198037,"d":"3%"}},{"$f":"IFERROR(収益[[#This Row],[5 月]]/収益[[#Totals],[5 月]],\"-\")","v":{"v":0.16009852216748768,"d":"16%"}},{"$f":"IFERROR(収益[[#This Row],[6 月]]/収益[[#Totals],[6 月]],\"-\")","v":{"v":0.04498269896193772,"d":"4%"}},{"$f":"IFERROR(収益[[#This Row],[7 月]]/収益[[#Totals],[7 月]],\"-\")","v":{"v":0.2797319932998325,"d":"28%"}},{"$f":"IFERROR(収益[[#This Row],[8 月]]/収益[[#Totals],[8 月]],\"-\")","v":{"v":0.1511111111111111,"d":"15%"}},{"$f":"IFERROR(収益[[#This Row],[9 月]]/収益[[#Totals],[9 月]],\"-\")","v":{"v":0.11021505376344086,"d":"11%"}},{"$f":"IFERROR(収益[[#This Row],[10 月]]/収益[[#Totals],[10 月]],\"-\")","v":{"v":0.048458149779735685,"d":"5%"}},{"$f":"IFERROR(収益[[#This Row],[11 月]]/収益[[#Totals],[11 月]],\"-\")","v":{"v":0.11907983761840325,"d":"12%"}},{"$f":"IFERROR(収益[[#This Row],[12 月]]/収益[[#Totals],[12 月]],\"-\")","v":{"v":0.1850431447746884,"d":"19%"}},{"$f":"IFERROR(収益[[#This Row],[年次]]/収益[[#Totals],[年次]],\"-\")","v":{"v":0.12182448036951501,"d":"12%"}}]
[null,"収益 5",null,{"v":7000,"d":"¥7,000"},{"v":16000,"d":"¥16,000"},{"v":12500,"d":"¥12,500"},{"v":8400,"d":"¥8,400"},{"v":19100,"d":"¥19,100"},{"v":9700,"d":"¥9,700"},{"v":5200,"d":"¥5,200"},{"v":4500,"d":"¥4,500"},{"v":17300,"d":"¥17,300"},{"v":13600,"d":"¥13,600"},{"v":14400,"d":"¥14,400"},{"v":16700,"d":"¥16,700"},{"$f":"SUM(収益[[#This Row],[1 月]:[12 月]])","v":{"v":144400,"d":"¥144,400"}},{"v":0.2,"d":"20%"},{"$f":"IFERROR(収益[[#This Row],[1 月]]/収益[[#Totals],[1 月]],\"-\")","v":{"v":0.11217948717948718,"d":"11%"}},{"$f":"IFERROR(収益[[#This Row],[2 月]]/収益[[#Totals],[2 月]],\"-\")","v":{"v":0.21739130434782608,"d":"22%"}},{"$f":"IFERROR(収益[[#This Row],[3 月]]/収益[[#Totals],[3 月]],\"-\")","v":{"v":0.1524390243902439,"d":"15%"}},{"$f":"IFERROR(収益[[#This Row],[4 月]]/収益[[#Totals],[4 月]],\"-\")","v":{"v":0.13747954173486088,"d":"14%"}},{"$f":"IFERROR(収益[[#This Row],[5 月]]/収益[[#Totals],[5 月]],\"-\")","v":{"v":0.23522167487684728,"d":"24%"}},{"$f":"IFERROR(収益[[#This Row],[6 月]]/収益[[#Totals],[6 月]],\"-\")","v":{"v":0.16782006920415224,"d":"17%"}},{"$f":"IFERROR(収益[[#This Row],[7 月]]/収益[[#Totals],[7 月]],\"-\")","v":{"v":0.08710217755443886,"d":"9%"}},{"$f":"IFERROR(収益[[#This Row],[8 月]]/収益[[#Totals],[8 月]],\"-\")","v":{"v":0.06666666666666667,"d":"7%"}},{"$f":"IFERROR(収益[[#This Row],[9 月]]/収益[[#Totals],[9 月]],\"-\")","v":{"v":0.2325268817204301,"d":"23%"}},{"$f":"IFERROR(収益[[#This Row],[10 月]]/収益[[#Totals],[10 月]],\"-\")","v":{"v":0.19970631424375918,"d":"20%"}},{"$f":"IFERROR(収益[[#This Row],[11 月]]/収益[[#Totals],[11 月]],\"-\")","v":{"v":0.19485791610284167,"d":"19%"}},{"$f":"IFERROR(収益[[#This Row],[12 月]]/収益[[#Totals],[12 月]],\"-\")","v":{"v":0.1601150527325024,"d":"16%"}},{"$f":"IFERROR(収益[[#This Row],[年次]]/収益[[#Totals],[年次]],\"-\")","v":{"v":0.16674364896073904,"d":"17%"}}]
[null,"収益 6",null,{"v":6100,"d":"¥6,100"},{"v":9900,"d":"¥9,900"},{"v":7000,"d":"¥7,000"},{"v":16200,"d":"¥16,200"},{"v":2800,"d":"¥2,800"},{"v":16300,"d":"¥16,300"},{"v":10100,"d":"¥10,100"},{"v":10300,"d":"¥10,300"},{"v":7800,"d":"¥7,800"},{"v":3300,"d":"¥3,300"},{"v":16200,"d":"¥16,200"},{"v":15900,"d":"¥15,900"},{"$f":"SUM(収益[[#This Row],[1 月]:[12 月]])","v":{"v":121900,"d":"¥121,900"}},{"v":0.1,"d":"10%"},{"$f":"IFERROR(収益[[#This Row],[1 月]]/収益[[#Totals],[1 月]],\"-\")","v":{"v":0.09775641025641026,"d":"10%"}},{"$f":"IFERROR(収益[[#This Row],[2 月]]/収益[[#Totals],[2 月]],\"-\")","v":{"v":0.13451086956521738,"d":"13%"}},{"$f":"IFERROR(収益[[#This Row],[3 月]]/収益[[#Totals],[3 月]],\"-\")","v":{"v":0.08536585365853659,"d":"9%"}},{"$f":"IFERROR(収益[[#This Row],[4 月]]/収益[[#Totals],[4 月]],\"-\")","v":{"v":0.265139116202946,"d":"27%"}},{"$f":"IFERROR(収益[[#This Row],[5 月]]/収益[[#Totals],[5 月]],\"-\")","v":{"v":0.034482758620689655,"d":"3%"}},{"$f":"IFERROR(収益[[#This Row],[6 月]]/収益[[#Totals],[6 月]],\"-\")","v":{"v":0.2820069204152249,"d":"28%"}},{"$f":"IFERROR(収益[[#This Row],[7 月]]/収益[[#Totals],[7 月]],\"-\")","v":{"v":0.16917922948073702,"d":"17%"}},{"$f":"IFERROR(収益[[#This Row],[8 月]]/収益[[#Totals],[8 月]],\"-\")","v":{"v":0.15259259259259259,"d":"15%"}},{"$f":"IFERROR(収益[[#This Row],[9 月]]/収益[[#Totals],[9 月]],\"-\")","v":{"v":0.10483870967741936,"d":"10%"}},{"$f":"IFERROR(収益[[#This Row],[10 月]]/収益[[#Totals],[10 月]],\"-\")","v":{"v":0.048458149779735685,"d":"5%"}},{"$f":"IFERROR(収益[[#This Row],[11 月]]/収益[[#Totals],[11 月]],\"-\")","v":{"v":0.21921515561569688,"d":"22%"}},{"$f":"IFERROR(収益[[#This Row],[12 月]]/収益[[#Totals],[12 月]],\"-\")","v":{"v":0.15244487056567593,"d":"15%"}},{"$f":"IFERROR(収益[[#This Row],[年次]]/収益[[#Totals],[年次]],\"-\")","v":{"v":0.1407621247113164,"d":"14%"}}]
[null,"収益 7",null,{"v":10500,"d":"¥10,500"},{"v":5500,"d":"¥5,500"},{"v":16300,"d":"¥16,300"},{"v":1200,"d":"¥1,200"},{"v":11700,"d":"¥11,700"},{"v":8300,"d":"¥8,300"},{"v":16300,"d":"¥16,300"},{"v":12000,"d":"¥12,000"},{"v":17100,"d":"¥17,100"},{"v":7900,"d":"¥7,900"},{"v":10500,"d":"¥10,500"},{"v":6900,"d":"¥6,900"},{"$f":"SUM(収益[[#This Row],[1 月]:[12 月]])","v":{"v":124200,"d":"¥124,200"}},{"v":0.1,"d":"10%"},{"$f":"IFERROR(収益[[#This Row],[1 月]]/収益[[#Totals],[1 月]],\"-\")","v":{"v":0.16826923076923078,"d":"17%"}},{"$f":"IFERROR(収益[[#This Row],[2 月]]/収益[[#Totals],[2 月]],\"-\")","v":{"v":0.07472826086956522,"d":"7%"}},{"$f":"IFERROR(収益[[#This Row],[3 月]]/収益[[#Totals],[3 月]],\"-\")","v":{"v":0.19878048780487806,"d":"20%"}},{"$f":"IFERROR(収益[[#This Row],[4 月]]/収益[[#Totals],[4 月]],\"-\")","v":{"v":0.019639934533551555,"d":"2%"}},{"$f":"IFERROR(収益[[#This Row],[5 月]]/収益[[#Totals],[5 月]],\"-\")","v":{"v":0.1440886699507389,"d":"14%"}},{"$f":"IFERROR(収益[[#This Row],[6 月]]/収益[[#Totals],[6 月]],\"-\")","v":{"v":0.14359861591695502,"d":"14%"}},{"$f":"IFERROR(収益[[#This Row],[7 月]]/収益[[#Totals],[7 月]],\"-\")","v":{"v":0.2730318257956449,"d":"27%"}},{"$f":"IFERROR(収益[[#This Row],[8 月]]/収益[[#Totals],[8 月]],\"-\")","v":{"v":0.17777777777777778,"d":"18%"}},{"$f":"IFERROR(収益[[#This Row],[9 月]]/収益[[#Totals],[9 月]],\"-\")","v":{"v":0.22983870967741934,"d":"23%"}},{"$f":"IFERROR(収益[[#This Row],[10 月]]/収益[[#Totals],[10 月]],\"-\")","v":{"v":0.11600587371512482,"d":"12%"}},{"$f":"IFERROR(収益[[#This Row],[11 月]]/収益[[#Totals],[11 月]],\"-\")","v":{"v":0.14208389715832206,"d":"14%"}},{"$f":"IFERROR(収益[[#This Row],[12 月]]/収益[[#Totals],[12 月]],\"-\")","v":{"v":0.06615532118887824,"d":"7%"}},{"$f":"IFERROR(収益[[#This Row],[年次]]/収益[[#Totals],[年次]],\"-\")","v":{"v":0.14341801385681294,"d":"14%"}}]
[null,"売上合計",null,{"$f":"SUBTOTAL(109,収益[1 月])","v":{"v":62400,"d":"¥62,400"}},{"$f":"SUBTOTAL(109,収益[2 月])","v":{"v":73600,"d":"¥73,600"}},{"$f":"SUBTOTAL(109,収益[3 月])","v":{"v":82000,"d":"¥82,000"}},{"$f":"SUBTOTAL(109,収益[4 月])","v":{"v":61100,"d":"¥61,100"}},{"$f":"SUBTOTAL(109,収益[5 月])","v":{"v":81200,"d":"¥81,200"}},{"$f":"SUBTOTAL(109,収益[6 月])","v":{"v":57800,"d":"¥57,800"}},{"$f":"SUBTOTAL(109,収益[7 月])","v":{"v":59700,"d":"¥59,700"}},{"$f":"SUBTOTAL(109,収益[8 月])","v":{"v":67500,"d":"¥67,500"}},{"$f":"SUBTOTAL(109,収益[9 月])","v":{"v":74400,"d":"¥74,400"}},{"$f":"SUBTOTAL(109,収益[10 月])","v":{"v":68100,"d":"¥68,100"}},{"$f":"SUBTOTAL(109,収益[11 月])","v":{"v":73900,"d":"¥73,900"}},{"$f":"SUBTOTAL(109,収益[12 月])","v":{"v":104300,"d":"¥104,300"}},{"$f":"SUBTOTAL(109,収益[年次])","v":{"v":866000,"d":"¥866,000"}},{"$f":"SUBTOTAL(109,収益[インデックス %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[1 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[2 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[3 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[4 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[5 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[6 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[7 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[8 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[9 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[10 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[11 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[12 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,収益[年 %])","v":{"v":1,"d":"100%"}}]

{"sheet":"売上原価","index":1,"n_rows":14,"n_cols":30,"rows_kept":14}
[null,{"$f":"Projection_Period_Title","v":"12 か月"},{"$nulls":27},{"$f":"会社名","v":"会社名"}]
[null,{"$f":"Wksht_Title","v":"損益予測"},{"$nulls":25},"会計年度:",{"$f":"FYMonthStart","v":"1 月"},{"$f":"FYStartYear","v":2017}]
[{"$nulls":3},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo,1),\"yyyy 年 m 月\"))","v":"2017 年 1 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+1,1),\"yyyy 年 m 月\"))","v":"2017 年 2 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+2,1),\"yyyy 年 m 月\"))","v":"2017 年 3 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+3,1),\"yyyy 年 m 月\"))","v":"2017 年 4 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+4,1),\"yyyy 年 m 月\"))","v":"2017 年 5 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+5,1),\"yyyy 年 m 月\"))","v":"2017 年 6 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+6,1),\"yyyy 年 m 月\"))","v":"2017 年 7 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+7,1),\"yyyy 年 m 月\"))","v":"2017 年 8 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+8,1),\"yyyy 年 m 月\"))","v":"2017 年 9 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+9,1),\"yyyy 年 m 月\"))","v":"2017 年 10 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+10,1),\"yyyy 年 m 月\"))","v":"2017 年 11 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+11,1),\"yyyy 年 m 月\"))","v":"2017 年 12 月"},"年次","インデックス %",{"$f":"IF(RIGHT(D3,4)>\"0\",RIGHT(D3,4),RIGHT(D3,3))&\" %\"","v":"1 月 %"},{"$f":"IF(RIGHT(E3,4)>\"0\",RIGHT(E3,4),RIGHT(E3,3))&\" %\"","v":"2 月 %"},"3 月 %","4 月 %","5 月 %","6 月 %","7 月 %","8 月 %","9 月 %","10 月 %","11 月 %","12 月 %","年 %"]
[null,"売上原価","トレンド","1 月","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年次","インデックス %","1 月 %","2 月 %","3 月 %","4 月 %","5 月 %","6 月 %","7 月 %","8 月 %","9 月 %","10 月 %","11 月 %","12 月 %","年 %"]
[null,"コスト 1",null,{"v":6100,"d":"¥6,100"},{"v":7800,"d":"¥7,800"},{"v":6500,"d":"¥6,500"},{"v":2900,"d":"¥2,900"},{"v":12500,"d":"¥12,500"},{"v":4900,"d":"¥4,900"},{"v":1400,"d":"¥1,400"},{"v":2600,"d":"¥2,600"},{"v":1400,"d":"¥1,400"},{"v":12900,"d":"¥12,900"},{"v":6000,"d":"¥6,000"},{"v":6500,"d":"¥6,500"},{"$f":"SUM(売上原価[[#This Row],[1 月]:[12 月]])","v":{"v":71500,"d":"¥71,500"}},{"v":0.12,"d":"12%"},{"$f":"IFERROR(売上原価[[#This Row],[1 月]]/売上原価[[#Totals],[1 月]],\"-\")","v":{"v":0.23018867924528302,"d":"23%"}},{"$f":"IFERROR(売上原価[[#This Row],[2 月]]/売上原価[[#Totals],[2 月]],\"-\")","v":{"v":0.21910112359550563,"d":"22%"}},{"$f":"IFERROR(売上原価[[#This Row],[3 月]]/売上原価[[#Totals],[3 月]],\"-\")","v":{"v":0.20634920634920634,"d":"21%"}},{"$f":"IFERROR(売上原価[[#This Row],[4 月]]/売上原価[[#Totals],[4 月]],\"-\")","v":{"v":0.12033195020746888,"d":"12%"}},{"$f":"IFERROR(売上原価[[#This Row],[5 月]]/売上原価[[#Totals],[5 月]],\"-\")","v":{"v":0.3132832080200501,"d":"31%"}},{"$f":"IFERROR(売上原価[[#This Row],[6 月]]/売上原価[[#Totals],[6 月]],\"-\")","v":{"v":0.15705128205128205,"d":"16%"}},{"$f":"IFERROR(売上原価[[#This Row],[7 月]]/売上原価[[#Totals],[7 月]],\"-\")","v":{"v":0.046822742474916385,"d":"5%"}},{"$f":"IFERROR(売上原価[[#This Row],[8 月]]/売上原価[[#Totals],[8 月]],\"-\")","v":{"v":0.11504424778761062,"d":"12%"}},{"$f":"IFERROR(売上原価[[#This Row],[9 月]]/売上原価[[#Totals],[9 月]],\"-\")","v":{"v":0.033816425120772944,"d":"3%"}},{"$f":"IFERROR(売上原価[[#This Row],[10 月]]/売上原価[[#Totals],[10 月]],\"-\")","v":{"v":0.4708029197080292,"d":"47%"}},{"$f":"IFERROR(売上原価[[#This Row],[11 月]]/売上原価[[#Totals],[11 月]],\"-\")","v":{"v":0.22727272727272727,"d":"23%"}},{"$f":"IFERROR(売上原価[[#This Row],[12 月]]/売上原価[[#Totals],[12 月]],\"-\")","v":{"v":0.1434878587196468,"d":"14%"}},{"$f":"IFERROR(売上原価[[#This Row],[年次]]/売上原価[[#Totals],[年次]],\"-\")","v":{"v":0.18727082242011525,"d":"19%"}}]
[null,"コスト 2",null,{"v":700,"d":"¥700"},{"v":500,"d":"¥500"},{"v":6900,"d":"¥6,900"},{"v":3200,"d":"¥3,200"},{"v":1100,"d":"¥1,100"},{"v":3000,"d":"¥3,000"},{"v":2700,"d":"¥2,700"},{"v":3200,"d":"¥3,200"},{"v":1000,"d":"¥1,000"},{"v":4100,"d":"¥4,100"},{"v":1300,"d":"¥1,300"},{"v":10500,"d":"¥10,500"},{"$f":"SUM(売上原価[[#This Row],[1 月]:[12 月]])","v":{"v":38200,"d":"¥38,200"}},{"v":0.18,"d":"18%"},{"$f":"IFERROR(売上原価[[#This Row],[1 月]]/売上原価[[#Totals],[1 月]],\"-\")","v":{"v":0.026415094339622643,"d":"3%"}},{"$f":"IFERROR(売上原価[[#This Row],[2 月]]/売上原価[[#Totals],[2 月]],\"-\")","v":{"v":0.014044943820224719,"d":"1%"}},{"$f":"IFERROR(売上原価[[#This Row],[3 月]]/売上原価[[#Totals],[3 月]],\"-\")","v":{"v":0.21904761904761905,"d":"22%"}},{"$f":"IFERROR(売上原価[[#This Row],[4 月]]/売上原価[[#Totals],[4 月]],\"-\")","v":{"v":0.13278008298755187,"d":"13%"}},{"$f":"IFERROR(売上原価[[#This Row],[5 月]]/売上原価[[#Totals],[5 月]],\"-\")","v":{"v":0.02756892230576441,"d":"3%"}},{"$f":"IFERROR(売上原価[[#This Row],[6 月]]/売上原価[[#Totals],[6 月]],\"-\")","v":{"v":0.09615384615384616,"d":"10%"}},{"$f":"IFERROR(売上原価[[#This Row],[7 月]]/売上原価[[#Totals],[7 月]],\"-\")","v":{"v":0.0903010033444816,"d":"9%"}},{"$f":"IFERROR(売上原価[[#This Row],[8 月]]/売上原価[[#Totals],[8 月]],\"-\")","v":{"v":0.1415929203539823,"d":"14%"}},{"$f":"IFERROR(売上原価[[#This Row],[9 月]]/売上原価[[#Totals],[9 月]],\"-\")","v":{"v":0.024154589371980676,"d":"2%"}},{"$f":"IFERROR(売上原価[[#This Row],[10 月]]/売上原価[[#Totals],[10 月]],\"-\")","v":{"v":0.14963503649635038,"d":"15%"}},{"$f":"IFERROR(売上原価[[#This Row],[11 月]]/売上原価[[#Totals],[11 月]],\"-\")","v":{"v":0.04924242424242424,"d":"5%"}},{"$f":"IFERROR(売上原価[[#This Row],[12 月]]/売上原価[[#Totals],[12 月]],\"-\")","v":{"v":0.23178807947019867,"d":"23%"}},{"$f":"IFERROR(売上原価[[#This Row],[年次]]/売上原価[[#Totals],[年次]],\"-\")","v":{"v":0.1000523834468308,"d":"10%"}}]
[null,"コスト 3",null,{"v":9900,"d":"¥9,900"},{"v":9500,"d":"¥9,500"},{"v":5100,"d":"¥5,100"},{"v":9000,"d":"¥9,000"},{"v":2100,"d":"¥2,100"},{"v":3400,"d":"¥3,400"},{"v":3000,"d":"¥3,000"},{"v":2400,"d":"¥2,400"},{"v":10900,"d":"¥10,900"},{"v":1600,"d":"¥1,600"},{"v":2100,"d":"¥2,100"},{"v":5200,"d":"¥5,200"},{"$f":"SUM(売上原価[[#This Row],[1 月]:[12 月]])","v":{"v":64200,"d":"¥64,200"}},{"v":0.19,"d":"19%"},{"$f":"IFERROR(売上原価[[#This Row],[1 月]]/売上原価[[#Totals],[1 月]],\"-\")","v":{"v":0.37358490566037733,"d":"37%"}},{"$f":"IFERROR(売上原価[[#This Row],[2 月]]/売上原価[[#Totals],[2 月]],\"-\")","v":{"v":0.26685393258426965,"d":"27%"}},{"$f":"IFERROR(売上原価[[#This Row],[3 月]]/売上原価[[#Totals],[3 月]],\"-\")","v":{"v":0.1619047619047619,"d":"16%"}},{"$f":"IFERROR(売上原価[[#This Row],[4 月]]/売上原価[[#Totals],[4 月]],\"-\")","v":{"v":0.37344398340248963,"d":"37%"}},{"$f":"IFERROR(売上原価[[#This Row],[5 月]]/売上原価[[#Totals],[5 月]],\"-\")","v":{"v":0.05263157894736842,"d":"5%"}},{"$f":"IFERROR(売上原価[[#This Row],[6 月]]/売上原価[[#Totals],[6 月]],\"-\")","v":{"v":0.10897435897435898,"d":"11%"}},{"$f":"IFERROR(売上原価[[#This Row],[7 月]]/売上原価[[#Totals],[7 月]],\"-\")","v":{"v":0.10033444816053512,"d":"10%"}},{"$f":"IFERROR(売上原価[[#This Row],[8 月]]/売上原価[[#Totals],[8 月]],\"-\")","v":{"v":0.10619469026548672,"d":"11%"}},{"$f":"IFERROR(売上原価[[#This Row],[9 月]]/売上原価[[#Totals],[9 月]],\"-\")","v":{"v":0.2632850241545894,"d":"26%"}},{"$f":"IFERROR(売上原価[[#This Row],[10 月]]/売上原価[[#Totals],[10 月]],\"-\")","v":{"v":0.058394160583941604,"d":"6%"}},{"$f":"IFERROR(売上原価[[#This Row],[11 月]]/売上原価[[#Totals],[11 月]],\"-\")","v":{"v":0.07954545454545454,"d":"8%"}},{"$f":"IFERROR(売上原価[[#This Row],[12 月]]/売上原価[[#Totals],[12 月]],\"-\")","v":{"v":0.11479028697571744,"d":"11%"}},{"$f":"IFERROR(売上原価[[#This Row],[年次]]/売上原価[[#Totals],[年次]],\"-\")","v":{"v":0.1681508643268727,"d":"17%"}}]
[null,"コスト 4",null,{"v":1300,"d":"¥1,300"},{"v":2800,"d":"¥2,800"},{"v":1500,"d":"¥1,500"},{"v":800,"d":"¥800"},{"v":8400,"d":"¥8,400"},{"v":1200,"d":"¥1,200"},{"v":5400,"d":"¥5,400"},{"v":7200,"d":"¥7,200"},{"v":4900,"d":"¥4,900"},{"v":2400,"d":"¥2,400"},{"v":6000,"d":"¥6,000"},{"v":3900,"d":"¥3,900"},{"$f":"SUM(売上原価[[#This Row],[1 月]:[12 月]])","v":{"v":45800,"d":"¥45,800"}},{"v":0.11,"d":"11%"},{"$f":"IFERROR(売上原価[[#This Row],[1 月]]/売上原価[[#Totals],[1 月]],\"-\")","v":{"v":0.04905660377358491,"d":"5%"}},{"$f":"IFERROR(売上原価[[#This Row],[2 月]]/売上原価[[#Totals],[2 月]],\"-\")","v":{"v":0.07865168539325842,"d":"8%"}},{"$f":"IFERROR(売上原価[[#This Row],[3 月]]/売上原価[[#Totals],[3 月]],\"-\")","v":{"v":0.047619047619047616,"d":"5%"}},{"$f":"IFERROR(売上原価[[#This Row],[4 月]]/売上原価[[#Totals],[4 月]],\"-\")","v":{"v":0.03319502074688797,"d":"3%"}},{"$f":"IFERROR(売上原価[[#This Row],[5 月]]/売上原価[[#Totals],[5 月]],\"-\")","v":{"v":0.21052631578947367,"d":"21%"}},{"$f":"IFERROR(売上原価[[#This Row],[6 月]]/売上原価[[#Totals],[6 月]],\"-\")","v":{"v":0.038461538461538464,"d":"4%"}},{"$f":"IFERROR(売上原価[[#This Row],[7 月]]/売上原価[[#Totals],[7 月]],\"-\")","v":{"v":0.1806020066889632,"d":"18%"}},{"$f":"IFERROR(売上原価[[#This Row],[8 月]]/売上原価[[#Totals],[8 月]],\"-\")","v":{"v":0.3185840707964602,"d":"32%"}},{"$f":"IFERROR(売上原価[[#This Row],[9 月]]/売上原価[[#Totals],[9 月]],\"-\")","v":{"v":0.11835748792270531,"d":"12%"}},{"$f":"IFERROR(売上原価[[#This Row],[10 月]]/売上原価[[#Totals],[10 月]],\"-\")","v":{"v":0.08759124087591241,"d":"9%"}},{"$f":"IFERROR(売上原価[[#This Row],[11 月]]/売上原価[[#Totals],[11 月]],\"-\")","v":{"v":0.22727272727272727,"d":"23%"}},{"$f":"IFERROR(売上原価[[#This Row],[12 月]]/売上原価[[#Totals],[12 月]],\"-\")","v":{"v":0.08609271523178808,"d":"9%"}},{"$f":"IFERROR(売上原価[[#This Row],[年次]]/売上原価[[#Totals],[年次]],\"-\")","v":{"v":0.11995809324253535,"d":"12%"}}]
[null,"コスト 5",null,{"v":3400,"d":"¥3,400"},{"v":7800,"d":"¥7,800"},{"v":4300,"d":"¥4,300"},{"v":3000,"d":"¥3,000"},{"v":7700,"d":"¥7,700"},{"v":5400,"d":"¥5,400"},{"v":2600,"d":"¥2,600"},{"v":1300,"d":"¥1,300"},{"v":5600,"d":"¥5,600"},{"v":3000,"d":"¥3,000"},{"v":4000,"d":"¥4,000"},{"v":6300,"d":"¥6,300"},{"$f":"SUM(売上原価[[#This Row],[1 月]:[12 月]])","v":{"v":54400,"d":"¥54,400"}},{"v":0.2,"d":"20%"},{"$f":"IFERROR(売上原価[[#This Row],[1 月]]/売上原価[[#Totals],[1 月]],\"-\")","v":{"v":0.12830188679245283,"d":"13%"}},{"$f":"IFERROR(売上原価[[#This Row],[2 月]]/売上原価[[#Totals],[2 月]],\"-\")","v":{"v":0.21910112359550563,"d":"22%"}},{"$f":"IFERROR(売上原価[[#This Row],[3 月]]/売上原価[[#Totals],[3 月]],\"-\")","v":{"v":0.1365079365079365,"d":"14%"}},{"$f":"IFERROR(売上原価[[#This Row],[4 月]]/売上原価[[#Totals],[4 月]],\"-\")","v":{"v":0.12448132780082988,"d":"12%"}},{"$f":"IFERROR(売上原価[[#This Row],[5 月]]/売上原価[[#Totals],[5 月]],\"-\")","v":{"v":0.19298245614035087,"d":"19%"}},{"$f":"IFERROR(売上原価[[#This Row],[6 月]]/売上原価[[#Totals],[6 月]],\"-\")","v":{"v":0.17307692307692307,"d":"17%"}},{"$f":"IFERROR(売上原価[[#This Row],[7 月]]/売上原価[[#Totals],[7 月]],\"-\")","v":{"v":0.08695652173913043,"d":"9%"}},{"$f":"IFERROR(売上原価[[#This Row],[8 月]]/売上原価[[#Totals],[8 月]],\"-\")","v":{"v":0.05752212389380531,"d":"6%"}},{"$f":"IFERROR(売上原価[[#This Row],[9 月]]/売上原価[[#Totals],[9 月]],\"-\")","v":{"v":0.13526570048309178,"d":"14%"}},{"$f":"IFERROR(売上原価[[#This Row],[10 月]]/売上原価[[#Totals],[10 月]],\"-\")","v":{"v":0.10948905109489052,"d":"11%"}},{"$f":"IFERROR(売上原価[[#This Row],[11 月]]/売上原価[[#Totals],[11 月]],\"-\")","v":{"v":0.15151515151515152,"d":"15%"}},{"$f":"IFERROR(売上原価[[#This Row],[12 月]]/売上原価[[#Totals],[12 月]],\"-\")","v":{"v":0.1390728476821192,"d":"14%"}},{"$f":"IFERROR(売上原価[[#This Row],[年次]]/売上原価[[#Totals],[年次]],\"-\")","v":{"v":0.14248297537978,"d":"14%"}}]
[null,"コスト 6",null,{"v":3300,"d":"¥3,300"},{"v":6100,"d":"¥6,100"},{"v":4200,"d":"¥4,200"},{"v":4300,"d":"¥4,300"},{"v":1900,"d":"¥1,900"},{"v":9400,"d":"¥9,400"},{"v":4600,"d":"¥4,600"},{"v":1500,"d":"¥1,500"},{"v":5500,"d":"¥5,500"},{"v":1500,"d":"¥1,500"},{"v":3700,"d":"¥3,700"},{"v":8900,"d":"¥8,900"},{"$f":"SUM(売上原価[[#This Row],[1 月]:[12 月]])","v":{"v":54900,"d":"¥54,900"}},{"v":0.1,"d":"10%"},{"$f":"IFERROR(売上原価[[#This Row],[1 月]]/売上原価[[#Totals],[1 月]],\"-\")","v":{"v":0.12452830188679245,"d":"12%"}},{"$f":"IFERROR(売上原価[[#This Row],[2 月]]/売上原価[[#Totals],[2 月]],\"-\")","v":{"v":0.17134831460674158,"d":"17%"}},{"$f":"IFERROR(売上原価[[#This Row],[3 月]]/売上原価[[#Totals],[3 月]],\"-\")","v":{"v":0.13333333333333333,"d":"13%"}},{"$f":"IFERROR(売上原価[[#This Row],[4 月]]/売上原価[[#Totals],[4 月]],\"-\")","v":{"v":0.17842323651452283,"d":"18%"}},{"$f":"IFERROR(売上原価[[#This Row],[5 月]]/売上原価[[#Totals],[5 月]],\"-\")","v":{"v":0.047619047619047616,"d":"5%"}},{"$f":"IFERROR(売上原価[[#This Row],[6 月]]/売上原価[[#Totals],[6 月]],\"-\")","v":{"v":0.30128205128205127,"d":"30%"}},{"$f":"IFERROR(売上原価[[#This Row],[7 月]]/売上原価[[#Totals],[7 月]],\"-\")","v":{"v":0.15384615384615385,"d":"15%"}},{"$f":"IFERROR(売上原価[[#This Row],[8 月]]/売上原価[[#Totals],[8 月]],\"-\")","v":{"v":0.06637168141592921,"d":"7%"}},{"$f":"IFERROR(売上原価[[#This Row],[9 月]]/売上原価[[#Totals],[9 月]],\"-\")","v":{"v":0.13285024154589373,"d":"13%"}},{"$f":"IFERROR(売上原価[[#This Row],[10 月]]/売上原価[[#Totals],[10 月]],\"-\")","v":{"v":0.05474452554744526,"d":"5%"}},{"$f":"IFERROR(売上原価[[#This Row],[11 月]]/売上原価[[#Totals],[11 月]],\"-\")","v":{"v":0.14015151515151514,"d":"14%"}},{"$f":"IFERROR(売上原価[[#This Row],[12 月]]/売上原価[[#Totals],[12 月]],\"-\")","v":{"v":0.19646799116997793,"d":"20%"}},{"$f":"IFERROR(売上原価[[#This Row],[年次]]/売上原価[[#Totals],[年次]],\"-\")","v":{"v":0.14379256155055004,"d":"14%"}}]
[null,"コスト 7",null,{"v":1800,"d":"¥1,800"},{"v":1100,"d":"¥1,100"},{"v":3000,"d":"¥3,000"},{"v":900,"d":"¥900"},{"v":6200,"d":"¥6,200"},{"v":3900,"d":"¥3,900"},{"v":10200,"d":"¥10,200"},{"v":4400,"d":"¥4,400"},{"v":12100,"d":"¥12,100"},{"v":1900,"d":"¥1,900"},{"v":3300,"d":"¥3,300"},{"v":4000,"d":"¥4,000"},{"$f":"SUM(売上原価[[#This Row],[1 月]:[12 月]])","v":{"v":52800,"d":"¥52,800"}},{"v":0.1,"d":"10%"},{"$f":"IFERROR(売上原価[[#This Row],[1 月]]/売上原価[[#Totals],[1 月]],\"-\")","v":{"v":0.06792452830188679,"d":"7%"}},{"$f":"IFERROR(売上原価[[#This Row],[2 月]]/売上原価[[#Totals],[2 月]],\"-\")","v":{"v":0.03089887640449438,"d":"3%"}},{"$f":"IFERROR(売上原価[[#This Row],[3 月]]/売上原価[[#Totals],[3 月]],\"-\")","v":{"v":0.09523809523809523,"d":"10%"}},{"$f":"IFERROR(売上原価[[#This Row],[4 月]]/売上原価[[#Totals],[4 月]],\"-\")","v":{"v":0.03734439834024896,"d":"4%"}},{"$f":"IFERROR(売上原価[[#This Row],[5 月]]/売上原価[[#Totals],[5 月]],\"-\")","v":{"v":0.15538847117794485,"d":"16%"}},{"$f":"IFERROR(売上原価[[#This Row],[6 月]]/売上原価[[#Totals],[6 月]],\"-\")","v":{"v":0.125,"d":"13%"}},{"$f":"IFERROR(売上原価[[#This Row],[7 月]]/売上原価[[#Totals],[7 月]],\"-\")","v":{"v":0.3411371237458194,"d":"34%"}},{"$f":"IFERROR(売上原価[[#This Row],[8 月]]/売上原価[[#Totals],[8 月]],\"-\")","v":{"v":0.19469026548672566,"d":"19%"}},{"$f":"IFERROR(売上原価[[#This Row],[9 月]]/売上原価[[#Totals],[9 月]],\"-\")","v":{"v":0.2922705314009662,"d":"29%"}},{"$f":"IFERROR(売上原価[[#This Row],[10 月]]/売上原価[[#Totals],[10 月]],\"-\")","v":{"v":0.06934306569343066,"d":"7%"}},{"$f":"IFERROR(売上原価[[#This Row],[11 月]]/売上原価[[#Totals],[11 月]],\"-\")","v":{"v":0.125,"d":"13%"}},{"$f":"IFERROR(売上原価[[#This Row],[12 月]]/売上原価[[#Totals],[12 月]],\"-\")","v":{"v":0.08830022075055188,"d":"9%"}},{"$f":"IFERROR(売上原価[[#This Row],[年次]]/売上原価[[#Totals],[年次]],\"-\")","v":{"v":0.13829229963331588,"d":"14%"}}]
[null,"売上原価合計",null,{"$f":"SUBTOTAL(109,売上原価[1 月])","v":{"v":26500,"d":"¥26,500"}},{"$f":"SUBTOTAL(109,売上原価[2 月])","v":{"v":35600,"d":"¥35,600"}},{"$f":"SUBTOTAL(109,売上原価[3 月])","v":{"v":31500,"d":"¥31,500"}},{"$f":"SUBTOTAL(109,売上原価[4 月])","v":{"v":24100,"d":"¥24,100"}},{"$f":"SUBTOTAL(109,売上原価[5 月])","v":{"v":39900,"d":"¥39,900"}},{"$f":"SUBTOTAL(109,売上原価[6 月])","v":{"v":31200,"d":"¥31,200"}},{"$f":"SUBTOTAL(109,売上原価[7 月])","v":{"v":29900,"d":"¥29,900"}},{"$f":"SUBTOTAL(109,売上原価[8 月])","v":{"v":22600,"d":"¥22,600"}},{"$f":"SUBTOTAL(109,売上原価[9 月])","v":{"v":41400,"d":"¥41,400"}},{"$f":"SUBTOTAL(109,売上原価[10 月])","v":{"v":27400,"d":"¥27,400"}},{"$f":"SUBTOTAL(109,売上原価[11 月])","v":{"v":26400,"d":"¥26,400"}},{"$f":"SUBTOTAL(109,売上原価[12 月])","v":{"v":45300,"d":"¥45,300"}},{"$f":"SUBTOTAL(109,売上原価[年次])","v":{"v":381800,"d":"¥381,800"}},{"$f":"SUBTOTAL(109,売上原価[インデックス %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[1 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[2 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[3 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[4 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[5 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[6 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[7 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[8 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[9 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[10 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[11 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[12 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,売上原価[年 %])","v":{"v":0.9999999999999999,"d":"100%"}}]
[]
[null,"粗利益",null,{"$f":"収益[[#Totals],[1 月]]-売上原価[[#Totals],[1 月]]","v":{"v":35900,"d":"¥35,900"}},{"$f":"収益[[#Totals],[2 月]]-売上原価[[#Totals],[2 月]]","v":{"v":38000,"d":"¥38,000"}},{"$f":"収益[[#Totals],[3 月]]-売上原価[[#Totals],[3 月]]","v":{"v":50500,"d":"¥50,500"}},{"$f":"収益[[#Totals],[4 月]]-売上原価[[#Totals],[4 月]]","v":{"v":37000,"d":"¥37,000"}},{"$f":"収益[[#Totals],[5 月]]-売上原価[[#Totals],[5 月]]","v":{"v":41300,"d":"¥41,300"}},{"$f":"収益[[#Totals],[6 月]]-売上原価[[#Totals],[6 月]]","v":{"v":26600,"d":"¥26,600"}},{"$f":"収益[[#Totals],[7 月]]-売上原価[[#Totals],[7 月]]","v":{"v":29800,"d":"¥29,800"}},{"$f":"収益[[#Totals],[8 月]]-売上原価[[#Totals],[8 月]]","v":{"v":44900,"d":"¥44,900"}},{"$f":"収益[[#Totals],[9 月]]-売上原価[[#Totals],[9 月]]","v":{"v":33000,"d":"¥33,000"}},{"$f":"収益[[#Totals],[10 月]]-売上原価[[#Totals],[10 月]]","v":{"v":40700,"d":"¥40,700"}},{"$f":"収益[[#Totals],[11 月]]-売上原価[[#Totals],[11 月]]","v":{"v":47500,"d":"¥47,500"}},{"$f":"収益[[#Totals],[12 月]]-売上原価[[#Totals],[12 月]]","v":{"v":59000,"d":"¥59,000"}},{"$f":"収益[[#Totals],[年次]]-売上原価[[#Totals],[年次]]","v":{"v":484200,"d":"¥484,200"}},null,{"$f":"D14/$P$14","v":{"v":0.0741429161503511,"d":"7%"}},{"v":0.07847996695580339,"d":"8%"},{"v":0.10429574555968608,"d":"10%"},{"v":0.07641470466749277,"d":"8%"},{"v":0.08529533250722841,"d":"9%"},{"v":0.05493597686906237,"d":"5%"},{"v":0.06154481619165634,"d":"6%"},{"v":0.09273027674514664,"d":"9%"},{"v":0.06815365551425032,"d":"7%"},{"v":0.08405617513424204,"d":"8%"},{"v":0.09809995869475423,"d":"10%"},{"v":0.12185047501032631,"d":"12%"},{"v":1,"d":"100%"}]

{"sheet":"経費","index":2,"n_rows":26,"n_cols":30,"rows_kept":26}
[null,{"$f":"Projection_Period_Title","v":"12 か月"},{"$nulls":27},{"$f":"会社名","v":"会社名"}]
[null,{"$f":"'収益 (売上)'!$B$2","v":"損益予測"},{"$nulls":25},"会計年度:",{"$f":"FYMonthStart","v":"1 月"},{"$f":"FYStartYear","v":2017}]
[{"$nulls":3},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo,1),\"yyyy 年 m 月\"))","v":"2017 年 1 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+1,1),\"yyyy 年 m 月\"))","v":"2017 年 2 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+2,1),\"yyyy 年 m 月\"))","v":"2017 年 3 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+3,1),\"yyyy 年 m 月\"))","v":"2017 年 4 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+4,1),\"yyyy 年 m 月\"))","v":"2017 年 5 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+5,1),\"yyyy 年 m 月\"))","v":"2017 年 6 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+6,1),\"yyyy 年 m 月\"))","v":"2017 年 7 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+7,1),\"yyyy 年 m 月\"))","v":"2017 年 8 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+8,1),\"yyyy 年 m 月\"))","v":"2017 年 9 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+9,1),\"yyyy 年 m 月\"))","v":"2017 年 10 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+10,1),\"yyyy 年 m 月\"))","v":"2017 年 11 月"},{"$f":"UPPER(TEXT(DATE(FYStartYear,FYMonthNo+11,1),\"yyyy 年 m 月\"))","v":"2017 年 12 月"},"年次","インデックス %",{"$f":"IF(RIGHT(D3,4)>\"0\",RIGHT(D3,4),RIGHT(D3,3))&\" %\"","v":"1 月 %"},{"$f":"IF(RIGHT(E3,4)>\"0\",RIGHT(E3,4),RIGHT(E3,3))&\" %\"","v":"2 月 %"},"3 月 %","4 月 %","5 月 %","6 月 %","7 月 %","8 月 %","9 月 %","10 月 %","11 月 %","12 月 %","年 %"]
[null,"経費","トレンド","列 1","2 月","3 月","4 月","5 月","6 月","7 月","8 月","9 月","10 月","11 月","12 月","年次","インデックス %","1 月 %","2 月 %","3 月 %","4 月 %","5 月 %","6 月 %","7 月 %","8 月 %","9 月 %","10 月 %","11 月 %","12 月 %","年 %"]
[null,"給与経費 "," ",{"v":1000,"d":"¥1,000"},{"v":1800,"d":"¥1,800"},{"v":1300,"d":"¥1,300"},{"v":800,"d":"¥800"},{"v":2200,"d":"¥2,200"},{"v":1800,"d":"¥1,800"},{"v":800,"d":"¥800"},{"v":1700,"d":"¥1,700"},{"v":2000,"d":"¥2,000"},{"v":800,"d":"¥800"},{"v":400,"d":"¥400"},{"v":1200,"d":"¥1,200"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":15800,"d":"¥15,800"}},{"v":0.12,"d":"12%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.0423728813559322,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.08780487804878048,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.05220883534136546,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.03065134099616858,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.08560311284046693,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.06569343065693431,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.03007518796992481,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.07234042553191489,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.08695652173913043,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.03088803088803089,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.013513513513513514,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.05194805194805195,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.05268422807602534,"d":"5%"}}]
[null,"人件費 "," ",{"v":2300,"d":"¥2,300"},{"v":1100,"d":"¥1,100"},{"v":700,"d":"¥700"},{"v":1400,"d":"¥1,400"},{"v":1200,"d":"¥1,200"},{"v":1900,"d":"¥1,900"},{"v":1900,"d":"¥1,900"},{"v":400,"d":"¥400"},{"v":700,"d":"¥700"},{"v":1300,"d":"¥1,300"},{"v":2500,"d":"¥2,500"},{"v":500,"d":"¥500"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":15900,"d":"¥15,900"}},{"v":0.09,"d":"9%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.09745762711864407,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.05365853658536585,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.028112449799196786,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.05363984674329502,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.04669260700389105,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.06934306569343066,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.07142857142857142,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.01702127659574468,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.030434782608695653,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.05019305019305019,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.08445945945945946,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.021645021645021644,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.05301767255751917,"d":"5%"}}]
[null,"外部サービス"," ",{"v":2300,"d":"¥2,300"},{"v":2000,"d":"¥2,000"},{"v":300,"d":"¥300"},{"v":1600,"d":"¥1,600"},{"v":1000,"d":"¥1,000"},{"v":500,"d":"¥500"},{"v":2000,"d":"¥2,000"},{"v":700,"d":"¥700"},{"v":400,"d":"¥400"},{"v":2200,"d":"¥2,200"},{"v":1300,"d":"¥1,300"},{"v":1400,"d":"¥1,400"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":15700,"d":"¥15,700"}},{"v":0.02,"d":"2%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.09745762711864407,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.0975609756097561,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.012048192771084338,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.06130268199233716,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.038910505836575876,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.01824817518248175,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.07518796992481203,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.029787234042553193,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.017391304347826087,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.08494208494208494,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.04391891891891892,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.06060606060606061,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.05235078359453151,"d":"5%"}}]
[null,"備品 (事務および運転用)"," ",{"v":1900,"d":"¥1,900"},{"v":400,"d":"¥400"},{"v":700,"d":"¥700"},{"v":1400,"d":"¥1,400"},{"v":2200,"d":"¥2,200"},{"v":1000,"d":"¥1,000"},{"v":2200,"d":"¥2,200"},{"v":500,"d":"¥500"},{"v":400,"d":"¥400"},{"v":1200,"d":"¥1,200"},{"v":1800,"d":"¥1,800"},{"v":2400,"d":"¥2,400"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":16100,"d":"¥16,100"}},{"v":0.08,"d":"8%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.08050847457627118,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.01951219512195122,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.028112449799196786,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.05363984674329502,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.08560311284046693,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.0364963503649635,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.08270676691729323,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.02127659574468085,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.017391304347826087,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.04633204633204633,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.060810810810810814,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.1038961038961039,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.05368456152050684,"d":"5%"}}]
[null,"修繕およびメンテナンス費"," ",{"v":1100,"d":"¥1,100"},{"v":1100,"d":"¥1,100"},{"v":1700,"d":"¥1,700"},{"v":1200,"d":"¥1,200"},{"v":200,"d":"¥200"},{"v":1400,"d":"¥1,400"},{"v":1200,"d":"¥1,200"},{"v":1000,"d":"¥1,000"},{"v":1800,"d":"¥1,800"},{"v":1100,"d":"¥1,100"},{"v":2300,"d":"¥2,300"},{"v":1100,"d":"¥1,100"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":15200,"d":"¥15,200"}},{"v":0.03,"d":"3%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.046610169491525424,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.05365853658536585,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.06827309236947791,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.04597701149425287,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.007782101167315175,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.051094890510948905,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.045112781954887216,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.0425531914893617,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.0782608695652174,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.04247104247104247,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.0777027027027027,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.047619047619047616,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.050683561187062354,"d":"5%"}}]
[null,"広告"," ",{"v":200,"d":"¥200"},{"v":1600,"d":"¥1,600"},{"v":600,"d":"¥600"},{"v":1300,"d":"¥1,300"},{"v":1100,"d":"¥1,100"},{"v":2200,"d":"¥2,200"},{"v":2100,"d":"¥2,100"},{"v":300,"d":"¥300"},{"v":1200,"d":"¥1,200"},{"v":700,"d":"¥700"},{"v":1700,"d":"¥1,700"},{"v":2000,"d":"¥2,000"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":15000,"d":"¥15,000"}},{"v":0.15,"d":"15%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.00847457627118644,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.07804878048780488,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.024096385542168676,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.04980842911877394,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.042801556420233464,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.08029197080291971,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.07894736842105263,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.01276595744680851,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.05217391304347826,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.02702702702702703,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.057432432432432436,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.08658008658008658,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.050016672224074694,"d":"5%"}}]
[null,"自動車、運送および出張"," ",{"v":800,"d":"¥800"},{"v":1700,"d":"¥1,700"},{"v":1100,"d":"¥1,100"},{"v":1100,"d":"¥1,100"},{"v":2100,"d":"¥2,100"},{"v":900,"d":"¥900"},{"v":2000,"d":"¥2,000"},{"v":300,"d":"¥300"},{"v":1400,"d":"¥1,400"},{"v":2200,"d":"¥2,200"},{"v":1600,"d":"¥1,600"},{"v":1200,"d":"¥1,200"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":16400,"d":"¥16,400"}},{"v":0.12,"d":"12%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.03389830508474576,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.08292682926829269,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.04417670682730924,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.0421455938697318,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.08171206225680934,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.032846715328467155,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.07518796992481203,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.01276595744680851,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.06086956521739131,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.08494208494208494,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.05405405405405406,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.05194805194805195,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.05468489496498833,"d":"5%"}}]
[null,"会計および法律"," ",{"v":500,"d":"¥500"},{"v":1300,"d":"¥1,300"},{"v":600,"d":"¥600"},{"v":1500,"d":"¥1,500"},{"v":1900,"d":"¥1,900"},{"v":1000,"d":"¥1,000"},{"v":1200,"d":"¥1,200"},{"v":900,"d":"¥900"},{"v":1500,"d":"¥1,500"},{"v":1600,"d":"¥1,600"},{"v":400,"d":"¥400"},{"v":900,"d":"¥900"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":13300,"d":"¥13,300"}},{"v":0.09,"d":"9%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.0211864406779661,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.06341463414634146,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.024096385542168676,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.05747126436781609,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.07392996108949416,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.0364963503649635,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.045112781954887216,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.03829787234042553,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.06521739130434782,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.06177606177606178,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.013513513513513514,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.03896103896103896,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.04434811603867956,"d":"4%"}}]
[null,"貸借料"," ",{"v":800,"d":"¥800"},{"v":400,"d":"¥400"},{"v":2300,"d":"¥2,300"},{"v":2500,"d":"¥2,500"},{"v":1000,"d":"¥1,000"},{"v":2400,"d":"¥2,400"},{"v":2200,"d":"¥2,200"},{"v":500,"d":"¥500"},{"v":1200,"d":"¥1,200"},{"v":2400,"d":"¥2,400"},{"v":2400,"d":"¥2,400"},{"v":1200,"d":"¥1,200"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":19300,"d":"¥19,300"}},{"v":0.01,"d":"1%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.03389830508474576,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.01951219512195122,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.09236947791164658,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.09578544061302682,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.038910505836575876,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.08759124087591241,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.08270676691729323,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.02127659574468085,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.05217391304347826,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.09266409266409266,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.08108108108108109,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.05194805194805195,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.06435478492830944,"d":"6%"}}]
[null,"電話番号"," ",{"v":2500,"d":"¥2,500"},{"v":200,"d":"¥200"},{"v":1200,"d":"¥1,200"},{"v":2500,"d":"¥2,500"},{"v":1000,"d":"¥1,000"},{"v":2400,"d":"¥2,400"},{"v":300,"d":"¥300"},{"v":2000,"d":"¥2,000"},{"v":300,"d":"¥300"},{"v":900,"d":"¥900"},{"v":2000,"d":"¥2,000"},{"v":1800,"d":"¥1,800"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":17100,"d":"¥17,100"}},{"v":0.01,"d":"1%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.1059322033898305,"d":"11%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.00975609756097561,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.04819277108433735,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.09578544061302682,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.038910505836575876,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.08759124087591241,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.011278195488721804,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.0851063829787234,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.013043478260869565,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.03474903474903475,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.06756756756756757,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.07792207792207792,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.05701900633544515,"d":"6%"}}]
[null,"公共企業"," ",{"v":1600,"d":"¥1,600"},{"v":1900,"d":"¥1,900"},{"v":900,"d":"¥900"},{"v":1600,"d":"¥1,600"},{"v":1300,"d":"¥1,300"},{"v":200,"d":"¥200"},{"v":400,"d":"¥400"},{"v":2400,"d":"¥2,400"},{"v":1600,"d":"¥1,600"},{"v":2200,"d":"¥2,200"},{"v":700,"d":"¥700"},{"v":1800,"d":"¥1,800"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":16600,"d":"¥16,600"}},{"v":0.01,"d":"1%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.06779661016949153,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.09268292682926829,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.03614457831325301,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.06130268199233716,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.05058365758754864,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":7.2992700729927005E-3,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.015037593984962405,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.10212765957446808,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.06956521739130435,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.08494208494208494,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.02364864864864865,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.07792207792207792,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.05535178392797599,"d":"6%"}}]
[null,"保険料"," ",{"v":1200,"d":"¥1,200"},{"v":900,"d":"¥900"},{"v":1600,"d":"¥1,600"},{"v":1900,"d":"¥1,900"},{"v":2500,"d":"¥2,500"},{"v":1700,"d":"¥1,700"},{"v":2000,"d":"¥2,000"},{"v":1400,"d":"¥1,400"},{"v":500,"d":"¥500"},{"v":1400,"d":"¥1,400"},{"v":500,"d":"¥500"},{"v":200,"d":"¥200"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":15800,"d":"¥15,800"}},{"v":0.01,"d":"1%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.05084745762711865,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.04390243902439024,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.0642570281124498,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.07279693486590039,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.09727626459143969,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.06204379562043796,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.07518796992481203,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.059574468085106386,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.021739130434782608,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.05405405405405406,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.016891891891891893,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":8.658008658008658E-3,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.05268422807602534,"d":"5%"}}]
[null,"税金 (不動産など)"," ",{"v":1600,"d":"¥1,600"},{"v":1300,"d":"¥1,300"},{"v":1000,"d":"¥1,000"},{"v":700,"d":"¥700"},{"v":1300,"d":"¥1,300"},{"v":300,"d":"¥300"},{"v":1300,"d":"¥1,300"},{"v":1700,"d":"¥1,700"},{"v":900,"d":"¥900"},{"v":400,"d":"¥400"},{"v":2200,"d":"¥2,200"},{"v":1800,"d":"¥1,800"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":14500,"d":"¥14,500"}},{"v":0.14,"d":"14%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.06779661016949153,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.06341463414634146,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.040160642570281124,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.02681992337164751,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.05058365758754864,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.010948905109489052,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.04887218045112782,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.07234042553191489,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.0391304347826087,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.015444015444015444,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.07432432432432433,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.07792207792207792,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.048349449816605536,"d":"5%"}}]
[null,"金利"," ",{"v":300,"d":"¥300"},{"v":200,"d":"¥200"},{"v":1900,"d":"¥1,900"},{"v":2100,"d":"¥2,100"},{"v":1300,"d":"¥1,300"},{"v":900,"d":"¥900"},{"v":700,"d":"¥700"},{"v":1300,"d":"¥1,300"},{"v":300,"d":"¥300"},{"v":600,"d":"¥600"},{"v":1000,"d":"¥1,000"},{"v":1300,"d":"¥1,300"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":11900,"d":"¥11,900"}},{"v":0.06,"d":"6%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.012711864406779662,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.00975609756097561,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.07630522088353414,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.08045977011494253,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.05058365758754864,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.032846715328467155,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.02631578947368421,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.05531914893617021,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.013043478260869565,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.023166023166023165,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.033783783783783786,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.05627705627705628,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.039679893297765924,"d":"4%"}}]
[null,"減価償却費"," ",{"v":800,"d":"¥800"},{"v":700,"d":"¥700"},{"v":600,"d":"¥600"},{"v":700,"d":"¥700"},{"v":700,"d":"¥700"},{"v":600,"d":"¥600"},{"v":1500,"d":"¥1,500"},{"v":2300,"d":"¥2,300"},{"v":2100,"d":"¥2,100"},{"v":1600,"d":"¥1,600"},{"v":1900,"d":"¥1,900"},{"v":700,"d":"¥700"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":14200,"d":"¥14,200"}},{"v":0.01,"d":"1%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.03389830508474576,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.03414634146341464,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.024096385542168676,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.02681992337164751,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.027237354085603113,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.021897810218978103,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.05639097744360902,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.09787234042553192,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.09130434782608696,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.06177606177606178,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.06418918918918919,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.030303030303030304,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.047349116372124044,"d":"5%"}}]
[null,"その他の費用 (具体的に)"," ",{"v":1400,"d":"¥1,400"},{"v":400,"d":"¥400"},{"v":2400,"d":"¥2,400"},{"v":600,"d":"¥600"},{"v":2000,"d":"¥2,000"},{"v":1400,"d":"¥1,400"},{"v":2100,"d":"¥2,100"},{"v":2000,"d":"¥2,000"},{"v":2200,"d":"¥2,200"},{"v":300,"d":"¥300"},{"v":1400,"d":"¥1,400"},{"v":600,"d":"¥600"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":16800,"d":"¥16,800"}},{"v":0.01,"d":"1%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.059322033898305086,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.01951219512195122,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.0963855421686747,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.022988505747126436,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.07782101167315175,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.051094890510948905,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.07894736842105263,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.0851063829787234,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.09565217391304348,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.011583011583011582,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.0472972972972973,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.025974025974025976,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.056018672890963656,"d":"6%"}}]
[null,"その他の費用 (具体的に)"," ",{"v":1400,"d":"¥1,400"},{"v":700,"d":"¥700"},{"v":2400,"d":"¥2,400"},{"v":1000,"d":"¥1,000"},{"v":700,"d":"¥700"},{"v":2400,"d":"¥2,400"},{"v":200,"d":"¥200"},{"v":1100,"d":"¥1,100"},{"v":2100,"d":"¥2,100"},{"v":1900,"d":"¥1,900"},{"v":1900,"d":"¥1,900"},{"v":2000,"d":"¥2,000"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":17800,"d":"¥17,800"}},{"v":0.01,"d":"1%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.059322033898305086,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.03414634146341464,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.0963855421686747,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.038314176245210725,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.027237354085603113,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.08759124087591241,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.007518796992481203,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.04680851063829787,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.09130434782608696,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.07335907335907337,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.06418918918918919,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.08658008658008658,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.059353117705901966,"d":"6%"}}]
[null,"その他の費用 (具体的に)"," ",{"v":1100,"d":"¥1,100"},{"v":800,"d":"¥800"},{"v":2500,"d":"¥2,500"},{"v":1100,"d":"¥1,100"},{"v":900,"d":"¥900"},{"v":2400,"d":"¥2,400"},{"v":1300,"d":"¥1,300"},{"v":1400,"d":"¥1,400"},{"v":1900,"d":"¥1,900"},{"v":2400,"d":"¥2,400"},{"v":1500,"d":"¥1,500"},{"v":700,"d":"¥700"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":18000,"d":"¥18,000"}},{"v":0.01,"d":"1%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.046610169491525424,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.03902439024390244,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.10040160642570281,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.0421455938697318,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.03501945525291829,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.08759124087591241,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.04887218045112782,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.059574468085106386,"d":"6%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.08260869565217391,"d":"8%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.09266409266409266,"d":"9%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.05067567567567568,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.030303030303030304,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.06002000666888963,"d":"6%"}}]
[null,"その他 (指定しない)"," ",{"v":800,"d":"¥800"},{"v":2000,"d":"¥2,000"},{"v":1100,"d":"¥1,100"},{"v":1100,"d":"¥1,100"},{"v":1100,"d":"¥1,100"},{"v":2000,"d":"¥2,000"},{"v":1200,"d":"¥1,200"},{"v":1600,"d":"¥1,600"},{"v":500,"d":"¥500"},{"v":700,"d":"¥700"},{"v":2100,"d":"¥2,100"},{"v":300,"d":"¥300"},{"$f":"SUM(tblExpenses[[#This Row],[列 1]:[12 月]])","v":{"v":14500,"d":"¥14,500"}},{"v":0.02,"d":"2%"},{"$f":"tblExpenses[[#This Row],[列 1]]/tblExpenses[[#Totals],[列 1]]","v":{"v":0.03389830508474576,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[2 月]]/tblExpenses[[#Totals],[2 月]]","v":{"v":0.0975609756097561,"d":"10%"}},{"$f":"tblExpenses[[#This Row],[3 月]]/tblExpenses[[#Totals],[3 月]]","v":{"v":0.04417670682730924,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[4 月]]/tblExpenses[[#Totals],[4 月]]","v":{"v":0.0421455938697318,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[5 月]]/tblExpenses[[#Totals],[5 月]]","v":{"v":0.042801556420233464,"d":"4%"}},{"$f":"tblExpenses[[#This Row],[6 月]]/tblExpenses[[#Totals],[6 月]]","v":{"v":0.072992700729927,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[7 月]]/tblExpenses[[#Totals],[7 月]]","v":{"v":0.045112781954887216,"d":"5%"}},{"$f":"tblExpenses[[#This Row],[8 月]]/tblExpenses[[#Totals],[8 月]]","v":{"v":0.06808510638297872,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[9 月]]/tblExpenses[[#Totals],[9 月]]","v":{"v":0.021739130434782608,"d":"2%"}},{"$f":"tblExpenses[[#This Row],[10 月]]/tblExpenses[[#Totals],[10 月]]","v":{"v":0.02702702702702703,"d":"3%"}},{"$f":"tblExpenses[[#This Row],[11 月]]/tblExpenses[[#Totals],[11 月]]","v":{"v":0.07094594594594594,"d":"7%"}},{"$f":"tblExpenses[[#This Row],[12 月]]/tblExpenses[[#Totals],[12 月]]","v":{"v":0.012987012987012988,"d":"1%"}},{"$f":"tblExpenses[[#This Row],[年次]]/tblExpenses[[#Totals],[年次]]","v":{"v":0.048349449816605536,"d":"5%"}}]
[null,"経費合計"," ",{"$f":"SUBTOTAL(109,tblExpenses[列 1])","v":{"v":23600,"d":"¥23,600"}},{"$f":"SUBTOTAL(109,tblExpenses[2 月])","v":{"v":20500,"d":"¥20,500"}},{"$f":"SUBTOTAL(109,tblExpenses[3 月])","v":{"v":24900,"d":"¥24,900"}},{"$f":"SUBTOTAL(109,tblExpenses[4 月])","v":{"v":26100,"d":"¥26,100"}},{"$f":"SUBTOTAL(109,tblExpenses[5 月])","v":{"v":25700,"d":"¥25,700"}},{"$f":"SUBTOTAL(109,tblExpenses[6 月])","v":{"v":27400,"d":"¥27,400"}},{"$f":"SUBTOTAL(109,tblExpenses[7 月])","v":{"v":26600,"d":"¥26,600"}},{"$f":"SUBTOTAL(109,tblExpenses[8 月])","v":{"v":23500,"d":"¥23,500"}},{"$f":"SUBTOTAL(109,tblExpenses[9 月])","v":{"v":23000,"d":"¥23,000"}},{"$f":"SUBTOTAL(109,tblExpenses[10 月])","v":{"v":25900,"d":"¥25,900"}},{"$f":"SUBTOTAL(109,tblExpenses[11 月])","v":{"v":29600,"d":"¥29,600"}},{"$f":"SUBTOTAL(109,tblExpenses[12 月])","v":{"v":23100,"d":"¥23,100"}},{"$f":"SUBTOTAL(109,tblExpenses[年次])","v":{"v":299900,"d":"¥299,900"}},{"$f":"SUBTOTAL(109,tblExpenses[インデックス %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[1 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[2 月 %])","v":{"v":1.0000000000000002,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[3 月 %])","v":{"v":1.0000000000000002,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[4 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[5 月 %])","v":{"v":1.0000000000000002,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[6 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[7 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[8 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[9 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[10 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[11 月 %])","v":{"v":0.9999999999999999,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[12 月 %])","v":{"v":1,"d":"100%"}},{"$f":"SUBTOTAL(109,tblExpenses[年 %])","v":{"v":0.9999999999999999,"d":"100%"}}]
[]
[null,"純利益",null,{"$f":"売上原価!$D$14-tblExpenses[[#Totals],[列 1]]","v":{"v":12300,"d":"¥12,300"}},{"$f":"売上原価!E14-tblExpenses[[#Totals],[2 月]]","v":{"v":17500,"d":"¥17,500"}},{"$f":"売上原価!F14-tblExpenses[[#Totals],[3 月]]","v":{"v":25600,"d":"¥25,600"}},{"$f":"売上原価!G14-tblExpenses[[#Totals],[4 月]]","v":{"v":10900,"d":"¥10,900"}},{"$f":"売上原価!H14-tblExpenses[[#Totals],[5 月]]","v":{"v":15600,"d":"¥15,600"}},{"$f":"売上原価!I14-tblExpenses[[#Totals],[6 月]]","v":{"v":-800,"d":"¥-800"}},{"$f":"売上原価!J14-tblExpenses[[#Totals],[7 月]]","v":{"v":3200,"d":"¥3,200"}},{"$f":"売上原価!K14-tblExpenses[[#Totals],[8 月]]","v":{"v":21400,"d":"¥21,400"}},{"$f":"売上原価!L14-tblExpenses[[#Totals],[9 月]]","v":{"v":10000,"d":"¥10,000"}},{"$f":"売上原価!M14-tblExpenses[[#Totals],[10 月]]","v":{"v":14800,"d":"¥14,800"}},{"$f":"売上原価!N14-tblExpenses[[#Totals],[11 月]]","v":{"v":17900,"d":"¥17,900"}},{"$f":"売上原価!O14-tblExpenses[[#Totals],[12 月]]","v":{"v":35900,"d":"¥35,900"}},{"$f":"売上原価!P14-tblExpenses[[#Totals],[年次]]","v":{"v":184300,"d":"¥184,300"}},null,{"$f":"D26/$P$26","v":{"v":0.06673901247965273,"d":"7%"}},{"$f":"E26/$P$26","v":{"v":0.09495387954422138,"d":"9%"}},{"v":0.138903960933261,"d":"14%"},{"v":0.05914270211611503,"d":"6%"},{"v":0.08464460119370591,"d":"8%"},{"v":-0.004340748779164406,"d":"-0%"},{"v":0.017362995116657624,"d":"2%"},{"v":0.11611502984264786,"d":"12%"},{"v":0.05425935973955507,"d":"5%"},{"v":0.08030385241454151,"d":"8%"},{"v":0.09712425393380358,"d":"10%"},{"v":0.19479110146500273,"d":"19%"},{"v":1,"d":"100%"}]