tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Comp Info Tech 3

COMPUTER AND INFORMATION TECHNOLOGY
Associate of Applied Science Degree
Student Name:
ID #
Information Security Track | Semester | Grade
___ CIT 182 (3) Perimeter Defense
___ CIT 184 (3) Attacks and Exploits
___ CIT 217 (3) UNIX/Linux Administration
___ Approved Network Elective Course (3)
___ Approved Network Elective Course (3)
___ Approved Security Elective Course (3)
___ Approved Technical Course(s) (6)
Internet Technologies Track
___ CIT 150 (3) Internet Technologies
OR ___CIT 155 (3) Web page Development
___ CIT 157 (3)Web Site Design and Production
___ CIT 253 (3) Date-Driven Web Pages: Topic
___ CIT 257 (3) Applied Internet Technologies
OR ___ CIT 258 (3) Internet Technologies Seminar
___ Completion of Internet Technologies Specialization Sequence (12)
Web Programming Specialization Sequence
___ Approved Level I Programming Language (3)
___ Approved Level II Programming Language (3)
___ CIT 171 (3) SQL I
___ Approved CIT Technical Course
Web Administration Specialization Sequence
___ CIT 219 (3) Internet [NAME]
___ CIT 255 (3) Web Server Administration
___ CIT 261 (3) MS Active Directory Services
AND ___ CIT 213 (3) MS Client/Server Configuration
OR ___CIT 262 (3) MS Network Infrastructure
AND ___ CIT 213 (3) MS Client/Server Configuration
OR ___ CIT 217 (3) UNIX/Linux Net Infrastructure
AND ___ CIT 218 UNIX/Linux Net Infrastructure
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 857465d1706483212-listing-column-headings-based-on-cell-values-mosom-9
Sheet: Sheet1

 | Role 1 | Role 2 | Role 3 | Role 4 | Role 5 |  |  | Drop down list of Permissions: | Permission 1
Permission 1 | y |  | y |  | y
Permission 2 |  | y |  | y
Permission 3 | y |  | y |  | y |  |  | What I want to appear: | Role 1
Permission 4 |  |  | y | y |  |  |  |  | Role 3
Permission 5 | y | y |  | y | y |  |  |  | Role 5
 |  |  |  |  |  |  |  | if the drop down selection is changed, this list repopulates with the relevant [NAME]
Spreadsheet: 216447d1361779658-find-data-betwwen-two-dates-find-data-between-2-dates-rev
Sheet: Sheet2

COL A | [NAME] | Start_date | End_date |  |  | 2012-01-01 00:00:00
1234 | DONE | 2012-01-01 00:00:00 | 2012-02-02 00:00:00 |  |  | 2012-04-22 00:00:00
12344 | NOT | 2012-02-21 00:00:00 | 2012-02-21 00:00:00
34323 | DONE | 2012-03-15 00:00:00 | 2012-03-16 00:00:00
45678 | NOT | 2012-01-13 00:00:00 | 2012-01-15 00:00:00
Spreadsheet: 139737d1328428581-solved-rate-as-result-of-multiple-cells-and-tables-basic-invoice-2-
Sheet: Invoice

To: | Client1
 |  |  |  |  | INVOICE
Code | Table | Area | Density | Net | Cuft |  |  |  |  | For OUT 4 we have 3 rates depending on Density:
4 | 2011 | [NAME] |  | 1000 | 200 |  |  |  |  | Low=under 5.5
 |  |  |  |  |  |  |  |  |  | Normal=between 5.5 and 5.9
 |  |  |  |  |  |  |  |  |  | High=over 6.0
 |  |  |  |  |  |  |  |  |  | Density is Calculated by entering manually "Net" and Cuft"
In or Out |  | Rate
Out
Spreadsheet: 69802d1270474575-countif-in-two-columns-sample
Sheet: Feuil1

Location 1
week1 |  | sample1 | p 74 |  | SD(E) | 01-08-2005 | 01-08-2005
week2 |  | sample2 | G 88 |  | SD(E) | 08-08-2005 | 02-08-2005
week3 | 8 | [NAME] | G 567 |  | SD(E) | 16-08-2006 | 02-08-2005
week4 |  | sample4 | G 676 |  | SD(E) | 23-08-2005 | 02-08-2005
week5 | 9 | sample5 | G 89 |  | SD(E) | 02-08-2005 | 02-08-2006
week6 |  | sample6 | G 6 |  | SD(E) | 02-08-2005 | 03-08-2007
week7 | 4 | sample7 | P 166 |  | SD(E) | 03-08-2005 | 04-08-2005
[NAME] | 1 | [NAME] | P 775 |  | SD(E) | 04-08-2005 | 04-08-2005
Location 2
week1 |  | sample1 | G 66 |  | SD(E) | 04-08-2005 | 07-08-2005
week2 | 3 | sample2 | G 72 |  | SD(E) | 08-08-2005 | 08-08-2005
week3 | 14 | [NAME] | G 90 |  | SD(E) | 08-08-2005 | 08-08-2005
week4 | 1 | sample4 | G 91 |  | SD(E) | 08-08-2005 | 08-08-2005
week5 |  | sample5 | G 92 |  | SD(E) | 08-08-2005 | 08-08-2005
week6 | 6 | sample6 | G 93 |  | SD(E) | 08-08-2005 | 10-08-2005
Location 3
week1 |  | sample1 | p 12 |  | TB(E) | 10-08-2005 | 10-08-2009
week2 |  | sample2 | p 13 |  | TB(E) | 10-08-2005 | 10-08-2010
week3 |  | [NAME] | p 14 |  | TB(E) | 10-08-2005 | 10-08-2006
week4 | 8 | sample4 | p 737 |  | TB(E) | 10-08-2005 | 10-08-2008
Spreadsheet: 157500d1337768634-productivity-calculation-example
Sheet: States

Login | Unproductive
AgentAuxWork 0 | Unproductive
Login-Phone | Unproductive
AgentAuxWork 9 | unproductive
AgentManualIn | Productive
CallRinging | Productive
CallInbound | Productive
AgentAfterCallWork | Productive
CallOnHold | Productive
CallConsult | Productive
CallOutbound | Productive
AgentAuxWork 5 | Unproductive
AgentAuxWork 3 | Unproductive
AgentAuxWork 1 | Unproductive
AgentAuxWork 2 | Unproductive
AgentAuxWork 6 | Unproductive
AgentAuxWork 4 | Unproductive
AgentAuxWork 8 | Unproductive
AgentAuxWork 7 | Unproductive
CallInternal | Productive
CallUnknown | Productive
Spreadsheet: 160326d1339053025-can-i-use-my-spreadsheet-graph-as-a-screen-saver-departmental-screen-shot-data
Sheet: CABLES

Cable Dept.
 | Week 20 |  | Dept. [NAME] |  | Plant Average 2012
On Time Delivery | 100 | % | 92.27 | % | 86.75 |  | % | >100Green  >90-100 Amber <90 Red
 | Week 20 |  | Dept. [NAME] |  | Plant Average 2012
Efficiency | 93 | % | 90.64 | % | 76.82 |  | % | >75  Green  70-75Amber       < 70 Red
 | Week 20 |  | Dept. [NAME] |  | Plant Average 2012
Throughput Days | 2.64 | % | 2.9 | % | 4.96 |  | % | <5 Green   5-7 Amber >7 Red
 | Week 20 |  |  |  | Plant Average 2012
Overheads | 24.72 |  |  | % | 23.48 |  | %
 | Week 17 |  | Dept. [NAME] |  | Plant Average 2012
Extra Time |  | % | 0.05 | % | 0.34 |  | %
Spreadsheet: d86a67b5-f7c5-4b33-b6b0-9774e587c9d2
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
SOLEF | Test | SOLEF | Sole, IgE | Sole, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
SOLEF | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SOLEF | Result | SOLEF | Sole, IgE | Sole, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7709-9
Spreadsheet: 476106d1471617617-fil-an-excel-sheet-automatically-test-for-pete
Sheet: Synthesis

Synthesis | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | total 2016/2019 | VAR 2016/2019 | VAR 2015/2019 | CAGR 2016/2019 |  |  |  | [NAME] | COUNT - Projects |  |  | SHEET - Projects | ROW - Projects |  | [NAME] | COUNT - Initiatives |  |  | SHEET - Initiatives | ROW - Initiatives
Total Sales projection
PAM | 1
Market Share
Sales projection %
Organic sales W/o:      - Delta P      - Growth initiatives      - New offers | 1
Growth assumptions |  | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01
Organic Value
Organic sales including:      - Delta P
Delta P % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Delta P Value
Organic sales including:      - Delta P      - Growth initiatives
Growth initiatives %
Growth initiatives Value
Organic sales including:      - Delta P      - Growth initiatives      - New offers
New Offers %
New Offers Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 PTEQP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016 PTLVB
Total initiatives
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test 3
Total New Products
Spreadsheet: 764167d1642617409-compare-range-and-show-duplicates-as-blanks-excluding-specified-numbers-snowman71-
Sheet: Sheet1

7 | 8 | 9 | 10 | 11 | 13 | 14 | 15 | 17 | 18
7 | 8 | 10 | 11 | 12 | 13 | 14 | 15 | 17 | 18 | 19
8 | 11 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
7 | 8 | 9 | 10 | 12 | 13 | 14 | 16 | 17 | 18 | 19 | 20 | 21
8 | 10 | 12 | 13 | 14 | 15 | 19 | 20
Spreadsheet: 130966d1322672835-if-match-and-somewhere-close-to-excelforum-help-sheet
Sheet: Sheet1

Creator SSN | Owner [NAME] | Projected Opportunity Amount | Contract Number | Contract Amount $
1 | Last Name 1 | 123456
2 | Last Name 2 | 50
3 | Last Name 3 | 27
4 | Last Name 4 | 11155522
5 | Last Name 5 | 4595
6 | Last Name 6 | 34564
7 | Last Name 7 | 15444851
8 | Last Name 8 | 12154
9 | Last Name 9 | 1
10 | Last Name 10 | 23564
11 | Last Name 11 | 7454
12 | Last Name 12 | 986532
13 | Last Name 13 | 124
14 | Last Name 14 | 3544
15 | Last Name 15 | 575416
16 | Last Name 16 | 21246
17 | Last Name 17 | 54
Spreadsheet: 48884d1248184375-streamline-dates-streamline-dates
Sheet: Sheet1

Data | Result Should be
02/06/2009 | 2009-06-02 00:00:00
29/05/2009
01/06/2009
02/06/2009
03/06/2009
04/06/2009
05/06/2009
08/06/2009
09/06/2009
10/06/2009
16/06/2009
12/06/2009
15/06/2009
16/06/2009
17/06/2009
18/06/2009
19/06/2009
290509
300509
010609
020609
030609
040609
050609
080609
090609
100609
110609
120609
130609
150609
160609
170609
180609
190609
200609
220609
230609
240609
250609
260609
270609
290609
24/06/2009
25/06/2009
2009-06-25 00:00:00
2009-06-26 00:00:00
2009-09-29 00:00:00
2009-06-25 00:00:00
2009-06-26 00:00:00
2009-09-29 00:00:00
Spreadsheet: daren_farmer__6653__CES - April
Sheet: GPPP

Purchase
 | From [NAME]
 | At the Gulf Plains Processing Plant (8348)
 | For IF-.09 (Base vols) and GD AD
Sale
 | Vols are transported into HPL
Term
 | Thru 6/2001
Other
 | Stella Morris confirms this point
 | All of the gas is given to us at the Gulf Plains Plant.
 | [NAME] are about 13,000
 | [NAME] determines base/swing breakout
Deal #'s | Jan | Feb | Mar | Apr
P | 139248
S | 143533
DD | 144963 | 154553 | 203587 | 229423
Spreadsheet: 92230d1291848114-populate-cell-with-values-from-multiple-other-cells-based-on-criteria-concatifexample
Sheet: Sheet1

ID | Custodian | DupID | AllCustodians | AllCustodians
13456 | [NAME], [NAME] | 12456 | [NAME], [NAME]; Black, [NAME]; [NAME], [NAME] | [NAME], [NAME]; Black, [NAME]; [NAME], [NAME]
13480 | Black, [NAME] | 12456 | [NAME], [NAME]; Black, [NAME]; [NAME], [NAME] | Black, [NAME]; [NAME], [NAME]; [NAME], [NAME]
13524 | Black, [NAME] | 0 | Black, [NAME] | Black, [NAME]
13567 | Night, [NAME] | 15789 | Night, [NAME]; [NAME], [NAME] | Night, [NAME]; [NAME], [NAME]
13589 | Night, [NAME] | 15789 | Night, [NAME]; [NAME], [NAME] | Night, [NAME]; [NAME], [NAME]
13594 | Night, [NAME] | 0 | Night, [NAME] | Night, [NAME]
13609 | Jones, [NAME] | 15789 | Night, [NAME]; [NAME], [NAME] | Jones, [NAME]; Night, [NAME]
13610 | Jones, [NAME] | 12456 | [NAME], [NAME]; Black, [NAME]; [NAME], [NAME] | Jones, [NAME]; [NAME], [NAME]; Black, [NAME]
Spreadsheet: 857834d1706713694-offset-from-the-second-large-answer-when-there-is-a-duplicate-amount-offset-challenge
Sheet: Sheet1

Product Code | 10126-4JL-M4W6
Rank | 2
 | Product Code | Qty | Code | LineNo
 | 10126-4JL-M4W6 | 36 | CTN202203015000927 | 32
 | 10126-001-M4W6 | 400 | CTN202203015000927 | 2
 | 10126-001-M4W6 | 300 | CTN202203015000927 | 3
 | 10126-4JL-M4W6 | 213 | CTN202208155016406 | 59
 | 10126-4JL-M4W6 | 107 | CTN202208155016406 | 14
 | 10126-4JL-M4W6 | 213 | CTN202208155016406 | 34
Spreadsheet: gerald_nemec__11523__Schedule B
Sheet: Sheet1

Crestone Invoices Before July 1, 2000
Invoice Number | Invoice Date | Date Paid | [NAME] | Work Order Number | Work Order Description | G/L Amount | Vendor Amount
17196 | 5/18/00 | 8/1/00 | Mountain West Fabrication | C.007285.01.05 | Box Draw/Maverick | 55122.39 | 109524.3
00-149 | 6/20/00 | 8/21/00 | ETAP, Inc. | C.007280.01.06.54 | South Kitty - 10" Poly Pipe | 150480 | 150480
00-146 | 6/12/00 | 7/18/00 | ETAP, Inc. | C.007280.01.06.54 | South Kitty - 10" Poly Pipe | 96382.44 | 90288
00-144 | 6/8/00 | 7/18/00 | ETAP, Inc. | C.007280.01.06.54 | South Kitty - 10" & 8" Poly Pipe | 68909.26 | 64552
367817 | 4/30/00 | 9/19/00 | Hanover Compression Inc. | C.007286.01.05 | Quantum #1 @ Mustang Station | 79800 | 79800
367818 | 4/30/00 | 9/26/00 | Hanover Compression Inc. | C.007286.01.05 | Petrogulf #7 @ Palomino Station | 79800 | 79800
371564 | 5/26/00 | 9/19/00 | Hanover Compression Inc. | C.007286.01.05 | Petrogulf #1 @ Palomino Station | 79800 | 79800
371566 | 5/26/00 | 9/19/00 | Hanover Compression Inc. | C.007286.01.05 | Petrogulf #3 @ Palomino Station | 79800 | 79800
367816 | 4/30/00 | 9/19/00 | Hanover Compression Inc. | C.007286.01.05 | Petrogulf #4 @ Palomino Station | 70350 | 70350
371565 | 5/26/00 | 9/19/00 | Hanover Compression Inc. | C.007286.01.05 | Petrogulf #2 @ Palomino Station | 70350 | 70350
372429 | 5/31/00 | 7/28/00 | Hanover Compression Inc. | C.007286.01.05 | West Port #2 Unit #73854 | 71522.5 | 67000
372440 | 5/31/00 | 9/19/00 | Hanover Compression Inc. | C.007286.01.05 | Quantum #5-73857 @ Mustang | 85186.5 | 79800
372435 | 5/31/00 | 9/19/00 | Hanover Compression Inc. | C.007286.01.05 | Quantum #3-73855 @ Mustang | 85186.5 | 79800
372430 | 5/31/00 | 9/19/00 | Hanover Compression Inc. | C.007286.01.05 | West Port #1 Unit #98195 | 85186.5 | 79800
0341609 | 4/19/00 | 7/27/00 | Lone Star Transportation, Inc. | C.007286.01.05 | Mustang #1 Palomino Lease | 92645.98 | 86787.8
811-61500-3 | 6/15/00 | 7/26/00 | Okemah Construction, Inc. | C.007279.01.05 | Clydesdale - Per Contract | 135290.68 | 135290.68
1028545 | 6/16/00 | 7/27/00 | Flint Energy Construction Co. | C.007279.01.05.64 | Clydesdale - 8" Poly & 8" Steel Pipe | 132876.71 | 124474.67
 |  |  |  |  | Totals
Spreadsheet: 103028d1300882004-fetch-unique-values-from-a-single-column-sample-testdata2
Sheet: Sheet1

Sum of Amount
EIN | Total
42103580 | 159
123456803 | 20
272499903 | 81
368521454 | 80
530196605 | 40
752485698 | 2220
852456123 | 99
852741369 | 10144
911189249 | 60
941156365 | 88
942443282 | 109.5
963258740 | 262.8
963852745 | 10
Grand Total | 13373.3
Spreadsheet: 741333d1626975842-problem-creating-statuses-based-on-populated-cells-statustest-doc
Sheet: Sheet1

Object 1 | Object 2 | Current Status | Step 1 | Step 3 | Step 4 | Step 5 | Step 6 | Step 7 | Step 8 | Step 9 | Step 10 | Step 11
 |  |  | 2021-06-06 00:00:00 | 2021-06-18 00:00:00 | 2021-06-22 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-28 00:00:00 | 2021-07-01 00:00:00 | 2021-07-03 00:00:00 | 2021-07-04 00:00:00 | 2021-07-22 00:00:00
 |  |  | 2020-04-01 10:00:00 | 2021-07-05 11:22:48 |  |  | 2021-07-05 11:22:48
 |  |  | 2020-04-01 11:00:00 |  |  | 2021-04-30 11:21:02 | 2021-07-05 11:24:02
 |  |  | 2020-04-01 13:00:00 | 2021-07-05 11:23:12 |  |  | 2021-07-05 11:23:12
 |  |  | 2020-04-01 14:00:00 | 2021-07-05 11:23:25 |  |  | 2021-07-05 11:23:25
 |  |  | 2020-04-01 15:00:00 | 2021-07-05 11:23:40 |  |  | 2021-07-05 11:23:40
 |  |  | 2021-04-01 11:00:00 |  |  | 2021-04-30 11:21:02 | 2021-07-05 11:24:02
Spreadsheet: 773434d1647865127-countif-based-on-two-conditions-over-non-continuous-cells-test_new-1-
Sheet: Sheet1

Count | A | B | C | A | B | C | A | B | C
 | 1 |  |  | 1 |  |  | 1
 | 1 |  |  | 1 |  |  | 1 | z
 | 1 |  |  | 1 | y |  | 1 | y
 | 0 |  |  | 0 |  |  | 0
 | 1 | z |  | 1 | z |  | 1
COUNTIF | Column: A > 0 AND column B is either blank OR equal to 'y'
 | The green cells are the ones COUNTED in each row.
Spreadsheet: 152605d1335450992-excel-2007-automatically-sizing-a-table-according-to-another-tables-size-maintenance-schedule-maintenance-summary-max-power-monthly-power
Sheet: MonthlyPower

Monthly Illumination Source Power Measurements
 | September, 2011 |  | October, 2011 |  | November, 2011 |  | December, 2011 |  | January, 2012 |  | February, 2012 |  | March, 2012 |  | April, 2012 |  | May, 2012 |  | June, 2012 |  | July, 2012 |  | August, 2012 |  | September, 2012 |  | October, 2012 |  | November, 2012 |  | December, 2012
AxioSkop | Y | 2011-09-11 00:00:00 | Y | 2011-10-21 00:00:00 | Y | 2011-11-11 00:00:00 | Y | 2011-12-13 00:00:00 | Y | 2012-01-30 00:00:00 | Y | 2012-02-29 00:00:00 | Y | 2012-03-15 00:00:00 | Y | 2012-04-23 00:00:00
Axiovert1 | Y | 2011-09-29 00:00:00 | Y | 2011-10-12 00:00:00 | Y | 2011-11-11 00:00:00 | Y | 2011-12-13 00:00:00 | Y | 2012-01-30 00:00:00 | Y | 2012-02-29 00:00:00 | Y | 2012-03-07 00:00:00 |  | 2012-04-24 00:00:00
Axiovert2 | N |  | N |  | Y | 2011-11-30 00:00:00 | N |  | Y | 2012-01-04 00:00:00 | Y | 2012-02-09 00:00:00 | Y | 2012-03-30 00:00:00 | Y | 2012-04-25 00:00:00
FLIM | Y | 2011-10-01 00:00:00 | N |  | Y | 2011-11-29 00:00:00 | Y | 2011-12-07 00:00:00 | Y | 2012-01-23 00:00:00 | Y | 2012-02-28 00:00:00 | Y | 2012-03-29 00:00:00 |  | 2012-04-26 00:00:00
LSM3 | Y | 2011-10-01 00:00:00 | Y | 2011-10-23 00:00:00 | N |  | Y | 2011-12-14 00:00:00 | Y | 2012-01-31 00:00:00 | Y | 2012-02-07 00:00:00 | Y | 2012-03-05 00:00:00 | Y | 2012-04-11 00:00:00
LSM4 | Y | 2011-09-18 00:00:00 | Y | 2011-10-17 00:00:00 | N |  | Y | 2011-12-01 00:00:00 | Y | 2012-01-31 00:00:00 | Y | 2012-02-27 00:00:00 | Y | 2012-03-22 00:00:00 | Y | 2012-04-11 00:00:00
Pascal1 | Y | 2011-09-28 00:00:00 | N |  | Y | 2011-11-11 00:00:00 | N |  | Y | 2012-01-31 00:00:00 | Y | 2012-02-24 00:00:00 | Y | 2012-03-21 00:00:00 | N |  | N |  | N |  | N |  | N |  | N
Pascal2 | Y | 2011-09-28 00:00:00 | N |  | N |  | Y | 2011-12-13 00:00:00 | Y | 2012-01-13 00:00:00 | Y | 2012-02-27 00:00:00 | Y | 2012-03-30 00:00:00 | N |  | N |  | N |  | N |  | N |  | N
LSM710 | Y | 2011-10-01 00:00:00 | Y | 2011-10-17 00:00:00 | Y | 2011-11-30 00:00:00 | Y | 2011-12-22 00:00:00 | Y | 2012-01-23 00:00:00 | N |  | Y | 2012-03-19 00:00:00 | Y | 2012-04-25 00:00:00
Data Validation List:
Y
N
Spreadsheet: 63794d1264666698-lognormal-distribution-function-mw-chart
Sheet: MW > 180 days

 | MW
 | 5.013736264
 | 1.502057613
 | 5.013736264
 | 2.984087791 |  |  | [NAME]
 | 14.95879121 |  |  | Mean
 | 0.802197802 |  |  | Var | 13.44374011
 | 0.210575778
 | 0.0200538
 | 0.373612637
 | 2.777701465
 | 0.690957933
 | 0.43170816
 | 1.753193431
 | 8.01754386
 | 20.04385965
 | 5.006849315
 | 20.03294893
 | 3.764258555
 | 1.717425432
 | 1.220841901
 | 0.810543751
 | 0.360235321
 | 0.570536258
 | 0.480423522
 | 5.006858711
 | 1.09150663
 | 0.72067337
 | 1.821678854
 | 0.58051493
 | 0.260432968
 | 1.802816901
 | 0.781233698
 | 3.172912858
 | 3.453153565
 | 6.803721461
 | 5.013736264
 | 2.984110654
 | 0.802197802
 | 0.421130952
 | 2.777586996
 | 0.040064103
 | 0.37099359
 | 0.690957933
 | 0.43170816
 | 1.722723705
 | 5.006849315
 | 1.261149163
 | 0.270243531
 | 1.271156773
 | 0.730669711
 | 0.360312024
 | 0.410388128
 | 0.580517504
 | 0.380365297
 | 1.612208505
 | 1.061454047
 | 0.700960219
 | 2.002743484
 | 10.00684932
 | 10.00684932
 | 1.602194787
 | 0.584133516
 | 0.75206044
 | 0.502762431
 | 0.75206044
 | 0.502270932
 | 0.752054795
 | 0.50226022
 | 3.008241758
 | 4.010989011
 | 0.502066116
 | 1.504120879
 | 1.004444444
 | 1.503639241
 | 5.013736264
 | 0.661813187
 | 0.66060274
 | 0.090247253
 | 0.090123457
 | 0.090082192
 | 0.110302198
 | 0.110150892
 | 0.110100457
 | 0.16043956
 | 0.160219479
 | 0.160146119
 | 0.66090535
 | 0.412005086
 | 0.355446009
 | 0.040195618
 | 2.657065728
Spreadsheet: 267276d1380032971-compare-data-across-worksheets-and-copy-data-if-match-file-export-load-list
Sheet: Carpet Pad Lookup

Quantity | [NAME] | Depth | Pad color | Qty | Pad color | Qty
90 | 8 | 10 | Pink | 1
160 | 8 | 20 | Green | 1
240 | 8 | 30 | Black | 1
100 | 10 | 10 | Red | 1
180 | 10 | 20 | Green | 1
200 | 10 | 20 | White | 1
270 | 10 | 30 | Black | 1
300 | 10 | 30 | Blue | 1
400 | 10 | 40 | White | 2
500 | 10 | 50 | White | 1 | Blue | 1
600 | 10 | 60 | Blue | 2
700 | 10 | 70 | Blue | 2 | Red | 1
800 | 10 | 80 | Blue | 2 | White | 1
900 | 10 | 90 | Blue | 3
1000 | 10 | 100 | Blue | 2 | White | 2
400 | 20 | 20 | White | 2
600 | 20 | 30 | White | 3
800 | 20 | 40 | White | 4
1000 | 20 | 50 | White | 5
1200 | 20 | 60 | White | 6
1400 | 20 | 70 | Blue | 4 | Red | 2
1600 | 20 | 80 | Blue | 4 | White | 2
1800 | 20 | 90 | Blue | 6
2000 | 20 | 100 | Blue | 4 | White | 4
900 | 30 | 30 | Blue | 3
1200 | 30 | 40 | Blue | 4
1500 | 30 | 50 | Blue | 5
1800 | 30 | 60 | Blue | 6
2100 | 30 | 70 | Blue | 6 | Red | 3
2400 | 30 | 80 | Blue | 6 | White | 3
1600 | 40 | 40 | White | 8
2000 | 40 | 50 | White | 10
2400 | 40 | 60 | White | 12
2500 | 50 | 50 | White | 5 | Blue | 5
90 | 10 | 8 | Pink | 1
160 | 20 | 8 | Green | 1
240 | 30 | 8 | Black | 1
180 | 20 | 10 | Green | 1
200 | 20 | 10 | White | 1
270 | 30 | 10 | Black | 1
300 | 30 | 10 | Blue | 1
400 | 40 | 10 | White | 2
500 | 50 | 10 | White | 1 | Blue | 1
600 | 60 | 10 | Blue | 2
700 | 70 | 10 | Blue | 2 | Red | 1
800 | 80 | 10 | Blue | 2 | White | 1
900 | 90 | 10 | Blue | 3
1000 | 100 | 10 | Blue | 2 | White | 2
600 | 30 | 20 | White | 3
800 | 40 | 20 | White | 4
1000 | 50 | 20 | White | 5
1200 | 60 | 20 | White | 6
1400 | 70 | 20 | Blue | 4 | Red | 2
1600 | 80 | 20 | Blue | 4 | White | 2
1800 | 90 | 20 | Blue | 6
2000 | 100 | 20 | Blue | 4 | White | 4
1200 | 40 | 30 | Blue | 4
1500 | 50 | 30 | Blue | 5
1800 | 60 | 30 | Blue | 6
2100 | 70 | 30 | Blue | 6 | Red | 3
2400 | 80 | 30 | Blue | 6 | White | 3
2000 | 50 | 40 | White | 10
2400 | 60 | 40 | White | 12
Spreadsheet: 851073d1701328949-getting-price-using-3-reference-points-test-126-aligw
Sheet: Delivery

Job No. | Order Refarence | Collection Address | Collection Date | Collection Contact Name | Delivery Address | Delivery Date | Delivery Time | Service | Quantity | Delivery Zone | Pallet Type | Delivery Cost | Supplementary Charges | Total Delivery Charge | Difference | Total Delivey Cost Excluding Extras |  | Total Difference |  | Total Pallets |  | 60 | Micro Pallet
 |  |  |  |  |  |  |  | A - 24 Hour | 1 | Zone A | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | B - 48 Hour | 1 | Zone C | Full Pallet 1 |  |  |  |  |  |  |  |  |  |  |  | Half Pallet
 |  |  |  |  |  |  |  | A - 24 Hour | 1 | Zone D | Full Pallet 3 |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pallet 10
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: U Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 01-01) 30-01-2020 | pdf |  | 05-01) 17-05-2020 | pdf |  | 05-01) 17-05-2020 | pdf |  | 05-01) 17-05-2020 | pdf
 | 02-01) 01-02-2020 | pdf
 | 04-01) 12-04-2020 | pdf