Scanlator Sheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Rules & Guidelines
3
FOR SCANLATORS/EDITORS
4
IF YOU DO NOT WANT YOUR PROJECTS HERE, PLEASE LET US KNOW AND WE WILL REMOVE THEM
5
RULES
6
1
Please do not delete for any group that is not your own.
7
2
If you filter while using, please remember to clear your filters for the person who uses it after you.
8
3
Use the dropdown options for "Status" and "Progress". Don't type your own nonsense. I won't tolerate anything like, "I swear I'm almost done <3 <3" Redraw is under cleaning.
9
4
For titles and authors, try to use the spelling used on Mangaupdates
10
5
Please only include 1 entry per joint project. You will know if there are duplicates.
11
6
ONLY add BL works
12
7
Don't mess with any of the permissions or conditions/formatting! If you have problems, let me know!
13
8
Only edit the date stamp when you are adding a series, not editing one. The date stamp is the date you first entered the series into the database. Otherwise, the formula will not work.
14
15
GUIDELINES
16
1
Status is color-coded. Blue=Future, Yellow=Ongoing, Green=Complete. You can choose them from the dropdown menu.
17
2
Duplicate values in the "Title" column will turn purple
18
3
When adding extras, use decimals after the chapter it comes from. So if it's the first extra after chapter 5, it'll be 5.1, second extra will be 5.2 and so on.
19
4
To filter, it's the second to last icon.
20
5
The date stamp will go red if a FUTURE project hasn't been updated/released in over 6 months.
21
6
Group 2&3 columns are grayed out unless you type something in it.
22
7
Comments are used to explain discrepancies/status or make announcements.
23
8
The Status worksheets are locked for editing. They are set to autopopulate, so there's no need to edit anything on them.
24
25
Filter and Import Your Group Projects
26
If you wanted to add this spreadsheet to your website, or reference it with JUST your projects filtered out, here's how:
27
1
Create a new Google Sheets
28
2
In cell A1, copy and paste this formula: =QUERY(IMPORTRANGE("1vFwaka6wz8zXqoPvJm1OPQYwOUrh7w3DnSmawdYylkg","Entire List!A1:J2000"),"select * where Col3 = 'Hoshikuzuu Scans' or Col4 = 'Hoshikuzuu Scans' or Col5 = 'Hoshikuzuu Scans' ")
29
3
Replace 'Hoshikuzuu Scans' with your group's name
30
4Voila
31
32
33
FOR READERS
34
Guidelines
35
1
To filter and search for works based on specific conditions, go to the top left corner and click the little "Y" shaped icon next to the Print icon. Then select
"create new temporary filter view". You will then see little triangles next to each of the column titles. From there, you can filter out what you're looking for.
There is a great tutorial here: https://www.youtube.com/watch?v=IWr5lEEtSAs
36
2
This was created so that we can update you on what we're doing. Please try not to pester groups on their status based on what you see here.
37
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
Loading...
 
 
 
Guidelines
Completed
Future
Ongoing
Comments
Completed Works
Entire List