You can get a rough idea of what to do by looking at this thread:http://us.battle.net/d3/en/forum/topic/7415156516
These instructions are slightly dated, but they should be a good starting point. You can also check out some instructions I wrote for comparing sets of gear and using the "test" columns on the DPS worksheet to make quick comparisons:http://us.battle.net/d3/en/forum/topic/7811022081?page=2#36
If you have any questions, just ask.
Currently, column E on the DPS worksheet is a scratchpad for off-the-cuff 1.0.6 calculations, and column I is a similar feature for the PTR.
Regarding formulas, I have put very light lock protection on the sheet (no password required; you can select but cannot change locked cells). This means that you can unlock the individual sheets if you want to play around with the formulas but that you can lose the formulas if you're not careful.
The basic rule of thumb:
If you want to know whether you should enter data in a cell, click on it. If you see a formula, don't enter anything. If you see a tooltip, follow the instructions.
The on-click tooltips are in every data entry cell in the sheet EXCEPT the drop-down fields on the Armor worksheet.
So that's pretty much it! Here's the basic flow:
1. Enter all the information in column C of the Character Sheet worksheet, except for the Attributes section.
2. Go to the Weapons worksheet, and use columns G through N to enter the data from your weapon tooltips.
3. Select a MH weapon and an OH weapon from the drop-down fields in cells D3 and E3.
4. Go to the individual armor worksheets ("Helms," "Boots," etc.), and use columns F through O to enter the data for your individual armor pieces. (Note: This is not what the Armor worksheet is for.)
5. Select a piece of armor in each worksheet, just like you did in step 3 for your weapons.
6. Use the Armor worksheet to mix and match your gear. Anything that isn't part of your normal gear set (i.e., that doesn't match the selections on the individual sheets) will be shaded light brown so you can tell that you changed it.
7. To commit your changes to the individual worksheets, click the Copy to Worksheets
button. To discard your changes and load your original gear selection, click the Copy from Worksheets
8. When you're finished with your armor selections, go to the DPS tab. A lot of your character's information will already be loaded into column C (for the live server) and column G (for the PTR).
9. Use cells C1, C2, and C3 to select a primary generator. For best results, um, stick with Thunderclap, as I haven't coded much of anything other than Quickening yet.
10. Select your SW snapshot weapon from cell C27. Your options are Main Hand, which indicates that you always ready the MH weapon; Off Hand, which you can probably figure out; and Random, which indicates that you don't ever bother looking.
11. Enter the sum of your additive damage buffs in the Other damage buffs (total %) field (cell C35). This will soon be programmed to load Blazing Wrath, Overawe, etc., but it's a manual field for now.
12. If you are using a WKL, enter the lightning buff in cell C36.
13. Your paper DPS will appear in cell C44, and your EDPS will appear in cell C50. To change the number of targets, use cell C18.
14. If you're playing around with the 1.0.6 or PTR scratchpad columns, use rows 24 to 26 to enter MH/OH attack speeds. Do not include IAS on your gear, but include anything that's on the weapons, plus the Enchantress bonus if you're using that. And Blazing Wrath's +0.05 APS per stack, if you're using that.
15. Once that is done, go to the Snapshot worksheet. Your current profile will appear in row 3.
16. To copy your current character's stats to row 5, click the Copy Snapshot button.
17. To copy and compare other stats/setups, make the desired changes elsewhere, come back to the Snapshot worksheet, and click the Copy Snapshot button.
And that should do it! Don't mess around too much with any of the arrays beyond the Shields worksheet. (They're currently hidden.) If something doesn't seem to be working as expected, make sure you've entered the correct data; if something still doesn't look right, let me know. (A note about socketed weapons: just pretend the socket bonus is part of the weapon's affixes. For example, a 68% CHD weapon with a 70% emerald should be recorded as a 138% CHD weapon.)
Enjoy! I'll be using this thread to answer any questions asked here, or any FAQs I receive via e-mail or in-game.
Thank you all for your patience.