Home

EtherCalc wiki

EtherCalc is the spreadsheet version of wiki, without logins and without editing locks. People can collaborate on a spreadsheet-like page simultaneously. It's somewhat a google sheet alternative, open source style.

Use Cases

When or why would you use EtherCalc? Here are a few scenarios.

• Scheduling a meeting without asking via e-mails nor filling one-time forms: Every participant can see the most up-to-date availability of other members. One can update his/her schedule any number of times. The number of available participants in each time slot can be easily seen.
• Car pooling arrangement: Who will ride in whose car? How many seats are still available in each car?
• Students mutual-grading: What does each student think of each other's exercises or projects?
• ...

Tips and tricks

Use a cell value from an other sheet.

Example, I have two sheets named sheet1 and sheet2 and I want to display cell A1's value from sheet1 in the sheet2's cell B3.

1. Go to cell B3 in sheet2
2. type this formula: ="sheet1"!A1

Color a cell depending of its value (aka Conditional Formating) .

Example, I want a cell B2 to turn either green if the value in cell A1 is foo; if not turn red.

1. Go to cell B2
2. In the menu/format/format/text choose "HTML" and save for this cell
3. Then type this formula: =if(A1="foo","<span style=""background-color:rgb(81,184,72);color:rgb(81,184,72)"">_______</span>","<span style=""background-color:rgb(226,86,43);color:rgb(226,86,43)"">_______</span>") So how does it work? Your IF function checks A1's value and gives you two possible output each of them being a simple text string made of underscores. The only subtility here is that we specify both pen color and background color to be the same (either green or red) so as it looks like the cell is filled either in red or in green. This is a workaround since there is no current straitforward function to set an empty cell's background color.