{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["MENU PRINCIPAL","PRODUCTOS","ENTRADAS","SALIDAS","FACTURA","OPCIONES DE LISTA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[1,4,1,11]]}

{"sheet":"PRODUCTOS","index":1,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,0,2,6]]}
[]
[]
["INVENTARIO DE PRODUCTOS"]
[]
["CODIGO","PRODUCTO","PROVEDOR","CANT. EX","ENTRADAS","SALIDAS","PRECIO DE COMPRA","PRECIO DE VENTA","GANANCIA","TOTAL COMPRA","TOTAL VENTA"]
[18,"TUBO SANITARIO 2\"","SELTA",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":60},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A6,ENTRADAS[[#All],[CANTIDAD]])","v":60},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A6,SALIDAS[[#All],[CANTIDAD]])","v":0},11000,16000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":5000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":660000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":960000}]
[17,"TUBO SANITARIO 3\"","SELTA",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":60},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A7,ENTRADAS[[#All],[CANTIDAD]])","v":60},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A7,SALIDAS[[#All],[CANTIDAD]])","v":0},18000,23000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":5000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":1080000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":1380000}]
[16,"TUBO SANITARIO 4\"","SELTA",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":80},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A8,ENTRADAS[[#All],[CANTIDAD]])","v":80},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A8,SALIDAS[[#All],[CANTIDAD]])","v":0},28000,32000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":4000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":2240000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":2560000}]
[15,"BOLSA DE CAL","FERRE TODO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":50},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A9,ENTRADAS[[#All],[CANTIDAD]])","v":50},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A9,SALIDAS[[#All],[CANTIDAD]])","v":0},5000,8000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":3000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":250000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":400000}]
[14,"PEGA MAC","FERRE TODO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":50},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A10,ENTRADAS[[#All],[CANTIDAD]])","v":50},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A10,SALIDAS[[#All],[CANTIDAD]])","v":0},8000,11000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":3000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":400000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":550000}]
[13,"FIJA LISTO","MATERIALES COLOMBIA",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":50},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A11,ENTRADAS[[#All],[CANTIDAD]])","v":50},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A11,SALIDAS[[#All],[CANTIDAD]])","v":0},9000,12000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":3000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":450000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":600000}]
[12,"LADRILLO","NO ESPECIFICADO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":5000},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A12,ENTRADAS[[#All],[CANTIDAD]])","v":5000},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A12,SALIDAS[[#All],[CANTIDAD]])","v":0},350,500,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":150},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":1750000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":2500000}]
[11,"BLOQUE DE HUECO","NO ESPECIFICADO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":1000},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A13,ENTRADAS[[#All],[CANTIDAD]])","v":1000},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A13,SALIDAS[[#All],[CANTIDAD]])","v":0},400,800,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":400},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":400000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":800000}]
[10,"LATA DE GRAVILLA","NO ESPECIFICADO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":300},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A14,ENTRADAS[[#All],[CANTIDAD]])","v":300},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A14,SALIDAS[[#All],[CANTIDAD]])","v":0},2200,3000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":800},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":660000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":900000}]
[9,"LATA ARENA FINA","NO ESPECIFICADO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":300},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A15,ENTRADAS[[#All],[CANTIDAD]])","v":300},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A15,SALIDAS[[#All],[CANTIDAD]])","v":0},500,1100,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":600},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":150000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":330000}]
[8,"LATA ARENA GRUESA","NO ESPECIFICADO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":300},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A16,ENTRADAS[[#All],[CANTIDAD]])","v":300},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A16,SALIDAS[[#All],[CANTIDAD]])","v":0},400,900,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":500},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":120000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":270000}]
[7,"BULTO ARGOS","CAZA EL ALBAÑIL",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":100},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A17,ENTRADAS[[#All],[CANTIDAD]])","v":100},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A17,SALIDAS[[#All],[CANTIDAD]])","v":0},23000,25500,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":2500},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":2300000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":2550000}]
[6,"BULTO ULTRACEM","FERRE TODO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":300},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A18,ENTRADAS[[#All],[CANTIDAD]])","v":300},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A18,SALIDAS[[#All],[CANTIDAD]])","v":0},24000,26500,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":2500},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":7200000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":7950000}]
[5,"ZING CORTO","MATERIALES COLOMBIA",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":100},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A19,ENTRADAS[[#All],[CANTIDAD]])","v":100},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A19,SALIDAS[[#All],[CANTIDAD]])","v":0},12000,15000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":3000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":1200000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":1500000}]
[4,"ZING LARO","MATERIALES COLOMBIA",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":100},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A20,ENTRADAS[[#All],[CANTIDAD]])","v":100},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A20,SALIDAS[[#All],[CANTIDAD]])","v":0},21000,24000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":3000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":2100000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":2400000}]
[3,"ETERNIT # 4","FERE TODO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":100},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A21,ENTRADAS[[#All],[CANTIDAD]])","v":100},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A21,SALIDAS[[#All],[CANTIDAD]])","v":0},12000,17000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":5000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":1200000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":1700000}]
[2,"ETERNIT #6","FERRE TODO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":300},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A22,ENTRADAS[[#All],[CANTIDAD]])","v":300},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A22,SALIDAS[[#All],[CANTIDAD]])","v":0},18000,23000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":5000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":5400000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":6900000}]
[1,"ETERNIT # 8","FERRE TODO",{"$f":"PRODUCTO[[#This Row],[ENTRADAS]]-PRODUCTO[[#This Row],[SALIDAS]]","v":300},{"$f":"SUMIF(ENTRADAS[[#All],[CODIGO ]],A5:A23,ENTRADAS[[#All],[CANTIDAD]])","v":300},{"$f":"SUMIF(SALIDAS[[#All],[CODICO]],A5:A23,SALIDAS[[#All],[CANTIDAD]])","v":0},30000,35000,{"$f":"PRODUCTO[[#This Row],[PRECIO DE VENTA]]-PRODUCTO[[#This Row],[PRECIO DE COMPRA]]","v":5000},{"$f":"PRODUCTO[[#This Row],[PRECIO DE COMPRA]]*PRODUCTO[[#This Row],[CANT. EX]]","v":9000000},{"$f":"PRODUCTO[[#This Row],[CANT. EX]]*PRODUCTO[[#This Row],[PRECIO DE VENTA]]","v":10500000}]
["Total",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,PRODUCTO[TOTAL COMPRA])","v":36560000},{"$f":"SUBTOTAL(109,PRODUCTO[TOTAL VENTA])","v":44750000}]

{"sheet":"ENTRADAS","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,2,3]]}
[]
[]
["ENTRADA DE PRODUCTOS"]
[]
["FECHA","CODIGO ","PRODUCTO","PRECIO DE COMPRA","CANTIDAD","TOTAL COMPRA ENTRADAS"]
[null,2,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"ETERNIT #6"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":18000},null,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":0}]
[null,1,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"ETERNIT # 8"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":30000},null,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":0}]
[null,18,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"TUBO SANITARIO 2\""},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":11000},60,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":660000}]
[null,17,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"TUBO SANITARIO 3\""},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":18000},60,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":1080000}]
[null,16,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"TUBO SANITARIO 4\""},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":28000},80,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":2240000}]
[null,15,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"BOLSA DE CAL"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":5000},50,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":250000}]
[null,14,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"PEGA MAC"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":8000},50,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":400000}]
[null,13,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"FIJA LISTO"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":9000},50,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":450000}]
[null,12,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"LADRILLO"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":350},5000,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":1750000}]
[null,11,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"BLOQUE DE HUECO"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":400},1000,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":400000}]
[null,10,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"LATA DE GRAVILLA"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":2200},300,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":660000}]
[null,9,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"LATA ARENA FINA"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":500},300,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":150000}]
[null,8,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"LATA ARENA GRUESA"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":400},300,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":120000}]
[null,7,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"BULTO ARGOS"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":23000},100,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":2300000}]
[null,6,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"BULTO ULTRACEM"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":24000},300,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":7200000}]
[null,5,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"ZING CORTO"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":12000},100,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":1200000}]
[null,4,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"ZING LARO"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":21000},100,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":2100000}]
[null,3,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"ETERNIT # 4"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":12000},100,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":1200000}]
[null,2,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"ETERNIT #6"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":18000},300,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":5400000}]
[null,1,{"$f":"IFERROR(VLOOKUP(ENTRADAS[[CODIGO ]],PRODUCTO[],2,FALSE), \"\")","v":"ETERNIT # 8"},{"$f":"IFERROR(VLOOKUP(ENTRADAS[[#This Row],[CODIGO ]],PRODUCTO[],7,FALSE), \"\")","v":30000},300,{"$f":"IFERROR(ENTRADAS[[#This Row],[PRECIO DE COMPRA]]*ENTRADAS[[#This Row],[CANTIDAD]], \"\")","v":9000000}]
["Total",null,null,{"$f":"SUBTOTAL(109,ENTRADAS[PRECIO DE COMPRA])","v":270850},{"$f":"SUBTOTAL(109,ENTRADAS[CANTIDAD])","v":8550},{"$f":"SUBTOTAL(109,ENTRADAS[TOTAL COMPRA ENTRADAS])","v":36560000}]

{"sheet":"SALIDAS","index":3,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,0,1,8]]}
[]
["SALIDA DE PRODUCTOS"]
[]
["FECHA","CODICO","PRODUCTO","CANTIDAD","PRECIO DE COMPRA","PRECIO DE VENTA","TOTAL VENTA ","GANANCIA","FORMA DE PAGO"]
[]
["Total",null,null,null,{"$f":"SUBTOTAL(109,SALIDAS[PRECIO DE COMPRA])","v":0},{"$f":"SUBTOTAL(109,SALIDAS[PRECIO DE VENTA])","v":0},{"$f":"SUBTOTAL(109,SALIDAS[[TOTAL VENTA ]])","v":0},{"$f":"SUBTOTAL(109,SALIDAS[GANANCIA])","v":0},{"$f":"SUMIF(SALIDAS[FORMA DE PAGO],\"CREDITO\",SALIDAS[[TOTAL VENTA ]])","v":0}]

{"sheet":"FACTURA","index":4,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,6,33,6],[32,5,33,5],[32,0,33,4],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[30,1,30,3],[0,0,1,6],[6,2,6,6],[5,2,5,6],[4,0,4,6],[3,0,3,6],[2,0,2,6],[7,0,7,6],[8,0,8,1],[8,2,8,3],[8,5,8,6],[9,0,9,1],[9,2,9,3],[9,5,9,6],[10,0,10,6],[12,1,12,3],[31,0,31,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[11,0,11,5],[31,5,31,6],[13,1,13,3],[14,1,14,3],[27,1,27,3],[29,1,29,3],[26,1,26,3],[28,1,28,3]]}
[]
[]
[]
[]
[]
["NO FACTURA",1088]
["FECHA",{"$f":"TODAY()","v":"2020-09-22"}]
["DATOS DEL CLIENTE"]
["CEDULA / NIT",null,null,null,"DR.",{"$f":"IFERROR(VLOOKUP(C9,#REF!,3,FALSE),\" \")","v":" "}]
["NOMBRE / APELLIDO",null,{"$f":"IFERROR(VLOOKUP(C9,#REF!,2,FALSE),\" \")","v":" "},null,"CEL.",{"$f":"IFERROR(VLOOKUP(C9,#REF!,4,FALSE),\" \")","v":" "}]
["DETALLES DE LA COMPRA"]
["                                                                                 FORMA DE PAGO",null,null,null,null,null,"CREDITO"]
["CODICO","PRODUCTO",null,null,"CANT.","   VR.  UNIT.","     VR. TOTAL",null,"FORMULARIO"]
[12,{"$f":"IFERROR(VLOOKUP(A14,PRODUCTO[],2,FALSE), \" \")","v":"LADRILLO"},null,null,null,{"$f":"IFERROR(VLOOKUP(A14,PRODUCTO[],8,FALSE),0)","v":500},{"$f":"E14*F14","v":0}]
[null,{"$f":"IFERROR(VLOOKUP(A15,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A15,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A16,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A16,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A17,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A17,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A18,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A18,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A19,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A19,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A20,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A20,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A21,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A21,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A22,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A22,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A23,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A23,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A24,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A24,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A25,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A25,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A26,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A26,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A27,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A27,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A28,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A28,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A29,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A29,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A30,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A30,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,{"$f":"IFERROR(VLOOKUP(A31,PRODUCTO[],2,FALSE), \" \")","v":" "},null,null,null,{"$f":"IFERROR(VLOOKUP(A31,PRODUCTO[],8,FALSE),0)","v":0},0]
[null,null,null,null,{"$f":"SUM(E14:E31)","v":0}]
["RECIBE CONFORME:",null,null,null,null,"TOTAL",{"$f":"G14+G15+G16+G17+G18+G19+G20+G21+G22+G23+G24+G25+G26+G27+G28+G29+G30+G31","v":0}]

{"sheet":"OPCIONES DE LISTA","index":5,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["FORMA DE PAGO"]
["EFECTIVO"]
["CREDITO"]
["SIN ENTREGAR"]