Talk:Mandos Charactersheet

From DQWiki
Jump to navigationJump to search

Bugs

I had stopped work on V8 while we work on V9 but I will go through the bugs people have found and tidy them up as it seems more than just me is using it :-) Please add any bugs you find to the top of the table ensuring that you include the version number of the Charactersheet so I can track the bug down.

Bug Tracker

Current list of bugs are being ironed out and a new version of the charactersheet will be available soon.

Version

Description

Fixed

Additions
Sean's Training time calculator
Max Spell limits Added V8.7.5
Outstanding
8.7.4 Orc Armour Mod is 6 not 5 Fixed V8.7.5
8.7.4 Details out by two lines on Character Gen Fixed V8.7.5
8.7.4 Stat Max for fatigue incorrect

On Ranking Sheet:
Cell H8 should read =VLOOKUP(H7,Fatiguetable,2,FALSE)+(VLOOKUP(Race,RaceTable,10,FALSE))
Cell I8 should read =VLOOKUP(I7,Fatiguetable,2,FALSE)+(VLOOKUP(Race,RaceTable,10,FALSE))

Fixed V8.7.5
8.7.4 Range and Class Column headers incorrect on Charactersheet page. Fixed V8.7.5
8.7.4 Warrior Requirement names are incorrect on Tables Sheet

WarriorReqCatNum DM45 should be at DN45
WarriorReqCatRank DM44 should be at DO44
WarriorReqWeaponNum DM48 should be at DN48
WarriorReqWeaponRank DM47 should be at DN47

Fixed V8.7.5
8.7.4 Cell 'Skills'H334 and H335 are erroneous and should be removed. Fixed V8.7.5
College Specific
8.7.4 BC for all enchanter rituals are incorrect Fixed V8.7.5

Questions

Should you have to add a new race just to add NA? - Martin
You can simply add the NA to your race if you don't want to add a whole new race :-)
How do you enter non-standard values for Social Status (in this case the now obsolete category of "Adventurer"). - Martin
The Social Status is simply a table. Adding new values (or obsolete ones) is as easy as adding a line in the table with your Entry.
How can one create a DEF bonus from a magic weapon? - Martin
Like Main-Gauche you have to add it as a weapon and a shield. Kludgy I know :-(
Does this allow for a different Physical Age from Actual Age? For those who have been rejuvenated or aged. - Stephen
No although there is room on the character sheet to add an additional age if the character required it. It is rare enough I haven't bothered to make it a standard feature. Although if it is something you have on your charactersheet and it gets used often I am happy to add it in.
Where do you put in mods to effective stats. Braegon has SoS on PS and EN all the time, and an AG, MD, and TMR penalty from the same magics. - Stephen
The Loadout section is copy and pasteable so that you can detail your combat abilities under various stat mods by overwriting values (or adding the bonus into the calculation). If you have them permenantly on so that it will affect carrying abilities etc, it should be added to your current stat with a comment added detailing the bonus.
The other option is to add a small table into additional stuff for Stat mods and change the formula to add the mods to the stats.
What's the column 'spare time' for?

You can select Spare time as a ranking option to help keep track of time spent traveling, making potions etc The spare time colume works to indicate how many days are involved in the activity and the time of day options will work with this to sort out the correct amount of time.

Requests

Please add any requests you have here.

Instructions - Hannah Jackson
I agree instructions would be good. - Jono Bean 15:14, 8 Sep 2006 (NZST)

I have added a Mandos Charactersheet Instructions page and will add to it slowly. Please add any thing you think is appropriate to the pages as my documentation skills are poor at best. Mandos 16:11, 12 Sep 2006 (NZST)

Colleges

Currently only a few of the colleges have been written up. Those that have been completed are

  • Mind
  • Necromancy
  • Enchanter
  • Wiccan
  • Earth
  • Namer
  • Celestial

A few are available in a previous version and will not take too long to convert

  • Fire

If you want a specific college completed and available. Please let me know and I will get them fixed up.

Version Changelog Archive

V with Bug

Description

Fixed

Version 8.7.4
Visibility of usable weapons ADDED 8.7.4
Experience sheet blocks weapons where the character does not have the stats to rank the weapon ADDED 8.7.4
Add Sex Mods to Character Gen ADDED 8.7.4
8.7.3 Character Gen. Stat mods for Agility and MD are reversed.
Cell C7 should read =(VLOOKUP(Startrace,RaceTable,5,FALSE))
Cell C6 should read =(VLOOKUP(Startrace,RaceTable,6,FALSE))
FIXED 8.7.4
8.7.3 Kinlu Weapons do not have Warrior Category on Ranking Sheet
To correct Drag visible contents of Column S on the Ranking Sheet down to line 113.
FIXED 8.7.4
8.7.3 Cell BX17 on tables should read =IF(AmuletLuck="Yes",3,0)+Resistancebonus FIXED 8.7.4
8.7.3 Remove ability to select mechanician options multiple times. FIXED 8.7.4
8.7.3 Move Elven Courtier discount to racial discounts from skills. FIXED 8.7.4
8.7.3 Add in Philosopher Discount FIXED 8.7.4
Version 8.7.3
8.7.2 After discussion changing amulet weights to 1oz Changed 8.7.3
8.7.2 Swapped notes and money fields on load out sheet. Changed 8.7.3
8.7.2 Discounts incorrect after addition of Adventuring skills to table Fixed 8.7.3
8.7.2 Amulet of Luck adds nothing to resistance Fixed 8.7.3
8.7.2 Cell BJ14 on the tables sheet should read 7 not 14. Fixed 8.7.3
8.7.2 Cells N7 and N8 on the Ranking sheet page "(Race,RaceTable,15,FALSE)" should read (Race,RaceTable,16,FALSE). Fixed 8.7.3
8.7.2 Potions is a bit broken. Still being refined. Fixed 8.7.3
8.7.2 Earth College fixed. Number of minor issues Fixed 8.7.3
8.7.2 Request for mistletoe column in Earth college Added 8.7.3
8.7.2 Ritual and Spell learning times added Added 8.7.3
Version 8.7.2
8.7.2A Language Discounts looking in the wrong column FIXED in 8.7.2B
8.7.2A Ranking to 10 broken FIXED in 8.7.2B
8.7.2A Race Stats EN and MA swapped FIXED in 8.7.2B
8.7.2A Unused number on Experiance sheet - Delete. FIXED in 8.7.2B
8.7.2A Start MA section has an extra - FIXED in 8.7.2B
8.7.2A Error with Aspect List FIXED in 8.7.2B
8.7.2A Rune Missing from College List FIXED in 8.7.2B
8.7.2A Label for Artisan in Char Gen - Remove 'Skill' FIXED in 8.7.2B
Age Missing ADDED in 8.7.2
Add Start date for character to assist with automatically updating age and duration of play ADDED in 8.7.2
Add Kinlu Weapons ADDED in 8.7.2
Add Character Gen Ranking Sheet ADDED in 8.7.2
8.7.1 Spy needs to be updated to new version FIXED in 8.7.2
8.7.1 Mind College Broken Badly FIXED in 8.7.2
Version 8.7.1
8.7.0 Major Issue on ranking table for languages. Only fails on 8.7.0 FIXED in 8.7.1
8.5.35 D69 rounds to a squillion decimal places FIXED in 8.7.1
8.5.35 Courtier appears to offer 1 too many Rank 0 options FIXED in 8.7.1
8.5.35 Mechanician offers 1 too many options rather than making Basic Mechanics & Foundations mandatory at Rank 0 FIXED in 8.7.1
8.5.35 Also, selecting Experimental Engineering causes a "Value not available" error FIXED in 8.7.1
8.5.35 Equipment sheet, Armour total weight formula don't account for female gender FIXED in 8.7.1
8.5.35 Swimming is missing from the skills FIXED in 8.7.1
8.5.35 Ranking did not take U into account very well FIXED in 8.7.1