November 17, 201213 yr 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?
November 17, 201213 yr 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.
November 17, 201213 yr 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 - 97kSmithing - 220kMagic - 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
November 17, 201213 yr Does anyone know how can I convert a value like 147k to 147000 at Microsoft Excel? My youtube channel with efficient skilling guides and achievements
November 17, 201213 yr Does anyone know how can I convert a value like 147k to 147000 at Microsoft Excel?Set the field as a number I'm guessing. [-- DYNAMIC SIGNATURES FOR RUNESCAPE 3 & OLDSCHOOL 2007 RUNESCAPE --]
November 17, 201213 yr 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. Thx to MxM for parts of the sig!
November 17, 201213 yr 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 pmAren't you like 35 Irl? 5b xp let's go!
November 17, 201213 yr 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 pmIt's for the purposes of his excel sheet directly related to this thread lol Thx to MxM for parts of the sig!
November 17, 201213 yr 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 pmIt'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
November 17, 201213 yr 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 pmIt'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 manuallyGrimy 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.
November 17, 201213 yr That's Google docs. My youtube channel with efficient skilling guides and achievements
November 18, 201213 yr 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 MExperience Gained: 0 Currently Inactive 2.) Jake Total Experience: 4,038 MExperience 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 MExperience 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 MExperience 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 MExperience 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 MExperience 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 MExperience 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 MExperience Gained: 0 Inactive 9.) Paulrat3 Total Experience: 2,849 MExperience 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 MExperience 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 MExperience 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 MExperience Gained: 20.639 M Week of chinning for Number this week along with the usually daily tree runs. 13.) Robbie Total Experience: 2,718 MExperience 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 MExperience 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 MExperience 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.
November 18, 201213 yr Very nice update, Poppe! :) It feels weird to see that Suomi hasn't gained xp, and that Allar flew out of the top15 :/
November 18, 201213 yr 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.
November 18, 201213 yr Thanks for the update! Glad to see Kingduffy with some larger gains this week :)
November 18, 201213 yr 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) 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.
November 19, 201213 yr 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) 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: Tried the first idea but didn't work too... :( My Microsoft Excel found a mistake right there: My youtube channel with efficient skilling guides and achievements
November 19, 201213 yr 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) 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: Tried the first idea but didn't work too... :( My Microsoft Excel found a mistake right there: You probably don't have a Q34? Thx to MxM for parts of the sig!
Create an account or sign in to comment