I am an Igor noob, so please bear with me. I work with lithium ion batteries and my electrochemical test equipment spits out a huge excel sheet containing 40 - 60 steps of a battery test file (cycling, impedance, etc.). How can I go about using Igor to sort through the data and divide it up? Thanks in advance for any help!
Next, as to your question, you haven't provided enough information for anyone who isn't extremely familiar with your exact situation to provide a useful answer. http://stackoverflow.com/help/how-to-ask is a good guide that will help you formulate your question in a way that it can have an answer that is useful to you.
If you know someone that uses Igor with data similar to yours, you may wish to talk with them about how to get started analyzing your data.
August 15, 2016 at 07:36 am - Permalink
August 15, 2016 at 08:26 am - Permalink
I've used Igor quite a bit for analyzing electrochemical data, usually for CV sweeps or chronopotentiometry but also a little EIS. My approach was usually to export the potentiostat data to a text file then use an Igor procedure to parse that text file into the appropriate waves with meaningful names. Let me know if you'd like to see an example procedure. The best way to process the data depends highly on the potentiostat software (I used Gamry, Modulab, and Jaissle models).
However, it would be worth your time to look into the Excel file loading capabilities. In the GUI that's under Data - Load Waves - Load Excel File, or you can get more detail in the help browser command help for "XLLoadWave".
August 15, 2016 at 08:26 am - Permalink
No simple way to do this without a bit of coding. Here's an example procedure that can create a bunch of subsets of "wave1" based on a step index held in "wave0." You can extend it to your other waves (capacity, time, etc.). Beware however that this can quickly lead to a proliferation of waves in the root folder, so if you want to keep organized, you might want to learn about data folders.
August 15, 2016 at 09:20 am - Permalink
You can duplicate the original waves, and then perform conditional assignment to copy over only certain values.
For instance, you could write:
You can get more complicated by writing a function that navigates the entire list of waves and creates subsets for each step number if you want to, but this logic should help.
August 17, 2016 at 08:46 am - Permalink