Hello!
Are you a research component packrat? If so, this might help you out. I created a spreadsheet that can be used to keep track of what spells and how many of that spell you can make with the resources you have available. All you have to do is an inventory of which components you have and how many, and it will tell you what you can make.
I'm uploading it here for your use. I play two characters with my boyfriend who also plays two. We make a great team and typically, unless friends wish to join us, all the loot goes to our cause =) I hate selling useful things like components or tradeskill items because I'm a big fan of tradeskills. Therefore, I found the task of sorting through all those 16 bags of components to figure out what we could make intimidating. I found creating this spreadsheet more interesting so I'll never have to think that hard again
I hope it proves to be a useful tool for at least some of you out there! Please post any questions or comments about the spreadsheet on this thread, whether it be complaints or compliments. Most definitely, mention anything inaccuracies you might have noticed.
Thanks ahead for the feedback! Good luck fellow artisans!
Sincerely,
Xorithra L`Amante
65 Cleric of The Nameless
Grandmaster Jeweller
Grandmaster Brewer
Grandmaster Baker
Grandmaster Potter
Grandmaster Smith
Blessed Coldain Prayer Shawl Survivor
aka
Zeryl Stolhit
65 Enchanter of The Nameless
Grandmaster Potter
Blessed Coldain Prayer Shawl Survivor
Revision:
Hello! My wonderful boyfriend fixed that horrible "Want to update links?" problem that I accidentally incorporated into the sheet. Here it is without that irritating question.
Also, I can eliminate the "Yes" column in the spreadsheet, so all you do is input the numbers. I had promised to post it last night though, so I somewhat rushed trying to make it user friendly for anyone else but me =) When I originally created it, I didn't care about knowing how many I could make. Only when I decided to make it available did that option occur to me. Now, the Yes column isn't really needed, so I'll revamp it and post it within a few days. Those who already downloaded it will just need to copy "Amount" column and paste into the new spreadsheet.
So, here is the revised sheet that wont pop up that links question, the next (and hopefully last) one will come soon!
(If you've already entered data and don't want to download the new spreadsheet, simply unprotect the "Makeable" sheet and changed cell A2 to =Spells!A1 )
FINAL Revision:
Hello again! Here is the final spreadsheet, changed so you have to do is input amounts. Kept the YES column on the "Makeable" sheet because I think it draws your eye more to those spells.
But yes, this has eliminated the "Availablity" column in the "Components" sheet. For those who have the first (or second) spreadsheet, you should just be able to copy and paste the "Amount" column (minus the title).
Funny thing is, took two minutes to change it, and 20 to fill out out for my personal use~ Have to admit though, knowing how much is incredibly helpful (original only had the "Makeable" column).
Have fun!
Correction: Graal pointed out two lefts for BoA instead of a left and a right. A quick check in the eqtraders database shows left and right (whereas I took the info from eqtraders shortly after LoY came out, and there were a couple uncertainties on recipes). It is changed and once again uploaded here.
For those who don't wish to mess with Excel:
*Download the sheet (making sure it will not overwrite yours. Hopefully you renamed it ;P).
*Open up old and new.
*Highlight cells B3:B173 in your old "Amount" column in the "Components" sheet, copy.
*Select B3 in the "Components" sheet of the new file and paste.
*Save new.
*Close old and delete old.
*Eat a cookie or do a little dance to the wonders of copy and paste.
*Don't forget to rename new to something happier. Bob, for example.
For those who just like to mess:
*Unprotect the "Components" and "Spells" sheets. (Tools --> Protection --> Unprotect Sheet)
*In cell C20 of the "Components" sheet, add "blessing of aegolism (C60)" before KEI if you want to be consistent.
*In cell E30 of the "Spells" sheet, change 'Left' to 'Right'.
*Be a safe and reprotect the "Components" and "Spell" sheets.
*Eat a cookie or do a little dance to the wonders of me staying up too late to type out instructions that you didn't need.
For those that don't have it and will download for the first time:
No worries! Hope you enjoy.
Thanks for pointing it out Graal!
Keep the comments coming =)
Are you a research component packrat? If so, this might help you out. I created a spreadsheet that can be used to keep track of what spells and how many of that spell you can make with the resources you have available. All you have to do is an inventory of which components you have and how many, and it will tell you what you can make.
I'm uploading it here for your use. I play two characters with my boyfriend who also plays two. We make a great team and typically, unless friends wish to join us, all the loot goes to our cause =) I hate selling useful things like components or tradeskill items because I'm a big fan of tradeskills. Therefore, I found the task of sorting through all those 16 bags of components to figure out what we could make intimidating. I found creating this spreadsheet more interesting so I'll never have to think that hard again
I hope it proves to be a useful tool for at least some of you out there! Please post any questions or comments about the spreadsheet on this thread, whether it be complaints or compliments. Most definitely, mention anything inaccuracies you might have noticed.
Thanks ahead for the feedback! Good luck fellow artisans!
Sincerely,
Xorithra L`Amante
65 Cleric of The Nameless
Grandmaster Jeweller
Grandmaster Brewer
Grandmaster Baker
Grandmaster Potter
Grandmaster Smith
Blessed Coldain Prayer Shawl Survivor
aka
Zeryl Stolhit
65 Enchanter of The Nameless
Grandmaster Potter
Blessed Coldain Prayer Shawl Survivor
Revision:
Hello! My wonderful boyfriend fixed that horrible "Want to update links?" problem that I accidentally incorporated into the sheet. Here it is without that irritating question.
Also, I can eliminate the "Yes" column in the spreadsheet, so all you do is input the numbers. I had promised to post it last night though, so I somewhat rushed trying to make it user friendly for anyone else but me =) When I originally created it, I didn't care about knowing how many I could make. Only when I decided to make it available did that option occur to me. Now, the Yes column isn't really needed, so I'll revamp it and post it within a few days. Those who already downloaded it will just need to copy "Amount" column and paste into the new spreadsheet.
So, here is the revised sheet that wont pop up that links question, the next (and hopefully last) one will come soon!
(If you've already entered data and don't want to download the new spreadsheet, simply unprotect the "Makeable" sheet and changed cell A2 to =Spells!A1 )
FINAL Revision:
Hello again! Here is the final spreadsheet, changed so you have to do is input amounts. Kept the YES column on the "Makeable" sheet because I think it draws your eye more to those spells.
But yes, this has eliminated the "Availablity" column in the "Components" sheet. For those who have the first (or second) spreadsheet, you should just be able to copy and paste the "Amount" column (minus the title).
Funny thing is, took two minutes to change it, and 20 to fill out out for my personal use~ Have to admit though, knowing how much is incredibly helpful (original only had the "Makeable" column).
Have fun!
Correction: Graal pointed out two lefts for BoA instead of a left and a right. A quick check in the eqtraders database shows left and right (whereas I took the info from eqtraders shortly after LoY came out, and there were a couple uncertainties on recipes). It is changed and once again uploaded here.
For those who don't wish to mess with Excel:
*Download the sheet (making sure it will not overwrite yours. Hopefully you renamed it ;P).
*Open up old and new.
*Highlight cells B3:B173 in your old "Amount" column in the "Components" sheet, copy.
*Select B3 in the "Components" sheet of the new file and paste.
*Save new.
*Close old and delete old.
*Eat a cookie or do a little dance to the wonders of copy and paste.
*Don't forget to rename new to something happier. Bob, for example.
For those who just like to mess:
*Unprotect the "Components" and "Spells" sheets. (Tools --> Protection --> Unprotect Sheet)
*In cell C20 of the "Components" sheet, add "blessing of aegolism (C60)" before KEI if you want to be consistent.
*In cell E30 of the "Spells" sheet, change 'Left' to 'Right'.
*Be a safe and reprotect the "Components" and "Spell" sheets.
*Eat a cookie or do a little dance to the wonders of me staying up too late to type out instructions that you didn't need.
For those that don't have it and will download for the first time:
No worries! Hope you enjoy.
Thanks for pointing it out Graal!
Keep the comments coming =)
Comment