Spreadsheet: 217677d1362150320-creating-list-based-on-several-criteria-on-another-sheet-sal1check_new
Sheet: B4 raw data_not_pivot

 | O_code | O_Name | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | Total Geral
DENI JULIANA SARAGI | 1600934 | KIMIA FARMA - KF 81, AP | 1038000 | 519000 | 749000 | 2090000 | 270000 | 936000 |  |  |  |  |  |  |  | 5602000
DENI JULIANA SARAGI | 1601314 | HARAPAN IBU(MEDAN), RS | 3114000 |  | 2249000 |  | 5795500 |  | 6228000 |  | 5256000 |  |  |  |  | 22642500
DENI JULIANA SARAGI | 1601415 | MATERNA(MEDAN), RS |  | 606000 |  |  |  |  |  |  | 588000 |  |  |  | 978000 | 2172000
DENI JULIANA SARAGI | 1603196 | CUT MEUTIA INSTALASI FARMASI(LANGSA |  | 1554000 | 1503000 |  |  |  |  |  |  |  | 2232500 |  |  | 5289500
DENI JULIANA SARAGI | 1604754 | HERNA ( MEDAN ), RS |  |  |  |  |  |  |  | 7002000 | 1800000 | 1944000 |  |  |  | 10746000
DENI JULIANA SARAGI | 1607740 | RSKB ACCUPLAST ( MEDAN ) | 11844000 | 832500 | 0 | 2070000 | 25353000 |  | 6660000 | 3240000 | 8190000 | 3615000 | 4320000 | 1548000 | 3330000 | 71002500
DENI JULIANA SARAGI | 1607919 | TRIMITRA KARYA PRIMA MANDIRI, [NAME] ( |  |  |  |  |  |  | 3240000 |  |  |  |  |  |  | 3240000
DENI JULIANA SARAGI | 1608209 | KARYA MEDIKA UTAMA ( DELITUA ), [NAME] |  | 3240000 | 7776000 | 3240000 | 3240000 |  |  |  |  |  |  |  |  | 17496000
DENI JULIANA SARAGI | 1609790 | KLINIK DR [NAME] (MEDAN) |  |  |  |  |  |  |  |  |  | 2758000 |  | 1586000 | 720000 | 5064000
 | DENI JULIANA SARAGI Total |  | 15996000 | 6751500 | 12277000 | 7400000 | 34658500 | 936000 | 16128000 | 10242000 | 15834000 | 8317000 | 6552500 | 3134000 | 5028000 | 143254500
 | O_code | O_Name | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | Total Geral
HARLEN | 1600075 | KARYA UTAMA SEHAT SEJAHTERA, PT/ RS |  |  |  |  |  |  |  |  |  |  |  |  | 1220000 | 1220000 |  | 93846.15384615384
HARLEN | 1600373 | RUMAH SAKIT COLUMBIA ASIA MEDAN | 18735000 | 18305000 | 25360000 | 4970000 | 18930000 | 5295000 | 22295000 | 36735000 | 16025000 | 4970000 | 14830000 | 9355000 | 32975000 | 228780000 |  | 17598461.53846154
HARLEN | 1604576 | [NAME]), AP |  |  |  |  |  |  |  |  | 1355000 | 6000000 |  |  |  | 7355000 |  | 565769.2307692308
HARLEN | 1604743 | DR PIRNGADI (MEDAN), RS |  |  |  |  |  |  | 2710000 | 4065000 | 6925000 | 3550000 | 4110000 | 12055000 | 12970000 | 46385000 |  | 3568076.923076923
HARLEN | 1604908 | KARYA PRIMATAMA (MEDAN), [NAME] |  |  |  |  |  | 28635000 |  |  | 3005000 |  |  |  |  | 31640000 |  | 2433846.153846154
HARLEN | 1607708 | ANUGRAH SATOLOP MAHITTA ( MEDAN ), |  |  |  |  |  |  |  | 120000 | 120000 |  |  |  |  | 240000 |  | 18461.53846153846
HARLEN | 1608030 | ASNIDA BUMI PERSADA ( MEDAN ), [NAME] |  |  |  |  |  |  |  | 1765000 |  | 970000 |  |  | 3000000 | 5735000 |  | 441153.8461538461
HARLEN | 1608187 | PT.STELLA MANDIRI HUSADA |  |  |  |  |  |  |  |  |  |  |  |  | 2860000 | 2860000 |  | 220000
HARLEN | 1608209 | KARYA MEDIKA UTAMA ( DELITUA ), [NAME] |  | 2340000 | 2540000 | 4650000 |  | 755000 | 5165000 | 3005000 | 2110000 |  |  |  |  | 20565000 |  | 1581923.076923077
HARLEN | 1608677 | PT.KARYA [NAME] SEJAHTERA |  |  |  | 240000 |  |  |  |  |  | 600000 |  |  |  | 840000 |  | 64615.38461538462
HARLEN | 1608835 | INST CSSD (RSU DR PIRNGADI MEDAN) |  |  |  | 3235000 |  |  |  |  |  |  |  |  |  | 3235000 |  | 248846.1538461538
HARLEN | 1608835 | RSUD DR.PIRNGADI (MEDAN) |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 |  | 0
HARLEN | 1609059 | ATHIQA (MEDAN) CV |  |  |  | 3245000 |  |  |  |  |  |  |  |  |  | 3245000 |  | 249615.3846153846
HARLEN | 1609564 | CV.JOVI KARUNIA JAYA (MEDAN) |  |  |  |  |  |  |  | 4890000 | 120000 | 1630000 | -3120000 | 240000 | 1475000 | 5235000 |  | 402692.3076923077
HARLEN | 1609759 | PT.MUARA USAHA MANDIRI (B.ACEH) |  |  |  |  |  |  |  |  | 63450000 |  |  |  |  | 63450000 |  | 4880769.230769231
 | 1609875 | PT.LADANG MEDIKA (B.ACEH) |  |  |  |  |  |  |  |  |  |  |  | 66230000 | 40370000 | 106600000 |  | 8200000
 | HARLEN Total |  | 18735000 | 20645000 | 27900000 | 16340000 | 18930000 | 34685000 | 30170000 | 50580000 | 93110000 | 17720000 | 15820000 | 87880000 | 94870000 | 527385000 |  | 40568076.92307692