{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["MENU PRINCIPAL","COSTOS FIJOS","COSTOS VARIABLES","CALCULOS DE COSTOS","CALCULOS DE COSTOS vehiculo","DATOS REFERENCIA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":"MENU PRINCIPAL","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,6,9,7],[10,6,10,7],[0,0,0,14],[2,0,2,14],[7,6,7,7],[8,6,8,7],[5,6,5,7],[6,6,6,7]]}
["INVERSIONES Y REPRESENTACIONES SALNEY LTDA."]
[]
["M  A  N  E  J  O   Y   C  O  N  T  R  O  L   D  E   C  O  S  T  O  S"]
[]
[]
[null,null,null,null,null,null,"<<MENU DE OPCIONES>>"]
[]
[null,null,null,null,null,null,"COSTOS FIJOS"]
[null,null,null,null,null,null,"COSTOS VARIABLES"]
[null,null,null,null,null,null,"CALCULOS DE COSTOS"]
[null,null,null,null,null,null,"DATOS DE REFERENCIA"]

{"sheet":"COSTOS FIJOS","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,1,13,3],[5,1,5,10],[12,1,12,3],[8,1,8,3],[10,1,10,3],[11,1,11,3],[8,4,8,5],[9,4,9,5],[10,4,10,5],[13,4,13,5],[12,7,12,8],[13,7,13,8],[11,7,11,8],[7,4,7,10],[11,4,11,5],[12,4,12,5],[0,0,0,1],[0,9,0,10],[8,7,8,8],[9,7,9,8],[10,7,10,8],[0,6,0,7],[0,3,0,4]]}
["MENU PRINCIPAL",null,null,"COSTOS VARIABLES",null,null,"CALCULO DE COSTOS",null,null,"DATOS DE REFERENCIA"]
[]
[]
[]
[]
[null,"COSTOS FIJOS"]
[]
[null,null,null,null,"VEHICULOS"]
[null,"DESCRIPCION",null,null,"SPH-289",null,"STL-357","SXZ-985",null,"UYU-809","UZC-663"]
[null,"SEGUROS",null,null,422100,null,422100,422100,null,422100,422100]
[null,"SALARIOS PRESTACIONES BASICAS",null,null,600000,null,600000,600000,null,600000,600000]
[null,"PARQUEADERO",null,null,140000,null,140000,140000,null,140000,140000]
[null,"IMPUESTOS",null,null,140000,null,140000,140000,null,140000,140000]
[null,"SERVICIO SATELITAL",null,null,86594,null,86594,86594,null,86594,86594]

{"sheet":"COSTOS VARIABLES","index":2,"n_rows":66,"n_cols":29,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,24,0,25],[0,27,0,28],[0,5,0,7],[0,9,0,10],[0,0,0,1],[0,18,0,19],[0,21,0,22]]}
["MENU PRINCIPAL",null,null,"COSTOS FIJOS",null,"CALCULO DE COSTOS",null,null,null,"DATOS DE REFERENCIA",null,null,null,null,null,null,null,null,null,null,null,"COSTOS VARIABLES",null,null,"CALCULO DE COSTOS"]
[]
["KILOMETROS RECORRIDOS",null,8187.6,null,null,null,"KILOMETROS RECORRIDOS",null,7379,null,null,null,"KILOMETROS RECORRIDOS",null,7991,null,null,null,"KILOMETROS RECORRIDOS",null,7284,null,null,null,"KILOMETROS RECORRIDOS",null,7898]
["No. DE HORAS",null,372.48,null,null,null,"No. DE HORAS",null,362,null,null,null,"No. DE HORAS",null,363,null,null,null,"No. DE HORAS",null,393,null,null,null,"No. DE HORAS",null,383]
["No. VIAJES LOCAL",null,31,null,null,null,"No. VIAJES LOCAL",null,28,null,null,null,"No. VIAJES LOCAL",null,23,null,null,null,"No. VIAJES LOCAL",null,10,null,null,null,"No. VIAJES LOCAL",null,3]
["No. VIAJES CARTAGENA",null,24,null,null,null,"No. VIAJES CARTAGENA",null,21,null,null,null,"No. VIAJES CARTAGENA",null,22,null,null,null,"No. VIAJES CARTAGENA",null,19,null,null,null,"No. VIAJES CARTAGENA",null,23]
["No. SANTA MARTA",null,0,null,null,null,"No. SANTA MARTA",null,0,null,null,null,"No. SANTA MARTA",null,1,null,null,null,"No. SANTA MARTA",null,6,null,null,null,"No. SANTA MARTA",null,0]
["No.  DE VIAJES",null,{"$f":"SUM(C5:C7)","v":55},null,null,null,"No.  DE VIAJES",null,{"$f":"SUM(I5:I7)","v":49},null,null,null,"No.  DE VIAJES",null,{"$f":"SUM(O5:O7)","v":46},null,null,null,"No.  DE VIAJES",null,{"$f":"SUM(U5:U7)","v":35},null,null,null,"No.  DE VIAJES",null,{"$f":"SUM(AA5:AA7)","v":26}]
["FACTURACION MES",null,10731761,null,null,null,"FACTURACION MES",null,null,null,null,null,"FACTURACION MES",null,null,null,null,null,"FACTURACION MES",null,null,null,null,null,"FACTURACION MES"]
[]
["VEHICULO",null,"SPH-289",null,null,null,"VEHICULO",null,"STL-357",null,null,null,"VEHICULOS",null,"SXZ-985",null,null,null,"VEHICULOS",null,"SPH-289",null,null,null,"VEHICULOS",null,"SPH-289"]
[]
["MES","DIA","COSTO","DESCRIPCION","VALOR",null,"MES","DIA","COSTO","DESCRIPCION","VALOR",null,"MES","DIA","COSTO","DESCRIPCION","VALOR",null,"MES","DIA","COSTO","DESCRIPCION","VALOR",null,"MES","DIA","COSTO","DESCRIPCION","VALOR"]
["ENERO",2,"CARTAGENA PEAJE",null,20000,null,"ENERO",1,"DOMINGO",null,0,null,"ENERO","1.","DOMINGO",null,"0-",null,"ENERO",1,"DOMINGO",null,0,null,"ENERO",1,"DOMINGO",null,35000]
["ENERO",3,"CARTAGENA PEAJE",null,20000,null,"ENERO",2,"CARTAGENA PEAJE",null,24800,null,"ENERO",2,"CARTAGENA PEAJE",null,24800,null,"ENERO",2,"CARTAGENA PEAJE",null,36400,null,"ENERO",2,"CARTAGENA PEAJE",null,36400]
["ENERO",4,"CARTAGENA PEAJE",null,24800,null,"ENERO",3,"CARTAGENA PEAJE",null,24800,null,"ENERO",3,"CARTAGENA PEAJE",null,24800,null,"ENERO",3,"SANTA MARTA PEAJE",null,51200,null,"ENERO",3,"CARTAGENA PEAJE",null,36400]
["ENERO",5,"CARTAGENA PEAJE",null,24800,null,"ENERO",3,"MANTENIMIENTO","COMPRA DE CORREA",23001,null,"ENERO",4,"CARTAGENA PEAJE",null,24800,null,"ENERO",4,"CARTAGENA PEAJE",null,36400,null,"ENERO",4,"CARTAGENA PEAJE",null,36400]
["ENERO",6,"CARTAGENA PEAJE",null,24800,null,"ENERO",4,"CARTAGENA PEAJE",null,36400,null,"ENERO",5,"CARTAGENA PEAJE",null,24800,null,"ENERO",5,"SANTA MARTA PEAJE",null,51200,null,"ENERO",4,"CAMBIO ACEITE",null,148000]
["ENERO",6,"CAMBIO ACEITE",null,130300,null,"ENERO",5,"CAMBIO ACEITE",null,131500,null,"ENERO",6,"CARTAGENA PEAJE",null,24800,null,"ENERO",6,"CARTAGENA PEAJE",null,36400,null,"ENERO",5,"CARTAGENA PEAJE",null,36400]
["ENERO",7,"CARTAGENA PEAJE",null,24800,null,"ENERO",5,"LOCAL",null,0,null,"ENERO",7,"SANTA MARTA PEAJE",null,52800,null,"ENERO",7,"CARTAGENA PEAJE",null,37400,null,"ENERO",6,"CARTAGENA PEAJE",null,36400]
["ENERO",8,"LAVADO Y PARQUEO",null,35000,null,"ENERO",6,"CARTAGENA PEAJE",null,24800,null,"ENERO",8,"LAVADO Y PARQUEO",null,35000,null,"ENERO",8,"LAVADO Y PARQUEO",null,35000,null,"ENERO",7,"CARTAGENA PEAJE",null,36400]
["ENERO",8,"CARTAGENA PEAJE",null,24800,null,"ENERO",7,"CARTAGENA PEAJE",null,13200,null,"ENERO",8,"CARTAGENA PEAJE",null,24800,null,"ENERO",9,"FESTIVO",null,0,null,"ENERO",8,"LAVADO Y PARQUEO",null,35000]
["ENERO",9,"LOCAL",null,0,null,"ENERO",8,"LAVADO Y PARQUEO",null,35000,null,"ENERO",9,"LOCAL",null,0,null,"ENERO",10,"SEGURIDAD SOCIAL",null,198200,null,"ENERO",8,"MANTENIMIENTO","ARREGLO LATONERIA",100000]
["ENERO",10,"CARTAGENA PEAJE",null,24800,null,"ENERO",8,"SALARIO","DOTACION SR. PACHECO",40000,null,"ENERO",10,"SEGURIDAD SOCIAL",null,176600,null,"ENERO",10,"CARTAGENA PEAJE",null,36400,null,"ENERO",9,"FESTIVO",null,0]
["ENERO",11,"CARTAGENA PEAJE",null,24800,null,"ENERO",9,"LOCAL",null,0,null,"ENERO",10,"CARTAGENA PEAJE",null,24800,null,"ENERO",11,"CARTAGENA PEAJE",null,36400,null,"ENERO",9,"MANTENIMIENTO","COMPRA ELECTRICO",5700]
["ENERO",11,"MANTENIMIENTO","COMPRA ROPAIN",29000,null,"ENERO",10,"SEGURIDAD SOCIAL",null,90700,null,"ENERO",11,"CARTAGENA PEAJE",null,13200,null,"ENERO",12,"CARTAGENA PEAJE",null,36400,null,"ENERO",10,"CARTAGENA PEAJE",null,36400]
["ENERO",12,"LOCAL",null,0,null,"ENERO",10,"CARTAGENA PEAJE",null,24800,null,"ENERO",12,"CARTAGENA PEAJE",null,24800,null,"ENERO",13,"PAGO SATELITAL",null,90831,null,"ENERO",11,"CARTAGENA PEAJE",null,36400]
["ENERO",12,"OTROS","COMPRA ESTIBAS",135000,null,"ENERO",11,"CARTAGENA PEAJE",null,24800,null,"ENERO",13,"PAGO SATELITAL",null,90831,null,"ENERO",13,"CAMBIO ACEITE",null,163600,null,"ENERO",12,"CARTAGENA PEAJE",null,36400]
["ENERO",13,"PAGO SATELITAL",null,90831,null,"ENERO",12,"CARTAGENA PEAJE",null,24800,null,"ENERO",13,"CAMBIO ACEITE",null,172800,null,"ENERO",13,"CARTAGENA PEAJE",null,36400,null,"ENERO",13,"PAGO SATELITAL",null,90831]
["ENERO",13,"SEGURIDAD SOCIAL",null,176600,null,"ENERO",13,"OTROS","RECIBO DE CAJA MENOR",3200,null,"ENERO",13,"LOCAL",null,0,null,"ENERO",14,"CARTAGENA PEAJE",null,36400,null,"ENERO",13,"CARTAGENA PEAJE",null,36400]
["ENERO",13,"CARTAGENA PEAJE",null,24800,null,"ENERO",13,"PAGO SATELITAL",null,90831,null,"ENERO",14,"CARTAGENA PEAJE",null,24800,null,"ENERO",15,"LAVADO Y PARQUEO",null,35000,null,"ENERO",14,"CARTAGENA PEAJE",null,36400]
["ENERO",14,"CARTAGENA PEAJE",null,24800,null,"ENERO",13,"CARTAGENA PEAJE",null,31600,null,"ENERO",15,"LAVADO Y PARQUEO",null,35000,null,"ENERO",15,"SALARIO",null,300000,null,"ENERO",15,"LAVADO Y PARQUEO",null,35000]
["ENERO",15,"SALARIO",null,300000,null,"ENERO",14,"LAVADO Y PARQUEO",null,35000,null,"ENERO",15,"SALARIO",null,300000,null,"ENERO",15,"COMISION TRABAJADOR",null,495000,null,"ENERO",15,"SALARIO",null,300000]
["ENERO",15,"COMISION TRABAJADOR",null,514000,null,"ENERO",15,"SALARIO",null,300000,null,"ENERO",15,"COMISION TRABAJADOR",null,476000,null,"ENERO",16,"CARTAGENA PEAJE",null,37300,null,"ENERO",15,"COMISION TRABAJADOR",null,455000]
["ENERO",15,"LAVADO Y PARQUEO",null,35000,null,"ENERO",15,"COMISION TRABAJADOR",null,414000,null,"ENERO",16,"LOCAL",null,0,null,"ENERO",17,"CARTAGENA PEAJE",null,37600,null,"ENERO",16,"CARTAGENA PEAJE",null,37300]
["ENERO",15,"MANTENIMIENTO","COMPRA REP. FRENOS",64000,null,"ENERO",16,"CARTAGENA PEAJE",null,25600,null,"ENERO",16,"FILTRO","FILTRO VEHICOSTA",146209,null,"ENERO",18,"CARTAGENA PEAJE",null,37600,null,"ENERO",17,"CARTAGENA PEAJE",null,37600]
["ENERO",15,"MANTENIMIENTO","MANO DE OBRA REP. FRENOS",50000,null,"ENERO",17,"CARTAGENA PEAJE",null,20600,null,"ENERO",17,"CARTAGENA PEAJE",null,25600,null,"ENERO",19,"LOCAL",null,0,null,"ENERO",18,"CARTAGENA PEAJE",null,37600]
["ENERO",16,"CARTAGENA PEAJE",null,25600,null,"ENERO",18,"CARTAGENA PEAJE",null,25600,null,"ENERO",18,"CARTAGENA PEAJE",null,25600,null,"ENERO",20,"CARTAGENA PEAJE",null,37600,null,"ENERO",19,"MANTENIMIENTO","COMPRA DE PORTA ESCOBILLAS",7800]
["ENERO",17,"CARTAGENA PEAJE",null,25600,null,"ENERO",20,"CARTAGENA PEAJE",null,25600,null,"ENERO",19,"CARTAGENA PEAJE",null,25600,null,"ENERO",20,"MANTENIMIENTO","COMPRA REPARACION VEHICULO",105000,null,"ENERO",19,"CARTAGENA PEAJE",null,37600]
["ENERO",18,"CARTAGENA PEAJE",null,25600,null,"ENERO",21,"CARTAGENA PEAJE",null,25600,null,"ENERO",20,"CARTAGENA PEAJE",null,25600,null,"ENERO",20,"MANTENIMIENTO","MANO DE OBRA REP. VEHICULO",50000,null,"ENERO",20,"CARTAGENA PEAJE",null,37600]
["ENERO",19,"CARTAGENA PEAJE",null,25600,null,"ENERO",22,"LAVADO Y PARQUEO",null,35000,null,"ENERO",21,"CARTAGENA PEAJE",null,25600,null,"ENERO",20,"MANTENIMIENTO","COMPRA DE REPUESTOS",55000,null,"ENERO",21,"MANTENIMIENTO","COMPRA DE BALINERAS",20000]
["ENERO",20,"LOCAL",null,0,null,"ENERO",23,"CARTAGENA PEAJE",null,20600,null,"ENERO",22,"LAVADO Y PARQUEO",null,35000,null,"ENERO",21,"CARTAGENA PEAJE",null,43400,null,"ENERO",21,"MANTENIMIENTO","MANO DE OBRA REPARACION VEHICULO",80000]
["ENERO",21,"CARTAGENA PEAJE",null,25600,null,"ENERO",24,"CARTAGENA PEAJE",null,25600,null,"ENERO",23,"CARTAGENA PEAJE",null,25600,null,"ENERO",22,"LAVADO Y PARQUEO",null,35000,null,"ENERO",21,"MANTENIMIENTO","MANO DE OBRA REPARACION VEHICULO",30000]
["ENERO",22,"LAVADO Y PARQUEO",null,35000,null,"ENERO",24,"LLANTAS","COMPRA NEUMATICO + PROTECTOR",94000,null,"ENERO",24,"LOCAL",null,0,null,"ENERO",23,"CARTAGENA PEAJE",null,37600,null,"ENERO",21,"NO LABORO",null,0]
["ENERO",23,"CARTAGENA PEAJE",null,25600,null,"ENERO",25,"CARTAGENA PEAJE",null,13600,null,"ENERO",25,"CARTAGENA PEAJE",null,25600,null,"ENERO",24,"SANTA MARTA PEAJE",null,52800,null,"ENERO",22,"LAVADO Y PARQUEO",null,35000]
["ENERO",24,"CARTAGENA PEAJE",null,25600,null,"ENERO",26,"LOCAL",null,0,null,"ENERO",26,"CARTAGENA PEAJE",null,25600,null,"ENERO",25,"CARTAGENA PEAJE",null,37600,null,"ENERO",23,"NO LABORO",null,0]
["ENERO",24,"LLANTAS","NEUMATICO + PROTECTOR",449000,null,"ENERO",27,"CARTAGENA PEAJE",null,25600,null,"ENERO",27,"CARTAGENA PEAJE",null,20600,null,"ENERO",26,"SANTA MARTA PEAJE",null,52800,null,"ENERO",24,"CARTAGENA PEAJE",null,37600]
["ENERO",24,"LLANTAS","COMPRA DE LLANTAS",403500,null,"ENERO",28,"CARTAGENA PEAJE",null,13600,null,"ENERO",28,"CARTAGENA PEAJE",null,25600,null,"ENERO",27,"CARTAGENA PEAJE",null,37600,null,"ENERO",25,"CARTAGENA PEAJE",null,37600]
["ENERO",25,"CARTAGENA PEAJE",null,20600,null,"ENERO",29,"LAVADO Y PARQUEO",null,35000,null,"ENERO",29,"LAVADO Y PARQUEO",null,35000,null,"ENERO",28,"SANTA MARTA PEAJE",null,52800,null,"ENERO",26,"CARTAGENA PEAJE",null,37600]
["ENERO",26,"CARTAGENA PEAJE",null,25600,null,"ENERO",30,"CARTAGENA PEAJE",null,25600,null,"ENERO",30,"CARTAGENA PEAJE",null,25600,null,"ENERO",29,"LAVADO Y PARQUEO",null,35000,null,"ENERO",27,"CARTAGENA PEAJE",null,37600]
["ENERO",27,"LOCAL",null,0,null,"ENERO",31,"CARTAGENA PEAJE",null,25600,null,"ENERO",31,"CARTAGENA PEAJE",null,25600,null,"ENERO",30,"CARTAGENA PEAJE",null,43700,null,"ENERO",27,"SALARIO","DESCARGUE DANONY",15000]
["ENERO",27,"CAMBIO ACEITE",null,158300,null,"ENERO",31,"COMISION TRABAJADOR",null,532000,null,"ENERO",31,"COMISION TRABAJADOR",null,520000,null,"ENERO",31,"SANTA MARTA PEAJE",null,52800,null,"ENERO",27,"MANTENIMIENTO","COMPRA DE CHUPAS",20000]
["ENERO",28,"CARTAGENA PEAJE",null,25600,null,"ENERO",31,"SALARIO",null,300000,null,"ENERO",31,"SALARIO",null,300000,null,"ENERO",31,"SALARIO",null,300000,null,"ENERO",27,"CAMBIO ACEITE",null,146900]
["ENERO",29,"LAVADO Y PARQUEO",null,35000,null,"ENERO",31,"COMISION NEIDA SALGADO",null,250000,null,"ENERO",31,"ACPM",null,3009903,null,"ENERO",31,"COMISION TRABAJADOR",null,587000,null,"ENERO",27,"MANTENIMIENTO","COMPRA DE FRENOS Y FRENOS",15320]
["ENERO",30,"CARTAGENA PEAJE",null,25600,null,"ENERO",31,"SERVICIOS PRESTADOS HEIDY BARRIOS",null,40000,null,"ENERO",31,"SERVICIOS PRESTADOS HEIDY BARRIOS",null,40000,null,"ENERO",31,"ACPM",null,2971558,null,"ENERO",27,"SEGURIDAD SOCIAL",null,100000]
["ENERO",31,"CARTAGENA PEAJE",null,25600,null,"ENERO",31,"ACPM",null,2616431,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",28,"CARTAGENA PEAJE",null,37600]
["ENERO",31,"SALARIO",null,300000,null,null,null,null,null,{"$f":"SUM(K14:K56)","v":5568863},null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",29,"LAVADO Y PARQUEO",null,35000]
["ENERO",31,"COMISION TRABAJADOR",null,554000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",29,"MANTENIMIENTO","COMPRA DE REPUESTOS",185000]
["ENERO",31,"SERVICIOS PRESTADOS HEIDY BARRIOS",null,40000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",29,"MANTENIMIENTO","MANO DE OBRA CAMBIO DE REPUESTOS",75000]
["ENERO",31,"COMISION NEIDA SALGADO",null,250000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",30,"CARTAGENA PEAJE",null,37600]
["ENERO",31,"ACPM",null,2765487,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",31,"CARTAGENA PEAJE",null,37600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",31,"SALARIO",null,300000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",31,"COMISION TRABAJADOR",null,490000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",31,"COMISION NEIDA SALGADO",null,250000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",31,"SERVICIOS PRESTADOS HEIDY BARRIOS",null,40000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERO",31,"ACPM",null,2863107]

{"sheet":"CALCULOS DE COSTOS","index":3,"n_rows":38,"n_cols":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,17,0,18],[0,20,0,21],[0,23,0,24],[0,26,0,27],[0,4,0,5]]}
["MENU PRINCIPAL",null,"COSTOS FIJOS",null,"COSTOS VARIABLES",null,null,"DATOS DE REFERENCIA",null,null,null,null,null,null,null,null,null,null,null,null,"COSTOS VARIABLES",null,null,"CALCULO DE COSTOS"]
[]
[]
[null,"SPH-289","STL-357","SXZ-985","UYU-809","UZC-663"]
["COMBUSTIBLE",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"ACPM\",'COSTOS VARIABLES'!E:E)","v":2765487},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"ACPM\",'COSTOS VARIABLES'!K:K)","v":2616431},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"ACPM\",'COSTOS VARIABLES'!Q:Q)","v":3009903},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"ACPM\",'COSTOS VARIABLES'!W:W)","v":2971558},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"ACPM\",'COSTOS VARIABLES'!AC:AC)","v":2863107}]
["COMISIONES",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!E:E)","v":1068000},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!K:K)","v":946000},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!Q:Q)","v":996000},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!W:W)","v":1082000},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!AC:AC)","v":945000}]
["LUBRICANTES",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!E:E)","v":288600},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!K:K)","v":131500},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!Q:Q)","v":172800},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!W:W)","v":163600},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!AC:AC)","v":294900}]
["LLANTAS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"LLANTAS\",'COSTOS VARIABLES'!E:E)","v":852500},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"LLANTAS\",'COSTOS VARIABLES'!K:K)","v":94000},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"LLANTAS\",'COSTOS VARIABLES'!Q:Q)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"LLANTAS\",'COSTOS VARIABLES'!W:W)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"LLANTAS\",'COSTOS VARIABLES'!AC:AC)","v":0}]
["ADMINISTRATIVOS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!E:E)+SUMIF('COSTOS VARIABLES'!C:C,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!E:E)+SUMIF('COSTOS VARIABLES'!C:C,\"OTROS\",'COSTOS VARIABLES'!E:E)+SUMIF('COSTOS VARIABLES'!C:C,\"PAGO SATELITAL\",'COSTOS VARIABLES'!E:E)","v":515831},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"OTROS\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"PAGO SATELITAL\",'COSTOS VARIABLES'!K:K)","v":384031},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"OTROS\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"PAGO SATELITAL\",'COSTOS VARIABLES'!Q:Q)","v":130831},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"OTROS\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"PAGO SATELITAL\",'COSTOS VARIABLES'!W:W)","v":90831},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"OTROS\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"PAGO SATELITAL\",'COSTOS VARIABLES'!AC:AC)","v":380831}]
["FILTROS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"FILTRO\",'COSTOS VARIABLES'!E:E)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"FILTRO\",'COSTOS VARIABLES'!K:K)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"FILTRO\",'COSTOS VARIABLES'!Q:Q)","v":146209},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"FILTRO\",'COSTOS VARIABLES'!W:W)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"FILTRO\",'COSTOS VARIABLES'!AC:AC)","v":0}]
["SEGUROS, PARQUEADERO, IMPUESTOS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"lavado y parqueo\",'COSTOS VARIABLES'!E:E)","v":140000},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"lavado y parqueo\",'COSTOS VARIABLES'!K:K)","v":140000},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"lavado y parqueo\",'COSTOS VARIABLES'!Q:Q)","v":140000},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"lavado y parqueo\",'COSTOS VARIABLES'!W:W)","v":140000},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"lavado y parqueo\",'COSTOS VARIABLES'!AC:AC)","v":140000}]
["SALARIOS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"SALARIO\",'COSTOS VARIABLES'!E:E)+SUMIF('COSTOS VARIABLES'!C:C,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!E:E)","v":776600},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"SALARIO\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!K:K)","v":730700},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"SALARIO\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!Q:Q)","v":776600},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"SALARIO\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!W:W)","v":798200},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"SALARIO\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!AC:AC)","v":715000}]
["MANTENIMIENTO",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"MANTENIMIENTO\",'COSTOS VARIABLES'!E:E)","v":143000},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"MANTENIMIENTO\",'COSTOS VARIABLES'!K:K)","v":23001},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"MANTENIMIENTO\",'COSTOS VARIABLES'!Q:Q)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"MANTENIMIENTO\",'COSTOS VARIABLES'!W:W)","v":210000},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"MANTENIMIENTO\",'COSTOS VARIABLES'!AC:AC)","v":538820}]
["PEAJES",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!E:E)","v":565400},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"SANTA MARTA PEAJE\",'COSTOS VARIABLES'!K:K)","v":503200},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"SANTA MARTA PEAJE\",'COSTOS VARIABLES'!Q:Q)","v":591400},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"SANTA MARTA PEAJE\",'COSTOS VARIABLES'!W:W)","v":992200},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"SANTA MARTA PEAJE\",'COSTOS VARIABLES'!AC:AC)","v":851300}]
[]
[]
[null,"SPH-289","STL-357","SXZ-985","UYU-809","UZC-663","TOTAL"]
["KILOMETROS RECORRIDOS",8187.6,7378.7999999999993,7990.7000000000007,7513.1,7879.7,{"$f":"SUM(B18:F18)","v":38949.899999999994}]
["No. DE HORAS",372.48,361.91,362.91,393.41,382.5,{"$f":"SUM(B19:F19)","v":1873.2100000000003}]
["CANTIDAD DE GALONES CONSUMIDOS",350.96081606546397,332.04450389351962,381.97901966557356,377.1127547031889,363.34951825943938,1805.4466125871854]
["No. VIAJES LOCAL",31,28,23,10,0,{"$f":"SUM(B21:F21)","v":92}]
["No. VIAJES CARTAGENA",24,21,22,18,26,{"$f":"SUM(B22:F22)","v":111}]
["NO. VIAJES SANTA MARTA",0,0,1,6,0,{"$f":"SUM(B23:F23)","v":7}]
["No.  DE VIAJES",{"$f":"SUM(B21:B23)","v":55},{"$f":"SUM(C21:C23)","v":49},46,34,26,{"$f":"SUM(B24:F24)","v":210}]
[]
[]
["ACTIVIDAD","CONDUCTOR","CARTAGENA","LOCAL","SANTA MARTA","RECORRIDOS INTERNOS"]
["1 PLANEAR RUTA DE ENTREGA","No. de Viajes",{"$f":"+(SUM($B$14:$F$14)*($G$22/$G$24))","v":1851850},{"$f":"+(SUM($B$14:$F$14)*(G21/$G$24))","v":1534866.6666666667},{"$f":"+(SUM($B$14:$F$14)*(G23/$G$24))","v":116783.33333333333}]
["2 CARGAR CAMION","No. de Viajes",{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*(G22/G24)","v":594259.64285714284},{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*G21/$G$24","v":492539.52380952379},{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*G23/$G$24","v":37475.833333333336}]
["3 VERIFICAR CARGA","No. de Viajes",{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*(G22/G24)","v":99043.273809523802},{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*(G21/G24)","v":82089.920634920636},{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*(G23/G24)","v":6245.9722222222217}]
["4 TRANSPORTAR CARGA","Galones Consumidos",{"$f":"+(SUM($B$7:$F$7)*('DATOS REFERENCIA'!$G$13/'CALCULOS DE COSTOS'!$G$18))+(SUM($B$8:$F$8)*('DATOS REFERENCIA'!$G$13/'CALCULOS DE COSTOS'!$G$18))+(SUM($B$10:$F$10)*'DATOS REFERENCIA'!$G$13/'CALCULOS DE COSTOS'!$G$18)+(SUM($B$13:$F$13)*'DATOS REFERENCIA'!G13/'CALCULOS DE COSTOS'!$G$18)+((('DATOS REFERENCIA'!G13*$G$20)/$G$18)*'DATOS REFERENCIA'!$B$18)+((SUM($B$11:$F$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)*G22/G24)","v":16616237.780377764},{"$f":"+(SUM($B$7:$F$7)*('DATOS REFERENCIA'!G14/'CALCULOS DE COSTOS'!$G$18))+(SUM($B$8:$F$8)*('DATOS REFERENCIA'!G14/'CALCULOS DE COSTOS'!$G$18))+(SUM($B$10:$F$10)*'DATOS REFERENCIA'!G14/'CALCULOS DE COSTOS'!$G$18)+(SUM($B$13:$F$13)*'DATOS REFERENCIA'!G14/'CALCULOS DE COSTOS'!$G$18)+((('DATOS REFERENCIA'!G14*$G$20)/$G$18)*'DATOS REFERENCIA'!$B$18)+((SUM($B$11:$F$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)*G21/G24)","v":1590378.3194389276},{"$f":"+(SUM($B$7:$F$7)*('DATOS REFERENCIA'!$G$12/'CALCULOS DE COSTOS'!$G$18))+(SUM($B$8:$F$8)*('DATOS REFERENCIA'!$G$12/'CALCULOS DE COSTOS'!$G$18))+(SUM($B$10:$F$10)*'DATOS REFERENCIA'!$G$12/'CALCULOS DE COSTOS'!$G$18)+(SUM($B$13:$F$13)*'DATOS REFERENCIA'!G12/'CALCULOS DE COSTOS'!$G$18)+((('DATOS REFERENCIA'!I13*$G$20)/$G$18)*'DATOS REFERENCIA'!$B$18)+((SUM($B$11:$F$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)*G23/G24)","v":481628.3543796005},{"$f":"+(SUM($B$7:$F$7)*('DATOS REFERENCIA'!$G$15/'CALCULOS DE COSTOS'!$G$18))+(SUM($B$8:$F$8)*('DATOS REFERENCIA'!$G$15/'CALCULOS DE COSTOS'!$G$18))+(SUM($B$10:$F$10)*'DATOS REFERENCIA'!$G$15/'CALCULOS DE COSTOS'!$G$18)+(SUM($B$13:$F$13)*'DATOS REFERENCIA'!G15/'CALCULOS DE COSTOS'!$G$18)+((('DATOS REFERENCIA'!G15*$G$20)/$G$18)*'DATOS REFERENCIA'!$B$18)","v":416093.64957548032}]
["5 DESCARGAR CARGA","No. de Viajes",{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*('CALCULOS DE COSTOS'!G22/'CALCULOS DE COSTOS'!G24)","v":594259.64285714284},{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*G21/$G$24","v":492539.52380952379},{"$f":"+(SUM($B$11:$F$11)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*G23/$G$24","v":37475.833333333336}]
["6 ENTREGAR REMISIONES","No. de Viajes",{"$f":"(+SUM($B$6:$F$6)+SUM($B$9:$F$9)+(SUM($B$11:$F$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*G22/G24","v":3555559.4880952379},{"$f":"(+SUM($B$6:$F$6)+SUM($B$9:$F$9)+(SUM($B$11:$F$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*G21/G24","v":2946950.2063492066},{"$f":"(+SUM($B$6:$F$6)+SUM($B$9:$F$9)+(SUM($B$11:$F$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$12:$F$12)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*G23/G24","v":224224.47222222225}]
[null,null,{"$f":"SUM(C28:C33)","v":23311209.827996813},{"$f":"SUM(D28:D33)","v":7139364.1607087692},{"$f":"SUM(E28:E33)","v":903833.79882404499}]
[]
["COSTO VIAJE LOCAL",{"$f":"+D34/G21","v":77601.784355530093}]
["COSTO VIAJE CARTAGENA",{"$f":"+C34/G22","v":210010.89935132265}]
["COSTO VIAJE SANTA MARTA",{"$f":"+E34/G23","v":129119.11411772072}]

{"sheet":"CALCULOS DE COSTOS vehiculo","index":4,"n_rows":100,"n_cols":24,"rows_kept":100,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,2,72,5],[86,0,86,1],[86,2,87,5],[25,0,25,1],[25,2,25,5],[40,0,40,1],[40,2,41,5],[55,0,55,1],[55,2,56,5],[0,4,0,5],[0,17,0,18],[0,20,0,21],[0,23,0,24],[0,26,0,27]]}
["MENU PRINCIPAL",null,"COSTOS FIJOS",null,"COSTOS VARIABLES",null,null,"DATOS DE REFERENCIA",null,null,null,null,null,null,null,null,null,null,null,null,"COSTOS VARIABLES",null,null,"CALCULO DE COSTOS"]
[]
[null,"SPH-289","STL-357","SXZ-985","UYU-809","UZC-663"]
["COMBUSTIBLE",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"ACPM\",'COSTOS VARIABLES'!E:E)","v":2765487},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"ACPM\",'COSTOS VARIABLES'!K:K)","v":2616431},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"ACPM\",'COSTOS VARIABLES'!Q:Q)","v":3009903},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"ACPM\",'COSTOS VARIABLES'!W:W)","v":2971558},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"ACPM\",'COSTOS VARIABLES'!AC:AC)","v":2863107}]
["COMISIONES",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!E:E)","v":1068000},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!K:K)","v":946000},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!Q:Q)","v":996000},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!W:W)","v":1082000},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"COMISION TRABAJADOR\",'COSTOS VARIABLES'!AC:AC)","v":945000}]
["LUBRICANTES",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!E:E)","v":288600},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!K:K)","v":131500},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!Q:Q)","v":172800},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!W:W)","v":163600},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"CAMBIO ACEITE\",'COSTOS VARIABLES'!AC:AC)","v":294900}]
["LLANTAS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"LLANTAS\",'COSTOS VARIABLES'!E:E)","v":852500},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"LLANTAS\",'COSTOS VARIABLES'!K:K)","v":94000},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"LLANTAS\",'COSTOS VARIABLES'!Q:Q)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"LLANTAS\",'COSTOS VARIABLES'!W:W)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"LLANTAS\",'COSTOS VARIABLES'!AC:AC)","v":0}]
["ADMINISTRATIVOS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!E:E)+SUMIF('COSTOS VARIABLES'!C:C,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!E:E)+SUMIF('COSTOS VARIABLES'!C:C,\"OTROS\",'COSTOS VARIABLES'!E:E)+SUMIF('COSTOS VARIABLES'!C:C,\"PAGO SATELITAL\",'COSTOS VARIABLES'!E:E)","v":515831},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"OTROS\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"PAGO SATELITAL\",'COSTOS VARIABLES'!K:K)","v":384031},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"OTROS\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"PAGO SATELITAL\",'COSTOS VARIABLES'!Q:Q)","v":130831},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"OTROS\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"PAGO SATELITAL\",'COSTOS VARIABLES'!W:W)","v":90831},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"COMISION NEIDA SALGADO\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"SERVICIOS PRESTADOS HEIDY BARRIOS\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"OTROS\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"PAGO SATELITAL\",'COSTOS VARIABLES'!AC:AC)","v":380831}]
["FILTROS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"FILTRO\",'COSTOS VARIABLES'!E:E)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"FILTRO\",'COSTOS VARIABLES'!K:K)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"FILTRO\",'COSTOS VARIABLES'!Q:Q)","v":146209},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"FILTRO\",'COSTOS VARIABLES'!W:W)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"FILTRO\",'COSTOS VARIABLES'!AC:AC)","v":0}]
["SEGUROS, PARQUEADERO, IMPUESTOS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"lavado y parqueo\",'COSTOS VARIABLES'!E:E)","v":140000},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"lavado y parqueo\",'COSTOS VARIABLES'!K:K)","v":140000},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"lavado y parqueo\",'COSTOS VARIABLES'!Q:Q)","v":140000},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"lavado y parqueo\",'COSTOS VARIABLES'!W:W)","v":140000},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"lavado y parqueo\",'COSTOS VARIABLES'!AC:AC)","v":140000}]
["SALARIOS",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"SALARIO\",'COSTOS VARIABLES'!E:E)+SUMIF('COSTOS VARIABLES'!C:C,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!E:E)","v":776600},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"SALARIO\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!K:K)","v":730700},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"SALARIO\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!Q:Q)","v":776600},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"SALARIO\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!W:W)","v":798200},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"SALARIO\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"SEGURIDAD SOCIAL\",'COSTOS VARIABLES'!AC:AC)","v":715000}]
["MANTENIMIENTO",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"MANTENIMIENTO\",'COSTOS VARIABLES'!E:E)","v":143000},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"MANTENIMIENTO\",'COSTOS VARIABLES'!K:K)","v":23001},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"MANTENIMIENTO\",'COSTOS VARIABLES'!Q:Q)","v":0},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"MANTENIMIENTO\",'COSTOS VARIABLES'!W:W)","v":210000},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"MANTENIMIENTO\",'COSTOS VARIABLES'!AC:AC)","v":538820}]
["PEAJES",{"$f":"+SUMIF('COSTOS VARIABLES'!C:C,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!E:E)","v":565400},{"$f":"+SUMIF('COSTOS VARIABLES'!I:I,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!K:K)+SUMIF('COSTOS VARIABLES'!I:I,\"SANTA MARTA PEAJE\",'COSTOS VARIABLES'!K:K)","v":503200},{"$f":"+SUMIF('COSTOS VARIABLES'!O:O,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!Q:Q)+SUMIF('COSTOS VARIABLES'!O:O,\"SANTA MARTA PEAJE\",'COSTOS VARIABLES'!Q:Q)","v":591400},{"$f":"+SUMIF('COSTOS VARIABLES'!U:U,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!W:W)+SUMIF('COSTOS VARIABLES'!U:U,\"SANTA MARTA PEAJE\",'COSTOS VARIABLES'!W:W)","v":992200},{"$f":"+SUMIF('COSTOS VARIABLES'!AA:AA,\"CARTAGENA PEAJE\",'COSTOS VARIABLES'!AC:AC)+SUMIF('COSTOS VARIABLES'!AA:AA,\"SANTA MARTA PEAJE\",'COSTOS VARIABLES'!AC:AC)","v":851300}]
[]
[]
[null,"SPH-289","STL-357","SXZ-985","UYU-809","UZC-663","TOTAL"]
["KILOMETROS RECORRIDOS",8187.6,7378.7999999999993,7990.7000000000007,7513.1,7879.7,{"$f":"SUM(B17:F17)","v":38949.899999999994}]
["No. DE HORAS",372.48,361.91,362.91,393.41,382.5,{"$f":"SUM(B18:F18)","v":1873.2100000000003}]
["CANTIDAD DE GALONES CONSUMIDOS",350.96081606546397,332.04450389351962,381.97901966557356,377.1127547031889,363.34951825943938,1805.4466125871854]
["No. VIAJES LOCAL",31,28,23,10,0,{"$f":"SUM(B20:F20)","v":92}]
["No. VIAJES CARTAGENA",24,21,22,18,26,{"$f":"SUM(B21:F21)","v":111}]
["NO. VIAJES SANTA MARTA",0,0,1,6,0,{"$f":"SUM(B22:F22)","v":7}]
["No.  DE VIAJES",{"$f":"SUM(B20:B22)","v":55},{"$f":"SUM(C20:C22)","v":49},46,34,26,{"$f":"SUM(B23:F23)","v":210}]
[]
[]
["RECURSOS",null,"VEHICULO SPH-289"]
["ACTIVIDAD","CONDUCTOR","CARTAGENA","LOCAL","SANTA MARTA","RECORRIDOS INTERNOS"]
["1 PLANEAR RUTA DE ENTREGA","No. de Viajes",{"$f":"+B13*($B$21/$B$23)","v":246720},{"$f":"+(B13)*(B20/B23)","v":318680},{"$f":"+(B13)*(B22/$B$23)","v":0}]
["2 CARGAR CAMION","No. de Viajes",{"$f":"+(SUM($B$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($B$21/$B$23)","v":99992.727272727265},{"$f":"+(B10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(B11*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)*B20/$B$23","v":144430},{"$f":"+((B10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM(B11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*B22/$B$23","v":0}]
["3 VERIFICAR CARGA","No. de Viajes",{"$f":"+(($B$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+($B$11*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($B$21/$B$23)","v":16665.454545454544},{"$f":"+(SUM($B$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($B$20/$B$23)","v":21526.21212121212},{"$f":"+(SUM($B$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($B$22/$B$23)","v":0}]
["4 TRANSPORTAR CARGA","Galones Consumidos",{"$f":"+(SUM($B$6)*('DATOS REFERENCIA'!$B$13/$B$17))+(SUM($B$7)*('DATOS REFERENCIA'!$B$13/$B$17))+(SUM($B$9)*'DATOS REFERENCIA'!$B$13/$B$17)+(SUM($B$10)*'DATOS REFERENCIA'!$B$13/$B$17)+((('DATOS REFERENCIA'!$B$13*$B$19)/$B$17)*'DATOS REFERENCIA'!$B$18)+((SUM($B$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($B$21/$B$23)","v":3955301.0311035761},{"$f":"+(SUM($B$6)*('DATOS REFERENCIA'!$B$14/$B$17))+(SUM($B$7)*('DATOS REFERENCIA'!$B$14/$B$17))+(SUM($B$9)*'DATOS REFERENCIA'!$B$14/$B$17)+(SUM($B$12)*'DATOS REFERENCIA'!$B$14/$B$17)+((('DATOS REFERENCIA'!$B$14*$B$19)/$B$17)*'DATOS REFERENCIA'!$B$18)+((SUM($B$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($B$20/$B$23)","v":430066.90333386627},{"$f":"+(SUM($B$6)*('DATOS REFERENCIA'!$B$12/$B$19))+(SUM($B$7)*('DATOS REFERENCIA'!$B$12/$B$19))+(SUM($B$9)*'DATOS REFERENCIA'!$B$12/$B$19)+(SUM($B$12)*'DATOS REFERENCIA'!$B$12/$B$19)+((('DATOS REFERENCIA'!$B$12*$B$19)/$B$17)*'DATOS REFERENCIA'!$B$18)+((SUM($B$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($B$22/$B$23)","v":0},{"$f":"+(SUM($B$6)*('DATOS REFERENCIA'!$B$15/'CALCULOS DE COSTOS vehiculo'!$B$17))+(SUM($B$7)*('DATOS REFERENCIA'!$B$15/'CALCULOS DE COSTOS vehiculo'!$B$17))+(SUM($B$9)*'DATOS REFERENCIA'!$B$15/'CALCULOS DE COSTOS vehiculo'!$B$17)+(SUM($B$12)*'DATOS REFERENCIA'!$B$15/'CALCULOS DE COSTOS vehiculo'!$B$17)+((('DATOS REFERENCIA'!$B$15*$B$19)/$B$17)*'DATOS REFERENCIA'!$B$18)","v":43326.960427964244}]
["5 DESCARGAR CARGA","No. de Viajes",{"$f":"+(SUM($B$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*('CALCULOS DE COSTOS vehiculo'!$B$21/'CALCULOS DE COSTOS vehiculo'!$B$23)","v":99992.727272727265},{"$f":"+(SUM($B$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($B$20/$B$23)","v":129157.27272727272},{"$f":"+(SUM($B$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*$B$22/$B$23","v":0}]
["6 ENTREGAR REMISIONES","No. de Viajes",{"$f":"(+SUM($B$5)+SUM($B$8)+(SUM($B$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($B$21/$B$23)","v":707791.70909090899},{"$f":"(+SUM($B$5)+SUM($B$8)+(SUM($B$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($B$20/$B$23)","v":914230.95757575741},{"$f":"(+SUM($B$5)+SUM($B$8)+(SUM($B$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($B$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($B$22/$B$23)","v":0}]
[null,null,{"$f":"SUM(C28:C33)","v":5126463.6492853947},{"$f":"SUM(D28:D33)","v":1958091.3457581084},{"$f":"SUM(E28:E33)","v":0}]
[]
["COSTO VIAJE LOCAL",{"$f":"+$D$34/$B$20","v":63164.236959938979}]
["COSTO VIAJE CARTAGENA",{"$f":"+C34/B21","v":213602.65205355812}]
["COSTO VIAJE SANTA MARTA",{"$f":"+E34/B22","v":{"$error":"#DIV/0!"}}]
[]
[]
["RECURSOS",null,"VEHICULO STL-357"]
[]
["ACTIVIDAD","CONDUCTOR","CARTAGENA","LOCAL","SANTA MARTA","RECORRIDOS INTERNOS"]
["1 PLANEAR RUTA DE ENTREGA","No. de Viajes",{"$f":"+$C$13*($C$21/$C$23)","v":215657.14285714284},{"$f":"+($C$13)*($C$20/$C$23)","v":287542.8571428571},{"$f":"+($C$13)*($C$22/$C$23)","v":0}]
["2 CARGAR CAMION","No. de Viajes",{"$f":"+(SUM($C$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($C$21/$C$23)","v":93289.28571428571},{"$f":"+(SUM($C$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($C$20/$C$23)","v":124385.71428571428},{"$f":"+(SUM($C$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($C$22/$C$23)","v":0}]
["3 VERIFICAR CARGA","No. de Viajes",{"$f":"+(($B$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+($B$11*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($C$21/$C$23)","v":16367.857142857141},{"$f":"+(SUM($C$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($C$20/$C$23)","v":20730.952380952378},{"$f":"+(SUM($C$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($C$22/$C$23)","v":0}]
["4 TRANSPORTAR CARGA","Galones Consumidos",{"$f":"+(SUM($C$6)*('DATOS REFERENCIA'!$C$13/$C$17))+(SUM($C$7)*('DATOS REFERENCIA'!$C$13/$C$17))+(SUM($C$9)*'DATOS REFERENCIA'!$C$13/$C$17)+(SUM($C$10)*'DATOS REFERENCIA'!$C$13/$C$17)+((('DATOS REFERENCIA'!$C$13*$C$19)/$C$17)*'DATOS REFERENCIA'!$B$18)+((SUM($C$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($C$21/$C$23)","v":2886049.6309039798},{"$f":"+(SUM($C$6)*('DATOS REFERENCIA'!$C$14/$C$17))+(SUM($C$7)*('DATOS REFERENCIA'!$C$14/$C$17))+(SUM($C$9)*'DATOS REFERENCIA'!$C$14/$C$17)+(SUM($C$10)*'DATOS REFERENCIA'!$C$14/$C$17)+((('DATOS REFERENCIA'!$C$14*$C$19)/$C$17)*'DATOS REFERENCIA'!$B$18)+((SUM($C$10)*('DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))+((SUM($C$11)*('DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))))*($C$20/$C$23)","v":336345.48742149328},{"$f":"+(SUM($C$6)*('DATOS REFERENCIA'!$C$12/$C$19))+(SUM($C$7)*('DATOS REFERENCIA'!$C$12/$C$19))+(SUM($C$9)*'DATOS REFERENCIA'!$C$12/$C$19)+(SUM($C$12)*'DATOS REFERENCIA'!$C$12/$C$19)+((('DATOS REFERENCIA'!$C$12*$C$19)/$C$17)*'DATOS REFERENCIA'!$B$18)+((SUM($C$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($C$22/$C$23)","v":0},{"$f":"+(SUM($C$6)*('DATOS REFERENCIA'!$C$15/'CALCULOS DE COSTOS vehiculo'!$C$17))+(SUM($C$7)*('DATOS REFERENCIA'!$C$15/'CALCULOS DE COSTOS vehiculo'!$C$17))+(SUM($C$9)*'DATOS REFERENCIA'!$C$15/'CALCULOS DE COSTOS vehiculo'!$C$17)+(SUM($C$11)*'DATOS REFERENCIA'!$C$15/'CALCULOS DE COSTOS vehiculo'!$C$17)+((('DATOS REFERENCIA'!$C$15*$C$19)/$C$17)*'DATOS REFERENCIA'!$B$18)","v":146559.7934216946}]
["5 DESCARGAR CARGA","No. de Viajes",{"$f":"+(SUM($C$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*('CALCULOS DE COSTOS vehiculo'!$C$21/'CALCULOS DE COSTOS vehiculo'!$C$23)","v":93289.28571428571},{"$f":"+(SUM($C$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($C$20/$C$23)","v":124385.71428571428},{"$f":"+(SUM($C$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*$C$22/$C$23","v":0}]
["6 ENTREGAR REMISIONES","No. de Viajes",{"$f":"(+SUM($C$5)+SUM($C$8)+(SUM($C$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($C$21/$C$23)","v":585561.49999999988},{"$f":"(+SUM($C$5)+SUM($C$8)+(SUM($C$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($C$20/$C$23)","v":780748.66666666651},{"$f":"(+SUM($C$5)+SUM($C$8)+(SUM($C$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($C$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($C$22/$C$23)","v":0}]
[null,null,{"$f":"SUM(C44:C49)","v":3890214.7023325511},{"$f":"SUM(D44:D49)","v":1674139.3921833979},{"$f":"SUM(E44:E49)","v":0}]
[]
["COSTO VIAJE LOCAL",{"$f":"+$D$50/$C$20","v":59790.692577978494}]
["COSTO VIAJE CARTAGENA",{"$f":"+$C$50/$C$21","v":185248.3191586929}]
["COSTO VIAJE SANTA MARTA",{"$f":"+E50/I34","v":{"$error":"#DIV/0!"}}]
[]
["RECURSOS",null,"VEHICULO 3"]
[]
["ACTIVIDAD","CONDUCTOR","CARTAGENA","LOCAL","SANTA MARTA","RECORRIDOS INTERNOS"]
["1 PLANEAR RUTA DE ENTREGA","No. de Viajes",{"$f":"+$D$13*($D$21/$D$23)","v":282843.47826086957},{"$f":"+($D$13)*($D$20/$D$23)","v":295700},{"$f":"+($D$13)*($D$22/$D$23)","v":12856.521739130434}]
["2 CARGAR CAMION","No. de Viajes",{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($D$21/$D$23)","v":109593.47826086957},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($D$20/$D$23)","v":114575},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($D$22/$D$23)","v":4981.521739130435}]
["3 VERIFICAR CARGA","No. de Viajes",{"$f":"+(($C$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+($C$11*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($D$21/$D$23)","v":17350.905797101448},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($D$20/$D$23)","v":19095.833333333332},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($D$22/$D$23)","v":830.25362318840575}]
["4 TRANSPORTAR CARGA","Galones Consumidos",{"$f":"+(SUM($D$6)*('DATOS REFERENCIA'!$D$13/$D$17))+(SUM($D$7)*('DATOS REFERENCIA'!$D$13/$D$17))+(SUM($D$9)*'DATOS REFERENCIA'!$D$13/$D$17)+(SUM($D$10)*'DATOS REFERENCIA'!$D$13/$D$17)+((('DATOS REFERENCIA'!$D$13*$D$19)/$D$17)*'DATOS REFERENCIA'!$B$18)+((SUM($D$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($D$21/$D$23)","v":3299931.680115453},{"$f":"+(SUM($D$6)*('DATOS REFERENCIA'!$D$14/$D$17))+(SUM($D$7)*('DATOS REFERENCIA'!$D$14/$D$17))+(SUM($D$9)*'DATOS REFERENCIA'!$D$14/$D$17)+(SUM($D$10)*'DATOS REFERENCIA'!$D$14/$D$17)+((('DATOS REFERENCIA'!$D$14*$D$19)/$D$17)*'DATOS REFERENCIA'!$B$18)+((SUM($D$10)*('DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))+((SUM($D$11)*('DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))))*($D$20/$D$23)","v":356748.25071228633},{"$f":"+(SUM($D$6)*('DATOS REFERENCIA'!$D$12/$D$19))+(SUM($D$7)*('DATOS REFERENCIA'!$D$12/$D$19))+(SUM($D$9)*'DATOS REFERENCIA'!$D$12/$D$19)+(SUM($D$12)*'DATOS REFERENCIA'!$D$12/$D$19)+((('DATOS REFERENCIA'!$D$12*$D$19)/$D$17)*'DATOS REFERENCIA'!$B$18)+((SUM($D$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($D$22/$D$23)","v":364336.3460769144},{"$f":"+(SUM($D$6)*('DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$D$17))+(SUM($D$7)*('DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$D$17))+(SUM($D$9)*'DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$D$17)+(SUM($D$11)*'DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$D$17)+((('DATOS REFERENCIA'!$D$15*$D$19)/$D$17)*'DATOS REFERENCIA'!$B$18)","v":69001.49694019297}]
["5 DESCARGAR CARGA","No. de Viajes",{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*('CALCULOS DE COSTOS vehiculo'!$D$21/'CALCULOS DE COSTOS vehiculo'!$D$23)","v":109593.47826086957},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($D$20/$D$23)","v":114575},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*$D$22/$D$23","v":4981.521739130435}]
["6 ENTREGAR REMISIONES","No. de Viajes",{"$f":"(+SUM($D$5)+SUM($D$8)+(SUM($D$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($D$21/$D$23)","v":557184.75362318836},{"$f":"(+SUM($D$5)+SUM($D$8)+(SUM($D$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($D$20/$D$23)","v":582511.33333333326},{"$f":"(+SUM($D$5)+SUM($D$8)+(SUM($D$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($D$22/$D$23)","v":25326.579710144924}]
[null,null,{"$f":"SUM(C59:C64)","v":4376497.7743183514},{"$f":"SUM(D59:D64)","v":1483205.417378953},{"$f":"SUM(E59:E64)","v":413312.74462763901},{"$f":"SUM(F59:F64)","v":69001.49694019297}]
[]
["COSTO VIAJE LOCAL",{"$f":"$D$65/$D$20","v":64487.192059954476}]
["COSTO VIAJE CARTAGENA",{"$f":"+$C$65/$D$21","v":198931.71701447052}]
["COSTO VIAJE SANTA MARTA",{"$f":"+$E$65/$D$22","v":413312.74462763901}]
[]
[]
["RECURSOS",null,"VEHICULO 4"]
[]
["ACTIVIDAD","CONDUCTOR","CARTAGENA","LOCAL","SANTA MARTA","RECORRIDOS INTERNOS"]
["1 PLANEAR RUTA DE ENTREGA","No. de Viajes",{"$f":"+($E$13)*($E$21/$E$23)","v":525282.3529411765},{"$f":"+($E$13)*($E$20/$E$23)","v":291823.5294117647},{"$f":"+($E$13)*($E$22/$E$23)","v":175094.11764705883}]
["2 CARGAR CAMION","No. de Viajes",{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($E$21/$E$23)","v":124173.52941176471},{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($E$20/$E$23)","v":68985.294117647063},{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($E$22/$E$23)","v":41391.176470588238}]
["3 VERIFICAR CARGA","No. de Viajes",{"$f":"+(($C$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+($C$11*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($D$21/$D$23)","v":17350.905797101448},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($E$20/$E$23)","v":11232.843137254902},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($E$22/$E$23)","v":6739.7058823529414}]
["4 TRANSPORTAR CARGA","Galones Consumidos",{"$f":"+(SUM($E$6)*('DATOS REFERENCIA'!$E$13/$E$17))+(SUM($E$7)*('DATOS REFERENCIA'!$E$13/$E$17))+(SUM($E$9)*'DATOS REFERENCIA'!$E$13/$E$17)+(SUM($E$10)*'DATOS REFERENCIA'!$E$13/$E$17)+((('DATOS REFERENCIA'!$E$13*$E$19)/$E$17)*'DATOS REFERENCIA'!$B$18)+((SUM($E$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($E$21/$E$23)","v":2648753.5452617267},{"$f":"+(SUM($E$6)*('DATOS REFERENCIA'!$E$14/$E$17))+(SUM($E$7)*('DATOS REFERENCIA'!$E$14/$E$17))+(SUM($E$9)*'DATOS REFERENCIA'!$E$14/$E$17)+(SUM($E$10)*'DATOS REFERENCIA'!$E$14/$E$17)+((('DATOS REFERENCIA'!$E$14*$E$19)/$E$17)*'DATOS REFERENCIA'!$B$18)+((SUM($E$10)*('DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))+((SUM($E$11)*('DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))))*($E$20/$E$23)","v":214846.2090471519},{"$f":"+(SUM($E$6)*('DATOS REFERENCIA'!$E$12/$E$19))+(SUM($E$7)*('DATOS REFERENCIA'!$E$12/$E$19))+(SUM($E$9)*'DATOS REFERENCIA'!$E$12/$E$19)+(SUM($E$12)*'DATOS REFERENCIA'!$E$12/$E$19)+((('DATOS REFERENCIA'!$E$12*$E$19)/$E$17)*'DATOS REFERENCIA'!$B$18)+((SUM($E$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($E$22/$E$23)","v":2083829.9466827931},{"$f":"+(SUM($E$6)*('DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$E$17))+(SUM($E$7)*('DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$E$17))+(SUM($E$9)*'DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$E$17)+(SUM($E$11)*'DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$E$17)+((('DATOS REFERENCIA'!$D$15*$E$19)/$E$17)*'DATOS REFERENCIA'!$B$18)","v":70310.521542372648}]
["5 DESCARGAR CARGA","No. de Viajes",{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*('CALCULOS DE COSTOS vehiculo'!$E$21/'CALCULOS DE COSTOS vehiculo'!$E$22)","v":703650},{"$f":"+(SUM($D$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($D$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($E$20/$E$23)","v":67397.058823529413},{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*$E$22/$E$23","v":41391.176470588238}]
["6 ENTREGAR REMISIONES","No. de Viajes",{"$f":"(+SUM($E$5)+SUM($E$8)+(SUM($E$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($E$21/$E$23)","v":641606.1176470588},{"$f":"(+SUM($E$5)+SUM($E$8)+(SUM($E$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($E$20/$E$23)","v":356447.84313725488},{"$f":"(+SUM($E$5)+SUM($E$8)+(SUM($E$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($E$22/$E$23)","v":213868.70588235292}]
[null,null,{"$f":"SUM(C75:C80)","v":4660816.4510588283},{"$f":"SUM(D75:D80)","v":1010732.7776746028},{"$f":"SUM(E75:E80)","v":2562314.8290357343},{"$f":"SUM(F75:F80)","v":70310.521542372648}]
[]
["COSTO VIAJE LOCAL",{"$f":"+$D$81/$E$20","v":101073.27776746028}]
["COSTO VIAJE CARTAGENA",{"$f":"+$C$81/$E$21","v":258934.247281046}]
["COSTO VIAJE SANTA MARTA",{"$f":"+$E$81/$E$22","v":427052.47150595573}]
[]
["RECURSOS",null,"VEHICULO 5"]
[]
["ACTIVIDAD","CONDUCTOR","CARTAGENA","LOCAL","SANTA MARTA","RECORRIDOS INTERNOS"]
["1 PLANEAR RUTA DE ENTREGA","No. de Viajes",{"$f":"+($F$13)*($F$21/$F$23)","v":851300},{"$f":"+($F$13)*($F$20/$F$23)","v":0},{"$f":"+($F$13)*($F$22/$F$23)","v":0}]
["2 CARGAR CAMION","No. de Viajes",{"$f":"+(SUM($F$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($F$21/$F$23)","v":213750},{"$f":"+(SUM($F$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($F$20/$F$23)","v":0},{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($F$22/$F$23)","v":0}]
["3 VERIFICAR CARGA","No. de Viajes",{"$f":"+(($D$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+($D$11*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($F$21/$F$23)","v":38191.666666666664},{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($F$20/$F$23)","v":0},{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$B$7/'DATOS REFERENCIA'!$B$9))*($F$22/$F$23)","v":0}]
["4 TRANSPORTAR CARGA","Galones Consumidos",{"$f":"+(SUM($F$6)*('DATOS REFERENCIA'!$F$13/$F$17))+(SUM($F$7)*('DATOS REFERENCIA'!$F$13/$F$17))+(SUM($F$9)*'DATOS REFERENCIA'!$F$13/$F$17)+(SUM($F$10)*'DATOS REFERENCIA'!$F$13/$F$17)+((('DATOS REFERENCIA'!$F$13*$F$19)/$F$17)*'DATOS REFERENCIA'!$B$18)+((SUM($F$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($F$21/$F$23)","v":3577286.6220287583},{"$f":"+(SUM($F$6)*('DATOS REFERENCIA'!$F$14/$F$17))+(SUM($F$7)*('DATOS REFERENCIA'!$F$14/$F$17))+(SUM($F$9)*'DATOS REFERENCIA'!$F$14/$F$17)+(SUM($F$10)*'DATOS REFERENCIA'!$F$14/$F$17)+((('DATOS REFERENCIA'!$F$14*$F$19)/$F$17)*'DATOS REFERENCIA'!$B$18)+((SUM($F$10)*('DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))+((SUM($F$11)*('DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))))*($F$20/$F$23)","v":0},{"$f":"+(SUM($F$6)*('DATOS REFERENCIA'!$F$12/$F$19))+(SUM($F$7)*('DATOS REFERENCIA'!$F$12/$F$19))+(SUM($F$9)*'DATOS REFERENCIA'!$F$12/$F$19)+(SUM($F$12)*'DATOS REFERENCIA'!$F$12/$F$19)+((('DATOS REFERENCIA'!$F$12*$F$19)/$F$17)*'DATOS REFERENCIA'!$B$18)+((SUM($F$10)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$C$7/'DATOS REFERENCIA'!$B$9))*($F$22/$F$23)","v":0},{"$f":"+(SUM($F$6)*('DATOS REFERENCIA'!$E$15/'CALCULOS DE COSTOS vehiculo'!$F$17))+(SUM($F$7)*('DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$F$17))+(SUM($F$9)*'DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$F$17)+(SUM($F$11)*'DATOS REFERENCIA'!$D$15/'CALCULOS DE COSTOS vehiculo'!$F$17)+((('DATOS REFERENCIA'!$D$15*$F$19)/$F$17)*'DATOS REFERENCIA'!$B$18)","v":69558.65833724635}]
["5 DESCARGAR CARGA","No. de Viajes",{"$f":"+(SUM($F$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*('CALCULOS DE COSTOS vehiculo'!$F$21/'CALCULOS DE COSTOS vehiculo'!$F$23)","v":213750},{"$f":"+(SUM($E$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($E$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*($F$20/$F$23)","v":0},{"$f":"+(SUM($F$10)*('DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$A$7/'DATOS REFERENCIA'!$B$9))*$F$22/$F$23","v":0}]
["6 ENTREGAR REMISIONES","No. de Viajes",{"$f":"(+SUM($F$5)+SUM($F$8)+(SUM($F$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($F$21/$F$23)","v":1361456},{"$f":"(+SUM($F$5)+SUM($F$8)+(SUM($F$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($F$20/$F$23)","v":0},{"$f":"(+SUM($F$5)+SUM($F$8)+(SUM($F$10)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9)+(SUM($F$11)*'DATOS REFERENCIA'!$E$7/'DATOS REFERENCIA'!$B$9))*($F$22/$F$23)","v":0}]
[null,null,{"$f":"SUM(C90:C95)","v":6255734.2886954248},{"$f":"SUM(D90:D95)","v":0},{"$f":"SUM(E90:E95)","v":0},{"$f":"SUM(F90:F95)","v":69558.65833724635}]
[]
["COSTO VIAJE LOCAL",{"$f":"+$D$96/$F$20","v":{"$error":"#DIV/0!"}},{"$f":"+C90+C75+C59+C44+C28","v":2121802.9740591887}]
["COSTO VIAJE CARTAGENA",{"$f":"+$C$96/$F$21","v":240605.16494982404}]
["COSTO VIAJE SANTA MARTA",{"$f":"+$E$96/$F$22","v":{"$error":"#DIV/0!"}}]

{"sheet":"DATOS REFERENCIA","index":5,"n_rows":18,"n_cols":24,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,17,0,18],[0,20,0,21],[0,23,0,24],[0,26,0,27],[0,7,0,8]]}
["MENU PRINCIPAL",null,"COSTOS FIJOS",null,"COSTOS VARIABLES",null,null,"CALCULO DE COSTOS",null,null,null,null,null,null,null,null,null,null,null,null,"COSTOS VARIABLES",null,null,"CALCULO DE COSTOS"]
[]
[]
["DATOS REFERENCIAS"]
[]
["HORAS CARGAR CAMION","HORAS VERIFICAR CARGA","HORAS TRANSPORTAR CARGA","HORAS DESCARGAR CARGA","HORAS ENTREGAR REMISIONES"]
[3,0.5,5,3,0.5]
[]
["HORAS PROMEDIO",12]
[]
["kilometros recorridos","SPH-289","STL-357","SXZ-985","UYU-809","UZC-663","TOTAL"]
["santa marta",null,null,293.8,1453.4999999999998,null,{"$f":"+B12+C12+D12+E12+F12","v":1747.2999999999997}]
["cartagena",7665.7,6756.7999999999993,7180.7000000000007,5601.4,7695.8,{"$f":"+B13+C13+D13+E13+F13","v":34900.400000000001}]
["barranquilla",434.3,319.3,381.9,229.10000000000002,null,{"$f":"+B14+C14+D14+E14+F14","v":1364.6}]
["recorridos internos",87.6,302.7,134.30000000000001,229.10000000000002,183.9,{"$f":"+B15+C15+D15+E15+F15","v":937.59999999999991}]
["TOTAL",{"$f":"SUM(B13:B15)","v":8187.6},{"$f":"SUM(C13:C15)","v":7378.7999999999993},{"$f":"SUM(D12:D15)","v":7990.7000000000007},{"$f":"SUM(E12:E15)","v":7513.1},7879.7,{"$f":"SUM(G12:G15)","v":38949.9}]
[]
["valor acpm",7879.76]