Subscription pricing
Does anyone has a tracker or spreadsheet that they use for LR and/or RC? I know that using a tracker/spreadsheet for LG is common but I was just wondering if anyone has something to track LR/RC progress before I try to make one from scratch and then realize there is one out there floating around which just so happens to be superior to the one I have created.
1
10 comments
@ninaleaoishi762 Gotcha!
@koffi04jun147 said:
@ninaleaoishi762 what is the PT'D? section for??
It's just so I can note whether or not I took a section on its own or as part of a PT!
Thanks guy these are beautiful and I love that you guys were able to bounce ideas off each other! @ninaleaoishi762 what is the PT'D? section for??
@katrakkade441 said:
@katrakkade441 said:
@aburk3611 said:
Actually, I realized that for some reason on this particular spreadsheet this does not actually work. I reformatted it a little(I changed the numbering to refer to the number 8 lines above it instead of being by copying and pasting it) and extended it to 83 tests worth. You can drag the formula down to more if it pleases you. I also flipped the order from 35-1 to 1-83 in order to accommodate space for the other tests. Otherwise this is just an excel copy of the google spreadsheet posted by @ninaleaoishi762.
https://docs.google.com/spreadsheets/d/e/2PACX-1vRLuIqvob-_btQ6jj9UHbNTwj4BTek2EMKNCoLIh_ARxjKG3JYrrczHMMG9HHMsIUEnn92P3fnC7kes/pub?output=xlsx
Ugh, beautiful! I didn't think of that.
@katrakkade441 said:
@aburk3611 said:
@ninaleaoishi762 That's awesome! As someone not extremely familiar with Excel or Google Sheets, how do you extend the formatting? Say for the LG's how would you "drag" the formatting downwards for more PTs?
You highlight the part that you want to repeat (probably 8 rows here to keep the alternating color). Then you use the little square in the bottom right corner of the cell to drag down the formula as far as you want.
Actually, I realized that for some reason on this particular spreadsheet this does not actually work. I reformatted it a little(I changed the numbering to refer to the number 8 lines above it instead of being by copying and pasting it) and extended it to 83 tests worth. You can drag the formula down to more if it pleases you. I also flipped the order from 35-1 to 1-83 in order to accommodate space for the other tests. Otherwise this is just an excel copy of the google spreadsheet posted by @ninaleaoishi762.
https://docs.google.com/spreadsheets/d/e/2PACX-1vRLuIqvob-_btQ6jj9UHbNTwj4BTek2EMKNCoLIh_ARxjKG3JYrrczHMMG9HHMsIUEnn92P3fnC7kes/pub?output=xlsx
@aburk3611 said:
@ninaleaoishi762 That's awesome! As someone not extremely familiar with Excel or Google Sheets, how do you extend the formatting? Say for the LG's how would you "drag" the formatting downwards for more PTs?
You highlight the part that you want to repeat (probably 8 rows here to keep the alternating color). Then you use the little square in the bottom right corner of the cell to drag down the formula as far as you want.
@aburk3611 said:
@ninaleaoishi762 That's awesome! As someone not extremely familiar with Excel or Google Sheets, how do you extend the formatting? Say for the LG's how would you "drag" the formatting downwards for more PTs?
Personally, I just copy and paste! (Select all the cells you want to copy, click on the upper left-hand cell of the area you want to add them to, paste).
@ninaleaoishi762 That's awesome! As someone not extremely familiar with Excel or Google Sheets, how do you extend the formatting? Say for the LG's how would you "drag" the formatting downwards for more PTs?
Here's mine! Actually my master sheet:
https://docs.google.com/spreadsheets/d/1yK-ux9iLzRF8c4zfJieZC7cXNuzPaAWEJtwT6BWVzxA/edit?usp=sharing
LG fool proof sheet (+ a column for blacking out/tracking which of the PT1-35 LG's you've done)
PT tracker
RC tracker
RC analysis (I like to make myself type out the explanations for the Q's I get wrong)
LR tracker
LR analysis
I just made one that has columns identifying: date; PT#; section#; score (xx/xx).