tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: geir_solberg__11249__EPE_MAY_2001
Sheet: MAY(13)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
2001-05-13 00:00:00
HR ENDING | HR ENDING | Palo Verde | Palo Verde | Palo Verde | Palo Verde | Palo Verde | 4 CORNERS | EDDY
Pacific | Mountain | SALE | SALE | SALE | SALE | BUY | SALE | BUY
Daylight | Standard | TO PSCO | TO PSCO | TO PSCO | TO EPMI | FROM PSCO | TO ENRON | From ENRON
Time | Time | 61.75 | 61.75 | 61.75
 |  | FOR THE DAY | FOR THE DAY | FOR THE MONTH! | THESE TWO DEALS BOOKOUT TOGETHER FOR THE MONTH |  | FOR THE MONTH! | FOR THE YEAR!
 |  | 4/1/01-4/30/01 | 4/1/01-4/30/01 | 4/1/01-4/30/01 | 5/1/01-5/31/01 | 5/1/01-5/31/01 | 3/1/01-3/31/01 | 3/1/01-3/31/01
 |  | PWX TAG#TGG | PWX TAG#0000TGH | EPMI TAG#21784;21785 | BOOKOUT | BOOKOUT | PSCO TAG#1014576 | SPS TAG # | TOTAL
PDT | MST | DIRECT BILL | DIRECT BILL | DIRECT BILL | DIRECT BILL | DIRECT BILL | DIRECT BILL | DIRECT BILL
0100 | 0100 | 25 | 15 | 3 | 60 | -60 | 60 | -103
0200 | 0200 | 25 | 15 | 3 | 60 | -60 | 60 | -103
0300 | 0300 | 25 | 15 | 3 | 60 | -60 | 60 | -103
0400 | 0400 | 25 | 15 | 3 | 60 | -60 | 60 | -103
0500 | 0500 | 25 | 15 | 3 | 60 | -60 | 60 | -103
0600 | 0600 | 25 | 15 | 3 | 60 | -60 | 60 | -103
0700 | 0700 | 25 | 15 | 3 | 60 | -60 | 60 | -103
0800 | 0800 | 25 | 15 | 3 | 60 | -60 | 60 | -103
0900 | 0900 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1000 | 1000 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1100 | 1100 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1200 | 1200 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1300 | 1300 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1400 | 1400 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1500 | 1500 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1600 | 1600 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1700 | 1700 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1800 | 1800 | 25 | 15 | 3 | 60 | -60 | 60 | -103
1900 | 1900 | 25 | 15 | 3 | 60 | -60 | 60 | -103
2000 | 2000 | 25 | 15 | 3 | 60 | -60 | 60 | -103
2100 | 2100 | 25 | 15 | 3 | 60 | -60 | 60 | -103
2200 | 2200 | 25 | 15 | 3 | 60 | -60 | 60 | -103
2300 | 2300 | 25 | 15 | 3 | 60 | -60 | 60 | -103
2400 | 2400 | 25 | 15 | 3 | 60 | -60 | 60
 | MST Total
 | PDT TOTAL
 |  | EPE(G)PV | EPE(G)PV | EPE(G)PV | EPE | PSCO | EPE@4C345 | SPS (G) @ EDDY TIE
 |  | PSCO | PSCO | PSCO | EPMI | EPMI | EPE(T)4C345/4C345 | EPMI
 |  | EPMI | EPMI | EPMI | PSCO | EPE | PSCO | EPE (L) @ EDDY TIE
 |  | PWX | PWX | APS(T)PV/WW5 O#21253 |  |  | NEVP
 |  | SRP | SRP | WALC(T)WWD/PPK O#26034 |  |  | TEP
 |  | SRP(T)PV/KYRENE | SRP(T)PV/KYRENE | WALC(T) PPK/MD2 O#26034 |  |  | TEP(T)4C345/4C345
 |  | SRP(L)KYRENE | SRP(L)KYRENE | EPMI |  |  | TEP@4C
 |  |  |  | NEVP (L-MEAD)
Spreadsheet: 532437d1502281237-help-with-a-formula-for-populating-a-rota-with-names-blank-template-rota
Sheet: Rota

 |  |  | Sen. |  |  | Sen. |  |  | Sen. |  |  | Sen. |  |  | Sen. |  |  | Sen. |  |  | Sen.
 | Mon |  | Initial | [NAME] |  | Initial | Wed |  | Initial | Thurs |  | Initial | Fri |  | Initial | Sat |  | Initial | Sun |  | Initial
AM |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 8.15-3.15 |  |  | 8.15-3.15
 |  | 7.30-10 |  |  | 7.30-2.30 |  |  | 7.30-12 |  |  | 7.30-2.30 |  |  | 7.30-2.30 |  |  | 8.15-3 |  |  | 8.15-3
 |  | 7.30-20 |  |  | 7.30-12 |  |  | 7.30-10 |  |  | 7.30-2.30 |  |  | 7.30-10 |  |  | 8.15-3 |  |  | 8.15-3
 |  | 7.30-10 |  |  | 7.30-10 |  |  | 7.30-10 |  |  | 7.30-12 |  |  | 7.30-10 |  |  | 8.15-1.45 |  |  | 8.15-1.45
Activities
PM |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30 |  |  | 2-10.30
 |  | 3-10 |  |  | 3-10 |  |  | 3-10 |  |  | 2.30-9 |  |  | 3-10 |  |  | 3-10 |  |  | 3-10
 |  | 2-9 |  |  | 2-9 |  |  | 2-9 |  |  | 2-9 |  |  | 2-9 |  |  | 2-9 |  |  | 2-9
 |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 3-9 |  |  | 3-9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4-10
 |  | 10-4 |  |  | 10-4 |  |  | 10-4 |  |  | 10-4 |  |  | 10-4
 |  | 11-3 |  |  |  |  |  | 10-3 |  |  | 11-3
 |  | 10-4 |  |  |  |  |  | 10-4 |  |  |  |  |  | 10-4 |  |  | 3-5 |  |  | 9-2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3-5 |  |  | 9-2
 |  | 8-11 |  |  |  |  |  |  |  |  | 8-11 |  |  |  |  |  | 9-2 |  |  | 9-2
 |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 4-9 |  |  | 5-9 |  |  | 3-9
 |  | 12-4 |  |  | 12-4 |  |  | 12-4 |  |  | 12-4 |  |  | 12-5
 |  | 12-4 |  |  | 12-4 |  |  | 12-4 |  |  | 12-4 |  |  | 12-5
W/N
S/I
CSV
[NAME]
Support Staff
[NAME]
Domestic
Training
Spreadsheet: 865671d1712696613-conditional-format-whole-row-based-on-match-with-data-in-another-table-dummy-workbook-2-_etaf
Sheet: Sheet1

 | Location | Status | Other data | other data | other data2 | Id | Name | Lifecycle | Code | Date | COUNT(Barcode) | [NAME]
 |  |  |  |  |  |  | Host AFN6B | Active |  | 2001 | 1
 |  |  |  |  |  |  | Die Transskription | Active |  | 1940 | 1
 |  |  |  |  |  |  | Genesis | Active |  | 1951 | 1
 |  |  |  |  |  |  | Bananas | Active |  | 1977 | 1
 |  |  |  |  |  |  | Esaias | Active |  | 1987 | 2
 |  |  |  |  |  |  | Altlateinische | Active |  | 1999 | 2
 |  |  |  |  |  |  | Pharo | Active |  | 1962 | 1
 |  |  |  |  |  |  | Host AFMCB | Active |  | 1966 | 1
 |  |  |  |  |  |  | [NAME] | Active |  | 1975 | 2
 |  |  |  |  |  |  | Ice lolly | Active |  | 1956 | 1
 |  |  |  |  |  |  | [NAME] | Active |  | 2000 | 1
 |  |  |  |  |  |  | [NAME] | Active |  | 2005 | 1
 |  |  |  |  |  |  | Hester | Active |  | 2003 | 1
 |  |  |  |  |  |  | Eendtje | Active |  | 1941 | 1
 |  |  |  |  |  |  | Marduk | Active |  | 1928 | 1
 |  |  |  |  |  |  | [NAME] | Active |  | 1996 | 1
 |  |  |  |  |  |  | Libri synoptici Veteris | Active |  | 1931 | 1
 |  |  |  |  |  |  | Host AFN6A | Active |  | 1993 | 1
 |  |  |  |  |  |  | Concordance grecque | Active |  | 1987 | 1
 |  |  |  |  |  |  | Itala | Active |  | 1970 | 3
Spreadsheet: 813015d1673503477-sumproduct-with-multiple-criteria-sumproduct-1-also-try
Sheet: Sheet1

 |  |  | Transaction Type |  |  |  | Quantity
 |  |  |  | Item |  |  |  |  | IN Stock/ backorder | Amount per style | Amount per style
 |  |  | EFT | zero |  |  |  |  | 100
 |  |  | Buy | Box |  |  | 20 |  | -23
 |  |  | Buy | cart |  |  | 14201 |  | -56
 |  |  | Buy | pencil |  |  | 7344 |  | 67
 |  |  | Buy | pen |  |  | 3446 |  | 767
 |  |  | Buy | paper |  |  | 6316 |  | 45
 |  |  | Buy | pin |  |  | 26892 |  | 45
 |  |  | Buy | plate |  |  | 42000 |  | 32
 |  |  | Bought | cup |  |  | 0.91 |  | 33
 |  |  | Bought | spoon |  |  | 0.031 |  | 45
 |  |  | Bought | fork |  |  | 0.186 |  | 40
 |  |  | Bought | meat |  |  | 0.134 |  | -33
 |  |  | Bought | veg |  |  | 0.085 |  | 12
 |  |  | Bought | Noodle |  |  | 0.632 |  | 564
 |  |  | Buy | salt |  |  | 15667 |  | 557
 |  |  | Sell | zero |  |  | -7344 |  | -57
 |  |  | Bought | Box |  |  | 0.745 |  | 76
 |  |  | Sold | cart |  |  | -0.186 |  | 78
 |  |  | BALANCE | pencil |  |  |  |  | -56
 |  |  | Interest | pen |  |  | 0.19 |  | 65
 |  |  | Interest | paper |  |  | 44 |  | 68
 |  |  | Dividend | pin |  |  | 0.521 |  | 55
 |  |  | Dividend | plate |  |  | 62 |  | 556
 |  |  | Sell | cup |  |  | -3500 |  | 56
 |  |  | EFT | spoon |  |  |  |  | 454
 |  |  | Dividend | fork |  |  | 0.55 |  | -34
 |  |  | Dividend | meat |  |  | 40 |  | 223
 |  |  | Sell | veg |  |  | -3500 |  | 22
 |  |  | Deposit | Noodle |  |  |  |  | 56
 |  |  | BALANCE | salt
 |  |  | Interest | zero |  |  | 0.77
 |  |  | Interest | Box |  |  | 49
 |  |  | Dividend | cart |  |  | 0.806
 |  |  | Dividend | pencil |  |  | 53
 |  |  | Buy | pen |  |  | 576
 |  |  | Dividend | paper |  |  | 0.595
 |  |  | Dividend | pin |  |  | 452
 |  |  | Dividend | plate |  |  | 0.953
 |  |  | Dividend | cup |  |  | 92
 |  |  | Dividend | spoon |  |  | 0.131
 |  |  | Dividend | fork |  |  | 29
 |  |  | EFT | meat
 |  |  | Bought | veg |  |  | 0.472
 |  |  | Redeemed | Noodle |  |  | -3500
 |  |  | Deposit | salt
 |  |  | Interest | zero |  |  | 0.08
 |  |  | Interest | Box |  |  | 49
 |  |  | Redeemed | cart |  |  | -3500
 |  |  | Deposit | pencil
 |  |  | Interest | pen |  |  | 0.85
 |  |  | Interest | paper |  |  | 42
 |  |  | Dividend | pin |  |  | 0.673
 |  |  | Dividend | plate |  |  | 87
 |  |  | Sell | cup |  |  | -2435
 |  |  | Redeemed | spoon |  |  | -3500
 |  |  | Redeemed | fork |  |  | -0.543
 |  |  | EFT | meat
 |  |  | Deposit | veg
 |  |  | Interest | Noodle |  |  | 0.44
 |  |  | Interest | salt |  |  | 34
 |  |  | Dividend | zero |  |  | 0.525
 |  |  | Dividend | Box |  |  | 46
 |  |  | Sell | cart |  |  | -221
 |  |  | Sell | pencil |  |  | -1930
 |  |  | Sell | pen |  |  | -1531
 |  |  | Sell | paper |  |  | -3717
 |  |  | Redeemed | pin |  |  | -0.331
 |  |  | Redeemed | plate |  |  | -0.465
 |  |  | Redeemed | cup |  |  | -0.004
 |  |  | Redeemed | spoon |  |  | -0.533
 |  |  | EFT | fork
 |  |  | EFT | meat
 |  |  | BALANCE | veg
 |  |  | Interest | Noodle |  |  | 0.18
 |  |  | Redeemed | salt |  |  | -3500
Spreadsheet: 170591d1343325940-vlookup-help-vlookup-help
Sheet: Sheet1

Policy Type | State | Commission Rate
A18 | IA | ?
A18 | OK | ?
A18 | KS | ?
A18 | IN | ?
A18 | IN | ?
A18 | TX | ?
A18 | LA | ?
A18 | LA | ?
Assumptions:
State | Policy Type | Year 1 Commission
AZ | A18 | 0.43
DE | A18 | 0.43
IA | A18 | 0.43
IN | A18 | 0.43
KY | A18 | 0.43
ME | A18 | 0.43
MI | A18 | 0.43
OR | A18 | 0.43
TN | A18 | 0.43
UT | A18 | 0.43
VA | A18 | 0.43
VT | A18 | 0.43
WA | A18 | 0.43
AK | A18 | 0.55
AL | A18 | 0.55
AR | A18 | 0.55
DC | A18 | 0.55
GA | A18 | 0.55
HI | A18 | 0.55
ID | A18 | 0.55
IL | A18 | 0.55
KS | A18 | 0.55
LA | A18 | 0.55
MO | A18 | 0.55
MS | A18 | 0.55
NE | A18 | 0.55
NM | A18 | 0.55
ND | A18 | 0.55
OH | A18 | 0.55
OK | A18 | 0.55
PA | A18 | 0.55
SC | A18 | 0.55
TX | A18 | 0.55
WI | A18 | 0.55
WV | A18 | 0.55
WY | A18 | 0.55
CO | A18 | 0.23
RI | A18 | 0.23
SD | A18 | 0.23
AZ | A44A | 0.55
AZ | A44B | 0.43
AK | A48 | 0.55
AL | A48 | 0.55
AR | A48 | 0.55
DC | A48 | 0.55
GA | A48 | 0.55
HI | A48 | 0.55
ID | A48 | 0.55
IL | A48 | 0.55
KS | A48 | 0.55
LA | A48 | 0.55
MO | A48 | 0.55
NE | A48 | 0.55
NM | A48 | 0.55
OK | A48 | 0.55
PA | A48 | 0.55
SC | A48 | 0.55
TX | A48 | 0.55
WI | A48 | 0.55
WV | A48 | 0.55
WY | A48 | 0.55
DE | A48 | 0.43
FL | A48 | 0.43
IA | A48 | 0.43
IN | A48 | 0.43
KY | A48 | 0.43
ME | A48 | 0.43
MI | A48 | 0.43
NC | A48 | 0.43
OH | A48 | 0.43
OR | A48 | 0.43
UT | A48 | 0.43
TN | A48 | 0.43
VT | A48 | 0.43
NV | A48 | 0.35
SD | A48 | 0.23
Spreadsheet: 748772d1632332918-create-a-daily-rolling-schedules-from-multiple-worksheets-daily-work-schedule
Sheet: Mech

Available vs Scheduled Hours
Available Personnel and Hours
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
Zach Nimeskern |  |  | 8 | 8 | 8 | 8 | 8
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
[NAME] |  |  | 8 | 8 | 8 | 0 | 0
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
[NAME] |  |  | 8 | 8 | 8 | 8 | 8
Mechanics |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
 | Break In | Priority |  |  |  |  |  | Status / Issues
7-3 AR pump , 2 grease lines broke off of suction valve seals. they are laying below valve. | need scaff | B |  |  |  |  |  | 21-708664 - NEED SCAFFOLD
U8 Absorb Quench EJ Replacement |  | A | comp? |  |  |  |  | 21-714234
8A side Econ and SCR branch gates need replaced |  | A | comp? |  |  |  |  | 21-725241
8-3 ASH SLUICE PUMP, Outboard Mechanical Seal Leaking |  | A |  |  |  |  |  | 21-605257
8-3 ASP Outboard Shaft Bearing Oil Seal Leaking |  | B |  |  |  |  |  | 21-692605 or 21-583410
U7 FA Diffuser Blower Belts |  | A | comp? |  |  |  |  | 21-727511
PMMECH quarterly UNIT 7 IK SOOT BLOWER INSPECTION & LUBRICATION PM |  | B |  |  |  |  |  | 21-666230
CY UP RIVER ([NAME]) BARGE HAUL bull gear fill pipe broke - repair before adding oil |  | B |  |  |  |  |  | 21-593456 need gbx drained before doing work
CBTS |  | A
8A side fly ash [NAME] |  | A | comp? |  |  |  |  | 21-725306
7-5 AF Burner Line Dayton Coupling has a hole- Outage |  | A
[NAME] |  | B
U7 IR-3: back out manually. Inspect and repair |  | B |  |  |  |  |  | 20-93263/missing parts and maintenance is signed on
U -7 7A layer 1 # 3 sonic not blowing |  | B | comp? |  |  |  |  | 21-659654
Replace quick disconnect on 8-1 #6 lighter |  | B | comp? |  |  |  |  | 21-705262
PMMECH FGD 2 YEARS 7-2 Absorber Recirculation Pump Liner Inspection |  | B |  |  |  |  |  | 21-656846- Actually do 8-5
PMMECH FGD 2 YEARS 8-2 Absorber Recirculation Pump Liner Inspection |  | B |  |  |  |  |  | 21-656864
7-2 ASH SLUICE PUMP, REPLACE WITH REBUILT PUMP | Outage | B |  |  |  |  |  | 21-436908
Free up 7-5CF Air register to allow beck drive to operate properly | outage | C |  |  |  |  |  | 21-430988
U8: IK-44, replace pinion roller bearing |  | C |  |  |  |  |  | 21-513866
U8 Demin Sump Pump #2 Install | WMAT | C | comp? |  |  | Start |  | 21-599062
8-3 AR Pump Gearbox Replacement | WMAT | C
Replace rail unloader valve | [NAME] | C |  |  |  |  |  | 21-514015
Troubleshoot and Repair issues with Landfill Eyewash Station | WMAT | C |  |  |  |  |  | 21-94002 Needs a new regulator
Tractor Garage Sump Pump | WMAT | C |  |  |  |  |  | 20-353406- Perform after electricians [NAME]
E-Crane pivot pins above bucket are worn - needs replaced | Hold | C |  |  |  |  |  | 19-525174- Hold until Controls are fixed.
Spreadsheet: 14ad2382-1d2d-45f9-8e88-03a2c6a012c0
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
 | 6202.0 Labour Force, Australia
 | Table 20. Aggregate monthly hours worked by State - Trend and Seasonally adjusted
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
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Trend | A3591553W | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Trend | A3591554X | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Trend | A3591555A | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Trend | A3591556C | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Trend | A3591557F | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Trend | A3591558J | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NORTHERN TERRITORY ; |  |  | Trend | A3591559K | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  AUSTRALIAN CAPITAL TERRITORY ; |  |  | Trend | A3591560V | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Seasonally Adjusted | A3591544V | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Seasonally Adjusted | A3591545W | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Seasonally Adjusted | A3591546X | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Seasonally Adjusted | A3591547A | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Seasonally Adjusted | A3591548C | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Seasonally Adjusted | A3591549F | 1978-07-01 00:00:00 | 2012-10-01 00:00:00 | 412 | 000 Hours | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 75893d1276510932-merging-several-tabs-attendance-template
Sheet: Sheet3

Management Attendance Sheet
 |  |  | May
Name |  | Contracted hours | 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
 |  | 38 | S | S | S | S | S | S | S | S | S | W | W | R | W | R | W | W | W | W | R | W | R | W | R | W | R | W | W | W | W | W | W
 |  | 38 | R | W | W | R | W | W | W | W | W | W | R | W | W | W | R | R | W | W | W | W | W | R | W | W | W | W | W | R | R | R | W
 |  | 38 | H | R | R | W | W | W | W | W | W | W | W | R | R | W | W | W | W | R | W | W | W | R | W | W | W | R | W | R | W | W | R
 |  | 38 | R | R | R | W | W | W | W | W | W | R | W | W | W | W | R | W | W | W | R | PRESTON
 |  | 38 | W | W | W | W | R | W | R | W | W | W | W | W | R | R | W | W | W | W | W | R | R | W | R | H | H | H | L | L | R | R | R
 |  | 38 | W | W | W | W | W | W | R | R | R | H | H | H | H | H | R | W | W | W | R | W | W | W | W | R | W | W | R | W | W | W | R
 |  |  | new starter |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | W | W | W | W | W | R | R | W | W | W | R | W | W | W | W
 |  | Worked | W
 |  | Rest Day | R |  |  |  |  |  |  |  | Date
 |  | Holiday | H |  |  |  |  |  |  |  | Manager [NAME]
 |  | Sickness | S
 |  | [NAME] | L |  | Ensure that you indicate on this form whether any compassionate leave is paid or unpaid
 |  | Maternity | M |  | Line managers should ensure that absence identified as paid or unpaid is in accordance
 |  | Paternity | P |  | with relevant company policy.
 |  | Jury service | J |  | Any deviation from company policy must only be with prior agreement of the HR Manager
 |  | Parental leave | PL
 |  | Training | T
Spreadsheet: 217870d1362236490-lookup-function-two-fixed-and-one-conditional-matches-three-condition-lookup-03022013
Sheet: Sheet1

Lookup function with three conditions.  Two are fixed and the third is variable and conditioned.
Step One:  TWO Cell Exact Match.  [NAME] formula in yellow highlighted cells in Table 1 seeking exact match of column A and B items to items within Table 2 column H and I.
Step Two: Conditional Lookup.  Then enter soonest time from column J exceeding or equalling the column C time but by not more than the time entered in cell M:16.
Enter Zero (0) if there is no match meeting these conditions.
NOTE:  The formula entered in the E column answers a different question.  It asks whether the matching number is the next higher number and enters 0 if it is not the next higher number, apparently ignoring the two cell exact match condition.  Example:  See cell E:22.  The desired answer number for E:22 is in D:22, entered manually.  However, the number in [NAME] is causing the formula answer to be ZERO, because the desired number is the second number greater than the c:22 number and even though the two matching conditions are not met.
Any way to do this without decending or ascending sort, or with standard non array formula?
Table 1 |  |  |  |  |  |  | Table 2 |  |  |  |  | Time Condition
Asset | Location | Time | Manual Result | [NAME] |  |  | Asset | Location | Time |  |  | 00:01:00
J | AA | 2013-02-15 14:29:00 | 00:00:00 |  |  |  | B | BB | 2013-02-15 10:32:53
I | CC | 2013-02-15 14:22:00 | 00:00:00 |  |  |  | B | BB | 2013-02-15 08:03:13
H | BB | 2013-02-15 08:45:00 | 00:00:00 |  |  |  | B | BB | 2013-02-15 08:00:52
F | CC | 2013-02-15 10:34:00 | 00:00:00 |  |  |  | C | CC | 2013-02-15 08:27:11
E | BB | 2013-02-15 10:28:00 | 00:00:00 |  |  |  | C | CC | 2013-02-15 08:11:10
D | AA | 2013-02-15 15:49:00 | 2013-02-15 15:49:02 |  |  |  | D | AA | 2013-02-15 15:49:02
C | CC | 2013-02-15 12:35:00 | 00:00:00 |  |  |  | D | AA | 2013-02-15 08:25:52
B | BB | 2013-02-15 10:32:00 | 2013-02-15 10:32:53 |  |  |  | F | CC | 2013-02-15 08:26:50
A | AA | 2013-02-15 09:02:00 | 00:00:00 |  |  |  | F | CC | 2013-02-15 08:06:45
 |  | 2013-02-15 08:32:00 | 00:00:00 |  |  |  | H | BB | 2013-02-15 09:02:45
F | CC | 2013-02-15 08:27:00 | 00:00:00 |  |  |  | H | BB | 2013-02-15 09:02:28
I | CC | 2013-02-15 10:32:00 | 00:00:00 |  |  |  | H | BB | 2013-02-15 08:41:42
F | BB | 2013-02-15 11:32:00 | 00:00:00 |  |  |  | H | BB | 2013-02-15 08:39:56
 |  | 2013-02-15 08:11:30 | 00:00:00 |  |  |  | J | AA | 2013-02-15 08:30:17
H | BB | 2013-02-15 09:02:26 | 2013-02-15 09:02:28 |  |  |  | J | AA | 2013-02-15 08:29:39
J | AA | 2013-02-15 08:29:39 | 2013-02-15 08:29:39 |  |  |  | J | AA | 2013-02-15 08:19:26
H | AA | 2013-02-15 08:29:39 | 00:00:00 |  |  |  |  |  | 2013-02-15 08:39:13
 |  |  |  |  |  |  |  |  | 2013-02-15 15:49:01
 |  |  |  |  |  |  |  |  | 2013-02-15 08:12:31
Spreadsheet: 887722d1738054684-merging-data-from-multiple-workbooks-sorting-alphabetically-creating-new-workbooks-workbook-example-2-to-merge
Sheet: P2 Phoneme

Rm | Surname | First Name | Say/Verbalise
 |  |  | s | a | t | i | p | n | m | d | g | o | c | k | ck | e | u | r | h | b | f | ff | l | ll | ss
2 | Circle | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Square | Immy | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Hexagon | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Rectangle | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Triangle | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Rhombus | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Star | April | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Octagon | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Decagon | Sonya | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Cube | Michelle | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2 | Cylinder | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1