tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50073d1249476374-excel-2007-information-merge-from-multiple-sheets-automatic-end-of-month-report-year-09
Sheet: JULY 09

 | CONTRACTOR UTILIZED: |  | [NAME]
 | WEEK #1 | 29 JUN - 4 JUL | # of HOURS | # of STUDENTS | CLASS #
ENTER COURSE, CLASS # & # OF STUDENTS IN THE TOTALS BLOCK AT BOTTOM OF PAGE | 15T10 Reclass |  | 32 | 14 | 09-003
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V) |  | 8
ENTER DATES AT WEEK # FIRST THEN ENTER HOURS FOR APPROPRIATE COURSE | WEEK #1 TOTAL |  | 40 | 14
 | WEEK #2 | 6 - 10 JUL | # of HOURS | # of STUDENTS | CLASS #
 | 15T10 Reclass |  | 40 | 14 | 09-003
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #2 TOTAL |  | 40 | 14
 | WEEK #3 | 13 - 17 JUL | # of HOURS | # of STUDENTS | CLASS #
 | 15T10 Reclass |  | 40 | 14 | 09-003
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #3 TOTAL |  | 40 | 14
 | WEEK #4 | 20 - 24 JUL | # of HOURS | # of STUDENTS | CLASS #
 | 15T10 Reclass |  | 0 | 0 | 09-003
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V) |  | 40
 | WEEK #4 TOTAL |  | 40 | 0
 | WEEK #5 |  | # of HOURS | # of STUDENTS | CLASS #
 | 15T10 Reclass |  |  |  | 09-003
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #5 TOTAL |  | 0 | 0
 | WEEK #6 |  | # of HOURS | # of STUDENTS | CLASS #
 | 15T10 Reclass |  |  |  | 09-003
 | 0 |  |  |  | 0
 | 0 |  |  |  | 0
 | LEAVE (H/V)
 | WEEK #6 TOTAL |  | 0 | 0
 |  |  | TOTALS |  | CLASS #
Enter Course Here------------> | 15T10 Reclass |  | 112 | 14 | 09-003 | <--------Enter Class # Here
Enter Second Course Here------------> |  |  | 0 |  |  | <--------Enter Second Class # Here
Enter Third  Course Here------------> |  |  | 0 |  |  | <--------Enter Third  Class # Here
 | LEAVE (H/V) |  | 48
 | GRAND TOTAL |  | 160 | 14 |  | Enter # of Students in # of Students Column Next to Appropriate Class
Spreadsheet: 52351d1252052891-make-columns-visible-invisible-as-per-the-conditions-team-activity-tracker-sept-09
Sheet: Deeps

Date | Day | Task | Functional Area | Total [NAME] | Total TC Modified | Existing Scenarios Identified | New Scenarios Identified | No of Test Matrices | Document/s Reviewd | TCs Executed | TCs Passed | TCs Failed | Defects Found | Defect Nos/ [NAME] retested | Detailed Description
2009-09-01 00:00:00 | Tuesday | Test Case Modification | Module 1
2009-09-02 00:00:00 | Wednesday | <select> | <select>
2009-09-03 00:00:00 | Thursday | <select> | <select>
2009-09-04 00:00:00 | Friday | <select> | <select>
2009-09-05 00:00:00 | Saturday
2009-09-06 00:00:00 | Sunday
2009-09-07 00:00:00 | Monday | <select> | <select>
2009-09-08 00:00:00 | Tuesday | <select> | <select> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <select> | <select>
2009-09-09 00:00:00 | Wednesday | <select> | <select> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Module 1 | Test Case Creation
2009-09-10 00:00:00 | Thursday | <select> | <select> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Module 2 | Test Case Modification
2009-09-11 00:00:00 | Friday | <select> | <select> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | Test Scenario Creation
2009-09-12 00:00:00 | Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Matrix
2009-09-13 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Review
2009-09-14 00:00:00 | Monday | <select> | <select> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | System Test
2009-09-15 00:00:00 | Tuesday | <select> | <select> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Retest
2009-09-16 00:00:00 | Wednesday | <select> | <select> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other
2009-09-17 00:00:00 | Thursday | <select> | <select>
2009-09-18 00:00:00 | Friday | <select> | <select>
2009-09-19 00:00:00 | Saturday
2009-09-20 00:00:00 | Sunday
2009-09-21 00:00:00 | Monday | <select> | <select>
2009-09-22 00:00:00 | Tuesday | <select> | <select>
2009-09-23 00:00:00 | Wednesday | <select> | <select>
2009-09-24 00:00:00 | Thursday | <select> | <select>
2009-09-25 00:00:00 | Friday | <select> | <select>
2009-09-26 00:00:00 | Saturday
2009-09-27 00:00:00 | Sunday
2009-09-28 00:00:00 | Monday | <select> | <select>
2009-09-29 00:00:00 | Tuesday | <select> | <select>
2009-09-30 00:00:00 | Wednesday | <select> | <select>
Spreadsheet: 36186d1233951586-selecting-multiple-criterias-to-return-one-variable-weekly-stat-report_testb
Sheet: Wkly Stat

Date: | 2009-01-26 00:00:00
TEAM GREEN | % Per Half Hr. |  |  |  |  |  |  |  | Average: | #N/A
Agent Name |  | 8:00 | 8:30 | 9:00 | 9:30 | 10:00 | 10:30 | 11:00 | 11:30 | 12:00 | 12:30 | 13:00 | 13:30 | 14:00 | 14:30 | 15:00 | 15:30 | Total | Actual
[NAME]
 | No. of Calls | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 34
 | Ready Time | 00:00:04 | 1900-01-01 00:00:00 | 00:00:27 | 1900-01-01 00:00:00 | 00:00:04 | 1900-01-01 00:00:00 | 00:00:15 | 00:00:20 | 00:00:37 | 00:00:39 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:00:06 | 00:00:08 | 00:00:08 | 1900-01-01 00:00:00 | 00:00:50
 | Talk Time | 00:01:20 | 1900-01-01 00:00:00 | 00:13:39 | 00:01:04 | 00:09:27 | 00:03:26 | 00:16:47 | 00:07:56 | 00:10:50 | 00:07:15 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:14:26 | 00:09:57 | 00:17:49 | 00:02:16 | 00:45:43
?? | Break Time | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | Total | 00:01:24 | 1900-01-01 00:00:00 | 00:14:06 | 00:01:04 | 00:09:31 | 00:03:26 | 00:17:02 | 00:08:16 | 00:11:27 | 00:07:54 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 00:14:32 | 00:10:05 | 00:17:57 | 00:02:16 | 00:46:33
 |  | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0.8333333333333334
 |  | 00:01:00
Spreadsheet: 145464d1331595863-calculating-start-and-end-times-roster-graph
Sheet: Graphic Layout of Roster

 | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday
 |  | Name 2 | Name 3 |  | Name 2 | Name 3 |  | Name 2 | Name 3 |  | Name 2 | Name 3 |  | Name 2 | Name 3 |  | Name 2 | Name 3 |  | Name 2 | Name 3
1900-01-12 00:00:00
00:30:00
01:00:00
01:30:00
02:00:00
02:30:00
03:00:00
03:30:00
04:00:00
04:30:00
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
23:30:00
1900-01-01 00:00:00
Spreadsheet: rick_buy__32924__Group_Netco1 Budget
Sheet: Natural Gas Admin

 | Natural Gas Admins
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 0
 |  |  |  |  |  |  |  | Director | 143000 | 0
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 693796d1599153972-getting-mid-and-iferror-to-play-nice-data-handling-test-mid-with-iferror
Sheet: Sheet1

ORIGINAL DATA | Nurse Y/N | Grad Date |  |  | CE Credit Date
[NAME], [NAME] Number (1121) Most Recent Nursing School Date: January 2020 Originally Completed Nursing School: 2017-09-01 | True | 2017-09-01 | January 2020 Originally Completed Nursing School: 2017-09-01 | January 2020 | January 2020
 |  |  | I cant seem to get A working formula to find the second space after the J in January so I am using the above work around
[NAME], [NAME] Number (61223) [NAME]. |  |  | #N/A | #N/A | #N/A
 |  | Cell Above: Now it looks like its working but, if you see below, wrapping the formula in If iserror isnt returning the date
[NAME], [NAME] Number (61223) [NAME]. Completed Nursing School: 2017-09-01 | True | 0 | #N/A | #N/A | #N/A
 |  | Cell above: Here it should be either the date or blank
Spreadsheet: 838441d1691009740-excel-calander-employee-absence-schedule12023
Sheet: June

 | Absence Type Key | AL | Annual Leave |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | June | Dates of Absence
 | Employee Name | 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 | Total Days | AL | Personal | Sick
 | [NAME] |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Alsop |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Avery |  |  |  |  | BH
 | Bailey |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Bell |  |  |  |  | BH
 | Berry |  |  |  |  | BH
 | Black |  |  |  |  | BH
 | Blake |  |  |  |  | BH
 | Bond |  |  |  |  | BH
 | Bower |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Buckland |  |  |  |  | BH
 | Burgess |  |  |  |  | BH
 | Butler |  |  |  |  | BH
 | Cameron |  |  |  |  | BH
 | Campbell |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Chapman |  |  |  |  | BH
 | Churchill |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Clarkson |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Cornish |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Davies |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Dyer |  |  |  |  | BH
 | Edmunds |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Ferguson |  |  |  |  | BH
 | Fisher |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Glover |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Grant |  |  |  |  | BH
 | Gray |  |  |  |  | BH
 | Greene |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
 | Hardacre |  |  |  |  | BH
 | [NAME] |  |  |  |  | BH
Spreadsheet: 185930d1349881341-return-d-based-on-closest-value-in-c-if-b-is-a-particular-value-return-closest-match-error
Sheet: Sheet1

 | Category A | Category B | Value |  |  |  |  | INPUT |  |  |  | ACTUAL OUTPUT |  |  |  | CORRECT OUTPUT
 | AA | 1097 | 2093.457943925233
 | AA | 507 | 939.252336448598 |  |  |  |  | Category A | Category B |  |  | Cat A | Cat B | Value |  | Cat A | Cat B | Value
 | AA | 609 | 728.9719626168223 |  |  |  |  | AC | 1097 |  |  | AA | 1097 | 2093.457943925233 |  | #N/A | #N/A | #N/A
 | IK | 640 | 939.252336448598 |  |  |  |  | OM | 321 |  |  | MI | 321 | 616.822429906542 |  | #N/A | #N/A | #N/A
 | IK | 662 | 1228.971962616822 |  |  |  |  | OT | 321 |  |  | OB | 353 | 691.588785046729 |  | OT | 353 | 800.545
 | IK | 568 | 752.3364485981308 |  |  |  |  | OB | 322 |  |  | MI | 303 | 584.1121495327102 |  | OB | 303 | 588.7850467289719
 | IK | 10000 | 728.9719626168223
 | MI | 321 | 616.822429906542
 | MI | 303 | 584.1121495327102
 | OB | 281 | 532.7102803738318
 | OB | 303 | 588.7850467289719
 | OB | 353 | 691.588785046729
 | OT | 353 | 800.545
Spreadsheet: 727712d1618052228-help-identify-position-on-graph-excelhelp2
Sheet: Parameters

Out of Bounds | Left Fairway | Right Fairway | Gross Price List Price
0.633333333 | 0 | 0 | 10000
0.676443501 | 0.126014336 | 0 | 25000
0.709055084 | 0.221340501 | 0 | 50000
0.728131637 | 0.277102733 | 0.047940151 | 75000
0.741666667 | 0.316666667 | 0.095833333 | 100000
0.793354803 | 0.467755064 | 0.278729814 | 300000
0.817388417 | 0.538007168 | 0.363771835 | 500000
0.83646497 | 0.5937694 | 0.431273484 | 750000
0.845042939 | 0.618843461 | 0.461626295 | 900000
0.85 | 0.633333333 | 0.479166667 | 1000000
0.860498585 | 0.664021504 | 0.516315505 | 1250000
0.869076553 | 0.689095565 | 0.546668316 | 1500000
0.876329122 | 0.710295382 | 0.572331252 | 1750000
0.882611583 | 0.728659499 | 0.594561498 | 2000000
0.901688136 | 0.784421731 | 0.662063148 | 3000000
0.915223166 | 0.823985664 | 0.70995633 | 4000000
0.92572175 | 0.854673835 | 0.747105168 | 5000000
0.934299719 | 0.879747896 | 0.777457979 | 6000000
0.941552288 | 0.900947713 | 0.803120915 | 7000000
0.947834749 | 0.919311829 | 0.825351162 | 8000000
0.953376272 | 0.935510128 | 0.844959629 | 9000000
0.958333333 | 0.95 | 0.8625 | 10000000
Spreadsheet: 39720d1238003816-lookup-question-inv-with-multiple-search
Sheet: What I would like to see

This is what I am looking for.
Search range
From | To
001001 | 001222
005001 | 005100
Output
[PHONE] |  |  |  | border formatting does not matter.
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
Spreadsheet: phillip_m_love__30155__9902_OA
Sheet: TX-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: jeff_dasovich__14155__WSCC Reserve Margins
Sheet: Sheet1

 | Est Unconstrained Non coincident Summer Peak
 | CA ISO | Oth CA | AZ/NM/NV | RMPA | [NAME] | US | BC | AB | MEX | WSCC
1998 | 45.7 | 6.2 | 21.75 | 8 | 34.9 |  | 7.7 | 6.9 | 1.34
1999 | 45.9 | 5.9 | 20 | 7.8 | 34.2 |  | 7.5 | 6.8 | 1.5
2000 | 46.2 | 6 | 21.8 | 8.4 | 35.6 |  | 7.6 | 7.2 | 1.59
2001 | 44.8 | 6.15 | 22.4452 | 8.4 | 34.08 |  | 7.252 | 7.416 | 1.66155
2002 | 45.43449999999999 | 6.30375 | 23.253398 | 8.693999999999999 | 35.93456 |  | 7.59704 | 7.63848 | 1.73631975
 | Gen Resources
1998 | 45 | 7 | 20.3 | 8.3 | 50 |  | 11 | 7.2 | 1.5
1999 | 45 | 7.2 | 20.3 | 8.6 | 50.2 |  | 11 | 7.8 | 1.5
2000 | 45 | 7.4 | 20.8 | 8.9 | 50.2 |  | 11.1 | 8.5 | 1.6
2001 | 46.5 | 7.7 | 22.7 | 9.3 | 51.9 |  | 11.3 | 8.8 | 2.1
2002 | 49.9 | 7.8 | 24.3 | 9.9 | 53.2 |  | 11.3 | 9.1 | 2.3
 | Load Managerment
1998 | 2.8 | 0 | 0.7 | 0 | 0.5 |  | 0 | 0.2 | 0
1999 | 2.8 | 0 | 0.7 | 0.2 | 0.5 |  | 0 | 0.2 | 0
2000 | 2 | 0 | 0.7 | 0.2 | 0.5 |  | 0 | 0.4 | 0
2001 | 1.5 | 0 | 0.3 | 0.1 | 1.1 |  | 0 | 0.4 | 0
2002 | 1.5 | 0 | 0.3 | 0.1 | 1.1 |  | 0 | 0.4 | 0
 | Net Demand
1998
1999
2000
2001
2002
 | Firm Trade
1998 | -4.2 | 0 | -2.5 | -0.3 | 6 |  | 1.2 | -0.5 | 0
1999 | -4.1 | 0 | -2.5 | -0.3 | 6 |  | 1.2 | -0.5 | -0.1
2000 | -4.1 | 0 | -2.5 | -0.3 | 6 |  | 1.2 | -0.5 | -0.1
2001 | -4.5 | 0.5 | -2.6 | -0.4 | 6 |  | 1 | -0.3 | 0
2002 | -4 | 0 | -2.6 | -0.4 | 6 |  | 1 | -0.3 | 0
 | Reserve Margin
1998
1999
2000
2001
2002
Spreadsheet: 869647d1716246911-converting-a-table-to-another-table-table-help
Sheet: Sheet2

Source.Name | Item 61 | Item 71 | Item 113
10C0104_A23A Scour Evaluation Final Report.xlsx | 7 | 8 | 8
10R0159_A23A Scour Evaluation Final Report.xlsx | 6 | 7 | 5
10XX140_A23A Scour Evaluation Final Report.xlsx | 7 | 7 | 8
10XX159_A23A Scour Evaluation Final Report.xlsx | 5 | 6 | 8
10XX233_A23A Scour Evaluation Final Report.xlsx | 5 | 6 | 7
Spreadsheet: 153342d1335878922-calculation-of-text-and-numbers-claims
Sheet: BI

Policy | CLAIMS |  |  |  | TOTAL CLAIMS |  | DEDUCTIBLE/ | Claims Recorded At Nil
Year | Paid |  | Oustanding |  |  |  | EXCESS
 | No. | Amount | No. | Amount | No. | Amount | APPLICABLE
 | 0 | Nil | 0 | Nil
 | 0 | Nil | 0 | Nil
 | 0 | Nil | 0 | Nil
 | 0 | Nil | 0 | Nil
 |  | Not Insured
TOTALS
Spreadsheet: 81687d1281810431-vlookup-shortage-presentation-template-1-
Sheet: Yesterday Shortages

DJ | System | Item | Description | QTY | NBD | Start DT | Commit DT | State | Comments
1234 | A | 1234-RB | VACCUM | 1 |  | 2010-08-16 00:00:00 | 2010-08-15 00:00:00 |  | 7-28 LH Please TAKE demand down and add 0246-02635
23132 | B | 15783-FI | TUBE | 1 |  |  | 2010-09-03 00:00:00 |  | 7/28 JW [x2 B45]
13213 | C | 476578CMP | HEATER | 3 |  | 2010-08-09 00:00:00 | 2010-08-31 00:00:00 |  | 7/28 JW [x5 8/2] fedex8691324
21321 | D | 23876TDK | VACUUM BOLT | 1 |  |  | 2010-09-01 00:00:00 |  | 7/27 GW [requested pull in]
1231 | G | 2387980RB | HEATER BOLT | 2 |  |  | 2010-08-25 00:00:00 |  | 7/28 GW [pending FAI]
21321 | A | 7986875CMP | HT COVER | 1 |  | 2010-08-12 00:00:00 | 2010-08-12 00:00:00 |  | 7/26CY - Req'd x8 from AGS Louisville for Next-day.  LT in Oracle was wrong-corrected.
213 | M | 23478FI | PROC | 1 |  |  | 2010-09-15 00:00:00 |  | 7/27-RA-{x2 in stock Austin depot -CR}
131331 | B | 8645CPI | SWITCH | 1 |  |  | 2010-09-11 00:00:00
13213 | C | 28672RB | FILM | 2 |  |  | 2010-08-31 00:00:00
1323 | M | 0040-1234 | TEMP | 1 |  |  | 2010-09-05 00:00:00
1323 | D | 0040-1235 | COOLER SYS | 1 |  |  | 2010-08-26 00:00:00 |  | 7/27-RA-{x2 in stock Austin depot -CR}
Spreadsheet: 789744d1659343976-iferror-or-else-need-help-with-formula-collections
Sheet: Tracked Mon 

 | Tracked Consumables Loading Requirements |  |  |  |  |  |  |  | 2022-07-25 00:00:00 | Monday
 | Customer |  | To be loaded |  |  |  | Duty Number | Prefrred Loading time | Trailer Number | Shift | Completed Yes/No | RCA for Non-Completion
 |  | NDC depart time | [NAME] Only | [NAME] with Red sleeves | [NAME] of Consolidated Red sleeves | Other
Spreadsheet: 456462d1460882039-calculations-using-a-matrix-correlations-use-tables_2
Sheet: Cor_INP

Commodities/Industries | 111CA | 113FF | 211 | 212 | 213 | 22 | 23 | 321 | 327 | 331 | 332 | 333 | 334 | 335 | 3361MV | 3364OT | 337 | 339 | 311FT | 313TT | 315AL | 322 | 323 | 324 | 325 | 326 | 42 | 441 | 445 | 452 | 4A0 | 481 | 482 | 483 | 484 | 485 | 486 | 487OS | 493 | 511 | 512 | 513 | 514 | 521CI | 523 | 524 | 525 | HS | ORE | 532RL | 5411 | 5415 | 5412OP | 55 | 561 | 562 | 61 | 621 | 622 | 623 | 624 | 711AS | 713 | 721 | 722 | 81 | GFGD | GFGN | GFE | GSLG | GSLE
111CA
113FF
211
212
213
22
23
321
327
331
332
333
334
335
3361MV
3364OT
337
339
311FT
313TT
315AL
322
323
324
325
326
42
441
445
452
4A0
481
482
483
484
485
486
487OS
493
511
512
513
514
521CI
523
524
525
HS
ORE
532RL
5411
5415
5412OP
55
561
562
61
621
622
623
624
711AS
713
721
722
81
GFGD
GFGN
GFE
GSLG
GSLE
Used
Other
V001
V002
V003
Spreadsheet: 844192d1695941241-display-unique-values-with-a-count-for-a-date-range-unique-values-test-01
Sheet: Sheet1

NAME | DATE |  | UNIQUE FOR (COLUMN A) FOR THE LAST 30 DAYS (COLUMN B) AND A COUNT OF THE TOTAL UNIQUE DISPLAYED AND SORTED HIGH TO LOW
JOE | 2023-08-01 00:00:00 |  | JOE | 3
JOE | 2023-09-02 00:00:00 |  | SUE | 2
SUE | 2023-09-04 00:00:00 |  | MARK | 1
MARK | 2023-09-06 00:00:00 |  | LISA | 1
LISA | 2023-09-15 00:00:00
SUE | 2023-09-16 00:00:00
JOE | 2023-09-18 00:00:00
JOE | 2023-09-20 00:00:00
TEST | 2023-08-01 00:00:00
Spreadsheet: 139916d1328544629-sort-with-combobox-sample-excel-inventory-using-indirect-data-validation
Sheet: SampleBOM

Updated | [NAME] Number- | 000.0000.00.0000.000.00 |  | Job# | REV 1
00/00/00 | Shaft Description- |  |  | 12345
 |  |  |  | Unit Cost | Extended | Extended
Quantity | Part Number | Description |  | Cost | Cost | Sell Price
 |  | FlangeYoke |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | SUBTOTAL
 | Hrs. |  | Assembly Labor | 52
 | Hrs. |  | [NAME] | 52
 |  |  | Total
 |  |  | Sell
Customer |  | Length |  |  | Color
Account# |  | Notes:
Phone#
Fax#
Contact
Spreadsheet: 215659d1361447986-extracting-rows-from-a-spreadsheet-based-on-a-unique-code-that-may-appear-in-two-columns-book1
Sheet: Sheet2

1235 | 5 | Rows Match
1235 | 0 | 1234 | data2 | Abc2 | 0
1238 | 0 | 1235 | data5 | [NAME] | 0
1235 | 0 | 1234 | data9 | Abc9 | 0
1236 | 0 | 1235 | data10 | Abc10 | 0
1235 | 0 | 1238 | data13 | Abc13 | 0
Spreadsheet: 844705d1696419423-same-conditional-formatting-rule-for-different-rows-example
Sheet: Sheet1

 |  |  |  |  |  |  | For cell E10 I have a Conditional formating rule, that if cell E10 is not bettween tolerances the text in E10 turns red.  Is there any option to copy this same rule for all other rows, but related to the data of each individual row (but I do not want to write rule for each row separately)?
Nominal | U tolerance | L tolerance
1 | -3 | 3 |  | 5
2 | -3 | 3 |  | 2
3 | -3 | 3 |  | 8
4 | -3 | 3 |  | 12
5 | -3 | 3 |  | 20
6 | -3 | 3 |  | 11
7 | -3 | 3 |  | 2
8 | -3 | 3 |  | 5
Spreadsheet: 118660d1313855235-check-between-two-dates-check-between-two-dates
Sheet: Sheet1

name | date from | date to
bob | 2010-08-05 00:00:00 | 2011-07-31 00:00:00 |  |  |  | Name |  | date |  | check
[NAME] | 2011-07-18 00:00:00 | 2011-08-01 00:00:00 |  |  |  | bob |  | 31-09-2009
pat | 2010-03-26 00:00:00 | 2011-06-16 00:00:00
[NAME] | 2010-03-10 00:00:00 | 2011-02-28 00:00:00
bob | 2010-04-14 00:00:00 | 2010-08-14 00:00:00
[NAME] | 2011-06-27 00:00:00 | 2012-01-07 00:00:00
[NAME] | 2008-09-29 00:00:00 | 2009-08-25 00:00:00
bob | 2009-07-24 00:00:00 | 2009-10-24 00:00:00
pat | 2010-09-04 00:00:00 | 2011-04-15 00:00:00
[NAME] | 2009-11-10 00:00:00 | 2010-06-24 00:00:00
[NAME] | 2009-12-05 00:00:00 | 2011-04-04 00:00:00
[NAME] | 2010-01-19 00:00:00 | 2010-07-18 00:00:00
Spreadsheet: 870903d1717398731-targets-vs-act-test-177-aligw
Sheet: Sheet1

 | REV STREAM | 2023 Q1 | 2023 Q2 | 2023 Q3 | 2023 Q4 | 2023 ACT | 2023 TARGET | OPEN. ORDER | Q1 ACT 2024 | Q2 ACT 2024 | Q3 ACT 2024 | Q4 ACT 2024 | Q1 TARGET | [NAME] | [NAME] | [NAME] | 2024 TARGET | ACT VS TGT
PROPERTIES |  |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.15 | 0.35 | 0.25 | 0.25 | 0.15 | 0.35
XY | ONG | 36419.69 | 20445.29 | 17640.29 | 7508.53 |  | 50000 | 0 | 10000 | 15000 | 10000 | 10000 | 7500 | 10000 | 18000 | 25000 | 70000
 |  |  |  |  |  |  |  |  |  |  |  | AliGW