A | B | C | D | E | |
---|---|---|---|---|---|
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 |