Here are some spreadsheets that I finished to give a report based off of the stats that are on a pickup player's game log.
To make it work is pretty simple, after copying the spreadsheet to your Google docs, copy the stats from the Game Log in the player's table and then paste them in cell A2 using Paste Values Only. To find that navigate to Edit -> Paste Special -> Paste Values Only in the menu.
FYI: Technically this spreadsheet will work for normal players, but the win/loss will only be accurate for pickup players & games because of Shirts and Skins always being the same.
QB - https://docs.google.com/spreadsheets/d/1gIM6Th2k8aw_LGnxlv9Ybb8McEPP5l-WcGwHJNzpEwg/
HB - https://docs.google.com/spreadsheets/d/1ohKpCpwpM7_XyvxWOr3sz7r5NOmcavNbCEAPKD7ekjM/
FB - https://docs.google.com/spreadsheets/d/1eQxncxw6dvRSTMT389hcwD3HS0mo_9qok-De2giolB8/
WR/TE - https://docs.google.com/spreadsheets/d/1_cVAzxPRxVNUSn_Ws2SrSG0vsBvMJS8L-v-XOcKWlvg/
OL - https://docs.google.com/spreadsheets/d/1lvktpnp7nJtmcawHWRgRE0uPFRJLR0P60BP1s2vk7no/
DL - https://docs.google.com/spreadsheets/d/1rd8Rg4K4i9W49LBPX4O-nGis2lscoAR3T1BDsRiGl5M/
LB/DB - https://docs.google.com/spreadsheets/d/1BA76HIhBBhnG7oXOlvE1rHkpWLnA5iDxMF8ih5eWfdE/
K - https://docs.google.com/spreadsheets/d/1fFOjg012fXGyBBm7xnvMLRwuNK7_QTWj-azoIEj9iKQ/
P - https://docs.google.com/spreadsheets/d/1IS1Ko-C4-oZRa9k-3UOnXZuv4k4Eg1hjAULis7dFSMM/
To make it work is pretty simple, after copying the spreadsheet to your Google docs, copy the stats from the Game Log in the player's table and then paste them in cell A2 using Paste Values Only. To find that navigate to Edit -> Paste Special -> Paste Values Only in the menu.
FYI: Technically this spreadsheet will work for normal players, but the win/loss will only be accurate for pickup players & games because of Shirts and Skins always being the same.
QB - https://docs.google.com/spreadsheets/d/1gIM6Th2k8aw_LGnxlv9Ybb8McEPP5l-WcGwHJNzpEwg/
HB - https://docs.google.com/spreadsheets/d/1ohKpCpwpM7_XyvxWOr3sz7r5NOmcavNbCEAPKD7ekjM/
FB - https://docs.google.com/spreadsheets/d/1eQxncxw6dvRSTMT389hcwD3HS0mo_9qok-De2giolB8/
WR/TE - https://docs.google.com/spreadsheets/d/1_cVAzxPRxVNUSn_Ws2SrSG0vsBvMJS8L-v-XOcKWlvg/
OL - https://docs.google.com/spreadsheets/d/1lvktpnp7nJtmcawHWRgRE0uPFRJLR0P60BP1s2vk7no/
DL - https://docs.google.com/spreadsheets/d/1rd8Rg4K4i9W49LBPX4O-nGis2lscoAR3T1BDsRiGl5M/
LB/DB - https://docs.google.com/spreadsheets/d/1BA76HIhBBhnG7oXOlvE1rHkpWLnA5iDxMF8ih5eWfdE/
K - https://docs.google.com/spreadsheets/d/1fFOjg012fXGyBBm7xnvMLRwuNK7_QTWj-azoIEj9iKQ/
P - https://docs.google.com/spreadsheets/d/1IS1Ko-C4-oZRa9k-3UOnXZuv4k4Eg1hjAULis7dFSMM/
Edited by Majestic Gent on Nov 16, 2015 09:04:36
Edited by Majestic Gent on Nov 15, 2015 20:46:22
Edited by Majestic Gent on Nov 15, 2015 20:23:22
Edited by Majestic Gent on Nov 15, 2015 17:13:20
Edited by Majestic Gent on Nov 15, 2015 17:11:11
