tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 829172d1683998043-large-data-set-into-pro-forma-format-s666-pq-pt-large-data-set-into-pro-forma-format
Sheet: Sheet1

 | Category | Type Code | Type Name | Date | Location | Amount
 | Revenue | 100 | Donations | 2023-01-21 00:00:00 | London | 2000 |  | London | January | February | March |  | [NAME] | January | February | March
 | Revenue | 200 | Sales Income | 2023-01-31 00:00:00 | [NAME] | 500
 | Revenue | 200 | Sales Income | 2023-02-14 00:00:00 | London | 600 |  | Revenue |  |  |  |  | Revenue
 | Revenue | 200 | Sales Income | 2023-01-14 00:00:00 | London | 800 |  | Cost of Sales |  |  |  |  | Cost of Sales
 | Revenue | 100 | Donations | 2023-01-10 00:00:00 | London | 1500 |  | Overheads |  |  |  |  | Overheads
 | Revenue | 100 | Donations | 2023-03-21 00:00:00 | London | 1700 |  | Profit/Loss |  |  |  |  | Profit/Loss
 | Revenue | 100 | Donations | 2023-03-02 00:00:00 | London | 200
 | Revenue | 100 | Donations | 2023-02-22 00:00:00 | London | 600
 | Revenue | 200 | Sales Income | 2023-01-10 00:00:00 | [NAME] | 600
 | Revenue | 200 | Sales Income | 2023-03-30 00:00:00 | [NAME] | 1000
 | Cost of Sales | 500 | Volunteer expenses | 2023-01-31 00:00:00 | [NAME] | -200
 | Overheads | 800 | Advertising - print | 2023-01-05 00:00:00 | London | -250 |  |  | Location | London
 | Overheads | 805 | Advertising - online | 2023-03-27 00:00:00 | London | -300
 | Overheads | 600 | Admin salary | 2023-01-25 00:00:00 | London | -300 |  |  | Sum of Amount | Months
 | Cost of Sales | 500 | Volunteer expenses | 2023-02-28 00:00:00 | [NAME] | -150 |  |  | Category | Jan | Feb | Mar
 | Cost of Sales | 500 | Volunteer expenses | 2023-03-31 00:00:00 | [NAME] | -250 |  |  | Overheads |  | 0
 | Overheads | 800 | Advertising - print | 2023-02-19 00:00:00 | London | -250 |  |  | Revenue | 4300 | 2400 | 1900
 | Overheads | 700 | Rent - shop | 2023-01-02 00:00:00 | [NAME] | -100 |  |  | Grand Total | 4300 | 2400 | 1900
 | Overheads | 700 | Rent - shop | 2023-02-02 00:00:00 | [NAME] | -100
 | Overheads | 700 | Rent - shop | 2023-03-02 00:00:00 | [NAME] | -100
 | Overheads | 750 | Rent - HQ | 2023-01-14 00:00:00 | London | -600
 | Revenue | 200 | Sales Income | 2023-02-07 00:00:00 | London | 1200
 | Overheads | 600 | Admin salary | 2023-02-25 00:00:00 | London | -300
 | Overheads | 600 | Admin salary | 2023-02-25 00:00:00 | London | 0
 | Overheads | 850 | Legal | 2023-02-02 00:00:00 | London | -1000
Spreadsheet: 7e485c09-d11d-4100-adee-166777b530ae
Sheet: Sheet1

State Representative (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Downloaded at 5/21/2013 4:32:58 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
Precinct | Daryl J Lies | Kenton Onstad | [NAME] | TOTALS
Precinct 0401 | 28 | 102 | 83 | 213
Precinct 0402 | 27 | 144 | 113 | 284
TOTAL | 55 | 246 | 196 | 497
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 820009d1677814371-how-to-alternate-cell-format-style-within-a-single-conditional-formatting-rule-ekstasis_x-book_251717-2
Sheet: Calendar

Month: | Year: |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
October | 2023
January | 2022
February | 2023
March | 2024
April | 2025
May | 2026
June | 2027
July | 2028
August | 2029
September | 2030
October | 2031
November | 2032
December | 2033
Spreadsheet: 797824d1664187001-average-but-only-including-certain-cells-based-on-text-in-different-column-sample-data-2022-09-26
Sheet: Sheet1

Notes:  All members of staff will be provided with an automatic allocation of a day per week of ‘Innovation Time’.  This time is provided for grant writing and/or teaching innovation as appropriate to the role pathway.
2021/22
[NAME] only started in April 22 (not included in this model) |  |  |  |  | 1540
Name | Resource ID | [NAME] | Sort order | FTE | Hours per Year (35hrs x 44wks x FTE) | School, Faculty, University Admin Roles | % | Other | % Other | Total | Percent | Expected days per week | Days per week
Name 1 | R1000601 | Pathway 3 |  | 1 | 1540 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0
Name 2 | R0233014 | Pathway 1 |  | 1 | 1540 | 539.5 | 0.3503246753246753 | 0 | 0 | 539.5 | 0.3503246753246753 | 5 | 1.751623376623377
Name 3 | R0230535 | Pathway 3 |  | 1 | 1540 | 100 | 0.06493506493506493 | 0 | 0 | 100 | 0.06493506493506493 | 5 | 0.3246753246753247
Name 4 | R0200320 | Pathway 1 |  | 1 | 1540 | 130 | 0.08441558441558442 | 128 | 0.08311688311688312 | 258 | 0.1675324675324675 | 5 | 0.8376623376623377
Name 5 | R0298213 | Pathway 3 |  | 1 | 1540 | 375 | 0.2435064935064935 | 24 | 0.01558441558441558 | 399 | 0.2590909090909091 | 5 | 1.295454545454545
Name 6 | R0222920 | Pathway 1 |  | 1 | 1540 | 233 | 0.1512987012987013 | 101 | 0.06558441558441558 | 334 | 0.2168831168831169 | 5 | 1.084415584415584
Name 7 | R0222928 | [NAME] |  | 0.2 | 308 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
Name 8 | R0280815 | Pathway 1 |  | 1 | 1540 | 200 | 0.1298701298701299 | 120 | 0.07792207792207792 | 320 | 0.2077922077922078 | 5 | 1.038961038961039
Name 9 | R1006054 | Pathway 3 |  | 0.5 | 770 | 0 | 0 | 0 | 0 | 0 | 0 | 2.5 | 0
Spreadsheet: chris_germany__2928__CES-AGL-Feb00
Sheet: Sonat Supply

 | Sonat  Supply  Details  - -  February  2000
 |  | CES Storage | [NAME] | Destin | Destin
 | Date | SSNG10 | PSNG2194 |  |  | Total
 | 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
 | Total:
Spreadsheet: 865911d1712863033-coordinate-conversion-1900-md-state-plane-coordinate-conversions_bw
Sheet: NAD 1983

Calculations found here: | https://www.ngs.noaa.gov/PUBS_LIB/ManualNOSNGS5.pdf |  |  | DEGREES TO XY |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | XY to Dec. Degrees |  |  |  |  |  |  |  |  | convergence angle | <- same but atan2() | longitude |  |  | latitude
 | DEFINING CONSTANTS |  |  |  |  |  |  |  |  |  |  |  | easting |  | northing |  | grid scale factor |  | X(ft)E | X(m)E | Y(ft)N | Y(m)N |  | N' | E' | R' | ϒ |  | ʎ | u | ΔΦ | Φ | k
southern standard parallel | 38.3 | Bs (Φs) |  | Meters per foot | Φ (Lat) | ʎ (Long) | ΔΦ | u | R | ϒ | E' | N' | E' | ft | N | ft | k |  | 13123333.333333 |  | 60699.489022
northern standard parallel | 39.45 | Bn (Φn) |  | 0.3048 | 37.83333333 | 77 |  |  |  |  |  |  |  |  |  |  |  |  | 180946.631 |  | 87497.057
latitude of | 37.66666666666666 | Bb (Φb) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1880554.15 |  | 754125.606
Central median, longitude of the true and grid origin | 77 | [NAME] (ʎo)
The northing value for Φb at the central meridian (grid origin). Sometimes idenified as [NAME] | 0:00:00 | Nb
The easting value at the central meridian ʎo. Sometimes identified as [NAME] | 4000000 | Eo
 | COMPUTED CONSTANTS
Central parallel, the latitude of the true projection origin | 38.8757880051 | Bo (Φo)
 |  | SinBo
Mapping radius at latitude Φb | 8055622.7373 | Rb
Mapping radius at latitude Φo | 7921405.1556 | Ro
Northing value at the intersection of the central meridian with the central parallel (the true projection origin) | 134217.5816 | No
Mapping radius at the Equator | 12551136.6396 | K
Grid scale factor at the central parallel Φo | 0.999494847842 | [NAME]
Scaled radius of curvature in the meridian at Bo | 6360263.7936 | Mo
Geometric mean radius of curvature at Bo scaled to the grid | 6373240 | ro
 | COEFICIENTS FOR GP to PC
 | 111007.5442 | L(1)
 | 9.5313 | L(2)
 | 5.63889 | L(3)
 | 0.019736 | L(4)
 |  | L(5)
 | COEFICIENTS FOR PC to GP
 | 9.00839671e-06 | G(1)
 | -6.96769e-15 | G(2)
 | 3.71144e-20 | G(3)
 | -1.0352e-27 | G(4)
 | COEFICIENTS FOR GRID SCALE FACTOR
 | 0.999949847842 | F(1)
 | 1.231e-14 | F(2)
 | 5.09e-22 | F(3)
Grid scale factor of a general point |  | k
Grid scale factor of a line (between point 1 and point 2) |  | [NAME]
Convergence angle |  | ϒ ©
Arc-to-chord or second-term correction |  | delta (t-T)
Mapping radius at latitude Φ |  | R
Isometric latitude |  | Q
Semimajor axis of the geodetic ellipsoid |  | a
Semiminor axis of the geodetic ellipsoid |  | b
Flattening of the geodetic ellipsoid (a-b)/a |  | f
First eccentricity of the ellipsoid (2f-f^2)^1/2 |  | e
Spreadsheet: b1188505-f34c-45de-b243-89c85f656292
Sheet: CDF 2014

APPENDIX C: Club Development Fund 2014 Application
Club Name:
Management, commercial and marketing services |  |  |  |  |  | £
Employment costs of |  |  |  |  |  |  |  | Explanatory Notes / Comment
1. General/Business Development Manager
2. Match Promotion/Marketing Officer
3. Player Ambassador
Other costs
4. Marketing materials and promotional activity
5. Other administrative and marketing expenditure
Total
For items under 1-3 please enter annual total employment costs, which reflect the £12.5k plus an explanation of the match funding and any further amounts allocated to this role.
For items under 4 & 5 please provide a further breakdown.
Coaching, medical and other football-related support services |  |  |  |  |  | £
Employment costs of |  |  |  |  |  |  |  | Explanatory Notes / Comment
1. Head Coach
2. Assistant Coach
3. Goalkeeping Coach
4. Chartered Physiotherapist
5. Doctor
Other Costs
6. Reserve Team
7. Other coaching, medical or football-related staff
8. Other coaching, medical or football-related services
Total
For items under 1-5 please enter total annual employment costs, or contract costs where the service is provided by an external organisation.
For items under 6-8 please provide explanatory notes.
Facilities |  |  |  |  |  | £
 |  |  |  |  |  |  |  | Explanatory Notes / Comment
1. Annual cost of hiring home ground
2. Annual maintenance costs of playing facilities
3. Annual cost of training facilities
Total
Total Club Development Fund
Spreadsheet: 171981d1343936311-mark-date-with-x-when-name-entered-workroster
Sheet: team

 | date | 2012-08-02 00:00:00
team 1 | team 2 | team 3 | team 4
piet |  | koos | koos
koos |  |  |  |  | as soon as I manually enter the name here it must mark a x or what ever next to his name, next column with each date
 | [NAME] | [NAME] | [NAME]
[NAME]
 | date | 2012-08-03 00:00:00
team 1 | team 2 | team 3 | team 4
piet | Jan | George
Spreadsheet: 759705d1639670808-countifs-between-2-columns-with-multiple-criteria-where-1-column-takes-priority-in-other-countifs-2-different-columns-with-multiple-criteria-dynamic-array
Sheet: Sheet1

 |  |  |  | 2022 | 2021 | 2020 |  | Budget Date |  | 2022
Region | Product Type | Product | Override Date | Budget Date | Budget Date | Budget Date
South | REG | B |  | 2023-02-13 00:00:00 |  | 2023-04-05 00:00:00 |  |  |  | 2022 | 2023 | 2024 |  |  | Dynamic Array
South | SP | D | 2022-08-01 00:00:00 | 2021-12-12 00:00:00 | 2021-05-13 00:00:00 | 2023-12-06 00:00:00 |  |  | 1 | 1 | 3 | 2
South | CST | A | 2024-01-15 00:00:00 | 2023-07-12 00:00:00 |  |  |  | A | 0 | 1 | 1 | 1
East | PRE | E |  |  | 2023-06-11 00:00:00 | 2024-12-03 00:00:00 |  | B | 0 | 0 | 1 | 0
South | REG | A |  | 2023-04-09 00:00:00 |  | 2023-02-11 00:00:00 |  | C | 0 | 0 | 0 | 0
East | SP | C |  | 2023-11-03 00:00:00 | 2023-04-05 00:00:00 |  |  | D | 0 | 1 | 0 | 0
South | SP | B |  | 2024-10-15 00:00:00 |  | 2021-08-14 00:00:00 |  | E | 1 | 0 | 0 | 0
North | CST | E |  | 2021-12-08 00:00:00 | 2021-02-11 00:00:00 | 2022-01-06 00:00:00 |  | Total | 2 | 3 | 5 | 3
South | SP | B |  | 2021-02-13 00:00:00
North | REG | A |  | 2022-01-17 00:00:00 | 2022-01-01 00:00:00 | 2024-02-01 00:00:00
East | SP | E |  | 2023-12-20 00:00:00 |  | 2021-02-10 00:00:00
East | SP | D |  | 2023-05-04 00:00:00 | 2021-05-09 00:00:00
South | CST | D |  | 2022-01-10 00:00:00 |  | 2023-03-01 00:00:00
East | SP | B |  | 2024-08-15 00:00:00 | 2023-02-08 00:00:00 | 2021-10-11 00:00:00 |  | Dynamic Array |  | Desired Result Count but in [NAME] based on I4# and J3#
East | PRE | C |  |  |  | 2024-12-04 00:00:00
Spreadsheet: 231275d1366991707-self-input-tine-sheet-weekly-lpl_lpm-schedules
Sheet: output from forms placed here

 |  | SHC Loss Prevention *Manager/Leads | change date of sheet to week of |  |  | Weekly [NAME]
 |  | *LPM/LPL |  |  |  |  |  | Week of
LP | District 161 | WEEK OF | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Phone | Unit Number/Store |  | 2013-04-21 00:00:00 | 2013-04-21 00:00:00 | 2013-04-21 00:00:00 | 2013-04-21 00:00:00 | 2013-04-21 00:00:00 | 2013-04-21 00:00:00
[PHONE] | 1162 Amherst | *[NAME] | off | 2013-12-09 00:00:00 | 2013-09-06 00:00:00 | off | 2013-12-09 00:00:00 | 2013-09-06 00:00:00 | 2013-12-09 00:00:00
[PHONE] | 1504 Williamsville | [NAME]
[PHONE] | 1514 [NAME] | [NAME] | 9-5 | 9-5 | 12-8 | OFF | 9-5 | OFF | 2013-12-09 00:00:00
[PHONE] | 1524 Greece | *[NAME]
[PHONE] | 1584 Victor | [NAME]
[PHONE] | 1894 Henrietta | *[NAME] | VAC | VAC | VAC | VAC | VAC | VAC | VAC
[PHONE] | 1984 Hamburg | *[NAME]
[PHONE] | 2003 Irondequoit | *Jessica Foote
[PHONE] | 2134 Cheektowaga | *[NAME]
[PHONE] | 1353 Dewitt | *[NAME] | 12-7:30 | 1-9:30 | - | 1-9:30 | - | 1-9:30 | 1-9:30
[PHONE] | 1623 Clay | [NAME] | 2013-10-07 00:00:00 | 1-930 | 830-530 | OFF | OFF | 830-515 | 1-930
[PHONE] | 2007 Auburn | [NAME]
[PHONE] | 2564 Ithaca | NO LP store | n/a | n/a | n/a | n/a | n/a | n/a | n/a
[PHONE] | 2744 Horseheads | *Chase Turner
 | CAPS = PA Store | *=Salaried LP MGR | North East |  |  |  | 161
 | [NAME] |  | Joel (Joel) Gordon |  |  | [NAME]
 | (716) 830-0073 |  | (732) 300-9895 |  |  | [PHONE]
 | Passcode 830-0073 |  | Passcode 300-9895 |  |  | 7309198
Spreadsheet: 690108d1596875385-using-countifs-over-muttiple-colums-using-countifs-over-muttiple-colums
Sheet: Sheet1

Type 1 | type 2 | type 3 | type 4 | dates |  |  |  | Expected result |  |  |  |  | RESULT
Cat |  |  |  | 1 |  |  |  | How many CAT in A:D where column E is <3 |  |  |  |  | 4 | 4
Cat | Cow | Dog | Horse | 1 |  |  |  | How many CAT in A:D where column E is =>3=<6 |  |  |  |  | 4 | 4
Cat |  |  |  | 1 |  |  |  | How many COW in A:D where column E is <3 |  |  |  |  | 1 | 1
Cat | Dog |  |  | 2 |  |  |  | How many COW in A:D where column E is =>3=<6 |  |  |  |  | 5 | 5
Dog |  |  |  | 2 |  |  |  | How many DOG in A:D where column E is <3 |  |  |  |  | 3 | 3
Cow |  |  |  | 3 |  |  |  | How many DOG in A:D where column E is =>3=<6 |  |  |  |  | 5 | 5
Dog | Cow | Horse |  | 3 |  |  |  | How many HORSE in A:D where column E is <3 |  |  |  |  | 1 | 1
Horse |  |  |  | 4 |  |  |  | How many HORSE in A:D where column E is =>3=<6 |  |  |  |  | 5 | 5
Cat |  |  |  | 4
Cat | Cow | Dog | Horse | 4
Cat |  |  |  | 5
Cat | Dog |  |  | 5
Dog |  |  |  | 5
Cow |  |  |  | 5
Dog | Cow | Horse |  | 6
Horse |  |  |  | 6
Spreadsheet: da3cb6bc-87e1-4dd7-b4a1-8ed6b235838d
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Spring Hill Csr | 789042436427 | Decemberadio | Drifter | 2007-03-20 | Distributed CD Trax | Rock | 9.98 | N | To Be Retired
Spreadsheet: 60020d1260538134-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-copy-of-poss-new-budget-planner
Sheet: Loan N'thn Rock

LOAN
MONTH | YEAR | APR | PAYMENT | BALANCE
2008-01-01 00:00:00 | 2008
2008-02-01 00:00:00 | 2008
2008-03-01 00:00:00 | 2008
2008-04-01 00:00:00 | 2008
2008-05-01 00:00:00 | 2008
2008-06-01 00:00:00 | 2008
2008-07-01 00:00:00 | 2008
2008-08-01 00:00:00 | 2008
2008-09-01 00:00:00 | 2008
2008-10-01 00:00:00 | 2008
2008-11-01 00:00:00 | 2008
2008-12-01 00:00:00 | 2008
2009-01-01 00:00:00 | 2009
2009-02-01 00:00:00 | 2009
2009-03-01 00:00:00 | 2009
2009-04-01 00:00:00 | 2009
2009-05-01 00:00:00 | 2009
2009-06-01 00:00:00 | 2009
2009-07-01 00:00:00 | 2009
2009-08-01 00:00:00 | 2009
2009-09-01 00:00:00 | 2009
2009-10-01 00:00:00 | 2009
2009-11-01 00:00:00 | 2009
2009-12-01 00:00:00 | 2009
2010-01-01 00:00:00 | 2010
2010-02-01 00:00:00 | 2010
2010-03-01 00:00:00 | 2010
2010-04-01 00:00:00 | 2010
2010-05-01 00:00:00 | 2010
2010-06-01 00:00:00 | 2010
2010-07-01 00:00:00 | 2010
2010-08-01 00:00:00 | 2010
2010-09-01 00:00:00 | 2010
2010-10-01 00:00:00 | 2010
2010-11-01 00:00:00 | 2010
2010-12-01 00:00:00 | 2010
Spreadsheet: 192200d1352336230-need-help-using-and-understanding-if-function-testing
Sheet: Team (Step 1)

POS | NAME | INJ (?) | OVR | COST |  |  | POS | NAME | INJ (?) | OVR | COST |  |  | POS | NAME | INJ (?) | OVR | COST | [NAME]
QB--1 | [NAME] |  | 98 |  |  |  | LE--1 | Offense |  | 89 |  |  |  | K--1 | [NAME] |  | 87
QB--2 | [NAME] |  | 83 |  |  |  | LE--2 | [NAME] |  | 61 |  |  |  | [NAME]
QB--3 | [NAME] |  | 61 |  |  |  | LE--3 |  |  |  |  |  |  | P--1 | [NAME] |  | 64
QB--4 | Dickhead |  |  |  |  |  | LE--4 |  |  |  |  |  |  | P--2
HB--1 | [NAME] |  | 88 |  |  |  | RE--1 | [NAME] ([NAME]) |  | 78
HB--2 | [NAME] |  | 60 |  |  |  | RE--2 | Akeem Waters |  | 65
HB--3 | [NAME] |  | 61 |  |  |  | RE--3
HB--4 |  |  |  |  |  |  | RE--4
FB--1 | [NAME] |  | 63 |  |  |  | DT--1 | [NAME] |  | 95
FB--2 | [NAME] |  | 62 |  |  |  | DT--2 | [NAME] |  | 66
WR--1 | [NAME] |  | 98 |  |  |  | DT--3 | [NAME] |  | 60
WR--2 | [NAME] |  | 97 |  |  |  | DT--4
WR--3 | [NAME] ([NAME]) |  | 83 |  |  |  | LOLB--1 | [NAME] |  | 89
WR--4 | [NAME] |  | 82 |  |  |  | LOLB--2 | [NAME] |  | 62 |  |  |  | # OF OFFENSIVE PLAYERS
WR--5 | [NAME] |  | 60 |  |  |  | LOLB--3 | AJ Moses |  | 61 |  |  |  | # OF DEFENSIVE PLAYERS
WR--6 | [NAME] |  | 60 |  |  |  | [NAME] |  |  |  |  |  |  | # OF SPEACIAL TEAMS PLAYERS
WR--7
TE--1 | [NAME] |  | 83 |  |  |  | MLB--1 | [NAME] |  | 90 |  |  |  | TOTAL
TE--2 | [NAME] |  | 68 |  |  |  | MLB--2 | [NAME] |  | 89 |  |  |  | ROSTER SPOTS LEFT
TE--3 | WR Wes Stone |  | 62 |  |  |  | MLB--3
LT--1 | [NAME] ([NAME]) |  | 78 |  |  |  | MLB--4 |  |  |  |  |  |  | OFFENSE TOTAL
LT--2 | [NAME] |  | 65 |  |  |  | ROLB--1 | Terrell Scruggs |  | 98 |  |  |  | DEFENSE TOTAL
LT--3 |  |  |  |  |  |  | ROLB--2 | [NAME] |  | 67 |  |  |  | SPC TEAM TOTAL
LG--1 | Lucas Beers ([NAME]) |  | 78 |  |  |  | ROLB--3 | [NAME] |  | 61 |  |  |  | TOTAL
LG--2 |  |  |  |  |  |  | ROLB--4 |  |  |  |  |  |  | Points over/under [NAME]
LG--3 |  |  |  |  |  |  | CB--1 | [NAME] |  | 89
C--1 | [NAME] |  | 85 |  |  |  | CB--2 | Juice Law |  | 98 |  |  |  | "X" in the "INJ (?)" indicates that the player is injured
C--2 |  |  |  |  |  |  | CB--3 | [NAME] |  | 78
C--3 |  |  |  |  |  |  | CB--4 | [NAME] |  | 77 |  |  |  | IF there is a new cap go into cell "S23" and change "1000" to the new cap ONLY
RG--1 | [NAME] |  | 81 |  |  |  | CB--5 | [NAME] |  | 61
[NAME] | [NAME] ([NAME]) |  | 77 |  |  |  | CB--6
RG--3 |  |  |  |  |  |  | CB--7
RG--4 |  |  |  |  |  |  | FS--1 | [NAME] |  | 78
RT--1 | [NAME] |  | 88 |  |  |  | FS--2 | LaMarcus Pierce |  | 66
RT--2 |  |  |  |  |  |  | FS-3
RT--3 |  |  |  |  |  |  | SS--1 | [NAME] |  | 89
 |  |  |  |  |  |  | SS--2 | [NAME] |  | 62
 |  |  |  |  |  |  | SS--3
Spreadsheet: 86d56044-9d78-4e89-9181-0072aee228fd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | Instructivo para calcular la retención de crédito de vivienda Infonavit
 | 1 | Capture el salario minimo que se encuentre vigente para el DF.
 | 2 | Averigue en esos documentos el tipo de retención que se le debe efectuar [NAME], normalmente es VSMDF o porcentaje
 | 3 | Tenga a la mano el aviso de retención que le entregó su trabajador, caso contrario, tenga a la mano  la EBA (Emision bimestral anticipada).
 | 4 | Seleccione de acuerdo con el punto anterior, el valor de la retención (porcentaje o VSMDF)
 | 5 | Capture el valor de la retención.
 | 6 | Capture el SBC (Salario base de cotización del trabajador con crédito de vivienda Infonavit
 | 7 | [NAME] en que paga usted [NAME] (semana, catorcena, quincena, mes).
 | 8 | [NAME] scroll down a la barra vertical de desplazamiento, [NAME] o [NAME] 75%.
 |  | Su apoyo para que la página continúe en línea a través de sus donaciones, son [NAME] [EMAIL]
Spreadsheet: 218257d1362411272-combo-box-linking-problem-comboboxexample
Sheet: Sheet1

Arsenal | yes
[NAME] | yes
Chelsea | yes
Everton | yes
Fulham | yes
Liverpool | no
Man City | yes
Man United | yes
Newcastle | yes
[NAME] | no
QPR | no
Reading | no
Southampton | yes
Stoke | yes
Swansea | yes
Tottenham | yes
West Brom | yes
West Ham | yes
[NAME] | no
Sunderland | yes
Spreadsheet: 550211d1512152474-getting-data-from-different-colums-book1
Sheet: Summary

 |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill |  |  | Produce | Chill
 |  | Under 90% | 19 | 20 |  |  | 6 | 11 |  |  | 7 | 15 |  |  | 10 | 15 |  |  | 5 | 8 |  |  | 4 | 13 |  |  | 6 | 13 |  |  | 7 | 13 |  |  | 9 | 11 |  |  | 11 | 19 |  |  | 7 | 7 |  |  | 7 | 9 |  |  | 7 | 9 |  |  | 11 | 11 |  |  | 6 | 9 |  |  | 12 | 17 |  |  | 6 | 6 |  |  | 4 | 12 |  |  | 1 | 12 |  |  | 6 | 9 |  |  | 6 | 9 |  |  | 10 | 18 |  |  | 7 | 7 |  |  | 9 | 8 |  |  | 5 | 4 |  |  | 8 | 12 |  |  | 8 | 13 |  |  | 8 | 16 |  |  | 4 | 7 |  |  | 6 | 10 |  |  | 6 | 10 |  |  | 7 | 11 |  |  | 8 | 9 |  |  | 11 | 18 |  |  | 7 | 11 |  |  | 7 | 13
 |  | 90 to 100% | 12 | 22 |  |  | 7 | 11 |  |  | 3 | 8 |  |  | 4 | 8 |  |  | 3 | 4 |  |  | 7 | 6 |  |  | 5 | 4 |  |  | 4 | 6 |  |  | 4 | 13 |  |  | 6 | 8 |  |  | 2 | 6 |  |  | 6 | 12 |  |  | 2 | 6 |  |  | 2 | 8 |  |  | 5 | 12 |  |  | 8 | 8 |  |  | 3 | 10 |  |  | 5 | 11 |  |  | 11 | 3 |  |  | 8 | 11 |  |  | 6 | 12 |  |  | 11 | 8 |  |  | 4 | 5 |  |  | 3 | 6 |  |  | 2 | 11 |  |  | 3 | 4 |  |  | 7 | 9 |  |  | 4 | 8 |  |  | 8 | 8 |  |  | 2 | 12 |  |  | 3 | 5 |  |  | 4 | 7 |  |  | 6 | 10 |  |  | 5 | 7 |  |  | 3 | 4 |  |  | 7 | 17
 |  | 100 to 120% | 17 | 26 |  |  | 7 | 16 |  |  | 12 | 11 |  |  | 10 | 22 |  |  | 9 | 9 |  |  | 6 | 14 |  |  | 8 | 9 |  |  | 12 | 11 |  |  | 8 | 12 |  |  | 12 | 23 |  |  | 7 | 8 |  |  | 4 | 11 |  |  | 7 | 7 |  |  | 8 | 13 |  |  | 9 | 14 |  |  | 6 | 22 |  |  | 7 | 7 |  |  | 10 | 13 |  |  | 7 | 5 |  |  | 6 | 13 |  |  | 8 | 11 |  |  | 5 | 17 |  |  | 6 | 8 |  |  | 6 | 18 |  |  | 5 | 12 |  |  | 6 | 13 |  |  | 5 | 12 |  |  | 13 | 15 |  |  | 7 | 9 |  |  | 6 | 12 |  |  | 9 | 7 |  |  | 6 | 9 |  |  | 8 | 11 |  |  | 8 | 19 |  |  | 6 | 8 |  |  | 7 | 8
 |  | Over 120% | 4 | 12 |  |  | 6 | 7 |  |  | 2 | 17 |  |  | 5 | 9 |  |  | 2 | 4 |  |  | 2 | 5 |  |  | 1 | 5 |  |  | 2 | 7 |  |  | 4 | 5 |  |  | 3 | 8 |  |  | 2 | 2 |  |  | 5 | 4 |  |  | 4 | 5 |  |  | 3 | 3 |  |  | 3 | 3 |  |  | 8 | 10 |  |  | 3 | 3 |  |  | 2 | 4 |  |  | 0 | 4 |  |  | 4 | 4 |  |  | 2 | 4 |  |  | 5 | 11 |  |  | 4 | 2 |  |  | 3 | 5 |  |  | 3 | 3 |  |  | 4 | 4 |  |  | 2 | 7 |  |  | 3 | 7 |  |  | 1 | 3 |  |  | 3 | 5 |  |  | 2 | 5 |  |  | 5 | 6 |  |  | 5 | 5 |  |  | 6 | 8 |  |  | 4 | 6 |  |  | 2 | 7
Spreadsheet: 41607d1240147740-comparing-and-deleting-data-in-2-columns-test-data
Sheet: ResultsFiltered&NoDuplicates

UniqueId | ReferenceNo | cardnumber | carddesc | designation | department | LastDoor | SwipeDate
104975 | 3 | 6876 | A Clowes | Treetops |  | 32 Ind St XOver Rr[32] | 2009-02-07 00:00:00
11017 | 3 | 10809 | A Eeles | Emergency Nurse Prac. | Emergency Dept. | 32 Ind St XOver Rr[32] | 2009-01-13 00:00:00
5094 | 3 | 2824 | a.grove  2824 | gardener | Interserve | 3 [NAME] exit (side)[19] | 2009-04-07 00:00:00
3596 | 2 | 596 | a.hughes  596 | porter | Interseve | Barrier out hosp rear | 2009-04-06 00:00:00
This Table show the results from the original 'SwipeDate' in 2009 filter and removal of duplicates