Elitist Jerks - View Single Post

enthrop · 06/12/08, 10:56 AM

Was just hoping to get some help w/ the DPS spreadsheet..

I'm having issues where things aren't updating. If I change my gear around, I can force a refresh of the 'cycle' and 'execute' dps shown in cells A5/A7/A9 by hitting 'fix it'. That's really not an issue cause it's not too much work for me to hit the button. But the big DPS spanning cells E2-F3.. the only way I get that to refresh is to save & close the whole workbook, then re-open it. I'm not TOO concerned w/ that either because I can more or less rely on the 'cycle' dps when I'm comparing different gear.

The problem that I can't figure out a workaround for is when I change talents. For some reason, I'm semi-permenantly stuck on a 4xSlam, 2xMS, 1xWW for my "using." I wanted to compare this PVE Arms set with a PVE Fury set... I initially setup the PvE Arms set in Gear1, then loaded it in Gear2, changed the weapons & the talent spec that's being used. But the "using" won't change, and I think it's still calculating dps based on an arms approach.

I've looked at the equation, and the "USING" field points to the Warriors_Sim workbook's cell G2. I looked at that equation and it basically picks between N2 & Q2, depending on if an offhand weapon exists. I see my offhand weapon having a speed of 2.50, so it should be picking Q2, which is the DW option. But the cell isn't refreshing and just shows the 2H option. I went into the cell, simply hit "F2 (edit)" and "enter" again, hoping to force a refresh.. but it caused the cell to become 0.00 instead =( The Warrior_DPS sheet DID update, and also reads 0.00 now.

I'm wondering what's going on and how to fix this.. This is all on MS Office 2003 SP3 w/ low macro security settings.

06/12/08, 10:56 AM	#1004 (permalink)
enthrop Glass Joe Christinium Blood Elf Mage Doomhammer	Was just hoping to get some help w/ the DPS spreadsheet.. I'm having issues where things aren't updating. If I change my gear around, I can force a refresh of the 'cycle' and 'execute' dps shown in cells A5/A7/A9 by hitting 'fix it'. That's really not an issue cause it's not too much work for me to hit the button. But the big DPS spanning cells E2-F3.. the only way I get that to refresh is to save & close the whole workbook, then re-open it. I'm not TOO concerned w/ that either because I can more or less rely on the 'cycle' dps when I'm comparing different gear. The problem that I can't figure out a workaround for is when I change talents. For some reason, I'm semi-permenantly stuck on a 4xSlam, 2xMS, 1xWW for my "using." I wanted to compare this PVE Arms set with a PVE Fury set... I initially setup the PvE Arms set in Gear1, then loaded it in Gear2, changed the weapons & the talent spec that's being used. But the "using" won't change, and I think it's still calculating dps based on an arms approach. I've looked at the equation, and the "USING" field points to the Warriors_Sim workbook's cell G2. I looked at that equation and it basically picks between N2 & Q2, depending on if an offhand weapon exists. I see my offhand weapon having a speed of 2.50, so it should be picking Q2, which is the DW option. But the cell isn't refreshing and just shows the 2H option. I went into the cell, simply hit "F2 (edit)" and "enter" again, hoping to force a refresh.. but it caused the cell to become 0.00 instead =( The Warrior_DPS sheet DID update, and also reads 0.00 now. I'm wondering what's going on and how to fix this.. This is all on MS Office 2003 SP3 w/ low macro security settings.