{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Penalidades"],"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":"Penalidades","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,1,24,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Cálculo de Penalidades. EJEMPLO."]
[]
["Comprobación de replanteo:",null,null,"2020-10-14"]
["Plazo inicial de obra (meses):",null,null,14]
["Fin inicial de obra:",null,null,"2021-12-14"]
["Ampliación plazo con penalidades (meses):",null,null,7]
["Plazo vigente de obra:",null,null,"2022-07-14"]
[]
["Importe adjudicación con IVA:",null,null,1532666.66]
["Importe adjudicación sin IVA:",null,null,{"$f":"D17/1.21","v":1266666.6611570248}]
["Importe de penalidades diarias: 0,60€ por cada 1.000€ del precio de contrato, IVA excluído"]
["5% del importe de adjudicación sin IVA:",null,null,{"$f":"D18*5/100","v":63333.33305785124}]
["Importe adjudicación sin IVA/1.000:",null,null,{"$f":"D18/1000","v":1266.6666611570247}]
[]
[]
[]
[null,"Cálculo de penalidades"]
["Mes",{"$f":"\"Diciembre-21\"","v":"Diciembre-21"},{"$f":"\"Enero-22\"","v":"Enero-22"},{"$f":"\"Febrero-22\"","v":"Febrero-22"},{"$f":"\"Marzo-22\"","v":"Marzo-22"},{"$f":"\"Abril-22\"","v":"Abril-22"},{"$f":"\"Mayo-22\"","v":"Mayo-22"},{"$f":"\"Junio-22\"","v":"Junio-22"},{"$f":"\"Julio-22\"","v":"Julio-22"}]
["Días retraso",{"$f":"31-14","v":17},{"$f":"31","v":31},28,31,30,31,30,14]
["€ mes",{"$f":"0.6*B27*$D$21","v":12919.999943801651},{"$f":"0.6*C27*$D$21","v":23559.999897520658},21279.999907438014,23559.999897520658,{"$f":"0.6*F27*$D$21","v":22799.999900826446},{"$f":"0.6*G27*$D$21","v":23559.999897520658},{"$f":"0.6*H27*$D$21","v":22799.999900826446},{"$f":"0.6*I27*$D$21","v":10639.999953719007}]
["€ acumulados",{"$f":"B28","v":12919.999943801651},{"$f":"B29+C28","v":36479.999841322307},{"$f":"C29+D28","v":57759.999748760325},{"$f":"D29+E28","v":81319.99964628098},104119.99954710742,127679.99944462808,150479.99934545453,161119.99929917353]
["% s/importe adj.",{"$f":"B29/$D$18","v":1.0199999999999999E-2},{"$f":"C29/$D$18","v":2.8799999999999996E-2},4.5599999999999995E-2,6.4199999999999993E-2,8.2199999999999981E-2,0.10079999999999999,0.11879999999999999,0.12719999999999998]
[null,null,null,null,"Resolución o",null,"Resolución o"]
[null,null,null,null,"acordar la",null,"Acordar la"]
[null,null,null,null,"continuidad",null,"continuidad"]
[null,null,null,null,"de su ejecución",null,"de su ejecución"]
[null,null,null,null,"con imposición",null,"con imposición"]
[null,null,null,null,"de nuevas",null,"de nuevas"]
[null,null,null,null,"penalidades.",null,"penalidades."]