Cyberpunk 2020 Character Generator

Menu

Version History

Basic Help

  • Introduction
  • Character Generation
  • Improving Characters
  • Help on Sheets

  • "Main" Sheet
  • "Skills" Sheet
  • "Lifepath" Sheet
  • "Cyberware" Sheet
  • "Weapons" Sheet
  • "Equipment" Sheet
  • "Armour" Sheet
  • "MiniCharacter- Sheet" Sheet
  • Advanced Help

  • The Toolbar
  • Character Database
  • Adding Reference Data
  • Language Support
  • Setting Up
  • Version History
  • NB: I increase the version number by a full point whenever the database format changes. you'll need to import all your old characters.

    CP2020v8.1

    This version primarily contains bug fixes. There was a problem when buying skills during character generation. It now can cope with you not spending all your points at once. The minisheet buttons were a bit dodgy - so they now work properly too.

    Other issues arose because of the changes to the last version. Importing old characters now works fully and you can put non-numbers in the Rounds and ROF part of the weapon list. I've increased the width of the weapon description column on the weapons sheet and added some smartgun linked weapons to the default list. Also, the smartgun link tick-boxes now clear properly when no weapon has been entered.

    Finally, I changed the sheet and VB passwords. If you've hacked or worked out the password, you're going to have to do it again.

    CP2020v8

    There have been alot of major changes in this version!

    Weapons: Added the stuff so that weapons operates similarly to cyberware/lifepaths/etc. This means that you can select weapons on the Weapon sheet via a pull-down list and that there is a button on the Setup page for added/edited/whatever more weapons. This means that I've reduced the number of things you have to type in on the Weapons sheet - you only need the name and any extra skill modifications. I've also entered all the weapons from the main source book. Also, it'll prompt for weapon information if it doesn't exist when you are Selecting a character.

    Optimising: In an attempt to reducing the size of the generator (to compensate for the added features) I've done some code optimisation, removed the form for saving characters, combined some other forms and reduced the quality of the pictures.

    Import/Export Data: Instead of typing every bit of custom data (extra weapons, new cyberware, etc) by hand when transferring to a new version you can export the data, alter it, then import it again. Access it via the forms on the Setup page

    Language Support: I've automated the process for reading in new language versions and changed how the source text is put together.

    Bug Fixes: The kit sheet has been fixed so that some of the text and generator instructions don't print. You can properly type the record ID number into the box on the View Database form. I fixed the write HTML so that it writes out the Armour stuff too. Now you can't delete everything in the data tables, thereby screwing the whole thing up. If the BODY stat = 0 then the damage modifier and BTM cells don't get errors.

    Enhancements: The Select Character now uses the progressbar and I've added a logo to the mini-character sheet

    CP2020v7.5

    The Generator can now write out your characters in HTML! It uses tables and style sheet, although it works without the style sheets.

    Also, 1 minor fix. It now clears the tick-box for smartgun-linked weapons when you create a new character

    CP2020v7.4

    I improved the VBScript which checks if certain boxes/cells contain numbers. Checks have been added to the equipment cost box (on the sheet) and the lifepath Stat modifications

    The reset skills button now no longer locks the chipped skill tick boxes and I now use "Cyberware" instead of "Cyberwear"!

    The Character Notes sometimes wasn't being imported properly. This is fixed and the generator also warns you of the location of any other problem cells when selecting a character. Now the database closes when you cancel a save and you cannot delete the character you are working on.

    The armour layering checks were not working properly and the new character button on the character generation form does not give the error it gave since the last version. The buttons on the Role setup form also reset when the reset buttons are pressed and the career skill list updates properly after selecting a character.

    Finally, I've cut down the constants required in the StringTable for the alternative language version. Basically I've removed the duplicate text

    CP2020v7.3

    The first full Italian version highlighted a few minor issues with the Language Support preparation. These are now fixed! Hopefully, all I need now is more languages...

    CP2020v7.2a

    Fixed a bug that caused the equipment selection to stop working. Added the employed/unemployment pull down to the list of stuff to be translated and changed text box sizes, etc for the 1st draft of the Italian Version.

    CP2020v7.1

    I tightened up form layouts and changed the character picture to something much better. The gender of the picture changes when you set the character gender. The old picture was also removed from the Cyberwear page and the layout of the page modified.

    Age checks on the Character generation form had broken the "Next>>" button - now fixed. Character Notes now get saved properly from the character generation form too.

    Skill name boxes were becoming unprotected occasionally. They now don't become unprotected at all

    I re-organised everything (forms, error messages, sheet text and buttons, pull-down menus and data sheets) such that the generator can be configured for different languages. Email me at cyberpunk@mieow.co.uk if you want to do a translation.

    CP2020v7

    This version is updated for Office 2000.

    The "Employed Status" box had got locked somewhere - not any more. There is a new Progress Bar which looks better and allows me to be more accurate.

    The equipment table got messed up if it was full when you wanted to remove some items. Now cannot edit gear which has been added (removed edit box)

    There was a missing "confirm delete role profile" dialog. It's be re-added

    Now the "showmodal" property is available for forms, I've changed the way you spend career, pick-up and IP points. Its much groovier now!

    The template/database has been changed to accomodate the new methods

    Added an "edit skill levels" toggle button

    Miscellanous Cyberwear was confused with Custom if the "Special" button was used

    CP2020v6_1

    Error messages used to pop up about not being able to protect/unprotect sheets. This problem has been fixed.

    There was a problem with the career skill buttons when reading in another character - also fixed

    You only need to fill in the "1x" box for the weapon ranges - and some dodgy tick boxes were fixed there too.

    The "special armour" section now counts towards the SP.

    Finally, the option button for changing skill names an IPs has been changed to a form. The default skills (those filled in when you start a new character) can also be set from the "setup" page.

    CP2020v6

    Added a text box to save character notes in. This saves to the database and can also be accessed from the character generation form.

    The career points to spend was being reset when "show career skills" was pressed - but the points already spent were left alone. This has been fixed. Also, the buttons to select between a choice of career skills wasn't locking or unlocking the cell to enter the skill level in.

    Now you can update the current character from the menu bar when you aren't on the "Main" sheet. And characters can now be updated after they have been "select"ed from the database.

    On the minisheet, it is now not possible to have all the buttons unselected.

    The menu bar is now created and removed internally to avoid it lingering unpleasently or pointing to a previously opened workbook.

    There were lock error messages appearing when saving characters sometimes. This and similar errors have been removed.

    If you had been creating a Techie via the character generator form, it would constantly complain about skills being invalid. Now it only highlights the cells that need a skill put in. Click "Show Career Skills" when you have selected your skills.

    Renamed "Add Data & Help" to "Setup" and made a few layout changes. Also updated the help pages to cover all the changes.

    CP2020v5_5

    Found a bug that had crept in after optimising the code: "Update Character" didn't work. This has been fixed.

    CP2020v5_4

    It was starting to get a bit big, so I optimised sections of code for size. This even speeded up some parts - especially the Cyberwear stuff. It dropped about 400k-bytes in size (unzipped) and about 200k zipped.

    CP2020v5_3

    It now adds a ".xls" to new databases if the users didn't type one. Silly me thought that Excel did this automatically. A generate "employment status" button has been put on the main sheet so that you don't have to start up the character generation form if you don't want to. The sheet used to accept extra white space at the start and end of the Role name. This confused it later on, so it now removes any extra white space it finds. Clicking the blue buttons half-way through speding points would reset the number of points. It now doesn't warn you about resetting the skills if you haven't spent any points on them (when calculating stats).

    I've also added a toolbar and you can now edit the life events so that they'll be save to the database. You'll get the same form when you "view lifepath" from the character gen form.

    My last lot of fixes had meant that it came up with an error when you tried to spent IP. It might also be a touch faster with some alternative coding things I did.

    CP2020v5_2

    Noticed that a cell had been corrupted while the Life Events subroutine had been re-written. This has been fixed.

    CP2020v5_1

    The IP stuff has been recoded and neatened up. It should be less prone to problems now. The database has changed a bit so old characters will need to be imported.

    A problem had developed with using/creating a blank database. This is fixed. Career skills now highlight when clicking the "choice" buttons and the career skill picked now locks and unlocks correctly. It now reads in entered career skills (e.g. Techie) when you read in a different role - instead of deleting them. The workbook does a SaveAs if it hasn't been saved before (when using the template).

    You used to be able to get your character and career points back if you swapped sheets halfway through spending them - not any more. Also fixed the annoying message that appeared at startup about selecting a cell. Stopped the skills sheet popping up occasionally - especially when going to/from the mini-sheet.

    The following sections were recoded such that the sheet formulas where transferred into Visual Basic Macro. Hopefully this should speed things up and make it more reliable.

      Skills calculations
      Humanity Loss calcs
      Cyberwear calcs
      Armour formulas
      Equipment calcs
      Life Events generation

    Finally, there were minor changes made to the helpfiles. Mostly just bits and pieces that hadn't been updated or were wrong

    CP2020v5

    Setting the number of character points in the "Main" sheet now makes a difference to character generation (despite what the previous helpfiles said).

    The lifepath area is now cleared up so that all the pages get deleted when both a new characters is done and the generate lifepath button is pressed again. It now doesn't create the extra lines at the bottom if the age goes over 40.

    Combat sense is now added to the initiative and gender has been added to the mini character sheet. The mini sheets has had some changes so that you can print it out as a usable blank character sheet.

    IP is now set in a form. It makes things much neater. Any unspent IP wasn't stored properly. This is fixed - but you'll need to import your old characters into a new blank database.

    CP2020v4

    For some reason the last lot of modifications didn't get saved. They have been included in this version.

    There will now not be any error messages if you try to remove characters from the import list when there are none there. It also won't allow you to open a template as a database file.

    If you move equipment in the list - it won't put a zero in the how many column.

    Some bits have been (slightly) speeded up by not using the sheet progress bar and the cost of armour will now be factored into how much you've spent if you buy armour from the Character Gen form. Other bits and pieces with the Equipment table have been fixed

    There was a problem creating a blank database. There was a blank column where there shouldn't be. This has also been fixed.

    Finally, the left pickup skills wasn't being updated properly if you moved sheets while still spending them. Every time you went to another sheet and returned - the number of points to spend reset

    CP2020v3_6

    Now it will offer you the option of importing a character if you click on "View" when there are no characters in the database. The area for lifepaths is set at 2 pages worth. "Special" button/form on Cyberpunk sheet doesn't always read the misc table okay. This is fixed for the first 2 cells of the misc table. Hopefully now won't crash on PC Office '97 when clicking on the Role spin buttons.

    CP2020v3_5

    Any forms that needed paths now uses standard Excel form for getting pathnames. Now asked to Confirm that the user wants to delete a character from the database. The "generate_lifepath" button in the character generation form now doesn't bring up an error when pressed after having spent skill points. A 0 SP was considered a layer if the cell was filled in - fixed. The skills are now always reset when any stat is changed in the character generation form. The cancel button on the View database form is changed to a close one (no functional change). The list boxes now can't scroll past the last entry. Moved Import button on Main sheet into database form. Entered skills clear when the Role changes. On opening the template or worksheet, a check is done on the location of the database. The worksheet will now create a new database if it can't find one already!

    CP2020v3_4

    Added Form to read in old characters from previous versions. Wasn't saving what career skills chosen (ie Martial Arts or Brawling for Solos) - fixed. Added buttons on Minichar.. to select how you want skill levels displayed. Can now find records over 1 digit long by typing ID in View DB form. Reading in characters now checks for Roles and Cyberwear not saved in data lists. Moved print button on "Main" to fit import button in. Print button on "main" gives choice of what sheet to print. Other bits and pieces tidied.

    CP2020v3_3

    Lifepath info typed in on char gen form not always written to sheet properly: fixed. Current Body value was using wrong mod to calculate: fixed. Can choose on MiniCharacter Sheet how to display skill levels. check boxes for chipped skills on mini sheet now relate to skills chipped as does damage taken.

    CP2020v3_2

    Printing out the full sheet is a waste of paper if you just want your stats as a reference. The "MiniCharacterSheet" was added as 2 pages of useful character information.

    CP2020v3_1

    Release Version. Found code that hadn't been tidied up. It would generate at error when the "new character" button was pressed: fixed.

    CP2020v3

    Release Version. Tidied up code and helpfiles.

    CP2020v2_7

    Can now add a character record using the Save button. Stopped from crashing when filled in certain cyberwear boxes. One cost for cyberwear not calculated when cyberwear added: fixed. Checks in boxes in armour sheet removed when armour removed or when a new character is needed.

    CP2020v2_6

    Excel doesn't update newly blank cells when saving character sheets. Added Save button on "Main".

    CP2020v2_5

    Now saves Life Events upto age 40. Career Points and pick-up skills points left saved. Formula for BODY and REF mods fixed. Roll 0 siblings, instead of "none", "non" caused type mismatch in form.

    CP2020v2_4

    Whether chipped skills were used, wasn't saved: fixed. Fixed setup form. Database now checked for when the file is opened, prompts if can't find it. "New Character" clears chipped skill check boxes. Help files finished, and updated.

    CP2020v2_1 to _3

    Some formulas in cells lost when character data was read in from database: fixed. Whole database code speeded up. Added setup form.

    CP2020v2

    Now saves and reads in characters, ie character database done. Error handling added: eg, error message box appears when typed in text instead of numbers.. and doesn't crash the program.

    CP2020v1???

    Sheet Layout done. Character Generation done, etc, etc. It's a bit slow and you have to save the whole thing for each character but it works.