ABC
1
Version 1.1 : Fixed "Current Stats (Auto)" not including all lines (it stopped at line 143 instead if line 173)
Version 1.0 : Updated to 2022, Added darkmode, Improved speed and reliablility
Remember to check the blog for updates and fixes before final delivery		Spreadsheet Version1.1 (Date:2022-04-10)
2
Need help? PM me on MAL@_RoseDagger
3
The spreadsheet should be rather self explanatory, though I have added detailed instructions here, incase there is any confusion
4
2022 Version@_RoseDagger
5
Instructions:2022-01-14
6
Fill in the info in "STATE YOUR INFO" (1)Fix auto stats2022-04-10
7
There are toggles for:
8
 - If you want the progress for each quest(3) in the bbcode outputPrevious versions credits:
9
 - If you want the spread sheet to be formated in darkmode(4) or normal2021 Complete rewamp@_RoseDagger (@Alexia383)
10
 - If you are ready to deliver(5) (this option will put the end date into the bbcode, and remove unsued items from the bbcode)2021-01-08
11
If you want to remove the water mark(6) with version info from the bbcode, you can remove the version info under auto info(7)Updated2021-02-01
12
 (you can keep the version info that is on the instructions for your convinience such that you can see if you need to update your sheet)2020 Half assed@_RoseDagger (@Alexia383)
13
2020-01-14
14
2019 Half assed@Dysp
15
Adding to an item2019-01-08
16
To fill in an item, put the url for that item in MAL URL(9), and the name will be gotten automatically (10) from xml import. (Note that this function might break if MALs backend changes to much.)2018 Verison@i_yuuko-chan
17
You can put the Start Date in (11) and End Date in (12)
- (If the challenge Start(13) says #VALUE! check that you have written the all dates correctly, or go into File/Settings/Locale and change country one that follows the date format you are using)		2018-01-23
18
If there is no URL then the item is registered as inactive(14) using the inactive color(15).If you find any issues:
19
If there is an URL but no start or end date, then the item is registered as Planned(16)(17).1. Check the with the rules that it is an issue there to
20
If there is an URL, and start date, but no end date, then the items is registered as Watching(18)(19).2. Check if there is a new version of the spreadsheet
21
If there is an URL, start and end date, then it is registered as Completed(20)(21)3. Post about it on my MAL blog, or dm @_RoseDagger
22
The quest will show completed when all items in that quest is completed(22)(23)
23
24
Fill in extra information in the notes(24) and add image links in (25)
25
For image links use (imgut) Direct Link(26) (or similar something similar in the service you are using)
26
If the Image URL field is red(27) then MAL requets or recomends a screenshot.
27
If you want a neet link in your Extra Info field, use the link combiner(28), by adding the display text(29), URL(30), and get BBcode out (31)
28
29
Output:
30
Copy the Full BB output(32) and paste it in your message on MAL, and remove the " (33) 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 X-AI)
32
(For changing date calculations and item progress you can look at the hidden formulas in A-L)
33
34
Hiding unused items:
35
You can hide unused items, by toggling the the option(34), opening the filter(35), and pressing "OK"(36)
36
And to unhide you toggle the option off, open the filter and press "OK"
37
Pressing Ready for delivery(5), will hide the unused items and quests in the bbcode only
38
39
Extra Notes:
40
Fields that are yellow contain automatic formulas.
41
DO NOT DELETE ANY OF THE ROWS 1-10 (there is a lot of hidden formulas hidden on those lines)
42
You can delete any items under quests, or whole quests with their items, and the sheet should still work as intended
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