{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Laporan Penjualan Produk","Data Riwayat","Daftar Harga","Pivot Titik Harga","Pivot Tren Penjualan"],"not_rendered":{"charts":2,"defined_names":6,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Laporan Penjualan Produk","index":0,"n_rows":20,"n_cols":2,"rows_kept":20}
[null,"Laporan Penjualan Produk"]
{"$rows_empty":18}
[null,"Produk"]

{"sheet":"Data Riwayat","index":1,"n_rows":33,"n_cols":10,"rows_kept":33}
[null,"Riwayat Daftar Harga Produk & Penjualan"]
[]
[null,"ID Produk","Nama Produk","Tanggal Harga","Harga Eceran Per Unit","Harga Grosir Per Unit*","Unit Terjual (eceran)","Unit Terjual (Grosir)","Total Penjualan (#)","Total Penjualan (Rp)"]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Celana Pendek"},"2012-01-01",20,{"v":20,"d":"Rp20"},629,{"v":1254,"d":"1,254"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1883,"d":"1,883"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":37660,"d":"Rp37,660"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Kemeja"},"2012-01-01",88,{"v":54,"d":"Rp54"},734,{"v":1427,"d":"1,427"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2161,"d":"2,161"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":141650,"d":"Rp141,650"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Sendal"},"2012-01-01",70,{"v":44,"d":"Rp44"},744,{"v":1043,"d":"1,043"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1787,"d":"1,787"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":97972,"d":"Rp97,972"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Payung"},"2012-01-01",63,{"v":44,"d":"Rp44"},681,{"v":1523,"d":"1,523"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2204,"d":"2,204"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":109915,"d":"Rp109,915"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Botol air"},"2012-01-01",35,{"v":27,"d":"Rp27"},602,{"v":1822,"d":"1,822"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2424,"d":"2,424"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":70264,"d":"Rp70,264"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Kemeja"},"2012-02-01",55,{"v":44,"d":"Rp44"},678,{"v":1515,"d":"1,515"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2193,"d":"2,193"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":103950,"d":"Rp103,950"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Sendal"},"2012-02-01",83,{"v":54,"d":"Rp54"},753,{"v":1005,"d":"1,005"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1758,"d":"1,758"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":116769,"d":"Rp116,769"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Payung"},"2012-02-01",34,{"v":34,"d":"Rp34"},986,{"v":1069,"d":"1,069"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2055,"d":"2,055"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":69870,"d":"Rp69,870"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Botol air"},"2012-02-01",35,{"v":25,"d":"Rp25"},848,{"v":1211,"d":"1,211"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2059,"d":"2,059"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":59955,"d":"Rp59,955"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Celana Pendek"},"2012-02-01",41,{"v":38,"d":"Rp38"},980,{"v":1330,"d":"1,330"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2310,"d":"2,310"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":90720,"d":"Rp90,720"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Kemeja"},"2012-02-29",27,{"v":18,"d":"Rp18"},533,{"v":1936,"d":"1,936"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2469,"d":"2,469"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":49239,"d":"Rp49,239"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Sendal"},"2012-02-29",38,{"v":28,"d":"Rp28"},952,{"v":1512,"d":"1,512"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2464,"d":"2,464"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":78512,"d":"Rp78,512"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Payung"},"2012-02-29",92,{"v":92,"d":"Rp92"},956,{"v":1266,"d":"1,266"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2222,"d":"2,222"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":204424,"d":"Rp204,424"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Botol air"},"2012-02-29",43,{"v":36,"d":"Rp36"},952,{"v":1390,"d":"1,390"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2342,"d":"2,342"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":90976,"d":"Rp90,976"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Celana Pendek"},"2012-02-29",98,{"v":73,"d":"Rp73"},530,{"v":1452,"d":"1,452"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1982,"d":"1,982"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":157936,"d":"Rp157,936"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Kemeja"},"2012-03-31",38,{"v":28,"d":"Rp28"},973,{"v":1415,"d":"1,415"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2388,"d":"2,388"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":76594,"d":"Rp76,594"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Sendal"},"2012-03-31",50,{"v":36,"d":"Rp36"},672,{"v":1105,"d":"1,105"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1777,"d":"1,777"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":73380,"d":"Rp73,380"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Payung"},"2012-03-31",24,{"v":23,"d":"Rp23"},769,{"v":1629,"d":"1,629"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2398,"d":"2,398"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":55923,"d":"Rp55,923"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Botol air"},"2012-03-31",72,{"v":57,"d":"Rp57"},985,{"v":1848,"d":"1,848"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2833,"d":"2,833"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":176256,"d":"Rp176,256"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Celana Pendek"},"2012-03-31",85,{"v":43,"d":"Rp43"},721,{"v":1426,"d":"1,426"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2147,"d":"2,147"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":122603,"d":"Rp122,603"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Kemeja"},"2012-04-30",91,{"v":65,"d":"Rp65"},603,{"v":1226,"d":"1,226"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1829,"d":"1,829"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":134563,"d":"Rp134,563"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Sendal"},"2012-04-30",91,{"v":55,"d":"Rp55"},892,{"v":1823,"d":"1,823"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2715,"d":"2,715"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":181437,"d":"Rp181,437"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Payung"},"2012-04-30",42,{"v":42,"d":"Rp42"},611,{"v":1181,"d":"1,181"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1792,"d":"1,792"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":75264,"d":"Rp75,264"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Botol air"},"2012-04-30",85,{"v":43,"d":"Rp43"},530,{"v":1039,"d":"1,039"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1569,"d":"1,569"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":89727,"d":"Rp89,727"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Celana Pendek"},"2012-04-30",82,{"v":71,"d":"Rp71"},716,{"v":1249,"d":"1,249"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":1965,"d":"1,965"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":147391,"d":"Rp147,391"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Kemeja"},"2012-05-14",34,{"v":31,"d":"Rp31"},850,{"v":1548,"d":"1,548"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2398,"d":"2,398"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":76888,"d":"Rp76,888"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Sendal"},"2012-05-14",64,{"v":40,"d":"Rp40"},876,{"v":1663,"d":"1,663"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2539,"d":"2,539"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":122584,"d":"Rp122,584"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Payung"},"2012-05-14",33,{"v":30,"d":"Rp30"},881,{"v":1149,"d":"1,149"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2030,"d":"2,030"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":63543,"d":"Rp63,543"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Botol air"},"2012-05-14",29,{"v":27,"d":"Rp27"},802,{"v":1548,"d":"1,548"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2350,"d":"2,350"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":65054,"d":"Rp65,054"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[ID Produk]]<>\"\",VLOOKUP(tblSales[ID Produk],tblProducts[[ID Produk]:[Nama]],2,FALSE),\"\"),\"ID Produk Tidak Diketahui\")","v":"Celana Pendek"},"2013-12-11",24,{"v":15,"d":"Rp15"},824,{"v":1994,"d":"1,994"},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]","v":{"v":2818,"d":"2,818"}},{"$f":"tblSales[[#This Row],[Unit Terjual (eceran)]]*tblSales[[#This Row],[Harga Eceran Per Unit]]+tblSales[[#This Row],[Unit Terjual (Grosir)]]*tblSales[[#This Row],[Harga Grosir Per Unit*]]","v":{"v":49686,"d":"Rp49,686"}}]

{"sheet":"Daftar Harga","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[15,1,15,5]]}
[null,"Daftar Harga Produk"]
[]
[null,"Adventure Works"]
[null,"23456 Maple Street"]
[null,"Springfield, CA 77503"]
[null,"Phone: (425) 555-0150"]
[null,"FAKS: (425) 555-0152"]
[null,"www.adventure-works.com",{"$nulls":3},"Terakhir diperbarui 15/8/2013"]
[]
[null,"ID Produk","Nama","Deskripsi","Harga Eceran Per Unit","Harga Grosir Per Unit*"]
[null,1,"Kemeja","Tetap rasakan kesejukan di musim panas dengan kemeja",{"v":22,"d":"Rp22"},{"v":15,"d":"Rp15"}]
[null,2,"Sendal","Pakailah sendal dengan sol karet tahan lama dan berjalanlah di atas pasir yang paling panas dengan nyaman.",{"v":10,"d":"Rp10"},{"v":6,"d":"Rp6"}]
[null,3,"Payung","Berlindunglah dari terik sinar matahari di bawah payung pantai besar kami yang memblokir 96% sinar UV yang berbahaya.",{"v":30,"d":"Rp30"},{"v":20,"d":"Rp20"}]
[null,4,"Botol air","Jangan biarkan diri Anda dehidrasi dengan air dengan suhu sempurna dari botol air insulasi kami.",{"v":7,"d":"Rp7"},{"v":5,"d":"Rp5"}]
[null,5,"Celana Pendek","Keluar dari air lalu melangkahlah langsung ke dalam mobil dalam balutan celana pendek nilon yang mengering dengan super cepat.",{"v":15,"d":"Rp15"},{"v":8,"d":"Rp8"}]
[]
[{"$nulls":5},"Hubungi kami untuk item yang tidak ada dalam daftar."]
[{"$nulls":5},"*Harga grosir berlaku untuk pembelian sebanyak 12 unit atau lebih."]

{"sheet":"Pivot Titik Harga","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"hidden":true,"merged":[[1,1,1,3]]}
[null,"PivotTable Titik Harga"]
[null,"Lembar ini harus tetap tersembunyi. Setiap perubahan yang dibuat pada PivotTable di bawah ini bisa menyebabkan kesalahan data pada Laporan Penjualan Produk. "]
[null,"Produk yang Dipilih:",{"$f":"IF(LEN(B5),B5,\"None\")","v":"Sendal"}]
[null,"Nama Produk","Harga Eceran Per Unit","Jumlah dari Total Penjualan (#)"]
[null,"Sendal",{"v":38,"d":"Rp38"},2464]
[null,null,{"v":50,"d":"Rp50"},1777]
[null,null,{"v":64,"d":"Rp64"},2539]
[null,null,{"v":70,"d":"Rp70"},1787]
[null,null,{"v":83,"d":"Rp83"},1758]
[null,null,{"v":91,"d":"Rp91"},2715]

{"sheet":"Pivot Tren Penjualan","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"hidden":true,"merged":[[1,1,1,3]]}
[null,"PivotTable Tren Penjualan"]
[null,"Lembar ini harus tetap tersembunyi. Setiap perubahan yang dibuat pada PivotTable di bawah ini bisa menyebabkan kesalahan data pada Laporan Penjualan Produk. "]
[null,"Jumlah dari Total Penjualan (#)","Nama Produk"]
[null,"Tanggal Harga","Sendal"]
[null,"Jan",1787]
[null,"Feb",4222]
[null,"Mar",1777]
[null,"Apr",2715]
[null,"May",2539]