Re: Spreadsheet to aid agenda planning

Marco Tiloca <marco.tiloca@ri.se> Fri, 10 September 2021 20:05 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 9A45B3A18D0 for <wgchairs@ietfa.amsl.com>; Fri, 10 Sep 2021 13:05:42 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -2.101
X-Spam-Level:
X-Spam-Status: No, score=-2.101 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, NICE_REPLY_A=-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 IAmla9PGfL1I for <wgchairs@ietfa.amsl.com>; Fri, 10 Sep 2021 13:05:36 -0700 (PDT)
Received: from EUR05-AM6-obe.outbound.protection.outlook.com (mail-am6eur05on2040.outbound.protection.outlook.com [40.107.22.40]) (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 59FBE3A18C5 for <wgchairs@ietf.org>; Fri, 10 Sep 2021 13:05:35 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=dJ+ZRoZEP2K2dBKZ9GUrz4m/7t+rcf2ZsRFTEEpdMvPZdnJ78RQuz2cZ0SAVrWMo6ypZcAQiOieNbhHcargUwU17RTUT14zbmbO+nCelSN/nQnF3KLVLxhRH9ZkhlO48dtYBm47y98dGUErIYM+zJcStaPRg3BG355SLzjIB4F8vrVdEuR3v2lyhBqBrw5oguKVtKQlSNLlTqC48jIqRUPBZEL9VZHk551q2hAj0RGXoMiWIxwVGXI8CTC0OzpHONmKnVNOZURMaJPr2AJXKo3NVe96kqcgvlYeOLnTc521lszBsET/mEn431wSY6TRV8wCZs9jZV4ZC1jnJrBBBtw==
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=dPwYECzYElTZUH4cdGsKEeCBSdsy9YM6Z24u6gJqfas=; b=NjnSjSCT4xv70uKZQV8U1q0X6juITb4vxcsBgZ4/fcTcmswDCLEkHsEJDHp9bYb+n+WC5CguCMgvw5WSkG67Hwi9N5hvrB/1y6n3Ww505CT1wNDZl5Zc01lPvi8BJJujw8i4Qx1Bhv0sqexHWKOdxoZ8s6YOCVQTB27CZXNWdp5f6cigyZAu3a9xYiZffCLMYRHKM+A5kJXsLGYRusSU85CfDbkvGyfHgfy5LjJfWQbYIfc2Az4vMSDY9NtaFuSZkLN/fgSzmvKhYQfAWSjpY2nVXchnWByjCJ6h3NqtDCSS9qXgupmZxkGIF5czxANr6Zg/TgGu2HP1gELw+EqfPw==
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=dPwYECzYElTZUH4cdGsKEeCBSdsy9YM6Z24u6gJqfas=; b=gZmSYzO0AKMavlfgqqst5MMHJ92wt2UF/7NH2XedJJZrjwnnL8EtLXDyYXaljQZKcSDufAwTJEexEcLtNpPM3NLjG8Ue8CWXKJq1fPezvHbQMg/6gtiPONBJEovqVw2mS7ZUkzFCeqLbbhCkC2dXRmrjaoeUqCMxHNJT1y6u7EU=
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 DBBP189MB1226.EURP189.PROD.OUTLOOK.COM (2603:10a6:10:1f3::23) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4500.14; Fri, 10 Sep 2021 20:05:31 +0000
Received: from DB8P189MB1032.EURP189.PROD.OUTLOOK.COM ([fe80::d94b:2e87:a8ef:b172]) by DB8P189MB1032.EURP189.PROD.OUTLOOK.COM ([fe80::d94b:2e87:a8ef:b172%7]) with mapi id 15.20.4500.017; Fri, 10 Sep 2021 20:05:31 +0000
Subject: Re: Spreadsheet to aid agenda planning
To: Bob Hinden <bob.hinden@gmail.com>
Cc: Working Chairs <wgchairs@ietf.org>
References: <10ae6318-ff47-000c-aac0-a6720d32d132@ri.se> <888B2C11-ECA6-4C96-B518-9D2BBBDFBAA5@gmail.com>
From: Marco Tiloca <marco.tiloca@ri.se>
Message-ID: <92c58f89-ad40-0576-ea28-9e96f38665dc@ri.se>
Date: Fri, 10 Sep 2021 22:05:28 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0
In-Reply-To: <888B2C11-ECA6-4C96-B518-9D2BBBDFBAA5@gmail.com>
Content-Type: multipart/signed; micalg="pgp-sha256"; protocol="application/pgp-signature"; boundary="RfAgLqiFNMWqUPBuxpAExWjg6Ex6oVD75"
X-ClientProxiedBy: HE1PR0901CA0062.eurprd09.prod.outlook.com (2603:10a6:3:45::30) To DB8P189MB1032.EURP189.PROD.OUTLOOK.COM (2603:10a6:10:16e::14)
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
Received: from [10.8.0.4] (31.13.191.148) by HE1PR0901CA0062.eurprd09.prod.outlook.com (2603:10a6:3:45::30) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4500.14 via Frontend Transport; Fri, 10 Sep 2021 20:05:30 +0000
X-MS-PublicTrafficType: Email
X-MS-Office365-Filtering-Correlation-Id: 36493ec3-3eef-417e-b110-08d97496573c
X-MS-TrafficTypeDiagnostic: DBBP189MB1226:
X-Microsoft-Antispam-PRVS: <DBBP189MB1226ADBA98ABDBB9278EED0A99D69@DBBP189MB1226.EURP189.PROD.OUTLOOK.COM>
X-MS-Oob-TLC-OOBClassifiers: OLM:8273;
X-MS-Exchange-SenderADCheck: 1
X-MS-Exchange-AntiSpam-Relay: 0
X-Microsoft-Antispam: BCL:0;
X-Microsoft-Antispam-Message-Info: taStySzWvOLWHerG0tySEfMchoRO71qkFjM/1Q76JqnPOZItzrekc5Hy5fw3g3RQs08jnUjRxbc5EqVpFEUykR7yyd4ZFT1ILtly+60rKxio2Nf9PzOshql8SXHOMaXh5yQyvA3zs5rLUdgxXwhpat8s9Gz19ZcrEMhl3cuIW2vA8NP8O+x74/UKGnlU5ZxZsE0O0jaxX9r3I8+XQxuShLKqdZC/S12NQed5dcCOCtwsA3Ol1Fetxwm0UA+fjkHs94s6hDz05h14fKIAh9sUQPLQ2vyq72hstwqTk3b89LxiSlLai+iWlVpKkGsOUYobbTkvHzx2u8opUwvWLuhVNZcv5J8HF8uIa3T4kDLwsoi12AA5nel6OFuNp2gmZCIfrCdkezgS4vVWZxT+9i/s+7OippxHPHF71PWnFG5lwKnjkp2S0IwjlhoIR174QtjWFkpI9z9PYrzMqN6leYM9fpaRN4XtBLsFNn/iciTozX+8zVHd4HJoeUj4Uw4jUvN9PQOZbz3XuWiBY0H4qoBxpNAX3Wsl+Ylxy7+b7d70BC2AvCpCN1N1uVXbne6TdyTnLyoEgFL7VwiXV6nXmG2luk7GQ3uQeSjzfLE9a6d4pqrg/4J8/NdQ9S9r1KG1u+cKGf1VzKVlB+k4A4pc8z+TPFrZl3VwV5rb+1sHFYsnF8cVPkscWzf2Hylb0nPB1V8aq56aGsXJJ3qQL6Shh5KxzBU8VW4Cz5Xs5NJ+GBicOVRpBNnCLSzAHm48e+S3uO/HsU4Iho7U6qtyAHRLW/exGtJHxT+Mb60YbXEPwcKwz9rBbKHUKPiyZ0Oo8F4qgEP9
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)(136003)(366004)(346002)(376002)(39860400002)(396003)(66476007)(66946007)(66556008)(31686004)(2616005)(21480400003)(36756003)(478600001)(33964004)(235185007)(956004)(316002)(83380400001)(186003)(8676002)(4326008)(26005)(86362001)(2906002)(38100700002)(53546011)(6916009)(6486002)(8936002)(966005)(5660300002)(16576012)(31696002)(44832011)(45980500001)(43740500002); DIR:OUT; SFP:1101;
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: PqXDX/Ut/MjZRQp//NvJGj5rqW7rcUnFnm8FawB8NOD8TQPJOUS/ndL5rmewAFNDUBxyB85tPTeNOjvqNPfk6wKlqFoC6FpqaJW2hbHwZ2SMrSoh3WRWh/6jVpYRKIJNbQOMuPqQMlpUf8HJXo1ZnNIgaIGOH1vE/OqQDzoE/dCt3Hc4fGI56GhqNeC2JOv5EhoJQdAhswtco7Js0a/0FKvbBm7deYmTdAAXsfAYrekhPI0mdlYk1WW6Uqs+E/yHr755pCFYX0Dq2UeJjY8Eby5FeSjnqgpvcXUJFeOdAyy0HaG6UGwWctpZQk9vUZ63AsnnejZSZDoaq6Im3GNtJflN2O/wTFM6U2zg94wRWNFfMhVvgaCHtOMpEqgVNU9/CF5YbVikxvw/khM4ypVhVx1vKSxUBgtHVH/Zqy2j2jv/H5NZTQUo0UPijtoTxLQ9pvExUDWELLFC++syRN+/IKRDR3RVNf+GarD6447Pk8jS3iSuICueppoCbG8qUTr/LoDch2YkbsY5FceviYHZwyqKq341ch/0SxLNYBJE8O2lF/3b9WFAq/l/uZfoyXZV8KxLbY6bdkiU416XAx8/bYRQuY/BXpMEZb2HO6qLD27grhdXba4TVWlCHTpcpph45cLxMltHaa+7sr4RjwrLuQyRqoiWUA5ObtNxXei+WJd6q60PWxMS66iqLKem6onq3TdmXKocnluSXZVxD7A+dLryubeBwVLKQxmG7fCTWCtwfNCSYLpUOcBJiUmayOAOGaccp86O5AnV+MVeF9YP3HGs3c7cOcxw5qN0WCq8OlSl3cfj+GQid0w7tWzgA1lCMSDmJ8KF3N5ohuwXz8Q2iAIJ/UEFLwwyly8Io7ENHw1kSDE/Bf+Hki9TWxwkvVtS+HUKKlZst68tpdqr0/2Wa8HjLFhIrHwffLGeAuC0fJJKndHNv4U4AlHLj1tH0Qrmcu1qmqMjXQueBGjlPOUckQSnWIVgUPpplxORqWIyGfR+kSHBCdUjvzoQ0bXpGebkzmrTiEST9lcyyijPsro9S0cf/XjDs8iBtoW0pXwO3YxaVyzYmPtJu3bL6j08OXCRS6k+H2EXV45bzchTLR01+6ju7OC9n5ZN3FKHAnGCc3M6aLBXirfKNXXGGvccc6EDDj7q/RWrwQnDTCs9izuVNe1fiWuMXgVSdSicsPJC8N+XtU1kyGZKkBDE78A0w7u6xOc1ffwY9xobEKAJsDc9Y/Zi7XCPDsQYBEFJrgDsg2vdQcqFOyA67vmzsVdv4sOEqG+EdQyE8650TmadZcpyGdXH50hjF7AFYDYKBvkiFABuZY5TBuzA2+iECyU2DFqD
X-OriginatorOrg: ri.se
X-MS-Exchange-CrossTenant-Network-Message-Id: 36493ec3-3eef-417e-b110-08d97496573c
X-MS-Exchange-CrossTenant-AuthSource: DB8P189MB1032.EURP189.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 10 Sep 2021 20:05:31.0323 (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: IwqKAGnG4dcS+V5MnaCu00bGVoQPvNexXuKxiAHHT5LCDnu65sajVPsvYlu8npGOs7ASek0i1Y0tLGzbOxt9Tw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DBBP189MB1226
Archived-At: <https://mailarchive.ietf.org/arch/msg/wgchairs/2KgmX2QiWeiOhgvqTkBUmFP0FMg>
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: Fri, 10 Sep 2021 20:05:43 -0000

Thank you all for the great feedback and pointers!

Best,
/Marco

On 2021-09-09 20:25, Bob Hinden wrote:
> Marco,
>
> In the w.g. I co-chair, we use a google sheet for this, it allows easy collaboration between chairs.   You can see this at:
>
> https://docs.google.com/spreadsheets/d/1_cp-Ny2toj1YfCmQ3nS5xs6wW9jsSi0iMpALG9IxIEc/edit?usp=sharing
>
> We first setup the time of the session(s), and the duration of the session(s).
>
> Then we add requests to the “Requested” section with title, draft, presenter, and requested time.  This allows for seeing how much time has been requested vs. time in the the session.  Also space for our notes/comments/etc.
>
> Then we move items to the “Session” section.    The colors are Green for w.g. document, Blue for documents with active discussion, and Yellow for new documents.
>
> We also have a section for w.g. documents, useful to see if we missed anything.
>
> This works well for us.  Feel free to copy or modify for your own use.
>
> Bob
>
>
>> On Sep 8, 2021, at 1:55 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)
>>
>> <agenda_planning_template.ods>

-- 
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)