09-21-2015, 12:03 AM
Post: #1
 Eddie W. Shore Senior Member Posts: 1,100 Joined: Dec 2013
I have also put this on the HP Prime Tutorial thread.

HP Prime Spreadsheet Tutorial #1: Sum of a Column of Numbers
http://edspi31415.blogspot.com/2015/09/h...1-sum.html

HP Prime Spreadsheet Tutorial #2: Copying and Pasting Formulas
http://edspi31415.blogspot.com/2015/09/h...ial-2.html

HP Prime Spreadsheet Tutorial #3: Adding Labels, Numeric Calculations, Cell Numeric Format, and Extend Columns
http://edspi31415.blogspot.com/2015/09/h...ial-3.html

HP Prime Spreadsheet Tutorial #4: Naming Columns and Using them Outside of Num View
http://edspi31415.blogspot.com/2015/09/h...ial-4.html

http://edspi31415.blogspot.com/2015/09/h...ial-5.html
09-22-2015, 03:56 PM
Post: #2
 ndzied1 Member Posts: 94 Joined: Apr 2014
I can't even get past the simple sum of numbers in tutorial 1. I keep getting a red X with Error: Syntax Error. :-(
09-22-2015, 06:37 PM
Post: #3
 John Colvin Member Posts: 171 Joined: Dec 2013
(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.
09-22-2015, 08:10 PM
Post: #4
 ndzied1 Member Posts: 94 Joined: Apr 2014
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!
09-22-2015, 08:57 PM (This post was last modified: 09-22-2015 08:58 PM by Tim Wessman.)
Post: #5
 Tim Wessman Senior Member Posts: 2,231 Joined: Dec 2013
(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.

TW

Although I work for the HP calculator group, the views and opinions I post here are my own.
09-24-2015, 01:42 AM
Post: #6
 Eddie W. Shore Senior Member Posts: 1,100 Joined: Dec 2013
(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.
09-24-2015, 01:44 AM
Post: #7
 Eddie W. Shore Senior Member Posts: 1,100 Joined: Dec 2013
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.
09-24-2015, 03:27 AM
Post: #8
 Skyblues Member Posts: 73 Joined: Jun 2015
(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.

09-25-2015, 03:41 PM
Post: #9
 Eddie W. Shore Senior Member Posts: 1,100 Joined: Dec 2013
(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.

Thank you!
09-25-2015, 03:43 PM
Post: #10
 Eddie W. Shore Senior Member Posts: 1,100 Joined: Dec 2013
HP Prime Spreadsheet Tutorial #6: Row and Column References in Formulas

http://edspi31415.blogspot.com/2015/09/h...6-row.html

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

http://edspi31415.blogspot.com/2015/09/h...ial-7.html

HP Prime Spreadsheet Tutorial #8: Statistical Analysis

http://edspi31415.blogspot.com/2015/09/h...ial-8.html

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

http://edspi31415.blogspot.com/2015/09/h...ial-9.html
09-25-2015, 05:39 PM
Post: #11
 Jonathan Cameron Member Posts: 204 Joined: Dec 2013
(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/h...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.

-Jonathan
09-25-2015, 06:17 PM
Post: #12
 StephenG1CMZ Senior Member Posts: 830 Joined: May 2015
(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 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.

Stephen Lewkowicz (G1CMZ)
09-26-2015, 12:15 PM
Post: #13
 DrD Senior Member Posts: 1,124 Joined: Feb 2014
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-
09-27-2015, 02:17 AM
Post: #14
 JimP Member Posts: 77 Joined: Apr 2014
(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.
09-27-2015, 11:03 PM
Post: #15
 Skyblues Member Posts: 73 Joined: Jun 2015
(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/h...6-row.html

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

http://edspi31415.blogspot.com/2015/09/h...ial-7.html

HP Prime Spreadsheet Tutorial #8: Statistical Analysis

http://edspi31415.blogspot.com/2015/09/h...ial-8.html

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

http://edspi31415.blogspot.com/2015/09/h...ial-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
 « Next Oldest | Next Newest »

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