Silverstein's *Nearly* Automated Profession Spreadsheets!

[Silverstein]

Do you like using spreadsheets, but hate having to insert the data by hand?

I have the perfect solution!

It's quite a simple process using a Microsoft Excel file, and http://theunderminejournal.com/

The file includes:
- Instructions
- Locations for the Scrolls
- Cost of prices on the AH (Server specific!)
- And the most important thing: GOLD EARNED!!

(Note: v1 only has the Enchanting Scrolls version, but I will be making more.. prioritizing requests over whatever I pick next!)

Credit to: maroz for starting this first one. I just used TheUndermineJournal to make it easier and quicker.\
(Original thread: Here (Enchanting (Scrolls) Spreadsheet)

Download Links

Profession Spreadsheetsv2.rar

Troubles? Try this!

So for everybody who had problems because of the instructions, and didn't know what to do, after you click "From Text", and you choose the file, leave the first the way it is, and click "Next". However, on the second window, you have to select the 3rd option (comma) in addition to what has been already selected, and just click Finish, and you should be done.

[Steffenftw]

Invalid Attachment specified. If you followed a valid link, please notify the administrator

I can't seem to download this.

[imafish2004]

Invalid Attachment specified. If you followed a valid link, please notify the administrator

I can't seem to download this.

Attachment is still pending moderator approval by the looks. Can't wait to have a nosey

[Steffenftw]

Ok, downloaded it.
At the same time I downloaded it I heard a loud "BEEP BEEP BEEP" alarm sound, as it were a virus. I found it it were just my rare mob detecter!

EDIT:
What do I do with the excel file after I've imported the text? It's just filled with this now:

A-Sylvanas,23519,"Felsteel Helm",7000000,0,7689655,967451,3592000,"2012-08-03T10:16:29+02:00"
A-Sylvanas,24032,"Subtle Dawnstone",150000,2,415293,216888,35000,"2012-08-05T01:56:29+02:00"
A-Sylvanas,24033,"Solid Star of Elune",150000,0,136000,15492,234000,"2012-08-04T03:46:29+02:00"
A-Sylvanas,38,"Recruit's Shirt",50000,0,,,,"2012-06-16T08:26:29+02:00"
A-Sylvanas,5976,"Guild Tabard",90000,0,940161,886401,,"2012-08-04T20:06:29+02:00"
A-Sylvanas,24036,"Flashing Living Ruby",100000,0,,,149500,"2012-01-17T09:20:40+01:00"
A-Sylvanas,32756,"Gyro-Balanced Khorium Destroyer",39990000,0,,,25264653,"2012-07-19T19:06:29+02:00"
A-Sylvanas,23108,"Timeless Shadow Draenite",149000,15,86498,88042,1750000,"2012-08-05T01:56:29+02:00"
A-Sylvanas,23103,"Radiant Deep Peridot",5050,1,91093,52757,149474,"2012-08-05T01:56:29+02:00"
A-Sylvanas,21871,"Frozen Shadoweave Robe",49999999,0,49999999,0,29398602,"2012-08-04T20:06:29+02:00"
A-Sylvanas,23114,"Smooth Golden Draenite",7500,0,7500,0,126583,"2012-08-01T17:26:29+02:00"

[Silverstein]

Just simply follow the instructions in the first tab.

[Steffenftw]

Ah there's more tabs! I didn't see that!

The document is just filled with a lot of #I/T's and there's no instructions on how to fix this.

[Silverstein]

Unless there's a request I believe there'll be a blacksmithing one next.

[Steffenftw]

Could you please help me with the #I/T's?...
The instructions doesn't say anything.

[Silverstein]

The instructions didn't say anything at all? What are you using to view the file? Did you download the right link at TUJ (CSV)? And did you make sure to insert the contents into cell A1?

[Zomtorg]

So for everybody who had problems because of the instructions, and didn't know what to do, after you click "From Text", and you choose the file, leave the first window the way it is, and click "Next". However, on the second window, you have to select the 3rd option (comma) in addition to what has been already selected, and just click Finish, and you should be done.

[Silverstein]

So for everybody who had problems because of the instructions, and didn't know what to do, after you click "From Text", and you choose the file, leave the first the way it is, and click "Next". However, on the second window, you have to select the 3rd option (comma) in addition to what has been already selected, and just click Finish, and you should be done.

Ohh forgot to add that. Thanks

[Steffenftw]

So for everybody who had problems because of the instructions, and didn't know what to do, after you click "From Text", and you choose the file, leave the first window the way it is, and click "Next". However, on the second window, you have to select the 3rd option (comma) in addition to what has been already selected, and just click Finish, and you should be done.

That fixed everything, thank you

[Silverstein]

Update! Added Blacksmithing to v2!

[coldbauer]

Invalid Attachment specified. If you followed a valid link, please notify the administrator

cant download

[Silverstein]

Give it a lil bit.. gotta be approved by mod still.. Just uploaded a new version