Show original
Try the app
Enjoyed this article?
Use "Request tipping" to ask the author to set up tip receiving.

AI translation
When there's no auditor on-site, using Excel's RAND() function for lottery draws has weak explanatory power. To process the roster within the browser and keep the seed and evidence PDF on hand, I implemented SUGUDASU lottery.
Try the app
Enjoyed this article?
Use "Request tipping" to ask the author to set up tip receiving.
In a marketing project I was involved with before, there was an internal audit witness and log recording for the lottery drawing. The tool I'm creating now is not a replacement for the audit department. The reason I made it was that I wanted something I could provide when asked "Did you draw from that list?" at a site where there was no witness present.
Excel's RAND() changes numbers when you open it again. Even if it looks fair, it's difficult to show the same result later. SUGUDASU lottery doesn't upload the list to a conversion site, draws within the browser, and leaves behind a PDF with the seed and the list's fingerprint. It's not magical fairness. It's the minimum material for when you're suspected.
There's also a primary check for the Premiums Display Act. It doesn't make judgments about legality or illegality. The assumption is that you select the campaign type and use it for organizing before consultation. Shipping to winners and internal authority management are out of scope.
Try: https://sugudasu.com/fair-draw?utm_source=tsukutta&utm_medium=social&utm_campaign=story_fairdraw_why約束: https://sugudasu.com/statements
以前私がマーケティングで関わった企画では、抽選に内部監査の立会とログ撮影がありました。今つくっている道具は、監査部門の代わりではありません。立会がいない現場で、「その名簿で引いたのか」と聞かれたときに渡せるものが欲しかった、というのが作った理由です。
Excel の RAND() は、開き直すと数字が変わります。公平そうに見えても、あとから同じ結果を示しにくい。SUGUDASU 抽選は、名簿を変換サイトに上げず、ブラウザ内で引き、シードと名簿の指紋付きの PDF を手元に残します。魔法の公正ではありません。疑われたときの最低限の材料です。
景品表示法の一次チェックもあります。合法・違法の判定はしません。キャンペーンの型を選んで、相談前の整理に使う想定です。当選者への発送や、社内の権限管理は対象外です。
試す: https://sugudasu.com/fair-draw?utm_source=tsukutta&utm_medium=social&utm_campaign=story_fairdraw_why約束: https://sugudasu.com/statements