{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["充电技术表单","热失控预警","历史剩余充电时间","每日里程"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,3,1,7],[9,1,9,7]]}
[]
[null,null,"项目","统计每次充电时段及充电前后静置时段的相关技术指标"]
[null,null,"读取本地文件","备注",null,"程序文件","运行周期","取数"]
[null,null,"sn-20210903.xlsx","sn总表",null,"core"]
[null,null,"gps.csv","gps城市对应表",null,"main_chrg","一天","24h内所有电池的BMS及GPS数据"]
[null,null,"temp.csv","气温表"]
[]
[]
[]
[null,"输出表：info_charge"]
[null,"序号","列名","单位","数据类型","长度","备注","示例"]
[null,1,"sn",null,"str","短",null,"MGMCLN750N215H001"]
[null,2,"time_st",null,"str","短","起始时间","2022-06-01T00:02:27"]
[null,3,"time_end",null,"str","短","结束时间","2022-06-02T23:59:46"]
[null,4,"status",null,"str","短","充放电状态","stand"]
[null,5,"delta_time","小时（H）","float","小数点后3位","时段时长",47.8829999999999]
[null,6,"soc_st","%","float","小数点后1位","起始SOC",0]
[null,7,"soc_end","%","float","小数点后1位","结束SOC",0]
[null,8,"volt_st","V","float","小数点后1位","起始电压",63.4]
[null,9,"volt_end","V","float","小数点后1位","结束电压",63.7]
[null,10,"diffvolt_st","V","float","小数点后3位","起始压差",0.237]
[null,11,"diffvolt_end","V","float","小数点后3位","结束压差",0.237]
[null,12,"temp_max","摄氏度（℃）","float","小数点后1位","全程最大单体温度",29]
[null,13,"temp_min","摄氏度（℃）","float","小数点后1位","全程最小单体温度",26]
[null,14,"temp_incr","摄氏度（℃）","float","小数点后1位","全程最大单体温升",5]
[null,15,"temp_mean","摄氏度（℃）","float","小数点后1位","全程平均单体温度",27.2]
[null,16,"temp_st_mean","摄氏度（℃）","float","小数点后1位","起始平均单体温度",28]
[null,17,"temp_end_mean","摄氏度（℃）","float","小数点后1位","结束平均单体温度",28.5]
[null,18,"difftem_max","摄氏度（℃）","float","小数点后1位","全程最大单体温差",2]
[null,19,"meancrnt","C","float","小数点后2位","电流倍率",0]
[null,20,"max_meancrnt","C","float","小数点后2位","最大倍率",0]
[null,21,"sts_flg",null,"int","1位整数","快慢充",0]
[null,22,"full_chrg_flg",null,"int","1位整数","满充",0]
[null,23,"ovchrg_flg",null,"int","1位整数","过充",0]
[null,24,"ovchrg_prop","%","float","小数点后3位","过充量",0]
[null,25,"gps_lon",null,"float","小数点后3位","经度",116.544]
[null,26,"gps_lat",null,"float","小数点后3位","纬度",39.76]
[null,27,"standtime_f","分钟（m）","float","小数点后3位","充电前静置时长",0]
[null,28,"standtime_b","分钟（m）","float","小数点后3位","充电后静置时长",0]
[null,29,"city",null,"str","短","城市","北京市市中⼼"]
[null,30,"airtemp_st","摄氏度（℃）","float","小数点后1位","起始气温",11]
[null,31,"airtemp_end","摄氏度（℃）","float","小数点后1位","结束气温",13]

{"sheet":"热失控预警","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[9,1,9,5]]}
[]
[null,"所需数据","bms"]
[null,"运行程序","程序名","备注","运行周期"]
[null,1,"anomalySparsePCA","分析异常指数变化"]
[null,2,"main_anomaly","2021年MGMC数据异常指数","一次"]
[]
[]
[]
[]
[null,"输出"]
[null,"序号","名称【单位】","数据类型","长度","备注"]
[null,1,"时间【小时】","str","短","年月日 小时"]
[null,2,"总电流[A]","float","短"]
[null,3,"总电压[V]","float","短"]
[null,4,"SOC[%]","float","短"]
[null,5,"单体电压1-20[V]","float","短"]
[null,6,"单体温度1-2[℃]","float","短"]
[null,7,"anomalySparsePCA","float","短"]
[null,8,"sn","str","短"]

{"sheet":"历史剩余充电时间","index":2,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,1,9,5]]}
[]
[null,"所需数据","bms"]
[null,"运行程序","程序名","备注"]
[null,1,"MakeDataSet.py","观测10月历史数据"]
[null,2,"修改时间后的MakeDataSet.py","观测09月历史数据"]
[]
[]
[]
[]
[null,"输出"]
[null,"序号","名称【单位】","数据类型","长度","备注"]
[null,1,"时间戳","str","短"]
[null,2,"总电流[A]","float","短（小数点后2位）"]
[null,3,"总电压[V]","float","短（小数点后2位）"]
[null,4,"SOC[%]","float","短（小数点后2位）"]
[null,5,"SOH[%]","float","短（小数点后2位）"]
[null,6,"剩余充电时间[sec]","int","短"]
[null,7,"剩余充电时间[时分秒]","str","短"]
[null,8,"最高单体电压[V]","float","短（小数点后2位）"]
[null,9,"最高单体温度[℃]","float","短（小数点后2位）"]
[null,10,"最低单体温度[℃]","float","短（小数点后2位）"]
[null,11,"sn","str","短"]

{"sheet":"每日里程","index":3,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[9,1,9,6],[20,1,20,6]]}
["所需数据","bms","gps"]
["所需程序","cal_mileage"]
["运行程序","程序名","运行时间","备注"]
[1,"main_daily_mileage","每天0h00运行","观测每天0h-24h数据"]
[2,"main_mileage","即刻","观测10月历史数据"]
[3,"修改时间后的main_mileage","main_mileage跑完后","观测09月历史数据"]
[]
[]
[]
[null,"过滤输入"]
[null,"序号","名称","数据类型","长度","单位","备注"]
[null,1,"时间戳","str",19,null,"时刻（年月日 时分秒）"]
[null,2,"总电流[A]","float","短（小数点后1位）","A","电池整体电流"]
[null,3,"总电压[V]","float","短（小数点后2位）","V","电池整体电压"]
[null,4,"SOC[%]","float","短（整数）","%","剩余电量"]
[null,5,"纬度","float","短（小数点后6位）","度","GPS定位"]
[null,6,"经度","float","短（小数点后6位）","度","GPS定位"]
[]
[]
[]
[null,"输出"]
[null,"序号","名称","数据类型","长度","单位","备注"]
[null,1,"时间戳","Series【str】","短","%Y-%m-%d %H:%M:%S","时刻（年月日 时分秒）"]
[null,2,"sn","Series【str】","短",null,"每辆车的编号"]
[null,3,"总电流[A]","Series【float】","短（小数点后1位）","A","电池整体电流"]
[null,4,"总电压[V]","Series【float】","短（小数点后2位）","V","电池整体电压"]
[null,5,"SOC[%]","Series【float】","短（整数）","%","剩余电量"]
[null,6,"充电状态","Series【float】","短（整数）",null,"2 or 3"]
[null,7,"纬度","Series【float】","短（小数点后6位）","度","GPS定位"]
[null,8,"经度","Series【float】","短（小数点后6位）","度","GPS定位"]
[null,9,"能耗[km/kwh]","Series【float】","短","km/kwh","中间用于计算距离的变量"]
[null,10,"每日累积里程[km]","Series【float】","短（小数点后9位）","km","每秒更新次日清零"]
[]
[null,null,null,"指令","输出"]
[null,null,null,"type(df_res.loc[0,'每日累积里程[km]'].values[0])","float"]
[null,null,null,"type(df_res.loc[0,'每日累积里程[km]'])","Series"]