4e Fan Creations and House RulesWorking on variant powers? Statting up a PC race or your version of a monster? Creating or converting an adventure? Put it here!
the true is, i cant select any checkbox on the character sheet. at least not by clicking it, if there's any other way, pls say.
It sounds like you need to enable macros (Office Button --> Excel Options --> Trust Center --> Trust Center Settings --> Macro Settings --> Enable all macros). That should get things working.
Is there a way to outfit a wizard with more than one implement? My wizard has Staff of Defense so he usually is equipped with a Staff of the War Mage, but he also carries a Master's Wand of Magic Missiles.
Another funny/tragic story: Apparently, wands in AV got missed somehow, so they're not even listed.
Once I remedy this, you'll be able to have the quarterstaff in one of the weapon slots, and the wand in the implement slot. The sheet automatically picks the implement with the highest enhancement bonus to use with your powers.
This should only be possible if you took Novice Power, Acolyte Power AND Adept Power using your remaining 5 feats from level 4 up to level 11 (prerequisites make it impossible to take them using the level 2 feat). Otherwise, you don't get to do a Paragon Multiclass.
So at the latest, you must have taken Novice Power at level 8, Acolyte Power at level 10 and Adept Power at level 11. That is, by level 8 you must have taken Novice Power, and by level 11 you must have taken Acolyte Power and Adept Power. If you did, Wonko's sheet has a bug. If not, that's the way it should be.
Obviosuly, I assumed most people would realize that by going Paragon Multiclass, I had taken the three power swap feats throughout the levels between 1 and 11. I guess I should have been more clear about that...
Anyway, your reply to my post had nothing to do with my post at all. I know how paragon multiclassing works. I also know that Warlocks get a set at-will depending on which pact they choose. They also get Eldritch Blast as an at-will.
Pact Initiate warlocks get the at-will of their pact choice as an encounter power. At level 11, with paragon multiclassing, the only other choice the spreadsheet is giving me for the at-will is Eldritch Blast. Now, normally, this is fine, but if I am a Half-Elf who took Eldrtich Blast for his Dilettante power and then got the Dark pact at-will as an encounter power from Pact Initiate, then when he gets to level 11, he should be able to pick from the other Warlock at-wills for his replacement at-will power. At the same time, this should also apply to non-Half-elf Pact Initiates, since Human Warlocks can pick from the other at-wills when picking their third at-will power.
Now, normally, this is fine, but if I am a Half-Elf who took Eldrtich Blast for his Dilettante power and then got the Dark pact at-will as an encounter power from Pact Initiate, then when he gets to level 11, he should be able to pick from the other Warlock at-wills for his replacement at-will power. At the same time, this should also apply to non-Half-elf Pact Initiates, since Human Warlocks can pick from the other at-wills when picking their third at-will power.
Is it possible that what you are suggesting is not possible because the dilletante ability is not s true "At-will" power? It is an encounter power. Just because it allows you to select another's class' at will power to be used as an encounter ability does not mean that you truly "possess" the At will power.
To tell the truth, you are probably right that you should be allowed to select any of the Warlock at-will's for your Paragon Multi-class At will ability at 11th level, but this would seem to be a plausible explanation of why the sheet is adjudicating in this manner.....
Having said all of this, I just wanted to let you know just how invaluable this Character Sheet is to my gaming experience. Wonko, you have taken almost all of the work out of playing a character and turned gamenight into an awesomely enjoyable experience. I love how easy this sheet is to learn to use, and the steps it takes out of combat for me allowing me to enjoy the role-playing experience. Using this sheet and the fourth edition rules, I have not had this much fun role-playing since 20+ years ago in high school when i was playing the old school basic Dungeons and Dragons.........
Now, am I missing something horribly obvious, or is there no choice for Paragon Multiclassing?
I made a Gnome Cleric, Multiclassed into Wizard.
Have all required feats and am level 12.
It lists all Cleric and Wizard Paragon paths that I am elligible for, except Paragon Multiclassing. Because of this, I can't choose my abilities, without Utilities area going "WARNING" red, because it doesn't think I should have a Paragon Utility.
Please, someone point me to where I am missing this option. Thank you. =)
PS. I am using the newest version of the sheet, as of this post.
Obviosuly, I assumed most people would realize that by going Paragon Multiclass, I had taken the three power swap feats throughout the levels between 1 and 11. I guess I should have been more clear about that...
Anyway, your reply to my post had nothing to do with my post at all. I know how paragon multiclassing works. I also know that Warlocks get a set at-will depending on which pact they choose. They also get Eldritch Blast as an at-will.
Pact Initiate warlocks get the at-will of their pact choice as an encounter power. At level 11, with paragon multiclassing, the only other choice the spreadsheet is giving me for the at-will is Eldritch Blast. Now, normally, this is fine, but if I am a Half-Elf who took Eldrtich Blast for his Dilettante power and then got the Dark pact at-will as an encounter power from Pact Initiate, then when he gets to level 11, he should be able to pick from the other Warlock at-wills for his replacement at-will power. At the same time, this should also apply to non-Half-elf Pact Initiates, since Human Warlocks can pick from the other at-wills when picking their third at-will power.
Well, it's simple. Firstly, I'm a programmer, so I think like a programmer. (Well, maybe not so much a spreadsheet programmer though -- more like C++, Java and stuff) You weren't clear, so I was trying to get you to put things clearly. What you believed to be clear was actually an assumption. Wonko can't work on assumptions, so I was hoping you would provide more details for him after my comment. No need to be so hostile.
Oh yeah, by the way, I know all that Warlock stuff too. Should we start a club?
When did A.7 come out? I only see .6 on the first page
v1.45.a.7 was never sent out...it was basically a working release that got kinda messy. My current working copy is getting a bit of an overhaul...sort of an "I've already got the thing up on the lift - might as well fix everything while I'm here" thing. A lot of formulas were becoming too complicated, so they are getting a facelift.
The good news is, when I finally get 1.46.A.1 out, Martial Power will be fully implemented. I would do mini-updates like I did with AV, but there's a lot of cross-dependency between feats and powers - a lot of it won't work until it all works, sort of thing.
I'm going to be adding the Remarkable Races line from Alluria Publishing in the very near future as well.
I hope I can get MotP in and be caught up for a while before the PHB2 comes out. I'm starting to see spreadsheets every time I close my eyes.
Long answer: I'm trying to figure out a way for a user to enter custom material that is both easy and able to be imported from one version to the next without having to copy/paste it over.
(BTW...I'm hardly a grand master at this...if I was, it would be easy to reverse engineer what I've done and add your own material. Instead, the code pretty much looks like a dog's breakfast - unhide the Powers sheet and take a look if you don't believe me :P)
Biggest question to that one is how much do you change the format in which data is stored within the sheet when you make revisions. If it is frequent, yea thats going to be a pain. However you could make a feature that converts custom-saved data into a CSV file tagged with the version, each worksheet would simply have to know the data format for version and then just sort the data into its current data format... If not very often, it should be simpler.
However that means that a custom race, feat, etc couldn't do anything that a current race, feat, etc doesn't already do. I.E a race gives the same general type of benefits, attribute bonuses, etc.
That does sound easy. The only problem is that I have no idea what a CSV file is.
I think I've thought of a way, but it's a couple of revisions off yet. I just started a week of 24/7 stand-by for work, so it won't be this week.
About CSV files, Excel, Access, Visual Basic, and exporting and importing data
Quote:
Originally Posted by Wonko the Sane
That does sound easy. The only problem is that I have no idea what a CSV file is.
I think I've thought of a way, but it's a couple of revisions off yet. I just started a week of 24/7 stand-by for work, so it won't be this week.
CSV stands for Comma-Separated Values. CSV files are what we call "flat files" in my field. They can only contain 1 table of data, and so if there are 2 or more tables of data, the tables would have to be "flattened" into 1 table, hence causing repetitions here and there. Not very nice. You have already done a good job with Excel, but if I had been here earlier, I would have suggested using Access, since you probably do not have access to Visual Basic which would have been so much easier to program with for a character sheet of such complexity. In Access, you could have created several tables of data and thus made things a lot easier. This of course requires some knowledge of the basics of database design and normalization, but it's not that difficult to get, considering you managed to do all this in Excel.
Anyway, we're stuck with either Excel or Access along with VBA (Visual Basic for Applications). Access with VBA would have been great and easy to design, export and import. There is also supposed to be a way to integrate Excel and Access, but I haven't tried that before, since I mostly delve in things like C++, Java and Visual Basic. However, I have done Access with VBA before, and it's rather easy to design and implement with. Especially when it comes to your character sheet. Okay, maybe it wouldn't look as close to the pen & paper character sheet, but it would be quite functional and user-friendly if you did the user interface well.
So, unless you can get a copy of Visual Basic and learn how to program with it, you're stuck with CSV files for exporting and importing. So if you have designed your data in a format that wouldn't fit into a single table, you could try exporting the data in separate CSV files (1 table per file), and importing them in the same manner, just in reverse.
Either that, or you'd have to learn Access and VBA and how to integrate it with Excel.
Or, you could get a hold of and master Visual Basic (which will probably take too much time).
I'll fire up the ol' Googlizer when I'm not so busy and look into CSV files and how ignorant it'll be for me to implement...I'm intrigued by the thought of learning VB/VBA, but I just don't have the time to try to make this work on another platform. I understand and can use Excel, but trying to make anything in Access makes me feel like Jerry Lewis in a closet full of wire hangers.
Yea I agree, you can do alot with Excel period. If I recall, Office 2007 changed VBA to something else?
CSV is just an example of keeping something in an external universally-readable file between changes in the worksheet itself. You can do the same with exporting to an XML format nowdays too, which is alot better imo.
At any rate, just my two cents in cause I'm a big fan of your worksheet since I have determined it to be the only fairly-complete (in terms of picking things from lists and making calculations) way to make a higher level character. I made a Shadar-Kai cleric, mixed up with ranger abilities (way of the warrior, adept, novice, etc) the other day with it and saved me -alot- of time.
Yea I agree, you can do alot with Excel period. If I recall, Office 2007 changed VBA to something else?
CSV is just an example of keeping something in an external universally-readable file between changes in the worksheet itself. You can do the same with exporting to an XML format nowdays too, which is alot better imo.
At any rate, just my two cents in cause I'm a big fan of your worksheet since I have determined it to be the only fairly-complete (in terms of picking things from lists and making calculations) way to make a higher level character. I made a Shadar-Kai cleric, mixed up with ranger abilities (way of the warrior, adept, novice, etc) the other day with it and saved me -alot- of time.
Actually, Microsoft didn't change VBA to anything else in Office 2007. They just added further support for certain MS Office applications to VSTO (Visual Studio Tools for Office) which started in Office 2003 if I'm not mistaken. VBA is still a built-in part of Office, whereas VSTO is a kind of add-on to Visual Studio, which requires really expensive licensing. So unless Wonko is a rich fella (i.e. already has or can afford to buy Visual Studio .NET), or a REALLY BIG fan of Microsoft, he's stuck with VBA. Which is why I chose to discuss more on things that are easier to obtain. VBA isn't bad if you know how to use it, though I admit it is rather pale compared to full-blown Visual Basic .NET and Visual C# .NET, or even the classic Visual Basic 6.
As for using XML versus using CSV files, I personally think that it would be a lot easier and better to use CSV files or something similar, as they are simple and orderly (from a programming point of view). You would need to worry so much less about what you could and couldn't do with the XML. Plus XML is only important if you want to do special formatting. No point using a cannon to kill a mosquitoe. CSV would be simple and easy, as you would only need to export and import in order, which requires much less research on Wonko's part. What is better or worse depends on the problem at hand, no? You could say C is far better than Prolog, but Prolog can do rule-based AI with much less effort and code. So I would personally suggest that Wonko not make things more high tech than necessary. Simplicity is best. He is after all, only going to export and import values from his spreadsheet.
As for Excel, true, you can do a lot with Excel, but I was just mentioning that it would have been so much simpler with Access and VBA had that been the platform that was used from the beginning. However, at this point, it would take a lot of effort to shift to a different platform, although it is still possible to use VBA in Excel as well. It's just that a database would have made life a lot easier, that's all.
Last edited by seanna2000; 18th January 2009 at 07:26 PM..
What you can effectively do for an export is create a macro that copies all the user input to a new blank sheet (or a hidden sheet, effectively) in a specified order, then just execute a "Save as ... CSV" using Excel's built-in funcitons. The macro should be able to handle that, might even throw the save dialog. Import then is just telling Excel to get data from an external file, then copy the data that was just obtained back to the correct locations throughout the spreadsheet. Tedious to write but simple to understand.
Linear Mode
And yet another word from our sponsors
