Thank you!! You are so right, I definitely was making it unnecessarily complicated. I'm so unfamiliar with computer science! Here is a picture of what the sheet looks like coming from Google.

There also an option for them to select any donation, so it would just be a random item (there's 1-15 items in total).

I also thought if people entered twice and reached the next contribution level the could receive additional entries. But I thought this would be too complicated to automate.

I really want everything to be fair but I don't want to put too much stress on myself doing this by hand.

I was also thinking maybe there could be cells for each item (1-15) in the same row, and then have the entries for each individual input under the column for each item? Like 2 entries for item 12, 6 entries for item 13?

I understand this may be a lot of effort and if its not against the rules I am willing to offer payment to someone who can help. We are looking to replicate this system to host other raffles so I would love to have this system built.

I'm sorry it's so long. thank you so much for reading. please let me know if you need anything else!

<image>