Create a checklist spreadsheet file:
Excel is a spreadsheet program. There are a few others. .... is free. Google Spreadsheets is free and online. This HOWTO will use Excel 2007, just because it's what I have.
- If it's there, find your set in ACO's Scan Gallery
- Open your favorite spreadsheet program.
- Type in the header row. It usually starts with # for number. It should end with OWN.
- Continue with your checklist. The last cell, under OWN, should be "YES NO ___"
- Double check your checklist, and save it. If you don't want to POST your own checklist, you can STOP HERE. Send the file to mystavash@animecards.org.
- Now, click "Save as..." other formats.
- Save it as a CSV file (see the drop down for file formats for the right one.)
- Close your file. It may give you some error messages about "Are you SURE you want to keep it as a csv file?" Yes, you are sure.
- Find the file on your computer. Right click it, and Open with Notepad.
- A CSV file uses commas to divide information. We don't want commas, we want pipe bars |. Click Edit >> Replace: Find what "," Replace " | " (don't forget the spaces!).
- Click save. Leave this file open.
Create an ACO checklist
- Click on Add a new checklist.
- Select the Anime Series from the drop down list. If you don't see what you need, please select OTHER.
- Type in the first word of the Set Name. Wait a few seconds. If what you want appears in a drop down, select it. Otherwise, finish typing in the set name.
- Type in the title of the checklist. Use this format: Series name - Set name (List).
- If there are any really important details, add them to the details box. The default is N/A (no details).
- Copy everything from the CSV file into the Checklist box.
- In the Update box, type
<i>Created</i>: Month Day, YEAR