CFM Spreadsheet

[itsmb8]

Quote: Originally Posted by tosa

https://forums.operationsports.com/f...e-tracker.html Here is a link to something I was using last year, someone else posted it (forgot who so cant give credit) and I made my own changes t it along the way.

Looks like I found my franchise spreadsheet.. Thanks!

[R1zzo23]

I just tried using that sheet after I uploaded it to Google Drive so I’m working in Google Sheets. Is it me or is it not possible to copy and paste the little logos on a Mac?


Sent from my iPhone using Tapatalk Pro

[itsmb8]

Quote: Originally Posted by R1zzo23

I just tried using that sheet after I uploaded it to Google Drive so I’m working in Google Sheets. Is it me or is it not possible to copy and paste the little logos on a Mac? Sent from my iPhone using Tapatalk Pro

Not sure about Google Sheets, but I have a Mac and Excel and the logos work just fine for me.

[philjcreed]

I've done one that is designed for tracking stats from just one team, and just generally inputting things at the end of the season.
I.e. I didn't want the hassle of putting in the box scores for every team every week.

It's based on using the 49ers, but you can change colours to match whoever you're using.

The 'HOME' page is locked, all you need to do is select the year from the drop down at the top and it will auto fill the page with the info it draws from the other sheets.

https://docs.google.com/spreadsheets...it?usp=sharing

[tosa]

Quote: Originally Posted by philjcreed

I've done one that is designed for tracking stats from just one team, and just generally inputting things at the end of the season. I.e. I didn't want the hassle of putting in the box scores for every team every week. It's based on using the 49ers, but you can change colours to match whoever you're using. The 'HOME' page is locked, all you need to do is select the year from the drop down at the top and it will auto fill the page with the info it draws from the other sheets. https://docs.google.com/spreadsheets...it?usp=sharing

Okay, this is awesome piece of work. Still don't understand the autofill part as I don't see a drop down unless I am overlooking it.Kudos for such a masterful job!!!

[tosa]

Quote: Originally Posted by tosa

Okay, this is awesome piece of work. Still don't understand the autofill part as I don't see a drop down unless I am overlooking it.Kudos for such a masterful job!!!

Never mind, figured that out. How could I change the image to the Houston Texans logo?

[philjcreed]

Quote: Originally Posted by tosa

Never mind, figured that out. How could I change the image to the Houston Texans logo?

No problem, if you play around with it you will see that as much as possible auto fills, so if it pops up telling you that a section is locked for editing, make sure you're not overwriting any formulas.

For different logos:

I used DeuceDouglas's sheet as the original idea.
https://docs.google.com/spreadsheets...it?usp=sharing

If you load that up, you will find a sheet called 'team templates' and you can copy your team logos from there. (Just copy the url section, and replace the one in my spreadsheet.)

[R1zzo23]

Wow, this is great stuff! I'll have to play around with it and see which I feel most comfortable with.