User talk:Colorin
From LSWiki
(Difference between revisions)
| Revision as of 20:11, 7 April 2019 (edit) Colorin (Talk | contribs) ← Previous diff |
Revision as of 20:23, 7 April 2019 (edit) Colorin (Talk | contribs) (→Spec Access Review) Next diff → |
||
| Line 10: | Line 10: | ||
| [https://docs.google.com/spreadsheets/d/1matjwf18d0VdwWibZe7StWj5TKdIaKJM7h91JxweOUs/edit?usp=sharing Spec Access Review Sheet - Screen Reader Version] - edit page to get link | [https://docs.google.com/spreadsheets/d/1matjwf18d0VdwWibZe7StWj5TKdIaKJM7h91JxweOUs/edit?usp=sharing Spec Access Review Sheet - Screen Reader Version] - edit page to get link | ||
| + | # Make a copy of the sheet to your own personal Google account, this will allow you to edit the sheets | ||
| # Do '''''show specialty access''''' and copy/paste entire list into '''''Pre-Load (Cleanup)''''' sheet, then delete any erroneous lines that are not skill related such as pauses, any OOC that snuck in, etc | # Do '''''show specialty access''''' and copy/paste entire list into '''''Pre-Load (Cleanup)''''' sheet, then delete any erroneous lines that are not skill related such as pauses, any OOC that snuck in, etc | ||
| # Make sure column A is empty in '''''Spec Before''''' sheet and paste show specialty access from '''''Pre-Load (Cleanup)''''' sheet into Cell A2 of '''''Spec Before''''' sheet | # Make sure column A is empty in '''''Spec Before''''' sheet and paste show specialty access from '''''Pre-Load (Cleanup)''''' sheet into Cell A2 of '''''Spec Before''''' sheet | ||
| # Leave/Join Guild or Assoc and then repeat steps 1 & 2, instead using '''''Spec After''''' sheet | # Leave/Join Guild or Assoc and then repeat steps 1 & 2, instead using '''''Spec After''''' sheet | ||
Revision as of 20:23, 7 April 2019
Google Sheets
I've created numerous Google Sheets over the years to help with managing and playing LS, some are spread throughout this wiki but I thought it'd be helpful to put them in once place. So enjoy!
IMPORTANT - For any links you'll need to edit this entry and copy/paste it, for some reason the Wiki isn't allowing a direct link out.
Spec Access Review
The purpose of this it allow the player to show what Spec Access they gained (or lost) when joining or leaving a Guild/Assoc. See steps below.
Spec Access Review Sheet - edit page to get link
Spec Access Review Sheet - Screen Reader Version - edit page to get link
- Make a copy of the sheet to your own personal Google account, this will allow you to edit the sheets
- Do show specialty access and copy/paste entire list into Pre-Load (Cleanup) sheet, then delete any erroneous lines that are not skill related such as pauses, any OOC that snuck in, etc
- Make sure column A is empty in Spec Before sheet and paste show specialty access from Pre-Load (Cleanup) sheet into Cell A2 of Spec Before sheet
- Leave/Join Guild or Assoc and then repeat steps 1 & 2, instead using Spec After sheet
