Week 9 : Export data to Excel file

            

We use the New Report.Vi in the diagram (on the left ) to specify the template given by the operator to save the data exported inside the template. 

                                                  This is how we connect the New Report .Vi .

The VIs in the both diagrams above are Excel Easy Table.Vi and Excel Bring to Front.Vi.

 

This diagram shows how we connect the Excel Easy Table.Vi in the program.It use to store the data exported to specified rows and columns.

 

We export the data to the excel template given by operator accordingly. 

 

We have modified the original template given and add in more measurements ( e.g  frequency, RMS, etc. ). In addition,we also generate some formulas to calculate the total input power for both open circuit test and short circuit test. As we all can see from the above diagram, the results for section 3.4.1 ,3.4.2, 3.6 and 3.7 are successfully filled in.

   

 

Our next job is to improve our program by creating a diagnostic program to check the communication,errors and instruments every time before the operators run the real test. With this program, we are able to save lots of time in troubleshooting.