7Likes
v5.1 is out! -- RIFT Patch v1.7.16
------------------------------
>> Links <<
For Online Viewing Purposes (no sorting buttons visible * ... DPS/FOCUS sorting used as default), please use this link:
Online View
For Download Purposes (with working sorting buttons and toggles *), simply click the download link, save the file to your PC and open it with Excel:
Download Link
Just for some extra peace of mind:
Virustotal Scan
* Note: Online Spreadsheets do not convert my Excel macros and custom functions. So, you will need to download the actual file in order to get functional sorting and toggle buttons in Excel.
If you do not have Excel, try this free suite http://go-oo.org/.
------------------------------
v5.1 Change Log (05 - 10 Apr 2012) -- RIFT Patch v1.7.16 ::
General Changes:
- Added a proper 1H/OH vs 2H weapon comparison system to the "Compare" sheet. Please check the "Details" section below for details on how to use it.
- Renamed the "TABLE" sheet to "Raid Buffs" and updated it to include more raid buffs to serve as a "Raid Buff Simulator"! Added automatic color-coding to it for easier visual tracking, in addition to a few others things. Please check the "Details" section below for more info on this.
- Moved the List Item Counter to "Runes" sheet. Total item count now is 669.
- Linked all the Tier 5 Epic and Relic ID gear to the Nyx's /Mage/ Crystal.
- The sorting now uses "post crit cap" stat weights by default. You can, of course, still change it to whatever you like in the "Stat Weight" sheet. DPS/Focus sorting is still used as default.
- Updated the "Legend" sheet with some basic info on Fire and Earth Resistance recommendation. The info is not final and will be updated soon.
- Changed Proc % Chance on Darkling Skull from 80% to 90% Uptime.
- Added drop source for:
- Diamond Hide Necklace.
- Mantle of Immortal Flame
Gear List - Added:
One Hand:
> Carceran Wizard's Dagger (Clever/Cunning)
> Fang of Maelforge
Off-Hand:
> Word of Laethys
> Eternal Sands of Laethys
> The Word of Maelforge
Staff:
> Prodigality
> Hookmaster’s Bloody Pylon
Wand:
> Lake of Fire (I assume focus = 75)
Helmet:
> Cowl of the Dawn
> Infernal Cowl
Shoulders:
> Shoulderpads of the Dawn
> Infernal Shoulderpads
Chest:
> Robe of the Dawn
> Infernal Robe
Gloves:
> Gloves of the Dawn
> Infernal Gloves
Belt:
> Belt of the Dawn
> Infernal Belt
Legs:
> Pantaloons of the Dawn
> Infernal Pantaloons
Feet:
> Slippers of the Dawn
> Infernal Slippers
Neck:
> Amulet of Laethic Gemstones
> Zael's Ever-burning Heart
> Annihilating Flare Amulet
Ring:
> Carceran Wizard's Ring (Clever/Cunning)
> Carceran Mystic's Insignia (Clever/Cunning)
> Carceran Crusader's Fingerguard (Clever/Cunning)
> Clutch of Immolation
> Seal of Cremation
> Burning Blood Gem
> Ring of Burning Sacrifice
> Eye of the Corpse Eater
> Power Monger's Curse
Essence:
> Sublime Coruscating Brimstone [F]
> Sublime Glittering Brimstone [F]
> Tectonic Shard [E]
> Purity Stone [E]
PS: Please note that any of the above items that were added from Patch 1.8 on PTS are not yet final.
IMPORTANT NOTE: There is a something wrong with Augments at the moment. Values listed in my Augment List could be off.
Crafted items in my List could be inaccurate and are tagged in red font for now.
==========================
>> DETAILS <<
------------------------------
The "Weapon Comparison" System:
Have you ever wanted to quickly and easily compare between a One-Hand/Off-Hand combo and a Two-Hander, without the need for a calculator?
Then please check out the new "Compare" sheet!
I've re-designed the old Compare system to work more efficiently and on the fly!
(I've re-purposed Column A in the main LIST for this feature.)
There are 2 comparison sets available (SET A and SET B). Each Set is independent and allows you to compare a One-Hand / Off-Hand combo to a Two-Handed item (including Runes).
You can also compare 2 One-Hand / Off-Hand combos against each other, or even 2 Two-Handed item against one another.
You can use one set or both. There is also a cross-comparison included between both Sets.
This comparison system also has built-in color-coding for easier tracking. It activates automatically when you type A, B, etc.
SET A = Turquoise color (Light Blue).
SET B = Lavender color (Purple).
How to use:
Simply, go to the main LIST, put a mark (A, B, A1, etc) to the left of each item you want to compare, then go to the "Compare" sheet to see the results!
SET A
For the One-Hand / Off-Hand combo and Runes:
Under column A in the main LIST, type A to choose a One-Hand item. Then type another A to choose an Off-Hand item.
Under column A in the main LIST, type A1 to choose a Rune for the One-Hand item. Type A2 (optional) to choose a Rune for the Off-Hand item.
PS: There is only 1 Rune list for both One-Hand and Off-Hand, and it is found under the One-Hand section.
PSS: If you want to use the same Rune for both the One-Hand and Off-Hand, avoid typing A2, and then A1 will be used for both.
For the 2H and Rune:
Under column A, type A to choose a Two-Handed item.
Under column A, type A1 to chose a Rune for the Two-Handed item.
SET B
The same goes for SET B, but with 2 exceptions:
1. You need to type the letter B instead of A to choose your weapons.
2. You need to type B1 (and B2) for the runes instead of A1 (and A2), but under COLUMN B instead of Column A .
For the One-Hand / Off-Hand combo and Runes:
Under column A in the main LIST, type B to choose a One-Hand item. Then type another B to choose an Off-Hand item.
Under column B in the main LIST, type B1 to choose a Rune for the One-Hand item. Type B2 (optional) to choose a Rune for the Off-Hand item.
PS: There is only 1 Rune list for both One-Hand and Off-Hand, and it is found under the One-Hand section.
PSS: If you want to use the same Rune for both the One-Hand and Off-Hand, avoid typing B2, and then B1 will be used for both.
For the 2H and Rune:
Under column A, type B to choose a Two-Handed item.
Under column B, type B1 to chose a Rune for the Two-Handed item.
- You will see some pre-existing examples on the main LIST for easier reference.
- This system is *very* simple once you understand how it works.
PS: The letters are NOT case sensitive, so both "A" and "a", or "B1" and "b1" will work, etc.
Tip:
In the "Compare" Sheet, the results window can quickly tell you which item is better (as you can see from the larger sign ">").
So, if you see: [SET A] 1H/OH > 2H ... then it means: In Set A, the 1H/OH is better than the 2H.
If you see: [SET A] 1H/OH > [SET B] 1H/OH ... then it means: the 1H/OH in Set A is better than the 1H/OH in Set B.
------------------------------
The Raid Buff Simulator:
This is a new system designed to provide you with a good estimate of expected TOTAL STATS (Spell Crit, Spell Power, etc) while raid buffed.
It also shows you the net gain from Raid Buffs, compared to the Base Stats you entered.
PS: Your Planar Attunement (PA) stats are factored into The Raid Buff Simulator, since it relies on your Base Stats input.
How to use:
Just enter your unbuffed base stats in the yellow section (as indicated to the left of the table), and then click "ALL ON" button to activate all the main buffs at once.
You can then use the single "CHECK MARKS" to turn on and off individual buffs, as per your preference.
Click "ALL OFF" to turn off all the buffs.
PS: If I missed any buffs or if you have any comments about this new feature, your feedback is welcome.
------------------------------
Updated to v5.1 (10 April 2012)
Updated to v5.0 (05 April 2012)
Updated to v4.7 (11 December 2011)
Updated to v4.6 (29 November 2011)
Updated to v4.5 (20 November 2011)
Updated to v4.4 (01 November 2011)
Updated to v4.3 (04 October 2011)
Updated to v4.2 (23 September 2011)
Updated to v4.1 (5 September 2011)
Updated to v4.0 (31 August 2011)
Updated to v3.9 (22 August 2011)
Updated to v3.8 (15 August 2011)
Updated to v3.7 (08 August 2011)
Updated to v3.6 (03 August 2011)
Updated to v3.5 (30 July 2011)
Updated to v3.4 (14 July 2011)
Updated to v3.3 (03 July 2011)
Updated to v3.2 (01 July 2011)
Updated to v3.1 (30 June 2011)
Initial Release v3.0 (28 June 2011)
------------------------------
If you have any comments or feedback, please feel free to post here or PM me.
Credit:
Most items' info was taken from Zam (and some cross-referenced with WindstormSCR's Mage List), unless otherwise stated.
Special Thanks:
WindstormSCR (Araenn) for his collaboration.
Enjoy,
Rez
Reply With Quote
Originally Posted by Zaphrina 
Bookmarks