Master00j Posted October 28, 2017 Share 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'. Link to comment Share on other sites More sharing options...
Butta Posted October 28, 2017 Share 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 Link to comment Share on other sites More sharing options...
Master00j Posted October 28, 2017 Author Share 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. Link to comment Share on other sites More sharing options...
Deceiver Posted October 28, 2017 Share Posted October 28, 2017 to make it look neater (format wise for prices) can highlight the column and go to get dis: Link to comment Share on other sites More sharing options...
Master00j Posted October 28, 2017 Author Share 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 Link to comment Share on other sites More sharing options...
Master00j Posted October 28, 2017 Author Share 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. Link to comment Share on other sites More sharing options...
Master00j Posted October 28, 2017 Author Share Posted October 28, 2017 Seems I figured it out, But it's not exactly what I want. but ok it works :p Link to comment Share on other sites More sharing options...
