need help in extrapolating to create a chart.

I have a flow chart that works just fine for very large flows but doesn't do the small flows at all. I did this many many years ago cell by cell and hope there is a easier/quicker way of getting a solution. The info that i have is in the pdf file attached. What I need to do is break that down to a flow per 0.01 increments for an excel spreadsheet and then chart it. The spreadsheet is used for automatic data retrevial using a Lookup function.

It's not entirely clear exactly what you need to do, but it sounds like you simply need to add several data points to the existing table, so it will work better as a lookup table for another spreadsheet, is that right?

What kind of algorithm do you want to use to do this? My first thought is to use a linear interpolation algorithm. Linear interpolation isn't difficult, but Excel doesn't have a built in formula for it (some other spreadsheets do, if you aren't bound to Excel), so you have to build the formula (I like to spread this one out over several cells). If this is the way you want to do it, you might put this into the site's search engine, because we discuss this fairly frequently.

You could alternatively use a correlation/regression approach, and build the lookup table that way. If the equation needed to fit the data is not overly complex, this might be the best approach. If you want to go with this approach, and you choose the right function, you can use the LINEST function in Excel to generate the coefficients of the equation, then use that equation with the derived coefficients to build your final lookup table.

And, if I appear to have completely misunderstood your question, I apologize in advance for making suggestions that don't apply.