<html><head></head><body bgcolor="#FFFFFF"><div>So it does! Thanks, José! If you're ever near San Francisco, drinks are on me.</div><div><br></div><div>Dave<br><br>On Oct 13, 2011, at 8:40 AM, Arthur Rowe <<a href="mailto:arthur.rowe@nottingham.ac.uk">arthur.rowe@nottingham.ac.uk</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><span style="font-face: Helvetica; ">Dave - Jose's method works fine - although doing a 'copy and paste' from the email is not a good idea - hidden characters get imported. Just go to 'New Function' and re-type before hitting 'to Menu'.<br><br>Arthur<br><br>*******************************************************************************<br>Arthur J Rowe<br>Professor of Biomolecular Technology / Director NCMH Business Centre<br>School of Biosciences<br>University of Nottingham<br>Sutton Bonington<br>Leics LE12 5RD<br><br>TEL: 0115 9516156<br>*******************************************************************************<br><br>On Oct 13, 2011, at 14:19, Dave wrote:<br><br></span><blockquote type="cite"><span style="font-face: Helvetica; ">Hi Jose,<br> Thanks! I'll give it a try. I haven't done much with writing programs in pro Fit, maybe I should expand my repertoire!<br><br>Dave<br>On Oct 13, 2011, at 12:10 AM, Jose Ignacio Espeso wrote:<br><br></span><blockquote type="cite"><span style="font-face: Helvetica; ">What about using a simple program? It could be as easy as this one:<br><br></span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">program</span><span style="font-face: Helvetica; font-size: 11pt; "> RunningSum;</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">var</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> i,col1,col2:</span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">integer</span><span style="font-face: Helvetica; font-size: 11pt; ">;</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> sum:</span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">extended</span><span style="font-face: Helvetica; font-size: 11pt; ">;</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">begin</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(30, 167, 68, 1); font-size: 11pt; ">Input</span><span style="font-face: Helvetica; font-size: 11pt; ">(</span><span style="font-face: Helvetica; color: rgba(120, 120, 120, 1); font-size: 11pt; ">'Input Column'</span><span style="font-face: Helvetica; font-size: 11pt; ">,col1,</span><span style="font-face: Helvetica; color: rgba(120, 120, 120, 1); font-size: 11pt; ">'Output Column'</span><span style="font-face: Helvetica; font-size: 11pt; ">,col2);</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> sum:=0;</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">for</span><span style="font-face: Helvetica; font-size: 11pt; "> i:=1 </span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">to</span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(30, 167, 68, 1); font-size: 11pt; ">nrRows</span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">do</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">if</span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(30, 167, 68, 1); font-size: 11pt; ">DataOK</span><span style="font-face: Helvetica; font-size: 11pt; ">(i,col1) </span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">then</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">begin</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> sum:=sum+</span><span style="font-face: Helvetica; color: rgba(30, 167, 68, 1); font-size: 11pt; ">data</span><span style="font-face: Helvetica; font-size: 11pt; ">[i,col1];</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(30, 167, 68, 1); font-size: 11pt; ">data</span><span style="font-face: Helvetica; font-size: 11pt; ">[i,col2]:=sum;</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; font-size: 11pt; "> </span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">end</span><span style="font-face: Helvetica; font-size: 11pt; ">;</span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; color: rgba(39, 11, 211, 1); font-size: 11pt; ">end</span><span style="font-face: Helvetica; font-size: 11pt; ">;</span><span style="font-face: Helvetica; "><br><br><br> /~~~~~~~~~~~~~~~~~~~~~~~~~~\<br> | Jose I. ESPESO | A/~~~\A<br> | Dpto. CITIMAC | ((o o))___ <br> | Universidad de Cantabria | \ / ~~~<br> # | 39005 Santander | # (---)\ # <br>-#--x---| SPAIN |----#-x---x---x---#---<br> # \_________________________/ # \ # <br>-#--x------| |--#---x---x---x-| |--x-------x---x---x---#-x---x---x---#---<br> #(// \\) | | )#(// \\)(// \\) | | (// \\)(// \\)(/ \)(/ \) # (// \\)(// \\) #<br><br><br>El 11/10/2011, a las 22:42, Dave Sopchak escribió:<br><br></span><blockquote type="cite"><span style="font-face: Helvetica; ">Hi all,<br><br>Is there a way to do a "running sum" of a column in pro fit? I mean, display the total of all values in a column thus far in the column next to it?<br><br>Nothing jumped out at me immediately. I know this is kind of a spreadsheet thing to do, but it would help if I could do this all in pro fit.<br><br>Thanks for any and all…<br><br>Dave<br><br><br>_______________________________________________<br><br>proFit-list mailing list<br></span><span style="font-face: Helvetica; color: rgba(0, 0, 237, 1); "><a href="mailto:proFit-list@quantum-soft.com">proFit-list@quantum-soft.com</a></span><span style="font-face: Helvetica; "><br></span><span style="font-face: Helvetica; color: rgba(0, 0, 237, 1); "><a href="http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com">http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com</a></span><span style="font-face: Helvetica; "><br></span></blockquote><span style="font-face: Helvetica; "><br>_______________________________________________<br>proFit-list mailing list<br></span><span style="font-face: Helvetica; color: rgba(0, 0, 237, 1); "><a href="mailto:proFit-list@quantum-soft.com">proFit-list@quantum-soft.com</a></span><span style="font-face: Helvetica; "><br><a href="http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com">http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com</a><br></span></blockquote><span style="font-face: Helvetica; ">_______________________________________________<br>proFit-list mailing list<br><a href="mailto:proFit-list@quantum-soft.com">proFit-list@quantum-soft.com</a><br><a href="http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com">http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com</a><br><br></span></blockquote><span style="font-face: Helvetica; "><br></span></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>proFit-list mailing list</span><br><span><a href="mailto:proFit-list@quantum-soft.com">proFit-list@quantum-soft.com</a></span><br><span><a href="http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com">http://quantum-soft.com/mailman/listinfo/profit-list_quantum-soft.com</a></span><br></div></blockquote></body></html>