Yes that's a good idea indeed and will for sure use it adding new tabs each month.
I'll just keep use one spreadsheet for each year to make it more practical to avoid to have too many tabs after some years
1 spreadsheet - 1 year - 12 tabs

remember I'm still a human being :P
I always put lot of care doing this.

this is a service I did and continue to do with pleasure to help finkleroy to have life 'easier' and it's not my aim to make it instead more complicated

But ehy, if a mistake will happen will be somehow managed
Eraseres and CTRL-Z exists for this in main life :)

I gave a look to your screenshots and proposal
Sincerely I'd like to keep it as it is because for 2 main reason: the single user point of view and 'administrative' point of view.
(the 'tool' was born mainly to help finkleroy in is heavy task)

For single user point of view:
this is just an help to verify if you have reached your limit or not and where.

I don't see big issue with a 1080p resolution like yours
I've done all of this using my Chromebook 14" 1080p see attached picture :)
(my main gaming computer is in my studio but I like to play it in my living room and all my GOG/Steam/Epic games are launched through Steam Link on my 50" TV)

To verify your month status you just a have to check your lines that could be at maximum 2: 1 per Non-Daggered - 1 per Daggered
and to quick move on the sheet just press CTRL+F and type your name in it... the result would be just max 2 to rows per user and fastly swap between the two of them using one ENTER key (so not a big fatigue)

For administrative point of view:
Keeping track of single titles, it's quite important to have a global trend view of the kind of games request, run an analysis of the requests at the end of certain period (how many AAA,AA titles has been requested per user, etc..) and put in place the corrective actions if necessary.

Second point:
In case of 'discussions' from some user the admin can always says:
you got this this and this
here it is the links of your granted requests - end of discussion

And to reach this I had to split in the separate views: 1 for Non-Daggered - 1 for Daggered

From my point view the important things are:
- the sheet should contain all the main information necessary to run correctly the GA
- the information should be as complete as possible to help finkleroy have his overview
- the information should be correct

I'll start this way and the see how it'll go, it's not forbidden to apply changes on the run





(sorry forgot to add the attachement.. i just link it https://ibb.co/FnB8dr6)

Your are both welcome!
Have fun and enjoy!

Ok, thank you for your time and the response.

I do understand where you are coming from, as I hadn't before, and I do appreciate the reasoning. I apologize for sinking into the all-too-common trap of wanting this spreadsheet thing be a "what's best for me" matter instead of "what's best for us."

Out of curiosity, if someone gets an unusually higher-than-average number of AAA, AA etc titles, but so long as they don't break any rules, what kind of administrative action would be required?
The statement in question is Maybe you didn't mean it as the way I could read it (ie if you request too many good games you might get BL'd), so would you mind clarifying?
I can also see how you meant this as a list of bullet point unrelated things, but the "corrective actions" immediately following "the number of requests per user (for top-tier games etc)" made me curious.

And, I was gonna make a joke, but cannot find the source material, so for now...this, i guess. :D

No need to apologize! we are here to talk about this

No no: probably I expressed myself bad
No 'corrective' action is planned, punishements or something similar (and neither I'm the person who will take them)
That was just an example I did

The aim is offer a tool that is as complete as possible to understand if things are working as finkleroy has in his mind

If after some times everything is fine: GREAT!
if not, maybe (and I repeat maybe) finkleroy can decide to apply some changes
This spreadsheet could be for him a starting point to begin an analysis, nothing more

As I as said let's start and see how things will work fine :)

Thank you Crackpot.756 for Hacknet, kmcoolice for Orwell and finkleroy for managing this thread.

Seems like a good balance. Thanks!

So if for 1 month there is 3 rounds. :
- 1st update have 10 "A+" games => + 1 round
- 2nd update have 3 "A+" => +0 round
- 3rd update have 40 "A+" => +1 round

For that particular month Things will be :
- 5ND + 7D from main list
+ 2ND + 2D for 1st updt
+ 1ND + 1D for 2nd Updt
+ 2ND + 2D for 3rd updt
==>> Total 10 ND + 12D and each updates will stand for about 10 days with 1round at the publishing date and 1 round just before the copy in the main list

Is that correct ?
For how long will run the 2nd round for 1st and 3rd updates ?

("A+" stand for "extremely popular" and I just do not want to know what A+ figure out for the others ;-p)

But is this not the purpose of the retained keys ?
If at any given moment you have so many "A+" games, it's time to do several updates during the same month, right?

There you add complexity by doubling redistribution mechanisms. Mostly updates that really contain a lot of A + games are not so common.
Therefore what is the criterion that triggers precisely a 2nd round?

Well, for me, this 2nd round by update is not useful for the majority of us. It can be if we suddenly think of a game that had escaped us in the first round and that we really want to have all of a sudden while the quota of the month is already exhausted on the main list. As it is an ELASTIC quota, it's convenient ...
But again, there is already a mechanism that can be used in this case: the appointment, which reserves a game for a few days. (the time to move to the next month for example.)

All this makes things very complex. But as I always say, things in your hands.


Edit : mispelling

I think Damon18 explained it well. I'll just be eyeballing it. The reason the limit is 1 daggered key + 1 non-daggered key per update is to prevent people from taking 3 popular keys at once. Introducing rounds prevents people from taking 5 at once when the update is added to the main list. I don't understand what's so complicated about how this works.

yes that's also what I understood. is there errors in my example that would made it more simple ?

yes that's also what I understood. Except that I do not think there will still have 5 remaining keys, OR, if we speak about the raptor wich will post at midnight, this raptor will have already grab all the keys using differents accounts + nomination process if needed.
we are talking about a better distribution for EVERYONE by avoiding malhonetes, isn't it?

So let's imagine this example voluntarily exaggerated: : my account, + my wife account + my 2 sons and 3 girls accounts (already 7/14 games for 1 update) + some friends wich will gently nominate me or one of my familly account to the next keys ;-)
This film, purposely absurd and gross, says that there are always mechanisms to prevent the rest of any A+ game at the end of 1st round ;-)
So I think it does not help to prevent the characters "fast enough at midnight" :-)

Finally, the only real and effective change is the 1ND + 1D update, for which fraudsters will still have a little more work to do. (and it's already a good thing!)
But it's a lot more complicated than before for everyone (and for you 2 too, up to you).

This point is important. Will there be a newsletter for EVERYONE to be aware about the next special offer?
(Next in PM my community friend ;-D - I'm kidding a bit ...)

because the 2nd round will be practical for that: to help a friend who has already taken his 1ND + 1D games so that he can have a 2nd before someone also asks for this game ...


Edit : trasnlations

You seem to be extremely paranoid about hypothetical situations that might occur in the future wherein scammers and cheaters take advantage of the giveaway. I haven't seen any of this happen during my time hanging around the giveaway. Has this been a problem in the past? What makes you think it will become one in the future?

Nobody will know if or when another round will happen before it happens. It will be random, just like the updates. I think you're unnecessarily complicating the rounds concept in your mind. It's really not.

<hissyfit>
Could you please stop your abstruse comments? They are not very helpful.
You have problems with the rules of this GA?
Why don't you open your own GA, with a strict rule book and a few deputy sheriffs?

Please excuse my harsh words, but I'm slightly irritated by your comments.
Maybe we are lost in misunderstanding/translation due to my poor language skills.

As I wrote before, I always liked the lighthearted vibe of this GA, and hope this will remain unchanged.
</hissyfit>

-------------
Thank you Damon18 and finkleroy for your patience.

Let's just wait for September first and see how it will go.

I agree with finkleroy, gixgox and AWG43 (+1 everyone)
There are too many reasoning here that are made on the Twilight Zone...
Ler's start this new thing and will we see how it's gonna settle..

... and above all, let's just all enjoy all the free games without cringing our brains too much



And that's what I'm gonna do here:

may I request from main list:
- Cast of the Seven Godsends
- Super House of Dead Ninjas + DLC (dlc is between the list of daggered)


:)

Granted.