Hello,
I am performing 96-well microtiter plate antimicrobial susceptibility testings. Right now, I already have a huge load of positive and negative results. I´ve been documenting these results through tables in Microsoft word files.
However, I´d like to save my results more efficient with less time required . Therefore, I am looking for an excel file - if possible with a "check function" for positive hits at the determined position/concentration of the 96-well design (like a classical checklist) - that i can modify according to my needs.
In the past, I have designed excel files with automatic check-lists, so I know how much work it is and I´d like to skip this step. There are so many people working on susceptibility tests with 96-well plates, so I am hoping that there is someone who can help me out with a crude template.
Preferably with A-H on top and 1-12 on the side.
Sorry, I do not have such a file; I just wonder why you include all 96 wells in the documentation - for all my purposes, I got along with documenting just the MIC (maybe with a commentary column in case some wells are skipped, in order to document that the test needs to be repeated). So could you explain what is the purpose to document +/-growth results per well? For benchtop documentation, I found it most comfortable to have a copy of the panel design (A-H /1-12, substances and concentration) where I could just mark the MIC manually (in our laboratory, it would not be possible to use the keyboard while we have "hands on" a microbial culture in a 96 well plate, due to work safety reasons). Maybe this helps if you don´t find a check-list-file.
Thanks for your suggestion, Dr. Hölzel. You are right, I only need the MICs..I´ve made an error in reasoning for I used color change as indicator. Here I also have semi-positives and I usually marked positives, semi-positives and negatives manually on a default sheet with the panel design, same as you do with the MICs. Then I transferred the results to the office computer later. I will modify my documentation according to your suggestion, thanks for pointing that out.
- Badges
- Science topic
- Similar topics
- Physical Sciences
- Materials Science
- Materials
- Polymers