• You've discovered RedGuides, an EverQuest multi-boxing and scripting community 🧙‍♀️⚙️. We want you to play several EQ characters at once, come join us and say hello! 👋

  • A TLP without truebox has thawed (Very Vanilla ready)
    Frostreaver

Macro - Export 54 Toons to a Excel Friendly Spreadsheet

Joined
Jul 24, 2019
RedCents
24,072¢
I wanted to be able to Export all my toons gear at once, and then Slurp it into Excel so when I'm running 54 toons and something drops - I can see at a glance that Toon X needs that.

This is my First Macro and i have basically just butchered Gear.mac So KUDOS goes to Lemons and CWTN for the Original Gear Macro

How this works:
Load up all your toons then do a /bcaa //mac Gear2

It will Output Every toon to One File called GEAR.INI in your Macro Folder.

Gear.ini will look something like this:

INI:
[Gear]
ToonName1,266,6285,525,6650,346,6479,238,5807,314,6683,282,5901,504,6650,445,9212,394,6451,394,6451,294,6630,476,6517,257,6648,305,6280,333,6279,354,6696,814,6983,612,6850,471,6717,352,6905=
ToonName2,266,6285,525,6650,346,6479,238,5807,314,6683,282,5901,504,6650,445,9212,394,6451,394,6451,294,6630,476,6517,257,6648,305,6280,333,6279,354,6696,814,6983,612,6850,471,6717,352,6905=
ToonName3,266,6285,525,6650,346,6479,238,5807,314,6683,282,5901,504,6650,445,9212,394,6451,394,6451,294,6630,476,6517,257,6648,305,6280,333,6279,354,6696,814,6983,612,6850,471,6717,352,6905=
ToonName4,266,6285,525,6650,346,6479,238,5807,314,6683,282,5901,504,6650,445,9212,394,6451,394,6451,294,6630,476,6517,257,6648,305,6280,333,6279,354,6696,814,6983,612,6850,471,6717,352,6905=

You can then Import it into a Spreadsheet with relative ease.

Note:
I haven't bothered with Mana...Because who cares about Mana.
This is exporting the BASE AC,HP. It ignore Powersource, and Augs.
I will probably Add Augs because that is useful info - but ran out of time.
I will also upload the Spreadsheet when I have it finished if anyone is interested.

Btw: This is using the /ini to create the file. Its very easy, but it also adds the = on the end of the line.
Is there another method of Output that could be used?
 

Attachments

Macro - Export 54 Toons to a Excel Friendly Spreadsheet

Users who are viewing this thread

Back
Top
Cart