(For some reason my blahaj comment didn’t federate)

Yes, yes you did. 590 average pixel count for mander.xyz.

I am using the log file that was provided in the announcement post https://cdn.sc07.company/canvas/2023/pixels.log.txt

There aren’t any of these stats in the file, so we have to find them ourselves.

So basically I am only looking at rows that are “user placed” (which doesn’t remove the undos completely, but it’s easier to do this) then I find an instance I want to look at and only grab logs from that. I then count each uniqe user and that’s the user count for that instance. Then I divide Total Pixels by User Count to see how many pixels on average are placed by those users.

cat pixels.log.txt | grep "place" | awk '{print $3}' | awk -F"@" '{print $1" " $2" "}' | sort | uniq -c | sort -nr | grep "mander.xyz" | count

> 10

So this says there are 10 users who are from mander.xyz who have placed at least one pixel on the canvas.

cat pixels.log.txt | grep "place" | awk '{print $3}' | awk -F"@" '{print $1" " $2" "}' | grep "mander.xyz" | count

> 5896

This tells me that there are 5896 pixels that were placed by users from mander.xyz

5896/10 ~= 590

Therefore on average a user from mander.xyz placed 590 pixels on the canvas. (This is very high, you brought the average up really high with your pixel count)

I’m very tired and am having some trouble with math atm, but I hope this explanation makes sense!

Absolutely, it was great going to bed being pretry confident everything would still be there when you woke up.

I suspect future events will have a different feel, if we start with a lot more users participating.

Ah, that’s a neat thing to find out too.

Should put in no.lastname.nz in the list ;)

With say an average of 300 pixels per user and a 628000 pixel total it puts the total users at 2100. I would want someone else to double check my results tho as my brain is just pixels now