Zantareous Posted November 19, 2012 Share Posted November 19, 2012 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?(letter = column, number = row of relevant item; highly doubtful Gameos doesn't know this otherwise I'd love to know how he was managing without the knowledge O_o) Link to comment Share on other sites More sharing options...
vmser Posted November 19, 2012 Share Posted November 19, 2012 Dunno how it works everywhere, but try ';' rather then ',' to seperate the arguments. In my version (dutch), the ',' is set for the decimal point and ';' as seperator.If you use '.' for the decimal point, then ',' is free to be used as seperator. Link to comment Share on other sites More sharing options...
-Kngkyle- Posted November 19, 2012 Share Posted November 19, 2012 Try what the others mentioned. It's probably what vmser said. If not, obviously the 'Q34' needs to be changed to the cell you are trying to turn into a number. I presume you know that though. I'm using Excel 2013, so probably a little newer than whatever you've got. Not sure if that matters in this instance. Link to comment Share on other sites More sharing options...
Gemeos2 Posted November 19, 2012 Share Posted November 19, 2012 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? I do have a Q34. Dunno how it works everywhere, but try ';' rather then ',' to seperate the arguments. In my version (dutch), the ',' is set for the decimal point and ';' as seperator.If you use '.' for the decimal point, then ',' is free to be used as seperator. Tried that and now it says "#Name?" My youtube channel with efficient skilling guides and achievements Link to comment Share on other sites More sharing options...
Gemeos2 Posted November 19, 2012 Share Posted November 19, 2012 Found the sulotion. If the number is for example 5k:=Replace(Q34;2;1;"000") Thanks for the help. Going to work this week on manually transfer everything to Microsoft Excel. After that is done (takes hours), there will be no limit of players that we can track with the time calculator. My youtube channel with efficient skilling guides and achievements Link to comment Share on other sites More sharing options...
Auror Posted November 19, 2012 Share Posted November 19, 2012 Gratz Kngkyle on your 7th 200m :) And please, never ever waste xp again! Link to comment Share on other sites More sharing options...
jayc3399 Posted November 19, 2012 Share Posted November 19, 2012 Why do you want to move away from google docs? It is far more powerful for importing web based content then excel. Quest Cape Achieved on November 14, 2007Items AcquiredCrystal Pick and HatchetBerzerker Ring x 33/28 Barrows Items Link to comment Share on other sites More sharing options...
Platinum_Myr Posted November 19, 2012 Share Posted November 19, 2012 Why do you want to move away from google docs? It is far more powerful for importing web based content then excel. It has a 25 imports limit. Maxed since Sunday, January 9th, 2014Completionist since Wednesday, June 4th, 2014 Link to comment Share on other sites More sharing options...
jayc3399 Posted November 19, 2012 Share Posted November 19, 2012 It's actually 50. And the easiest way around that is to make copies of your maxed sheet and create a third consolidation sheet. This introduces a small amount of lag but I sounds like this sheet has a fair bit of that to begin with. Quest Cape Achieved on November 14, 2007Items AcquiredCrystal Pick and HatchetBerzerker Ring x 33/28 Barrows Items Link to comment Share on other sites More sharing options...
-Kngkyle- Posted November 19, 2012 Share Posted November 19, 2012 Found the sulotion. If the number is for example 5k:=Replace(Q34;2;1;"000") Thanks for the help. Going to work this week on manually transfer everything to Microsoft Excel. After that is done (takes hours), there will be no limit of players that we can track with the time calculator. I would highly recommend using the other function if that works with the changes, as it will never require editing unlike the Replace function which will break when something goes above/below 1k, 10k, 100k, etc. =IF(Q34<1000;Q34;(NUMBERVALUE(Q34;4;"k"))*1000) should work Why do you want to move away from google docs? It is far more powerful for importing web based content then excel. In my opinion, Excel is way easier to work with than Google Docs. But it's been awhile since I've used it so perhaps it's improved. Link to comment Share on other sites More sharing options...
Gemeos2 Posted November 20, 2012 Share Posted November 20, 2012 Why do you want to move away from google docs? It is far more powerful for importing web based content then excel. Microsoft Excel is far more powerful for importing web based content. Google docs fail alot when importing.Also, I can only track 25 players with Google docs (due to 50 import limit). The only bad side is that you wont be able to see the updated version of my weekly time calc posts... but I don't think many people use that anyway. My youtube channel with efficient skilling guides and achievements Link to comment Share on other sites More sharing options...
Spirit Eyes Posted November 20, 2012 Share Posted November 20, 2012 Congratz! :) The pure of flying! Link to comment Share on other sites More sharing options...
Hedgehog Posted November 20, 2012 Share Posted November 20, 2012 The only major advantage of gdocs is that it can be viewed by anyone or on any machine. For Gemeos's purposes, excel is the best option. Link to comment Share on other sites More sharing options...
Teddieh Posted November 20, 2012 Share Posted November 20, 2012 Has any top player said they'll quit because of EOC? Link to comment Share on other sites More sharing options...
Auror Posted November 20, 2012 Share Posted November 20, 2012 Has any top player said they'll quit because of EOC? No, because EoC isn't a bad thing. 5 Link to comment Share on other sites More sharing options...
SnuGGzZ Posted November 20, 2012 Share Posted November 20, 2012 Eoc is ftw lol. Mining is a joke now, 90k Xp p/h - no urns or superheat just juju pots and dropping with 1 key. 5b xp let's go! Link to comment Share on other sites More sharing options...
Teddieh Posted November 20, 2012 Share Posted November 20, 2012 ^ Turning certain skills into jokes isn't good... One of the reasons for playing the game is the feeling of accomplishment (or boasting rights) you get after completing a goal, and EOC only lessens that part of the game. Link to comment Share on other sites More sharing options...
haimonek Posted November 20, 2012 Share Posted November 20, 2012 ^ Turning certain skills into jokes isn't good... One of the reasons for playing the game is the feeling of accomplishment (or boasting rights) you get after completing a goal, and EOC only lessens that part of the game. Dude please... multiple skills have been devaluated over the years. Adding 1 or 2 more skills to the list is no biggie. Link to comment Share on other sites More sharing options...
Mylez Posted November 20, 2012 Share Posted November 20, 2012 ^ Turning certain skills into jokes isn't good... One of the reasons for playing the game is the feeling of accomplishment (or boasting rights) you get after completing a goal, and EOC only lessens that part of the game. Dude please... multiple skills have been devalued over the years. Adding 1 or 2 more skills to the list is no biggie. This much is true, I think top players quitting is generally down to the overall decrease in respect for skills. At least this is what players like Zezima said. EoC isn't that bad, I think players generally don't like change (myself included), the main problem is that hindsight makes us believe the "old" RS was preferable. Link to comment Share on other sites More sharing options...
Gemeos2 Posted November 20, 2012 Share Posted November 20, 2012 Arctic pines while splitting logs method nerfed. Not like it was the best method but still sad. My youtube channel with efficient skilling guides and achievements Link to comment Share on other sites More sharing options...
G0d_vs_D3vil Posted November 21, 2012 Share Posted November 21, 2012 Eoc is ftw lol. Mining is a joke now, 90k Xp p/h - no urns or superheat just juju pots and dropping with 1 key.i did 85k-90k w/o sum and mining suite so wheres the diference mining was 110-120k/h anyways :) just ppl were lazy to train powerskilling Arctic pines while splitting logs method nerfed. Not like it was the best method but still sad.well c2 just wc is 120k/h :l and doing fish wc , 70-80k fish 80-90k wc hope didnt change much after eoc:x Link to comment Share on other sites More sharing options...
SnuGGzZ Posted November 21, 2012 Share Posted November 21, 2012 Eoc is ftw lol. Mining is a joke now, 90k Xp p/h - no urns or superheat just juju pots and dropping with 1 key.i did 85k-90k w/o sum and mining suite so wheres the diference mining was 110-120k/h anyways :) just ppl were lazy to train powerskilling It's not faster in any way, just way easier and more afk. 5b xp let's go! Link to comment Share on other sites More sharing options...
Gemeos2 Posted November 21, 2012 Share Posted November 21, 2012 Eoc is ftw lol. Mining is a joke now, 90k Xp p/h - no urns or superheat just juju pots and dropping with 1 key.i did 85k-90k w/o sum and mining suite so wheres the diference mining was 110-120k/h anyways :) just ppl were lazy to train powerskilling Arctic pines while splitting logs method nerfed. Not like it was the best method but still sad.well c2 just wc is 120k/h :l and doing fish wc , 70-80k fish 80-90k wc hope didnt change much after eoc:x GDs are much faster now. So, whatever XP rate people got before EoC, was increased. My youtube channel with efficient skilling guides and achievements Link to comment Share on other sites More sharing options...
Swisscooler_ Posted November 22, 2012 Share Posted November 22, 2012 gemeos2, Are there already some new xp rates of c2 or other skils since eoc which you can add to ur calc? edit: and i'm sure that now most of the top players do mining while superheating, so there will be much decrease of time left? Link to comment Share on other sites More sharing options...
Gemeos2 Posted November 22, 2012 Share Posted November 22, 2012 gemeos2, Are there already some new xp rates of c2 or other skils since eoc which you can add to ur calc? edit: and i'm sure that now most of the top players do mining while superheating, so there will be much decrease of time left? There wasn't any accurate XP rate of c2 before EoC. So, "new" XP rate is unthinkable yet.I won't add C2 to my time calc though because top players doesn't really use it. My youtube channel with efficient skilling guides and achievements Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now