{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Laporan","Database","db_customer"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Laporan","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Database","index":1,"n_rows":130,"n_cols":16,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["Company","Project Name","Customer No","Client Name","Penagihan/Pembayaran","Deskripsi","Invoice No","Date","Month","Year","Due Date","Days Outstanding","Status","Principal USD","Vat USD","Gross USD"]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011043,"2017-01-24",{"$f":"IFERROR(VLOOKUP(MONTH(H2),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"January"},{"$f":"IF(H2=\"\",\"\",YEAR(H2))","v":2017},{"$f":"H2+30","v":"2017-02-23"},null,null,677953.81242002256,{"$f":"N2*10%","v":67795.381242002259},{"$f":"SUM(N2:O2)","v":745749.1936620248}]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011062,"2017-02-14",{"$f":"IFERROR(VLOOKUP(MONTH(H3),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"February"},2017,"2017-03-16",null,null,944444.21476761624,{"$f":"N3*10%","v":94444.421476761636},{"$f":"SUM(N3:O3)","v":1038888.6362443778}]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011093,"2017-02-20",{"$f":"IFERROR(VLOOKUP(MONTH(H4),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"February"},2017,"2017-03-22",null,null,1589760.5187406298,158976.05187406298,1748736.5706146928]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011118,"2017-03-08",{"$f":"IFERROR(VLOOKUP(MONTH(H5),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,"2017-04-07",null,null,1784973.3614854747,178497.33614854747,1963470.6976340222]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011151,"2017-03-22",{"$f":"IFERROR(VLOOKUP(MONTH(H6),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,"2017-04-21",null,null,632486.67325546569,63248.667325546572,695735.34058101231]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011202,"2017-04-26",{"$f":"IFERROR(VLOOKUP(MONTH(H7),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"April"},2017,"2017-05-26",null,null,1412748.100510051,141274.8100510051,1554022.9105610561]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011221,"2017-05-17",{"$f":"IFERROR(VLOOKUP(MONTH(H8),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,"2017-06-16",null,null,482393.13849977404,48239.313849977407,530632.45234975149]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011222,"2017-05-17",{"$f":"IFERROR(VLOOKUP(MONTH(H9),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,"2017-06-16",null,null,1973387.0390872119,197338.70390872122,2170725.7429959332]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011240,"2017-05-26",{"$f":"IFERROR(VLOOKUP(MONTH(H10),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,"2017-06-25",null,null,1319078.9585027865,131907.89585027864,1450986.8543530651]
[12,"Jaksel",600190,"PT CDE","Penagihan","Listrik",17011246,"2017-06-09",{"$f":"IFERROR(VLOOKUP(MONTH(H11),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},2017,"2017-07-09",null,null,1213339.29,121333.929,1334673.219]
[12,"Jaksel",600190,"PT CDE","Penagihan","Gas",17011292,"2017-06-27",{"$f":"IFERROR(VLOOKUP(MONTH(H12),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},2017,"2017-07-27",null,null,1394665.82,139466.58200000002,1534132.402]
[12,"Jaksel",600190,"PT CDE","Penagihan","Gas",17011293,"2017-07-11",{"$f":"IFERROR(VLOOKUP(MONTH(H13),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,"2017-08-10",null,null,435767.84,43576.784000000007,479344.62400000001]
[12,"Jaksel",600190,"PT CDE","Penagihan","Gas",17011325,"2017-07-26",{"$f":"IFERROR(VLOOKUP(MONTH(H14),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,"2017-08-25",null,null,598364.42000000004,59836.44200000001,658200.86200000008]
[12,"Jaksel",600190,"PT CDE","Penagihan","Gas",17011344,"2017-08-08",{"$f":"IFERROR(VLOOKUP(MONTH(H15),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,"2017-09-07",null,null,1246470.6274186291,124647.06274186292,1371117.690160492]
[12,"Jaksel",600190,"PT CDE","Penagihan","Gas",17011392,"2017-08-23",{"$f":"IFERROR(VLOOKUP(MONTH(H16),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,"2017-09-22",null,null,1136861.2423878806,113686.12423878806,1250547.3666266687]
[12,"Jaksel",600190,"PT CDE","Penagihan","Air",17011430,"2017-09-25",{"$f":"IFERROR(VLOOKUP(MONTH(H17),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,"2017-10-25",null,null,1239898,123989.8,1363887.8]
[12,"Jaksel",600190,"PT CDE","Penagihan","Air",17011431,"2017-09-25",{"$f":"IFERROR(VLOOKUP(MONTH(H18),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,"2017-10-25",null,null,1437579,143757.9,1581336.9]
[12,"Jaksel",600190,"PT CDE","Penagihan","Air",17011468,"2017-10-17",{"$f":"IFERROR(VLOOKUP(MONTH(H19),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,"2017-11-16",null,null,2424151.89,242415.18900000001,2666567.0789999999]
[12,"Jaksel",600190,"PT CDE","Penagihan","Air",17011476,"2017-10-25",{"$f":"IFERROR(VLOOKUP(MONTH(H20),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,"2017-11-24",null,null,2836613.9033911079,283661.3903391108,3120275.2937302189]
[12,"Jaksel",600190,"PT CDE","Penagihan","Air",17011514,"2017-11-17",{"$f":"IFERROR(VLOOKUP(MONTH(H21),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,"2017-12-17",null,null,2757355.22,275735.52200000006,3033090.7420000001]
[12,"Jaksel",600190,"PT CDE","Penagihan","Air",17011521,"2017-11-28",{"$f":"IFERROR(VLOOKUP(MONTH(H22),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,"2017-12-28",null,null,3037439.81,null,3037439.81]
[12,"Tanggerang",600190,"Pt OPQ","Pembayaran",null,16010698,"2017-03-13",{"$f":"IFERROR(VLOOKUP(MONTH(H23),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,null,{"$f":"N23*10%","v":0},{"$f":"SUM(N23:O23)","v":0}]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011043,"2017-03-13",{"$f":"IFERROR(VLOOKUP(MONTH(H24),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,-677953.81,-67795.381000000008,-745749.19100000011]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011062,"2017-03-13",{"$f":"IFERROR(VLOOKUP(MONTH(H25),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,-66145.45,-6614.5450000000001,-72759.994999999995]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011062,"2017-03-20",{"$f":"IFERROR(VLOOKUP(MONTH(H26),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,-878298.76,-87829.876000000004,-966128.63600000006]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011093,"2017-03-20",{"$f":"IFERROR(VLOOKUP(MONTH(H27),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,-82952.31,-8295.2309999999998,-91247.540999999997]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011093,"2017-03-30",{"$f":"IFERROR(VLOOKUP(MONTH(H28),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,-735527.19,-73552.718999999997,-809079.90899999999]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011093,"2017-04-26",{"$f":"IFERROR(VLOOKUP(MONTH(H29),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"April"},2017,null,null,null,-684956.97,-68495.697,-753452.66700000002]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011093,"2017-05-02",{"$f":"IFERROR(VLOOKUP(MONTH(H30),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-37766.94,-3776.6940000000004,-41543.634000000005]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011093,"2017-05-12",{"$f":"IFERROR(VLOOKUP(MONTH(H31),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-48557.1,-4855.71,-53412.81]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011118,"2017-05-12",{"$f":"IFERROR(VLOOKUP(MONTH(H32),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-323613.63,-32361.363000000001,-355974.99300000002]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011118,"2017-05-19",{"$f":"IFERROR(VLOOKUP(MONTH(H33),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-1144995.45,-114499.545,-1259494.9949999999]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011118,"2017-05-30",{"$f":"IFERROR(VLOOKUP(MONTH(H34),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},{"$f":"IF(H34=\"\",\"\",YEAR(H34))","v":2017},null,null,null,-316364.28000000003,-31636.428000000004,-348000.70800000004]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011151,"2017-05-30",{"$f":"IFERROR(VLOOKUP(MONTH(H35),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-632486.67000000004,-63248.667000000009,-695735.33700000006]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011202,"2017-05-30",{"$f":"IFERROR(VLOOKUP(MONTH(H36),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-692310.31,-69231.031000000003,-761541.34100000001]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011202,"2017-06-06",{"$f":"IFERROR(VLOOKUP(MONTH(H37),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},2017,null,null,null,-390227.86,-39022.786,-429250.64600000001]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011202,"2017-07-14",{"$f":"IFERROR(VLOOKUP(MONTH(H38),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,-330209.91999999998,-33020.991999999998,-363230.91200000001]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011221,"2017-07-14",{"$f":"IFERROR(VLOOKUP(MONTH(H39),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,-3169.58,-316.95800000000003,-3486.538]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011221,"2017-07-24",{"$f":"IFERROR(VLOOKUP(MONTH(H40),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,-479223.55,-47922.355000000003,-527145.90500000003]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011222,"2017-07-24",{"$f":"IFERROR(VLOOKUP(MONTH(H41),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,-683813.78,-68381.378000000012,-752195.15800000005]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011222,"2017-08-03",{"$f":"IFERROR(VLOOKUP(MONTH(H42),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,-1289573.26,-128957.326,-1418530.5860000001]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011246,"2017-08-03",{"$f":"IFERROR(VLOOKUP(MONTH(H43),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,-37000.199999999997,-3700.02,-40700.219999999994]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011246,"2017-08-18",{"$f":"IFERROR(VLOOKUP(MONTH(H44),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,-108585.22,-10858.522000000001,-119443.742]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011246,"2017-09-06",{"$f":"IFERROR(VLOOKUP(MONTH(H45),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,-1067753.8700000001,-106775.38700000002,-1174529.2570000002]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011292,"2017-09-06",{"$f":"IFERROR(VLOOKUP(MONTH(H46),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,-363360.67,-36336.067000000003,-399696.73699999996]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011292,"2017-09-20",{"$f":"IFERROR(VLOOKUP(MONTH(H47),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,-200698.62,-20069.862000000001,-220768.48199999999]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011292,"2017-09-20",{"$f":"IFERROR(VLOOKUP(MONTH(H48),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,830606.53,83060.653000000006,913667.18300000008]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011293,"2017-09-20",{"$f":"IFERROR(VLOOKUP(MONTH(H49),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,-65326.81,-6532.6810000000005,-71859.490999999995]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011293,"2017-10-04",{"$f":"IFERROR(VLOOKUP(MONTH(H50),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-370441.03,-37044.103000000003,-407485.13300000003]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011325,"2017-10-04",{"$f":"IFERROR(VLOOKUP(MONTH(H51),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-598364.42000000004,-59836.44200000001,-658200.86200000008]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011344,"2017-10-04",{"$f":"IFERROR(VLOOKUP(MONTH(H52),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-225732.48000000001,-22573.248000000003,-248305.728]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011344,"2017-10-20",{"$f":"IFERROR(VLOOKUP(MONTH(H53),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-417607.25,-41760.725000000006,-459367.97499999998]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011344,"2017-10-25",{"$f":"IFERROR(VLOOKUP(MONTH(H54),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-603130.9,-60313.090000000004,-663443.99]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011329,"2017-10-25",{"$f":"IFERROR(VLOOKUP(MONTH(H55),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-688108.72,-68810.872000000003,-756919.59199999995]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011329,"2017-11-01",{"$f":"IFERROR(VLOOKUP(MONTH(H56),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,-448752.52,-44875.252000000008,-493627.772]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011430,"2017-11-10",{"$f":"IFERROR(VLOOKUP(MONTH(H57),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,-476207.81,-47620.781000000003,-523828.59100000001]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011430,"2017-11-10",{"$f":"IFERROR(VLOOKUP(MONTH(H58),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,-763690,-76369,-840059]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011431,"2017-11-10",{"$f":"IFERROR(VLOOKUP(MONTH(H59),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,-295156.3,-29515.63,-324671.93]
[12,"Jaksel",600190,"PT CDE","Pembayaran",null,17011431,"2017-11-16",{"$f":"IFERROR(VLOOKUP(MONTH(H60),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,-817568.98,-81756.898000000001,-899325.87800000003]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011008,"2017-01-13",{"$f":"IFERROR(VLOOKUP(MONTH(H61),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"January"},2017,null,null,null,951720.05,{"$f":"N61*10%","v":95172.005000000005},{"$f":"SUM(N61:O61)","v":1046892.0550000001}]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011064,"2017-02-14",{"$f":"IFERROR(VLOOKUP(MONTH(H62),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"February"},2017,null,null,null,3686172.43,368617.24300000002,4054789.6730000004]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011125,"2017-03-13",{"$f":"IFERROR(VLOOKUP(MONTH(H63),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,4535185.3,453518.53,4988703.83]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011169,"2017-04-12",{"$f":"IFERROR(VLOOKUP(MONTH(H64),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"April"},2017,null,null,null,4596474.2,459647.42000000004,5056121.62]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011209,"2017-05-12",{"$f":"IFERROR(VLOOKUP(MONTH(H65),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,2512178.2799999998,251217.82799999998,2763396.108]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011253,"2017-06-12",{"$f":"IFERROR(VLOOKUP(MONTH(H66),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},{"$f":"IF(H66=\"\",\"\",YEAR(H66))","v":2017},null,null,null,2228784.2999999998,222878.43,2451662.73]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011306,"2017-07-19",{"$f":"IFERROR(VLOOKUP(MONTH(H67),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,1560269,156026.9,1716295.9]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011357,"2017-08-11",{"$f":"IFERROR(VLOOKUP(MONTH(H68),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,3226308,322630.80000000005,3548938.8]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011406,"2017-09-12",{"$f":"IFERROR(VLOOKUP(MONTH(H69),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,4175429,417542.9,4592971.9000000004]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011450,"2017-10-12",{"$f":"IFERROR(VLOOKUP(MONTH(H70),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,6507584.0599999996,650758.40599999996,7158342.466]
[12,"Jakut",138111,"PT HIJ","Penagihan","Iuran",17011500,"2017-11-13",{"$f":"IFERROR(VLOOKUP(MONTH(H71),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,8738597,873859.70000000007,9612456.6999999993]
[12,"Jatim",138113,"PT KLM","Penagihan","Iuran",17011007,"2017-01-13",{"$f":"IFERROR(VLOOKUP(MONTH(H72),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"January"},2017,null,null,null,4754878.5199999996,{"$f":"N72*10%","v":475487.85199999996},{"$f":"SUM(N72:O72)","v":5230366.3719999995}]
[12,"Jatim",138113,"PT KLM","Penagihan","Iuran",17011065,"2017-02-14",{"$f":"IFERROR(VLOOKUP(MONTH(H73),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"February"},2017,null,null,null,3206479.66,320647.96600000001,3527127.6260000002]
[12,"Jatim",138113,"PT KLM","Penagihan","Iuran",17011126,"2017-03-13",{"$f":"IFERROR(VLOOKUP(MONTH(H74),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,3741821.25,374182.125,4116003.375]
[12,"Jatim",138113,"PT KLM","Penagihan","Iuran",17011171,"2017-04-12",{"$f":"IFERROR(VLOOKUP(MONTH(H75),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"April"},2017,null,null,null,2498604.12,249860.41200000001,2748464.5320000001]
[12,"Jatim",138113,"PT KLM","Penagihan","Bunga",17011210,"2017-05-12",{"$f":"IFERROR(VLOOKUP(MONTH(H76),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,2366177.77,236617.777,2602795.5470000003]
[12,"Jatim",138113,"PT KLM","Penagihan","Bunga",17011252,"2017-06-12",{"$f":"IFERROR(VLOOKUP(MONTH(H77),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},2017,null,null,null,5182498.45,518249.84500000003,5700748.2949999999]
[12,"Jatim",138113,"PT KLM","Penagihan","Bunga",17011305,"2017-07-14",{"$f":"IFERROR(VLOOKUP(MONTH(H78),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,8695372,869537.20000000007,9564909.1999999993]
[12,"Jatim",138113,"PT KLM","Penagihan","Bunga",17011356,"2017-08-11",{"$f":"IFERROR(VLOOKUP(MONTH(H79),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,7908899,790889.9,8699788.9000000004]
[12,"Jatim",138113,"PT KLM","Penagihan","Bunga",17011407,"2017-09-12",{"$f":"IFERROR(VLOOKUP(MONTH(H80),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,8437985,843798.5,9281783.5]
[12,"Jatim",138113,"PT KLM","Penagihan","Bunga",17011451,"2017-10-12",{"$f":"IFERROR(VLOOKUP(MONTH(H81),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,7614923.6299999999,761492.36300000001,8376415.9929999998]
[12,"Jatim",138113,"PT KLM","Penagihan","Bunga",17011501,"2017-11-13",{"$f":"IFERROR(VLOOKUP(MONTH(H82),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,6447087,644708.70000000007,7091795.7000000002]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011007,"2017-01-31",{"$f":"IFERROR(VLOOKUP(MONTH(H83),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"January"},2017,null,null,null,-4754879,-475487.9,-5230366.9000000004]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011065,"2017-02-28",{"$f":"IFERROR(VLOOKUP(MONTH(H84),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"February"},2017,null,null,null,-3206479.66,{"$f":"N84*10%","v":-320647.96600000001},{"$f":"SUM(N84:O84)","v":-3527127.6260000002}]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011126,"2017-03-31",{"$f":"IFERROR(VLOOKUP(MONTH(H85),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,-3741821.25,-374182.125,-4116003.375]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011171,"2017-04-30",{"$f":"IFERROR(VLOOKUP(MONTH(H86),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"April"},2017,null,null,null,-2498604.12,-249860.41200000001,-2748464.5320000001]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011210,"2017-05-31",{"$f":"IFERROR(VLOOKUP(MONTH(H87),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-2366177.77,-236617.777,-2602795.5470000003]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011253,"2017-06-30",{"$f":"IFERROR(VLOOKUP(MONTH(H88),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},2017,null,null,null,-2228784.2999999998,{"$f":"N88*10%","v":-222878.43},{"$f":"SUM(N88:O88)","v":-2451662.73}]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011252,"2017-06-30",{"$f":"IFERROR(VLOOKUP(MONTH(H89),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},2017,null,null,null,-4413070.3490000004,-518249.84499999997,-4931320.1940000001]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011306,"2017-07-31",{"$f":"IFERROR(VLOOKUP(MONTH(H90),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,-1560269,{"$f":"N90*10%","v":-156026.9},{"$f":"SUM(N90:O90)","v":-1716295.9}]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011305,"2017-07-31",{"$f":"IFERROR(VLOOKUP(MONTH(H91),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,-7007532.3299999991,-869537.2,-7877069.5299999993]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011357,"2017-08-31",{"$f":"IFERROR(VLOOKUP(MONTH(H92),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,-3226308,{"$f":"N92*10%","v":-322630.80000000005},{"$f":"SUM(N92:O92)","v":-3548938.8}]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011356,"2017-08-31",{"$f":"IFERROR(VLOOKUP(MONTH(H93),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,-7446258.2247754596,-790889.9,-8237148.12477546]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011406,"2017-09-30",{"$f":"IFERROR(VLOOKUP(MONTH(H94),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,-3171543.5075692399,-417542.9,-3589086.4075692398]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011407,"2017-09-30",{"$f":"IFERROR(VLOOKUP(MONTH(H95),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,-8437985,{"$f":"-8437985*10%","v":-843798.5},{"$f":"SUM(N95:O95)","v":-9281783.5}]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011450,"2017-10-30",{"$f":"IFERROR(VLOOKUP(MONTH(H96),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-6507584.0599999996,{"$f":"N96*10%","v":-650758.40599999996},{"$f":"SUM(N96:O96)","v":-7158342.466}]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011451,"2017-10-30",{"$f":"IFERROR(VLOOKUP(MONTH(H97),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-7614923.6299999999,{"$f":"N97*10%","v":-761492.36300000001},{"$f":"SUM(N97:O97)","v":-8376415.9929999998}]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011252,"2017-10-30",{"$f":"IFERROR(VLOOKUP(MONTH(H98),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},{"$f":"IF(H98=\"\",\"\",YEAR(H98))","v":2017},null,null,null,-365616.78352867498,null,{"$f":"SUM(N98:O98)","v":-365616.78352867498}]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011008,"2017-01-31",{"$f":"IFERROR(VLOOKUP(MONTH(H99),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"January"},2017,null,null,null,-951720.05,{"$f":"N99*10%","v":-95172.005000000005},{"$f":"SUM(N99:O99)","v":-1046892.0550000001}]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011064,"2017-02-28",{"$f":"IFERROR(VLOOKUP(MONTH(H100),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"February"},2017,null,null,null,-3686172.43,-368617.24300000002,{"$f":"SUM(N100:O100)","v":-4054789.6730000004}]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011125,"2017-03-31",{"$f":"IFERROR(VLOOKUP(MONTH(H101),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,-4535185.3,-453518.53,-4988703.83]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011169,"2017-04-30",{"$f":"IFERROR(VLOOKUP(MONTH(H102),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"April"},2017,null,null,null,-4596474.2,-459647.42000000004,-5056121.62]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011209,"2017-05-31",{"$f":"IFERROR(VLOOKUP(MONTH(H103),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-2512178.2799999998,-251217.82799999998,{"$f":"SUM(N103:O103)","v":-2763396.108}]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011406,"2017-10-02",{"$f":"IFERROR(VLOOKUP(MONTH(H104),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-1003885.4924307599,null,-1003885.4924307599]
[12,"Bandung",1,"PT ABC","Penagihan","Bunga",17011006,"2017-01-13",{"$f":"IFERROR(VLOOKUP(MONTH(H105),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"January"},2017,null,null,null,504014.63,{"$f":"N105*10%","v":50401.463000000003},{"$f":"SUM(N105:O105)","v":554416.09299999999}]
[12,"Bandung",1,"PT ABC","Penagihan","Bunga",17011091,"2017-02-17",{"$f":"IFERROR(VLOOKUP(MONTH(H106),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"February"},2017,null,null,null,1085345.0882308846,{"$f":"N106*10%","v":108534.50882308847},{"$f":"SUM(N106:O106)","v":1193879.597053973}]
[12,"Bandung",1,"PT ABC","Penagihan","Bunga",17011127,"2017-03-13",{"$f":"IFERROR(VLOOKUP(MONTH(H107),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,1567354.86,156735.486,1724090.3460000001]
[12,"Bandung",1,"PT ABC","Penagihan","Bunga",17011175,"2017-04-13",{"$f":"IFERROR(VLOOKUP(MONTH(H108),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"April"},2017,null,null,null,2905706.6886438644,290570.66886438645,3196277.357508251]
[12,"Bandung",1,"PT ABC","Penagihan","Listrik",17011203,"2017-05-12",{"$f":"IFERROR(VLOOKUP(MONTH(H109),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,3281024.6,328102.46000000002,3609127.06]
[12,"Bandung",1,"PT ABC","Penagihan","Listrik",17011251,"2017-06-12",{"$f":"IFERROR(VLOOKUP(MONTH(H110),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},2017,null,null,null,2941369.11,294136.91100000002,3235506.0209999997]
[12,"Bandung",1,"PT ABC","Penagihan","Listrik",17011304,"2017-07-14",{"$f":"IFERROR(VLOOKUP(MONTH(H111),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,2351154,235115.40000000002,2586269.4]
[12,"Bandung",1,"PT ABC","Penagihan","Listrik",17011345,"2017-08-09",{"$f":"IFERROR(VLOOKUP(MONTH(H112),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,2718132,271813.2,2989945.2]
[12,"Bandung",1,"PT ABC","Penagihan","Listrik",17011411,"2017-09-14",{"$f":"IFERROR(VLOOKUP(MONTH(H113),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,2869189,286918.90000000002,3156107.9]
[12,"Bandung",1,"PT ABC","Penagihan","Listrik",17011442,"2017-10-11",{"$f":"IFERROR(VLOOKUP(MONTH(H114),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,3504361,350436.10000000003,3854797.1]
[12,"Bandung",1,"PT ABC","Penagihan","Listrik",17011495,"2017-11-13",{"$f":"IFERROR(VLOOKUP(MONTH(H115),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,3387941.82,338794.18200000003,3726736.0019999999]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011006,"2017-01-31",{"$f":"IFERROR(VLOOKUP(MONTH(H116),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"January"},2017,null,null,null,-504014.63,{"$f":"N116*10%","v":-50401.463000000003},{"$f":"SUM(N116:O116)","v":-554416.09299999999}]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011091,"2017-02-28",{"$f":"IFERROR(VLOOKUP(MONTH(H117),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"February"},2017,null,null,null,-1085345.08823088,-108534.50882308801,{"$f":"SUM(N117:O117)","v":-1193879.5970539679}]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011127,"2017-03-31",{"$f":"IFERROR(VLOOKUP(MONTH(H118),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"March"},2017,null,null,null,-1567354.86,-156735.486,-1724090.3460000001]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011175,"2017-04-30",{"$f":"IFERROR(VLOOKUP(MONTH(H119),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"April"},2017,null,null,null,-2905706.6886438602,-290570.66886438604,-3196277.3575082463]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011203,"2017-05-31",{"$f":"IFERROR(VLOOKUP(MONTH(H120),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"May"},2017,null,null,null,-3281024.6,-328102.46000000002,-3609127.06]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011251,"2017-06-30",{"$f":"IFERROR(VLOOKUP(MONTH(H121),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"June"},2017,null,null,null,-2941369.11,-294136.91100000002,-3235506.0209999997]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011304,"2017-07-31",{"$f":"IFERROR(VLOOKUP(MONTH(H122),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"July"},2017,null,null,null,-2351154,-235115.40000000002,-2586269.4]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011345,"2017-08-30",{"$f":"IFERROR(VLOOKUP(MONTH(H123),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"August"},2017,null,null,null,-2718132,-271813.2,-2989945.2]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011411,"2017-09-29",{"$f":"IFERROR(VLOOKUP(MONTH(H124),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"September"},2017,null,null,null,-2869189,-286918.90000000002,-3156107.9]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011442,"2017-10-31",{"$f":"IFERROR(VLOOKUP(MONTH(H125),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"October"},2017,null,null,null,-3504361,-350436.10000000003,-3854797.1]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011252,"2017-11-30",{"$f":"IFERROR(VLOOKUP(MONTH(H126),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},2017,null,null,null,-403811.32,null,-403811.32]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011501,"2017-11-30",{"$f":"IFERROR(VLOOKUP(MONTH(H127),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},{"$f":"IF(H127=\"\",\"\",YEAR(H127))","v":2017},null,null,null,-6447087,{"$f":"N127*10%","v":-644708.70000000007},-7091795.7000000002]
[12,"Jatim",138113,"PT KLM","Pembayaran",null,17011305,"2017-11-30",{"$f":"IFERROR(VLOOKUP(MONTH(H128),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},{"$f":"IF(H128=\"\",\"\",YEAR(H128))","v":2017},null,null,null,-425828.61,null,-425828.61]
[12,"Jakut",138111,"PT HIJ","Pembayaran",null,17011500,"2017-11-30",{"$f":"IFERROR(VLOOKUP(MONTH(H129),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},{"$f":"IF(H129=\"\",\"\",YEAR(H129))","v":2017},null,null,null,-8738597,{"$f":"N129*10%","v":-873859.70000000007},-9612456.6999999993]
[12,"Bandung",1,"PT ABC","Pembayaran",null,17011495,"2017-11-30",{"$f":"IFERROR(VLOOKUP(MONTH(H130),db_customer!$A$18:$B$29,2,FALSE),\"\")","v":"November"},{"$f":"IF(H130=\"\",\"\",YEAR(H130))","v":2017},null,null,null,-3387941.82,{"$f":"N130*10%","v":-338794.18200000003},-3726736.0019999999]

{"sheet":"db_customer","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Job No","Project Name","Customer No","Client Name","Group"]
[515035,"Hanoman West Coal Mine",600190,"PT CLS","CLS"]
[515036,"Wahana West Coal Mine",387573,"PT WBM","BAYAN"]
[515033,"CLS Plant Hire Agreement",600190,"PT CLS","CLS"]
[515034,"CLS Management Agreement",600190,"PT CLS","CLS"]
[515030,"TCI Satui Interim Works",519949,"PT ARUTMIN","ARUTMIN"]
[513086,"Satui Mine Project",18290,"PT ARUTMIN","ARUTMIN"]
[513087,"Senakin Mine Project",18290,"PT ARUTMIN","ARUTMIN"]
[515001,"KPC Mining Services",18307,"PT KPC","KPC"]
[515021,"TSA - Mining Melak",138111,"PT TSA","BAYAN"]
[515023,"FKP - Mining Melak",138113,"PT FKP","BAYAN"]
[515038,"GBU Coal Mine Project",737777,"PT GBU","GBU"]
[515039,"MSJ Coal Mine Project",388030,"PT MSJ","MSJ"]
[]
[]
[1,"January"]
[2,"February"]
[3,"March"]
[4,"April"]
[5,"May"]
[6,"June"]
[7,"July"]
[8,"August"]
[9,"September"]
[10,"October"]
[11,"November"]
[12,"December"]