tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138115d1327516776-excel-2007-multiple-if-statements-with-vlookup-copy-of-quote-template
Sheet: LABOR RATES

West |  | East |  | [NAME] |  | Houston |  | Houston C |  | [NAME] |  | Malaysia
Saw | 81.62 | Saw | 97.11 | Saw | 41 | Saw | 101 | Saw | 87 | Saw | 60 | Saw | 23
NCL-Sm | 96.34 | NCL-Sm | 97.11 | NCL-Sm | 57 | NCL-Sm | 101 | NCL-Sm | 87 | NCL-Sm | 60 | NCL-Sm | 73.02
NCL-Med | 112.28 | NCL-Med | 97.11 | NCL-Med | 63 | NCL-Med | 101 | NCL-Med | 87 | NCL-Med | 60 | NCL-Med | 73.02
NCL-Lg | 112.28 | NCL-Lg | 102.63 | NCL-Lg | 79 | NCL-Lg | 101 | NCL-Lg | 87 | NCL-Lg | 60 | NCL-Lg | 73.02
Weiler SM | 96.34 | Weiler SM | N/A | Weiler SM | 70 | Weiler SM | 101 | Weiler SM |  | Weiler SM | 60 | Weiler SM | N/A
Weiler LG | 96.34 | Weiler LG | N/A | Weiler LG | N/A | Weiler LG | N/A | Weiler LG |  | Weiler LG |  | Weiler LG | N/A
Manual Lathe | 81.62 | Manual Lathe | 97.11 | Manual Lathe | 64 | Manual Lathe | 101 | Manual Lathe | 87 | Manual Lathe | 60 | Manual Lathe | N/A
NCM-Sm | 96.34 | NCM-Sm | 97.11 | NCM-Sm | 69 | NCM-Sm | 101 | NCM-Sm | 87 | NCM-Sm | 60 | NCM-Sm | 73.02
NCM-Med | 96.34 | NCM-Med | 97.11 | NCM-Med | 67 | NCM-Med | 101 | NCM-Med | 87 | NCM-Med | 60 | NCM-Med | 73.02
NCM-Lg | 112.28 | NCM-Lg | 102.63 | NCM-Lg | 84 | NCM-Lg | 101 | NCM-Lg | 87 | NCM-Lg | 60 | NCM-Lg | N/A
NCM-FE_Cell | 98.69 | NCM-FE_Cell | 97.11 | NCM-FE_Cell | 73 | NCM-FE_Cell | N/A | NCM-FE_Cell | N/A | NCM-FE_Cell | 60 | NCM-FE_Cell | N/A
[NAME] | 81.62 | [NAME] | 97.11 | [NAME] | 64 | [NAME] | 101 | [NAME] | 87 | [NAME] | 60 | [NAME] | N/A
Gundrill | 96.34 | Gundrill | N/A | Gundrill | 72 | Gundrill | N/A | Gundrill | N/A | Gundrill | 60 | Gundrill | N/A
Hone | 81.62 | Hone | N/A | Hone | 61 | Hone | N/A | Hone | N/A | Hone | 60 | Hone | N/A
EDM | 81.62 | EDM | N/A | EDM | 76 | EDM | N/A | EDM | N/A | EDM | N/A | EDM | N/A
Grind | 81.62 | Grind | N/A | Grind | 57 | Grind | N/A | Grind | N/A | Grind | N/A | Grind | N/A
Straighten | 81.62 | Straighten | N/A | Straighten | 67 | Straighten | N/A | Straighten | N/A | Straighten | N/A | Straighten | N/A
Weld | 81.62 | Weld | 97.11 | Weld | 53 | Weld | N/A | Weld | N/A | Weld | N/A | Weld | N/A
Deburr | 65.25 | Deburr | 97.11 | Deburr | 37 | Deburr | 101 | Deburr | 87 | Deburr | N/A | Deburr | 20
Assembly 1 | 65.25 | Assembly 1 | 64.99 | Assembly 1 | N/A | Assembly 1 | N/A | Assembly 1 | N/A | Assembly 1 | N/A | Assembly 1 | 31.47
Assembly 2 | 65.25 | Assembly 2 | 75.83 | Assembly 2 | N/A | Assembly 2 | N/A | Assembly 2 | N/A | Assembly 2 | N/A | Assembly 2 | N/A
Inpsection | 96.34 | Inpsection | 75.83 | Inpsection | 50 | Inpsection | 101 | Inpsection | 87 | Inpsection | 60 | Inpsection | 29.4
Pkg/Ship | 65.25 | Pkg/Ship | 75.83 | Pkg/Ship | 67 | Pkg/Ship | 101 | Pkg/Ship | 87 | Pkg/Ship | 60 | Pkg/Ship | 29.4
Freight | 75.83 | Freight | 75.83 | Freight | 67 | Freight | 101 | Freight | 87 | Freight | 60 | Freight | 29.4
Tooling | 81.62 | Tooling | 75.83 | Tooling | 67 | Tooling | 101 | Tooling | 87 | Tooling | 60 | Tooling | 29.4
Misc | 81.62 | Misc | 75.83 | Misc | 67 | Misc | 101 | Misc | 87 | Misc | 60 | Misc | 29.4
Spreadsheet: 783722d1655107681-formula-linked-to-a-table-2022-06-11-oeldere-magalela-excel-forum-1-
Sheet: Sheet1

Reference | Code | Description |  |  |  |  | Reference | Code | Description |  |  |  |  | Reference | Code | Description |  | Result1 | Result2
C | 8520010 | Cash | t |  |  |  | C | 8520010 | Cash | h5 |  |  |  | C | 8520010 | Cash | T | 8520020 | Transfer
T | 8520020 | Transfer |  |  |  |  | T | 8520020 | Transfer |  |  |  |  | T | 8520020 | Transfer |  | OR
S | 8520030 | Speedpoint |  |  |  |  | S | 8520030 | Speedpoint |  |  |  |  | S | 8520030 | Speedpoint | C | 8520010 | Cash
CA | 9990000 | Cancelled |  |  |  |  | CA | 9990000 | Cancelled |  |  |  |  | CA | 9990000 | Cancelled
if A2 is selected on D2 then E2 = 8520010 and F2 = Cash |  |  |  |  |  |  | if H5 is selected on K2 then L2 = 9990000 and M2 = Cancelled
The result should always be on E2 and F2 |  |  |  |  |  |  | The result should always be on L2 and M2
Scenario 1 |  |  |  |  |  |  | Scenario 2
Spreadsheet: 748637d1632251562-populate-dynamic-calendar-with-tasks-based-on-task-frequency-rebecca_v2
Sheet: Sheet1

Year | 2025 |  | Frequency of Tasks |  |  |  |  |  |  |  |  |  |  | Date of First Monday
Date | Day | Week | Task 1 | Task 2 | Task 3 | Task 4 | Task 5 | Task 6 | Task 7 | Task 8 | Task 9 | Task 10
Spreadsheet: vladi_pimenov__41006__counterparties
Sheet: Sheet1

 | USUAL september counterparties |  |  |  | Counterparties  that gave up on us back in october
 | Adams Resources Marketing, Ltd. |  |  |  | Adams Resources Marketing, Ltd.
 | AEP Energy Services, Inc. |  |  |  | AEP Energy Services, Inc.
 | Amerada Hess Corporation
 | Aquila Energy Marketing Corporation |  |  |  | Aquila Energy Marketing Corporation
 | Aquila Risk Management Corporation |  |  |  | Aquila Risk Management Corporation
 | Ashland Specialty Chemicals Company
 | BP Energy Company |  |  |  | BP Energy Company
 | Calpine Energy Services, L.P.
 | Castle Power LLC |  |  |  | Castle Power LLC
 | Colonial Energy Inc. |  |  |  | Colonial Energy Inc.
 | Conectiv Energy Supply, Inc.
 | Consolidated Edison Energy, Inc. |  |  |  | Consolidated Edison Energy, Inc.
 | Constellation Power Source, Inc. |  |  |  | Constellation Power Source, Inc.
 | Cook Inlet Energy Supply L.L.C. |  |  |  | Cook Inlet Energy Supply L.L.C.
 | Coral Energy Holding L.P.
 | Coral Energy Resources, L.P. |  |  |  | Coral Energy Resources, L.P.
 | Duke Energy Trading and Marketing, L.L.C. |  |  |  | Duke Energy Trading and Marketing, L.L.C.
 | Dynegy Marketing and Trade |  |  |  | Dynegy Marketing and Trade
 | e prime, inc. |  |  |  | e prime, inc.
 | El Paso Merchant Energy, L.P. |  |  |  | El Paso Merchant Energy, L.P.
 | EnergyUSA - Appalachian Corp |  |  |  | EnergyUSA - Appalachian Corp
 | EnergyUSA-TPC Corp. |  |  |  | EnergyUSA-TPC Corp.
 | Entergy-Koch Trading, LP |  |  |  | Entergy-Koch Trading, LP
 | FirstEnergy Solutions Corp.
 | KeySpan Gas East Corporation |  |  |  | KeySpan Gas East Corporation
 | Mirant Americas Energy Marketing, L.P. |  |  |  | Mirant Americas Energy Marketing, L.P.
 | National Fuel Gas Distribution Corporation
 | New Jersey Natural Gas Company |  |  |  | New Jersey Natural Gas Company
 | NJR Energy Services Company |  |  |  | NJR Energy Services Company
 | NRG Power Marketing Inc. |  |  |  | NRG Power Marketing Inc.
 | NUI Energy Brokers, Inc. |  |  |  | NUI Energy Brokers, Inc.
 | OGE Energy Resources, Inc.
 | PanCanadian Energy Services Inc.
 | Pepco Gas Services, Inc. |  |  |  | Pepco Gas Services, Inc.
 | PG&E Energy Trading-Gas Corporation |  |  |  | PG&E Energy Trading-Gas Corporation
 | PSEG Energy Resources & Trade LLC
 | Reliant Energy Services, Inc. |  |  |  | Reliant Energy Services, Inc.
 | Sempra Energy Trading Corp. |  |  |  | Sempra Energy Trading Corp.
 | Sithe Power Marketing, L.P.
 | South Jersey Resources Group LLC
 | Sprague Energy Corp. |  |  |  | Sprague Energy Corp.
 | Texex Energy Partners Ltd. |  |  |  | Texex Energy Partners Ltd.
 | The Brooklyn Union Gas Company
 | Tractebel Energy Marketing, Inc.
 | TransCanada Gas Services Inc.
 | TXU Energy Trading Company |  |  |  | TXU Energy Trading Company
 | Virginia Power Energy Marketing, Inc. |  |  |  | Virginia Power Energy Marketing, Inc.
 | Western Gas Resources, Inc. |  |  |  | Western Gas Resources, Inc.
 | Williams Energy Marketing & Trading Company |  |  |  | Williams Energy Marketing & Trading Company
Spreadsheet: 837652d1690323074-count-functions-example
Sheet: Sheet1

Week | Day | Date | Staff | Staff | Staff | Staff | Staff |  | Notes
1 | Sat | 2023-04-01 00:00:00
 | Sun | 2023-04-02 00:00:00
 | Mon | 2023-04-03 00:00:00 |  | TTH T3 | TTH T3
 | Tue | 2023-04-04 00:00:00 |  | TTH T3 | TTH T3
 | Wed | 2023-04-05 00:00:00 |  | TTH T3 | TTH T3
 | Thu | 2023-04-06 00:00:00 |  | TTH T3 | TTH T3
 | Fri | 2023-04-07 00:00:00
2 | Sat | 2023-04-08 00:00:00 |  |  | F/S
 | Sun | 2023-04-09 00:00:00 |  | TQS NIGHT
 | Mon | 2023-04-10 00:00:00 |  | TQS
 | Tue | 2023-04-11 00:00:00 |  | TQS
 | Wed | 2023-04-12 00:00:00
 | Thu | 2023-04-13 00:00:00 |  |  | [NAME]
 | Fri | 2023-04-14 00:00:00 |  |  | [NAME]
3 | Sat | 2023-04-15 00:00:00 |  | TQS NIGHT
 | Sun | 2023-04-16 00:00:00 |  | TQS NIGHT
 | Mon | 2023-04-17 00:00:00 |  | TQS NIGHT | 7OAKS TNL DN
 | Tue | 2023-04-18 00:00:00 |  | TQS NIGHT | Sevenoaks Down
 | Wed | 2023-04-19 00:00:00 |  | 7OAKS TNL DN | 7OAKS TNL DN
 | Thu | 2023-04-20 00:00:00 |  | Rest - Double weekend | 7OAKS TNL DN
 | Fri | 2023-04-21 00:00:00
4 | Sat | 2023-04-22 00:00:00
 | Sun | 2023-04-23 00:00:00
 | Mon | 2023-04-24 00:00:00
 | Tue | 2023-04-25 00:00:00
 | Wed | 2023-04-26 00:00:00
 | Thu | 2023-04-27 00:00:00 |  | AL?
 | Fri | 2023-04-28 00:00:00
 |  |  | Weekends Worked | Weekends Worked | Weekends Worked | Weekends Worked | Weekends Worked
Spreadsheet: 1e06dc08-476e-47bc-a6d1-312c2a510b41
Sheet: Instructions EN

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | English
1
2
3
1
2
3
4
5
6
 |  | 1
 |  |  |  |  |  | N # | % |  |  |  |  | N # | % | N # | % | N # | %
 |  |  |  |  |  | D # |  |  |  |  |  | D # |  | D # |  | D #
 |  |  |  |  |  |  |  |  |  | above
Spreadsheet: kevin_ruscitti__20253__money
Sheet: Prices

 |  |  |  |  |  |  |  | Live Prices |  |  |  |  | Inj/(W/d)
 |  |  | Price | Basis | Index |  |  | PV Price | PV Basis | PV Index | PV FXF | 2000-08-01 00:00:00 | -500000
 |  |  |  |  |  |  | 2000-09-01 00:00:00 |  |  |  |  | 2000-09-01 00:00:00 | 505000
 |  |  |  |  |  |  |  |  |  |  |  | 2000-10-01 00:00:00 | 495000
 |  |  |  |  |  |  |  |  |  |  |  | 2000-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 2000-12-01 00:00:00 | -500000
 |  |  |  |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | -500000
 |  |  |  |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | 500000
 |  |  |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00
 |  |  |  |  |  |  |  | Settle Prices
 |  |  | Price | Basis | Index |  |  | PV Price | PV Basis | PV Index | PV FXF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g
Spreadsheet: 794950d1662430508-formula-to-search-value-across-multiple-sheets-example
Sheet: Session 2

Attended |  | Awaiting Arrival | Cancelled | No Show
Course: [Course Name] |  |  |  | Course Status: | Tentative
Date: | Monday 10th October |  | Time: [Time]
Department: [Department] |  |  | Facilitator: [Facilitator]
Location: [Location]
 | Name | Role | Leader | Notes
1 | [NAME]
2 | [NAME]
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Select hyperlink to return to schedule → |  | Schedule
Spreadsheet: 74547d1275036163-excel-2007-vlookup-more-than-one-match-vlookup
Sheet: Sheet1

0000109 | =VLOOKUP(A1;Sheet2!$A$1:$C$19;2;0) |  |  |  |  | 0000109 | =VLOOKUP(A1;Sheet2!$A$1:$C$19;2;0)
0000402 |  | =VLOOKUP(A1;Sheet2!$A$1:$C$19;3;0) |  |  |  | 0000402 | CAT1 | =VLOOKUP(A1;Sheet2!$A$1:$C$19;3;0)
0000486 |  |  |  |  |  | 0000486 | CAT1
0000534 |  |  | IT SHOULD BE LIKE THIS! |  |  | 0000534 | CAT1 |  | AND THIS IS WHAT I GET!
0000605 |  |  |  |  |  | 0000605 | CAT1
0000634 |  |  |  |  |  | 0000634 | CAT1
0000869 |  |  |  |  |  | 0000869 | CAT1
0000892 |  |  |  |  |  | 0000892 | CAT1
0000903 |  |  |  |  |  | 0000903 | CAT1
0000996 |  |  |  |  |  | 0000996 | CAT1
0001003 |  |  |  |  |  | 0001003 | CAT1
0010272 |  |  |  |  |  | 0010272 | CAT1
0010276 |  |  |  |  |  | 0010276 | CAT1
0010278 |  |  |  |  |  | 0010278 | CAT1
0010281 |  |  |  |  |  | 0010281 | CAT1
0010284 |  |  |  |  |  | 0010284 | CAT1
0010293 |  |  |  |  |  | 0010293 | CAT1
0010308 |  |  |  |  |  | 0010308 | CAT1
0010309 |  |  |  |  |  | 0010309 | CAT1
Spreadsheet: 455614d1460434757-holiday-formatting-example
Sheet: Hoja1

Frontier [NAME]
Supervisor | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month |  |  | April
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year |  |  | 2016
Customer service Rep |  | Enter: T = Tardy,  U = Unexcused,  E = Excused,  P = Present, CW = Critical Work, NCNS = No call No show, LE = Leave early, Off = Day off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals
ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T | U | E | P | CW | NCNS | LE | Off
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [42]
Spreadsheet: 879407d1726892583-how-to-vlook-up-one-cell-from-a-sheet-to-show-the-whole-row-on-another-sheet-need-help-version-1
Sheet: FINAL Attendance

 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME |  |  | OVERTIME |  |  | OVERTIME |  |  | OVERTIME |  |  | TOTAL OVERTIME | TOTAL HOURS | DAYS OF WORK
Biometrics | FIRST NAME | MIDDLE NAME | LAST NAME | FULL NAME | COMPANY | AREA | POSITION | For Test | For Test | For Test | For Test | For Test | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day | Time In | Time Out | Hours of work per day
 | [NAME] | Dayday | Aniel |  | Test | MAIN | Delivery
 | Jesmer | [NAME] | Arancana |  | Test | MAIN | Delivery
 | Angelita | Morales | Bago |  | Test | MAIN | Delivery
Spreadsheet: 795398d1662656284-amalgamating-and-deleting-rows-gk-special-assistance-final-example
Sheet: How It Should Look

Passenger Assist List |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-04 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Departure
Job | Assigned To | Name | HIP | VIP | W/C | BR W/C | Mob Imp | [NAME] | Time | Head Code | From | [NAME] | Time | Head Code | Destination | [NAME] | Additional Comments
1 |  | PAX A |  |  |  | Y | Y | Y | 07:44:00 | 1B18 | [NAME] |  | 07:53:00 | 1S35 | Edinburgh |  | Luggage
2 |  | PAX B |  | Y |  |  | Y |  | 08:52:00 | 1P38 | Crewe |  | 09:03:00 | 1S38 | Haymarket
4 |  | PAX C |  |  |  |  | Y |  |  |  |  |  | 09:09:00 | 1U93 | [NAME]
6 |  | PAX D | Y | Y |  |  | Y |  |  |  |  |  | 09:19:00 |  | Wolverhampton |  | Luggage
3 |  | PAX E |  | Y |  | Y | Y |  | 09:23:00 | 2N62 | [NAME] |  |  |  |  |  | Luggage
19 |  | PAX F |  |  | Y |  |  | Y |  |  |  |  | 09:52:00 |  | Edinburgh | D61 | Luggage
7 |  | PAX G | Y | Y | Y |  | Y | Y | 10:37:00 | 1M83 | Carlisle | E01, E03, E04 | 10:52:00 | 1N55 | [NAME] |  | Luggage
28 |  | PAX H |  | Y |  |  |  |  |  |  |  |  | 10:41:00 |  | Glasgow Central |  | Luggage
8 |  | PAX I |  |  |  |  | Y | Y | 10:50:00 | 2S55 | St Annes-on-the-Sea |  | 11:29:00 | 1F03 | Liverpool Lime Street |  | Luggage
9 |  | PAX J |  | Y |  |  |  |  | 10:50:00 | 1N55 | [NAME]
10 |  | PAX K |  |  | Y |  |  | Y | 10:53:00 | 2H06 | [NAME] |  | 11:04:00 | 1S46 | Haymarket |  | Luggage
32 |  | PAX L |  | Y |  |  | Y |  |  |  |  |  | 10:59:00 | 1M08 | [NAME]
29 |  | PAX M |  |  |  |  | Y |  |  |  |  |  | 10:59:00 |  | [NAME] |  | Luggage
30 |  | PAX N |  |  |  | Y | Y |  |  |  |  |  | 10:59:00 |  | [NAME] |  | Luggage
31 |  | PAX O |  |  |  |  | Y |  |  |  |  |  | 10:59:00 |  | [NAME]
25 |  | PAX P |  |  |  |  | Y |  |  |  |  |  | 11:17:00 |  | Wolverhampton |  | Luggage
18 |  | PAX Q |  |  |  |  | Y |  |  |  |  |  | 11:17:00 |  | Crewe |  | Luggage
12 |  | PAX R |  |  |  |  | Y |  | 11:27:00 | 1F03 | Poulton-le-Fylde |  | 11:44:00 | 1C53 | Barrow-in-Furness
21 |  | PAX S |  |  | Y |  | Y | Y |  |  |  |  | 11:29:00 | 1F03 | Liverpool Lime Street |  | Luggage
14 |  | PAX T | Y |  | Y |  |  | Y | 11:38:00 |  | [NAME] |  | 12:00:00 | 1N56 | [NAME]
36 |  | PAX U |  |  |  | Y |  |  |  |  |  |  | 11:41:00 |  | Glasgow Central |  | Luggage
15 |  | PAX V |  |  |  |  | Y | Y | 11:44:00 | 1B26 | [NAME] |  | 11:59:00 |  | Warrington Bank Quay |  | Luggage
16 |  | PAX W |  |  |  | Y | Y |  | 11:47:00 | 1M94 | Lancaster |  | 12:18:00 |  | Crewe |  | Luggage
17 |  | PAX X |  |  |  |  | Y | Y | 11:56:00 | 1M09 | Glasgow Central |  | 12:18:00 | 9M52 | Wolverhampton |  | Luggage
37 |  | PAX Y |  |  | Y |  |  | Y |  |  |  |  | 11:59:00 | 1M09 | [NAME] | D58, D61
24 |  | PAX Z | Y | Y |  |  | Y | Y | 12:28:00 | 1N85 | Liverpool Lime Street |  | 12:45:00 | 1C71 | Kendal |  | Luggage
Spreadsheet: 217743d1362166453-need-help-on-index-match-function-attendance
Sheet: Absent

 | Code | Name | Date
 | 1 | A | 2013-02-28 00:00:00
 |  | B | 2013-02-28 00:00:00
 |  | C | 2013-02-28 00:00:00
 |  | D | 2013-02-28 00:00:00
 |  | E | 2013-02-28 00:00:00
 |  | F | 2013-02-28 00:00:00
 |  | G | 2013-02-28 00:00:00
 |  | H | 2013-02-28 00:00:00
 |  | I | 2013-02-28 00:00:00
 |  | J | 2013-02-28 00:00:00
 |  | K | 2013-02-28 00:00:00
 |  | L | 2013-02-28 00:00:00
 |  | M | 2013-02-28 00:00:00
 |  | N | 2013-02-28 00:00:00
 |  | O | 2013-02-28 00:00:00
 |  | P | 2013-02-28 00:00:00
 |  | Q | 2013-02-28 00:00:00
 |  | R | 2013-02-28 00:00:00
 |  | S | 2013-02-28 00:00:00
 |  | T | 2013-02-28 00:00:00
 |  | U | 2013-02-28 00:00:00
 |  | V | 2013-02-28 00:00:00
 |  | W | 2013-02-28 00:00:00
 |  | Q | 2013-02-28 00:00:00
 |  | Y | 2013-02-28 00:00:00
 |  | Z | 2013-02-28 00:00:00
 | 1 | A | 2013-02-27 00:00:00
Spreadsheet: 13a7bccb-52f6-440d-8cdc-d9c9c84d4252
Sheet: Sheet1

Burglary | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 37.33865322117721 | 64.92397760878418 | 8.411059310804854
13-14 | 535.9027300604365 | 927.1901171480159 | 124.9708285737811
15 | 785.8908823229548 | 1391.470951459091 | 147.7272124583557
16 | 839.0845430054361 | 1497.801592733185 | 140.5943991717187
17 | 813.312475162954 | 1453.136019634288 | 132.1503250690606
18 | 795.8251145691931 | 1448.404140428962 | 109.707204220644
19 | 599.746283195755 | 1090.5630866518 | 87.91881265576491
20 | 460.4831331629662 | 827.3639381026236 | 77.5226371903423
21 | 402.5767551101163 | 720.5725250262605 | 70.68821240299432
22 | 353.5820354396182 | 630.7226139260036 | 66.84631658768949
23 | 332.8987513696119 | 587.6434380276814 | 70.32849946944296
24 | 306.1455909313555 | 538.1893137226566 | 67.97094583357892
25-29 | 271.2872681108911 | 481.9882107634861 | 59.0268687396174
30-34 | 208.1210257379993 | 370.5865169796122 | 46.54931129842792
35-39 | 139.558508689857 | 248.7302800420916 | 31.58976916956199
40-44 | 74.87144270264248 | 134.450152813011 | 16.70927527059466
45-49 | 37.39924229183939 | 67.4160928499999 | 8.463700641656654
50-54 | 18.93987528110605 | 34.08248385896338 | 4.612173652679439
55-59 | 9.739340840060924 | 17.74171484305057 | 2.366238571147256
60-64 | 4.548408613834848 | 8.309535881573124 | 1.221378284058918
65 and over | 1.803384595026351 | 4.021823932526596 | 0.2909094755659504
Spreadsheet: 823754d1680123664-copy-if-not-isblank-formula-in-multiple-cells-of-spreadsheet-at-one-time-matrix-excel-help-
Sheet: Hiring Matrix

Hiring Matrix
 | [NAME] Policy datA21 OA21 states when interviews are conducted, [NAME] mandates that the total point value for interviews is 200 points. Interview questions will be released 30 minutes prior to candidates scheduled interview date and time. Additionally, hiring panels will offer opportunity for feedback to candidates interviewed.
Resume Scores |  |  | 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
1 | Relevant Experience |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCORES
2 | Diversity of Experience
3 | Education
4 | Certification
5 | PME
6 | Supervisory/Lead Experience (Only applies to Supervisor Positions)
Resume Total Score (Max 100 Points for Non-Supervisory and 115 for Supervisory)
Interview Scores
 | Competency | Question
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCORES
2
3
4
Interview Final Consensus Score (Max 200 Points)
Total Applicant Score
Spreadsheet: 68a0a023-5408-4227-a4f2-557665b59512
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (2 [NAME]):
 | 7 Biotechnologie 7.3 Elektrophorese 7.3.10 Elektrophorese-Netzgeräte
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | Biometra GmbH | Deutschland | Göttingen | 37079 | A1.211/310
2 | SERVA Electrophoresis GmbH | Deutschland | Heidelberg | 69115 | A3.360
Spreadsheet: 108936d1305848830-plotting-reliability-charts-relibility-chart-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Log(1 - Reliability)
 | x | y | labels |  | Equip | Run1 | Run2 | Run3 | Run1 | Run2 | Run3
 | 0 | 0 |  |  | Equip1 | 0.934854 | 0.945433 | 0.939843
 | 0 | -1 |  |  | Equip2 | 0.999942 | 0.999989 | 0.999953
 | 0 | -2 |  |  | Equip3 | 0.999439 | 0.999753 | 0.999488
 | 0 | -3 |  |  | Equip4 | 0.999993 | 0.999994 | 0.999994
 | 0 | -4 |  |  | Equip5 | 0.999985 | 0.999982 | 0.999993
 | 0 | -5
 | 0 | -6
 |  |  |  |  |  |  |  |  |  |  |  | 1 | Create the column chart
 |  |  |  |  |  |  |  |  |  |  |  | 2 | Format the y axis for Values in reverse order
 |  |  |  |  |  |  |  |  |  |  |  | 3 | Add the x-y data as a new series
 |  |  |  |  |  |  |  |  |  |  |  | 4 | Change the chart type for the new series to xy scatter
 |  |  |  |  |  |  |  |  |  |  |  | 5 | Format the y axis:    Change scale to min = -6, [NAME] = 0    Change the number format to ;;;
 |  |  |  |  |  |  |  |  |  |  |  | 6 | Add data labels for the new series: Y value
 |  |  |  |  |  |  |  |  |  |  |  | 7 | Select each data label and add a formula to point to the label value
 |  |  |  |  |  |  |  |  |  |  |  | 8 | Right-click the data labels, select Format Data Labels, Alignment, Label Position, Left
 |  |  |  |  |  |  |  |  |  |  |  | 9 | Format the series to have no line and no marker (not done at left)
 |  |  |  |  |  |  |  |  | 1 - Reliability
 |  |  |  |  | Equip | Run1 | Run2 | Run3 | Run1 | Run2 | Run3
 |  |  |  |  | Equip1 | 0.934854 | 0.945433 | 0.939843
 |  |  |  |  | Equip2 | 0.999942 | 0.999989 | 0.999953
 |  |  |  |  | Equip3 | 0.999439 | 0.999753 | 0.999488
 |  |  |  |  | Equip4 | 0.999993 | 0.999994 | 0.999994
 |  |  |  |  | Equip5 | 0.999985 | 0.999982 | 0.999993
Spreadsheet: darrell_schoolcraft__7796__imbalsumm0107
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12299 | 10388 | -556
2 | 11706 | 10732 | -472
3 | 11910 | 10841 | -486
4 | 10885 | 10906 | -523
5 | 11935 | 10912 | -570
6 | 11321 | 10866 | -565
7 | 10936 | 10786 | -410
8 | 10657 | 10786
9 | 17477 | 10786
10 | 12031 | 10913 | -2
11 | 11355 | 10913
12 | 10931 | 10912
13 | 11220 | 10903
14 | 11376 | 10730
15 | 11218 | 10362
16 | 11351 | 10741
17 | 11364 | 10719
18 | 11172 | 10692 | -45
19 | 12613 | 10726
20 | 12175 | 10684
21 | 11773 | 10655
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  | 542879.87
2001-07-21 00:00:00
Spreadsheet: 172520d1344247644-how-to-automatically-draw-a-graph-with-wanted-time-periods-excel-example
Sheet: Sheet1

 | 34232 | 234234 | 77767 | 9087 | 76443 | 8888 | 1111 | 6666 | 6666 | 5555 | 6666 | 45452
 | If Im interested in P2/10 - P9/10 I want the graph to look like this: