Master00j Posted October 28, 2017 Posted October 28, 2017 I'm working on some spreadsheet for my services and I would like to add some skill calculator in it. But i have no clue on how to get this working. Does anyone have some experience with google spreadsheet or exel? Some examle of what i need. so start level 1 in this case and desired level 60. I want an auto calculated price in the 'price collum'.
Butta Posted October 28, 2017 Posted October 28, 2017 if you want to do this without programming use this: http://runescape.wikia.com/wiki/Experience/Table Paste all levels and XP on the sheet > sum(difference XP) * gp/xp 1
Master00j Posted October 28, 2017 Author Posted October 28, 2017 6 minutes ago, Butta said: if you want to do this without programming use this: http://runescape.wikia.com/wiki/Experience/Table Paste all levels and XP on the sheet > sum(difference XP) * gp/xp Thanks gonna try this.
Deceiver Posted October 28, 2017 Posted October 28, 2017 to make it look neater (format wise for prices) can highlight the column and go to get dis:
Master00j Posted October 28, 2017 Author Posted October 28, 2017 2 minutes ago, Deceiver said: to make it look neater (format wise for prices) can highlight the column and go to get dis: thanks for the suggestion. prices are atm in 'K' but will take a look at it, for now I need to figure out about that calculation thing
Master00j Posted October 28, 2017 Author Posted October 28, 2017 1 hour ago, Butta said: if you want to do this without programming use this: http://runescape.wikia.com/wiki/Experience/Table Paste all levels and XP on the sheet > sum(difference XP) * gp/xp not exactly what I'm looking for, since most skills have different gp/xp rates. I made 1 page with the levels and their cp's and then I got stuck, think I just don't have the knowledge about this code. on 'blad 2' are all the skills and their xp's.
Master00j Posted October 28, 2017 Author Posted October 28, 2017 Seems I figured it out, But it's not exactly what I want. but ok it works :p
