{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["_Form_","_Fields_"],"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":"_Form_","index":0,"n_rows":46,"n_cols":30,"rows_kept":46,"cut":false,"hidden":false,"merged":[[30,2,30,5],[42,10,42,12],[6,3,6,4],[7,3,7,9],[9,3,9,9],[10,3,10,9],[31,2,31,5],[13,2,13,7],[16,2,16,5],[17,2,17,5],[34,2,34,5],[32,2,32,5],[33,2,33,5],[14,2,14,7],[4,1,4,14],[3,1,3,8],[35,2,35,5],[36,2,36,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[29,2,29,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control Documentario"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Codigo Formato:  FRM-16-001"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version: 1.0"]
[]
[null,"ORDEN DE COMPRA BIENES/SERVICIOS"]
[]
[null,null,"Nro. O.C.:"]
[null,null,"Obra:"]
[]
[null,null,"Proveedor:"]
[null,null,"Atención:"]
[]
[null,null,"Lugar Entrega/Otros:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recepcion de Items"]
[{"$f":"ROW()","v":17},"Item","Descripcion",null,null,null,"Unidad","Cantidad","Fecha Req. \nen Obra","Moneda","P.U.","Parcial","X","Proveedor","Nro Cotiz.",null,"SALDO Qty","Qty Acum.",1,{"$f":"S17+1","v":2},{"$f":"T17+1","v":3},4,5,6,7,8,9,10,11,12]
[null,{"$f":"IF(C18<>\"\",ROW()-$A$17,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"H18*K18","v":0},null,null,null,null,{"$f":"H18-R18","v":0},{"$f":"SUM(S18:AD18)","v":0}]
[null,{"$f":"IF(C19<>\"\",ROW()-$A$17,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,null,null,null,null,{"$f":"H19-R19","v":0},{"$f":"SUM(S19:AD19)","v":0}]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[null,"",null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,"SubTotal:",null,{"$f":"SUBTOTAL(9,L18:L37)","v":0},null,null,null,null,null,null,{"$f":"SUMPRODUCT($K$18:$K$37,S18:S37)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"IGV:",0.18,{"$f":"L39*K40","v":0},null,null,null,null,null,null,{"$f":"S39*$K$40","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"L39+L40","v":0},null,null,null,null,"Valor Acum.",{"$f":"SUM(S41:AD41)","v":0},{"$f":"S39+S40","v":0},{"$f":"T39+T40","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,"Tipo de Pago:"]
[]
[null,"Instrucciones Generales:"]
[null,"1. Las descripciones en cada celda un pueden ser mayores a 100 caracteres."]

{"sheet":"_Fields_","index":1,"n_rows":411,"n_cols":8,"rows_kept":411,"cut":false,"hidden":false,"merged":[]}
["Field","Celda","Act","id_A156","id_B247","id_C100","id_D101","id_E710"]
["DIRECCION","B4",null,null,null,null,null,"12345"]
["OC","D7","Y",140,351,3248,1131]
["OBRA","D8","Y",141,351,3248,1131]
["PROV","D10"]
["ATT","D11"]
["NOTA1","C14"]
["NOTA2","C15"]
["ITEM1","C18"]
["ITEM2","C19"]
["ITEM3","C20"]
["ITEM4","C21"]
["ITEM5","C22"]
["ITEM6","C23"]
["ITEM7","C24"]
["ITEM8","C25"]
["ITEM9","C26"]
["ITEM10","C27"]
["ITEM11","C28"]
["ITEM12","C29"]
["ITEM13","C30"]
["ITEM14","C31"]
["ITEM15","C32"]
["ITEM16","C33"]
["ITEM17","C34"]
["ITEM18","C35"]
["ITEM19","C36"]
["ITEM20","C37"]
["UND1","G18"]
["UND2","G19"]
["UND3","G20"]
["UND4","G21"]
["UND5","G22"]
["UND6","G23"]
["UND7","G24"]
["UND8","G25"]
["UND9","G26"]
["UND10","G27"]
["UND11","G28"]
["UND12","G29"]
["UND13","G30"]
["UND14","G31"]
["UND15","G32"]
["UND16","G33"]
["UND17","G34"]
["UND18","G35"]
["UND19","G36"]
["UND20","G37"]
["QTY1","H18"]
["QTY2","H19"]
["QTY3","H20"]
["QTY4","H21"]
["QTY5","H22"]
["QTY6","H23"]
["QTY7","H24"]
["QTY8","H25"]
["QTY9","H26"]
["QTY10","H27"]
["QTY11","H28"]
["QTY12","H29"]
["QTY13","H30"]
["QTY14","H31"]
["QTY15","H32"]
["QTY16","H33"]
["QTY17","H34"]
["QTY18","H35"]
["QTY19","H36"]
["QTY20","H37"]
["FECR1","I18"]
["FECR2","I19"]
["FECR3","I20"]
["FECR4","I21"]
["FECR5","I22"]
["FECR6","I23"]
["FECR7","I24"]
["FECR8","I25"]
["FECR9","I26"]
["FECR10","I27"]
["FECR11","I28"]
["FECR12","I29"]
["FECR13","I30"]
["FECR14","I31"]
["FECR15","I32"]
["FECR16","I33"]
["FECR17","I34"]
["FECR18","I35"]
["FECR19","I36"]
["FECR20","I37"]
["MON1","J18"]
["MON2","J19"]
["MON3","J20"]
["MON4","J21"]
["MON5","J22"]
["MON6","J23"]
["MON7","J24"]
["MON8","J25"]
["MON9","J26"]
["MON10","J27"]
["MON11","J28"]
["MON12","J29"]
["MON13","J30"]
["MON14","J31"]
["MON15","J32"]
["MON16","J33"]
["MON17","J34"]
["MON18","J35"]
["MON19","J36"]
["MON20","J37"]
["PU1","K18"]
["PU2","K19"]
["PU3","K20"]
["PU4","K21"]
["PU5","K22"]
["PU6","K23"]
["PU7","K24"]
["PU8","K25"]
["PU9","K26"]
["PU10","K27"]
["PU11","K28"]
["PU12","K29"]
["PU13","K30"]
["PU14","K31"]
["PU15","K32"]
["PU16","K33"]
["PU17","K34"]
["PU18","K35"]
["PU19","K36"]
["PU20","K37"]
["PROV1","N18"]
["PROV2","N19"]
["PROV3","N20"]
["PROV4","N21"]
["PROV5","N22"]
["PROV6","N23"]
["PROV7","N24"]
["PROV8","N25"]
["PROV9","N26"]
["PROV10","N27"]
["PROV11","N28"]
["PROV12","N29"]
["PROV13","N30"]
["PROV14","N31"]
["PROV15","N32"]
["PROV16","N33"]
["PROV17","N34"]
["PROV18","N35"]
["PROV19","N36"]
["PROV20","N37"]
["COTIZ1","O18"]
["COTIZ2","O19"]
["COTIZ3","O20"]
["COTIZ4","O21"]
["COTIZ5","O22"]
["COTIZ6","O23"]
["COTIZ7","O24"]
["COTIZ8","O25"]
["COTIZ9","O26"]
["COTIZ10","O27"]
["COTIZ11","O28"]
["COTIZ12","O29"]
["COTIZ13","O30"]
["COTIZ14","O31"]
["COTIZ15","O32"]
["COTIZ16","O33"]
["COTIZ17","O34"]
["COTIZ18","O35"]
["COTIZ19","O36"]
["COTIZ20","O37"]
["IGV","K40"]
["TIPOPAG","J43"]
["NOTATP","K43"]
["SS18","S18"]
["SS19","S19"]
["SS20","S20"]
["SS21","S21"]
["SS22","S22"]
["SS23","S23"]
["SS24","S24"]
["SS25","S25"]
["SS26","S26"]
["SS27","S27"]
["SS28","S28"]
["SS29","S29"]
["SS30","S30"]
["SS31","S31"]
["SS32","S32"]
["SS33","S33"]
["SS34","S34"]
["SS35","S35"]
["SS36","S36"]
["SS37","S37"]
["TT18","T18"]
["TT19","T19"]
["TT20","T20"]
["TT21","T21"]
["TT22","T22"]
["TT23","T23"]
["TT24","T24"]
["TT25","T25"]
["TT26","T26"]
["TT27","T27"]
["TT28","T28"]
["TT29","T29"]
["TT30","T30"]
["TT31","T31"]
["TT32","T32"]
["TT33","T33"]
["TT34","T34"]
["TT35","T35"]
["TT36","T36"]
["TT37","T37"]
["UU18","U18"]
["UU19","U19"]
["UU20","U20"]
["UU21","U21"]
["UU22","U22"]
["UU23","U23"]
["UU24","U24"]
["UU25","U25"]
["UU26","U26"]
["UU27","U27"]
["UU28","U28"]
["UU29","U29"]
["UU30","U30"]
["UU31","U31"]
["UU32","U32"]
["UU33","U33"]
["UU34","U34"]
["UU35","U35"]
["UU36","U36"]
["UU37","U37"]
["VV18","V18"]
["VV19","V19"]
["VV20","V20"]
["VV21","V21"]
["VV22","V22"]
["VV23","V23"]
["VV24","V24"]
["VV25","V25"]
["VV26","V26"]
["VV27","V27"]
["VV28","V28"]
["VV29","V29"]
["VV30","V30"]
["VV31","V31"]
["VV32","V32"]
["VV33","V33"]
["VV34","V34"]
["VV35","V35"]
["VV36","V36"]
["VV37","V37"]
["WW18","W18"]
["WW19","W19"]
["WW20","W20"]
["WW21","W21"]
["WW22","W22"]
["WW23","W23"]
["WW24","W24"]
["WW25","W25"]
["WW26","W26"]
["WW27","W27"]
["WW28","W28"]
["WW29","W29"]
["WW30","W30"]
["WW31","W31"]
["WW32","W32"]
["WW33","W33"]
["WW34","W34"]
["WW35","W35"]
["WW36","W36"]
["WW37","W37"]
["XX18","X18"]
["XX19","X19"]
["XX20","X20"]
["XX21","X21"]
["XX22","X22"]
["XX23","X23"]
["XX24","X24"]
["XX25","X25"]
["XX26","X26"]
["XX27","X27"]
["XX28","X28"]
["XX29","X29"]
["XX30","X30"]
["XX31","X31"]
["XX32","X32"]
["XX33","X33"]
["XX34","X34"]
["XX35","X35"]
["XX36","X36"]
["XX37","X37"]
["YY18","Y18"]
["YY19","Y19"]
["YY20","Y20"]
["YY21","Y21"]
["YY22","Y22"]
["YY23","Y23"]
["YY24","Y24"]
["YY25","Y25"]
["YY26","Y26"]
["YY27","Y27"]
["YY28","Y28"]
["YY29","Y29"]
["YY30","Y30"]
["YY31","Y31"]
["YY32","Y32"]
["YY33","Y33"]
["YY34","Y34"]
["YY35","Y35"]
["YY36","Y36"]
["YY37","Y37"]
["ZZ18","Z18"]
["ZZ19","Z19"]
["ZZ20","Z20"]
["ZZ21","Z21"]
["ZZ22","Z22"]
["ZZ23","Z23"]
["ZZ24","Z24"]
["ZZ25","Z25"]
["ZZ26","Z26"]
["ZZ27","Z27"]
["ZZ28","Z28"]
["ZZ29","Z29"]
["ZZ30","Z30"]
["ZZ31","Z31"]
["ZZ32","Z32"]
["ZZ33","Z33"]
["ZZ34","Z34"]
["ZZ35","Z35"]
["ZZ36","Z36"]
["ZZ37","Z37"]
["AAA18","AA18"]
["AAA19","AA19"]
["AAA20","AA20"]
["AAA21","AA21"]
["AAA22","AA22"]
["AAA23","AA23"]
["AAA24","AA24"]
["AAA25","AA25"]
["AAA26","AA26"]
["AAA27","AA27"]
["AAA28","AA28"]
["AAA29","AA29"]
["AAA30","AA30"]
["AAA31","AA31"]
["AAA32","AA32"]
["AAA33","AA33"]
["AAA34","AA34"]
["AAA35","AA35"]
["AAA36","AA36"]
["AAA37","AA37"]
["AAB18","AB18"]
["AAB19","AB19"]
["AAB20","AB20"]
["AAB21","AB21"]
["AAB22","AB22"]
["AAB23","AB23"]
["AAB24","AB24"]
["AAB25","AB25"]
["AAB26","AB26"]
["AAB27","AB27"]
["AAB28","AB28"]
["AAB29","AB29"]
["AAB30","AB30"]
["AAB31","AB31"]
["AAB32","AB32"]
["AAB33","AB33"]
["AAB34","AB34"]
["AAB35","AB35"]
["AAB36","AB36"]
["AAB37","AB37"]
["AAC18","AC18"]
["AAC19","AC19"]
["AAC20","AC20"]
["AAC21","AC21"]
["AAC22","AC22"]
["AAC23","AC23"]
["AAC24","AC24"]
["AAC25","AC25"]
["AAC26","AC26"]
["AAC27","AC27"]
["AAC28","AC28"]
["AAC29","AC29"]
["AAC30","AC30"]
["AAC31","AC31"]
["AAC32","AC32"]
["AAC33","AC33"]
["AAC34","AC34"]
["AAC35","AC35"]
["AAC36","AC36"]
["AAC37","AC37"]
["AAD18","AD18"]
["AAD19","AD19"]
["AAD20","AD20"]
["AAD21","AD21"]
["AAD22","AD22"]
["AAD23","AD23"]
["AAD24","AD24"]
["AAD25","AD25"]
["AAD26","AD26"]
["AAD27","AD27"]
["AAD28","AD28"]
["AAD29","AD29"]
["AAD30","AD30"]
["AAD31","AD31"]
["AAD32","AD32"]
["AAD33","AD33"]
["AAD34","AD34"]
["AAD35","AD35"]
["AAD36","AD36"]
["AAD37","AD37"]