PTCGP Collection Tracker 1.0.2.4

	B	C	D	I	O	Q	U	V	W	X	AD	AE	AF	AG
1	If you have any questions, suggestions, or feedback feel free to reach out on Discord / Reddit @ konekode / u/konekode			Data Migration	Generate Transfer Data	Restore User Data	Transfer Data				Temporary Backup
2				Data Migration	Generate Transfer Data	Restore User Data	Transfer Data				Temporary Backup
3				If you are coming from a version prior to this system, you'll have to manually move your data to the Transfer Data section:			Genetic Apex		Promo		Genetic Apex		Promo
4	How To Use						Owned (Checkbox)	Copies (Numerical)	Owned (Checkbox)	Copies (Numerical)	Owned (Checkbox)	Copies (Numerical)	Owned (Checkbox)	Copies (Numerical)
5	How To Use						Owned (Checkbox)	Copies (Numerical)	Owned (Checkbox)	Copies (Numerical)	Owned (Checkbox)	Copies (Numerical)	Owned (Checkbox)	Copies (Numerical)
6	Step 1: Make a copy				Transfer Data Start Cell: U6 Temporary Backup Start Cell: AD6		FALSE	1	FALSE	0
7	Step 1: Make a copy			1. Go to your old sheet and copy the entire copies / checkbox column (whichever is present or used in your sheet) and paste the values to the right under the Transfer Data section. 2. At the time of writing, there is only the Genetic Apex sheet with user input. If you use checkboxes, paste into the owned column. If you use numerical entry paste into the copies column. 3. Click the Restore User Data checkbox. It will uncheck itself when the script is finished.			FALSE	0	FALSE	0
8	- Mobile (Sheets App): Three dots -> Share & Export -> Make a copy						FALSE	0	FALSE	0
9	- PC (Google Sheets Website): File -> Make a copy						FALSE	0	FALSE	0
10	NOTE: Any cell that accepts user input contains a light blue background. Other cells should not be touched.						FALSE	0	FALSE	0
11							FALSE	0	FALSE	0
12	Step 2: Input # of Copies for each card in your collection						FALSE	0	FALSE	0
13							FALSE	0	FALSE	0
14							FALSE	0	FALSE	0
15	- There is a toggle next to the checklist that allows you to choose between marked cards via Checkbox or by entering the # of owned copies. (The data is preserved when switching, and both are accounted for when tracking metrics.)			How To Use			FALSE	0	FALSE	0
16				How To Use			FALSE	0	FALSE	0
17				Step 1: Generate Transfer Data			FALSE	0	FALSE	0
18				Step 1: Generate Transfer Data			FALSE	0	FALSE	0
19	- The only exception is the Playsets metric which requires knowledge about the # of owned copies. The sheet will allow you to enter copy quantities higher than 2, but metrics only care about 0, 1, or 2 copies.			If you have done any filtering / sorting, ensure to sort your tables A - Z on the # column. (Pokedex # in format of 001, etc.) This ensures that your data will be transferred correctly, as A - Z by # is the default sort order for all tables.			FALSE	0	FALSE	0
20							FALSE	0	FALSE	0
21							FALSE	0	FALSE	0
22	NOTE: Use 0 instead of an empty cell to denote cards you do not own. (The query aggregate functions don't play well with empty cells. Most things would be fine, but strange numbers may appear as a result of empty cells.)						FALSE	0	FALSE	0
23				Click the Generate Transfer Data checkbox. The checkbox will uncheck itself upon finishing and your data will be in the Transfer Data section..			FALSE	0	FALSE	0
24							FALSE	0	FALSE	0
25							FALSE	0	FALSE	0
26	Playsets			Copy all of the values and paste them into the new version of the sheet under the same columns in the Transfer Data section. Some columns may have more data than others, so I suggest the following:			FALSE	0	FALSE	0
27	Playsets						FALSE	0	FALSE	0
28	- For the purposes of this sheet, a playset is defined as two copies of the same named card. (You can put max 2 of the same card in your deck, and will often want two copies to raise the chances of drawing one.)						FALSE	0	FALSE	0
29				1. On Row 4, select all of the columns for the transfer data. 2. Use CTRL/CMD + SHIFT + DOWN until you've reached the final row in the sheet. Copy and paste that data over.			FALSE	0
30							FALSE	0
31	- This metric is used for tracking how much of a pack you have ready to use in a deck. Many cards have alternative art versions that can come from any number of sources. As long as you have at least 2 copies across all versions, the playset will be marked as completed.						FALSE	0
32				NOTE: The new sheet may have additional columns, but they will always be sorted in the same order. As long as you select all transfer data and start in the left most column when pasting, your data should end in the correct columns.			FALSE	0
33							FALSE	0
34							FALSE	0
35	- All ★ / ♕ cards are functionally identical to their ♦ version. (As an example, ♦♦♦♦ Charizard EX is the same card as the ★★/★★★/♕ versions, with the only difference being the art. You can only use 2 max across all four versions.)						FALSE	0
36				Step 2: Restore User Data			FALSE	0
37				Step 2: Restore User Data			FALSE	0
38				Click the Restore User Data checkbox, and the sheet will take all of the transfer data and put it in the correct sheets.			FALSE	0
39	Filtering and Sorting						FALSE	0
40	Filtering and Sorting			Before restoring data, the sheet will take all of the current inputs to create a temporary backup. If you accidentally hit restore data you can copy the Temp. Backup Data to Transfer Data and restore it.			FALSE	0
41	- The sheet is set to sort by Dex # by default, allowing your input order to mirror the in game list.						FALSE	0
42							FALSE	0
43	- If you wish to change any settings, click the 3 bars next to the column header you wish to change. (On Mobile, click on the cell and use the modal that should appear.)			The temporary backup section is a failsafe to protect your data. Should you acidentally restore user data a second time without copying your temporary backup, your data may be permanantly lost.			FALSE	0
44							FALSE	0
45							FALSE	0
46	- All columns in the table are filterable / sortable. An example would be filtering to show Electric cards from the Mewtwo pack, and then sorting by # of owned copies.						FALSE	0
47							FALSE	0
48							FALSE	0
49	Changelog						FALSE	0
50	Changelog						FALSE	0
51	Version	Date	Changes				FALSE	0
52	Version	Date	Changes				FALSE	0
53	----	9/26/2024	- Initial Release				FALSE	0
54	1.0.2.1	9/28/2024	- Added metrics to track Playsets. (Credit to u/lotsofaaa & u/SWNarcasus for the suggestion) - Added card types for Trainer / Supporter cards. (Credit to u/dewey-defeats-truman for the suggestion) - Fixed typos in card names.				FALSE	0
55							FALSE	0
56							FALSE	0
57							FALSE	0
58							FALSE	0
59							FALSE	0
60							FALSE	0
61	1.0.2.2	9/30/2024	- Added Mew to Genetic Apex A1 list - Changed Dex # to use leading zeros. (Credit to u/M0UL for the suggestion.)				FALSE	0
62							FALSE	0
63							FALSE	0
64							FALSE	0
65	1.0.2.3	10/4/2024	- Added Data Migration system to ease the data transfer process. - Added Dashboard and Immersive Mew Tracker. (Credit to u/NotaSarcasticWaffle for Mew suggestion.) - Added ability to toggle between checkbox and numerical input mode. (Credit to u/StudioCalcifer. Partial move towards their suggestion.) - QOL to make expanding the sheet easier in the future. (Faux database, reworked formulas, etc.) - Added images + links to Serebii's card page for easier access to skills, stats, etc. (Credit u/Merlinazo & u/NotaSarcasticWaffle for suggestion) - Added Promo-A pack				FALSE	0
66							FALSE	0
67							FALSE	0
68							FALSE	0
69							FALSE	0
70							FALSE	0
71							FALSE	0
72							FALSE	0
73							FALSE	0
74							FALSE	0
75							FALSE	0
76							FALSE	0
77							FALSE	0
78							FALSE	0
79							FALSE	0
80							FALSE	0
81	1.0.2.4	10/4/2024	- Redesigned Dashboard page				FALSE	0
82							FALSE	0
83							FALSE	0
84							FALSE	0
85							FALSE	0
86							FALSE	0
87							FALSE	0
88							FALSE	0
89							FALSE	0
90							FALSE	0
91							FALSE	0
92							FALSE	0
93							FALSE	0
94							FALSE	0
95							FALSE	0
96							FALSE	0
97							FALSE	0
98							FALSE	0
99							FALSE	0
100							FALSE	0