--- title: Calculating Interharmonics with Raw Waveform Data description: The Revolution PQ recorder can compute interharmonics in real-time, and also record each one individually as a stripchart. image: https://library.powermonitors.com/hubfs/Blog_Images/blue%20temporary%20header.png --- [![PMI_Logo_White_Slogan](https://library.powermonitors.com/hs-fs/hubfs/Branding%20-%20Logos%20and%20Designs/PMI_Logo_White_Slogan.png?width=655&height=175&name=PMI_Logo_White_Slogan.png "PMI_Logo_White_Slogan")](https://powermonitors.com) [![PMI Logo: Tools you Need. People you Trust.](https://library.powermonitors.com/hubfs/PMI_Website/logo.svg "PMI Logo: Tools you Need. People you Trust.")](http://powermonitors.com) [![PMI Logo: Tools you Need. People you Trust.](https://library.powermonitors.com/hubfs/PMI_Website/logo.svg "PMI Logo: Tools you Need. People you Trust.")](http://powermonitors.com) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. - [Home](https://powermonitors.com) - [Products](https://powermonitors.com/products) - Library - Videos - [All](https://powermonitors.com/videos/) - [Bolt Quality Tests](https://powermonitors.com/videos/?video_search=&video_topic=bolt-quality-tests) - [Promotional Videos](https://powermonitors.com/videos/?video_search=&video_topic=promotional-videos) - [Support Videos](https://powermonitors.com/videos/?video_search=&video_topic=support) - [Power Quality Decoded](https://powermonitors.vids.io/tags/1f9bd9b6181b90/ask-a-pro) - White Papers - [All](https://library.powermonitors.com) - [All](https://powermonitors.com/whitepapers/) - [Artificial Intelligence](https://powermonitors.com/whitepapers/?whitepaper_search=Merlin&whitepaper_topic=) - [Case Studies](https://powermonitors.com/whitepapers/?whitepaper_topic=case-studies) - Communications - [All Communications](https://powermonitors.com/whitepapers/?whitepaper_topic=communications) - [Cellular Communications](https://powermonitors.com/whitepapers/?whitepaper_topic=cellular-communications) - [General Communications](https://powermonitors.com/whitepapers/?whitepaper_topic=general-communications) - [Distributed Generation](https://powermonitors.com/whitepapers/?whitepaper_topic=distributed-generation) - Products - [All Products](https://powermonitors.com/whitepapers/?whitepaper_topic=products) - [Boomerang](https://powermonitors.com/whitepapers/?whitepaper_topic=boomerang) - [Boomerang SCADA](https://powermonitors.com/whitepapers/?whitepaper_search=Boomerang+Scada&whitepaper_topic=) - [Box Recorder](https://powermonitors.com/whitepapers/?whitepaper_topic=box-recorder) - [Canvass](https://powermonitors.com/whitepapers/?whitepaper_topic=canvass) - [Eagle](https://powermonitors.com/whitepapers/?whitepaper_topic=eagle) - [Flex CT](https://powermonitors.com/whitepapers/?whitepaper_topic=flex-ct) - [Guardian](https://powermonitors.com/whitepapers/?whitepaper_topic=guardian) - [Merlin™](https://powermonitors.com/whitepapers/?whitepaper_search=Merlin&whitepaper_topic=) - [Meter Sockets](https://powermonitors.com/whitepapers/?whitepaper_topic=meter-sockets) - [PQ Canvass](https://powermonitors.com/whitepapers/?whitepaper_topic=pq-canvass) - [ProVision](https://powermonitors.com/whitepapers/?whitepaper_topic=provision) - [Revolution](https://powermonitors.com/whitepapers/?whitepaper_topic=revolution) - [TLAR](https://powermonitors.com/whitepapers/?whitepaper_topic=tlar) - [Using PMI Recorders](https://powermonitors.com/whitepapers/?whitepaper_topic=using-pmi-recorders) - [Harmonics](https://powermonitors.com/whitepapers/?whitepaper_topic=harmonics) - [IEEE Standards](https://powermonitors.com/whitepapers/?whitepaper_topic=ieee-standards) - Power Quality - [All Power Quality](https://powermonitors.com/whitepapers/?whitepaper_topic=power-quality) - [Analyzing Waveforms](https://powermonitors.com/whitepapers/?whitepaper_topic=analyzing-waveforms) - [Flicker](https://powermonitors.com/whitepapers/?whitepaper_topic=flicker) - [PQ Data Analysis](https://powermonitors.com/whitepapers/?whitepaper_topic=pq-data-analysis) - [PQ Theory](https://powermonitors.com/whitepapers/?whitepaper_topic=pq-theory) - Voltage - [All Voltage](https://powermonitors.com/whitepapers/?whitepaper_topic=voltage) - [CVR](https://powermonitors.com/whitepapers/?whitepaper_topic=cvr) - [Voltage Sag](https://powermonitors.com/whitepapers/?whitepaper_topic=voltage-sag) - [Voltage Unbalance](https://powermonitors.com/whitepapers/?whitepaper_topic=voltage-unbalance) - Training - [All](https://info.powermonitors.com/training) - [PDH Eligible Classes](https://powermonitors.com/product-category/classes/) - [On-Site Training](https://powermonitors.com/on-site-training/) - [Online Webinars](https://info.powermonitors.com/no-cost-class-schedule) - [Support](https://powermonitors.com/support/) - About - [About Us](https://powermonitors.com/about-pmi/) - [Contact](https://powermonitors.com/contact/) - [Join Our Team!](https://info.powermonitors.com/join-pmi) - [Receive our Newsletter](https://info.powermonitors.com/email-subscribe-page) - [PQ Resources](https://info.powermonitors.com/power-quality-resources) - [Power Quality Solutions](https://powermonitors.com/power-quality-solutions/) - [Who We Serve](https://powermonitors.com/sales-representatives/) - [Account](https://powermonitors.com/account/) This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. ![PMI-Logo-Phone-Site-2023-900px](https://library.powermonitors.com/hs-fs/hubfs/PMI-Logo-Phone-Site-2023-900px.png?width=113&name=PMI-Logo-Phone-Site-2023-900px.png "PMI-Logo-Phone-Site-2023-900px") # Calculating Interharmonics with Raw Waveform Data   |   , ## **Portable Spreadsheet-Based Interharmonic Analysis for Power Quality Data** This white paper introduces a spreadsheet tool that enables the calculation of interharmonics from raw waveform data without the need for specialized software or macros. By leveraging only cell formulas, the tool performs a 3072-point FFT, facilitating detailed interharmonic analysis in compliance with IEC 61000-4-7. The approach allows users to analyze data from various PMI recorders, bypassing the limitations of built-in FFT functions and enhancing data portability and accessibility. **Key topics include:** - Introduction to Interharmonic Analysis - IEC 61000-4-7 and Data Capture Requirements - Spreadsheet FFT Implementation - Working with Raw Waveform Data - Step-by-Step Usage Instructions - Case Study: Lab Test and Results **Why utilities should care:** Enables efficient, standards-compliant interharmonic analysis using widely available spreadsheet software, eliminating the need for proprietary tools or IT-intensive macros. This maximizes accessibility, reduces operational costs, and supports comprehensive power quality diagnostics. You may also enjoy...   - - - - ## Speakers ### [Alvin Rogers](https://library.powermonitors.com/calculating-interharmonics-with-raw-waveform-data#inline-content-1speakers)[Follow me on LinkedIn](https://www.linkedin.com/apex-alvinrogers) Director of Sales Omnicorp Alvin Rogers Director of Sales Omnicorp About Alvin Rogers Alvin Rogers is a highly accomplished and sought-after speaker, renowned for their expertise and captivating stage presence. With a diverse background in \[relevant field or industry\], they bring a wealth of knowledge and experience to every speaking engagement. Their dynamic and engaging style seamlessly combines powerful storytelling with actionable insights, leaving audiences inspired and equipped with practical strategies for success. Alvin has delivered impactful keynote addresses at prestigious conferences and corporate events worldwide, consistently receiving rave reviews for their ability to connect with and energize audiences. Whether addressing topics such as \[specific areas of expertise\], leadership, or innovation, Alvin is dedicated to empowering individuals and organizations to reach their full potential. [LinkedIn](https://www.linkedin.com/apex-alvinrogers) [Facebook](https://www.facebook.com/apex-alvinrogers) [Instagram](https://www.instagram.com/apex-alvinrogers) [Twitter](https://www.twitter.com/apex-alvinrogers) ### [Lisa Smith](https://library.powermonitors.com/calculating-interharmonics-with-raw-waveform-data#inline-content-2speakers)[Follow me on LinkedIn](https://www.linkedin.com/apex-lisasmith) Creative Director Megacorp Lisa Smith Creative Director Megacorp About Lisa Smith Lisa Smith is a highly accomplished and sought-after speaker, renowned for their expertise and captivating stage presence. With a diverse background in \[relevant field or industry\], they bring a wealth of knowledge and experience to every speaking engagement. Their dynamic and engaging style seamlessly combines powerful storytelling with actionable insights, leaving audiences inspired and equipped with practical strategies for success. Lisa has delivered impactful keynote addresses at prestigious conferences and corporate events worldwide, consistently receiving rave reviews for their ability to connect with and energize audiences. Whether addressing topics such as \[specific areas of expertise\], leadership, or innovation, Lisa is dedicated to empowering individuals and organizations to reach their full potential. [LinkedIn](https://www.linkedin.com/apex-lisasmith) [Facebook](https://www.facebook.com/apex-lisasmith) [Instagram](https://www.instagram.com/apex-lisasmith) [Twitter](https://www.twitter.com/apex-lisasmith) ### [James McGiven](https://library.powermonitors.com/calculating-interharmonics-with-raw-waveform-data#inline-content-3speakers)[Follow me on LinkedIn](https://www.linkedin.com/apex-jamesmcgiven) President Minicorp James McGiven President Minicorp About James McGiven James McGiven is a highly accomplished and sought-after speaker, renowned for their expertise and captivating stage presence. With a diverse background in \[relevant field or industry\], they bring a wealth of knowledge and experience to every speaking engagement. Their dynamic and engaging style seamlessly combines powerful storytelling with actionable insights, leaving audiences inspired and equipped with practical strategies for success. James has delivered impactful keynote addresses at prestigious conferences and corporate events worldwide, consistently receiving rave reviews for their ability to connect with and energize audiences. Whether addressing topics such as \[specific areas of expertise\], leadership, or innovation, James is dedicated to empowering individuals and organizations to reach their full potential. [LinkedIn](https://www.linkedin.com/apex-jamesmcgiven) [Facebook](https://www.facebook.com/apex-jamesmcgiven) [Instagram](https://www.instagram.com/apex-jamesmcgiven) [Twitter](https://www.twitter.com/apex-jamesmcgiven) Power Monitors, Inc. is an industry-leading product design and manufacturing firm based in Mt. Crawford, Virginia. PMI strives to solve power quality problems by listening to our customers and working with them to design and manufacture products. Total customer satisfaction is the primary goal of all PMI staff. Please browse our site or call us to learn more about PMI and how we can help meet your power monitoring needs.   800 N Main St Mt Crawford, VA 22841 | Toll Free 800.296.4120 | Fax 540.432.9430 | © 2025 Power Monitors, Inc. ###### Follow Us [Follow us on Facebook](https://www.facebook.com/powermonitors/) [Follow us on LinkedIn](https://www.linkedin.com/company/power-monitors) [Follow us on Twitter](https://twitter.com/powermonitors) [Follow us on Instagram](https://info.powermonitors.com/email-subscribe-page) - [Support](https://powermonitors.com/support) - [Library](https://library.powermonitors.com) - [Training](https://info.powermonitors.com/training) - [Contact](https://powermonitors.com/contact/) - [Products](https://powermonitors.com/products/) - [- Bolt](https://powermonitors.com/product/bolt/) - [- Revolution](https://powermonitors.com/product/revolution/) - [- Seeker](https://powermonitors.com/product/seeker/) - [- Guardian](https://powermonitors.com/product/guardian/) - [Careers](https://info.powermonitors.com/join-pmi) - [Terms and Conditions](https://powermonitors.com/terms-and-conditions/)