## Excel on scratch!

Oh no! We're having trouble displaying this Scratch project.

If you are on a mobile phone or tablet, try visiting this project on a computer.

If you're on a computer, your Flash player might be disabled, missing, or out of date. Visit this page to update Flash.

**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.

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.

**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.

+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.

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

Thumbnail created with Adobe Dimension

#### Add this project to a studio you curate (or remove it from a studio)

Just click on the button for any of the studios from the list below#### Download this project file

(dialog appears on the stage)

#### Comments

- Comments loading...