A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | How To Use: | v.1.30 | ||||||||||
2 | Here you can use The Collection spreadsheet to curate your S.H.MonsterArts collection! | |||||||||||
3 | You can use this to track what you own, what you are looking for, and if you have anything for sale. | |||||||||||
4 | NOTE: Some instructions include animated GIF for mobile users. These may not play on all devices. | |||||||||||
5 | ||||||||||||
6 | Setup: | |||||||||||
7 | 1. [For Computer] Go to "File" and select "MAKE A COPY" (Figure A). | |||||||||||
8 | [For Mobile] Tap on the elipses in the top right corner and tap "SHARE & EXPORT" and then tap "MAKE A COPY" (Figure B). | |||||||||||
9 | IMPORTANT: You CAN NOT edit the master template, this is why you need to make a copy first which will enable editing. | |||||||||||
10 | Figure A | |||||||||||
11 | ||||||||||||
12 | Figure B (Animated GIF) | |||||||||||
13 | ||||||||||||
14 | Click here if animated GIF isn't playing on your device. | |||||||||||
15 | ||||||||||||
16 | 2. There are 4 tabs at the bottom of the spreadsheet, COLLECTION, OWNED, LOOKING FOR, & FOR SALE. | |||||||||||
17 | By hitting any checkbox in the COLLECTION tab, each figure will go to the corresponding tab. | |||||||||||
18 | ||||||||||||
19 | ||||||||||||
20 | ||||||||||||
21 | 3. DO NOT edit the AVATAR or NAME cells in the OWNED, LOOKING FOR*, & FOR SALE** tabs. | |||||||||||
22 | All of your adjustments must be made in the COLLECTION tab. | |||||||||||
23 | *LOOKING FOR has a section where you can enter a price range or a fixed price you are looking to spend. | |||||||||||
24 | ||||||||||||
25 | ||||||||||||
26 | ||||||||||||
27 | **FOR SALE has a section where you can enter a price range or a fixed price you would like to sell for. | |||||||||||
28 | ||||||||||||
29 | ||||||||||||
30 | ||||||||||||
31 | 4. When a new figure is announced, you can download the new avatar here. | |||||||||||
32 | Once you've downloaded the new avatar you can now add it to the empty cell in the COLLECTION TAB. | |||||||||||
33 | - [For Computer] Select empty cell. Go to "INSERT" and then "IMAGE" and then "INSERT IMAGE IN CELL". | |||||||||||
34 | ||||||||||||
35 | - [For Mobile] Tap on the empty cell you wish to insert the image. | |||||||||||
36 | Tap the "+" in the upper right corner. Then tap "IMAGE". Then tap "IMAGE IN CELL". | |||||||||||
37 | Then tap "FROM PHOTOS". Select your downloaded avatar. | |||||||||||
38 | ||||||||||||
39 | ||||||||||||
40 | ||||||||||||
41 | Click here if animated GIF isn't playing on your device. | |||||||||||
42 | ||||||||||||
43 | 5. IMPORTANT: For spreadsheet to function, all Avatars MUST have a name below it. | |||||||||||
44 | ||||||||||||
45 | 6. You can customize the sheet by adding rows (not columns), as long as the Avatar and Name cells aren't separated. | |||||||||||
46 | ||||||||||||
47 | 7. You can share, screengrab, or export your sheet as a PDF to share on social media. | |||||||||||
48 | [For Computer] You can access the share and export feature from the FILE menu, or use the Windows snipping tool. | |||||||||||
49 | ||||||||||||
50 | ||||||||||||
51 | ||||||||||||
52 | [For Mobile] You can access the share and export feature from the elipses or Share Icon in the top right corner. | |||||||||||
53 | IMPORTANT: If you share your spreadsheet, make sure that you change link sharing from RESTRICTED to ANYONE WITH LINK. | |||||||||||
54 | ||||||||||||
55 | ||||||||||||
56 | ||||||||||||
57 | Click here if animated GIF isn't playing on your device. | |||||||||||
58 | ||||||||||||
59 | 8. Once you own a PREORDERD item you can simply rename that cell to "Own It" in the COLLECTION tab. | |||||||||||
60 | ||||||||||||
61 | 9. If you need any assistance or have questions, please write to shma.taseries@gmail.com | |||||||||||
62 | ||||||||||||
63 |