tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: SW OLP Pipelines

EOTT OPERATING PIPELINES - SW Area
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
[NAME] [NAME]
Beginning Inventory | 29570.74
Receipts | 672079.79
Deliveries | 643381.72
Ending Inventory | 54573.95
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)- %
Oklahoma City Pipeline - 7201
Beginning Inventory | 4131.62
Receipts | 15684.6
Deliveries | 15244.62
Ending Inventory | 4483.58
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)- %
Pitchfork Ranch Gathering -7298
Beginning Inventory | 2530.87
Receipts | 66565.86
Deliveries | 65909.03
Ending Inventory | 2530.87
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)- %
Total SW Area Pipelines OLP
Beginning Inventory |  | 0
Receipts
Deliveries
Ending Inventory
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's
Adjusted G(L)-Bbls
Adjusted G(L)- %
Spreadsheet: 83047d1283089482-refering-to-specific-entry-in-a-drop-down-list-fsr-wc-2010-statistic-book
Sheet: BAH

 |  | Round 01 | Bahrain, Sakhir, Sakhir International Circuit
 |  | Laps | 57
 |  | Grid [NAME]
 |  | Number Of Leaders
 |  | Attrition Rate
 | Lineup | Name |  | Qualify | Name | Team | QPenalty |  | Race | Name | Team | Laps | LL | FL | DNF | Points
 | TWI | MLZ |  | 1 | HUI |  |  |  | 1 | HUI |  | 57 | 53 | FL |  | 25
 |  | MAR |  | 2 | HAH |  |  |  | 2 | MLZ |  | 57 | 4 |  |  | 18
 | PRE | MIK |  | 3 | MLZ |  |  |  | 3 | TAL |  | 57 |  |  |  | 15
 |  | HUI |  | 4 | TAL |  |  |  | 4 | MAR |  | 57 |  |  |  | 12
 | ASH | MOR |  | 5 | GRE |  |  |  | 5 | GRE |  | 57 |  |  |  | 10
 |  | PHI |  | 6 | MAR |  |  |  | 6 | PUU |  | 57 |  |  |  | 8
 | TMO | DIS |  | 7 | MIK |  |  |  | 7 | HEL |  | 57 |  |  |  | 6
 |  | HEL |  | 8 | HEL |  |  |  | 8 | WIT |  | 57 |  |  |  | 4
 | MAK | TAL |  | 9 | CAS |  |  |  | 9 | CAS |  | 57 |  |  |  | 2
 |  | HAH |  | 10 | CNP |  |  |  | 10 | DIS |  | 57 |  |  |  | 1
 | FTS | CNP |  | 11 | PUU |  |  |  | 11 | KEE |  | 57
 |  | WIT |  | 12 | WIT |  |  |  | 12 | PON |  | 57
 | GHO | GRE |  | 13 | PON |  |  |  | 13 | ELE |  | 56
 |  | KEE |  | 14 | KEE |  |  |  | 14 | GEE |  | 56
 | SBM | PUU |  | 15 | MOR |  |  |  | 15 | PHI |  | 56
 |  | PON |  | 16 | DIS |  |  |  | 16 | HAH |  | 53 |  |  | DNF
 | DHR | ELE |  | 17 | DOM |  |  |  | 17 | KEI |  | 33 |  |  | DNF
 |  | KEI |  | 18 | ELE |  |  |  | 18 | MIK |  | 14 |  |  | DNF
 | ROA | GRZ |  | 19 | KEI |  |  |  | 19 | CNP |  | 2 |  |  | DNF
 |  | GEE |  | 20 | PHI |  |  |  | 20 | GRZ |  | 0 |  |  | DNF
 | FAC | CAS |  | 21 | GRZ |  |  |  | 21 | DOM |  | 0 |  |  | DNF
 |  | DOM |  | 22 | GEE |  |  |  | 22 | MOR |  | 0 |  |  | DNF
 | - | - |  | 23 | - | - | - |  | 23 | - | - | - | - | - | - | -
 |  | - |  | 24 | - | - | - |  | 24 | - | - | - | - | - | - | -
 | - | - |  | 25 | - | - | - |  | 25 | - | - | - | - | - | - | -
 |  | - |  | 26 | - | - | - |  | 26 | - | - | - | - | - | - | -
Spreadsheet: 61032d1261601681-highlight-cells-in-a-calendar-with-conditional-formatting-condformatdays
Sheet: Sheet1

 |  | 2010-01-01 00:00:00 |  |  |  | 1
S | M | T | W | T | F | S |  |  |  |  | DATE | MONTH | DAY
 |  |  |  |  | 1 | 2 |  |  |  |  | 2010-01-03 00:00:00 | 1 | 3
3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  |  | 2010-01-09 00:00:00 | 1 | 9
10 | 11 | 12 | 13 | 14 | 15 | 16 |  |  |  |  | 2010-01-14 00:00:00 | 1 | 14
17 | 18 | 19 | 20 | 21 | 22 | 23 |  |  |  |  | 2010-02-04 00:00:00 | 2 | 4
24 | 25 | 26 | 27 | 28 | 29 | 30 |  |  |  |  | 2010-04-12 00:00:00 | 4 | 12
31 |  |  |  |  |  |  |  |  |  |  | 2010-06-23 00:00:00 | 6 | 23
 |  |  |  |  |  |  |  |  |  |  | 2010-07-03 00:00:00 | 7 | 3
 |  |  |  |  |  |  |  |  |  |  | 2010-07-29 00:00:00 | 7 | 29
 |  |  |  |  |  |  |  |  |  |  | 2010-08-24 00:00:00 | 8 | 24
Spreadsheet: 724282d1616093473-if-then-statement-is-resulting-false-but-should-be-true-off-in-the-13th-decimal-place
Sheet: JAPMB 05.20 (2)

 | Date | Description | Vendor | Personal Amt. | Business Amt. | Amt. Pstd to MB | Amt. to be Trnsfrd | Job Location/Other Notes |  | Line Ttl | PPWK | ORIG VO | CR VO | FINAL VO
1 |  |  |  |  | -5.8
2 |  |  |  |  | -5.8
3 |  |  |  |  | -3.05
4 |  |  |  |  | -3.05
5 |  |  |  |  |  | 28
6 |  |  |  |  |  | 107.28
7 |  |  |  |  |  | 144.99
8 |  |  |  |  |  | 144.99
9 |  |  |  |  |  | 76.31
10 |  |  |  |  | 3.18 | 73.13
11 |  |  |  |  |  | 32.55
12 |  |  |  |  |  | 17.99
13 |  |  |  |  |  | 6.5
14 |  |  |  |  | 29.11
15 |  |  |  |  |  | 12
16 |  |  |  |  |  | 63
17 |  |  |  |  |  | 2.5
18 |  |  |  |  |  | 525
19 |  |  |  |  |  | 160
20 |  |  |  |  |  | 118.5
21 |  |  |  |  | 42
22 |  |  |  |  | 30.56
23
24
25
26
27
28
29
30
31
32
33
34
VO |  |  | Inv. |  | 20-05 | Personal Total
Vndr |  |  | Inv. Date |  | 2020-05-10 00:00:00 | Business Total | 87.15
G/L Code |  |  | Amt. |  |  | Ttl. Pstd to MB | 1512.74
G/L Code |  |  | Amt. |  |  | Ttl. To be Trans | 0
G/L Code |  |  | Amt. |  |  | Spreadsheet Ttl | 1599.89 | 1599.89
G/L Code |  |  | Amt. |  |  | [NAME] | 1587.03 | 1587.03
G/L Code |  |  | Amt. |  |  | Finance Chg | 30.56 | 30.56
G/L Code |  |  | Amt. |  | 0 | Credits | -17.7 | -17.7
G/L Code |  |  | Amt. |  |  | Notes/Lines
G/L Code |  |  | Amt. |  |  | Notes/Lines
G/L Code |  |  | Amt. |  |  | Notes/Lines
 |  |  |  | Voucher Ttl |  | Difference
 |  |  |  |  | 87.1500000000001 |  | 1.27897692436818e-13
Spreadsheet: 61820d1262732829-multiple-if-statements-sales-david-morin-01-2010
Sheet: sales

Timestamp | CUSTOMER USERNAME | LINE TYPE | SPEED | VOICE PLAN
2010-01-05 17:01:15 | ccole35 | VOICE ONLY | VOICE ONLY | ALL MAINE
2010-01-05 17:06:29 | brucegagnon | DSL/VOICE | 5MB | UNLIMITED
 | test | SOLO | 20MB | INTERNET ONLY
 | test3 | SOLO | 15MB | BASIC
 | TEST | VOICE ONLY | VOICE | UNLIMITED
Spreadsheet: 105656d1302953471-excel-2007-how-to-select-the-row-with-the-highest-number-bandmaxadvfilter
Sheet: Sheet1

Start | End | Band | Diff | Helper |  | Start | End | Band | Diff | Helper | <<[NAME]
[PHONE] | 128834764 | 608 | 255 |  |  |  |  |  |  | 1 | <<[NAME]
[PHONE] | 128336473 | 608 | 127
[PHONE] | 128343244 | 621 | 511 |  |  | Start | End | Band | Diff | Helper | <<Advanced Filter
[PHONE] | 128344831 | 621 | 127 |  |  | [PHONE] | 128834764 | 608 | 255 | 1 | <<Uses Sorted Data by Band then [NAME]
[PHONE] | 128345177 | 621 | 127 |  |  | [PHONE] | 128343244 | 621 | 511 | 1
[PHONE] | 129165619 | 623 | 255 |  |  | [PHONE] | 129165619 | 623 | 255 | 1
[PHONE] | 129045763 | 623 | 7 |  |  | [PHONE] | 128558358 | 624 | 15 | 1
[PHONE] | 128558358 | 624 | 15 |  |  | [PHONE] | 128325081 | 625 | 127 | 1
[PHONE] | 128558339 | 624 | 7
[PHONE] | 128558775 | 624 | 7
[PHONE] | 128559037 | 624 | 7
[PHONE] | 128325081 | 625 | 127
 |  | Row Labels | [NAME] of Diff
 |  | 608 | 255
 |  | 621 | 511
 |  | 623 | 255
 |  | 624 | 15
 |  | 625 | 127
 |  | Grand Total | 511
Spreadsheet: 849181d1699703691-how-do-i-find-row-differences-between-2-datasets-excel18
Sheet: Sheet1

 |  | Data set A |  |  | Data set B
 | Item | Quantity |  |  | Item | Quantity
 | Blue | 10 |  |  | Blue | 10
 | Blue | 8 |  |  | Blue | 8
 | Red | 1 |  |  | Blue | 1
 | Red | 2 |  |  | Red | 1
 | Yellow | 5 |  |  | Red | 2
 | Black | 4 |  |  | Yellow | 5
 |  |  |  |  | Yellow | 8
 |  |  |  |  | Black | 4
Spreadsheet: 63030d1264000724-help-compiling-data-on-a-summary-page-depending-on-drop-down-menu-choices-example-a-
Sheet: Year2

STAFF: | A | H | C | N | O
% of DAYS AVAILABLE | 0.1272727272727273 | 0.09090909090909091 | 0.02727272727272727 | 0.00909090909090909 | 0.1045454545454545
TOTAL DAYS: | 28 | 20 | 6 | 2 | 23
Days Spent on Activity 1: | 1 | 2 |  | 2
Days Spent on Activity 2: | 2 | 3 | 6
Days Spent on Activity 3: | 3 | 4
Days Spent on Activity 4: | 4 | 5 |  |  | 23
Days Spent on Activity 5: | 18 | 6
Spreadsheet: 0307b4df-f7a2-4664-819f-ad908c8f236e
Sheet: Labor Worksheet - SFA

LABOR WORKSHEET - SFA
(To be completed by SFA for SFA employees.)
 |  |  |  |  | Pay rates for the School Year __________
 |  |  |  |  |  |  | Retirement % | FICA/Med % | Wk Comp %
School |  |  |  |  | Annual | Total |  |  |  | Insurance &
Building* | Employee | Job Title* | Hrly Pay* | Daily Hrs* | Days* | Wages* | Retirement* | FICA* | Work Comp* | Longevity
 | Total Food Service
*Minimum information that must be completed for this worksheet.
Note: Insert percentage for Retirement in cell H5, FICA/Med in cell I5, and Wk Compensation in cell J5. Then insert hourly pay, daily hours and annual days to automatically calculate
and populate cells for wages, retirement, FICA, and worker's compensation.
Spreadsheet: 775704d1649261426-split-sheet-in-half-vertically-trailer-dots-due
Sheet: Sheet1

TRAILER # | DOT expires | STATUS | TRAILER # | DOT expires | STATUS
DUE DATES GUIDE |  | NEXT MONTH | THIS MONTH | OVERDUE
431 | 2022-01-06 00:00:00 |  | 9551 | 2022-03-28 00:00:00
1501 | 2021-08-26 00:00:00 |  | 9555 | 2022-05-28 00:00:00
1502 | 2022-07-08 00:00:00 |  | 9556 | 2021-08-20 00:00:00
1503 | 2021-10-26 00:00:00 |  | 9562 | 2022-02-06 00:00:00
1504 | 2021-09-06 00:00:00 |  | 9563 | 2022-06-01 00:00:00
1505 | 2022-03-25 00:00:00 |  | 9564 | 2022-01-04 00:00:00
1506 | 2022-06-06 00:00:00 |  | 9565 | 2022-04-27 00:00:00
1507 | 2022-04-02 00:00:00 |  | 9577 | 2022-06-07 00:00:00
1508 | 2021-09-01 00:00:00 |  | 9584 | 2021-08-08 00:00:00
1509 | 2021-10-02 00:00:00 |  | 9599 | 2022-01-16 00:00:00
1510 | 2021-11-12 00:00:00 |  | 135233 | 2022-04-30 00:00:00
3524 | 2022-06-13 00:00:00 |  | 135234 | 2022-05-01 00:00:00
5250 | 2022-03-10 00:00:00 |  | 135235 | 2021-11-25 00:00:00
5251 | 2022-04-01 00:00:00 |  | 135236 | 2022-04-29 00:00:00
5430 | 2022-01-13 00:00:00 |  | 135237 | 2022-04-28 00:00:00
5431 | 2021-12-29 00:00:00 |  | 135238 | 2021-10-30 00:00:00
5432 | 2022-03-26 00:00:00 |  | 135239 | 2021-11-13 00:00:00
5433 | 2022-06-25 00:00:00 |  | 195240 | 2022-05-31 00:00:00
5434 | 2021-11-24 00:00:00 |  | 195241 | 2022-01-29 00:00:00
5435 | 2021-12-19 00:00:00 |  | 195242 | 2022-07-19 00:00:00
6700 | 2022-01-12 00:00:00 |  | 195243 | 2022-06-27 00:00:00
6701 | 2021-10-03 00:00:00 |  | 195244 | 2021-10-23 00:00:00
6702 | 2021-12-07 00:00:00 |  | 195245 | 2022-05-15 00:00:00
6703 | 2022-06-26 00:00:00 |  | 195246 | 2022-01-15 00:00:00
6704 | 2021-10-09 00:00:00 |  | 195247 | 2022-05-25 00:00:00
6705 | 2021-10-26 00:00:00 |  | 195248 | 2021-08-30 00:00:00
9526 | 2022-06-01 00:00:00 |  | 195249 | 2021-12-06 00:00:00
9527 | 2022-06-01 00:00:00 |  | 195301 | 2021-11-28 00:00:00
9528 | 2022-06-01 00:00:00 |  | 195302 | 2021-08-11 00:00:00
9529 | 2022-06-01 00:00:00 |  | 195305 | 2022-05-31 00:00:00
9530 | 2022-07-01 00:00:00 |  | 195306 | 2022-01-29 00:00:00
9531 | 2021-09-05 00:00:00 |  | 195430 | 2021-09-10 00:00:00
9532 | 2022-01-09 00:00:00 |  | 195431 | 2021-11-11 00:00:00
9533 | 2022-02-24 00:00:00 |  | 195432 | 2021-09-13 00:00:00
9534 | 2022-01-06 00:00:00 |  | 195433 | 2022-05-07 00:00:00
9535 | 2022-03-28 00:00:00 |  | 195434 | 2022-05-09 00:00:00
9536 | 2022-07-01 00:00:00 |  | 195435 | 2022-06-22 00:00:00
9537 | 2022-08-01 00:00:00 |  | 195436 | 2021-07-31 00:00:00
9538 | 2022-08-01 00:00:00 |  | 195437 | 2022-02-25 00:00:00
9539 | 2021-07-30 00:00:00 |  | MSP 571 | 2022-07-23 00:00:00
9540 | 2022-07-17 00:00:00 |  | MSP 573 | 2022-05-22 00:00:00
9541 | 2022-07-11 00:00:00 |  | MSP569 | 2022-06-10 00:00:00
9542 | 2022-03-21 00:00:00 |  | MSP574 | 2021-07-31 00:00:00
9544 | 2022-05-19 00:00:00 |  |  | NA
9545 | 2021-12-09 00:00:00 |  |  | NA
9546 | 2022-01-24 00:00:00 |  |  | NA
9547 | 2021-11-27 00:00:00 |  |  | NA
9548 | 2021-09-16 00:00:00 |  |  | NA
9549 | 2022-03-05 00:00:00 |  |  | NA
9550 | 2022-02-22 00:00:00 |  |  | NA
Spreadsheet: eric_saibi__9710__Market briefs
Sheet: Sheet1

Market Brief | Friday, January 4
Stocks | Close | Change | % Change
DJIA | 10259.74 | 87.60000000000036 | 0.008611757211363624
DJ 15 Util. | 294.17 | -2.050000000000011 | -0.006920532036999565
NASDAQ | 2059.38 | 15.11000000000013 | 0.007391391548083241
S&P 500 | 1172.51 | 7.240000000000009 | 0.006213152316630489
Market Vols | Close | Change | % Change
AMEX (000) | 166836 | 15307 | 0.1010169670492117
NASDAQ (000) | 2203775 | -6043 | -0.002734614343805689
NYSE (000) | 1513069 | 115502 | 0.08264505386861595
Commodities | Close | Change | % Change
Crude Oil (Feb) | 21.4 | 0.75 | 0.03631961259079904
Heating Oil (Feb) | 0.5859 | 0.02 | 0.03534193320374628
Nat. Gas (Henry) | 2.275 | -0.03400000000000025 | -0.01472498917280219
Propane (Feb) | 30.9 | -0.8500000000000014 | -0.02677165354330713
Palo Verde (Feb) | 24.75 | 0 | 0
COB (Feb) | 24.75 | 0 | 0
PJM (Feb) | 27.55 | -1.45 | -0.05
Dollar US $ | Close | Change | % Change
Australia $ | 1.92 | -0.02300000000000013 | -0.0118373648996398
Canada $ | 1.597 | 0 | 0
Germany Dmark | 2.184 | 0.009000000000000341 | 0.004137931034482916
Euro | 0.8954 | -0.004000000000000004 | -0.004447409384033804
Japan ¥en | 130.9 | -0.799999999999983 | -0.0060744115413818
Mexico NP | 9.17 | 0.07000000000000028 | 0.007692307692307724
[NAME] | 0.6917 | -0.003700000000000037 | -0.005320678746045494
Foreign Indices | Close | Change | % Change
Arg MerVal | 343.22 | 2.62 | 0.007692307692307705
[NAME]. | 3374.3 | 6.900000000000091 | 0.002049058620894485
[NAME] | 14331.92 | 66.56999999999971 | 0.004666552170118484
Can TSE 300 | 7833.24 | 59.07999999999993 | 0.007599534869362083
Germany DAX | 5318.73 | 48.4399999999996 | 0.009191145079302961
[NAME] | 11702.15 | 278.6299999999992 | 0.02439090578035484
Japan Nikkei 225 | 10871.49 | 328.869999999999 | 0.03119433309746524
[NAME] | 6612.08 | 8.329999999999927 | 0.001261404505016078
UK FTSE 100 | 5323.8 | 29.2 | 0.0056
Spreadsheet: lynn_blair__24325__TW 12-03-01 Transportation Invoices - ENA
Sheet: TW-ENA Invoices

[NAME]
November 2001 Transportation Invoices
In Which ENA in PAYOR
[NAME] | Contr # | Charge Id | Invoice # | Inv Date | Due Date | Amount | Comments
EASTERN NEW MEXICO GAS ASSOCIATION | 24754 | RES | 217283 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 1569.38 | ENA acting as Agent
EASTERN NEW MEXICO GAS ASSOCIATION | 24754 | COM | 217556 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 160.92 | ENA acting as Agent
ENERVEST SAN JUAN OPERATING, L.L.C. | 24568 | RES | 217273 | 2001-12-03 00:00:00 | 2001-12-13 00:00:00 | 198720 | ENA acting as Agent
ENERVEST SAN JUAN OPERATING, L.L.C. | 24568 | COM | 217552 | 2001-12-03 00:00:00 | 2001-12-13 00:00:00 | 10035.16 | ENA acting as Agent
ENRON NORTH AMERICA CORP. | 8003 | COM | 217534 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 18929.59 | ENA Contract
ENRON NORTH AMERICA CORP. | 24654 | RES | 217274 | 2001-12-03 00:00:00 | 2001-12-13 00:00:00 | 49680 | ENA Contract
ENRON NORTH AMERICA CORP. | 24654 | COM | 217553 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 3871.39 | ENA Contract
ENRON NORTH AMERICA CORP. | 24924 | RES | 217293 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 42982.41 | ENA Contract
ENRON NORTH AMERICA CORP. | 24924 | COM | 217558 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 2017.59 | ENA Contract
ENRON NORTH AMERICA CORP. | 26740 | RES | 217394 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 10086.4 | ENA Contract
ENRON NORTH AMERICA CORP. | 26740 | COM | 217579 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 1913.6 | ENA Contract
ENRON NORTH AMERICA CORP. | 27750 | RES | 217039 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 77865 | * Capacity Release: Aquired from Citizens
ENRON NORTH AMERICA CORP. | 27750 | COM | 217065 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 670.23 | * Capacity Release: Aquired from Citizens
ENRON NORTH AMERICA CORP. | 27752 | RES | 217040 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 127890.01 | * Capacity Release: Aquired from Citizens
ENRON NORTH AMERICA CORP. | 27752 | COM | 217066 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 7178.34 | * Capacity Release: Aquired from Citizens
SOUTHERN UTE INDIAN TRIBE | 24669 | RES | 217276 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 15018.43 | ENA acting as Agent
SOUTHERN UTE INDIAN TRIBE | 24669 | COM | 217554 | 2001-12-03 00:00:00 | 2001-12-14 00:00:00 | 846.11 | ENA acting as Agent
* Capacity Release contracts aquired from Citizens Communications Company.  A notification letter was sent to ENA (and Citizens) on 12/17/01 notifiying
them they are in default of Transwestern's capacity release program.  The demand invoices will revert back to Citizens for payment.  [NAME] recalled this
capacity on 11/30/01 and plan to pay TW directly for December business.
Spreadsheet: 711759d1609880585-simple-countifs-returns-value-example-31
Sheet: OCC - Delays report

2021-01-05
Delays on 2020-12-01 - 2020-12-31
Departure delays
Date | Flight | Reg | DEP | DST | ATD | ATA | D1 | Delay | D2 | Delay | D3 | Delay | D4 | Delay | Total dep delay |  |  |  | Reason | 5-15 minutes | 16-60 minutes | >60 minutes
2020-12-21 16:33:00 |  |  | ABC | DEF | 2020-12-21 16:33:00 | 2020-12-21 17:03:00 | FT | 6 |  | 0 |  | 0 |  | 0 | 6 |  |  |  | FT
2020-12-27 07:29:00 |  |  | ABC | HIJ | 2020-12-27 07:29:00 | 2020-12-27 08:16:00 | ED | 22 |  | 0 |  | 0 |  | 0 | 22 |  |  |  | ED
2020-12-03 05:44:00 |  |  | ABC | KLM | 2020-12-03 05:44:00 | 2020-12-03 07:06:00 | WI | 101 |  | 0 |  | 0 |  | 0 | 101 |  |  |  | WI
Spreadsheet: 734302d1622099719-multiple-lookup-book2
Sheet: Sheet2

Type | [NAME] | Reference
IN02 | 2065000000 | [PHONE]
IN05 | 2065000000 | 5395
IN02 | 2065000001
IN05 | 2065000001
IN02 | 2065000002
IN05 | 2065000002
IN02 | 2065000003
IN05 | 2065000003
IN02 | 2065000004
IN05 | 2065000004
IN02 | 2065000005
IN05 | 2065000005
IN02 | 2065000006
IN05 | 2065000006
IN02 | 2065000007
IN05 | 2065000007
IN02 | 2065000008
IN05 | 2065000008
IN02 | 2065000009
IN05 | 2065000009
IN02 | 2065000010
IN05 | 2065000010
IN02 | 2065000012
IN05 | 2065000012
IN02 | 2065000013
IN05 | 2065000013
IN02 | 2065000014
IN05 | 2065000014
IN02 | 2065000015
IN05 | 2065000015
IN02 | 2065000016
IN05 | 2065000016
IN02 | 2065000017
IN05 | 2065000017
IN02 | 2065000018
IN05 | 2065000018
IN02 | 2065000019
IN05 | 2065000019
IN02 | 2065000020
IN05 | 2065000020
IN02 | 2065000021
IN05 | 2065000021
IN02 | 2065000022
IN05 | 2065000022
IN02 | 2065000023
IN05 | 2065000023
IN02 | 2065000024
IN05 | 2065000024
IN02 | 2065000025
IN05 | 2065000025
IN02 | 2065000026
IN05 | 2065000026
IN02 | 2065000027
IN05 | 2065000027
IN02 | 2065000028
IN05 | 2065000028
IN02 | 2065000029
IN05 | 2065000029
IN02 | 2065000031
IN05 | 2065000031
IN02 | 2065000035
IN05 | 2065000035
IN02 | 2065000036
IN05 | 2065000036
IN02 | 2065000037
IN05 | 2065000037
IN02 | 2065000039
IN05 | 2065000039
IN02 | 2065000044
IN05 | 2065000044
IN02 | 2065000045
IN05 | 2065000045
IN02 | 2065000046
IN05 | 2065000046
IN02 | 2065000047
IN05 | 2065000047
IN02 | 2065000050
IN05 | 2065000050
IN02 | 2065000051
IN05 | 2065000051
IN02 | 2065000052
IN05 | 2065000052
IN02 | 2065000054
IN05 | 2065000054
IN02 | 2065000086
IN05 | 2065000086
IN02 | 2065000087
IN05 | 2065000087
IN02 | 2065000088
IN05 | 2065000088
IN02 | 2065000089
IN05 | 2065000089
IN02 | 2065000091
IN05 | 2065000091
IN02 | 2065000092
IN05 | 2065000092
IN02 | 2065000093
IN05 | 2065000093
IN02 | 2065000094
IN05 | 2065000094
IN02 | 2065000095
IN05 | 2065000095
IN02 | 2065000096
IN05 | 2065000096
IN02 | 2065000097
IN05 | 2065000097
IN02 | 2065000098
IN05 | 2065000098
IN02 | 2065000099
IN05 | 2065000099
IN02 | 2065000100
IN05 | 2065000100
IN02 | 2065000102
IN05 | 2065000102
IN02 | 2065000104
IN05 | 2065000104
IN02 | 2065000106
IN05 | 2065000106
IN02 | 2065000108
IN05 | 2065000108
IN02 | 2065000109
IN05 | 2065000109
IN02 | 2065000115
IN05 | 2065000115
IN02 | 2065000117
IN05 | 2065000117
IN02 | 2065000122
IN05 | 2065000122
IN02 | 2065000123
IN05 | 2065000123
IN02 | 2065000124
IN05 | 2065000124
IN02 | 2065000125
IN05 | 2065000125
IN02 | 2065000126
IN05 | 2065000126
IN02 | 2065000127
IN05 | 2065000127
IN02 | 2065000128
IN05 | 2065000128
IN02 | 2065000129
IN05 | 2065000129
IN02 | 2065000130
IN05 | 2065000130
IN02 | 2065000131
IN05 | 2065000131
IN02 | 2065000132
IN05 | 2065000132
IN02 | 2065000134
IN05 | 2065000134
IN02 | 2065000135
IN05 | 2065000135
IN02 | 2065000136
IN05 | 2065000136
IN02 | 2065000148
IN05 | 2065000148
IN02 | 2065000149
IN05 | 2065000149
IN02 | 2065000150
IN05 | 2065000150
IN02 | 2081001001
IN05 | 2081001001
IN02 | 2081001003
IN05 | 2081001003
IN02 | 2081001005
IN05 | 2081001005
IN02 | 2088200000
IN05 | 2088200000
IN02 | 2088200001
IN05 | 2088200001
Spreadsheet: 698098d1601741236-criteria-based-ranking-test-38-ans
Sheet: Test

 |  |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Except | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-15 00:00:00 | [NAME] |  | 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  |  | * Rank 1 is to be given for XXX & YYY items (in col. E), then ranking is to be done of only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.5 | Urgent | 2020-05-11 00:00:00 |  |  | 2
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 |  |  | 3
CTR_06 | 3.41 | Urgent | 2020-04-21 00:00:00 |  |  | 4
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  |  | 5
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00 | YYY |  | 1
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 6
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 6
Spreadsheet: 828480d1683542840-pull-multiple-data-table-based-on-specific-value-test
Sheet: Overview

 | Customer Details |  |  |  |  |  | Training |  |  |  | CSM Visits
 | Customer | Nowel |  |  |  |  |  |  |  |  | Q1 | Q2 | Q3 | Q4
 | Country |  |  |  |  |  | Delivered |  |  | Status
 | Location |  |  |  |  |  | Days Until |  |  | Days Until
 | Contract Type
 | Contract Start Date |  |  |  |  |  | Weekly Reports |  |  | Teams Meetings
 | Contract Duration |  |  |  |  |  | Sent | Compliance % |  | Held | Compliance %
 | Equipment
 | SF Link
 | Historical Feedback
 | Date | Comments