Tsoran Trainer v4.2.9 (CMAN Update and moving forward)

[Bobmuhthol]

Someone in another thread mentioned wanting Tsoran's trainer to include the new CMANs so I updated it for that. If there are any other bugs or update requests I would be happy to look into them.

For now, here's the version with the new CMAN information -- and thanks to Buckwheet for being a real bro and hosting it for me:

http://www.cmnservicesgroup.com/tsoran/trainer.html

I haven't tested it extensively so please let me know if I broke something.

[Tsoran]

If you got it to work, you probably found most if not all of the things that need changing.

The only thing that might conceivably be missed is some of the formulas in the hidden rows further down on the CMAN page. (Normally that stuff would have been on another (hidden) sheet, but there's some stuff that only worked on the same sheet, so it's there, but hidden. Ugly, but it worked.

Chances are if you got it so that it appears to be working, it probably is. Thanks for picking up the torch!!!

[Meos]

Nice, thanks. To both of you guys.

[Makkah]

Nice

[Buckwheet]

Just because I am not one to like static URLs, in case shit changes, I updated the web page to reflect we actually now DO have a beta version.

http://www.cmnservicesgroup.com/tsoran/trainer.html

That should be the "go to" link.

[Makkah]

Do you play again, Bobmu?

[Bobmuhthol]

No, I'm staying away. This is just good practice for me.

[Anebriated]

anyone get this to work with openoffice?

[Buckwheet]

anyone get this to work with openoffice?

I am 99% sure that macros in Open Office are coded a lot differently than in Excel.

So all of that would be broken in OpenOffice.

[Bobmuhthol]

After opening the spreadsheet in OpenOffice I can comfortably say that there will not be a version that is compatible.

[DaCapn]

I noticed that the shadow mastery cost is incorrect. The costs should be:

Squares: 2/4/6/8/10
Semis: 3/6/9/12/15

Thanks for the update.

[Drew]

If you already have made the spreadsheet in office I've had good luck manipulating training in open office. It adjusts TPs and such correctly. I haven't had any luck starting from scratch.

[Bobmuhthol]

Shadow Mastery is listed on play.net with the costs in the spreadsheet but I will assume you/Krakiipedia are correct and change them.

[Axhinde]

Any way to get the ranged AS and DS to work? Seems off in the old spreadsheet. AS was slightly off for me and DS was way off.

[Buckwheet]

new version uploaded

[Wharde]

Nice to see you're still around to a degree, Tsoran.

[Bobmuhthol]

Any way to get the ranged AS and DS to work? Seems off in the old spreadsheet. AS was slightly off for me and DS was way off.

If you can point me to the correct formulas I'll try to work something out.

[Axhinde]

http://www.krakiipedia.org/wiki/The_Art_of_the_Bow_(guide))

[Tsoran]

Hey guys,

The last version of the spreadsheet that I put on the website was version 4.2.8. I had made subsequent changes (which would have been in v4.2.9 if I had ever put it out on the web.)

Here's the release note section for 4.2.9:

"On the CMAN sheet, added the Coup de Grace, Cunning Defense, Divert, and Vanish CMANS. Side by Side is now available to all professions. Shadow Mastery is no longer allowed for Monks, and the point cost for Rogues and Rangers is reduced by one point per rank."

Hopefully that information is useful.

If you want, I can forward the unreleased 4.2.9 to you, but it sounds like you got most of it. The only thing I didn't see mentioned in the mods you've made is the part about the profession availability changing for the Shadow Mastery and Side By Side CMANs.

[Buckwheet]

That would be helpful. If you could zip it and upload it to google docs and then share it with me. That would be great.

I am PMing you my email.

[Tsoran]

As for the AS/DS formulas... I'd be surprised if ANY of them were close to accurate anymore.

They got a lot more complicated in GS4, and kept getting more and more complicated as the years went by. Not only did just keeping up with the formulas become more difficult, but finding a way to reasonably allow people to represent any training plan became increasingly difficult. Furthermore, in GS4, it just seemed far less critical what your numbers were; tactics became more important while raw numbers were less important than in GS3.

As a result, I stopped trying to keep the AS/DS sheets accurate. In GS3, those numbers decided if you lived or you died; in GS4, they didn't seem to matter that much. For years I had been contemplating just removing those sheets altogether, but kept them in just in case, since putting them back later would involve more than a little effort.

[Tsoran]

In case anyone wants it, I put the unreleased 4.2.9 on google docs (thanks for the idea, Buckwheat!).

Here's the link:

https://docs.google.com/leaf?id=0B2UBjkuV2lYfODYxNTA5OGEtNDY1YS00NWJjLWFlZ jktMzE5NzJjNjE0MmE5&hl=en_US

No guarantees as to whether the stuff in there works, but I suspect it does.

Here's the link to the associated doc file, but the only thing different in there is the release note, which I posted a few comments up.

https://docs.google.com/leaf?id=0B2UBjkuV2lYfNzFlZDhkZjktZDI5Ny00MjM5LTk1M zctYmMzYTg5Yjk2MDA1&hl=en_US

Mike

[Bobmuhthol]

I will make a note to include your changes and my next release will be when I either successfully recode ranged AS or give up.

[Bobmuhthol]

Ranged AS: DEX Bonus + Bow/Arrow Enchant (+50 max) + Ranged Skill + ((Ambush ranks – 40/4) + Perception ranks – 40/4)) + Spell effects (211, 215, Warcry, 1606, 425, etc.)

Is that intended to be (Ambush ranks - 40)/4? I am reading it, syntactically, as Ambush|Perception Ranks - 10 and I'm assuming it is intended to be Ambush|Perception Ranks / 4 - 10.

Edit: Furthermore, when do I round, truncate, etc.? I am very close to just writing it like this:


DEX bonus + Ranged Skill + INT((Ambush Ranks + Perception Ranks) / 4) - 20 + Enchant + Spell Effects


The way I've written it, a level 20 elf rogue with 100 DEX (30 bonus), 2x ranged, 2x ambush, 3x perception, and a 0x bow with no enhancements should have an AS of 162. Someone should sanity check this figure for me.

The spreadsheet also has a checkbox for hiding and claims that ranged AS is different when hiding. Is this the case?

[DaCapn]

Sample ranged AS calculation:
http://forum.gsplayers.com/showpost.php?p=893326&postcount=21

In that post, I mentioned something about whether you could be 4x between ambush & perception and still get the full bonus (e.g. 1x ambush, 3x perception). I tried it out once and found that they're capped at 2x each. i.e. 1x ambush, 3x perception would count as 1x ambush, 2x perception for purposes of ranged AS.

[Bobmuhthol]

And that cap does not exist when adding the ranged skill bonus? Thanks for this.

[Asrial]

Ranged DS Formula: http://forum.gsplayers.com/showpost.php?p=954443&postcount=7

The rest of the DS formulas are there too. Read the notes for each one to see the status of them.

[Asrial]

The spreadsheet also has a checkbox for hiding and claims that ranged AS is different when hiding. Is this the case?No.

..and the formula is..

(((perception - 40) / 40) + ((ambush - 40) / 40))

.5 and .75 rounds up, .25 rounds down

PERCEPTION is capped at (level * 2)

AMBUSH is capped at (level * 2 + 2)

[Bobmuhthol]

I'm making progress!

[BriarFox]

Added some parentheses to my guide to clear up the AS formula. These guys are dead on.

[mgoddess]

Looking good... any chance of having the Armor skills system implemented at some point?

[Stry]

Not too* shabby. I've been toying with a few things, being an excel guru wannabe myself.

I noticed you seem to have missed Cunning Defense from your list. - It's a newer(ish) Cman.

If nobody gets you the info from Krakii I will later once I'm not at work.

[Bobmuhthol]

Cunning Defense is in my copy, v4.2.10

[Stry]

Ah, it seems I have v4.2.8

[AquiziTC]

I'm having a hard time saving this file after I pop in some stats and skills, as it's not wanting to save it with the macros in place.

Or, even worse, having real compatibility problems with the CMAN conditional formatting.

How can I fix these issues to be able to save this workbook?

[Tsoran]

I'm going to jump the gun and ask a few questions that Bobmuhthol probably will need the answers to in order to respond to you:

What spreadsheet software are you using? Excel or Open Office? What platform (Windows, Mac, or Linux)? What version of the software?

Also, do you have this problem with my older spreadsheets, or just with the new one from Bobmuhthol (which may have been created by a different version of Excel than what I'm using.)?

[AquiziTC]

Ah, I'm sorry.

Just 4.2.10, and I run Excel um.. 2007 on a Windows machine. When I open the file in general, it opens in Compatibility Mode (or so it says up top, I didn't notice that until I was making sure I ran '07)

Edit: 4.2.8 runs fine, and I use that sheet for my cleric, however I'm dabbling with a rogue and I need the updated sheet for the CMANs.

[Tsoran]

Find my note in this topic where I posted a link to where I put 4.2.9 on google docs. (Or, I could just post the link again: https://docs.google.com/leaf?id=0B2UBjkuV2lYfODYxNTA5OGEtNDY1YS00NWJjLWFlZ jktMzE5NzJjNjE0MmE5&hl=en_US)

4.2.9 has the cman changes in it, so it should be what you need for your rogue.

I'm guessing 4.2.10 was saved from office 2010 which I suppose could cause issues with earlier versions of Excel.

[Bobmuhthol]

I am saving the files in Excel 2007 as 97-2003 (.xls) files. Excel does warn me about compatibility issues with previous versions but I would think there wouldn't be a problem if you run it in 2007.

[mgoddess]

Speaking of "problems", I noticed the CMan sheet not working quite right...

http://i1083.photobucket.com/albums/j397/moon81goddess/GSSpreadsheetCManWonkiness.jpg

It's calculating the usage correctly, but it isn't putting the used points in the right places. As shown in the above image, it's putting the points for Crowd Press, Dirtkick, Multi-Fire, Spin Attack, Staggering Blow, Tackle, Trip, Twin Hammerfists, and Weapon Bonding in/under Truehand. I believe I saw other non-Warrior CMan's doing a similar thing...

[Tsoran]

I tied opening 4.2.10 (I'm using Excel 2007 also), and immediately saving it as a macro-enabled workbook (.xlsm). Obviously, I've got macros enabled in Excel.

I get a warning message about the wookbook containing features unsuppored in that file format:

Excel 5.0/95 Menu Editor Customizations

After hitting OK, things seemed to work fine. I'm not sure what that problem is caused by. Never saw it before.

I tried putting in a training plan and saving it. No problems.

Aquizi, I suspect your problem is caused by a safety feature in Excel. Out of the box it won't let you run macros. I believe you need to turn it on before it will let you save the spreadsheet with macros enabled. I don't remember the exact process, but you should be able to find the directions to do so in the Excel help system pretty easily.

Bobmuthol, you probably haven't gotten to this yet, but the "Import from old spreadsheet" button doesn't seem to be working. There's a hidden sheet which contains tabular metadata for mapping all old versions of the spreadsheet to the current spreadsheet. This needs to be updated for each release by adding a new column for the current release number. I probably did NOT do that for 10.2.9, so the button is likely busted in that release also. I recommend that when you add the data in there for 4.2.10 that you also add the data for 4.2.9. Since 4.2.9 is publicly available (unfinished as it is), it's conceivable that someone will use it and then try to upgrade from .9 to your new .10. If there's no column for .9, the upgrade won't work.

Also, along the same lines, you probably won't want to let people see early "beta" versions of spreadsheets, or at least make sure you change the version numbers between beta releases. There may be issues with doing an import from one version to the next if they have identical version numbers. Certainly you must absolutely change the version numbers when the meta data changes when you add or re-arrange data.

The front trainer sheet contains references to my old email address and URL. Since the registration on tsoran.com has lapsed, those no longer work. It seems like someone has re-registered the domain name, so who knows where it's going to point to. I'm surprised it took this long. You should remove the references to the tsoran.com domain, unless, of course, you're the one who registered it. ;)

[Buckwheet]

I tried to buy it, but it went to auction and was sold for $99 and it now owned by a domain camper who sells them for profit.

[Beguiler]

Mkay, my inner blonde is acting up, and I got confused. Where do I go to get the latest and greatest iteration? Pleeeze?

[mgoddess]

--> http://www.cmnservicesgroup.com/tsoran/trainer.html

The second "Click here" link is the one you want.

[Bobmuhthol]

I think I found the problem with the total ranks showing up under truehand. I'll fix it as soon as I can.

[Beguiler]

Thanks!

[Tsoran]

I tried to buy it, but it went to auction and was sold for $99 and it now owned by a domain camper who sells them for profit.

Heh! Cool, he just wasted $99. :)

[Jace Solo]

So this isn't live anymore huh?

[Buckwheet]

No, its still up? My webhost might have been offline for a quick moment. I had a couple emails this morning that the site was not reachable.

[Jace Solo]

Thanks

[Deathravin]

I never liked the look of Tsoran's trainer. Seemed too spread out for me. Don't get me wrong, its fantastic at what it does, but the look was just off for me.

So I made my own trainer quite a while ago while I was playing shattered... Here's what I made. it's unbelievably unfinished, and heavily steals from Tsoran, but I liked how it looked.

I had some goals for it:

a capped trainer tab, but I couldn't ever think of a good way to do it.
As small as I could make it
A Lock mastery tab
Include as few macros as possible
Work better with enhancements (the "en" column)
A lot of visual improvements
Help choosing stats
Help with training (a ranked list of final goals, and it would train it for you)


At any rate, I get my excel jones very satisfied with my job now, so I don't see me ever finishing it.

preview (http://i.imgur.com/DAWHE.png)
download (https://docs.google.com/open?id=0B61hVPf1lATWNTM4YzIwNzMtYjgxNi00YmIwLWJiN jAtNzA5MGJjYzRlZTI4) (file, download original)

[Asrial]

Thanks Deathravin :)

[Aeronal]

this looks so nice.

thanks for the updates!

[Makkah]

Might be a question already answered somewhere... but fuck it...

Is there an online trainer? Don't currently have a PC worth a shit to access from except this little piece of shit 10 inch laptop with no Office.

[DaCapn]

The short answer is basically "no."

There's some kind of script on the lich repo called "profiler" which does some kind of training predictions and whatnot. I haven't played with it but it uses your character info to do something training-related.

Celephais (I think) made a web-based traininer for wizards or bards or something (he simply modified the GS character manager such that you can plug in however many TPs you want). It requires some leg-work and he may not be hosting it anymore either.

The character manager is all client-side, though. It would be totally feasible for someone web and javascript-savvy to just modify the the manager to expand it to a general character manager. There are a number of people who could probably do this but it would be a significant time investment for little real payoff.

Along those lines, you could also use a firefox extension like firebug to edit the javascript on that modified character generator (if it's still around) to set your profession TP costs.

[Deathravin]

I could probably make a Google Documents version of the spreadsheet...

*edit* The only problem with a g-docs version is speed. It's a lot of calculations, and while Excel is fast enough to build & play Excel PacMan, g-docs isn't. It has trouble with most simple charts I've given it... Although I suppose it did somewhat okay with that item seller sheet for shattered I made a while ago, I'll give it a try this weekend and see how it goes.

[Sygil81]

Giving this a shot. If it can be cloud-i-fied through google docs or some other means, that would be awesome. I don't have office on my home computer, so I have to jump through hoops to remote into my work to look up training spreadsheets :/

Positive comments:
-Lightweight (260k vs. 5.5mb lol)
-I like the training points at the top. On the old one, I couldn't train armor use without massive scrolling to watch my TPs, or have a much higher vertical resolution.

Constructive Criticism:
-I see what you're doing with the colors, but scrolling on it literally makes me motion sick. I can remove those myself, tho.
-When I scroll all the way to the right near 100, the bottom horizontal scrollbar maximizes. Then when I scroll a little to the left, it re-adjusts and dumps me back to the left side. Anywhere in between is fine, it's just the right side max that seems to be bugging.

Does this work in Open Office or did I not read that part of the thread?

[Deathravin]

Thank you very much for the criticism.

The size has mainly to do with the fact that Tsoran's trainer has far more functionality than mine. Also, that his was built on Excel 2000/03 (If not 97), and the 2010 .xlsx format is naturally zipped (in fact, it IS a zip file. If you rename an xlsx(m) file to .zip, you can uncompress it - it's just a bunch of databases and xml files). It stands to reason if I added the same functionality, mine would grow as well.

Tsoran Trainer Sheets size:
Sheet|Size (kb)
Trainer|862
Roundtime|114
Ambushing|31
CMAN|1540
Lockpicking|141
Attack Strength|202
Defense|153
Experience|65
Magic|420
Spells|152
Stand By|1
DataCopy|322
Tables|131
Buffer|926
VBA Code|235

The colors can be easily changed. I set them up so they used the theme colors, so you can change the theme colors by going to Page Layout, Colors.

I see the scrollbar thing too, that is very strange. It has to do with my habit of hiding unused columns & rows. It happens on any spreadsheet I have that's more than a page wide and I've hidden the remaining columns (when I scroll all the way to the end, the scrollbar goes strange).

It wasn't built in Open Office, but it does work in OO... I'd rather remake it in G-Docs.

[Kithus]

Just an FYI I've got a new version of Tsoran's spreadsheet just about completed for monks including making them a square, training costs and new CMans. I'm just waiting on updated GIs and I want to include the weapon types that aren't currently available in it. I also have no place to host it currently.

[mgoddess]

Just an FYI I've got a new version of Tsoran's spreadsheet just about completed for monks including making them a square, training costs and new CMans. I'm just waiting on updated GIs and I want to include the weapon types that aren't currently available in it. I also have no place to host it currently.
Woooo, awesome!

If you have a Google account, Drive (aka Docs) is a good place to host. Alternatively, if you don't have a Google account (and don't want one), you could sign up for Dropbox and put it there.

Or, someone with webspace and bandwidth could host it. :shrug:

[Lulfas]

Just an FYI I've got a new version of Tsoran's spreadsheet just about completed for monks including making them a square, training costs and new CMans. I'm just waiting on updated GIs and I want to include the weapon types that aren't currently available in it. I also have no place to host it currently.

I can toss it up on my website, if you'd like.

[Kithus]

I appreciate the offer and I'll be happy to pass it to anyone who wants to host it as soon as I get the monk GIs. Unfortunately its rather pointless until those are correct.

[DaCapn]

On one of the more recent trainer revisions, I noticed that the combat toughness CM point cost was off. If anyone makes an update and has a chance to check it, here's the cost directly from CM HELP in-game:



Skill Name: Combat Toughness
Mnemonic: toughness
Hostile: No
Stamina Cost: None.
Other Requirements: None.
Available to: Warriors, Rogues, Monks, Paladins.
Prerequisites:
None
CMP Cost:
Rank 1: (Squares) 6 (Semis) 9
Rank 2: (Squares) 8 (Semis) 12
Rank 3: (Squares) 10 (Semis) 15
Description: Permanently enhances your maximum number of Health Points (HP) by 5 plus 10 points per rank.

[Jace Solo]

I appreciate the offer and I'll be happy to pass it to anyone who wants to host it as soon as I get the monk GIs. Unfortunately its rather pointless until those are correct.

Oh, I want! And happy 666...or sad 666...whatever, to whoever's into that...

[Kithus]

Alright the GIs are still wrong so don't trust your stat growth for monks at all but otherwise it's a useful tool. Please e-mail, IM or respond here if you have any problems with it. It couldn't be converted to google document format because the formulas are too complex so you'll have to download it and use excel.

TrainerGS4v4.3 (https://docs.google.com/open?id=0BwK2Wh8fyR_LOGxZTzRZanZPT1U)

[Deathravin]

Ya, having to simplify the formulas was the block I found too... I started separating out the different parts of each formula and putting them into their own cells to make it more simple in each place, but it got to be too much effort for the payoff so I stopped.

[hockeyinheaven]

Is there a place to get the old trainer that works for the other professions as well? I had one eons ago but haven't had one since my computer crashed. Unfortunatly, my daughter had gotten ahold of the external drive I used for backup and decided it would make a good bath toy. Anyway... I don't have it anymore. Any help out there? Thanks in advance

[Kithus]

The link I posted is the updated version of the old trainer. It still handles all the older professions, I just added all the monk stuff.

[Deathravin]

Everything from stat growth to skill costs will probably be tweaked up and down for at least a couple months after release. Going to be a pain in the butt.

[mgoddess]

Trainer's buggy now, even when not working with the Monk class selected... the CMAN sheet isn't counting points used/remaining correctly, and the Spells sheet is all kinds of not working (when trying to click the checkbox for spell 1130, it checks the boxes for 1130, 1204, 1208, 1216, and 1220; no checkbox for 1601; when clicking the "Show Selected Spell Bonuses" button, the "Stand By" sheet presents a Run-time error '13': "Type mismatch", however, when clicking the "Show Known Spell Bonuses" button, no error occurs).

[Kithus]

Alright I'll get into it and see what I broke.

[Kithus]

I'm in the middle of a WoW raid but I will get that fixed tomorrow. The problem with 1130 was a matter of copying that checkbox for the monk spells and not reassigning the cell. The other issues are background code and will take a bit more time.

Edit: Tested the show selected spells bonus button and didn't experience an error. Could you tell me exactly what spells you have selected when you do so?

[mgoddess]

Edit: Tested the show selected spells bonus button and didn't experience an error. Could you tell me exactly what spells you have selected when you do so?
Off the top of my head, I think it was: 101, 102, 103, 104, 105, 107, 112, 120, 202, 204, 207, 211, 215, 218, 219, 401, 406, 414, 503, 507, 509, 602, 611, 618, 911, 1109, & 1119.

[Kithus]

The problem with selecting 1130 on the spells page also selecting all minor mental spells is corrected. The highlighting on the CMAN page is now working properly.

I was unable to recreate the error message with Show Selected Spells Bonus. if you can recreate the error I'd be interested in your exact settings at the time.

I've updated the original link to point to the corrected version. Thank you very much for the feedback.

[MrMortimur]

Finros posted monk GIs

STR: 25
CON: 25
DEX: 20
AGI: 30
DIS: 25
AUR: 15
LOG: 20
INT: 20
WIS: 15
INF: 10

[Kithus]

The spreadsheet has been updated with the correct monk GIs.

TrainerGS4v4.3 (https://docs.google.com/open?id=0BwK2Wh8fyR_LakRxaTN1dnNwMmc)

At this point I am planning to keep the main document on google docs so I can easily access it for editting. I will likely place the appropriate link on GSGuide.net once I get ahold of Mario and beat him for locking down the editting so much I can't. I'm also considering creating a page for it on Krakiipedia along with change notes, etc but I need to get ahold of Naos to allow me editting.

My hope is to make this easily available and accessible to anyone that wants to use it, as it used to be on Tsoran's site, and to keep it relatively up-to-date. I'd also consider new feature requests as time and my personal excel abilities permit.

[JustDan]

Does this handle post-cap training and TPs accurately? A previous version of it I used most definitely didn't. Just curious if that's been added/fixed somewhere along the line.

[Kithus]

The short answer is I haven't made any improvements beyond adding monk stuff properly. That said my main is post cap and its something I'd like to do. Would an additional column after level 100 that handles post cap training totals be enough? What would people like to see for post cap functionality?

[JustDan]

The short answer is I haven't made any improvements beyond adding monk stuff properly. That said my main is post cap and its something I'd like to do. Would an additional column after level 100 that handles post cap training totals be enough? What would people like to see for post cap functionality?

I'm just looking for the ability to play with training plans, is all. Getting the skill points accurate based on the XP total, so I can see what's affordable and what isn't. Another column would work great for me.

[Kithus]

I've updated the link again. Apparently in version 4.2.9 (read as: before me) the formula for AGI GI on the trainer page was overwritten by a hard value of 25 for all classes/races. I've replaced the formula to correct the problem.

[Jace Solo]

Says unable to view at present.

[Kithus]

Says unable to view at present.

It is not going to be available to view as a google doc. The formulas are too complex for google docs to handle. What you need to do is click the link to download the sheet and run it in excel locally.


Does this handle post-cap training and TPs accurately? A previous version of it I used most definitely didn't. Just curious if that's been added/fixed somewhere along the line.

Alright but only because you asked nice:

TrainerGS4v4.4.3.1BETA (https://docs.google.com/open?id=0BwK2Wh8fyR_LTHgtNVYwOE5sTWM)

Please note the file is BETA. I've added what I think are the appropriate settings to handle post cap training and tested it with my own post cap character but I cannot promise it's perfect. If something needs to be fixed please let me know. When I'm satisfied its bug free that will replace the current release version.

Disclaimer: This spreadsheet is available for use as is and used at your own risk. I offer no warranty of any kind on the sheet nor will I accept any liability as a result of damages from its use.

[Jace Solo]

It keeps telling me I can't do things because it's protected and when I try to turn it off it requires a password? What am I doing wrong? Trying to go through the skills part

[Kithus]

I'm sorry could you be more specific? Everything should be protected unless you're meant to add info there. As for turning off the protection I didn't add a password to it so you're welcome to change anything you want but I'm only supporting the uploaded version without changes.

[Jace Solo]

It's been a long time since I used the spreadsheet. I see where I went wrong for that.

In calculating AS (for spells) it seems not to pull in the spell bonuses where it should. Citing =HLOOPUP(J1,E24:DA35,11) and then societal bonus cited as =HLOOPUP(J1,E24:DA35,12).

Did I skip over a place to add the society?

[Asrial]

For anyone that used to use Tavarion's, here it is updated with Monks.

I also found a pretty serious error with Paladins that got fixed (wrong skill costs).

[EDIT: Since this is from Excel 97 originally, I think I may have re-introduced an error from way back when (missing reference, etc etc). I'm going to take this opportunity to re-create everything with a newer Excel.]

[Kithus]

Alright I did some major updates to the 4.3.1beta to get more of the post cap stuff working properly. Let me know if you experience issues.

[mgoddess]

when clicking the "Show Selected Spell Bonuses" button, the "Stand By" sheet presents a Run-time error '13': "Type mismatch", however, when clicking the "Show Known Spell Bonuses" button, no error occurs
Figured this error out... having "Focus" as the spell base duration on the Tables worksheet was fucking it up. Replaced "Focus" with "?" (like what Bard Songs have), and "Spells" sheet is happy.

[Kithus]

Thanks for that mgoddess. I've fixed that in the latest version as well as correcting some problems with the Cman sheet and updating a host of formulas that were not able to calculate correctly with the level set to "Post." The most up-to-date version can now always be found at:

Training Spreadsheet on GSGuide.net (http://www.gsguide.net/index.php?title=Training_Spreadsheet)

[Asrial]

Okay, I got Tavarion's spreadsheet transferred over to Excel 2k3 so there should be (hopefully) no errors when using it.

I still have some things that I'd like to change, and maybe add (especially a manual), so there are still some things that are a bit awkward and a couple of notes.

Everything works though and I rechecked all the numbers for everything. Monks have been updated to reflect the info on Krakiipedia.

The difference between Tsoran's and Tavarion's is that Tsoran's does a lot where Tavarion's is only for stats and skills.

Back in the day, you could have performance issues with Tsoran's and so that's why I liked Tavarion's and have since stuck with it.

[clarkeemilia601]

The latest edition of the Elanthian Journal is now available for sale. Features for this issue cover the kidnapping of Captain Jezzbelly, the effect of the Spitfire on the local kobold population, and the announcement of a cultural pageant in Icemule Trace. Look for the nearest hovel to buy your copy now!

[clarkeemilia601]

http://www.webcam-steamate.com/cookies/42/b/happy.gif

Serious bug in the safari zoo in TZ2:

I had 6 new animals I was able to purchase today, and I bought the first 2 of each animal.

The first two of those, and presumably all 6, were actually the "prizes" from completing training levels in TZ2 safari. After completing level 1 it gave me a 3rd Green Acouchi. I wonder what would have happened if I already had 4 of them? Or if I was breeding the 4th when I got one as a prize?

[Kithus]

A few minor updates to the spreadsheet:

- 7/9/12: Fixed a small error in one of the total mental training point display formulas

- 7/9/12: Added Combat Mobility to the available monk Cmans

- 7/9/12: Combat Manuvers with Pre-requisites will now "yellow out" until the pre-reqs are met


If there are other features that should be added (Beyond a UAF calcuator which I'm working on) please let me know.

[Kithus]

- 7/14/12: Fixed a serious bug with the monk TP formula that was still using the old prime stats in places (Thanks Kaliq)

[Asrial]

What's the new monk modifiers?

[Kithus]

What's the new monk modifiers?

Monks were originally slated as Semis so they had I believe agility and discipline as prime stats. With the change over to squares they got strength and agility as prime stats.

Also another update:

- 7/14/12: Bit of careless copy and pasting with the last fix broke TP truncating (Thanks again Kaliq)

[Lulfas]

With Monk selected, putting points into feint acts kind of wonky. First 3 points are fine, 4th point doesn't add to your total ranks

[Kithus]

With Monk selected, putting points into feint acts kind of wonky. First 3 points are fine, 4th point doesn't add to your total ranks

Are you selecting a rank beyond your currently selected level? The total ranks will only take into account anything up to that point.

[Lulfas]

Are you selecting a rank beyond your currently selected level? The total ranks will only take into account anything up to that point.

That is the exact issue. Thank ya kindly.

[FNLN]

At risk of necroing this thread, is there an updated "full featured" (Tsoran's, perhaps?) spreadsheet out there? Followed up on some of the options presented in the thread and the GSGuide one is a no go.

[mgoddess]

I've slowly been working on updating a "full featured" version of Tsoran's spreadsheet... still have a couple of kinks to work out, but it's mostly working (the two major kinks that I haven't worked out yet are the CMan sheet showing cman's that professions don't have access to, and the spellsheet f'ing up on calculating spells past a certain number of spells selected; edit: also, making it so that Monks have MnS and MnM, instead of MnM and Monk, spell circles, on the main "Trainer" sheet).

Here's a link: https://docs.google.com/open?id=0By7EkVY5JsHvOXg1dWxnbWhPUkE

[Calbrenar]

Is there a version of this floating around with the monk prime stats set properly? I've downloaded 4 or 5 various versions described as beta or WIP and all of them list the monk stats as DIS/AGL while GS has them as Str/Agl

[Kithus]

Version 4.4.4 Beta of the training spreadsheet is now available. I've added a new Shield tab, similar to the Cman tab to calculate your shield skills. I'll be adding the new manuvers later today. As always the latest version can be found at:

http://gsguide.wikia.com/wiki/Training_Spreadsheet

Keith/Kithus/Brinret

[Kithus]

Added the new manuvers, shield prereqs and some general cleanup. If anyone has any requests now is the time to tell me while I'm working on it.

[Fallen]

Cool resource. Thanks for keeping it current, Kithus.

[Whirlin]

Yeah... tiny VBA Thing... on the subroutine after the profession switch, could you turn screenupdate off and then turn it on at the conclusion of the script? Minor tweeks like that really help performance and aethetics.

[Daiyon]

I keep getting a runtime error 13 if I try to autofill when the value of "target level" = "post"

Target = .Range("Target_Level").Value

debugger says that line caused it

[Kithus]

Target was definately looking for an integer and setting target_level to post was feeding it a string. It's been corrected and thank you for the heads up. I've also changed the profession change macro and the spreadsheet reset macro to not update the screen per Whirlin's suggestion. It does seem to work much faster like that. Thank you for the excellent input. The latest update v4.4.2 is now up on GSGuide with those changes.

[Daiyon]

Everytime I hit autofill, my excel crashes when using excel 2013

[Kithus]

Everytime I hit autofill, my excel crashes when using excel 2013

Unfortunately Daiyon I don't have access to Excel 2013 to recreate your error. If you would like to send me a copy of your training sheet, saved just before you hit autofill, I can try to run it on excel 2010 and see if I can recreate it there. Otherwise we may need someone else with Excel 2013 and VB knowledge to determine the cause of the problem. You can send your sheet to me at kkorandanis@gmail.com.

[Mettler]

I just wanted to say this spreadsheet is really excellent and I am very impressed and grateful for this. That is all!

[Suppressed Poet]

Has anyone added a spot for enhancives? I would like to see some of the hard numbers: RT/CS/AS/DS/TD etc. with my enhanced stats. Thanks in advance the spreadsheet is amazing.

[Lord Orbstar]

I cannot seem to get this to download. I get a "this document is not in this server" or some such error. It may be because I am in Afghanistan right now. It goes to some Hajji version of google in Arabic. If anyone can please email me the training sheet, I would be grateful. PM me and I will send you my email address.

[Kithus]

I found a longstanding error with the way shield DS was calculated that was de-valuing large and tower sized shields. The spreadsheet has been updated to correct this. I will look into adding something for enhancives in my next update.

http://gsguide.wikia.com/wiki/Training_Spreadsheet

[Lulfas]

Monks don't show as having Crowd Press, even though they do.

[Whirlin]

Let me know if you want any VBA Optimization help, or calculation verification... Just point me to the macro/equations to work with.

[JustDan]

Does anyone have an issue with this crashing as soon as the race is changed? More to the point, does anyone know how to possibly fix that issue?

[Whirlin]

What version of excel are you running?

[JustDan]

What version of excel are you running?

2013

[Whirlin]

2013

I think I have 2013 on my home comp, I'll check it out tonight. If not, I'll upgrade to 2013 and see what the problem is with the VBA.

In the interim... I know you're seeing it appear to lockup, but you should be able to use CTRL + Pause Break to stop the execution of the VBA. Any screenshots or additional information you could provide from attempting to step into the code after that would be helpful. (Getting into the code and giving me a line would be a godsend!)

The code itself has been heavily spaghetti strung over the years, through various excel supporters, and isn't very well written... so it may require heavy rework for 2013 support. Something I should be able to tackle over the long weekend.

[JustDan]

I think I have 2013 on my home comp, I'll check it out tonight. If not, I'll upgrade to 2013 and see what the problem is with the VBA.

In the interim... I know you're seeing it appear to lockup, but you should be able to use CTRL + Pause Break to stop the execution of the VBA. Any screenshots or additional information you could provide from attempting to step into the code after that would be helpful. (Getting into the code and giving me a line would be a godsend!)

The code itself has been heavily spaghetti strung over the years, through various excel supporters, and isn't very well written... so it may require heavy rework for 2013 support. Something I should be able to tackle over the long weekend.

Hokey doke... Open a freshly-downloaded copy of the trainer, and I click on the Race dropdown box. I select Elf, and it crashes immediately.

I get: Microsoft Excel has stopped working (with literally no lag between selecting the race and the error box coming up).

Problem signature:
Problem Event Name: APPCRASH
Application Name: excel.exe
Application Version: 15.0.4535.1507
Application Timestamp: 52282afa
Fault Module Name: excel.exe
Fault Module Version: 15.0.4535.1507
Fault Module Timestamp: 52282afa
Exception Code: c0000005
Exception Offset: 00019c76
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 1033

Additional information about the problem:
LCID: 1033
skulcid: 1033

[AnticorRifling]

Hokey doke... Open a freshly-downloaded copy of the trainer, and I click on the Race dropdown box. I select Elf, and it crashes immediately.

I get: Microsoft Excel has stopped working (with literally no lag between selecting the race and the error box coming up).

Problem signature:
Problem Event Name: APPCRASH
Application Name: excel.exe
Application Version: 15.0.4535.1507
Application Timestamp: 52282afa
Fault Module Name: excel.exe
Fault Module Version: 15.0.4535.1507
Fault Module Timestamp: 52282afa
Exception Code: c0000005
Exception Offset: 00019c76
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 1033

Additional information about the problem:
LCID: 1033
skulcid: 1033

Symptoms similar to when a windows update was installed when the application was open. Trying doing a repair or running:

http://support.microsoft.com/kb/929833

[Whirlin]

Also, further research showed that 2013 doesn't come with VBA natively installed, it's actually an additional package you need to 'unlock'
•[1]. Open Control Panel;
•[2]. Uninstall a program;
•[3]. Right-click Office program to select the Change menu item;
•[4]. Click Office Shared Features to see if Visual Basic for Applications is available.

[AnticorRifling]

Also, further research showed that 2013 doesn't come with VBA natively installed, it's actually an additional package you need to 'unlock'
•[1]. Open Control Panel;
•[2]. Uninstall a program;
•[3]. Right-click Office program to select the Change menu item;
•[4]. Click Office Shared Features to see if Visual Basic for Applications is available.

Who doesn't install all when they do an install?!

[Whirlin]

Who doesn't install all when they do an install?!

The speculation by the excel specialists is that Microsoft is trying to phase out VBA support. This would be a means to increase sales of other automation and collaborative tools, such as Sharepoint. Excel is widely regarded as the main business application that is used in ways it was never meant to support. So you end up having people storing medical records in Excel, with a password protected sheet, and then they get pissed at Microsoft for Excel not having strong encryption.

Structurally speaking, the VBA objects package have not been seeing the same functional enhancements that the Excel front end have. We're very much still coding to the same Excel 97 object hierarchies.

In fact, a handful of the 'new features' that they've added in the last few iterations in Excel have been able to be accomplished through the creative use of VBA.

[JustDan]

Well, to be fair, this is an office workstation, where I don't have admin rights (to uninstall or change the installation of Excel/Office). I'm stuck with the Excel they gave me. I use Google Drive's spreadsheet thingie when I'm at home, but I realize this spreadsheet is way too complex for that. Last I heard, openoffice wasn't compatible either. Are there any other options that I'm unaware of? Preferably something Android-based?

[Whirlin]

Nope, VBA is Proprietary Microsoft. OpenOffice, Google Drives and everything don't use the same formulas, and can't use VBA.

The spreadsheet likely COULD be re-written using purely formula driven layouts and other features, but honestly, that's a massive overhaul, and probably a couple hundred hours of formula work.



But, what we can do is test and see if user defined functions are functioning.

Are you able to mess with the stats and training? If the only thing that's crashing is running those macros when you change race/profession, we could always send a copy of the spreadsheet over that's already set on the proper profession.

[JustDan]

Nope, VBA is Proprietary Microsoft. OpenOffice, Google Drives and everything don't use the same formulas, and can't use VBA.

The spreadsheet likely COULD be re-written using purely formula driven layouts and other features, but honestly, that's a massive overhaul, and probably a couple hundred hours of formula work.



But, what we can do is test and see if user defined functions are functioning.

Are you able to mess with the stats and training? If the only thing that's crashing is running those macros when you change race/profession, we could always send a copy of the spreadsheet over that's already set on the proper profession.

Everything else seems to be working, yep. If I had a copy that was, say, set to Elf Rogue (you know, for example), then everything else would likely work just fine.

Or I can just see if I can acquire a previous version of Excel, if need be.

[AnticorRifling]

The speculation by the excel specialists is that Microsoft is trying to phase out VBA support. This would be a means to increase sales of other automation and collaborative tools, such as Sharepoint. Excel is widely regarded as the main business application that is used in ways it was never meant to support. So you end up having people storing medical records in Excel, with a password protected sheet, and then they get pissed at Microsoft for Excel not having strong encryption.

Structurally speaking, the VBA objects package have not been seeing the same functional enhancements that the Excel front end have. We're very much still coding to the same Excel 97 object hierarchies.

In fact, a handful of the 'new features' that they've added in the last few iterations in Excel have been able to be accomplished through the creative use of VBA.


I can agree with that.

[AnticorRifling]

Nope, VBA is Proprietary Microsoft. OpenOffice, Google Drives and everything don't use the same formulas, and can't use VBA.

The spreadsheet likely COULD be re-written using purely formula driven layouts and other features, but honestly, that's a massive overhaul, and probably a couple hundred hours of formula work.



But, what we can do is test and see if user defined functions are functioning.

Are you able to mess with the stats and training? If the only thing that's crashing is running those macros when you change race/profession, we could always send a copy of the spreadsheet over that's already set on the proper profession.

I'll expect this project completed by next Thursday. Thanks.

[Whirlin]

I'll expect this project completed by next Thursday. Thanks.

Write your own damn spreadsheets!

[masterdtwin]

Write your own damn spreadsheets!

Has anyone looked into adding a line in the trainer for magical ranks per level, and possibly adding in a runestave defense portion?

[Nahkaev]

Anyone have a really old version of this that (might) be compatible with Excel 2013?
Every version linked in this thread causes Office 2013 crashes under multiple conditions (chaning race, chaning class, auto-filling training, changing weapons, more)

[Gemstones]

Just because I am not one to like static URLs, in case shit changes, I updated the web page to reflect we actually now DO have a beta version.

http://www.cmnservicesgroup.com/tsoran/trainer.html

That should be the "go to" link.


Currently, we are only accepting new clients on a referral basis as the response to our services has been overwhelming.

What a great business problem to have, Buckwheat.

[Loyrl]

Heres .2.8 .2.9 and 2.10 Not sure if they will work, I only have 2010 at work =(

https://drive.google.com/file/d/0Bx36GxFyFlIjMHFaYi10OEd2Mjg/edit?usp=sharing

[Whirlin]

Anyone have a really old version of this that (might) be compatible with Excel 2013?
Every version linked in this thread causes Office 2013 crashes under multiple conditions (chaning race, chaning class, auto-filling training, changing weapons, more)

One page too late.


Also, further research showed that 2013 doesn't come with VBA natively installed, it's actually an additional package you need to 'unlock'
•[1]. Open Control Panel;
•[2]. Uninstall a program;
•[3]. Right-click Office program to select the Change menu item;
•[4]. Click Office Shared Features to see if Visual Basic for Applications is available.

I'll reach out to Kithus when I have some free time, and take a look at the current VB, and table formats, and see if I can add in some information, to align with what mastertwin was asking for.

[Kithus]

Anyone have a really old version of this that (might) be compatible with Excel 2013?
Every version linked in this thread causes Office 2013 crashes under multiple conditions (chaning race, chaning class, auto-filling training, changing weapons, more)

Have you followed Whirlin's instructions earlier in the thread for adding the VBA components to 2013?

[Nahkaev]

One page too late.


I tried your steps, but the context menu in the programs cpanel does not give me any options other than 'repair' and 'online repair'

I googled that problem then again.... and it has something to do with office 365, which I do *NOT* have (I have excel 2013).

So at this point, I'm just using a mac for all of my excel/gemstone needs.

[Whirlin]

http://msdn.microsoft.com/en-us/library/tt6cbe57.aspx

[HermieTheDentist]

I can't get the gsguide link to work for me. I get a 404 error code. Any help would be appreciated. I tried opening it up in another window and that didn't work either.

Thanks,
Matt

[Whirlin]

I can't get the gsguide link to work for me. I get a 404 error code. Any help would be appreciated. I tried opening it up in another window and that didn't work either.

Thanks,
Matt

Sent it via e-mail to your gmail account.

[Geijon Khyree]

4.4.5 works great.

[Demgar]

Where's this 4.4.5? I had pulled 4.2.1 off the link
http://www.cmnservicesgroup.com/tsoran/trainer.html

And then I see 4.3 at
https://docs.google.com/file/d/0BwK2Wh8fyR_Lei1kcl9MQ2tiVTA/edit?usp=sharing&pli=1

I've done a bunch of work on my personal version of the spreadsheet. It was running slowly, so I optimized some of the tables, and decomissioned one of the buffer tables that wasn't useful. Have a couple others flagged to look at as well, I think the skill bonuses table is eating a lot of cycles. Plan to look at changing from a calculated bonus a static lookup (trains->bonus), or a calc on demand from VBA to write values instead of formulas there; It's using something like 100k operations for just that table before you even look at dependencies. Corrected a few bugs in the VBA code, added stat and stat bonus enhancives, but didn't get around to skill enhansives yet. Planning on trying to get runestaff DS in there also, as well as look at the EXP formulas which don't agree with krakiipedia.

I'd like to merge my work into the most recent version before I go any further though...

[Versin]

That gdocs link is to 4.4.5.....

I usually access it via http://gsguide.wikia.com/wiki/Training_Spreadsheet

But would love to get another version going, I have updated my offline one as well.

[Whirlin]

Where's this 4.4.5? I had pulled 4.2.1 off the link
http://www.cmnservicesgroup.com/tsoran/trainer.html

And then I see 4.3 at
https://docs.google.com/file/d/0BwK2Wh8fyR_Lei1kcl9MQ2tiVTA/edit?usp=sharing&pli=1

I've done a bunch of work on my personal version of the spreadsheet. It was running slowly, so I optimized some of the tables, and decomissioned one of the buffer tables that wasn't useful. Have a couple others flagged to look at as well, I think the skill bonuses table is eating a lot of cycles. Plan to look at changing from a calculated bonus a static lookup (trains->bonus), or a calc on demand from VBA to write values instead of formulas there; It's using something like 100k operations for just that table before you even look at dependencies. Corrected a few bugs in the VBA code, added stat and stat bonus enhancives, but didn't get around to skill enhansives yet. Planning on trying to get runestaff DS in there also, as well as look at the EXP formulas which don't agree with krakiipedia.

I'd like to merge my work into the most recent version before I go any further though...

I had been exchanging some e-mails with Kithus on those points.

The problem is that the entire book has become as yarnballed as Gemstone's coding.

This is mainly a symptom of two main things. First, this was originally coded for Excel 95. VB and Excel equation capabilities have increased substantially, and maintaining that backwards compatibility is a MAJOR pain in the ass... especially if you're used to working with an xlsm filetype. I mean hell... Countifs was only introduced in 2007, before that, you'd need to write up array funcitons. Secondly, we've seen a ton of people working with it over the years, editting it, and adding in their own stuff, and own functions, who may or may not have leveraged what was pre-existing.

When I looked into the sizing and scope of the effort to optimize, I didn't see the return to be worth the investment. I found myself needing to perform such a major overhaul, that it would have resulted in recreation of the entire workbook from the ground up... streamline calculations, VB code, table structure, etc. The end result may as much as a 2 second net gain. Concurrently the target audience would be curbed as the userbase we know are all still using AIM and playing text based games, and may still only have Excel 95.

[Whirlin]

With all of the above in mind... I can pinch off the sorc guide and stop considering any other guides, and go work on a Whirlin trainer spreadsheet... Because if I need to rewrite it all from the ground up... I'm going to dethrone Tsoran.

[Versin]

And in 2035 when savants are released we will be begging for a new Whirlin trainer spreadsheet.

But yeah I got the same sense regarding the cost/benefit of updating the VB. If its a project you ever start, let me know.


With all of the above in mind... I can pinch off the sorc guide and stop considering any other guides, and go work on a Whirlin trainer spreadsheet... Because if I need to rewrite it all from the ground up... I'm going to dethrone Tsoran.

[Demgar]

Ok, the version number on the trainer tab says 4.3, but the filename is 4.4.5. Got it.

I actually didn't think that the Tsoran spreadsheet was unsalvagable. Some interesting decisions have gone into it, to be sure, but I put a couple hours into it during some downtime earlier this week and was able to make some good progress. I'll update with my changes and let you guys take a look (probably early next week before I can get around to it). I've got a good changelog that I'll share.

[Whirlin]

Ok, the version number on the trainer tab says 4.3, but the filename is 4.4.5. Got it.

I actually didn't think that the Tsoran spreadsheet was unsalvagable. Some interesting decisions have gone into it, to be sure, but I put a couple hours into it during some downtime earlier this week and was able to make some good progress. I'll update with my changes and let you guys take a look (probably early next week before I can get around to it). I've got a good changelog that I'll share.

Honestly, when I took a look at the VB... it was like, "My first VB" level of coding. Please don't misunderstand... kudos to Tsoran for setting it up. But man... series like this:


Sub CalculateStatGrowth()
saveStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Gathering Data..."
Prof = Worksheets("Trainer").Cells(3, 2).Value
Race = Worksheets("Trainer").Cells(3, 6).Value
CO_GI = Worksheets("Tables").Cells(95 + Race, 1 + Prof)
DE_GI = Worksheets("Tables").Cells(105 + Race, 1 + Prof)
DI_GI = Worksheets("Tables").Cells(115 + Race, 1 + Prof)
LO_GI = Worksheets("Tables").Cells(125 + Race, 1 + Prof)
IN_GI = Worksheets("Tables").Cells(135 + Race, 1 + Prof)
ST_GI = Worksheets("Tables").Cells(145 + Race, 1 + Prof)
RE_GI = Worksheets("Tables").Cells(155 + Race, 1 + Prof)
CH_GI = Worksheets("Tables").Cells(165 + Race, 1 + Prof)
WI_GI = Worksheets("Tables").Cells(175 + Race, 1 + Prof)
AU_GI = Worksheets("Tables").Cells(185 + Race, 1 + Prof)
Application.StatusBar = "Initializing..."

It just makes me cringe when I see it. Especially since all of those variables are undeclared, and therefore being treated as variant object types, which is inherently less optimized.

That was 10 rows... It only takes me 25 rows to do a pull of every file from a folder, pull every value from any named ranged, track whether or not responses were blank, and copy the values into a consolidated tracking spreadsheet.

Plus, You should work with Kiltus if you want to provide updates to the current version of the VB. He may have been working on some functional enhancements.

[Whirlin]

... fuck it... lets write our own damn spreadsheet. I'll contact you via PMs, and we can scope out the project.

[Demgar]

Funnily enough, that code isn't even being used that I can tell. That isn't called from anywhere else in the code, and doesn't launch from any of the buttons on the spreadsheet side... Looks like an aborted attempt to replace the formulas in the sheet with an on-demand calc from VBA. Not a terrible idea, even if the coder was a bit... straightforward... and needs to learn about arrays ;) I've seen worse!

What really drives me up the wall is stuff like this, that leaves the application calculation off if the procedure ends in a fault state! When you turn off the calculation, you'd better be damn sure you get it back on again!

Worksheets("Spells").Activate
Application.Calculation = xlCalculationAutomatic
Exit Sub
boom:
Worksheets("Spells").Activate
MsgBox "error: " & Error()
End With
End Sub


Anyways, I want to try to contribute to the community now that I'm back in the realms. I'll update and I'd like to hear your critiques. I design (and re-design) spreadsheets professionally, but I know there's always room for improvement.

[Whirlin]

Anyways, I want to try to contribute to the community now that I'm back in the realms. I'll update and I'd like to hear your critiques. I design (and re-design) spreadsheets professionally, but I know there's always room for improvement.

You may be my new best friend... I actually post occasionally over on ExcelForum.com. If I sort by rep, I constantly hover around #200 or so out of the 667k users. That's really the only baseline I have.

Lets set up another thread to gather requirements to ensure that we can scope the work out properly. I received another PM from another potential contributor.

If we can get Mark on board for equations, we'll be all set!

[Billthecoyote]

I use office 365 and every version of the trainer that I pull up crashes my Excel. Last one I used was 4.4.5, while reading this old thread and trying to follow all the advice.

1) Any news on a modern/revised/streamlined version of the trainer?

2) Barring that, anyone using Office 365 that can walk me through getting the trainer to work?

Thanks in advance.

[Aeronal]

the best solution I have found is to install excel 2007 and just use that with this .xls file. It never crashes like the newer versions do.

i've tried all the fancy shit suggested here and it still kept making me crash

[Daiyon]

excel 2003 and 2007 are the only way to get the spreadsheet to work for me. I get the crash problems too.

[Rhovan]

Office 2013 has problems and crashes, but was able to repair the file. I've been able to use it since. It was TrainerGS4.4.4.5 if that helps.