tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: da2384da-b83b-4ff1-85fe-326ac58d743e
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
FYERS | Test | FYERS | Yersinia enterocolitica Antibodies, IgA, IgG and IgM by Immunoblot | [NAME] Ab IgA, IgG & IgM | Qualitative Immunoblot |  |  |  |  |  | Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Separate from cells within 2 hours of collection. Send 1 mL of serum refrigerated in a plastic vial. | 0.2 mL | Hemolysis:	Mild reject; Gross reject Thawing:	Warm OK < 48 hours; Cold OK Lipemia:	Mild reject; Gross reject Icterus:	Mild reject; Gross reject Other:	Heat-inactivated, contaminated, or turbid specimens | Yersinia enterocolitica, IgA by Immunoblot	Negative Yersinia enterocolitica, IgG by Immunoblot	Negative Yersinia enterocolitica, IgM by Immunoblot	Negative  Test Performed by:	ARUP Laboratories 			500 [NAME], UT 84108 | Tuesday | 1 - 8 days | 3 - 19 days | 3 | 86793 |  |  |  |  | ARUP Laboratories
FYERS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FYERS | Result | Z2780 | Y. enterocolitica, IgA Immunoblot | Y. enterocolitica, IgA Immunoblot | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FYERS | Result | Z2781 | Y. enterocolitica, IgG Immunoblot | Y. enterocolitica, IgG Immunoblot | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FYERS | Result | [NAME] | Y. enterocolitica, IgM Immunoblot | Y. enterocolitica, IgM Immunoblot | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 738252d1624930779-return-consecutive-duplicates-and-non-duplicates-from-a-column-book1
Sheet: Sheet1

1-123
1-123
1-123
5-001
1-111
1-123
1-001
Spreadsheet: 224225d1364491813-merge-24-seperate-workbooks-into-one-2012-1-15-log-inv
Sheet: Parameters

Ordering Information |  |  |  | Elkem Report System
Report Type |  | INVENTORY
Report Type Description
Report Request |  | Inventory by Location Report
Ordered Time |  | Wednesday, March 27, 2013 16:01:28
Ordered By |  | [NAME]
Parameters |  | Owner Org Unit | (In ('CNA','MAR','MKT'))
 |  | Prod Unit | ()
 |  | From Date | (15-JAN-2012 00:00:00)
 |  | To Date | (15-JAN-2012 00:00:00)
 |  | Date Type | (A)
 |  | Cost Type | (S)
 |  | Report Type | (SAL)
 |  | Reporting Element | ()
 |  | Family | ()
 |  | Product | ()
 |  | Grade | ()
 |  | Size | ()
 |  | Package Group | ()
 |  | Package | ()
 |  | Lot Org Unit | ()
 |  | Lot Type | ()
 |  | Lot No | ()
 |  | Global Location | (In ('MONPQLSI'))
 |  | Storage | ()
 |  | Transtype | ()
 |  | Reason Code | ()
 |  | Include Values | (Y)
 |  | Include Cost Centers | (N)
 |  | Include Lot Analysis | (N)
 |  | Quantity | ()
 |  | NoP | ()
 |  | Value | ()
 |  | Inventory Account | (In ('147010','147070'))
 |  | Chemical Code | ()
Spreadsheet: 0b13dec6-bfba-4a4e-913a-b53b7363812c
Sheet: Dasher

Leg | Pilot | From | Departure time | To | Arrival time | FBO | N Number
0 | [NAME] | Mt. Pleasant | 07:30:00 | [NAME], SC | 08:00:00 | Sheltair? Signature? | [NAME]
 | [PHONE] |  |  | KHXD
1 | [NAME] | KHXD | 08:30:00 | Smithfield, NC | 10:00:00 | Johnson County | [NAME]
 |  |  |  | KJNX
2 | [NAME] | KJNX | 10:30:00 | Leesburg, VA | 11:50:00 | Terminal/Projet Aviatn | N5U
 | [PHONE] |  |  | KJYO
3 | [NAME] | KJYO | 12:10:00 | KPOU | 13:55:00 | Dutchess Co Aviation | N201ak
 | [PHONE]
4 | [NAME] | KPOU | 14:10:00 | KTAN | 15:10:00 | FBO | N63T
 | (508) 238-7591
 |  |  | Dasher | www.flightaware.com
Spreadsheet: 161843d1339651344-copy-paste-data-with-matching-criteria-from-different-sheet-for-help-form
Sheet: Report

True | 5
 | DATE | 2012-06-10 00:00:00
 | SR # | ITEM CODE | [NAME] | UOM | OPENING BALANCE | TODAY RECEIPT | RECIEPT TODATE
 | 1 | 5262 | HIGH SPEED DIESEL | LTR | 14090
 | When Date Change in reciept & issuance sheet  all data against the given copied with according to [NAME]
 | Receipt Information
 | item Code | Description | UOM | [NAME] | Qty Received
 | 5262 | HIGH SPEED DIESEL | LTR | 9937 | 15000
 | Issuance  Information
 | EQUPMENT ID | EQUPMENT TYPE | itemCode | Description | Unit | Qty
 | 73523 | BUS | 5262 | HIGH SPEED DIESEL | LTR | 100
Spreadsheet: 196872d1354131719-editing-a-pre-made-excel-worksheet-1yorkshires-snooker-league-2012
Sheet: League Table

 | Position | Teams | PL | Won | Draw | Lose | For | Agg | Ratio | Pts | HOME MATCHES STATS |  |  |  |  |  |  |  | AWAY MATCHES STATS
 |  |  |  |  |  |  |  |  |  |  | P | W | D | L | F | A | R | Pts | P | W | D | L | F | A | R | Pts
 | 1 | Bradford No1 | 4 | 4 | 0 | 0 | 18 | 6 | 12 | 12 | 2 | 2 | 0 | 0 | 9 | 3 | 6 | 6 | 2 | 2 | 0 | 0 | 9 | 3 | 6 | 6 |  |  |  |  |  | Promotion
 | 2 | Sheffield No1 | 5 | 1 | 3 | 1 | 14 | 16 | -2 | 6 | 3 | 1 | 2 | 0 | 10 | 8 | 2 | 5 | 2 | 0 | 1 | 1 | 4 | 8 | -4 | 1
 | 3 | [NAME] No1 | 3 | 1 | 1 | 1 | 9 | 9 | 0 | 4 | 1 | 1 | 0 | 0 | 5 | 1 | 4 | 3 | 2 | 0 | 1 | 1 | 4 | 8 | -4 | 1 |  |  |  |  |  | Relegation
 | 4 | Harrogate | 4 | 1 | 1 | 2 | 11 | 13 | -2 | 4 | 1 | 1 | 0 | 0 | 4 | 2 | 2 | 3 | 3 | 0 | 1 | 2 | 7 | 11 | -4 | 1
 | 5 | Barnsley | 3 | 0 | 2 | 1 | 7 | 11 | -4 | 2 | 2 | 0 | 1 | 1 | 4 | 8 | -4 | 1 | 1 | 0 | 1 | 0 | 3 | 3 | 0 | 1
 | 6 | Sheffield No3 | 3 | 0 | 1 | 2 | 7 | 11 | -4 | 1 | 2 | 0 | 1 | 1 | 5 | 7 | -2 | 1 | 1 | 0 | 0 | 1 | 2 | 4 | -2 | 0
Spreadsheet: michelle_lokay__26574__imbalsumm0012
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -562072
3531 | -924674 | -873562
60667 | -334488 | -654641
60749 | 434829 | -400486
61206
61334 | -460348
62960
INDEX
2000-11-30 00:00:00 |  |  | 52631.01
2000-12-31 00:00:00
Spreadsheet: 857193d1706223075-overtime-if-not-at-40-pay
Sheet: TIME LOG

 |  | TIME AND MONEY |  | TIME AND MONEY | TIME AND MONEY
 |  | DAY |  | WAGES (11-15-23)
 |  |  |  | FEDERAL TAXES
 |  | TIME LOG |  | [NAME] PAY | 28
 |  |  |  | REGULAR HOURS | 8
 |  |  |  | 2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
 |  |  |  | NOVEMBER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER
 |  |  |  |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $
 |  | DAYS EMPLOYED |  | 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 | 32 | 33 |  | 34 | 35 | 36 | 37 | 38 | 39 | 40 |  | 41 | 42 | 43 | 44 | 45 | 46 | 47
 |  | TIME LOG |  | BEGUN WORK |  |  |  |  |  | PERIOD START |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERIOD START |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERIOD START
 |  |  |  | WEEK 1 |  |  |  |  |  | WEEKS 2-3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEKS 4-5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEKS 6-7
 |  |  |  | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN |  | MON | TUE | WED | THU | FRI | SAT | SUN
 |  | DATE |  | 15 | 16 | 17 | 18 | 19 | WEEK 1 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | WEEK 2 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | WEEK 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | WEEK 4 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | WEEK 5 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | WEEK 6 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | WEEK 7
 |  | OCCASION |  |  |  |  |  |  | TOTALS |  |  |  | PAID HOLIDAY | PAID HOLIDAY |  |  | TOTALS |  |  |  |  |  |  |  | TOTALS |  |  |  |  |  |  |  | TOTALS |  |  |  |  |  |  |  | TOTALS | 06:33:00 |  |  |  |  |  |  | TOTALS | PAID HOLIDAY |  |  |  |  |  |  | TOTALS
 |  | CLOCK IN |  |  | 08:00:00 | 07:49:00 |  |  |  | 06:03:00 | 07:41:00 | 07:00:00 | 08:00:00 | 08:00:00 |  |  |  | 07:29:00 | 07:43:00 | 05:04:00 | 05:48:00 | 07:19:00 |  |  |  | 05:32:00 | 07:58:00 | 07:37:00 | 06:38:00 | 07:54:00 |  |  |  | 07:03:00 | 07:38:00 | 07:38:00 | 08:00:00 | 07:44:00
 |  | LUNCH OUT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:42:00 | 12:11:00 | 11:58:00 | 11:43:00 | 13:33:00 |  |  |  | 11:30:00 | 13:19:00 | 12:10:00 | 11:40:00 | -
 |  | FIRST PART TOTAL
 |  | LUNCH IN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:14:00 | 12:57:00 | 12:33:00 | 13:02:00 | 14:43:00 |  |  |  | 12:05:00 | 14:09:00 | 13:04:00 | 12:29:00 | -
 |  | CLOCK OUT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:43:00 | 16:55:00 | 18:15:00 | 16:55:00 | 17:54:00
 |  | SECOND PART TOTAL
 |  | REGULAR HOURS WORKED
 |  | OT HOURS WORKED
 |  | TOTAL HOURS WORKED
 |  | REGULAR MONEY MADE
 |  | OT MONEY MADE
 |  | GROSS PAY
 |  | FEDERAL WITHHOLDING
 |  | MEDICARE
 |  | SOCIAL SECURITY
 |  | TOTAL TAXES TAKEN
 |  | NET PAY
Spreadsheet: 05cc4a38-0bc5-46b1-b6cb-4fbdb5d203af
Sheet: MN Institution Contact Info

To obtain more detailed program and contact information, visit the general website, then locate links to the Education Department or Division.
College/Institution | Location | Telephone Number | Website address
Augsburg College | Minneapolis, MN 55454 | [PHONE] | visit www.augsburg.edu
Bemidji State University | Bemidji, MN 56601 | [PHONE] | visit www.bemidjistate.edu
Bethel University | St. Paul, MN 55112 | [PHONE] | Visit www.bethel.edu
Capella University | Minneapolis, MN 55402 | [PHONE] | visit www.capella.edu
Concordia University - St. Paul | St. Paul, MN 55104 | [PHONE] | visit www.csp.edu
Hamline University | St. Paul, MN 55104 | [PHONE] | visit www.hamline.edu
Minnesota State University - Mankato | Mankato, MN 56002 | [PHONE] | visit www.mnsu.edu
Minnesota State University - Moorhead | Moorhead, MN 56563 | [PHONE] | visit www.mnstate.edu
Southwest Minnesota State University | [NAME], MN 56258 | [PHONE] | visit www.smsu.edu
St. Cloud State University | St. Cloud, MN 56301 | [PHONE] | visit www.stcloudstate.edu
St. Mary's University | Winona, MN 55987 | [PHONE] | visit www.smumn.edu
University of Minnesota - Duluth | Duluth, MN 55812 | [PHONE] | visit www.d.umn.edu
University of Minnesota - Twin Cities | Minneapolis, MN 55455 | [PHONE] | visit www1.umn.edu
University of St. Thomas | St. Paul, MN 55403 | [PHONE] | visit www.stthomas.edu
Walden University | Minneapolis, MN 55401 | [PHONE] | visit www.waldenu.edu
Winona State University | Winona, MN 55987 | [PHONE] | visit www.winona.edu
Spreadsheet: martin_cuilla__25348__Bowl2000
Sheet: pick-summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL BONUS BET
Spreadsheet: 821650d1678826050-combine-multiple-rows-based-on-a-value-of-one-column-combine-rows
Sheet: Combined Data

ID | Name | Data Set A | Data Set B | Data Set C | Data Set D | Data Set E | Data Set F
112233445 | [NAME] | A |  |  | D | E | F
123456789 | Apple | A | B |  | D | E
223344556 | Pear | A | B | C | D | E | F
334455667 | Kiwi |  | B | C |  | E | F
987654321 | Orange |  |  | C |  |  | F
Spreadsheet: 774440d1648476580-vba-dynamic-list-from-same-column-on-multiple-sheets-forrick
Sheet: Vehicles1

 | Vehicles1 List
 | v1123
 | v1124
 | v1125
 | v1126
 | v1127
 | v1128
 | v1129
 | v1130
 | v1131
 | v1132
 | v1133
 | v1134
 | v1135
 | v1136
 | v1137
 | v1138
 | v1139
 | v1140
 | v1141
Spreadsheet: rick_buy__32913__OverallENEPostPetitionListing
Sheet: Sheet1

ENE - Post Petition Organization
 |  |  |  |  | North America | Energy Services | Global Markets | Industrial Markets | Global Assets | Broadband | Europe
 | Unit/Group Lead
 | Commercial Lead |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Legal |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Accounting |  |  |  | [NAME] | Wade Stubblefield | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | HR |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Support Operations |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | n/a
 | IT |  |  |  | [NAME] | [NAME] |  |  | n/a
 | RAC/Credit |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Finance |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Tax |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Overall Accounting Lead |  |  |  | [NAME]
 | Overall Tax Lead |  |  |  | [NAME]
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 10d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, January 18 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 820588d1678186269-mapping-data-dictionary-with-raw-data-sample
Sheet: Sheet1

Data Dictionary |  |  |  | Raw data |  |  |  |  | Results
Sheet1 |  |  |  | Sheet2 |  |  |  |  | Sheet3
Variable | Answer | definition |  | Case ID | v000 | v001 | v002 |  | Case ID | v000 | v001 | v002 |  |  |  |  | Count of Case ID | Column Labels
v000 | 1 | Yes |  | A1 | 1 | 1 | 1 |  | A1 |  |  |  |  |  |  |  | Row Labels | Rural | Urban | Grand Total
 | 2 | No |  | A2 | 2 | 2 | 3 |  | A2 |  |  |  |  |  |  |  | East | 3 | 1 | 4
v001 | 1 | Rural |  | A3 | 1 | 2 | 4 |  | A3 |  |  |  |  |  |  |  | North | 2 | 4 | 6
 | 2 | Urban |  | A4 | 1 | 2 | 4 |  | A4 |  |  |  |  |  |  |  | South | 2 | 1 | 3
v002 | 1 | East |  | A5 | 1 | 2 | 4 |  | A5 |  |  |  |  |  |  |  | West | 1 | 1 | 2
 | 2 | West |  | A6 | 2 | 1 | 3 |  | A6 |  |  |  |  |  |  |  | Grand Total | 8 | 7 | 15
 | 3 | South |  | A7 | 1 | 1 | 1 |  | A7
 | 4 | North |  | A8 | 1 | 1 | 2 |  | A8
 |  |  |  | A9 | 1 | 2 | 1 |  | A9
 |  |  |  | A10 | 2 | 1 | 3 |  | A10
 |  |  |  | A11 | 2 | 1 | 4 |  | A11
 |  |  |  | A12 | 1 | 2 | 4 |  | A12
 |  |  |  | A13 | 1 | 2 | 2 |  | A13
 |  |  |  | A14 | 2 | 1 | 1 |  | A14
 |  |  |  | A15 | 2 | 1 | 4 |  | A15
Spreadsheet: 740841d1626622649-auto-calculate-end-date-sample
Sheet: Sheet2

Machine | Allocated Hours | start date | End Date | Date | Day | Working hours
Machine 1 | 30.25 | 2021-07-17 10:35:00 | ?? | 2021-07-17 00:00:00 |  | 7
Machine 2 | 30.25 | 2021-07-18 14:00:00 | ?? | 2021-07-18 00:00:00 |  | 7
Machine 3 | 30.25 | 2021-07-19 09:00:00 | ?? | 2021-07-19 00:00:00 |  | 7
Machine 4 | 30.25 | 2021-07-20 14:00:00 | ?? | 2021-07-20 00:00:00 |  | 7
Machine 5 | 30.25 | 2021-07-21 14:00:00 | ?? | 2021-07-21 00:00:00 |  | 0
Machine 6 | 37.25 | 2021-07-22 13:00:00 | ?? | 2021-07-22 00:00:00 |  | 0
Machine 7 | 40.25 | 2021-07-23 00:00:00 | ?? | 2021-07-23 00:00:00 |  | 0
Machine 8 | 30.25 | 2021-07-24 12:00:00 | ?? | 2021-07-24 00:00:00 |  | 7
Machine 9 | 30.25 | 2021-07-25 00:00:00 | ?? | 2021-07-25 00:00:00 |  | 7
Machine 10 | 30.25 | 2021-07-26 00:00:00 | ?? | 2021-07-26 00:00:00 |  | 7
Machine 11 | 30.25 | 2021-07-27 00:00:00 | ?? | 2021-07-27 00:00:00 |  | 7
 |  |  |  | 2021-07-28 00:00:00 |  | 7
 |  |  |  | 2021-07-29 00:00:00 |  | 7
 |  |  |  | 2021-07-30 00:00:00 |  | 0
 |  |  |  | 2021-07-31 00:00:00 |  | 7
 |  |  |  | 2021-08-01 00:00:00 |  | 7
 |  |  |  | 2021-08-02 00:00:00 |  | 7
 |  |  |  | 2021-08-03 00:00:00 |  | 7
 |  |  |  | 2021-08-04 00:00:00 |  | 7
 |  |  |  | 2021-08-05 00:00:00 |  | 7
 |  |  |  | 2021-08-06 00:00:00 |  | 0
 |  |  |  | 2021-08-07 00:00:00 |  | 7
 |  |  |  | 2021-08-08 00:00:00 |  | 7
 |  |  |  | 2021-08-09 00:00:00 |  | 7
 |  |  |  | 2021-08-10 00:00:00 |  | 7
 |  |  |  | 2021-08-11 00:00:00 |  | 7
 |  |  |  | 2021-08-12 00:00:00 |  | 7
 |  |  |  | 2021-08-13 00:00:00 |  | 0
Spreadsheet: 749799d1633014447-dynamically-auto-filtering-a-shared-excel-document-in-teams-with-iferror-and-index-dynamic-filtering-sarawho-
Sheet: Drop Downs

BusinessUnit | Region | FollowUpType | Team | ProductList | YesorNo | CampaignStatus
Legal | North America | [NAME] | Team A | Product 1 | Yes | Pending,Active,Recurring
Corporate | Europe | Outbound | Team B | Product 2 | No | Complete
 |  |  | Team C | Product 3 |  | Cancelled
 |  |  | Team D | Product A
 |  |  | Team E | Product B
 |  |  | Team F | Product C
 |  |  |  | Product D
 |  |  |  | Product E
 |  |  |  | Product F
 |  |  |  | Product G
Spreadsheet: 543247d1508295929-loookup-on-multiple-date-range-and-multiple-lines-example_budgetactual_1
Sheet: Final Result

[NAME] | Location | Trvl Start Date | Trvl End Date | Actual Amount | Budget Amount | Difference
Suzie | Tokyo | 2017-01-09 00:00:00 | 2017-01-10 00:00:00 | 119.9 | 131
Markie | Tokyo | 2017-04-11 00:00:00 | 2017-04-13 00:00:00 | 239.8 | 131
[NAME] | Tokyo | 2017-09-17 00:00:00 | 2017-09-22 00:00:00 | 262.1 | 206
Macy | Alaska | 2017-08-22 00:00:00 | 2017-08-23 00:00:00 | 117.52 | 204
[NAME] | Brazil | 2017-10-10 00:00:00 | 2017-10-12 00:00:00 | 136.4 | 191
Billy | Mexico | 2017-03-08 00:00:00 | 2017-03-10 00:00:00 | 442.12 | 101
Spreadsheet: daren_farmer__6610__3rivers
Sheet: Sheet1

Texas Desk
HPL 3-Rivers Gas Flowing through King Ranch
 |  | Feb (Monthly) |  | [NAME])
[NAME] | Deal | Vol |  | Vol
2622 | 130510 | 6728 |  | 452
2630 | 156556 | 560 |  | 21
2645 | 136275 | 1204 |  | 57
2650 | 139092 | 56 |  | 15
2651 | 126330 | 521 |  | 27
2662 | 125808 | 12848 |  | 613
2667 | 125808 | 5916 |  | 323
2668 | 125808 | 1021 |  | 85
2673 | 137850 | 87 |  | 5
2677 | 137858 | 29 |  | 1
2680 | 125808 | 8080 |  | 252
2688 | 125808 | 290 |  | 26
2691 | 138456 | 336 |  | 23
4028 | 131715 | 38816 |  | 1297
4229 |  | 0 |  | 189
4548 | 156422 | 29 |  | 43
4660 | 138958 | 5046 |  | 190
4965 | 131720 | 8961 |  | 196
5853 | 138426 | 22801 |  | 644
6118 | 136739 | 2928 |  | 121
6181 | 133344 | 736 |  | 45
6258 | 126335 | 10150 |  | 591
6272 | 138573 | 2175 |  | 158
6331 | 113858 | 0 |  | 0
6563 |  | 0 |  | 0
6575 | 168509 | 8013 |  | 603
6581 | 130865 | 4886 |  | 241
6682 | 137936 | 261 |  | 16
6835 | 138097 | 696 |  | 24
6842 | 133205 | 5423 |  | 179
6845 | 133205 | 44718 |  | 1737
6847 | 137939 | 145 |  | 0
9604 | 131719 | 9464 |  | 91
9638 | 133173 | 124700 |  | 0
9640 | 138958 | 8178 |  | 301
9682 | 155502 | 25315 |  | 6000
9698 | 133263 | 1131 |  | 54
9700 | 166810 | 406 |  | 0
9717 | 134987 | 4698 |  | 271
9737 | 133433 | 2791 |  | 94 |  | 3-Rivers gas flowing through King Ranch
9739 | 138958 | 2494 |  | 92
9740 | 133432 | 6471 |  | 446 |  | All meters in System 757
 |  |  |  |  |  | All meters in System 441 except:
 | Total |  |  |  |  |  |  | Mtr | 2601
 |  |  |  |  |  |  |  | Mtr | 4723
 | Daily |  |  |  |  |  |  | Mtr | 5106
 |  |  |  |  |  |  |  | Mtr | 5801
**  The gas flowing at the above meters is purchased at the wellhead |  |  |  |  |  |  |  | Mtr | 6015
by [NAME] and transported through HGPL to King Ranch and processed. |  |  |  |  |  |  |  | Mtr | 6725
The gas is then delivered to HPL at mtr 9643 (Stratton) or at the |  |  |  |  |  |  |  | Mtr | 9629
Humble header. |  |  |  |  |  | The following meters in System 429:
 |  |  |  |  |  |  |  | Mtr | 4548
**   Producers at the highlighted meters have the option each month to |  |  |  |  |  |  |  | Mtr | 6835
either 1) sell the gas to HPLC at the wellhead or 2) to process the gas |  |  |  |  |  |  |  | Mtr | 6842
and sell the residue (at the tailgate of the plant) to HPLC. |  |  |  |  |  |  |  | Mtr | 9682
Spreadsheet: 678214d1589784767-autofill-downwards-in-a-sequential-manner-but-only-where-an-adjacent-cell-has-content-autofill-query
Sheet: Before

ITEM |  | QTY | UNIT | RATE | TOTAL
1 | ITEM 1 - WALL WORKS
 | General Allowance - No Detail
 | General Allowance to fire rate gap between slab edge &_x000D_glazing across L1,2 & 3 in lift lobby | 10 | lm | 300
 | ITEM 2 - INSTALL FIRE SUPPRESSION SYSTEM
 | New Drencher Service - S & I:
 | Allowance for extension of new drencher service to L1_x000D_& 2 openings extended from mains water service | 1 | Item | 40000
 | Allowance for provision of access equipment & EWP | 1 | Item | 900
 | BWICS - Allowance (TBC):
 | Allowance for patching upto 20lm ceilings | 20 | m | 60
 | Allowance for painting works | 20 | m | 10
 | ITEM 3 - FIRE ENGINEERING FOR LINK_x000D_BRIDGE OPENINGS
 | New Drencher Service - S & I:
 | Allowance for extension of new drencher service to L1_x000D_& 2 openings extended from mains water service | 1 | Item | 40000
 | Allowance for provision of access equipment & EWP | 1 | Item | 900
 | BWICS - Allowance (TBC):
 | Allowance for patching upto 20lm ceilings | 20 | m | 60
 | Allowance for painting works | 20 | m | 10
 | a | 1 | m | 15
 | b | 1 | m | 15
 | c | 1 | m | 15
 | d | 1 | m | 15
 | e | 1 | m | 15
 | f | 1 | m | 15
 | g | 1 | m | 15
 | h | 1 | m | 15
 | j | 1 | m | 15
 | i | 1 | m | 15
 | k | 1 | m | 15
 | l | 1 | m | 15
 | ITEM 4 - SMOKE CURTAIN
 | Signage - S & I:
 | Allowance for signage "WARNING -DROPPING FIRE CURTAIN" | 1 | Item | 250
 | Fire Services - Allow to:
 | Site Establishment & Travel | 1 | Item |  | INCL
 | Reposition single smoke detector | 2 | no | 500
 | Ceiling Makegood - Allowance:
 | Allowance to patch & paint Ceilings | 1 | Item | 500
 | ITEM 5 - INFRARED SMOKE DETECTOR
 | Walls & Ceilings - Allow to:
 | Allowance to open ceiling to enable works | 2 | hrs | 50
 | Install New smoke detector | 3 | m2 | 500
 | Allowance to makegood ceiling area including painting | 1 | Item | 600
 | ITEM 6 - SLAB IMPROVEMENTS
 | Fire separation between slabs - Allow to:
 | Allowance post-tension survey | 4 | items | 400
 | Specialised Labour allowance. | 16 | hrs | 120
 | Misc Materials | 1 | Item | 150
 | Subtotal
Spreadsheet: 854459d1704322322-if-then-multiple-criteria-with-an-end-result-of-changing-a-cell-a-color-bordemkills-excel-example
Sheet: Sheet1

 | Department
 | A
 | B
 |  | *Notes
 |  | In each Cell above in the blue section
 |  | Example: In Cell "C5", I'd like to reference the Department "A" to the table on Sheet2. If the date/time matchs and falls withing the time range then change the color of this cell to Green
 |  | So in Cell C8, since this block falls within the table in Sheet 2 it will meet the criteria and Change colors
 |  | End Result:
 |  | Also could this work if I needed it to span over multiple days like the "Department B" row example in Sheet2?
 |  | End Result:
Spreadsheet: 770996d1646381863-how-to-turn-a-bar-chart-into-a-boxplot-diagram-workbook
Sheet: Tabelle1

 | Rating | I think Feedback is important.
 | 1
 | 2
 | 3 | 1
 | 4
 | 5 | 2
 | 6
 | 7 | 2
 | 8 | 4
 | 9 | 5
 | 10 | 9
Spreadsheet: 805657d1668807301-return-array-with-values-repeated-n-times-based-on-another-criteria-book2-2-
Sheet: Sheet1

allo_id | allo_wh_n |  | OUTPUT
allo-750-001 | 1
allo-750-002 | 1
allo-750-003 | 1
allo-750-004 | 2
allo-750-005 | 3
allo-750-006 | 4
Spreadsheet: 855328d1704925591-is-this-even-possible-ludo-edited
Sheet: Sheet1

Date | 1st Token in 7 Points | 2nd Token in 6 Points | 3rd Token in 5 Points | 4th Token in 4 Points | 5th Token in 3 Points | 6th Token in 2 Points | 7th Token in 1 Points |  | Winner |  | Points | Points
 |  |  |  |  |  |  |  |  |  |  | A | B
2024-01-09 00:00:00 | A | A | B | B | B | A | A
2024-01-10 00:00:00 | A | A | B | B | B | B