The Gold Road Chapter – which includes the Scribing system – and Update 42 is now available to test on the PTS! You can read the latest patch notes here: https://forums.elderscrollsonline.com/en/discussion/656454/
Maintenance for the week of April 15:
• [COMPLETE] ESO Store and Account System for maintenance – April 16, 8:00AM EDT (12:00 UTC) - 6:00PM EDT (22:00 UTC)
• [COMPLETE] ESO Store and Account System for maintenance – April 16, 8:00AM EDT (12:00 UTC) - 6:00PM EDT (22:00 UTC)
Enchanting Spreadsheet Help
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
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
Guild: Het Vreemdelingen Legioen
Account Name: @arieblom
Characters: Aelendil Lv50 Nightblade, Temael Lv50 Templar, Sorcael Lv50 Sorcerer, Wardael Lv50 Warden
0
-
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:57PM0 -
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.0 -
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 Warden0 -
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 elseEdited by Sunburnt_Penguin on September 28, 2015 9:53AM1