tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 37940d1236050276-pulling-out-1-2-char-strings-into-other-columns-book1_mar2
Sheet: Sheet1

 | Jarrett [NAME], Ind PG PG | PG
 | [NAME], NY SG SG | SG
 | [NAME], Cha SF, PF SF PF | SF | PF
 | [NAME], Min PF PF | PF
 | [NAME], [NAME] C | C
 | [NAME], Cha PG PG | PG
 | Peja [NAME], Nor SF SF | SF
 | [NAME], NY PG PG | PG
 | [NAME], Phi SG, SF SG SF | SF | SG
 | [NAME], Cha PG PG | PG
 | [NAME], Ind SF SF | SF
 | [NAME], SA SG SG | SG
 | [NAME], Tor SF, PF, C SF PF | SF | C | PF
 | [NAME], Cle PF, C PF | C | PF
 | Ronny Turiaf, GS PF, C PF | C | PF
 | [NAME], Por PG PG | PG
 | [NAME], [NAME], SF SG SF | SF | SG
Spreadsheet: john_lavorato__16504__FundTrades
Sheet: CBK

Christiania Bank - David Nahor
 |  |  |  |  |  | Spread/
 | Type | Name | Contracts | Buy/Sell | Month | Future | Call | Strike | Put | Strike | Premium | Origination | $ Origination | Comments
2000-05-12 00:00:00 | NG | CBK | 198 | Sell | 2000-02-01 00:00:00 | 3.075 |  |  |  |  |  | 0.0025 |  | Feb01-Dec01 Swap, 18/mth
 |  |  | Sept | Sept |  |  | Oct
 |  | 4.5 | 500 | 0.09 |  |  | 0.195
 |  | 4.75 | 750 | 0.055 |  |  | 0.15
 |  | 5 | 250 | 0.0325 |  |  | 0.1125
 |  |  |  |  |  | 0.195
Spreadsheet: d0a9f028-9e1b-4fc2-8a26-6c32d3d0a0c6
Sheet: Sheet1

created: 09 Thursday May 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
NO | NAMESPACE | VARIABLE | VALUE | LABEL
1 | L | URN | 134832 | Unique Reference Number
2 | L | LA | 928 | Local authority Number
3 | L | ESTAB | 6068 | School number
4 | L | LAESTAB | 9286068 | DfE Number
5 | L | SCHNAME | Alderwood | School name
6 | L | STREET | The Chestnuts | Street
7 | L | LOCALITY | 296 Bedford Road | Locality
8 | L | ADDRESS3 |  | Address
9 | L | TOWN | Rushden | Town
10 | L | POSTCODE | NN10 0SE | Postcode
11 | L | TELNUM | 01933 359861 | Telephone number
12 | L | ICLOSE | Open | Closed school
13 | L | OPENDATE |  | Date school opened since 12th September only
14 | L | CLOSEDATE |  | Date school closed since 12th September only
15 | L | ISNEW |  | New school
16 | L | MINORGROUP | Special School | Type of school/college
17 | L | NFTYPE | Other Independent Special School | School type
18 | L | ISPRIMARY | 1 | Primary
19 | L | ISSECONDARY | 1 | Secondary
20 | L | ISPOST16 | 1 | 16-18
21 | L | AGEL | 8 | Lowest age of entry
22 | L | AGEH | 19 | Highest age of entry
23 | L | GENDER |  | Gender of entry
24 | L | SFGENDER | Mixed | Gender of entry to sixth form
25 | L | RELDENOM | Does not apply | Denomination
26 | L | ADMPOL | Not collected | Current admissions policy
27 | L | NEWACFLAG | 6 | Flag for Academy
28 | [NAME] | URN | 134832 | Unique Reference Number
29 | [NAME] | LA | 928
30 | [NAME] | ESTAB | 6068
31 | [NAME] | [NAME] | 6 | Total number of pupils on roll (all ages)
32 | [NAME] | NORG | 0 | Number of girls on roll
33 | [NAME] | NORB | 6 | Number of boys on roll
34 | [NAME] | PNORG | 0 | Percentage of girls on roll
35 | [NAME] | PNORB | 1 | Percentage of boys on roll
36 | [NAME] | TSENSAP | NP | Number of pupils SEN statement or on School Action Plus
37 | [NAME] | TSENA | NP | Number of pupils on roll with SEN on School Action
38 | [NAME] | PSENSAP | NP | Percentage of pupils with SEN statement or on School Action Plus
39 | [NAME] | PSENA | NP | Percentage of pupils on roll with SEN on School Action
40 | [NAME] | TOTPUPEALDN | NP | Number of pupils of compulsory school age and above
41 | [NAME] | NUMEAL | NP | Number of pupils with English not as first language
42 | [NAME] | NUMUNCFL | NP | Number of pupils where first language is unclassified
43 | [NAME] | PNUMEAL | NP | Percentage of pupils with English not as first language
44 | [NAME] | PNUMUNCFL | NP | % pupils where first language is unclassified
45 | [NAME] | TOTPUPFSMDN | NP | Number of pupils used in FSM calculation
46 | [NAME] | NUMFSM | NP | Total pupils eligible for free school meals
47 | [NAME] | PNUMFSM | NP | Percentage of  pupils eligible for free school meals
48 | [NAME] | NUMFSMEVER | NP | Number of pupils eligible for FSM at any time during the past 6 years
49 | [NAME] | PNUMFSMEVER | NP | Percentage of pupils eligible for FSM at any time during the past 6 years
Spreadsheet: 92080d1291747660-formula-value-from-two-columns-of-ranges-book1
Sheet: Sheet1

OVER | BUT NOT OVER |  | 21254.32
0 | 6050
6050 | 10425 |  | This is the value input by the user (X)
10425 | 36050
36050 | 67700
67700 | 84450 |  |  |  | This is where my formula goes, which in this case should return a value of $10,425
84450 | 87700
87700 | 173900
173900 | 375700
375700
These are the ranges
The value in D1 falls between one of the ranges defined in columns A and B. I want the value of A for that row put into cell F7
Spreadsheet: 800679d1665795508-converting-date-to-a-text-representing-the-week-weekof-question
Sheet: Weekly

Count of WEEKOF | Column Labels
Row Labels | [NAME] | FAILED | CANCELLED | Grand Total
W1 Aug 29 | 126 | 11 | 16 | 153
[NAME] 05 | 157 | 3 | 55 | 215
[NAME] 12 | 238 | 16 | 69 | 323
[NAME] 19 | 163 | 9 | 1 | 173
[NAME] 26 | 337 | 9 | 1 | 347
[NAME] | 400 | 37 | 135 | 572
Grand Total | 1421 | 85 | 277 | 1783
Spreadsheet: 196987d1354179598-min-max-axis-options-issue-880000
Sheet: 2000

Artist | [NAME] | [NAME] | Weeks Charted
3 Doors Down | Kryptonite |  | 39
Matchbox Twenty | Bent |  | 36
[NAME] | The Way You Love Me |  | 35
Creed | With Arms Wide Open |  | 34
[NAME] | Dance With Me |  | 23
[NAME] | Don't Think I'm Not |  | 22
Pink | Most Girls |  | 21
[NAME] | Music |  | 21
Mya | Case of the Ex |  | 20
[NAME] | Best of Intentions |  | 20
Spreadsheet: 80180d1280383872-lookup-match-index-match
Sheet: Sheet2

 | Sum Insred | Relation | 0-35 | 36-40 | 41-45 | 46-50 | 51-55 | 56-60 | 61-65 | 66-70
 | 100000 | Self | 1270 | 1515 | 1895 | 2770 | 3120 | 3620 | 4050 | 4560
 | 100000 | Spouse | 2530 | 2915 | 3575 | 5450 | 6280 | 7130 | 8110 | 9110
 | 100000 | Child | 2780 | 3210 | 3925 | 6040 | 6960 | 7890 | 9170 | 10190
 | 200000 | Self | 3030 | 3490 | 4280 | 6620 | 7640 | 8670 | 10070 | 11230
 | 200000 | Spouse | 3280 | 3775 | 4635 | 7190 | 8310 | 9430 | 10920 | 12120
 | 200000 | Child | 3530 | 4070 | 4985 | 7760 | 8980 | 10210 | 11670 | 13120
Spreadsheet: 55892d1256054080-cumulative-totals-exceltipexample2
Sheet: Comp1

 |  |  |  |  |  |  |  |  |  | Requirement
 |  |  |  |  |  |  |  |  |  | Ref | Other ID | ISIN | Name | Code | Declaration | Nominal | Total Nominal | Pay Amount
 |  |  |  |  |  |  |  |  |  | 123456789 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 200000 | 800000 | 200000
 |  |  |  |  |  |  |  |  |  | 148568478 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000 | 800000 | 300000
 |  |  |  |  |  |  |  |  |  | 138499345 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000 | 800000 | 150000
 |  |  |  |  |  |  |  |  |  | 235688974 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 300000 | 452000 | 200000
 |  |  |  |  |  |  |  |  |  | 265478899 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 152000 | 452000 | 0
Solution
Ref | Other ID | ISIN | Name | Code | Declaration | Nominal | Total Nominal | Pay Amount | start row
123456789 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 200000 | 800000 | 200000 | 12
148568478 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000 | 800000 | 300000 | 12
138499345 | DOO102034556 | GB1 | The Big Red Fun Bus | APPLE1 | 650000 | 300000 | 800000 | 150000 | 12
235688974 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 300000 | 452000 | 200000 | 15
265478899 | DOO102034556 | GB2 | The Green Helicopter | SAUCE2 | 200000 | 152000 | 452000 | 0 | 15
Spreadsheet: 794234d1661952701-vlookup-with-multiple-conditions-template-mock
Sheet: Quotation

 | Kinetics Noise Control |  |  |  |  |  |  |  | Date:
 | 6300 Irelan Place |  |  |  |  |  |  |  | RFQ:
 | Dublin, OH 43016
 | [PHONE]
 | Thank you for your recent email inquiry. Should you have any questions about this quote, please do not hesitate to contact me directly  by email at [EMAIL]. KNC is to provide CAG with all production drawings should this quote become an order.
 | Best regards,
 | [NAME]
 | ITEM | Qty | Type | Description | Powder Color | THICKNESS | GAUGE | MATERIAL | [NAME] | Length | AMOUNT
 | 1 | 10 | Panel | KNP-4-SIDED | Black-KIN-B (RAL 9004) | 4 | 22 | A-60 | 30 | 96
 | 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
 | 32
 | 33
 | 34
 | 35
 |  | ALL MATERIAL BELOW QUOTED USING THE FOLLOWING UNLESS OTHERWISE SPECIFIED BY KNP. ANY Z-CLIP 3" X 1-1/2" QUOTED USING KNC-ZCL-3 UNPAINTED
 |  | PERF QUOTED USING 23% OPEN (3/32"ø HOLES ON 3/16" STAGGERED CENTERS)
 |  | Powder to be smooth, low gloss.
 |  | Proposal validity is 30 days from date of quotation.
 |  | LEAD TIME: WILL VARY BASED ON MATERIALS NEEDED. LEAD TIME CAN NOT BE GIVEN UNTIL PO IS RECEIVED AND CONFIRMED FOR SPECIAL ORDER MATERIALS.
Spreadsheet: 456546d1460936535-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-a
Sheet: MON - HOSPITAL

DATE/DAY |  |  |  |  |  |  |  | DATE/DAY |  |  |  |  |  |  |  | Vegetables
TOTAL MEALS |  |  |  | Total |  | FROZENS | TOTAL | TOTAL MEALS |  |  |  |  |  | FROZENS |  | Corn |  | Chaffey | No Corn
BOTTOM |  |  |  |  |  |  |  | BOTTOM |  |  |  |  |  |  |  | Beans |  | Cocking | No Corn
TOTAL MEALS |  |  |  |  |  |  | 7 | TOTAL MEALS |  |  |  |  |  | 7 |  | Mash Potato |  | M Wilson | No Corn
TOMATO SOUP |  |  |  |  |  |  | 5 | SOUP |  |  |  |  |  |  |  | Pasta
ROAST BEEF & GRAVY |  |  |  |  |  |  |  | ROAST BEEF & GRAVY |  |  |  |  |  |  |  | Sweets
CHICKEN & POTATO PIE |  |  |  |  |  |  |  | CHICKEN & POTATO PIE |  |  |  |  |  |  |  | [NAME] |  | Cull | Fruit & Custard
SWEETS | DIABETIC |  |  |  |  |  |  | SWEETS | DIABETIC |  |  |  |  |  |  |  |  | Cull | No Corn
YOGHURT | JELLY |  |  |  |  |  |  | YOGHURT | JELLY |  |  |  |  |  |  |  |  | Wells | No Corn
APPLE JUICE | ORANGE JUICE |  |  |  |  |  |  |  | ORANGE JUICE |  |  |  |  |  |  | Soup
LANGLANDS |  | NO CORN (QUICHE) |  |  |  |  |  |  |  |  |  |  |  |  |  | Tomato |  | White | 7 Frozen Meals
LANGLANDS |  | NO CORN (BEEF)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Denson | No Mash
MIDDLE |  |  |  |  |  |  |  | MIDDLE
TOTAL MEALS |  |  |  |  |  |  | 7 | TOTAL MEALS |  |  |  |  |  | 7
TOMATO SOUP |  |  |  |  |  | 5 |  | SOUP |  |  |  |  |  |  |  |  |  | Cocking | Jelly - No Fruit or [NAME]
ROAST BEEF & GRAVY
CHICKEN & POTATO PIE
SWEETS | DIABETIC |  |  |  |  |  |  |  | DIABETIC
YOGHURT | JELLY |  |  |  |  |  |  |  | JELLY
APPLE JUICE | ORANGE JUICE |  |  |  |  |  |  |  | ORANGE JUICE
WHITE |  | 7 FROZEN MEALS (NO JUICE OR SW)  (Meals without Corn or Mushroom Please)
MUGIVEN |  | NO PINE OR CITRUS JELLY
TOP |  |  |  |  |  |  |  | TOP
TOTAL MEALS |  |  |  |  |  |  |  | TOTAL MEALS
TOMATO SOUP |  |  |  |  |  |  |  | SOUP
ROAST BEEF & GRAVY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BEEF
CHICKEN & POTATO PIE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUICHE
SWEETS | DIABETIC |  |  |  |  |  |  |  | DIABETIC |  |  |  |  |  | [NAME]
YOGHURT | JELLY |  |  |  |  |  |  |  | JELLY |  |  |  |  |  | YOGH
APPLE JUICE | ORANGE JUICE |  |  |  |  |  |  |  | ORANGE JUICE
BARNIER |  | QUICHE MASH ONLY
COCKING |  | NO CORN (BEEF), NO CITRUS JELLY
CHAFFEY |  | NO CORN (BEEF)
DENSON |  | NO MASH (BEEF)
Spreadsheet: 874059d1720625367-getting-data-from-one-workbook-to-another-athletics-spreadsheet-v14-tms
Sheet: Juniors

 |  | Prep Boys | Yr 1 Boys | Yr 2 Boys | Prep Girls | Yr 1 Girls | [NAME] | TOTALS
Shot Put | Coonowrin | 22 | 28 | 44 | 22 | 22 | 31
 | Tibro | 22 | 31 | 60 | 21 | 25 | 32
 | Coochin | 21 | 25 | 41 | 23 | 15 | 34
Fox Tails | Coonowrin | 31 | 15 | 17 | 19 | 17 | 16 |  |  | TIBROGARGAN
 | Tibro | 38 | 17 | 22 | 20 | 15 | 12 |  |  | COOCHIN
 | Coochin | 30 | 16 | 18 | 19 | 18 | 15 |  |  | COONOWRIN
[NAME] | Coonowrin | 31 | 30 | 30 | 23 | 32 | 30
 | Tibro | 15 | 27 | 23 | 9 | 34 | 43
 | Coochin | 32 | 39 | 55 | 10 | 47 | 38
Discus | Coonowrin | 8 | 8 | 14 | 8 | 9 | 10
 | Tibro | 2 | 6 | 5 | 17 | 11 | 8
 | Coochin | 5 | 6 | 20 | 8 | 9 | 6
Vortex | Coonowrin | 12 | 7 | 14 | 8 | 11 | 20
 | Tibro | 3 | 11 | 9 | 13 | 12 | 10
 | Coochin | 13 | 9 | 26 | 9 | 13 | 8
Take & Put | Coonowrin | 2 | 0 | 4 | 4 | 3 | 4
 | Tibro | 1 | 0 | 4 | 3 | 5 | 5
 | Coochin | 3 | 0 | 4 | 1 | 2 | 3
Sprints | Coonowrin | 93 | 35
 | Tibro | 77 | 30
 | Coochin | 90 | 30
Relays | Coonowrin | 9
 | Tibro | 9
 | Coochin | 9
Spreadsheet: 158446d1338246708-is-this-possible-reading-data-exception-tracking-2012
Sheet: May by Shift

AUDIT DESCREPANCIES BY SHIFT MAY
 | MAY
AUDIT DESCREPANCIES / EXCEPTIONS | DAY | SWING | GRAVE
Illegible or missing signature/ badge number
Any void not completed properly
Improper Error Corrections
Inconsistent Key Return
Incorrect/ Missing Information/ Totals
Missing Time Stamp/ Manual Date
Paperwork not received in Audit
Compliance Exceptions
Totals
Total Audit Exceptions
Total Compliance Exceptions
THESE ARE THE AUDIT DISCREPANCIES RECEIVED IN MAY!
THE GOAL FOR [NAME] IS A 10% REDUCTION. |  |  |  | JUNE GOAL
Spreadsheet: 140052d1328611145-excel-2007-compare-cells-within-several-groups-target-to-target-similarity-6
Sheet: Search Criteria

Search Criteria
Request | Operator | Description | Hits
Database | Include | All Mergers & Acquisitions | n/a
Date Announced | Between | 01/01/2000 to 12/31/2009 | n/a
Percent of Shares Owned after Transaction | Between | 50 to HI | 225722
Acquiror Nation (Code) | Include | United States of America | 73258
Acquiror Public Status (Code) | Include | Public | 31925
Deal Status (Code) | Include | Completed | 31897
Acquiror Primary SIC (Code) | Include | Crude petroleum and natural gas Natural gas liquids Drilling oil and gas wells Oil and gas field exploration services Oil and gas field services, nec Petroleum refining Asphalt paving mixtures and blocks Asphalt felts and coatings Lubricating oils and greases Products of petroleum and coal, nec Crude petroleum pipelines Refined petroleum pipelines Pipelines, nec | 1355
Custom Report |  | search strategy tabl... | 1355
Spreadsheet: 739229d1625583806-looking-for-a-formula-to-find-a-value-based-on-multiple-criteria-in-multiple-sheets-sample1
Sheet: Tab1

 |  | Thomas Franks Ltd.
 |  | Stock trend
 |  | 12 Months
 |  |  |  |  | Jul 20 |  | Aug 20 |  | Sep 20 |  | Oct 20 |  | Nov 20 |  | Dec 20 |  | Jan 21 |  | Feb 21 |  | Mar 21 |  | Apr 21 |  | May 21 |  | Jun 21
Location number | Location name | OPS | RD |  | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks
 |  | 0 | 0
 |  | 0 | 0
121 | test121 |  |  |  | 8785.7 | - | 7955.96 | 6.29 | 13277.85 |  | 5271.9 |  | 6551.32 |  | 4002.28 |  | 3641.41 |  | 3652.28 |  | 2867.88 |  | 7003.67 |  | 6473.92 |  | 6289.36
141 | test141 |  |  |  | 3582.78 | 9 | 7857.63 | 5.81 | 8324.49 |  | 6928.69 |  | 7543.4 |  | 6814.56 |  | 5660.18 |  | 5851.15 |  | 5062.39 |  | 7220 |  | 10694.57 |  | 5701.42
- | - | - | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Total | Tab1
- | - | - | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 771648d1646770216-vlookup-for-multiple-criteria-using-multiple-table-arrays-sample-data
Sheet: Selected Bench

2022-02-28 00:00:00 |  |  |  | 2022-03-01 00:00:00 |  |  |  | 2022-03-02 00:00:00 |  |  |  | 2022-03-03 00:00:00 |  |  |  | 2022-03-04 00:00:00
 | YEAR | MMD |  |  | YEAR | MMD |  |  | YEAR | MMD |  |  | YEAR | MMD |  |  | YEAR | MMD
0 | 2020 |  |  | 0 | 2020 |  |  | 0 | 2020 |  |  | 0 | 2020 |  |  | 0 | 2020
1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2
3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3 |  |  |  | 3
4 |  |  |  | 4 |  |  |  | 4 |  |  |  | 4 |  |  |  | 4
5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5 |  |  |  | 5
6 |  |  |  | 6 |  |  |  | 6 |  |  |  | 6 |  |  |  | 6
7 |  |  |  | 7 |  |  |  | 7 |  |  |  | 7 |  |  |  | 7
8 |  |  |  | 8 |  |  |  | 8 |  |  |  | 8 |  |  |  | 8
9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9 |  |  |  | 9
10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10 |  |  |  | 10
11 |  |  |  | 11 |  |  |  | 11 |  |  |  | 11 |  |  |  | 11
12 |  |  |  | 12 |  |  |  | 12 |  |  |  | 12 |  |  |  | 12
13 |  |  |  | 13 |  |  |  | 13 |  |  |  | 13 |  |  |  | 13
14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14
15 |  |  |  | 15 |  |  |  | 15 |  |  |  | 15 |  |  |  | 15
16 |  |  |  | 16 |  |  |  | 16 |  |  |  | 16 |  |  |  | 16
17 |  |  |  | 17 |  |  |  | 17 |  |  |  | 17 |  |  |  | 17
18 |  |  |  | 18 |  |  |  | 18 |  |  |  | 18 |  |  |  | 18
19 |  |  |  | 19 |  |  |  | 19 |  |  |  | 19 |  |  |  | 19
20 |  |  |  | 20 |  |  |  | 20 |  |  |  | 20 |  |  |  | 20
21 |  |  |  | 21 |  |  |  | 21 |  |  |  | 21 |  |  |  | 21
22 |  |  |  | 22 |  |  |  | 22 |  |  |  | 22 |  |  |  | 22
23 |  |  |  | 23 |  |  |  | 23 |  |  |  | 23 |  |  |  | 23
24 |  |  |  | 24 |  |  |  | 24 |  |  |  | 24 |  |  |  | 24
25 |  |  |  | 25 |  |  |  | 25 |  |  |  | 25 |  |  |  | 25
26 |  |  |  | 26 |  |  |  | 26 |  |  |  | 26 |  |  |  | 26
27 |  |  |  | 27 |  |  |  | 27 |  |  |  | 27 |  |  |  | 27
28 |  |  |  | 28 |  |  |  | 28 |  |  |  | 28 |  |  |  | 28
29 |  |  |  | 29 |  |  |  | 29 |  |  |  | 29 |  |  |  | 29
30 |  |  |  | 30 |  |  |  | 30 |  |  |  | 30 |  |  |  | 30
Spreadsheet: 487569d1478142880-sorting-by-last-name-under-special-circumstances-sortingtestworkbook
Sheet: Sheet1

firstname | lastname | address1 | address2 | city | state | zip | country | phone | email | filename | 10x15 | 13x18cm | 20x30cm | 28x42cm
[NAME] | [NAME] | 123 Main St |  | America | WA | 1234 | america | 12341234 | [EMAIL] | ABC0001 | 1 | 1
 |  |  |  |  |  |  |  |  |  | ABC0002 | 1 | 1
 |  |  |  |  |  |  |  |  |  | ABC0003 | 1 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  | ABC0004 | 1 | 1
Goofy | TheDog | 1600 Pennslyvania Ave |  | Washginton | DC | 12345 | America | 45674562 | [EMAIL] | ABC4526 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  | ABC4527 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  | [NAME] |  | 1 | 1
 |  |  |  |  |  |  |  |  |  | ABC4529 | 1 |  | 1
Elmer | Fudd | 25 Very Very Quiet Way |  | Perth | Wa | 6921 | Australia | 45678453 | [EMAIL] | ABC4726 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  | ABC4727 |  | 2 | 1
 |  |  |  |  |  |  |  |  |  | ABC4728 | 1 |  | 1
 |  |  |  |  |  |  |  |  |  | ABC4729 | 1 |  |  | 1
 |  |  |  |  |  |  |  |  |  | ABC4730 | 1 | 3 | 1
 |  |  |  |  |  |  |  |  |  | ABC4731 | 1
Spreadsheet: 164216d1340694588-vlookup-multiple-sheets-plist
Sheet: Can

 | Section Size A x B x t1 |  | PRICE
item | [NAME] (in) | m | Company A | Company B | Company C | Company D | Company E
can | 127 x 64 x 5.2  (5 x 2-1/2) | 6m |  |  |  |  | 69
can | 150 x 75 x 9.0 | 6m |  |  |  |  | 170
can |  | 9m |  |  |  | 290 | 260
can |  | 12m | 330
can | 100 x 50 x 5.0  (4 x 2) | 6m |  |  |  |  | 58
can | 250 x 90 x 9.0 | 12m |  |  |  | 500
can | 200 x 90 x 8.0 | 6m |  |  |  |  | 212
Spreadsheet: 377808d1424175879-showing-changes-only-in-scrolling-list-desired-layout-job-change-example-for-tips
Sheet: Report

Employ_ref | Forename | Surname | Leaver | Busarea | Costcentre | Description | Old grade | New Grade | Fromdate_1 | Untildate_1 | [NAME]
Spreadsheet: 866104d1713043955-automatically-generating-a-filtered-excel-page-generating-a-filtered-excel-bennett-y-
Sheet: Expected results

Today | 2024-04-11 00:00:00
Number | First date | irrelevant data ("A" will represent those dates) | Third date | Forth date | Fifth date | 3-1 | 4-3 | 5-4 | Tdy-4 | Name | Details ("B" will represent those data) | Quantity |  | It would be great if the automation could color the content by itself
10 | 2023-12-11 00:00:00 | A |  |  |  |  |  |  |  | [NAME] | B | 1
11 | 2024-01-15 00:00:00 | A | 2024-03-15 00:00:00 |  |  |  |  |  |  | [NAME] | B | 1
14 | 2024-03-17 00:00:00 | A | 2024-04-20 00:00:00 |  |  |  |  |  |  | [NAME] | B | 1
15 | 2024-04-06 00:00:00 | A | 2024-04-10 00:00:00 |  |  |  |  |  |  | [NAME] | B | 1
2 | 2022-08-17 00:00:00 | A | 2022-11-10 00:00:00 | 2023-01-12 00:00:00 | 2023-05-24 00:00:00 |  |  |  |  | [NAME] | B | 1
1 | 2022-05-12 00:00:00 | A | 2023-06-29 00:00:00 | 2023-08-23 00:00:00 | 2023-09-20 00:00:00 |  |  |  |  | [NAME] | B | 1
5 | 2023-05-17 00:00:00 | A | 2023-08-11 00:00:00 | 2023-09-12 00:00:00 |  |  |  |  |  | [NAME] | B | 1
7 | 2023-09-29 00:00:00 | A | 2023-12-28 00:00:00 | 2024-01-12 00:00:00 | 2024-04-08 00:00:00 |  |  |  |  | [NAME] | B | 1 |  | As these data's "Tdy-4" is greater than 61 days, it was then highlighted in black
3 | 2023-02-17 00:00:00 | A | 2023-06-29 00:00:00 | 2024-02-17 00:00:00 |  |  |  |  |  | [NAME] | B | 1
4 | 2023-02-17 00:00:00 | A | 2023-06-29 00:00:00 | 2024-02-23 00:00:00 |  |  |  |  |  | [NAME] | B | 1
8 | 2023-11-07 00:00:00 | A | 2024-02-06 00:00:00 | 2024-02-26 00:00:00 | 2024-04-10 00:00:00 |  |  |  |  | [NAME] | B | 1
6 | 2023-08-07 00:00:00 | A | 2024-01-22 00:00:00 | 2024-03-04 00:00:00 |  |  |  |  |  | [NAME] | B | 1
9 | 2023-11-20 00:00:00 | A | 2024-02-06 00:00:00 | 2024-03-04 00:00:00 |  |  |  |  |  | [NAME] | B | 1 |  | As these data's "Tdy-4" is greater than 31 days and less than 61 days, it was then highlighted in red
13 | 2024-02-01 00:00:00 | A | 2024-02-10 00:00:00 | 2024-03-17 00:00:00 |  |  |  |  |  | [NAME] | B | 1 |  | As these data's "Tdy-4" is less than 30 days, it was then highlighted in yellow
12 | 2024-01-19 00:00:00 | A | 2024-02-24 00:00:00 | 2024-04-07 00:00:00 |  |  |  |  |  | [NAME] | B | 1
We are finding the results as of 2024-03-31
Above is the table that I would like to generate automatically.
[NAME]
[NAME]
[NAME]
[NAME]
Total
If above table that count the number of appearances of each individual can be generated at the same time, it will be even better for me. Thank you.
Spreadsheet: 18016723-1ad0-47b0-b573-2b9dce0dbc53
Sheet: Input

BASIC PRESENT VALUE ANALYSIS
Building Name |  |  | Discount Rate | 0.05
Building Street Address |  |  | Escalation Rate | 0.025
Building City, State, Zip Code |  |  | Parking Escalation Rate | 0.025
Offeror's Name
Client Agency |  |  | Present Value per USF
Term |  | Years | Months
Total Term to be Evaluated Per SFO, in Months
Initial Term (months) | 0
[NAME] (months) | 0
Square Footage & Parking
Rentable Square Feet | 0 | R/U Factor
ANSI/BOMA Office Area (Usable) | 0
Structured Parking Spaces | 0
Surface Parking Spaces | 0
Rent
Does Shell Rent Step? (Y/N) | N
Does Parking Rate Step? (Y/N) | n
Does Parking Rate Escalate? (Y/N) | n
Does Offer Include Free Rent? (Y/N) | n
 | Initial Term
 | Rate per USF | Annual Rent
Shell Rent | 0
Op Cost (in Lease) | 0
Op Cost (Government) | 0
Amortization of TIA
Total Lessor's Overhead and Fees
Rate Per Sq Ft for Security
Structured Parking Rate | 0
Surface Parking Rate | 0
Tenant Improvement Allowance | Office Area (Usable) | Total TIA Principal
Total TIA Rate pusf provided in Annual Rent | 0
Lessor's Amortization Rate | 0 | Years | Months
Term in Months to Amortize TIA | 0
Total Lessor's Overhead and Fees
Overtime Utilities |  | Annual OT | [NAME] and Broker Credit
Number of Estimate Hours | 0 | Charge | Total Lump Sum | 0
Rate Per Hour | 0 |  | Commission Credit | 0
Does Overtime Charge Escalate? (Y/N) | n
Building Specific Amortized Capital
Total Cost of Security | 0
Security Amortization Rate | 0 | Years | Months
Term in Month to Amortize Security | 0
Rate Per Sq Ft for Security
General
Spreadsheet: 111460d1307825780-excel-2007-lookup-with-summing-lookup-with-summing
Sheet: Φύλλο2

Select a Name | [NAME]
Total Count
A | B | C | D |  | Name
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | Gerard
 |  |  |  |  | [NAME]