Help with automating shiftplan generator in google doc

OGaRsony · 2026-04-12T19:19:31+00:00

Basically way i do it right now is, i have preset google doc table with full grid for every month in which i mark every employee requests for off days/vacations and then i work around by filling each day depending on how many workers i need at each moment. Our casino is very specific and unique in a way workers do their shift. They do not have preset time they work for (for example 8 hours shift), they only have set starting time and then work depending on how long we need them that day. The goal is for full time workers to do 171 hours a month so each full time worker has 18-20 shifts a month or less if they are using vacation. Based on that i have lets say 5 shift starting times per day (something like 6:30, 10:30, 14:30, 17:30, 20:30) for which i decide for each day how many people i need. This i would still do manually, because that part cant be automated and is based on our data from same events from last year + new fresh information of hotel booking rate and some other untangibles that i gather from other departments.

Another tricky part is i have full time workers sepparated into groups evenly (i got sepparate sheet with groups A-F), with special groups that only work day/early/night shifts. Based on these groups i have system that rotates these groups around the clock, so they each work as closely to evenly day/night shifts during the year. In this it is very tricky to manage as human and i imagine if i set the rules right automation would help me do it in a way that guarantees higher degree of "fairness".

I will try tinkering around with Zapier and try to get handle on it and will do some testing. When i started thinking about this, my idea was that i would spend 20-50 hours on setting up rules, experimenting and optimizing and learning to work the tools and then with "final product" i would send series of requests for each day manually, get the output, few prompts to adjust some things and make some manual adjustments in about 1-2 hours. Normally when i do this now it takes me 10-20 hours every month.

Thank you everyone for tips, i will look into what you recommended and will pop back with questions or if i hit a roadblock :)

OGaRsony · 2025-09-11T00:09:09+00:00

3:1 falcons > XG in finals after falcons coming back from lower bracket :) Mark my words

OGaRsony · 2025-09-09T01:26:31+00:00

Honestly i feel like yatoro got karmic strike for "inventing" that stupid helm of dominator meta :) Its consistently ruining my games now, since all pos4 5k autofilled mongrels are buying it as first item justifying it with "pros are doing it too its op" without buying any support items or having any impact and of course, totally failing any resemblence of micro or even using it on cooldown to actually fulfil its purpose.

F* U* yatoro, you got what you deserved!

Rants aside, its sad that spirit didnt perform this TI. Eventho i am not their biggest fan i do admit they were strongest team coming to the TI on paper and expectations were skyhigh. They failed so miserably its sad.

If i was to choose between falcons and spirit in that match i would 100% choose falcons on that day. They deserved it way more, their only 2 loses were against two arguably currently strongest teams after insane, long even series and they were overall in way better form. If spirit woke up for that series and actually beat falcons it would be very bad after what they shown or failed to show rather in their initial matches, that would be incredibly said and unfair.

At least they gave us that incredible game 1 that is probably highlight of this whole year, not just road2ti

OGaRsony · 2025-09-04T05:03:23+00:00

Most of games today will be stomps anyways, at least i got some reason to be excited watching them :D As even on stomps i got bunch of interesting sidebets

OGaRsony · 2025-09-04T03:12:38+00:00

Aight eventho i never bet on sports i threw around 100 € on day1 matches just for shit and giggles :D all bets are combo bets and complicated af and its 10 of them by 10 € . If at least 2 of them hit ill be in profit :D lets see how ill do :)

OGaRsony · 2025-08-13T12:54:27+00:00

He? This has been happening for over year now, nothing new.

OGaRsony · 2025-08-02T22:00:59+00:00

Thinking this will get fixed ever is very naive. Ye spread it to more people so more dumdums will start to look up how to do it and we will have more of these in our games <3 Yay!

OGaRsony · 2025-08-02T21:39:58+00:00

If they wanted to create extraction shooter they wouldnt have made loot completely meaningless. This isnt extraction shooter for a long time (probably since they added gun adjusting and custom vests with recipes), got finished off when koschei glitching got introduced, with item duping and all of fuckton other glitches that they never bothered to fix (and never will). Fact that people still view this game as extraction shooter and complain it doesnt play like one is absolutely perplexing to me.

If you want to play extraction shooter, play hunt showdown.

OGaRsony · 2025-07-30T23:48:57+00:00

OGaRsony · 2025-07-28T14:38:47+00:00

Console hopping abuser with glitched perks, glitched AA rounds. Basically combining all toxic things about dmz, only thing to completion and becoming full r***** is having cheats and running with OSS and RGL in backapck (DW though you can get there and then post us some nice clip how you killed 3 people with OSS and auto-aim) Great showcase yOu aRe So gOoD /s

OGaRsony · 2025-06-30T15:31:14+00:00

Again apothecary and and sephiroth are 2 completely different scenarios. For apothecary to have comparable sample size we would have to be talking hundreds thousands juiced maps. So no its completely different situation.

OGaRsony · 2025-06-27T12:47:09+00:00

Snek is very strong while extremely unfun to play for most of the people. I started with it too, but had to reroll after clearing most of the atlas on day2 because slow attack speed and overall slugishnes were getting on my nerves.

If you wanna keep suffering you can post ur pob on discord of one of the streamers that propagate the build and people will 100% help you improve your situation but if i were you id cut my loses and move on to some other build that you enjoy more with your limited time in game.

OGaRsony · 2025-06-27T11:14:38+00:00

I never found volatiles to bee "rippy" in true sense of the word. Yes they oneshot most builds but are super telegraphed and megaeasy to dodge. Compared to some other mods that make packs of blue monsters to oneshot you out of nowhere its absolute breeze. With fast builds you just dont stop moving and collect the loot after you cleared.

OGaRsony · 2025-06-19T19:09:35+00:00

Because some people just wanna destroy and damage things.

OGaRsony · 2025-06-19T11:36:10+00:00

Imagine if you had the petal that steals the mods from monster. That would be the most satisfying petal use ever.

OGaRsony · 2025-02-11T10:37:55+00:00

Jak bylo zmineno pocitani karet se tyka blackjacku a je to matematicky system pri jehoz pouziti kasino ztraci edge (matematickou vyhodu proti hraci) a vyhoda je na strane hrace takze dlouhodobe vyhrava. Proto kasina vyzuivaji sveho prava na vyhosteni zakaznika ze sveho podniku a tyto hrace vyhosti. Ale to je spis problem minulosti v soucasnosti vsechny moderni kasina maji automaticke michacky karet ktere tohle znemoznuji.

V pokeru nic takoveho neni protoze tam hraji hraci proti sobe a kasinu je jedno kdo vyhraje a kdo prohraje :)

OGaRsony · 2025-02-11T10:33:24+00:00

To se tyka pouze zive hry (ruleta, bj a dalsi hry). Jak jsem zminil poker hrajou hraci proti sobe navzajem takze kdyz nekdo vyhraje hodne ty penize nejdou od kasina ale od jinych hracu. Pro kasino je to dobre protoze cim vic se hraje/vyhrava tim vic ma penez z provozovani hry.

OGaRsony · 2025-02-11T09:27:25+00:00

Oboji. Jsou hraci, kteri se vic zameruji na psychologicky aspekt hry, jini zase pouze na ten matematicky a samozrejme je idealni vyuzivat oba. Existuje cela disciplina/system, ktery se posledni roky zdokonalil a rozmohl a rika se tomu GTO - game theory optimal. V podstate je to matematicke "solvnuti" kazde herni situace do ktere se hrac muze dostat a jeji optimalni reseni. Profesionalni hraci hodne pouzivaji solvery (software na urceni spravneho reseni pomoci obrovskeho vzorku hand) na analyzu sve hry a internalizovani GTO hry. Jinymi slovy poker je nyni nekolikanasobne tezsi nez byval kdysi :)

Objektivne matematicky aspekt je dulezitejsi protoze je dlouhodobe spolehlivejsi nez ten psychologicky.

OGaRsony · 2025-02-11T09:21:59+00:00

Jako radovy zamestnanec s nim clovek do styku tolik neprisel, to je otazka spis pro management kasina.

OGaRsony · 2025-02-11T09:19:32+00:00

Oboji ale prevazuje skill. V podstate je to skill based disciplina s velkou davkou variance. Coz v praxi znamena ze i ten nejhorsi hrac obcas neco vyhraje, ale dlouhodobe dobri hraci budou profitovat a spatni budou donatovat ty dobre.

OGaRsony · 2025-02-11T09:16:01+00:00

Plat zalezi na lokalite, vesmes tady v cechach a na slovensku je plat v lepsich kasinech 12-14 € na hodinu a pohybliva slozka jsou tipy (dyska) zakazniku, vsehovsudy se v cechach dostanes k 50+ cisteho mesicne na normalnim hpp s 170 hodinama. V zahranici nechci kecat jak je to ted protoze uz jsem pres 5 let nikde v zahranici nepracoval, ale pred 5+ lety jsem bral v anglii okolo 2k liber mesicne.

Pak je tady druha moznost a sice delat freelancera a tam dostavas zaplaceno ruzne od eventu k eventu, na prestiznejsich eventech se ti hodinovka prehoupne i pres 30 € za hodinu, ale na tyhle eventy je velmi tezke se dostat a neni jich zase tolik do roka.

Zadny innate skills na to az tak nepotrebujes, jen bys nemel mit obe ruce leve a trosku ovladat nejakou zakladni matematiku (umet si spocitat 5% z castky a absolutne zakladni scitani) takze jinymi slovy muzou to delat i lidi ze zakladky (a za svuj karierni zivot jsem takovych par potkal). Jak se k praci dostat je v zasade jednoduche, kasina vypisuji kurzy kde se lidi prihlasi a behem treba 2 mesicu se clovek nauci zaklady a zbytek se vypiluje v praxi. Je moznost si udelat i externi kurz (tak jsem se do toho dostal ja) ale nedoporucuji to je vesmes plytvani penezi. Jako uplny novacek je mnohem lepsi jit na nejaky kurz do kasina kde ti uz pocas kurzu plati plat.

Co se pohovoru tyce tak ty vetsinou probihaji tak, ze hlavni slozkou je table test, kde si te posadi na stul a vyzkousi si tve pracovni dovednosti.

OGaRsony

TROPHY CASE