LR/RC Tracker/Spreadsheet

Comments

• sbc.mom_3x Alum Member

  January 2018 1501 karma

  I just made one that has columns identifying: date; PT#; section#; score (xx/xx).
• 5 Likes

  hawaiihi Free Trial Member

  January 2018 973 karma

  Here's mine! Actually my master sheet:

  https://docs.google.com/spreadsheets/d/1yK-ux9iLzRF8c4zfJieZC7cXNuzPaAWEJtwT6BWVzxA/edit?usp=sharing

  1. LG fool proof sheet (+ a column for blacking out/tracking which of the PT1-35 LG's you've done)
  2. PT tracker
  3. RC tracker
  4. RC analysis (I like to make myself type out the explanations for the Q's I get wrong)
  5. LR tracker
  6. LR analysis
• Mindful Monkey Member

  January 2018 136 karma

  @hawaiihi 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?
• 1 Like

  hawaiihi Free Trial Member

  January 2018 973 karma

  @"Mindful Monkey" said:
  @hawaiihi 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).
• 2 Likes

  Seeking Perfection Alum Member

  January 2018 4428 karma

  @"Mindful Monkey" said:
  @hawaiihi 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.
• 1 Like

  Seeking Perfection Alum Member

  January 2018 4428 karma

  @"Seeking Perfection" said:

  @"Mindful Monkey" said:
  @hawaiihi 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 @hawaiihi.

  https://docs.google.com/spreadsheets/d/e/2PACX-1vRLuIqvob-_btQ6jj9UHbNTwj4BTek2EMKNCoLIh_ARxjKG3JYrrczHMMG9HHMsIUEnn92P3fnC7kes/pub?output=xlsx
• 1 Like

  hawaiihi Free Trial Member

  January 2018 973 karma

  @"Seeking Perfection" said:

  @"Seeking Perfection" said:

  @"Mindful Monkey" 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 @hawaiihi.

  https://docs.google.com/spreadsheets/d/e/2PACX-1vRLuIqvob-_btQ6jj9UHbNTwj4BTek2EMKNCoLIh_ARxjKG3JYrrczHMMG9HHMsIUEnn92P3fnC7kes/pub?output=xlsx

  Ugh, beautiful! I didn't think of that.
• Mia Fairweather Alum Member

  February 2018 221 karma

  Thanks guy these are beautiful and I love that you guys were able to bounce ideas off each other! @hawaiihi what is the PT'D? section for??
• hawaiihi Free Trial Member

  February 2018 edited February 2018 973 karma

  @"Mia Fairweather" said:
  @hawaiihi 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!
• Mia Fairweather Alum Member

  February 2018 221 karma

  @hawaiihi Gotcha!