ABC
1
Version 1.3: Fixed not all rows having auto title. (Quick fix, select any auto title cell above item 26, and copy it all the way down to fill the missing formulas)
Version 1.2: Fixed Rubik's Rubric slot I6. was previously 112, it should have been 122
Version 1.1: Fixed issue where items 69-70 that had the Theme: Mahou Shoujo also listed the Genre: Shoujo, this is incorrect.
Cards with this issue: 1 Aera #69, 5 Étude #69, 6 Rubik #70, 7 Moz #69, and 8 Ran #69
(And if you had the spelling issue of plan-to-watchh, or card 5 Étude's Aviary center item was 112, which should have been 122, that has also been fixed since release)		Need help? PM me on MAL@Alexia383
2
The spreadsheet should be rather self explanatory, though I have added detailed instructions here, incase there is any confusionLast updated2021-02-01
3
4
Instructions:Previous versions credits:
5
Fill in the info in "STATE YOUR INFO" (1)2021 Complete rewamp@Alexia383
6
Set the board id you wish to use in "Bingo Sheet Number"(2)2021-01-08
7
Over on the right (3) you will see the board you selected. (It updates automaticaly when you set the Bingo Sheet Number.)2020 Half assed@Alexia383
8
The main list of items will also update automatically. Graying out items that are not on the board(4). Setting the cordinate for that item on the board(5).2020-01-14
9
If the cordinate color(5) is purple(6) then that item is in the center square, and can be changed following the Rules set for this challange.2019 Half assed@Dysp
10
To change a center square item, go to (21) and override the item indexes there. And the spreadsheet will update automaticaly.2019-01-08
11
(If the item you which to change to is 64-73 (Genre and Theme set by board), then you need to also override the board id for that item in(7))2018 Verison@i_yuuko-chan
12
2018-01-23
13
Adding to an item
14
To fill in an item, put the url for that item in MAL URL(8), and the name will be gotten automatically (9) from a web craweler. (Note that the web crawler might break if MALs backend changes to much.)
15
You can put the Start Date in (10) and End Date in (11) following the format in (12). (Note MAL specificaly asks for the format MMM DD, English only)
Note: The bingo board thing threw me for a
16
If there is no URL then the item is registered as inactive(13) using the inactive color(14).
loop, I have tried to make sure everything is
17
If there is an URL but no start or end date, then the item is registered as Planned(15)(16).
correct, but I'm only human, so there might be
18
If there is an URL, and start date, but no end date, then the items is registered as Watching(17)(18).
some mistakes. Please PM me on MAL
19
If there is an URL, start and end date, then it is registered as Completed(19)(20)@Alexia383
20
Those colors also show in the board visualization (21)
If you find any issues. And I'll get to it when
21
The start of rows or columns in the board visualization will be color red(31) if it is incomplete, or green(32) if it is complete. With diagonals being on the top cornors(33)(34)I have time.
22
The top left cornor(33) of the board, contains the number for currently completed lines
23
24
Fill in extra information in the notes(22) and add image links in (23)
25
For image links use (imgut) Direct Link(24) (or similar something similar in the service you are using)
26
If the Image URL field is pink(23) then MAL has specificaly asked for a screen shot.
27
If you want a neet link in your Extra Info field, use the link combiner(26), by adding the display text(27), URL(28), and get BBcode out
28
29
Output:
30
Copy the Full BB output(29) and paste it in your message on MAL, and remove the "(30) that sheets spawns in at the begining and end
31
(If you want to change the formating, you can edit the formulas hidden between the coloums K and S)
32
33
Extra Notes:
34
Fields that are yellow contain automatic formulas.
35
DO NOT DELETE ANY OF THE ROWS 1-10 as there is a lot logic hidden there and in the hidden columns past AF
36
You can safely delete all other rows, if you want the sheet to be more tidy, (except for 3 hidden rows at the very end, which are color yellow)
37
Or if you dont want an item in your BB Output, you can delete cordinate in (5) and it will treat it as if that item is not on the board.
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100