tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 685789d1594199306-2-fold-problem-data-issue-and-multiple-countif-with-exclusions-sales-funnel-help
Sheet: Sheet4

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEXT TO COLUMNS FOR THE DATES IN THE RAW FILE
 |  |  | Exclude | X | Y
 | Course module viewed
 |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00
 |  | Course: Field Guide
 |  | File: [DOWNLOAD] The 10 Cardinal Principles Presentation
 |  | Folder: Resources : Business As Usual
 |  | Folder: Resources: Assess Liquidity and Plan Scenarios
 |  | Folder: Resources: How to use the field guide
 |  | Folder: Resources: Manage Investors to Raise Funds In Crisis
 |  | Folder: Resources: Negotiating with customers
 |  | Folder: Resources: Negotiating with suppliers
 |  | Folder: Resources: Pivot Business Model During Crisis
 |  | Folder: Resources: Plan Internal Communication For Restructuring Roles And Org
 |  | Folder: Resources: Reduce costs to improve runway
 |  | Folder: Resources: Reset strategy for a new world
 |  | Folder: Resources: Restructure roles and organisation to suit new normal
 |  | Folder: Resources: Return To Work
 |  | Folder: Resources: Return To Work
 |  | Folder: Resources: Setting up your task team
 |  | Forum: Announcements
Spreadsheet: 755516d1636926264-help-me-with-formula-to-correctly-calculate-unsocial-hours-worked-sample-timesheet-2-
Sheet: Data

 | Duty Periods |  |  |  | Total Hours
 | From | To | Core | OT
 | 00:30:00
 | 01:30:00
 | 02:30:00
 | 03:30:00
 | 04:30:00
 | 05:30:00
 | 06:30:00
 | 07:30:00
 | 08:30:00
 | 09:30:00
 | 10:30:00
 | 11:30:00
 | 12:30:00
 | 13:30:00
 | 14:30:00
 | 15:30:00
 | 16:30:00
 | 17:30:00
 | 18:30:00
 | 19:30:00
 | 20:30:00
 | 21:30:00
 | 22:30:00
 | 23:30:00
 | 1900-01-01 00:30:00
 | 1900-01-01 01:30:00
 | 1900-01-01 02:30:00
 | 1900-01-01 03:30:00
 | 1900-01-01 04:30:00
 | 1900-01-01 05:30:00
 | 1900-01-01 06:30:00
 | 1900-01-01 07:30:00
Spreadsheet: 794756d1662299010-count-the-number-of-days-from-arrival-to-current-date-lookup-xmatch-aligw
Sheet: Sheet1

 | FORMULA HERE | AUGUST 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER 2022
 | # of days (from arrival to current date) | 2022-08-01 00:00:00 | 2022-08-02 00:00:00 | 2022-08-03 00:00:00 | 2022-08-04 00:00:00 | 2022-08-05 00:00:00 | 2022-08-06 00:00:00 | 2022-08-07 00:00:00 | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 | 2022-08-12 00:00:00 | 2022-08-13 00:00:00 | 2022-08-14 00:00:00 | 2022-08-15 00:00:00 | 2022-08-16 00:00:00 | 2022-08-17 00:00:00 | 2022-08-18 00:00:00 | 2022-08-19 00:00:00 | 2022-08-20 00:00:00 | 2022-08-21 00:00:00 | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00 | 2022-08-26 00:00:00 | 2022-08-27 00:00:00 | 2022-08-28 00:00:00 | 2022-08-29 00:00:00 | 2022-08-30 00:00:00 | 2022-08-31 00:00:00 | 2022-09-01 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | 2022-09-04 00:00:00 | 2022-09-05 00:00:00 | 2022-09-06 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00 | 2022-09-09 00:00:00 | 2022-09-10 00:00:00 | 2022-09-11 00:00:00 | 2022-09-12 00:00:00 | 2022-09-13 00:00:00 | 2022-09-14 00:00:00 | 2022-09-15 00:00:00 | 2022-09-16 00:00:00 | 2022-09-17 00:00:00 | 2022-09-18 00:00:00 | 2022-09-19 00:00:00 | 2022-09-20 00:00:00 | 2022-09-21 00:00:00 | 2022-09-22 00:00:00 | 2022-09-23 00:00:00 | 2022-09-24 00:00:00 | 2022-09-25 00:00:00 | 2022-09-26 00:00:00 | 2022-09-27 00:00:00 | 2022-09-28 00:00:00 | 2022-09-29 00:00:00 | 2022-09-30 00:00:00
Adams |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3
[NAME] |  | 3 | 3 | 3 | 3 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3
Evans |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 1 |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 1 |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1
Hills |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
1 | DEPART
2 | [NAME]
3 | WHOLE DAY
Spreadsheet: 838497d1691067825-formula-help-to-add-recurring-number-sequence-up-to-a-limit-and-age-formula-excel-query1
Sheet: Sheet1

DOB | Event Date | Age at event | Until age | Result date
1957-08-11 00:00:00 | 2012-03-16 00:00:00 |  | 66
 |  |  |  | ( formula to add every 3 years until reaching "until age" - (to include the last full 3 year period either before or after the until age date))
 |  | Looking for a formula which adds continuous 3 years increments up to the "Until Age" input number in column D
 | plus 3 years | 57 years 217 days
 | plus 3 years | 60 years 217 days
 | plus 3 years | 63 years 217 days |  | Then as per this example adds the 12 years to give the date at that age
 | plus 3 years | 66 years 217 days |  | Date at 66 years 217days = 11/08/1969
Spreadsheet: 231772d1367223286-how-to-sort-information-based-on-date-in-a-header-row-excel-schedule
Sheet: Jul

 |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2
 | 2013-01-01 00:00:00 |  | J | u | l | y
Job No. | Activity | Start Date | 2013-07-01 00:00:00 | 2013-07-02 00:00:00 | 2013-07-03 00:00:00 | 2013-07-04 00:00:00 | 2013-07-05 00:00:00 | 2013-07-06 00:00:00 | 2013-07-07 00:00:00 | 2013-07-08 00:00:00 | 2013-07-09 00:00:00 | 2013-07-10 00:00:00 | 2013-07-11 00:00:00 | 2013-07-12 00:00:00 | 2013-07-13 00:00:00 | 2013-07-14 00:00:00 | 2013-07-15 00:00:00 | 2013-07-16 00:00:00 | 2013-07-17 00:00:00 | 2013-07-18 00:00:00 | 2013-07-19 00:00:00 | 2013-07-20 00:00:00 | 2013-07-21 00:00:00 | 2013-07-22 00:00:00 | 2013-07-23 00:00:00 | 2013-07-24 00:00:00 | 2013-07-25 00:00:00 | 2013-07-26 00:00:00 | 2013-07-27 00:00:00 | 2013-07-28 00:00:00 | 2013-07-29 00:00:00 | 2013-07-30 00:00:00 | 2013-07-31 00:00:00
 |  | [NAME] | 2013-07-01 00:00:00 | 2013-07-02 00:00:00 | 2013-07-03 00:00:00 | 2013-07-04 00:00:00 | 2013-07-05 00:00:00 | 2013-07-06 00:00:00 | 2013-07-07 00:00:00 | 2013-07-08 00:00:00 | 2013-07-09 00:00:00 | 2013-07-10 00:00:00 | 2013-07-11 00:00:00 | 2013-07-12 00:00:00 | 2013-07-13 00:00:00 | 2013-07-14 00:00:00 | 2013-07-15 00:00:00 | 2013-07-16 00:00:00 | 2013-07-17 00:00:00 | 2013-07-18 00:00:00 | 2013-07-19 00:00:00 | 2013-07-20 00:00:00 | 2013-07-21 00:00:00 | 2013-07-22 00:00:00 | 2013-07-23 00:00:00 | 2013-07-24 00:00:00 | 2013-07-25 00:00:00 | 2013-07-26 00:00:00 | 2013-07-27 00:00:00 | 2013-07-28 00:00:00 | 2013-07-29 00:00:00 | 2013-07-30 00:00:00 | 2013-07-31 00:00:00
1
1.2
2.1
2.2
2.3
2.4
2.5
3
3.1
3.2
4
4.1
4.2
4.3
5
5.1
5.2
5.3
6
6.1
6.2
6.3
6.4
7
7.1
7.2
7.3
7.4
7.5
8
8.1
8.2
8.3
8.4
8.5
8.6
Spreadsheet: 768516d1645007724-copy-an-entire-row-based-on-specific-column-meeting-criteria-copy-entire-row-if-criteria-met-in-specific-colomn
Sheet: Sheet1

days | item | supplier
mon | box | adam
tue | card | [NAME]
wed | square | [NAME]
[NAME] | circle | [NAME]
fri | line | mary
sat | hex | jess
[NAME] | traingle | [NAME]
wed | hex | [NAME]
[NAME] | traingle | mary
fri | card | mary
sat | square | jess
[NAME] | circle | [NAME]
wed | line | [NAME]
wed | hex | [NAME]
[NAME] | box | [NAME]
fri | card | [NAME]
sat | square | [NAME]
Search Supplier |  | [NAME]
[NAME] | traingle | [NAME]
[NAME] | circle | [NAME]
fri | card | [NAME]
Spreadsheet: e3984e37-eacd-4232-b916-eea0414eba41
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (7 [NAME]):
 | 5 Labortechnische Geräte 5.4 Labortechnik und Laboreinrichtung 5.4.8 Zulieferprodukte 5.4.8.3 Kunststoffteile für analytische und labortechnische [NAME]
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | Berghof Products + Instruments GmbH | Deutschland | [NAME] | 72800 | A1.417
2 | BRAND GMBH + CO KG Fabrik für Laborgeräte | Deutschland | Wertheim | 97877 | B1.323/422
3 | CubiDesign Gehäuse GmbH | Deutschland | Hildesheim | 31137 | B2.102
4 | Fibracon : Insoll Machined Plastics | Großbritannien | High Peak | SK23 0QZ | B2.314
5 | IDEX Health & Science | Deutschland | Wertheim | 97877 | A3.221/320
6 | National Lab GmbH Kälte- und Temperiertechnik | Deutschland | [NAME] | 23879 | B2.200
7 | Thermo Scientific | Deutschland | Dreieich | 63303 | B1.101/202
Spreadsheet: 4a5060bc-b5bd-46b9-b378-bb9c0f17680f
Sheet: Page 2

Permit No.: |  |  | WQ0013200 |  |  | Facility Name: |  | Southeast Brunswick Sanitary District WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 04 (PGM 9) |  | Field Name: |  | 04 (T&R HIGH) |  | Field Name: |  | 05 (PGM 4) |  | Field Name: |  | 06 (PGM 16)
 |  |  |  |  |  | Area (acres): |  | 10.21 |  | Area (acres): |  | 25.54 |  | Area (acres): |  | 3.99 |  | Area (acres): |  | 2.57
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 98.8 |  | Annual Rate (in): |  | 37.4 |  | Annual Rate (in): |  | 37.4 |  | Annual Rate (in): |  | 98.8
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: ad3c101c-53cb-4252-bb2f-28defc6f9d04
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40151527 | 2014-02-20 21:14:47 | AXIS | 1 | 10 | 4 | 1207815 | Juju0506 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40152146 | 2014-02-20 21:49:09 | ALLIES | 0 | 7 | 10 | 1207815 | Juju0506 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40221794 | 2014-02-24 21:32:53 | AXIS | 1 | 5 | 4 | 1498194 | Dondiego | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
40222245 | 2014-02-24 21:53:01 | ALLIES | 1 | 5 | 2 | 1498194 | Dondiego | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
40382751 | 2014-03-06 14:33:12 | AXIS | 1 | 6 | 2 | 1487332 | Freuden | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
40382891 | 2014-03-06 14:50:08 | ALLIES | 1 | 6 | 2 | 1487332 | Freuden | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
40385417 | 2014-03-06 18:55:11 | AXIS | 0 | 5 | 7 | 14063 | Corregidor | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
40402315 | 2014-03-07 20:46:02 | ALLIES | 1 | 7 | 5 | 722588 | Lucius109 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40402547 | 2014-03-07 21:03:16 | AXIS | 1 | 7 | 6 | 722588 | Lucius109 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 181517d1348063521-how-to-add-more-ranges-to-my-formula-example
Sheet: Monday

 | L1 PFF | P20 PFS | M1 PFF
 | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | "=INDEX(Monday!$B$3:$K$3" | <Want to include Row 10, 17 and 24.
 |  |  |  |  |  |  |  |  |  |  |  |  | ",MATCH(Sheet1!A1,Monday!$B$4:$K$4,0))" | <Want to include Row 11, 18 and 25.
 |  |  |  |  |  | Vehicle List
 |  |  |  |  |  | DIGITAL | ANALOGUE | VANS
 |  |  |  |  |  | L1 PFF | P20 PFS | M1 PFF
 |  |  |  |  |  | [NAME] | PF02 PFF | P400 PFS
 |  |  |  |  |  | [NAME] | PF03 PFF | P800 PFS
 |  |  |  |  |  | P50 PFS | PF04 PFF | P900 PFS
 |  |  |  |  |  | P70 PFS | PF04 PFS | V12 PFF
 |  |  |  |  |  | P88 PFS | PF05 PFF | X16 PFF
 |  |  |  |  |  | P100 PFF | PF53 PFF
 |  |  |  |  |  | P200 PFS | W14 PFF
 |  |  |  |  |  | P222 PFS | W15 PFF
 |  |  |  |  |  | P300 PFS | [NAME]
 |  |  |  |  |  | P333 PFS
 |  |  |  |  |  | P444 PFS
 |  |  |  |  |  | P500 PFS
 |  |  |  |  |  | P600 PFS
 |  |  |  |  |  | P700 PFS
 |  |  |  |  |  | P777 PFS
 |  |  |  |  |  | P888 PFS
 |  |  |  |  |  | R2 PFF
 |  |  |  |  |  | R7 PFF
 |  |  |  |  |  | T9 PFF
 |  |  |  |  |  | T10 PFF
Spreadsheet: 119424d1314380798-master-break-schedule-disaster-breaklist
Sheet: Thursday

 |  |  | Revised August 5th, 2011 - Jcampbell
 | Master [NAME] (all shifts) Thursday into Friday morning
 | Thursday - Friday | 1st break | Lunch | 2nd  Break
 | Amber | off | off | off
 | [NAME] | 08:15:00 | 10:15:00 | 12:45:00
 | [NAME] | 07:45:00 | 09:30:00 | 12:30:00
 | Dominique | off | off | off
 | [NAME] | cashiering entire shift | (8:45 am, 11:30am, 2:15 pm)
 | [NAME] | 09:00:00 | 10:45:00 | 13:15:00
 | [NAME]
 | [NAME] | 09:15:00 | 12:45:00 | 14:15:00
 | Damariss | 10:00:00 | 11:45:00 | 14:30:00
 | Katriona | off | off | off
 | Tarana | off | off | off
 | OPEN | 11:15:00 | 13:45:00 | 15:15:00
 | [NAME] | 12:15:00 | 14:45:00 | 16:45:00
 | [NAME] | 04:15:00 | 18:30:00 | 21:00:00
 | [NAME] | off | off | off
 | [NAME] | 17:15:00 | 19:00:00 | 21:45:00
 | [NAME] | 17:30:00 | 19:30:00 | 22:15:00
 | [NAME] | 17:45:00 | 20:00:00 | 22:30:00
 | [NAME] | 18:00:00 | 20:30:00 | 23:45:00
 | Shanae | 18:15:00 | 20:30:00 | 22:45:00
 | [NAME] | 18:30:00 | 21:15:00 | 23:15:00
 | Sandra | 18:15:00 | 21:00:00 | 23:30:00
 | Kathy | 19:30:00 | 22:00:00 | 1900-01-01 00:00:00
 | Kwan
 | Cathy | 19:15:00 | 21:45:00 | 00:15:00
 | Tonisha | off | off | off
 | [NAME] | 20:00:00 | 22:30:00 | 00:30:00
 | Rebecca | off | off | off
 | [NAME] | 21:30:00 | 23:45:00 | 02:00:00
 | [NAME] | 23:00:00 | 01:30:00 | 03:15:00
 | Charmaine | off | off | off
 | [NAME] | 00:15:00 | 02:45:00 | 05:00:00
 | Debbie | 00:30:00 | 04:15:00 | 05:45:00
 | OPEN | 01:00:00 | 03:30:00 | 05:30:00
 | Suze | 04:00:00 | 06:15:00 | 08:15:00
 | Intervals with 2 people out: 830am, 1030am, 1045am, 1245pm, 615pm-1045pm, 1145pm-1230am
 | [NAME] | 07:45:00 | 09:45:00 | 13:00:00
 | [NAME] | off | off | off
 | [NAME] | 08:45:00 | 11:45:00 | 14:45:00
 | [NAME] | off | off | off
 | Alise | 08:15:00 | 10:45:00 | 13:30:00
 | Nikki | 07:30:00 | 09:15:00 | 12:45:00
 | OPEN | 08:00:00 | 10:15:00 | 13:15:00
 | [NAME] | 08:45:00 | 11:30:00 | 2pm
 | [NAME] | 08:00:00 | 10:15:00 | 13:15:00
 | [NAME] | 08:30:00 | 11:15:00 | 13:45:00
 | [NAME]
 | Simone
 | SandyJo | 09:00:00 | 12:15:00 | 15:00:00
 | [NAME] | 15:45:00 | 17:15:00 | 19:45:00
 | Heather | 16:00:00 | 17:45:00 | off
 | [NAME] | 04:15:00 | 18:15:00 | 20:15:00
 | [NAME] | 04:30:00 | 18:45:00 | 20:30:00
 | [NAME] | 16:00:00 | 17:30:00 | 20:00:00
 | [NAME] | 16:30:00 | 19:15:00 | 21:00:00
 | [NAME] | 16:45:00 | 18:30:00 | 20:45:00
 | [NAME] | off | off | off
 | Rene | off | off | off
 | OPEN | 04:45:00 | 19:00:00 | 21:15:00
 | Adrian | 17:00:00 | 19:30:00 | 21:30:00
 | [NAME] | off | off | off
 | [NAME] | 00:45:00 | 03:30:00 | 05:15:00
 | Otto
 | [NAME] | 23:45:00 | 01:30:00 | 04:30:00
 | [NAME] | off | off | off
 | Skip | 1900-01-01 00:00:00 | 02:00:00 | 04:45:00
 | [NAME] | 00:15:00 | 02:30:00 | 05:00:00
 | Taiesha | off | off | off
 | OPEN | off | off | off
 | All staff must speak to a supervisor before leaving for break, lunch, or end of shift. NO EXCEPTIONS. At no time, may you take a break when TAXI CALLS are holding - without expressed permission from a supervisor.
Spreadsheet: 539473d1506160076-linked-up-worksheets-in-a-summary-summary-sheet
Sheet: 001

Snag Ref | 001 |  |  |  |  |  |  |  |  |  | Snag Risk | Responsibility |  | Summary
Date Raised | 2017-09-21 00:00:00 |  |  |  |  |  |  |  |  |  | High | A
Raised by | J Blogs |  |  |  |  |  |  |  |  |  | Medium | B
Responsibility | A |  |  |  |  |  |  |  |  |  | Low | C
If other |  |  |  |  |  |  |  |  |  |  | Resolved | D
Description | First snag |  |  |  |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  |  |  |  |  | F
Snag Risk | High |  |  |  |  |  |  |  |  |  |  | G
 |  |  |  |  |  |  |  |  |  |  |  | H
Date | Action
 | Snag Raised
2017-09-23 00:00:00
Spreadsheet: df97c929-c9d6-4bd9-bad6-22e2e70c7a67
Sheet: QTD Recon Q4FY10

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Reconciliation of GAAP to Non-GAAP Unaudited Condensed Consolidated Statements of Operations
(in millions, except per share data)
 | Three Months Ended March 31, 2010
 | GAAP Results |  | Acquisition-related expenses |  | Change in Deferred Net Revenue (Packaged Goods and Digital Content) |  | Loss on Strategic Investments |  | Loss on Licensed Intellectual Property Commitment (COGS) |  | Restructuring and other |  | Stock-Based Compensation |  | Income Tax Adjustments |  | Non-GAAP Results
Net revenue | 979 |  | 0 |  | -129 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 850
Cost of revenue | 298 |  | -2 |  | 0 |  | 0 |  | 1 |  | 0 |  | -1 |  | 0 |  | 296
Gross profit | 681 |  | 2 |  | -129 |  | 0 |  | -1 |  | 0 |  | 1 |  | 0 |  | 554
Operating expenses:
Marketing and sales | 171 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -4 |  | 0 |  | 167
General and administrative | 79 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -9 |  | 0 |  | 70
Research and development | 311 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -28 |  | 0 |  | 283
Acquisition-related contingent consideration | 2 |  | -2 |  | 0 |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
Amortization of intangibles | 15 |  | -15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Restructuring and other | 20 |  | 0 |  | 0 |  | 0 |  | 0 |  | -20 |  | 0 |  | 0 |  | 0
Total operating expenses | 598 |  | -17 |  | 0 |  | 0 |  | 0 |  | -20 |  | -41 |  | 0 |  | 520
Operating income | 83 |  | 19 |  | -129 |  | 0 |  | -1 |  | 20 |  | 42 |  | 0 |  | 34
Loss on strategic investments | -1 |  | 0 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Interest and other income (expense), net | -2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -2
Income before provision for income taxes | 80 |  | 19 |  | -129 |  | 1 |  | -1 |  | 20 |  | 42 |  | 0 |  | 32
Provision for income taxes | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  | -41 |  | 9
Net income | 30 |  | 19 |  | -129 |  | 1 |  | -1 |  | 20 |  | 42 |  | 41 |  | 23
Earnings per share |  |  |  |  |  |  |  |  |  |  |  |  | Earnings per share
Basic | 0.09 |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 0.07
Diluted | 0.09 |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 0.07
Number of shares used in computation |  |  |  |  |  |  |  |  |  |  |  |  | Number of shares used in computation
Basic | 327 |  |  |  |  |  |  |  |  |  |  |  | Basic |  |  |  | 327
Diluted | 330 |  |  |  |  |  |  |  |  |  |  |  | Diluted |  |  |  | 330
Spreadsheet: phillip_m_love__30145__200003_OA
Sheet: EAST-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 196365526 | 533064366
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 96028476 | 269283472
4 |  | Option Premiums | 0 | 10354
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 292394002 | 802358192
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -195240163 | -524044474
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -95951921 | -271284464
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 561927 | 1566495
 | Total Purchases: |  | -290630157 | -793762443
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 13934 | 41850
14 |  | Cash Out | 579330 | 1546257
15 |  | Cash In | -721131 | -1967200
16 |  | Synthetic Storage | -136134 | -1121629
 | Total Imbalances: |  | -264001 | -1500722
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 1213095 | 3150492
18 |  | W/D (Purchase from Stg) | -2533756 | -6709343
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -2533756 | -6709343
 | Total Storage: |  | -1320661 | -3558851
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -156215 | -410689.235
 |  |  | 0 | 0
23 | Fuel: |  | -561927 | -1566495
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -2196592
25 |  | Demand | 0
 | Total Transport Expense: |  | 0 | -3932753
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 1165617.6111
31 |  | Prior Month Book Balance | 0 | -563222
 |  | Total MTM Income | 0 | 602395.6111000003
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 702407
34 |  | Originations | 0 | -34406
35 |  | Broker Fees | 0 | -5809
36 |  | Asset Group Demand Charges | 0
37 |  | [NAME] | 0 | 22941.755
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | -202500
40 |  | Miscellaneous | 0 | -72206
 |  | TOTAL INTRA-MTH
FT-East
 |  | Current Month MTM | 0 | 65612 | 0 | 0 |  |  | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 863744d1711128615-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22
Sheet: Game 6

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down