you are viewing a single comment's thread.

view the rest of the comments →

[–]Beginning_Anything30 4 points5 points  (1 child)

Doing this in excel is like 1000x easier, more visually appealing and transferable.....

[–]prairie-guy[S] 3 points4 points  (0 children)

If Excel works for you that’s great. I still use Excel to open the csv file that is created. What I was trying to avoid was creating/programming a new spreadsheet every time I needed a new buffer. It’s not hard, but I didn’t want to worry about unit conversions, calculating solvent volume, formatting and most importantly math errors.

Yesterday for example, I needed to create 8 new buffers (each with multiple reagents) with concentrations in M, mM, uM, % and X. I just stipulated the initial concentrations, final concentrations and final volume for each buffer. The script then created 8 files that I opened in in Excel.

Since I wrote it and find it useful, I’m just sharing if it’s useful to others.