DQCS Change Details

Details of latest changes for the DQ Community Character Sheet

General

Version	Type	Bug/Suggestion	Entered By	Comments/Status
9.5.5	New	new features for v9.5.5 from 9.5.4	Neil	Completed Water College descriptions Add Highighting of some key numbers, eg primary, languages, normal MR, normal Defence Change New character EP from 250 to 2500 Add a few hyperlinks where appropriate to edit data optional "display calculations" in loadout
9.5.5	Bug	Ranged damage not being displayed if not a warrior	Neil	This makes a difference only when using "overstrength" (which isn't possible with ranged attacks)
9.5.4	New	key new features for v9.5.4 from 9.5.1	Neil	Add a generic "custom bonus" table for any ability, allowing EP discount, extra ranks Remove idea of "purified" BC, and instead make purification either a Temporary or Permanent enchantment. Allow optional showing of "magic BC including temp enchantments" instead of "BC" and "BCPure". Custom Magic: Remove need for "BCPure" formula; New code automatically converts formulae to account for Perm/Non Perm magic. Add descriptions of key calculations on Loadout and Chr Sheet. Add Endurance armour to Custom armour types. Clarify components of armour on loadout: std, magic, NA, Endurance) Combat Calculations: Further separate out BCs/DM for Melee, Close, Ranged to correctly take account for Warrior & Overstrength conditions. (...so even MORE numbers! This is getting silly, but the rules require this sadly) Note: Healer penalty now not included in SC, but this was wrong anyway. to add this means you would need 6 different numbers, for all combinations of (M,C,R)x(SC,DM)... so I gave up. (Will wait until warrior 3.0, and petition for a change to healer SC impact) Add defence calculations on to chr sheet, to remove reliance on Loadout page. (which some people don't want) Loadout: allow additional one-off buffs for each loadout. Allow entry of a custom consumable without an error for the Weight calculation if it isn't in the custom consumables list. Add rudimentary water college; numbers are there, but not spell effect descriptions
9.5.4	Bug	Main non cosmetic bugs fixed in v9.5.4	Neil	Enchantments (ie Greater) missing from a couple of skill BCs (swimming, merchant) Remove healer penatly from SC, which was wrong anyway (now shown in Healer skill details) MR: Shape changer +5% was missing Third magical talent on chr sheet was missing (formula deleted) MR table: Correct separation of perm/temp magic Fix running of some button code in protected mode. Improve refreshing of lists and filters after changes; sometimes was not being done.
9.5.1	Bug	Some "Standard discounts" for Skills were not correct. Fixed earlier, but changes lost	Neil	Herbalist discount moved to Mechanician, Swimming discount moved to Weaponsmith, Thief and Navigator discounts removed
9.5.1	Various	Noticeable Enhancements for 9.5.1	Neil	Add Money sheet, and ranking changes to add Income & Training costs including cost of living Add philosopher fields to Skills Cleanup language tables, add Max Ranks, Fix incorrect families Add Philosopher Discount to Languages Add custom amulets (otherwise they have to be in "equipment carried during combat", which is a pain!) Weapons: Reorg columns, including Separate Warrior and Non-Warrior secitons (for SC and DM). Weapons: Allow selectable MD choice for calculations on Character sheet Merge 2 character sheets into one, with optional sections. (Options are copied from previous version during ugprade) Add enhanced Rank calculations to magic tables. Add optional "Show Primary Weapons Only" in character sheet Remove Female weight factor mod if not using Sex Mods
9.5.1	Various	Minor fixes and tweaks	Neil	Fix custom skills table as 9.4.2 (including cumulative update) Fix beastmaster num options; 1+xx --> (Rank>=0) + xx Custom Rituals were not being shown in Magic lists (point to wrong cell) Misc Equipment didn't have total after 5th line Increase Other Combat Equipment number of lines Cleanups on initial ranking by hiding/changing some field values, and mention Money requirements Bug: import character did not resets ranks (cause of "illusionist" counter at Rk 0?). Due to skipVal instead of skipErrorVal Custom Skills: "Usable" columns were incorrect Remove headers from a couple of ranges (eg alchemist, armourer) Add Merchant speciality to Chr Data BUG: Grenado Damage = #VALUE due to If "V" in table. Fix to show raw value if not numeric BUG: Primary language rank wasn't copied across with Chr Gen Equipment formatting; other armor AG mod formula BUG: custom Rankable Weapon name in EP table had been cleared BUG: non-Loadout Weapon Calcs used AG not AG_Combat Convert OSD column to +X instead of total D+X Fix racial witchsight rank=0 Refresh pivot tables with all other refreshes (or at least some... done) BUG: CustomWeapons not copying across Special - CustomWeaponData did not include column. BUG: get_version was returning formula not actual version; RangerSpeciality was not being copied across BUG: commit Ranking date not being copied across due to typo in name.

College Specific

College	Version Found	Bug/Suggestion	Entered By	Comments/Status
Namer	9.3.4	Missing Counterspells for Greater Summoner	Stephen
Witchcraft	9.3.3	Not sure this is a real bug as I'm trying the sheet with OO.org... but the Witchcraft College does not appear to be one of the available options to select in the Chr Gen and Chr Data sheet College dropdowns -- list ends at Water.	Martin	Yes - it is missing off the end of the list. FIX: Edit name "ListCollege" and change from "=Tables!$HI$4:$HI$21" to "=Tables!$HI$4:$HI$22". (In Excel, this is Edit->Names->Define) Note though that no one has put in the data for Witchcraft so if you would like to use it, let us know. --Neil FIXED: 9.3.4