{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["邳州分公司","巨野分公司"],"read":"whole","date_system":"1900"}

{"sheet":"邳州分公司","index":0,"n_rows":25,"n_cols":26,"rows_kept":25,"merged":[[0,0,0,26],[1,1,1,23],[2,0,3,0],[2,2,2,6],[2,8,2,19],[2,20,2,22],[2,23,3,23],[2,24,3,24],[2,25,3,25]]}
["收料登记表填报\n日期  ：2019 年 4 月 9 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"07:58:00","苏CJD623","刘兆彬","汤计丰",13621863868,"庄团结","退货",null,"河砂","中粗砂",{"$nulls":4},3.6,{"$nulls":7},"刘会良","杜娥娥","含泥量超标，退货"]
[2,"13:33:00","鲁Q338AA","冯波","王磊",15351691234,"李海洋",12701,"WIN0050115","石子","1-2#",101.7,23.28,78.42,{"$nulls":3},"良好",7,0.52,77.9,98,{"$f":"U6*V6","v":7634.2},"刘会良","杜娥娥"]
[3,"13:38:00","鲁Q515BZ","冯波","郭方猛",13813273822,"李海洋",12702,"WIN0050115","石子","1-2#",108.68,26.62,82.06,{"$nulls":3},"良好",7,0.56,81.5,98,7987,"刘会良","杜娥娥"]
[4,"14:25:00","鲁Q188BD","戴春宇","谭常来",15852103716,"李海洋",12703,"WIN0050115","石子","1-2#",82.32,19.44,62.88,{"$nulls":3},"良好",7,0.58,62.3,98,6105.4,"陈金芳","杜娥娥"]
[5,"14:28:00","鲁Q502BY","戴春宇","王戈义",15152016113,"李海洋",12704,"WIN0050115","石子","1-2#",75.48,18.64,56.84,{"$nulls":3},"良好",7,0.54,56.3,98,5517.4,"陈金芳","杜娥娥"]
[6,"14:42:00","鲁Q562BG","戴春宇","郑嘉雷",15862121767,"丁庆余",12705,"WIN0050113","石子","1-2#",105.04,23.2,81.84,{"$nulls":3},"含碎石",8,2.04,79.8,98,7820.4,"陈金芳","杜娥娥"]
[7,"15:11:00","鲁Q932BR","丁宝利","张吉成",13864917051,"丁宝利",12706,"WIN0050114","石子","1-2#",59.74,17.08,42.66,{"$nulls":3},"良好",7,0.56,42.1,98,4125.8,"陈金芳","杜娥娥"]
[8,"15:15:00","鲁Q905BU","丁宝利","宋家轮",15266695067,"丁宝利",12707,"WIN0050114","石子","1-2#",58.5,17.36,41.14,{"$nulls":3},"良好",7,0.54,40.6,98,3978.8,"陈金芳","杜娥娥"]
[9,"15:50:00","鲁Q611BY","周磊","周磊",13776756667,"李海洋",12708,"WIN0050115","石子","1-2#",88.22,17.82,70.4,{"$nulls":3},"良好",7,0.5,69.9,98,6850.2,"李凤","杜娥娥"]
[10,"18:03:00","鲁Q577AX","韩红","曹庆杰",13815377665,"丁庆余",12709,"WIN0050113","石子","1-2#",76.5,19.28,57.22,{"$nulls":3},"良好",7,1.02,56.2,98,5507.6,"杨家辉","李彤彤"]
[11,"18:06:00","鲁Q673AX","戴春宇","冯英武",15190795960,"李海洋",12710,"WIN0050115","石子","1-2#",76.96,18.56,58.4,{"$nulls":3},"良好",7,1,57.4,98,5625.2,"杨家辉","李彤彤"]
[12,"21:49:00","鲁Q932BR","丁宝利","张吉成",13864917051,"丁宝利",12713,"WIN0050114","石子","1-2#",59.08,17.02,42.06,{"$nulls":3},"良好",7,0.56,41.5,98,4067,"杨家辉","李彤彤"]
[13,"21:52:00","鲁Q905BU","丁宝利","宋佳伦",13280525199,"丁宝利",12714,"WIN0050114","石子","1-2#",59.22,17.12,42.1,{"$nulls":3},"良好",7,0.5,41.6,98,4076.8,"杨家辉","李彤彤"]
[14,"23:55:00","鲁Q233AA","彭兆","彭兆",15195487666,"李海洋",12716,"WIN0050115","石子","1-2#",97.44,20.56,76.88,{"$nulls":3},"良好",7,1.08,75.8,98,7428.4,"杨家辉","李彤彤"]
[15,"23:57:00","鲁Q611BY","周磊","周磊",13776756667,"李海洋",12717,"WIN0050115","石子","1-2#",91.18,17.66,73.52,{"$nulls":3},"良好",7,1.02,72.5,98,7105,"杨家辉","李彤彤"]
[16,"01:04:00","苏C1T837","戴春宇","吴云龙",13585365885,"李海洋",12718,"WIN0050115","石子","1-2#",83.86,21.68,62.18,{"$nulls":3},"良好",7,0.58,61.6,98,6036.8,"杨家辉","李彤彤"]
[17,"01:07:00","鲁Q673AX","戴春宇","冯英武",15190795960,"丁庆余",12719,"WIN0050113","石子","1-2#",76.4,18.46,57.94,{"$nulls":3},"良好",7,0.54,57.4,98,5625.2,"杨家辉","李彤彤"]
[18,"01:10:00","鲁Q577AX","韩红","曹庆杰",13815377665,"李海洋",12720,"WIN0050115","石子","1-2#",73.14,18.88,54.26,{"$nulls":3},"良好",7,0.56,53.7,98,5262.6,"杨家辉","李彤彤"]
[19,"01:41:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",12721,"WIN0050115","石子","1-2#",107.38,23.18,84.2,{"$nulls":3},"良好",7,0.5,83.7,98,8202.6,"杨家辉","李彤彤"]
[]
["合计",{"$nulls":12},{"$f":"SUM(N5:N24)","v":1125},{"$nulls":6},{"$f":"SUM(U5:U24)","v":1111.8},null,{"$f":"SUM(W5:W24)","v":108956.4}]

{"sheet":"巨野分公司","index":1,"n_rows":73,"n_cols":25,"rows_kept":73,"merged":[[0,0,0,21],[1,1,1,21],[2,0,3,0],[2,2,2,6],[2,7,2,18],[2,19,2,21],[2,22,3,22],[2,23,3,23],[2,24,3,24]]}
["收料登记表填报\n日期    2019年 4 月 09 日                                填表人  ：杨振华                                "]
[null,"单位：江苏大力神管桩有限公司巨野分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时 分","车号","车主姓名","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重","皮重","净重","含水率%","含泥量%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"07:31:00","鲁RN9829","魏翔远","魏翔远",15854038599,"英良运输","012905","机制沙","中粗",49.56,16.29,{"$f":"K5-L5","v":33.27},{"$nulls":5},"0.1T",33.1,139,{"$f":"T5*U5","v":4600.9},"冯海英","聂恒光"]
[2,"07:33:00","鲁RM2498","魏庆如","崔保东",18953075722,"英良运输","012906","机制沙","中粗",49.45,16.22,33.23,{"$nulls":5},"0.1T",33.1,139,4600.9,"冯海英","聂恒光"]
[3,"07:35:00","鲁RM6981","黄国栋","黄国栋",13583034566,"英良运输","012907","机制沙","中粗",49.67,16.56,33.11,{"$nulls":5},"0.1T",33,139,4587,"冯海英","聂恒光"]
[4,"08:06:00","鲁JA0033","赵才刚","赵才刚",13345281088,"赵才刚","012908","195线材","6.5#",47.53,14.47,33.06,{"$nulls":6},33.06,4095,135380.7,"冯海英","聂恒光"]
[5,"12:01:00","苏G7869E","仲济领","仲济领",13585292371,"仲济领","012909","钢棒","&10.7",49,32.66,16.34,{"$nulls":6},16.34,4670,76307.8,"冯海英","聂恒光"]
[6,"13:32:00","苏G7869E","仲济领","仲济领",13585292371,"仲济领","012910","钢棒","&9.0",32.65,16.33,16.32,{"$nulls":6},16.32,4670,76214.4,"冯海英","聂恒光"]
[7,{"$nulls":11},0,{"$nulls":8},0]
[8,{"$nulls":11},0,{"$nulls":8},0]
[9,{"$nulls":11},0,{"$nulls":8},0]
[10,{"$nulls":11},0,{"$nulls":8},0]
[11,{"$nulls":11},0,{"$nulls":8},0]
[12,{"$nulls":11},0,{"$nulls":8},0]
[13,{"$nulls":11},0,{"$nulls":8},0]
[14,{"$nulls":11},0,{"$nulls":8},0]
[15,{"$nulls":11},0,{"$nulls":8},0]
[16,{"$nulls":11},0,{"$nulls":8},0]
[17,{"$nulls":11},0,{"$nulls":8},0]
[18,{"$nulls":11},0,{"$nulls":8},0]
[19,{"$nulls":11},0,{"$nulls":8},0]
[20,{"$nulls":11},0,{"$nulls":8},0]
[21,{"$nulls":11},0,{"$nulls":8},0]
[22,{"$nulls":11},0,{"$nulls":8},0]
[23,{"$nulls":11},0,{"$nulls":8},0]
[24,{"$nulls":11},0,{"$nulls":8},0]
[25,{"$nulls":11},0,{"$nulls":8},0]
[26,{"$nulls":11},0,{"$nulls":8},0]
[27,{"$nulls":11},0,{"$nulls":8},0]
[28,{"$nulls":11},0,{"$nulls":8},0]
[29,{"$nulls":11},0,{"$nulls":8},0]
[30,{"$nulls":11},0,{"$nulls":8},0]
[31,{"$nulls":11},0,{"$nulls":8},0]
[32,{"$nulls":11},0,{"$nulls":8},0]
[33,{"$nulls":11},0,{"$nulls":8},0]
[34,{"$nulls":11},0,{"$nulls":8},0]
[35,{"$nulls":11},0,{"$nulls":8},0]
[36,{"$nulls":11},0,{"$nulls":8},0]
[37,{"$nulls":11},0,{"$nulls":8},0]
[38,{"$nulls":11},0,{"$nulls":8},0]
[39,{"$nulls":11},0,{"$nulls":8},0]
[40,{"$nulls":11},0,{"$nulls":8},0]
[41,{"$nulls":11},0,{"$nulls":8},0]
[42,{"$nulls":11},0,{"$nulls":8},0]
[43,{"$nulls":11},0,{"$nulls":8},0]
[44,{"$nulls":11},0,{"$nulls":8},0]
[45,{"$nulls":11},0,{"$nulls":8},0]
[46,{"$nulls":11},0,{"$nulls":8},0]
[47,{"$nulls":11},0,{"$nulls":8},0]
[48,{"$nulls":11},0,{"$nulls":8},0]
[49,{"$nulls":11},0,{"$nulls":8},0]
[50,{"$nulls":11},0,{"$nulls":8},0]
[51,{"$nulls":11},0,{"$nulls":8},0]
[52,{"$nulls":11},0,{"$nulls":8},0]
[53,{"$nulls":11},0,{"$nulls":8},0]
[54,{"$nulls":11},0,{"$nulls":8},0]
[55,{"$nulls":11},0,{"$nulls":8},0]
[56,{"$nulls":11},0,{"$nulls":8},0]
[57,{"$nulls":11},0,{"$nulls":8},0]
[58,{"$nulls":11},0,{"$nulls":8},0]
[59,{"$nulls":11},0,{"$nulls":8},0]
[60,{"$nulls":11},0,{"$nulls":8},0]
[61,{"$nulls":11},0,{"$nulls":8},0]
[62,{"$nulls":11},0,{"$nulls":8},0]
[63,{"$nulls":11},0,{"$nulls":8},0]
[64,{"$nulls":11},0,{"$nulls":8},0]
[65,{"$nulls":11},{"$f":"K69-L69","v":0},{"$nulls":8},{"$f":"T69*U69","v":0}]
[66,{"$nulls":11},0,{"$nulls":8},0]
[67,{"$nulls":11},0,{"$nulls":8},0]
[68,{"$nulls":11},0,{"$nulls":8},0]
["合计：",{"$nulls":18},0,null,{"$f":"SUM(V5:V72)","v":301691.7}]