{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["检查结果汇总","资产与设备信息不一致","物理世界中资产岗位关系与二维码中存的关系一致性检查","物理世界对象与模型一致性检查","多个岗位共用一个bimID检查","与业务空间有所在关系的设备的实际位置和业务空间位置不一致检查","revit模型中的族编码和岗位的设备类编码一致性检查"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":0,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[2,0,2,2]]}
["本次检查建筑体"]
["本次检查楼层"]
[]
["全部检查项","是否选择进行检查","结果"]

{"sheet":"资产与设备信息不一致","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7],[2,0,2,7]]}
["检查内容","检查资产与设备同一信息点都有值，值是否相等"]
["方法","1，缓存Building下的所有资产；\n2，缓存Building下的所有岗位；\n3，遍历所有的岗位，对比岗位和资产信息点，判断同一个有值的信息点，值是否相等。"]
["共检查XXX条数据，未通过检查的如下"]
["楼层本地名称","资产ID","资产本地名称","关联的岗位ID","岗位的本地名称","BIMID","通过","备注（失败原因）"]

{"sheet":"物理世界中资产岗位关系与二维码中存的关系一致性检查","index":2,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5]]}
["检查内容","二维码照片存储的资产和岗位是否正确"]
["方法","1，获取Buiding下的所有资产；\n2，通过资产，获取二维码关系表信息；\n3，对比资产对应的岗位id和二维码中存储的岗位id，判断是否一致。"]
["共检查XXX条数据，未通过检查的如下"]
["二维码key值","资产ID","资产关联的岗位id","资产二维码中关联的岗位id","通过","备忘（失败原因）"]

{"sheet":"物理世界对象与模型一致性检查","index":3,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6]]}
["检查内容","模型√ 对象×  需要重新创建对象\n模型×  对象√ 需要删除对象"]
["方法","1，获取Building下所有的楼层；\n2，遍历楼层；\n3，缓存本层物理世界的所有对象（设备、部件、信标、空间）数据；\n4，由本层模型计算所有可识别对象（设备、部件、信标、空间）数据；\n5，对比步骤3，4的数据，获取需要重建和删除对象的数据；\n6，移除删除的对象中BIMID不完整的数据。\n注：BIMID完整示例：Fl1223xxx:1233."]
[]
["楼层本地名称","对象ID","对象的本地名称","对象类型"," BIMID","通过","备忘（失败原因）"]

{"sheet":"多个岗位共用一个bimID检查","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,0,2,5]]}
["检查内容","多个岗位共用一个bimID"]
["方法","1，获取Building下所有的对象；\n2，按BIMID进行分组；\n3，遍历分组，如果分组中对象数量大于1，且对象的BIMID不为空或不为楼层Id，表明此分组对象共用一个BIMID；\n注：对象的BIMID为空或为楼层Id表示些对象为待建模状态。"]
["共检查XXX条数据，未通过检查的如下"]
["楼层本地名称","岗位ID","岗位的本地名称"," BIMID","通过","备忘（失败原因）"]
[]
[]
[]
[]
[]
[null,"     "]

{"sheet":"与业务空间有所在关系的设备的实际位置和业务空间位置不一致检查","index":5,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,1,1,8]]}
["检查内容","业务空间所在楼层和其中的设备所在楼层一致性检查         "]
["方法","1，获取所有楼层；\n2，遍历楼层：\n2.1，查询楼层下的设备，得到设备集合A; \n2.2，查询楼层下的业务空间集合B；\n2.3，查询与业务空间集合B有EquipinSpace关联的设备，得到集合C\n2.4，集合C与集合A求差集；得到设备集合D（即设备所在楼层与业务空间所在楼层不一致的设备）\n2.5，设备集合D，查询其中的设备所在楼层"]
["共检查XXX条数据，未通过检查的如下"]
["业务空间类型","业务空间本地名称","业务空间id","业务空间所在楼层","空间内的设备本地名称","设备id","设备所在楼层","通过","备忘（失败原因）"]

{"sheet":"revit模型中的族编码和岗位的设备类编码一致性检查","index":6,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7]]}
["检查内容","模型中的族编码和岗位的设备类编码是否一致"]
["方法","1，获取Building下所有的楼层；\n2，遍历楼层；\n3，缓存本层物理世界的所有岗位（设备、部件）数据；\n4，遍历本层所有的岗位（设备、部件）；\n4.1，依据岗位的Bimid从本层文件中获取模型对象；\n4.2，对比岗位的设备类编码与模型对象的族编码是否一致，不一致显示到下列表中。"]
["共检查XXX条数据，未通过检查的如下"]
["楼层本地名称","revit模型族编码","模型族名称","BIMid","岗位设备类编码","岗位id","通过","备忘（失败原因）"]