Awesome, good to hear man!

Hey all, in looking at this with Warbash I realized that the recent website change (omission of the previous home page and magelo switch) the magelo tables are pulled into excel differently. It's still possible to get the data, with some modification to cell lookups etc. but I don't have time to update this right now.

I know mq2 has a plugin available for this but I'm not sure if it's allowed, would need word from Hunter.

MQ2AutoLogin

Hey Warbash, glad this is helpful! If you aren't able to sort out the glitches let me know and I'll see if I can help.

I'll add a list of known issues that I haven't buggered to fix:

• Second bracer needs to be found using a manually adjusted OFFSET within the excel function
• Haven't come up with a way to show the currently equipped secondary
• Not an issue but I would like to label each character as T1, T2, etc. based on their highest level of COMPLETE gear set

I'm sure their are more problems but those are the ones that bother me the most right now. 

Hey EZ Server,

I made an spreadsheet that people may be able to modify for their own needs. It tracks my group of characters' gear by scraping information from their magelo links.

To utilize this for your own characters you'll need to:

• Change the tab names to reflect you characters' names
• Update all of the data connections to point to the appropriate magelo links
• Change the character names in cells B1, C1, etc. to your character names

I believe the rest of the spreadsheet is completely dynamic and should, once the above is done, update for your characters.

Here's an example of the data shown.


Link to spreadsheet:
EZServer Character Spreadsheet

Disclaimer: Don't trust me or anyone else giving you a macro enabled spreadsheet. If you want to use this make sure you enable the developer tab and check out the function I built to scrape the magelo tables.