A Field Perspective on Engineering Commissioning Resources
  • Home
    • What's New
  • Blog
    • Blog Support
  • SketchUp Models
    • SketchUp Resources
    • Bureaucratic Affairs Building HHW System Logic Exercise
    • Bureaucratic Affairs Building Scavenger Hunt
    • Chilled Water Plant System Diagram Exercise
    • The HIjend Hotel >
      • Chilled Water Plant Scoping Exercise
      • Ballroom AHU Scoping Exercise
      • Cooling Tower Scoping Exercise
  • Tools
    • Altitude Correction Factor
    • Economizer Evaluation Checklist
    • Eikon for Educators and WindLGC
    • Effective Duct Length Tool
    • Excel Third Axis Tool
    • Excel Time Value Conversion
    • Insulation Savings Tools
    • Logic Diagram Tool
    • Mixed Air Calculations
    • Monitoring Plan Spreadsheet
    • Pipe Friction Chart
    • Plot Digitizer >
      • Plot Digitizer Pump Curve Example
    • Square Law Spreadsheet
    • System Diagram Symbols
    • Thermodynamic Diagrams Spreadsheet
    • Universal Translator Data Analysis Tool
    • y = (m * x) + b Spreadsheet
  • Useful Formulas
    • Affinity Laws
    • Circular Equivalent Duct
    • Effective Duct Length
    • FT Guide Appendix C
    • HVAC Equations and Concepts
    • Hydraulic Diameter
    • Pump Power and Energy
    • "Square Law"
  • What's That Thing?
    • Cooling Towers
    • Pumps
    • Valves
  • Resources
    • Bill Coad's Writings
    • Data Logging Resources
    • EBCx Skills Guidebook
    • Energy Design Resources
    • Fisher Controls Valve Cavitation Bulletin
    • Functional Testing Guide
    • Honeywell Gray Manual
    • MCC Powers Bulletins
    • NBCIP Reports
    • PEC Tool Lending Library
    • PID Resources
    • Pneumatic Control Resources
    • Resource List
    • Scoping Resources
    • TAB Resources
    • Vintage Carrier Design Manual
    • VRF Systems
    • Williams' Wisdom
  • Videos
    • Bureaucratic Affairs HHW Logic Answers
    • Cooling Tower Flow Variation
    • Economizer Stratification
    • Functional Testing
    • Induction Principles
    • Monitoring Plans
    • Ripple Effects
    • Testing a Pump
    • The Garden of Low Entropy
    • Variable Flow Systems
  • Training
    • Materials from Classes and Presentations >
      • ACEEE
      • ASHRAE
      • ASHRAE - Engineers Notebook
      • BCxA and NCBC
      • BEST Institute
      • Case Studies
      • ERDC 2020 RCx Academy
      • ELPNW
      • ICEBO
      • Marriott AEP
      • Magazine Articles
      • NAVFAC
      • Pacific Energy Center Design, Performance and Commissioning Issues Classes >
        • PEC Class Materials Archive
      • Pacific Energy Center EBCx Project Review
      • Pacific Energy Center EBCx Workshop Series >
        • EBCx Workshop Series 12
        • EBCx Workshop Series 13
        • EBCx Workshop Series 14
        • EBCx Workshop Series 15 >
          • Student One On One Discussions
        • EBCx Workshop Series 16
        • EBCx Workshop Series 17
      • Portland General Electric
      • U of W >
        • U of W Archive
    • On Demand Training >
      • Fans, Ducts and AHUs
      • Induction Motor Principles
      • Introduction to Functional Testing
      • Scope of Work Documents
    • Training Opportunities
  • Contact
    • Copyright and Permissions
  • Home
    • What's New
  • Blog
    • Blog Support
  • SketchUp Models
    • SketchUp Resources
    • Bureaucratic Affairs Building HHW System Logic Exercise
    • Bureaucratic Affairs Building Scavenger Hunt
    • Chilled Water Plant System Diagram Exercise
    • The HIjend Hotel >
      • Chilled Water Plant Scoping Exercise
      • Ballroom AHU Scoping Exercise
      • Cooling Tower Scoping Exercise
  • Tools
    • Altitude Correction Factor
    • Economizer Evaluation Checklist
    • Eikon for Educators and WindLGC
    • Effective Duct Length Tool
    • Excel Third Axis Tool
    • Excel Time Value Conversion
    • Insulation Savings Tools
    • Logic Diagram Tool
    • Mixed Air Calculations
    • Monitoring Plan Spreadsheet
    • Pipe Friction Chart
    • Plot Digitizer >
      • Plot Digitizer Pump Curve Example
    • Square Law Spreadsheet
    • System Diagram Symbols
    • Thermodynamic Diagrams Spreadsheet
    • Universal Translator Data Analysis Tool
    • y = (m * x) + b Spreadsheet
  • Useful Formulas
    • Affinity Laws
    • Circular Equivalent Duct
    • Effective Duct Length
    • FT Guide Appendix C
    • HVAC Equations and Concepts
    • Hydraulic Diameter
    • Pump Power and Energy
    • "Square Law"
  • What's That Thing?
    • Cooling Towers
    • Pumps
    • Valves
  • Resources
    • Bill Coad's Writings
    • Data Logging Resources
    • EBCx Skills Guidebook
    • Energy Design Resources
    • Fisher Controls Valve Cavitation Bulletin
    • Functional Testing Guide
    • Honeywell Gray Manual
    • MCC Powers Bulletins
    • NBCIP Reports
    • PEC Tool Lending Library
    • PID Resources
    • Pneumatic Control Resources
    • Resource List
    • Scoping Resources
    • TAB Resources
    • Vintage Carrier Design Manual
    • VRF Systems
    • Williams' Wisdom
  • Videos
    • Bureaucratic Affairs HHW Logic Answers
    • Cooling Tower Flow Variation
    • Economizer Stratification
    • Functional Testing
    • Induction Principles
    • Monitoring Plans
    • Ripple Effects
    • Testing a Pump
    • The Garden of Low Entropy
    • Variable Flow Systems
  • Training
    • Materials from Classes and Presentations >
      • ACEEE
      • ASHRAE
      • ASHRAE - Engineers Notebook
      • BCxA and NCBC
      • BEST Institute
      • Case Studies
      • ERDC 2020 RCx Academy
      • ELPNW
      • ICEBO
      • Marriott AEP
      • Magazine Articles
      • NAVFAC
      • Pacific Energy Center Design, Performance and Commissioning Issues Classes >
        • PEC Class Materials Archive
      • Pacific Energy Center EBCx Project Review
      • Pacific Energy Center EBCx Workshop Series >
        • EBCx Workshop Series 12
        • EBCx Workshop Series 13
        • EBCx Workshop Series 14
        • EBCx Workshop Series 15 >
          • Student One On One Discussions
        • EBCx Workshop Series 16
        • EBCx Workshop Series 17
      • Portland General Electric
      • U of W >
        • U of W Archive
    • On Demand Training >
      • Fans, Ducts and AHUs
      • Induction Motor Principles
      • Introduction to Functional Testing
      • Scope of Work Documents
    • Training Opportunities
  • Contact
    • Copyright and Permissions

Plot Digitizer Example

 What follows is an example of a digitized pump curve I created using Plot Digitizer and a spreadsheet template that I developed that makes it pretty easy to take the CSV files you get from Plot Digitizer and load them into the spreadsheet so they show up in a chart with out a lot of effort to select series, format things, etc.   I include a link to a copy of the spreadsheet at bottom of the page along with a video illustrating the basic steps for using plot digitizer to generate the raw CSV files you would need in order to use it.  The template itself has instructions in the various tabs that tell you how to use it once you have the CSV data.

The purpose of the spreadsheet template is to allow you to take the very basic CSV data generated by plot digitizer for say, an impeller line, which looks like this ...
Picture
...  and combine it with other, similar files for other lines on the chart to reproduce the pump curve as a chart/graph in an Excel spreadsheet.
Picture
The  value in making that effort is that you can now easily plot other data that you may be of interest in the context of analyzing a pump directly on the chart using standard Excel charting techniques.   

For example, perhaps you have run into a pump out in the field with a throttled valve on its discharge and you want to assess what your options are in terms of optimizing it to eliminate the wasted energy associated with pumping the design flow through a throttled discharge valve.  A common way of performing this analysis is to plot various conditions on the pump curve and use the that information for energy and power calculations for each of the operating points you are exploring.  

The typical starting point for such an analysis is to plot the design operating point and system curve on the pump curve.  In the olden days, we would accomplish that by making a table on a piece of graph paper that had a column for flow and a column for head.  The, we would use the "square law" to calculate a number of points on the system curve based on our design operating point using a slide rule or a calculator, fill in the table, and then manually plot the results on a paper copy of the chart.

Now-a-days, most of us would do the system curve math in an electronic spreadsheet, at least that is what I would do.  The image to the left below is an example of that.  ​But before I discovered Plot Digitizer, I still had to plot that data on a paper copy of the chart, or an image of it so I could perform the analysis.   I while back now, I started using an image of the curve loaded into PowerPoint instead of literally drawing on paper for a number of reasons.  The PowerPoint slide to the right below is an example of what that might look like (for a different pump from the one associated with the curve above).
Picture
Spreadsheet Calculation Example: The known values are entered into the yellow cells and formulas in the other cells reference them and use the square law to calculate points on the system curve based on arbitrarily selected flow values.
Picture
But if you have used Plot Digitizer to create a chart representing the pump curve in Excel,  you can easily plot the system curve and other data that you may be of interest in the context of analyzing a pump directly on the chart using standard Excel charting techniques.  In the images below, I used this approach to compare an impeller trim (left) to a speed change (right) for optimizing a pump that had a throttled valve on its discharge.
Picture
Picture
If you only needed to plot a design point and a system curve, the probably the old-fashioned way will be faster.  But, on the other hand, once you have digitized a curve, you will have it to use for any project with that pump on it moving forward.   So there can be an economy of scale in addition to a reduction in the time required to do a specific analysis if multiple calculations and plots will be required, as might be the case for the analysis of a variable flow pumping system or fan system.
​
The link that follows will take you to the template I use as the starting point for my Pump Digitizer Pump and Fan Curves.
Digitized Pump Curve Example (pump_curve_starting_point_vweb.xlsx)
File Size: 199 kb
File Type: xlsx
Download File

​The video below is a very informal screen capture I made to show one of our Office Admins how to perform the digitization process.  That is a win for both of us because she appreciates the work and it saves me the time and allows me to focus on other stuff while she does the basic digitization effort.  In fact, since the point in time where I made the video, she has learned to take the template I am providing here and get the raw data into the chart, saving me even more time.   

Home

Blog

Resources

Contact

Picture
A Field Perspective on Engineering - © 2017 Facility Dynamics Engineering, All Rights Reserved
(Contact Me to Check on Lefts or Any Other Questions You May Have about Permissions)