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>")