Jump to content

200M in all Skills

Makilio

By Makilio
in General Discussion

 Share

Recommended Posts

  • Replies 29.6k
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Artemis1330
Artemis1330

That's a bit biased, taking tips on how jagex runs their polls kaida? So I'll add this- like this post if you don't want it changed.     Just playing devils advocate.

Auror
Auror

There will obviously be a huge arena,just like the Colosseum in italy, and server with a capasity to hold 10k players, then, suomi is in the middle of the arena, 10k people sitting on the seats, then,

Hedgehog
Hedgehog

From the data we have so far, it appears that anyone who is capable of achieving 200m in all skills would be overcome by their ego and then fail to get the final xp.   As of right now, it looks like i

Poppe

Poppe

Posted
Posted

A few pages back he mentioned he changed 200mil smithing calculations to be done at Artisan's Workshop since quite a few people do it there instead of combining it with mining. Its not uber efficient but the afkablity makes it more enjoyable for most previously. Could see if EOM (evolution of mining) makes an argument to change it back.

siggy_zps7b2911b4.png
Link to comment
Share on other sites
Gemeos2

Gemeos2

Posted
Posted

Angerfist and My Kingz have expressed they will be going for 200m all skills. Where are they in terms of above/below Richard?

 

Angerfist needs 15936 hours at this moment.

My Kingz needs 13545 hours at this moment.

 

For the calculations of hours left to 5b exp, what methods/exp rates do you use for mining/smithing and will their hours to 5b be reduced by the EoC?

 

Mining - 97k

Smithing - 220k

Magic - 315k

 

If Slayer or melee training XP rates get increased, hours will be reduced.

 

A few pages back he mentioned he changed 200mil smithing calculations to be done at Artisan's Workshop since quite a few people do it there instead of combining it with mining. Its not uber efficient but the afkablity makes it more enjoyable for most previously. Could see if EOM (evolution of mining) makes an argument to change it back.

 

If "top players" start to do mining while superheating instead of Artisan's Workshop, I'll change it back to the first method mentioned.

My youtube channel with efficient skilling guides and achievements

Link to comment
Share on other sites
Coconut Bodywash

Coconut Bodywash

Posted
Posted

Does anyone know how can I convert a value like 147k to 147000 at Microsoft Excel?

=LEFT(A1,LEN(A1)-1)*IF(RIGHT(A1,1)="K",1000,IF(RIGHT(A1,1)="M",1000000,1))

 

Found this on the googles, replace A1 with what you want to be substituted.

 

If you want to maintain the cell you can manually find+replace K\M in selected areas with 000 or 000000.

jagerbluebt1.gif

Thx to MxM for parts of the sig!

Link to comment
Share on other sites
SnuGGzZ

SnuGGzZ

Posted
Posted

Does anyone know how can I convert a value like 147k to 147000 at Microsoft Excel?

=LEFT(A1,LEN(A1)-1)*IF(RIGHT(A1,1)="K",1000,IF(RIGHT(A1,1)="M",1000000,1))

 

Found this on the googles, replace A1 with what you want to be substituted.

 

If you want to maintain the cell you can manually find+replace K\M in selected areas with 000 or 000000.

could you guys please be a little more off topic. try using pm

Aren't you like 35 Irl?

Fried_Chikn8.png

 

5b xp let's go!

Link to comment
Share on other sites
Coconut Bodywash

Coconut Bodywash

Posted
Posted

Does anyone know how can I convert a value like 147k to 147000 at Microsoft Excel?

=LEFT(A1,LEN(A1)-1)*IF(RIGHT(A1,1)="K",1000,IF(RIGHT(A1,1)="M",1000000,1))

 

Found this on the googles, replace A1 with what you want to be substituted.

 

If you want to maintain the cell you can manually find+replace K\M in selected areas with 000 or 000000.

could you guys please be a little more off topic. try using pm

It's for the purposes of his excel sheet directly related to this thread lol

  • Like 1

jagerbluebt1.gif

Thx to MxM for parts of the sig!

Link to comment
Share on other sites
Gemeos2

Gemeos2

Posted
Posted

Does anyone know how can I convert a value like 147k to 147000 at Microsoft Excel?

=LEFT(A1,LEN(A1)-1)*IF(RIGHT(A1,1)="K",1000,IF(RIGHT(A1,1)="M",1000000,1))

 

Found this on the googles, replace A1 with what you want to be substituted.

 

If you want to maintain the cell you can manually find+replace K\M in selected areas with 000 or 000000.

could you guys please be a little more off topic. try using pm

It's for the purposes of his excel sheet directly related to this thread lol

 

Exactly.

 

Sadly, your solution didn't work though. I am trying to import GE prices from GE database and make calcs with those numbers. So, it would have to be auto and not manually

My youtube channel with efficient skilling guides and achievements

Link to comment
Share on other sites
ProtoRob

ProtoRob

Posted
Posted

Does anyone know how can I convert a value like 147k to 147000 at Microsoft Excel?

=LEFT(A1,LEN(A1)-1)*IF(RIGHT(A1,1)="K",1000,IF(RIGHT(A1,1)="M",1000000,1))

 

Found this on the googles, replace A1 with what you want to be substituted.

 

If you want to maintain the cell you can manually find+replace K\M in selected areas with 000 or 000000.

could you guys please be a little more off topic. try using pm

It's for the purposes of his excel sheet directly related to this thread lol

 

Exactly.

 

Sadly, your solution didn't work though. I am trying to import GE prices from GE database and make calcs with those numbers. So, it would have to be auto and not manually

Grimy Bunyip's spreadsheets are of great use I imagine, although It looks pretty similar to the formula posted above. Here is the table of contents spreadsheet, If you wish to speak to him directly about it I'm sure you'd be able to find him if you performed a search in relation to wasting xp.

 

Thunder also did something similar and used this sentence to sort out "k":

=IF(ISERR(FIND("k",F33,1))=FALSE,LEFT(F33,(FIND("k(,F33,1)-1))*1000,F33)

 

that formula is in regards to the secondary cost for making saradomin brews, used in this spreadsheet.

Link to comment
Share on other sites
Poppe

Poppe

Posted
Posted

Top 15 Most Experience Update

 

(November 11th to November 17th)

 

Quick Highlights

 

Highest 3 Gains in the Top 15 this week:

1.) Drumgun (+28.5M)

2.) Jake (+26.7)

3.) Kingduffy (+21M)

 

Rank changes:

 

- Number1Boss hopped ranks 12 and 13 to be the new rank 12th.

 

Officially this week Allar leaves the top 15. If anyone is familiar with a quick history of Allar's skilling history I'd love to hear it.

 

Total experience gained by the top 15:

 

182.554 M

 

 

Full Update

 

 

 

 

 

1.) S_U__O__M_I

 

Total Experience: 4,747 M

Experience Gained: 0

 

Currently Inactive

 

 

2.) Jake

 

Total Experience: 4,038 M

Experience Gained: 26.696 M

 

Jake finished off 200M Herblore this week for his 18th 200M skill and then promptly started Construction. He ended the week 7M shy of the 100M mark in Construction as well. If he continues this pace we could see 200M Construction in about a month. He also passed 120M Farming experience this week as well.

 

 

3.) Elvis

 

 

Total Experience: 3,667 M

Experience Gained: 7.991 M

 

Slightly slower week for Elvis, but still focusing on Smithing. Still not positive how he is doing it as he is gaining a fair amount of magic experience to go along with it. Would make me think he is superheating. We should see Elvis get 200M Smithing as his 12th 200M skill next week.

 

 

4.) Jdelacroix

 

 

Total Experience: 3,652 M

Experience Gained: 7.386 M

 

Slayer and a mix of Runespanning for Jd this week. He managed to cross the 125M mark in slayer this week and is about 4M shy of 100M Runecrafting as well.

 

 

5.) Drumgun

 

 

Total Experience: 3,631 M

Experience Gained: 28.215 M

 

Drumgun is closing in on Jd and we could see a rank shift next week if each continue at there current pace. Drumgun is hammering out Construction as well and should be able to finish it within two weeks. Also managed some Firemaking experience this week, could mean he is using his daily Book of Char.

 

 

6.) Elias

 

Total Experience: 3,584 M

Experience Gained: 16.972 M

 

Fairly impressive hunter gains for Elias this week at almost 17M experience gained. He is about a week and half away from 200M Hunter as his 14th 200M skill.

 

 

7.) Almostlost

 

Total Experience: 2,965 M

Experience Gained: 3.448 M

 

Extremely slow week for Richard and appears he spent his week at Arctic Pines with 2M Woodcutting experience and 650k Firemaking experience this week.

 

 

8.) Telmomarques

 

 

Total Experience: 2,871 M

Experience Gained: 0

 

Inactive

 

 

9.) Paulrat3

 

Total Experience: 2,849 M

Experience Gained: 11.703 M

 

A mix of experience between Herblore, Thieving, and Dungoneering this week, along with 400k slayer experience. Fairly diverse week again for Paul.

 

 

10.) Kingduffy

 

Total Experience: 2,826 M

Experience Gained: 20.957 M

 

Big week for experience gains for the king, with 12M Prayer Experience gained and 4M Herblore experience gained. Be interesting to see if he keeps to these huge gains as he could possibly overtake Paulrat next week. Looking at his stats looks like Kingduffy is aiming for 100M base and he has 23M exp to go in both prayer and herblore currently.

 

 

11.) Dragonseance

 

Total Experience: 2,801 M

Experience Gained: 8.342 M

 

Runespanning and herblore for the Dragon. As of last night he was working on herblore again so he may be on the hunt to finish it off finally, only 19M more experience to go for 200M herblore and knowing Dragon he could do that in a few days.

 

 

12.) Number1 Boss

 

Total Experience: 2,721 M

Experience Gained: 20.639 M

 

Week of chinning for Number this week along with the usually daily tree runs.

 

 

13.) Robbie

 

Total Experience: 2,718 M

Experience Gained: 14.664 M

 

Robbie still continues to work on slayer and is about 11.4M away from 200M. He won't be able to finish it before EoC comes out though so will be interesting to his experience gains next week with the launch of it. Robbie also managed to get 200M Range this week for his 6th 200M, congrats :)

 

 

14.) Nico Robin (aka Chilly)

 

Total Experience: 2,708 M

Experience Gained: 4.272 M

 

Slow week for Chilly compared to her normal standards. This week was primarily Woodcutting for her with a tad mix of Fishing. She is about 30M experience away from 200M Woodcutting.

 

 

15.) Pope712

 

 

Total Experience: 2,689 M

Experience Gained: 11.269 M

 

This week Pope officially enters the top 15 and booting Allar out of the top 15. Pope trained a variety of skills this week and is close to 100M Prayer and also finished off 50M Hunter. He should also be able to get 150M Dungeoneering next week as well.

 

 

 

  • Like 1
siggy_zps7b2911b4.png
Link to comment
Share on other sites
-Kngkyle-

-Kngkyle-

Posted
Posted

Does anyone know how can I convert a value like 147k to 147000 at Microsoft Excel?

 

Replace function works. The '2' is the number of characters from the start to begin the edit. So if something is 35k instead of 5k then that number needs to be '3'. There may be a more perfect solution, but this is just the one I know off the top of my head.

 

2012-11-18_1739.png

Link to comment
Share on other sites
-Kngkyle-

-Kngkyle-

Posted
Posted

I exp wasted and came up with a perfect formula for what you wanted, Gemeos2. So forget the other one.

 

 

=IF(Q34<1000,Q34,(NUMBERVALUE(Q34,4,"k"))*1000)

 

 

2012-11-18_1807.png

 

 

To be more on topic: I got 200M thieving the other day for my 7th 200M. I'm also looking forward to EoC. Should be fun doing things differently for the first month or so at least.

  • Like 1
Link to comment
Share on other sites
Gemeos2

Gemeos2

Posted
Posted

I exp wasted and came up with a perfect formula for what you wanted, Gemeos2. So forget the other one.

 

 

=IF(Q34<1000,Q34,(NUMBERVALUE(Q34,4,"k"))*1000)

 

 

2012-11-18_1807.png

 

 

To be more on topic: I got 200M thieving the other day for my 7th 200M. I'm also looking forward to EoC. Should be fun doing things differently for the first month or so at least.

 

My Microsoft Excel found a mistake right there:

1rS1T.png

 

Tried the first idea but didn't work too... :(

 

My Microsoft Excel found a mistake right there:

1rS4S.png

My youtube channel with efficient skilling guides and achievements

Link to comment
Share on other sites
Coconut Bodywash

Coconut Bodywash

Posted
Posted

I exp wasted and came up with a perfect formula for what you wanted, Gemeos2. So forget the other one.

 

 

=IF(Q34<1000,Q34,(NUMBERVALUE(Q34,4,"k"))*1000)

 

 

2012-11-18_1807.png

 

 

To be more on topic: I got 200M thieving the other day for my 7th 200M. I'm also looking forward to EoC. Should be fun doing things differently for the first month or so at least.

 

My Microsoft Excel found a mistake right there:

1rS1T.png

 

Tried the first idea but didn't work too... :(

 

My Microsoft Excel found a mistake right there:

1rS4S.png

 

You probably don't have a Q34?

jagerbluebt1.gif

Thx to MxM for parts of the sig!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept