Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




Parts Per Million Formula
I need to generate a 6 month rolling PPM formula and I have no idea where to
start. It needs to automatically select the last six months of data and calculate it into PPM accurately. any help would be greatly appreciated. 
#2




Answer: Parts Per Million Formula
Sure, I can help you with that!
First, let's start with the formula for calculating PPM: PPM = (defective units / total units) x 1,000,000 To generate a 6 month rolling PPM formula, you'll need to follow these steps:
That's it! Your PPM formula should now be calculating the last six months of data and updating automatically as new data is added. Let me know if you have any questions or need further clarification.
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.misc




Parts Per Million Formula
you'll need to send more data
or send me a copy of the file direct  Greetings from New Zealand "Rachel" wrote in message ... I need to generate a 6 month rolling PPM formula and I have no idea where to start. It needs to automatically select the last six months of data and calculate it into PPM accurately. any help would be greatly appreciated. 
#4
Posted to microsoft.public.excel.misc




Parts Per Million Formula
The formula is generally the amount rejected/the amount shipped*1000000, with
an if then statement preceding that says IF(amount shipped=0,0. My data is organized in columns with headers of the months april to december with the amount shipped and rejected for each company under each month. So in total theres nine months, but i need to build the formula to function even if more months are added. I know its hard to explain, but im not very familiar with this forum and i dont know how to post an attchment of the file for you to take a look at. "Bill Kuunders" wrote: you'll need to send more data or send me a copy of the file direct  Greetings from New Zealand "Rachel" wrote in message ... I need to generate a 6 month rolling PPM formula and I have no idea where to start. It needs to automatically select the last six months of data and calculate it into PPM accurately. any help would be greatly appreciated. 
#5
Posted to microsoft.public.excel.misc




Parts Per Million Formula
Rachel
By "direct" I meant.... send me a copy of the file to my email address. By the way.... the end result is it going to be an average of the ppm's per month or is it a recalculated ppm of "the total send" divided by "the total rejected" for the 6 months Bill K "Rachel" wrote in message ... The formula is generally the amount rejected/the amount shipped*1000000, with an if then statement preceding that says IF(amount shipped=0,0. My data is organized in columns with headers of the months april to december with the amount shipped and rejected for each company under each month. So in total theres nine months, but i need to build the formula to function even if more months are added. I know its hard to explain, but im not very familiar with this forum and i dont know how to post an attchment of the file for you to take a look at. "Bill Kuunders" wrote: you'll need to send more data or send me a copy of the file direct  Greetings from New Zealand "Rachel" wrote in message ... I need to generate a 6 month rolling PPM formula and I have no idea where to start. It needs to automatically select the last six months of data and calculate it into PPM accurately. any help would be greatly appreciated. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
1 Million Rows ??  New Users to Excel  
10 million appears as 10,000,000.00  Excel Discussion (Misc queries)  
How do I set up a formula for parts (or units) per hour?  Excel Worksheet Functions  
Make 1 Million Dollars $$  New Users to Excel  
format degrees, mg/l, parts per million  Excel Discussion (Misc queries) 