Originally Posted by Lord Pendragon
I was a big fan of the OpenOffice spreadsheet in BC, so I thought it was about time to get the new Excel version and start planning out my warrior's gear. However, after inputting all my current gear, the dps calculation has changed to "N/A". Likewise the SEP calculations, after I click on the green button, also all change to "N/A".
Obviously I'm doing something wrong. Could someone enlighten me? I'd love to start using this spreadsheet, but I have a feeling my inexperience with Excel may be getting in the way...
|
I've had this happen to me before as well. One solution although painful is to make a change, when you see your dps # calculate correct press alt+s to save the page. Then make another change. If you end up with the #N/A close the spreadsheet and re-open to the previously saved version. It may be a pain but it got me past my issue.
*Adding New Items* - I find it to be more work to insert a new row. I just take an item that has crap stats and rename it and replace all of the values on the lookup tab. I've add several items this way. I steer clear of items with procs/on use abilities and let that magic up to landsoul.
*Side Note - After patchwerk last night the spreadsheet seems to be a very accurate modeling utility. I did not reach the speadsheets DPS, but I was fairly close. Thanks again for the hard work landsoul