{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["连云港分公司","邳州分公司"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"连云港分公司","index":0,"n_rows":20,"n_cols":25,"rows_kept":20,"merged":[[0,0,0,24],[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 月12日                                填表人 张传迎、杜华军                                   "]
[null,"单位：江苏大力神管桩有限公司连云港分公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":4},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含杂质%","细度模数","级配区","压碎值","扣杂质t","结算重量","单价","金额"]
[1,"03:01:00","0553","孙冲","张来高",13775439287,"孙冲",5409,"碎石","5~25",139.18,26.24,112.44,1.2,0.5,null,"I",{"v":0.098,"d":"9.8%"},1.44,111,90,null,"杜华军","张传迎"]
[2,"22:21:00","0553","孙冲","张来高",13775439287,"孙冲",5412,"碎石","5~25",138.24,27,111.24,1.2,0.6,null,"I",{"v":0.094,"d":"9.4%"},1.24,110,90,null,"杜华军","张传迎"]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15,{"$nulls":11},{"$f":"SUM(M5:M18)","v":223.68},{"$nulls":6},{"$f":"SUM(T5:T18)","v":221}]
[null,"备注：退货也登记，在备注中注明不合格退货，所有重量和单价、金额均以0标记"]

{"sheet":"邳州分公司","index":1,"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 月 12 日                                填表人  ：李凤                                 "]
[null,"单位：江苏大力神管桩有限公司"]
["序号","到厂时间","送料人相关信息",{"$nulls":5},"物品相关信息（参数指标等）",{"$nulls":11},"结算信息",null,null,"检验员","过磅员","备注"]
[null,"  时  分","车号","车主姓名\n（客户）","司机姓名","司机手机号","所属车队","磅单单号","入库单号","品名","规格","毛重t","皮重t","净重t","含水率%","含泥量%","细度模数","级配区/颗粒级配","压碎值%","扣杂质t","结算重量","单价/元","金额/元"]
[1,"13:55:00","鲁Q188BD","戴春宇","李宋",18913488722,"李海洋",12804,"WIN0050149","石子","1-2#",75.36,19.14,56.22,{"$nulls":3},"良好",7,0.52,55.7,98,{"$f":"U5*V5","v":5458.6},"刘会良","李彤彤"]
[2,"14:24:00","鲁Q577AX","韩红","曹庆杰",13815377665,"李海洋","退货",null,"石子","1-2#",{"$nulls":12},"刘会良","李彤彤"]
[3,"14:28:00","鲁Q380BH","戴春宇","魏楠",13655213111,"李海洋","退货",null,"石子","1-2#",{"$nulls":12},"刘会良","李彤彤"]
[4,"14:29:00","苏C1T837","戴春宇","冯康",13585365885,"李海洋","司机自己拉走",null,"石子","1-2#",{"$nulls":13},"李彤彤"]
[5,"14:32:00","鲁Q673AX","戴春宇","冯英武",15190795960,"李海洋","司机自己拉走",null,"石子","1-2#",{"$nulls":13},"李彤彤"]
[6,"14:58:00","苏C1T507","戴春宇","祁建辉",18751646723,"李海洋",12809,"WIN0050149","石子","1-2#",97.82,22.92,74.9,{"$nulls":3},"良好",7,0.5,74.4,98,{"$f":"U10*V10","v":7291.2},"李凤","李彤彤"]
[7,"21:13:00","苏CGV338","周桂林","李城市",18751653412,"杨需",12811,"WIN0050147","机制砂","中粗砂",80.4,21.56,68.84,5,2.5,2.8,"Ⅱ区",null,0.74,68.1,122,8308.2,"王尧","马娜","三车间商混"]
[8,"21:16:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",12812,"WIN0050147","机制砂","中粗砂",90.6,22.7,67.9,5,2,2.8,"Ⅱ区",null,0.7,67.2,122,8198.4,"王尧","马娜"]
[9,"21:18:00","苏C2A698","高雷","高雷",13913462579,"杨需",12813,"WIN0050147","机制砂","中粗砂",109.08,29.36,79.72,5,2,2.8,"Ⅱ区",null,0.82,78.9,122,9625.8,"王尧","马娜"]
[10,"21:21:00","鲁Q582BY","陈伟","陈伟",15852102259,"丁庆余",12814,"WIN0050148","石子","1-2#",72.28,18.14,54.14,{"$nulls":3},"良好",7,0.54,53.6,98,5252.8,"王尧","马娜"]
[11,"23:37:00","鲁Q577AX","韩红","曹庆杰",13815377665,"李海洋",12817,"WIN0050149","石子","1-2#",74.14,19.2,54.94,{"$nulls":3},"良好",7,0.54,54.4,98,5331.2,"王尧","马娜"]
[12,"23:39:00","鲁Q233AA","彭兆","彭兆",15195487666,"李海洋",12818,"WIN0050149","石子","1-2#",97.72,19.98,77.74,{"$nulls":3},"含石粉碎石",8,1.04,76.7,98,7516.6,"王尧","马娜"]
[13,"02:03:00","苏CGV338","周桂林","李城市",18751653412,"杨需",12821,"WIN0050147","机制砂","中粗砂",90.1,21.4,68.7,5,1.6,2.7,"Ⅱ区",null,0.7,68,122,8296,"王尧","马娜"]
[14,"02:06:00","鲁Q627AP","宫东明","宫东明",15253915869,"杨需",12822,"WIN0050147","机制砂","中粗砂",91.9,22.52,69.38,5,1.6,2.7,"Ⅱ区",null,0.78,68.6,122,8369.2,"王尧","马娜"]
[15,"02:08:00","苏C2A698","高雷","高雷",13913462579,"杨需",12823,"WIN0050147","机制砂","中粗砂",106.52,29.2,77.32,5,1.6,2.7,"Ⅱ区",null,0.82,76.5,122,9333,"王尧","马娜"]
[16,"02:34:00","苏C1T833","刘文龙","刘团结",13646114999,"丁庆余",12824,"WIN0050148","石子","1-2#",103.28,22.42,80.86,{"$nulls":3},"良好",7,0.56,80.3,98,7869.4,"王尧","马娜"]
[17,"02:41:00","鲁Q582BY","陈伟","陈伟",15852102259,"丁庆余",12825,"WIN0050148","石子","1-2#",72.5,18.26,54.24,{"$nulls":3},"良好",7,0.54,53.7,98,5262.6,"王尧","马娜"]
[18,"06:34:00","苏CGD838","王浩","张玉",13626150626,"李海洋",12827,"WIN0050149","石子","1-2#",91.26,20.04,71.22,{"$nulls":3},"良好",7,0.52,70.7,98,6928.6,"王尧","马娜"]
[19,"06:37:00","苏P000AJ","王浩","曹天强",13357931887,"李海洋",12828,"WIN0050149","石子","1-2#",95.88,21.14,74.74,{"$nulls":3},"良好",7,0.54,74.2,98,7271.6,"王尧","马娜"]
[20,"06:40:00","鲁Q956BY","王浩","杜祥波",15162009688,"李海洋",12829,"WIN0050149","石子","1-2#",98.22,18.78,78.44,{"$nulls":3},"良好",7,0.54,78.9,98,7732.2,"王尧","马娜"]
["合计",{"$nulls":12},{"$f":"SUM(N5:N24)","v":1109.3},{"$nulls":6},{"$f":"SUM(U5:U24)","v":1099.9},null,{"$f":"SUM(W5:W24)","v":118045.4}]