Search the Community
Showing results for tags 'excel'.
20 downloadsHere is an Excel-based Combat Record Sheet for 4th edition--didn't see one currently in the downloads. I reopened my Champions folder from the '90's and was motivated to work on a throwback 4th edition game on Roll20 for a charity fundraiser to fight COVID-19. The embedded formulae calculate and place Phases in the appropriate Segments of the Speed column based on the Speed Chart on p.139 of the Big Blue Book (BBB). For example, if Mindlock has a SPD of 5, the spreadsheet automatically populates action Phases for her in segments 3, 5, 8, and 10-12. I included other examples from sample characters in the BBB as well, but please note that ALL of the columns with segment values have the embedded formula based on the SPD column. Just insert your combatants in the appropriate rows, insert their SPD, and the chart will do the rest. You can copy-paste for more rows or delete rows as desired. An additional benefit of Excel: insert your combatants in any order, use the Sort function based on the SPD value, and your combatants will sort themselves automatically into turn order. Comments and corrections welcomed. For anyone interested in participating in a Roll20- and Zoom-based episodic 4th edition game to raise money for charity--stay tuned! I hope to announce something here and on Roll20 in the near future. Best, Steve "Koop" Kuperberg 4th edition GM at University of Michigan-Ann Arbor 1989-91, presently Bethesda, MD ChampionsCombatSheet.xlsx
163 downloadsThis is an Excel spreadsheet that generates Hero Designer prefabs using Custom Skills and Custom Powers. It works best for creating lists of items such as equipment. It does not add (or extract) advantages or limitations though these can be added in Hero Designer. It can separate groups of data into Lists. Once appropriate data has been entered, paste the resulting output in to an empty HDP file. For Equipment: Captures Name, Description, Price, and Weight. For Skills: Captures Name, Description, Skill cost, End Cost, Skill roll. Options for custom skill or skills using the Power Skill For Powers: Captures Name, Description, Real Cost, End Cost Description Example: Given the following block of text if entered in the Description area of the spreadsheet: <i>Creates a small bubble of acid that is hurled at the target</i><p>Ranged Killing Attack 1 point (vs. PD), Penetrating (+1/2), Uncontrolled (+1/2), Continuous (+1) (15 Active Points); 1 Continuing Charge lasting 1 Turn (-1 1/4), Gestures (-1/4), Incantations (-1/4), Extra Time (Delayed Phase, Only to Activate, -1/4) This is applied to the Display area of a HD power resulting in: (Note italics and separation of first and second line. Creates a small bubble of acid that is hurled at the target Ranged Killing Attack 1 point (vs. PD), Penetrating (+1/2), Uncontrolled (+1/2), Continuous (+1) (15 Active Points); 1 Continuing Charge lasting 1 Turn (-1 1/4), Gestures (-1/4), Incantations (-1/4), Extra Time (Delayed Phase, Only to Activate, -1/4) Instructions are included for use and sample data to get a better idea of how this works. This was designed in the Open Office spreadsheet and converted to XLS. I have not been able to verify its full functionality in Excel. If there are issues or questions, please let me know.
245 downloadsThe file is still a work in progress but I wanted to upload it and see what people thought. The file uses a bunch of macros. Don't change the file name, the hyperlinks will fall apart. There is a color code, cells colored green indicate that it's built to be changed. Don't change a cell that isn't green.
527 downloadsIn the Hero system, movement is measured in meters per phase. Meters aren't used in the U.S. culture. Phases are "measured" by speed (SPD), and phases are within turns, which last 12 seconds. The number of miles per hour achieved by a character is dependent on their movement (purchased or unpurchased) and their SPD characteristic. This chart, when printed, provides a handy reference to know how fast, in U.S. terms, a character can go given these two variables. Since normal humans are given SPD 2 and running at 12 m, you can see this computes to about 4.5 MPH, which an average, healthy, human adult can run. The chart is also helpful if you want to build a character that moves a certain number of miles per hour. If you have already bought the character's SPD, then you can do a reverse look-up and buy the appropriate movement in meters for the movement ability you are building (such as flying, swimming, running, or tunneling, etc.). For instance, to fly at 40 miles an hour, you buy about 70 m of Flight at SPD 3, about 55 m of Flight at SPD 4, about 45 m of Flight at SPD 5, etc. You are also free to change the Movement column values, and the whole grid will update to reflect your changes (it IS Excel, after all).