#Idle Clans Skilling XP Calculator

128 messages · Page 1 of 1 (latest)

wise hare
spare pebble
#

Woooo using api, nice work ✨

cerulean hawk
#

explain @wise hare ?

image.png
#

my exp super thicc?

wise hare
#

Crushing gems yields lots of xp/hr 🙂

cerulean hawk
#

looks great so far btw

#

saves me a lot of manual calcs lol

#

is it possible to add xp bonus tab for events like halloween?

spare pebble
#

Best calculator so far

wise hare
cerulean hawk
#

it fits here lol

image.png
spare pebble
#

a very little detail, to be closer what we are used to use, why not common enchant / rare enchant / diamond enchant instead T1/T2/T3 scrolls ? (or is it to get it right in the column size ?)

wise hare
#

Thats just how it was on the previous sheet, I can change it to be common/rare/exceptional - exceptional seems to be too big for the cells though might need to mess with the font size

spare pebble
#

bha I guess every one canc understand T1/T2/T3 too

cerulean hawk
#

instead of common/rare/exceptional
silver/gold/diamond?

wise hare
#

I was going to just pull that with the profile api but it goes off what people have equipped at the time, and some jewelry may not have enchants so I had to leave them as dropdowns, could do it based on the jewelry type silver/gold/diamond like you said

spare pebble
#

does calc take in count 8h boost + 16h no boost ? I don't find it.

cerulean hawk
spare pebble
#

ah ok found it.

#

there is that in mining page

image.png
wise hare
#

If the amount of tasks takes > 8 hours, it will take an average ratio if you boosted 8/24 hours a day, but if the task time is <= 8 hours, it will just multiply xp by +30%

spare pebble
#

definitively best calculator. Impressive work !

wise hare
#

Thanks! Like I mentioned in the overview tab, a lot of the groundwork was already in place thanks to the Wendy's clan and their spreadsheet which I linked to - I added new things and improvements from there.

cerulean hawk
#

you're the best for putting this together

spare pebble
#

get the link in wiki ! 🙂

serene python
#

this is amazing

cunning gate
#

alot of the information is stuck loading for many seconds now why is this

wise hare
#

You may need to refresh the api on the overview page - the clan info hangs for some reason sometimes

image.png
cunning gate
#

yep that worked clicked it a couple times and it loaded no issue, thanks appreciate it i like seeing the progress to xyz percentages

#

sorry for spam

wise hare
#

No worries, atm you would need to enter 120 as the target level on every skill page 😬

cunning gate
#

ah gotcha np

#

thats not that bad

#

hmm i guess thats not necesarrily total total though as this doesnt include combat but it still gives a ballpark

#

this is nice good work so far

wise hare
#

Yeah you would need to consider combat, crafting (if you are on an instant task), and enchanting additionally to what you see there - unfortunately I don't have reliable combat calcs so I haven't tried to work that out

Also this doesn't account for xp rewards like clan events and quests so the eta could be lower than it is

cunning gate
#

says about 70 days which i would have to nitpick and fix all my drop downs/boosts so it seems accurate to me based on my napkin math i did early

#

im not worried you will probably continue to work on this or get others to help so everything in time

#

nice to see an update to the wendys one

wise hare
#

yeah I always liked the old wendys one so I figured I would try to update it, its super nice having the xp auto-update as you open it and seeing the time until goal tick down 🙂

cunning gate
#

yeah definitely much better qol

wise hare
#

main hurdle is that you need to enter your tools, enchantments, capes, outfit pieces, and consumables on every page but luckily you only need to do that like one time, can't really get around that with the API

cunning gate
#

yeah i wonder if it would be possible because you can sort of inspect people; though that doesnt update in real time

#

so there has to be like some sort of way to fetch the "armory" but i have no idea what im talking about so 🙂

wise hare
#

I've pulled a rough profile lookup page, the problem is that it only pulls what you are currently wearing and what your current jewelry boosts are which would be problematic for the calculator in my opinion, and it updates slowly like you said its ~15 minutes I think? might be 5 minutes actually idk I'd have to check again

image.png
cunning gate
#

hmm yeah interesting

#

maybe in the future tems will consider the use of community tool and add in stuff to help ease some of these things lik this

lament kiln
#

Heya, question 'cause there's something I think I didn't understand. In there, current xp is good. I put on my jewelleries level, and no pots at all are used. But, it says a plank is doing 54xp on average, which is false. Without boost, I'm doing 108 xp on mahogany. It seems like it's calculated for lower tiers planks. Is there somewhere I should enter the level of plank I'm doing ? Didn't see it though so, may be wrong. Thanks 😄

image.png
wise hare
lament kiln
#

Okay I'm fully dumb I didn't see it lmao. Thanks, and amazing work btw.

ashen lynx
#

is there a way to input endgoal of 500m xp to calc resources needed and time?

wise hare
#

yeah you can enter 500 for the target level and it should calc tasks and time to get 500m xp

ashen lynx
#

alright thx

wise hare
#

Just a heads up I had to update the consumables formula on the Carpentry page, had to update cells I20 and K8 in the official sheet so that the consumable xp bonus is factored into the time remaining.

Similar changes were also made for the mining page as the guardian's lamp was not affecting estimated task time; had to update cells H20 and L9 on the mining sheet

true condor
#

I dont know if im using it incorrectly, but if I have more than the 88m exp for a skill, but I want to know how much time I need for all skills to be maxed (120) I get (obvious) a negative time. But this negative time then also gets added to the "Time until all target levels met" on the overview page.

#

ive now just added MAX(value in question, 0) to not get any negative time there

correct.png
#

But this calculator is really really awesome!!

wise hare
wise hare
#

I've added a dropdown in the overview to factor in the holiday event xp boost 🎉 should be working correctly but let me know if anything weird shows up!

glossy idol
#

@wise hare Do you know if there is an issue with the API? It is not loading for me suddenly

wise hare
spare pebble
#

same issue for me too 😒

true condor
#

Will Exterminating get added to? Kappa

wise hare
spare pebble
#

There is something broke with datas atm ? Red litle corner is " error - loading datas"

image.png
#

I guess the reason is those things missing from api ?

image.png
wise hare
#

Try refreshing the api checkbox like I mentioned above

spare pebble
spare pebble
#

@wise hare Perhaps a little error in formula "progress to 120" for Comp T4 cape ? 2255 total skills -> 100% reached ?

image.png
#

In fact error seems to be in L64 : the sum of skills points : 1681257379.1 is > 19x88474739=1681020041

#

I found what it is : you do sum of all XP for each skill but do not take only lvl120 XP if xp is > lvl 120.

#

If for one skill i've 100mil xp, it should be only 88474739 for the sum.

#

So instead =E37+E40+E43+E46+E49+E52+E55+E58+E61+E64+L37+L40+L43+L46+L49+L52+L55+L58+L61

#

it could be =min(88474739,E37)+min(88474739,E40)+min(88474739,E43)+min(88474739,E46)+min(88474739,E49)+min(88474739,E52)+min(88474739,E55)+min(88474739,E58)+min(88474739,E61)+min(88474739,E64)+min(88474739,L37)+min(88474739,L40)+min(88474739,L43)+min(88474739,L46)+min(88474739,L49)+min(88474739,L52)+min(88474739,L55)+min(88474739,L58)+min(88474739,L61)

#

Formula above works

image.png
#
  • Function "min" is in french, not sure what name for same function in english.
wise hare
#

I updated the function to take this into account, thanks!

spare pebble
#

You could use that formula for 064 :

#

=min(1,(E37+E40+E43+E46+E49+E52+E55+E58+E61+E64+L37+L40+L43+L46+L49+L52+L55+L58+L61)/500000000/19)

wise hare
#

I updated the 500m function

faint spire
#

There are 4 pieces for the Crafting set now

#

Wolf Fur + boots

#

Additionally, Plundering and Agility have 3 new outfit pieces as well

wise hare
faint spire
#

🔥

regal kraken
#

the import seems to be broke, and im getting this error on hover.
is there something i need to add to the sheet extenstion wise or anything?

image.png
wise hare
spare pebble
#

works fine for me.

regal kraken
#

let me double check the copy over

#

yeah says the scripts will be copied over

image.png
wise hare
#

Is it still having the same issue after saying the scripts will be copied over? 👀

regal kraken
#

i went to breakfast came back and now its showing some stuff

wise hare
#

Nice, it looks like you're getting that annoying Loading... thing though, make sure you toggle that checkbox on the top right of your screenshot so the clan api info loads 🙂

spare pebble
#

Yup annoying thing ^^

#

On a side note : SOON !

image.png
wise hare
# spare pebble Yup annoying thing ^^

I need a better solution for it to handle recursive api calls 😅 its pulling your profile data to get the clan name and then using the clan name to get the clan data and thats why it does the Loading... the first time you open up the gsheet

spare pebble
#

Bha little detail in fact, still really great calculator 🙌

wise hare
#

As a side-note I think I need to add the new consumables for smithing and agility still...

teal hatch
#

So ive made my copy. Nothing was happening. Opened up Apps Script and ran one manually so it triggers a google permissions request (Had to do this with one of mine). All permissions granted but still not working 😢 Have ticked and unticked the refresh box so many times its starting to fade

edit: Scratch that, closed it all entirely and reopened in a new browser window. Now works fine

wise hare
#

I've updated the sheet with the new consumables for smithing and agility that I missed before, also I've added a few new notes in cells to give more context as to what they pertain to - mainly for the skilling outfits (and where you get them) and for what the common/rare consumables are called for each skill. 🎉 If you want the latest version of the sheet be sure to make a new copy.

short yarrow
#

Spreadsheet doesn't seem to be updating for me. Followed the instructions, copied the file (including scripts). Typed my name, tried unchecking and checking the Refresh API box a couple times. Also kept the spreadsheet open for over an hour to see if it'd refresh but nothing. Have also tried forcing the permissions request like someone else tried. Also tried deleting the sheet and starting again with a new one.

cerulean hawk
#

i just re-copy it and make new one

short yarrow
#

Just an update: I tried again this afternoon - deleted the old copy and made a new one. Its now working, weird but glad its fixed

wise hare
#

Small announcement:
I've fixed a few issues that I had posted above in the latest copy of the sheet

  • Some skills show 4 skilling clothing items possible in the dropdown menu when there are only 3 existing in-game
  • The potions per hour doesn't factor in the new upgrades which will change gold p/h
  • The levels shown at the bottom of the overview page is missing the Exterminating skill
  • Smithing calcs for smelting magic and forgery procs were not correct
wise hare
#

The skilling calculator broke due to a small update made to the API 🙃

I've fixed the issue, and changed ~80% of the functions on the overview tab to be more resilient to API changes in the future - to get the working version please make a new copy of the sheet!

wise hare
#

Idle Clans Skilling XP Calculator

acoustic pine
#

What is this white area to the right of the mining section?

IMG_0110.png
wise hare
acoustic pine
#

Strange that it wasn’t hidden when I directly copied it

wise hare
#

ah mb might have forgotten to hide it when I was fixing some calcs

#

rehid it now

spare pebble
#

Hey Sven, even keeping to refresh that one and only one keep to be #N/A.

image.png
#

oh wait, that is an old copy. Should I get new one from link in upper post ?

#

OK, needed a fresh new copy, Fixed !

robust tulip
#

Is it possible to have progress to next level shown as amount of time needed to next level on the front page?

bleak pike
#

Is this calculator no longer available?

spare pebble
#

Or first post is bugged, I don't know.

wise hare
#

yeah thanks for linking to it, I tried closing & deleting this post after I posted it in #1353606160892297216 but I don't think it did anything

spare pebble
crystal plover
#

so... i have a relatively new group iron, and the clan house is coming up error, im not able to change it since its no longer a drop down either so the whole sheet becomes unuseable. what to do to fix it?

#

if ur wondering if everything else comes up, it does, just not the clan house,

wise hare
#

just a heads up I moved the post over to #1353606160892297216 now but have you tried checking out the FAQ in there? if it says "loading..." you can try toggling the refresh api checkbox or refreshing the page

crystal plover
#

its not loading

image.png