Jump to content

Create Your Own Defenses


xplozv

Recommended Posts

This is for the newer people because I just figured this out.  There's functions called hexdec and dechex on excel that allow you to organize your pointers.  For a given play you can figure out what location to start in rather than having to flip back and forth between where ever you're keeping track of pointers you just made and another spreadsheet:

 

  1. Enter in the first hex location for a given byte in a cell (for example:  defense 50 is at 66f0, which is in row 31 in the downloadable defensive pointers spreadsheet).  Thus, for our example, you'll type 66f0 in cell M31;
  2. Off to the side along the same row, enter "=hexdec(M31)."  (M31 is the first blank space to the right on this spreasheet.  You should get the value 26352);
  3. Go down one cell from what you just entered (=hexdec..., which we'll call Z31) and type "=Z31+22. " (This was typed at Z32 and should yield 26374);
  4. Then come back to the original row (at M32) and type "=dechex(Z32)."  This should come out to a value of 6706.
  5. Simply copy and paste vertically all the way down the column until you've finished at FD (being the pointer value, with 75CE, presumably at M204).  Z204 then should read 30158.

 

Working on the 4-3 is not more complicated.  All you have to do is start the process with 466F0 instead of 66F0 for the 3-4.  The first hexdec command/equation will yield 288496, then plus 22 in the cell below will give you 288518.  Covert the cell underneath of the value 466F0 (=dechex of the cell containing 288518) and then copy and paste accordingly.  The values will read like normal. 

 

 

This helps know where to start when editing plays, rather than counting to 22 everytime you want to start or having to use a calculator. 

 

Edit:  I've noticed that they're a large gap (see the calculations from O33 on the 3-4 tab) in the defensive play byte coding.  There are 37 available slots from 2c to 50.  Has anyone tried playing with these?  (It works out evenly also, as there are 814 hex spaces and 22*37 = 814).

 

There a similar gap on offense between the formation pointers (41f4) and those dealing with the offensive (non-STs) play commands.  I don't know how you would access these, but there's space there.

 

 

 

Pointers help.xlsx

 

Defensive Pointers.xlsx

Edited by quince3800
Spreadsheet being updated and question asked
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...