Social impact patronage

https://vaccinegowhere.sg

Original inspiration from @jordanlys95's https://vaccinegowhere.sg/disclaimer

• Added safe travel link
• Added group limit for sports
• Added link to guidelines for arts sector

Review so far:

Analytics:
👥 2600+ users in last 30min during its peak
📈 160k active users as at today
👁 238k page views as at today

Featured on:
📻 CNA938 radio
📰 Today
📔 8Days
🗞 AsiaOne
📣 MS News

Donations:
☕️ 124 coffees received
💰 $640 one-off support
♻️ 1 new monthly subscription member

❤️ Most importantly, so many kind words that came along with the coffees:

"We share the same name, so I have had at least one person ask me if I am you. Clearly not! I don’t have your gift. Thank you for applying your talent for good. I’m super moved and impressed by your efforts." ~ (another) Jason Leow

"Good job Jason. the society need people like you. Enjoy your coffees, but ask for less sugar ok? Stay healthy and safe. Hahaha…" ~ Alvin Chee

Singaporeans can be so lovely and adorable at times. I wish I can see more of this side more often! Makes the pandemic so much easier.

FetchRSS: https://fetchrss.com/

gov.sg rss feed:
http://fetchrss.com/rss/6115afb020479f4b8a7f64f26115af775d968d3fc77e40f2.atom

MOH covid-19 page rss feed:
http://fetchrss.com/rss/6115afb020479f4b8a7f64f26115b2bc9fc8bc4195716b82.atom

MOH phase advisory page rss feed:
http://fetchrss.com/rss/6115afb020479f4b8a7f64f26115b4785bfcf4286923de52.atom

• the Javascript snippet was the easy part, making the stylings the same as the website was harder due to Carrd
• in the end, I simple copied the entire HTML element (incl. classes) from another similar element from dev console and used it in an embed

2400 users in last 30min
73k active users
95k page views

And it was just launched 4 days ago on 9 Aug!

• sent 1-to-1 messages to friends and family to share it fwd
• engaged Twitter folks who commented on comment on levelsio's tweet
• posted custom messages in other groups - DesignSG, SG Strong, Lion City Makers
• posted on 2 Minister's Facebook post
• next: launch on r/singapore, Twitter

• added new hospital visits section
• added testimonials section and more testimonials
• on nudging by a friend, added buy me a coffee section
• added update status in top-left
• highlighted that it is unofficial and volunteer-driven
• added dates to new data sources added

• Added "latest"
• Removed "from 10 Aug onwards"
• Fixed scroll-to-top button on mobile

• Added more data
• Tweaked typos
• Got feedback from users - highlight source and date
• Highlight that it's 10 Aug onwards

Tweeted out monthly goals for August

using kueh lapis colours 😁

Can't figure out the Excel formula for this on Convert Calculator!

I have an array of variables VA, VB, VC, VD. I want to find the top 3 largest values of this array.

I used MAX() to find the largest value.

To break it down to find the individual 2nd and 3rd largest values, I used the LARGE function

LARGE(array, k), where k is the nth largest value I want.

So to find 2nd largest value from the array, I do this LARGE({VA,VB,VC,VD},2)

Ultimately, I will wrap it in a IF condition to hide/show a piece of info:

IF(LARGE({VA,VB,VC,VD},2) = VB,1,0)

But this doesn't work. 😩