Greetings Dan,
one more important “issue” that I noticed on your spreadsheet is highlighted below ...
it looks like you have the control block for your PID located at N10:0 ... so the 23 words of the control block occupy N10:0 through N10:22 ... nothing wrong with that at all ... but ...
your approach of taking the “CV%” reading as the OUTPUT of the PID is highly unorthodox ... normally we use the integer memory location which we’ve listed as the “Control Variable” on the PID instruction (on the ladder rung) as the output of the PID - not word 16 of the PID’s control block ... in Figure 2 of my post #11 I used N7:75 as my “CV” ... in normal operation, the PID will drive this location with values ranging from 0 to 16383 ... this “CV” location is the one that SHOULD be used for the input to your final SCP ... of course your program’s address may be different from my N7:75 example ... I’d suggest N10:29 if you’re not already using it for something else ...
normally the value from the “CV%” is used as a readout display for the operator, etc. ... it tells him (in simple 0 to 100% units) how hard the PID is presently driving the output ...
all of that having been said: I can’t think of anything to actually prevent you from using the “CV%” location (word #16 of the PID control block) and scaling it as you have ... it looks like it should work OK ... but be aware that this approach gives your PID only 100 steps of resolution for its output signal ... not 16383 steps as would normally result from using the “proper” location ... that might be fine for this particular application, but in many (most?) others just 100 steps would not be enough for smooth control ...
as I said, your present approach should work ... but I can assure you that it is NOT commonly done this way in the real world ... since you’re obviously trying to learn as much as possible from this exercise, then I suggest (in the friendliest terms) that you “get in step” with everyone else and use the “CV” and not the “CV%” for your PID’s output ...
there are a few other minor issues with things like your “engineering units”, etc. ... but it’s obvious that you’re still working through those types of things ... I for one am going to let them simmer for awhile ... there’ll be plenty of time to tackle them later if you need help ...
it looks like you’re making a systematic approach to mastering this subject ... if either you or your instructor wants to talk about it by phone, feel free to send me a Private Message with a phone number ... I’ve helped quite a few tech schools with this type of stuff in the past ...