{"text_format":"2","workbook":"xlsx","n_sheets":2,"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":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,1,4,5]]}
[]
[null,"所需数据","bms，gps","备注"]
[null,"运行程序","dataset.py","整合7月到10月历史数据"]
[]
[null,"输出"]
[null,"序号","名称【单位】","数据类型","长度","备注"]
[null,1,"时间戳","str","短"]
[null,2,"总电流[A]","float","短（小数点后2位）"]
[null,3,"总电压[V]","float","短（小数点后2位）"]
[null,4,"故障代码","int","短"]
[null,5,"故障等级","int","短"]
[null,6,"gms信号","int","短"]
[null,7,"充电状态","int","短"]
[null,8,"开关状态","int","短"]
[null,9,"SOC[%]","float","短（小数点后2位）"]
[null,10,"SOH[%]","float","短（小数点后2位）"]
[null,11,"单体压差","float","短（小数点后3位）"]
[null,12,"绝缘电阻","float","短（小数点后2位）"]
[null,"13-32","单体电压[V]   1-20","float","短（小数点后2位）"]
[null,"33-34","单体温度[℃]  1、2","float","短（小数点后2位）"]
[null,35,"定位类型","int","短"]
[null,36,"纬度","float","短（小数点后6位）"]
[null,37,"经度","float","短（小数点后6位）"]
[null,38,"速度","float","短（小数点后2位）"]
[null,39,"有效位","int","短"]
[null,40,"sn","str","短"]

{"sheet":"每日里程","index":1,"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"]