tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 76636d4a-bafb-48d2-a9d9-cbc4bef0653c
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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 | Schedule 2:    Academic Work Load:    Year 2010
 |  | Semester 2: | From |  | To
 |  |  |  |  |  |  |  |  | Lecturing weeks per semester
 | University |  |  |  |  |  |  |  | Faculty
 | Name of the Academic Staff |  |  |  |  | Designation | Lectures |  | Tutorial Assignments |  | Lab/Field/Clinical /Workshop/Drawing |  | Other                   (Please specify) |  | Total
 |  |  |  |  |  |  | Assigned no. of hours | Actual no. of hours | Assigned no. of hours | Actual no. of hours | Assigned no. of hours | Actual no. of hours | Assigned no. of hours | Actual no. of hours | Assigned no. of hours | Actual no. of hours
 | (including the Temporary Lecturer/Prob. Lecturer/Demonstrator/…………...)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
 | Please return the duly completed schedule to the Head, MIS Division, UGC, 20, Ward Place, Colombo 7.    Tel. 2685184/2678730   Fax: 2685184   E-mail [EMAIL]
Spreadsheet: 67372d1268019894-string-concatenation-of-values-sample-data
Sheet: Output

Group | Subgroup | Members | Section | Status | In-charge | Level | Units
Lopez | A | 1 | Sec A | Completed | [NAME] | Beginner | 12
[NAME] | B | 7 | Sec B | On-going | Siy | Proficient | 13
Martinez | A | 1 | Sec C | Not started | [NAME] | Beginner | 21 |  |  | *Colors not included
Martinez | A | 2 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 3 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 4 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 5 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | A | 6 | Sec C | Not started | [NAME] | Beginner | 21
Martinez | B | 7 | Sec C | Not started | [NAME] | Beginner | 21
[NAME] | A | 1 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 2 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 3 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 4 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 5 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | A | 6 | Sec D | Completed | [NAME] | Beginner | 20
[NAME] | B | 7 | Sec D | Completed | [NAME] | Beginner | 20
Ramos | A | 1 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 2 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 3 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 4 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 5 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 6 | Sec E | Not started | Dy | Beginner | 16
Ramos | A | 7 | Sec E | Not started | Dy | Beginner | 16
Uy | A | 1 | Sec F | On-going | Han | Proficient | 11
Uy | A | 2 | Sec E | On-going | Han | Proficient | 11
Uy | A | 3 | Sec E | On-going | Han | Proficient | 11
Uy | A | 4 | Sec E | On-going | Han | Proficient | 11
Uy | B | 7 | Sec E | On-going | Han | Proficient | 11
Uy | C | 8 | Sec E | On-going | Han | Proficient | 11
[NAME] | B | 7 | Sec G | Started | Niy | Proficient | 13
[NAME] | C | 8 | Sec H | Completed | [NAME] | Proficient | 11
Spreadsheet: 81180d1281443935-copy-text-from-one-sheet-to-another-using-macro-request-form-template2
Sheet: September

 |  |  |  | Date | 2010-08-10 12:26:51 |  | September Total Hours
 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Percentage
 | Year | Month | Date | Hours | Total Hours |  |  | Total Hours |  |  | 240 | 100
 | 2010 | September | 2010-09-01 00:00:00 | 0 | 0 |  |  | Total Hours Requested |  |  | 0 | 0
 |  |  | 2010-09-02 00:00:00 | 0 |  |  |  | Hours Not Requested |  |  | 240 | 100
 |  |  | 2010-09-03 00:00:00 | 0 |  |  |  |  |  |  |  |  |  | Key
 |  |  | 2010-09-04 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Hours Requested
 |  |  | 2010-09-05 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Left Over Hours
 |  |  | 2010-09-06 00:00:00 | 0
 |  |  | 2010-09-07 00:00:00 | 0
 |  |  | 2010-09-08 00:00:00 | 0
 |  |  | 2010-09-09 00:00:00 | 0
 |  |  | 2010-09-10 00:00:00 | 0
 |  |  | 2010-09-11 00:00:00 | 0
 |  |  | 2010-09-12 00:00:00 | 0
 |  |  | 2010-09-13 00:00:00 | 0
 |  |  | 2010-09-14 00:00:00 | 0
 |  |  | 2010-09-15 00:00:00 | 0
 |  |  | 2010-09-16 00:00:00 | 0
 |  |  | 2010-09-17 00:00:00 | 0
 |  |  | 2010-09-18 00:00:00 | 0
 |  |  | 2010-09-19 00:00:00 | 0
 |  |  | 2010-09-20 00:00:00 | 0
 |  |  | 2010-09-21 00:00:00 | 0
 |  |  | 2010-09-22 00:00:00 | 0
 |  |  | 2010-09-23 00:00:00 | 0
 |  |  | 2010-09-24 00:00:00 | 0
 |  |  | 2010-09-25 00:00:00 | 0
 |  |  | 2010-09-26 00:00:00 | 0
 |  |  | 2010-09-27 00:00:00 | 0
 |  |  | 2010-09-28 00:00:00 | 0
 |  |  | 2010-09-29 00:00:00 | 0
 |  |  | 2010-09-30 00:00:00 | 0
Spreadsheet: 142929d1330093007-excel-2007-duration-between-two-dates-in-month-week-and-days-durations
Sheet: Sheet1

Start | End | Days | Duration
2011-12-19 00:00:00 |  | 40
2012-01-07 00:00:00 |  | 33
2012-01-07 00:00:00 |  | 31
2012-01-10 00:00:00 |  | 37
2012-01-12 00:00:00 |  | 14
2011-12-01 00:00:00 |  | 91
2012-02-01 00:00:00 |  | 3
2012-02-02 00:00:00 |  | 9
Spreadsheet: 28474d1222767355-ranking-data-sales
Sheet: Sheet2

Sales Rep | Application Value | [NAME] | MPPI | HC
[NAME] | 250 | 2-Sep | BA | BA
[NAME] | 100 | 2 Sep | TA | TA
[NAME] | 600 | 3 Sep |  | JA
[NAME] | 520 | 4 Sep
[NAME] | 120 | 5 Sep | MA | MA
[NAME] A | 328 | 6 Sep | SA
[NAME] | 300 | 7 Sep |  | BA
[NAME] | 278 | 8 Sep
[NAME] | 956 | 9 Sep | JA
[NAME] | 756 | 10 Sep |  | MA
[NAME] | 300 | 11 Sep | TA
[NAME] | 550 | 12 Sep |  | TA
[NAME] | 100 | 13 Sep | BA
[NAME] | 500 | 14 Sep | BA
[NAME] | 63 | 15-Sep | TA | TA
[NAME] A | 2000 | 14-sep | SA | SA
 |  |  |  |  |  | Advisor | [NAME] | [NAME] | [NAME] | Apps on MLD | Apps Received Target | [NAME] | Total Value of apps received | MPPI Sales | MPPI Conversion | MPPI Target | HC sales | HC Conversion | HC Target
 |  |  |  |  |  | [NAME] |  | 10 | 4 | 4 | 5 | 0.8 | 1150 | 3 | 0.75 | 0.5 | 2 | 0.5 | 0.45
 |  |  |  |  |  | [NAME] |  | 10 | 3 | 3 | 5 | 0.6 | 1834 | 1 | 0.3333333333333333 | 0.5 | 1 | 0.3333333333333333 | 0.45
 |  |  |  |  |  | [NAME] |  | 10 | 2 | 2 | 5 | 0.4 | 876 | 1 | 0.5 | 0.5 | 2 | 1 | 0.45
 |  |  |  |  |  | [NAME] A |  | 10 | 2 | 2 | 5 | 0.4 | 2328 | 2 | 1 | 0.5 | 1 | 0.5 | 0.45
 |  |  |  |  |  | [NAME] |  | 10 | 5 | 5 | 5 | 1 | 1533 | 3 | 0.6 | 0.5 | 3 | 0.6 | 0.45
 |  |  |  |  |  | Total | 0 | 50 | 16 | 16 | 25 | 0.6399999999999999 | 7721 | 10 | 0.6366666666666666 |  | 9 | 0.5866666666666667
 |  |  |  |  |  | Highest MPPI Conversion
 |  |  |  |  |  | Highest HC Conversion
 |  |  |  |  |  | Highest Apps Conversion
Spreadsheet: 700306d1603122431-count-consecutive-cells-in-reverse-above-value-test2
Sheet: week2

ID | Student | Grade | Total Full-Day Attended | Periods Present (P) | [NAME]  (PND) | [NAME]  (SKP) | Periods Family Activity  (FAM) | Periods Employment  (EMP) | Periods Transportation  (TRA) | Periods Medical Unexcused  (MDU) | Periods Medical Excused  (MDE) | Periods Family Emergency  (EME) | Periods Legal or Judicial Requirement  (LEG) | [NAME] Activity Excused  (ACE) | Periods Religious Observance  (REL) | Periods Present/Absent (PAA) | [NAME] (DIS) | Periods School Function (SCF) | [NAME] (RLC) | Periods Intervention (INT) | [NAME] (EEX) | Periods Made up Class (MUC) | [NAME] (TAR) | Periods Bus Tardy (BTR) | Periods Excused Tardy (EXT) | [NAME] (XTR) | Periods Unexcused Tardy (ATR) | Periods NovaNet (NOV) | Periods Office (OFF) | Periods Early Release (ERL) | Periods Early Release Excused (ERX) | [NAME] (ABS) | Periods Quarantine Present (QP) | Periods Quarantine Absent (QA) | Total Periods Missed
1
2
3
4
5
6
7
8
9
Spreadsheet: 121474d1316090793-how-to-use-multiple-autofilters-nhl94-player-ratings
Sheet: Tampa Bay

Lightning]
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | Stick Lt | [NAME] | Glove Lt
G | Wendell Young | L | 1 | 188 | 55 | 55 | 45 | 45 | 55 | 25 | 25 | 25 | 55 | 45 | 55 | 55
G | [NAME] | R | 35 | 180 | 45 | 55 | 45 | 45 | 45 | 25 | 25 | 25 | 45 | 45 | 45 | 45
G | J.C. Bergeron | L | 30 | 196 | 45 | 55 | 45 | 45 | 45 | 25 | 25 | 25 | 35 | 35 | 35 | 35
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
C | [NAME] | R | 19 | 172 | 65 | 55 | 65 | 55 | 65 | 55 | 55 | 85 | 65 | 45 | 55 | 55
C | [NAME] | L | 10 | 220 | 55 | 45 | 55 | 45 | 45 | 55 | 45 | 45 | 55 | 65 | 55 | 55
C | [NAME] | R | 17 | 188 | 45 | 45 | 55 | 55 | 45 | 35 | 45 | 65 | 45 | 45 | 35 | 45
C | [NAME] | L | 11 | 180 | 55 | 55 | 35 | 55 | 45 | 65 | 55 | 55 | 55 | 45 | 55 | 35
LW | [NAME] | L | 7 | 212 | 45 | 55 | 55 | 45 | 45 | 55 | 55 | 45 | 55 | 55 | 45 | 45
LW | [NAME] | R | 14 | 212 | 45 | 55 | 55 | 55 | 55 | 45 | 55 | 45 | 55 | 45 | 55 | 55
LW | [NAME] | L | 34 | 188 | 45 | 65 | 45 | 55 | 45 | 35 | 55 | 45 | 65 | 85 | 55 | 25
LW | [NAME] | L | 37 | 220 | 45 | 45 | 45 | 55 | 45 | 55 | 45 | 35 | 55 | 65 | 45 | 45
RW | [NAME] | L | 16 | 204 | 55 | 55 | 65 | 55 | 55 | 55 | 55 | 85 | 65 | 55 | 55 | 25
RW | Marc Bureau | R | 28 | 196 | 55 | 55 | 55 | 55 | 45 | 45 | 55 | 45 | 55 | 55 | 45 | 65
RW | [NAME] | R | 18 | 180 | 45 | 55 | 55 | 55 | 45 | 45 | 45 | 45 | 55 | 45 | 45 | 55
RW | [NAME] | R | 24 | 196 | 55 | 55 | 55 | 55 | 45 | 45 | 45 | 45 | 55 | 65 | 45 | 35
RW | [NAME] | R | 21 | 204 | 45 | 45 | 35 | 55 | 45 | 45 | 45 | 35 | 55 | 85 | 45 | 45
RW | [NAME] | R | 27 | 196 | 35 | 45 | 35 | 25 | 45 | 45 | 35 | 45 | 25 | 85 | 35 | 45
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
D | [NAME] | L | 44 | 196 | 55 | 45 | 45 | 55 | 55 | 45 | 55 | 35 | 55 | 65 | 45 | 55
D | [NAME] | L | 22 | 212 | 45 | 45 | 55 | 55 | 45 | 45 | 45 | 35 | 55 | 45 | 45 | 45
D | [NAME] | L | 25 | 188 | 45 | 45 | 45 | 45 | 55 | 55 | 45 | 25 | 55 | 55 | 45 | 45
D | [NAME] | L | 29 | 228 | 55 | 45 | 45 | 45 | 55 | 45 | 55 | 25 | 55 | 45 | 45 | 55
D | [NAME] | L | 40 | 188 | 35 | 35 | 45 | 35 | 35 | 25 | 35 | 25 | 35 | 35 | 35 | 65
D | [NAME] | R | 2 | 212 | 55 | 55 | 55 | 55 | 45 | 45 | 45 | 45 | 55 | 55 | 45 | 55
D | [NAME] | R | 26 | 212 | 35 | 35 | 45 | 35 | 35 | 45 | 35 | 25 | 35 | 55 | 25 | 65
Spreadsheet: 204857d1357665930-how-to-obtain-similar-text-values-from-a-data-range-in-the-next-column-heading-problem
Sheet: Sheet1

 | Day | Dates | Calls
 |  | 2013-01-01 00:00:00 | 8
 |  | 2013-01-02 00:00:00 | 75 |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 2013-01-03 00:00:00 | 70
 |  | 2013-01-04 00:00:00 | 72
 |  | 2013-01-05 00:00:00 | 7
 |  | 2013-01-06 00:00:00 | 42
 |  | 2013-01-07 00:00:00 | 29
 |  | 2013-01-08 00:00:00 | 100
 |  | 2013-01-09 00:00:00 | 22
 |  | 2013-01-10 00:00:00 | 71
 |  | 2013-01-11 00:00:00 | 95
 |  | 2013-01-12 00:00:00 | 74
 |  | 2013-01-13 00:00:00 | 30
 |  | 2013-01-14 00:00:00 | 61
 |  | 2013-01-15 00:00:00 | 42
 |  | 2013-01-16 00:00:00 | 95
 |  | 2013-01-17 00:00:00 | 10
 |  | 2013-01-18 00:00:00 | 12
 |  | 2013-01-19 00:00:00 | 57
 |  | 2013-01-20 00:00:00 | 85
 |  | 2013-01-21 00:00:00 | 46
 |  | 2013-01-22 00:00:00 | 29
 |  | 2013-01-23 00:00:00 | 56
 |  | 2013-01-24 00:00:00 | 13
 |  | 2013-01-25 00:00:00 | 60
 |  | 2013-01-26 00:00:00 | 82
 |  | 2013-01-27 00:00:00 | 52
 |  | 2013-01-28 00:00:00 | 18
 |  | 2013-01-29 00:00:00 | 96
 |  | 2013-01-30 00:00:00 | 83
 |  | 2013-01-31 00:00:00 | 34
Spreadsheet: 770272d1645973847-excel-formula-to-produce-balance-sheet-balannce-sheet-2021
Sheet: Trial Balance

 | Trial Balance
 |  | DR | CR
 | School development funds |  | 846341.62
 | Accumulated funds |  | 491809.59
 | Buildings @ Cost | 331833
 | Equipment @ Cost | 206430.88
 | Equipment - Accum Depreciation |  | 56922.58666666667
 | Motor Vehicles | 124400
 | Motor Vehicles - Accum Depreciation |  | 119298.0293389605
 | Furniture @ Cost | 777068.89
 | Furniture - Accum Depreciation |  | 171647.2673333333
 | Receivables | 2868092.2
 | STANBIC USD ACCOUNT | 165135.46
 | NOSTRO US$ | 49071.96
 | CBZ - COLLEGIATE:  [PHONE] | 9775.96
 | Sundry Suppliers |  | 309000
 | Other obligations |  | 172.1
 | Net Surplus / (defict) for the year |  | 2536617.16
Spreadsheet: 92375d1291937311-excel-2007-sumif-problem-example
Sheet: Sheet1

 |  | DATE | PRODUCT | PROFIT |  |  |  | TOTAL
 |  | 2011-01-01 00:00:00 | Aluminium | 200 |  |  | Aluminium
 |  | 2011-01-01 00:00:00 | Aluminium | 201 |  |  | Lead
 |  | 2011-01-01 00:00:00 | Aluminium | 202 |  |  | Brass
 |  | 2011-01-01 00:00:00 | Aluminium | 203 |  |  | Zinc
 |  | 2011-01-01 00:00:00 | Aluminium | 204 |  |  | Iron
 |  | 2011-01-01 00:00:00 | Aluminium | 205 |  |  | S/Steel
 |  | 2011-01-01 00:00:00 | Aluminium | 206
 |  | 2011-01-01 00:00:00 | Aluminium | 207
 |  | 2011-01-01 00:00:00 | Aluminium | 208
 |  | 2011-01-01 00:00:00 | Aluminium | 209
 |  | 2011-01-01 00:00:00 | Aluminium | 210
 |  | 2011-01-01 00:00:00 | Aluminium | 211
 |  | 2011-01-01 00:00:00 | Aluminium | 212
 |  | 2011-01-01 00:00:00 | Aluminium | 213
Spreadsheet: 75867d1276490252-index-and-match-function-return-value-where-is-my-mistake-threepagefields
Sheet: Sheet4

Color | (All)
Size | (All)
Item | (All)
Sum of Amount | Month
Store | Jan | Feb | Mar | Grand Total
Downtown | 245.62 | 102.72 | 226.06 | 574.4000000000001
East End | 114.06 | 131.24 | 100.56 | 345.86 |  | #N/A
Northside | 16.68 | 203.12 | 126.28 | 346.08
South Plaza | 273.8 | 13.98 | 56.63999999999999 | 344.42
Grand Total | 650.16 | 451.0600000000001 | 509.54 | 1610.76
Spreadsheet: 121350d1316007256-return-value-of-first-and-last-occurence-book1
Sheet: Sheet1

Date: | Code 1 | Code 2 | Code 3 | 1066
2011-09-01 00:00:00 | 5154 | 5156 | 5160
2011-09-02 00:00:00 | 5313 | 5224 | 5235
2011-09-03 00:00:00 | 1066 | 2135 | 2378
2011-09-04 00:00:00 | 2090 | 5225 | 1066
2011-09-05 00:00:00 | 5153 | 5156 | 5263
2011-09-06 00:00:00 | 5227 | 5313 | 5233
2011-09-07 00:00:00 | 1066 | 2090 | 2135
2011-09-08 00:00:00 | 1066 | 2075 | 2280
Spreadsheet: 771017d1646388954-convert-list-into-calculation-sample-workbook-2
Sheet: summary export

 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028
product A
product B
product C
product D
product E
Spreadsheet: 770279d1645976455-trim-text-some-from-sentence-score-card-by-trim
Sheet: Sheet1

In round 1 Wellington Jighere, (replying) played Ebomah Peter and lost 383 - 446, a difference of -63. Wellington Jighere is ranked 11th with 0 points and a cumulative spread of -63
In round [NAME], (starting) played [NAME] and won 510 - 335, a difference of 175. Wellington Jighere is ranked 3rd with 1 points and a cumulative spread of 112
In round 3 Wellington Jighere, (replying) played [NAME] and won 497 - 356, a difference of 141. Wellington Jighere is ranked 2nd with 2 points and a cumulative spread of 253
In round 4 Wellington Jighere, (starting) played Idahosa Bright and won 519 - 379, a difference of 140. Wellington Jighere is ranked 1st with 3 points and a cumulative spread of 393
In round 5 Wellington Jighere, (replying) played Olaribigbe Hakeem and won 496 - 389, a difference of 107. Wellington Jighere is ranked 1st with 4 points and a cumulative spread of 500
In round 6 Wellington Jighere, (starting) played Ogbonyomi Friday and won 502 - 323, a difference of 179. Wellington Jighere is ranked 1st with 5 points and a cumulative spread of 679
In round 7 Wellington Jighere, (replying) played [NAME] and lost 447 - 478, a difference of -31. Wellington Jighere is ranked 1st with 5 points and a cumulative spread of 648
In round 8 Wellington Jighere, (starting) played [NAME] and won 447 - 411, a difference of 36. Wellington Jighere is ranked 1st with 6 points and a cumulative spread of 684
In round 9 Wellington Jighere, (starting) played [NAME] and lost 373 - 457, a difference of -84. Wellington Jighere is ranked 1st with 6 points and a cumulative spread of 600
In round 10 Wellington Jighere, (replying) played Eta Karo and lost 404 - 405, a difference of -1. Wellington Jighere is ranked 4th with 6 points and a cumulative spread of 599
In round 11 Wellington Jighere, (starting) played [NAME] and won 447 - 374, a difference of 73. Wellington Jighere is ranked 2nd with 7 points and a cumulative spread of 672
In round 12 Wellington Jighere, (replying) played [NAME] and lost 370 - 433, a difference of -63. Wellington Jighere is ranked 5th with 7 points and a cumulative spread of 609
In round 13 Wellington Jighere, (starting) played Olaribigbe Hakeem and won 581 - 319, a difference of 262. Wellington Jighere is ranked 4th with 8 points and a cumulative spread of 871
In round 14 Wellington Jighere, (replying) played [NAME] and won 512 - 347, a difference of 165. Wellington Jighere is ranked 2nd with 9 points and a cumulative spread of 1036
Spreadsheet: andy_zipper__716__10_10_01LO3
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | 23 | 133 | 143 | 52.3 | 56.3 | 0.79 | 2001-10-10 10:46:00
 | CL Z1 | 23 | 295 | 305 | 52.1 | 53.9 | 0.77 | 2001-10-10 10:46:00
 | CL F2 | 23 | 370 | 390 | 48.2 | 50.8 | 0.72 | 2001-10-10 10:46:00
 | CL G2 | 23.5 | 435 | 450 | 45.3 | 46.9 | 0.68 | 2001-10-10 10:46:00
 | CL H2 | 23.5 | 470 | 485 | 43.2 | 44.6 | 0.65 | 2001-10-10 10:46:00
 | CL J2 | 23.5 | 490 | 505 | 40.8 | 42 | 0.61 | 2001-10-10 10:46:00
 | CL K2 | 23.5 | 500 | 520 | 38 | 39.5 | 0.57 | 2001-10-10 10:46:00
 | CL M2 | 23.5 | 515 | 530 | 36.6 | 37.6 | 0.55 | 2001-10-10 10:46:00
 | CL N2 | 23.5 | 520 | 540 | 34.6 | 35.9 | 0.52 | 2001-10-10 10:46:00
 | CL Q2 | 23.5 | 520 | 540 | 32.8 | 34.1 | 0.49 | 2001-10-10 10:46:00
 | CL U2 | 23 | 525 | 545 | 32.4 | 33.6 | 0.48 | 2001-10-10 10:46:00
 | [NAME] | 23 | 525 | 545 | 30.9 | 32.1 | 0.46 | 2001-10-10 10:46:00
 | [NAME] | 22.5 | 520 | 550 | 29.1 | 30.8 | 0.42 | 2001-10-10 10:46:00
 | CL M3 | 22 | 525 | 555 | 25.7 | 27.1 | 0.37 | 2001-10-10 10:46:00
 | CL Z3 | 21.5 | 530 | 570 | 23.7 | 25.5 | 0.33 | 2001-10-10 10:46:00
Spreadsheet: 220835d1363277403-how-to-determine-if-multiple-cells-contain-identical-text-but-ignore-the-blanks-excel-issue-sample-2
Sheet: Sheet1

Week 1 | Date 1 | Week 2 | Date 2 | Week 3 | Date 3 | Week 4 | Date 4 | Week 5 | Date 5 |  | Result Should Be:
AN | 2012-11-22 00:00:00 | LM | 2012-11-22 00:00:00 | LM | 2012-11-22 00:00:00 | LM | 2012-11-22 00:00:00 |  |  |  | No
AN | 2012-10-11 00:00:00 |  |  | AN | 2012-10-11 00:00:00 | AN | 2012-10-11 00:00:00 | AN | 2012-10-11 00:00:00 |  | Yes
LM | 2012-12-31 00:00:00 | LM | 2012-12-31 00:00:00 | LM | 2012-12-31 00:00:00 | LM | 2012-12-31 00:00:00 | LM | 2012-12-31 00:00:00 |  | Yes
RS | 2012-10-14 00:00:00 | AN | 2012-10-14 00:00:00 | LM | 2012-10-14 00:00:00 | LM | 2012-10-14 00:00:00 | LM | 2012-10-14 00:00:00 |  | No
RS | 2012-11-25 00:00:00 |  |  |  |  |  |  | RS | 2012-11-25 00:00:00 |  | Yes
Spreadsheet: 125114d1318881408-summarizing-for-pivot-table-copy-of-testdatals_v2
Sheet: Sheet3

Category | Username | Average of Hrs/User
Development | [NAME] | 1
 | Rlake | 1
Development Total |  | 1
Leadership | Jfrank | 4
 | Msmith | 1
 | Rspring | 5
Leadership Total |  | 3.333333333333333
Service | [NAME] | 8
 | Plaird | 25
Service Total |  | 16.5
Grand Total |  | 6.428571428571429
Spreadsheet: 106811d1303991934-generation-of-data-in-sheet-2-workassignments
Sheet: Sheet1

Task No. | Name |  |  |  |  |  |  |  |  | A
1213 | A |  |  |  |  |  |  |  |  | B
1214 | A |  |  |  |  |  |  |  |  | C
1215 | A |  |  |  |  |  |  |  |  | D
1216 | D |  |  |  |  |  |  |  |  | E
1217 | D |  |  |  |  |  |  |  |  | F
1218 | D
1219 | E
1220 | E
1221 | E
2113 | B
3110 | C
Spreadsheet: 377685d1424118963-need-help-with-sorting-and-making-multiple-rows-into-column-column-to-rows-ndmv2
Sheet: Sheet1

 |  | Who | Date | Received | Total |  | Who | Date | Total
eBay. - Rare Honey Artwear Paymet received |  |  |  |  |  |  | eBay - Dehia OMER Payment received | 2014-12-30 00:00:00 | 13.95
2014-12-31 00:00:00 |  |  |  |  |  |  |  | 2015-12-30 00:00:00 | 13.95
dBay - Rare Honey Artwear Payment received |  |  |  |  |  |  | eBay - Dehia OMER Payment received Total |  | 27.9
15.02 |  |  |  |  |  |  | eBay - Evelyn Lowe Payment received | 2015-12-31 00:00:00 | 24.57
eBay. -Kayla [NAME] received |  |  |  |  |  |  |  | 2014-12-31 00:00:00 | 24.57
2014-12-31 00:00:00 |  |  |  |  |  |  | eBay - Evelyn Lowe Payment received Total |  | 49.14
eBay - Kayla Patterson Payment received |  |  |  |  |  |  | eBay. - Rare Honey Artwear Paymet received | 2015-12-31 00:00:00 | 15.02
26.53 |  |  |  |  |  |  |  | 2014-12-31 00:00:00 | 15.02
eBay - Evelyn Lowe Payment received |  |  |  |  |  |  | eBay. - Rare Honey Artwear Paymet received Total |  | 30.04
2014-12-31 00:00:00 |  |  |  |  |  |  | eBay. -Kayla [NAME] received | 2015-12-31 00:00:00 | 26.53
eBay - Evelyn Lowe Payment received |  |  |  |  |  |  |  | 2014-12-31 00:00:00 | 26.53
24.57 |  |  |  |  |  |  | eBay. -Kayla [NAME] received Total |  | 53.06
eBay - Dehia OMER Payment received |  |  |  |  |  |  | Grand Total |  | 160.14
2014-12-30 00:00:00
eBay - Dehia OMER Payment received
13.95
eBay. - Rare Honey Artwear Paymet received
2015-12-31 00:00:00
dBay - Rare Honey Artwear Payment received
15.02
eBay. -Kayla [NAME] received
2015-12-31 00:00:00
eBay - Kayla Patterson Payment received
26.53
eBay - Evelyn Lowe Payment received
2015-12-31 00:00:00
eBay - Evelyn Lowe Payment received
24.57
eBay - Dehia OMER Payment received
2015-12-30 00:00:00
eBay - Dehia OMER Payment received
13.95
Spreadsheet: 140375d1328724204-populate-items-in-a-list-while-removing-them-from-another-list-stock-in-out
Sheet: Sheet3

ItemID | Master List | 0 | 0
1 | Eggs | Eggs-0 | 0
2 | Bread | Bread-1 | 1
3 | Cheese | Cheese-0 | 1
4 | Meat | Meat-1 | 2
5 | Fruit | Fruit-0 | 2
Spreadsheet: 197086d1354207821-index-or-sumproduct-for-date-index_date_issue
Sheet: Sheet1

 |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 |  | Week 1 | Jan 2-8 | Feb 6-12 | [NAME] | Apr 2-8 | May 7-13 | [NAME] | July 2-8 | Aug 6-12 | Sep 3-9 | Oct 1-7 | Nov 5-11 | Dec 3-9
 |  | Week 2 | Jan 9-15 | Feb 13-19 | [NAME] | Apr 9-15 | May 14-20 | [NAME] | July 10-15 | Aug 13-19 | Sep 10-16 | Oct 8-14 | Nov 12-18 | Dec 10-16
 |  | Week 3 | Jan 16-22 | Feb 20-26 | [NAME] | Apr 16-22 | May 21-27 | [NAME] | July 16-22 | Aug 20-26 | Sep 17-23 | Oct 15-21 | Nov 19-25 | Dec 17-23
 |  | Week 4 | Jan 23-29 | Feb 27-Mar 4 | [NAME] | Apr 23-29 | May 28-Jun 3 | Jun 25-July1 | July 23-29 | Aug 27-Sep 2 | Sep 24-30 | Oct 22-28 | Nov 26-Dec 2 | Dec 24-30
 |  | Week 5 | Jan 30-Feb 5 |  |  | Apr 30-May 6 |  |  | July 30-Aug 5 |  |  | Oct 29-Nov 4
 |  | Purchased | 2012-01-15 00:00:00
 |  | Commission date |  | (commission paid on 28th day from purchase date)
 |  | Falls between | Feb 6-12 | < need formula that will select the correct time frame the date in D14 falls under
Spreadsheet: 93986d1293751175-pick-up-first-number-in-a-given-row-in-an-array-vlookup-sample_workbook_sfro
Sheet: Data_indicator

Country | Gini coefficient (0 = Absolute equality, 100 = Absolute inequality), latest data
Chile
Colombia
Madagascar
Mexico
Panama
Brazil
Turkey
Ireland
Argentina
Trinidad and Tobago
Ecuador
[NAME] and [NAME]
Germany
Switzerland
Uruguay
Honduras
El Salvador
Sweden
Venezuela
Guatemala
Jamaica
Georgia
Tanzania
Rwanda