SPL Programming

Why do you (as a business person) need to learn some programming?

Yes, this is a programming course for business people. Many people are confused. They think that only programmers need to be able to program, and programming is very difficult.

However, it is not. Programming is not exclusive to programmers. Like foreign language and Excel, it is just a tool to help us improve our work efficiency. It can help us perform some repetitive and inefficient work, and let us spend more time and energy on the more important things.

To process tabular data in the past, you might have to spell, copy, paste, sort, search, and repeat over and over, and still you couldn't work it out for a long time. Now, as long as the data is put into the program, the report that the boss and customers want can be automatically produced in less than half a minute.

Why do business people need this book when they learn programming?

Because this book narrates clearly, from the shallow to the deep, starts from the 0 foundation to explain the basic concept of programming, and proceeds step by step. After learning and mastering the contents of this book, it is much easier to learn various other programming languages.

The book contains programs designed specifically for business people to process tabular data, after all, we should learn to apply them. Learning programming is to deal with the work at hand, and dealing with tabular data is a task that business people have to do every day:

  • Financial Accounting: programming can help you automatically integrate, categorize and summarize tables (e.g. frequently changing tax rate calculations).
  • Media operation: capture data, divide customers into groups, targeted operation, etc.
  • Marketing personnel: automatically draw a visual table, objective and clear.
  • Human resources: a variety of overlapping personnel information tables.
  • etc. …

Are the current popular Python training courses inappropriate?

Yes, they are inappropriate, TRULY.

There is no problem to use Python to learn the basic programming concept and logic. However, after learning these contents, you can only solve some arithmetical problems in primary and secondary schools, which is not helpful for daily work. If you want to use Python to process the tabular data that the business people have to deal with every day, it can only be said that it looks simple, but in fact, it is quite difficult to learn. Because pandas(it IS pandas, no mistake) doesn't consider and organize tabular data in your habitual way of thinking. It's not designed for this purpose. It's just that there is no more suitable tool on the market at present and people use it as an alternative. Obviously, and of course, Python is not suitable for business people to learn programming. (after learning this book and then take a look at python, you will agree with me with both hands up!)

What does this book use to learn programming?

We use SPL, a programming language written in cells (like programming in Excel). It is easy to understand, easy to install and debug. In particular, SPL provides a wealth of professional tabular data processing capabilities, which can be used after learning. It is no problem to solve excel difficulties, and it can even get big data done(while python will be paralyzed).

Pull programming down the altar, let 0-based beginners learn programming easily.

CONTENTS

Chapter 1 Basic concepts of programming READ

  • 1.1 Computer program and language
  • 1.2 esProc installation
  • 1.3 The simplest program
  • 1.4 More simple program examples
  • 1.5 Program structure
  • 1.6 The task of programming
  • 1.7 Exercises
  • Chapter 2 Algorithm and program READ

  • 2.1 What is algorithm?
  • 2.2 Simple algorithm examples
  • 2.3 Characteristics of the algorithm
  • 2.4 Methods of representing algorithm
    • Represent algorithm by flow chart
    • Represent algorithm by N-S flow chart
    • Represent algorithm by pseudo code
    • Represent algorithm by SPL
  • 2.5 Structured programming method
  • 2.6 Exercises
  • Chapter 3 Sequential structure programming READ

  • 3.1 Examples of sequential programming
  • 3.2 The representation of data and its operation
    • Constant and variable
    • Data type
    • Identification of data types
  • 3.3 Operators and Expressions
    • Common operators in SPL
    • Basic arithmetic operators
    • Operator precedence
    • Mixed operations of multi type data
    • Forced type conversion operators
  • 3.4 SPL statement
  • 3.5 Input and output of data
    • Input/output examples
    • Input and output data in SPL
  • 3.6 Exercises
  • Chapter 4 Selection structure programming READ

  • 4.1 Selection structure and condition judgment
  • 4.2 Implement selection structure with if statement
    • Example of selection structure
    • The general form of if statement
    • Other forms of if statement
  • 4.3 Relational operators and relational expression
    • Relational operators and their precedence
    • Relational expression
  • 4.4 Logical operators and logical expression
    • Logical operators and their precedence
    • Logical expression
  • 4.5 Function if
  • 4.6 Nesting of selection structure
  • 4.7 Exercises
  • Chapter 5 Loop structure programming READ

  • 5.1 The need for loop structure
  • 5.2 Implement loop structure with for x statement
    • The general form of for x statement
    • Loop of specified cycle number
    • Break and next statements
  • 5.3 For statement that specifies the scope of the loop
    • for a, b statement
    • for a, b, s statement
  • 5.4 Nesting of loop structure
    • Nesting of loop structure
    • Using break and next in multi-layer loops
  • 5.5 Examples of loop structure
  • 5.6 Exercises
  • Chapter 6 Text and string READ

  • 6.1 String
    • String constant
    • String operator
    • Special strings
    • Escape character and special characters
  • 6.2 String conversion
    • Character and ASCII
    • Coding and conversion
    • String and display format
  • 6.3 Dynamic program
    • Macro
    • eval function
  • 6.4 Text file
  • 6.5 String functions
    • Character function
    • String functions
    • Regular expression
  • 6.6 Exercises
  • Chapter 7 Function and subroutine READ

  • 7.1 What is a function?
  • 7.2 Calling a function in SPL
    • Calling a function
    • Parameters of function in SPL
    • Function options in SPL
  • 7.3 Subroutine
    • Definition and call of subroutine
    • Parameter transfer in subroutine
    • Scope of variables
    • Calling procedure of subroutine
    • Nesting of subroutines
    • Recursion of subroutines
  • 7.4 Cross grid calling
    • Cross grid calling
    • Parameter transfer in cross grid calling
    • Nesting and recursion of cross grid calling
  • 7.5 Exercises
  • Chapter 8 Sequence READ

  • 8.1 The concept of sequence
  • 8.2 Generation and modification of a sequence
    • Sequence constants
    • Member access of a sequence
    • Add a member to the end of a sequence
  • 8.3 Loop and calculation of sequence
    • Execute the loop with for A
    • Aggregation
    • Examples of sequence calculation
  • 8.4 Common sequences
    • A sequence of numbers
    • A sequence of strings
  • 8.5 Multidimensional sequence
    • What is multidimensional sequence?
    • Access to multidimensional sequence members
    • The use of multidimensional sequences
  • 8.6 Exercises
  • Chapter 9 Calculation of sequence READ

  • 9.1 Set property of sequence
    • Ordered property of sequence
    • Sequence and set
  • 9.2 Sequence functions
    • Generation and maintenance of sequence
    • String and sequence
  • 9.3 Aggregate calculation
    • Count, Sum & Average
    • Ranking
    • Max/Min value and median
    • Other aggregate functions
  • 9.4 Loop calculation
    • Complete loop calculation with A.(x)
    • Calculation by position
    • Loop functions
  • 9.5 Positioning
    • Find the position of the specified member
    • Find the position of a member that meets the condition
    • Find the position of the Max/Min value
    • Overall positioning
  • 9.6 Select
    • Find members that meet the conditions
    • Select the Max/Min value
    • Sorting and ranking
  • 9.7 Calculation of multidimensional sequence
  • 9.8 Examples of sequence calculation
  • 9.9 Exercises
  • Chapter 10 Data table READ

  • 10.1 Structured data
    • Structured data
    • Field and record
    • Data table
  • 10.2 Operations of table sequence
    • Create/View a table sequence
    • Record access
    • Basic addition, deletion and modification
    • Examples and extension operations
  • 10.3 External data
    • Data file
    • Reading file data
    • Exporting file data
    • Database DBMS
  • 10.4 Table sequence operations
    • Aggregation
    • Filter
  • 10.5 Record sequence
    • The concept of record sequence
    • Record sequence operations
    • The difference between record sequence and table sequence
  • 10.6 Exercises
  • Chapter 11 Calculation of table READ

  • 11.1 Aggregation
  • 11.2 Filter and positioning
    • Filter
    • Positioning
    • Positioning calculation
  • 11.3 Aligned calculation
    • Modification
    • Generation
    • Addition
  • 11.4 Sorting and ranking
    • Sorting
    • Sorting and positioning
    • Ranking
  • 11.5 Max/Min value
    • Max/Min value
    • TOP
  • 11.6 Exercises
  • Chapter 12 Order-related calculations READ

  • 12.1 Ordered set
    • The concept of ordered set
    • Access by sequence number
  • 12.2 Iterative function
  • 12.3 Positioning calculations
    • Locate members
    • Locate max/min value
    • Get the sequence numbers of members that meet the conditions
  • 12.4 Sorting and alignment
    • Sorting
  • 12.5 Exercises
  • Chapter 13 Grouping calculations READ

  • 13.1 Group aggregation
    • Group aggregation
    • Calculate unique values
  • 13.2 The essence of grouping
    • Grouped subsets
    • Group aggregation vs. grouping
  • 13.3 Non equivalent grouping
    • Equivalent grouping and non equivalent grouping
    • Alignment grouping
    • Enumeration grouping
  • 13.4 Ordered grouping
    • Order of grouping
    • Ordered grouping
  • 13.5 Exercises
  • Chapter 14 Inter table association READ

  • 14.1 Primary key and index
    • Find a record by primary key value
    • Index table
  • 14.2 Inter table association
    • Inter table association
    • Common associated relationships
  • 14.3 Foreign key table
  • 14.4 Same dimension table and main sub table
  • 14.5 Cross join and non equivalent join
    • Cross join
    • Non equivalent join
  • 14.6 Exercises
  • Chapter 15 Graphics drawing READ

  • 15.1 Canvas
    • Canvas
    • Element
  • 15.2 Physical coordinates
    • Absolute coordinates
    • Relative coordinates
  • 15.3 Logical coordinates
    • Numeric axis
    • Enumeration axis
    • Date axis
  • 15.4 More logical mappings
    • Polar coordinates
    • Combined coordinate system
    • Legend
  • 15.5 Finished graph
    • Column graph
    • Dual-axis graph
  • 15.6 Exercises
    • Trigonometric function
    • Multiple combinations
    • K-line chart

    Chapter 16 Big data and cursor READ

  • 16.1 Big data and cursor
    • Big data
    • Cursor concept
  • 16.2 Basic cursor operations
    • Use a cursor to read data
    • Loop the cursor
  • 16.3 Cursor functions
    • Aggregate operations of a cursor
    • Use cursor functions
    • Deferred calculation vs. immediate calculation
  • 16.4 Ordered cursor
  • 16.5 Big cursor
    • Big sorting
    • Big grouping
    • Combine
    • Merge
    • Join
    • Multi cursors
  • 16.6 Exercises
  • ebook


    Resouce Link