Finally mapped out my first tracking spreadsheet and I am stoked

Posted by quietfox94 in Getting Started Beginners

Hey everyone I just finished organizing all my lab logs into a massive color coded spreadsheet for my subject tracking and I am honestly way too excited about it. For the longest time my notes were just random scraps of paper and sticky notes scattered around my desk which was driving me nuts. Now every single variable from storage temps to daily observations is cleanly laid out. It feels amazing to finally have a proper system in place for the current research phase. Data collection is so much smoother when you are not scrambling to find where you wrote down the last weight check or vial batch number. If you are starting out definitely build the tracker before you even open the first package.

10 Comments

vialdev

Welcome to the spreadsheet master race because there is no turning back once you start color coding everything.

bench2146

I give it three weeks before you abandon the fancy formulas and just go back to a simple text file.

molarstack35

Do not listen to the skeptics, clean data is poetry in motion.

graydev25

Are you tracking barometric pressure too or is that going overboard?

vialfiles

That is hilarious, please do not give people new ideas for overly complicated variables.

echomind

Honestly having a solid database saves you so many headaches later when you try to look back at old vial lots.

quietfox94

Right, exactly, I feel like a mad scientist in the best way possible now.

amberrat

If you are not tracking lunar phases does your data even count?

protocol88

Jokes aside make sure you back up that file to cloud storage because losing a hard drive hurts deep down.

biohackguy72

Pro tip add conditional formatting so your low stock items light up red automatically.