{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["十二个月的现金流","现金流统计"],"not_rendered":{"charts":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"十二个月的现金流","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]]}
[]
["十二个月的现金流",{"$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（月初）",{"v":550000,"d":"550,000"},{"$f":"IF(Receipts[[#Totals],[Column3]]+PaidOut[[#Totals],[Column3]]=0,\"\",B11)","v":{"v":675930,"d":"675,930"}},{"$f":"IF(Receipts[[#Totals],[Column4]]+PaidOut[[#Totals],[Column4]]=0,\"\",C11)","v":{"v":542650,"d":"542,650"}},{"$f":"IF(Receipts[[#Totals],[Column5]]+PaidOut[[#Totals],[Column5]]=0,\"\",D11)","v":{"v":557390,"d":"557,390"}},{"$f":"IF(Receipts[[#Totals],[Column6]]+PaidOut[[#Totals],[Column6]]=0,\"\",E11)","v":{"v":692900,"d":"692,900"}},{"$f":"IF(Receipts[[#Totals],[Column7]]+PaidOut[[#Totals],[Column7]]=0,\"\",F11)","v":{"v":656180,"d":"656,180"}},{"$f":"IF(Receipts[[#Totals],[Column8]]+PaidOut[[#Totals],[Column8]]=0,\"\",G11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column9]]+PaidOut[[#Totals],[Column9]]=0,\"\",H11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column10]]+PaidOut[[#Totals],[Column10]]=0,\"\",I11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column11]]+PaidOut[[#Totals],[Column11]]=0,\"\",J11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column12]]+PaidOut[[#Totals],[Column12]]=0,\"\",K11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column13]]+PaidOut[[#Totals],[Column13]]=0,\"\",L11)","v":""},{"$f":"IF(Receipts[[#Totals],[Column14]]+PaidOut[[#Totals],[Column14]]=0,\"\",M11)","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":625010,"d":"625,010"}}]
["可用现金\n（现有 + 未兑现收据） ",{"$f":"SUM(B9,Receipts[[#Totals],[Column2]])","v":{"v":675930,"d":"675,930"}},{"$f":"IF(C9=\"\",\"\",SUM(C9,Receipts[[#Totals],[Column3]]))","v":{"v":760650,"d":"760,650"}},{"$f":"IF(D9=\"\",\"\",SUM(D9,Receipts[[#Totals],[Column4]]))","v":{"v":833010,"d":"833,010"}},{"$f":"IF(E9=\"\",\"\",SUM(E9,Receipts[[#Totals],[Column5]]))","v":{"v":910320,"d":"910,320"}},{"$f":"IF(F9=\"\",\"\",SUM(F9,Receipts[[#Totals],[Column6]]))","v":{"v":896620,"d":"896,620"}},{"$f":"IF(G9=\"\",\"\",SUM(G9,Receipts[[#Totals],[Column7]]))","v":{"v":762000,"d":"762,000"}},{"$f":"IF(H9=\"\",\"\",SUM(H9,Receipts[[#Totals],[Column8]]))","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I9,Receipts[[#Totals],[Column9]]))","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J9,Receipts[[#Totals],[Column10]]))","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K9,Receipts[[#Totals],[Column11]]))","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L9,Receipts[[#Totals],[Column12]]))","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M9,Receipts[[#Totals],[Column13]]))","v":""},{"$f":"IF(N9=\"\",\"\",SUM(N9,Receipts[[#Totals],[Column14]]))","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":832520,"d":"832,520"}}]
["现金状况\n（月末）",{"$f":"(B10-PaidOut[[#Totals],[Column2]])","v":{"v":675930,"d":"675,930"}},{"$f":"IFERROR(C10-PaidOut[[#Totals],[Column3]],\"\")","v":{"v":542650,"d":"542,650"}},{"$f":"IFERROR(D10-PaidOut[[#Totals],[Column4]],\"\")","v":{"v":557390,"d":"557,390"}},{"$f":"IFERROR(E10-PaidOut[[#Totals],[Column5]],\"\")","v":{"v":692900,"d":"692,900"}},{"$f":"IFERROR(F10-PaidOut[[#Totals],[Column6]],\"\")","v":{"v":656180,"d":"656,180"}},{"$f":"IFERROR(G10-PaidOut[[#Totals],[Column7]],\"\")","v":{"v":514130,"d":"514,130"}},{"$f":"IFERROR(H10-PaidOut[[#Totals],[Column8]],\"\")","v":""},{"$f":"IFERROR(I10-PaidOut[[#Totals],[Column9]],\"\")","v":""},{"$f":"IFERROR(J10-PaidOut[[#Totals],[Column10]],\"\")","v":""},{"$f":"IFERROR(K10-PaidOut[[#Totals],[Column11]],\"\")","v":""},{"$f":"IFERROR(L10-PaidOut[[#Totals],[Column12]],\"\")","v":""},{"$f":"IFERROR(M10-PaidOut[[#Totals],[Column13]],\"\")","v":""},{"$f":"IFERROR(N10-PaidOut[[#Totals],[Column14]],\"\")","v":""},{"$f":"IFERROR(AVERAGE(Summary[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":592650,"d":"592,650"}}]
[]
["现金收入"]
["现金销售",{"v":56160,"d":"56,160"},{"v":38890,"d":"38,890"},{"v":244110,"d":"244,110"},{"v":316420,"d":"316,420"},{"v":146470,"d":"146,470"},{"v":30340,"d":"30,340"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":155246,"d":"155,246"}}]
["贷方应收款",{"v":44980,"d":"44,980"},{"v":34930,"d":"34,930"},{"v":19870,"d":"19,870"},{"v":10290,"d":"10,290"},{"v":29110,"d":"29,110"},{"v":42340,"d":"42,340"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":27308,"d":"27,308"}}]
["贷款/其他现金",{"v":24790,"d":"24,790"},{"v":10900,"d":"10,900"},{"v":26380,"d":"26,380"},{"v":26220,"d":"26,220"},{"v":28140,"d":"28,140"},{"v":33140,"d":"33,140"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":24956,"d":"24,956"}}]
["总现金收入",{"$f":"SUBTOTAL(109,Receipts[Column2])","v":{"v":125930,"d":"125,930"}},{"$f":"SUBTOTAL(109,Receipts[Column3])","v":{"v":84720,"d":"84,720"}},{"$f":"SUBTOTAL(109,Receipts[Column4])","v":{"v":290360,"d":"290,360"}},{"$f":"SUBTOTAL(109,Receipts[Column5])","v":{"v":352930,"d":"352,930"}},{"$f":"SUBTOTAL(109,Receipts[Column6])","v":{"v":203720,"d":"203,720"}},{"$f":"SUBTOTAL(109,Receipts[Column7])","v":{"v":105820,"d":"105,820"}},{"$f":"SUBTOTAL(109,Receipts[Column8])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column9])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column10])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column11])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column12])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column13])","v":0},{"$f":"SUBTOTAL(109,Receipts[Column14])","v":0},{"$f":"IFERROR(AVERAGE(Receipts[[#Totals],[Column3]:[Column14]]),\"\")","v":{"v":86462.5,"d":"86,463"}}]
[]
["现金支出"]
["购买（请指定）",null,{"v":5210,"d":"5,210"},{"v":3230,"d":"3,230"},{"v":2740,"d":"2,740"},{"v":4510,"d":"4,510"},{"v":1040,"d":"1,040"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":3346,"d":"3,346"}}]
["总工资（具体提款）",null,{"v":105720,"d":"105,720"},{"v":145140,"d":"145,140"},{"v":105610,"d":"105,610"},{"v":131700,"d":"131,700"},{"v":124780,"d":"124,780"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":122590,"d":"122,590"}}]
["用品（办公及经营用品）",null,{"v":2500,"d":"2,500"},{"v":4280,"d":"4,280"},{"v":1650,"d":"1,650"},{"v":11680,"d":"11,680"},{"v":3450,"d":"3,450"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":4712,"d":"4,712"}}]
["修理维护费",null,0,{"v":22000,"d":"22,000"},{"v":1630,"d":"1,630"},670,0,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":4860,"d":"4,860"}}]
["广告",null,{"v":11000,"d":"11,000"},{"v":6250,"d":"6,250"},{"v":13560,"d":"13,560"},0,{"v":25600,"d":"25,600"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":11282,"d":"11,282"}}]
["租金",null,{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"v":35000,"d":"35,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":35000,"d":"35,000"}}]
["水电费",null,{"v":2850,"d":"2,850"},{"v":3180,"d":"3,180"},{"v":1510,"d":"1,510"},{"v":1340,"d":"1,340"},{"v":2280,"d":"2,280"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":2232,"d":"2,232"}}]
["其他费用（请指定）",null,{"v":1230,"d":"1,230"},{"v":2340,"d":"2,340"},{"v":1230,"d":"1,230"},{"v":2340,"d":"2,340"},{"v":1230,"d":"1,230"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":1674,"d":"1,674"}}]
["贷款本金支付",null,{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"v":40000,"d":"40,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":40000,"d":"40,000"}}]
["资本购买（请指定）",null,{"v":6790,"d":"6,790"},{"v":7000,"d":"7,000"},{"v":6790,"d":"6,790"},{"v":6500,"d":"6,500"},{"v":6790,"d":"6,790"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":6774,"d":"6,774"}}]
["其他启动费用",null,{"v":4000,"d":"4,000"},{"v":3500,"d":"3,500"},{"v":4000,"d":"4,000"},{"v":3000,"d":"3,000"},{"v":4000,"d":"4,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":3700,"d":"3,700"}}]
["保留或由第三人保存",null,{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":{"v":3000,"d":"3,000"}}]
["所有者提款",null,700,700,700,700,700,{"$nulls":7},{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":700}]
["总现金支出",null,{"$f":"SUBTOTAL(109,PaidOut[Column3])","v":{"v":218000,"d":"218,000"}},{"$f":"SUBTOTAL(109,PaidOut[Column4])","v":{"v":275620,"d":"275,620"}},{"$f":"SUBTOTAL(109,PaidOut[Column5])","v":{"v":217420,"d":"217,420"}},{"$f":"SUBTOTAL(109,PaidOut[Column6])","v":{"v":240440,"d":"240,440"}},{"$f":"SUBTOTAL(109,PaidOut[Column7])","v":{"v":247870,"d":"247,870"}},{"$f":"SUBTOTAL(109,PaidOut[Column8])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column9])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column10])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column11])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column12])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column13])","v":0},{"$f":"SUBTOTAL(109,PaidOut[Column14])","v":0},{"$f":"IFERROR(AVERAGE(PaidOut[[#Totals],[Column3]:[Column14]]),\"\")","v":{"v":99945.83333333333,"d":"99,946"}}]
[]
["基本运营数据 （非现金流信息）"]
["销售量（美元）",{"v":20000,"d":"20,000"},{"v":25000,"d":"25,000"},{"v":22570,"d":"22,570"},{"v":23870,"d":"23,870"},{"v":26640,"d":"26,640"},{"v":23240,"d":"23,240"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":23553.333333333332,"d":"23,553"}}]
["应收帐款",{"v":15000,"d":"15,000"},{"v":5000,"d":"5,000"},{"v":8860,"d":"8,860"},{"v":10350,"d":"10,350"},{"v":17750,"d":"17,750"},{"v":8390,"d":"8,390"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":10891.666666666666,"d":"10,892"}}]
["坏帐（月末）",{"v":3000,"d":"3,000"},{"v":2000,"d":"2,000"},{"v":2250,"d":"2,250"},{"v":2690,"d":"2,690"},{"v":4480,"d":"4,480"},{"v":3590,"d":"3,590"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":{"v":3001.6666666666665,"d":"3,002"}}]
["现有库存（月末）",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["应付帐款（月末）",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["折旧",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]

{"sheet":"现金流统计","index":1,"n_rows":27,"n_cols":11,"rows_kept":27}
{"$rows_empty":25}
[{"$nulls":9},"数据点：",6]
[null,null,"（拖动上方滑块以更改绘制的总数据点。）"]