tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 732130d1620785593-having-simple-sum-formula-but-using-a-variable-as-one-of-the-criteria-test
Sheet: Sales

2021-03-01 00:00:00 | : Date |  |  |  |  |  | SUM(Master[@[Jan-20]:A1])
Project | UNIT | Value | To Be Billed | Status | AM | PM | Billed Total (accumulated) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22
Project 1 | TS | 42000 |  | In Dev | EJ | DW |  |  |  |  |  |  |  |  |  |  |  |  | 14000 | 21500 |  | 4190 | 2000
Project 2 | TS | 25928 |  | In Dev | EJ | GR |  |  |  |  |  |  |  |  |  |  | 6000 | 11500 | 3000 | 1300 |  | 1280 | 1600
Project 3 | TS | 133950 |  | In Dev | CR | TC |  |  |  |  |  |  |  |  |  |  |  |  | 9000 | 15000 | 20000 | 31000 | 20000 | 22000 | 16950
Spreadsheet: kevin_hyatt__19641__Sun Devil Fuel020307
Sheet: Hp Site Rating

 |  |  |  |  |  | Sun Devil Project
 |  |  |  |  |  | Fuel Anaylsis
 |  |  |  |  |  | Mainline Swing Only, Phoenix 100%
 |  |  |  |  |  | 1000 MMcf/d Senario
 |  | Type |  | Sun Devil
 |  |  |  | Site Rated
Sta. # | 4 | G | 25000
Sta. # | 3.5 | G | 15000
Sta. # | 3 | G | 28000
Sta. # | 2.5 | G | 25000
Sta. # | 2 | G | 27500
Sta. # | 1 | G | 27500
 | Sun Devil CS1 | G | 27500
 | Bloomfield | G | 4800 |  | Each units #1 & #2
 |  | G | 7000 |  | New unit #5
 |  | E | 7000 |  | Unit #4
 | Bisti | E | 9500
 | Standing Rock | G | 9500 |  | New station
 | Gallup | E | 9500
 |  | E | 9500 |  | New unit
Note: | 1. | Values shown on the Fuel sheet are required Hp.
 | 2.
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: November

 |  | 2022-10-31 00:00:00 | 2022-11-01 00:00:00 | 2022-11-02 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00 | 2022-11-05 00:00:00
 |  | 2022-11-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-09 00:00:00 | 2022-11-10 00:00:00 | 2022-11-11 00:00:00 | 2022-11-12 00:00:00
 |  | 2022-11-14 00:00:00 | 2022-11-15 00:00:00 | 2022-11-16 00:00:00 | 2022-11-17 00:00:00 | 2022-11-18 00:00:00 | 2022-11-19 00:00:00
 |  | 2022-11-21 00:00:00 | 2022-11-22 00:00:00 | 2022-11-23 00:00:00 | 2022-11-24 00:00:00 | 2022-11-25 00:00:00 | 2022-11-26 00:00:00
 |  |  |  |  | Thanksgiving              Office Closed | Day after Thanksgiving               Office Closed
 |  | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 | 2022-12-01 00:00:00 | 2022-12-02 00:00:00 | 2022-12-03 00:00:00
 |  | 2022-12-05 00:00:00 | Notes
Spreadsheet: 001da1a1-169c-4936-86a8-3ae2e81f8255
Sheet: FB-OSR Funds-other

Fund Balance for Various Other Funds (row 60) in Other Special Revenue Funds section
 |  | fund # | amount
 |  | 2830 | 148.39
 |  | 1690 | 123331
 |  | 2110 | 593
 |  | 1230 | 0.56
 |  | 1041 | 31074.71
 |  | 1680 | 16.61
 |  | 1270 | 9
 |  | 1250 | 1
 |  | 1211 | 2504
Spreadsheet: 856693d1705913308-need-a-formula-need-a-formula
Sheet: Data

DATE | COLOUR | OPEN BALANCE | INBOUND | OUTBOUND | CLOSE BALANCE |  |  |  |  |  |  | DATE | COLOUR | OPEN BALANCE | INBOUND | OUTBOUND | CLOSE BALANCE
2024-01-19 00:00:00 | RED |  | 200 |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00 | RED |  | 200
2024-01-19 00:00:00 | ORANGE |  | 2034 |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00 | ORANGE |  | 2034
2024-01-19 00:00:00 | YELLOW |  | 1500 |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00 | YELLOW |  | 1500
2024-01-19 00:00:00 | BLUE |  | 1320 |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00 | BLUE |  | 1320
2024-01-20 00:00:00 | RED |  |  | 50 |  |  |  |  |  |  |  | 2024-01-20 00:00:00 | RED |  |  | 50
2024-01-20 00:00:00 | YELLOW |  |  | 120 |  |  |  |  |  |  |  | 2024-01-20 00:00:00 | YELLOW |  |  | 120
2024-01-21 00:00:00 | ORANGE |  |  | 150 |  |  |  |  |  |  |  | 2024-01-21 00:00:00 | ORANGE |  |  | 150
2024-01-21 00:00:00 | BLUE |  |  | 300 |  |  |  |  |  |  |  | 2024-01-21 00:00:00 | BLUE |  |  | 300
2024-01-22 00:00:00 | GREEN |  | 2500 | 120 |  |  |  |  |  |  |  | 2024-01-22 00:00:00 | GREEN |  | 2500 | 120
2024-01-22 00:00:00 | BLUE |  | 600 |  |  |  |  |  |  |  |  | 2024-01-22 00:00:00 | BLUE |  | 600
2024-01-22 00:00:00 | RED |  | 450 |  |  |  |  |  |  |  |  | 2024-01-22 00:00:00 | RED |  | 450
Spreadsheet: 842914d1694901536-calculate-monthly-achievable-target-weight-test
Sheet: Demo

Date | Total Tonnes
2023-06-01 00:00:00 | 4.818000000000001
2023-06-02 00:00:00 | 5.25
2023-06-03 00:00:00 | 0
2023-06-04 00:00:00 | 0
2023-06-05 00:00:00 | 0
2023-06-06 00:00:00 | 4.989
2023-06-07 00:00:00 | 5.367
2023-06-08 00:00:00 | 4.98
2023-06-09 00:00:00 | 7.257
2023-06-10 00:00:00 | 0
2023-06-11 00:00:00 | 0
2023-06-12 00:00:00 | 5.259
2023-06-13 00:00:00 | 4.629
2023-06-14 00:00:00 | 5.808
2023-06-15 00:00:00 | 2.892
2023-06-16 00:00:00 | 1.731
2023-06-17 00:00:00 | 0.228
2023-06-18 00:00:00 | 0
2023-06-19 00:00:00 | 3.450000000000001
2023-06-20 00:00:00 | 3.486
2023-06-21 00:00:00 | 7.752000000000001
2023-06-22 00:00:00 | 5.16
2023-06-23 00:00:00 | 8.373
2023-06-24 00:00:00 | 0
2023-06-25 00:00:00 | 0
2023-06-26 00:00:00 | 4.962
2023-06-27 00:00:00 | 3.747
2023-06-28 00:00:00 | 6.500999999999999
2023-06-29 00:00:00 | 5.205
2023-06-30 00:00:00 | 3.27
Spreadsheet: 154927d1336602816-how-to-count-weekly-plan-and-weekly-plans-achievement-date-copy-of-date-count
Sheet: Sheet1

plan date | achievement date
2012-05-01 00:00:00 | 2012-05-03 00:00:00 |  |  |  | may |  | june |  | july |  | august
2012-05-03 00:00:00 | 2012-05-04 00:00:00 |  |  |  | w1 |  | w2 |  | w3 |  | w4
2012-05-05 00:00:00 | 2012-05-05 00:00:00 |  |  |  | 2012-05-01 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-31 00:00:00
2012-05-07 00:00:00 | 2012-05-09 00:00:00 |  |  |  | plan | achivement | plan | achivement | plan | achivement | plan | achivement
2012-05-09 00:00:00 |  |  |  |  | 4 | 4 | 3 | 0 | 7 | 6 | 10 | 2
2012-05-11 00:00:00
2012-05-13 00:00:00
2012-05-15 00:00:00 | 2012-05-17 00:00:00
2012-05-16 00:00:00 | 2012-05-19 00:00:00
2012-05-17 00:00:00 | 2012-05-21 00:00:00
2012-05-18 00:00:00
2012-05-19 00:00:00 | 2012-05-25 00:00:00
2012-05-20 00:00:00 | 2012-05-27 00:00:00
2012-05-21 00:00:00 | 2012-05-29 00:00:00
2012-05-22 00:00:00
2012-05-23 00:00:00
2012-05-24 00:00:00
2012-05-25 00:00:00
2012-05-26 00:00:00
2012-05-27 00:00:00
2012-05-28 00:00:00
2012-05-29 00:00:00
2012-05-30 00:00:00 | 2012-06-16 00:00:00
2012-05-31 00:00:00 | 2012-06-18 00:00:00
Spreadsheet: 266557d1379664367-need-index-match-formula-that-arranges-xs-in-bottom-rows-and-then-starts-arranging-ys-rearrange-stng-chrt
Sheet: Sheet1

4Jill Enz | 8Nancy [NAME] | 12May [NAME]
3Gina Decker | 7Sue Moseley | 11April Hope
2Dan Jones | 6Dave [NAME] | 10Shawn Reeves | 14Nate Gust
1Bob Smith | 5Rick Olesen | [NAME] | 13Seth [NAME]
 |  |  |  |  | A6:[NAME] the results that I want. So the formulas in A6:D9 need to look at Sheet2 M1:M16 find the boys there and then arrange them  in A9:D9 from left to right, then if there are more continue arranging them from left to right in A8:D8 etc. Then when all the boys are placed start arranging the girls starting in the next open space in the row or if that is filled move to the next row up starting on the left.
11April Hope | 12May [NAME]
3Gina Decker | 4Jill Enz | 7Sue Moseley | 8Nancy [NAME] |  | An additional requirement is a girl would only be placed next to a boy if there is an odd number of girls. So for example with the current list: IF Nate Gust's wasn't in the class [NAME] would still be placed in A7 However if both Nate Gust and [NAME] were not in the class then [NAME] would be placed next to [NAME].
[NAME] | 10Shawn Reeves | 13Seth [NAME] | 14Nate Gust
1Bob Smith | 2Dan Jones | 5Rick Olesen | 6Dave [NAME]
Spreadsheet: 774268d1648341946-error-in-vlookup-to-match-5-characters-match5-chars
Sheet: Sheet1

number | 5Chars | correct results
13459 |  |  |  |  |  |  | VLOOKUP
24578 |  | 6 | 124579 | 1 |  |  | 5 characters from column A  matches from column D3:D12, than Value from column E
135678 |  | 7 | 123478 | 2
123469 |  | 0 | 23689 | 3 |  |  | VLOOKUP(LEFT(A2,5)&"*",$D$3:$E$12,2,0)
1569 |  |  | 12457 | 4
3467 |  |  | 2367 | 5
134578 |  | 1 | 24578 | 6
234789 |  |  | 135678 | 7
145679 |  |  | 245679 | 8
245679 |  |  | 1467 | 9
12469 |  |  | 123469 | 0
125679
123469
123467
35679
124579
1345689
34789
134578
123468
36789
125689
123789
234589
2479
25679
38156
134589
23568
134578
12579
123789
134589
1237
45678
12467
23578
156789
124789
13468
123478
245678
12358
123567
25789
123578
1357
13568
1348
135689
3456
145789
13567
236789
1358
14679
125678
1347
12578
23679
123467
124689
12489
234578
1278
23459
2456789
124589
12368
12347
13478
12569
234568
12467
14567
245679
1289
2346789
123458
123457
12589
134589
124579
3589
567
5679
13689
135789
25789
1234568
13678
23689
145678
14568
123589
135679
35789
34568
235789
156789
356789
136789
123479
13458
123579
1239
1268
15679
146789
1348
257
12368
24589
1459
12357
234679
23789
35789
124589
126789
12359
23459
123457
12568
13467
124679
12367
234679
1236789
2467
346789
4589
12349
124579
24589
12378
356789
123578
3456789
1234569
1245679
136789
123469
235789
14578
12578
24678
14578
123678
124678
125689
24689
25679
12348
1245689
23567
345789
23459
25689
24569
2457
3479
123567
24568
1247
1258
24689
13467
123678
25789
124569
1678
23568
234568
1235678
2579
23568
23468
124789
12678
23459
123456
13456
12368
12478
3579
12456
12569
345689
134579
1345789
14578
24567
4579
2567
12478
245689
24567
34567
23589
123579
34789
568
12367
156789
45679
X
Spreadsheet: 300224d1393418535-data-from-multiple-worksheets-test1
Sheet: Invoice Details

 | Invoice Details
 | Description | Invoice # | Item # | Code | Qty | Unit Price | Discount | Total
 |  | SPCL0001 | GROSS | RT CB | 480 | 648
 |  | SPCL0001 | JAR | [NAME] | 540 | 216
 |  | SPCL0001 | JAR | AD RJar | 180 | 216
 |  | SPCL0002 | JAR | [NAME] | 288 | 216
 |  | SPCL0002 | JAR | AD RJar | 720 | 216
 |  | SPCL0002 | JAR | AD Jar | 792 | 216
Spreadsheet: 04e0e3c4-e3be-4e33-ab31-55ceaa9115fa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 15b. MERCHANDISE [NAME], State and Australia, Customs Value
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New South Wales ; |  |  | Original | A1829564W | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Victoria ; |  |  | Original | A1829565X | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Queensland ; |  |  | Original | A1829566A | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
South Australia ; |  |  | Original | A1829567C | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Western Australia ; |  |  | Original | A1829568F | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Tasmania ; |  |  | Original | A1829569J | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Northern Territory ; |  |  | Original | A1829570T | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Australian Capital Territory ; |  |  | Original | A1829571V | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
State not available for publication ; |  |  | Original | A2529326T | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
Total (State of Final Destination) ; |  |  | Original | A1829572W | 1988-01-01 00:00:00 | 2009-06-01 00:00:00 | 258 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 584206d1533031528-header-rows-when-combining-worksheets-in-get-and-transform-data-joe-bloggs
Sheet: Sheet1

 |  |  | Customer info |  | Product info
Sales rep | Invoice | Value | ID | Name | Product Code | Description
[NAME] | 123456 | 100 | 123 | AN Other | 1234 | Apple
[NAME] | 234567 | 550 | 432 | [NAME] | 6655 | Pear
Spreadsheet: 150256d1334352863-vlookup-multiple-criteria-vs-index-and-match-vlookup_problem
Sheet: Sheet1

Table 1
 | ABC | DEF | GHI
2011-06-01 00:00:00 | 15 | 29 | 18
2011-06-03 00:00:00 | 42 | 66 | 22
2011-06-05 00:00:00 | 81 | 82 | 44
Table 2
Letters | Date | Amount
ABC | 2011-06-01 00:00:00 | ???
DEF | 2011-06-05 00:00:00 | ???
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: Odessa

[NAME]
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
FOSTER - WTI - 28422
Beginning Inventory | 14731.48
Receipts | 2347.15
Deliveries | 0
Ending Inventory | 17059.53
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
FOSTER - WTS - 28423
Beginning Inventory | 44565.79
Receipts | 102976.93
Deliveries | 118351.78
Ending Inventory | 29179.91
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
TOTALODESSA PIPELINE
Beginning Inventory |  | 0
Receipts
Deliveries
Ending Inventory
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's
Adjusted G(L)-Bbls
Adjusted G(L)- %
Spreadsheet: 456688d1460996248-combo-box-drop-down-populate-another-cell-excel-forum-question
Sheet: Data

 | START | END |  | Summary List of Locations
 | ASCS |  |  | 1STD
 |  |  |  | ACSC
 |  |  |  | AFBJ
 |  |  |  | AFBN
 |  |  |  | AFBX
 |  |  |  | APAC
 |  |  |  | CK
 |  |  |  | CM
 |  |  |  | [NAME]
 |  |  |  | CNBA
 |  |  |  | CNBW
Spreadsheet: 127319d1320294416-excel-2007-need-to-find-if-duplicate-values-exist-in-a-master-sheet-compare-in-new-generated-sh-mutkumram-2011-11-02
Sheet: New

priority | internal | co no | pol no | rid no | proces | step
5 | -4 | 3K | 12003915 | 0 | Pol | chk | 2
5 | -2 | 3G | 12358953 | 0 | ADD | chg | 3
5 | 1 | 2R | 12345785 | 0 | ANS | NYN | 4
5 | 1 | 3K | 4567253 | 0 | WYN | ZOC
5 | 2 | 3G | 12345785 | 0 | WYN | POL
5 | 3 | 2R | 12345785 | 0 | SNA | LOP |  | <-- Do not copy formula in H beyond end of table
Spreadsheet: 860369d1708498027-does-a-derivative-of-sumif-exist-avgironistance
Sheet: Sheet1

 | Average Distance
5i | For each "5i" in column B, add the value in Column A to the value in column C.  Then, divide by the count of "5i" in column B.
5i
6i
7i
8i
9i
PW
50*
Yardage | Iron | -Lft / +Rgt
195 | 5i | -2
135 | 58* | 11
200 | 5i | 8
120 | 58* | -7
205 | 5i | 4
175 | 58* | -16
Spreadsheet: louise_kitchen__23037__AAearn by month
Sheet: Bank Request

E N R O N   N O R T H  A M E R I C A
12/31/99 - 3Q2001
in Millions of $
 |  | As of 12/31/1999 |  | 1Q 2000 |  | 2Q 2000 |  | 3Q 2000 |  | 4Q 2000 |  | 1Q 2001 |  | 2Q 2001 |  | 3Q 2001 |  | Total
Schedule C |  | 50.7 |  | -50.5 |  |  |  | 248.9 |  | 509.6 |  | 481.2 |  | -1 |  | -395.2
Specific Reserves |  | 28.8 |  | -8.9 |  | -0.8 |  | 7 |  | 71.8 |  | 0.6 |  | 2.6 |  | 113.1
Total
*Schedule D items not included:
Alberta PPA |  |  |  |  |  |  |  |  |  | 197.7
Other(COF Rediscounting) |  |  |  |  |  |  |  |  |  | 83.6
Spreadsheet: 100286d1298664545-delete-n-a-row-sample1test111
Sheet: 4

Week | ID | Employee | Hour
4 |  | [NAME] | 40
4 |  | Chad | 20
4 |  | [NAME] | 35
4 |  | Fred | 40
Spreadsheet: 718137d1613002737-z-distance-of-3d-points-to-a-plane-through-3-3d-points-plane_distance
Sheet: S

Point | x | y | z |  | Plane Equation |  |  | Plane |  | x | y | z |  |  | Ref.List | (DropDown)
P.01 | 3 | -2 | -8 |  | ax + by + cz + d = 0 |  |  | Point - 1 | P.01
P.02 | -7 | 0 | 7 |  | 3 points P₁(x₁, y₁, z₁), P₂(x₂, y₂, z₂) and P₃(x₃, y₃, z₃) |  |  | Point - 2 | P.02
P.03 | 2 | -3 | 4 |  |  |  |  | Point - 3 | P.03
P.04 | 5 | 2 | 8
P.05 | -2 | 5 | 6 |  |  |  |  | Coefficients | a | b | c | d
P.06 | -2 | 3 | -2
P.07 | 0 | -5 | -5 |  | Coefficients
P.08 | -5 | -3 | -7 |  | a = (y₂ - y₁)*(z₃ - z₁) - (y₃ - y₁)*(z₂ - z₁) |  |  | Distance  Point - Plane
P.09 | 2 | 4 | -7 |  | b = (x₃ - x₁)*(z₂ - z₁) - (x₂ - x₁)*(z₃ - z₁) |  |  | Point | x | y | z | Distance
P.10 | -2 | 0 | 7 |  | c = (x₂ - x₁)*(y₃ - y₁) - (x₃ - x₁)*(y₂ - y₁)
 |  |  |  |  | d = - (a*x₁ + b*y₁ + c*Z₁)
 |  |  |  |  | Distance Point - Plane
 |  |  |  |  | Plane | ax + by + cz + d = 0
 |  |  |  |  | Point Q | Q (Qx, [NAME], Qz)
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19997 | -19960
2 | -20003 | -19960
3 | -19992 | -19793
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
2002-02-28 00:00:00 |  |  | 0
2002-03-03 00:00:00
CBS Dollars
 |  |  | 0
Spreadsheet: 821558d1678793902-how-to-get-output-for-the-next-appointment-date-based-on-admission-date-in-excel-excel-help-2
Sheet: Sheet1

Patient Index Number | Adm. [NAME] | Dis. Date | Next Appointment Date
1 | 27/11/2021 | 2021-01-12 00:00:00 | 27/6/2022
1 | 27/6/2022 | 2021-01-12 00:00:00 | 27/6/2022
2 | 2022-04-02 00:00:00 | 2022-09-02 00:00:00 | 29/7/2022
2 | 29/7/2022 | 2022-09-02 00:00:00 | 29/7/2022
3 | 19/11/2021 | 23/11/2021 | 2022-07-07 00:00:00
3 | 2022-07-07 00:00:00 | 23/11/2021 | 2022-07-07 00:00:00
3 | 29/8/2022 | 23/11/2021 | 2022-07-07 00:00:00
4 | [NAME] | 28/07/2022 | [NAME]
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 28 March 2012

Daily Morning Staff |  |  |  |  | Wednesday
 | 07:30-14:30 |  | 2012-03-28 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS | Annual leave
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS | Com off Air Show
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME] | Annual leave
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS | Annual leave
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 136353d1326565178-if-and-or-logic-question-sample_bonus
Sheet: OTS Bonus Payout

 |  | Per Plan Achievement |  |  |  | Bonus Payout
 |  | 1.5 | to | 10 |  | 4500 |  |  | 150%-1000% | 150 | 1000
 |  | 1.4 | to | 1.4999 |  | 3250 |  |  | 140%-149.99% | 140 | 149.99
 |  | 1.3 | to | 1.3999 |  | 2500 |  |  | 130%-139.99% | 130 | 139.99
 |  | 1.2 | to | 1.2999 |  | 2000 |  |  | 120%-129.99% | 120 | 129.99
 |  | 1.15 | to | 1.1999 |  | 1500 |  |  | 115%-119.99% | 115 | 119.99
 |  | 1.1 | to | 1.1499 |  | 1300 |  |  | 110%-114.99% | 110 | 114.99
 |  | 1.05 | to | 1.0999 |  | 1160 |  |  | 105%-109.99% | 105 | 109.99
 |  | 1 | to | 1.0499 |  | 1000 |  |  | 100%-104.99% | 100 | 104.99
 |  | 0.9 | to | 0.9999 |  | 500 |  |  | 90%-99.99% | 90 | 99.99
 |  | 0.8 | to | 0.8999 |  | 300 |  |  | 80%-89.99% | 80 | 89.99
 |  | 0 | to | 0.7999 |  | 0 |  |  | 0%-79.99% | 0 | 79.99
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1
2
3
4 | 1
5
6 | 15
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
 | 2001-01-31 00:00:00 |  |  |  | 1884
 | 2001-02-07 00:00:00
Spreadsheet: kate_symes__18291__03-29
Sheet: Sheet1

DATE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | MW PER HR | TOTAL MW | EES Price
2001-03-29 00:00:00 |  | 2 |  |  | SP15 | 9 |  | 50 | sold
 |  | 3 |  |  | SP15 | 10 |  | 50 | sold
 |  | 4 |  |  | SP15 | 11 |  | 50 | sold
 |  | 5 |  |  | SP15 | 8 |  | 50 | sold
 |  | 6 |  |  | SP15 | 16 |  | 50 | sold
 |  | 7 |  |  | SP15 | 20 |  | 90 | sold
 |  | 8 |  |  | SP15 | 11 |  | 90 | sold
 |  | 9 |  |  | SP15 | 4 |  | 90 | sold
2001-03-29 00:00:00 | Y | 7 | 9 |  | SP15 | 10 |  | 110 | sold
2001-03-29 00:00:00 | Y | 10 | 10 |  | SP15 | 7 |  | 160 | sold
2001-03-29 00:00:00 | Y | 11 | 11 |  | SP15 | 6 |  | 160 | sold
2001-03-29 00:00:00 | Y | 12 | 12 |  | SP15 | 4 |  | 160 | sold
2001-03-29 00:00:00 | Y | 13 | 13 |  | SP15 | 2 |  | 160 | sold
2001-03-29 00:00:00 | Y | 14 | 14 |  | SP15 | 2 |  | 160 | sold
2001-03-29 00:00:00 | Y | 15 | 15 |  | SP15 | 2 |  | 160 | sold
2001-03-29 00:00:00 | Y | 16 | 16 |  | SP15 | 5 |  | 160 | sold
2001-03-29 00:00:00 | Y | 17 | 17 |  | SP15 | 10 |  | 160 | sold
2001-03-29 00:00:00 | Y | 18 | 18 |  | SP15 | 10 |  | 160 | sold
2001-03-29 00:00:00 | Y | 19 | 19 |  | SP15 | 6 |  | 160 | sold
2001-03-29 00:00:00 | Y | 20 | 20 |  | SP15 | 6 |  | 160 | sold
2001-03-29 00:00:00 | Y | 21 | 21 |  | SP15 | 10 |  | 160 | sold
2001-03-29 00:00:00 | Y | 22 | 22 |  | SP15 | 10 |  | 160 | sold
Spreadsheet: 868912d1715618640-how-to-move-unlinked-cells-alongside-linked-cells-passednon-passed
Sheet: Sheet2

Task | Lead | ID | Comments | Passed?
 |  |  | Wed | Y
2 | [NAME] | 43009 | Finished ER | Y
3 | Emily | 12236 | Progress | N
4 | Fiat | 43563 | Progress | N
5 | Rover | 18902 | DisQ | E
Spreadsheet: 472319d1469540911-count-2-columns-count-in-countif-sample
Sheet: Sheet1

 |  |  |  | Currently |  |  |  | Expecting
Names | [NAME] |  |  | Names | Count |  |  | Names | Count
A |  |  |  | A |  |  |  | A | 5
A |  |  |  | B |  |  |  | B | 4
B |  |  |  | C |  |  |  | C | 4
B |  |  |  | D |  |  |  | D | 4
C |  |  |  | V |  |  |  | V | 7
A | V |  |  | Total |  |  |  | Total
C
D
D
A
B
B
D | V
C
C
A
B | V
V
V
D
D
V
A
V
Spreadsheet: 600015d1543419464-need-a-formula-to-filter-data-sample-31-ans
Sheet: Sheet1

Winner | [NAME] | Winner Score | [NAME] |  | Emma | Winner | [NAME] | Winner Score | [NAME] |  |  | Winner | [NAME] | Winner Score | [NAME]
Emma | Jake | 3 | 2 |  |  |  |  |  |  |  |  | Emma | Jake | 3 | 2
Jake | Sandra | 4 | 0 |  |  |  |  |  |  |  |  | [NAME] | Emma | 1 | 0
[NAME] | [NAME] | 2 | 1 |  |  |  |  |  |  |  |  | Emma | Kait | 5 | 2
Millie | Kait | 10 | 8
[NAME] | Emma | 1 | 0
Hamish | [NAME] | 9 | 8
Millie | [NAME] | 6 | 3
Emma | Kait | 5 | 2
Spreadsheet: 3b1439f0-1131-421f-8770-14b10d2135ab
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5179 | 29917 | Gergo | Mezei | HUN | 0 | 00:44:56 | 00:00:49 | 01:16:04 | 00:01:20 | 00:19:57 | 1 | 02:23:06
Spreadsheet: 706114d1606481097-supplier-based-on-price-and-quantity-count
Sheet: Sheet2

Supplier | Sup1 | Sup2 | Sup3 | Sup4 | Sup5
Price | 172.5 | 50 | 172.5 | 50 | 172.5
Quantity | 90 | 50 | 40 | 70 | 20
lowest price
lowest price
Spreadsheet: andy_zipper__173__DYNEGY-ICE VOL Apr19
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-19-01 thru Apr-19-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader