Dear Mr. Kid, Terima kasih atas pencerahannya dan jika berkenan bisa memberikan penjelasan tentang formula tersebut karena saya masih belum mudeng formula tersebut.
Hormat saya, Samsudin [cid:[email protected]] From: [email protected] [mailto:[email protected]] Sent: Tuesday, February 17, 2015 12:03 PM To: BeExcel Subject: Re: [belajar-excel] Roster 3-1 [1 Attachment] Pak Samsudin, File terlampir menggunakan fungsi lookup dan sebuah tabel referensi berisi pola-pola yang akan digunakan. Asumsinya, A. nomor pola yang digunakan oleh setiap nama mengikuti nomor urutnya dengan siklus 3 pola. Jadi nomor urut 4 akan kembali ke pola nomor 1. B. tanggal mulai di-set per tanggal 2015-01-01. C. setiap pola adalah siklus 58 hari sesuai ketentuan yang ada. Hari ke-59 akan kembali seperti hari ke-1 di pola tersebut yang tetap. Silakan dikembangkan dan disesuaikan dengan kebutuhan setempat. Wassalam, Kid. On Mon, Feb 16, 2015 at 2:31 PM, Samsudin [email protected]<mailto:[email protected]> [belajar-excel] <[email protected]<mailto:[email protected]>> wrote: Dear Suhu Excel, Mohon bantuan dan pencerahannya untuk membuat jadwal roster 3-1, dimana ketentuannya adalah : 1. Karyawan dibagi 2 shift ( 7 hari masuk pagi dan 7 hari masuk malam) 2. Karyawan diberikan libur 1 hari, setelah masuk 14 hari (shift I dan Shift II) 3. Karyawan diberikan cuti 7 hari, setelah masuk 14 hari + libur 1 hari + 7 hari masuk (shift I / shift II). Atas bantuannya diucapkan terima kasih. Hormat saya, Samsudin --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy. --------------------------------------------------------------------------------------------------- This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and hereby notified that any disclosure, copying, or distribution of this message (or any part thereof), or the taking of any action based on it, is strictly prohibited. No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this email is free of viruses. The views expressed in this email are, unless otherwise stated, those of the author and not those of the Company or its management. The Company reserves the right to monitor, intercept and block emails addressed to its users or take any other action in accordance with its email use policy.
