tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 718154d1613016394-index-match-multiple-criteria-greater-than-value-excelforum-index-match-greater-than_gt
Sheet: Sheet1

Dynamic Data |  |  |  |  | Static Data |  |  |  | Bank | First Row | Last Row | [NAME] | Tier range |  | [NAME]
Bank | CET1 | Tier |  |  | Bank | CET1 | Tier |  | GS
GS | 5 |  |  |  | GS | 1 | Unsatisfactory |  | BNPP
GS | 27 |  |  |  | GS | 50 | Satisfactory
GS | 49 |  |  |  | GS | 75 | Compliant
GS | 170 |  |  |  | GS | 125 | Buffered
BNPP | 20 |  |  |  | BNPP | 1 | Unsatisfactory
BNPP | 30 |  |  |  | BNPP | 25 | Satisfactory
BNPP | 40 |  |  |  | BNPP | 50 | Compliant
BNPP | 120 |  |  |  | BNPP | 100 | Buffered
Spreadsheet: 794962d1662442134-make-an-average-based-on-the-data-that-contain-number-0-make-an-average-based-on-the-last-data-contain-number-aligw
Sheet: INDEX MATCH

 |  | NO | DATE | Feed |  |  |  |  |  |  | RESULT
 |  |  |  | Morning | Night | TOTAL
 |  | 1 | 2022-09-01 00:00:00 | 0 | 0 |  |  |  |  |  |  |  | THIS IS THE RESULT THAT I WANT
 |  | 2 | 2022-09-02 00:00:00 | 30 | 0
 |  | 3 | 2022-09-03 00:00:00 | 30 | 30 |  |  |  |  |  |  |  | I USE THIS FORMULA; BUT IT SHOWS ERROR
 |  | 4 | 2022-09-04 00:00:00 | 150 | 120
 |  | 5 | 2022-09-05 00:00:00 | 90 | 70 |  |  |  |  |  |  |  | IT ALSO ERROR
 |  | 6 | 2022-09-06 00:00:00 | 120 | 100
 |  | 7 | 2022-09-07 00:00:00 | 120 | 120 |  |  |  |  |  |  | USE CTR+SHFT+ENTER
 |  | 8 | 2022-09-08 00:00:00 | 150 | 30
 |  | 9 | 2022-09-09 00:00:00 | 0 | 0
 |  | 10 | 2022-09-10 00:00:00 | 0 | 0
 |  | 11 | 2022-09-11 00:00:00 | 0 | 0
Spreadsheet: 161838d1339648313-how-to-flag-dates-that-are-within-9-days-of-today-my-debt-plan
Sheet: Credit Cards

Creditor Name | Balance | Rate | Credit Limit |  | Util % |  | Min Pay | Due Date |  |  | Payments @ Min |  |  | Total Credit |  |  |  | Total Cards Min |  |  |  | Today's Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Owed |  |  |  | Total Fixed Min
Alliant Credit Union CC | 1399.93 | 0.1224 | 3000 |  |  |  | 43 | 2012-07-08 00:00:00
Amazon Store Card | 155.93 | 0.2599 | 1000 |  |  |  | 25 | 2012-07-10 00:00:00 |  |  |  |  |  | Util |  |  |  | Total Mth Min
Barclay's Apple Card | 502.57 | 0.2299 | 2000 |  |  |  | 20 | 2012-07-08 00:00:00
Capital One-Cash Back | 896.33 | 0.198 | 3000 |  |  |  | 50 | 2012-07-09 00:00:00 |  |  |  |  |  | Cash in bank | 1600
Chase BP | 159.37 | 0.1924 | 1000 |  |  |  | 50 | 2012-07-21 00:00:00 |  |  |  |  |  | Snowball
Chase Freedom | 1438.58 | 0.2 | 3000 |  |  |  | 50 | 2012-07-13 00:00:00
Discover Open Road | 2373.38 | 0.06 | 4000 |  |  |  | 50 | 2012-07-11 00:00:00
Exxon | 0 | 0.2499 | 650 |  |  |  | 0
Kohls | 0 | 0.23 | 500 |  |  |  | 0
Macys | 0 | 0.245 | 100 |  |  |  | 0
Pay Pal Buyer Credit | 45.87 | 0.2699 | 800 |  |  |  | 25 | 2012-07-15 00:00:00
PSECU VISA | 4465.62 | 0.029 | 10000 |  |  |  | 100 | 2012-07-25 00:00:00
Sears | 0 | 0.28 | 500 |  |  |  | 0
Target | 143.37 | 0.22 | 2000 |  |  |  | 25 | 2012-07-11 00:00:00
Walmart | 0 | 0.229 | 1350 |  |  |  | 0
Navy Federal Visa | 63.13 | 0.1565 | 15000 |  |  |  |  | 2012-07-14 00:00:00
Fake | 500 | 0.18 | 2000 |  |  |  | 14 | 2012-06-20 00:00:00
Spreadsheet: 274857d1383237711-counting-strings-in-a-cell-only-in-a-row-where-another-column-value-0-counttest-abreviated
Sheet: Slection

Qty Req | Total Qty | Remaining | ItemRef | ItemName | RequiredItems | Stock | Qty/Item | Required
1 |  |  | 1001 | Easel | 1004;1004; | 10
 |  |  | 1002 | Blackboard | 1004;1001;1003; | 5
 |  |  | 1003 | Boardwipe |  | 100
 |  |  | 1004 | [NAME] |  | 20 |  |  | H6 needs to count where D6 appears only in rows where the relative cell in column A >0
 |  |  | 1005 | Peg Board | 1004;1004;1004;1004; | 4 |  |  | Therefore H6 should = 2
 |  |  | 1006 | Candellabra | 1007;1007;1007;1007;1007; | 10 |  |  | but currently it is also counting rows that do not have 1 in column A
 |  |  | 1007 | Candle |  | 25
 |  |  | 1008 | [NAME] | 1009; | 25
 |  |  | 1009 | [NAME] |  | 100
 |  |  | 1010 | Radio | 1011;1012;1013; | 25
 |  |  | 1011 | Radio Battery |  | 35
 |  |  | 1012 | Radio Aeriel |  | 25
 |  |  | 1013 | Radio Belt Clip |  | 25
 |  |  | 1014 | Radio Multi Charger | 1015;1015 | 1
 |  |  | 1015 | 13A IEC Lead |  | 10
 |  |  | 1016 | FRH50 | 1017;1015 | 6
 |  |  | 1017 | Clamp - Scaff Tube |  | 6
 |  |  | 1018 | Printer - A4 | 1019;1020;1021;1022; | 4
 |  |  | 1019 | [NAME] |  | 4
 |  |  | 1020 | Printer - Driver Disk |  | 4
 |  |  | 1021 | USB to Printer Cable |  | 4
 |  |  | 1022 | A4 Ream Paper White |  | 100
 |  |  | 1023 | [NAME] | 1024;1025;1026;1027;1028 | 4
 |  |  | 1024 | Stapler | 1026; | 4
 |  |  | 1025 | Hole Punch |  | 2
 |  |  | 1026 | Staples |  | 5
 |  |  | 1027 | [NAME] |  | 5
 |  |  | 1028 | Clip Board |  | 3
Spreadsheet: 769602d1645618225-if-formula-with-multiple-criteria-ex-wb
Sheet: Sheet1

[NAME] | DateB | [NAME] | Notes | Action Needed?
25/10/2021 |  | 2021-11-20 10:49:29 | Apples | FORMULA
25/10/2021 |  | 2021-11-20 10:49:30 | Apples
25/10/2021 |  | 2021-11-20 10:49:30 | Local
2021-12-13 00:00:00 |  | 2021-11-20 10:49:26 | Apples
2021-12-13 00:00:00 |  | 2021-11-20 10:49:28 | Apples
2021-12-13 00:00:00 |  | 2021-11-20 10:49:33 | Local
2022-02-14 00:00:00 |  | 2021-11-20 10:49:26 | Apples
2022-02-14 00:00:00 |  | 2021-11-20 10:49:27 | Local
2022-02-14 00:00:00 | 2022-02-21 00:00:00 | 2021-11-20 10:49:33 | Local
2021-08-30 00:00:00 | 2021-08-23 00:00:00 | 2021-11-20 10:49:29 | Grapes
2021-06-22 00:00:00 | 2021-06-15 00:00:00 | 2021-11-20 10:49:27 | Bananas
2020-01-06 00:00:00 | 2020-01-13 00:00:00 | 2021-11-20 10:49:26 | Bananas
2022-02-14 00:00:00 | 2022-02-07 00:00:00 | 2021-11-20 10:49:25 | Local
2021-11-22 00:00:00 | 2021-11-29 00:00:00 | 2021-11-20 10:49:33 | Local
2020-11-27 00:00:00 | 2020-11-20 00:00:00 | 2021-11-20 10:49:27 | Supplier
2021-08-02 00:00:00 |  | 2021-11-20 10:49:26 | Apples
2020-09-28 00:00:00 |  | 2021-11-20 10:49:27 | Apples
2021-11-29 00:00:00 | 2021-11-22 00:00:00 | 2021-11-20 10:49:25 | Local
2021-11-08 00:00:00 |  | 2021-11-20 10:49:26 | Apples
2021-11-08 00:00:00 |  | 2021-11-20 10:49:33 | Local
2021-09-27 00:00:00 |  | 2021-11-20 10:49:31 | Local
2021-09-27 00:00:00 |  | 2021-11-20 10:49:26 | Apples
25/10/2021 | 2021-10-13 00:00:00 | 2021-11-20 10:49:25 | Local
2021-09-27 00:00:00 |  | 2021-11-20 10:49:33 | Apples
2022-01-24 00:00:00 |  | 2021-11-20 10:49:29 | Local
2021-08-30 00:00:00 |  | 2021-11-20 10:49:29 | Apples
2022-01-03 00:00:00 |  | 2021-11-20 10:49:38 | Supplier
2022-01-03 00:00:00 | 2021-12-22 00:00:00 | 2021-11-20 10:49:27 | Supplier
2021-08-30 00:00:00 | 2021-08-18 00:00:00 | 2021-11-20 10:49:28 | [NAME]
2022-02-14 00:00:00 | 2022-02-21 00:00:00 | 2021-11-20 10:49:38 | Local
18/10/2021 | 2021-10-06 00:00:00 | 2021-11-20 10:49:25 | Local
25/10/2021 | 2021-10-13 00:00:00 | 2021-11-20 10:49:29 | Local
2021-11-01 00:00:00 | 2021-11-08 00:00:00 | 2021-11-20 10:49:29 | Local
2021-12-27 00:00:00 | 2021-12-15 00:00:00 | 2021-11-20 10:49:29 | Local
2021-12-27 00:00:00 |  | 2021-11-20 10:49:33 | Supplier
2022-01-10 00:00:00 |  | 2021-11-20 10:49:33 | Local
2022-01-10 00:00:00 |  | 2021-11-20 10:49:27 | Local
2022-01-17 00:00:00 | 2022-01-05 00:00:00 | 2021-11-20 10:49:25 | Local
2022-02-14 00:00:00 | 2022-02-02 00:00:00 | 2021-11-20 10:49:29 | Local
2022-02-14 00:00:00 |  | 2021-11-20 10:49:30 | Supplier
2022-02-14 00:00:00 |  | 2021-11-20 10:49:25 | Local
2022-02-14 00:00:00 |  | 2021-11-20 10:49:30 | Coconut
2022-02-14 00:00:00 |  | 2021-11-20 10:49:27 | Local
2022-02-14 00:00:00 | 2022-02-02 00:00:00 | 2021-12-24 19:16:07 | Local
2022-02-14 00:00:00 |  | 2021-12-24 19:16:07 | Local
2022-02-14 00:00:00 |  | 2021-11-20 10:49:38 | Local
2022-02-14 00:00:00 | 2022-02-02 00:00:00 | 2021-11-20 10:49:30 | Local
2022-02-14 00:00:00 |  | 2021-11-20 10:49:26 | Cherries
2022-02-14 00:00:00 | 2022-02-01 00:00:00 | 2022-01-25 20:31:24 | Supplier
Spreadsheet: 154477d1336455930-sum-with-vlookup-calling-values-by-categories-0tab1
Sheet: Tab2

apple | 10
orange | 10
banana | 10
[NAME] | 10
melon | 10
apple | 10
orange | 10
banana | 10
[NAME] | 10
melon | 10
apple | 10
orange | 10
banana | 10
[NAME] | 10
melon | 10
apple | 10
orange | 10
banana | 10
banana | 10
Spreadsheet: 763078d1641982042-having-problems-with-edate-dashcopy
Sheet: Weaving

 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00
ACCIDENT MANAGEMENT (ROLLING 12M)
Accident Inv Closure Rate
Accident Inv Closure <2 days
Average Time to Complete Investigation
Accident Act Closure Rate
Accident Act Closure <7 days
Average time to Complete Corrective
HAZARD REPORTING (ROLLING 12M)
[NAME] Target
[NAME]
Average Days Open
CAMPAIGN (CURRENT YEAR)
Campaign 1
Campaign 2
Campaign 3
Campaign 4
DAILY WALKS
[NAME]
Headcount
Spreadsheet: 879783d1727339586-choosecols-function-to-incorporate-manual-column-no-value-sheet1
Sheet: Expected Result

Lookup 1 | [NAME] |  | to be arrange alphabetically |  | this col.to be added in formula
Sun | Sheet1
Day | Application No | Code | Solar System | Exam | Base | Fee | Charge
Sun | AP-1 | 65363 | Venus | 1991.05.04 | MS | 2063 | 25
Sun | DJ-986 |  | Venus | 2099.65.30 | MS | 320
Sun | AS-5 | 6316 | Earth | 1010.03.02 | MS | 1500 | 6
Sun | LST-3 | 9843 | Mars | 1011.04.02 | MS | 500 | 65
Grand Total
Spreadsheet: darrell_schoolcraft__7369__NNG LAMAR NOMNATION
Sheet: 01-(19-22)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 2002-01-19 00:00:00
 |  |  |  | Ending Gas Day: | 2002-01-22 00:00:00
 |  | [NAME] |  |  | 50000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 3500
 |  |  | 1000
 |  |  | 1000
 |  | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 500
 |  |  | 1000
 |  |  | 1000
Spreadsheet: 882138d1730390733-formula-to-calculate-end-of-year-projection-on-rolling-basis-example-workbook
Sheet: Example Workbook

 | Current Month | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2024-12-01 00:00:00
 | 2024-10-01 00:00:00 | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Forecast | Actuals | Year End Projection
 | Licenses | 3 | 5 | 3 | 5 | 2 | 4 | 3 | 7 | 2 | 8 | 9 | 8 | 90 | 78 | 12 | 43 | 24 | 97 | 78 |  | 80 |  | 90 |  | 503
 | Software | 30 | 37 | 30 | 38 | 30 | 36 | 30 | 32 | 30 | 21 | 30 | 57 | 30 | 6 | 30 | 98 | 30 | 1 | 30 |  | 30 |  | 30 |  | 416
 | Resources | 15 | 16 | 15 | 16 | 15 | 15 | 18 | 24 | 24 | 22 | 24 | 30 | 28 | 32 | 23 | 26 | 27 | 29 | 35 |  | 40 |  | 40 |  | 325
Spreadsheet: 275194d1383387020-vlookup-help-roster-query2-
Sheet: Sunday

SUNDAY
 |  |  |  | Date | 2013-11-03 00:00:00 |  |  |  | CS 5/13
Staff | Name | Key | Rostered Shift | Overtime | Remarks - Reason For Overtime
Number
812409 | S Barber | CP2 | 0515-1215
530504 | M Limon | C | 0515-1315
826406 | A Hatch | F1 | 0515-1145 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406
u | Uncovered | P7 | 0515-1145 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
u | Uncovered | P1 | 0700-1130 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
115862 | C Canhan | F2 | 1130-1930 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115862
142354 | R Murray | P6 | 1230-1630 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142354 | 142354
206953 | K Phelan | P4 | 1300-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206953
169566 | N Wilson | P3 | 1500-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169566 | 169566
771140 | C Smith | 19 | 1645-2215 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 771140
528648 | M Keast | B | 1415-2215 | 1300-1415
226967 | D MacQueen | CS2 | 1200-2000
 |  | QC1 | 1300-1930
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406 | 154218 | u
Rostered Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406 | 154218 | u
 |  |  |  | O/T Avail ? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406 | 154218 | u
533497 | R Miller | CS1 | OFF
516643 | R Carr | A | OFF |  |  |  |  |  |  | 967
741078 | A Dray | 1 | OFF |  |  |  |  |  |  | 971
128557 | M Bindoraho | F3 | OFF |  |  |  |  |  |  | 973 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 128557
169565 | S Amadio | P2 | OFF |  |  |  |  |  |  | 975 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169565 | 169565
154218 | L Rosier | P5 | OFF |  |  |  |  |  |  | 977 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154218 | 154218
u | Uncovered | 20 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
885369 | R Price | 18 | OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 885369 | 885369
134948 | R Gillis | CP1 | OFF
 |  | QC2 | OFF
Wooksheets Required
Week Commencing |  |  | 2013-11-03 00:00:00
812409 | S Barber |  | CP2
533497 | R Miller |  | CS1
226967 | D MacQueen |  | CS2
134948 | R Gillis |  | CP1
516643 | R Carr |  | A
528648 | M Keast |  | B
530504 | M Limon |  | C
741078 | A Dray |  | 1
826406 | A Hatch |  | F1
317947 | J [NAME] |  | L
539671 | A.Saunders |  | L
206953 | K Phelan |  | P4
115862 | C Canhan |  | F2
104159 | A [NAME] |  | AB
128557 | M Bindoraho |  | F3
771140 | C Smith |  | 19
885369 | R Price |  | 18
154218 | L Rosier |  | P5
142354 | R Murray |  | P6
169566 | N Wilson |  | P3
169565 | S Amadio |  | P2
318474 | P Thomson |  | SL
101770 | J [NAME] |  | -
 |  |  | -
u | Uncovered |  | P1
u | Uncovered |  | P7
u | Uncovered |  | 20
u | Uncovered |  | -
u | Uncovered |  | -
u | Uncovered |  | -
Spreadsheet: louise_kitchen__24304__Personnel Description
Sheet: Personnel Description

 |  | Name | Title | Description
 |  | [NAME] | Vice President | Joined Enron in 1998 in finance ([NAME] hired me) from Citicorp Securities.  [NAME] team in Feb. 2000; created Asset Marketing Group in April 2001.
 |  | [NAME] | Director | Stuart joined Asset Marketing in April 2001.  Prior to Asset Marketing, [NAME] was Assistant GC in legal, having joined Enron in 1998.  [NAME] and I have worked together since we both arrived at Enron.  He is stellar at negotiating and structuring, and is unparalleled at docs.
 |  | [NAME] | Director | [NAME] joined Asset Marketing in late summer from DealBench.  Prior to DealBench he spent time in corp. dev. as well as other rotations. [NAME] will be a big contributor on the E&P assets.
 |  | [NAME] | Manager | Doug joined Asset Marketing a month or so ago from power mid-marketing.  [NAME] is a really bright guy, with a strong technical power background.  He has been a big help with our power assets.
 |  | [NAME] | Associate | [NAME] joined the group in mid/late summer.  He has been around Enron for 4+ years.  He is a good all-around player.
 |  | [NAME] | Analyst | Jon began working for me in mid-2000 as an original [NAME] team member.  [NAME] is our 770 GMAT guy.  [NAME] picks things up quickly and there is not a better modeler in all of Enron.
 |  | [NAME] | Administrative Assistant | Angie has been at Enron 10+ years, and joined Asset Marketing at its formation in 2001.  [NAME] is exceptional at her job.
 |  | [NAME] | Director | [NAME] technically still works for Detmering, although she has been working with me on Vitro up through the close in October.  She will be working with me on the sale of our remaining 20% interest in Vitro. She is great details person, with very strong modeling skills.  She understands the South American market very well, and has been working with Mariella on Eco.
Spreadsheet: mary_fischer__25632__31N
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031N
COMPANY NAME    EFS C&S
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: kevin_hyatt__19644__Database Format
Sheet: Mrs. Vann

Rm # | Photo ID | Class | Teacher | GRD | Last Name | First Name | M/F | DRESS | SHRT | PANTS | COAT | SHOES | COLOR | Permission Slip? | Sponsor Name | Sponsor Ext | Alt Ext | Mail Stop
 | 393 |  | Vann | 5th | Vega | Amanda | F | 10/12 | 10/12 | 12 | 12 | 4-1/2A | Blue
 | 386 |  | Vann | 5th | Madrid | [NAME] | F | ? | 10/12 | 12R | 16L | 5-1/2A | Baby Blue/Black
 | 378 |  | Vann | 5th | Mohamed | [NAME] | F | 14/16 | 10/12 | 14 | 14/16 | 8-1/2A | Yellow/Blue
 | 372 |  | Vann | 5th | Banks | [NAME] | M |  | 14/16 | 14R | 20 | 9A | Gray
 | 377 |  | Vann | 5th | Lopez | Willman | M |  | 16/18 | 12R | 18L | 5-1/2A | Red/Blue
 | 376 |  | Vann | 5th | Byrd | Maureen | F | ? | 10M | 14/16 | 14/16 | 7A | Blue/green
 | 383 |  | Vann | 5th | Zarate | [NAME] | M |  | 14/16 | 14 | 10/12 | 8A | Red/Black
 | 385 |  | Vann | 5th | Sierra | [NAME] | F | 14/16 | 14/16 | 12L | 18 | 3-1/2A | Baby Blue/Purple
 | 373 |  | Vann | 5th | [NAME] | Desirae | F | 18/20 WM | 18/20XL | 18/20XL | 18 | 8A | Blue/Red/Green
 | 379 |  | Vann | 5th | [NAME] | Shabrie | F | 14 | 12 | 10 | 14 | 7A | Blue/Pink
 | 395 |  | Vann | 5th | Morales | [NAME] | M |  | 10/12 | 12 | 14/16 | 4A | Blue/Black
 | 399 |  | Vann | 5th | Katta | Abhilash | M |  | 10/12 | 12 | 6 | 2-1/2A | Red/Black
 | 374 |  | Vann | 5th | Pineda | [NAME] | F | 15/16 WM | 16WM | 16/16 | 16WM | 7A | Blue/Green/Purple
 | 384 |  | Vann | 5th | Fleming | [NAME] | M |  | 14/16 | 10/12S | 18/20 | 8A | Black/Blue
 | 391 |  | Vann | 5th | Byrd | Mark | M |  | 10/12 | 10P | 14/16 | 5A | Black/Red
 | 398 |  | Vann | 5th | Lopez | [NAME] | F | 10/12 | 10/12 | 10/12 | 14/16 | 2A | Blank/White
 | 396 |  | Vann | 5th | [NAME] | [NAME] | F | 14 | 14 | 14 | 14 | 4-1/2A | Purple/Blue
 | 387 |  | Vann | 5th | Rojas | [NAME] | F | 10/12 | 10/12 | 12 | 12 | 4-1/2A | Yellow/Blue
 | 392 |  | Vann | 5th | Fleming | [NAME] | M |  | 12/14 | 14S | 16 | 6A | Red/Blue
 | 380 |  | Vann | 5th | Mohammed | Nyiel | F | 14/16 | 14/16M | 14/16M | 14/16 | 6A | Blue
 |  |  | Vann | 5th | [NAME] | [NAME] | M |  | 14 | 10 | 16 | 5-1/2A | Blue
 | 375 |  | Vann | 5th | [NAME] | [NAME] | F | 18 Wm | L-Women | L | 18 | 10A | Black/White
 | 389 |  | Vann | 5th | Jacinto | [NAME] | M |  | 10/12 | 10/12 | 12M | 4A | Black
 | 397 |  | Vann | 5th | [NAME] | Lourdes | F | 10/12L | 10/12M | 10/12M | 10/12 | 2-1/2A | Blue/pink
 | 394 |  | Vann | 5th | Hueso | [NAME] | M |  | 10/12M | 10/12M | 12M | 5-1/2A | Blue
 | 390 |  | Vann | 5th | Caravantes | [NAME] | M |  | 10/12 | 10/12 | 14/16 | 5-1/2A | Black/Red
 | 388 |  | Vann | 5th | Aguirre | [NAME] | F | 10/12M | 10/12M | 12 | 10/12 | 3-1/2A | Blue/Purple
 | 371 |  | Vann | 5th | Smith | [NAME] | F | 14/16 | 14/16 | 12M | 14/16 | 7-1/2A | Blue/Red/Green
 | 381 |  | Vann | 5th | [NAME] | [NAME] | M |  | 14/16 | 12R | 18L | 5-1/2A | Red/Blue
Spreadsheet: 847615d1698459324-consolidating-different-pieces-of-data-on-same-dates-formula-help
Sheet: Sheet1

FLT_DATE | FLT_SEQ | FLT_BEGIN | FLT_END | SEQ_NUM | FS_ID | DS_ID | HRS |  | FLT_DATE | FLT_SEQ | FLT_BEGIN | FLT_END | FS W | FS D | FS NG | DS_ID | HRS
2023-10-12 00:00:00 | 1 | 15:00 | 17:00 | 1 | W | IE | 1.8 |  | 2023-10-12 00:00:00 | 1 | 15:00:00 | 17:00:00 | 1.8 | 0.2 | 0 | IE | 2
2023-10-12 00:00:00 | 1 | 15:00 | 17:00 | 2 | D | IE | 0.2 |  | 2023-10-12 00:00:00 | 2 | 20:00:00 | 22:00:00 | 0 | 0 | 2 | IP | 2
2023-10-12 00:00:00 | 2 | 20:00 | 22:00 | 1 | NG | IP | 2
 |  | Need formula to read this^ |  |  |  |  |  |  |  |  | And turn it into this^
Spreadsheet: 110043d1306842508-rearranging-data-for-further-analysis-mk3_dot_sub_route_1175-data-adjusted
Sheet: Sheet1

Date | Duty | Route | DOT Rout No | Trip | Contract | Bus | Driver | Sched Time | Book On Time | Schedule Distance |  | Non-Rev | Revenue | Passes | Tickets | Transfer | Total Psngrs
Spreadsheet: 781501d1653383982-array-formula-which-isnt-populating-further-down-the-sheet-stock-control-example
Sheet: Project Stock

Project Name | M-Pod Type | Materials Needed | Total Needed | Total in Stock | Enough Stock for Project | New Stock Total | Reorder? | Amount Ordered | Order Date | Delivery Date | Project Completed? |  | Archived Orders
[NAME] |  |  |  |  |  |  |  | 10 | 2022-05-15 00:00:00 |  | No
[NAME]
Clod Ensemble
Spreadsheet: 685962d1594296623-find-and-returns-value-of-a-table-from-multiple-criteria-sample-2
Sheet: Sheet2

Row Number | Date | Value
 |  |  |  |  | Statement for all the ABC transaction
 |  |  |  |  | Wanted a statement for both ABC and XYZ transactions.
Spreadsheet: b585f21c-28fe-473d-8cf6-e14d3e302ae9
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
G6PD | Test | G6PD | Glucose-6-Phosphate Dehydrogenase (G-6-PD), Quantitative, Erythrocytes | G-6-PD, QN, RBC | Kinetic Spectrophotometry (KS) | Yellow-Top (ACD) Tube: ACD |  |  | 4 | mL | Container/Tube: Preferred: Yellow top (ACD solution B) Acceptable: EDTA [NAME]: 6 mL Collection Instructions: Do not transfer blood to other containers. Forms: If not ordering electronically, submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | 8.8-13.4 U/g hemoglobin | Monday through Saturday | 1 day | 4 days | 1 | 82955 |  |  |  |  | Rochester
G6PD | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 20 days
G6PD | Result | G6PD_ | G-6-PD, QN, RBC | G-6-PD, QN, RBC | Numeric |  |  |  |  | U/g Hb |  |  |  |  |  |  |  |  |  | 32546-4