tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 757119d1638025115-cant-figure-out-how-apportion-earnings-in-a-period-to-daily-tried-sumifs-function-helpmeplease-aligw
Sheet: Sheet1

Worker | Start Date | End Date | Amount earned | Number of days worked | Amount earned per day
[NAME] | 2021-06-02 00:00:00 | 2021-06-04 00:00:00 | 350
[NAME] | 2021-06-02 00:00:00 | 2021-06-06 00:00:00 | 600
[NAME] | 2021-06-03 00:00:00 | 2021-06-08 00:00:00 | 692
[NAME] | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 137
Desired Result
Date | Daily salary cost |  | Non working formula
2021-06-01 00:00:00 | 0
2021-06-02 00:00:00
2021-06-03 00:00:00
2021-06-04 00:00:00
2021-06-05 00:00:00
2021-06-06 00:00:00
2021-06-07 00:00:00
2021-06-08 00:00:00
2021-06-09 00:00:00 | 0
2021-06-10 00:00:00 | 0
2021-06-11 00:00:00 | 0
Spreadsheet: 025acb2f-e83c-4c56-a5d2-11a5048d1ef7
Sheet: InstructionMethods

Instructional Method Codes for Staff Course Records K-12
Code | Type | Definition | K8 or 9-12 usage
CR | Classroom | Instruction is predominately face-to-face in a classroom setting; internet and other instructional management systems maybe employed to track grades, assignments and homework. | 9-12 only
CS | Classroom Self-Contained | Instruction is delivered by a single teacher and is predominately face-to-face in a classroom setting; internet maybe used as an instructional tool.  Management systems maybe employed to track grades, assignments and homework. | K8 only
CT | Classroom Team | Instruction is delivered by multiple teachers assigned to a single or multiple grade levels or content areas. | K8 only
CC | Classroom Collaborative | External and/or internal instructional leaders model lessons, observer and coach classroom teachers; often a purchased instructional program with substantial teacher professional development may be associated with a college or university. | K8 only
CL | Classroom Looped | One or more teachers continue instruction with a group of students through two or more grade levels. | K8 only
CP | Computer Program | All instruction is delivered through a computer program which may be online or from a CD-ROM. | Both
ITVS | ITV Sending | Interactive live video course.  This designation denotes the section where the instructor is present. | Both
ITVR | ITV Receiving | Interactive live video course.  This designation denotes the section in which students receive the course via ITV. | Both
BH | Blended/Hybrid | This designation denotes reduced classroom seat time and some instruction delivered online.  This designation blends online and face-to-face delivery. | Both
G | Guided | Teacher acts as guide or mentor to student independent work.  Use this designation for scheduled courses classified according to the MCCC as Independent Study. | Both
CO | Completely Online | All instruction is delivered online.  This designation has no required face-to-face meetings.  A student may arrange meetings with small groups of classmates or the instructor. | Both
O | Other | Use this designation when no other designation adequately describes the course delivery type. | Both
Spreadsheet: 172607d1344268736-i-need-to-delete-a-bunch-of-zeros-0-in-a-selected-group-and-not-the-entire-page-example-for-excel-forum-zeros
Sheet: Sheet1

Part # | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00
122000 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 4 | 3 | 0
123000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 6 | 0
124000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 13 | 0
125000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0
126000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | 22 | 0
127000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 0
128000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0
129000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 12 | 0
Spreadsheet: michelle_lokay__26640__C000749EOG04_01
Sheet: INVOICE

 | [NAME]
 |  |  | INVOICE
 | EOG RESOURCES, INC. |  |  | Please Remit To:
 | Attn:  [NAME] |  |  | [NAME]
 | [NAME] |  |  | Dallas, TX   75284-0463
 | Houston, TX 77210-4362
 |  |  |  | INVOICE
 |  |  |  | DATE | TERMS
 |  |  |  | 2001-04-18 00:00:00 | NET 30 DAYS
 | Account | [NAME] | Work Order | CUSTOMER | INVOICE
 | Number | Number | Number | NUMBER | NUMBER
 | 56000000 | 006-01 | C000749.04 | 4000002251 | W06001040240
 | To invoice for related costs to reactivate 6" pronghorn hot tap on the 24" WTX lateral
 | 17.5 miles SE of WT-1 compressor station including  building and all related support
 | systems and piping modifications for valve.  Located in Sec. 15, T23S, R32E in Lea County, NM.
 |  |  | Project Estimated Cost | 423000
 |  |  | Payment 11/00 | -30000
 |  |  | TOTAL AMOUNT DUE
 | Accountant:   [NAME]
 | Marketing:  [NAME]
 | PLEASE ADDRESS INQUIRIES TO:
 | [NAME]
 | P.O. BOX 1188
 | HOUSTON, TX  77251-1188
 | OR CALL:  (713) 853-3912
Spreadsheet: mark_haedicke__24590__2002 Plan Budget Pack - Legal Group 021001(HCODE)
Sheet: Expense Detail

 | 2001 Budget Template - $US
 | Summary  Region - Cost Center Head
 |  |  |  |  | 2000 |  | 2001 |  | 2002
 | Average Headcount ( 2001 = Year End) |  |  |  |  |  |  |  |  | Comments
 | Salaries & Wages |  |  |  | $ |  | $ |  | $
 | Total Annual Salaries
 | Average Cost Per Head
 | Opening Headcount Dec 2001
 | Starters
 | Leavers | -11
 | December 2002
 | Travel & Entertainment
 | Flights
 | Europe - Internal
 | Business @ | 630 |  |  |  |  |  |  |  | - European travel related to deal closure
 | Hotel @ | 205 |  |  |  |  |  |  |  | - European travel related to deal closure
 | Europe - US
 | Economy @ | 1030 |  |  |  |  |  |  |  | - US travel relating to business and conferences
 | Business @ | 4700
 | First @ | 10285
 | Hotel @ | 185 |  |  |  |  |  |  |  | - US travel relating to business and conferences
 | Europe Asia
 | Economy @ | 1675
 | Business @ | 5800
 | First @ | 7535
 | Hotel @ | 270
 | US internal
 | Economy @ | 1895
 | First @ | 2245
 | Hotel @ | 185
 | Other Business Travel |  |  |  |  |  |  |  |  | - Includes Late Taxis, Rail Travel and [NAME] related costs (Germany and Fuel)
 | Entertainment & Meals |  |  |  |  |  |  |  |  | - Includes Late Meals and Travel Related Expenses
 | Client Entertainment
 | Total T&E |  |  | 0
Spreadsheet: 688280d1595680970-existing-formulas-dont-correctly-show-the-status-of-cells-being-either-blank-or-text-pairs
Sheet: Sheet1

 | No | Village | PairedWith | Status
 | 1 | [NAME]
 | 2
 | 3 | [NAME]
 | 4 | [NAME]
 | 5
 | 6
 | 7 | [NAME]
 | 8
 | 9
 | 10 | Sue
 | 11 | [NAME]
 | 12
 | 13 | [NAME]
 | 14 | [NAME]
 | 15
 | 16
Spreadsheet: 120652d1315426341-help-with-formula-for-creating-weekly-hours-worked-hours-worked
Sheet: Sheet1

 |  | W/C 28/08 |  |  | W\C 04/09 |  |  | W/C 11/09
 |  | Start | Finish | Hours Worked | Start | Finish | Hours Worked | Start | Finish | Hours Worked
 | Sunday
 | Monday | 07:00:00 | 16:00:00 | 9
 | Tuesday | 07:00:00 | 13:30:00 | 6.5
 | Wednesday
 | Thursday | 07:00:00 | 18:30:00 | 11.5
 | Friday | 07:00:00 | 17:00:00 | 10
 | Saturday | 07:00:00 | 13:00:00 | 6
 | Total Hours |  |  | 43
 | Sunday |  |  | 0
 | Monday | 07:00:00 | 16:00:00 | 8.999999999999998
 | Tuesday | 07:00:00 | 13:30:00 | 6.5
 | Wednesday |  |  | 0
 | Thursday | 07:00:00 | 18:30:00 | 11.5
 | Friday | 07:00:00 | 17:00:00 | 10
 | Saturday | 07:00:00 | 13:00:00 | 5.999999999999998
 | Total Hours |  |  | 43
Spreadsheet: 874202d1720768107-sum-calculation-sample-1
Sheet: Sheet2

 |  |  |  | REQ | company 1 | company 2 | company 3 | company 4 | company 5 | company 6 | company 7 | Total
Course etc | Running totals 2024 |  |  | REQ |  | 48.54 |  | 48.54 | 48.54
company 1 |  |  |  | REQ | 22.34 |  | 22.34 | 22.34 | 22.34
company 2 |  |  |  | REQ | 175.87 |  |  |  | 175.87
company 3 |  |  |  | REQ |  |  |  |  | 100.96 |  | 100.97
company 4 |  |  |  | REQ | 73.47
company 5 |  |  |  | REQ |  |  |  | 102.5 | 102.5
company 6 |  |  |  | REQ |  | 135.52 |  | 135.52 | 67.76
company 7 |  |  |  | REQ |  |  | 30.56 |  |  |  | 30.56
Spreadsheet: 680197d1590852562-index-match-with-3-criteria-index-match_match-type
Sheet: Sheet2

 |  | 2020-05-31 00:00:00 | 2020-04-30 00:00:00 | 2020-03-31 00:00:00 | 2020-02-29 00:00:00 | 2020-01-31 00:00:00
small | haha | 12 | 34 | 56 | 98 | 85
medium | hehe | 78 | 89 | 910 | 54 | 52
large | hoho | 1112 | 1314 | 1516 | 321 | 63
Less than |  | With 2 criteria |  | With 3 criteria
criteria 1 | haha
criteria 2 | small
criteria 3 | 2020-03-30 00:00:00
Spreadsheet: 883802d1732530950-returning-1-when-it-should-be-0-rows-unique-filter-function-returning-1-when-it-should-be-0-rows-unique-filter-function-v2
Sheet: Backend

Company | 3 |  |  | Company |  | Department |  | Training Topics |  | Month
Department | 1
Training Topics | 1
Month | 12
Total Participant per month |  |  |  |  |  |  |  |  | Problem:
 |  |  |  |  |  |  |  |  | if I choose the month [NAME], how to show Jan-June?
 |  |  |  |  |  |  |  |  | also how to show the Mar: 0, May: 0, which not on rawdata?
Total topic by skill type
 |  |  | Problem:
 |  |  | if I choose Company Z, Dept ALL, Topics ALL, Month January --> Hardskill 1 which should be 0
 |  |  | if I choose company Z, Dept ANS --> #[NAME]?
Spreadsheet: 142762d1330005116-please-help-with-detailed-serial-numbers-book3
Sheet: Sheet1

894270210912500325 | 894270210912500325
 | 894270210912500326
 | 894270210912500327
 | 894270210912500328
 | 894270210912500329
 | 894270210912500330
 | 894270210912500331
 | 894270210912500332
 | 894270210912500333
 | 894270210912500334
 | 894270210912500335
 | 894270210912500336
 | 894270210912500337
 | 894270210912500338
 | 894270210912500339
 | 894270210912500340
 | 894270210912500341
 | 894270210912500342
 | 894270210912500343
 | 894270210912500344
 | 894270210912500345
 | 894270210912500346
 | 894270210912500347
 | 894270210912500348
 | 894270210912500349
 | 894270210912500350
 | 894270210912500351
 | 894270210912500352
 | 894270210912500353
 | 894270210912500354
 | 894270210912500355
 | 894270210912500356
 | 894270210912500357
 | 894270210912500358
 | 894270210912500359
 | 894270210912500360
 | 894270210912500361
 | 894270210912500362
 | 894270210912500363
 | 894270210912500364
 | 894270210912500365
 | 894270210912500366
 | 894270210912500367
 | 894270210912500368
 | 894270210912500369
 | 894270210912500370
 | 894270210912500371
 | 894270210912500372
 | 894270210912500373
 | 894270210912500374
 | 894270210912500375
 | 894270210912500376
 | 894270210912500377
 | 894270210912500378
 | 894270210912500379
 | 894270210912500380
 | 894270210912500381
 | 894270210912500382
 | 894270210912500383
 | 894270210912500384
 | 894270210912500385
 | 894270210912500386
 | 894270210912500387
 | 894270210912500388
 | 894270210912500389
 | 894270210912500390
 | 894270210912500391
 | 894270210912500392
 | 894270210912500393
 | 894270210912500394
 | 894270210912500395
 | 894270210912500396
 | 894270210912500397
 | 894270210912500398
 | 894270210912500399
 | 894270210912500400
 | 894270210912500401
 | 894270210912500402
 | 894270210912500403
 | 894270210912500404
 | 894270210912500405
 | 894270210912500406
 | 894270210912500407
 | 894270210912500408
 | 894270210912500409
 | 894270210912500410
 | 894270210912500411
 | 894270210912500412
 | 894270210912500413
 | 894270210912500414
 | 894270210912500415
 | 894270210912500416
 | 894270210912500417
 | 894270210912500418
 | 894270210912500419
 | 894270210912500420
 | 894270210912500421
 | 894270210912500422
 | 894270210912500423
 | 894270210912500424
Spreadsheet: 753386d1635411076-how-can-i-use-filter-to-show-results-where-any-column-contains-todays-date-filter_example2newaggregate
Sheet: New Cadence July

SERIALNUM | Due Date | [NAME] | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date | Next Due | Open Date
BNA-M1 | 2021-03-25 00:00:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
LAS-M1 | 2021-03-25 00:00:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
LAS-M2 | 2021-03-25 00:00:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
PHX-M1 | 2021-03-25 00:00:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
PHX-M2 | 2021-03-25 00:00:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
MDW-1 | 2021-03-26 00:00:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
IAH-1 | 2021-03-27 00:00:00 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
MCO-CD | 2021-03-29 00:00:00 | 10
MSY-1 | 2021-03-22 00:00:00 | 14
[NAME] | 2021-03-24 00:00:00 | 14
SNA-1 | 2021-03-24 00:00:00 | 14
MCO-AB | 2021-03-24 00:00:00 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
DAL-1 | 2021-03-25 00:00:00 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
PDX-M1 | 2021-03-25 00:00:00 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-19 00:00:00
BWI-NEDS-DELTA |  | 14 |  |  |  |  |  |  | 2021-08-03 00:00:00
TPA-NEDS-1 |  | 14 |  |  |  |  |  |  | 2021-08-07 00:00:00
KOA-1 | 2021-04-07 00:00:00 | 30
Spreadsheet: 814670d1674542211-convert-array-data-into-a-table-table-data-1-ans
Sheet: Sheet1

Existing array with data that is updated regularly
 | [NAME] | [NAME] | [NAME]
2023-01-01 00:00:00 | A | A | C
2023-01-02 00:00:00 | A | A | C
2023-01-03 00:00:00 | A | A | C
2023-01-04 00:00:00 | A | B | C
2023-02-01 00:00:00 | A | A | B
2023-02-02 00:00:00 | A | A | B
2023-02-03 00:00:00 | A | A | B
2023-02-04 00:00:00 | B | C | B
2023-03-01 00:00:00 | B | C | A
2023-03-02 00:00:00 | B | C | A
2023-03-03 00:00:00 | B | C | A
2023-03-04 00:00:00 | B | C | A
convert to table below |  |  |  |  |  | Expected
 | A | B | C |  |  |  | A | B | C
Jan |  | 1 | 4 |  |  | Jan | 7 | 1 | 4
Feb | 6 | 5 | 1 |  |  | Feb | 6 | 5 | 1
Mar | 4 | 4 | 4 |  |  | Mar | 4 | 4 | 4
 | [NAME]:D20  EXTRA SPACES WERE THERE. I HAHVE REMOVED.
Spreadsheet: 120141d1315005316-populate-multiple-cells-w-unique-data-from-one-identifier-test_emc
Sheet: Goal Scoring Worksheet

 | WORK SPACE |  |  | REFERENCE
 | Employee Name | EE6 |  | Past Performance Ratings
 | Employee ID |  |  | 2H FY11 | 1H FY11 | Focal FY11
 | Grade
 | GOAL COUNT & NAME |  |  | Hire Date
 |  | Score |  | SCORE DEFINIFTIONS
 |  |  |  | 1 = | FAR EXCEED GOAL
 |  |  |  | 1.5 = | EXCEED GOAL
 |  |  |  | 2 = | MET GOAL
 |  |  |  | 2.5 = | MET GOAL W/ ISSUE
 |  |  |  | 3 = | DID NOT MEET GOAL
 | Average Score
Spreadsheet: 743457d1628519016-formula-s-for-choosing-and-calculating-milage-rates-expenses_sheet_main
Sheet: January

Employee Business Kilometres & Subsistence Expenses Claim |  |  |  |  |  | Period Ended:
Employee Name: |  |  |  |  | Car Reg
 |  |  |  |  | Engine Size
Home Address:
 |  |  |  |  | Start Odometer Reading
 |  |  |  |  | Current Odometer Reading
Mileage |  |  |  |  |  | Subsistence
 |  |  |  |  |  | <10HR | >10HR | O/N
Date | Reason for Journey |  | To | From | Total | 15.41 | 36.97 | 147
 |  |  |  |  | 1300
 |  | This Month | Last Month | Annual to date
Total Business Kilometres |  |  | 0 |  | Total
Rate Applicable
Value of Mileage Claim (KM x rate) |  |  |  |  | Total Claim (mileage & subsistence)
Rates per Kilometre are determined by Engine Size
 |  | Distance (KM) | Under 1200cc | 1201 to 1500cc | 1501 and over
 |  | 0 - 1500 | 0.3795 | 0.3986 | 0.4479
 |  | 1501 - 5500 | 0.7 | 0.7321 | 0.8353
 |  | 5501 - 25000 | 0.2755 | 0.2903 | 0.3221
 |  | *Rates change after completing 1500/5500 business kilometres
Signed |  |  |  |  | Date
Approved by |  |  |  |  | Date
Return this form within seven days of month end to accounts department
Spreadsheet: c43a0445-d360-461f-8684-557c2cb91f7c
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (7 Entries):
 | 10 Power supplies 10.6 Frequency converters
No. | Company | Country | City | [NAME] | Hall/Booth
1 | CHROMA A.T.E. Europe b.v. | Netherlands | EDE | 6716 AH | A1.632
2 | ET System electronic GmbH | Germany | Altlußheim | 68804 | B2.411
3 | PACIFIC POWER SOURCE Inc. | USA | [NAME] | CA 92614 | A1.654
4 | [NAME] | Germany | München | 81249 | A1.478
5 | [NAME] | Germany | Achern | 77855 | B2.442
6 | Spitzenberger & Spies GmbH & Co. [NAME] | Germany | Viechtach | 94234 | A1.106
7 | Zentro-Elektrik GmbH KG | Germany | [NAME] | 75239 | B2.113
Spreadsheet: 55404d1255526443-drop-down-boxes-template
Sheet: Sheet1

 | Date |  | 2009-11-01 00:00:00
 | Investigator |  | Bijal Dosani
 | Absence |  | Holiday
 | Number of Inward Alerts |  | 10
 | Time Spent Inward Alerts |  | 30
 | Number of Outward Alerts |  | 10
 | Time Spent [NAME] |  | 90
 | Number Alerts |  | 10
 | Time Spent Mail Box |  | 25
 | Number of Queries |  | 2
 | Time Spent Queries |  | 55
 | Time Spent Regular Reading/Viewing |  | 30
 | Training/Coaching |  | 30
 | Team Meetings |  | 15
 | [NAME]! |  | 0
 | Workouts |  | 0
 | Other |  | 60
 |  |  |  |  |  | Name | Position | RACF |  | Absence
 |  |  |  |  |  | Bijal Dosani | Secondary Investigator | DOSANIB |  | Holiday
 |  |  |  |  |  | [NAME] | Secondary Investigator | LEWISCE |  | Sick
 |  |  |  |  |  | [NAME] | Secondary Investigator | DECVPYD |  | Course
 |  |  |  |  |  | [NAME] | Secondary Investigator | FLACCU
 |  |  |  |  |  | [NAME] | Secondary Investigator | MURPCCA
 |  |  |  |  |  | Claudia Parisi | Secondary Investigator | PARISIC
 |  |  |  |  |  | [NAME] | Secondary Investigator | PINTCA
 |  |  |  |  |  | [NAME] | Secondary Investigator | SINGDH
 |  |  |  |  |  | [NAME] | Secondary Investigator | KNIGHDI
 |  |  |  |  |  | [NAME] | Secondary Investigator | BUTLEDG
 |  |  |  |  |  | [NAME] | Secondary Investigator | NYAKAND
 |  |  |  |  |  | [NAME] | Secondary Investigator | MILLSE
 |  |  |  |  |  | [NAME] | Secondary Investigator | GILBELB
 |  |  |  |  |  | [NAME] | Secondary Investigator | MCCLUHA
 |  |  |  |  |  | [NAME] | Secondary Investigator | RUSZECJ
 |  |  |  |  |  | [NAME] | Secondary Investigator | PRICELH
 |  |  |  |  |  | [NAME] | Secondary Investigator | SKEELSL
 |  |  |  |  |  | [NAME] | Secondary Investigator | SOMERLE
 |  |  |  |  |  | Marios Panayi | Secondary Investigator | PANAYIM
 |  |  |  |  |  | Marlon Moise | Secondary Investigator | MOISEM
 |  |  |  |  |  | [NAME] | Secondary Investigator | SHUMM
 |  |  |  |  |  | [NAME] | Secondary Investigator | MUSGODP
 |  |  |  |  |  | [NAME] | Secondary Investigator | WATKIRQ
 |  |  |  |  |  | [NAME] | Secondary Investigator | BAXR
 |  |  |  |  |  | [NAME] | Secondary Investigator | GRANTRC
 |  |  |  |  |  | [NAME] | Secondary Investigator | WRIGHSL
 |  |  |  |  |  | [NAME] | Secondary Investigator | PATELS
 |  |  |  |  |  | [NAME] | Secondary Investigator | ROBERSW
 |  |  |  |  |  | [NAME] | Secondary Investigator | GRIFFSS
 |  |  |  |  |  | [NAME] | Secondary Investigator | AHMADIS
 |  |  |  |  |  | [NAME] | Secondary Investigator | JADEJSB
 |  |  |  |  |  | [NAME] | Secondary Investigator | POTTENS
 |  |  |  |  |  | Troy Attride | Secondary Investigator | ATTRIDT
 |  |  |  |  |  | [NAME] | Supervisor | SMITEAK
 |  |  |  |  |  | [NAME] | Supervisor | RYANJC
 |  |  |  |  |  | [NAME] | Verifier | JOHNSGB
 |  |  |  |  |  | Karen isitt | Verifier | ISITTK
 |  |  |  |  |  | [NAME] | Verifier | DRUMMKR
 |  |  |  |  |  | Olha Leeming | Verifier | LEEMINO
 |  |  |  |  |  | Pam Sales | Verifier | SALESP
 |  |  |  |  |  | [NAME] | Verifier | WOOSTSA
 |  |  |  |  |  | [NAME] | Verifier | WOZNICT
Spreadsheet: 774540d1648540258-according-to-the-selection-of-f1-and-then-id-calculate-the-number-of-class-in-descending-3029
Sheet: Sheet1

CLASS | ID |  | ID | QTY | 2C | CLASS
1C | 1234 |  | 1235 | 7
2C | 1235 |  | 1243 | 3
3C | 1236 |  | 1249 | 2
4C | 1237
5C | 1238
6C | 1239
7C | 1240 |  | When F1 = 2C Sample result |  |  | SAMPLE ONLY |  | 2C | 1235
8C | 1241 |  | 1235 | 7 |  |  |  | 2C | 1235
1C | 1234 |  | 1243 | 3 |  |  |  | 2C | 1235
2C | 1235 |  | 1249 | 2 |  |  |  | 2C | 1235
3C | 1236 |  |  |  |  |  |  | 2C | 1235
1C | 1234 |  | When F1 = 3C  Sample result |  |  |  |  | 2C | 1235
2C | 1235 |  | 1236 | 3 |  |  |  | 2C | 1235
2C | 1235 |  | 1244 | 1 |  |  |  | 2C | 1243
2C | 1235 |  |  |  |  |  |  | 2C | 1243
2C | 1235 |  |  |  |  |  |  | 2C | 1249
1C | 1234 |  |  |  |  |  |  | 2C | 1243
2C | 1235 |  |  |  |  |  |  | 2C | 1249
3C | 1236
4C | 1237
5C | 1238 |  |  |  | 3C | 1236
6C | 1239 |  |  |  | 3C | 1236
7C | 1240 |  |  |  | 3C | 1236
8C | 1241 |  |  |  | 3C | 1244
1C | 1242
2C | 1243
3C | 1244
1C | 1245
2C | 1243
2C | 1249
2C | 1243
2C | 1249
Spreadsheet: 160476d1339090903-excel-2007-index-with-duplicates-department-updates-and-announcements
Sheet: Finance

Announcement Number | Employee Announcements
finance1
finance2
finance3
finance4
finance5
Announcement Number | Manager [NAME]
Finance1manager
Finance2manager
Finance3manager
Spreadsheet: 755257d1636737297-textjoin-in-a-spill-array-formula-textjoin-in-a-spill-array-formula
Sheet: Planilha1

ID | ESTADO |  |  |  |  |  |  |  |  |  |  |  |  |  | =UNIQUE(Tabela1[ID])
1234 | RJ |  |  |  |  |  |  |  |  |  | ID | CIDADE |  |  | ID | CIDADE
1234 | SP |  |  | SP |  |  |  |  |  |  | 1234 |  |  |  |  |  | =CHOOSE(ROW(P3#)-2,TEXTJOIN(" / ",,INDEX(E2#,,1)),TEXTJOIN(" / ",,INDEX(E2#,,2)),TEXTJOIN(" / ",,INDEX(E2#,,3)),TEXTJOIN(" / ",,INDEX(E2#,,4)))
1234 | DF |  |  | DF |  |  |  |  |  |  | 1111 |  |  |  | 1111 | ES / RJ
1111 | ES |  |  |  | ES |  |  |  |  |  | 1212 |  |  |  | 1212 | SP / DF / RJ / ES / MA / AM / RO / MT / MS / PI / PE / RN
1111 | RJ |  |  |  | RJ |  |  |  |  |  |  |  |  |  | 1215 | US
1212 | SP |  |  |  |  | SP
1212 | DF |  |  |  |  | DF
1212 | RJ |  |  |  |  | RJ
1212 | ES |  |  |  |  | ES
1212 | MA |  |  |  |  | MA
1212 | AM |  |  |  |  | AM
1212 | RO |  |  |  |  | RO
1212 | MT |  |  |  |  | MT
1212 | MS |  |  |  |  | MS
1212 | PI |  |  |  |  | PI
1212 | PE |  |  |  |  | PE
1212 | RN |  |  |  |  | RN
1215 | US |  |  |  |  |  | US
Spreadsheet: kate_symes__18095__Deal Correction 12-8
Sheet: Current Day

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2000-12-05 00:00:00
 | 2000-12-05 00:00:00
 | 2000-12-05 00:00:00
 | 2000-12-08 00:00:00 | 2000-12-08 00:00:00 | 2000-12-01 00:00:00 | LTCA | BB | Houston | Natsource | Energy type: from Firm to CAISO |  | 471740 | SP-15 | F-01 | On [NAME] | 25 | 197 | Mieco
 |  |  |  | BB Count
 | 2000-12-07 00:00:00 | 2000-12-08 00:00:00 | 2000-12-07 00:00:00 | STSW | MF | MF | Prebon | Delivery Point: from PV to Mid-C |  | 476435 | Mid-C | Q2-01 | On [NAME] | 25 | 225 | Edison Mission
 |  |  |  | [NAME]
 | 2000-12-08 00:00:00 | 2000-12-08 00:00:00 | 2000-12-04 00:00:00 | LTSW | EES | Houston | N/A | Deal Date: from 12/5 to 12/4 |  | 474438 | COB N/S | F-01 | On [NAME] | 50 | 435 | Powerex
 |  |  |  | EES Count
 | 2000-12-08 00:00:00 | 2000-12-08 00:00:00 | 2000-12-08 00:00:00 | LTSW | MM | Houston | TFS | Delivery Point: from NP to SP |  | 477191 | SP | Q3-01 | On [NAME] | 25 | 185 | Duke
 | 2000-12-08 00:00:00 | 2000-12-08 00:00:00 | 2000-12-08 00:00:00 | LTSW | MM | Houston | TFS | Delivery Point: from SP to NP |  | 477190 | NP | Q3-01 | On [NAME] | 25 | 180 | Duke
 |  |  |  | MM Count
 | 2000-12-08 00:00:00 | 2000-12-08 00:00:00 | 2000-12-08 00:00:00 | LTNW | MS | Houston | Amerex | Broker: from APB to Amerex |  | 477183 | Mid-C | Z-00 | On [NAME] | 25 | 1750 | TransAlta
 |  |  |  | MS Count
 |  |  |  | Grand Count