Formulae of Fate: Spreadsheet

by Octagon

Tab 3: The Pet Model

Page Index

For a Printer Friendly version click here.

I. Forumlae of Fate Tutorial

II. Formulae of Fate Spreadsheet

Tab 1: Introduction to the Spreadsheet

Tab 2: Character Model

Tab 3: Pet Model

Tab 4: Summoned Monsters

Tab 4.1: Life Stat

Tab 4.2: Minimum Damage Stat

Tab 4.3: Maximum Damage Stat

Tab 4.4: Attack Stat

Tab 4.5: Defense Stat

Other Tabs

III. Download the Zip file: formulas_of_fate_v1.1.zip

2.1 Gathering the Data

*Note: The use of first person pronouns in this document refers to the editor, and these are my experiences as I followed this tutorial, and any mistakes are mine... not the author’s.

You’ll need to gather the data from your pet into a readily available place to enter into the spreadsheet. One thing you’ll notice about the Pet Model is that only a single entry is required: your pet’s level. All stats are calculated by the spreadsheet. So jot down your pet’s level, and then write, type or take some pictures of the bonuses on your pet’s jewelry, if desired. See below:

The Pet Sheet

An Example Item

2.2 Enter the Data

Whatever the method you choose, once gathered, the data has to be entered into the spreadsheet.

The RED boxes are for entering data, and are required for any evaluation to take place.

The GREEN boxes are output boxes, showing the results of your entries.

The BLUE boxes are for entering data, but are optional.

For example, a pet’s stats are determined by level, but comparing item bonuses by filling in the Item Bonuses section can sure help you decide which is the best jewelry for your pet.

Important Note:

Most of the images used for illustration below have been modified, anywhere from a little bit to a great deal, both for readability and to reduce image size, but they are designed to be easily understandable within the context of the spreadsheet.

2.2.1 The Ability Stats section:

Enter your pet’s level in the corresponding the red block, and all your pet’s stats will be calculated by the spreadsheet automatically, as shown below:

Pet Model Ability Stats

2.2.2 The Skills table

The skill scores for your pet will be derived from any entries in the Items Bonus section, as shown below:

Pet Model Skills

2.2.3 The Transformation table

The Transformation table lists the adjustments for all default fish types. Just copy the data from the monster you wish to evaluate to the corresponding blue boxes on line 22. For example, in the illustration below, the high-lighted numbers for the Shrike have been copied to the blue boxes.

You can also import data from modded transformations, see the The Introduction for details.

Pet Transformation Table

2.2.4 The Item Bonus table

Finally, the Item Bonuses section. This section is quite large, and so is divided into sub-sections by bonus type. This where you will enter the data collected from the jewelry you are considering for your pet.

This section is entirely optional, and can be used to great effect when comparing 2 single items against each other ( ie. compare two rings ). Just enter the bonuses into the blue boxes as shown below.

Important Note:

The presence (or absence) of any given bonus type within this table does imply that it “works” ( or in the case of absence, does not work ) when applied to the pet. I believe that to be beyond the scope of this document.

That said, it’s pretty much common sense... most pets do not carry weapons or shields, so weapon and shield skills are probably not a good bet for pet bonuses.

--Editor

1. Pet Ability Stat Bonuses