Fixing final changes for The Giving Quiz
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. 😩
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. 😩
🙃 Just did 5h of judging for a Hawker Hackathon, to help our Singaporean hawkers
Recorded my first Loom video for a short sharing at Hawker Hackathon
https://www.loom.com/share/5ffce63c2dc846d9ba7c29dcbefd3ffd
Video call with Solve n+1 on future plans for The Giving Quiz
Completed Giver profile quiz
Convert Calculator was an interesting nocode calculator tool. Quite well-featured and intuitive, feels like the Carrd of calculator tools:
• Comprehensive UI options - buttons, sliders, toggles, radio buttons, everything
• Can have hide/show logic
• Can connect with Google Sheets, Zapier, Mailchimp or Hubspot to become a database for collecting form submissions
• Embeddable in all web CMS or websites
• Custom CSS to customize every text and button
But expensive for nonprofits at $60/m !
• Comprehensive UI options - buttons, sliders, toggles, radio buttons, everything
• Can have hide/show logic
• Can connect with Google Sheets, Zapier, Mailchimp or Hubspot to become a database for collecting form submissions
• Embeddable in all web CMS or websites
• Custom CSS to customize every text and button
But expensive for nonprofits at $60/m !
Final tweaks to the Giver Profile quiz
🤩 Got featured on The IT Society magazine by Singapore Computer Society for my COVID tech for good work
https://issuu.com/scsmagazine/docs/scs_theitsociety_issue1_2021_final
Updated Call Home SG website with new info
Spoke at online fireside chat for entrepreneurs in Singapore, about my COVID products, nocode, and tech for good
🔴 Recording here:
https://www.scs.org.sg/videos/techour-may-session-digital-tools-for-success
https://www.scs.org.sg/videos/techour-may-session-digital-tools-for-success
Created prototype of a Giver Profile quiz, as part of collab with Solve n+1
https://thegiverquiz.carrd.co/
using nocode tool
convertcalculator.co
using nocode tool
convertcalculator.co
Got another annual sub $50/year on my social impact crowdfund!
Thanks @joelfirenze !
Researched and found nocode calculator builder ConvertCalculator.co to build the giver personality quiz! Starting on MVP now
Collaborating with social impact partner Solve-n+1 on this project
Created JAMstack website MVP for NGO in Singapore - Integral Singapore https://integralsingapore.netlify.app/
Confirmed speaking opportunity for SCS May TecHour 12 May 12pm - gonna talk about using nocode tech for good!
Vetted SCS magazine article
🚤 Shipped prototype under 1h!
Prototype is an Airtable online form and table view for nursing home - for them to takes misc purchase orders from residents, scan receipts, upload scans, and track purchases
Chat with elderly nursing home to create a tech for good project together
Started new project window - mental health for young working adults
I start projects by starting a new browser window with lots of tabs of research. This time, collaborating with Common Ground, a social enterprise in Singapore, to help young working adults with/concerned about their mental health and wellbeing.
https://www.channelnewsasia.com/news/singapore/in-focus-young-people-mental-health-singapore-treatment-13002934
https://www.mindline.sg/
https://stayprepared.sg/mymentalhealth/
https://www.channelnewsasia.com/news/singapore/in-focus-young-people-mental-health-singapore-treatment-13002934
https://www.mindline.sg/
https://stayprepared.sg/mymentalhealth/
Replied email for potential pro bono volunteering opportunity for SSAs/ECDA (gov folks)
Arranged phone call to appear in CNA documentary about COVID innovators by Peddling Pictures
More opportunities! Not sure where all these goes, but OK!
Completed magazine interview for IT mag
📺"Look mum, I'm on TV!"
Receiving the awards at SCS IT Leaders awards ceremony for all the COVID19-related tech for good products I made last year
☕️ Received my 2nd monthly subscriber - US$5/m
🤑 Received my first annual subscriber! US$50/m
🚀 Finally launched my social impact patronage project!
Help me help others, using tech for good.
See my crowdsourcing/-funding page here 👇🏻
https://www.buymeacoffee.com/jasonleowsg
Read more about it here 👇🏻
https://golifelog.com/posts/launching-my-social-impact-patronage-1616137024350
---
Please link me up with ideas or charities/NGOs who need tech help, or support financially by a monthly membership (to offset the costs of domain/web hosting).
See my crowdsourcing/-funding page here 👇🏻
https://www.buymeacoffee.com/jasonleowsg
Read more about it here 👇🏻
https://golifelog.com/posts/launching-my-social-impact-patronage-1616137024350
---
Please link me up with ideas or charities/NGOs who need tech help, or support financially by a monthly membership (to offset the costs of domain/web hosting).