tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 272867d1382536882-filter-or-formula-susan-ray-data2
Sheet: Original

Work Order Number | Asset Number | [NAME] | Status | Original Priority | Origination Date | Origination Time | Start Date | Start Time
C228192 | PACCESS03 | [NAME] | CLO | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-07 00:00:00 | 858
C228192 | PACCESS03 | [NAME] | AWA | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-01 00:00:00 | 1631
C228192 | PACCESS03 | [NAME] | CMP | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-01 00:00:00 | 1702
C228193 | BDG001-HVAC | [NAME] | CMP | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-07 00:00:00 | 1325
C228193 | BDG001-HVAC | [NAME] | CLO | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-08 00:00:00 | 1325
C228193 | BDG001-HVAC | [NAME] | AWA | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-01 00:00:00 | 1637
C228193 | BDG001-HVAC | [NAME] | RDY | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-03 00:00:00 | 1053
I would like to see only the rows highlight yellow:
Work Order Number | Asset Number | [NAME] | Status | Original Priority | Origination Date | Origination Time | Start Date | Start Time
C228192 | PACCESS03 | [NAME] | CLO | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-07 00:00:00 | 858
C228192 | PACCESS03 | [NAME] | AWA | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-01 00:00:00 | 1631
C228192 | PACCESS03 | [NAME] | CMP | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-01 00:00:00 | 1702
C228193 | BDG001-HVAC | [NAME] | CMP | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-07 00:00:00 | 1325
C228193 | BDG001-HVAC | [NAME] | CLO | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-08 00:00:00 | 1325
C228193 | BDG001-HVAC | [NAME] | AWA | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-01 00:00:00 | 1637
C228193 | BDG001-HVAC | [NAME] | RDY | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-03 00:00:00 | 1053
Spreadsheet: 700720d1603302489-if-formula-problems-clin-tracking-base-year-10012020lkf
Sheet: OBLIGATEDPARTS

 |  |  |  | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
PR/PO # | VENDOR | DATE | AMOUNT | OCTOBER | NOVEMBER | DECEMBER | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | CLIN #
 |  |  | 5012
 |  |  | 1188.6
 |  |  | 4550.6
 |  |  | 173.75
 |  |  | 0
 |  |  | 83.26
 |  |  | 112.5
 |  |  | 850
 |  |  | 157.6
 |  |  | 12.2
 |  |  | 1890
 |  |  | 173.99
 |  |  | 68
 |  |  | 53.23
 |  |  | 178.1
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  | Total | 14503.83
 |  | 0.0868 | 1258.932444
 |  | Total | 15762.762444
Spreadsheet: 100225d1298632431-cant-hide-n-a-and-get-rank-to-work-horsetournament
Sheet: Stigagjöf

Rank | Points
1 | 300
2 | 280
3 | 270
4 | 260
5 | 250
6 | 240
7 | 230
8 | 220
9 | 210
10 | 200
11 | 190
12 | 180
13 | 170
14 | 160
15 | 150
16 | 140
17 | 130
18 | 120
19 | 110
20 | 100
21 | 90
22 | 80
23 | 70
24 | 60
25 | 50
26 | 40
27 | 30
28 | 20
29 | 10
30 | 0
31 | 0
32 | 0
33 | 0
34 | 0
35 | 0
36 | 0
37 | 0
38 | 0
39 | 0
40 | 0
Spreadsheet: 811658d1672734029-resource-allocation-based-on-week-numbers-resource-allocation
Sheet: Sheet1

Name | Start date | Weeks in total | Week number | Week number | Week number | Week number | Week number | Week number
Name 1 | 2023-01-01 00:00:00 | 2 |  | 2
Name 2 | 2023-02-02 00:00:00 | 4 |  | 7 | 8 | 9
Name 3 | 2023-03-03 00:00:00 | 3 |  | 11 | 12
Name 4 | 2023-04-04 00:00:00 | 1
Spreadsheet: 678084d1589707420-sorting-and-connecting-example1
Sheet: List1

Have: |  |  |  | Want to sort with formula: |  |  |  |  |  | Explanation
Level | Code |  | Level 1 | Level 2 | Level 3 |  |  |  | Level 1 = first number place | 1.
1 | 133XY |  | 133XY |  |  |  |  |  | Level 2 = 2nd number place (can be 1 to 3 digits) | 10.
1.10 | 2314XY |  |  | 2314XY |  |  |  |  | Level 3 = 3d nuber place | 1
1.10.1 | 231Ze |  |  |  | 231Ze
1.10.2 | 31WE |  |  |  | 31WE
Spreadsheet: 713715d1610893483-extracting-data-from-multiple-worksheets-sample-new-ufc
Sheet: Bantamweight_edit_

Rank | Fighter | Record | Last fight | Next fight
C | [NAME] | 15–1 | [NAME] | vs. Aljamain Sterling (UFC 259)
1 | Aljamain Sterling | 19–3 | [NAME] | vs. [NAME] (UFC 259)
2 | [NAME] | 13–2 | [NAME] | vs. [NAME] (UFC Fight Night 184)
3 | [NAME] | 12–3 | [NAME] | TBD
4 | [NAME] | 24–8–1 | [NAME] | vs. [NAME] (UFC Fight Night 184)
5 | [NAME] | 18–4 | [NAME] | TBD
6 | [NAME] | 29–7 | [NAME] | TBD
7 | [NAME] | 23–8–1 | Lost to [NAME] | TBD
8 | [NAME] | 18–5 (1 NC) | Lost to [NAME] | vs. [NAME] (UFC 258)
9 | [NAME] | 23–4 | [NAME] | vs. [NAME] (UFC 258)
10 | [NAME] | 27–8 | Lost to [NAME] | vs. [NAME] (UFC Fight Night 186)
11 | [NAME] | 22–3 | Lost to [NAME] | vs. [NAME] (UFC 259)
12 | [NAME] | 12–4 | [NAME] [NAME] | TBD
13 | [NAME] | 18–3–1 | Lost to [NAME] | vs. [NAME] (UFC Fight Night 184)
14 | [NAME] | 16–4–1 (1 NC) | [NAME] | vs. [NAME] (UFC 259)
15 | Marlon Vera | 16–7–1 | Lost to [NAME] | TBD
Spreadsheet: 152771d1335521836-formula-to-input-time-after-selection-from-drop-down-boxes-martin-sheets
Sheet: Table2

Material Grade
13CR80
25CR 125KSI
25CR 80KSI
28CR 110KSI
AC110SS
C110VHS
C90 13CR
C90-1CR
C95
C95 13CR
C95-1CR
HC-110
HC-95
Inconel 625
Inconel 718
Inconel 925
J55
JFE 13CR85
JFE 13CR95
JFE HP1 13CR 95
JFE HP1 13CR110
JFE HP2 13CR110
JFE HP2 13CR95
K55
L80
L80 1CR
L80 9CR
N80
P110
Q125
QR125
SAF2507
SM13CR-85
SM13CRS110
SM13CRS-95
SM25CRW-110
SM25CRW-125
SM25CRW-80
SM-95T
SM-95TS
SM-C110
SMT95S
ST-110
ST-95
T95-1
TN110HC
TN110SS
TRC95
VM 110 HC
VM 110 HCSS
VM 110 SS
VM 125 HC
VM 125 LT
VM 80 13CR
VM 80 HC
VM 80 HCS
VM 80 HCSS
VM 80 LT
VM 80 SS
VM 85 13 CR
VM 90 SS
VM 95 13CR
VM 95 13CRSS
VM 95 HC
VM 95 HCS
VM 95 HCSS
VM 95 LT
VM 95 S
VM 95 SS
[NAME]
VM110 13CR
VM110 LT
VM110 SS
VM125 CY
VM125 HY
VM130CY
VM25S 125
VM55 LT
X56
XT-155
Spreadsheet: 57771d1257980467-pivot-table-layout-copy-of-pivotquery
Sheet: data

name | LM | work time | travel time | Claim Total
[NAME] | Suzanne | 4 | 2 | 128
[NAME] | Suzanne | 5 | 3 | 128
[NAME] | Suzanne | 4 | 2 | 128
[NAME] | Suzanne | 6 | 1 | 128
[NAME] | Suzanne | 5 | 4 | 128
[NAME] | Suzanne | 4 | 1 | 128
denise | Suzanne | 5 | 3 | 100
denise | Suzanne | 6 | 1 | 100
denise | Suzanne | 7 | 1 | 100
denise | Suzanne | 8 | 1 | 100
denise | Suzanne | 6 | 2 | 100
denise | Suzanne | 5 | 2 | 100
shaun | Suzanne | 4 | 2 | 94
shaun | Suzanne | 4 | 1 | 94
shaun | Suzanne | 5 | 1 | 94
shaun | Suzanne | 6 | 2 | 94
shaun | Suzanne | 5 | 1 | 94
shaun | Suzanne | 4 | 1 | 94
shaun | Suzanne | 5 | 1 | 94
shaun | Suzanne | 6 | 1 | 94
suzanne | Joy | 4 | 1 | 34
suzanne | Joy | 3 | 2 | 34
suzanne | Joy | 4 | 2 | 34
suzanne | Joy | 3 | 2 | 34
suzanne | Joy | 4 | 1 | 34
suzanne | Joy | 3 | 1 | 34
paps | Joy | 5 | 2 | 199
paps | Joy | 6 | 2 | 199
paps | Joy | 5 | 2 | 199
paps | Joy | 6 | 1 | 199
paps | Joy | 7 | 3 | 199
paps | Joy | 6 | 2 | 199
paps | Joy | 5 | 3 | 199
Spreadsheet: 766759d1644043570-i-have-a-formula-that-when-broken-down-shows-correct-value-but-shows-error-formula-issue
Sheet: Sheet2

 | Date | Name | Details | Income | Director's Loan Accounts |  | Bank Fess |  |  | customer services | Tools | repairs | Registration | Total | Bank Balance
 |  |  |  |  | A | G | Acc Fee | Debit fee | Int fees
 | 2020-07-01 00:00:00 | Opening Bank Balance |  |  |  |  |  |  |  |  |  |  |  | 228.28
 | 2020-07-03 00:00:00 |  |  |  | -51.67
 | 2020-07-21 00:00:00 |  |  |  |  |  |  |  |  |  |  | 100
 | 2020-07-31 00:00:00 |  |  |  | 50
 | 2020-09-22 00:00:00 |  |  |  |  | 40
 | 2020-10-02 00:00:00 |  |  |  |  | -34
 | 2020-10-17 00:00:00 |  |  |  |  | -29
 | 2020-10-27 00:00:00 |  |  | 340.7
 | 2020-11-01 00:00:00 |  |  |  |  |  | 6
 | 2020-11-12 00:00:00 |  |  |  |  | -200
 | 2020-11-12 00:00:00 |  |  |  |  | 200
 | 2021-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 79.5
 | 2021-01-13 00:00:00 |  |  |  |  | 45
 | 2021-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | 300
 | 2021-01-13 00:00:00 |  |  |  |  | -43.95
 | 2021-02-01 00:00:00 |  |  |  |  |  | 3
 | 2021-03-28 00:00:00 |  |  | 120
 | 2021-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 112
 | 2022-04-06 00:00:00 |  |  | 193.64
 | 2021-04-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 250
 | 2021-05-09 00:00:00 |  |  |  |  | 60
 | 2022-05-10 00:00:00 |  |  |  |  | -60
 | Totals
Spreadsheet: 216808d1361894012-help-with-nested-vlookup-function-to-calculate-estimated-annual-insurance-premium-ckg-operating-costs
Sheet: Mileage

Highway Driving: Miles per Gallon
 | Engine
Weight Class | 4 | 6 | 8 | turbo
1 | 37 | 31 | 29 | 27 |  |  |  | City
2 | 33 | 28 | 25 | 24 |  |  | Engine | 4
3 | NA | 24 | 22 | 21 |  |  | Weight | 3
Mixed Driving: Miles per Gallon
 | Engine
Weight Class | 4 | 6 | 8 | turbo
1 | 33 | 27 | 24 | 23
2 | 29 | 24 | 20 | 19
3 | NA | 21 | 18 | 17
City Driving: Miles per Gallon
 | Engine
Weight Class | 4 | 6 | 8 | turbo
1 | 30 | 24 | 20 | 18
2 | 25 | 21 | 18 | 17
3 | NA | 18 | 16 | 15
Spreadsheet: 473533d1470254110-mileage-reimbursement-form-formulas-not-working-mileage-reimbursement
Sheet: Mileage Log and Reimbursement

Mileage Log and Reimbursement Form (effective 7.21.16)
Employee Name |  | [NAME] |  | Amityville |  | Huntington 148 E Main
Manager's Name |  | [NAME] |  | Bay Shore 180 |  | [NAME] 281 Main
Manager's Signature |  |  |  | Bay Shore 375 |  | Little Neck
 |  |  |  | Brentwood |  | Other
Rate Per Mile |  | 0.54 |  | Deer Park |  | Port Jefferson
 | Total Mileage |  |  | Garden City |  | Riverhead
Total Mileage Reimbursement LIEYE Managers enter in payroll |  |  |  | Hauppauge |  | Sayville
Total Mileage Hours/Minutes LIEYE Managers enter in payroll |  |  | Mileage minutes are rounded to the nearest quarter hour | Haupauge (LIVM/MCM) |  | Smithtown
 |  |  |  | Hempstead |  | Southampton
Pay Date |  |  |  | Holbrook |  | Southold
Pay Period Start (Monday) |  |  |  |  |  | West Islip
Pay Period End (Sunday)
Please keep in mind that mileage reimbursement is only applicable towards travel that exceeds one's normal commute.
If the location you are traveling to or from is not listed in Column C or D, please select "Other" and explain the location and mileage rationale thoroughly.
You must include mileage data from Google Maps only if "Other" is selected.
Date | [NAME] | Starting Location | Destination | Description/Reason | Mileage (one way) | Reimbursement | Mileage Hours /Minutes
2016-08-03 00:00:00 | No | Amityville | Bay Shore 180 | Food Run
2016-08-03 00:00:00 | Yes | [NAME] | Amityville | Food Run
2016-08-03 00:00:00 | Yes | Garden City | Sayville | Food Run
Spreadsheet: 57006d1257188103-sumif-countif-using-multiple-criteria-blueyz829
Sheet: Sheet4

CUST | ID | CATEGORY | Q1 | Q2 | Q3 | Q4 | Q5
49874 | CATEGORY | 1 | 1 | 1 | 1 | 1 | NA
49874 | CATEGORY | 2 | NA | 1 | NA | 0 | NA
49874 | CATEGORY | 3 | 1 | NA | 0 | 0 | NA
49874 | CATEGORY | 4 | NA | NA | 0 | 0 | NA
49672 | CATEGORY | 1 | 1 | NA | 0 | 1 | NA
49672 | CATEGORY | 2 | NA | NA | NA | 0 | NA
49672 | CATEGORY | 3 | NA | NA | 0 | 0 | NA
49672 | CATEGORY | 4 | NA | NA | 0 | 0 | NA
 | SUMIF | COUNTIF
49874 | 11 | 6
Spreadsheet: 754444d1636198241-formula-to-extract-data-from-worksheets-test
Sheet: Data Collation

Year | Name | Subject 1 | Subject 2 | Subject 3 | Subject 4
1 | Name 1
2 | Name 2
3 | Name 3
Spreadsheet: lisa_gang__22488__Hanson Scheduling Model_6_19
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-06-19 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 20.664 | 20.736 | 20.628 | 20.904 | 21 | 21.144 | 21.372 | 19.812 | 19.668 | 19.152 | 19.044 | 22.236 | 24.924 | 21.612 | 19.98 | 24.06 | 25.656 | 24.36 | 21.048 | 26.016 | 26.628 | 26.604 | 26.268 | 26.424 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 27.00023590669258 | 27.00023590669258 | 27.00023590669258 | 27.00023590669258 | 27.00023590669258 | 27.00023590669258 | 27.20023590669259 | 27.20023590669259 | 27.20023590669259 | 27.20023590669259 | 27.20023590669259 | 27.20023590669259 | 22.32523590669259 | 22.32523590669259 | 22.32523590669259 | 21.44523590669258 | 21.44523590669258 | 21.44523590669258 | 30.22023590669259 | 30.22023590669259 | 31.10023590669259 | 31.10023590669259 | 31.10023590669259 | 31.10023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 61531d1262417706-comparing-groups-of-numbers-for-duplicates-712460_solnajeff
Sheet: Sheet1

2 | 16 | 32 | 50 | 61 | 3 | 19 | 36 | 51 | 64 | 4 | 23 | 37 | 53 | 65 | 13 | 24 | 40 | 54 | 70 |  | 15 | 25 | 45 | 58 | 72 | 2:3:4:13:16:19:23:24:32:36:37:40:50:51:53:54:61:64:65:70 | 1
6 | 20 | 31 | 46 | 66 | 9 | 21 | 33 | 52 | 67 | 11 | 27 | 39 | 55 | 69 | 12 | 29 | 41 | 57 | 73 |  | 14 | 30 | 42 | 60 | 75 | 6:9:11:12:20:21:27:29:31:33:39:41:46:52:55:57:66:67:69:73 | 1
1 | 17 | 34 | 47 | 62 | 5 | 18 | 35 | 48 | 63 | 7 | 22 | 38 | 49 | 68 | 8 | 26 | 43 | 56 | 71 |  | 10 | 28 | 44 | 59 | 74 | 1:5:7:8:17:18:22:26:34:35:38:43:47:48:49:56:62:63:68:71 | 1
1 | 17 | 33 | 47 | 61 | 4 | 21 | 37 | 53 | 63 | 9 | 22 | 39 | 56 | 64 | 11 | 25 | 41 | 58 | 65 |  | 12 | 29 | 44 | 59 | 73 | 1:4:9:11:17:21:22:25:33:37:39:41:47:53:56:58:61:63:64:65 | 1
3 | 20 | 31 | 46 | 67 | 6 | 23 | 34 | 48 | 68 | 10 | 24 | 38 | 50 | 69 | 13 | 27 | 40 | 52 | 72 |  | 15 | 30 | 42 | 60 | 75 | 3:6:10:13:20:23:24:27:31:34:38:40:46:48:50:52:67:68:69:72 | 1
2 | 16 | 32 | 49 | 62 | 5 | 18 | 35 | 51 | 66 | 7 | 19 | 36 | 54 | 70 | 8 | 26 | 43 | 55 | 71 |  | 14 | 28 | 45 | 57 | 74 | 2:5:7:8:16:18:19:26:32:35:36:43:49:51:54:55:62:66:70:71 | 1
2 | 17 | 31 | 47 | 66 | 7 | 21 | 32 | 52 | 67 | 10 | 25 | 37 | 54 | 69 | 13 | 26 | 40 | 55 | 74 |  | 14 | 28 | 41 | 58 | 75 | 2:7:10:13:17:21:25:26:31:32:37:40:47:52:54:55:66:67:69:74 | 1
4 | 16 | 35 | 46 | 63 | 5 | 20 | 42 | 48 | 64 | 9 | 22 | 43 | 53 | 68 | 12 | 27 | 44 | 57 | 70 |  | 15 | 30 | 45 | 60 | 72 | 4:5:9:12:16:20:22:27:35:42:43:44:46:48:53:57:63:64:68:70 | 1
1 | 18 | 33 | 49 | 61 | 3 | 19 | 34 | 50 | 62 | 6 | 23 | 36 | 51 | 65 | 8 | 24 | 38 | 56 | 71 |  | 11 | 29 | 39 | 59 | 73 | 1:3:6:8:18:19:23:24:33:34:36:38:49:50:51:56:61:62:65:71 | 1
4 | 16 | 31 | 48 | 62 | 10 | 18 | 34 | 49 | 64 | 11 | 20 | 36 | 53 | 67 | 14 | 24 | 40 | 54 | 68 |  | 15 | 26 | 42 | 60 | 73 | 4:10:11:14:16:18:20:24:31:34:36:40:48:49:53:54:62:64:67:68 | 1
Spreadsheet: darrell_schoolcraft__7578__UnitOp84
Sheet: Holcomb

Detailed compression analysis for pipeline hydraulic model: |  |  |  |  |  | HugHol84.wpf
 |  |  |  |  |  | 03/19/02 flows with Fin 2 & 4 routed south, Hugo 440 PSIG dis
Unit | Service | Suction |  | Discharge |  | Flow | HP | RPM | Step | Efficiency | Fuel
 |  | Temp | Press | Temp | Press
 |  | (F) | (PSIG) | (F) | (PSIG) | (MMSCF/D) | (HP) | (RPM) |  | (%) | (MMSCF/D)
8 | [NAME] to B | 78 | 295 | 170 | 579 | 34 | 1204 | 120 | 1 |  | 0.301
Subtotal
2 | Fin1/Hs to B | ?70? | 107 | ?212? | 579 | 13 | 1286 | 110 | 1 |  | 0.322
12 | Fin1/Hs to B | ?70? | 107 | ?206? | 579 | 5 | 472 | 280 | 1 |  | 0.118
Subtotal
Spreadsheet: 839556d1692072781-30d-moving-average-30d-moving-average
Sheet: Sheet1

Result: | Value
2031-01-01 00:00:00 | 0
2031-01-02 00:00:00 | 0
2031-01-03 00:00:00 | 0
2031-01-04 00:00:00 | 0
2031-01-05 00:00:00 | 39.88434
2031-01-06 00:00:00 | 39.74716
2031-01-07 00:00:00 | 39.61092
2031-01-08 00:00:00 | 39.47561
2031-01-09 00:00:00 | 39.34122
2031-01-10 00:00:00 | 39.20775
2031-01-11 00:00:00 | 39.07517
2031-01-12 00:00:00 | 38.94349
2031-01-13 00:00:00 | 38.8127
2031-01-14 00:00:00 | 38.68278
2031-01-15 00:00:00 | 38.55372
2031-01-16 00:00:00 | 38.42553
2031-01-17 00:00:00 | 38.29818
2031-01-18 00:00:00 | 38.17168
2031-01-19 00:00:00 | 38.04601
2031-01-20 00:00:00 | 37.92116
2031-01-21 00:00:00 | 37.79713
2031-01-22 00:00:00 | 37.67391
2031-01-23 00:00:00 | 37.55149
2031-01-24 00:00:00 | 37.42986
2031-01-25 00:00:00 | 37.30902
2031-01-26 00:00:00 | 37.18896
2031-01-27 00:00:00 | 37.06966
2031-01-28 00:00:00 | 36.95113
2031-01-29 00:00:00 | 36.83336
2031-01-30 00:00:00 | 36.71633
2031-01-31 00:00:00 | 36.60005
2031-02-01 00:00:00 | 39.28566
2031-02-02 00:00:00 | 39.16202
2031-02-03 00:00:00 | 39.03916
2031-02-04 00:00:00 | 38.91706
2031-02-05 00:00:00 | 38.79573
2031-02-06 00:00:00 | 38.67515
2031-02-07 00:00:00 | 38.55532
2031-02-08 00:00:00 | 38.43622
2031-02-09 00:00:00 | 38.31786
2031-02-10 00:00:00 | 38.20023
2031-02-11 00:00:00 | 38.08332
2031-02-12 00:00:00 | 37.96712
2031-02-13 00:00:00 | 37.85163
2031-02-14 00:00:00 | 37.73684
2031-02-15 00:00:00 | 37.62274
2031-02-16 00:00:00 | 37.50933
2031-02-17 00:00:00 | 37.3966
2031-02-18 00:00:00 | 37.28455
2031-02-19 00:00:00 | 37.17317
2031-02-20 00:00:00 | 37.06245
2031-02-21 00:00:00 | 36.95239
2031-02-22 00:00:00 | 36.84298
2031-02-23 00:00:00 | 36.73422
2031-02-24 00:00:00 | 36.62609
2031-02-25 00:00:00 | 36.5186
2031-02-26 00:00:00 | 36.41174
2031-02-27 00:00:00 | 36.30551
2031-02-28 00:00:00 | 36.19989
2031-03-01 00:00:00 | 38.15134
2031-03-02 00:00:00 | 38.04099
2031-03-03 00:00:00 | 37.93128
2031-03-04 00:00:00 | 37.8222
2031-03-05 00:00:00 | 37.71375
2031-03-06 00:00:00 | 37.60592
2031-03-07 00:00:00 | 37.4987
2031-03-08 00:00:00 | 37.39209
2031-03-09 00:00:00 | 37.28609
2031-03-10 00:00:00 | 37.18069
2031-03-11 00:00:00 | 37.07587
2031-03-12 00:00:00 | 36.97166
2031-03-13 00:00:00 | 36.86802
2031-03-14 00:00:00 | 36.76496
2031-03-15 00:00:00 | 36.66248
2031-03-16 00:00:00 | 36.56056
2031-03-17 00:00:00 | 36.45922
2031-03-18 00:00:00 | 36.35843
2031-03-19 00:00:00 | 36.2582
2031-03-20 00:00:00 | 36.15852
2031-03-21 00:00:00 | 36.05938
2031-03-22 00:00:00 | 35.96079
2031-03-23 00:00:00 | 35.86273
2031-03-24 00:00:00 | 35.76521
2031-03-25 00:00:00 | 35.66822
2031-03-26 00:00:00 | 35.57175
2031-03-27 00:00:00 | 35.47581
2031-03-28 00:00:00 | 35.38038
2031-03-29 00:00:00 | 35.28546
2031-03-30 00:00:00 | 35.19104
2031-03-31 00:00:00 | 35.09714
Spreadsheet: 484572bf-afd4-4835-9759-46fce1e2b8f3
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187934122 | [NAME] | Glory All Around | 2014-06-03 | Compact Disc | Ac | 13.99 | Y | NYP
Curb Records | 715187934023 | [NAME] | Work Of Love | 2014-06-03 | Compact Disc | Ac | 13.99 | Y | NYP
Curb Records | 715187931725 | Plumb | Need You Now | 2013-02-26 | Compact Disc | Rock | 13.99 | Y | Available
Curb Records | 715187931824 | [NAME] | Some People Change | 2013-03-26 | Compact Disc | Pop | 13.99 | Y | Available
Curb Records | 715187935921 | [NAME] | Hurricane | 2013-10-15 | Compact Disc | Ac | 13.99 | Y | Available
Spreadsheet: 829402d1684195768-formula-that-continues-to-count-random-colored-cells-as-more-cells-are-added-sample-5-15-23
Sheet: Sample

 | 43.9375 | 43.96875 |  |  |  |  |  |  | The Green cells in column E only turn green if it's equal to D column of the same row. Same as the yellow except it follows the 'not equal' command.
 | 44.25 | 43.96875 |  |  | 1
 | 44.34375 | 44.21875 |  |  |  | 1
 | 44.8125 | 44.40625 |  |  |  |  |  |  | Column F looks at column E to count how many times greens cells appear in a row and then return blank cells in the other cells. Basically it will return a # in E col everytime you have a green single cell as "1" and the others as you see with a 5, 4, 2, etc. Column F will be same as column E except it looks for yellow.
 | 45 | 44.96875
 | 44.96875 | 44.96875
 | 44.96875 | 44.96875
 | 44.65625 | 44.8125 |  |  | 5
 | 44.71875 | 44.65625 |  |  |  | 1
 | 44.9375 | 44.78125
 | 44.59375 | 44.875
 | 43.46875 | 44.46875
 | 43.4375 | 43.46875 |  |  | 4
 | 43.40625 | 43.9375
 | 43.5625 | 43.40625 |  |  |  | 2
 | 43.71875 | 43.6875 |  |  | 1
 | 43.6875 | 43.84375 |  |  |  | 1
 | 44.25 | 43.71875 |  |  | 1
 | 44.34375 | 44.21875 |  |  |  | 1
 | 44.40625 | 44.4375 |  |  | 1
 | 44.28125 | 44.5625 |  |  |  | 1
 | 44.9375 | 44.3125
 | 45.125 | 45 |  |  | 2
 | 44.875 | 45.1875
 | 44.75 | 44.9375 |  |  |  | 2
 | 45.75 | 44.84375
 | 45.59375 | 45.65625 |  |  | 2
 | 45.6875 | 45.59375
 | 45.5625 | 45.71875 |  |  |  | 2
 | 45.09375 | 45.1875 |  |  | 1
 | 45.3125 | 45.0625 |  |  |  | 1
Spreadsheet: 758883d1639143976-multi-if-with-filter-function-lookup-filter-value
Sheet: Sheet2

SN | M No | Code | CA
152 | MMM215 | SSSS123 | AAA1
251 | MMM216 | SSSS124 | AAA2
63 | MMM217 | SSSS125 | AAA3
1632 | MMM218 | SSSS126 | AAA4
155 | MMM219 | SSSS127 | AAA5
232 | MMM220 | SSSS128 | AAA6
5236 | MMM221 | SSSS129 | AAA1
455 | MMM222 | SSSS130 | AAA8
662 | MMM223 | SSSS131 | AAA9
230 | MMM224 | SSSS132 | AAA1
123 | MMM225 | SSSS133 | AAA11
6325 | MMM226 | SSSS134 | AAA12
44 | MMM227 | SSSS135 | AAA1
56 | MMM228 | SSSS136 | AAA14
22 | MMM229 | SSSS137 | AAA6
793 | MMM230 | SSSS138 | AAA16
467 | MMM231 | SSSS139 | AAA17