{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["十二个月的现金流","现金流统计"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"十二个月的现金流","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[11,0,11,15],[7,0,7,15],[17,0,17,15],[33,0,33,15]]}
[]
["十二个月的现金流",null,null,null,null,null,null,null,null,null,null,null,null,null,"财政年度开始时间：","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（月初）",550000,{"$f":"IF(Receipts[[#Totals],[Column3]]+PaidOut[[#Totals],[Column3]]=0,\"\",B11)","v":675930},{"$f":"IF(Receipts[[#Totals],[Column4]]+PaidOut[[#Totals],[Column4]]=0,\"\",C11)","v":542650},{"$f":"IF(Receipts[[#Totals],[Column5]]+PaidOut[[#Totals],[Column5]]=0,\"\",D11)","v":557390},{"$f":"IF(Receipts[[#Totals],[Column6]]+PaidOut[[#Totals],[Column6]]=0,\"\",E11)","v":692900},{"$f":"IF(Receipts[[#Totals],[Column7]]+PaidOut[[#Totals],[Column7]]=0,\"\",F11)","v":656180},{"$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":625010}]
["可用现金\n（现有 + 未兑现收据） ",{"$f":"SUM(B9,Receipts[[#Totals],[Column2]])","v":675930},{"$f":"IF(C9=\"\",\"\",SUM(C9,Receipts[[#Totals],[Column3]]))","v":760650},{"$f":"IF(D9=\"\",\"\",SUM(D9,Receipts[[#Totals],[Column4]]))","v":833010},{"$f":"IF(E9=\"\",\"\",SUM(E9,Receipts[[#Totals],[Column5]]))","v":910320},{"$f":"IF(F9=\"\",\"\",SUM(F9,Receipts[[#Totals],[Column6]]))","v":896620},{"$f":"IF(G9=\"\",\"\",SUM(G9,Receipts[[#Totals],[Column7]]))","v":762000},{"$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":832520}]
["现金状况\n（月末）",{"$f":"(B10-PaidOut[[#Totals],[Column2]])","v":675930},{"$f":"IFERROR(C10-PaidOut[[#Totals],[Column3]],\"\")","v":542650},{"$f":"IFERROR(D10-PaidOut[[#Totals],[Column4]],\"\")","v":557390},{"$f":"IFERROR(E10-PaidOut[[#Totals],[Column5]],\"\")","v":692900},{"$f":"IFERROR(F10-PaidOut[[#Totals],[Column6]],\"\")","v":656180},{"$f":"IFERROR(G10-PaidOut[[#Totals],[Column7]],\"\")","v":514130},{"$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":592650}]
[]
["现金收入"]
["现金销售",56160,38890,244110,316420,146470,30340,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":155246}]
["贷方应收款",44980,34930,19870,10290,29110,42340,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":27308}]
["贷款/其他现金",24790,10900,26380,26220,28140,33140,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(Receipts[[#This Row],[Column3]:[Column14]]),\"\")","v":24956}]
["总现金收入",{"$f":"SUBTOTAL(109,Receipts[Column2])","v":125930},{"$f":"SUBTOTAL(109,Receipts[Column3])","v":84720},{"$f":"SUBTOTAL(109,Receipts[Column4])","v":290360},{"$f":"SUBTOTAL(109,Receipts[Column5])","v":352930},{"$f":"SUBTOTAL(109,Receipts[Column6])","v":203720},{"$f":"SUBTOTAL(109,Receipts[Column7])","v":105820},{"$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":86462.5}]
[]
["现金支出"]
["购买（请指定）",null,5210,3230,2740,4510,1040,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":3346}]
["总工资（具体提款）",null,105720,145140,105610,131700,124780,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":122590}]
["用品（办公及经营用品）",null,2500,4280,1650,11680,3450,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":4712}]
["修理维护费",null,0,22000,1630,670,0,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":4860}]
["广告",null,11000,6250,13560,0,25600,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":11282}]
["租金",null,35000,35000,35000,35000,35000,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":35000}]
["水电费",null,2850,3180,1510,1340,2280,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":2232}]
["其他费用（请指定）",null,1230,2340,1230,2340,1230,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":1674}]
["贷款本金支付",null,40000,40000,40000,40000,40000,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":40000}]
["资本购买（请指定）",null,6790,7000,6790,6500,6790,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":6774}]
["其他启动费用",null,4000,3500,4000,3000,4000,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":3700}]
["保留或由第三人保存",null,3000,3000,3000,3000,3000,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":3000}]
["所有者提款",null,700,700,700,700,700,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(PaidOut[[#This Row],[Column3]:[Column14]]),\"\")","v":700}]
["总现金支出",null,{"$f":"SUBTOTAL(109,PaidOut[Column3])","v":218000},{"$f":"SUBTOTAL(109,PaidOut[Column4])","v":275620},{"$f":"SUBTOTAL(109,PaidOut[Column5])","v":217420},{"$f":"SUBTOTAL(109,PaidOut[Column6])","v":240440},{"$f":"SUBTOTAL(109,PaidOut[Column7])","v":247870},{"$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":99945.833333333328}]
[]
["基本运营数据 （非现金流信息）"]
["销售量（美元）",20000,25000,22570,23870,26640,23240,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":23553.333333333332}]
["应收帐款",15000,5000,8860,10350,17750,8390,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":10891.666666666666}]
["坏帐（月末）",3000,2000,2250,2690,4480,3590,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":3001.6666666666665}]
["现有库存（月末）",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["应付帐款（月末）",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]
["折旧",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AVERAGE(EssencialOperatingData[[#This Row],[Column2]:[Column14]]),\"\")","v":""}]

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