Menu
What's new
By:
Filters

I like spread sheets, so I made something silly

Horopito

Horopito

Kava Curious
Kava Calculator

To use make duplicate, if you want imperial please let me know what units would best suit so I can. I'm happy to make kava measure by "spoons" version too, but not yet thought how to make that till I visualise in my head at some point.

If you have even sillier ideas to add to the calculator please let me know.

Current Calculator functions
  1. millilitres to time
  2. grams to time
  3. millilitres to grams
  4. grams to millilitres
  5. time to grams
Some good base numbers to play with is 15ml and 40ml to 1g

Enjoy some silliness, from a weird nerd.

~Churr

~Noticed some issues with the time functions so fixed them

pps spelling is not my thing numbers are, so let me know if I screwed up something.
 
Last edited:
Forretressqt

Forretressqt

Kava Curious
Horopito said:
I wonder what other movie binge watch you could calculate time to grams then lord of the rings

FYI all I fixed the time functions, some of them where not correct.
Click to expand...
Ahhh, I checked earlier and thought "Some of the calculations seem a little more than I would expect.".

Kia Ora from Aotearoa! (Kapiti) My friends and I binge LOTR maybe every 3 months, Kava is almost always involved.
 
Horopito

Horopito

Kava Curious
Forretressqt said:
Ahhh, I checked earlier and thought "Some of the calculations seem a little more than I would expect.".

Kia Ora from Aotearoa! (Kapiti) My friends and I binge LOTR maybe every 3 months, Kava is almost always involved.
Click to expand...
Kia ora too!!

My brain trying to do time calculations calculated shells, then did the next step off shells but becasue of rounding on the shells, and some formatting issues it ended up super weird... thus now it's fixed.
 
Last edited:
Horopito

Horopito

Kava Curious
Any nerds know how to get past 24 hours in google sheets for this? for stupid long tv binge watch's, still new to decimal time
 
Last edited:
Forretressqt

Forretressqt

Kava Curious
Horopito said:
Any nerds know how to get past 24 hours in google sheets for this? for stupid long tv binge watch's, still new to decimal time
Click to expand...
Use =TEXT(TIME(0,G4*A3/$B$3*C$3,0),"h:mm AM/PM") for i3 and fill in the rest - this formats it to AM/PM.

You can just copy paste the formulae from other boxes into the brackets directly after "TIME"
 
Horopito

Horopito

Kava Curious
Forretressqt said:
Use =TEXT(TIME(0,G4*A3/$B$3*C$3,0),"h:mm AM/PM") for i3 and fill in the rest - this formats it to AM/PM.

You can just copy paste the formulae from other boxes into the brackets directly after "TIME"
Click to expand...
That would make it time of day, not get past elapsed hours of 24 hours, unless the time format was shifted to not just hours but elapsed days too. for liek calculating the whole of stargate
 
You must log in or register to reply here.
Top