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'.

 

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

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.

to make it look neater (format wise for prices)

can highlight the column and go

to get dis:

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

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. 

 

 

Seems I figured it out, But it's not exactly what I want. but ok it works :p