Excel templates

0. Before we begin

Install the excel template runner by opening a terminal and running

python3 -m pip install syre-excel-template-runner

1. Add the noise_stats.xlsx template to your project

First, click anywhere in the background of the canvas to clear any selections. Then, either

• Drag and drop the noise_stats.xlsx file into the project analyses area, or
• Click the  button to add noise_stats.xlsx as an Excel template

2. Create the noise stats template

1. Click on the column B label twice. This sets the replace range to Sheet1!B:B.

   
2. Select None for how data should be labeled.
3. Select Spreadsheet for the type of data that will be ingested.
4. Set the asset filter type to noise-data.

5. Set the columns to be copied to B.

   

6. Set the file name to noise_stats.
   Set the asset name to Noise Stats.
   Set the type to noise-stats.  

   
7. Click Create template.

3. Create the recipe stats template

1. Add the recipe_stats.xlsx template to the project as described in step 1.

2. Click on the column B label then the column C label. This sets the replace range to Sheet1!B:C.

   
3. Select Replace headers for how data should be labeled.
4. Select Excel for the type of data that will be ingested.
5. Set the  type to noise-stats.
   (Remember, we set the output data to have this type. This is how we can chain the output fro one analysis into the input of another.)

6. Set the worksheet id to Sheet1.
   Set the columns to be copied to E.

   

7. Set the file name to recipe_stats.
   Set the asset name to Recipe Stats.
   Set the type to recipe-stats.  

8. Click Create template.

4. Create the recipe comparison template

1. Add the recipe_comparison.xlsx template to the project as described in step 1.

2. Click on the column B label then the column C label. This sets the replace range to Sheet1!B:C.

3. Select Replace headers for how data should be labeled.
4. Select Excel for the type of data that will be ingested.
5. Set the  type to recipe-stats.
   

6. Set the worksheet id to Sheet1.
   Set the columns to be copied to F.

7. Set the file name to recipe_comparison.
   Set the asset name to Recipe Comparison.
   (Here we dont need to set the type, like we did with the others, because the output won't be consumed by another analysis.)

8. Click Create template.

5. Assign the noise stats template to run on the batch containers.

To tell Syre which scripts to run where, we must assign them to a container.

0. Change the preview mode to Analysis.
   (This isn't necessary to assign scripts, but allows to see what we're doing as we do it.)
1. Bulk select (shift + click) the four batch containers.
2. Click the + button next to the Scripts section.
3. Add the noise_stats.xlsx template.

6. Assign the remaining templates.

You can drag and drop analyses to assign them, too.

0. Clear your selection to show the project analyses panel.
1. Drag and drop the recipe_stats.xlsx tempate on the Recipe A container. Do the same for Recipe B.
2. Assign the recipe_comparison.xlsx template to the data container.

7. Analyze the project.

The time has come! We can finally see how Syre can automatically analyze our data and organize the results.

0. Change to the data preview.
   (Again, this isn't necessary, but makes it easier to see the changes occurring.)
1. Click the Analyze button.
2. There is no second step, that's how easy it is!