Excel on scratch!
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.
The other 15 squares in the functions menu are used when you use *, +, - or / to link different functions together. If you use one of these, the appropriate symbol and two red letters (e.g. a and b). These letters refer to other squares in the functions menu. Click a letter to change it, like with coordinates. Then simply enter into the relevant boxes in the functions menu with those letters next to them the two values that you want to multiply, add, etc.. For example, if you wanted to add together squares A01 and A02 on the main grid, you could put the function ‘Coordinate A01’ in square ‘a’ of the functions menu, ‘Coordinate A02’ in square ‘b’ and ‘a + b’ in the square with the yellow =, because this is your final answer. Think of it like operator scratch blocks: the addition block would be around the two things that you are adding and is your final answer.
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.
+ADD: Adds the values of two squares in the functions menu together.
-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.
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
Thumbnail created with Adobe Dimension
Ready to Remix!
Add your ideas! You could try:
- drawing a new costume
- changing the scripts
- creating a new sprite