Page 1 of 2 12 LastLast
Results 1 to 25 of 41

Thread: Research Spreadsheet

  1. #1
    Contributor
    Join Date
    Sep 2003
    Posts
    64

    Wink Research Spreadsheet

    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 =)
    Attached Files Attached Files
    Last edited by Xorithra L`Amante; 09-02-2004 at 07:07 PM.

  2. #2
    Contributor
    Join Date
    Feb 2003
    Posts
    64
    Nice Work, thanks
    Salomea Sillverfrost
    Lvl 65 Arcanist
    CoV and Coldain Faction Maxed
    Flagged for entry to Planes of Air, Water, Earth and Fire

  3. #3
    Super Moderator Maevenniia's Avatar
    Join Date
    Dec 2002
    Posts
    2,752

    Thumbs up

    Wonderful, thank you!
    Master Artisan Maevenniia the Springy Sprocket Stockpiler of the really long name
    Silky Moderator Lady
    Beneath the silk, lies a will of steel.


  4. #4
    Contributor
    Join Date
    Dec 2002
    Posts
    35
    A quick and simple fix is on cell b3:

    =if(c3>0,"Yes","")
    (those are double quotes ("), not single quotes(').)

    and then just copy that all the way down till the next verison is ready.

    Thank you for all the work you put into this... Sorely needed it to help put guild inventory into perspective
    Ianthe - 65 Dread Lord
    Grizzor Faewalker - 65 Druid
    250 Baker, Brewer, Fletcher, Jeweler, Potter, and Tailor
    200 Fisher

  5. #5
    Artisan Lilosh's Avatar
    Join Date
    Dec 2002
    Posts
    3,104
    You Sir, Are greater than asterick.



    -Lilosh

  6. #6
    Contributor
    Join Date
    Sep 2003
    Posts
    64
    I'm sorry, Lilosh? Are you speaking to Ianthe or me? Either way, what do you mean? I have a theory but I'm not sure~

    Thank you, Ianthe, for your suggestion! No promises, but I'll probably get the final one uploaded by tonight (Hawaii evening anyway. Most of you should be sleeping). I believe I know what needs to be done, but it's usually a matter of testing.



    Xorithra L`Amante
    Last edited by Xorithra L`Amante; 09-18-2003 at 08:02 PM.

  7. #7
    Artisan Lilosh's Avatar
    Join Date
    Dec 2002
    Posts
    3,104
    I was speaking to you.

    This spreadsheet is GOLDEN.


    -Lilosh

  8. #8
    Contributor
    Join Date
    Sep 2003
    Posts
    64
    Just wanted to thank everyone for their postive input! Very pleased to find that it is useful for some out there!

    Thanks again!

    Xorithra L`Amante

  9. #9
    Visitor Zargonn's Avatar
    Join Date
    Sep 2003
    Posts
    2
    This is GREAT and makes it sooo much easier!

    Thanks,
    Zargonn

    LVL 65 Arcanist


  10. #10
    Visitor
    Join Date
    Oct 2003
    Posts
    1

    Love the spreadsheet...

    But I am currently only level 27.

    Do you have one for lower level research pages or know if one exists somewhere?

    Thanks for you hard work.
    Az

  11. #11
    Contributor
    Join Date
    Sep 2003
    Posts
    64

    About another spreadsheet...

    Hi there everyone!

    Glad to see it's getting so many downloads.

    In reply to Az's request, I'm afraid I can't do it. There is a lot of potential for tradeskills with this sheet because it's in a format that could be used for ANYTHING. Inventory on the first, actual list of ingredients on the second, and combines on the third... the problem is that since EQtraders changed their format, it's not easy to copy and paste the information for the second sheet any longer.

    As most of you probably can remember, the former format was columns with final combine, then component 1, 2, 3 and so on. Now, it is final combine in one cell, components in another cell, with much more information. Beautiful for the site, but unfortunately the idea of the spreadsheet came a little too late. The only reason I was able to do it was because I had copied the old format info into a document a long time ago for my own tracking.

    So... if any of you out there also have acurate old formatting, feel free to use the formulas and format of this spreadsheet. Could be altered a little bit for tailoring... like how many pelts you have, then how many bonings, studs and the like you'd need... anyhow I'm rambling! Just throwing ideas in the air. If you do use the format and formulas of this spreadsheet, please be so kind to mention that you got it from Xorithra L`Amante

    Enjoy, and I'm sorry I can't bust any more out. If someone does have the old format with correct components (any skill, not just research), upload it onto this string and myself (when this semester is over, or I have more time) or anyone else who knows how can work with it.

    Xorithra L`Amante

  12. #12
    Visitor
    Join Date
    Dec 2002
    Posts
    34
    Blessing of Aegolism shows it requires 2 Yaeth 26 left pages. I believe this should be a left and a right.
    Shaman of War
    65 Bashes
    Code of Silence, Luclin

  13. #13
    Contributor
    Join Date
    Sep 2003
    Posts
    64

    BoA

    Thanks, Graal. I modified the first post (A Correction Section with instructions for the transition for those that would like help) and uploaded the updated file.

    Xorithra L`Amante

  14. #14
    Hobbyist
    Join Date
    Dec 2002
    Posts
    88
    Someday, when I get time, I plan on doing something like this in .php scripts and data stored in database tables (mySQL, etc.) with files for most people that will display individual items in the database alone with spells that can be generated from them, and another set of files for "Component Administrators" that can add new components, remove components (either individually and/or by stating you've made a spell to remove a component of each, etc.)

    Has anyone done something like this yet so I don't have to reinvent the wheel? Or is this something all new?



  15. #15
    Contributor
    Join Date
    Sep 2003
    Posts
    64
    My boyfriend was thinking about making an executable through Access that was much like this so that it would not require people to have Excel to use it. I'm afraid he is too swamped for it though.

    Sounds like you're our winner! Awesome of you to think of it.

    Xorithra L`Amante

  16. #16

    thanks Xorithra

    thanks for putting this sheet together, Xorithra. You've made my life as my guild's main researcher bearable!

  17. #17
    Apprentice Trader
    Join Date
    Dec 2002
    Posts
    283
    WOW Thanks! I've been dreading research inventory for months, but with this worksheet i'm (almost) looking forward to it!


    Falcon’s Pride @ The Nameless



    Destiny of the Free @ the Oasis

  18. #18
    Visitor
    Join Date
    Nov 2003
    Posts
    11
    This is an EXCELENT guide for tracking and seeing what goes with what.

    I have been compiling a similar listing, but you took it that one extra step and linked all the components with the corresponding spells!!!!

    This will be great for organizing my mules (yes I have one for each type: Runes, Words, Pages, and Misc items/trade skill) for use for my GF (65 Necro) to get her research up!!
    Alhtough not an advocate for selling spells, this will be a great way for her to make some side money, and get the spells into the needed hands of serveral characters at a cheap rate (because she will definately undercut all others to help bring the spell cost market down just a bit).

    VIVE LE umm..... Vive le errr.... hrm....
    HoverCraaft -- BavekStabaholic -- WebbFeet
    "Well ya see, Norm, it's like this... A herd of buffalo can only move as fast as the slowest buffalo. And when the herd is hunted, it is the slowest and weakest ones at the back that are killed first. This natural selection is good for the herd as a whole, because the general speed and health of the whole group keeps improving by the regular killing of the weakest members.
    In much the same way, the human brain can only operate as fast as the slowest brain cells. Excessive intake of alcohol, as we know, kills brain cells. But naturally, it attacks the slowest and weakest brain cells first. In this way, regular consumption of beer eliminates the weaker brain cells, making the brain a faster and more efficient machine. That's why you always feel smarter after a few beers."
    -Cliff Clavin (Cheers)

  19. #19
    Apprentice Trader Melinia's Avatar
    Join Date
    Aug 2003
    Posts
    183
    OMG! Wow! Nice work! That's Alot of work! I tried playing around making a sheet but gave up after I went cross eyed!
    Researches thank you!

    /Melinia bows before you.

    Happy Holidays!
    Duchess Melinia Spellteaser of Vazaelle
    "Old World Travelers"
    Tradeskills:
    GM Baker 300 + Trophy GM Brewing 12/18/04
    Fletching 146 Smithing 110
    Jewel Crafting 175 Pottery 175
    Research 155 Tailoring 83
    Fishing 185

  20. #20
    Contributor
    Join Date
    Sep 2003
    Posts
    64
    Hello Everyone!

    I haven't posted on this thread for a while and didn't want anyone to think that I wasn't paying attention any longer. I REALLY appreciate everyone's feedback and it's gratifying to hear that people are enjoying it.

    Also, Prach emailed me personally about a modification for the sheet. Through conditinal formatting, Prach came up with a way to highlight components in the "Spells" sheet to show which ones you had (and thus visually showing you how close you are to making a spell) and if you have all the components, it highlights the spell.

    It's an awesome modification, but I've been so busy with work and class I haven't had the time to go through it and make the necessary modifications so I could post it up. It's coming soon though! This week is finals week.

    I suggested to Prach to just post it up on this thread, but he (or she?) didn't want to impose. What a gem

    Check back in a week or so and the new sheet should be posted.

    Xorithra L`Amante

  21. #21
    Apprentice Trader Melinia's Avatar
    Join Date
    Aug 2003
    Posts
    183
    Not sure if someone has mentioned this before but..

    For those without Excel... You can download a program from the Microsoft website that will allow you to View Excel spreadsheets. I was able to download it *Free*.


    Edit (Melinia): Here is the link for the download from Microsoft
    http://www.microsoft.com/downloads/d...displaylang=EN

    I hope it works!

    Happy Holidays!
    Last edited by Melinia; 12-22-2003 at 07:16 PM.
    Duchess Melinia Spellteaser of Vazaelle
    "Old World Travelers"
    Tradeskills:
    GM Baker 300 + Trophy GM Brewing 12/18/04
    Fletching 146 Smithing 110
    Jewel Crafting 175 Pottery 175
    Research 155 Tailoring 83
    Fishing 185

  22. #22
    Visitor
    Join Date
    Jan 2004
    Posts
    1
    Or, if you want to view and edit Excel spreadsheets for free, download Open Office

    http://www.openoffice.org

    It's a big download (70Mb), but it's a complete office-type suite, developed with the Open-source community...

  23. #23
    Contributor
    Join Date
    Sep 2003
    Posts
    64

    Obsolete!

    Hello Everyone!

    So I've been bad. The holidays have come and gone and I still didn't have time to upload the conditional formatting change...

    But, if you were to look at the OTHER sticky in the forum, you would see a very nice program that also allows you to keep track of prices. The only bad thing about it is that you are not able to view all your spells, therefore skimming through wouldn't be easy. The programmer seems to be happy with suggestions though, so who knows, maybe even that wouldn't be an issue!

    I'm pretty lazy myself, so I've asked my boyfriend to program something that would parse a character magelo file and let me view all the spells I can make and components and all that jazz that the spreadsheet allows you to do without having to manually input numbers~ (He doesn't want to write it for public view though... only way I could get him to do it was to promise it was just for my use).

    Anyhow, if anyone DOES use the spreadsheet and would want me to go ahead and upload the conditional formatting, I will. I just don't want to if no one will use it. The other program is pretty awesome, and I would use it if it weren't for my boyfriend

    Those who are interested in the LoY Matrix, here is a link to the post -- http://mboards.eqtraders.com/upload/...hreadid=12215, and you can also find the site to download the program!

    Thanks for all your support!
    Xorithra L`Amante

  24. #24
    Visitor
    Join Date
    Dec 2002
    Posts
    40

    good job !

    That is a fine piece of work. Congratulations.

    I too have created a spreadsheet for high level research, but it does not actually contain inventory columns. Mine is strictly like this:

    Column 1: every ingredient (sometimes duplicated because some classes use it for more than 1 spell)
    Columns 2-8: each class.
    The 'meat' of the spreadsheet says what each ingredient is for in this format: "53, Scent of Terris" which is in the necro column.

    On top of each column I put pull down arrows; you can pull down the class arrow to the spell you want, and see what ingredients you need from column A (the ingredients column);
    OR you can pull down the arrow in the ingredients column to see what spell(s) it is used for.

    I also created separate tabs just for each class, incase I gave this to someone who didn't know how to use pull down arrows.

    If anyone wants to see mine, send me a message and I will send it along to you...

    Windru Peacekeaper, CT server
    Bofor Shinystone, CT server, 199 research

  25. #25
    Contributor
    Join Date
    Sep 2003
    Posts
    64
    Why wouldn't we want to see it? Feel free to use this thread, or start another =) The more that's out there, the more options people have.

    Xorithra L`Amante

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •