User talk:Colorin
From LSWiki
(Difference between revisions)
Revision as of 19:09, 7 April 2019 (edit) Colorin (Talk | contribs) ← Previous diff |
Revision as of 19:11, 7 April 2019 (edit) Colorin (Talk | contribs) Next diff → |
||
Line 1: | Line 1: | ||
= Google Sheets = | = 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! | 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== | ==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. | 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. | ||
- | [https://docs.google.com/spreadsheets/d/11YvuPOZZT--9pXvs1_DWEa00dhYhf221K1iGh8nwVMk/edit?usp=sharing Spec Access Review Sheet] | + | [https://docs.google.com/spreadsheets/d/11YvuPOZZT--9pXvs1_DWEa00dhYhf221K1iGh8nwVMk/edit?usp=sharing Spec Access Review Sheet] - edit page to get link |
- | [https://docs.google.com/spreadsheets/d/1matjwf18d0VdwWibZe7StWj5TKdIaKJM7h91JxweOUs/edit?usp=sharing Spec Access Review Sheet - Screen Reader Version] | + | [https://docs.google.com/spreadsheets/d/1matjwf18d0VdwWibZe7StWj5TKdIaKJM7h91JxweOUs/edit?usp=sharing Spec Access Review Sheet - Screen Reader Version] - edit page to get link |
# 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 19:11, 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
- 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