TOADWATER IS ACTUALLY DEAD :-(
Toadwater Welcome, Guest. Please login or register.
Did you miss your activation email?
August 16, 2022, 12:58:49 pm
Home Login Register
News: Pat McGroin finished fertilizing a field for Halcyon

Toadwater  |  Toadwater Inn  |  Mopsi's Modern Tavern  |  Topic: Gribby's Up-to-date Toadstat! v0.2 0 Members and 1 Guest are viewing this topic.
Pages: [1] Print
Author Topic: Gribby's Up-to-date Toadstat! v0.2  (Read 7250 times)
Gribby
Centivelian
----------
*

Karma: 5
Offline Offline

Posts: 11


« on: October 10, 2013, 08:27:44 pm »

Hi everyone.

Over the last few days I put together a spreadsheet with many XP and odds calculators. Why is mine better?

*It automatically gets your stats from the website and updates them for you!*

So, what does it include (so far)?

  • Automatic stat updating!
  • Forestry planting odds, including with normal fertiliser and EBP.
  • Farming odds.
  • Tree wood / seed calculator (New system!)
  • Whittling odds.
  • Construction odds.

I am currently finishing up farming odds for carrots and tomatoes, and also the cooking calculator for salads. Any other suggestions and future additions will be added to this list:

  • Finish farming.
  • Finish cooking.
  • Add tinkering.

Instructions for use

  • 1. Click *HERE* to view the spreadsheet. You can check it out before you decide to use it.
  • 2. If you want to use it, you need to be signed in to Google. In the top right, there should be a sign in button. Sign yourself in.
  • 3. Click File -> Make a Copy. This should copy the spreadsheet into your own Drive. That's Google Drive, not your hard drive.

Okay, you have a copy of the spreadsheet now. But you're seeing my stats.
So:

  • 1. Go to 'Sheet1' in the spreadsheet saved IN YOUR DRIVE.
  • 2. In Cell A1 you'll see a load of numbers and my name, click this cell.
  • 3. In the formula bar (just above the spreadsheet), you should see: "=importHTML("http://toadwater.com/TWeb/Profile.php?name=Gribby","table",0)"
  • 4. You guessed it, it's as simple as changing 'Gribby' to whatever your character ID is. That's the name you use to login.
  • 5. Once you've changed it, hit enter.

Now it should update everything on the stats page with your numbers.
You will notice throughout the spreadsheet that there are various coloured cells. Colours on odds are fairly self explanatory, the higher they are, the greener they are. The lower, the redder.

However, the cyan cells are ones you can interact with! For example you can:

  • Boost your stats with radishes/GRs. On the stats page, put a '1' for a single buff and a '2' for a double buff.
  • On the farming page, choose how many crops you'd like to plant and see the outcome.
  • On the tree seeds / odds page, choose the age of the tree and find out how old you should grow it before thinking about cutting it!

At the moment it is not compatible with Excel. It may be in the future, it may not, we'll see.

UPDATE v0.2

Click *HERE* for the new version. I have also changed the url above in the instructions. Both are the same thing.

Changes:

Sheet1
  • Added the ability to import the data from a second character so you can compare your own to theirs. Do it exactly the same as when you put your own character in, except into cell A4. It's set to Excalibus by default. Enjoy that.
Stats
  • On the stats sheet it shows the stats of the second character and calculates the difference in XP and rank, which is colour coded: red = you are behind, green = you are ahead.
  • On your own stats your distance to the next rank is also coloured, just like on your profile page.
  • Added age bonus to the stats page. If you have deaths this doesn't work properly. Go eat a DCM already.
Farming
  • Added carrots and tomatoes to the farming page. Carrots are about 99% accurate. I'll fix them soon. Hotfixed.
  • The farming page now shows how much planting your desired amount of crops would cost, and tells you how much XP you get for every gold spent.
  • Tweaked the yields to be a bit more accurate.
Forestry - Wood & Seeds
  • Fixed the real time calculator to show the time in imperial values rather than decimal.
  • Added the ability to calculate Wood and Seeds from real days as well as TW years and days.
Cooking
  • Began the work on calculating salad odds. I will do it one day.

If you have any suggestions or comments, please post them!
« Last Edit: October 15, 2013, 12:24:06 am by Gribby » Logged

<[twisti]>: Gribby, are you single and a hot girl by any chance ?
<[twisti]>: if so, marry me
<Gribby>: LOL what?
<[twisti]>: well, i dont mind men, but i wouldnt want to marry one
tydie1
Centivelian
----------
*

Karma: 2
Offline Offline

Posts: 4


« Reply #1 on: October 10, 2013, 08:57:37 pm »

Really useful spreadsheet, I will be using it a lot in the future.

I did notice one typo, in the farming tab, if your radish odds aren't 100%, it uses the raw pepper odds, which leads to funny results.

J2 should read =IF(I2>=100,100,I2), instead of =IF(I2>=100,100,C2)
Logged
Gribby
Centivelian
----------
*

Karma: 5
Offline Offline

Posts: 11


« Reply #2 on: October 10, 2013, 09:09:55 pm »

Thanks for spotting that Tydie, fixed that.
Logged

<[twisti]>: Gribby, are you single and a hot girl by any chance ?
<[twisti]>: if so, marry me
<Gribby>: LOL what?
<[twisti]>: well, i dont mind men, but i wouldnt want to marry one
Ex
Toadwater God
----------
****

Karma: 41
Offline Offline

Posts: 316


« Reply #3 on: October 11, 2013, 12:54:07 am »

wow this is very cool and useful gribby, thanks!!



PS, it looks like tinkering is missing as well?
Logged

Excalibus washed 7 Sun Fungus, now it's very shiny. Odds: (0.01%)

Excalibus successfully washed 3 gnarled carrots and found 2 Elder Carrots. Odds: 0.04%
   
Excalibus successfully mined six Ring Ore from a Bilfornite Mine! Odds: (0.01%)
Gribby
Centivelian
----------
*

Karma: 5
Offline Offline

Posts: 11


« Reply #4 on: October 11, 2013, 12:59:42 am »

Yes Ex unfortunately it is. If it becomes possible to include it in the sheet I will do so. I'll add it to the list for the future.

If there are any more features or formulas that you can think of, please say so and I will try to add it Smiley.
Logged

<[twisti]>: Gribby, are you single and a hot girl by any chance ?
<[twisti]>: if so, marry me
<Gribby>: LOL what?
<[twisti]>: well, i dont mind men, but i wouldnt want to marry one
Mr. Demus, Himself
Centivelian
----------
*

Karma: 55
Offline Offline

Posts: 128



WWW
« Reply #5 on: October 11, 2013, 01:25:03 am »

I really like your toadstat Gribby!  Thank you for making this! 
Logged



Xavier
Apprentice
----------
*********

Karma: -4
Offline Offline

Posts: 11


« Reply #6 on: October 11, 2013, 03:29:41 am »

First off this is an awesome toadstat and I love. My only issue with it is that my stats on the toadstat are not the same as the stats show on my game client or in my profile. Some are off by 20 but others are off by quite a bit.
Logged
Travis
Administrator
----------
*******

Karma: 207
Offline Offline

Posts: 2100


« Reply #7 on: October 11, 2013, 05:42:39 am »

Wow.  That's really cool.  I really like the color coding.
Logged
Gribby
Centivelian
----------
*

Karma: 5
Offline Offline

Posts: 11


« Reply #8 on: October 11, 2013, 11:21:51 am »

First off this is an awesome toadstat and I love. My only issue with it is that my stats on the toadstat are not the same as the stats show on my game client or in my profile. Some are off by 20 but others are off by quite a bit.


Thank you Xavier, double check that on your stats page that there are no numbers in the cyan box next to the radish buffs.

Thank you everyone. Glad to hear you are enjoying it!
Logged

<[twisti]>: Gribby, are you single and a hot girl by any chance ?
<[twisti]>: if so, marry me
<Gribby>: LOL what?
<[twisti]>: well, i dont mind men, but i wouldnt want to marry one
Hoshiko
Centivelian
----------
*

Karma: 37
Offline Offline

Posts: 65


« Reply #9 on: October 12, 2013, 01:39:15 am »

Wow! Thank you, the Toadstat is great. Personalized and interactive.
Logged
Lackey Twisti
Toadwater God
----------
****

Karma: 41
Offline Offline

Test: teeeeest
Posts: 963


Infected with Gay Fever


« Reply #10 on: October 13, 2013, 12:57:41 am »

If stats are off, check if you have accounted for age bonus and deaths (every death is -1 to all skills).
Logged

<+farmyb> id say my spelling and grammar is pretty good
Gribby
Centivelian
----------
*

Karma: 5
Offline Offline

Posts: 11


« Reply #11 on: October 13, 2013, 01:28:03 am »

Age bonus is factored in automatically, the values it fetches from TW have the bonus included. Not sure about deaths though. The likely culprit for Xavier is the radish bonus, I was messing with the spreadsheet forgetting it was the live one.
Logged

<[twisti]>: Gribby, are you single and a hot girl by any chance ?
<[twisti]>: if so, marry me
<Gribby>: LOL what?
<[twisti]>: well, i dont mind men, but i wouldnt want to marry one
Lackey Twisti
Toadwater God
----------
****

Karma: 41
Offline Offline

Test: teeeeest
Posts: 963


Infected with Gay Fever


« Reply #12 on: October 13, 2013, 12:12:44 pm »

My God, messing with the live code ? How irresponsible!
Logged

<+farmyb> id say my spelling and grammar is pretty good
Gribby
Centivelian
----------
*

Karma: 5
Offline Offline

Posts: 11


« Reply #13 on: October 15, 2013, 12:10:32 am »

Now updated. Please report any mysterious behaviour.
Logged

<[twisti]>: Gribby, are you single and a hot girl by any chance ?
<[twisti]>: if so, marry me
<Gribby>: LOL what?
<[twisti]>: well, i dont mind men, but i wouldnt want to marry one
Gribby
Centivelian
----------
*

Karma: 5
Offline Offline

Posts: 11


« Reply #14 on: October 18, 2013, 08:03:29 pm »

Spotted an error with the whittling level. It has now been fixed. Make another copy to receive the changes.
Logged

<[twisti]>: Gribby, are you single and a hot girl by any chance ?
<[twisti]>: if so, marry me
<Gribby>: LOL what?
<[twisti]>: well, i dont mind men, but i wouldnt want to marry one
Travis
Administrator
----------
*******

Karma: 207
Offline Offline

Posts: 2100


« Reply #15 on: October 22, 2013, 04:38:56 am »

Good job on the salad odds, keep up the good work!
Logged
Pages: [1] Print 
Toadwater  |  Toadwater Inn  |  Mopsi's Modern Tavern  |  Topic: Gribby's Up-to-date Toadstat! v0.2
Jump to:  


Login with username, password and session length

The Toadwater Forums and Game are Copyright © 2014 The TW Development Group
Powered by SMF 1.1.1 | SMF © 2006, Simple Machines LLC