BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//International Cost Estimating and Analysis Association - ECPv6.2.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://www.iceaaonline.com
X-WR-CALDESC:Events for International Cost Estimating and Analysis Association
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
TZID:America/Los_Angeles
BEGIN:DAYLIGHT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
TZNAME:PDT
DTSTART:20250309T100000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
TZNAME:PST
DTSTART:20251102T090000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20250314
DTEND;VALUE=DATE:20250416
DTSTAMP:20260502T114529
CREATED:20250127T153447Z
LAST-MODIFIED:20250127T153447Z
UID:21274-1741910400-1744761599@www.iceaaonline.com
SUMMARY:2025-2027 Election Polls Open
DESCRIPTION:
URL:https://www.iceaaonline.com/calendar/2025-2027-election-polls-open/
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Los_Angeles:20250409T120000
DTEND;TZID=America/Los_Angeles:20250409T130000
DTSTAMP:20260502T114529
CREATED:20250311T183535Z
LAST-MODIFIED:20250311T183535Z
UID:21466-1744200000-1744203600@www.iceaaonline.com
SUMMARY:SoCal Chapter Webinar - Preparing Data for Cost Estimating: Data Consolidation Techniques in Excel
DESCRIPTION:Michael Finnegan has often found it useful in his career to ask two key questions: “How can I make this easier in Excel?” and “How can I reduce my file size?” Join him on Wednesday\, April 9th for a lunchtime webinar as he walks through some basic (and not-so-basic) Excel capabilities relevant to cost estimating. Michael builds tools for data consolidation\, escalation\, reporting\, learning curves\, pricing\, CER development\, and more– while taking approach that avoids a “black box.” He strives to create (and encourages others to create) Excel tools that everyone can use\, understand\, and replicate. Toward that end\, Michael will demonstrate how he applies INDEX/Match\, SumIfs\, OFFSETs\, Power Query\, and other techniques for consolidating and analyzing data. He will also show various methods he uses to keep his file sizes small enough to operate efficiently while handling large(ish) data sets from various sources.
URL:https://www.iceaaonline.com/calendar/socal040925/
END:VEVENT
END:VCALENDAR