Warren,
Sorry to be the bearer of bad news, but it looks to me like your PA data and your AoA data are hosed on your last spreadsheets.
It looks like one or two other pieces of data are interspersed with the PA data. If you calculate & plot a running average vertical speed from the PA data (just subtract each value from the previous one (giving one second sampling), you'll see the spikes. Three up spikes and then one down spike & the pattern repeats. Periodically, the pattern reverses (3 down & 1 up), so it may be the same data that's stepping on your PA data.
Is there something else that shares this frame slot with the PA?
OK, I found your m = .175781 and b=0, in the 757-3b_1 text under "indicated AoA".
It also shows "corrected AoA" scaling factors as "m = 0.35156 & b = 0".
What is the definition of the difference between "indicated" & "corrected" AoA? (And, ap, why the hell are they showing the pilot anything other than "corrected AoA"?)
But you say that you don't use this conversion, but rather the one in
D226A101-3G.pdf.
Unfortunately, the version of that which I've downloaded doesn't contain the text info. It seems to be a bunch of picture files, and therefore the search function doesn't work.
My personal search function (looking in the table of contents) seems to be coming up short too. No info seen on Indicated AoA. Or AoA of any sort.
Is this only the file that I've downloaded? Do you have the text encoding and search function working in your copy of D226A?
Could you post the scaling & offset numbers that you did use for the figuring indicated & correcte AoA.
Regardless, the numbers in the spreadsheet just don't make any sense.
If you plot the pitch angle and AoA vs. time during the take off roll & climb out, you'll see that the trends are OK. This tells you that this is not a sign issue. The sign of the multiplier is correct (positive). It also suggests that the offset is not zero for some reason. (But just using a different multiplier won't fix the problem.)
But it looks like there is about a -15 to -20 degree offset to the AoA. The data says that the AoA stays negative all thru the climb out.
As my petulant 6 year old niece used to say, "I don't think so... " (Complete with foot stamp.)
Good luck digging up the problem. "You're doing a heluva job, Brownie."
Tom