tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 45497d1244222088-evaluating-the-day-of-week-timesheet-calculator2
Sheet: Rates

PAYE |  |  | Multiply by:
 |  |  | 1.25 | 1.25 | 1.5
Name | Trade | Flat Hourly rate (8am - 5pm) | Night rate          Mon - Fri      (5:30pm onwards) | Weekend Day        (8am - 5pm) | Weekend Night (5:30pm onwards)
M. Laity | C | 10.3 | 12.875 | 12.875 | 15.45
[NAME] | C | 10.3 | 12.875 | 12.875 | 15.45
[NAME] | C | 11.5 | 14.375 | 14.375 | 17.25
[NAME] | L | 7.5 | 9.375 | 9.375 | 11.25
I. Edwards | FC | 14.5 | 18.125 | 18.125 | 21.75
[NAME] | FC | 11.44 | 14.3 | 14.3 | 17.16
[NAME] | P | 11.5 | 14.375 | 14.375 | 17.25
M. Wilding | FC | 14.5 | 18.125 | 18.125 | 21.75
K. Wilding | L | 7 | 8.75 | 8.75 | 10.5
[NAME] | B | 11.5 | 14.375 | 14.375 | 17.25
S. Ignatov | Semi Skilled | 10 | 12.5 | 12.5 | 15
[NAME] | Semi Skilled | 10 | 12.5 | 12.5 | 15
[NAME] | Skilled | 14 | 17.5 | 17.5 | 21
[NAME] | Skilled | 14 | 17.5 | 17.5 | 21
[NAME] | Skilled | 14 | 17.5 | 17.5 | 21
[NAME] | Skilled | 14 | 17.5 | 17.5 | 21
D. Hardwell | Skilled | 14 | 17.5 | 17.5 | 21
[NAME] | Semi Skilled | 12.5 | 15.625 | 15.625 | 18.75
[NAME] | Semi Skilled | 12.5 | 15.625 | 15.625 | 18.75
[NAME] | Non Skilled | 7 | 8.75 | 8.75 | 10.5
T. Riley | Skilled | 14 | 17.5 | 17.5 | 21
[NAME] | Skilled | 14 | 17.5 | 17.5 | 21
[NAME] | Skilled | 12.5 | 15.625 | 15.625 | 18.75
Spreadsheet: 778082d1650853807-automatic-ranking-standings-bouwcenter-poule-f1-2022-v1a-clau46-
Sheet: Sheet1

World Drivers' Championship standings
Pos. | Driver | BHR | SAU | AUS | EMI | MIA | ESP | MON | AZE | CAN | GBR | AUT | FRA | HUN | BEL | NED | ITA | TBA | SIN | JPN | USA | Mex | Bra | ABU | Points | Key
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Colour | Result
1 | [NAME] | 1PF | 2F | 1PF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gold | Winner
2 | [NAME] | 4 | 5 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | Silver | Second place
3 | [NAME] | 2 | 3 | Ret |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | [NAME] | Third place
4 | [NAME] | 18 | 4P | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | Green | Other points position
5 | [NAME] | 3 | 10 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | Blue | Other classified position
6 | [NAME] | 19 | 1 | Ret |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | Not classified, finished (NC)
7 | Esteban Ocon | 7 | 6 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | Purple | Not classified, retired (Ret)
8 | [NAME] | 15 | 7 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Red | Did not qualify (DNQ)
9 | [NAME] | 5 | 9 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | Did not pre-qualify (DNPQ)
10 | [NAME] | 6 | Ret | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Black | Disqualified (DSQ)
11 | [NAME] | 14 | Ret | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | White | Did not start (DNS)
12 | [NAME] | Ret | 8 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | Race cancelled (C)
13 | [NAME] | 8 | DNS | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Blank | Did not practice (DNP)
14 | [NAME] | 9 | Ret | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | Excluded (EX)
15 | [NAME] | 10 | 11 | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | Did not arrive (DNA)
16 | [NAME] | 13 | 14 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | Withdrawn (WD)
17 | [NAME] | 11 | WD | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Annotation | Meaning
18 | Lance Stroll | 12 | 13 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Superscript | Points-scoring position
19 | [NAME] | 17 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | number | in sprint
20 | [NAME] | 16 | Ret | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | P | Pole position
– | [NAME] | - | - | Ret |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | F | Fastest lap
Spreadsheet: 1b3fcfa1-e632-456f-baf6-83c64d0e311a
Sheet: Sheet1

Unnamed: 0 | CITRIX SYSTEMS, INC. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | REVENUES BY REPORTABLE SEGMENT
 | (In thousands)
 |  |  | Three Months |  | Three Months |  | Three Months |  | Three Months |  | Twelve Months
 |  |  | Ended |  | Ended |  | Ended |  | Ended |  | Ended
 |  |  | March 31, |  | June 30, |  | September 30, |  | December 31, |  | December 31,
 |  |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002
 | Revenues:
 | Americas (1) |  | 69828 |  | 54321 |  | 61067 |  | 70222 |  | 255438
 | EMEA (2) |  | 51049 |  | 46979 |  | 46847 |  | 64645 |  | 209520
 | Asia-Pacific |  | 11561 |  | 11946 |  | 10984 |  | 13917 |  | 48408
 | Other (3) |  | 9872 |  | 4210 |  | 0 |  | 0 |  | 14082
 | Total Revenue |  | 142310 |  | 117456 |  | 118898 |  | 148784 |  | 527448
 | (1) - Our Americas segment is comprised of the United States, Canada, Latin America.
 | (2) - Defined as Europe, Middle East and Africa.
 | (3) - Represents royalty fees in connection with the Microsoft Development Agreement, which expired in May 2002.
 | Note:  This document should not be read in isolation and should be read in conjunction with the Company's SEC Filings.
 | *Posted as of 4-8-2005
Spreadsheet: 787179d1657657007-trying-to-filter-out-information-into-a-new-sheet-tasks-and-projects2
Sheet: In Progress

 | # | Task | Captain | Assistant | Priority | Due Date | Status | Days Left
Spreadsheet: 0a623b80-fe23-4410-a327-748015aff800
Sheet: Sheet1

Tiered Price Analysis Worksheet
Cost of Ingredients |  |  | 1.68
Cost of Packaging |  |  | 0.12
Cost of Labor |  |  | 0
 | % amt | $ amt |  | [NAME]
Gross Margin | 0.3 |  |  | Price to broker
[NAME] | 0.1 |  |  | Price to distributor
[NAME] | 0.2 |  |  | Wholesale price (to retailer)
[NAME] | 1 |  |  | Retail Price
Spreadsheet: 540378d1506670820-sum-two-cells-from-two-different-tables-excel-help-example
Sheet: Nov17

 |  |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  |  |  |  |  |  | 44 |  |  | 1 | 2 | 3 | 4 | 5 |  | Total days: | 23
 |  |  |  |  |  |  | 45 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | Work hours:
 |  |  |  |  |  |  | 46 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 |  |  |  |  |  |  | 47 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 |  |  |  |  |  |  | 48 | 27 | 28 | 29 | 30 | 29 | 30
Not-uniqe | Not-uniqe2 | Cost Center | % | Time spent | Comment
FDASD |  | 1
FDASD |  | 2
 |  | 3
ASD |  | 4
ASD |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11 |  | 0:30:00
 |  | 12 |  | 1 day, 1:00:00
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18 |  | 2 days, 2:00:00
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | 32
 |  | 33
 |  | 34
 |  | 35
 |  | 36
 |  | 37
 |  | 38
 |  | 39
Total
Spreadsheet: 160409d1339079705-multiple-orders-per-client-ef105_combine_multi_orders
Sheet: Sheet1

Client Name | Order | seq
[NAME] | Cakes |  | [NAME] added in column C
[NAME] | Oranges |  | Copied down beyond data
[NAME] | Bananas
[NAME] | Bread
[NAME] | Potatoes
[NAME] | Carrots
Spreadsheet: 708808d1608036456-extract-and-sum-numerical-values-using-string-matching-from-single-multi-value-cell-submission
Sheet: CALCULATIONS

Fred |  |  |  |  | 2675_DRIVE BASE_BOTTOM FLANGE_WELD_02 |  |  |  |  | 2675_PACKAGE 1_08
Jake |  |  |  |  | 2675_DRIVE BASE_BOTTOM [NAME] |  |  |  |  | 2675_DRIVE BASE_MADE UP_02
[NAME] |  |  |  |  | 2675_PACKAGE 1_08 |  |  |  |  | 2675_DRIVE BASE_FAKEE_06
[NAME]
[NAME]
STEP 1 - EXTRACT 2675 |  |  |  |  | CALCULATION
STEP 2 - EXTRACT THE ACTION "DRIVE BASE" |  |  |  |  | Position
STEP 3 - EXTRACT THE COMPONENT |  |  |  |  | Position
STEP 4 - EXTRACT ACTION
STEP 5 - EXTRACT HOURS
Spreadsheet: 126409d1319670678-index-and-match-formula-tournamenttemplatetest
Sheet: Thank You Letter

Category:
[NAME] | Donation | Description of Goods/Services | Hole Sponsorship | Value | Prefix | First Name | Last Name | Company Name | Street Address | City | State | Zip Code | Greeting | E-mail | Phone |  | Thank You Letters | [NAME] in Charge:
Spreadsheet: 76588d1277142961-match-index-from-data-sheet-to-individual-sheet-subj-reimb-credit-calculation-question
Sheet: Subj Reimbursement (3)

Subject # | # of Days |  | 3
212 | 3
Site: Example
COMS #: 2######
CVD Study #: 82#####
Sponsor: Example
Protocol: ###xyz
Line Item | Rate | Units | SubTotals
Unit Days | 999 | 3 | 2997
Unit Day (by Exception)* | 999 | 0 | 0
OPVs | 999 | 0 | 0
Extended OPVs | 999 | 0 | 0
Wash out < 5 Days | 99 | 0 | 0
Wash out > 5 Days but < 10 Days | 999 | 0 | 0
Wash out > 10 Days but < 15 Days | 999 | 0 | 0
Continued participation through follow-up calculated as [NAME] out above | 9 | 0 | 0
Diaries (per week)** | 99 | 0 | 0
Telephone Contacts | 99 | 0 | 0
 |  |  | 2997 | Total
*Used for studies requiring extended in-house stays where stipends are >$10,000.  Discuss stipend options with the site for those studies.
**Varies depending on the type of diary/subject time commitment - minimum listed as default.
Spreadsheet: 876767d1723496537-help-schedule-problem-pulling-task-and-revert-back-to-am-or-pm-weekly_employee_schedule_template
Sheet: Time

 | 06:00:00 |  |  | 00:30:00
 | 06:30:00 |  |  | 0 | 0
 | 07:00:00
 | 07:30:00
 | 08:00:00 |  |  |  |  | TRAINING
 | 08:30:00 |  |  |  |  | CIGS
 | 09:00:00 |  |  |  |  | CASHIER
 | 09:30:00 |  |  |  |  | CLERK
 | 10:00:00 |  |  |  |  | VMC
 | 10:30:00 |  |  |  |  | GROCERY
 | 11:00:00 |  |  |  |  | DAIRY
 | 11:30:00 |  |  |  |  | STOCKER
 | 12:00:00 |  |  |  |  | DELI
 | 12:30:00 |  |  |  |  | DISPLAY
 | 13:00:00 |  |  |  |  | DESK
 | 13:30:00 |  |  |  |  | FLOORS
 | 14:00:00
 | 14:30:00
 | 15:00:00
 | 15:30:00
 | 16:00:00
 | 16:30:00
 | 17:00:00
 | 17:30:00
 | 18:00:00
 | 18:30:00
 | 19:00:00
 | 19:30:00
 | 20:00:00
 | 20:30:00
 | 21:00:00
 | 21:30:00
 | 22:00:00
 | OFF
Spreadsheet: 679099d1590187375-help-need-on-date-function-date-function
Sheet: Sheet1

 |  |  | Target Month | 2020-08-22 00:00:00
 |  |  |  | As Is
 | Sr.No | Task Name | Frequency | To be Started by | To be completed by | Status |  |  |  | Holiday Calendar
 | 1 | Task 1 | Monthly | 1st business day of every month | 5th Business day of every month | Completed
 | 2 | Task 2 | Monthly | 8th busness day before the end of month | 8th busness day before the end of month | In Progress |  |  |  | 2020-04-17 00:00:00
 | 3 | Task 3 | Quarterly | 3 biz days before end of Mar/Jun/Sep/Dec | Last biz day of Mar/Jun/Sep/Dec | Not Required |  |  |  | 2020-04-27 00:00:00
 | 4 | Task 4 | Quarterly | 1st biz day of Jan/April/July/Oct | 15th biz day of Jan/April/July/Oct | Not Required |  |  |  | 2020-05-04 00:00:00
 | 5 | Task 5 | Half-Yearly | 1st biz day of Feb/Aug | Last biz day of Feb/Aug | Not Started |  |  |  | 2020-05-05 00:00:00
 | 6 | Task 6 | Half-Yearly | 10th biz day of Feb/Aug | End of March/Sept | Not Started |  |  |  | 2020-05-29 00:00:00
 | 7 | Task 7 | Yearly | 10th biz day of Oct | End of Nov | Not Started |  |  |  | 2020-06-15 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-07-28 00:00:00
 |  |  |  | To be |  |  |  |  |  | 2020-08-15 00:00:00
 | Sr.No | Task Name | Frequency | Start Date | End Date | Status |  |  |  | 2020-08-17 00:00:00
 | 1 | Task 1 | Monthly |  |  | Completed
 | 2 | Task 2 | Monthly |  |  | In Progress
 | 3 | Task 3 | Quarterly |  |  | Not Required
 | 4 | Task 4 | Quarterly |  |  | Not Required |  |  |  | Calendar
 | 5 | Task 5 | Half-Yearly |  |  | Not Started |  |  |  | QSet1 | QSet2
 | 6 | Task 6 | Half-Yearly |  |  | Not Started |  |  |  | 1 | 3
 | 7 | Task 7 | Yearly |  |  | Not Started |  |  |  | 4 | 6
 |  |  |  |  |  |  |  |  |  | 7 | 9
 |  |  |  |  |  |  |  |  |  | 10 | 12
 |  |  |  |  |  |  |  |  |  | HSet1
 |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 833551d1687078982-marginal-tax-rate-cell-value-to-reflect-percentage-change-in-another-tax
Sheet: Tax Liability

 | 2023/24 Tax Year
 | Taxable Income
 | Personal Allowance Taper
 | Difference
 | Deductions
 | Tax Brackets
 | Taxable Income | Tax Payable | Tax Rate
 | 0 | 0 | 0
 |  | 0 | 0.2
 |  |  | 0.4
 |  |  | 0.45
 | Calculations
 | Payable in previous band
 | Rate of current band
 | Payable in current band
 | Tax payment
 | Marginal Rate
 | Effective Rate
Spreadsheet: 567929d1522285482-lookup-multiple-occurrences-of-the-same-value-in-two-different-columns-ef1136b_elo_adjustments
Sheet: ELO

Name | ELO 1 | ELO 2 | ELO 3 | ELO 4 | ELO 5 | ELO 6 | ELO 7 | ELO 8 | ELO 9 | ELO 10 | ELO 11 | ELO 12 | ELO 13 | ELO 14 | ELO 15
Adam
Alicia
[NAME]
Braxton
Ellie
[NAME]
Erin
Grace
Jessica
Olivia
[NAME]
[NAME]
[NAME]
Tyron
Spreadsheet: 490524d1479908968-series-of-dates-with-quarter-end-dates-sample-date-schedule
Sheet: Sheet1

 |  |  | CASE 1 |  |  | CASE 2
Start Date | 2016-01-15 00:00:00 |  | Start Date | 2016-01-15 00:00:00 |  | Start Date | 2016-01-15 00:00:00
2nd Given Date | 2016-02-14 00:00:00 |  | 2nd Given Date | 2016-02-14 00:00:00 |  |  | 2016-03-31 00:00:00
 |  |  |  | 2016-03-14 00:00:00 |  |  | 2016-06-30 00:00:00
 |  |  |  | 2016-03-31 00:00:00 |  | 2nd Given Date | 2016-07-14 00:00:00
 |  |  |  | 2016-04-14 00:00:00 |  |  | 2016-08-14 00:00:00
 |  |  |  | 2016-05-14 00:00:00 |  |  | 2016-09-14 00:00:00
 |  |  |  | 2016-06-14 00:00:00 |  |  | 2016-09-30 00:00:00
 |  |  |  | 2016-06-30 00:00:00 |  |  | 2016-10-14 00:00:00
 |  |  |  | 2016-07-14 00:00:00 |  |  | 2016-11-14 00:00:00
 |  |  |  | 2016-08-14 00:00:00 |  |  | 2016-12-14 00:00:00
 |  |  |  | 2016-09-14 00:00:00 |  |  | 2016-12-31 00:00:00
 |  |  |  | 2016-09-30 00:00:00 |  |  | 2017-01-14 00:00:00
 |  |  |  | 2016-10-14 00:00:00 |  |  | 2017-02-14 00:00:00
 |  |  |  | 2016-11-14 00:00:00 |  |  | 2017-03-14 00:00:00
 |  |  |  | 2016-12-14 00:00:00 |  |  | 2017-03-31 00:00:00
 |  |  |  | 2016-12-31 00:00:00 |  |  | 2017-04-14 00:00:00
 |  |  |  | 2017-01-14 00:00:00 |  |  | 2017-05-14 00:00:00
 |  |  |  | 2017-02-14 00:00:00 |  |  | 2017-06-14 00:00:00
 |  |  |  | 2017-03-14 00:00:00 |  |  | 2017-06-30 00:00:00
 |  |  |  | 2017-03-31 00:00:00 |  |  | 2017-07-14 00:00:00
 |  |  |  | 2017-04-14 00:00:00 |  |  | 2017-08-14 00:00:00
 |  |  |  | 2017-05-14 00:00:00 |  |  | 2017-09-14 00:00:00
 |  |  |  | 2017-06-14 00:00:00 |  |  | 2017-09-30 00:00:00
 |  |  |  | 2017-06-30 00:00:00 |  |  | 2017-10-14 00:00:00
End Date | 2017-12-20 00:00:00 |  |  | 2017-07-14 00:00:00 |  |  | 2017-11-14 00:00:00
 |  |  |  | 2017-08-14 00:00:00 |  |  | 2017-12-14 00:00:00
 |  |  |  | 2017-09-14 00:00:00 |  | End Date | 2017-12-20 00:00:00
 |  |  |  | 2017-09-30 00:00:00
 |  |  |  | 2017-10-14 00:00:00
 |  |  |  | 2017-11-14 00:00:00
 |  |  |  | 2017-12-14 00:00:00
 |  |  | End Date | 2017-12-20 00:00:00
Spreadsheet: 75882d1276504522-merging-several-tabs-attendance-template
Sheet: Sheet2

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 | H | R | W | R | T | T | W | W | W | R | W | W | R | W | W | W | W | R | W | R | W | W | R | W | W | W | R | W | W | W | W
 |  | 38 | LEFT THE BUSINESS
 |  | 38 | R | R | W | W | W | W | W | R | R | W | W | W | W | W | R | R | L | W | W | W | W | R | R | W | W | W | W | W | R | R | H
 |  | 38 | W | W | W | W | W | W | R | R | R | W | W | R | W | W | W | R | H | H | R | H | H | H | W | W | W | W | W | R | R | W | W
 |  | 38 | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | S | W | W | W | R | W | R | W | W | R | W | W | R | W
 |  | 38 | LEFT THE BUSINESS
 |  | 38 | W | R | H | H | H | H | H | R | W | W | W | W | W | R | R | W | W | W | R | W | R | W | W | W | R | W | W | R | W | W | R
 |  | 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 with relevant company policy.
 |  | Paternity | P |  |  |  |  |  | Any deviation from company policy must only be with prior agreement of the HR Manager
 |  | Jury service | J
 |  | Parental leave | PL
 |  | Training | T
Spreadsheet: 584459d1533203205-index-match-multiple-criteria-and-return-value-w-in-employee-schedule-employee-schedule
Sheet: Overview

 | Date |  |  | Date |  |  |  | Example output | Date | 2018-07-25 00:00:00 |  | Date | 2018-07-26 00:00:00
 | Position |  |  | Status |  |  |  |  | Position | Day Lead |  | Status | Leave
 | Name |  |  | Name (s): |  |  |  |  | Name | Employee 2 |  | Name (s): | Employee 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Employee 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Employee 11
Spreadsheet: 271701d1382024633-forumla-if-help-compare-list-of-dates-with-date-and-values-function
Sheet: Function

Booking Date | Items | Value
2013-10-01 00:00:00 | Cake | 20
2013-10-01 00:00:00 | Cake | 20
2013-10-01 00:00:00 | Drinks | 30
2013-10-01 00:00:00 | Cake | 20
2013-10-03 00:00:00 | Drinks | 30
2013-10-04 00:00:00 | Drinks | 30
2013-10-05 00:00:00 | Cake | 20
2013-10-06 00:00:00 | Drinks | 30
2013-10-06 00:00:00 | Cake | 20
2013-10-09 00:00:00 | Drinks | 30
2013-10-10 00:00:00 | Drinks | 30
2013-10-11 00:00:00 | Drinks | 30
2013-10-12 00:00:00 | Cake | 20
2013-10-13 00:00:00 | Cake | 20
2013-10-14 00:00:00 | Cake | 20
2013-10-15 00:00:00 | Cake | 20
2013-10-15 00:00:00 | Drinks | 30
2013-10-15 00:00:00 | Cake | 20
2013-10-16 00:00:00 | Drinks | 30
2013-10-17 00:00:00 | Cake | 20
2013-10-18 00:00:00 | Drinks | 30
2013-10-19 00:00:00 | Cake | 20
2013-10-20 00:00:00 | Drinks | 30
2013-10-21 00:00:00 | Cake | 20
2013-10-22 00:00:00 | Drinks | 30
2013-10-23 00:00:00 | Cake | 20
2013-10-24 00:00:00 | Drinks | 30
2013-10-25 00:00:00 | Cake | 20
2013-10-26 00:00:00 | Drinks | 30
2013-10-27 00:00:00 | Cake | 20
2013-10-28 00:00:00 | Drinks | 30
2013-10-28 00:00:00 | Cake | 20
2013-10-30 00:00:00 | Drinks | 30
Spreadsheet: 108861d1305814870-collection-of-data-from-different-ranges-to-one-range-sample
Sheet: DAILY SALE ENTRY

 | DAILY SALES REPORT |  |  |  |  | DATE OF DSR | 2011-05-14 00:00:00
 | NO | SECTOR | WT | CREDIT | CASH | CUST | JOB
 | 254 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 255 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 256 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 257 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 258 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | TOTAL
 | DAILY SALES REPORT |  |  |  |  | DATE OF DSR | 2011-05-15 00:00:00
 | NO | SECTOR | WT | CREDIT | CASH | CUST | JOB
 | 259 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 260 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 261 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 262 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 263 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | TOTAL
 | DAILY SALES REPORT |  |  |  |  | DATE OF DSR | 2011-05-18 00:00:00
 | NO | SECTOR | WT | CREDIT | CASH | CUST | JOB
 | 265 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 266 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 267 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 268 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | 269 | RTW | 250 | 0 | 2500 | JONE | 2011-11-25 00:00:00
 | TOTAL
Spreadsheet: 765075d1643148053-countifs-within-a-numerical-range-book1a2
Sheet: Sheet1

 | Goal Differential | Moneylines
Game #1 | 3 | -200 | w |  |  |  | <=-200
Game #2 | -2 | -160 | l |  |  |  | >=-199 & <=-150
Game #3 | 4 | -120 | w |  |  |  | >=-149 & <=-100 |  | <<<<< what like to know how to put the numerical range in cells E3 & E4
Game #4 | -3 | -250 | l |  |  |  | >=100
Game #5 | 1 | 120 | w
Game #6 | 3 | 140 | w
Game #7 | -1 | -175 | l
Spreadsheet: 59555d1260141449-sorting-columns-that-contain-values-other-than-numerics-sorting
Sheet: Sheet1

B | C |  | B | C
100 | 2549 |  | . | .
785 | 587 |  | . | .
124 | 421 |  | . | .
156 | 156 |  | . | .
154 | 451 |  | . | .
1027 | 7201 |  | . | .
125 | 521 |  | . | .
325 | 523 |  | . | .
180 | 810 |  | . | .
996 | 699 |  | . | .
198 | 894 |  | 3258 | 8523
. | . |  | 1027 | 7201
. | . |  | 1356 | 6531
. | . |  | 1356 | 6531
. | . |  | 2365 | 5632
. | . |  | 3127 | 2550
750 | 570 |  | 100 | 2549
569 | 965 |  | 100 | 1000
155 | 551 |  | 100 | 1000
2365 | 5632 |  | 100 | 1000
126 | 621 |  | 579 | 975
657 | 756 |  | 669 | 966
117 | 711 |  | 569 | 965
3258 | 8523 |  | 198 | 894
194 | 491 |  | 180 | 810
100 | 1000 |  | 857 | 758
156 | 156 |  | 657 | 756
114 | 411 |  | 117 | 711
. | . |  | 996 | 699
. | . |  | 456 | 654
412 | 421 |  | 126 | 621
750 | 570 |  | 785 | 587
200 | 250 |  | 750 | 570
3127 | 2550 |  | 750 | 570
579 | 975 |  | 155 | 551
150 | 510 |  | 625 | 526
100 | 1000 |  | 625 | 526
625 | 526 |  | 325 | 523
325 | 523 |  | 325 | 523
112 | 211 |  | 325 | 523
1356 | 6531 |  | 125 | 521
857 | 758 |  | 150 | 510
123 | 321 |  | 194 | 491
456 | 654 |  | 154 | 451
669 | 966 |  | 124 | 421
. | . |  | 412 | 421
. | . |  | 114 | 411
. | . |  | 123 | 321
. |  |  | 200 | 250
100 | 1000 |  | 112 | 211
625 | 526 |  | 112 | 211
325 | 523 |  | 156 | 156
112 | 211 |  | 156 | 156
Spreadsheet: 126470d1319712051-time-based-cash-flow-question-model
Sheet: Expenses

 | Expense Summary by Month
 |  | CY2013 |  |  |  |  |  |  |  |  |  |  | SUM | CY2014 |  |  |  |  |  |  |  |  |  |  |  | CY2015 |  |  |  |  |  |  |  |  |  |  |  | CY2016
 |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00
Compensation | Base Salaries
 | Benefits
 | Performance Bonuses
 | Spot Incentives
 | [NAME]