Tutorials: Spreadsheet App

09212015, 12:03 AM
Post: #1




Tutorials: Spreadsheet App
I have also put this on the HP Prime Tutorial thread.
New! Tutorials: Spreadsheet App HP Prime Spreadsheet Tutorial #1: Sum of a Column of Numbers http://edspi31415.blogspot.com/2015/09/h...1sum.html HP Prime Spreadsheet Tutorial #2: Copying and Pasting Formulas http://edspi31415.blogspot.com/2015/09/h...ial2.html HP Prime Spreadsheet Tutorial #3: Adding Labels, Numeric Calculations, Cell Numeric Format, and Extend Columns http://edspi31415.blogspot.com/2015/09/h...ial3.html HP Prime Spreadsheet Tutorial #4: Naming Columns and Using them Outside of Num View http://edspi31415.blogspot.com/2015/09/h...ial4.html HP Prime Spreadsheet Tutorial #5: Spreadsheets and Histograms http://edspi31415.blogspot.com/2015/09/h...ial5.html 

09222015, 03:56 PM
Post: #2




RE: Tutorials: Spreadsheet App
I can't even get past the simple sum of numbers in tutorial 1. I keep getting a red X with Error: Syntax Error. :(


09222015, 06:37 PM
Post: #3




RE: Tutorials: Spreadsheet App  
09222015, 08:10 PM
Post: #4




RE: Tutorials: Spreadsheet App
That was it. Seems silly to me that inside an app you would have to do this but I'm sure there is a reasonable reason for it...
Thanks! 

09222015, 08:57 PM
(This post was last modified: 09222015 08:58 PM by Tim Wessman.)
Post: #5




RE: Tutorials: Spreadsheet App
(09222015 08:10 PM)ndzied1 Wrote: That was it. Seems silly to me that inside an app you would have to do this but I'm sure there is a reasonable reason for it... Indeed, there is. At its most basic level, RPN is all about immediate evaluation on entry. Provided you want to SAVE an algebraic expression then, how would you create a formula object in RPN? The solution they came up with quite a while back (28S/C I think???) is that you have a QUOTE operator that prevents evaluation. To make it simpler, they used ' ' around something to mean quote. Thus in RPN you can do something like 'Y=X+2' and create a formula (algebraic object). It sees the ' and says "Aha. The user wants me to not evaluate the next stuff until I reach a closing ' mark". When creating the spreadsheet, we wanted you to have the ability to user RPN in there if so desired. Thus any time you are trying to store the FORMULA rather then an immediate evaluation we used the same syntax. All you are really doing in a spreadsheet with the =A1+B3 or similar is creating a formula you'd like stored in that location. Since RPN already had the syntax for this... we felt we really should use it. TW Although I work for HP, the views and opinions I post here are my own. 

09242015, 01:42 AM
Post: #6




RE: Tutorials: Spreadsheet App
(09222015 06:37 PM)John Colvin Wrote:(09222015 03:56 PM)ndzied1 Wrote: I can't even get past the simple sum of numbers in tutorial 1. I keep getting a red X with Error: Syntax Error. :( I didn't even think about RPN mode when using the spreadsheet. I am assuming that people are in Algebraic mode since it is closer to computer spreadsheet programs. 

09242015, 01:44 AM
Post: #7




RE: Tutorials: Spreadsheet App
Wish list for the Spreadsheet App:
1. Sort Function. Sort columns or blocks of data using any column as an anchor. 2. The ability to convert spreadsheets between HP Prime format to .csv files in the Connectivity Kit. I am working on my second batch of tutorials this week. 

09242015, 03:27 AM
Post: #8




RE: Tutorials: Spreadsheet App
(09242015 01:44 AM)Eddie W. Shore Wrote: Wish list for the Spreadsheet App: I'm looking forward to them. I found your spreadsheet tutorials very helpful. 

09252015, 03:41 PM
Post: #9




RE: Tutorials: Spreadsheet App
(09242015 03:27 AM)Skyblues Wrote:(09242015 01:44 AM)Eddie W. Shore Wrote: Wish list for the Spreadsheet App: Thank you! 

09252015, 03:43 PM
Post: #10




RE: Tutorials: Spreadsheet App
HP Prime Spreadsheet Tutorial #6: Row and Column References in Formulas
http://edspi31415.blogspot.com/2015/09/h...6row.html HP Prime Spreadsheet Tutorial #7: Absolute References (Post 500) http://edspi31415.blogspot.com/2015/09/h...ial7.html HP Prime Spreadsheet Tutorial #8: Statistical Analysis http://edspi31415.blogspot.com/2015/09/h...ial8.html HP Prime Spreadsheet Tutorial #9: Custom Functions and the AMORT Function http://edspi31415.blogspot.com/2015/09/h...ial9.html 

09252015, 05:39 PM
Post: #11




RE: Tutorials: Spreadsheet App
(09252015 03:43 PM)Eddie W. Shore Wrote: HP Prime Spreadsheet Tutorial #6: Row and Column References in Formulas Eddie, You might consider copying these items into your first post in this thread so that they are all available in the same place. Thanks for your tutorials! Jonathan 

09252015, 06:17 PM
Post: #12




RE: Tutorials: Spreadsheet App
(09242015 03:27 AM)Skyblues Wrote:(09242015 01:44 AM)Eddie W. Shore Wrote: Wish list for the Spreadsheet App: I would prefer the ability to import/export a spreadsheet to/from a CSVformatted Note to be available onPrime, not just in the CK. Of course a user program could be written, but it would be convenient to just call a procedure. Stephen Lewkowicz (G1CMZ) https://my.numworks.com/python/steveg1cmz 

09262015, 12:15 PM
Post: #13




RE: Tutorials: Spreadsheet App
Eddie:
How about doing a tutorial on external referencing methods for customizing a spreadsheet? For example: Referencing Cell(0,0) Sheet definitions, where an optional third number relates to specific parameters, i.e, Cell(0,1,2):="Column A Titlename", Cell(0,2,2):="Column B Titlename", etc. Sometimes the tutorials are particularly useful, when the help files seem too compressed to get at needed information quickly. Dale 

09272015, 02:17 AM
Post: #14




RE: Tutorials: Spreadsheet App
(09222015 03:56 PM)ndzied1 Wrote: I can't even get past the simple sum of numbers in tutorial 1. I keep getting a red X with Error: Syntax Error. :( I struggled with this too and found it was simpler just to switch modes to ALG for the simple purpose of working with the spreadsheet app. Subjectively speaking, it's a bit tedious and if I had my druthers, one could use exactly the same notations in the app irrespective of RPN vs. ALG  fewer conventions to have to master. 

09272015, 11:03 PM
Post: #15




RE: Tutorials: Spreadsheet App
(09252015 03:43 PM)Eddie W. Shore Wrote: HP Prime Spreadsheet Tutorial #6: Row and Column References in Formulas Awesome tutorial, thanks for sharing! I had no idea how to use the spreadsheet in my Prime until I watched your tutorials. Jim 

« Next Oldest  Next Newest »

User(s) browsing this thread: 1 Guest(s)