Maintenance for the week of November 18:
• PC/Mac: No maintenance – November 18
• ESO Store and Account System for maintenance – November 19, 9:00AM EST (14:00 UTC) - 6:00PM EST (23:00 UTC)
• PlayStation®: EU megaserver for maintenance – November 19, 23:00 UTC (6:00PM EST) - November 20, 17:00 UTC (12:00PM EST)
https://forums.elderscrollsonline.com/en/discussion/668861

Enchanting Spreadsheet Help

Aelendil
Aelendil
✭✭
Can anyone see the error in the Armor and Jewelry formula's? I don't see why they don't work properly.
https://docs.google.com/spreadsheets/d/1E4kZa8VYLcH93ywVEixqeXc0RtDaFhAV6LxET-9VL08/edit#gid=465498898
Server: EU
Guild: Het Vreemdelingen Legioen
Account Name: @arieblom
Characters: Aelendil Lv50 Nightblade, Temael Lv50 Templar, Sorcael Lv50 Sorcerer, Wardael Lv50 Warden


  • CGPsaint
    CGPsaint
    ✭✭✭✭✭
    ✭✭
    Try inputting the sheet name as: 'Data'!H58:I66

    This will help Google Docs recognize that the data is actually on another page.
    Edited by CGPsaint on September 26, 2015 2:57PM
    "Some enjoy bringing grief to others. They remind M'aiq of mudcrabs—horrible creatures, with no redeeming qualities."
  • Sunburnt_Penguin
    Sunburnt_Penguin
    ✭✭✭✭✭
    I can "see" the error but I can't see what the formula error is and I don't think there's a way for me to view it.

    If you paste the formula in here I'll be able to sort it out for you.
  • Aelendil
    Aelendil
    ✭✭
    If you make a copy on your own account you should be able to see and edit everything sinces theres multiple formulas.
    Server: EU
    Guild: Het Vreemdelingen Legioen
    Account Name: @arieblom
    Characters: Aelendil Lv50 Nightblade, Temael Lv50 Templar, Sorcael Lv50 Sorcerer, Wardael Lv50 Warden


  • Sunburnt_Penguin
    Sunburnt_Penguin
    ✭✭✭✭✭
    @Aelendil

    Got it now, will have a look this evening.
  • Sunburnt_Penguin
    Sunburnt_Penguin
    ✭✭✭✭✭
    @Aelendil

    Okay, I think I've sorted it.

    F11 should be:
    =IF(ISERROR(D9),"Choose Enchant",IF(C11="Choose Level","Choose Level",IF(C11="Choose Status","Choose Status",IF(D13=0,"Choose Quality",IF(D13=1,VLOOKUP(C9,Data!$AA$5:$AV$40,MATCH(D11,Data!$AA$4:$AV$4,0),FALSE),IF(D13=2,VLOOKUP(C9,Data!$AA$44:$AV$79,MATCH(D11,Data!$AA$43:$AV$43,0),FALSE),IF(D13=3,VLOOKUP(C9,Data!$AA$83:$AV$118,MATCH(D11,Data!$AA$82:$AV$82,0),FALSE),IF(D13=4,VLOOKUP(C9,Data!$AA$122:$AV$157,MATCH(D11,Data!$AA$121:$AV$121,0),FALSE),IF(D13=5,VLOOKUP(C9,Data!$AA$161:$AV$196,MATCH(D11,Data!$AA$160:$AV$160,0),FALSE),"Err")))))))))

    D13 should be:
    =IF(ISERROR(MATCH(C13,Data!$I$51:$I$55,0)),0,MATCH(C13,Data!$I$51:$I$55,0))

    D31 should be:
    =IF(ISERROR(MATCH(C31,Data!$I$51:$I$55,0)),0,MATCH(C31,Data!$I$51:$I$55,0))


    I have no idea about enchanting so cannot confirm whether the figures it's producing are correct.

    Hope this helps and let me know if you need anything else
    Edited by Sunburnt_Penguin on September 28, 2015 9:53AM
  • Aelendil
    Aelendil
    ✭✭
    You're a lifesaver, it works now with all correct values.
    Server: EU
    Guild: Het Vreemdelingen Legioen
    Account Name: @arieblom
    Characters: Aelendil Lv50 Nightblade, Temael Lv50 Templar, Sorcael Lv50 Sorcerer, Wardael Lv50 Warden


  • Sunburnt_Penguin
    Sunburnt_Penguin
    ✭✭✭✭✭
    @Aelendil

    No worries, sometimes it just needs a second pair of eyes.
Sign In or Register to comment.