Page 2 of 2 FirstFirst 12
Results 21 to 35 of 35
  1. #21
    Community Member
    Join Date
    Oct 2009
    Posts
    192

    Default

    One thing I've noticed with crafting is that the "Offhand weapon/Shield" should be considered separately, despite how they're listed in DDO crafting.

    Some effects are off-hand but can't be used with a shield (and I'm pretty sure I saw an "off-hand" effect that couldn't be used with ranged ... can't remember what it was) and there are many effects that can be applied to a shield but not an off-hand weapon.
    Last edited by TimoteoDeLani; 06-21-2011 at 04:12 PM.

  2. #22

    Default

    Quote Originally Posted by TimoteoDeLani View Post
    Some effects are off-hand but can't be used with a shield (and I'm pretty sure I saw an "off-hand" effect that could be used with ranged ... can't remember what is was) and there are many effects that can be applied to a shield but not an off-hand weapon.
    When I went through all the recipes I tried to pay close attention to this, and I couldn't find a single shard that had one without the other.

  3. #23
    Community Member
    Join Date
    Oct 2009
    Posts
    192

    Default

    Edited my above message ... I meant off-hand but not ranged ...

    Do you mean you were looking at what the description said, or what it could actually be applied to? I don't have any shards or many essences available at the moment, but I'm sure I tried to apply some that said off-hand/shield to both, and it would not let me apply them to one or the other.

    Perhaps my understanding of off-hand weapon is incorrect. I'm assuming it means a weapon that equips to the off-hand slot e.g. a bow.

  4. #24
    Community Member RudeIota's Avatar
    Join Date
    Mar 2010
    Posts
    108

    Default

    Just checked it out. Fantastic work.

    May I suggest that each item slot (trinket, head, neck etc..) have its own column at the end with a mark of some sort indicating that it works in that slot. It would make it easier to sort and programmatically interpret the data in terms of finding the right property for the right slot.

  5. #25

    Default

    Quote Originally Posted by TimoteoDeLani View Post
    Do you mean you were looking at what the description said, or what it could actually be applied to? I don't have any shards or many essences available at the moment, but I'm sure I tried to apply some that said off-hand/shield to both, and it would not let me apply them to one or the other.

    Perhaps my understanding of off-hand weapon is incorrect. I'm assuming it means a weapon that equips to the off-hand slot e.g. a bow.
    What it could actually be applied to. The way I created the Crafting Recipes thread was to add a blank item to the last machine and then make a list of every shard that came up. For the main hand weapons I added a bastard sword (and later a warhammer to check bludgeon effects) and I paid close attention to the offhand weapon/shield category. No shards had one without the other. Then when I added a shield blank to the machine to create the shields list I paid close attention again, and again there was never one without the other. Wherever offhand weapon goes shield goes, and vice versa.

    An offhand weapon is any weapon that isn't two-handed.

  6. #26
    Community Member BoBo2020's Avatar
    Join Date
    Nov 2009
    Posts
    494

    Default Outstanding work

    This is great - thank you for your work on this.

    If possible, you may want to consider adding a column indicating whether the effect is a prefix or suffix.

    ...

  7. #27

    Default

    Quote Originally Posted by RudeIota View Post
    Just checked it out. Fantastic work.

    May I suggest that each item slot (trinket, head, neck etc..) have its own column at the end with a mark of some sort indicating that it works in that slot. It would make it easier to sort and programmatically interpret the data in terms of finding the right property for the right slot.
    In regards to the "each item slot" idea. The newer spreadsheet we are working on still uses the same comma separation, but includes some vb coding and drop downs that take advantage of that and allow you to see only those things that apply to the shard you are looking at. There are also a few other things that ideas that haven't been implemented yet. Damienvryce is doing an awesome job with that part of what the new one will do. We were going to release it today or tomorrow, but with the release of the new levels yesterday, we've had to make some adjustments. I have all the new data in as I'm typing this and I spoke with Damienvryce earlier and we think we will have a new file available by Friday.

    Also, to the person that requested the prefix/suffix identification. When I made this I intended to use it in Excel 2010 for myself. In that version, you can sort by cell shading, so yellow for prefix and green for suffix was all I needed. The new one, however, has textual representation for that, so it won't be an issue anymore.

    This new one will ONLY function via download if you want to use it to its fullest. Google docs won't run all the helpful macros and dropdowns online. I will probably end up posting a similar version to what is up though for those that are interested in a read only less interactive version.

    -Merrill

  8. #28

    Default New Single Sheet Updated

    I have posted a new sheet similar to the first that now includes items up to level 100 for both unbound and bound. You can find it here.


    https://spreadsheets.google.com/spre...hl=en_US#gid=0

  9. #29
    Community Member Crann's Avatar
    Join Date
    Oct 2009
    Location
    Ohio
    Posts
    1,813

    Default

    TY +1 for the great work.

    I had considered something like this, more from the standpoint of "here I made this item, with this preffix on it...now what suffix can I add?"

    That brought me to the conclusion that you needed sortable columns for every aspect of the shards, which it looks like you are well on your way to achieving. That's alot of work, thanks for tackling it.

  10. #30

    Default

    Quote Originally Posted by Crann View Post
    I had considered something like this, more from the standpoint of "here I made this item, with this preffix on it...now what suffix can I add?"

    That brought me to the conclusion that you needed sortable columns for every aspect of the shards, which it looks like you are well on your way to achieving. That's alot of work, thanks for tackling it.
    The Crafting Recipes by Gear thread linked in my signature is designed to answer those kinds of questions.

  11. #31
    The Hatchery danotmano1998's Avatar
    Join Date
    Dec 2010
    Location
    The rainy side of earth
    Posts
    4,199

    Default

    Very nice work!!

    +1 to the OP.
    <-Curelite Bottling Company->

    Quote Originally Posted by Chilldude
    Dude, did you see they way that guy just pressed button 1? It was amazing! A display of skill unseen since the 1984 World Games where in the men's room, between events, a man washed his hands with such unbridled majesty that people were claiming the faucet he used was OP.

  12. #32
    Community Member
    Join Date
    Jun 2010
    Location
    slovakia
    Posts
    11

    Default

    Quote Originally Posted by t0pazdrag0n View Post
    Just a suggestion but you might want to change so that the most relevent aspect of the shard's name comes first. For example, currently you have it as:

    Greater Corrosion I -> Corrosion I, Greater
    here i did it
    http://esge1.wz.cz/temp/CannithCraftingSingleSheet.xls

    didn't do the alphabetical sort though, i leave that for the creator
    "You can tell the size of a man by the size of the thing that makes him mad." - Adali Stevenson
    Esge - newbie rang on Ghallanda
    (ignore my forum join date, i started to play a year after that)

  13. #33

    Default

    Quote Originally Posted by Esgeyl View Post
    here i did it
    http://esge1.wz.cz/temp/CannithCraftingSingleSheet.xls

    didn't do the alphabetical sort though, i leave that for the creator
    The only problem with that, for me at least, is that when you alpha sort you end up with something like this...


    Name Level Potential
    Corrosion I, Greater Greater Corrosion I 12 1
    Corrosion I, Improved Improved Corrosion I 9 1
    Corrosion I, Superior Superior Corrosion I 19 2
    Corrosion II, Greater Greater Corrosion II 23 2
    Corrosion II, Improved Improved Corrosion II 14 1
    Corrosion II, Superior Superior Corrosion II 34 2
    Corrosion III, Greater Greater Corrosion III 38 2



    Which ends up grouping type, but giving you a kind of mismatch in terms of the level required to craft and potential level. I know that all the "Greater" stuff including banes etc get lumped the way it is now, but once you locate the "Ardor" types in that Greater section, you are looking at them from easiest to most difficult and from low to High Potential/ML.

    This sheet and even more so the sheet I'm working on currently are primarily meant to be downloaded because google docs doesn't do well for multiple viewers messing with the sort order. What I'll do is add this sheet in to the current one and have both forms up in one file and people can choose the sheet they prefer.

    Thanks for taking the time to make the edit.

    -Merrill




    Here is the link for that one. Second sheet has the resort on the edited shard name changes.

    https://spreadsheets.google.com/spre...thkey=CO-z_70M

    The single sheet was already a bit slow on my computer. I don't notice a difference in speed by adding the second full sheet.

    Again, DLing it and using it in Excel is recommended for those that can do so. It makes it a lot easier to navigate and make the most of.
    Last edited by Merrill_Greeneshade; 06-27-2011 at 04:18 PM.

  14. #34
    Community Member
    Join Date
    Jun 2010
    Location
    slovakia
    Posts
    11

    Default

    Quote Originally Posted by Merrill_Greeneshade View Post
    potential lvl mismatch
    yeah a agree there, i would suggest to double sort by name and bound lvl, but it doesn't work for me for some reason :/

    Quote Originally Posted by Merrill_Greeneshade View Post
    Thanks for taking the time to make the edit.
    np, a little formula did the editing for me
    "You can tell the size of a man by the size of the thing that makes him mad." - Adali Stevenson
    Esge - newbie rang on Ghallanda
    (ignore my forum join date, i started to play a year after that)

  15. #35

    Default New Spreadsheet up for those that are interested.

    Figured I'd post a reference here for those that are interested. A new and better spreadsheet is available for download. If you downloaded and enjoyed this one, I think you'll absolutely love the new one. Damienvryce from Cannith did an amazing job with the dropdowns and coding.

    http://forums.ddo.com/showthread.php...26#post3896426

Page 2 of 2 FirstFirst 12

Posting Permissions

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

This form's session has expired. You need to reload the page.

Reload