XLS《基本信息》

"3.

20特种设备作业人员考试成绩单" "序号","姓名","身份证号","性别","学历","工作单位","作业种类","作业项目代号","考试时间","理论成绩","实操成绩","区域" "1","王刚","3710XXXXXXXXXX5319","男","高中","威海海韵居置业有限公司","电梯作业","T3","20170320","81","85","荣成" "2","宋伟","3710XXXXXXXXXX6710","男","本科","山东华鹏玻璃股份有限公司","电梯作业","T3","20170320","81","98","荣成" "3","王淑萍","3710XXXXXXXXXX4122","女","高中","家家悦集团股份有限公司","电梯作业","T3","20170320","72","96","荣成" "4","方海娟","3706XXXXXXXXXX7422","女","高中","烟台康桥物业管理有限公司","电梯作业","T3","20170320","86","92","荣成" "5","林文奇","230XXXXXXXXXX8051X","男","高中","荣成市合顺水产有限公司","电梯作业","T3","20170320","81","70","荣成" "6","林少亭","3710XXXXXXXXXX3412","男","本科","威海星展商业管理有限公司","电梯作业","T3","20170320","80","70","经区" "7","张耀文","3710XXXXXXXXXX5028","女","大专","威海步特户外用品有限公司","电梯作业","T3","20170320","87","90","经区" "8","宫宇","3710XXXXXXXXXX0514","男","中专","威海泰纺制衣有限公司","电梯作业","T3","20170320","78","90","经区" "9","黄金龙","3702XXXXXXXXXX8138","男","本科","威海泰纺制衣有限公司","电梯作业","T3","20170320","79","90","经区" "10","刘纵","5130XXXXXXXXXX2116","男","高中","威海东方新纪元置业有限公司","电梯作业","T1","20170320","78","70","高区" "11","王梓","3203XXXXXXXXXX0415","男","中专","威海东方新纪元置业有限公司","电梯作业","T1","20170320","77","65","高区" "12","郑忠凯","1305XXXXXXXXXX3159","男","初中","威海三净电子有限公司","电梯作业","T3","20170320","68","89","高区" "13","邱忠伟","3710XXXXXXXXXX841X","男","初中","威海同泰进出口有限公司","电梯作业","T3","20170320","68","70","高区" "14","张军","3710XXXXXXXXXX4554","男","初中","威海威高血液净化制品有限公司","电梯作业","T3","20170320","79","88","高区" "15","鲁田利","3706XXXXXXXXXX5516","男","中专","威海威高血液净化制品有限公司","电梯作业","T3","20170320","72","70","高区" "16","范昌坤","3706XXXXXXXXXX716","男","本科","威海威高血液净化制品有限公司","电梯作业","T3","20170320","80","85","高区" "17","慈永帅","3710XXXXXXXXXX3015","男","本科","威海威高血液净化制品有限公司","电梯作业","T3","20170320","78","90","高区" "18","张喜平","3706XXXXXXXXXX8238","男","中专","汇钜工业(威海)有限公司","电梯作业","T3","20170320","79","90","临港" "特种设备相关管理",,

,,

,,

,"特种设备安全管理负责人","A1",,

,,

,"特种设备质量管理负责人","A2",,

,,

,"锅炉压力容器压力管道安全管理","A3",,

,,

,"电梯安全管理","A4",,

,,

,"起重机械安全管理","A5",,

,,

,"客运索道安全管理","A6",,

,,

,"大型游乐设施安全管理","A7",,

,,

,"场(厂)内专用机动车辆安全管理","A8",,

,,

,,

,,

,,

"锅炉作业","一级锅炉司炉","G1",,

,,

,"二级锅炉司炉","G2",,

,,

,"三级锅炉司炉","G3",,

,,

,"一级锅炉水质管理","G4",,

,,

,"二级锅炉水质管理","G5",,

,,

,"锅炉能效作业","G6",,

,,

,,

,,

,,

"压力容器作业","固定式压力容器操作","R1",,

,,

,"移动式压力容器充装","R2",,

,,

,"氧舱维护保养","R3",,

,,

,,

,,

,,

"气瓶作业","永久气体气瓶充装","P1",,

,,

,"液化气体气瓶充装","P2",,

,,

,"溶解乙炔气瓶充装","P3",,

,,

,"液化石油气瓶充装","P4",,

,,

,"车用气瓶充装","P5",,

,,

,,

,,

,,

"压力管道作业","压力管道巡检维护","D1",,

,,

,"带压封堵","D2",,

,,

,"带压密封","D3",,

,,

,,

,,

,,

"电梯作业","电梯机械安装维修","T1",,

,,

,"电梯电气安装维修","T2",,

,,

,"电梯司机","T3",,

,,

,,

,,

,,

"起重机械作业","起重机械机械安装维修","Q1",,

,,

,"起重机械电气安装维修","Q2",,

,,

,"起重机械指挥","Q3",,

,,

,"桥门式起重机司机","Q4",,

,,

,"塔式起重机司机","Q5",,

,,

,"门座式起重机司机","Q6",,

,,

,"缆索式起重机司机","Q7",,

,,

,"流动式起重机司机","Q8",,

,,

,"升降机司机","Q9",,

,,

,"机械式停车设备司机","Q10",,

,,

,,

,,

,,

"客运索道作业","客运索道安装","S1",,

,,

,"客运索道维修","S2",,

,,

,"客运索道司机","S3",,

,,

,"客运索道编索","S4",,

,,

,,

,,

,,

"大型游乐设施作业","大型游乐设施安装","Y1",,

,,

,"大型游乐设施维修","Y2",,

,,

,"大型游乐设施操作","Y3",,

,,

,"水上游乐设施操作与维修","Y4",,

,,

,,

,,

,,

"场(厂)内专用机动车辆作业","车辆维修","N1",,

,,

,"叉车司机","N2",,

,,

,"搬运车牵引车推顶车司机","N3",,

,,

,"内燃观光车司机","N4",,

,,

,"蓄电池观光车司机","N5",,

,,

,,

,,

,,

"安全附件维修作业","安全阀校验","F1",,

,,

,"安全阀维修","F2",,

,,

,,

,,

,,

"特种设备焊接作业","金属焊接操作","HJ",,

,,

,"非金属焊接操作","FJ",,

,,

"地市","区县","行政区划" "济南市","市辖区","370101" ,"历下区","370102" ,"市中区","370103" ,"槐荫区","370104" ,"天桥区","370105" ,"历城区","370112" ,"长清区","370113" ,"平阴县","370124" ,"济阳县","370125" ,"商河县","370126" ,"章丘市","370181" ,"开发区","370185" "青岛市","市辖区","370201" ,"市南区","370202" ,"市北区","370203" ,"四方区","370205" ,"黄岛区","370211" ,"崂山区","370212" ,"李沧区","370213" ,"城阳区","370214" ,"保税区","370220" ,"高新区","370222" ,"胶州市","370281" ,"即墨市","370282" ,"平度市","370283" ,"胶南市","370284" ,"莱西市","370285" "淄博市","市辖区","370301" ,"淄川区","370302" ,"张店区","370303" ,"博山区","370304" ,"临淄区","370305" ,"周村区","370306" ,"桓台县","370321" ,"高青县","370322" ,"沂源县","370323" ,"开发区","370399" "枣庄市","市辖区","370401" ,"市中区","370402" ,"薛城区","370403" ,"峄城区","370404" ,"台儿庄区","370405" ,"山亭区","370406" ,"高新区","370407" ,"滕州市","370481" "东营市","市辖区","370501" ,"东营区","370502" ,"河口区","370503" ,"开发区","370504" ,"海港区","370505" ,"垦利县","370521" ,"利津县","370522" ,"广饶县","370523" "烟台市","市辖区","370601" ,"芝罘区","370602" ,"福山区","370611" ,"牟平区","370612" ,"莱山区","370613" ,"长岛县","370634" ,"开发区","370636" ,"龙口市","370681" ,"莱阳市","370682" ,"莱州市","370683" ,"蓬莱市","370684" ,"招远市","370685" ,"栖霞市","370686" ,"海阳市","370687" "潍坊市","市辖区","370701" ,"潍城区","370702" ,"寒亭区","370703" ,"坊子区","370704" ,"奎文区","370705" ,"临朐县","370724" ,"昌乐县","370725" ,"滨海区","370730" ,"高新区","370731" ,"峡山区","370732" ,"青州市","370781" ,"诸城市","370782" ,"寿光市","370783" ,"安丘市","370784" ,"高密市","370785" ,"昌邑市","370786" "济宁市","市辖区","370801" ,"市中区","370802" ,"任城区","370811" ,"微山县","370826" ,"鱼台县","370827" ,"金乡县","370828" ,"嘉祥县","370829" ,"汶上县","370830" ,"泗水县","370831" ,"梁山县","370832" ,"曲阜市","370881" ,"兖州市","370882" ,"邹城市","370883" ,"开发区","370899" "泰安市","市辖区","370901" ,"泰山区","370902" ,"高新区","370906" ,"岱岳区","370911" ,"宁阳县","370921" ,"东平县","370923" ,"新泰市","370982" ,"肥城市","370983" "威海市","市辖区","371001" ,"环翠区","371002" ,"文登市","371081" ,"荣成市","371082" ,"乳山市","371083" ,"高新区","371084" ,"经济区","371085" ,"工业新区","371086" "日照市","市辖区","371101" ,"东港区","371102" ,"岚山区","371103" ,"五莲县","371121" ,"莒县","371122" "莱芜市","市辖区","371201" ,"莱城区","371202" ,"钢城区","371203" "临沂市","市辖区","371301" ,"兰山区","371302" ,"罗庄区","371311" ,"河东区","371312" ,"沂南县","371321" ,"郯城县","371322" ,"沂水县","371323" ,"苍山县","371324" ,"费县","371325" ,"平邑县","371326" ,"莒南县","371327" ,"蒙阴县","371328" ,"临沭县","371329" ,"高新区","371339" ,"临港区","371340" ,"经济区","371399" "德州市","市辖区","371401" ,"德城区","371402" ,"经济开发区","371403" ,"陵县","371421" ,"宁津县","371422" ,"庆云县","371423" ,"临邑县","371424" ,"齐河县","371425" ,"平原县","371426" ,"夏津县","371427" ,"武城县","371428" ,"乐陵市","371481" ,"禹城市","371482" "聊城市","市辖区","371501" ,"东昌府区","371502" ,"阳谷县","371521" ,"莘县","371522" ,"茌平县","371523" ,"东阿县","371524" ,"冠县","371525" ,"高唐县","371526" ,"临清市","371581" ,"开发区","371599" "滨州市","市辖区","371601" ,"滨城区","371602" ,"惠民县","371621" ,"阳信县","371622" ,"无棣县","371623" ,"沾化县","371624" ,"博兴县","371625" ,"邹平县","371626" ,"经济区","371627" ,"高新区","371628" ,"临港区","371629" "菏泽市","市辖区","371701" ,"牡丹区","371702" ,"曹县","371721" ,"单县","371722" ,"成武县","371723" ,"巨野县","371724" ,"郓城县","371725" ,"鄄城县","371726" ,"定陶县","371727" ,"东明县","371728" ,"开发区","371799" "1","性别是1和2,男的是1,女的是2" "2","如果一个人一个证书多个项目的话,是这样填写的:|A1|A2","前面和中间用"|"分开" "3","两个日期,批准日期和有效日期,必须是文本型的." "4","如果提示"读取模板错误",就在填写好内容的下面,删除200行,右侧删除50列,以保证内容正确","原因:因为在填写的过程中,很容易造成下面或者后面看似空的内容上,会有空格内容,造成读取模板错误" "6","作业种类、作业项目代号依据"项目内容查询"",