Fletching Bod Workbook!
Posted: Sat Jan 08, 2011 3:16 am
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
Large Bods
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
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.
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).
)! 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
Large Bods
- Bow, Composite Bow, Yumi
Crossbow, Heavy Crossbow, Repeating Crossbow
Bow, Composite Bow, Yumi, Crossbow, Heavy Crossbow, Repeating Crossbow
- Wood
Pine
Ash
Mohogany
Yew
Oak
Zircote
Ebony
Bamboo
Purple Heart
Redwood
Petrified
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 4549 times
- fletch3xlbod.JPG (63.06 KiB) Viewed 4566 times
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).