tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 87418d1287272266-lookup-query-book1
Sheet: Sheet1

Count | Superceded UPRN | NEW UPRN | Dept | Construct Year | Block Name | Flat | Number | Address Line 1
1 | 11278 | 40997001 | PHA
2 | 11292 | 40176001 | PHA
3 | 11294 | 40176003 | PHA
4 | 10335 | 40455001 | PHA
5 | 10779 | 40774001 | PHA
6 | 14834 | 41989001 | PHA
7 | 10785 | 40779001 | PHA
8 | 10780 | 40775001 | PHA
9 | 10793 | 40781001 | PHA
10 | 10337 | 40456001 | PHA
11 | 13387 | 41720001 | PHA
12 | 14836 | 41991001 | PHA
13 | 12010 | 41123001 | PHA
14 | 12011 | 41124001 | PHA
15 | 13258 | 41639001 | PHA
16 | 10825 | 40809001 | PHA
17 | 11249 | 40983001 | PHA
18 | 11038 | 40910001 | PHA
19 | 10357 | 40474001 | PHA
20 | 11402 | 41017001 | PHA
21 | 11401 | 41016001 | PHA
22 | 11405 | 41020001 | PHA
23 | 11407 | 41022001 | PHA
24 | 11403 | 41018001 | PHA
25 | 11404 | 41019001 | PHA
26 | 11409 | 41024001 | PHA
27 | 11410 | 41025001 | PHA
28 | 11408 | 41023001 | PHA
Spreadsheet: 835356d1688536480-count-and-rank-from-data-with-category-example-1
Sheet: Sheet1

 | Group | Transport |  |  | Count |  |  |  | Rank
 | Children | Boat |  |  | Group | Transport | Count |  | Group | Transport | Count | Rank
 | Adult | Car |  |  | Children | Boat | 1 |  | Children | Bus | 2 | 1
 | Teen | Bike |  |  |  | Car |  |  |  | Boat | 1 | 2
 | Adult | Bus |  |  |  | Bike | 1 |  |  | Bike | 1 | 2
 | Adult | Taxi |  |  |  | Bus | 2 |  |  | Plane | 1 | 2
 | Teen | Boat |  |  |  | Plane | 1 |  |  | Car
 | Teen | Taxi |  |  |  | Taxi |  |  |  | Taxi
 | Children | Bike |  |  | Teen | Boat | 2 |  | Teen | Car | 3 | 1
 | Teen | Car |  |  |  | Car | 3 |  |  | Boat | 2 | 2
 | Adult | Boat |  |  |  | Bike | 1 |  |  | Bike | 1 | 3
 | Children | Plane |  |  |  | Bus |  |  |  | Taxi | 1 | 3
 | Children | Bus |  |  |  | Plane |  |  |  | Bus
 | Adult | Boat |  |  |  | Taxi | 1 |  |  | Plane
 | Adult | Taxi |  |  | Adult | Boat | 3 |  | Adult | Boat | 3 | 1
 | Teen | Boat |  |  |  | Car | 1 |  |  | Taxi | 2 | 2
 | Teen | Car |  |  |  | Bike |  |  |  | Car | 1 | 3
 | Children | Bus |  |  |  | Bus | 1 |  |  | Bus | 1 | 3
 | Teen | Car |  |  |  | Plane |  |  |  | Bike
 | Adult | Boat |  |  |  | Taxi | 2 |  |  | Plane
Spreadsheet: 862633d1710306266-exclude-holidays-in-total-holiday-sample-1-3-
Sheet: Feb

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 2017-02-01 00:00:00 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 845580d1697033675-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerliveck76bak-aligw
Sheet: Handicaps

 |  |  | 2023-12-04 00:00:00 | 2024-01-08 00:00:00 | 2024-02-05 00:00:00 | 2024-03-04 00:00:00 | 2024-04-08 00:00:00 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00
Team/Hcap | StartHcp | Hcaps for 13/11 | Hcaps for 04/12 | Hcaps for 08/01 | Hcaps for 05/02 | Hcaps for 04/03 | Hcaps for 08/04 | Hcaps for 06/05 | Hcaps for 03/06
Team1
Player1 | 12
Player2 | 17
Player3 | 16
Player4 | 17
Team2 |  |  |  |  |  |  |  |  |  |  | Team2
Player5 | 10 |  |  |  |  |  |  |  |  |  | Player5 | 10 | 10 | 9 | 8 | 9 | 10 | 9 | 10 | 10
Player6 | 15 |  |  |  |  |  |  |  |  |  | Player6 | 15 | 14 | 13 | 14 | 15 | 14 | 15 | 15 | 15
Player7 | 19 |  |  |  |  |  |  |  |  |  | Player7 | 19 | 18 | 17 | 18 | 19 | 18 | 19 | 19 | 19
Player8 | 22 |  |  |  |  |  |  |  |  |  | Player8 | 22 | 21 | 20 | 21 | 22 | 21 | 22 | 22 | 22
Team3
Player9 | 15
Player10 | 20
Player11 | 25
Player12 | 28
Team4
Player13 | 13
Player14 | 19
Player15 | 21
Player16 | 22
Team5
Player17 | 12
Player18 | 14
Player19 | 19
Player20 | 23
Team6
Player21 | 17
Player22 | 19
Player23 | 22
Player24 | 25
Team7
Player22 | 10
Player23 | 16
Player24 | 22
Player25 | 25
Spreadsheet: 887014d1737089255-extracting-column-header-relationships-repertory-data-test
Sheet: Data Synthesis

2 Remedies | Count | Symptoms |  | 3 Remedies | Count | Symptoms
Bay leaf, Natrum flouratum | 8 | Allergies, Autism, Transitions, Head, ME (fatigue), Miasm - Syphilitic, Pituitary, [NAME] |  | Bay leaf, Natrum flouratum, Oak | 2 | Allergies, Miasm - Syphilitic
Bay leaf, Oak | 7 | Allergies, Stoic, Eyes, Liver, Miasm - Syphilitic, Endocrine |  | Bay leaf, Natrum flouratum, Wych Elm | 5 | Autism, Transitions, Head, ME (fatigue), [NAME]
Bay leaf, Wych Elm | 10 | Autism, Exhaustion, Lethargy, Transitions, Head, ME (fatigue), Protection, Circulatory, [NAME], Endocrine |  | Bay leaf, Natrum flouratum, Clay | 3 | Allergies, ME (fatigue), Pituitary
Spreadsheet: 681863d1591795365-index-and-match-to-pick-out-all-the-data-values-in-a-specified-column-of-data-example01
Sheet: Charts

 |  | user020-001 | <<< Drop-Down List
 | User Number
 | [NAME] | ?
 | Item02 | ? |  | How do I automate a Match Function with the Index Function to allow, all the "Specific" Column Data (from Worksheet Data!Rng_Matrix, to be displayd in Column C (Charts!) C5 to C28
 | Item03 | ?
 | Item04 | ?
 | Item05 | ?
 | Item06 | ?
 | Item07 | ?
 | Item08 | ?
 | Item09 | ?
 | Item10 | ?
 | Item11 | ?
 | Item12 | ?
 | Item13 | ?
 | Item14 | ?
 | Item15 | ?
 | Item16 | ?
 | Item17 | ?
 | Item18 | ?
 | Item19 | ?
 | Item20 | ?
 | Item21 | ?
 | Item22 | ?
 | Item23 | ?
 | Item24 | ?
 | Item25 | ?
Spreadsheet: 747276d1631345464-compounding-interest-for-weekly-distribution-annual-to-weekly-compounding-interest
Sheet: Sheet1

Week | Bal b/f | Interest | Bal c/f | Alternative
1 | 100 |  |  |  |  | Assuming interest rate with annual compounding = i, and
2 |  |  |  |  |  | interest rate with weekly compounding = r, then
3
4 |  |  |  |  |  | => (1+r)^52=1+i
5 |  |  |  |  |  | => r=((1+i)^(1/52)-1, which is the same formula as provided by curiouscat408
6 |  |  |  |  |  | => weekly balance = (principal+(1+8%)^(1/52)-1)^weeknum
7
8 |  |  |  |  |  | i | 0.08
9 |  |  |  |  |  | r
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Spreadsheet: john_griffith__15560__Brazos-Volumes
Sheet: Preston Gas Vol.

 |  | PRESTON VPP
 |  | Scheduled Volumes and Cash Flows for Gas Volumes
 |  | Delivery Point: TGT
 |  | Index:  Gas Daily - Louisiana Onshore South- Tx Gas SL
 |  | Vol/ Day | Vol/ Month |  |  |  |  | Class A Volumes and Notional Amounts |  |  | Class B Volumes and Notional Amounts
 |  |  |  | Contract Price | Gross Value
 |  |  | 8583080 |  |  |  |  | [NAME] | Notional Value |  | [NAME] | Notional Value
 |  |  |  |  | 40710680.09999999
2000-12-31 00:00:00 | 31 | 9700 | 300700
2001-01-31 00:00:00 | 31 | 10410 | 322710 | 6 | 1804200
2001-02-28 00:00:00 | 28 | 11480 | 321440 | 4.6975 | 1515930.23
2001-03-31 00:00:00 | 31 | 10335 | 320385 | 4.6975 | 1509964.4
2001-04-30 00:00:00 | 30 | 10640 | 319200 | 4.6975 | 1505008.54
2001-05-31 00:00:00 | 31 | 10260 | 318060 | 4.6975 | 1499442
2001-06-30 00:00:00 | 30 | 10565 | 316950 | 4.6975 | 1494086.85
2001-07-31 00:00:00 | 31 | 10100 | 313100 | 4.6975 | 1488872.63
2001-08-31 00:00:00 | 31 | 9900 | 306900 | 4.6975 | 1470787.25
2001-09-30 00:00:00 | 30 | 10045 | 301350 | 4.6975 | 1441662.75
2001-10-31 00:00:00 | 31 | 9555 | 296205 | 4.6975 | 1415591.63
2001-11-30 00:00:00 | 30 | 9710 | 291300 | 4.6975 | 1391422.99
2001-12-31 00:00:00 | 31 | 9255 | 286905 | 4.6975 | 1368381.75
2002-01-31 00:00:00 | 31 | 9125 | 282875 | 4.6975 | 1347736.24
2002-02-28 00:00:00 | 28 | 9970 | 279160 | 4.6975 | 1328805.31
2002-03-31 00:00:00 | 31 | 8895 | 275745 | 4.6975 | 1311354.1
2002-04-30 00:00:00 | 30 | 9085 | 272550 | 4.6975 | 1295312.14
2002-05-31 00:00:00 | 31 | 8695 | 269545 | 4.6975 | 1280303.63
2002-06-30 00:00:00 | 30 | 8895 | 266850 | 4.6975 | 1266187.64
2002-07-31 00:00:00 | 31 | 8500 | 263500 | 4.6975 | 1253527.88
2002-08-31 00:00:00 | 31 | 8150 | 252650 | 4.6975 | 1237791.25
2002-09-30 00:00:00 | 30 | 8910 | 267300 | 4.6975 | 1186823.38
2002-10-31 00:00:00 | 31 | 8545 | 264895 | 4.6975 | 1255641.75
2002-11-30 00:00:00 | 30 | 8750 | 262500 | 4.6975 | 1244344.26
2002-12-31 00:00:00 | 31 | 8400 | 260400 | 4.6975 | 1233093.75
2003-01-31 00:00:00 | 31 | 8205 | 254355 | 4.6975 | 1223229
2003-02-28 00:00:00 | 28 | 8435 | 236180 | 4.6975 | 1194832.61
2003-03-31 00:00:00 | 31 | 7330 | 227230 | 4.6975 | 1109455.55
2003-04-30 00:00:00 | 30 | 7280 | 218400 | 4.6975 | 1067412.93
2003-05-31 00:00:00 | 31 | 6790 | 210490 | 4.6975 | 1025934
2003-06-30 00:00:00 | 30 | 6775 | 203250 | 4.6975 | 988776.78
2003-07-31 00:00:00 |  |  |  | 4.6975 | 954766.88
Spreadsheet: 792790d1661166603-counting-ranges-in-sequences-socialmedia-calendar-draft
Sheet: Overview

9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | 2022
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | february | 2023
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March | 2024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April | 2025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
Company |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June
Cornerstone Audilogy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 06edc1dd-d75a-4033-bd23-917bb109855c
Sheet: Reading Grade 6

2013 Minnesota Comprehensive Assessments-Modified
Grade 6 Reading
Raw Score | Scale Score | Level
0 | 91 | D
1 | 116 | D
2 | 130 | D
3 | 139 | D
4 | 146 | D
5 | 151 | D
6 | 155 | D
7 | 159 | D
8 | 163 | D
9 | 166 | D
10 | 169 | D
11 | 172 | D
12 | 175 | D
13 | 178 | D
14 | 180 | D
15 | 183 | D
16 | 185 | D
17 | 188 | D
18 | 190 | P
19 | 192 | P
20 | 195 | P
21 | 197 | P
22 | 200 | M
23 | 203 | M
24 | 205 | M
25 | 208 | E
26 | 211 | E
27 | 215 | E
28 | 218 | E
29 | 222 | E
30 | 227 | E
31 | 232 | E
32 | 238 | E
33 | 247 | E
34 | 262 | E
35 | 286 | E
End of Worksheet
Spreadsheet: 3915da21-691b-4400-b173-ddcc422037cf
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
09/03/2010 | Men's Soccer | MONMOUTH | L, 0-1 (2OT)
09/05/2010 | Men's Soccer | UNC WILMINGTON | W, 3-2 (2OT)
09/10/2010 | Men's Soccer | vs. William & Mary (Virginia Beach, Va.) | L, 1-2
[NAME] | Men's Soccer | at Old Dominion | W, 2-1
09/17/2010 | Men's Soccer | CAL-STATE FULLERTON | W, 3-1
09/19/2010 | Men's Soccer | [NAME] | W, 1-0
09/24/2010 | Men's Soccer | DE PAUL | W, 5-0
09/29/2010 | Men's Soccer | at Duquesne | T, 0-0 (2OT)
10/02/2010 | Men's Soccer | at Georgetown | L, 0-1
10/06/2010 | Men's Soccer | at Elon | T, 1-1 (2OT)
10/09/2010 | Men's Soccer | NOTRE DAME | W, 2-1
10/13/2010 | Men's Soccer | PITT | W, 2-0
10/16/2010 | Men's Soccer | at USF | L, 0-1
10/19/2010 | Men's Soccer | at Connecticut | L, 0-2
10/23/2010 | Men's Soccer | SETON HALL | W, 3-2 (1OT)
10/27/2010 | Men's Soccer | MARQUETTE | W, 3-0
10/30/2010 | Men's Soccer | at Providence | L, 0-1
11/03/2010 | Men's Soccer | USF (BIG EAST First Round) | W, 2-1
11/06/2010 | Men's Soccer | at Louisville (BIG EAST Quarterfinals) | L, 0-2
11/18/2010 | Men's Soccer | XAVIER (NCAA First Round) | W, 4-2
11/21/2010 | Men's Soccer | at Akron (NCAA Second Round) | L, 2-3
Spreadsheet: 490227d1479752554-requesting-some-help-with-regards-to-a-vlookup-formula-sample-sheet
Sheet: Sheet1

Date | Time | Location | Repair | A/B |  |  |  | Date Range |  | 3/20 - 3/22
2016-03-17 00:00:00 | 250 | 111 access st | road sign | a
2016-03-17 00:00:00 | 1350 | 3941 adams ave | road sign | a |  |  |  | Number of B's |  | 2
2016-03-19 00:00:00 | 1440 | 218 freedom | road sign | a
2016-03-20 00:00:00 | 1445 | 897 rock well | pavement | a |  |  |  | Number of A's |  | 3
2016-03-21 00:00:00 | 1928 | 2240 steam st | pavement | a
2016-03-22 00:00:00 | 120 | 5992 major st | pavement | b |  |  |  | Time Slots |  | 0-700 | 2
2016-03-22 00:00:00 | 700 | 4876 arthur st west | road sign | b |  |  |  |  |  | 701-1600 | 0
2016-03-22 00:00:00 | 1850 | 2401 zebra | pavement | b |  |  |  |  |  | 1601-2400 | 2
Spreadsheet: 02d1907f-8967-404c-8530-d536f3e856a1
Sheet: Sheet1

PROFESSIONAL STAFF SUMMARY
This workbook contains 2009-10 full- and part-time professional staff counts for all public schools
in Pennsylvania as reported by school districts, area vocational-technical schools, charter schools,
intermediate units and state juvenile correctional institutes.
Average Salaries, Years of Service and Education Level are calculated from full-time staff only.
COUNTY AND STATEWIDE TOTAL NOTES
LEVEL TOTALS ARE DISTINCT WITHIN THE LEVEL
Local Education Agency (LEA) Level: An individual is only counted once per LEA, regardless of the number of schools or buildings where she or he is employed.
County Level: An individual is only counted once per county, regardless of the number of LEAs where she or he is employed.
State Level: An individual is only counted once per state, regardless of the number of LEAs or counties where she or he is employed.
LEA TYPE CODES
CS - Charter School
CTC - Career Technical Center (AVTS)
IU - Intermediate Unit
SD - School District
SJCI - State Juvenile Correctional Institute
EDUCATION LEVEL CODES
1 - Less than high school graduate
2 - High school graduate
3 - Some college, less than bachelor's degree
4 - Bachelor's degree (includes master's equivalency)
5 - Master's degree
6 - Doctor's degree
SALARY CONTRACT YEAR
All salary data are based on the contract year noted in the LEA Averages worksheet. [NAME] names without footnotes in the LEA Averages worksheet reported salaries based on current contracts. The contract exceptions footnoted in the LEA Averages worksheet apply to other sheets even though the LEA name is not footnoted.
\1 Salaries are based on a contract that expired during the 2007-08 school year.
\2 Salaries are based on a contract that expired during the 2008-09 school year.
CONTACT:
PA Department of Education
Division of Data Quality
333 Market Street
Harrisburg, PA  17126-0333
[NAME]:  [NAME]
Phone:  (717) 787-2644
Fax:  (717) 787-3148
Text Telephone TTY:  (717) 783-8445
Data Source: Pennsylvania Information Management System (PIMS)
2009-10 Professional Staff Collection
2010-10-22 00:00:00
Spreadsheet: 164149d1340659206-finding-the-highest-number-from-a-list-of-random-numbers-book1
Sheet: Sheet1

rand |  |  | wizard
13 |  |  | Int | 20
8 |  |  | Cha | 20
18 |  |  | Con | 18
4 |  |  | Dex | 13
20 |  |  | Wis | 8
20 |  |  | Str | 4
Spreadsheet: 178054d1346627066-percentiles-with-frequency-data-help-me
Sheet: Sheet1

 | Median % | Count
 | 0.05 | 4
 | 0.15 | 4
 | 0.25 | 8
 | 0.35 | 3
 | 0.45 | 4
 | 0.55 | 2
 | 0.65 | 0
 | 0.75 | 3
 | 0.85 | 0
 | 0.95 | 6
 | 1.1 | 4
 | 1.3 | 4
 | 1.5 | 0
 | 1.7 | 2
 | 1.9 | 1
 | 2.25 | 7
75th %ile | ?
Median | ?
25th %ile | ?
Spreadsheet: 275446d1383516495-finding-a-value-in-row-based-on-a-condition-sample
Sheet: Sheet1

Name | Age | Weight | Height | Age Criteria
[NAME] | 20 | 108 | 5 | 20
Rachel | 30 | 175 | 6
[NAME] | 20 | 150 | 6
[NAME] | 35 | 125 | 5
Spreadsheet: 164804d1340896689-find-text-example3
Sheet: Sheet1

Scott
 | [NAME]
[NAME]
[NAME]
 |  | [NAME]
 |  |  | Mark
[NAME]
 | [NAME]
 |  |  |  | Kelly
 |  | [NAME]
Spreadsheet: 21077d1208188484-cells-formatted-the-same-are-showing-0-00-vs-formatting-issue-example
Sheet: Sheet1

Situation 1
 | 5264 | -1.13686837721616e-13 | 1316 | 3158.4 | 789.6 |  |  |  | IN PROGRESS
Situation 2
 | 5264 | 0 | 1316 | 3159 | 789 |  |  |  | COMPLETED
Situation 3
 | 5264 | 0 | 1316 | 3158.4 | 789.6 |  |  |  | COMPLETED
Spreadsheet: 268992d1380909270-average-of-data-excluding-gaps-formula-20test-1-
Sheet: Sheet1

Date | Time | Data | Flag | Average
01 01 2013 | 00:00:00 | 10
01 01 2013 | 01:00:00 | 8
01 01 2013 | 02:00:00 | 8
01 01 2013 | 03:00:00 | 9
01 01 2013 | 04:00:00 | 5
01 01 2013 | 05:00:00 | 10
01 01 2013 | 06:00:00 | 13
01 01 2013 | 07:00:00 | 14
01 01 2013 | 08:00:00 | 12
01 01 2013 | 09:00:00 | 15
01 01 2013 | 10:00:00 | 18
01 01 2013 | 11:00:00 | 21
01 01 2013 | 12:00:00 | 16
01 01 2013 | 13:00:00 | 22
01 01 2013 | 14:00:00 | 25
01 01 2013 | 15:00:00 | 17
01 01 2013 | 16:00:00 | 14
01 01 2013 | 17:00:00 | 13
01 01 2013 | 18:00:00 | 10
01 01 2013 | 19:00:00 | 7
01 01 2013 | 20:00:00 | 8
01 01 2013 | 21:00:00 | 7
01 01 2013 | 22:00:00 | 10
01 01 2013 | 23:00:00 | 12
01 02 2013 | 00:00:00 | 13
01 02 2013 | 01:00:00 | 14
Spreadsheet: 875289d1721876934-formula-that-compares-relative-position-of-numbers-from-tables-stock-comparison-33
Sheet: Sheet1

table 1 | 1e0t2l14l3 | 1er1t20t4l2 | t2r1t3l1 | t3r1 | ?? | t3r3 |  | ? | t10l1 |  |  | t120 |  | t12r2
 | 1e | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1 | 1 | 4 | 3 | 4 | 4
2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 1 | 1 | 4 | 3 | 5 | 4
3 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 1 | 2 | 2 | 5 | 5 | 8 | 6
4 | 0 | 0 | 0 | 1 | 1 | 1 | 4 | 1 | 4 | 3 | 5 | 8 | 7 | 13 | 9
5 | 0 | 0 | 0 | 1 | 3 | 1 | 4 | 1 | 5 | 6 | 7 | 11 | 11 | 18 | 14
6 | 0 | 0 | 0 | 1 | 4 | 1 | 5 | 3 | 6 | 7 | 11 | 14 | 14 | 22 | 20
7 | 0 | 0 | 0 | 1 | 4 | 1 | 5 | 3 | 6 | 7 | 11 | 14 | 14 | 22 | 20
table 2
 | 1e0bt4l3 |  | [NAME] | 1er3 | t6?l1 | t2r4 |  |  | t5r4 |  |  | t10r2
 | 1e | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15 |  |  | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 3 | 2 | 2 | 4 | 5
2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 3 | 2 | 2 | 4 | 5
3 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 2 | 3 | 4 | 4 | 5 | 7 | 8
4 | 0 | 1 | 0 | 0 | 2 | 0 | 1 | 1 | 2 | 3 | 4 | 5 | 7 | 10 | 11
5 | 0 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 3 | 4 | 8 | 6 | 12 | 14 | 14
6 | 0 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 3 | 4 | 9 | 9 | 16 | 18 | 17
7 | 0 | 1 | 0 | 0 | 3 | 0 | 1 | 1 | 3 | 4 | 9 | 9 | 16 | 19 | 18
comparison |  | no??(2/3b) |  |  |  |  | 123..12..1245t |  |  |  |  |  | a ..b t2=3,t6=3,
table
a ..b t2=3,t6=3, | 1e | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
1 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 1 | 4 | 5 | 4 | 6 | 9 | 9
2 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 1 | 4 | 5 | 4 | 6 | 9 | 9
3 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 1 | 2 | 5 | 6 | 5 | 7 | 11 | 11
4 | 0 | 0 | 1 | 0 | 3 | 2 | 2 | 1 | 4 | 6 | 9 | 8 | 13 | 16 | 18
5 | 0 | 0 | 1 | 0 | 3 | 2 | 2 | 2 | 5 | 8 | 11 | 9 | 16 | 17 | 22
6 | 0 | 0 | 1 | 0 | 3 | 2 | 3 | 2 | 5 | 9 | 11 | 9 | 17 | 19 | 24
7 | 0 | 0 | 1 | 0 | 3 | 2 | 3 | 2 | 5 | 9 | 11 | 9 | 17 | 19 | 24
Spreadsheet: 744844d1629480479-unique-formula-based-on-two-columns-excel-example
Sheet: Data Source

Data Source |  |  |  |  |  |  | Desired Tables
Product | Companies | City |  |  |  |  | Companies | City | Product Count
1 | A | Boston |  |  |  |  | A | Boston
2 | B | New York |  |  |  |  | B | New York
3 | A | Chicago |  |  |  |  | A | Chicago
4 | A | Chicago |  |  |  |  | B | Phenoix
5 | B | New York
6 | A | Boston
7 | B | Pheonix
8 | B | Phenoix
9 | A | Boston
Spreadsheet: 799724d1665237036-assign-different-values-to-cells-and-sum-them-spec
Sheet: Foglio1

October |  | Federica 1 | Gabriele | Martina | Luisa | Natale | Francesca | Stefano | October
Sum
3 | lun | Ch Rob P | Ort P | 20 - 8 | Gin M | Amb | Oto M | [NAME] | 3 | lun
4 | [NAME] | NCH P | Amb | sn | 20 - 8 | NCH M | End Dig M | Vasc M | 4 | [NAME]
5 | [NAME] | Amb + BU P | [NAME] | [NAME] | sn | [NAME] | L | 20 - 8 | 5 | [NAME]
6 | gio | Ch Uni P | [NAME] | Oto M | BLS 9 17 |  | Amb + Uro Rob P | sn | 6 | gio
7 | ven | Ort M | 20 - 8 | NCH P | L | [NAME] | NCH M | Amb | 7 | ven
8 | sab |  | sn |  | FS |  | FS |  | 8 | sab
9 | dom |  |  |  |  | 20 - 8 |  | [NAME] | 9 | dom
10 | lun | Ocu M | Pom 2 | L | Amb | sn | BU P | L | 10 | lun
11 | [NAME] | Amb | 20 - 8 | End Uro M | Ort M | [NAME] |  | [NAME] | 11 | [NAME]
12 | [NAME] | BU P | sn | BLS 9 17 | NCH 8-17 | Vasc M  + Pom | Amb | [NAME] | 12 | [NAME]
13 | gio | Uro Rob M | [NAME] | Ch Uni M | [NAME] | [NAME] | End Uro M | Ort M | 13 | gio
14 | ven | 20 - 8 | NCH M | Uro Rob P | Ch Osp M | [NAME] | Ort M | [NAME] | 14 | ven
15 | sab | sn | FS | Amb |  | FS | FS |  | 15 | sab
16 | dom |  |  |  |  |  | 20 - 8 |  | 16 | dom
17 | lun | NCH 8-17 | [NAME] | Ort M | Amb | [NAME] P | sn | 20 - 8 | 17 | lun
18 | [NAME] | Ort M | NCH P | NCH M | Vasc M | Pom 2 | Vasc P | sn | 18 | [NAME]
19 | [NAME] | Ch [NAME] | [NAME] | [NAME] | 20 - 8 | L | NCH 8-17 | [NAME] | 19 | [NAME]
20 | gio | Amb | Gin M | Vasc M + Pom 2 | sn | Ort M + Pom | End Uro M | Oto M | 20 | gio
21 | ven | L | [NAME] | Ch Osp M |  | NCH P + Ch Osp M | Pom 2 | NCH M | 21 | ven
22 | sab |  |  |  | [NAME] |  | Amb |  | 22 | sab
23 | dom |  |  |  |  |  |  |  | 23 | dom
24 | lun | 20 - 8 | Ort M | Gin Rob P | NCH 8-17 | [NAME] | [NAME] | BU P | 24 | lun
25 | [NAME] | sn | End Dig M | 20 - 8 |  | Amb | Ort M | Gin M | 25 | [NAME]
26 | [NAME] | Vasc M | NCH 8-17 | sn | Ocu M | 20 - 8 | [NAME] |  | 26 | [NAME]
27 | gio | [NAME] |  | [NAME] | Amb | sn |  | [NAME] | 27 | gio
28 | ven | FS | [NAME] | FS | FS | FS | FS | Ort M + Ort P | 28 | ven
29 | sab | FS |  | FS | FS | FS | FS | Amb | 29 | sab
30 | dom | FS |  | FS | FS | FS | FS |  | 30 | dom
31 | lun |  | [NAME] | L | Gin P | NCH 8-17 | 20 - 8 | Amb | 31 | lun
Spreadsheet: 45787d1244580613-formula-giving-undesired-result-state-codes_1
Sheet: Sheet1

S.No | State Names | Codes | Text Files | Possible Text File |  | AHQ.1 | [NAME] | AHQ.3 | AHQ.4 | AHQ.5 | AHQ.6 | [NAME] | AHQ.8
1 | Andaman & Nicobar Islands | 35 | AHQ.1 | AHQ.1 |  | 9 | 10
2 | Andhrapradesh | 28 | AHQ. 2 | #N/A |  | 13 | 12
3 | Arunchal Pradesh | 12 | AHQ. 3 | [NAME] |  | 17 | 15
4 | Assam | 18 | AHQ. 4 | [NAME] |  | 35 | 16
5 | Bihar | 10 | AHQ. 5 | [NAME] |  |  | 18
6 | Chandigarh | 4 | AHQ. 6 | #N/A
7 | Chhattisgarh | 22 | AHQ. 7 | #N/A
8 | Dadar & Nagar Haveli | 26 | AHQ. 8 | #N/A
9 | Daman&Diu | 25 |  | #N/A
10 | Delhi | 7 |  | #N/A
11 | Goa | 30 |  | #N/A
12 | Gujarat | 24 |  | #N/A
13 | [NAME] | 6 |  | #N/A
14 | Himachal Pradesh | 2 |  | #N/A
15 | Jammu and Kashmir | 1 |  | #N/A
16 | Jharkhand | 20 |  | #N/A
17 | Karnataka | 29 |  | #N/A
18 | Kerala | 32 |  | #N/A
19 | Lakshadweep | 31 |  | #N/A
20 | Madhya Pradesh | 23 |  | #N/A
21 | Maharashtra | 27 |  | #N/A
22 | Manipur | 14 |  | #N/A
23 | Meghalya | 17 |  | AHQ.1
24 | Mizoram | 15 |  | [NAME]
25 | Nagaland | 13 |  | AHQ.1
26 | [NAME] | 21 |  | #N/A
27 | [NAME] | 1 |  | #N/A
28 | Punjab | 3 |  | #N/A
29 | [NAME] | 8 |  | #N/A
30 | Sikkim | 11 |  | #N/A
31 | [NAME] | 33 |  | #N/A
32 | Tripura | 16 |  | [NAME]
33 | Uttaranchal | 5 |  | #N/A
34 | Uttar Pradesh | 9 |  | AHQ.1
35 | West Bengal | 19 |  | #N/A
Spreadsheet: 111567d1307950238-leave-days-vacation-example
Sheet: Sheet1

Vacation
Monthly Summary
Employee Code | Employee Name | Opening Days | Leave Entitlement | July | August | September | October | November | December | January | February | March | April | May | June | Closing Days |  |  | Date of Leave | Form Number | Employee Code | Number of Days | Employee Name
 | aaa |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eee
 | bbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | bbb
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | ddd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ddd
 | eee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | bbb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aaa