{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Index","ChuKuJi","RuKuJi","Data","SanTem","SanLan","KuCunCha","JinXiao","DanPin","GaoJi","ZiLiao","JinChu","DanCha","User","SysInfo"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":10,"comments":9,"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","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[[5,0,22,0]]}
[]
[]
[]
[]
[]
["功能导航"]

{"sheet":"ChuKuJi","index":1,"n_rows":107,"n_cols":11,"rows_kept":107,"cut":false,"hidden":true,"merged":[[0,3,0,8],[105,1,105,2],[105,3,105,7],[105,8,105,9],[1,3,2,8],[106,8,106,9],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
[null,null,null,{"$f":"IF(SysInfo!B25=\"\",\"\",SysInfo!B25)","v":"中国XXX股份集团有限公司"}]
[null,null,null,"出 库 单"]
[null,null,null,null,null,null,null,null,null,"出库单号：","CK200311001"]
[null,"领用单位：",null,"",null,"出库类别：",null,"",null,"出库日期：","2020-03-11"]
[null,"序号","编号","货物名称","规格型号","单位","单价","数量","金额","分类","备注"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]
[null,100]
[null,"金额(大写):",null,{"$f":"IF(TRIM(SUM($I$6:$I$105))=\"\",\"\",IF(SUM($I$6:$I$105)=0,\"\",\"(RMB)\"&IF(SUM($I$6:$I$105)<0,\"负\",)&IF(INT(SUM($I$6:$I$105)),TEXT(INT(ABS(SUM($I$6:$I$105))),\"[DBNum2]\")&\"元\",)&IF(INT(ABS(SUM($I$6:$I$105))*10)-INT(ABS(SUM($I$6:$I$105)))*10,TEXT(INT(ABS(SUM($I$6:$I$105))*10)-INT(ABS(SUM($I$6:$I$105)))*10,\"[DBNum2]\")&\"角\",IF(INT(ABS(SUM($I$6:$I$105)))=ABS(SUM($I$6:$I$105)),,IF(ABS(SUM($I$6:$I$105))<0.1,,\"零\")))&IF(ROUND(ABS(SUM($I$6:$I$105))*100-INT(ABS(SUM($I$6:$I$105))*10)*10,),TEXT(ROUND(ABS(SUM($I$6:$I$105))*100-INT(ABS(SUM($I$6:$I$105))*10)*10,),\"[DBNum2]\")&\"分\",\"整\")))","v":""},null,null,null,null,"金额(小写):",null,{"$f":"IF(SUM(I6:I105)=0,\"\",SUM(I6:I105))","v":""}]
[null,null,null,"领料人：","",null,null,null,"经办人：",null,""]

{"sheet":"RuKuJi","index":2,"n_rows":107,"n_cols":11,"rows_kept":107,"cut":false,"hidden":true,"merged":[[1,3,2,8],[0,3,0,8],[105,8,105,9],[106,8,106,9],[105,1,105,2],[105,3,105,7],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8]]}
[null,null,null,{"$f":"IF(SysInfo!B25=\"\",\"\",SysInfo!B25)","v":"中国XXX股份集团有限公司"}]
[null,null,null,"入 库 单"]
[null,null,null,null,null,null,null,null,null,"入库单号：","RK200311001"]
[null,"供货单位：",null,"",null,"入库类别：",null,"",null,"入库日期：","2020-03-11"]
[null,"序号","编号","货物名称","规格型号","单位","单价","数量","金额","分类","备注"]
[null,"1"]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]
[null,100]
[null,"金额(大写):",null,{"$f":"IF(TRIM(SUM($I$6:$I$105))=\"\",\"\",IF(SUM($I$6:$I$105)=0,\"\",\"(RMB)\"&IF(SUM($I$6:$I$105)<0,\"负\",)&IF(INT(SUM($I$6:$I$105)),TEXT(INT(ABS(SUM($I$6:$I$105))),\"[DBNum2]\")&\"元\",)&IF(INT(ABS(SUM($I$6:$I$105))*10)-INT(ABS(SUM($I$6:$I$105)))*10,TEXT(INT(ABS(SUM($I$6:$I$105))*10)-INT(ABS(SUM($I$6:$I$105)))*10,\"[DBNum2]\")&\"角\",IF(INT(ABS(SUM($I$6:$I$105)))=ABS(SUM($I$6:$I$105)),,IF(ABS(SUM($I$6:$I$105))<0.1,,\"零\")))&IF(ROUND(ABS(SUM($I$6:$I$105))*100-INT(ABS(SUM($I$6:$I$105))*10)*10,),TEXT(ROUND(ABS(SUM($I$6:$I$105))*100-INT(ABS(SUM($I$6:$I$105))*10)*10,),\"[DBNum2]\")&\"分\",\"整\")))","v":""},null,null,null,null,"金额(小写):",null,{"$f":"IF(SUM(I6:I105)=0,\"\",SUM(I6:I105))","v":""}]
[null,null,null,"供货人：","",null,null,null,"经办人：",null,""]

{"sheet":"Data","index":3,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["编号","货物名称","规格型号","单位","单价","数量","金额","分类","出入类别","单据类型","进出日期","供领单位","供领人","经办人","凭证单号","备注"]

{"sheet":"SanTem","index":4,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,10,0,12],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,0,5],[0,6,0,9]]}
["日期","凭证单号","出入摘要","收入",null,null,"发出",null,null,null,"结存"]
[null,null,null,"数量","单价","金额","数量","成本","单价","金额","数量","均价","金额"]

{"sheet":"SanLan","index":5,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":true,"merged":[[2,3,2,5],[2,6,2,7],[1,6,1,7],[1,3,1,5],[1,11,1,12],[2,11,2,12],[1,9,1,10],[2,9,2,10],[4,10,4,12],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,9]]}
[]
["开始日期","结束日期","货物编号","货物名称",null,null,"规格型号",null,"单位","分类",null,"备注信息"]
["","","","",null,null,"",null,"","",null,""]
[]
["日期","凭证单号","出入摘要","入库",null,null,"出库",null,null,null,"结存"]
[null,null,null,"数量","单价","金额","数量","成本","单价","金额","数量","均价","金额"]

{"sheet":"KuCunCha","index":6,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["编号","货物名称","规格型号","单位","分类","最低库存","最高库存","当前数量","库存金额","存量提示","货物备注"]

{"sheet":"JinXiao","index":7,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,3,2,4],[4,4,5,4],[4,7,4,8],[4,9,4,12],[4,5,4,6],[4,15,5,15],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,13,4,14]]}
[]
[]
["起始日期:","","结束日期:",""]
[]
["编号","货物名称","规格型号","单位","货物分类","期初结存",null,"本期收入",null,"本期发出",null,null,null,"期末结存",null,"货物备注"]
[null,null,null,null,null,"数量","金额","数量","金额","数量","成本","金额","利润","数量","金额"]

{"sheet":"DanPin","index":8,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":true,"merged":[[1,3,1,4],[2,3,2,4]]}
[]
[null,"编号","开始日期","结束日期"]
[null,"","",""]
[]
["编号","货物名称","规格型号","单位","单价","数量","金额","分类","出入类别","单据类型","进出日期","供领人","供领单位","经办人","凭证单号","备注"]

{"sheet":"GaoJi","index":9,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":true,"merged":[[1,5,1,6],[2,5,2,6],[2,1,2,2],[1,1,1,2],[1,3,1,4],[2,3,2,4]]}
[]
["货物编号","供领单位",null,"开始日期",null,"结束日期",null,"货物分类","出入类别","单据类型","供领人","经办人"]
["","",null,"",null,"",null,"","","","",""]
[]
["编号","货物名称","规格型号","单位","单价","数量","金额","货物分类","出入类别","单据类型","进出日期","供领人","供领单位","经办人","凭证单号","备注"]

{"sheet":"ZiLiao","index":10,"n_rows":13,"n_cols":22,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["编号","货物名称","规格型号","单位","入库价(参考)","出库价(参考)","货物分类","期初\n库存","期初金额","最低库存","最高库存","备注信息","检查提示",null,null,"供货单位","领用单位","供货人","领货人","经办人","入库类别","出库类别"]
["1001","示例货物1","54*3","个","10",12,"分类1",3,30,2,5,null,null,null,null,"生产部","示例客户1","小红","张三","陈明","采购入库","销售出库"]
[1002,"示例货物2","DN015","个",10,13,"分类3",2,20,2,5,"A类货物",null,null,null,"采购部","示例客户2","小明","李四","刘光","生产入库","领料出库"]
["1003","示例货物3","12*50","套",10,14,"分类2",3,30,2,5,null,null,null,null,"工程部","示例客户3","小光","王五","任雪","销售退货","报废出库"]
[1004,"示例货物4","DN015","片",10,12,"分类2",6,48,2,5,"B类货物",null,null,null,"示例供应商1","销售部","小丽","赵六","李亮","盘盈入库","采购退货"]
[1005,"示例货物5","DN020","片",10,13,"分类1",3,30,2,5,null,null,null,null,"示例供应商2","生产部",null,null,null,null,"盘亏出库"]
["1006","示例货物6","DN015","个",10,14,"分类3","3",30,2,5,null,null,null,null,"示例供应商3","后勤部"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"示例供应商4","示例客户4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"示例供应商5","示例客户5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"盘盈入库","盘亏出库"]

{"sheet":"JinChu","index":11,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,13,5,13],[4,0,5,0],[1,1,1,3],[2,1,2,3],[4,5,4,7],[4,8,4,12],[4,4,5,4],[4,3,5,3],[4,2,5,2],[4,1,5,1]]}
[]
["单据类型","供领单位",null,null,"货物分类","开始日期","结束日期","供领人","经办人","出入类别"]
["","",null,null,"","","","","",""]
[]
["编号","货物名称","规格型号","单位","货物分类","入库统计",null,null,"出库统计",null,null,null,null,"货物备注"]
[null,null,null,null,null,"数量","均价","金额","数量","均价","金额","成本均价","成本金额"]

{"sheet":"DanCha","index":12,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
["单据类型","凭证单号","开始日期","结束日期","供领单位","供领人","经办人","出入类别"]
["","","","","","","",""]
[null,null,null,"",null,null,null,""]
["单据类型","凭证单号","出入日期","出入类别","供领单位","供领人","经办人","单据金额","操作提示"]

{"sheet":"User","index":13,"n_rows":2,"n_cols":50,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["姓名","账号","密码","备注",null,null,null,null,"库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易","库管易"]
["admin","admin","4AFF7E0B20C78CA2AB598EFC33F4C708","高级管理员",null,null,null,null,"1","1","1","1","1","1","1",null,null,null,"1","1","1","1",null,null,null,null,null,null,"1","1","1","1",null,null,null,null,null,"1","1","1","1","1",null,null,null,null,null,"1","1","1"]

{"sheet":"SysInfo","index":14,"n_rows":63,"n_cols":5,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["库管易","001","0",""]
["库管易","001","0",""]
["库管易","200311"]
["库管易","200311"]
["库管易","RK"]
["库管易","CK"]
["库管易",null,"是否查询","单号","查询失败"]
["库管易"]
["库管易","20170411"]
["库管易","admin"]
["库管易"]
["库管易","1"]
["库管易","0"]
["库管易","1"]
["库管易","1"]
["库管易","1"]
["库管易"]
["库管易","2"]
["库管易","1"]
["库管易","1"]
["库管易","1"]
["库管易"]
["库管易"]
["库管易"]
["库管易","中国XXX股份集团有限公司"]
["库管易","库管易Excel库存管理系统"]
["库管易"]
["库管易"]
["库管易"]
["库管易"]
["库管易","0"]
["库管易","0"]
["库管易"]
["库管易","0"]
["库管易","0"]
["库管易"]
["库管易","0"]
["库管易","0"]
["库管易"]
["库管易","1"]
["库管易","1"]
["库管易"]
["库管易","1"]
["库管易","1"]
["库管易"]
["库管易","0"]
["库管易","0"]
["库管易"]
["库管易","1"]
["库管易","1"]
["库管易"]
["库管易","0"]
["库管易","0"]
["库管易"]
["库管易","2"]
["库管易","2"]
["库管易"]
["库管易","30"]
["库管易"]
["库管易","0"]
["库管易","0"]
["库管易"]
["库管易","1"]