{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[7,1,7,7],[8,1,8,7],[9,1,9,7],[6,2,6,3],[0,1,0,7],[1,6,1,7],[4,2,4,4],[5,2,5,7],[2,6,2,7],[3,6,3,7],[2,2,2,4],[3,2,3,4],[27,1,27,7],[14,5,14,7],[16,5,16,7],[17,2,17,7],[25,6,25,7],[19,1,19,7],[16,2,16,4],[14,2,14,4]]}
[null,"内 部 出 货 单"]
[null,null,null,null,null,"销售单编号(合同号)："]
[null,"客  户  名  称：","苏州筹策智能科技有限公司",null,null,"商 机 类 型：","快速商机"]
[null,"商  机  名  称：","相机采购130万",null,null,"商 机 编 号：","1-3AM6ZVC"]
[null,"客户要求交货时间："]
[null,"发货地址及收货人：","系统"]
[null,"是否需要项目交付："]
[null,"  一类产品：平台软件，交通产品，视频综合平台；"]
[null,"  二类产品：(可能需要外出支持，根据工程商的能力而定）IPC，网络球机，其他网络设备，单兵，车载，解码器，网络键盘， 板卡，智能产品，大屏；存储；"]
[null,"  三类产品：（基本不需要外出支持）：DVR,模拟相机，DVS，光端机，4000、4200客户端软件。"]
[null,"最终用户行业大类："]
[]
[]
[]
[null,"最终用户所属子行业：","手机装配（整机）"]
[]
[null,"商 机 子 业 务：","条码识别"]
[null,"  未签合同原因说明："]
[]
[null,"出 货 产 品 明 细"]
["物料号","产品名称","数量","单价","总金额","备注","是否特价","账期"]
[306300058,"MV-CA050-20GC(国内标配)",1,3000,{"$f":"INDIRECT(\"C\"&ROW())*INDIRECT(\"D\"&ROW())","v":3000},"特价编号：1-3AVXUR1"]
[306300222,"MV-CE120-10GC(国内标配)",1,5000,{"$f":"INDIRECT(\"C\"&ROW())*INDIRECT(\"D\"&ROW())","v":5000},"特价编号：1-3AVXUR1"]
[null,"合计",{"$f":"SUM(C22:INDIRECT(\"C\"&ROW()-1))","v":2},"-",{"$f":"SUM(E22:INDIRECT(\"E\"&ROW()-1))","v":8000}]
[]
[null,"销售员签名：",null,"技术员：",null,"日期：","2018-07-17"]
[]
[null,"注：本表格红色字体部分为必填项。"]

{"sheet":"Sheet3","index":1,"n_rows":92,"n_cols":11,"rows_kept":92,"cut":false,"hidden":true,"merged":[]}
["行业大类","子行业","行业代码","子业务","子业务代码",null,"行业大类","序号","子行业数","偏移量","子业务数"]
["公安政府","科通","GA-A","平安城市\\智慧平安城市综合建设业务","GA-1","公安政府","公安政府",1,11,0,10]
[null,"刑侦","GA-B","国标互联监控业务","GA-2","公安政府","交通",2,13,11,13]
[null,"边防武警","GA-C","图侦（控）实战业务","GA-3","公安政府","金融",3,12,24,11]
[null,"治安","GA-D","警务督察监控管理业务","GA-4","公安政府","司法",4,8,36,11]
[null,"监所","GA-E","监所及内审监控管理业务","GA-5","公安政府","智能楼宇",5,7,47,9]
[null,"督察","GA-F","指挥中心监控建设业务","GA-6","公安政府","文教卫",6,10,56,10]
[null,"指挥中心","GA-G","移动警务视频系统业务","GA-7","公安政府","能源",7,11,66,18]
[null,"保安公司","GA-H","报警保安视频系统业务","GA-8","公安政府","电讯",8,5,84,5]
[null,"政府","GA-I","卡口用视频监控业务","GA-9","公安政府","经销",9,1,89,1]
[null,"综合","GA-J","公安政府-其它业务","GA-999","公安政府","其他渠道",10,1,90,1]
[null,"公安政府-其它用户","GA-ZZZ",null,null,"公安政府"]
["交通","交警","JT-A","公安交通指挥系统业务","JT-1","交通",0]
[null,"港口","JT-B","港口视频监控业务","JT-2","交通",{"$f":"IF(G13=0,\"无\",INDEX(G2:G11,G13))","v":"无"},null,{"$f":"IF(G13=0,0,INDEX(I2:I11,$G$13))","v":0},{"$f":"IF(G13=0,0,INDEX(J2:J11,$G$13))","v":0},{"$f":"IF(G13=0,0,INDEX(K2:K11,$G$13))","v":0}]
[null,"公路局","JT-C","公路视频监控业务","JT-3","交通"]
[null,"客货运","JT-D","运管及客管视频监控业务","JT-4","交通"]
[null,"海事 港航","JT-E","海事及港航视频监控业务","JT-5","交通",{"$f":"IF(Sheet1!C15=\"请选择\",0,VLOOKUP(Sheet1!C15,Sheet3!B2:F92,5,0))","v":{"$error":"#N/A"}},{"$f":"IF(G13=0,2,IF(G17=G14,1,0))","v":2}]
[null,"轨道 公交","JT-F","轨道及公交视频监控业务","JT-6","交通",{"$f":"IF(Sheet1!C17=\"请选择\",0,VLOOKUP(Sheet1!C17,Sheet3!D2:F92,3,))","v":{"$error":"#N/A"}},{"$f":"IF(G13=0,2,IF(G18=G14,1,0))","v":2}]
[null,"机场","JT-G","机场视频监控业务","JT-7","交通"]
[null,"高速公路","JT-H","高速公路视频监控业务","JT-8","交通"]
[null,"铁路","JT-I","铁路视频监控业务","JT-9","交通"]
[null,"物流","JT-J","物流视频监控业务","JT-10","交通"]
[null,"交通局","JT-K","交通局联网视频监控业务","JT-11","交通"]
[null,"停车场业主","JT-L","停车及出入口管理业务","JT-12","交通"]
[null,"交通-其它用户","JT-ZZZ","交通-其它业务","JT-999","交通"]
["金融","工行","JR-A","营业网点","JR-1","金融"]
[null,"农行","JR-B","自助银行","JR-2","金融"]
[null,"中行","JR-C","办公大楼","JR-3","金融"]
[null,"建行","JR-D","监控中心","JR-4","金融"]
[null,"交行","JR-E","金库监控","JR-5","金融"]
[null,"邮政储蓄","JR-F","押运监控","JR-6","金融"]
[null,"农信","JR-G","远程授权可视化管理","JR-7","金融"]
[null,"人行","JR-H","理财可视化管理","JR-8","金融"]
[null,"股份行","JR-I","信贷可视化管理","JR-9","金融"]
[null,"城商行","JR-J","远程定损","JR-10","金融"]
[null,"保险证券","JR-K","其它业务","JR-999","金融"]
[null,"金融-其它用户","JR-ZZZ",null,null,"金融"]
["司法","监狱","SF-A","监所安防业务","SF-1","司法"]
[null,"劳教戒毒","SF-B","公安审讯业务","SF-2","司法"]
[null,"检察院","SF-C","同步录音录像业务","SF-3","司法"]
[null,"法院","SF-D","驻所监控业务","SF-4","司法"]
[null,"纪委","SF-E","数字庭审业务","SF-5","司法"]
[null,"军队","SF-F","法院执行指挥业务","SF-6","司法"]
[null,"海关","SF-G","纪委谈话业务","SF-7","司法"]
[null,"司法-其它用户","SF -ZZZ","军队监控业务","SF-8","司法"]
[null,null,null,"海关缉私及监控业务","SF-9","司法"]
[null,null,null,"海关监管业务","SF-10","司法"]
[null,null,null,"司法-其它业务","SF-999","司法"]
["智能楼宇","地产","LY-A","物业及安保管理业务","LY-1","智能楼宇"]
[null,"连锁经营","LY-B","人员出入口管理业务 ","LY-2","智能楼宇"]
[null,"烟草","LY-C","远程看护业务","LY-3","智能楼宇"]
[null,"企业园区","LY-D","工地监控业务","LY-4","智能楼宇"]
[null,"公共服务","LY-E","连锁监控和门店管理业务","LY-5","智能楼宇"]
[null,"体育场馆","LY-F","消费行为分析业务","LY-6","智能楼宇"]
[null,"智能楼宇-其它用户","LY-ZZZ","客户体验管理业务","LY-7","智能楼宇"]
[null,null,null,"企业园区监控及管理业务","LY-8","智能楼宇"]
[null,null,null,"智能楼宇-其它业务","LY-999","智能楼宇"]
["文教卫","高教","WJW-A","平安校园","WJW-1","文教卫"]
[null,"职教","WJW-B","考场监控","WJW-2","文教卫"]
[null,"普教幼教","WJW-C","教学录播","WJW-3","文教卫"]
[null,"卫生医疗 ","WJW-D","校车监管","WJW-4","文教卫"]
[null,"食药管理","WJW-E","平安医院","WJW -5","文教卫"]
[null,"文博","WJW-F","食药安全","WJW -6","文教卫"]
[null,"文化传媒 ","WJW-G","数字文博","WJW -7","文教卫"]
[null,"旅游景区","WJW-H","数字景区","WJW -8","文教卫"]
[null,"考试培训","WJW-I","文化监管","WJW -9","文教卫"]
[null,"文教卫-其它用户","WJW-ZZZ","文教卫-其它业务","WJW -999","文教卫"]
["能源","电网公司（含地方电力）","NY-A","变电站综合监控","NY-1","能源"]
[null,"发电集团（风电、火电、水电，核电）","NY-B","发电综合监控子业务","NY-2","能源"]
[null,"煤矿企业/煤监局","NY-C","线路在线监测子业务 ","NY-3","能源"]
[null,"中石油/中石化（包括其他石油、石化企业）","NY-D","配电监控","NY-4","能源"]
[null,"燃气企业/集团（管道燃气、天然气销售）","NY-E","电力营业厅","NY-5","能源"]
[null,"冶金制造（钢铁冶金、有色冶金企业）","NY-F","油气田生产监控","NY-6","能源"]
[null,"非煤矿业（除煤矿外的其他有色矿山、化学矿山）","NY-G","炼化生产监控","NY-7","能源"]
[null,"化工制造","NY-H","管道监控","NY-8","能源"]
[null,"气象环保","NY-I","加油加气站","NY-9","能源"]
[null,"水利水务","NY-J","天然气供热","NY-10","能源"]
[null,"能源-其他用户","NY-ZZZ","油罐车监控","NY-11","能源"]
[null,null,null,"巡检排班","NY-12","能源"]
[null,null,null,"物联监控","NY-13","能源"]
[null,null,null,"矿业监控","NY-14","能源"]
[null,null,null,"化工制造监控","NY-15","能源"]
[null,null,null,"智慧水利","NY-16","能源"]
[null,null,null,"环保气象监控","NY-17","能源"]
[null,null,null,"能源-其他业务","NY-999","能源"]
["电讯","电信","DX-A","营业厅监控","DX-1","电讯"]
[null,"移动","DX-B","基站监控","DX-2","电讯"]
[null,"联通","DX-C","ICT集成业务","DX-3","电讯"]
[null,"广电","DX-D","运营监控业务","DX-4","电讯"]
[null,"电讯-其它用户","DX-ZZZ","电讯-其它业务","DX-999","电讯"]
["经销","经销产品市场","经销","经销商业务","经销","经销"]
["其他渠道","其他行业","其他","其他业务","其他","其他渠道"]