{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Orden de Compra","Lista de Productos"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":"Orden de Compra","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,5,6,6],[7,5,7,6],[14,3,14,4],[3,2,4,3],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4]]}
[{"$f":"COUNTA(C11:C15)+1","v":1}]
[null,"ORDEN DE COMPRA"]
[]
[null,"ENVIAR A:","Av. Universitaria 1801,\n San Miguel, Lima 32, Perú",null,null,"PO Number:"]
[null,null,null,null,null,"Fecha:"]
[]
[null,"METODO DE ENVIO",null,"INCOTERMS",null,"INSTRUCCIONES DEL ENVIO"]
[null,"Barco",null,"FOB Perú",null,"Entrega inmediata"]
[]
[null,"CANTIDAD","PROD. ID","DESCRIPCIÓN DEL PRODUCTO",null,"PRECIO UNITARIO","TOTAL (US$)"]
[null,null,null,null,null,null,{"$f":"B11*F11","v":0}]
[null,null,null,null,null,null,{"$f":"B12*F12","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Comentarios:",null,null,null,"SUBTOTAL",{"$f":"SUM(G11:G15)","v":0}]
[null,null,null,null,null,"IGV",{"$f":"G16*0.19","v":0}]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G16:G17)","v":0},null,null,null,null,"|"]
[]
[]
[]
[]
[null,null,null,null,"Firma del comprador","Fecha"]

{"sheet":"Lista de Productos","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["NOMBRE PRODUCTOS","PRODUCTO ID","CATEGORIA","PRECIO AL POR MENOR","PRECIO AL POR MAYOR","COGS"]
["Abrelatas","HH-001","Casa",4.99,3.99,{"$f":"E2*0.6","v":2.3940000000000001}]
["Tijeras","HH-002","Casa",9.99,7.99,{"$f":"E3*0.6","v":4.7939999999999996}]
["Cubeta de hielo","HH-003","Casa",9.99,7.99,4.7939999999999996]
["Tacho de basura","HH-004","Casa",19.989999999999998,15.99,9.5939999999999994]
["Aspirador","HH-005","Casa",39.99,31.99,19.193999999999999]
["Mini-nevera","HH-006","Casa",49.99,39.99,23.994]
["Calentador","HH-007","Casa",69.989999999999995,55.99,33.594000000000001]
["Aire acondicionado","HH-008","Casa",119.99,95.99,57.593999999999994]
["Mesa comedor","HH-009","Casa",149.99,119.99,71.994]
["Limpiaparabrisas","AU-001","Automóvil",4.99,3.99,2.3940000000000001]
["Faros de reemplazo","AU-002","Automóvil",9.99,7.99,4.7939999999999996]
["Llantas","AU-003","Automóvil",299.99,239.99,143.994]
["Mesa de patio","OA-001","Actividades al aire libre",49.99,39.99,23.994]
["Tienda","OA-002","Actividades al aire libre",99.99,79.989999999999995,47.993999999999993]