{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["12 か月のキャッシュ フロー","キャッシュ フローの概要"],"not_rendered":{"charts":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"12 か月のキャッシュ フロー","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"merged":[[7,0,7,15],[11,0,11,15],[17,0,17,15],[33,0,33,15]]}
[]
["12 か月のキャッシュ フロー",{"$nulls":13},"年度開始日:","2013-07-01"]
["会社名"]
["郵便番号、都道府県、市区町村、番地"]
["電話、電子メール、Web"]
[]
[null,"開始金額",{"$f":"FiscalYear","v":"2013-07-01"},{"$f":"DATE(YEAR(C7),MONTH(C7)+1,1)","v":"2013-08-01"},{"$f":"DATE(YEAR(D7),MONTH(D7)+1,1)","v":"2013-09-01"},"2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","月\n平均","概要"]
["現金概要"]
["手元現金\n(月初)",{"v":5500000,"d":"5,500,000"},{"$f":"IF(領収書[[#Totals],[Column3]]+支払い[[#Totals],[Column3]]=0,\"\",B11)","v":{"v":6759300,"d":"6,759,300"}},{"$f":"IF(領収書[[#Totals],[Column4]]+支払い[[#Totals],[Column4]]=0,\"\",C11)","v":{"v":5426500,"d":"5,426,500"}},{"$f":"IF(領収書[[#Totals],[Column5]]+支払い[[#Totals],[Column5]]=0,\"\",D11)","v":{"v":5573900,"d":"5,573,900"}},{"$f":"IF(領収書[[#Totals],[Column6]]+支払い[[#Totals],[Column6]]=0,\"\",E11)","v":{"v":6929000,"d":"6,929,000"}},{"$f":"IF(領収書[[#Totals],[Column7]]+支払い[[#Totals],[Column7]]=0,\"\",F11)","v":{"v":6561800,"d":"6,561,800"}},{"$f":"IF(領収書[[#Totals],[Column8]]+支払い[[#Totals],[Column8]]=0,\"\",G11)","v":""},{"$f":"IF(領収書[[#Totals],[Column9]]+支払い[[#Totals],[Column9]]=0,\"\",H11)","v":""},{"$f":"IF(領収書[[#Totals],[Column10]]+支払い[[#Totals],[Column10]]=0,\"\",I11)","v":""},{"$f":"IF(領収書[[#Totals],[Column11]]+支払い[[#Totals],[Column11]]=0,\"\",J11)","v":""},{"$f":"IF(領収書[[#Totals],[Column12]]+支払い[[#Totals],[Column12]]=0,\"\",K11)","v":""},{"$f":"IF(領収書[[#Totals],[Column13]]+支払い[[#Totals],[Column13]]=0,\"\",L11)","v":""},{"$f":"IF(領収書[[#Totals],[Column14]]+支払い[[#Totals],[Column14]]=0,\"\",M11)","v":""},{"$f":"IFERROR(AVERAGE(概要[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":6250100,"d":"6,250,100"}}]
["使用できる現金\n(精算前の手元現金および受取現金) ",{"$f":"SUM(B9,領収書[[#Totals],[Column2]])","v":{"v":6759300,"d":"6,759,300"}},{"$f":"IF(C9=\"\",\"\",SUM(C9,領収書[[#Totals],[Column3]]))","v":{"v":7606500,"d":"7,606,500"}},{"$f":"IF(D9=\"\",\"\",SUM(D9,領収書[[#Totals],[Column4]]))","v":{"v":8330100,"d":"8,330,100"}},{"$f":"IF(E9=\"\",\"\",SUM(E9,領収書[[#Totals],[Column5]]))","v":{"v":9103200,"d":"9,103,200"}},{"$f":"IF(F9=\"\",\"\",SUM(F9,領収書[[#Totals],[Column6]]))","v":{"v":8966200,"d":"8,966,200"}},{"$f":"IF(G9=\"\",\"\",SUM(G9,領収書[[#Totals],[Column7]]))","v":{"v":7620000,"d":"7,620,000"}},{"$f":"IF(H9=\"\",\"\",SUM(H9,領収書[[#Totals],[Column8]]))","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I9,領収書[[#Totals],[Column9]]))","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J9,領収書[[#Totals],[Column10]]))","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K9,領収書[[#Totals],[Column11]]))","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L9,領収書[[#Totals],[Column12]]))","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M9,領収書[[#Totals],[Column13]]))","v":""},{"$f":"IF(N9=\"\",\"\",SUM(N9,領収書[[#Totals],[Column14]]))","v":""},{"$f":"IFERROR(AVERAGE(概要[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":8325200,"d":"8,325,200"}}]
["現金持ち高\n(月末)",{"$f":"(B10-支払い[[#Totals],[Column2]])","v":{"v":6759300,"d":"6,759,300"}},{"$f":"IFERROR(C10-支払い[[#Totals],[Column3]],\"\")","v":{"v":5426500,"d":"5,426,500"}},{"$f":"IFERROR(D10-支払い[[#Totals],[Column4]],\"\")","v":{"v":5573900,"d":"5,573,900"}},{"$f":"IFERROR(E10-支払い[[#Totals],[Column5]],\"\")","v":{"v":6929000,"d":"6,929,000"}},{"$f":"IFERROR(F10-支払い[[#Totals],[Column6]],\"\")","v":{"v":6561800,"d":"6,561,800"}},{"$f":"IFERROR(G10-支払い[[#Totals],[Column7]],\"\")","v":{"v":5141300,"d":"5,141,300"}},{"$f":"IFERROR(H10-支払い[[#Totals],[Column8]],\"\")","v":""},{"$f":"IFERROR(I10-支払い[[#Totals],[Column9]],\"\")","v":""},{"$f":"IFERROR(J10-支払い[[#Totals],[Column10]],\"\")","v":""},{"$f":"IFERROR(K10-支払い[[#Totals],[Column11]],\"\")","v":""},{"$f":"IFERROR(L10-支払い[[#Totals],[Column12]],\"\")","v":""},{"$f":"IFERROR(M10-支払い[[#Totals],[Column13]],\"\")","v":""},{"$f":"IFERROR(N10-支払い[[#Totals],[Column14]],\"\")","v":""},{"$f":"IFERROR(AVERAGE(概要[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":5926500,"d":"5,926,500"}}]
[]
["現金収入"]
["現金売上",{"v":561600,"d":"561,600"},{"v":388900,"d":"388,900"},{"v":2441100,"d":"2,441,100"},{"v":3164200,"d":"3,164,200"},{"v":1464700,"d":"1,464,700"},{"v":303400,"d":"303,400"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(領収書[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":1552460,"d":"1,552,460"}}]
["口座からの集金",{"v":449800,"d":"449,800"},{"v":349300,"d":"349,300"},{"v":198700,"d":"198,700"},{"v":102900,"d":"102,900"},{"v":291100,"d":"291,100"},{"v":423400,"d":"423,400"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(領収書[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":273080,"d":"273,080"}}]
["融資/その他の現金注入",{"v":247900,"d":"247,900"},{"v":109000,"d":"109,000"},{"v":263800,"d":"263,800"},{"v":262200,"d":"262,200"},{"v":281400,"d":"281,400"},{"v":331400,"d":"331,400"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(領収書[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":249560,"d":"249,560"}}]
["総現金収入",{"$f":"SUBTOTAL(109,領収書[Column2])","v":{"v":1259300,"d":"1,259,300"}},{"$f":"SUBTOTAL(109,領収書[Column3])","v":{"v":847200,"d":"847,200"}},{"$f":"SUBTOTAL(109,領収書[Column4])","v":{"v":2903600,"d":"2,903,600"}},{"$f":"SUBTOTAL(109,領収書[Column5])","v":{"v":3529300,"d":"3,529,300"}},{"$f":"SUBTOTAL(109,領収書[Column6])","v":{"v":2037200,"d":"2,037,200"}},{"$f":"SUBTOTAL(109,領収書[Column7])","v":{"v":1058200,"d":"1,058,200"}},{"$f":"SUBTOTAL(109,領収書[Column8])","v":0},{"$f":"SUBTOTAL(109,領収書[Column9])","v":0},{"$f":"SUBTOTAL(109,領収書[Column10])","v":0},{"$f":"SUBTOTAL(109,領収書[Column11])","v":0},{"$f":"SUBTOTAL(109,領収書[Column12])","v":0},{"$f":"SUBTOTAL(109,領収書[Column13])","v":0},{"$f":"SUBTOTAL(109,領収書[Column14])","v":0},{"$f":"IFERROR(AVERAGE(領収書[[#Totals],[Column3]:[Column14]]),\"\")","v":{"v":864625,"d":"864,625"}}]
[]
["現金支払い"]
["購入 (内容を記入)",null,{"v":52100,"d":"52,100"},{"v":32300,"d":"32,300"},{"v":27400,"d":"27,400"},{"v":45100,"d":"45,100"},{"v":10400,"d":"10,400"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":33460,"d":"33,460"}}]
["総賃金 (正確な引き出し額)",null,{"v":1057200,"d":"1,057,200"},{"v":1451400,"d":"1,451,400"},{"v":1056100,"d":"1,056,100"},{"v":1317000,"d":"1,317,000"},{"v":1247800,"d":"1,247,800"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":1225900,"d":"1,225,900"}}]
["必需品 (事務用品)",null,{"v":25000,"d":"25,000"},{"v":42800,"d":"42,800"},{"v":16500,"d":"16,500"},{"v":116800,"d":"116,800"},{"v":34500,"d":"34,500"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":47120,"d":"47,120"}}]
["修理 、メンテナンス",null,0,{"v":220000,"d":"220,000"},{"v":16300,"d":"16,300"},{"v":6700,"d":"6,700"},0,{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":48600,"d":"48,600"}}]
["広告",null,{"v":110000,"d":"110,000"},{"v":62500,"d":"62,500"},{"v":135600,"d":"135,600"},0,{"v":256000,"d":"256,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":112820,"d":"112,820"}}]
["家賃",null,{"v":350000,"d":"350,000"},{"v":350000,"d":"350,000"},{"v":350000,"d":"350,000"},{"v":350000,"d":"350,000"},{"v":350000,"d":"350,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":350000,"d":"350,000"}}]
["公益事業",null,{"v":28500,"d":"28,500"},{"v":31800,"d":"31,800"},{"v":15100,"d":"15,100"},{"v":13400,"d":"13,400"},{"v":22800,"d":"22,800"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":22320,"d":"22,320"}}]
["その他 (内容を記入)",null,{"v":12300,"d":"12,300"},{"v":23400,"d":"23,400"},{"v":12300,"d":"12,300"},{"v":23400,"d":"23,400"},{"v":12300,"d":"12,300"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":16740,"d":"16,740"}}]
["融資元本支払い",null,{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"v":400000,"d":"400,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":400000,"d":"400,000"}}]
["資本財購入 (内容を記入)",null,{"v":67900,"d":"67,900"},{"v":70000,"d":"70,000"},{"v":67900,"d":"67,900"},{"v":65000,"d":"65,000"},{"v":67900,"d":"67,900"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":67740,"d":"67,740"}}]
["その他の設立費用",null,{"v":40000,"d":"40,000"},{"v":35000,"d":"35,000"},{"v":40000,"d":"40,000"},{"v":30000,"d":"30,000"},{"v":40000,"d":"40,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":37000,"d":"37,000"}}]
["準備金および第三者預託",null,{"v":30000,"d":"30,000"},{"v":30000,"d":"30,000"},{"v":30000,"d":"30,000"},{"v":30000,"d":"30,000"},{"v":30000,"d":"30,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":30000,"d":"30,000"}}]
["所有者の引き出し",null,{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"v":7000,"d":"7,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(支払い[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":7000,"d":"7,000"}}]
["総現金支払い",null,{"$f":"SUBTOTAL(109,支払い[Column3])","v":{"v":2180000,"d":"2,180,000"}},{"$f":"SUBTOTAL(109,支払い[Column4])","v":{"v":2756200,"d":"2,756,200"}},{"$f":"SUBTOTAL(109,支払い[Column5])","v":{"v":2174200,"d":"2,174,200"}},{"$f":"SUBTOTAL(109,支払い[Column6])","v":{"v":2404400,"d":"2,404,400"}},{"$f":"SUBTOTAL(109,支払い[Column7])","v":{"v":2478700,"d":"2,478,700"}},{"$f":"SUBTOTAL(109,支払い[Column8])","v":0},{"$f":"SUBTOTAL(109,支払い[Column9])","v":0},{"$f":"SUBTOTAL(109,支払い[Column10])","v":0},{"$f":"SUBTOTAL(109,支払い[Column11])","v":0},{"$f":"SUBTOTAL(109,支払い[Column12])","v":0},{"$f":"SUBTOTAL(109,支払い[Column13])","v":0},{"$f":"SUBTOTAL(109,支払い[Column14])","v":0},{"$f":"IFERROR(AVERAGE(支払い[[#Totals],[Column3]:[Column14]]),\"\")","v":{"v":999458.3333333334,"d":"999,458"}}]
[]
["重要な経営データ (非キャッシュフロー情報)"]
["売上高 (金額)",{"v":200000,"d":"200,000"},{"v":250000,"d":"250,000"},{"v":225700,"d":"225,700"},{"v":238700,"d":"238,700"},{"v":266400,"d":"266,400"},{"v":232400,"d":"232,400"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(必須の経営データ[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":235533.33333333334,"d":"235,533"}}]
["売掛金",{"v":150000,"d":"150,000"},{"v":50000,"d":"50,000"},{"v":88600,"d":"88,600"},{"v":103500,"d":"103,500"},{"v":177500,"d":"177,500"},{"v":83900,"d":"83,900"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(必須の経営データ[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":108916.66666666667,"d":"108,917"}}]
["回収不能金 (月末)",{"v":30000,"d":"30,000"},{"v":20000,"d":"20,000"},{"v":22500,"d":"22,500"},{"v":26900,"d":"26,900"},{"v":44800,"d":"44,800"},{"v":35900,"d":"35,900"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(必須の経営データ[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":30016.666666666668,"d":"30,017"}}]
["手持在庫 (月末)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(必須の経営データ[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["支払勘定 (月末)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(必須の経営データ[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["減価償却",{"$nulls":13},{"$f":"IFERROR(AVERAGE(必須の経営データ[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]

{"sheet":"キャッシュ フローの概要","index":1,"n_rows":27,"n_cols":11,"rows_kept":27}
{"$rows_empty":25}
[{"$nulls":9},"データ要素:",2]
[null,null,"(表示されるデータ要素の合計を変更するには、上のスライダーをドラッグします。)"]