Pesawat Hercules jatuh di Medan, ikut berduka

Seiring dengan kejadian jatuhnya pesawat Hercules TNI AU C130 di medan yang mengakibatkan jatuhnya korban jiwa di bulan suci ramadhan ini, maka perkenankan saya Hery Purnama mengucapkan Turut berduka cita dan mendoakan agar para korban jiwa diberi tempat yang terbaik di sisinya dan dihapuskan dosa dosanya, serta untuk keluarga yang ditinggalkan diberikan ketabahan dan keikhlasan. AMIN ya Allah.

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Training Ms. PROJECT di PT. DENKO ENGINEERING Bekasi

Inhouse training Project Management Methodology with MS. PROJECT di PT.DENKO bekasi

Semoga bermanfaat,
HERY PURNAMA
INHOUSE TRAINER

Training Android di PT. KRA Balikpapan

Inhouse training Mobile Apps. Development for Android di PT.KOMATSU REMANUFACTURING ASIA Balikpapan.

Semoga bermanfaat,
HERY PURNAMA
INHOUSE TRAINER

Training Android di hotel bandung

Kegiatan mengajar Android mobile apps. Development di hotel malaka bandung

Makan malam di nelayan seafood restaurant medan

Jamuan Dinner penutupan kelas inhouse training MS Project di PT. DUNGO REKSA MEDAN , makan malam di nelayan seafood medan

Training autocad 2D/3D di angkasa pura

Inhouse training autocad 2D/3D di PT. Angkasa Pura II bandara soekarno hatta.

Semoga bermanfaat,
HERY PURNAMA
INHOUSE TRAINER

Training Excel VBA Macro batch 3 , KPUC Samarinda

Inhouse training excel vba macro at Kayan Putra Utama Coal Samarinda , batch 3.

Semoga bermanfaat,
HERY PURNAMA
INHOUSE TRAINER

Training MS Project at PT. HUTAMA KARYA

Inhouse training Project Management Methodology with MS Project at PT. HUTAMA KARYA Jakarta

Semoga bermanfaat

HERY PURNAMA
INHOUSE TRAINER

Training excel dashboard, with vba macro, powerpivot, powerview di PT semen padang

Batch 1, inhouse training excel dashboard with vba macro, power pivot, powerview at PT.Semen Padang SumBar

Semoga bermanfaat

Regards,
Hery Purnama
INHOUSE TRAINER

Danau Maninjau sumbar

Selfi di danau maninjau sumbar, memanfaatkan jeda hari libur saat mengajar di semen padang sumbar

Sunset at danau singkarak sumbar in ramadhan

Sambil menunggu berbuka puasa, menikmati indahnya sunset di danau singkarak bersama rekan rekan dari semen padang

Penetapan Hari Libur besar dan libur bersama 2016

Menko PMK Puan Maharani didampingi Menag, Menteri PAN-RB, dan Menaker mengumumkan penetapan hari libur nasional dan cuti bersama 2016, di kantor Kementerian PMK

Berikut daftar 15 Hari libur nasional 2016:

1. 1 Januari Tahun Baru 2016 Masehi
2. 8 Februari Tahun Baru Imlek 2567 Kongzili
3. 9 Maret Hari Raya Nyepi Tahun Baru Saka 1938
4. 25 Maret Wafat Isa Al-Masih
5. 1 Mei Hari Buruh Internasional
6. 5 Mei Kenaikan Yesus Kristus
7. 6 Mei Isra Mi'raj Nabi Muhammad SAW
8. 22 Mei Hari Raya Waisak 2560
9. 6-7 Juli Hari Raya Idulfitri 1437 Hijriah
10. 17 Agustus Hari Kemerdekaan Republik Indonesia
11. 12 September Hari Raya Iduladha 1437 Hijriah
12. 2 Oktober Tahun Baru Islam 1438 Hijriah
13. 12 Desember Maulid Nabi Muhammad SAW
14. 25 Desember Hari Raya Natal

Hari cuti bersama 2016:

1. 4,5 dan 8 Juli Hari Raya Idulfitri 1437 Hijriah
2. 26 Desember Hari Raya Natal

by http://inhousetrainer.net

Inhouse Trainer di Bali, Bandung, Jakarta, Medan, Padang, Samarinda, Makasar

Hery Purnama 081.223344.506 ,Trainer MS Project ,Excel VBA Macro, Dashboard PowerPivot , PowerView, Autocad Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , Autocad, Sencha ExtJS Oracle DBA, SQL Server DBA, MySQL DBA,ASP.Net, Laravel, MS Access VBA, Primavera P6, MS Project,PHP Jquery, Yii framework, CodeIgniter : Call/SMS/WA : 081.223344.506 | PinBB : 7DC633AA | Email / YM : inhousetrainer@yahoo.com
Inhouse Training di Bandung Jakarta Bali Sumatera Kalimantan Sulawesi

Visit : http://inhousetrainer.net , http://freelance-it-trainer.blogspot.com

Trainer di Bandung Jakarta Bali Sumatera Kalimantan Sulawesi

Visit : http://inhousetrainer.net , http://freelance-it-trainer.blogspot.com

Trip to puncak lawang sumatera barat

Berkunjung ke taman wisata puncak lawang sumatera barat bersama relasi dari PT. SEMEN PADANG , what a wonderfull place

IT Trainer, Freelance

Inhouse Trainer – Excel Macro, Android, ITIL, COBIT, Primavera, MS Project, Oracle, PM, ExtJS, etc

Hery Purnama 081.223344.506 – Freelance Trainer , Excel VBA Macro, Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , MS Project, Sencha ExtJS, Oracle DBA, SQL Server DBA, MySQL DBA, MS. Access VBA, Primavera P6, MS Project,Jquery, Yii, CodeIgniter. CIW, OCA, ITILF, TOGAF, Certified Trainer For Inquiry : Call/SMS/WA : 081.223344.506 | PinBB : 7DC633AA | Email / YM : inhousetrainer@yahoo.com | FB : inhousetrainer | TW : inhousetrainer

Excel looking group interval or frequency (formula an VBA Macro)

Excel Formula to looking group of interval data
=IF(AND(IF(ISNUMBER(A1)=FALSE,0,A1)<=80,A2>80),-1,0)

Total minutes	Status dengan formula		Group
85	-1	==>	Group 1
30	0
89	-1	==>	Group 2
89	0		Group 2
80	0
30	0
89	-1	==>	Group 3
89	0
30	0
60	0
89	-1	==>	Group 4
99	0
89	0
86	0
80	0
60	0
89	-1	==>	Group 5
81	0		Group 5
60	0
89	-1	==>	Group 6
81	0		Group 6

There are six (6) group of data interval which has value > 80

I’m creating vba function as well to looking the Group Frequency in Excel

Function cariinterval(sel1 As String, sel2 As Single) As Single

Dim vsel1 As Single

If IsNumeric(sel1) = False Then
    vsel1 = 0
    Else
    vsel1 = sel1
End If

If vsel1 <= 80 And sel2 > 80 Then
    cariinterval = -1
    Else
    cariinterval = 0
    End If

End Function