Toadwater

Toadwater Inn => Mopsi's Modern Tavern => Topic started by: Gribby on October 10, 2013, 08:27:44 pm



Title: Gribby's Up-to-date Toadstat! v0.2
Post by: Gribby 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* (https://docs.google.com/spreadsheet/ccc?key=0AmCo7N9zgXvHdEFtVld5Q1JSZllEVlUxVDl3eDZEQ0E&usp=sharing) 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* (https://docs.google.com/spreadsheet/ccc?key=0AmCo7N9zgXvHdEFtVld5Q1JSZllEVlUxVDl3eDZEQ0E&usp=sharing) 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!


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: tydie1 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)


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Gribby on October 10, 2013, 09:09:55 pm
Thanks for spotting that Tydie, fixed that.


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Ex 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?


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Gribby 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 :).


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Mr. Demus, Himself on October 11, 2013, 01:25:03 am
I really like your toadstat Gribby!  Thank you for making this! 


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Xavier 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.


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Travis on October 11, 2013, 05:42:39 am
Wow.  That's really cool.  I really like the color coding.


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Gribby 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!


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Hoshiko on October 12, 2013, 01:39:15 am
Wow! Thank you, the Toadstat is great. Personalized and interactive.


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Lackey Twisti 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).


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Gribby 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.


Title: Re: Gribby's Up-to-date Toadstat! v0.1
Post by: Lackey Twisti on October 13, 2013, 12:12:44 pm
My God, messing with the live code ? How irresponsible!


Title: Re: Gribby's Up-to-date Toadstat! v0.2
Post by: Gribby on October 15, 2013, 12:10:32 am
Now updated. Please report any mysterious behaviour.


Title: Re: Gribby's Up-to-date Toadstat! v0.2
Post by: Gribby 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.


Title: Re: Gribby's Up-to-date Toadstat! v0.2
Post by: Travis on October 22, 2013, 04:38:56 am
Good job on the salad odds, keep up the good work!