{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["dB","2101"],"not_rendered":{"charts":0,"images":0,"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":"dB","index":0,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"TANGGAL","NAMA BARANG","HARGA UNIT","Nama BUMdes/Desa/Kab:","Lele Desa Paria Kec. Apolo Kab. Angkasa"]
[]
[null,"2021-02-01","Indomie Goreng 50gr",1000]
[null,null,"Aqua 1500ml",6000]
[null,null,"Leminerale",5000]

{"sheet":"2101","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6]]}
[{"$f":"LEFT(MID(CELL(\"filename\"),FIND(\"]\",CELL(\"filename\"))+1,255),1)&\".\"&RIGHT(MID(CELL(\"filename\"),FIND(\"]\",CELL(\"filename\"))+1,255),1)","v":"2.1"},{"$f":"\"BADAN USAHA MILIK DESA (BUM DESA) \"&(UPPER(BUMdes))","v":"BADAN USAHA MILIK DESA (BUM DESA) LELE DESA PARIA KEC. APOLO KAB. ANGKASA"}]
[null,{"$f":"\"BUKU PEMBANTU PENJUALAN BARANG BULAN \"&(UPPER(TEXT(RIGHT(MID(CELL(\"filename\",A2), FIND(\"]\", CELL(\"filename\", A2))+ 1, 255),2)&\"/20\"&LEFT(MID(CELL(\"filename\",A2), FIND(\"]\", CELL(\"filename\", A2))+ 1, 255),2),\"mmmm yyyy\")))","v":"BUKU PEMBANTU PENJUALAN BARANG BULAN JANUARI 2021"}]
[]
[]
[null,"TANGGAL","KETERANGAN","UNIT","HARGA JUAL","HPP","LABA/RUGI"]
[]
[null,"2021-03-01","Indomie Goreng 50gr",10,12000,{"$f":"IFERROR((VLOOKUP(C7,tbBarang,2,FALSE))*(D7),\"\")","v":10000},{"$f":"IFERROR((((E7)-F7)),\"\")","v":2000}]
[null,"2021-03-01","Aqua 1500ml",5,29000,{"$f":"IFERROR((VLOOKUP(C8,tbBarang,2,FALSE))*(D8),\"\")","v":30000},{"$f":"IFERROR((((E8)-F8)),\"\")","v":-1000}]
[null,null,null,null,null,{"$f":"IFERROR((VLOOKUP(C9,tbBarang,2,FALSE))*(D9),\"\")","v":""},""]
[null,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"IFERROR((VLOOKUP(C11,tbBarang,2,FALSE))*(D11),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR((VLOOKUP(C12,tbBarang,2,FALSE))*(D12),\"\")","v":""},""]
[null,null,null,null,null,{"$f":"IFERROR((VLOOKUP(C13,tbBarang,2,FALSE))*(D13),\"\")","v":""},""]
[]
[null,null,"TOTAL",{"$f":"SUM(D$7:D14)","v":15},{"$f":"SUM(E$7:E14)","v":41000},{"$f":"SUM(F$7:F14)","v":40000},{"$f":"SUM(G7:G14)","v":1000}]