Spreadsheet Graphing Templates

One of the export options for machine or work order efficiency reports from Nanospark: CNC Machine Monitor is a “.csv file”. A CSV file is useful for importing data into a spreadsheet where it may placed side-by-side with data from other machines for quick comparison, tracked visually over a length of time or other useful number crunching.

How to use templates:

  1. Open the csv file from the Nanospark Monitor email in a spreadsheet
  2. Open your spreadsheet template
  3. Copy the data from the csv file to the “Paste” sheet of the template
  4. Switch to the “Display” sheet of the template
  5. Save As or Export according to your preference

In the interest of keeping our system as simple as possible, we’ve put together some spreadsheet templates so you can just copy/paste from the csv file into the template.

If you don’t see a template below that targets your need, send us a note (support@nanospark.com) and we’ll see about putting a template together for you.

 


Running Weekly Average Production Hours
In conjunction with a weekly report monitoring the Green Light, this report will chart weekly production hours over the course of a year.

 



Side-by-Side % Comparison, 2 Machines
Wire two machines to your Nanospark: CNC Machine monitor, create a report for three inputs from each machine, paste the data here to compare machine performance. Works will all report time frames.

 


Side-by-Side Comparison with hours, 4 Machines
Wire two inputs from each of four machines to your Nanospark: CNC Machine monitor, create a report which monitors all eight inputs, paste the data here to compare machine performance. Works will all report time frames.

 


Similar posts
  • Job (or Work Order) Efficiency Report... When we started showing Nanospark to shops this spring, one loud feedback we received was the need to track efficiency by the job or work order. Since the foundation had been laid, it was pretty easy for us to adapt by adding the by job reports feature. Further, the way it’s been crafted, “by job” [...]
  • Preventative Maintenance One of the features of Nanospark: CNC Machine Monitor that we tout is how flexible it is in meeting your unique needs. Here’s an example. Senasys, Nanospark’s parent company, is using the Nanospark: CNC Machine Monitor to add an extra layer of assurance to the preventative maintenance program on their Swiss machine. This is in [...]
  • Running Efficiency Snapshots Goal: Get running efficiency reports from your CNC machine throughout a shift. Use a line graph to get a visual indication of the reason for any dip in efficiency. You may wish to see a report part way through a shift or even hour by hour during a shift. The key to getting this is [...]
  • Unattended Operation (Overnight) Goal: Be alerted if your machine experiences an error after hours. Perhaps the error happens early enough in the evening to come in and fix the problem. If it happens in the wee hours of the morning, at least the operator will know that when he walks in the door he needs to go straight [...]