tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: Ws

Weed. S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 59805d1260362432-getting-averages-from-seperate-worksheets-2010
Sheet: December

 |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 |  | 2010-12-01 00:00:00 |  | 2010-12-02 00:00:00 |  | 2010-12-03 00:00:00 |  | 2010-12-04 00:00:00 |  | 2010-12-06 00:00:00 |  | 2010-12-07 00:00:00 |  | 2010-12-08 00:00:00 |  | 2010-12-09 00:00:00 |  | 2010-12-10 00:00:00 |  | 2010-12-11 00:00:00 |  | 2010-12-13 00:00:00 |  | 2010-12-14 00:00:00 |  | 2010-12-15 00:00:00 |  | 2010-12-16 00:00:00 |  | 2010-12-17 00:00:00 |  | 2010-12-18 00:00:00 |  | 2010-12-20 00:00:00 |  | 2010-12-21 00:00:00 |  | 2010-12-22 00:00:00 |  | 2010-12-23 00:00:00 |  | 2010-12-24 00:00:00 |  | 2010-12-25 00:00:00 |  | 2010-12-27 00:00:00 |  | 2010-12-28 00:00:00 |  | 2010-12-29 00:00:00 |  | 2010-12-30 00:00:00 |  | 2010-12-31 00:00:00
Consultant Name | Team Leader | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved
Mpho | [NAME]
[NAME] | [NAME]
Glodean ([NAME]) | [NAME]
[NAME] | [NAME]
Lehlohonolo | [NAME]
Matshidiso | [NAME]
Rachel | [NAME]
Naledi G | [NAME]
Innocentia | [NAME]
Glyndine | [NAME]
Total |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Consultant | Total Sales | Monthly Target | [NAME] | Total Approved | QA Monthly Score | QA Rating
Mpho | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Glodean ([NAME]) | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Lehlohonolo | 0 |  | 0 | 0 |  | -
Matshidiso | 0 |  | 0 | 0 |  | -
Rachel | 0 |  | 0 | 0 |  | -
Naledi G | 0 |  | 0 | 0 |  | -
Innocentia | 0 |  | 0 | 0 |  | -
Glyndine | 0 |  | 0 | 0 |  | -
Total | 0 | 0 | 0 | 0 | #N/A | #N/A
 |  | 0 | 0.8499 | D
 |  | 0.85 | 0.9 | C
 |  | 0.91 | 0.9499 | B
 |  | 0.95 | 1 | A
Spreadsheet: 767350d1644422000-help-with-sorting-records-in-a-report-into-groups-based-on-specific-criteria-and-dates-test-data
Sheet: Sheet1

Consultant | Date | Day of Week | School | Day Type | Content | Vendor/Contract | Funding Source (Non-Public Schools) | PO | Day X of X | Signed Log | Pay Rate  (Finance to Update) | Pay Status  (Finance to Update) | Submission Date | Estimated Payment Date | Payment Date Amount
Person 1 | 2021-12-07 00:00:00 | Tuesday | School 1 | Full Day | MATH | SOL352471 | Title IIA | WR220089158 | 1 of 9 | X | 950 | Yes | 2022-02-09 00:00:00
Person 1 | 2021-12-14 00:00:00 | Tuesday | School 1 | Full Day | MATH | SOL352471 | Title IIA | WR220089158 | 2 of 9 | X | 950 | Yes | 2022-02-09 00:00:00
Person 1 | 2021-12-21 00:00:00 | Tuesday | School 1 | Full Day | MATH | SOL352471 | Title IIA | WR220089158 | 3 of 9 | X | 950 | Yes | 2022-02-09 00:00:00
Person 1 | 2022-01-04 00:00:00 | Tuesday | School 1 | Full Day | MATH | SOL352471 | Title IIA | WR220089158 | 4 of 9 | X | 950 | Yes | 2022-02-09 00:00:00
Person 1 | 2022-01-18 00:00:00 | Tuesday | School 1 | Half Day | MATH | SOL352471 | Title IIA | WR220089158 | 4.5 of 9 | X | 475 | Yes | 2022-02-09 00:00:00
Spreadsheet: 788016d1658225939-help-with-index-match-against-a-partial-match-test1-etaf
Sheet: Sheet2

week number | Date | Del Date | [NAME] |  |  |  | Customer |  | Reason | Action |  | Whos     Order
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003959 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003958 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003957 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003956 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003955 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | [NAME] |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-18 00:00:00 | SRO-003953 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-18 00:00:00 | SRO-003952 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003951 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003950 |  |  |  |  |  |  | SHIPPED
33 | 2022-07-18 00:00:00 | 2022-07-19 00:00:00 | SRO-003949 |  |  |  |  |  |  | SHIPPED
Spreadsheet: 717643d1612788713-counting-customers-by-the-hour-of-the-day-customer-count-ans
Sheet: Output

 |  | Time | Active Customers
 |  | 02:00:00 | 1
 |  | 03:00:00 | 1
 |  | 04:00:00 | 1
 |  | 05:00:00 | 1
 |  | 06:00:00 | 3
 |  | 07:00:00 | 5
 |  | 08:00:00 | 5
 |  | 09:00:00 | 5
 |  | 10:00:00 | 3
 |  | 11:00:00 | 2
 |  | 12:00:00 | 3
 |  | 13:00:00 | 2
 |  | 14:00:00 | 2
 |  | 15:00:00 | 1
 |  | 16:00:00 | 1
 |  | Grand Total | 10
Spreadsheet: 847913d1698758068-conditional-formatting-of-referenced-cells-conditional-formatting-example
Sheet: Item 1

 | Goal | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | YTD
Disposition |  | 98 | 100 | 65 | 12 | 98 | 100 | 65 | 12 | 12 |  |  |  | 62.44444444444444
Source Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Source Code tab, line 2
Template |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Template tab, line 2
Submittal |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Submittal tab, line 2
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Trimble

School | Scholarship | Experation Date
Trimble | Scholarship | Experiation Date
 | Hino Motors Scholarship | March 7th
 | Foodland Scholarship Program | March 12th
 | Ohio Association of Garden Clubs Scholarship | March 15th
 | [NAME] Memorial Scholarship | March 29th
 | [NAME] | March 31st
 | Minority Journalism Scholarship | March 31st
 | [NAME] | April  5th
 | Ohio State Fair Scholarship | July 1st
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 23550 | 23150
2 | 23965 | 23150
3 | 23996 | 23150
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
2000-11-30 00:00:00 |  |  | 96531
2000-12-03 00:00:00
Spreadsheet: 676916d1589056748-lookup-to-return-most-recently-dated-note-based-on-multiple-criteria-notes
Sheet: Rollup

Status | ID | Last Note Manager Note
Active | 1234
Active | 2345
Inactive | 3456
Active | 5678
Active | 8910
Active | 9876
Active | 8765
Active | 7654
Active | 6543
Inactive | 5432
Active | 4321
Active | 2109
Spreadsheet: 11a5fd0f-7f2b-4156-8487-c92800e88dfb
Sheet: vs. allocation

Total Serials Expenditures, All Libraries, FY09, Compared to Allocations
Library | FY09 Allocation | FY09 Actual | % difference
Kingston serials | 2071572.5
Kingston monographs | 300000 | 302430.28
[NAME] serials (pelp) | 50000
[NAME] monographs | 0 | 2168.62 | N/A
CCE serials (ccep) | 0 |  | N/A
CCE monographs | 0 | 7058.43 | N/A
TOTALS
Spreadsheet: 864469d1711631318-how-to-assign-values-diet_plan
Sheet: Tabelle1

 |  |  |  |  |  |  | Diet Plan
List |  |  |  | Monday | Product | Quantity | Calories | Total Cal.
Product | Quant.[NAME] | Kcal |  | Breakfast | [NAME] | 200 g | 360
[NAME] | 100 g | 180 |  |  | Bread | 4 pcs. | 480
Bread | Pcs. | 120
[NAME] | 100 g | 170
Spreadsheet: 879908d1727506074-lookup-from-tab-names-sample_data_mull21
Sheet: 2vi

 | Nimi | Team | 1 | 2 | 3 | 4 | 5 | Total
1 | Person Green Three | Team Green | 269 | 213 | 226 | 186 | 232
2 | Person Yellow Three | Team Yellow | 176 | 225 | 170 | 148 | 247
3 | Person Yellow One | Team Yellow | 196 | 178 | 168 | 205 | 201
4 | Person Yellow Two | Team Yellow | 156 | 235 | 209 | 174 | 150
5 | Person Green One | Team Green | 192 | 225 | 145 | 190 | 168
6 | Person Green Two | Team Green | 217 | 121 | 195 | 183 | 174
7 | Person Blue One | Team Blue | 133 | 161 | 169 | 194 | 151
8 | Person Blue Two | Team Blue | 181 | 149 | 169 | 148 | 159
9 | Person Blue Three | Team Blue | 167 | 194 | 116 | 154 | 169
Spreadsheet: 827daa83-f4cb-4153-a7f8-6d81a732cfc6
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | ENGINEERING & TECHNICAL
 |  |  |  |  |  |  | BRANCH: BRISBANE
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | [NAME] approved timesheets to: [EMAIL]
 |  |  |  |  |  | or | FAX: 1800 652 808 before 9am Monday
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod Payroll, 200 Greenhill Road, EASTWOOD SA 5063
August 2010
Spreadsheet: 99040d1297811038-sumif-but-only-for-the-last-5-results-goaldiff-example
Sheet: Sheet1

Date | HomeTeam | AwayTeam | Home Goals | Away Goals | Home Teams Goal Difference (Last 5 games) | [NAME] (Last 5 games)
2007-09-11 00:00:00 | [NAME] | Liverpool
2007-08-11 00:00:00 | [NAME] | Liverpool | 0 | 4
2007-07-11 00:00:00 | [NAME] | Portsmouth | 3 | 0
2007-07-11 00:00:00 | Everton | Liverpool | 1 | 1
2007-06-11 00:00:00 | [NAME] | [NAME] | 2 | 2
2007-06-11 00:00:00 | Sunderland | Liverpool | 1 | 1
2007-05-11 00:00:00 | [NAME] | Man City | 2 | 1
2007-05-11 00:00:00 | Arsenal | Liverpool | 3 | 0
2007-04-11 00:00:00 | [NAME] | Birmingham | 1 | 2
2007-04-11 00:00:00 | Man United | Liverpool | 2 | 2
2007-03-11 00:00:00 | [NAME] | Newcastle | 0 | 1
2007-02-11 00:00:00 | [NAME] | Sunderland | 1 | 1
2007-02-11 00:00:00 | Birmingham | Liverpool | 2 | 2
Spreadsheet: 854215d1704176724-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-formula-play_with-expected-results-highlighted-in-yellow_v4-hd-1-
Sheet: NSW Public Hol

 |  | Labour Day | 2023-10-02 00:00:00
 |  | Christmas Day | 2023-12-25 00:00:00
 |  | Boxing Day | 2023-12-26 00:00:00
 |  | Picnic Day | 2023-12-27 00:00:00
 |  | New Year's Day | 2024-01-01 00:00:00
 |  | Australia Day | 2024-01-26 00:00:00
 |  | Good Friday | 2024-03-29 00:00:00
 |  | Easter Saturday | 2024-03-30 00:00:00
 |  | Easter Sunday | 2024-03-31 00:00:00
 |  | Easter Monday | 2024-04-01 00:00:00
 |  | Anzac Day | 2024-04-25 00:00:00
 |  | King's Birthday | 2024-06-10 00:00:00
 |  | bank holiday | 2024-08-05 00:00:00
 |  | Labour Day | 2024-10-07 00:00:00
 |  | Christmas Day | 2024-12-25 00:00:00
 |  | Boxing Day | 2024-12-26 00:00:00
Spreadsheet: mary_fischer__25606__31Z
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY #  031Z
COMPANY NAME    LINC
ANALYSIS OF RESERVE ITEMS
FOR THE YEAR ENDED 12-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065) |  | -316745 |  |  |  |  |  |  |  |  |  |  |  | Reserve for doubtful accounts
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 185223d1349576219-recap-of-depreciation-current-year-depreciation
Sheet: Cove

 |  | Asset Depreciation Information
 |  |  |  | Asset Description | Cove Cottage
 |  |  |  | Asset Class | Building
 |  |  |  | Depreciation Basis | 25000
 |  |  |  | Recovery Period (n) | 27.5 |  |  | 27.5
 |  |  |  | Depreciation Method | SL | DB Factor | 2
 |  |  |  | Convention | Mid-Month
 |  |  |  | Placed in Service Month | 6 | 1994-06-11 00:00:00
 |  |  |  | Last Year of Depreciation | 28
 |  |  |  | First Year Fraction | 0.5416666666666666
 |  | Depreciation Schedule |  |  |  |  |  |  | [42]
Year | Rate | Year | Adjustments | Basis | Dj (SL) | Dj (DB) | Depreciation | Cumulative | Book Value
1994 | 0.0196968 | 1 |  | 25000 | 492.42 | 0 | 492.42 | 492.42 | 24507.58
1995 | 0.0363636 | 2 |  | 24507.58 | 909.09 | 0 | 909.09 | 1401.51 | 23598.49
1996 | 0.0363636 | 3 |  | 23598.49 | 909.09 | 0 | 909.09 | 2310.6 | 22689.4
1997 | 0.0363636 | 4 |  | 22689.4 | 909.09 | 0 | 909.09 | 3219.69 | 21780.31
1998 | 0.0363636 | 5 |  | 21780.31 | 909.09 | 0 | 909.09 | 4128.78 | 20871.22
1999 | 0.0363636 | 6 |  | 20871.22 | 909.09 | 0 | 909.09 | 5037.87 | 19962.13
2000 | 0.0363636 | 7 |  | 19962.13 | 909.09 | 0 | 909.09 | 5946.96 | 19053.04
2001 | 0.0363636 | 8 |  | 19053.04 | 909.09 | 0 | 909.09 | 6856.05 | 18143.95
2002 | 0.0363636 | 9 |  | 18143.95 | 909.09 | 0 | 909.09 | 7765.14 | 17234.86
2003 | 0.0363636 | 10 |  | 17234.86 | 909.09 | 0 | 909.09 | 8674.23 | 16325.77
2004 | 0.0363636 | 11 |  | 16325.77 | 909.09 | 0 | 909.09 | 9583.32 | 15416.68
2005 | 0.0363636 | 12 |  | 15416.68 | 909.09 | 0 | 909.09 | 10492.41 | 14507.59
2006 | 0.0363636 | 13 |  | 14507.59 | 909.09 | 0 | 909.09 | 11401.5 | 13598.5
2007 | 0.0363636 | 14 |  | 13598.5 | 909.09 | 0 | 909.09 | 12310.59 | 12689.41
2008 | 0.0363636 | 15 |  | 12689.41 | 909.09 | 0 | 909.09 | 13219.68 | 11780.32
2009 | 0.0363636 | 16 |  | 11780.32 | 909.09 | 0 | 909.09 | 14128.77 | 10871.23
2010 | 0.0363636 | 17 |  | 10871.23 | 909.09 | 0 | 909.09 | 15037.86 | 9962.14
2011 | 0.0363636 | 18 |  | 9962.14 | 909.09 | 0 | 909.09 | 15946.95 | 9053.05
2012 | 0.0363636 | 19 |  | 9053.05 | 909.09 | 0 | 909.09 | 16856.04 | 8143.959999999999
2013 | 0.0363636 | 20 |  | 8143.959999999999 | 909.09 | 0 | 909.09 | 17765.13 | 7234.869999999999
2014 | 0.0363636 | 21 |  | 7234.869999999999 | 909.09 | 0 | 909.09 | 18674.22 | 6325.779999999999
2015 | 0.0363636 | 22 |  | 6325.779999999999 | 909.09 | 0 | 909.09 | 19583.31 | 5416.689999999999
2016 | 0.0363636 | 23 |  | 5416.689999999999 | 909.09 | 0 | 909.09 | 20492.4 | 4507.599999999999
2017 | 0.036364 | 24 |  | 4507.599999999999 | 909.1 | 0 | 909.1 | 21401.5 | 3598.5
2018 | 0.0363636 | 25 |  | 3598.5 | 909.09 | 0 | 909.09 | 22310.59 | 2689.41
2019 | 0.036364 | 26 |  | 2689.41 | 909.1 | 0 | 909.1 | 23219.69 | 1780.310000000001
2020 | 0.0363636 | 27 |  | 1780.310000000001 | 909.09 | 0 | 909.09 | 24128.78 | 871.2200000000012
2021 | 0.03484880000000005 | 28 |  | 871.2200000000012 | 871.2200000000012 | 0 | 871.2200000000012 | 25000 | 0
Spreadsheet: 30ffe252-7ad8-4abb-822f-4253b35da43b
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/12/2010 | Women's Basketball | Loyola, Maryland | 12:00 AM | W, 80-49
11/17/2010 | Women's Basketball | Duquesne | 12:00 AM | W, 69-58
11/19/2010 | Women's Basketball | Delaware State | 12:00 AM | W, 66-31
11/25/2010 | Women's Basketball | No. 21/25 TCU (St. Thomas, V.I.) | 12:00 AM | W, 62-49
11/26/2010 | Women's Basketball | vs. Virginia (St. Thomas, V.I.) | 12:00 AM | W, 57-43
11/27/2010 | Women's Basketball | No. 19/17 Iowa State (St. Thomas, V.I.) | 12:00 AM | W, 64-53
12/02/2010 | Women's Basketball | Elon | 12:00 AM | W, 90-51
12/04/2010 | Women's Basketball | High Point | 12:00 AM | W, 81-52
12/09/2010 | Women's Basketball | at Villanova | 12:00 AM | W, 39-36
12/11/2010 | Women's Basketball | Prairie View A&M | 12:00 AM | W, 71-39
12/18/2010 | Women's Basketball | St. Francis (Pa.) | 12:00 AM | W, 83-55
12/21/2010 | Women's Basketball | at North Carolina Central | 12:00 AM | W, 71-39
12/30/2010 | Women's Basketball | at St. Bonaventure | 12:00 AM | W, 62-53
01/02/2011 | Women's Basketball | Central Connecticut State | 12:00 AM | W, 63-37
01/05/2011 | Women's Basketball | at Seton Hall | 12:00 AM | W, 67-46
01/08/2011 | Women's Basketball | Cincinnati | 12:00 AM | W, 72-44
01/11/2011 | Women's Basketball | at Marquette | 12:00 AM | L, 69-54
01/15/2011 | Women's Basketball | No. 25/RV Syracuse | 12:00 AM | W, 70-61
01/19/2011 | Women's Basketball | vs. [NAME] (Charleston, W.Va.) | 12:00 AM | W, 78-21
01/22/2011 | Women's Basketball | USF | 12:00 AM | W, 78-52
01/25/2011 | Women's Basketball | at No. 19/19 Georgetown | 12:00 AM | L, 65-60
01/30/2011 | Women's Basketball | at No. 12/17 [NAME] | 12:00 AM | L, 78-55
02/01/2011 | Women's Basketball | Providence | 12:00 AM | W, 59-45
02/05/2011 | Women's Basketball | Pitt | 12:00 AM | L, 60-53
02/08/2011 | Women's Basketball | No. 2/2 Connecticut | 12:00 AM | L, 57-51
02/13/2011 | Women's Basketball | at Louisville | 12:00 AM | L, 57-47
02/19/2011 | Women's Basketball | at Pitt | 12:00 AM | W, 90-79
02/22/2011 | Women's Basketball | No. 8/7 Notre Dame | 12:00 AM | L, 72-60
02/26/2011 | Women's Basketball | at Rutgers | 12:00 AM | L, 67-58
02/28/2011 | Women's Basketball | St. John's | 12:00 AM | W, 69-49
03/04/2011 | Women's Basketball | vs. Cincinnati | 12:00 AM | W, 66-41
03/05/2011 | Women's Basketball | vs. St. John's | 12:00 AM | L, 59-51
03/20/2011 | Women's Basketball | vs. No. 22/24 Houston (NCAA) | 12:00 AM | W, 79-73
03/22/2011 | Women's Basketball | vs. [NAME] (NCAA) | 12:00 AM | L, 82-68
Spreadsheet: 715921d1611922877-formula-to-offset-address-shown-in-another-cell-or-to-the-formula-that-calculates-it-county104sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | more centered near the top of the screen.
Scenario List |  |  | Evaluation Record |  |  | 1 | Scenario |  | 1
D9_MISC |  | SCENARIO REVIEW NO 1
 | XXXXXXXXXXXXXXXXXXXXXXXXXXXX |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  | AA1 | Evaluation Record |  |  |  | Scenario
D9_MISC |  | SCENARIO REVIEW NO 2
 | YYYYYYYYYYYYYYYYYYYYYYYYYYYY |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  | AA2 | Evaluation Record |  |  |  | Scenario
D9_MISC |  | SCENARIO REVIEW NO 3
 | ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  | AA3 | Evaluation Record |  |  |  | Scenario
 |  |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  |  | Evaluation Record |  |  |  | Scenario
 |  |  |  |  |  |  |  |  | HOME
 |  |  |  |  |  |  |  |  | DOR
 |  |  |  |  |  |  |  |  | TOP
 |  |  |  |  |  |  |  |  | END
 |  |  | Evaluation Record |  |  |  | Scenario
Spreadsheet: 847862d1698696090-v-lookup-find-e-mail-and-capture-additional-values-v-lookup-e-mail-and-provide-values-other-cells
Sheet: Sheet1

Code | Last | First | E Mail |  | match | result | Last | First
1 | A | Sara | [EMAIL] |  | [EMAIL] |  | A | Sara
2 | B | [NAME] | [EMAIL] |  | [EMAIL] |  | B | [NAME]
4 | C | [NAME] | [EMAIL] |  | [EMAIL] |  | C | [NAME]
4 | D | [NAME] | [EMAIL] |  | [EMAIL] |  | D | [NAME]
5 | E | [NAME] | [EMAIL] |  | [EMAIL] |  | E | [NAME]
6 | F | Irmgard | [EMAIL] |  | [EMAIL] |  | F | Irmgard
7 | G | LYNDA | [EMAIL] |  | [EMAIL] |  | G | LYNDA
7 | H | Lynda |  |  | [EMAIL]
10 | I | [NAME] |  |  | [EMAIL]
11 | J | [NAME] |  |  | [EMAIL]
I want to see if a given e mail is in a list and return last and first name for that e mail.  My example uses a short list. The real one is much longer. The formula I am using is not working. I have written it to indicate whether the statement is true or not, which is a minimum requirement, but it won't do that. Ideally I would like to return the last and first name. Does my request make sense?
Spreadsheet: 132238d1323631146-counting-formula-question-count-cells-and-rows-with-sames-conditions
Sheet: Φύλλο1

 |  |  | yes | yes | no | no | no | yes | no | 1 | ROWS--RESULT(All CRiTeRIA) | RESULT(All CRITERIA) cells
 |  |  | yes | yes | no | no | no | yes | no | 1 | 3 | 21
 |  |  | yes | no | no | no | no | yes | no | 0
 |  |  | yes | yes | no | no | no | no | no | 0
 |  |  | yes | yes | no | no | no | yes | no | 1
 |  |  | no | yes | no | no | no | yes | no | 0
Spreadsheet: 781335d1653237104-formula-that-check-and-give-me-results-like-green-ok-red-not-ok-skill-etaf
Sheet: users

username | name | surname | groups | check | Prince | King | Queen |  |  |  | List Count
123456 | [NAME] | doe | dell | OK [NAME] |  |  |  |  |  |  | Prince | King | Queen
123456 | [NAME] | doe | hp
123456 | [NAME] | doe | lenovo
123456 | [NAME] | doe | ios
123456 | [NAME] | doe | think
123456 | [NAME] | doe | nike
123456 | [NAME] | doe | adidas
123456 | [NAME] | doe | primark
2494144 | mila | [NAME] | ios | OK KING
2494144 | mila | [NAME] | monitor
2494144 | mila | [NAME] | mac
2494144 | mila | [NAME] | dell
2494144 | mila | [NAME] | bus
44895 | [NAME] | russell | boat | NOT OKAY QUEEN
44895 | [NAME] | russell | ios
44895 | [NAME] | russell | lenovo
44895 | [NAME] | russell | dell
44895 | [NAME] | russell | keyboard
44895 | [NAME] | russell | pad
44895 | [NAME] | russell | ice
44895 | [NAME] | russell | country
44895 | [NAME] | russell | mac
Spreadsheet: 881688d1729820927-fleet-tracker-fleet-tracker-eba
Sheet: Tracker

Trailer Inventory | How many days used this month? | Percentage of Time Used? | [NAME] if not used more than 2 Days
A1234
B4368
A1235
[NAME]
A1236
B4370
A1237
B4371
A1238
B4372
A1239
[NAME]
A1240
B4374
A1241
B4375
A1242
B4376
A1243
[NAME]
A1244
B4378
A1245