LDoN Gear/Aug spreadsheet
Posted: Sat Mar 24, 2018 12:08 am
http://s000.tinyupload.com/index.php?fi ... 3436146062
**info from cardplace ldon script... some errors likely, some stats may be based on level above 65 from live, syntax errors from that site, and any possible typeing errors on my end. the given data in the tables isn't meant to be a one-size fits all... copy paste anythign you want into them.
Armor per type
Augs 1,2,3 covered -- possibly missing Charisma related augs.
limited type 4 and 6 augs listed. easy enough to look those up per weapon and proc. listed at end of Type 2 and Type 3 worksheets, respectively.
not the same spreadsheet from aug thread. that spreadsheet was for a server that removed lore tags from the augs. it wasn't very useful for this server beyond organized by armor type, names of the items, and vendors.
input current stats per character (highlighted yelow - with buffs if you want to use them instead of wasting them). input Max values for each stat. (305/355 for PoP AAs). if oyu don't want the 305/355 caps, adjust those too. imo, you'll get there eventually, so might as well plan for it.
simply copy paste any aug below the class tables on "Type 1,2,3" worksheets to update Totals worksheet. it will add up all the stats in those tables and subtract from the max listed for that stat.
there's 5 or 6 tables, but you only need one. copy paste table below the rest, and it should "add" more - do the same for all 4 worksheets. formulas will adjust to new location. you can add rows within any table, and no problems with the formulas. as long as they are in the same order, they will match up - use same format and spacing between tables. so if you add "Enchanter" table at the end, make sure corresponding tables on "type 1,2 and 3" are all at the end with same # of tables total. (you could insert enough rows and put anywhere, but again, more complicated to ensure formulas maintain integrity - if unsure, simply check the Totals worksheet and see if formulas match up to correct cell location -- if one adjusted, they all have. if one is wrong, the rest of them are wrong too)
You could chop this down to just 1 template and re-use and save per character. no matter what you type into the tables, it will add them up and subtract from Max. Base stats + buffs per toon still needed to calculate accurately.
Not limited to LDoN, but no other items included below the tables to copy/paste name/stats. you'll have to pretend type 1 is type x,y,z etc... add a spreadsheet if you have more than 3 types of augs. insert another subtotal row for that new "type" worksheet on the Totals worksheet.
with 20 items and even just 1 aug each, let alone 3 each, it's easy to waste by going over a stat cap when you could use a different aug and actually gain something rather than nothing from it.
**info from cardplace ldon script... some errors likely, some stats may be based on level above 65 from live, syntax errors from that site, and any possible typeing errors on my end. the given data in the tables isn't meant to be a one-size fits all... copy paste anythign you want into them.
Armor per type
Augs 1,2,3 covered -- possibly missing Charisma related augs.
limited type 4 and 6 augs listed. easy enough to look those up per weapon and proc. listed at end of Type 2 and Type 3 worksheets, respectively.
not the same spreadsheet from aug thread. that spreadsheet was for a server that removed lore tags from the augs. it wasn't very useful for this server beyond organized by armor type, names of the items, and vendors.
input current stats per character (highlighted yelow - with buffs if you want to use them instead of wasting them). input Max values for each stat. (305/355 for PoP AAs). if oyu don't want the 305/355 caps, adjust those too. imo, you'll get there eventually, so might as well plan for it.
simply copy paste any aug below the class tables on "Type 1,2,3" worksheets to update Totals worksheet. it will add up all the stats in those tables and subtract from the max listed for that stat.
there's 5 or 6 tables, but you only need one. copy paste table below the rest, and it should "add" more - do the same for all 4 worksheets. formulas will adjust to new location. you can add rows within any table, and no problems with the formulas. as long as they are in the same order, they will match up - use same format and spacing between tables. so if you add "Enchanter" table at the end, make sure corresponding tables on "type 1,2 and 3" are all at the end with same # of tables total. (you could insert enough rows and put anywhere, but again, more complicated to ensure formulas maintain integrity - if unsure, simply check the Totals worksheet and see if formulas match up to correct cell location -- if one adjusted, they all have. if one is wrong, the rest of them are wrong too)
You could chop this down to just 1 template and re-use and save per character. no matter what you type into the tables, it will add them up and subtract from Max. Base stats + buffs per toon still needed to calculate accurately.
Not limited to LDoN, but no other items included below the tables to copy/paste name/stats. you'll have to pretend type 1 is type x,y,z etc... add a spreadsheet if you have more than 3 types of augs. insert another subtotal row for that new "type" worksheet on the Totals worksheet.
with 20 items and even just 1 aug each, let alone 3 each, it's easy to waste by going over a stat cap when you could use a different aug and actually gain something rather than nothing from it.