August 27, 200817 yr Basically, I need to make a formula for x with this data. y is a variable given. y = (x+300*2^(x/7))/4 Any ideas? The best I got still had x in the formula. Dragon Drops : 5 Dragon Medium Helmets, 3 Dragon Claws, 3 Dragon platelegs, 2 Dragon plateskirts, 2 Dragon Hatchets, 2 Dragon Spears, 7 pairs of Dragon Boots, 1 Dragon pickaxe, 10 Dragon defenders, 3 Dragon 2h swords, 1 Dragon armour Slice, 1 Dragon armour Lump, 1 Dragon chainbody, 1 Dragon kiteshield, 1 Dragon hasta, 1 Dragon ward, 25 Dragon knives pairsThe Warrior's Blog , Herblore Habitat - Efficient and profitable[hide=Stats and logs].:Adventurer's Log:.[/hide]
August 27, 200817 yr Author No, it's RuneScape level and experience calculator. y = experience for next lvl (once rounded down) and x = current lvl-1 I want to Excel to calculate my current lvl based on xp I put in. Dragon Drops : 5 Dragon Medium Helmets, 3 Dragon Claws, 3 Dragon platelegs, 2 Dragon plateskirts, 2 Dragon Hatchets, 2 Dragon Spears, 7 pairs of Dragon Boots, 1 Dragon pickaxe, 10 Dragon defenders, 3 Dragon 2h swords, 1 Dragon armour Slice, 1 Dragon armour Lump, 1 Dragon chainbody, 1 Dragon kiteshield, 1 Dragon hasta, 1 Dragon ward, 25 Dragon knives pairsThe Warrior's Blog , Herblore Habitat - Efficient and profitable[hide=Stats and logs].:Adventurer's Log:.[/hide]
August 27, 200817 yr You can't remove X from this formula, as x is varliable, and y is dependant on x.
August 27, 200817 yr You can't remove X from this formula, as x is varliable, and y is dependant on x. Not true, well probably not true, the fact that he's mixed up X and Y doesn't really effect the equation. You could always just switch them back to their proper relationship if it made you feel better. I can't really remember all the rules dealing with "not base 2" radicals, and I would much rather avoid putting in the effort to remember it...you could always just use Tip.It's calculators :thumbsup: or maybe someone will show you the source coding, it would most likely have this function embedded in it somewhere, or maybe they took the easy way out and made the XP for each level a constant, I have no idea, and this is a run on sentence so I'll just leave now... Barrows: 9~2 V Brass,V Flail,2 Dh Plate,V Helm,V Skirt,T Legs,Malevolent Shield + DKing: 48~6 W Ring,13 A Ring,8 M Staff,9 S Ring,7 B Ring,3 SeercullDragon Drops: 500+~50+ Med,26 Axe,3 Chain,10+ Legs,10+ Spear,2 D2h,10+ L Half,49 Boots,2 DDs,10+ Lump,9 Claws,50+ Dagger,14 Visage,50+ Mace,4 Scimitar,7 Hasta,Baxe,50+ Long,30+ Royal,2 Kite,4 Ward,2 Plate,Staff,Hammer,Limbs, Mattock,HalberdGWD: 156~4 S Staff,50+ Shard,9 B Tass,13 B Plate,5 B Boots,6 A Plate,11 S Sword,8 A Hilt,4 A Skirt,9 A Helm,S Hilt,3 B Hilt,B Glove,2 A Buckler,Z Ward,Z Garb,2 Z Boots,B Shield,B Helm Corp: 3~Elysian,2 Sp Sh + Nex: 6~Torva Legs,Cere,P cowl,Z bow,2 T boots + GWD2: 9~2 Glaive,Wand,2 Crest,Blade,2 Essence,Core + Araxyte: 5~Web,3 Pheromone,Fang + Raids: 4~3 Codex,P Boots + Trails: 2~Bob Shirt,Fortunate Etc: 64~3 Sceptre,B Mask,16 Whip,2 Focus Sight,5 D Bow,7 SOL,Ragefire,2 Steadfast,Arma Staff,6 Rider Armor,5 Vine,2 Razorback,2 A Wand,Abby Orb,3 Blood Shard,6 Hydrix,Gland,Asc Xbow [spoiler=Capes]Quest Cape Aquired 12-7-07 ~ Level 93 + + + Completionist Cape Aquired 5-22-15 ~ Level 138Hitpoints Cape Aquired 9-21-09 ~ Level 131 + Magic Cape Aquired 9-24-09 + Attack Cape Aquired 3-5-10 ~ Level 135 + Summoning Cape Aquired 3-12-10Strength Cape Aquired 6-1-11 ~ Level 137 + Fire Cape Aquired 6-23-11 + Defence Cape Aquired 7-5-11 + Ranged Cape Aquired 8-1-11 + Kiln Cape Aquired 2-26-12 ~ Level 138Dungeoneering Cape Aquired 4-22-12 + Slayer Cape Aquired 6-25-14 ~ Level 200 + Herblore Cape Acquired 12-9-14 ~ Level 138 + Prayer Cape Acquired 12-20-14Agility Cape Acquired 1-4-15 + Hunter Cape Acquired 1-30-15 + Construction Cape Acquired 1-31-15 + Crafting Cape Acquired 2-22-15 + Thieving Cape Acquired 3-18-15Runecrafting Cape Acquired 4-14-15 + Mining Cape Acquired 4-19-15 + Fishing Cape Acquired 4-25-15 + Firemaking Cape Acquired 4-26-15 + Woodcutting Cape Acquired 4-26-15Cooking Cape Acquired 4-26-15+ Smithing Cape Acquired 4-28-15 + Farming Cape Acquired 4-29-15 + Divination Cape Acquired 5-3-15 + Dungeoneering Mastery 5-4-15Fletching Cape Acquired 5-4-15 + Max Cape Acquired 5-4-15 + Invention Cape Acquired 11-9-16 + Invention Mastery 5-16-19 + Archaeology Cape Acquired 10-30-20
August 27, 200817 yr Author You can't remove X from this formula, as x is varliable, and y is dependant on x. So it's impossible to get an x= formula? Dragon Drops : 5 Dragon Medium Helmets, 3 Dragon Claws, 3 Dragon platelegs, 2 Dragon plateskirts, 2 Dragon Hatchets, 2 Dragon Spears, 7 pairs of Dragon Boots, 1 Dragon pickaxe, 10 Dragon defenders, 3 Dragon 2h swords, 1 Dragon armour Slice, 1 Dragon armour Lump, 1 Dragon chainbody, 1 Dragon kiteshield, 1 Dragon hasta, 1 Dragon ward, 25 Dragon knives pairsThe Warrior's Blog , Herblore Habitat - Efficient and profitable[hide=Stats and logs].:Adventurer's Log:.[/hide]
August 27, 200817 yr You can't remove X from this formula, as x is varliable, and y is dependant on x. So it's impossible to get an x= formula? You can call the variables whatever you want :wall: Might as well switch out all the X's and Y's in your initial post to avoid confusion. Barrows: 9~2 V Brass,V Flail,2 Dh Plate,V Helm,V Skirt,T Legs,Malevolent Shield + DKing: 48~6 W Ring,13 A Ring,8 M Staff,9 S Ring,7 B Ring,3 SeercullDragon Drops: 500+~50+ Med,26 Axe,3 Chain,10+ Legs,10+ Spear,2 D2h,10+ L Half,49 Boots,2 DDs,10+ Lump,9 Claws,50+ Dagger,14 Visage,50+ Mace,4 Scimitar,7 Hasta,Baxe,50+ Long,30+ Royal,2 Kite,4 Ward,2 Plate,Staff,Hammer,Limbs, Mattock,HalberdGWD: 156~4 S Staff,50+ Shard,9 B Tass,13 B Plate,5 B Boots,6 A Plate,11 S Sword,8 A Hilt,4 A Skirt,9 A Helm,S Hilt,3 B Hilt,B Glove,2 A Buckler,Z Ward,Z Garb,2 Z Boots,B Shield,B Helm Corp: 3~Elysian,2 Sp Sh + Nex: 6~Torva Legs,Cere,P cowl,Z bow,2 T boots + GWD2: 9~2 Glaive,Wand,2 Crest,Blade,2 Essence,Core + Araxyte: 5~Web,3 Pheromone,Fang + Raids: 4~3 Codex,P Boots + Trails: 2~Bob Shirt,Fortunate Etc: 64~3 Sceptre,B Mask,16 Whip,2 Focus Sight,5 D Bow,7 SOL,Ragefire,2 Steadfast,Arma Staff,6 Rider Armor,5 Vine,2 Razorback,2 A Wand,Abby Orb,3 Blood Shard,6 Hydrix,Gland,Asc Xbow [spoiler=Capes]Quest Cape Aquired 12-7-07 ~ Level 93 + + + Completionist Cape Aquired 5-22-15 ~ Level 138Hitpoints Cape Aquired 9-21-09 ~ Level 131 + Magic Cape Aquired 9-24-09 + Attack Cape Aquired 3-5-10 ~ Level 135 + Summoning Cape Aquired 3-12-10Strength Cape Aquired 6-1-11 ~ Level 137 + Fire Cape Aquired 6-23-11 + Defence Cape Aquired 7-5-11 + Ranged Cape Aquired 8-1-11 + Kiln Cape Aquired 2-26-12 ~ Level 138Dungeoneering Cape Aquired 4-22-12 + Slayer Cape Aquired 6-25-14 ~ Level 200 + Herblore Cape Acquired 12-9-14 ~ Level 138 + Prayer Cape Acquired 12-20-14Agility Cape Acquired 1-4-15 + Hunter Cape Acquired 1-30-15 + Construction Cape Acquired 1-31-15 + Crafting Cape Acquired 2-22-15 + Thieving Cape Acquired 3-18-15Runecrafting Cape Acquired 4-14-15 + Mining Cape Acquired 4-19-15 + Fishing Cape Acquired 4-25-15 + Firemaking Cape Acquired 4-26-15 + Woodcutting Cape Acquired 4-26-15Cooking Cape Acquired 4-26-15+ Smithing Cape Acquired 4-28-15 + Farming Cape Acquired 4-29-15 + Divination Cape Acquired 5-3-15 + Dungeoneering Mastery 5-4-15Fletching Cape Acquired 5-4-15 + Max Cape Acquired 5-4-15 + Invention Cape Acquired 11-9-16 + Invention Mastery 5-16-19 + Archaeology Cape Acquired 10-30-20
August 27, 200817 yr You can't remove X from this formula, as x is varliable, and y is dependant on x. So it's impossible to get an x= formula? It's possible to get x = (your level) But somewhere you are giong to have to input your xp, leaving you with x=y. Do you understand that? You are always going to have an x and a y
August 27, 200817 yr You can't remove X from this formula, as x is varliable, and y is dependant on x. So it's impossible to get an x= formula? It's possible to get x = (your level) But somewhere you are giong to have to input your xp, leaving you with x=y. Do you understand that? You are always going to have an x and a y Well he could fix that by making the variable that represents his current level based off of the variable that he sets to his experience, so then he would only have 1 input variable. I'm betting that the XP values follow a formula, but I honestly never bothered to find it out. Barrows: 9~2 V Brass,V Flail,2 Dh Plate,V Helm,V Skirt,T Legs,Malevolent Shield + DKing: 48~6 W Ring,13 A Ring,8 M Staff,9 S Ring,7 B Ring,3 SeercullDragon Drops: 500+~50+ Med,26 Axe,3 Chain,10+ Legs,10+ Spear,2 D2h,10+ L Half,49 Boots,2 DDs,10+ Lump,9 Claws,50+ Dagger,14 Visage,50+ Mace,4 Scimitar,7 Hasta,Baxe,50+ Long,30+ Royal,2 Kite,4 Ward,2 Plate,Staff,Hammer,Limbs, Mattock,HalberdGWD: 156~4 S Staff,50+ Shard,9 B Tass,13 B Plate,5 B Boots,6 A Plate,11 S Sword,8 A Hilt,4 A Skirt,9 A Helm,S Hilt,3 B Hilt,B Glove,2 A Buckler,Z Ward,Z Garb,2 Z Boots,B Shield,B Helm Corp: 3~Elysian,2 Sp Sh + Nex: 6~Torva Legs,Cere,P cowl,Z bow,2 T boots + GWD2: 9~2 Glaive,Wand,2 Crest,Blade,2 Essence,Core + Araxyte: 5~Web,3 Pheromone,Fang + Raids: 4~3 Codex,P Boots + Trails: 2~Bob Shirt,Fortunate Etc: 64~3 Sceptre,B Mask,16 Whip,2 Focus Sight,5 D Bow,7 SOL,Ragefire,2 Steadfast,Arma Staff,6 Rider Armor,5 Vine,2 Razorback,2 A Wand,Abby Orb,3 Blood Shard,6 Hydrix,Gland,Asc Xbow [spoiler=Capes]Quest Cape Aquired 12-7-07 ~ Level 93 + + + Completionist Cape Aquired 5-22-15 ~ Level 138Hitpoints Cape Aquired 9-21-09 ~ Level 131 + Magic Cape Aquired 9-24-09 + Attack Cape Aquired 3-5-10 ~ Level 135 + Summoning Cape Aquired 3-12-10Strength Cape Aquired 6-1-11 ~ Level 137 + Fire Cape Aquired 6-23-11 + Defence Cape Aquired 7-5-11 + Ranged Cape Aquired 8-1-11 + Kiln Cape Aquired 2-26-12 ~ Level 138Dungeoneering Cape Aquired 4-22-12 + Slayer Cape Aquired 6-25-14 ~ Level 200 + Herblore Cape Acquired 12-9-14 ~ Level 138 + Prayer Cape Acquired 12-20-14Agility Cape Acquired 1-4-15 + Hunter Cape Acquired 1-30-15 + Construction Cape Acquired 1-31-15 + Crafting Cape Acquired 2-22-15 + Thieving Cape Acquired 3-18-15Runecrafting Cape Acquired 4-14-15 + Mining Cape Acquired 4-19-15 + Fishing Cape Acquired 4-25-15 + Firemaking Cape Acquired 4-26-15 + Woodcutting Cape Acquired 4-26-15Cooking Cape Acquired 4-26-15+ Smithing Cape Acquired 4-28-15 + Farming Cape Acquired 4-29-15 + Divination Cape Acquired 5-3-15 + Dungeoneering Mastery 5-4-15Fletching Cape Acquired 5-4-15 + Max Cape Acquired 5-4-15 + Invention Cape Acquired 11-9-16 + Invention Mastery 5-16-19 + Archaeology Cape Acquired 10-30-20
August 27, 200817 yr He only has one input variable and one output variable, i believe? Or am i reading it wrong.. how can you have two input varliables without an output variable? If you do have two input variables, then of course you can get rid of one of them.
August 27, 200817 yr Author Let's just put it like this: I need a formula you can enter in excel that calculates your current level for you based on an input xp amount. Dragon Drops : 5 Dragon Medium Helmets, 3 Dragon Claws, 3 Dragon platelegs, 2 Dragon plateskirts, 2 Dragon Hatchets, 2 Dragon Spears, 7 pairs of Dragon Boots, 1 Dragon pickaxe, 10 Dragon defenders, 3 Dragon 2h swords, 1 Dragon armour Slice, 1 Dragon armour Lump, 1 Dragon chainbody, 1 Dragon kiteshield, 1 Dragon hasta, 1 Dragon ward, 25 Dragon knives pairsThe Warrior's Blog , Herblore Habitat - Efficient and profitable[hide=Stats and logs].:Adventurer's Log:.[/hide]
August 27, 200817 yr Let's just put it like this: I need a formula you can enter in excel that calculates your current level for you based on an input xp amount. Ok, no problem. I'll make you one now. Your formula is giving the xp amount of a certain level. For example, if i input X = 99 i get y = 1,356,729 your formula isn't quite accurate, you need to times it by ten. I'll play with it a bit.
August 27, 200817 yr Author I know, all it does know is calculate the xp needed to lvl up. It uses B*+formula, however this is dependant on former equations and isn't dynamic. I only just realised that. #-o Dragon Drops : 5 Dragon Medium Helmets, 3 Dragon Claws, 3 Dragon platelegs, 2 Dragon plateskirts, 2 Dragon Hatchets, 2 Dragon Spears, 7 pairs of Dragon Boots, 1 Dragon pickaxe, 10 Dragon defenders, 3 Dragon 2h swords, 1 Dragon armour Slice, 1 Dragon armour Lump, 1 Dragon chainbody, 1 Dragon kiteshield, 1 Dragon hasta, 1 Dragon ward, 25 Dragon knives pairsThe Warrior's Blog , Herblore Habitat - Efficient and profitable[hide=Stats and logs].:Adventurer's Log:.[/hide]
August 27, 200817 yr I'll solve it for you if you can make the equation look better (I can't tell some parts about it) Is this what it is supposed to look like? (x + 300) (2^(x/7)) y = -------------------------- 4 Like above? Is that the equation? And you are trying to solve for x right?
August 27, 200817 yr Why not create a and use the data found in the XP Table to lookup the level ? True. I can't be bothered watching that link, but you could use Excel web queries to get your xp and level. I do it with a few automated G E Calculators i have. If you can't work it out i'll gladly set the sheet up for you, if you pm me.
August 28, 200817 yr Author Why not create a and use the data found in the XP Table to lookup the level ? That guy gets on my nerves... Also, the VLOOKUP messes up when using 2 tables consisting solely of numbers. I can't download his guides either. Edit: Nevermind, perfected it. Dragon Drops : 5 Dragon Medium Helmets, 3 Dragon Claws, 3 Dragon platelegs, 2 Dragon plateskirts, 2 Dragon Hatchets, 2 Dragon Spears, 7 pairs of Dragon Boots, 1 Dragon pickaxe, 10 Dragon defenders, 3 Dragon 2h swords, 1 Dragon armour Slice, 1 Dragon armour Lump, 1 Dragon chainbody, 1 Dragon kiteshield, 1 Dragon hasta, 1 Dragon ward, 25 Dragon knives pairsThe Warrior's Blog , Herblore Habitat - Efficient and profitable[hide=Stats and logs].:Adventurer's Log:.[/hide]
August 28, 200817 yr Why not create a and use the data found in the XP Table to lookup the level ? That guy gets on my nerves... Also, the VLOOKUP messes up when using 2 tables consisting solely of numbers. I can't download his guides either. Edit: Nevermind, perfected it. Data>Web Queries>Put in web adress>Go>Import :D
August 28, 200817 yr Apparently I've forgotten how to math, or I would do it for you. Same lol. I know I could have done it in about a minute when I was a Sophomore in high school... but that was four years ago now. I should learn math again >_> Join "DG Sweepers" Clan Chat for Dungeoneering Floors | Accepting all tipiters who are Willing to Learn |
August 28, 200817 yr What does the ^ means :x "To the," like an exponent (5^2 = five to the second = 5x5 = 25). If you don't know what that means, it means you have no hope of solving the problem. You undo it with logarithms... somehow. Join "DG Sweepers" Clan Chat for Dungeoneering Floors | Accepting all tipiters who are Willing to Learn |
August 28, 200817 yr What does the ^ means :x "To the," like an exponent (5^2 = five to the second = 5x5 = 25). If you don't know what that means, it means you have no hope of solving the problem. You undo it with logarithms... somehow. 5^2=5x5=25 5^3=5x5x5=125 5^4=5x5x5x5=625 and so on.. normally, it's notated as 5^n, and you can solve for n with the forumla n=ln(1+FV*i/R)/ln(1+i) it means you have no hope of solving the problem. There is no problem to solve
August 28, 200817 yr There is no problem to solve Oh, sorry, is "I don't know how to plug this formula into excell" not a problem? Because, you know, I thought that was the whole point of the thread. Join "DG Sweepers" Clan Chat for Dungeoneering Floors | Accepting all tipiters who are Willing to Learn |
Create an account or sign in to comment