tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 274676d1383179280-help-with-formula-for-sport-fixtures-badsa-fixtures
Sheet: 10 team

Round | Match | Home | Away |  | Diamond | Time |  |  | TEAM NAMES
1 | 1 | 2 | 1 |  |  |  |  | 1
1 | 2 | 3 | 9 |  |  |  |  | 2
1 | 3 | 4 | 8 |  |  |  |  | 3
1 | 4 | 5 | 7 |  |  |  |  | 4
1 | 5 | 6 | 10 |  |  |  |  | 5
2 | 1 | 7 | 6 |  |  |  |  | 6
2 | 2 | 1 | 3 |  |  |  |  | 7
2 | 3 | 10 | 2 |  |  |  |  | 8
2 | 4 | 9 | 4 |  |  |  |  | 9
2 | 5 | 8 | 5 |  |  |  |  | 10
3 | 1 | 6 | 8
3 | 2 | 7 | 10
3 | 3 | 4 | 1
3 | 4 | 3 | 2
3 | 5 | 5 | 9
4 | 1 | 10 | 3
4 | 2 | 9 | 6
4 | 3 | 8 | 7
4 | 4 | 1 | 5
4 | 5 | 2 | 4
5 | 1 | 5 | 2
5 | 2 | 4 | 3
5 | 3 | 7 | 9
5 | 4 | 8 | 10
5 | 5 | 6 | 1
6 | 1 | 9 | 8
6 | 2 | 1 | 7
6 | 3 | 2 | 6
6 | 4 | 3 | 5
6 | 5 | 10 | 4
7 | 1 | 5 | 4
7 | 2 | 9 | 10
7 | 3 | 8 | 1
7 | 4 | 7 | 2
7 | 5 | 6 | 3
8 | 1 | 3 | 7
8 | 2 | 4 | 6
8 | 3 | 10 | 5
8 | 4 | 1 | 9
8 | 5 | 2 | 8
9 | 1 | 9 | 2
9 | 2 | 8 | 3
9 | 3 | 7 | 4
9 | 4 | 6 | 5
9 | 5 | 10 | 1
10 | 1 | 1 | 2
10 | 2 | 9 | 3
10 | 3 | 8 | 4
10 | 4 | 7 | 5
10 | 5 | 10 | 6
11 | 1 | 6 | 7
11 | 2 | 3 | 1
11 | 3 | 2 | 10
11 | 4 | 4 | 9
11 | 5 | 5 | 8
12 | 1 | 8 | 6
12 | 2 | 10 | 7
12 | 3 | 1 | 4
12 | 4 | 2 | 3
12 | 5 | 9 | 5
13 | 1 | 3 | 10
13 | 2 | 6 | 9
13 | 3 | 7 | 8
13 | 4 | 5 | 1
13 | 5 | 4 | 2
14 | 1 | 2 | 5
14 | 2 | 3 | 4
14 | 3 | 9 | 7
14 | 4 | 10 | 8
14 | 5 | 1 | 6
15 | 1 | 8 | 9
15 | 2 | 7 | 1
15 | 3 | 6 | 2
15 | 4 | 5 | 3
15 | 5 | 4 | 10
16 | 1 | 4 | 5
16 | 2 | 10 | 9
16 | 3 | 1 | 8
16 | 4 | 2 | 7
16 | 5 | 3 | 6
17 | 1 | 7 | 3
17 | 2 | 6 | 4
17 | 3 | 5 | 10
17 | 4 | 9 | 1
17 | 5 | 8 | 2
18 | 1 | 2 | 9
18 | 2 | 3 | 8
18 | 3 | 4 | 7
18 | 4 | 5 | 6
18 | 5 | 1 | 10
19 | 1 | 2 | 1
19 | 2 | 3 | 9
19 | 3 | 4 | 8
19 | 4 | 5 | 7
19 | 5 | 6 | 10
20 | 1 | 7 | 6
20 | 2 | 1 | 3
20 | 3 | 10 | 2
20 | 4 | 9 | 4
20 | 5 | 8 | 5
21 | 1 | 6 | 8
21 | 2 | 7 | 10
21 | 3 | 4 | 1
21 | 4 | 3 | 2
21 | 5 | 5 | 9
22 | 1 | 10 | 3
22 | 2 | 9 | 6
22 | 3 | 8 | 7
22 | 4 | 1 | 5
22 | 5 | 2 | 4
23 | 1 | 5 | 2
23 | 2 | 4 | 3
23 | 3 | 7 | 9
23 | 4 | 8 | 10
23 | 5 | 6 | 1
24 | 1 | 9 | 8
24 | 2 | 1 | 7
24 | 3 | 2 | 6
24 | 4 | 3 | 5
24 | 5 | 10 | 4
25 | 1 | 5 | 4
25 | 2 | 9 | 10
25 | 3 | 8 | 1
25 | 4 | 7 | 2
25 | 5 | 6 | 3
26 | 1 | 3 | 7
26 | 2 | 4 | 6
26 | 3 | 10 | 5
26 | 4 | 1 | 9
26 | 5 | 2 | 8
27 | 1 | 9 | 2
27 | 2 | 8 | 3
27 | 3 | 7 | 4
27 | 4 | 6 | 5
27 | 5 | 10 | 1
Spreadsheet: 147037d1332494384-vlookup-but-using-2-conditions-sample-workbook-1-
Sheet: Sample Sheet

[NAME] | Value
Castings Per Mould | 2
Moulds Per Hour | 274
Pouring Time | 8.5
Gross Casting Weight | 29.16 |  |  |  | AM Number
Cup Level | 1 |  |  |  | AM001A
[NAME] | Value
Castings Per Mould | 1
Moulds Per Hour | 360
Pouring Time | 8
Gross Casting Weight | 16.18
Cup Level | 1
[NAME] | Value
Castings Per Mould | #N/A
Moulds Per Hour | #N/A
Pouring Time | #N/A
Gross Casting Weight | #N/A
Cup Level | #N/A
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Business Certificates 8

BUSINESS
Certificates
Student Name:
ID #
Supervisory Management | Semester | Grade
Required
___ CIT 105 (3) Introductin to Computers
___ OST 235 (3) Business Communications Technology
___ [NAME] (3) Introduction to Business
___ [NAME] (3) Supervisory Management
___ [NAME] (3) Human Resource Management
Choose 6 hours from the following Technical Courses.  Students may select other courses as approved by the
Business Administration Systems Program Coordinator.
___ [NAME] (3) Principles of Management
___ [NAME] (3) Personal and Organizational Leadership
___ [NAME] (3) Management, Ethics & Society
___ OST 275 (3) Office Management
___ QMS 101 (3) Introduction to Quality Systems
Team Leadership
Required
___ OST 105 (3) Introduction to Information Systems
OR ___ CIT 105 (3) Introduction to Computers
___ OST 235 (3) Business Communications Technology
OR ___ COM 181 (3) Basic Public Speaking
OR ___ COM 252 (3) Introduction to Interpersonal Communication
___ [NAME] (3) Supervisory Management
___ [NAME] (3) Personal & Organizational Leadership
___ QMS 101 (3) Introduction to Quality Management
Choose 3 hours from the following Technical Courses.  Students may select other courses as approved by the
Business Administration Systems Program Coordinator.
___ QMS 202 (3) Performance Management
___ [NAME] (3) Introduction to Business
___ [NAME] (3) Human Resource Management
___ [NAME] (3) Management, Ethics & Society
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 876684d1723406681-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.11.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-11 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 6 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 23 | 1 | 5 | 0 | 2 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 23 | 0 | 4 | 0 | 2 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 20 | 0 | 6 | 1 | 0 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 1 | 1 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 5 | 1 | 0 | 0 | 0 | 2 | 0 | ABC
 | Total Holds MID |  |  | 0 | 0 | 6 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-11 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 2 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 20 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 19 | 0 | 4 | 0 | 3 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 17 | 0 | 5 | 1 | 2 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 4 | 0 | 2 | 0 | 0 | 0 | 0
 | Total MED
 | JKL | 26 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 3 | 0 | 3 | 1 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 3 | 0 | 4 | 2 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 865971d1712911360-help-with-forecasting-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Data set
Month | Project Name | Month number | Date | Costs Month | Cost 3 months rolling |  |  |  |  | Costs | Mapping | Project Definition.Project Definition Level 01 | Month
January | project Y | 1 | 2024-01-01 00:00:00 |  |  |  |  |  |  | 24112 | Cash Out (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
February | project Y | 2 | 2024-02-01 00:00:00 |  |  |  |  |  |  | 2994 | Cash Out (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
March | project Y | 3 | 2024-03-01 00:00:00 |  |  | <-- Expect 0 |  |  |  | 2086 | Cash Out (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
April | project Y | 4 | 2024-04-01 00:00:00 |  |  |  |  |  |  | 3 | Cost Of Hours Other (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
May | project Y | 5 | 2024-05-01 00:00:00 |  |  |  |  |  |  | 51369 | Cash Out (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
June | project Y | 6 | 2024-06-01 00:00:00 |  |  |  |  |  |  | -149 | Cash Out (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
July | project Y | 7 | 2024-07-01 00:00:00 |  |  |  |  |  |  | 61569 | Cash Out (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
August | project Y | 8 | 2024-08-01 00:00:00 |  |  |  |  |  |  | 3730 | Cash Out (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
September | project Y | 9 | 2024-09-01 00:00:00 |  |  |  |  |  |  | 52 | Cash Out (Paid by [NAME]) | project Y | 2024-02-01 00:00:00
October | project Y | 10 | 2024-10-01 00:00:00 |  |  |  |  |  |  | -51369 | Cash Out (Paid by [NAME]) | project Y | 2024-02-01 00:00:00
November | project Y | 11 | 2024-11-01 00:00:00 |  |  |  |  |  |  | 20250 | Cost Of Hours Group Technology & Innovation (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
December | project Y | 12 | 2024-12-01 00:00:00 |  |  |  |  |  |  | 7125 | Cost Of Hours Group Technology & Innovation (Paid by [NAME]) | project Y | 2024-01-01 00:00:00
Spreadsheet: 695247d1600107462-autogenerate-dynamic-lists-using-multiple-criteria-example-sheet
Sheet: Sheet1

S no. | Office | Staff | Functions | Sub-functions | Time (Hrs) | [NAME] | [NAME] | [NAME] | [NAME] |  | Problem 1: | Similar to the output in Green - Autogenerate the unique office list from (Column B and D) from  the Main table. Then on the basis of generated list,  I am looking for all the unique Staff names (from Column C if possible or else from Column G2:J2)  required in the correspoding office IN A SINGLE CELL
1 | Dallas | Jeo, Perry | HR | Recruitment | 1 | [NAME] | [NAME] |  |  |  |  | List of unique "Office-Function" (Column B and C) and Staff needed in these locations
2 | Dallas | Jeo, [NAME] | Finance | AR | 2 | [NAME] |  | [NAME] |  |  |  | Office-Function | Staff required
3 | London | [NAME] | HR | L&D | 1 |  |  |  | [NAME] |  | Example | Dallas-HR | [NAME], [NAME], [NAME]
4 | Dallas | [NAME], [NAME] | Sales | Sales force | 3 |  |  |  |  |  |  | Dallas-Finance | [NAME], [NAME]
5 | London | Jeo, [NAME] | Finance | AP | 4 | [NAME] |  | [NAME]
6 | Dallas | [NAME],  [NAME] | HR | Salaries | 1 |  | [NAME] | [NAME]
7 | London | [NAME] | Sales | Budegeting | 3 |  |  | [NAME]
8 | London | Jeo, [NAME], [NAME], [NAME] | HR | Rewards | 3 | [NAME] |  | [NAME] | [NAME]
9 | Dallas | Jeo, Perry | Marketing | Channel Management | 1 | [NAME] | [NAME] |  |  |  | Problem 2: | Similar to the output in green - Auto generate a List of Functions (column D) and sub functions for each staff member ([NAME] ([NAME]) , [NAME] (O13), [NAME] (Q13), and [NAME]) based in Dallas (A22) office.
10 | Dallas | Jeo, Perry | HR | [NAME] | 2 | [NAME] | [NAME] |  |  |  |  | [NAME] | Time | [NAME] | Time | [NAME] | Time | [NAME] | Time
 |  |  |  |  |  |  |  |  |  |  | Dallas | HR | 4
 |  |  |  |  |  |  |  |  |  |  |  | Recruitment | 1
 |  |  |  |  |  |  |  |  |  |  |  | Salaries | 1
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2
 |  |  |  | - |  |  |  |  |  |  |  | Finance | 6
 |  |  |  | - |  |  |  |  |  |  |  | AR | 2
 | - |  |  | - |  |  |  |  |  |  |  | AP | 4
 | - |  |  | - |  |  |  |  |  |  |  | Marketing | 1
 | - |  |  | - |  |  |  |  |  |  |  | Channel Management | 1
Spreadsheet: 782181d1653885557-aged-debtor-report-formatting-question-aged-debtor-formatting
Sheet: Aim

Aged Debtor Report
 | Debtor | Invoice No | Date | Total | Period 1 | Period 2 | Period 3
Spreadsheet: a7663a90-42e3-4ddf-8a8b-814547e8b914
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (4 Entries):
 | 6 Test and measurement 6.7 Optical and acoustical parameters 6.7.11 Sound level meters
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Brüel & Kjaer GmbH | Germany | Bremen | 28359 | A1.467
2 | CHAUVIN ARNOUX GmbH | Germany | [NAME] / Rhein | 77694 | A1.132
3 | Lutron Electronic Enterprise Co., Ltd. | Taiwan | Taipei | 103 | A1.159/3
4 | SINUS Messtechnik GmbH | Germany | Leipzig | 04347 | A1.665
Spreadsheet: 27800d1221470262-holdings-checking-checking-holdings-1-
Sheet: Weekly Summary-copy

INPUT 2
Weekly summary date range
2008-08-25 00:00:00 | 2008-08-31 00:00:00
INPUT 1 |  |  |  | OUTPUT | INPUT 3
Security code | Quoted ex date | Record Date | Payable Date | Yes/No | Date of Holdings
QQCAAA | 2008-08-26 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No | 2008-06-15 00:00:00
QQZBBB | 2008-08-27 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No | 2008-06-23 00:00:00
QQHCCC | 30/09/2008 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No | 2008-06-30 00:00:00
[NAME] | 2008-07-29 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No | 2008-07-07 00:00:00
QQREEE | 2008-07-07 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 | No | 2008-07-14 00:00:00
QQSFFF | 2007-06-24 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 | No | 2008-07-28 00:00:00
QQTGGG | 2008-07-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 | No | 2008-08-04 00:00:00
QQXHHH | 2008-08-11 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 | No | 2008-08-11 00:00:00
QQZPBIII | 2008-08-19 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No | 2008-08-18 00:00:00
QBBJJJ | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No | 2008-08-25 00:00:00
QBCKKK | 2008-07-29 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No | 2008-09-01 00:00:00
QBILLL | 2008-07-07 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QBJMMM | 2008-06-24 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 | No
[NAME] | 2008-07-01 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 | No
QBQOOO | 2007-08-11 00:00:00 | 2008-08-31 00:00:00 | 2008-09-05 00:00:00 | No
QBQOPPP | 2008-08-19 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QBQQQQ | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QBSSMWRRR | 2008-07-29 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QBUSSSS | 2008-07-07 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QBVTTTTTT | 2008-06-24 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00 | No
QBWUUUU | 2008-07-01 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00 | No
QBYVVVVVV | 2008-08-11 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QCBWWWWW | 2008-08-19 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QCKXXXXX | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QCQYYYYYY | 2008-08-19 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | No
QCRZZZZZ | 2008-08-25 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00 | No
Spreadsheet: 118633d1313810146-shorten-formula-to-avoid-maxing-of-cpu-master-budget-twitt-adjustments-ttrial
Sheet: Project Finance

 |  |  | Project Finance
 |  |  | Cash on hand (Including invoices paid by start date) |  |  |  | Asset | 4500
 |  |  | Cash Loan (savings) |  |  |  | Liabillity | 5000
 |  |  | Credit card  - Personal |  |  |  | Liabillity | 8000
 |  |  | Credit card  - Middleton |  |  |  | Liabillity | 25000
 |  |  |  |  | Completion of job account balance
 |  |  | minus liabillities of |  |  | Project end account balcnce
Spreadsheet: john_griffith__16088__1_17_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | 51 | 335 | 435 | 47.4 | 61.6 | 1.75 | 2002-01-17 13:39:00
 | [NAME] | 51 | 680 | 780 | 51.4 | 58.9 | 1.77 | 2002-01-17 13:39:00
 | HO J2 | 52 | 880 | 980 | 49.9 | 55.6 | 1.72 | 2002-01-17 13:39:00
 | HO K2 | 52 | 990 | 1090 | 46.6 | 51.4 | 1.6 | 2002-01-17 13:39:00
 | HO M2 | 53 | 1085 | 1185 | 43.6 | 47.6 | 1.52 | 2002-01-17 13:39:00
 | HO N2 | 53 | 1160 | 1260 | 42.4 | 46.1 | 1.47 | 2002-01-17 13:39:00
 | HO Q2 | 54 | 1230 | 1330 | 40.6 | 43.9 | 1.43 | 2002-01-17 13:39:00
 | HO U2 | 55 | 1300 | 1400 | 39.1 | 42.2 | 1.41 | 2002-01-17 13:39:00
 | [NAME] | 56 | 1300 | 1400 | 36.2 | 39 | 1.32 | 2002-01-17 13:39:00
 | HO X2 | 57 | 1375 | 1500 | 35.6 | 38.9 | 1.33 | 2002-01-17 13:39:00
 | [NAME] | 57 | 1400 | 1550 | 34.7 | 38.5 | 1.31 | 2002-01-17 13:39:00
 | HO F3 | 58 | 1400 | 1600 | 32.7 | 37.5 | 1.28 | 2002-01-17 13:39:00
 | [NAME] |  |  |  | 33.2 | 36.5 | 1.31 | 2001-12-31 13:18:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 160958d1339339839-get-past-two-similar-names-in-a-vlookup-test
Sheet: Roster Builder

 |  |  |  |  | Time Builder
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter 1 if public Holiday ==>
 |  |  |  |  | Time Code | Times | Start |  |  | End |  |  | Shift Start | Shift End | HRS |  |  | NAMES | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY
 |  |  |  |  |  |  | HR | Minute | AM/PM | HR | Minute | AM/PM |  |  |  |  |  | Managers | Name | Time Slot Code | Shift | Name | Time Slot Code | Shift | Name | Time Slot Code | Shift | Name | Time Slot Code | Shift | Name | Time Slot Code | Shift | Name | Time Slot Code | Shift | Name | Time Slot Code | Shift
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | a | 1 | 8:0 AM - 4:30 PM | b | 1 | 8:0 AM - 4:30 PM | c | 1 | 8:0 AM - 4:30 PM | b | 1 | 8:0 AM - 4:30 PM | b | 1 | 8:0 AM - 4:30 PM | a | 1 | 8:0 AM - 4:30 PM | b | 1 | 8:0 AM - 4:30 PM
 |  |  |  |  | 1 | 8:0 AM - 4:30 PM | 8 | 0 | AM | 4 | 30 | PM | 08:00:00 | 16:30:00 | 8.5 |  |  | 2
 | Employees | Position |  |  | 2 | 3:30 PM - 10:0 PM | 3 | 30 | PM | 10 | 0 | PM | 15:30:00 | 22:00:00 | 6.499999999999998 |  |  | 3
1 | a |  |  |  | 3 | 12:0 AM - 12:0 PM | 12 | 0 | AM | 12 | 0 | PM | 1900-01-01 00:00:00 | 12:00:00 | 12 |  |  | 4
2 | b |  |  |  | 4 | 8:0 am - 8:0 pm | 8 | 0 | am | 8 | 0 | pm | 08:00:00 | 20:00:00 | 12 |  |  | 5
3 | c |  |  |  | 5 | :  - : |  |  |  |  |  |  |  |  |  |  |  | 6
4 |  |  |  |  | 6 | :  - :
5 |  |  |  |  | 7 | :  - : |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE
6 |  |  |  |  | 8 | :  - :
7 |  |  |  |  | 9 | :  - :
8 |  |  |  |  | 10 | :  - :
9 |  |  |  |  | 11 | :  - :
10 |  |  |  |  | 12 | :  - :
11 |  |  |  |  | 13 | :  - :
12 |  |  |  |  | 14 | :  - :
13 |  |  |  |  | 15 | :  - : |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE
40
41
42
43
44
45
46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE
47
48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE |  |  | EMPLOYEE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
AM | 1 | 0
PM | 2 | 30
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
Spreadsheet: 806591d1669400654-match-partial-or-complete-text-and-match-in-another-column-to-extract-index-value-help-4-ans
Sheet: INDEX-MATCH1

 |  |  | need to match partial title and chn and bring value from index column
 | Employee |  |  | expected answer | =INDEX(F$7:F$11,MATCH(TRUE,ISNUMBER(SEARCH(B$6:[NAME]))
 | title | chn | index value |  | current formula I have | lookup data
 | [NAME] |  |  | Kaisi |  | index value | chn
 | Siyan |  |  | siyani |  | Kaisi | AAA
 | Farq E |  |  | farq |  | siyani | GGG
 | Ep Habs |  |  | habs |  | farq | AAA
 | magar |  |  |  |  | habs | AAA
 | [NAME] |  |  | agar |  | agar | GGG
 | [NAME] |  |  | Kaisi |  | kais | GGG
 | kais |  |  | kais
Spreadsheet: drew_fossum__8690__Gallup Modification Exh N
Sheet: INCREMENTAL TAXES

 |  |  |  |  |  |  |  |  |  |  |  | Page  4 of 7
Transwestern Pipeline Company
Estimated   Incremental   Taxes   Other
Line
No. |  | Description |  | Year   1 |  | Year  2 |  | Year  3 |  | Year  4 |  | Year  5
 |  |  |  | -1 |  | -2 |  | -3 |  | -4 |  | -5
1 |  | Ad Valorem Taxes |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
2 |  | Total Taxes  -  Other
Spreadsheet: 140454d1328756808-want-multiple-results-from-vlookup-multiple-lookup
Sheet: Sheet1

 | Company | Customer | Amount
 | a | [NAME] | 10
 | b | [NAME] | 11
 | c | helen | 12
 | a | bob | 13
 | a | [NAME] | 14
 | d | [NAME] | 15
 | e | mark | 16
 | b | [NAME] | 17
 | c | natalia | 18
 | c | [NAME] | 19
 | d | ross | 20
 | c | anna | 21
 | a | [NAME] | 22
 | Company | A | Amount
Spreadsheet: 781873d1653595860-sum-values-depending-on-several-criteria-text-and-number-criteria-test
Sheet: 540_rekapitulacija

[NAME]
Šumarija: Ogulin
Gospodarska jedinica: Josipovac
 |  |  |  |  |  |  | T-2
[NAME] prihoda | [NAME] drveća |  | Tarifa | Površina (ha)
 |  |  |  |  | Etat | Do [NAME]
Glavni redovni |  | O. bukva |  |  |  |  | 14435
Glavni redovni |  | G. javor |  |  |  |  | 392
Glavni redovni |  | OTB |  |  |  |  | 0
Glavni redovni |  | [NAME] |  |  |  |  | 6234
Glavni redovni |  | Smreka |  |  |  |  | 540
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni
Glavni redovni |  | Ukupno:
Glavni slučajni |  |  |  |  |  |  | 0
Glavni slučajni |  |  |  |  |  |  | 0
Glavni slučajni |  | [NAME] |  |  |  |  | 500
Glavni slučajni |  | Smreka |  |  |  |  | 200
Glavni slučajni |  | Ukupno:
Ukupno glavni prihod |  | O. bukva
Ukupno glavni prihod |  | G. javor
Ukupno glavni prihod |  | OTB
Ukupno glavni prihod |  | [NAME]
Ukupno glavni prihod |  | Smreka
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
Ukupno glavni prihod
 |  | Sveukupno:
Prethodni redovni |  | O. bukva
Prethodni redovni |  | G. javor
Prethodni redovni |  | [NAME]
Prethodni redovni |  | Smreka
Prethodni redovni
Prethodni redovni |  |  |  |  |  | Revirnik:____________________________________
Prethodni redovni
Prethodni redovni
Prethodni redovni
Prethodni redovni
Prethodni redovni
Prethodni redovni
Prethodni redovni |  | Ukupno:
Glavni i prethodni prihod |  | O. bukva
Glavni i prethodni prihod |  | G. javor
Glavni i prethodni prihod |  | OTB
Glavni i prethodni prihod |  | [NAME]
Glavni i prethodni prihod |  | Smreka
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod
Glavni i prethodni prihod |  | Sveukupno:
Datum: |  |  |  |  |  |  | Revirnik:
Spreadsheet: 2fe32cd7-4941-48bf-90df-0d73379f0787
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Rate
 | per 1,000 | 95% CI
 | total births | RateLL | RateUL | UCL | LCL
South Derbyshire CD | 5.4 | 2.4 | 12.1 | 6.699999999999999 | 3
Amber Valley CD | 5.6 | 2.7 | 11.6 | 6 | 2.899999999999999
East Northamptonshire CD | 6.1 | 2.8 | 13.6 | 7.5 | 3.3
[NAME] CD | 6.2 | 3 | 13 | 6.8 | 3.2
Erewash CD | 6.5 | 3.3 | 13 | 6.5 | 3.2
Bolsover CD | 6.6 | 3 | 14.6 | 8 | 3.6
Gedling CD | 6.8 | 3.4 | 13.5 | 6.7 | 3.4
Chesterfield CD | 7.3 | 3.6 | 14.5 | 7.2 | 3.7
Derby UA | 7.6 | 5.1 | 11.2 | 3.6 | 2.5
South Northamptonshire CD | 7.7 | 3.7 | 16.1 | 8.400000000000002 | 4
North East Derbyshire CD | 7.9 | 3.8 | 16.6 | 8.700000000000001 | 4.100000000000001
North West Leicestershire CD | 7.9 | 4 | 15.8 | 7.9 | 3.9
ENGLAND | 8 | 7.8 | 8.2 | 0.1999999999999993 | 0.2000000000000002
Harborough CD | 8.1 | 3.9 | 16.9 | 8.799999999999999 | 4.199999999999999
[NAME] CD | 8.1 | 4.4 | 15.1 | 7 | 3.699999999999999
Newark and Sherwood CD | 8.3 | 4.5 | 15.4 | 7.1 | 3.800000000000001
EAST MIDLANDS | 8.4 | 7.7 | 9.3 | 0.9000000000000004 | 0.7000000000000002
[NAME] | 8.4 | 6 | 11.8 | 3.4 | 2.4
Broxtowe CD | 8.4 | 4.4 | 16.1 | 7.700000000000001 | 4
Charnwood CD | 8.5 | 5 | 14.3 | 5.800000000000001 | 3.5
Northampton CD | 8.5 | 5.8 | 12.5 | 4 | 2.7
West Lindsey CD | 8.9 | 4.3 | 18.6 | 9.700000000000001 | 4.600000000000001
Ashfield CD | 9.4 | 5.5 | 16.1 | 6.700000000000001 | 3.9
South Kesteven CD | 9.7 | 5.7 | 16.7 | 7 | 3.999999999999999
Kettering CD | 10.3 | 5.9 | 18.1 | 7.800000000000001 | 4.4
East Lindsey CD | 11.2 | 6.5 | 19.1 | 7.900000000000002 | 4.699999999999999
Hinckley and [NAME] CD | 11.5 | 6.7 | 19.8 | 8.3 | 4.8
Corby CD | 12 | 6.2 | 22.9 | 10.9 | 5.8
Bassetlaw CD | 12 | 7.1 | 20.2 | 8.2 | 4.9
Wellingborough CD | 12.9 | 7.3 | 22.6 | 9.700000000000001 | 5.600000000000001
Leicester UA | 13.2 | 10.3 | 16.8 | 3.600000000000001 | 2.899999999999999
Oadby and Wigston CD | 17.1 | 8.9 | 32.6 | 15.5 | 8.200000000000001