{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Data Penjualan","Laporan Penjualan","Inventaris"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Data Penjualan","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"PENJUALAN HARIAN BERDASARKAN MESIN KASIR"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"TANGGAL","WAKTU","NOMOR TRANSAKSI","NOMOR SKU/PRODUK","DESKRIPSI","JUMLAH PENJUALAN","PAJAK %","PAJAK PENJUALAN","TOTAL"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"No description found\")","v":"Selimut"},{"v":74.95,"d":"Rp74.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]*tblSalesData[[#This Row],[PAJAK %]]","v":{"v":3.7475000000000005,"d":"Rp3.75"}},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]+tblSalesData[[#This Row],[PAJAK PENJUALAN]]","v":{"v":78.6975,"d":"Rp78.70"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"No description found\")","v":"Taplak meja, bulat 6'"},{"v":34.99,"d":"Rp34.99"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]*tblSalesData[[#This Row],[PAJAK %]]","v":{"v":1.7495000000000003,"d":"Rp1.75"}},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]+tblSalesData[[#This Row],[PAJAK PENJUALAN]]","v":{"v":36.7395,"d":"Rp36.74"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"No description found\")","v":"Piring bulat"},{"v":55.95,"d":"Rp55.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]*tblSalesData[[#This Row],[PAJAK %]]","v":{"v":2.7975000000000003,"d":"Rp2.80"}},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]+tblSalesData[[#This Row],[PAJAK PENJUALAN]]","v":{"v":58.7475,"d":"Rp58.75"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"No description found\")","v":"Piring persegi"},{"v":2.95,"d":"Rp2.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]*tblSalesData[[#This Row],[PAJAK %]]","v":{"v":0.14750000000000002,"d":"Rp0.15"}},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]+tblSalesData[[#This Row],[PAJAK PENJUALAN]]","v":{"v":3.0975,"d":"Rp3.10"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[NOMOR SKU/PRODUK]],tblInventory[],2,0)),\"No description found\")","v":"Bantal"},{"v":14.98,"d":"Rp14.98"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]*tblSalesData[[#This Row],[PAJAK %]]","v":{"v":0.7490000000000001,"d":"Rp0.75"}},{"$f":"tblSalesData[[#This Row],[JUMLAH PENJUALAN]]+tblSalesData[[#This Row],[PAJAK PENJUALAN]]","v":{"v":15.729000000000001,"d":"Rp15.73"}}]

{"sheet":"Laporan Penjualan","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"PENJUALAN HARIAN BERDASARKAN MESIN KASIR"]
[]
[]
[]
[]
[]
[null,"NOMOR SKU/PRODUK","DESKRIPSI","TANGGAL","Jumlah dari JUMLAH PENJUALAN","Jumlah dari PAJAK PENJUALAN","Total "]
[null,90001,"Selimut","2012-02-01",{"v":74.95,"d":"Rp74.95"},{"v":3.7475000000000005,"d":"Rp3.75"},{"v":78.6975,"d":"Rp78.70"}]
[null,90002,"Bantal","2012-02-01",{"v":14.98,"d":"Rp14.98"},{"v":0.7490000000000001,"d":"Rp0.75"},{"v":15.729000000000001,"d":"Rp15.73"}]
[null,90004,"Piring persegi","2012-02-01",{"v":2.95,"d":"Rp2.95"},{"v":0.14750000000000002,"d":"Rp0.15"},{"v":3.0975,"d":"Rp3.10"}]
[null,90005,"Piring bulat","2012-02-01",{"v":55.95,"d":"Rp55.95"},{"v":2.7975000000000003,"d":"Rp2.80"},{"v":58.7475,"d":"Rp58.75"}]
[null,90023,"Taplak meja, bulat 6'","2012-02-01",{"v":34.99,"d":"Rp34.99"},{"v":1.7495000000000003,"d":"Rp1.75"},{"v":36.7395,"d":"Rp36.74"}]
[null,"Total Keseluruhan",null,null,{"v":183.82000000000002,"d":"Rp183.82"},{"v":9.191000000000003,"d":"Rp9.19"},{"v":193.011,"d":"Rp193.01"}]

{"sheet":"Inventaris","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"PENJUALAN HARIAN BERDASARKAN MESIN KASIR"]
[]
[]
[]
[]
[]
[null,"NOMOR SKU/PRODUK","DESKRIPSI"]
[null,90001,"Selimut"]
[null,90002,"Bantal"]
[null,90003,"Sprei"]
[null,90004,"Piring persegi"]
[null,90005,"Piring bulat"]
[null,90006,"Mangkuk, besar"]
[null,90007,"Mangkuk, kecil"]
[null,90008,"Piring bulat, kecil"]
[null,90009,"Garpu, kecil"]
[null,90010,"Garpu, besar"]
[null,90011,"Sendok, kecil"]
[null,90012,"Sendok, besar"]
[null,90013,"Pisau mentega, kecil"]
[null,90014,"Pisau mentega, besar"]
[null,90015,"Taplak meja, 10x5"]
[null,90016,"Taplak meja, 8x5"]
[null,90017,"Taplak meja, 8x8"]
[null,90018,"Taplak meja, 6x6"]
[null,90019,"Taplak meja, 6x4"]
[null,90020,"Taplak meja, 4x4"]
[null,90021,"Taplak meja, bulat 10'"]
[null,90022,"Taplak meja, bulat 8'"]
[null,90023,"Taplak meja, bulat 6'"]