Several people said our labs’ inventory and purchasing worksheet was just me reinventing Quartzy… well… I guess now it’s just a free and homegrown version of Quartzy 😂 happy to share! 💸
I’m amazed by all of the interest in the sheet… I am having a trouble keeping up with the requests on here, so please send me an email if you want a copy of the spreadsheet!
And here is the thread outlining how we use the spreadsheet #TheLabEdit
Holy moly, y'all really wanted the spreadsheet! If I had charged $159 per person, I would be >$7,000 richer. This spreadsheet will really, REALLY always be free, though... but if we meet in person, I will always accept a free coffee/drink/bagel/sandwich 🤣🙃😁
I'm muting this post now... so... if you want the spreadsheet, send me an email. There is simply not enough time for me to personally email it to everyone who commented asking for it. Hope y'all understand!
Okay - we are up to $25K. That woulda funded a nice RNA seq experiment in the lab! I'm just happy I could contribute to the scientific community. Being organized has saved money, protected the longevity of our lab, and helped reduce anxiety. We know where/what shit is!
• • •
Missing some Tweet in this thread? You can try to
force a refresh
#NewPIHack: I receive frequent emails from spectacular scientists wanting to learn more about UW grad programs, asking for help with their applications, or asking about doing a postdoc in my lab. To streamline my responses and save me time, I generated email templates... 🧵
Re: direct admissions. I am often asked if folks can join my lab for their Ph.D. studies, but we do not do direct admits at UW. You'll have to apply like everyone else, but here is the information 😃
Re: grad program questions. I wish I could help everyone, but if you want specific information about the grad program, the program websites are simply amazing. Same with @ProjectShort and @cientificolatin for providing application help. See for yourself!😁
Week 7: the method behind the madness. My #TheLabEdit tools are inspired by past system failures that created chaos/stress and wasted time/money. I don’t think there is one way to keep track of ordering/inventory, but this is what works for us. (1/n)
Ordering starts on a shared Excel spreadsheet hosted on Google Sheets before going into the Fred Hutch system. Items are added onto the spreadsheet, inputting the date, your name, item category, informal item description, formal item name, vendors, catalog number and a link (2/n)
Is this extra? Maybe, but having the details readily accessible helps know what came from where and makes re-ordering a breeze. I made dropdown for common categories of stuff in the lab. I hope to use this annually to assess spending by category. (3/n)