Account
Merchandise
en
en-gb
de
fr
es
ru
The Elder Scrolls Online
Home
Game Guide
Story
The Alliance War
Alliances
Daggerfall Covenant
Ebonheart Pact
Aldmeri Dominion
Interactive Map
Adventure Zones
Craglorn
Media
All
Videos
Concept Art
Screenshots
Wallpapers
Extras
Malukah
News
View all news
Announcements
Art / Media
Patch Notes
Community Programs
Development
Press / Buzz
Awards
DLC
Forum
Support
Buy Now!
Home
Forums
English
Crafting
Dev Tracker
Categories
Recent
Unanswered
Sign In
Go
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/
Enchanting Spreadsheet Help
Leave a Reply
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
#1
September 2015
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:57PM
"Some enjoy bringing grief to others. They remind M'aiq of mudcrabs—horrible creatures, with no redeeming qualities."
#2
September 2015
0
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.
@Sunburnt_Penguin
#3
September 2015
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 Warden
#4
September 2015
0
Sunburnt_Penguin
✭✭✭✭✭
@Aelendil
Got it now, will have a look this evening.
@Sunburnt_Penguin
#5
September 2015
0
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
@Sunburnt_Penguin
#6
September 2015
1
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
#7
September 2015
0
Sunburnt_Penguin
✭✭✭✭✭
@Aelendil
No worries, sometimes it just needs a second pair of eyes.
@Sunburnt_Penguin
#8
September 2015
0
Home
Forums
English
Crafting
Sign In
or
Register
to comment.