{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cover page","Overview SP","Overview EN","Inicio","Conductores","Vehículos","Recorrido","Combustible","Indicadores","Hoja2"],"not_rendered":{"charts":7,"images":30,"macros":1,"external_links":0,"defined_names":62,"comments":0,"pivot_tables":5},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Cover page","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[7,2,10,8],[11,4,11,5],[12,4,12,5],[16,2,26,8]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Economic saving and GHG mitigation emisions tool \nFor the Implementation of Ecodriving Program "]
[]
[]
[]
[null,null,null,null," July 2021"]
[null,null,null,null,"Lima, Peru "]
[]
[]
[]
[null,null,"Product developed within the framework of TRANSfer Peru project and the consultancy \"Ecodriving MRV Toolkit\" for the economic and GHG evaluation of the implementation of Ecodriving program. Carried out by Proactive Engenieering for the Ministry of Transport and Communication and Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Author: Luis Felipe Villareal "]

{"sheet":"Overview SP","index":1,"n_rows":4,"n_cols":58,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"1. Secciones de la herramienta",null,null,null,null,null,null,null,null,null,null,null,null,null,"A. Sección: información de la flota ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B. Sección: Gestion de la ruta y combustible ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C. Sección: Indicadores de desempeño"]

{"sheet":"Overview EN","index":2,"n_rows":4,"n_cols":58,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"1. Toolkit sections",null,null,null,null,null,null,null,null,null,null,null,null,null,"A. Section: Fleet Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B. Section: Fuel and route management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C. Section: Key Performance indicators"]

{"sheet":"Inicio","index":3,"n_rows":41,"n_cols":1,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["® Proactive Engineering S.A.C. "]

{"sheet":"Conductores","index":4,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Fecha de Registro","Apellidos y Nombres","Nacionalidad","Número de Documento","Fecha de Vencimiento de Documento","Código de Conductor","Categoría de Licencia de Conducir","Número de Licencia de Conducir","Fecha de vencimiento de Licencia de Conducir","Licencias especiales","Años de Experiencia como condcutor"]
[null,"2021-07-03T10:50:47","MUÑOZ LOPEZ LUIS ALFREDO","VENEZOLANO","002988274","21/01/2024",null,"AIII-C","Q002988274","26/08/2025","","Mayor o igual a 10 años y menor a 15 años"]
[null,"2021-07-03T10:50:59","TAIPE SILVERA ROLANDO JAIME","PERUANO","44433255","07/10/2027",null,"AIII-C","Q44433255","15/08/2022","","Mayor o igual a 5 años y menor a 10 años"]
[null,"2021-07-03T10:51:10"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","PERUANO","32302732","19/10/2026",null,"AIII-C","Q32302732","03/06/2024","","Mayor o igual a 5 años y menor a 10 años"]
[null,"2021-07-03T10:51:18"," BARRIENTOS GARAY GERMAN","PERUANO","10203204","12/07/2026",null,"AIII-C","Q10203204","07/01/2023","","Mayor a 15 años"]
[null,"2021-07-03T10:51:28","RUDECINDO ROSALES ALEJANDRO","PERUANO","28781874","11/11/2026",null,"AIII-C","Q25781874","11/05/2022","","Mayor o igual a 10 años y menor a 15 años"]
[null,"2021-07-03T10:51:38"," VEGA SILVA CARLOS ENRIQUE","PERUANO","25781874","02/10/2026",null,"AIII-C","Q25781874","13/03/2022","","Mayor a 15 años"]
[null,"2021-07-03T10:53:40","AVILA PERALTA LUIS ANGEL","PERUANO","40733972","11/03/2028",null,"AIII-C","Q40733972","20/02/2020","","Menor a 5 años"]

{"sheet":"Vehículos","index":5,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Fecha de Registro","Fecha de adquisicón","Placa de vehículo","Carrocería","Categoría","Marca","Modelo","Año de fabricación","Peso bruto","Peso neto","Carga útil","Bicombustible","Combustible 1","Combustible 2","Recorrido actual (Km)","Valor de adquisición (Incl. IGV)"]
[null,"2021-07-03T09:53:54","2014-10-01","B1Q809","Remolque","N3","FREIGHTLINER","M2 112","2008",23.587,7,16.587,"No","Diesel B5","","",""]
[null,"2021-07-03T10:00:47","25/04/2014","P2M891","Remolque","N3","VOLVO","F12","1993",25,7,18,"No","Diesel B5","","",""]
[null,"2021-07-03T10:24:42","15/06/2015","C1K756","Remolque","N3","FREIGHTLINER","CL120","2012",27.21,8.19,19.02,"No","Diesel B5","","",""]
[null,"2021-07-03T10:35:50","13/11/2014","ABR841","Remolque","N3","SCANIA","P410 A6X4","2014",26.5,9.34,17.16,"No","Diesel B5","","",""]
[null,"2021-07-03T10:41:08","27/08/2019","B8W786","Remolque","N3","INTERNATIONAL","8600 SBA 6X4","2013",23.585000000000001,7.1849999999999996,16.399999999999999,"No","Diesel B5","","",""]
[null,"2021-07-03T10:46:25","09/07/2018","F1O746","Remolque","N3","FREIGHTLINER","FLD11264ST","1996",25,6.67,18.329999999999998,"No","Diesel B5","","",""]
[null,"2021-07-03T10:49:11","27/08/2019","B8T720","Remolque","N3","INTERNATIONAL","8600 SBA 6X4","2013",23.585000000000001,7.1849999999999996,16.399999999999999,"No","Diesel B5","","",""]

{"sheet":"Recorrido","index":6,"n_rows":132,"n_cols":16,"rows_kept":132,"cut":false,"hidden":false,"merged":[]}
[null,"Fecha de Registro","Placa de vehículo","Placa de vehículo no motorizado","Conductor(a)","Unidad de negocio","Peso de la carga transportada","Fecha Partida","Hora Partida","Kilometraje Partida","Lugar Partida","Fecha Destino","Hora Destino","Kilometraje Destino","Lugar Destino","Recorrido"]
[null,"2021-07-12T11:52:32","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",31.2,"2021-06-24","","0","Huacho","2021-06-25","",null,"Ate",157.4]
[null,"2021-07-12T11:54:53","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-06-24","","0","OQUENDO","2021-06-25","",null,"LURIN",132]
[null,"2021-07-12T11:55:36","F1O746","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-06-24","","0","OQUENDO","2021-06-25","",null,"LURIN",54.5]
[null,"2021-07-12T11:56:30","P2M891",""," BARRIENTOS GARAY GERMAN","",16,"2021-06-24","","0","OQUENDO","2021-06-24","",null,"OQUENDO",32.700000000000003]
[null,"2021-07-12T11:57:12","P2M891",""," BARRIENTOS GARAY GERMAN","",31,"2021-06-24","","0","OQUENDO","2021-06-25","",null,"CHORRILLOS",32.4]
[null,"2021-07-12T11:58:05","ABR841","","AVILA PERALTA LUIS ANGEL","",30.42,"2021-06-24","","0","HUACHO","2021-06-24","",null,"ATE",157.4]
[null,"2021-07-12T11:58:59","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",31.2,"2021-06-24","","0","HUACHO","2021-06-25","",null,"ATE",151.69999999999999]
[null,"2021-07-12T12:01:48","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",31.2,"2021-06-25","","0","HUACHO","2021-06-26","",null,"V.E.S.",169.3]
[null,"2021-07-12T12:02:49","F1O746","","RUDECINDO ROSALES ALEJANDRO","",29,"2021-06-25","","0","HUACHIPA","2021-06-28","",null,"BARRANCA",203]
[null,"2021-07-12T12:03:21","P2M891",""," BARRIENTOS GARAY GERMAN","",30,"2021-06-25","","0","OQUENDO","2021-06-25","",null,"OQUENDO",32.700000000000003]
[null,"2021-07-12T12:03:53","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-06-25","","0","HUACHO","2021-06-26","",null,"OQUENDO",124.2]
[null,"2021-07-12T12:06:25","B1Q809",""," VEGA SILVA CARLOS ENRIQUE","",31.2,"2021-06-26","","0","HUACHO","2021-06-28","",null,"CERCADO DE LIMA",258.3]
[null,"2021-07-12T12:07:09","ABR841","","AVILA PERALTA LUIS ANGEL","",30.16,"2021-06-26","","0","HUACHO","2012-06-28","",null,"BOCANEGRA",135.69999999999999]
[null,"2021-07-12T12:07:37","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-06-26","","0","HUACHO","2021-06-28","",null,"PUENTE PIEDRA",266.3]
[null,"2021-07-12T12:08:06","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",31.2,"2021-06-26","","0","HUACHO","2021-06-27","",null,"PRODUCTORES",142.5]
[null,"2021-07-12T12:09:47","P2M891",""," BARRIENTOS GARAY GERMAN","",30,"2021-06-28","","0","OQUENDO","2021-06-28","",null,"OQUENDO",32.700000000000003]
[null,"2021-07-12T12:10:12","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",16,"2021-06-28","","0","OQUENDO","2021-06-28","",null,"OQUENDO",32.299999999999997]
[null,"2021-07-12T12:10:57","P2M891",""," BARRIENTOS GARAY GERMAN","",8,"2021-06-28","","0 ","VENTANILLA","2021-06-29","",null,"BOCANEGRA",92.4]
[null,"2021-07-12T12:11:37","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",8,"2021-06-28","","0","VENTANILLA","2021-06-29","",null,"BOCANEGRA",92.4]
[null,"2021-07-12T12:13:33","F1O746","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-06-28","","0","HUACHO","2021-06-29","",null,"OQUENDO",288.39999999999998]
[null,"2021-07-12T12:14:49","B8W786","","TAIPE SILVERA ROLANDO JAIME","",17.96,"2021-06-29","","0","HUACHIPA","2021-06-29","",null,"ATE",31.3]
[null,"2021-07-12T12:15:22","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",15.02,"2021-06-29","","0","HUACHIPA","2021-06-29","",null,"COMAS",153]
[null,"2021-07-12T12:22:41","F1O746","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-06-30","","0","OQUENDO","2021-07-01","",null,"CHORRILLOS",32.4]
[null,"2021-07-12T12:23:22","P2M891",""," BARRIENTOS GARAY GERMAN","",16.309999999999999,"2021-06-30","","0","HUACHIPA","2021-06-30","",null,"CALLAO",27.2]
[null,"2021-07-12T12:23:51","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",27,"2021-06-30","","0","HUACHIPA","2021-07-01","",null,"HUARAL",95.8]
[null,"2021-07-12T12:24:17","ABR841","","AVILA PERALTA LUIS ANGEL","",29,"2021-06-30","","0","HUACHIPA","2021-07-01","",null,"BARRANCA",203]
[null,"2021-07-12T12:24:42","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",8,"2021-06-30","","0","BOCANEGRA","2021-06-30","",null,"HUACHO",137.5]
[null,"2021-07-12T12:25:02","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-06-30","","0","HUACHO","2021-07-01","",null,"CALLAO",138.19999999999999]
[null,"2021-07-12T12:26:04","B8W786","","TAIPE SILVERA ROLANDO JAIME","",17.920000000000002,"2021-07-01","","0","OQUENDO","2021-07-02","",null,"CHORRILLOS",73.7]
[null,"2021-07-12T12:26:34","P2M891",""," BARRIENTOS GARAY GERMAN","",30,"2021-07-01","","0","OQUENDO","2021-07-02","",null,"OQUENDO",32.700000000000003]
[null,"2021-07-12T12:27:09","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-01","","0","HUACHO","2021-07-02","",null,"PUENTE PIEDRA",119.2]
[null,"2021-07-12T12:27:34","ABR841","","AVILA PERALTA LUIS ANGEL","",30,"2021-07-01","","0","HUACHO","2021-07-02","",null,"CHINCHA",342]
[null,"2021-07-12T12:27:54","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-01","","0","OQUENDO","2021-07-02","",null,"CALLAO",32.299999999999997]
[null,"2021-07-12T12:28:49","F1O746","","RUDECINDO ROSALES ALEJANDRO","",17,"2021-07-02","","0","OQUENDO","2021-07-02","",null,"OQUENDO",32.299999999999997]
[null,"2021-07-12T12:29:08","F1O746","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-02","","0","OQUENDO","2021-07-02","",null,"OQUENDO",32.299999999999997]
[null,"2021-07-12T12:29:32","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-02","","0","HUACHO","2021-07-05","",null,"CHIMBOTE",290.5]
[null,"2021-07-12T12:30:01","B8W786","","TAIPE SILVERA ROLANDO JAIME","",17.89,"2021-07-02","","0","HUACHIPA","2021-07-02","",null,"S.J.L.",7.5]
[null,"2021-07-12T12:30:27","B8W786","","TAIPE SILVERA ROLANDO JAIME","",28.5,"2021-07-02","","0","HUACHO","2021-07-03","",null,"OQUENDO",288.39999999999998]
[null,"2021-07-12T12:30:54","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",7,"2021-07-02","","0","PUENTE NUEVO","2021-07-03","",null,"BOCANEGRA",14]
[null,"2021-07-12T12:31:18","P2M891",""," BARRIENTOS GARAY GERMAN","",20,"2021-07-02","","0","OQUENDO","2021-07-03","",null,"LURIN",58.5]
[null,"2021-07-12T12:31:55","ABR841","","AVILA PERALTA LUIS ANGEL","",29,"2021-07-02","","0","HUACHIPA","2021-07-03","",null,"BARRANCA",203]
[null,"2021-07-12T12:33:04","B1Q809",""," VEGA SILVA CARLOS ENRIQUE","",30,"2021-07-03","","0","HUACHO","2021-07-05","",null,"PUENTE PIEDRA",216.9]
[null,"2021-07-12T12:33:27","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",20,"2021-07-03","","0","OQUENDO","2021-07-05","",null,"ATE",37.700000000000003]
[null,"2021-07-12T12:33:50","ABR841","","AVILA PERALTA LUIS ANGEL","",30.34,"2021-07-03","","0","HUACHO","2021-07-05","",null,"BOCANEGRA",135.69999999999999]
[null,"2021-07-12T12:34:50","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-05","","0","OQUENDO","2021-07-06","",null,"CALLAO",40.9]
[null,"2021-07-12T12:35:17","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-05","","0","OQUENDO","2021-07-06","",null,"OQUENDO",32.299999999999997]
[null,"2021-07-12T12:35:43","B8W786","","TAIPE SILVERA ROLANDO JAIME","",17.87,"2021-07-05","","0","HUACHIPA","2021-07-06","",null,"INDEPENDENCIA",28.4]
[null,"2021-07-12T12:38:46","B8W786","","TAIPE SILVERA ROLANDO JAIME","",17.8,"2021-07-06","","0","CHORRILLOS","2021-07-07","",null,"OQUENDO",42]
[null,"2021-07-12T12:39:14","ABR841","","AVILA PERALTA LUIS ANGEL","",29.5,"2021-07-06","","0","HUACHO","2021-07-07","",null,"OQUENDO",288.39999999999998]
[null,"2021-07-12T12:39:47","P2M891",""," BARRIENTOS GARAY GERMAN","",16.18,"2021-07-06","","0","HUACHIPA","2021-07-06","",null,"CALLAO",27.2]
[null,"2021-07-12T12:40:11","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-06","","0","HUACHO","2021-07-06","",null,"OQUENDO",130.30000000000001]
[null,"2021-07-12T12:40:33","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-06","","0","CALLAO","2021-07-06","",null,"CALLAO",31.4]
[null,"2021-07-12T12:40:53","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",28,"2021-07-06","","0","HUACHIPA","2021-07-07","",null,"HUARAL",165.3]
[null,"2021-07-12T12:41:19","B1Q809",""," VEGA SILVA CARLOS ENRIQUE","",28,"2021-07-06","","0","CALLAO","2021-07-07","",null,"BARRANCA",242.3]
[null,"2021-07-12T12:41:41","B8W786","","TAIPE SILVERA ROLANDO JAIME","",17.87,"2021-07-06","","0","HUACHIPA","2021-07-06","",null,"SURCO",37.9]
[null,"2021-07-12T12:42:35","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-07","","0 ","HUACHO","2021-07-08","",null,"OQUENDO",288.39999999999998]
[null,"2021-07-12T12:43:09","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-07-07","","0","OQUENDO","2021-07-07","",null,"ATE",38.799999999999997]
[null,"2021-07-12T12:43:34","ABR841","","AVILA PERALTA LUIS ANGEL","",30,"2021-07-07","","0","OQUENDO","2021-07-08","",null,"HUACHO",288.39999999999998]
[null,"2021-07-12T12:44:01","P2M891",""," BARRIENTOS GARAY GERMAN","",17.16,"2021-07-07","","0","HUACHIPA","2021-07-07","",null,"SURCO",37.9]
[null,"2021-07-12T12:44:28","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-07","","0","HUACHO","2021-07-08","",null,"OQUENDO",124.2]
[null,"2021-07-12T12:44:57","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-08","","0","OQUENDO","2021-07-08","",null,"OQUENDO",32.299999999999997]
[null,"2021-07-12T12:45:24","P2M891",""," BARRIENTOS GARAY GERMAN","",30,"2021-07-08","","0","OQUENDO","2021-07-08","",null,"OQUENDO",32.700000000000003]
[null,"2021-07-12T12:46:57","ABR841","","AVILA PERALTA LUIS ANGEL","",30,"2021-07-08","","0","HUACHO","2021-07-08","",null,"OQUENDO",288.39999999999998]
[null,"2021-07-12T12:48:00","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-07-08","","0","HUACHO","2021-07-09","",null,"PUENTE PIEDRA",120]
[null,"2021-07-12T12:48:29","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",17,"2021-07-08","","0","OQUENDO","2021-07-08","",null,"OQUENDO",32.299999999999997]
[null,"2021-07-12T12:49:28","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-08","","0","OQUENDO","2021-07-08","",null,"ATE",38.799999999999997]
[null,"2021-07-19T13:11:22","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-09","","0","HUACHO","2021-07-09","",null,"PRODUCTORES",148.19999999999999]
[null,"2021-07-19T13:16:06","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-09","","0","HUACHO","2021-07-10","",null,"OQUENDO",288.39999999999998]
[null,"2021-07-19T13:17:52","P2M891",""," BARRIENTOS GARAY GERMAN","",25,"2021-07-09","","0","CHORRILLOS","2021-07-10","",null,"LOS OLIVOS",29.9]
[null,"2021-07-19T13:18:45","P2M891",""," BARRIENTOS GARAY GERMAN","",26,"2021-07-09","","0","HUACHIPA","2021-07-09","",null,"SJL|",18.600000000000001]
[null,"2021-07-19T13:21:31","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-09","","0","HUACHO","2021-07-10","",null,"OQUENDO",130.30000000000001]
[null,"2021-07-19T13:23:10","B8W786","","TAIPE SILVERA ROLANDO JAIME","",29,"2021-07-09","","0","HUACHIPA","2021-07-10","",null,"BARRANCA",205.1]
[null,"2021-07-19T13:25:28","B8W786","","TAIPE SILVERA ROLANDO JAIME","",29,"2021-07-09","","0","HUACHIPA","2021-07-10","",null,"BARRANCA",205.1]
[null,"2021-07-19T13:27:52","ABR841","","AVILA PERALTA LUIS ANGEL","",28.5,"2021-07-09","","0","HUACHO","2021-07-10","",null,"OQUENDO",288.39999999999998]
[null,"2021-07-19T13:29:38","ABR841","","AVILA PERALTA LUIS ANGEL","",30,"2021-07-10","","0","OQUENDO","2021-07-12","",null,"HUACHIPA",34.299999999999997]
[null,"2021-07-19T13:32:45","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",31.2,"2021-07-10","","0","OQUENDO","2021-07-12","",null,"TRUJILLO",549.4]
[null,"2021-07-19T13:34:55","P2M891",""," BARRIENTOS GARAY GERMAN","",20,"2021-07-10","","0","OQUENDO","2021-07-12","",null,"LURIN",58.5]
[null,"2021-07-19T13:36:21","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",129.6,"2021-07-10","","0","HUACHO","2021-07-12","",null,"SMP",129.6]
[null,"2021-07-19T13:38:42","B8W786","","TAIPE SILVERA ROLANDO JAIME","",31.2,"2021-07-10","","0","HUACHO","2021-07-11","",null,"PRODUCTORES",148.19999999999999]
[null,"2021-07-19T13:40:03","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",31.2,"2021-07-10","","0","HUACHO","2021-07-12","",null,"OQUENDO",124.2]
[null,"2021-07-20T09:21:29","B8W786","","TAIPE SILVERA ROLANDO JAIME","",25,"2021-07-12","","0","CHORRILLOS","2021-07-12","",null,"LOS OLIVOS",29.9]
[null,"2021-07-20T09:22:29","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-07-12","","0","OQUENDO","2021-07-14","",null,"TRUJILLO",559.4]
[null,"2021-07-20T09:23:35","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",20,"2021-07-12","","0","OQUENDO","2021-07-13","",null,"CHORRILLOS",32.4]
[null,"2021-07-20T09:24:53","P2M891",""," BARRIENTOS GARAY GERMAN","",25,"2021-07-12","","0","CHORRILLOS","2021-07-13","",null,"LOS OLIVOS",29.9]
[null,"2021-07-20T09:25:33","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",2,"2021-07-12","","0","CALLAO","2021-07-12","",null,"CALLAO",3]
[null,"2021-07-20T09:28:26","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-12","","0","OQUENDO","2021-07-13","",null,"PRODUCTORES",27.3]
[null,"2021-07-20T09:32:14","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-13","","0","HUACHO","2021-07-14","",null,"OQUENDO",130.30000000000001]
[null,"2021-07-20T09:33:55","ABR841","","AVILA PERALTA LUIS ANGEL","",25,"2021-07-13","","0","CHORRILLOS","2021-07-13","",null,"OLIVOS",29.9]
[null,"2021-07-20T09:41:06","ABR841","","AVILA PERALTA LUIS ANGEL","",30,"2021-07-14","","0","HUACHO","2021-07-15","",null,"OQUENDO",288.39999999999998]
[null,"2021-07-20T09:42:21","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",28,"2021-07-14","","0","HUACHIPA","2021-07-15","",null,"HUARAL",89.8]
[null,"2021-07-20T09:43:34","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-14","","0","HUACHO","2021-07-14","",null,"OQUENDO",124.2]
[null,"2021-07-20T09:44:18","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",17,"2021-07-14","","0","OQUENDO","2021-07-15","",null,"OQUENDO",0]
[null,"2021-07-20T09:46:21","P2M891",""," BARRIENTOS GARAY GERMAN","",27.2,"2021-07-14","","0","HUACHIPA","2021-07-14","",null,"CALLAO",27.2]
[null,"2021-07-20T09:47:45","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-14","","0","OQUENDO","2021-07-15","",null,"OQUENDO",32.700000000000003]
[null,"2021-07-20T09:49:33","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-15","","O","OQUENDO","2021-07-16","",null,"LURIN",58.5]
[null,"2021-07-20T09:50:34","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-07-15","","0","HUACHO","2021-07-16","",null,"PUENTE PIEDRA",119.2]
[null,"2021-07-20T09:51:31","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-15","","0","OQUENDO","2021-07-16","",null,"ZAPALLAL",20.7]
[null,"2021-07-20T09:54:28","ABR841","","AVILA PERALTA LUIS ANGEL","",28,"2021-07-15","","0","HUACHIPA","2021-07-16","",null,"BARRANCA",205.1]
[null,"2021-07-20T09:56:36","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-15","","0","HUACHO","2021-07-16","",null,"SMP",0]
[null,"2021-07-20T09:57:31","P2M891",""," BARRIENTOS GARAY GERMAN","",26,"2021-07-15","","0","HUACHIPA","2021-07-15","",null,"SURCO",25.1]
[null,"2021-07-20T09:58:48","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30.5,"2021-07-15","","0","OQUENDO","2021-07-15","",null,"ATE",36.5]
[null,"2021-07-23T13:25:41","ABR841","","AVILA PERALTA LUIS ANGEL","",30,"2021-07-16","","0","HUACHO","2021-07-17","",null,"CHINCHA",342.1]
[null,"2021-07-23T13:26:43","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-07-16","","0","HUACHO","2021-07-17","",null,"V.E.S",169.3]
[null,"2021-07-23T13:27:42","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-16","","0","HUACHO","2121-07-17","",null,"S.M.P",141.19999999999999]
[null,"2021-07-23T13:28:46","P2M891",""," BARRIENTOS GARAY GERMAN","",23,"2021-07-16","","0","HUACHIPA","2021-07-16","",null,"COMAS",31.6]
[null,"2021-07-23T13:29:43","P2M891",""," BARRIENTOS GARAY GERMAN","",30,"2021-07-16","","0","OQUENDO","2021-07-17","",null,"PRODUCTORES",27.3]
[null,"2021-07-23T13:31:17","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-17","","0","HUACHO","2021-07-19","",null,"S.M.P",141.19999999999999]
[null,"2021-07-23T13:33:08","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-19","","0","OQUENDO","2021-07-20","",null,"HUACHO",130.4]
[null,"2021-07-23T13:33:59","P2M891",""," BARRIENTOS GARAY GERMAN","",28,"2021-07-19","","0","PTE. NUEVO","2021-07-19","",null,"BOCANEGRA",12.8]
[null,"2021-07-23T13:34:51","B8W786","","TAIPE SILVERA ROLANDO JAIME","",25,"2021-07-19","","0","HUACHIPA","2021-07-19","",null,"CALLAO",27.2]
[null,"2021-07-23T13:35:37","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-07-19","","0","OQUENDO","2021-07-20","",null,"HUARMEY",279.3]
[null,"2021-07-23T13:38:54","P2M891",""," BARRIENTOS GARAY GERMAN","",30,"2021-07-20","","0","OQUENDO","2021-07-20","",null,"OQUENDO|",32.700000000000003]
[null,"2021-07-23T13:39:43","ABR841","","AVILA PERALTA LUIS ANGEL","",30,"2021-07-20","","0","HUACHO","2021-07-21","",null,"HUACHIPA",150]
[null,"2021-07-23T13:40:39","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-20","","0","HUACHO","2021-07-21","",null,"S.M.P",141.19999999999999]
[null,"2021-07-23T13:41:30","P2M891",""," BARRIENTOS GARAY GERMAN","",30,"2021-07-20","","0","OQUENDO","2021-07-21","",null,"HUACHIPA",34.1]
[null,"2021-07-23T13:43:04","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-21","","0","HUACHO","2021-07-21","",null,"PRODUCTORES",148.19999999999999]
[null,"2021-07-23T13:44:09","F1O746",""," VEGA SILVA CARLOS ENRIQUE","",25,"2021-07-21","","0","HUACHIPA","2021-07-21","",null,"ATE",4.2]
[null,"2021-07-23T13:45:02","F1O746",""," VEGA SILVA CARLOS ENRIQUE","",30,"2021-07-21","","0","OQUENDO","2021-07-22","",null,"CHORRILLOS",32.4]
[null,"2021-07-23T13:45:47","F1O746",""," VEGA SILVA CARLOS ENRIQUE","",30,"2021-07-21","","0","CHORRILLOS","2021-07-22","",null,"OQUENDO",32.4]
[null,"2021-07-23T13:46:36","B8W786","","TAIPE SILVERA ROLANDO JAIME","",30,"2021-07-21","","0","HUACHO","2021-07-21","",null,"PRODUCTORES",25]
[null,"2021-07-23T13:47:41","P2M891",""," BARRIENTOS GARAY GERMAN","",30,"2021-07-21","","0","OQUENDO","2021-07-22","",null,"PRODUCTORES",27.3]
[null,"2021-07-24T09:11:33","B8W786","","TAIPE SILVERA ROLANDO JAIME","",39,"2021-07-22","","0","HUACHO","2021-07-23","",null,"HUACHIPA",155]
[null,"2021-07-24T09:13:00","ABR841","","AVILA PERALTA LUIS ANGEL","",30,"2021-07-22","","0","HUACHO","2021-07-21","",null,"HUARAZ",266]
[null,"2021-07-24T09:14:30","P2M891",""," BARRIENTOS GARAY GERMAN","",25,"2021-07-22","","0","HUACHIPA","2021-07-22","",null,"SURC0",25.1]
[null,"2021-07-24T09:15:33","B8W786","","TAIPE SILVERA ROLANDO JAIME","",25,"2021-07-22","","0","HUACHIPA","2021-07-22","",null,"COMAS",31.6]
[null,"2021-07-24T09:16:58","C1K756",""," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","",30,"2021-07-22","","0","HUACHO","2021-07-23","",null,"PACHACAMAC",186.6]
[null,"2021-07-24T09:20:03","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-22","","0","OQUENDO","2021-07-22","",null,"OQUENDO",32.700000000000003]
[null,"2021-07-24T09:21:24","B8T720","","MUÑOZ LOPEZ LUIS ALFREDO","",30,"2021-07-22","","0","OQUENDO","2021-07-23","",null,"LURIN,CHORRILLOS",58.5]
[" ","2021-07-24T10:06:54","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-16","","0","OQUENDO","2021-07-17","",null,"OQUENDO",32.700000000000003]
[null,"2021-07-24T10:07:44","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-17","","0","HUACHO","2021-07-19","",null,"V.E.S",169.3]
[null,"2021-07-24T10:08:42","B1Q809","","RUDECINDO ROSALES ALEJANDRO","",30,"2021-07-22","","0","OQUENDO","2021-07-23","",null,"HUACHIPA",34.1]

{"sheet":"Combustible","index":7,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Fecha de Registro","Fecha de abastecimiento","Placa de vehículo","Conductor","Kilometraje de abastecimiento","Razón Social del grifo","Tipo de documento contable","Número de factura/boleta/ticket","Tipo de combustible","Unidad de negocio","Volumen de combustible abastecido","Medida","Gasto total (Incl. IGV)","Imagen de la factura/boleta/ticket"]
[null,"2021-07-30T19:12:09","2021-06-23","ABR841","AVILA PERALTA LUIS ANGEL","0","GRIFOS ESPINOZA S.A.","Factura","F109-00116111","Diesel B5","",74.13,"Galones",847.47]
[null,"2021-07-30T19:12:15","2021-06-23","F1O746"," VEGA SILVA CARLOS ENRIQUE",0,"OPERADORES S.A.C.","Factura","F102-00107756","Diesel B5","",32.076999999999998,"Galones",338.98]
[null,"2021-07-30T19:12:15","2021-06-26","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ",0,"ESTACION DE SERVICIOS HERCO S.A.C.","Factura","F055-026962","Diesel B5","",23.904,"Galones",254.24]
[null,"2021-07-30T19:12:15","2021-06-28","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ",0,"ETISSA S.A.","Factura","F001-00057887","Diesel B5","",145,"Galones",1634.32]
[null,"2021-07-30T19:12:16","2021-06-29","B8T720","MUÑOZ LOPEZ LUIS ALFREDO","0","ESTACION SANTA RITA S.A.C.","Factura","F001-00013031","Diesel B5","",147.60300000000001,"Galones",1694.93]
[null,"2021-07-30T19:12:16","2021-07-05","ABR841","AVILA PERALTA LUIS ANGEL",0,"JE OPERACIONES S.A.C","Factura","F103-00099151","Diesel B5","",146.69900000000001,"Galones",1535.36]
[null,"2021-07-30T19:12:16","2021-06-29","ABR841","AVILA PERALTA LUIS ANGEL","0","ESTACION PETROGAS CAMPOY S.A.C.","Factura","F420-00000604","Diesel B5","",127.821,"Galones",1436.36]
[null,"2021-07-30T19:12:16","2021-06-25","B1Q809","RUDECINDO ROSALES ALEJANDRO","0","ESTACION PETROGAS CAMPOY S.A.C.","Factura","F420-00000605","Diesel B5","",151.83099999999999,"Galones",1706.17]
[null,"2021-07-30T19:12:16","2021-06-19","B8T720","MUÑOZ LOPEZ LUIS ALFREDO","0","ESTACION PETROGAS CAMPOY S.A.C","Factura","F420-00000606","Diesel B5","",97.715999999999994,"Galones",1098.06]
[null,"2021-07-30T19:12:17","2021-06-21","B8W786","TAIPE SILVERA ROLANDO JAIME","0","ESTACION PETROGAS CAMPOY S.A.C.","Factura","F420-00000607","Diesel B5","",113.295,"Galones",1273.1300000000001]
[null,"2021-07-30T19:12:17","2021-06-28","B8W786","TAIPE SILVERA ROLANDO JAIME","0","ESTACION PETROGAS CAMPOY S.A.C.","Factura","F420-00000607","Diesel B5","",84.465000000000003,"Galones",949.16]
[null,"2021-07-30T19:12:17","2021-06-21","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","0","ESTACION PETROGAS CAMPOY S.A.C.","Factura","F420-00000608","Diesel B5","",80.001999999999995,"Galones",899.01]
[null,"2021-07-30T19:12:17","2021-06-25","F1O746"," VEGA SILVA CARLOS ENRIQUE","0","ESTACION PETROGAS CAMPOY S.A.C.","Factura","F420-00000610","Diesel B5","",113.5,"Galones",1275.43]
[null,"2021-07-30T19:12:17","2021-06-29","P2M891"," BARRIENTOS GARAY GERMAN","0","ESTACION PETROGAS CAMPOY S.A.C.","Factura","F420-00000612","Diesel B5","",102.18600000000001,"Galones",1148.3]
[null,"2021-07-30T19:12:18","2021-07-05","ABR841","AVILA PERALTA LUIS ANGEL","0","JE OPERADORES SAC","Factura","F103-00099151","Diesel B5","",146.69900000000001,"Galones",1535.36]
[null,"2021-07-30T19:12:18","2021-07-02","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","0","SERVICENTRO HUARMEY SAC","Factura","F113-00050281","Diesel B5","",112.79,"Galones",1389.85]
[null,"2021-07-30T19:12:18","2021-07-09","B1Q809","RUDECINDO ROSALES ALEJANDRO","0","EMP. DE SERV. Y TRANSP. EL NEGRO EIRL","Factura","FC05-00001131","Diesel B5","",43.134439999999998,"Galones",508.47]
[null,"2021-07-30T19:12:18","2021-07-09","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","0","ESTACION DE SERVICIOS HERCO SAC","Factura","F055-028387","Diesel B5","",36.927,"Galones",423.73]
[null,"2021-07-30T19:12:18","2021-07-13","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","0","G CELESTE SAC","Factura","F006-016567","Diesel B5","",36.152999999999999,"Galones",423.73]
[null,"2021-07-30T19:12:19","2021-07-13","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","0","LOS PORTALES","Factura","F002-00075058","Diesel B5","",37.481000000000002,"Galones",423.73]
[null,"2021-07-30T19:12:19","2021-07-12","F1O746"," VEGA SILVA CARLOS ENRIQUE","0","JE OPERADORES SAC","Factura","F102-00110148","Diesel B5","",23.148,"Galones",254.24]
[null,"2021-07-30T19:12:19","2021-07-13","B8T720","MUÑOZ LOPEZ LUIS ALFREDO","0","GRIFO SERVITOR SA","Factura","F112-00109348","Diesel B5","",145.09100000000001,"Galones",1624.28]
[null,"2021-07-30T19:12:19","2021-07-14","B1Q809","RUDECINDO ROSALES ALEJANDRO","0","GRIFOS ESPINOZA S.A.","Factura","F109-00117205","Diesel B5","",159.203,"Galones",1927.97]
[null,"2021-07-30T19:12:19","2021-07-16","B8W786","TAIPE SILVERA ROLANDO JAIME","0","ESTACION DE SERVICIOS PASO DE LOS ANDES","Factura","F213-00051929","Diesel B5","",35.74,"Galones",423.73]
[null,"2021-07-30T19:12:20","2021-07-13","ABR841","AVILA PERALTA LUIS ANGEL","0","ESTACION PETROGAS CAMPOY S.A.C","Factura","F420-618","Diesel B5","",117.11499999999999,"Galones",1371.64]
[null,"2021-07-30T19:12:20","2021-07-07","P2M891"," BARRIENTOS GARAY GERMAN","0","ESTACION PETROGAS CAMPOY S.A.C","Factura","F420-623","Diesel B5","",56.195999999999998,"Galones",618.64]
[null,"2021-07-30T19:12:20","2021-07-13","P2M891"," BARRIENTOS GARAY GERMAN","0","ESTACION PETROGAS CAMPOY S.A.C","Factura","F420-623","Diesel B5","",49.421999999999997,"Galones",578.82000000000005]
[null,"2021-07-30T19:12:20","2021-07-07","B8W786","TAIPE SILVERA ROLANDO JAIME","0","ESTACION PETROGAS CAMPOY S.A.C","Factura","F420-620","Diesel B5","",99.894999999999996,"Galones",1099.69]
[null,"2021-07-30T19:12:20","2021-07-11","B8W786","TAIPE SILVERA ROLANDO JAIME","0","ESTACION PETROGAS CAMPOY S.A.C","Factura","F420-620","Diesel B5","",84.79,"Galones",993.05]
[null,"2021-07-30T19:12:21","2021-07-10","B1Q809","RUDECINDO ROSALES ALEJANDRO","0","ESTACION PETROGAS CAMPOY S.A.C","Factura","F420-619","Diesel B5","",147.251,"Galones",1724.58]
[null,"2021-07-30T19:12:21","2021-07-23","B1Q809","RUDECINDO ROSALES ALEJANDRO","0","GRIFO ESPINOZA S.A","Factura","F109-00117643","Diesel B5","",166,"Galones",2010.29]
[null,"2021-07-30T19:12:21","2021-07-19","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","0","EMPRESA GRUPO QUINTO S.A","Factura","F101-0016716","Diesel B5","",13.1815,"Galones",139.83000000000001]
[null,"2021-07-30T19:12:22","2021-07-16","C1K756"," ZORRILLA REDUCIENDO SANTIAGO FLORENCIO ","0","COETI S.A","Factura","F69P-00002020","Diesel B5","",35.74,"Galones",423.73]

{"sheet":"Indicadores","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hoja2","index":9,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Etiquetas de fila","Suma de Gasto total (Incl. IGV)"]
[null,"Diesel B5",33986.28]
[null,"Total general",33986.28,null,null,null,null,null,null,"Diesel B5",{"$f":"GETPIVOTDATA(\"[Measures].[Suma de Gasto total (Incl. IGV)]\",$B$3,\"[TablaCombustible].[Tipo de combustible]\",\"[TablaCombustible].[Tipo de combustible].&[Diesel B5]\")","v":33986.28}]
[null,null,null,null,null,null,null,null,null,"Urea",{"$f":"IFERROR(VLOOKUP(J6,B4:C5,2,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(K5:K6)","v":33986.28}]
[]
[]
[]
[]
[]
[null,"Tipo de combustible","Medida","Suma de Volumen de combustible abastecido"]
[null,"Diesel B5","Galones",2986.1859399999998]
[null,"Total general",null,2986.1859399999998]
[]
[]
[]
[]
[null,"Placa de vehículo","Suma de Volumen de combustible abastecido"]
[null,"ABR841",612.46400000000006]
[null,"B1Q809",667.41944000000001]
[null,"B8T720",390.41]
[null,"B8W786",418.185]
[null,"C1K756",521.17849999999999]
[null,"F1O746",168.72499999999999]
[null,"P2M891",207.804]
[null,"Total general",2986.1859399999998]
[]
[null,null,null,null,null,null,null,null,null,null,"Recorrido","Volúmen de combustible abastecido","Gasto","Km/gl","Soles/km"]
[null,null,null,null,null,null,null,null,null,"ABR841",{"$f":"IFERROR(VLOOKUP(J31,$B$54:$C$60,2,0),0)","v":3646.2},{"$f":"IFERROR(VLOOKUP(J31,$B$21:$C$27,2,0),0)","v":612.46400000000006},{"$f":"IFERROR(VLOOKUP(J31,$B$37:$C$43,2,0),0)*1.18","v":7936.904199999999},{"$f":"ROUND(K31/L31,2)","v":5.95},{"$f":"M31/K31","v":2.1767605177993525},null,{"$f":"+M31/L31","v":12.958972609002322}]
[null,null,null,null,null,null,null,null,null,"B1Q809",2249.3000000000002,{"$f":"IFERROR(VLOOKUP(J32,$B$21:$C$27,2,0),0)","v":667.41944000000001},{"$f":"IFERROR(VLOOKUP(J32,$B$37:$C$43,2,0),0)*1.18","v":9295.4263999999985},{"$f":"ROUND(K32/L32,2)","v":3.37},{"$f":"M32/K32","v":4.1325863157426745},null,{"$f":"+M32/L32","v":13.927413321973358}]
[null,null,null,null,null,null,null,null,null,"B8T720",2059.1,390.41,5212.3786,5.27,2.5313868194842408,null,13.35103762710996]
[null,null,null,null,null,null,null,null,null,"B8W786",3020.6,418.185,5591.7367999999997,7.22,1.8512006886049128,null,13.371442782500568]
[null,null,null,null,null,null,null,null,null,"C1K756",2354.9,521.17849999999999,{"$f":"IFERROR(VLOOKUP(J35,$B$37:$C$43,2,0),0)*1.18","v":7094.3606},4.5199999999999996,3.0125952694381928,null,13.612151307085769]
[null,"Placa de vehículo","Suma de Gasto total (Incl. IGV)",null,null,null,null,null,null,"F1O746",{"$f":"IFERROR(VLOOKUP(J36,$B$54:$C$60,2,0),0)","v":711.9},168.72499999999999,2205.0070000000001,4.22,3.0973549655850543,null,13.068644243591644]
[null,"ABR841",6726.19,null,null,null,null,null,null,"P2M891",{"$f":"IFERROR(VLOOKUP(J37,$B$54:$C$60,2,0),0)","v":819.2},207.804,2767.9967999999999,3.94,{"$f":"M37/K37","v":3.3789023437499996},null,13.320228677022579]
[null,"B1Q809",7877.48,null,null,null,null,null,null,"Total",{"$f":"SUM(K31:K37)","v":14861.2},{"$f":"SUM(L31:L37)","v":2986.1859400000003},{"$f":"SUM(M31:M37)","v":40103.810399999995},4.9800000000000004,2.6985580168492445]
[null,"B8T720",4417.2700000000004]
[null,"B8W786",4738.76]
[null,"C1K756",6012.17,null,null,null,null,null,null,null,null,null,null,null,null,"Soles/Ton"]
[null,"F1O746",1868.65,null,null,null,null,null,null,null,null,null,"Km/gl","Soles/km","Soles/gl"]
[null,"P2M891",2345.7600000000002,null,null,null,null,null,null,null,null,"Izquierda",{"$f":"N38","v":4.9800000000000004},{"$f":"O38","v":2.6985580168492445},{"$f":"M38/L38","v":13.429776713770204}]
[null,"Total general",33986.28,null,null,null,null,null,null,null,null,"Puntero",0.3,0.1,0.3]
[null,null,null,null,null,null,null,null,null,null,null,"Derecha",{"$f":"$M$51-M43-M44","v":24.72},{"$f":"$N$51-N43-N44","v":7.2014419831507563},{"$f":"$M$51-O43-O44","v":16.270223286229797}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Segmento 1",5,{"$f":"5/3","v":1.6666666666666667}]
[null,null,null,null,null,null,null,null,null,null,null,"Segmento 2",5,{"$f":"+N47","v":1.6666666666666667}]
[null,null,null,null,null,null,null,null,null,null,null,"Segmento 3",5,{"$f":"+N48","v":1.6666666666666667}]
[null,null,null,null,null,null,null,null,null,null,null,"Segmento 4",15,{"$f":"SUM(N47:N49)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M50+M49+M48+M47","v":30},{"$f":"+N50+N49+N48+N47","v":10}]
[]
[null,"Placa de vehículo","Suma de Recorrido"]
[null,"ABR841",3646.2]
[null,"B1Q809",2249.3000000000002]
[null,"B8T720",2059.1]
[null,"B8W786",3020.6]
[null,"C1K756",2354.9]
[null,"F1O746",711.9]
[null,"P2M891",819.2]
[null,"Total general",14861.2]