From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id wHD/EMcVCF+0CwAA0tVLHw (envelope-from ) for ; Fri, 10 Jul 2020 07:16:23 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id eIDDDMcVCF85VQAAbx9fmQ (envelope-from ) for ; Fri, 10 Jul 2020 07:16:23 +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 ABCD79404CB for ; Fri, 10 Jul 2020 07:16:22 +0000 (UTC) Received: from localhost ([::1]:54124 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jtnGf-0004gP-Cy for larch@yhetil.org; Fri, 10 Jul 2020 03:16:21 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:43940) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jtnFz-0004f1-Nq for emacs-orgmode@gnu.org; Fri, 10 Jul 2020 03:15:40 -0400 Received: from mail-oo1-xc33.google.com ([2607:f8b0:4864:20::c33]:38220) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jtnFy-0004Sl-5h for emacs-orgmode@gnu.org; Fri, 10 Jul 2020 03:15:39 -0400 Received: by mail-oo1-xc33.google.com with SMTP id x2so817973oog.5 for ; Fri, 10 Jul 2020 00:15:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=+HHbgQKNZPlE9eZKF6oT/vWbTGHJP/mZHfp3rSEVufs=; b=W6UWm3pYtkV70wCGudxRpOYa+Nlpf92UbZxDnXgKLD6u2/VEdQ9dM/7CmDt3v5ztTb VeFECFB8N1Z2kzglOvH+p4C134mcY26ccfj6YCEbqXzNKOH2BOmrm68+DXrs5joKqlWJ hjL5liH0R2fVdvh44V20ns5F0zXoL7TGpbTEZL5/0kZf3wehroedZwbdQgyUpJLuvtfs CNnf/17hL6mYM39yJh9y8ZqqkMZpiHOiL8MMk11GlfjvIAipb9F7V0uw50Kj7dD0GvIq 9TdwQ/QAO/A+14QBmg3UcQxJv7iPdSwpKetDCK0viuocBX/bJQUUBtMaYbGmGj2dMsSf BGiA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=+HHbgQKNZPlE9eZKF6oT/vWbTGHJP/mZHfp3rSEVufs=; b=dL1KdXSTeiAsoGo/hCgJbtmuVp/swrSK8GDg58Kc6jzwW0feX6th7+q9cYlQw4ak6N k44/g/iTkP3CH9qswf8O23oudgKaEsAjJm7DUoHQl32/pbSrjLweQ/Xztr0wCyqrrwCy rWZofEBbxWiYVXLJyJ9ivWTjAGobEKEsETU4TDdX5hwBnQ8S8Mc0rzPa0wJ9oqowkImN QMkPtPtAv7zhst3k5Ud1UhXO1zwbIbSXOu14y5UqGbJm5BzKQIsVWzBXURsETOLmrMej xB0BRIyY11nbfFHrCPRWyhdFZYHZmIlQpDrrisXhbrEmcFRDDaEWknhKQO8Mwn8a3nxD /0Vg== X-Gm-Message-State: AOAM532oIDkbTqUD51PFXcxRuNf1rbVetVj0NeP88luFruof1XxP9MMZ 5elEO1CCwxVLE+b8x9zlhBg1IKV4DXECCMal5rY= X-Google-Smtp-Source: ABdhPJwlxPi/JQOCSPj+i47jV6cillW+/OCAXsoovr0SvL6Kc1tId809QUomDI05EitKGUMoH1nIk4Oq02dz6Ck1uvo= X-Received: by 2002:a4a:3405:: with SMTP id b5mr9461220ooa.9.1594365336567; Fri, 10 Jul 2020 00:15:36 -0700 (PDT) MIME-Version: 1.0 References: <87a7084afo.fsf@nicolasgoaziou.fr> In-Reply-To: From: Michael Brand Date: Fri, 10 Jul 2020 09:15:25 +0200 Message-ID: Subject: Re: empty/nil in table cells To: Mario Frasca Content-Type: text/plain; charset="UTF-8" Received-SPF: pass client-ip=2607:f8b0:4864:20::c33; envelope-from=michael.ch.brand@gmail.com; helo=mail-oo1-xc33.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: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action 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: , Cc: Org Mode 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=gmail.com header.s=20161025 header.b=W6UWm3pY; dmarc=pass (policy=none) header.from=gmail.com; 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.71 X-TUID: 4a7+Oo9WyCJk Hi Mario For such cases I use ~subseq~ to take the running window out of the complete range ~@I$2..@II$2~: | date | measure | running avg | |-------+---------+-------------| | 01-27 | 604 | | | 01-28 | 314 | | | 01-29 | 636 | | | 01-30 | 305 | | | 01-31 | 760 | | | 02-01 | 531 | | | 02-02 | 331 | 497.29 | | 02-03 | 77 | 422.00 | | 02-04 | 621 | 465.86 | | 02-05 | 406 | 433.00 | | 02-06 | 621 | 478.14 | | 02-07 | 975 | 508.86 | | 02-08 | 252 | 469.00 | | 02-09 | 794 | 535.14 | | 02-10 | 36 | 529.29 | #+TBLFM: $3 = '(let ((len 7)) (if (> @# len) (format "%.2f" (/ (apply #'+ (subseq '(@I$2..@II$2) (- @# 1 len) (- @# 1))) (float len))) "")); N Michael