HP Forums
Tutorials: Spreadsheet App - Printable Version

+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Tutorials: Spreadsheet App (/thread-4761.html)



Tutorials: Spreadsheet App - Eddie W. Shore - 09-21-2015 12:03 AM

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/hp-prime-spreadsheet-app-tutorial-1-sum.html

HP Prime Spreadsheet Tutorial #2: Copying and Pasting Formulas
http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-2.html

HP Prime Spreadsheet Tutorial #3: Adding Labels, Numeric Calculations, Cell Numeric Format, and Extend Columns
http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-3.html

HP Prime Spreadsheet Tutorial #4: Naming Columns and Using them Outside of Num View
http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-4.html

HP Prime Spreadsheet Tutorial #5: Spreadsheets and Histograms
http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-5.html


RE: Tutorials: Spreadsheet App - ndzied1 - 09-22-2015 03:56 PM

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


RE: Tutorials: Spreadsheet App - John Colvin - 09-22-2015 06:37 PM

(09-22-2015 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. :-(

If you are in RPN mode, you need to enter: 'SUM(A!:A6)'
leaving off the = sign and in single quotes.


RE: Tutorials: Spreadsheet App - ndzied1 - 09-22-2015 08:10 PM

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!


RE: Tutorials: Spreadsheet App - Tim Wessman - 09-22-2015 08:57 PM

(09-22-2015 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.


RE: Tutorials: Spreadsheet App - Eddie W. Shore - 09-24-2015 01:42 AM

(09-22-2015 06:37 PM)John Colvin Wrote:  
(09-22-2015 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. :-(

If you are in RPN mode, you need to enter: 'SUM(A!:A6)'
leaving off the = sign and in single quotes.

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.


RE: Tutorials: Spreadsheet App - Eddie W. Shore - 09-24-2015 01:44 AM

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.


RE: Tutorials: Spreadsheet App - Skyblues - 09-24-2015 03:27 AM

(09-24-2015 01:44 AM)Eddie W. Shore Wrote:  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.

I'm looking forward to them. I found your spreadsheet tutorials very helpful.


RE: Tutorials: Spreadsheet App - Eddie W. Shore - 09-25-2015 03:41 PM

(09-24-2015 03:27 AM)Skyblues Wrote:  
(09-24-2015 01:44 AM)Eddie W. Shore Wrote:  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.

I'm looking forward to them. I found your spreadsheet tutorials very helpful.

Thank you! Smile


RE: Tutorials: Spreadsheet App - Eddie W. Shore - 09-25-2015 03:43 PM

HP Prime Spreadsheet Tutorial #6: Row and Column References in Formulas

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-6-row.html

HP Prime Spreadsheet Tutorial #7: Absolute References (Post 500)

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-7.html

HP Prime Spreadsheet Tutorial #8: Statistical Analysis

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-8.html

HP Prime Spreadsheet Tutorial #9: Custom Functions and the AMORT Function

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-9.html


RE: Tutorials: Spreadsheet App - Jonathan Cameron - 09-25-2015 05:39 PM

(09-25-2015 03:43 PM)Eddie W. Shore Wrote:  HP Prime Spreadsheet Tutorial #6: Row and Column References in Formulas

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-6-row.html

etc

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


RE: Tutorials: Spreadsheet App - StephenG1CMZ - 09-25-2015 06:17 PM

(09-24-2015 03:27 AM)Skyblues Wrote:  
(09-24-2015 01:44 AM)Eddie W. Shore Wrote:  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.

I'm looking forward to them. I found your spreadsheet tutorials very helpful.

I would prefer the ability to import/export a spreadsheet to/from a CSV-formatted Note to be available on-Prime, not just in the CK. Of course a user program could be written, but it would be convenient to just call a procedure.


RE: Tutorials: Spreadsheet App - DrD - 09-26-2015 12:15 PM

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-


RE: Tutorials: Spreadsheet App - JimP - 09-27-2015 02:17 AM

(09-22-2015 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.


RE: Tutorials: Spreadsheet App - Skyblues - 09-27-2015 11:03 PM

(09-25-2015 03:43 PM)Eddie W. Shore Wrote:  HP Prime Spreadsheet Tutorial #6: Row and Column References in Formulas

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-6-row.html

HP Prime Spreadsheet Tutorial #7: Absolute References (Post 500)

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-7.html

HP Prime Spreadsheet Tutorial #8: Statistical Analysis

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-8.html

HP Prime Spreadsheet Tutorial #9: Custom Functions and the AMORT Function

http://edspi31415.blogspot.com/2015/09/hp-prime-spreadsheet-app-tutorial-9.html

Awesome tutorial, thanks for sharing! I had no idea how to use the spreadsheet in my Prime until I watched your tutorials.

Jim