Forum Discussion

chytrid's avatar
chytrid
Copper Contributor
Nov 10, 2020
Solved

adding batch data to excel

Hi all, 

 

I need to keep track of ~10 labs worth of media batches, and within that, around 10-20 different types of media. I'm already using excel to present our clinic success rates, and would like to present this data in the same file. 
Would someone please suggest the best way I could do this? originally i was thinking with an inserted calendar, but I think this might display too messily?

 

Thank s everyone for the help!

excel

7 Replies

    • chytrid's avatar
      chytrid
      Copper Contributor
      Nov 11, 2020

      Ramiz_Assaf 

       

      Sure! Thank you for your reply. 

       

      So for example, I have a single batch of media A with the lot number 5678, which I will start today. I also have media B, C, D and E with their own lot numbers, which I will start at some stage this week. Then there are 9 other labs, also with the same *type* of media, and potentially the same lot numbers, but they might start their media on a different day to my lab. 

       

      I need to a) trace the use of a single lot number, ie when it was opened and when it was finished, and b) compare that against what media our  other labs were using at the same time. 

       

      I assumed it would easier to visualize this on a calendar-style display, but if you have any suggestions I would really appreciate it.

       

      TIA

Resources