ABCDE
1
2
Welcome to my AP Tracker Template! Here you'll find a quick guide to everything you'll need to know to get started using the template for yourself.
3
4
Features:Upload art Directly to the tracker, no lost AP from deleted deviations or eaten stash entries!
5
Helpful (?) section for AP counter use
6
Automatic SUM of final AP count!
7
8
First, Create a Copy of this sheet for your own use!File > Make a copy...
9
To add images, simply go to Insert > Image > Image in cell
10
This adds an image that will size to the cell. Adjust width as needed!
11
Fill in your totals below your images in the AP tracker as normal! I suggest only one bonus per line
12
Example totals entered- the only section that fills automatically is cel A22, the rest of the math is your own!Cel A22 is the sum of row 21!
13
Just keep adding Columns to add more art! Make a new tab after counts to act as a divider!
14
15
To add new AP tracker tabs to the sheet: Right Click the AP Tracker Blank and select "Duplicate"Double click to Rename the tab!
16
To protect your new sheet: Right click the tab you wish to protect. Select "Protect sheet..."
17
From the new menu, select "Except Certain Cells" and enter or select the area you want to ALLOW people to edit!24:30 is the editable range on this sheet
18
"Set Permissions" and accept to save!
19
20
These steps will ensure that users the sheet is shared with can only edit the Guest area of the sheet!
21
If this feature does not interest you, delete it from your Blank Template!
22