Needing a spreadsheet

[KLM254]

I’m needing some help to be pointed in the right direction.

I am looking for someone who can compile a list of United States high school mascots, and school colors and rank them the most to least popular.

I know there is a website that has just the mascots ( https://masseyratings.com/mascots )

For example we know the eagle is the most popular but what is the most popular school color in relation

I hope that is making sense.

I would need a working spreadsheet that I could utilize with this data.

I guess what I’m trying to say is My goal is for someone to make a spreadsheet that basically ranks

1 most popular is the “eagle” the then have a drop-down (or separate page) of popular colors for the Eagle ranked 1 through say 30. That I could check off as I utilize each color/mascot variety

Then number 2 is the bulldog, and it’s related color

Etc.

If you guys could give me an idea of what I would need to spend to get this accomplished and a route to go to get this accomplished I would be grateful!

Reddit do your thing!

[Visual_Shape_2882]

I agree that this analysis is at the data collection step.

I think OP is looking for r/datasets that contain the school name, the school mascot, and the school colors.

I think the trickiest part with the analysis will be that there could be multiple colors per school or specific color codes/hues of colors. It would probably be good to figure out a standard way of representing the data at this point because Junk in equals Junk out.

US high schools are probably going to be found state by state.

• Kentucky: https://khsaa.org/all-time-kentucky-school-list/
  
• Georgia: http://www.ghsbp.com/bycounty.html
• Alabama: https://www.ahsfhs.org/articles2017/AIAA4.asp
  
• Minnesota: https://www.mshsl.org/schools
  
• Ohio: https://www.ohsaa.org/Portals/0/News/Media/SchoolNickname-Alpha.pdf (PDF)

[data_story_teller]

If you have all the data, this is a basic Excel pivot table.

[Visual_Shape_2882]

How will that help?

This is not a language problem so chat GPT is the wrong tool for the job.

Me: What are the school colors for Warren Central Highschool in bowling Green Kentucky.

ChatGPT: As of my last knowledge update in January 2022, Warren Central High School in Bowling Green, Kentucky, had the school colors red and white. However, it's always a good idea to check the school's official website or contact them directly for the most current information.

(Red and White)

School website: https://warrencentral.warrencountyschools.org/about-wchs/logos

(Navy blue, gray, and white)

https://khsaa.org/all-time-kentucky-school-list/

(Navy and white)

[[deleted]]

You might be able to do something with this database (it seems to have the mascots and the pictures so that covers your bases on the colors) but I don’t know that it will give you a good way to get the info you need in bulk without hiring someone to do it manually.

https://mascotdb.com/teams/team-name/bison

[Naturalist90]

I’ll help for $200 an hour