Re: Spreadsheet to aid agenda planning

Tim Wicinski <tjw.ietf@gmail.com> Wed, 08 September 2021 20:59 UTC

Return-Path: <tjw.ietf@gmail.com>
X-Original-To: wgchairs@ietfa.amsl.com
Delivered-To: wgchairs@ietfa.amsl.com
Received: from localhost (localhost [127.0.0.1]) by ietfa.amsl.com (Postfix) with ESMTP id 06C963A3823 for <wgchairs@ietfa.amsl.com>; Wed, 8 Sep 2021 13:59:16 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -2.097
X-Spam-Level:
X-Spam-Status: No, score=-2.097 tagged_above=-999 required=5 tests=[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, HTML_MESSAGE=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=unavailable autolearn_force=no
Authentication-Results: ietfa.amsl.com (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com
Received: from mail.ietf.org ([4.31.198.44]) by localhost (ietfa.amsl.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 5Ywql_AqUSiW for <wgchairs@ietfa.amsl.com>; Wed, 8 Sep 2021 13:59:10 -0700 (PDT)
Received: from mail-lf1-x135.google.com (mail-lf1-x135.google.com [IPv6:2a00:1450:4864:20::135]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id A91093A37CD for <wgchairs@ietf.org>; Wed, 8 Sep 2021 13:59:09 -0700 (PDT)
Received: by mail-lf1-x135.google.com with SMTP id e23so7441439lfj.9 for <wgchairs@ietf.org>; Wed, 08 Sep 2021 13:59:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=XRcgb5B7TrrJz1TlFMx061d/D9UigZJhUwM8+XxSDbM=; b=HHqxQ7WyAf5e/u0jXj1r1+VKaFooyrpzulY9h+MhoPElJgj4JjBVncTElJxxoO3Aiq UbdGcSLuAkHuNVpMrfdp09fchnAaj1DH0VR/CHkYUnmvFOqwZ6T3qi8wjKWHMAot957X yaOaV5SGJfj5NeWCmaNl/q9HlZuAxGMc2QSofsRKSL2IJubipdVKgxTEY1dZ7BedDKHi 9jJ/aK991jpj9KZYsHO6axVU18npNhtRHUn/i3pr7o4FI8mWQj3s7/nUU9bhSzYIjmzv PT/nRhPRHxEqxZkXC4Wrfga2fafvelWLD0+2/TAdqaOwsL5zZHRDl+4Ie3I3fggNL+q4 MVjg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=XRcgb5B7TrrJz1TlFMx061d/D9UigZJhUwM8+XxSDbM=; b=288m91UaGP+qoxKBEGi0OU9hVIScg90f6Nvcm8s7LCg5xslHIvWbvjKGs6/GjKHXQ3 xtITc3kRsjr7TU8naAxRWra8Beq+doqoQupr0YRJ3YyYsUXiz+3MGI9lqNWo/j+fouC7 /P1YG8iQh4upRP0dshkrA8ZSns1xp1geEfkBCr6wRDNMTesEZkWiAkWE+tr27AHfxWWA QnmCcP79JlME5cT2hyx9bAM6CVCEUXr+lq3cFU7sbRKnA9iXscngHT7DCX+Lzyo0bpJH v0hkfRexd5HGa1x3cLZoCzKWjHcMVI0urbBvBOoL36WAiBJDQ/SnZp42SlRZXEY1UxLZ ZSzg==
X-Gm-Message-State: AOAM532PXyJJpyKOetO3lsdym56vgnhQmXof5rWCCz+k/tpPUDxHQ1Rs 5ceIiY0DurYQKoSBu1EmlVkM4+Q3CIkrRb8+vIylP2puFjQ=
X-Google-Smtp-Source: ABdhPJz0lvCcZI4pT29swdqsWecsQkCNOtahZN1jmhwa42szoWnZYdtXx79U6kiXKC08zCPFqlRHWkLUy6PUtMJtLMc=
X-Received: by 2002:a05:6512:114c:: with SMTP id m12mr49523lfg.162.1631134745813; Wed, 08 Sep 2021 13:59:05 -0700 (PDT)
MIME-Version: 1.0
References: <10ae6318-ff47-000c-aac0-a6720d32d132@ri.se>
In-Reply-To: <10ae6318-ff47-000c-aac0-a6720d32d132@ri.se>
From: Tim Wicinski <tjw.ietf@gmail.com>
Date: Wed, 08 Sep 2021 16:58:54 -0400
Message-ID: <CADyWQ+EnrDt-ohLdoZTxYtKmspvNVn+_mq8dYAS-qJevGfJR3Q@mail.gmail.com>
Subject: Re: Spreadsheet to aid agenda planning
To: Marco Tiloca <marco.tiloca=40ri.se@dmarc.ietf.org>
Cc: Working Chairs <wgchairs@ietf.org>
Content-Type: multipart/alternative; boundary="0000000000001ae86b05cb82279e"
Archived-At: <https://mailarchive.ietf.org/arch/msg/wgchairs/xKsFJVdHq5o9GVAa0b8NxXTrEFA>
X-BeenThere: wgchairs@ietf.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: Working Group Chairs <wgchairs.ietf.org>
List-Unsubscribe: <https://www.ietf.org/mailman/options/wgchairs>, <mailto:wgchairs-request@ietf.org?subject=unsubscribe>
List-Archive: <https://mailarchive.ietf.org/arch/browse/wgchairs/>
List-Post: <mailto:wgchairs@ietf.org>
List-Help: <mailto:wgchairs-request@ietf.org?subject=help>
List-Subscribe: <https://www.ietf.org/mailman/listinfo/wgchairs>, <mailto:wgchairs-request@ietf.org?subject=subscribe>
X-List-Received-Date: Wed, 08 Sep 2021 20:59:16 -0000

We use one of these in DNSOP that I think I stole from Warren.  It has the
advantage of doing
some math in the columns, because you know, math is hard

https://docs.google.com/spreadsheets/d/1Yv_AD2TfPo8WY8UKjpl78Y5hzY5U1qAvdCOM_hWVwq0/edit?usp=sharing


On Wed, Sep 8, 2021 at 4:56 PM Marco Tiloca <marco.tiloca=
40ri.se@dmarc.ietf.org> wrote:

> Hi all,
>
> During a WG Chair training session this week, we also discussed
> approaches for planning a meeting agenda, especially for WG sessions at
> main IETF meetings.
>
> Some suggested me to share on this list about a pretty frugal "tool" I
> mentioned, that I've been using for a while, i.e., a simple spreadsheet.
>
> Not fancy at all, but I found it helpful for "simulating" the agenda
> slots and their duration all in front of me at a glance, while quickly
> and easily adjusting the duration of agenda slots to fit the overall
> time budget.
>
> So, please find the spreadsheet attached to this mail. The "How likely?"
> green/yellow/red indicator is just a qualitative, aggregated estimator
> of factors that influence an inclusion in the agenda, e.g., a topic's
> urgency/priority or chances to actually have updates to present/discuss
> about a (resubmitted) draft.
>
> Admittedly, this may just be an overkill for some WGs, depending on
> their current workload, patterns, dynamics and so on. However, it was
> pretty useful to early devise the sessions for the CoRE WG in the last
> few IETF meetings, and then adjust and refine the plan as things evolved
> towards an eventual agenda.
>
> Hope this helps!
>
> Best,
> /Marco
>
> --
> Marco Tiloca
> Ph.D., Senior Researcher
>
> Division: Digital System
> Department: Computer Science
> Unit: Cybersecurity
>
> RISE Research Institutes of Sweden
> https://www.ri.se
>
> Phone: +46 (0)70 60 46 501
> Isafjordsgatan 22 / Kistagången 16
> SE-164 40 Kista (Sweden)
>
>