Welcome, Guest. Please login or register.
Did you miss your activation email?
July 04, 2024, 07:40:52 am *

Login with username, password and session length
Pages: [1]
Print
Author Topic: Excel Character Tracking - Magelo Scraper  (Read 6188 times)
Kromagnome
Newbie
*
Posts: 6


View Profile
« on: June 26, 2013, 12:46:04 pm »

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.
Logged
Kromagnome
Newbie
*
Posts: 6


View Profile
« Reply #1 on: June 26, 2013, 12:52:56 pm »

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.  Wink
Logged
Danish
Full Member
***
Posts: 120


View Profile
« Reply #2 on: June 27, 2013, 07:03:32 am »

That looks really awesome.

It can be quite a hassle to keep track of what toon needs what armor. I'm sure a lot of new players will find this extremely useful.
Logged
Warbash
Hero Member
*****
Posts: 563


View Profile
« Reply #3 on: July 22, 2013, 02:27:36 am »

This is very handy! I am getting a few issues but it late and I am sure its my fault.

Looks like the import is placing in wrong cells etc.... ill have to check tomorrow.
Logged

Warbash and crew <Ancient Elites>
Kromagnome
Newbie
*
Posts: 6


View Profile
« Reply #4 on: July 23, 2013, 02:58:12 pm »

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.
Logged
Warbash
Hero Member
*****
Posts: 563


View Profile
« Reply #5 on: July 24, 2013, 08:36:53 pm »

Thanks for the offer, i think I do need help. So its importing the data weird, check out the attachments. Keep in mind I am using excel 2003 with the xmls addon to see new file types.
Logged

Warbash and crew <Ancient Elites>
Kromagnome
Newbie
*
Posts: 6


View Profile
« Reply #6 on: July 25, 2013, 10:22:52 am »

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.
Logged
Warbash
Hero Member
*****
Posts: 563


View Profile
« Reply #7 on: July 25, 2013, 10:38:13 am »

No worries, I got the HP Ac issue working by modifying the cells but its not working on the gear. I ordered office 2013 to see if that addresses the problem Smiley
Logged

Warbash and crew <Ancient Elites>
Warbash
Hero Member
*****
Posts: 563


View Profile
« Reply #8 on: July 25, 2013, 11:30:42 am »

Hi Kromagnome,
Installing Office 2013 fixed most of the issues. Just need to get RoA and UC to work. I see if I can play with it tomorrow.
Logged

Warbash and crew <Ancient Elites>
Kromagnome
Newbie
*
Posts: 6


View Profile
« Reply #9 on: July 25, 2013, 03:32:49 pm »

Awesome, good to hear man!
Logged
Pages: [1]
Print
Jump to:  

Recent

Stats

Members
Stats
  • Total Posts: 65024
  • Total Topics: 5058
  • Online Today: 105
  • Online Ever: 8678
  • (December 19, 2022, 02:32:09 pm)
Users Online
Users: 1
Guests: 76
Total: 77
TinyPortal v1.0 beta 4 © Bloc