{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Data Prospek","Penjualan Diprakirakan ","Prakiraan Tertimbang Bulanan"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Data Prospek","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Nama Perusahaan"]
[null,"Pencatat Prospek Mendetail"]
[null,{"$f":"TODAY()","v":"2022-04-02"}]
[{"$nulls":8},{"$f":"Nama_Perusahaan","v":"Nama Perusahaan"},"RAHASIA"]
[null,"Nama Prospek","Kontak Prospek","Sumber \nProspek","Wilayah \nProspek","Jenis \nProspek","Kesempatan Potensial","Peluang \nPenjualan","Prakiraan \nTutup","Prakiraan \nTertimbang"]
[null,"A. Datum Corporation",{"$nulls":3},"Strategis",{"v":300000,"d":"Rp300,000.00"},{"v":0.9,"d":"90%"},"Januari",{"$f":"IFERROR(IF(DataProspek[[#This Row],[Peluang \nPenjualan]]<>\"\",DataProspek[[#This Row],[Peluang \nPenjualan]]*DataProspek[[#This Row],[Kesempatan Potensial]],\"\"),\"\")","v":{"v":270000,"d":"Rp270,000.00"}}]
[null,"Adventure Works",{"$nulls":3},"Strategis",{"v":200000,"d":"Rp200,000.00"},{"v":0.1,"d":"10%"},"Februari",{"$f":"IFERROR(IF(DataProspek[[#This Row],[Peluang \nPenjualan]]<>\"\",DataProspek[[#This Row],[Peluang \nPenjualan]]*DataProspek[[#This Row],[Kesempatan Potensial]],\"\"),\"\")","v":{"v":20000,"d":"Rp20,000.00"}}]
[null,"Alpine Ski House",{"$nulls":3},"Taktis",{"v":100000,"d":"Rp100,000.00"},{"v":0.2,"d":"20%"},"Maret",{"$f":"IFERROR(IF(DataProspek[[#This Row],[Peluang \nPenjualan]]<>\"\",DataProspek[[#This Row],[Peluang \nPenjualan]]*DataProspek[[#This Row],[Kesempatan Potensial]],\"\"),\"\")","v":{"v":20000,"d":"Rp20,000.00"}}]
[null,"Total",{"$nulls":4},{"$f":"SUBTOTAL(109,DataProspek[Kesempatan Potensial])","v":{"v":600000,"d":"Rp600,000.00"}},null,null,{"$f":"SUBTOTAL(109,DataProspek[Prakiraan \nTertimbang])","v":{"v":310000,"d":"Rp310,000.00"}}]

{"sheet":"Penjualan Diprakirakan ","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"merged":[[3,12,3,13]]}
[null,{"$f":"Nama_Perusahaan","v":"Nama Perusahaan"}]
[null,"Penjualan Diprakirakan"]
[null,{"$f":"TanggalPencatat","v":"2022-04-02"}]
[{"$nulls":11},{"$f":"Nama_Perusahaan","v":"Nama Perusahaan"},"RAHASIA"]
[null,"Nama prospek","Prakiraan \nJanuari","Prakiraan \nFebruari","Prakiraan \nMaret","Prakiraan \nApril","Prakiraan \nMei","Prakiraan \nJuni","Prakiraan Juli","Prakiraan \nAgustus","Prakiraan \nSeptember","Prakiraan \nOktober","Prakiraan \nNovember","Prakiraan \nDesember"]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":"A. Datum Corporation"},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":270000,"d":"Rp270,000"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":"Adventure Works"},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":20000,"d":"Rp20,000"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":"Alpine Ski House"},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":20000,"d":"Rp20,000"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":{"v":0,"d":"Rp0"}}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(DataProspek[[#This Row],[Nama Prospek]] <> \"\", ROW(PenjualanDiprakirakan[Nama prospek])<>EntriTerakhir),DataProspek[Nama Prospek], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]]= \"Januari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Februari\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Maret\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Juli\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(DataProspek[[#This Row],[Prakiraan \nTutup]] <>\"\",IF(DataProspek[[#This Row],[Prakiraan \nTutup]] = \"Prakiraan\",DataProspek[Prakiraan \nTertimbang],0),\"\"),\"\")","v":""}]
[null,"Total",{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nJanuari])","v":{"v":270000,"d":"Rp270,000"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nFebruari])","v":{"v":20000,"d":"Rp20,000"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nMaret])","v":{"v":20000,"d":"Rp20,000"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nApril])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nMei])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nJuni])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan Juli])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nAgustus])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nSeptember])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nOktober])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nNovember])","v":{"v":0,"d":"Rp0"}},{"$f":"SUBTOTAL(109,PenjualanDiprakirakan[Prakiraan \nDesember])","v":{"v":0,"d":"Rp0"}}]
[null,"Total Kumulatif",{"$f":"C20","v":{"v":270000,"d":"Rp270,000"}},{"$f":"C21+D20","v":{"v":290000,"d":"Rp290,000"}},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"},{"v":310000,"d":"Rp310,000"}]

{"sheet":"Prakiraan Tertimbang Bulanan","index":2,"n_rows":3,"n_cols":2,"rows_kept":3}
[null,{"$f":"Nama_Perusahaan","v":"Nama Perusahaan"}]
[null,"Prakiraan Tertimbang Bulanan"]
[null," "]