In the interests of helping the cleric community, improving this tool, and hopefully encouraging others to share their tools, I would like to offer the cleric cast parse spreadsheet that I use to evaluate cleric applicants for my guild and for general knowledge and improvement purposes. It has come a long way from the first spreadsheet I came up with, which required a lot of manual data entry that took me a little over an hour for every cast comparison. Thanks to the efforts of fellow guild cleric Panorramix, it now requires just copying/pasting of a few parses from GamParse and provides a lot more data. You can download it from the link below, which is a link to a OneDrive folder with the most recent version of the spreadsheet (1.4). Just click download on the page there with the file selected: https://1drv.ms/f/s!Ak_B2EdsKUCXgQLsxjzyP9GfTWY4 Requirements There are, however, some requirements. The first is that you need GamParse (any version, though I am sure its creator/contributor would rather you use the latest one) and to use that, you need to log everything involving cleric casts in the game. It is possible, however, to use raw parses generated by someone else for use in the spreadsheet, though the instructions will assume you are logging things yourself. The second is that you need to download either OpenOffice (http://www.openoffice.org/download/index.html) or LibreOffice (http://www.libreoffice.org/download/download/) to use it. These are open-source programs that are available for free and provide functionality that is similar, though more limited, than Microsoft Excel. That might be a deal-breaker for some, but it was important to me that the spreadsheet be usable by anyone without requiring an additional purchase. Samples Here is what the spreadsheet can give you (not using actual cleric names because not all of those in my guild would be comfortable with their names and data being shared): Cast Comparisons by Category Cast Summary Bar Chart (All Clerics) Pie Chart Comparisons (Individuals) Instructions You'll first need to load up a parse in GamParse and combine all of the events you want to compare. Here, I'll just select them all and name them "EOK plus TBM Raids" then click on "Combine Fights" to combine them: Then, you'll need to go to the "Spells and Discs" tab, sort by class by clicking on "Class", then highlight a cleric whose parse you wish to export to the spreadsheet. Here, I will export my parse by clicking on "Export to Forum": Finally, you'll need to open the spreadsheet and right-click on the A1 cell in the "Spells" tab of the spreadsheet and select "Paste" (just press OK if something else pops up after that) to insert the parse into it. To find the "Spells" tab, look at the bottom and above where it says "Sheet 1/5" you should see some arrows to help you navigate the different tabs (Spells, Detailed Breakdown, Glorious Table and Summary, Pie Charts, Cast Time -- ignore that last tab though because it just helps create the "Time" stats and doesn't provide parse-specific information): The spreadsheet will do the rest of the work for you, and you can just navigate the different tabs to view the one you want to see and click on it to bring it up. You will have to modify the name of the cleric here on the "Spells" tab if you wish to modify the name throughout the rest of the spreadsheet. That can be done by just clicking on the cell the name is in (here it is A3) and changing the name there to something different -- you won't need to change it anywhere else. Then you just need to repeat the process from the selecting the cleric step for every other cleric you want to compare (up to 7 max). Troubleshooting I haven't had any problems using the spreadsheet but only Pano and I have used it so far. One thing you want to be sure of is that a certain option is enabled in OpenOffice if you're getting 0s for everything: That "regular expressions" option specifically is required for the formulas to work properly. Analyzing and Other Stuff I left a lot of things out about analyzing the results the spreadsheet gives you, but I will get to that another time if there is enough interest in the spreadsheet. I will say, though, that context is important in analyzing the results of this (or any) parse. So it's best not to view this as a "the one with the best numbers wins" situation or even view it as a competition where there is a "winner". A cast parse also just shows how much something was cast, not how useful those casts actually were. The assumption is, however, that clerics are casting things because they intend for them to be useful (or in the case of heals, casting them as often as possible to heal proactively), so I generally don't expect clerics to "cheat" and just cast things at random to get their numbers up (though that is, of course, always a possibility). The group healing situation also determines cast choices to a large degree. A cleric in a group with more tanks who tank simultaneously, for instance, will always have a higher group heal total, and since those spells take longer to cast, they won't be able to cast as many single-target heals. There are, however, subtle aspects to healing that can be uncovered through a parse like this, such as showing when spells and abilities are being under-utilized and the percentage of those casts to other casts. It is also useful to break things down by category (Utility Spells, Buffs, AAs, etc.) because it helps to see a cleric's relative contribution in each of those areas. Again, context is important because if you assign particular clerics to re-buff during combat (we don't) then one cleric is obviously going to do better in that category than everyone else. Speaking of categorization, some might not agree with how I have categorized things also. Undying Life, for instance, could be categorized as three different things (a single-target heal, a group heal, or a utility/buff spell due to the HP boost). In the spreadsheet and our guild, we mostly use it as a utility/buff spell because we encourage limiting it to targets that need the HP boost, but in other guilds where clerics are encouraged to just include it in a single-target multibind and it is just cast as another single-target heal, it would probably be more appropriate to categorize it as a fast single-target heal. I don't think it matters either way, however, as a cleric who uses it as a single-target heal without especially considering the HP buff is still providing the HP buff to their target, so it is still being used as a "utility" spell. Some clickies like the Manisi Balm effect from the Small Manisi Branch are included in the AA section as well even though they are not AAs because we wanted to encourage their use (and honestly, they are almost as good as AAs like Burst of Life). There may also be spells missing from the spreadsheet because we don't encourage their use (like Ardent Light). The spreadsheet is kind of hard to modify (the cost of making it easier to input the raw parse data) but if you have any feedback on things you feel would make it better or more usable for you, let me know. There is a lot more I could say about analyzing cast parses and about what some of the stats in the summary mean but I will have to save it for another time. Hopefully other clerics find the spreadsheet useful and if you have created something similar, please do share it, as we would like to see what others have come up with and how we can improve ours. Conditional Formatting (which would allow highlighting of the first, second, and third most frequent casters of each spell, for instance) is off the table, though, due to the difficulty of getting it to work with these formulas in the open-source spreadsheet programs.