{"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":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":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"]