[columns][size=4][color=black]howdy do! i'm arga & i run a lot of raffles. i am here to offer some simple ticket tracking tools and explain how to use them.
> [b]the base[/b].
[url=https://docs.google.com/spreadsheets/d/1ynQQcWe5muEYiS-TEajBK_EsXGbxa1ZWqFtlTKzV4BM/edit?usp=sharing][i]google spreadsheet link[/i][/url]
to make a copy, press file -> make a copy.
[u]for manual ticket entry[/u]
this sheet automatically calculates the winning numbers held by each user; you just have to tell it how many tickets they have. for example:
[/size][/color][nextcol][nextcol][nextcol][img]https://www1.flightrising.com/static/cms/familiar/art/41965.png[/img][/columns]
[img]https://cdn.discordapp.com/attachments/739338366109220879/902016134621065256/unknown.png[/img]
user 1 has 4 tickets. their winning numbers are 1, 2, 3, and 4 (1 - 4). you only need to add data to the [i]orange[/i] cells. the blue ones update once you do.
[img]https://cdn.discordapp.com/attachments/739338366109220879/902016907568377856/unknown.png[/img]
if desired, you can add a user's new tickets into a new row. this means user 1's winning numbers are now 1, 2, 3, 4, 7, 8, 9, 10, and 11.
> [b]troubleshooting (& misc)[/b].
[i]i accidentally deleted / typed over information.[/i]
[indent]if you have not closed the sheet, press ctrl-z (undo) as many times as needed. if you accidentally press it too many times, press ctrl-y (redo).
if you have, file -> version history - see version history may have the information showed. "show changes" may be checked, and it will show you a preview. the current sheet is not overwritten until you click "restore this version."[/indent]
[i]can i use this sheet to build my own?[/i]
[indent]sure![/indent]
howdy do! i'm arga & i run a lot of raffles. i am here to offer some simple ticket tracking tools and explain how to use them.
> the base.
google spreadsheet link
to make a copy, press file -> make a copy.
for manual ticket entry
this sheet automatically calculates the winning numbers held by each user; you just have to tell it how many tickets they have. for example:
|
|
|
|
user 1 has 4 tickets. their winning numbers are 1, 2, 3, and 4 (1 - 4). you only need to add data to the
orange cells. the blue ones update once you do.
if desired, you can add a user's new tickets into a new row. this means user 1's winning numbers are now 1, 2, 3, 4, 7, 8, 9, 10, and 11.
>
troubleshooting (& misc).
i accidentally deleted / typed over information.
if you have not closed the sheet, press ctrl-z (undo) as many times as needed. if you accidentally press it too many times, press ctrl-y (redo).
if you have, file -> version history - see version history may have the information showed. "show changes" may be checked, and it will show you a preview. the current sheet is not overwritten until you click "restore this version."
can i use this sheet to build my own?
sure!
i'm in a stylized text mood so sorry in advance (this is a reserve)
easy pinglists:
[code]=CONCATENATE("@", (join(" @", unique(A1:A))))[/code]
i'm in a stylized text mood so sorry in advance (this is a reserve)
easy pinglists:
Code:
=CONCATENATE("@", (join(" @", unique(A1:A))))
armored colony my beloved... (reserve)
armored colony my beloved... (reserve)
i don't think i'll need this many but just in case. last reserve!
i don't think i'll need this many but just in case. last reserve!
