Excel 2000 Character Sheet

Discuss Mongoose RPGs here, such as the OGL rulebooks, Jeremiah, Armageddon 2089 and Macho Women with Guns
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Excel 2000 Character Sheet

Postby ryhopewood » Tue Apr 05, 2005 11:45 am

Hi all

After being increasingly frustrated with the existing character generator programs and their lack of easy utility to Conan RPG, I set about building my own in MS Excel 2000. Spending more hours on this than I care to remember (or am willing to admit to) it is nearly finished.

I would like to make this labour of love available to all for free but need to know what procedures I need to go through so that I don't upset anyone at Mongoose re-copyright issues.

Basically the character sheet allows you to:

(1) Enter ability scores
(2) Select race (from Conan RPG book only)
(3) Select up to six different class and level combinations (e.g. Barbarian 2 / Thief 3 / Scholar 1 etc ...) from Conan RPG and Signs & Portents (for Bandit)
(4) Select skills, feats and spells (Conan RPG plus Scrolls of Skelos).
(5) Select armour, weapons and equipment.
(6) Assigns racial and class abilities automatically based on selections PLUS gives you pulldown lists for the optional ones.
(7) Calculates about 90% of the intermediary values and collates the circumstance bonuses into summaries (e.g. apply +3 when cooking in Shem)
(8) Generates a character sheet - not to dissimilar to the one in the Core Rules.

It is about 1 MB unzipped and requires Microsoft Excel 2000. It uses three macros to load list options, assign racial features and assign class features but everything else is contained within the spreadsheet.

Aside from the mechanical crunchy bits I have been careful not to include any additional descriptive text and to refer to the Conan RPG rulebook wherever possible.

Would the people at Mongoose mind if I e-mailed the spreadsheet directly to them for comment? I definitely don't have any commercial interest in this whatsoever (apart from the time saved to game with my friends).

Regards,

Ian Martin, Ashby UK
sbarrie
Banded Mongoose
Posts: 256
Joined: Mon May 31, 2004 7:17 pm
Location: Canuckistan

Postby sbarrie » Tue Apr 05, 2005 12:05 pm

I hope you get a positive response.
Scott
SableWyvern
Lesser Spotted Mongoose
Posts: 749
Joined: Mon May 31, 2004 10:21 am
Location: Melbourne, Australia

Postby SableWyvern » Tue Apr 05, 2005 2:27 pm

Sounds like there's no Conan IP in there (hmmm ... on second thought, maybe the races...), which would mean you could legally release this under the OGL.

Of course, getting specific approval from Mongoose might save you the hassle of ensuring that you did in fact meet all the OGL requirements.
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Still Looking for Official Advice from Mongoose

Postby ryhopewood » Mon Apr 11, 2005 5:34 pm

Hi there

No one from Mongoose has responded to my earlier post so can I ask them to do so again?

My spreadsheet is ready to go. I've appended the OGL licence conditions from the Wizards web-site and left the archectiture totally open - you can see it all guys - as per the licence condition.

I need word from Mongoose itself before I start distributing re: race names and possibly spell names.

Guys at Mongoose Hall - happy to send you a copy if you want to see it.

Cheers,

Ian
sbarrie
Banded Mongoose
Posts: 256
Joined: Mon May 31, 2004 7:17 pm
Location: Canuckistan

Postby sbarrie » Tue Apr 12, 2005 4:36 pm

You may consider changing the race names from "Cimmerian" to something like "+2 Str, -2 Int, Preferred Class Barbarian".

I doubt the spell names will be a problem, as they were created by Mongoose and aren't a direct part of the Conan licence.
Scott
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Postby ryhopewood » Tue Apr 12, 2005 5:59 pm

Hi there

Good thought but my macros work on the real names so I would need to edit the VBA code more than I want to.

Given the other thread on this site involves fairly liberal dissemination of materials with race names etc..., perhaps I'm worrying too much.

Anyone out there with a Conan themed website who would mind hosting the download for me - about 250k zipped?


Ian
bolen
Mongoose
Posts: 129
Joined: Fri Jan 30, 2004 11:00 pm

Postby bolen » Wed Apr 13, 2005 7:04 pm

any chance I could get a copy of this spreadsheet?
Nothing in the world is more dangerous than sincere ignorance and concientious stupidity--

Martin Luther King
Camelon75
Weasel
Posts: 37
Joined: Mon Feb 09, 2004 10:39 pm
Location: Scotland

Postby Camelon75 » Fri Apr 15, 2005 3:20 pm

I too would like to get my hands on a self calc sheet

Have you found a web home for it and is there a link?
or
Can you send it to individuals or does that infringe anything?
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Postby ryhopewood » Sat Apr 16, 2005 6:32 am

Hi all

I have forwarded the spreadsheet to a website for hosting. It should be available to all soon ...

Version 1.1 will be available that adds the commoner class and fixes a bug with the skill points total (the INT modifier wasn't being properly applied).

I'm working to add in Noble today, which leave only pirate missing.

Ian
albjohnson
Shrew
Posts: 14
Joined: Tue Jan 04, 2005 9:01 pm

Postby albjohnson » Sat Apr 16, 2005 10:54 pm

Cant wait to see the sheet how long untill its on-line somewhere :?:
Fearguis
Stoat
Posts: 53
Joined: Mon Mar 01, 2004 4:03 pm

Conan Yahoo Group

Postby Fearguis » Mon Apr 18, 2005 1:36 pm

http://groups.yahoo.com/group/ConanD20/


There's all kinds of files hosted here. Join up and you can add it to the files section. A good portion of the Mongoose boys are members, as well.
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Postby ryhopewood » Mon Apr 18, 2005 1:57 pm

Thanks for this.

I've applied to join the group. I will post the latest version as soon as I can.

Release version 1_2 now includes all 9 classes from core rules and bandit class from Signs and Portents.

Also generates a handy NPC stat block as well as the full character sheet.

Version 1_2 fixes a few bugs as well including skill points and power points.

Cheers

Ian
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Postby ryhopewood » Mon Apr 18, 2005 2:14 pm

Hi all

Version 1_2 of the Excel spreadsheet has been successfully uploaded to the Conan D20 group at Yahoo.

You can download it from the files section. It is the file entitled Conan_release_1_2.zip.

URL: http://groups.yahoo.com/group/ConanD20/ ... %201_2.zip

All comments greatly received so that I can improve it. Post remarks on this thread please.

Hope some of you (ok maybe too ambitious, at least one of you) finds it useful.

Best wishes, Ian
Fearguis
Stoat
Posts: 53
Joined: Mon Mar 01, 2004 4:03 pm

Conan Yahoo Group

Postby Fearguis » Mon Apr 18, 2005 2:31 pm

You'll need to join the Yahoo Group before downloading files. I keep the group closed for approval only, to screen out the email spammers. (Of which there have been many that tried :)
sbarrie
Banded Mongoose
Posts: 256
Joined: Mon May 31, 2004 7:17 pm
Location: Canuckistan

Postby sbarrie » Mon Apr 18, 2005 5:08 pm

That's really, really great, man.

A few notes:
I created a South Islander who has 2 levels of Barbarian and 4 levels of Pirate.

On the User Sheet:
  • It gave me 5 feats, but I think I should only have 4. Barbarian and Pirate are each favoured classes, but they don't each give a bonus at their first level. Figured that out myself - the combined Barbarian/Pirate levels reached 5th.

    It would be nice if you only recorded what you rolled for hit points, and then let the sheet add the Constitution modifier. That would make it easier if you keep updating the same sheet as a character gains levels. You could even fill in the first level automatically, since you ask for the starting class.

    Missing religion. +2 to Will Saves can be pretty important
On the Character Sheet:
  • It writes that I have a +1 to hit with spears, but it doesn't include that under my War Spear's "Attack Mod" (a very minor quibble).

    I gave him a Stygian bow, and apparently I have a -4 Attack Bonus with it even though I have Versatility.

    A column with the Total Attack Bonus of each weapon would be nice. (Right now it only includes Weapon Focus, Unfamiliarity and maybe others)

    Under Class Abilities, I have "Sneak Attack (+1d6/+1d8)", like a thief. It may be useful to keep track of Pirate and Thief sneak attack bonuses seperately, so multiclass Thief/Pirates know how many d8s and how many d6s to roll when using their favoured weapon.

    Dodge and Parry totals shouldn't have pluses prefixing them.
I'd like to add that this is a great tool as-is. Just because I can find things to nitpick doesn't mean it isn't complete or I won't use it. :D
Scott
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Postby ryhopewood » Mon Apr 18, 2005 7:11 pm

Hi Scott

Thanks for the really great feedback. I'll collect all the issues up this week and work to fix them over the coming weekend. I'm sure there are a few clangers that need to be addressed.

I'm not really a programmer so many of the approaches / fixes will look like jury-rigging but it doesn't have to look pretty underneath the hood.

Once the basics are sorted out I'll think about adding stuff from all the source books sitting on my shelf.

Regards,

Ian
Belkregos
Banded Mongoose
Posts: 314
Joined: Tue Mar 30, 2004 5:44 pm
Location: San Diego Ca.

Postby Belkregos » Mon Apr 18, 2005 7:17 pm

ryhopewood wrote: Once the basics are sorted out I'll think about adding stuff from all the source books sitting on my shelf.
Ian
Cool!!
hope the Kezankian hillman gets a spot :D
The struggle itself towards the heights is enough to fill a man's heart. One must imagine Sisyphus happy.
The Myth of Sisyphus
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Postby ryhopewood » Wed Apr 20, 2005 7:13 am

Hi everyone

Just to let you know that the Excel spreadsheet can now also be downloaded from Thulsa's excellent Hyborian Age website.

See http://hyboria.xoth.net/news.htm or go directly to
http://hyboria.xoth.net/resources/index.htm

While you are there check out the other great stuff especially the conversion notes for d20 Ancient Kingdoms: Mesopotamia for Conan RPG. The adventure is a very cool, pulp fiction scenario involving tombs, cults, desert tribes and lost cities. Ideal for Conan really.

Please post any feedback on the spreadsheet on this thread and I'll try and make changes / updates on a regular basis.

Many thanks to Thulsa for hosting it!

Cheers,

Ian
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Postby ryhopewood » Wed May 04, 2005 8:53 pm

Hi folks

Just to let you know that Version 1.3 of the PC generator has been posted to the Yahoo Groups File area. I've now corrected most of the errors reported to me in the past week or so.

The major enhancement in this version is that the user now specifies class and ability score increases on a character level basis. This allows more accurate calculation of skill points and now hit points too.

Keep finding the errors and I'll keep fixing them.
:lol:
Hope you enjoy it,

Ian
ryhopewood
Mongoose
Posts: 142
Joined: Tue Apr 05, 2005 11:28 am
Location: Ashby de-la Zouch, UK

Postby ryhopewood » Fri May 06, 2005 8:07 am

Hi all

Some you are reporting that the hit point calculations don't work - that is, the NAME! error appears in the cell after the first character level.

The error occurs because you have not installed the Data Analysis Pak of
additional Excel functions that come with the basic Excel 97 / 2000 installation but aren't switched on yet. It is trying to call the RANDBETWEEN() function but can't find it in your Excel library.

It is easily fixed.

Open Excel. Select Tools from the top menu and then Add Ins ... option.

From the dialog box check the "Analysis Toolpak" and "Analysis Toolpak -
VBA" options and click ok. Excel should install them automatically from its
system directory but you may need the installation disk. I don't know why
Excel doesn't install these automatically at the start because there are a
lot of useful functions in there.

The spreadsheet should work from then on.

Let me know if this doesn't fix the problem.

Cheers,

Ian

Who is online

Users browsing this forum: Yahoo [Bot] and 7 guests