Ethercalc-Hangouts: Difference between revisions

From H&D Publishing Wiki
No edit summary
 
(30 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<div class="article ethercalc-hangouts layout-2" id="Prompts_for_hanging_out_in_a_spreadsheet">
<div class="article Spreadsheet_Routines layout-2" id="Spreadsheet_Routines">
<div class="hide-from-website">
[[File:Screenshot 2022-08-24 at 09.44.58.png|thumb|class=title_image|Screenshot of the Ethercalc spreadsheet, which served as a guideline, workshop and discussion space, as well as documentation of workshop outcomes]]
</div>


[[File:Screenshot 2022-08-24 at 09.44.58.png|thumb|class=title_image|caption]]
<div class="hide-from-book scriptothek">
[[File:Screenshot 2022-08-24 at 09.44.58.png|thumb]]
[[File:ethercalc-prompt-1.png|thumb|https://ec.hackersanddesigners.nl/routine-1-connect]]
[[File:ethercalc-prompt-2.png|thumb]]
[[File:ethercalc-prompt-4.png|thumb|https://ec.hackersanddesigners.nl/routine-2-play]]
[[File:ethercalc-prompt-5.png|thumb|]]
[[File:ethercalc-prompt-6.png|thumb|https://ec.hackersanddesigners.nl/routine-4-cook]]


===Spreadsheet Routines===
[[File:liquify.png|thumb|https://ec.hackersanddesigners.nl/routine-3-liquify]]
<span class="author">Anja Groten, Karl Moubarak</span><br>


[[File:Screenshot_2022-08-24_at_09.47.52.png|thumb]]
[[File:Screenshot 2022-08-24 at 10.55.04.png|thumb]]
[[File:time-table.png|thumb|Time table HDSA 2021]]


[[File:Screenshot 2021-07-24 at 11.48.00.png|thumb]]
</div>


===Spreadsheet Routines===
<span class="author">Anja Groten and Karl Moubarak</span>
“Spreadsheet Routines” or "Ethercalc hangouts" is a series of mini workshops that emerged from a shared enthusiasm for spreadsheets. The thirty minute daily sessions can be repeated for an unlimited period of time, and are intended to cultivate a sense of togetherness among people who, for example, collaborate regularly but don’t live not in close proximity. Through the exercises, participants are invited to spend time together and collectively explore the expressive and collaborative potential of spreadsheets.
“Spreadsheet Routines” or "Ethercalc hangouts" is a series of mini workshops that emerged from a shared enthusiasm for spreadsheets. The thirty minute daily sessions can be repeated for an unlimited period of time, and are intended to cultivate a sense of togetherness among people who, for example, collaborate regularly but don’t live not in close proximity. Through the exercises, participants are invited to spend time together and collectively explore the expressive and collaborative potential of spreadsheets.


 
As a meeting place, we propose using Ethercalc, an open-source collaborative web spreadsheet editor developed by Audrey Tang and built with SocialCalc. Similarly to Etherpad, Ethercalc allows users to edit documents simultaneously. Ethercalc is typically used for inventories, survey forms, list management, brainstorming sessions, budgets, and timetables—all of which we found essential for collaborative organizing!
As a meeting place, we propose using Ethercalc, an open source collaborative web spreadsheet editor developed by Audrey Tang and built with SocialCalc. Similarly to Etherpad, Ethercalc allows users to edit documents simultaneously. Ethercalc is typically used for inventories, survey forms, list management, brainstorming sessions, budgets, and timetables—all of which we found essential for collaborative organizing!
 


Each session kicks off with a short prompt, which can be repeated, edited, and new iterations created.
Each session kicks off with a short prompt, which can be repeated, edited, and new iterations created.


==== Daily Ethercalc Routines  ====
==== Daily Ethercalc Routines  ====
''Duration: Twenty-thirty minutes per day.''
''Duration: Twenty-thirty minutes per day.''


Line 29: Line 38:
*You may invite participants to create their own prompts and host their own sessions.
*You may invite participants to create their own prompts and host their own sessions.
*Consider sending additional updates and reminders, motivational posts, and screenshots of the outcomes and highlights.
*Consider sending additional updates and reminders, motivational posts, and screenshots of the outcomes and highlights.


==== Onboarding  ====
==== Onboarding  ====
 
[[File:Screenshot 2021-07-24 at 11.48.00.png|thumb]]
To introduce the practice of Ethercalc hangouts, we propose setting up a video call for the first time you meet on the spreadsheet. Facilitators can share some background information on Ethercalc, invite participants to set intentions for the daily practice, and take some questions.  
To introduce the practice of Ethercalc hangouts, we propose setting up a video call for the first time you meet on the spreadsheet. Facilitators can share some background information on Ethercalc, invite participants to set intentions for the daily practice, and take some questions.  
* Ethercalc is a web-based collaborative spreadsheet editor.  
* Ethercalc is a web-based collaborative spreadsheet editor.  
[[File:Ethercalc interface.png|thumb]]
* It is open-source. This means the source code of the software is visible, reusable, and extendable. Anyone can copy the code, make improvements, and develop it further.  
* It is open-source. This means the source code of the software is visible, reusable, and extendable. Anyone can copy the code, make improvements, and develop it further.  
* Ethercalc was developed by Audrey Tang, Taiwan’s minister of digital affairs. [[File:Audrey Tang.png|thumb]]
* Ethercalc was developed by Audrey Tang, Taiwan’s minister of digital affairs.  
* Ethercalc can be installed on any computer. You can run Ethercalc locally on your personal computer if you want to use it alone. You can host it on a local device like a Raspberry Pi if you want to collaborate with people in close proximity, or you can install it on a remote server, allowing you to collaborate with anyone in the world with an internet connection!  
* Ethercalc can be installed on any computer. You can run Ethercalc locally on your personal computer if you want to use it alone. You can host it on a local device like a Raspberry Pi if you want to collaborate with people in close proximity, or you can install it on a remote server, allowing you to collaborate with anyone in the world with an internet connection!  


==== Ethercalc tips and tricks ====
==== Ethercalc tips and tricks ====
[[File:Ethercalc-inaction-02.png]]
[[File:Ethercalc-inaction-02.png]]
* To create an unnamed Ethercalc, go to [https://ethercalc.hackersanddesigners.nl/ <u>https://ethercalc.hackersanddesigners.nl/</u>] and click &quot;Create Spreadsheet.&quot;
* To create an unnamed Ethercalc, go to [https://ethercalc.hackersanddesigners.nl/ <u>https://ethercalc.hackersanddesigners.nl/</u>] and click &quot;Create Spreadsheet.&quot;
* To create a named Ethercalc, type [https://ethercalc.hackersanddesigners.nl/ <u>https://ethercalc.hackersanddesigners.nl/</u>] into your address bar followed by the name of your sheet.
* To create a named Ethercalc, type [https://ethercalc.hackersanddesigners.nl/ <u>https://ethercalc.hackersanddesigners.nl/</u>] into your address bar followed by the name of your sheet.
Line 62: Line 64:
* If Ethercalc gets slow or stuck, refreshing the page will do the trick.
* If Ethercalc gets slow or stuck, refreshing the page will do the trick.


<span class="page-break">&nbsp;</span>
==== Session 1: “Connect” ====
==== Session 1: “Connect” ====
The first prompt aims to help participants to familiarize themselves and learn about the quirks of its formatting and functions.
The first prompt aims to help participants to familiarize themselves and learn about the quirks of its formatting and functions.
   
   
Line 73: Line 73:
#(15 min) Meet each other on the carpet and go with the flow of weaving a carpet with the different formatting options and within your cells.
#(15 min) Meet each other on the carpet and go with the flow of weaving a carpet with the different formatting options and within your cells.


''*Useful tip: the clipboard is shared, so if you use the paste button, you might be pasting someone else's  
''*Useful tip: the clipboard is shared, so if you use the paste button, you might be pasting someone else's cells.''
cells.''
 
<span class="spread">[[File:Screenshot_2022-08-24_at_09.47.52.png|thumb]]</span>
<span class="spread">[[File:Screenshot 2022-08-24 at 10.55.04.png|thumb]]</span>


==== Session 2: “Play” ====
==== Session 2: “Play” ====
#Hello, good morning / afternoon / evening everyone!
#Hello, good morning / afternoon / evening everyone!
#Say hi in a cell.
#Say hi in a cell.
Line 88: Line 83:
#Keep an eye out for instructions <br>The Ethercalc moderators will indicate there are 5 more minutes left to draw and when the time is up.<br>Once the time is up, do not touch the spreadsheet anymore. Just watch!<br>Your avatars will be moved to be paired.
#Keep an eye out for instructions <br>The Ethercalc moderators will indicate there are 5 more minutes left to draw and when the time is up.<br>Once the time is up, do not touch the spreadsheet anymore. Just watch!<br>Your avatars will be moved to be paired.
#(10 minutes or as long as you wish) Go look for your avatar and see whose company you are in. Use the cells around your avatars to chat away!
#(10 minutes or as long as you wish) Go look for your avatar and see whose company you are in. Use the cells around your avatars to chat away!
<div class="visual-footnote img">
[[File:Ethercalc-drawing-08.png|thumb]]</div>


'''Meet the characters:'''
[[File:Ethercalc-drawing-08.png|thumb]]
<span class="page-break">&nbsp;</span>
==== Session 3: “Cook” ====
==== Session 3: “Cook” ====
#Hello, good morning / afternoon / evening everyone!
#Hello, good morning / afternoon / evening everyone!
#Say hi in a cell.
#Say hi in a cell.
Line 101: Line 93:
#(5 min) Check out the other dishes and guess some of their ingredients (write in the column next to the dish).
#(5 min) Check out the other dishes and guess some of their ingredients (write in the column next to the dish).
#Set a date to cook the dishes.
#Set a date to cook the dishes.
 
<div class="visual-footnote img">
Recipes:  
[[File:Screenshot 2022-08-24 at 10.49.10.png|thumb]]
 
[[File:Screenshot 2022-08-24 at 10.47.17.png|thumb]]
[[File:Screenshot 2022-08-24 at 10.47.17.png|thumb]]
</div>
<div class="visual-footnote img">
[[File:Screenshot 2022-08-24 at 10.48.58.png|thumb]]
[[File:Screenshot 2022-08-24 at 10.48.58.png|thumb]]
[[File:Screenshot 2022-08-24 at 10.49.10.png|thumb]]
[[File:Screenshot 2022-08-24 at 10.49.30.png|thumb]]
[[File:Screenshot 2022-08-24 at 10.49.30.png|thumb]]
<span class="page-break">&nbsp;</span>  
</div>
 
==== Session 4: “Liquify”  ====
==== Session 4: “Liquify”  ====
#Hello, good morning / afternoon / evening everyone!
#Hello, good morning / afternoon / evening everyone!
#Say hi in a cell.
#Say hi in a cell.
#Liquidation is the prompt!<br />
#Liquidation is the prompt!<br />
Challenge the fixed boundaries of the cells, rows, and columns. Get inspired by streams, ponds, rivers, creeks, sinks, the deep seas, a toilet flush. . . Create a liquid environment that dilutes fixed boundaries and categorization.<br>You are not limited to one spot on the spreadsheet .
Challenge the fixed boundaries of the cells, rows, and columns. Get inspired by streams, ponds, rivers, creeks, sinks, the deep seas, a toilet flush. Create a liquid environment that dilutes fixed boundaries and categorization.<br>You are not limited to one spot on the spreadsheet.
[[File:Screenshot 2022-08-24 at 10.54.33.png|thumb]]


''The Ethercalc Hangouts were practiced throughout the H&amp;D Summer Academy 2021.''
<div class="visual-footnote img">
[[File:Screenshot 2022-08-24 at 10.54.33.png|class=wide_image|thumb|Spreadsheet drawing]]
</div>


'''References:'''
''The Ethercalc Hangouts took place throughout the H&D Summer Academy 2021.''
 
====References:====


* Sadie Plant, &quot;The Future Looms. Weaving Women and Cybernetics,&quot; Body &amp; Society, 1.3-4 (1995): 45-64. https://monoskop.org/images/1/13/Plant_Sadie_1995_The_Future_Looms_Weaving_Women_and_Cybernetics.pdf.
* Sadie Plant, &quot;The Future Looms. Weaving Women and Cybernetics,&quot; Body &amp; Society, 1.3-4 (1995): 45-64. https://monoskop.org/images/1/13/Plant_Sadie_1995_The_Future_Looms_Weaving_Women_and_Cybernetics.pdf.
Line 126: Line 122:
* Dani Deahl, “You can now make sick beats in Microsoft Excel,” The Verge, February 6, 2020, [https://www.theverge.com/2020/2/6/21126465/xl-studio-music-making-drum-microsoft-excel-daw-dylan-tallchief <u>https://www.theverge.com/2020/2/6/21126465/xl-studio-music-making-drum-microsoft-excel-daw-dylan-tallchief</u>].
* Dani Deahl, “You can now make sick beats in Microsoft Excel,” The Verge, February 6, 2020, [https://www.theverge.com/2020/2/6/21126465/xl-studio-music-making-drum-microsoft-excel-daw-dylan-tallchief <u>https://www.theverge.com/2020/2/6/21126465/xl-studio-music-making-drum-microsoft-excel-daw-dylan-tallchief</u>].


<br>
<small>
[[#Platframe Postscript|'''Anja Groten''''s bio.]]<br>
[[#Platframe Postscript|'''Karl Moubarak''''s bio.]]
</small>
<span class="spread">[[File:Screenshot_2022-08-24_at_09.47.52.png|thumb]]</span>
<span class="spread">[[File:Screenshot 2022-08-24 at 10.55.04.png|thumb]]</span>
</div>
</div>

Latest revision as of 20:57, 18 November 2022

Screenshot of the Ethercalc spreadsheet, which served as a guideline, workshop and discussion space, as well as documentation of workshop outcomes

Spreadsheet Routines

Anja Groten and Karl Moubarak “Spreadsheet Routines” or "Ethercalc hangouts" is a series of mini workshops that emerged from a shared enthusiasm for spreadsheets. The thirty minute daily sessions can be repeated for an unlimited period of time, and are intended to cultivate a sense of togetherness among people who, for example, collaborate regularly but don’t live not in close proximity. Through the exercises, participants are invited to spend time together and collectively explore the expressive and collaborative potential of spreadsheets.

As a meeting place, we propose using Ethercalc, an open-source collaborative web spreadsheet editor developed by Audrey Tang and built with SocialCalc. Similarly to Etherpad, Ethercalc allows users to edit documents simultaneously. Ethercalc is typically used for inventories, survey forms, list management, brainstorming sessions, budgets, and timetables—all of which we found essential for collaborative organizing!

Each session kicks off with a short prompt, which can be repeated, edited, and new iterations created.

Daily Ethercalc Routines 

Duration: Twenty-thirty minutes per day.

Note to facilitator(s):

  • Pick a time that suits all participants (consider different time zones).
  • Prepare the sheets beforehand and release the links to the sheets a few minutes before the agreed time every day. You can do that via email or through a shared chat room.
  • Every day, participants will open the linked spreadsheet to respond to a new prompt. The prompts can be interpreted freely. Participants are free to continue creating Ethercalc art after the thirty minutes is up. 
  • You may invite participants to create their own prompts and host their own sessions.
  • Consider sending additional updates and reminders, motivational posts, and screenshots of the outcomes and highlights.

Onboarding

Screenshot 2021-07-24 at 11.48.00.png

To introduce the practice of Ethercalc hangouts, we propose setting up a video call for the first time you meet on the spreadsheet. Facilitators can share some background information on Ethercalc, invite participants to set intentions for the daily practice, and take some questions.

  • Ethercalc is a web-based collaborative spreadsheet editor.
  • It is open-source. This means the source code of the software is visible, reusable, and extendable. Anyone can copy the code, make improvements, and develop it further.
  • Ethercalc was developed by Audrey Tang, Taiwan’s minister of digital affairs.
  • Ethercalc can be installed on any computer. You can run Ethercalc locally on your personal computer if you want to use it alone. You can host it on a local device like a Raspberry Pi if you want to collaborate with people in close proximity, or you can install it on a remote server, allowing you to collaborate with anyone in the world with an internet connection!

Ethercalc tips and tricks

Ethercalc-inaction-02.png

  • To create an unnamed Ethercalc, go to https://ethercalc.hackersanddesigners.nl/ and click "Create Spreadsheet."
  • To create a named Ethercalc, type https://ethercalc.hackersanddesigners.nl/ into your address bar followed by the name of your sheet.
  • All the functions you need are in the toolbar (some are less visible than others).
  • Other people's cursors appear as cells with a blue border.
  • Keyboard shortcuts are a little bit weird:
    • CMD / CTRL + C copies values and styles
    • CMD / CTRL + V pastes values only
    • Use the toolbar to paste styles
    • CMD / CTRL + Z goes backwards in history
    • CMD / CTRL + SHIFT + Z also goes backwards in history
    • To move forward in history, use the toolbar
  • The clipboard is shared, so watch out! You might be pasting someone else's clipping.
  • The edit history is also shared, so be aware that if you “undo,” you might be undoing someone else's work.
  • If Ethercalc gets slow or stuck, refreshing the page will do the trick.

Session 1: “Connect”

The first prompt aims to help participants to familiarize themselves and learn about the quirks of its formatting and functions.

  1. Hello, good morning / afternoon / evening everyone!
  2. Say hi in a cell.
  3. We propose the analogy of weaving a carpet. Imagine this spreadsheet as our distributed loom!
  4. We prepared some carpets for you from row 30 onward. Couple up by pasting your name above a carpet.
  5. (15 min) Meet each other on the carpet and go with the flow of weaving a carpet with the different formatting options and within your cells.

*Useful tip: the clipboard is shared, so if you use the paste button, you might be pasting someone else's cells.

Session 2: “Play”

  1. Hello, good morning / afternoon / evening everyone!
  2. Say hi in a cell.
  3. (2 min) Find yourself a spot on the spreadsheet and draw an avatar in approximately 20 rows and 30 columns. Before you start, make sure to mark your drawing area. Add your coordinates and avatar names here.
  4. (10 minutes) Drawn your avatar!
  5. Name your avatar.
  6. Keep an eye out for instructions
    The Ethercalc moderators will indicate there are 5 more minutes left to draw and when the time is up.
    Once the time is up, do not touch the spreadsheet anymore. Just watch!
    Your avatars will be moved to be paired.
  7. (10 minutes or as long as you wish) Go look for your avatar and see whose company you are in. Use the cells around your avatars to chat away!
Ethercalc-drawing-08.png

Session 3: “Cook” 

  1. Hello, good morning / afternoon / evening everyone!
  2. Say hi in a cell.
  3. (15 min) Create a drawing of your favorite dish (to be cooked from the picture at a shared meeting time).
  4. (2 min) Invent a new name for the dish (without describing it literally).
  5. (5 min) Check out the other dishes and guess some of their ingredients (write in the column next to the dish).
  6. Set a date to cook the dishes.
Screenshot 2022-08-24 at 10.49.10.png
Screenshot 2022-08-24 at 10.47.17.png
Screenshot 2022-08-24 at 10.48.58.png
Screenshot 2022-08-24 at 10.49.30.png

Session 4: “Liquify”

  1. Hello, good morning / afternoon / evening everyone!
  2. Say hi in a cell.
  3. Liquidation is the prompt!

Challenge the fixed boundaries of the cells, rows, and columns. Get inspired by streams, ponds, rivers, creeks, sinks, the deep seas, a toilet flush. Create a liquid environment that dilutes fixed boundaries and categorization.
You are not limited to one spot on the spreadsheet.

Spreadsheet drawing

The Ethercalc Hangouts took place throughout the H&D Summer Academy 2021.

References:


Anja Groten's bio.
Karl Moubarak's bio.

Screenshot 2022-08-24 at 09.47.52.png
Screenshot 2022-08-24 at 10.55.04.png