{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CALCULO","BASE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"CALCULO","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,2,3,6],[8,2,8,6],[16,2,16,5],[1,2,1,7]]}
[]
[null,null,"CALCULO DE IMPUESTOS",null,null,null,null,null,"N°"]
[null,null,"PRODUCTO",null,null,"SPN",null,null,"T/C:",3.62]
[null,null,"BASE IMPONIBLE",null,null,null,null,"USD$",null,"SOLES"]
[null,null,"FOB",null,null,null,null,12000,null,{"$f":"H5*J3","v":43440}]
[null,null,"FLETE",null,null,null,null,null,"%Seg",{"$f":"H6*J3","v":0}]
[null,null,"SEGURO (% o  Valor)",0,null,null,null,{"$f":"IF(D7>0,D7,(H5*I7)/100)","v":0},null,{"$f":"H7*J3","v":0}]
[null,null,"VALOR CIF",null,null,null,"$",{"$f":"H5+H6+H7","v":12000},"S/",{"$f":"J5+J6+J7","v":43440}]
[null,null,"CALCULO IMPUESTOS",null,null,null,null,"USD$",null,"SOLES"]
[null,null,"Ad/Valorem",null,null,6,"%",{"$f":"H8*F10/100","v":720},null,{"$f":"H10*J3","v":2606.4}]
[null,null,"I.P.M.",null,null,"2","%",{"$f":"(H8+H10)*2/100","v":254.4},null,{"$f":"H11*J3","v":920.928}]
[null,null,"I.G.V.",null,null,16,"%",{"$f":"(H8+H10)*16/100","v":2035.2},null,{"$f":"H12*J3","v":7367.424}]
[null,null,"ISC.(U=Unid,$=USD$).Base",0,"U",1,"%",{"$f":"IF(E13=\"U\",D13*F13,(D13*F13)/100)","v":0},null,{"$f":"H13*J3","v":0}]
[null,null,"DERECHO ESPECIFICO",0,"KG",0,"TN",{"$f":"D14*F14","v":0},null,{"$f":"H14*J3","v":0}]
[null,null,"SUB TOTAL",null,null,null,null,{"$f":"H10+H11+H12+H13+H14","v":3009.6},null,{"$f":"H15*J3","v":10894.752}]
[null,null,"PERCEPCION",null,null,null,"%",{"$f":"(H8+H15)*F16/100","v":0},null,{"$f":"H16*J3","v":0}]
[null,null,"TOTAL IMPUESTOS",null,null,null,"$",{"$f":"H15+H16","v":3009.6},"S/",{"$f":"H17*J3","v":10894.752}]
[null,null,"Fecha","2021-02-14"]
[]
[]
[]
[]
[null,null,"NOTA: Solo de color amarillo se ingresa datos"]

{"sheet":"BASE","index":1,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"NRO.","PRODUCTO","PARTIDA","FOB","FLETE","SEGURO","CIF","AD/VAL","IPM","IGV","ISC","DER.ESP.","SUB TOTAL","PERCEPCION","TOT.IMP."]