{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Pencatat Perbaikan Otomotif"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Pencatat Perbaikan Otomotif","index":0,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"PENCATAT PERBAIKAN OTOMOTIF"]
[null,"TOTAL KESELURUHAN",{"$f":"IFERROR(SUM(Perbaikan[JUMLAH]), \"\")","v":{"v":47515100,"d":"Rp47,515,100.00"}}]
[null,"TOTAL KENDARAAN 1",{"$f":"IFERROR(SUMIFS(Perbaikan[JUMLAH],Perbaikan[KENDARAAN],Nama_Kendaraan_1), \"\")","v":{"v":40321100,"d":"Rp40,321,100.00"}},{"$f":"\"NILAI \"&Nama_Kendaraan_1","v":"NILAI KENDARAAN 1"},{"v":140000000,"d":"Rp140,000,000.00"},{"$f":"Nama_Kendaraan_1","v":"KENDARAAN 1"}]
[null,"TOTAL KENDARAAN 2",{"$f":"IFERROR(SUMIFS(Perbaikan[JUMLAH],Perbaikan[KENDARAAN],Nama_Kendaraan_2), \"\")","v":{"v":7194000,"d":"Rp7,194,000.00"}},{"$f":" \"NILAI \"&Nama_Kendaraan_2","v":"NILAI KENDARAAN 2"},{"v":70000000,"d":"Rp70,000,000.00"},{"$f":"Nama_Kendaraan_2","v":"KENDARAAN 2"}]
[null,"TANGGAL","JUMLAH","KENDARAAN","TEMPAT","DESKRIPSI"]
[null,{"$f":"TODAY()-800","v":"2016-04-20"},{"v":6321100,"d":"Rp6,321,100.00"},"KENDARAAN 1","Dealer","Penggantian radiator"]
[null,{"$f":"TODAY()-270","v":"2017-10-02"},{"v":3898700,"d":"Rp3,898,700.00"},"KENDARAAN 2","Toko Ban","4 ban baru"]
[null,{"$f":"TODAY()-400","v":"2017-05-25"},{"v":34000000,"d":"Rp34,000,000.00"},"KENDARAAN 1","Bengkel Bodi Kendaraan","Perbaikan tabrakan"]
[null,{"$f":"TODAY()-90","v":"2018-03-31"},{"v":899900,"d":"Rp899,900.00"},"KENDARAAN 2","Toko Ban","Penyelarasan ban kendaraan"]
[null,{"$f":"TODAY()","v":"2018-06-29"},{"v":2395400,"d":"Rp2,395,400.00"},"KENDARAAN 2","Dealer","Pemeriksaan 100.000 mil dan perawatan rutin"]