Tag: spreadsheet

Categories
Umum

Tentang Pendataan Vaksinasi COVID-19 untuk Lansia (Melalui Google Form)

Photo by Anete Lusina from Pexels

Pada awal Februari 2021 lalu, BPOM mengeluarkan persetujuan penggunaan darurat (emergency use authorization) vaksin CoronaVac untuk usia 60 tahun ke atas dengan dua dosis suntikan vaksin, yang diberikan dalam selang waktu 28 hari.

Ya, tentu saja ini kabar baik. Saya tidak terlalu mengikuti perkembangan bagaimana mekanismenya. Tapi, saya justru tertarik tentang bagaimana proses pendataannya. Jadi, beredar beberapa info dan tautan melalui kanal komunikasi di grup WhatsApp mengenai mekanismenya dengan mengisi data… melalui Google Form.

Iya, Google Form.

Google Form tentu memiliki fitur yang dibutuhkan untuk dapat menginput data dengan mudah bagi publik. Data yang masuk bahkan sudah sangat mudah untuk dikelola, karena bisa langsung dapat tersedia dalam format spreadsheet.

Tapi, kenapa menggunakan Google Form ya? Maksud saya lebih kepada bukankan ini — pengisian menggunakan Google Form — akan cukup mudah untuk disalahgunakan? Sesulit apa untuk menyalahgunakan formulir semacam ini? Apalagi, informasi seperti ini sangat “menarik” bagi banyak orang. Bayangkan saja, tautan yang ‘ilegal’ dengan format formulir yang sama persis beredar di masyarakat, lalu data terisi, lalu siapapun yang memiliki formulir itu memegang data.

Bayangkan juga, bahwa ini lalu tidak dibuat hanya terkait pendataan data untuk vaksinasi COVID-19 bagi lansia. Entah mengapa proses input data ini tidak dilaksanakan terpusat di situs Kementerian Kesehatan Republik Indonesia. Atau, di situs Satgas Penanganan COVID-19. Kalaupun di tingkat yang lebih kecil, bisa ada di situs dinas kesehatan kota/kabupaten. Apa iya tidak bisa membuat sebuah mekanisme mandiri, sehingga data-data yang masuk dapat lebih terlindungi?

Sehingga, peluang untuk mekanisme pengisian data untuk disalahgunakan bisa paling tidak sedikit dikurangi.

Data yang perlu diisi berdasarkan “formulir resmi” terkait pendataan ini seperti NIK (Nomor Induk Keluarga), tanggal lahir, nomor ponsel, dan alamat. Semoga saja, tidak perlu banyak beredar “formulir palsu” nantinya.

Categories
General

Moving to Google Apps for Work

Google Apps for Work

It’s been two for around two months since my small office moved the email service to Google Apps for Work. So far, it’s been a great experience and I think it was the right decision to make.

Why Moving?

Before moving to Google Apps for Work, we manage the email servers on our own. Meaning, we needed to do the setup, maintenance, including backup. There are less than twenty email accounts to manage under two main domains. The email was hosted on a cloud-based server — we used DigitalOcean. Everything was running almost without any issues.

We depend on emails on day-to-day operation. At the same time, we need to have (almost) zero maintenance and increase our productivity. Our small team needs to share lots of things like documents, spreadsheets, and agendas. The thing is that we need to use our personal Google account to share documents. The other things is on the storage. I have more than 6 GB of email (for work). So, moving to Google Apps for Work is an anticipation. Here are some main reasons on the migration:

  1. Zero maintenance. By outsourcing the email service to Google, we at least only need to keep the domain active.
  2. Integration with other Google services like Google Docs, Google Sheets, Google Calendar, and more. The integration also includes the seamless collaboratoin between coworkers.
  3. Flexible storage. By default, I have 30 GB of storage for my Gmail, Google Drive, and photos. If later I need to upgrade, the price is pretty reasonable. 100 GB for IDR 27,000 (per account) is a good deal.
  4. Simple setup and management. Setting up each service provided by Google Apps for Work is very easy.

Migration Process

The migration process was pretty easy. Since there were only around 12 email accounts, so moving them individually did not take too much time. My coworkers moved all the email account by themselves. The only challenge is not to have the downtime. There is a simple guide to work on this area. During the registration process, I only need to use a primary domain — and setup the secondary domain as domain alias later on.

For the cost efficiency, I worked on the settings on email routing. For example, if there is an email address that was only accessed by specific people in the organisation, I created some routing rules. By this, I can minimise the number of accounts.

After all emails (including attachments) had been migrated to Google Apps, we kept the “old” servers online for few days just to make sure that no data left behind. I was not sure how long the whole processes was completed, but it was around one week.

Categories
General

Why I Pick Telegram as My Primary Messaging Platform?

Last year, I mentioned that I used Telegram and I enjoyed it. Been using for more than a year, I feel that it’s much better than the other messaging platforms. Well, I’m not using that many platforms to connect with other friends or colleagues if I consider the other options like LINE, Facebook Messenger, WhatsApp, and many more. But, why Telegram?

Since I do not experience all messaging apps, I know that some other apps might be better. For now, I’m still considering that Telegram is the perfect option (for me) for some reasons.

Cross-platform and Multiple Sessions

Currently, I have multiple devices I use on my daily basis. Well, not really daily, but I usually switch between devices. I have 15-inch MacBook Pro Retina, iPhone 5, iPad 3rd generation, and Oppo Find 7. I have Telegram installed in those devices. It makes me stay connected. I can easily be in the conversation with friends, and especially colleagues. It’s flexibility to have multiple active session is my favorite!

Features

Telegram offers great set of handy features. Go to Telegram’s website for complete features, but here are some of favorite features:

  • File sharing made easy. I can share various types of files, not only photos, videos, but also PDFs, Android packages (yes, I use this a lot at work), spreadsheets, or any other document types.
  • API. It can be integrated easily to make useful tools. I will give some examples in the bottom part of this article.

Simple, fast, and lightweight

I like it’s simplicity. It helps me a lot in communication. I feel that it’s fast, a core feature that a messaging app needs. Of course, there are some extended features like stickers — even we can make our own stickers, bots (hello, @BotFather), event animated GIF.

Bots

It’s a Telegram account and operated by machine.

Bots are simply Telegram accounts operated by software — not people — and they’ll often have AI features. They can do anything — teach, play, search, broadcast, remind, connect, integrate with other services, or even pass commands to the Internet of Things.

The other one is an inline bots.

With the new inline mode, bots become omnipresent and can be used as a tool in any of your chats, groups or channels – it doesn’t matter, whether the bot is a member or not. Inline bots can help you with dozens of different tasks, like quickly sending relevant GIFs, pictures from the Web, YouTube videos, Wikipedia articles, etc.

At work, some of my colleagues made some handy tools based on this platforms.

Categories
General

Track Current Stock Information in Google Spreadsheet


I am not a person who got affected when there are major stock changes in the market. But, for those who need to track the stock information growth — and also use Google Spreadsheet, this is probably useful. Anyway, this will retrieve data from Google Finance.
There is a tutorial about tracking stocks in Google Spreadsheets

Instead of copying data into your worksheet, when the linked source changes, the cells in your spreadsheet will automatically update, which can save a lot of work if you pull reports regularly. This external data can be pulled from XML, other spreadsheet documents, and even (assuming you can bear to look) current and historical stock quotes from Google Finance.

Using this method, you can retrieve current stock information and also pull historical stock data. There are some spreadsheet samples you can download.