## Excel on scratch!

Instructions

NOTE: You will be asked to turn on TURBO MODE
Full screen is recommended, but not necessary.

The main sheet works like in excel: Click on a square to activate it and type to enter numbers. For other typing options use the -, . and backspace buttons next to the typing field. You can also copy and paste!
Entering functions is a bit more complicated. Click ‘Edit function’ to see the functions menu, which has another grid in it. The last square has a yellow-coloured = sign in it, the answer to whatever you put in that square is what will be shown on the main grid. Ignore the other squares for now.
Choose a function from the sidebar to put in the field (what the functions mean and do is explained in the ‘credits’ section). Functions like SUM refer to other squares on the main grid through coordinates (e.g. A01). Click a coordinate to change it. With VAL, you can give a square inside the functions menu a certain value. If you want to use just one of the functions for the square on the main grid you have selected, put this function in the square with the yellow = sign and ignore the squares.

Notes and Credits

21/04/18 - Curated by @bidulule and loved by @Will_Wam
Responds to backspace, enter and period keys! (Credits below)

THE FUNCTIONS EXPLAINED:
SUM: Adds the values of two squares (shown by the coordinates) together, and the values of all squares between them on the main grid.
NUMBR: Lets you assign a value to a certain square in the functions menu. It can be useful if you want to e.g. multiply a function by a certain number.
COORD: Assigns the value of a square on the main grid (shown by the coordinate) to the selected square in the functions menu.
-SUB: Subtracts the value of one square in the functions menu from the value of another.
xMULT: Multiplies the values of two squares in the functions menu together.
/DIV: Divides the value of one square in the functions menu by the value of another.
MEAN: Calculates the average of the values of two squares, and all the squares between them on the main grid.
>MIN: Shows the smallest number from a group of numbers, consisting of two squares (shown by the coordinates) and all the squares between them on the main grid.
<MAX: Shows the largest number from a group of numbers, consisting of two squares (shown by the coordinates) and all the squares between them on the main grid.

OTHER TIPS FOR USING FUNCTIONS
- With any function that uses two coordinates (e.g. SUM), these two coordinates must either be in the same row or the same column.
- Empty squares are not counted when working out averages: to make them affect the average, enter ‘0’ into the square.
- If you would like to use the four operators (*, +, - and /) for squares in the main grid instead of squares in the functions menu, use the COORD function. This will make the squares in the functions menu you are referring to exactly the same as the squares on the main grid that you want to refer to instead.

CREDITS:

If you feel like you helped with any part of this project and I forgot to mention you below, please tell me!

Credit to @run_script for coding and design
Credit to @NiMike for backspace key detector
Credit to @MrSmacknShack for enter key detector
Credit to @-TheHacker- for period key detector
Thanks to @bidulule for curating this!
Based on Microsoft Excel
Project created with scratch