Spreadsheet to aid agenda planning

Marco Tiloca <marco.tiloca@ri.se> Wed, 08 September 2021 20:55 UTC

Return-Path: <marco.tiloca@ri.se>
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 7EA3D3A3804 for <wgchairs@ietfa.amsl.com>; Wed, 8 Sep 2021 13:55:30 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -2.1
X-Spam-Level:
X-Spam-Status: No, score=-2.1 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, MSGID_FROM_MTA_HEADER=0.001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=ham autolearn_force=no
Authentication-Results: ietfa.amsl.com (amavisd-new); dkim=pass (1024-bit key) header.d=ri.se
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 Wi60YrfUxjpP for <wgchairs@ietfa.amsl.com>; Wed, 8 Sep 2021 13:55:25 -0700 (PDT)
Received: from EUR04-HE1-obe.outbound.protection.outlook.com (mail-eopbgr70049.outbound.protection.outlook.com [40.107.7.49]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id A05B73A37FE for <wgchairs@ietf.org>; Wed, 8 Sep 2021 13:55:23 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=fRbuLRgE4aKdaOxVRBR54YpJotzqiydchp++IlD0DI+JX1BaWfdfUZAmMc30P64SUWx7o0nryRiW6OkfGWG+2NCAsEF/VhQgvCZZVt2sP1vfytTGrXVBesxwAKeMsU23RfRNDgwzUphXEt3pBJsAK/eKnEQDTV1w8wRZqyMmMjrLBeie+68Zg0hQTM9R5KMulu5yOf01SBGhI0uPMOEA6JvKsiCuNl08EbaJNqIIxpbH3d8UCJAZr3w/Lv+JTZK4kvZp6Bypohh18TtC5egEgohDW9Ag2JT01ORMX1XfgU20gI4a12/4W6bVRuOt6I3OkQG14VWRGJC8eXad8CnPiw==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=xNt8XLIihxtMUxVcSgBeFCF4LTHUJpbvJb8MPRB17VE=; b=SU4rvfWwaAIYPloBqixTm/UJxBzHVmOrfRxYkmLyr30+5zNwu43f20aaq4wjLHansVSILNzOGixFnzbH4r7vaiIh405wSubKdu/P+2Rza7857YkCGT9obcNtAmwGIMzMAEQ0hgP74MbX/5QG6va+QQOstTQ6o8kdLoxBMvrzO+1DGvX0yaTXEzeXMT7wEMMEzbBrSzsiDN08+kwHBI9BI1IYi16o9xeI18aOsJj0uTTA3zDuCqIkbkXqELjSrmdq4QC1lWtszozgbgTblh8XasqL6M/uqEWg/plkfaBOR17jm/NhyBrAkRQYKkpIE+V4UfsY1EiaI2cTWsBE7qFpww==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ri.se; dmarc=pass action=none header.from=ri.se; dkim=pass header.d=ri.se; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ri.se; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=xNt8XLIihxtMUxVcSgBeFCF4LTHUJpbvJb8MPRB17VE=; b=Gbn3mHnoAyjCpiE1hzLWvJs2qOYadPrnImRZpeIcNMsN7lQgqweuIwn9FA65ozkRGDCH9dTT45SScBeG2OXa2IkD0hxH3suO9XxTBk9dFU0Hzv37zKtM3xGEws+JehBqul4b1HyC+UD1N7TuNLwKpxJV+FxM4kME11mn64+wkvo=
Authentication-Results: ietf.org; dkim=none (message not signed) header.d=none;ietf.org; dmarc=none action=none header.from=ri.se;
Received: from DB8P189MB1032.EURP189.PROD.OUTLOOK.COM (2603:10a6:10:16e::14) by DB8P189MB0618.EURP189.PROD.OUTLOOK.COM (2603:10a6:10:129::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4500.16; Wed, 8 Sep 2021 20:55:19 +0000
Received: from DB8P189MB1032.EURP189.PROD.OUTLOOK.COM ([fe80::d94b:2e87:a8ef:b172]) by DB8P189MB1032.EURP189.PROD.OUTLOOK.COM ([fe80::d94b:2e87:a8ef:b172%6]) with mapi id 15.20.4478.026; Wed, 8 Sep 2021 20:55:19 +0000
To: Working Chairs <wgchairs@ietf.org>
From: Marco Tiloca <marco.tiloca@ri.se>
Subject: Spreadsheet to aid agenda planning
Message-ID: <10ae6318-ff47-000c-aac0-a6720d32d132@ri.se>
Date: Wed, 08 Sep 2021 22:55:17 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0
Content-Type: multipart/signed; micalg="pgp-sha256"; protocol="application/pgp-signature"; boundary="T2eKLuB5SL4AcfowEJHSCfrKhsMcydsSx"
X-ClientProxiedBy: HE1PR0701CA0043.eurprd07.prod.outlook.com (2603:10a6:3:9e::11) To DB8P189MB1032.EURP189.PROD.OUTLOOK.COM (2603:10a6:10:16e::14)
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
Received: from [10.8.3.2] (185.219.140.230) by HE1PR0701CA0043.eurprd07.prod.outlook.com (2603:10a6:3:9e::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4523.8 via Frontend Transport; Wed, 8 Sep 2021 20:55:19 +0000
X-MS-PublicTrafficType: Email
X-MS-Office365-Filtering-Correlation-Id: b6d415b0-cf85-4524-6017-08d9730af7cb
X-MS-TrafficTypeDiagnostic: DB8P189MB0618:
X-Microsoft-Antispam-PRVS: <DB8P189MB061856DEBBB240927B45061399D49@DB8P189MB0618.EURP189.PROD.OUTLOOK.COM>
X-MS-Oob-TLC-OOBClassifiers: OLM:10000;
X-MS-Exchange-SenderADCheck: 1
X-MS-Exchange-AntiSpam-Relay: 0
X-Microsoft-Antispam: BCL:0;
X-Microsoft-Antispam-Message-Info: CYz0l5o846hepRKcO16na9BVNqC6NPcwyqUkAEnqT84dF5fyI/BVJRSTNQZCVlcWZZwjmmUNqGFp7R6yqFy3+y2qO7GnxB4xWRh8UvybQQKejEiCcyORAdMBR+nwlEeFWieJdzaTjeMMDmuxaUFUiH3fJJ8ZET9euC5nNN3wPJ4MzAvOOibprIz6zNH0ozDzmZh4vwT03gyhhALnQFouMkWjqSpoPIujtnkhzDxz+GZrkpATwIovvAnnmWesWVDtIGHZ3Yxptxpfk/5if4CZYyvRhQbKdvtPESPnUT1gcEpxSWnZ8uViI+AQ9gpi/kDOnAz26XJDoedekkeVvYBtUeOC7a/mqgQZpwKqk4dl/TpekcUg31I72m7+0lQ5bCeFlfOwsKElsvxTGgaDkcMx02qt/iGBLGxG1MR/NOqFvB5k11i6jNqvzJ/TKSIPOLRf7wEwOevGwF48TsJsWatZv2EgQ7o1BZ2S66IqbZes8Vj0g2Y/BtyXIZzOS6cN5Ne4YPp1r9VU0vHLa4JYJSArl3Ukx+i/uqKjlMcpEs9tx67uJepeM9H7cHgveYka+OeDNdFLkrBZjD3zdJoe5HK3DbxaS3cP9t+/gMQnyI/kQZU/TECmasUQ40S2coDw4lZ8BK/LgT/tVY4+Hai2eQt8z6UxsPZ53DSwi2PhdPRvCIq0fm18Utf2TKEjB86Cmpy00BSeQJD2G8Au1iLQMez/GSMuSxL9kHeYuq8aK/oLh2jQmcvJIkpQ8YfJ1pEfJtg2JwDe8sdlBSWhXS3STldtig==
X-Forefront-Antispam-Report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:DB8P189MB1032.EURP189.PROD.OUTLOOK.COM; PTR:; CAT:NONE; SFS:(4636009)(366004)(2616005)(8676002)(38100700002)(36756003)(66616009)(66476007)(5660300002)(186003)(316002)(235185007)(508600001)(31686004)(66556008)(16576012)(966005)(2906002)(6486002)(26005)(66946007)(956004)(21480400003)(8936002)(86362001)(83380400001)(44832011)(33964004)(6916009)(31696002)(43740500002)(45980500001); DIR:OUT; SFP:1101;
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: a+q+RcgMB30cnsEax0Yv8Q9s33cuUdQw79jVRkf8XKQd1YRMajZtQR1f3aJ/5EOh8xxmby9X7NJ14P5voD/KGA0wbaJ10RT4n642z4VDRGebMRcRJokuZAxmkmkmhaFZOhtrSYOLj2nsoE17/2Hg1/5gllx+mix3dZKW2HEfwFXeMrYHRRLMSYCZ9cvimDDAumiksDXvmujQyzMqfa8C2+GDrxy0imXR3Z5GZiglSFlIkOhCZlQNfNgJoJQ0YB8kpIp1IQgDAH9M09DJ9YZGPxjYI552XmOVSY/lUd1Y69bXqktEN9BxZzUN+ngFKrA6KiYhgWjQ68kxtfvOB0tfpFD3G1b3lPbOa2bMKKc82ZpwFy2iqPSaQAYMnjtRwpKe/LWdNqEFrkWexO+ckhF1fGNBnzp2g2A6/52UeGg8I+8CBPkg7Uxag/JCQaml8BB/IKk5McbI8GdzCtLvkB0nkHPaV4uWezTFTpgDvGZgLHtUHykd4aEPoryYkAD6Y7rcNck7/QppQ8ricxl5dtYEmuPI+ONh10du/QkXvnsdrjyEVbqx+p6iDJhpQr24NL+0tSJnRs/HGIWPEnBvV5BJk5Z1qU6RzXySO8kVDU2wIVzxjXq7/AVVNHRhKXbV6TcBkJzD4ZaagaQ0FXlCpdD8FyKXSczhV7MgLvyF9dm+Zu9vPLodfE3SA8ERHd4W2mFh/AU6jdnDgRtp97rNoBEXbor4akcW2MhApVVwbRWgKIuWkEJTyazWpRHtKygjQfN6hTKpTRolyRuRLAD3VKbJABE8XwHr4NvfFGB7GslOfS6Ig2fmu2WXyJgpEgwYGpcmAQ2Bhms2JXrhFN8pCrwUPJOt8z0Ivi6QCrnhODBJfgzlA5TE+nNyIbKQ+R0e57Syw7H21qiwdL9BLtpvfCklihms/QKIHNLAQUVicjeZffeYlrN1td/Kl/syAtOjH6VYV3oQzfYFtkQpJ0JUZpDV6QoUjZxtJS7cIERZpZqo7cGb3cykillIkbecu1Wde+tBAuYtQ9+R9WpdMBy/ytBO7lqOLYkpG/AxscfmYFgmFQ/xhr8Jzo0L4YoljVbdNjxnZxkJQ7772K91cxIgVuUdseZVp6Y+NomTHeJmQq1ZC4mV8DANlV+4zNmnpjyx9fH080WmPAzUBVgrd/RfoW7on7OE66r8pswrBicoNDJeWwQUtgUVFEsAjY+3IzY4id9Vb90cP+5C4Y0TcUre0yZBUktSrseCV/q8h1I9Ztfxnhq0QC6xwwHdkVYlHMxMovQAkq47X6jl2NKVE8ReMiQ4tUH0OrDobOkER07Pa0ha2hzZFOcoorlvby8ZYuwrkhRh
X-OriginatorOrg: ri.se
X-MS-Exchange-CrossTenant-Network-Message-Id: b6d415b0-cf85-4524-6017-08d9730af7cb
X-MS-Exchange-CrossTenant-AuthSource: DB8P189MB1032.EURP189.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 08 Sep 2021 20:55:19.5874 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 5a9809cf-0bcb-413a-838a-09ecc40cc9e8
X-MS-Exchange-CrossTenant-MailboxType: HOSTED
X-MS-Exchange-CrossTenant-UserPrincipalName: zlvDl4F1C4PDe1yWvShNObe0xERUSTf49pLiHJvVHm1g+ImbHcsaHGi651NFcvtV3Dz9pjX5aue8+aIKHkEgJw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB8P189MB0618
Archived-At: <https://mailarchive.ietf.org/arch/msg/wgchairs/5ujJgIo8yBbwwOistBv8n4e7ZQU>
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:55:31 -0000

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)