tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 948d70bf-2d75-4a3f-941b-19b7b522872f
Sheet: Sheet1

SCHOOL REGISTRATION FORM for IAIS / IAS 2011 | Unnamed: 1 | Unnamed: 2
School Code (Only for schools that have registered for IAIS / IAS in any previous year. Please write the exact 8-digit school code as printed on your previous year’s school report) :
School Name [Please mention the exact name that you want printed on your IAIS / IAS School Report and IAIS / IAS Certificates. The school name should not exceed more than EIGHTY (80) characters including letters, numbers, spaces and full stops (.). No other characters are allowed. For example - A B C SCHOOL. CHENNAI. INDIA ] :
School Address 1 :
School Address 2 :
City / Town :
State / Union Territory :
Country :
Pin Code :
Phones (with STD code) :
Fax :
Administrators Email Id (This is required by EAA to send important information to the school by email):
Administrators Mobile No. (This is required by EAA to send important information to the school by SMS):
Principal's Name :
Principal's / School's E-mail Id :
Board Affiliation :
Subjects Opted by the School (Write "1" for the subjects opted) | English
 | Science
 | Mathematics
 | Computer Skills
English | Coordinator's Name :
 | Coordinator's E-mail Id :
Science | Coordinator's Name :
 | Coordinator's E-mail Id :
Mathematics | Coordinator's Name :
 | Coordinator's E-mail Id :
Computer Skills | Coordinator's Name :
 | Coordinator's E-mail Id :
SAP Entry Details (Sales Office (SR21)+Cuctomer [NAME]))
Registration Details | Total Students Registred | 0
 | English | 0
 | Science | 0
 | Mathematics | 0
 | Computer Skills | 0
 | GRAND TOTAL OF TESTS | 0
Total Amount Collected From This School |  | 0
Spreadsheet: 118410d1313669568-count-times-when-conditional-formatting-met-marks2
Sheet: Sheet1

 |  | Pupil | Points | :) | : | :( | 2011-09-01 00:00:00 | 2011-09-02 00:00:00 | 2011-09-03 00:00:00 | 2011-09-04 00:00:00 | 2011-09-05 00:00:00 | 2011-09-06 00:00:00
1c | 1.1 | [NAME] | 13 | 4 | 1 | 2 | 1c | 1b | 1c | 2a | 3b | 3c | 3c | 3b
1b | 1.2 | [NAME] | 12 | 4 | 0 | 1 | 1c | 1a | 2a | 3c | 2a | 3c
1a | 1.3 | [NAME] | 9 | 3 | 0 | 2 | 1c | 2c | 1a | 1b | 2a | 3c
2c | 2.1 | [NAME] | 4 | 1 | 1 | 0 | 1c | 1c | 2b
2b | 2.2 | [NAME] | 21 | 6 | 3 | 1 | 1b | 1b | 1a | 2c | 2c | 2b | 2b | 2a | 1c | 1b | 1a
2a | 2.3 | [NAME] | 3 | 1 | 0 | 0 | 1a | 2a
3c | 3.1 | [NAME] | 3 | 1 | 0 | 0 | 2c | 3b
3b | 3.2 | [NAME] | 12 | 4 | 0 | 2 | 2b | 1a | 1b | 1a | 2c | 2b | 2a
3a | 3.3
4c | 4.1
4b | 4.2
4a | 4.3
5c | 5.1
5b | 5.2
5a | 5.3
6c | 6.1
6b | 6.2
6a | 6.3
7c | 7.1
7b | 7.2
7a | 7.3
Spreadsheet: 780379d1652430771-formula-reliant-on-number-value-to-populate-different-cells-fmr-formulas
Sheet: Sheet1

Replacement Cost | Remaining Life | Backlog | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
100 | -2
150 | 0
300 | 2
80 | 4
20 | 8
Required Formula | --->
Spreadsheet: d5d54af5-2443-4a70-98f8-3e22cc89d5ff
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CAU | Test | CAU | Calcium, 24 Hour, [NAME] | Calcium, 24 Hr, U | Inductively Coupled Plasma-Optical Emission Spectrometry (ICP-OES) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	Yes Thymol	No | 0.1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Males: 25-300 mg/specimen* Females: 20-275 mg/specimen* Hypercalciuria: >350 mg/specimen *Values are for persons with average calcium intake (ie, 600-800 mg/day). | Monday through Friday; 11 a.m.-6 p.m. | 1 day | 3 days | 1 | 82340 |  |  |  |  | Rochester
CAU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CAU | Order Question | TM13 | Collection Duration |  | Plain Text
CAU | Order Question | VL11 | [NAME] |  | Plain Text
CAU | Result | 8594 | Calcium, 24 Hr, U | Calcium, 24 Hr, U | Numeric |  |  |  |  | mg/spec |  |  |  |  |  |  |  |  |  | 6874-2 | Calcium:MRat:24H:Urine:Qn:
CAU | Result | TM13 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
CAU | Result | VL11 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9 | [NAME] volume:Vol:Pt:[NAME]:Qn:
CAU | Result | 2520 | Calcium Concentration | Calcium Concentration | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 18488-7 | Calcium:MCnc:24H:[NAME]:Qn:
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: DX51 VFB

 |  |  |  |  | DX51 VFB
Registration number : | DX51 VFB |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | DAF |  | 2002-12-31 00:00:00 | 12 Months | 2003-01-01 00:00:00 | 1964
Specification : | 4 x 2 A |  | 2003-12-31 00:00:00 | 12 Months | 2004-01-01 00:00:00 | 1850
Type : | FTCF85.430 |  | 2004-12-31 00:00:00 | 12 Months | 2005-01-01 00:00:00 | 1850
1st Registered : | 11.12.01 |  | 2005-12-30 00:00:00 | 12 Months | 2006-01-01 00:00:00 | 1850
Engine : | XE CI 12.60 litre |  | 2006-12-29 00:00:00 | 12 Months | 2007-01-01 00:00:00 | 1850
[NAME] : |  |  | 2007-12-28 00:00:00 | 12 Months | 2008-01-01 00:00:00 | 1850
 |  |  | Tax Surrendered 31/7/2009
 |  |  | 2009-01-30 00:00:00 | 12 Months | 2010-02-01 00:00:00 | 165 | Private HGV (training)
 |  |  | 2010-01-29 00:00:00 | 12 Months | 2011-02-01 00:00:00 | 165
Back To Index |  |  | 2011-01-31 00:00:00 | 12 Months | 2012-02-01 00:00:00 | 165
 |  |  | 1/4/2011 - Down plated to 34,000kg
 |  |  | 4/4/2011 Tax disc exhanged from PRIVATE HGV to HGV
 |  |  | 2011-04-04 00:00:00 | 12 Months | 2012-02-01 00:00:00 | 237
 |  |  | 2012-01-26 00:00:00 | 12 Months | 2013-02-01 00:00:00 | £450 + £2.50 (Online Fee)
Spreadsheet: 731877d1620654096-mrp-related-question-mrp-question
Sheet: Sheet1

 |  |  |  | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-12 00:00:00 | 2021-06-13 00:00:00 | 2021-06-14 00:00:00
 |  |  | Demand |  |  |  |  |  |  |  |  |  |  |  | 200
Leadtime | 10 |  | Offset leadtime |  | 200
 |  |  |  | I need a formula  that will take the value on row 5 ( 200) and transpose that value to the right but in row 6, depending on the leadtime of that item.  Can you help me with the formula
Spreadsheet: 377033d1423773430-several-issues-at-once-helpmeexcel
Sheet: Vendor 1

Item Number | Distributor | Description | UM | Size | Case Qty | Cost/ea | Cost/UM | Cost/Case | Type | Use | Frequency | Not Applicable
101 | v1 | Cleaner 8 oz Can | can | 8 | 12 |  |  | 200 | [NAME] | Expendable | 2
102 | v1 | Nitrile Glove | box | 100 | 10 |  |  | 50 | Glove | Expendable | 1
103 | v1 | Paper 800ft | roll | 800 | 4 |  |  | 40 | Towel | Expendable | 3
104 | v1 | 55 gallon thick | roll | 25 | 10 |  |  | 35 | [NAME] | Expendable | 1
105 | v1 | Lobby broom plastic | ea | 1 | 1 |  |  | 5 | Broom | Non-Expendable | 0
Spreadsheet: 457c19c2-ca20-41d1-a57b-2105f2212384
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-01-22 09:46:40.750000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.693 | 102.568 | 102.443 | 102.068
4.625 | 101.947 | 101.822 | 101.697 | 101.322 |  | Note: | Refer To Price [NAME]
4.5 | 101.025 | 100.9 | 100.775 | 100.4 |  |  | For all Price Adjs
4.375 | 100.066 | 99.941 | 99.816 | 99.191
4.25 | 99.371 | 99.246 | 99.121 | 98.496
4.125 | 98.553 | 98.428 | 98.303 | 97.678
4 | 97.545 | 97.42 | 97.295 | 96.67
3.875 | 96.495 | 96.37 | 96.245 | 95.62 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.472 | 102.347 | 102.222 | 101.847
3.75 | 101.798 | 101.673 | 101.548 | 101.173
3.625 | 101.36 | 101.235 | 101.11 | 100.735
3.5 | 100.81 | 100.685 | 100.56 | 99.935
3.375 | 100.017 | 99.892 | 99.767 | 99.142
3.25 | 99.255 | 99.13 | 99.005 | 98.38 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-02-05 09:46:40.750000
30 DAY | 2014-02-20 09:46:40.750000
45 DAY | 2014-03-07 09:46:40.750000
60 DAY | 2014-03-22 09:46:40.750000
90 DAY | 2014-04-21 09:46:40.750000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 673944d1587594017-conditional-formatting-ignoring-or-symbols-predicted-grades_template_updated_22-04-20_forum_example
Sheet: Sheet1

 | Name | Target Grade | Target Grade (MID function) (This column is for use in Conditional Formatting only) | Target Grade (Minus 1) (This column is for use in Conditional Formatting only) | [NAME]
 | a | 6+ |  |  | 7
 | b | 6 |  |  | 5
 | c | 4- |  |  | 2
 | d | 7+ |  |  | 9
Spreadsheet: 746667d1630942732-count-unique-ids-that-have-multiple-records-example-dataset
Sheet: Sheet1

Student ID | Month
1 | 2020-09-01 00:00:00 |  | September | 1
2 | 2020-09-01 00:00:00 |  | October | 2
3 | 2020-09-01 00:00:00 |  | November | 2
3 | 2020-09-01 00:00:00 |  | December | 3
4 | 2020-10-01 00:00:00
5 | 2020-10-01 00:00:00
5 | 2020-10-01 00:00:00
5 | 2020-10-01 00:00:00
6 | 2020-10-01 00:00:00
7 | 2020-10-01 00:00:00
7 | 2020-10-01 00:00:00
8 | 2020-11-01 00:00:00
9 | 2020-11-01 00:00:00
9 | 2020-11-01 00:00:00
10 | 2020-11-01 00:00:00
10 | 2020-11-01 00:00:00
11 | 2020-12-01 00:00:00
11 | 2020-12-01 00:00:00
11 | 2020-12-01 00:00:00
12 | 2020-12-01 00:00:00
12 | 2020-12-01 00:00:00
13 | 2020-12-01 00:00:00
14 | 2020-12-01 00:00:00
15 | 2020-12-01 00:00:00
15 | 2020-12-01 00:00:00
Spreadsheet: 741288d1626955666-how-to-lookup-the-words-which-is-inside-the-sentence-and-using-lookup-formula-to-get-data-channel-code
Sheet: Sheet1

OUTLET NAME | CHANNEL CODE |  |  |  |  |  | CHANNEL | CHANNEL CODE
DANISH RESTAURENT |  |  |  |  |  |  | RESTAURENT | SC22
SATYA STORE |  |  |  |  |  |  | MOMO | SC22
B AND B Cafe |  |  |  |  |  |  | Cafe | SC22
DIBYA HOTEL AND LODGE |  |  |  |  |  |  | HOTEL | SC22
KIMCHI COLD DRINKS |  |  |  |  |  |  | COLD | SC05
RAMESH MOMO PASAL |  |  |  |  |  |  | STORE | SC05
TRISHARA RESTAURENT AND CLUB
DÉJÀ VU RESTAURENT
QUALITY MOMO PVT LTD
Spreadsheet: 42193d1240768626-return-blank-or-zero-book1x
Sheet: WK 1

 |  |  | 2009-04-23 00:00:00 | Week 1
 |  |  |  | Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Gross | Net
 |  | Net |  | Front Par | 4 | 4 | 5 | 3 | 4 | 3 | 5 | 3 | 4 | 35
 |  | Rank | Name | HCP | 10 | 4 | 5 | 12 | 16 | 14 | 6 | 2 | 1
 |  |  |  | Low Score for [NAME] (MIN) | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 3 | [NAME] | 5 | 6 | 4 | 5 | 3 | 5 | 4 | 5 | 6 | 6 | 44 | 39
 |  | 7 | [NAME] | 12 | 6 | 6 | 5 | 3 | 6 | 6 | 9 | 5 | 7 | 53 | 41
 |  | 1 | [NAME] | 13 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  | 4 | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 3 | 6 | 4 | 7 | 45 | 40
 |  | 4 | [NAME] | 9 | 5 | 6 | 6 | 5 | 6 | 5 | 6 | 5 | 5 | 49 | 40
 |  | 11 | [NAME] | 10 | 6 | 6 | 10 | 4 | 4 | 3 | 7 | 5 | 7 | 52 | 42
 |  | 2 | [NAME] | 3 | 3 | 4 | 6 | 5 | 4 | 4 | 5 | 5 | 5 | 41 | 38
 |  | 7 | [NAME] | 14 | 6 | 8 | 6 | 4 | 7 | 5 | 7 | 5 | 7 | 55 | 41
 |  | 7 | [NAME] | 14 | 6 | 5 | 7 | 5 | 7 | 6 | 6 | 5 | 8 | 55 | 41
 |  | 7 | [NAME] | 14 | 6 | 7 | 6 | 5 | 8 | 6 | 6 | 6 | 5 | 55 | 41
 |  | 4 | Stevie | 9 | 4 | 7 | 6 | 4 | 6 | 5 | 8 | 4 | 5 | 49 | 40
Spreadsheet: f38b0bfd-388a-459f-af49-ceb4005339e9
Sheet: School Supplies Budget

 |  |  | Back to school supplies budget
 |  |  | your name here
 |  |  | Item needed | Description | Cost | Quantity | Total |  | Actually paid | Difference
 |  |  | Paper |  | 2 | 1
 |  |  | Pencils
 |  |  | Pens
 |  |  | Notebooks
 |  |  | Art supplies
 |  |  | Backpack
 |  |  | Grand total
Spreadsheet: 219133d1362673317-dynamic-drop-down-listing-221-test-worksheet
Sheet: KIT LOC OVERVIEW

 |  | KIT | [NAME] |  |  | DURBAN | EWMS | GALLE | SUEZ | 21N - SEA PATROL |  | DURBAN | EWMS | GALLE | SUEZ | 21N - SEA PATROL
 |  | KIT001 | DURBAN
 |  | KIT002 | DURBAN
 |  | KIT003 | EWMS
 |  | KIT004 | 21N - SEA PATROL
 |  | KIT005
 |  | KIT006 | GALLE
 |  | [NAME] | DURBAN
 |  | KIT008 | DURBAN
 |  | KIT009 | EWMS
 |  | KIT010 | DURBAN
 |  | KIT011
 |  | KIT012
 |  | KIT013
 |  | KIT014
 |  | KIT015
 |  | KIT016
 |  | KIT017
 |  | KIT018
 |  | KIT019 | SUEZ
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Nov25-Dec1p

Pavilion
 | 2012-11-25 00:00:00 |  |  | Thru | 2012-12-01 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-11-25 00:00:00 | 2012-11-26 00:00:00 | 2012-11-27 00:00:00 | 2012-11-28 00:00:00 | 2012-11-29 00:00:00 | 2012-11-30 00:00:00 | 2012-12-01 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: jonathan_mckay__16901__Telus Convention
Sheet: Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Calgary Convention Centre Authority |  |  |  | Deal Date: | 2001-05-30 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: |  |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 38 | 7565
 | February | 49 | 6079
 | March | 20 | 6119
 | April | 20 | 4578
 | May | 26 | 3657
 | June | 13 | 3032
 | July | 9 | 2473
 | August | 16 | 1858
 | September | 48 | 3308
 | October | 26 | 4962
 | November | 13 | 6560
 | December | 35 | 7139
 | TOTAL:
Spreadsheet: 63794d1264666698-lognormal-distribution-function-mw-chart
Sheet: Chart

 |  |  |  | Mean | 2.241738326 | [NAME]. [NAME] | 3.64
-4
-3.75
-3.5
-3.25
-3
-2.75
-2
-1.5
-1.25
-1
-0.75
-0.5
-0.25
0
0.25
0.5
0.75
1
1.25
1.5
1.75
2
2.25
2.5 |  |  |  |  |  | size of MW contracts traded greater than 180 that were validated or not disputed
2.75
3
3.25
3.5
3.75
4
Spreadsheet: 833292d1686889515-finding-top-5-with-multiple-criteria-and-solving-for-duplicate-results-results-test-1-
Sheet: Sheet1

 |  | Example 1
 |  | State | Store | Day 1 |  | Top 5 Restaurants
 |  | CA | [NAME] 1 | 487 |  | CA | 1 | [NAME] 6 | 856 |  |  |  |  | 1 | [NAME] 6 | 856
 |  | CA | [NAME] 2 | 790 |  |  | 2 | [NAME] 2 | 790 |  |  |  | CA | 2 | [NAME] 2 | 790
 |  | CA | [NAME] 3 | 734 |  |  | 3 | [NAME] 2 | 790 |  |  |  | CA | 3 | [NAME] 4 | 790
 |  | CA | [NAME] 4 | 790 |  |  | 4 | [NAME] 3 | 734 |  |  |  | CA | 4 | [NAME] 3 | 734
 |  | CA | [NAME] 5 | 471 |  |  | 5 | [NAME] 1 | 487 |  |  |  | CA | 5 | [NAME] 1 | 487
 |  | CA | [NAME] 6 | 856 |  | NV | 1 | [NAME] 5 | 815 |  |  |  | NV | 1 | [NAME] 5 | 815
 |  | CA | [NAME] 7 | 457 |  |  | 2 | [NAME] 5 | 815 |  |  |  | NV | 2 | [NAME] 6 | 815
 |  | CA | [NAME] 8 | 276 |  |  | 3 | [NAME] 10 | 523 |  |  |  | NV | 3 | [NAME] 10 | 523
 |  | CA | [NAME] 9 | 407 |  |  | 4 | [NAME] 4 | 507 |  |  |  | NV | 4 | [NAME] 4 | 507
 |  | CA | [NAME] 10 | 302 |  |  | 5 | [NAME] 2 | 401 |  |  |  | NV | 5 | [NAME] 2 | 401
 |  | NV | [NAME] 1 | 114 |  | TX | 1 | [NAME] 4 | 960 |  |  |  | TX | 1 | [NAME] 4 | 960
 |  | NV | [NAME] 2 | 401 |  |  | 2 | [NAME] 4 | 960 |  |  |  | TX | 2 | [NAME] 8 | 960
 |  | NV | [NAME] 3 | 301 |  |  | 3 | [NAME] 6 | 721 |  |  |  | TX | 3 | [NAME] 6 | 721
 |  | NV | [NAME] 4 | 507 |  |  | 4 | [NAME] 1 | 699 |  |  |  | TX | 4 | [NAME] 1 | 699
 |  | NV | [NAME] 5 | 815 |  |  | 5 | [NAME] 7 | 534 |  |  |  | TX | 5 | [NAME] 7 | 534
 |  | NV | [NAME] 6 | 815 |  | HI | 1 | HI Store 8 | 828 |  |  |  | HI | 1 | HI Store 8 | 828
 |  | NV | [NAME] 7 | 277 |  |  | 2 | HI Store 7 | 714 |  |  |  | HI | 2 | HI Store 7 | 714
 |  | NV | [NAME] 8 | 360 |  |  | 3 | HI Store 1 | 691 |  |  |  | HI | 3 | HI Store 1 | 691
 |  | NV | [NAME] 9 | 204 |  |  | 4 | HI Store 3 | 568 |  |  |  | HI | 4 | HI Store 3 | 568
 |  | NV | [NAME] 10 | 523 |  |  | 5 | HI Store 9 | 531 |  |  |  | HI | 5 | HI Store 9 | 531
 |  | TX | [NAME] 1 | 699 |  | FL | 1 | FL Store 8 | 819 |  |  |  | FL | 1 | FL Store 8 | 819
 |  | TX | [NAME] 2 | 377 |  |  | 2 | FL Store 7 | 797 |  |  |  | FL | 2 | FL Store 7 | 797
 |  | TX | [NAME] 3 | 482 |  |  | 3 | FL Store 1 | 640 |  |  |  | FL | 3 | FL Store 1 | 640
 |  | TX | [NAME] 4 | 960 |  |  | 4 | FL Store 3 | 471 |  |  |  | FL | 4 | FL Store 3 | 471
 |  | TX | [NAME] 5 | 247 |  |  | 5 | FL Store 9 | 470 |  |  |  | FL | 5 | FL Store 9 | 470
 |  | TX | [NAME] 6 | 721
 |  | TX | [NAME] 7 | 534
 |  | TX | [NAME] 8 | 960
 |  | TX | [NAME] 9 | 366
 |  | TX | [NAME] 10 | 284
 |  | HI | HI Store 1 | 691
 |  | HI | HI Store 2 | 313
 |  | HI | HI Store 3 | 568
 |  | HI | HI Store 4 | 180
 |  | HI | HI Store 5 | 446
 |  | HI | HI Store 6 | 407
 |  | HI | HI Store 7 | 714
 |  | HI | HI Store 8 | 828
 |  | HI | HI Store 9 | 531
 |  | HI | HI Store 10 | 300
 |  | FL | FL Store 1 | 640
 |  | FL | FL Store 2 | 176
 |  | FL | FL Store 3 | 471
 |  | FL | FL Store 4 | 337
 |  | FL | FL Store 5 | 115
 |  | FL | FL Store 6 | 241
 |  | FL | FL Store 7 | 797
 |  | FL | FL Store 8 | 819
 |  | FL | FL Store 9 | 470
 |  | FL | FL Store 10 | 244
Spreadsheet: 722950d1615464265-count-duplicate-values-in-the-same-cell-and-in-a-range-example
Sheet: Sheet1

 | INVOICE DATE | SITE | PLOT(S)
 | 2021-02-26 00:00:00 | Gipping [NAME] | 123, 124, 125, 126
 | 2021-03-04 00:00:00 | Gipping [NAME] | 108, 110
 | 2021-03-05 00:00:00 | Gipping [NAME] | 108, 109
 | 2021-03-02 00:00:00 | Gipping [NAME] | 108
 | 2021-02-03 00:00:00 | Gipping [NAME] | 109
 | 2021-02-01 00:00:00 | Gipping [NAME] | 123, 124
 | 2021-02-26 00:00:00 | Gipping [NAME] | 82, 83
 | 2021-02-25 00:00:00 | Gipping [NAME] | 110, 112
 | 2021-02-24 00:00:00 | Gipping [NAME] | 123, 124, 125, 126, 127
 | 2021-02-20 00:00:00 | Gipping [NAME] | 123, 124, 125
 | 2021-02-19 00:00:00 | Gipping [NAME] | 124, 125, 126
 | 2021-02-18 00:00:00 | Gipping [NAME] | 123
 | 2021-02-17 00:00:00 | Gipping [NAME] | 124
 | 2021-02-15 00:00:00 | Gipping [NAME] | 126, 127
 | 2021-02-16 00:00:00 | Gipping [NAME] | 127
Spreadsheet: 178714d1346880572-horizontal-and-vertical-lookup-lookupmatchsample
Sheet: Sheet1

 | HireDate1 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | Grand Total
 | 2011-06-01 00:00:00 | 5 | 13 | 22 | 23 | 27 | 30 | 37 | 36 | 35 | 39 | 32 | 299
 | 2011-07-01 00:00:00 |  |  | 3 | 6 | 4 | 10 | 4 | 5 | 3 | 9 | 10 | 54
 | 2011-08-01 00:00:00 |  | 6 | 14 | 40 | 45 | 50 | 50 | 51 | 51 | 61 | 57 | 425
 | 2011-09-01 00:00:00 |  |  |  | 7 | 20 | 30 | 34 | 32 | 29 | 27 | 34 | 213
 | 2011-10-01 00:00:00 |  |  |  |  | 6 | 9 | 24 | 19 | 17 | 15 | 26 | 116
 | 2011-11-01 00:00:00 |  |  |  | 1 | 1 | 8 | 27 | 34 | 35 | 47 | 44 | 197
 | 2012-01-01 00:00:00 |  |  |  |  |  |  |  | 1 | 7 | 4 | 17 | 29
 | 2012-02-01 00:00:00 |  |  |  |  |  |  |  |  | 1 | 11 | 22 | 34
 | 2012-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 | 1
 | 2012-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2 | 10 | 12
 | Grand Total | 5 | 19 | 39 | 77 | 103 | 137 | 176 | 178 | 178 | 215 | 253 | 1380
 | Class of | # of Hires | 2011-06-01 00:00:00 |  | 2011-07-01 00:00:00 |  | 2011-08-01 00:00:00 |  | 2011-09-01 00:00:00 |  | 2011-10-01 00:00:00 |  | 2011-11-01 00:00:00 |  | 2011-12-01 00:00:00 |  | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00
 |  |  | # | $ | # | $ | # | $ | # | $ | # | $ | # | $ | # | $ | # | $ | # | $ | # | $ | # | $ | # | $ | # | $
 | 2011-06-01 00:00:00 | 6
 | 2011-07-01 00:00:00 | 2
 | 2011-08-01 00:00:00 | 12
 | 2011-09-01 00:00:00 | 9
 | 2011-10-01 00:00:00 | 4
 | 2011-11-01 00:00:00 | 11
 | 2011-12-01 00:00:00 | 2
 | 2012-01-01 00:00:00 | 6
 | 2012-02-01 00:00:00 | 8
 | 2012-03-01 00:00:00 | 2
 | 2012-04-01 00:00:00 | 17
 | 2012-05-01 00:00:00 | 2
 | 2012-06-01 00:00:00 | 17