tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18857__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-15 00:00:00 |  | 190.53 | 14720 | 144.42 | 7600
 | 2001-03-14 00:00:00 |  | 177.21 | 17120 | 139.11 | 8840
 | 2001-03-13 00:00:00 |  | 178.33 | 18000 | 141.6 | 9400
 | 2001-03-12 00:00:00 |  | 207.12 | 14000 | 167.55 | 6200
 | 2001-03-11 00:00:00 |  |  |  |  |  | 167.57 | 18000
 | 2001-03-10 00:00:00 |  | 189.97 | 30000 | 155.94 | 17200
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
Spreadsheet: 887417d1737651833-get-data-from-one-sheet-and-make-a-weekly-timesheet-ef1664_test
Sheet: SHEET 1

Date/time | Name | Action
2025-01-03 10:21:00 | PERSON 1 | IN |  | <== Corrected dates
2025-01-03 08:45:32 | PERSON 2 | IN
2025-01-03 11:14:13 | PERSON 3 | IN
2025-01-03 16:55:22 | PERSON 1 | OUT
2025-01-03 16:55:22 | PERSON 2 | OUT
2025-01-03 16:55:22 | PERSON 3 | OUT
Spreadsheet: 845162d1696684065-looking-for-non-array-formula-to-extract-values-if-condition-is-met-extract-values_sample_2
Sheet: Sheet2

Employment Status |  |  | Employment Status Selection |  | S/N | First Name | Last Name | Name (Combined) | [NAME] |  | Name | Name (By Status) | Status |  |  |  |  |  |  |  |  |  |  |  | Employment Status | Checkbox | Left [ | Employment Status |  | Helper |  | [NAME] |  |  |  | Cond | LEN |  | LEN
 | Active |  |  |  | 1 | [NAME] | Davolio |  | Active |  |  | Davolio, [NAME] | Active |  |  |  |  |  |  |  |  |  |  |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  | Sum
 | Inactive |  |  |  | 2 | [NAME] | Fuller |  | Terminated |  |  | Smith, Emily | Active |  |  |  |  |  |  |  |  |  |  |  |  | True
 | Terminated |  |  |  | 3 | [NAME] | Doe |  | Inactive |  |  | Doe, [NAME] | Inactive |  |  |  |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  | 4 | Emily | Smith |  | Active
Spreadsheet: 21118d1208269299-listing-cells-that-meet-a-criteria-trsetparameters
Sheet: Parameters

 |  |  | Oil Screen
 |  |  | Rating | Neutralization Number | D877 | SPGR | Visual | Sediment
 |  |  | Acceptable | [NAME] 0.08 | Value [NAME] 30 kV | 0.95 ≤ Value ≤ 0.98 | CLR | NONE
 |  |  | Questionable | 0.08 > Value ≤ 0.10 | 25 kV ≤ Value < 30 kV | Value < 0.95
 |  |  | Unacceptable | Value > 0.10 | Value < 25 kV | Value > 0.98
Spreadsheet: 849242d1699766954-how-to-text-join-based-on-criteria-but-only-return-the-first-3-values-text-join
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 4+ | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  | 0.4
 |  |  | Average |  |  |  |  |  |  |  |  | 0.3
 |  |  |  | 0.69 | 0.75 | 0.7 | 0.63 | 0.48 |  |  |  | 0.2
 |  |  | 31.497 | 78 | 0.65 | 0.45 | 0.12 | 0.88 |  |  |  | 0.1
 |  |  | 0.7485714285714287 |  | 0.74 | 0.76
 |  |  | 0.43 | 0.01 |  |  | 0.99
Spreadsheet: 267526d1380103168-data-validation-limit-based-on-previous-choice-data-validation-answer
Sheet: Data

First month | Last month |  | I am applying data validation to cells and would like to limit the range based on a value entered in the preceding cell. | ` |  |  | Apr
Aug | Aug |  |  |  |  |  | May
Nov | Nov |  | In the attached, in column A you can select any month in the list in column H. |  |  |  | Jun
Mar | May |  |  |  |  |  | Jul
 |  |  | In column B I would like to restrict the list to months after that chosen in A. |  |  |  | Aug
 |  |  |  |  |  |  | Sep
 |  |  | I have been trying to use OFFSET and MATCH but haven't found anything that works yet, does anybody have any advice? |  |  |  | Oct
 |  |  |  |  |  |  | Nov
 |  |  | I'm also not sure how to get round the problem of someone choosing column B first... |  |  |  | Dec
 |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  | Mar
Spreadsheet: 193437d1352832363-how-autofill-works-with-more-than-2-cells-book8
Sheet: Sheet1

 | Example 1 |  |  |  | Example 2
 | 2 |  |  |  | 3
 | 3 |  |  |  | 8
 | 6 |  |  |  | 11
 | 7.66666666666667 | 4 | 7.666666666666666 |  | 15.3333333333333 | 8 | 15.33333333333333
 | 9.66666666666667 | 6 | 9.666666666666666 |  | 19.3333333333333 | 12 | 19.33333333333333
 | 11.6666666666667 | 8 | 11.66666666666667 |  | 23.3333333333333 | 16 | 23.33333333333333
Spreadsheet: 867505d1714379305-substitute-with-array-of-criteria-substitute-with-array-of-criteria
Sheet: Sheet1

 | Data |  |  | Criteria to remove in data set |  |  |  | Required Output
 | text1 abc |  |  | text1 |  |  |  | abc
 | def [NAME] text1 |  |  | text2 |  |  |  | def
 | 39734 sdlkdjs - text3 |  |  | - text3 |  |  |  | 39734 sdlkdjs
 | sksj [NAME] (50 mins) |  |  | (50 mins) |  |  |  | sksj [NAME]
 | sksj [NAME] (50 mins) |  |  | text4 |  |  |  | sksj [NAME]
 | (50 mins) ghi moretext |  |  | moretext |  |  |  | ghi
 | text1 - text3 jkl |  |  |  |  |  |  | jkl
Spreadsheet: 63369d1264280997-excel-2008-value-results-from-xl-bug-beta_budgetmaster
Sheet: Lists

 |  | R
Account | Budget |  |  | Type | Type
Awards | 20 |  |  | Check | Check
Degree expense | 200 |  |  | Deposit | Deposit
Demolay | 200 |  |  | Debit Card | Debit Card
Donation - MLA | 150 |  |  |  | Bank Charge
Donations - other | 200
Dues - Lifetime | 300
Dues - Other | 500
Dues - Regular | 3000
GL Comm Assis. | 700
GL fees | 300
Insurance | 150
IORG | 200
JDI | 222
Meals - Regular | 1200
Meals - Special | 500
Postage | 500
Printing and Copy | 400
Rent | 1400
Scholarships | 3000
Sec/Treas fee | 750
Supplies - GL | 250
Supplies - Office | 1200
Supplies - Lodge | 300
Spreadsheet: 776752d1649885321-hlookup-sorting-hlookup
Sheet: Sheet1

Name | Score
 |  |  | Score | 100 | 90 | 80 | 98 | 85 | 100
 |  |  | Name | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Something like this though for some reason its not finding the [NAME]'s 100??
 | On my actual document it is writing just like this but it shows all the names correct
 | just in an order from right to left in my document??
Spreadsheet: 124761d1318597538-from-one-excel-cell-to-multiple-files-blah1
Sheet: another tab here, unused

 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.5
 |  |  |  |  | 203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | data set for graph
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.2475
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 0.2475
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1.122
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 1.122
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 0.2475
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 159 | 0.8745
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Depth
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top: | 0.2475
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Base: | 1.122
Contract No. | 0 |  |  | Co-ordinates (E,N) |  |  | 416344.451 | 6225426.297 | CRS: | 0 |  |  | CPT Number:
Area | 0 |  |  | Water Depth (m [NAME]) |  |  | 74.61 |  | Comments: |  |  |  | [NAME]
 |  |  |  | Date of Test |  |  | 1999-01-12 00:00:00 |  | 0
Vessel | 0 |  |  | Cone Number |  |  | (cm²)
Client | 0 |  |  | Base Inclination (Combined) |  |  |  |  | [NAME]: |  | Checked |  | [NAME] filename : |  | 0
Spreadsheet: 771441d1646672911-joining-columns-ignoring-blank-cells-test-file
Sheet: Sheet1

First Name | Last Name | suffix | UserCertificationName
[NAME] | [NAME]
Vivian | Teran |  | |CCHP|CPM
Stanley | Searcy
[NAME] | Lungha
[NAME] | Fluellen
[NAME] | [NAME]
[NAME] | Ahrens |  | |MBA
[NAME] | [NAME]
Michelle | Deforest
[NAME] | Heil
Kelly | Splinter
[NAME] | McMillian
[NAME] | [NAME]
[NAME] | [NAME]
Hector | Lara
[NAME] | [NAME]
[NAME] | Nunley
[NAME] | [NAME]
[NAME] | Odebralski
Kuanasia | Murphy
[NAME] | Nash
Christina | Cruz
Mark | [NAME]
Chance | [NAME]
Astrid | Fuentes
America | Hernandez
[NAME] | Venegas
Miguel | Vidal
[NAME] | Wilson
[NAME] | Cosgrove
[NAME] | Klein |  | |CCE
Crystal | Atkinson
[NAME] | Iverson
[NAME] | Escobedo
[NAME] | Gillespie
[NAME] | Shorkey
[NAME] | Hurley
[NAME] | Petrykowski
[NAME] | Willis
[NAME] | Rodriguez
George | Trippany
Shannon | Payne
[NAME] | [NAME] |  | |CCO|CJM|CPM|MS
[NAME] | [NAME]
Fredy | Cueva
Mark | Mendoza
[NAME] | Morris
[NAME] | [NAME]
George | Brotchi
Calvin | [NAME]
Todd | Schlines
[NAME] | [NAME]
[NAME] | Geeting
[NAME] | [NAME]
Tijuan | [NAME]
[NAME] | [NAME]
Gerardo | Moreno
[NAME] | Gil
[NAME] | Page
[NAME] | Baranic | Esq.
[NAME] | Cupit
Maria | Marquez
Amber | [NAME]
[NAME] | Carranza
[NAME] | Richardson
Deann | Bertram |  | |CPM
[NAME] | Brock
Adam | Falk
[NAME] | [NAME]
Callie | Locklear
[NAME] | [NAME]
[NAME] | [NAME]
George | Holt | IV
[NAME] | Zierfus
Spreadsheet: 694271d1599493345-how-to-use-vlookup-with-changing-table-array-sample
Sheet: Sheet2

country | year | Code | value
BE | 1 | A | 13.14949645
BG | 1 | A | 7.10063264
CZ | 1 | A | 3.2657067
DK | 1 | A | 9.70402683
DE | 1 | A | 3
EE | 1 | A | 12.99360932
BE | 2 | A | 20.03528441
BG | 2 | A
CZ | 2 | A | 18.16884898
DK | 2 | A | 13.95231504
DE | 2 | A | 11.71710219
EE | 2 | A | 10.15221192
BE | 1 | B | 15.50549587
BG | 1 | B | 13.07703133
CZ | 1 | B | 4
DK | 1 | B | 2
DE | 1 | B | 1
EE | 1 | B | 1
BE | 2 | B | 2
BG | 2 | B | 24
CZ | 2 | B | 6
DK | 2 | B | 5
DE | 2 | B | 3
EE | 2 | B | 18
Spreadsheet: 9e12236c-4e92-43b8-b8d9-52b91229f067
Sheet: ENGL 303

COURSE ASSESSMENT MATRIX
Engl 303 Grammar and Linguistics Prerequisite: Engl 113. This course is a study of language usage and English grammar. Topics include a study of current approaches to English grammar and language use. Relationships between English and Lakota language structures will be discussed.  3 credits
Goal:  The goal of this course is to teach students language use and grammar.
Objective | Assessment Method | Desired Result | Corrective Action
Achieve a basic mastery of English grammar (the eight parts of speech) necessary to teach K - 8. | Weekly Assignments                Quizzes & Exams                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                      80% students pass Exams 80% students pass writing assignments | [NAME] Weekly Assignments                      Revise Rubrics
Display a basic understanding of the nature of language as an oral, symbolic system by which human beings interact and communicate. | Weekly Assignments                Quizzes & Exams                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                      80% students pass Exams 80% students pass writing assignments | [NAME] Weekly Assignments                      Revise Rubrics
Display a basic understanding of the  history of English and how English continually changes in vocabulary, syntax and pronunciation. | Weekly Assignments                Quizzes & Exams                                          Class Participation  Writing projects scored with Rubric | Weekly Assignments Completed                                      80% students pass Exams 80% students pass writing assignments | [NAME] Weekly Assignments                      Revise Rubrics
Date | Form of Assessment and Actions Taken
Spring 2011 | Syllabus Reviewed --Mainly looked to see that all sections on checklist were present.  Scheduled to review content during the Fall 2011 semester.
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Date | Form of Assessment and Actions Taken
Spreadsheet: 223355d1364180131-referring-to-different-matrices-dependant-on-value-entry-multimatrix-ref
Sheet: Product C

 | 3m | 5m | 8m | 10m | 12.5m | 16m | 20m | 22m | 25m
2T | Model T | [NAME] | Model TL | Model TXL | Model TXXL | [NAME] | Model TGG | Model TGG2 | Model TGG3
5T | [NAME] | Model UM | [NAME] | Model UXL | Model UXXL | Model UG | Model UGG | Model UGG2 | Model UGG3
7T | Model V | Model VM | Model VL | Model VXL | Model VXXL | Model VG | Model VGG | Model VGG2 | Model VGG3
10T | [NAME] | Model WM | [NAME] | [NAME] | Model WXXL | Model WG | Model WGG | Model WGG2 | Model WGG3
12T | Model X | Model XM | Model XL | Model XXL | Model XXXL | Model XG | [NAME] | Model XGG2 | [NAME]
15T | Model Y | Model YM | Model YL | Model YXL | [NAME] | Model YG | [NAME] | Model YGG2 | Model YGG3
30T | Model Z | Model ZM | Model ZL | Model ZXL | Model ZXXL | Model ZG | [NAME] | [NAME] | [NAME]
Spreadsheet: 695789d1600395523-formula-to-find-lowest-time-n-2-groups-then-the-difference-between-them-ignoring-sample-data-1
Sheet: Sheet1

 |  |  |  |  |  |  |  | F | G | H | I
 |  |  |  |  |  |  |  | amb | fire | amb | fire
 |  |  |  |  |  |  |  | 23:15:09 | 23:19:18 | 23:00:00 | 23:20:00
 |  |  |  |  |  |  |  | 23:19:18 | 23:15:09 | 23:20:00 | 23:00:00
 |  |  |  |  |  |  |  | 23:19:18 | 23:15:09 | - | 23:00:00
 |  |  |  |  |  |  |  | 23:19:18 | 23:15:09 | 23:20:00 | -
Spreadsheet: 440232d1452703404-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2016
Sheet: Summary

 | Total Hours Used | Start Date | 1 Year | 3 Years
A |  | 2014-10-23 00:00:00 | 2015-10-23 00:00:00 | 2017-10-23 00:00:00
B |  | 2014-11-11 00:00:00 | 2015-11-11 00:00:00 | 2017-11-11 00:00:00
C |  | 2015-08-11 00:00:00 | 2016-08-11 00:00:00 | 2018-08-11 00:00:00
D |  | 2014-10-27 00:00:00 | 2015-10-27 00:00:00 | 2017-10-27 00:00:00
E |  | 2015-03-30 00:00:00 | 2016-03-30 00:00:00 | 2018-03-30 00:00:00
F |  | 2015-03-21 00:00:00 | 2016-03-21 00:00:00 | 2018-03-21 00:00:00
G |  | 2015-05-29 00:00:00 | 2016-05-29 00:00:00 | 2018-05-29 00:00:00
H |  | 2013-11-20 00:00:00 | 2014-11-20 00:00:00 | 2016-11-20 00:00:00
J |  | 2012-08-31 00:00:00 | 2013-08-21 00:00:00 | 2015-08-21 00:00:00
K |  | 2014-01-27 00:00:00 | 2015-01-27 00:00:00 | 2017-01-27 00:00:00
L |  | 2012-07-09 00:00:00 | 2013-07-09 00:00:00 | 2015-07-09 00:00:00
N |  | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2018-01-01 00:00:00
O |  | 2010-07-20 00:00:00 | 2011-07-20 00:00:00 | 2013-07-20 00:00:00
 | as of 8/18/15 |  | 40 hours avail | 80 hours avail
Spreadsheet: 836924d1689727143-display-corresponding-text-field-based-on-max-value-fabric
Sheet: Sheet1

Year | Silk | Cotton | Wool
2019 | 1 | 2 | 1
2020 | 0 | 0 | 1
2021 | 1 | 2 | 1
2022 | 1 | 1 | 1
2023 | 1 | 1 | 1
Totals
The prefered fabric is
The second preferered fabric is |  |  | Wool
Spreadsheet: 770780d1646246361-manipulating-text-string-data-into-separate-columns-formatting-per-person-cost
Sheet: Sheet1

Data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Desired Output [Manual]
$1,139 – $1,329 / Person |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1139 | 1329 | / Person
2450 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2450
$1,139 – $1,329 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1139 | 1329
$795 – $1,800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 795 | 1800
$500 – $13,800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | 13800
$887 – $19,978 / Person |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 887 | 19978 | / Person
$2,425 – $12,450 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2425 | 12450
3100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3100
$1,613 / Person |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1613 |  | / Person
Spreadsheet: 39904d1238154597-looking-up-a-range-of-cells-with-criterias-attached-forum-example-answer-version-1-
Sheet: Handlers

Agent | Band | Rate | Value
[NAME] | Euro | 0.56 | 1.4
[NAME] | IRL NB | 0.2 | 1.2 |  |  | Band & Rate can vary from day to day.
[NAME] | All-In-One | 0.25 | 1
[NAME] | IRL NB | 0.125 | 0.8
Zak | PEN | 0.12 | 0.8
Spreadsheet: benjamin_rogers__1008__NY trading contacts
Sheet: Sheet1

Generators | Trader | Telephone #
Ontario Power Generation | [NAME] | [PHONE] | dailies
 | [NAME] | [PHONE] | term
AES Eastern Energy | AnnMarie Reynolds | [PHONE] | dailies
 | [NAME] | [PHONE] | term
 | [NAME] | [PHONE]
[NAME] | Symeon [NAME] | [PHONE] | term/dailies
 | Alain LeBlanc | [PHONE] | real time
 | Nick Demers | [PHONE] | backup
Utilities
NYSEG | [NAME] | [PHONE]
 | [NAME] | [PHONE]
 | [NAME] | [PHONE]
 | Debbie Manning | [PHONE]
 | [NAME] | [PHONE]
Rochester Gas & Electric | [NAME] | [PHONE] | [PHONE]
 | [NAME] | [PHONE] | [PHONE]
 | [NAME] | [PHONE] | [PHONE]
 | [NAME] | [PHONE] | [PHONE]
 | [NAME] | [PHONE] | [PHONE]
 | [NAME] | [PHONE] | [PHONE]
[NAME] | [NAME] | [PHONE]
 | [NAME] | [PHONE]
 | [NAME] | [PHONE]
 | [NAME] | [PHONE]
Consolidated Edison | [NAME] | [PHONE]
 | Darsh Jain | [PHONE]
 | [NAME] | [PHONE]
[NAME] | [NAME] | [PHONE]
[NAME] | [NAME] | [PHONE] | term
 | Darin Colangelo | [PHONE] | dailies
 | [NAME] | [PHONE] | dailies
 | [NAME] | [PHONE]
ConEdison Energy | [NAME] | [PHONE]
 | [NAME] | [PHONE]
 | Trading Hotline | [PHONE]
Spreadsheet: 700789d1603346290-complicated-look-up-with-spaces-in-search-table-complicated-look-up-from-table-with-spaces
Sheet: ISSUE

 | 07018 |  |  |  |  |  |  |  |  |  |  |  |  | DHL EXPRESS (AUSTRALIA) PTY LTD | DP924650 | DH511 | DHL MAIN LEASE |  |  |  | 01-OCT-17 | 30-SEP-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07-AV-007018 |  |  | NE SECTOR | AVIATION | DOMESTIC FREIGHT | 01-OCT-17 | 30-SEP-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07-AV-007043 |  |  | NE SECTOR | AVIATION | DOMESTIC FREIGHT | 01-OCT-17 | 30-SEP-29
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DHL | 07-AV-007056 |  |  | NE SECTOR | AVIATION | DOMESTIC FREIGHT | 01-OCT-19 | 30-SEP-29
Spreadsheet: 59321d1259801255-if-function-excel-problem
Sheet: Sheet1

 | Week's Late | Penalties |  | [NAME] | Week's Late
 | 0 | 0 |  | 0 | 0 |  | i need the forumla to give those values and change in column C if the
 | 0 | 0 |  | 2 | 1 |  | value in column B changes.
 | 0 | 0 |  | 4 | 2
 | 0 | 0 |  | 6 | 3
 | 1 | -2 |  | 20 | 4 |  | B8 = so i need the spreadsheet to take away E5, but if i change B8 to 2
 | 2 | -4 |  |  |  |  | the spreadsheet must take away E6
 | 3 | -6
 | 4 | -20
 | 0 | 0
 | 1 | -2
 | 0 | 0
Spreadsheet: 848592d1699294133-align-data-from-rows-to-columns-parent-1-and-2-example-2-
Sheet: Sheet2

 | Student First | Parent [NAME] | Parent First | Parent [NAME] | Parent First | Parent [NAME] | Parent First | Parent [NAME] | Parent First
[NAME] | [NAME] | [NAME] | Mom | [NAME] | Dad | Guardian | One | Guardian | Two
[NAME] | Kaylee | [NAME] | Daddy | [NAME] | Mommy
Spreadsheet: 830734d1685062891-organizing-text-from-random-cells-into-one-column-s666-pq-organizing-text-from-random-cells-into-one-column
Sheet: Result2

MS | UQ | VC | VG | VQ | YC | YG | YQ | ZA | ZC | ZG
MSDAI07,MSDAI09,MSDAI01,MSDAI05 | UQR01MLT | VCX90323 | VGX90323 | VQQ02MLT | [NAME] | YGA05323,YGA03323,YGA20323,YGA18323,YGA07323 | YQQ01MLT,[NAME] | ZAL05MLT | ZCL15MLT | ZGL16MLT
Spreadsheet: 34db85eb-d4b4-4622-ade8-4f56979e9beb
Sheet: Reference Tables

[NAME] of ammonium nitrogen available this year.
Sidedress Application
 | Incorporated | 1
 | Sprinkler irrigation | 0.5
Preplant Application and Not Incorporated
 | Surface - spring or fall | 0
Preplant Application and Incorporated
 |  | Solid | Liquid Applied When Air Temperature is Above 50°F | Liquid Applied When Air Temperature is At or Below 50°F
 | Immediately | 0.95 | 0.95 | 0.95
 | One day later | 0.5 | 0.7 | 0.7
 | Two days later | 0.25 | 0.5 | 0.55
 | Three days later | 0.15 | 0.25 | 0.45
 | Seven or more days later | 0 | 0 | 0.4
Table II. Fraction of organic nitrogen available this year.
Beef/Dairy
 | Solid (e.g. feedlot) |  | 0.25
 | Stored liquid |  | 0.35
 | Compost |  | 0.15
Poultry
 | Deep pit |  | 0.45
 | Solid with litter |  | 0.3
 | Solid without litter |  | 0.35
Swine
 | Fresh |  | 0.5
 | Stored liquid |  | 0.35
Table III. Organic [NAME] over time.
Rotation
 | corn-soybeans |  | 0.1
 | corn-corn |  | 0.2
 | soybeans - corn |  | 0.2
 | corn-alfalfa-alfalfa |  | 0
Spreadsheet: 599782d1543313289-formulas-for-error-messages-honda-servicing-guide
Sheet: Sheet1

 | Age Or Mileage | Base Service | Petrol | Diesel | Type R |  |  |  |  |  |  |  |  |  | List 1 | List 2
 |  |  | 210 | 230 | 230 |  |  |  | Fuel Type | Age/Mileage |  |  |  |  | Petrol 10 | 1 Year or 12,500 miles
 | 1 Year or 12,500 miles | AB or 12 month/12,500 miles |  |  |  |  |  |  | Petrol 10 | 6 Year or 75,000 miles |  |  |  |  | Diesel 20 | 2 Year or 25,000 miles
 |  |  | 280 | 300 | 300 |  |  |  |  |  |  |  |  |  | Type R 30 | 3 Year or 37,500 miles
 | 2 Year or 25,000 miles | AB2 or 24 months/25,000 miles | Add 3/CVT fluid if CVT |  | Add 9 |  |  |  | 10 | 6 |  |  |  |  |  | 4 year or 50,000 miles
 |  |  | 260 | 280 | 280 |  |  |  | 10 | 1 |  |  |  |  |  | 5 Year or 62,000 miles
 | 3 Year or 37,500 miles | AB78 |  | Add 4 |  |  |  |  | 20 | 2 |  |  |  |  |  | 6 Year or 75,000 miles
 |  |  | 165 | 185 | 185 |  |  |  | 30 | 3
 | 4 year or 50,000 miles | AB2 or Honda 12 & pollen Filter | Add 3 /CVT fluid if CVT |  | Add 9 |  |  |  | Has the customer done 75,000 miles?
 |  |  | 165 | 185 | 185 |  |  |  | 1 For Yes, 2 for No
 | 5 Year or 62,000 miles | AB or Honda 12 | Add 9 if at 62,500 miles | Add5 |  |  |  |  | 2
 |  |  | 270 | 290 | 290
 | 6 Year or 75,000 miles | AB378 or Honda 12+ & Trans oil change | Add 4 at 75,000 miles | Add 4 (2012 any model onwards) Add tranfer box oil if 2013 onwards CRV Diesel Auto only | Add 9
 |  |  |  |  |  |  |  |  |  | Air Filter £50 | Pollen Filter £48 | Petrol Fuel Filter £160 | Diesel Fuel Filter £116
 |  |  |  |  |  |  |  |  |  | 4x Iridium spark plugs £160 | Valve Clearance £100 | Manual Gearbox Oil £85 | Auto box Fluid £85
 | A | B | 2 | 3 | 4 |  |  |  |  | CVT Fluid £85 | [NAME] £35 | Brake Fluid £65 | Steel Spark Plugs £90 for 4 £180 for 8 (JAZZ UP TO 2009)
 | Oil filter | Check | [NAME] | [NAME] | Spark Plug |  |  |  |  | Transfer Box Oil £85 | Rear Differential Oil £85 | Coolant Change £85
 | 5 | 7 | 8 | 9 | 10
 | Coolant | Brake Fluid | Air Filter | Valve Clearance | [NAME]
 |  | If the customer has a tailored plan- find out what is covered then apply extras that are not included
 |  | If the customer has an approved used plan or a plan from new - all extras are included
Spreadsheet: 700272d1603107878-countifs-with-date-between-formula-book2
Sheet: PIP Data

 | 26/09/2020 - 23/10/2020 |  |  | 24/10/2020 - 20/11/2020
 | H | M | L | H | M | L
PIP MH |  | 0 | 0 | 0 | 0 | 0
PIP WPT | 0 | 0 | 0 | 0 | 0 | 0
PIP RR | 0 | 0 | 0 | 0 | 0 | 0
 | I want to use countifs to count how many lines are between the 2 dates (which are listed in the validation page) and of those if they are High and are listed as either PIP MH, PIP WPT or PIP RR
 | all the data should come from the Site tab
Column A Sites | Action raised should fit between the two dates above to be counted
Column G | Will give the data whether its migh medium or low
Column H | will provide the data for PIP MH etc