Fletching Bod Workbook!

[Adrias]

Apparently my Taming Bod Workbook was popular enough that people were curious if I would make any others. So here one is! A fletching one (because this one had the fewest amount of items to my knowledge! )!

This information is likely not complete but was made to the best of my ability. If there are any errors, corrections, or features you would like to see feel free to contact me on the forums or in game (Adrias).

Some basic Information:
BOD (or however I decide to randomly capitalize it) stands for Bulk Order Deed.
SBOD stands for Small Bulk Order Deed.
LBOD stands for Large Bulk Order Deed.

Fletching Bod reward information: http://uoex.net/wiki/Fletching_BOD_rewards

There are only a handful of Fletching SBods:

Small Bods

• Bow
  Composite Bow
  Yumi
  Crossbow
  Heavy Crossbow
  Repeating Crossbow

And only 3 LBods
Large Bods

• Bow, Composite Bow, Yumi
  Crossbow, Heavy Crossbow, Repeating Crossbow
  Bow, Composite Bow, Yumi, Crossbow, Heavy Crossbow, Repeating Crossbow

Each BOD can require one of the types of wood listed below

• Wood
  Pine
  Ash
  Mohogany
  Yew
  Oak
  Zircote
  Ebony
  Bamboo
  Purple Heart
  Redwood
  Petrified

That makes a total of 216 SBODs alone! (10 per, 15 per, 20 per, material required, and the itemself!) This makes filling out a specific LBOD a difficult task!


Excel Workbook
I protected almost every cell besides the ones you want to plug values into. If you want to mess around you can always unprotect the worksheets (password is blank). If you wish you do not need to enable macros, as it only affects the calculator on the last page.

Important note - This worksheet only handles exceptional or normal bods. If you need to keep track of both bods download this excel file twice and name one "ExceptionalFletchingbods" and the other "NormalFletchingbods" (can name them whatever, this is just an example).

:!:disclaimer Can drive you crazy trying to put in hundreds of bods
-If you are upgrading to a newer version you should be able to easily copy and paste all the values into the newer version with no problems

fletchsmallbod.JPG (45 KiB) Viewed 4548 times

This the SBOD Worksheet (above). The layout for this is a bit different than my Taming Bod one. Since there are many materials to consider, I made a table for each amount in a specific SBOD (10x, 15x, and 20x). The left hand side lists the item and the row across the top is the material for the specific SBOD.

fletch3xlbod.JPG (63.06 KiB) Viewed 4565 times

This is the 3x LBOD Worksheet (above). The first column in this worksheet are the items in the particular LBOD. The second column is the material your specific LBOD requires. The top row contains the amount of each item needed in the bod: 10x, 15x, or 20x.

Ready to go? will turn from False to True when you have all the necessary SBODS and LBODS to fill out a particular LBOD.

Remember after you turn in a BOD to decrement all the necessary values in the workbook!

Another feature of this worksheet is a very, very crude "bod point calculator" (not pictured). This is under the Rewards worksheet tab. On this sheet you simply place a "1" in the row(s) that correspond to the BOD you are about to turn in to predict the reward you are about to get (I am unsure whether this rounds up or down). The reset button resets all the values to 0(for the points on this page! so don't worry about losing all the bods you put in!). You can get goofy results here by putting in numbers >1, multiple 1s in the same category, etc... The reward list is underneath the values (if you cannot innately see it).


If there are any errors, corrections, or features you would like to see feel free to contact me on the forums or in game (Adrias).

[kennth]

Well done dude,,,,,

[Gus]

great job .....how do i get the animal tame one

[Adrias]

click on the taming bod link in my sig, it's at the bottom of the first post.