• 0 Posts
  • 30 Comments
Joined 2 years ago
cake
Cake day: June 27th, 2023

help-circle








  • But won’t excel detect there’s no values and no print anything?

    I think it has logic to only print pages which have values.

    1. Type “.” In A1

    2. Change the fill colour of A1 to Black

    3. [CTRL] + [A] (Selects all cells)

    4. [CTRL] + [R] (Copy’s the left most selected column across to the right most select column)

    5. [CTRL] + [D] (Copy’s the top most selected column down to the bottom most select column)

    Every cell will now contain the value “.” and be set to fill colour black.

    1. Right click any of the column letters at the top > Set width > 1000. (Changes the column width to 1000 pixels. (Expanding the cells so they take up more room when printing)

    2. Right click any of the row numbers at the left hand side > Set height > 1000. (Changes the row height to 1000 pixels. (Expanding the cells so they take up more room when printing)

    3. [CTRL] + [P] (Opens up the print dialog)

    4. [ENTER] (Selects the print button to start printing)







  • Idea 1:

    I was thinking of web scraping the data before hand, then having it hardcoded in an array or DB to be used in the drop-down. I have seen a few of the anime sites have pages for each season it could be pulled from. I saw some plugins for searchable drop downs for lime survey, So you might be able to make it work with the same software.

    I think Manga would be the most difficult to limit, I am not aware of a single point where all the data is available. Light Novels have a CSV someone is scraping and hosting on GitHub, Anime have clearly defined seasons, But manga doesn’t seem to have a release system.

    Idea 2:

    You could check the account age. If anyone starts creating accounts now for a poll which may never happen then they deserve an extra vote.


  • I am absolutely open to feedback like this for if/when we do something like this again.

    Just some ideas -

    1. Limiting the options - you could pull the anime’s that have aired in the time frame from one of the Anime databases and limit the users to searchable drop downs.

    I do worry now that people know I made these calls based on number of nominations that they could simply fill out the form a bunch of times. There are some steps I can take on my end to prevent or filter that, but it would also mean doing things like attaching browser cookies to the form or recording ip addresses, which I haven’t wanted to do out of respect for the users.

    1. I feel it would be less intrusive than cookies or IP addresses to have a confirmation like you do with email signups. You could have an optional input for Lemmy Username and have a script to send the user a message via Lemmy to confirm they made a submission (… reply ‘YES’ to confirm…). Blank or unconfirmed submission could be treated with less importance when taking nominations due to the possibility of multiple submissions.

    If you do decide to do it again in the future I am happy to help when possible.

    And Thanks again for doing this.