From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id SOg2BFB/7158dAAA0tVLHw (envelope-from ) for ; Sun, 21 Jun 2020 15:40:00 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id wIpMO09/7173ZAAAB5/wlQ (envelope-from ) for ; Sun, 21 Jun 2020 15:39:59 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 810489402A2 for ; Sun, 21 Jun 2020 15:39:59 +0000 (UTC) Received: from localhost ([::1]:48246 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jn24c-0001tW-3a for larch@yhetil.org; Sun, 21 Jun 2020 11:39:58 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:40446) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jmj8S-00006Y-OH for emacs-orgmode@gnu.org; Sat, 20 Jun 2020 15:26:40 -0400 Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29]:35347) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jmj8Q-0004g2-Kl for emacs-orgmode@gnu.org; Sat, 20 Jun 2020 15:26:40 -0400 Received: by mail-oo1-xc29.google.com with SMTP id e12so2575766oou.2 for ; Sat, 20 Jun 2020 12:26:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nau-edu.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=veQh1nw8vSMkQrrn7n4lTUOOAL5wjTV1QkHVYjblsBs=; b=NwpoVtiMAOnojhPOeX8S2Kb5FqBRRmCQ0oyv/ihkE810XX7fQGtvv6ipDhGT96aueD azexf1HF7BFsQsxO7q5MFs7I4KvB6U10879tGcsjkxC9iqEzj4zE3zrN8PmbM+ZU4Zwb 1MbCf5+sxZ0EmBDNvAV/3C5n1epO5NZUAjD5nZCLTs8nMWfcB6iJfmkrKCiqV/+lw4AT gRTlAMiwTQ7/Gxu1MvhKB7Yn7acIIBv83cKcybOffQwa8jwCYrCTuoSUf9tnaHM1U/Kz wQpt1SiTk85KPYvvOeXz39g0S+gTQGUjb3UJz92jAS6eTIgoqAzJJh0z4DDpLUkMmVRV u3SA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=veQh1nw8vSMkQrrn7n4lTUOOAL5wjTV1QkHVYjblsBs=; b=m2dtUTL4/xW5WOtx7Ugh9UCqyvWuD/bETvFt7GkoQ/DZ3fpTUV7ERGILFuf+6Zp6St u2td8fl39BeXBHsUKc1bweq8YzonCcdU7nDcrFWPvxUi/DSxCETwquFm08Cy8JVPnenz ducv+xUkEacBMYms4Cz3EjAR60Ke53nlSfyioeQS9JmzzgtLvf1auMWuoEDbbLXpBQXE QbMFL2i81eUgYRkVYBKyXqVTQYbVTS+9pUgL7VpRurrmr/PD+AhmFEf+oX+EVDyqC6rK sLEmo59eMbX+9cMcfiFYtaz8kpJZb3RKNsRqj67QQNLX9z8QaxA1uFKBiUC0envbk0O5 n0Uw== X-Gm-Message-State: AOAM533bwqL9fpr66xr8wFc+ydqnLtZUtnC0C2NbLUfRsPX3Gv8I2JEF /HM0lbhiKxSFSJDloZSKRQhw5GZ8op2OJ/Swg363DsRvEME= X-Google-Smtp-Source: ABdhPJyQAZIee2UxXGSun3WaMqyzBNgI/wk+a31QpLSH3oNxuO1AkgpHk4a/ydTEB1bI4KgWSnMoi0IDnx/Hc1i5EXc= X-Received: by 2002:a4a:3e14:: with SMTP id t20mr2215971oot.15.1592681196584; Sat, 20 Jun 2020 12:26:36 -0700 (PDT) MIME-Version: 1.0 From: Michael Partridge Date: Sat, 20 Jun 2020 12:26:20 -0700 Message-ID: Subject: Org Spreadsheet Documentation Suggestion To: emacs-orgmode@gnu.org Content-Type: multipart/alternative; boundary="000000000000f695b905a888fc0a" Received-SPF: pass client-ip=2607:f8b0:4864:20::c29; envelope-from=mcp292@nau.edu; helo=mail-oo1-xc29.google.com X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-Mailman-Approved-At: Sun, 21 Jun 2020 11:39:20 -0400 X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=nau-edu.20150623.gappssmtp.com header.s=20150623 header.b=NwpoVtiM; dmarc=fail reason="SPF not aligned (relaxed), DKIM not aligned (relaxed)" header.from=nau.edu (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -1.11 X-TUID: 8xfZVhkh6Sco --000000000000f695b905a888fc0a Content-Type: text/plain; charset="UTF-8" Hello, In the spreadshconfidentendlyeet intro under "Column formulas and field formulas" starting with "Finally, we can add the row for the means per discipline..." there is no walkthrough and thus a great teaching opportunity missed. I take it the writer intended for the reader to imply that we apply a similar formula using the row notation, and if they need a hint they can review the 'TBLFM' line. But, I would've liked to have discussion as to: 1. Why the writer explicitly marked the cells instead of just using 'vmean(@2..@4)'? 2. How to repeat this formula on the next cell in the row (the previous methods don't seem to work). This would complete the tutorial and would have allowed me to jump right into my task confidently (save the fact that the Calc manual link is broken). MCP --000000000000f695b905a888fc0a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,
In the spreadshconfidentendlyeet intr= o under "Column formulas and field formulas" starting with &q= uot;Finally, we can add the row for the means per discipline..." there= is no walkthrough and thus a great teaching opportunity missed.
=

I take it the writer intended for the reader to imply that = we apply a similar formula using the row notation, and if they need a hint = they can review the 'TBLFM' line. But, I would've liked to have= discussion as to:
=C2=A0 1. Why the writer explicitly marked = the cells instead of just using 'vmean(@2..@4)'?
=C2=A0 2. = How to repeat this formula on the next cell in the row (the previous method= s don't seem to work).

This would complete the tut= orial and would have allowed me to jump right into my task confidently (sav= e the fact that the Calc manual link is broken).


<= /div>
MCP
--000000000000f695b905a888fc0a--