tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 157782d1337871050-pivot-table-that-automatically-adjusts-with-new-entries-forum-clean-up-report
Sheet: OPENRES

DATE | 1010 | 1040 | 2010 | TOTAL
2012-04-16 00:00:00 | 2367 | 394 | 226
2012-04-23 00:00:00 | 2004 | 417 | 243 |  |  | Reset "Row Labels" to reflect 6 weeks of data
2012-04-30 00:00:00 | 1701 | 371 | 247
2012-05-07 00:00:00 | 1714 | 289 | 245
2012-05-14 00:00:00 | 1031 | 227 | 271 |  |  | TOTAL |  |  | 1010 |  |  | 1040 |  |  | 2010
2012-05-21 00:00:00 | 671 | 257 | 105 |  |  | Row Labels | Sum of TOTAL |  | Row Labels | Sum of 1010 |  | Row Labels | Sum of 1040 |  | Row Labels | Sum of 2010
 |  |  |  |  |  | 2012-04-16 00:00:00 | 2987 |  | 2012-04-16 00:00:00 | 2367 |  | 2012-04-16 00:00:00 | 394 |  | 2012-04-16 00:00:00 | 226
 |  |  |  |  |  | 2012-04-23 00:00:00 | 2664 |  | 2012-04-23 00:00:00 | 2004 |  | 2012-04-23 00:00:00 | 417 |  | 2012-04-23 00:00:00 | 243
 |  |  |  |  |  | 2012-04-30 00:00:00 | 2319 |  | 2012-04-30 00:00:00 | 1701 |  | 2012-04-30 00:00:00 | 371 |  | 2012-04-30 00:00:00 | 247
 |  |  |  |  |  | 2012-05-07 00:00:00 | 2248 |  | 2012-05-07 00:00:00 | 1714 |  | 2012-05-07 00:00:00 | 289 |  | 2012-05-07 00:00:00 | 245
 |  |  |  |  |  | 2012-05-14 00:00:00 | 1529 |  | 2012-05-14 00:00:00 | 1031 |  | 2012-05-14 00:00:00 | 227 |  | 2012-05-14 00:00:00 | 271
 |  |  |  |  |  | 2012-05-21 00:00:00 | 1033 |  | 2012-05-21 00:00:00 | 671 |  | 2012-05-21 00:00:00 | 257 |  | 2012-05-21 00:00:00 | 105
 |  |  |  |  |  | Grand Total | 12780 |  | Grand Total | 9488 |  | Grand Total | 1955 |  | Grand Total | 1337
Spreadsheet: 787247d1657706460-formula-to-calculate-risk-2022-07-12-oeldere-joenuhbanana-formula-help-aligw
Sheet: Sheet1

With Date | Lead time | Stock Level | Cover | 2 month stock cover date | Expected Stock Out Date | Delivery Date | What this should be
 | 5 | 0 | 0 | 2022-05-13 00:00:00 | 2022-07-12 00:00:00 | 2022-07-29 00:00:00 | Out of Stock
 | 5 | 2000 | 4 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 | 2022-09-03 00:00:00 | Good Stock Level
 | 5 | 2000 | 8 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 | 2022-09-09 00:00:00 | Good Stock Level
 | 5 | 500 | 1 | 2022-06-12 00:00:00 | 2022-08-11 00:00:00 | 2022-09-03 00:00:00 | Will Go OOS
 | 5 | 1000 | 2 | 2022-07-12 00:00:00 | 2022-09-10 00:00:00 | 2022-08-24 00:00:00 | Risk of OOS
 | 5 | 0 | 0 | 2022-05-13 00:00:00 | 2022-07-12 00:00:00 |  | Out of Stock
 | 5 | 2000 | 4 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 |  | Will go OOS
 | 5 | 2000 | 8 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 |  | Good Stock Level
 | 5 | 500 | 1 | 2022-06-12 00:00:00 | 2022-08-11 00:00:00 |  | Will go OOS
 | 5 | 1000 | 2 | 2022-07-12 00:00:00 | 2022-09-10 00:00:00 |  | Will go OOS
 | 5 | 4000 | 8 | 2023-01-09 00:00:00 | 2023-03-10 00:00:00 | 2023-04-15 00:00:00 | Will Go OOS
Out of Stock - if Stock Level =(ColC)is 0
Good Stock Level - if delivery date (COlG) is before 2 month stock out date (ColE) OR cover (ColD) > lead time ([NAME]) +2 when delivery date (ColG) is blank
Will Go OOS -  if delivery date (COlG) is after expected stock out date (ColF) OR if cover (ColD) is < lead time (ColB) and delivery date (COlG) is blank
Risk of OOS - if delivery date (COlG) is after 2 month stock out date (ColE) but before expected stock out date (ColF) OR if cover (ColD) is < lead time ([NAME]) +2, but > lead time (ColB) & delivery date (COlG) is blank
When there is delivery date available, the calculation should be based on the delivery dates not the lead times
Spreadsheet: 861400d1709271162-power-query-merge-query-issues-with-duplicate-values-in-the-matching-column-bankfile
Sheet: Sheet1

Check Number/Direct Debit | Amount |  |  |  | Date | Description | Amount
2365 | 700 |  |  |  | 2024-02-21 00:00:00 | 653 | 500
6546 | 500 |  |  |  | 2024-02-22 00:00:00 | 653245 | 700
9898 | 350 |  |  |  | 2024-02-23 00:00:00 | 653265 | 350
950 | 200 |  |  |  | 2024-02-24 00:00:00 | 653264 | 200
 |  |  |  |  | 2024-02-25 00:00:00 | 656562 | 700
Spreadsheet: 823831d1680160868-average-using-cells-reference-excel-average-using-cell-address
Sheet: Calculation Details

Material | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Average Monthly Consumption | 1st Tentative | 2nd Tentative
PART #1 | 0 | 0 | 0 | 0 | 0 | 670 | 335
PART #2 | 1 | 1 | 1 | 3 | 1 | 1 | 1.666666666666667
PART #3 | 0 | 0 | 0 | 0 | 5 | 5 | 5
PART #4 | 4 | 1 | 15 | 0 | 0 | 0 | 3.75
PART #5 | 0 | 200 | 0 | 600 | 150 | 0 | 250
PART #6 | 27 | 0 | 0 | 0 | 0 | 0 | 4.5
PART #7 | 0 | 8 | 2 | 3 | 2 | 9 | 5.5
PART #8 | 21 | 32 | 31 | 31 | 25 | 37 | 31
PART #9 | 0 | 1 | 2 | 0 | 0 | 1 | 0.75
PART #10 | 0 | 1 | 0 | 0 | 0 | 2 | 1
PART #11 | 0 | 0 | 1 | 0 | 0 | 2 | 1
PART #12 | 0 | 0 | 0 | 0 | 0 | 1 | 0.5
PART #13 | 0 | 0 | 0 | 0 | 0 | 1 | 0.5
PART #14 | 0 | 0 | 0 | 0 | 5 | 0 | 2.5
PART #15 | 0 | 0 | 0 | 0 | 100 | 0 | 50
PART #16 | 0 | 0 | 0 | 0 | 1 | 0 | 0.5
PART #17 | 3430 | 1620 | 1570 | 260 | 1800 | 250 | 1488.333333333333
PART #18 | 0 | 1 | 4 | 0 | 1 | 0 | 1.25
PART #19 | 0 | 1 | 1 | 0 | 1 | 0 | 0.5
PART #20 | 342 | 2259 | 204 | 700 | 360 | 3120 | 1740
PART #21 | 0 | 0 | 0 | 0 | 0 | 1 | 0.5
PART #22 | 5 | 2 | 0 | 0 | 15 | 19 | 17
PART #23 | 37 | 67 | 31 | 15 | 12 | 21 | 29.2
Spreadsheet: marie_heard__24529__Ineos
Sheet: Sheet1

ISDA Master Swap Agreement Worksheet
 |  | ATTORNEY:
DATE: | 2001-10-29 00:00:00 | DEAL MAKER: | Troy Black
COUNTERPARTY: | Ineos Acrylics Inc. | CONTACT: | [NAME] and [NAME]
ADDRESS: | 7275 Goodlett Farms Parkway | TITLE:
 | Cordova, TN 38018 | PHONE: | (901) 381-2033
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) | Ineos Acrylics Group Holdings Limited | Enron Corp.
LIMIT |  | 25000000
Incorporation State
COLLATERAL  THRESHOLD
 | 4000000 | 20000000
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING | 250000 | 250000
Delivery Amount
Return Amount
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change
-Below = S&P/Moody's |  | BBB- | S&P
Financial Covenants
-Funded debt/Worth
-Minimum Net Worth | 40000000
-Current Ratio | <1:1
-EBITDA/Interest | <1.5:1
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 4000000
-Guarantor |  | 100000000
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
COUNTERPARTY IS ELIGIBLE CONTRACT PARTICIPANT: |  | YES: x | NO:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO: x
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
Confirming that the MAC's are tied to the parent in British Pounds, but the thresholds and collateral amounts are in US$.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 5-8261
Spreadsheet: 331b740c-971c-4046-9fcb-0712bd491947
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
ADMA | Test | ADMA | [NAME], Plasma | [NAME], P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Collection/Container/Tube: Lavender top (EDTA) Submisson Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Fasting-overnight (12 hours) | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <18 years: not established > or =18 years: 63-137 ng/mL | Wednesday; 8 a.m. | 1 day | 8 days | 1 | 83789 |  |  |  |  | Rochester
ADMA | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen
ADMA | Result | 83651 | [NAME], P | [NAME], P | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
ADMA | Result | 32053 | ADMA Interpretation | ADMA Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 329042d1404177046-vlookup-between-two-sheets-including-entire-row-fmsonline-wip
Sheet: Feb

 |  | Reading and Sales
 |  | Date | Unleaded |  |  |  | Premium |  |  |  |  | Diesel
 |  |  | Reading* | Gallons | Sales |  | Reading* | Gallons | Plus Sales | [NAME]. Sales |  | Reading* | Gallons | Sales
 |  | 2014-02-01 00:00:00 | 81.75 |  | 843.21 |  | 35 |  | 52.99 | 85.82 |  | 52.99 |  | 843.21
 |  | 2014-02-02 00:00:00 | 78 |  | 1352.11 |  | 35 |  | 29 | 75 |  | 25.5 |  | 1352.11
 |  | 2014-02-03 00:00:00 | 73 |  | 159.7 |  | 34.5 |  |  |  |  | 25.5 |  | 159.7
 |  | 2014-02-03 00:00:00 |  |  | 432.37 |  |  |  |  | 17 |  |  |  | 432.37
 |  | 2014-02-03 00:00:00 |  |  | 24850.443 |  |  |  |  | 98.99 |  |  |  | 24850.443
 |  | 2014-02-04 00:00:00 | 70 |  | 1737.928 |  | 34 |  |  | 106.34 |  | 25 |  | 1737.928
 |  | 2014-02-05 00:00:00 | 68 |  | 1396.335 |  | 33.5 |  | 30 | 92.4 |  | 24.75 |  | 1396.335
 |  | 2014-02-06 00:00:00 | 64.75 |  | 14602.98 |  | 33.5 |  | 28.19 | 195.93 |  | 24.75 |  | 14602.98
 |  | 2014-02-07 00:00:00 | 66.5 |  | 14135.43 |  | 33 |  | 157.58 | 78.24 |  | 24.75 |  | 14135.43
 |  | 2014-02-08 00:00:00 | 57 |  | 13740.08 |  | 33 |  | 74.12 | 81.03 |  | 24 |  | 13740.08
 |  | 2014-02-09 00:00:00 | 52.5 |  | 1459.5 |  | 32 |  | 48.23 | 37 |  | 24 |  | 1459.5
 |  | 2014-02-10 00:00:00 | 47 |  | 872.25 |  | 32 |  | 30.02 | 39 |  | 24 |  | 872.25
 |  | 2014-02-11 00:00:00 | 43.25 |  | 721.41 |  | 31.5 |  | 49.46 | 119.43 |  | 24 |  | 721.41
 |  | 2014-02-12 00:00:00 | 46.5 |  | 786.46 |  | 31 |  | 30 | 10 |  | 23.75 |  | 786.46
 |  | 2014-02-13 00:00:00 | 37.5 |  | 1348.28 |  | 31 |  | 41.71 | 95.9 |  | 23.5 |  | 1348.28
 |  | 2014-02-14 00:00:00 | 32.25 |  | 970.08 |  | 30 |  |  | 173.33 |  | 22.75 |  | 970.08
 |  | 2014-02-15 00:00:00 |  |  | 2505.25 |  |  |  | 126.57 | 320.85 |  |  |  | 2505.25
 |  | 2014-02-16 00:00:00 |  |  | 1838.89 |  | 28.5 |  | 10 | 406.19 |  | 22.5 |  | 1838.89
 |  | 2014-02-17 00:00:00 | 4 |  | 2318.01 |  | 26.5 |  | 35.04 | 94.33 |  | 21.5 |  | 2318.01
 |  | 2014-02-18 00:00:00 | 62.5 |  | 1759.38 |  | 33 |  | 36 | 200.63 |  | 28 |  | 1759.38
 |  | 2014-02-19 00:00:00 | 56.25 |  | 1919.63 |  | 32 |  | 100.5 | 245.21 |  | 27.5 |  | 1919.63
 |  | 2014-02-20 00:00:00 | 49.75 |  | 2228.14 |  | 31 |  | 155.59 | 204.65 |  | 27.5 |  | 2228.14
 |  | 2014-02-21 00:00:00 | 41 |  | 2505.71 |  | 30 |  | 231.74 | 200.88 |  | 27 |  | 2505.71
 |  | 2014-02-22 00:00:00 | 31 |  | 4373.78 |  | 29 |  | 184.46 | 456.06 |  | 26.5 |  | 4373.78
 |  | 2014-02-23 00:00:00 | 85.75 |  | 5809.94 |  | 33.75 |  | 94.17 | 315.73 |  | 32.5 |  | 5809.94
 |  | 2014-02-24 00:00:00 | 64 |  | 2246.3 |  | 32 |  | 173.46 | 63.55 |  | 32 |  | 2246.3
 |  | 2014-02-25 00:00:00 | 55.5 |  | 1429.94 |  | 31.25 |  | 199.36 | 101.15 |  | 32 |  | 1429.94
 |  | 2014-02-26 00:00:00 | 50.5 |  | 1675.77 |  | 31 |  | 127.36 | 176.35 |  | 31.75 |  | 1675.77
 |  | 2014-02-27 00:00:00 | 44 |  | 2103.95 |  | 29.75 |  | 64.9 | 202.4 |  | 22.5 |  | 2103.95
 |  | 2014-02-28 00:00:00 | 36 |  | 45859.13 |  | 29 |  | 2236.79 | 4068.21 |  | 31 |  | 45859.13
 |  |  |  |  |  |  |  |  | `
 |  | *Inches
Spreadsheet: 844848d1696504924-match-input-with-pool-of-texts-or-word-bank-and-return-correspoding-value-excelforum
Sheet: Sheet1

 |  |  | List | Word Bank
 |  |  | [NAME] | Qadeer | Ahmed | [NAME] | [NAME] | Qadeer [NAME] | [NAME]
Input | [NAME] |  | Jawad | Jawad | Asad | Bengan | Alo | Tamatar | Bhindi
Required Output: |  |  | [NAME] | Dil | Gurda | Jigar | Damagh | Pagal | Falaj
 |  |  | Victor | Langra | [NAME] | Half | Full | Medium | Strong
Spreadsheet: 735945d1623268186-combining-an-ifs-and-if-and-function-test
Sheet: Sheet1

Job | Status | Estimate | Revenue | [NAME]
Job 1 | Active | 2 | 11
Job 2 | Active | 3 | 0
Job 3 | Active | 0 | 4
Job 4 | Potential | 7 | 8
Job 5 | Potential | 5 | 0
Job 6 | Potential | 0 | 9
Spreadsheet: 203217d1356980887-if-statements-and-getting-excel-to-skip-rows-and-leave-no-blanks-or-falses-practice-work
Sheet: 2nd

[NAME], [NAME] |  | D | E | E | E | E | E |  | E | E | E |  |  | E | E |  | E | E
[NAME], [NAME] |  |  |  |  | P | P | P |  |  |  |  | P | P | P
[NAME], [NAME] |  |  | A |  | D |  |  |  | D | D |  | 7d |  |  |  | D | 7d
[NAME], [NAME] |  | D |  | D |  | D | D |  |  |  | D |  | D | D | D | A
Cruz, [NAME] |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | 0700  1500 R
Fioritta, [NAME] |  |  | D | D | D |  |  | D |  | D | D | D |  |  | D | D
Fox, [NAME] |  | P | P | P |  |  |  |  | P | P | P |  |  |  |  | P | P | P
[NAME], [NAME] |  | D | 0945  2215 Reg | E |  | D | D |  | D |  |  | 1945  2215 Reg | 1945  2215 Reg | D | D |  | 1045  1515 Reg | D
Jones, Jordan |  | D | E | E | E | E |  |  | E | E | E | E | E |  |  |  |  | 0945  2215 Reg
Kirchhof, [NAME] |  | E |  |  | D | E | E |  |  |  |  | D | D |  | D | E
Thigpen, Keisha |  | E | A | A |  |  |  | D |  | A |  |  |  | A | D |  | A
Spreadsheet: 219305d1362706103-calculating-how-many-hrs-are-ord-hrs-time-and-a-half-and-double-time-over-a-range-payroll-and-invoicing-wheatstone
Sheet: Sheet2

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | 2013-03-09 00:00:00 | 2013-03-10 00:00:00
 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
Spreadsheet: jeff_dasovich__14127__FIN group project1204
Sheet: Exhibit Y

Inflation: | 0.03
 |  |  | paid | [NAME] paid |  |  |  | Price
Year | win % | price | attendance | attendance | [NAME] ticket pr | %changeQ | %changeP | Elasticity
1989 | 0.451 | 6.8 | 1298430
1990 | 0.475 | 7.12 | 1509759
1991 | 0.512 | 6.37 | 2147877
1992 | 0.395 | 8.88 | 1651428 | 1651398
1993 | 0.506 | 8.91 | 2051853
1994 | 0.438 | 11.86 | 1104206 | 2032743
1995 | 0.545 | 10.88 | 1643203 | 1823280
1996 | 0.528 | 12.34 | 2723850
* | purchased 200,000 worth of tickets by county
** | strike shortened seasons - adj. up to full season
 |  | price incl. | new price | elasticity
Year | Attendance | 10% tax |  | 0.8 | 0.85 | 0.95 | 0.75 | 0.7
1999 | 2703704 | 15.64
2000 | 2478395 | 16.23
2001-18 | 2253086 | 16.87
 |  | price incl. | new price | elasticity
Year | Attendance | 10% tax |  | 0.8 | 0.85 | 0.95 | 0.75 | 0.7
1999 | 2703704 | 15.64
2000 | 2478395 | 16.23
2001-18 | 2253086 | 16.87
 |  | price incl. | new price | elasticity
Year | Attendance | 10% tax |  | 0.8 | 0.85 | 0.95 | 0.75 | 0.7
1999 | 2703704 | 15.64
2000 | 2478395 | 16.23
2001-18 | 2253086 | 16.87
Spreadsheet: 111240d1307651811-excel-2007-separating-time-when-the-sum-is-more-than-24-hours-779344-separating-time
Sheet: Sheet1

Name | Hours
AAAA | 13:58:45
BBBB | 08:19:50
CCC | 16:13:41
DDD | 1 day, 8:53:48
EEE | 12:11:48
FFF | 03:44:01
GGG | 2 days, 10:24:54
HHH | 14:37:27
III | 06:56:06
JJJ | 13:58:45
Total Hours |  | =SUM(B2:B11)
 |  | [hh]:mm:ss
 |  | =INT(B13*24)
 |  | General
 |  | =INT(SUM(B2:B11)*24)
 |  | =MINUTE(SUM(B2:B11))
Total Hours 181:19:05
Spreadsheet: 144740d1331124816-excel-2007-need-result-in-sheet2-column-b-book1
Sheet: Sheet1

Ref No. | ID No.
0
0
PRF00031378 | 782581
PRF00031378 | 782581
0
PRF00031364 | 780866
PRF00031364 | 780866
0
0
PRF00031364 | 780866
PRF00031378 | 782581
0
0
PRF00031364 | 780866
PRF00031369 | 782400
0
PRF00031369 | 782400
PRF00031369 | 782400
Spreadsheet: 703658d1605102983-if-excel-formula-that-can-use-ranges-example-workbook
Sheet: Sheet1

 | No. | Score | Result
 | Metric 1 | Silver
 | Metric 2 |  |  |  | For Metric 2
 | Metric 3 | 0.9901
 | Metric 4 | 0.98 |  |  | Hoping to achieve the following results in D4
 |  |  |  |  | C4 | D4 (desired outcome)
 |  |  |  |  | 0%-97.99% | 0
 |  |  |  |  | 98%-99.99% | 48
 |  |  |  |  | 100%-109.99% | 60
 |  |  |  |  | 110%+ | 72
Spreadsheet: 700432d1603194514-if-formula-reading-from-2-different-pieces-of-information-testing-wknd-cost
Sheet: Sheet1

 | [NAME] |  | Replaced | Not sent | MUST BE IN DATE ORDER! |  | WEEK number | 25 |  | B,D,E,I,K,M,N,O,P,Q,R,S |  |  |  |  |  |  |  |  |  | Please indicate loading order i.e. 1, 2, 3
 |  |  | Amended | Sent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Stand Trl A - 1" means load on next trailer on headboard. "Live Load - 1" means live load order on headboard
 |  |  | Cancelled | Collection |  |  | Wk commencing : | 2020-03-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Haulier Comments
 | Status | [NAME] | Availability | Delivery Date | Delivery Day | AML No. | [NAME]. | Account Number | Customer Name | Customer Town | Postcode | Pallets | KG's | Product | [NAME] (KG) | [NAME] | [NAME] | Delivery Time | Delivery Instructions | Collection Date | Collection Time | Collection Vehicle | Stand/Live Load | Weighbridge ticket | KM's | COST | [NAME]  COST
 |  | wasp |  | 2020-10-17 00:00:00 |  |  |  | 752386 |  |  |  | 24 |  |  |  |  |  | Book |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Book
Spreadsheet: 114261d1310046652-automatically-updating-col-based-on-another-cols-value-automatically_insert_number_value
Sheet: Sheet1

Metric | Number | Description
[NAME] | 1 | increase by xyz
[NAME] | 2 | chanage equipment
Testcost | 1 | [NAME]
Prodcost | 1 | [NAME]
Testcost | 2 | change pdq
[NAME] | 3 | increase thickness
Prodcost | 2 | decrease xyzpdqer
[NAME] |  | junk1
Testcost |  | junk1
Testcost |  | junk2
Spreadsheet: 211670d1359880524-pattern-matching-within-a-dynamic-data-set-position_spreadsheet-copy
Sheet: Condor

 |  | Fly | Mar13Jun13Sep13 | Jun13Sep13Dec13 | Sep13Dec13Mar14 | [NAME] | Mar14Jun14Sep14 | [NAME] | Sep14Dec14Mar15 | Dec14Mar15Jun15 | Mar15Jun15Sep15 | [NAME]
 | Position
[NAME] |  | Spread | Mar13 [NAME] | [NAME] | [NAME] | Dec13 Mar14 | [NAME] | [NAME] Sep14 | Sep14 Dec14 | Dec14 Mar15 | Mar15 [NAME] | [NAME]
2013-03-18 00:00:00 | 0 |  | 0
2013-06-17 00:00:00 | 0 |  | 0 | 0
2013-09-16 00:00:00 | 10 |  |  | 0 | 10
2013-12-16 00:00:00 | -30 |  |  |  | -10 | -20
2014-03-17 00:00:00 | 30 |  |  |  |  | 20 | 10
2014-06-16 00:00:00 | -10 |  |  |  |  |  | -10 | 0
2014-09-15 00:00:00 | 0 |  |  |  |  |  |  | 0 | 0
2014-12-15 00:00:00 | 0 |  |  |  |  |  |  |  | 0
2015-03-16 00:00:00 | 0
2015-06-15 00:00:00 | 0
2015-09-14 00:00:00 | 0
2015-12-14 00:00:00 | 0
2016-03-14 00:00:00 | 0
 | 0
 | 0
Spreadsheet: 025f689c-36bc-4a02-b352-3633394410cc
Sheet: $$ Total Library Expenditures

[NAME] vs. [NAME]
Total [NAME]
 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | % Change
Peer Average
Peer Median
University of Rhode Island | 5176620 | 6019655 | 7220518 | 5809771 | 5758100
[NAME] University | 6088297 | 6586523 | 7702932 | 8434390 | 11126066
Montana State University - Bozeman | 5400307 | 5437986 | 6693091 | 6955865 | 6957580
North Dakota State University - Main Campus | 3896985.93 | 3863271 | 3601283 | 4478805 | U/A | U/A
University of Maine | 6574493 | 7208428 | 7709318 | 7875447 | 8876360
University of New Hampshire - Main Campus | 8724552 | 9868593 | 10339301 | 10460546 | 10817056
University of Vermont and State Ag. Coll. | U/A | 10262071 | 9635970 | 11089572 | 11502744 | U/A
University of Wyoming | 6980503 | 7117286 | 11845130 | 11489238 | 8165459
Source: ACRLMetrics
Revised: October 24, 2011, ajr
Spreadsheet: 62579d1263494156-identifying-monthly-changes-in-product-information-and-grouping-the-results-west-coast-1
Sheet: Sheet2

Product ID | Qty | Location | Price | Matches
1 | 1000 | Warehouse A | 45 | 0 | 0
2 | 3000 | Warehouse B | 40 | 1
3 | 5000 | Warehouse B | 30 | 0
4 | 10000 | Warehouse B | 20 | 1
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: Paul

 | # | Date | Name | Distance in        Miles | Total Elevation in Feet | Total Time HH:MM | Moving Time HH:MM | Stoped Time HH:MM | Avarage Speed MPH | Average Moving Speed MPH
 |  |  | 2017
 |  |  | 2018
 |  |  | 2019
 |  |  | 2020
 |  | 2020-06-20 00:00:00 | County Gate - Lynmouth - Watersmeet - County Gate | 16.6 | 3547 |  | 07:58:00 | 03:12:00
 |  | 2020-06-28 00:00:00 | Minehead to Bossington and Back | 12.1 | 1218 |  | 05:26:00 | 01:03:00
 |  | 2020-07-03 00:00:00 | [NAME] | 6.1 | 1237 |  | 02:41:00 | 00:07:00
 |  | 2020-07-26 00:00:00 | [NAME] Warren | 6.9 | 1352 |  | 03:23:00 | 00:47:00
 |  | 2020-08-12 00:00:00 | [NAME] (Rhyd Ddu Path) | 8.1 | 2904 |  | 05:10:00 | 04:36:00
 |  |  | 2021
 |  | 2021-04-02 00:00:00 | Miserden | 9 | 1272 |  | 04:08:00 | 01:06:00
 |  | 2021-04-11 00:00:00 | Wells to Glastonbury | 10.4 | 901 |  | 04:23:00 | 01:21:00
 |  | 2021-05-02 00:00:00 | Brecon Beacons | 10.2 | 3573 |  | 06:05:00 | 01:23:00
 |  | 2021-05-09 00:00:00 | Axbridge Reservoir - Crook Peak Circular | 10.4 | 1598 |  | 04:32:00 | 01:07:00
 |  | 2021-05-23 00:00:00 | Pontneddfechan Waterfall Walk | 10.6 | 1649 |  | 05:47:00 | 01:01:00
 |  | 2021-07-05 00:00:00 | [NAME] | 10.4 | 4419 |  | 07:22:00 | 05:11:00
 |  |  | 2022
 |  | 2022-05-22 00:00:00 | Golden Vally Nature Reserve | 7.5 | 1046 | 04:00:00 | 03:24:00 | 00:36:00 | 1.88 | 2.21
 |  | 2022-05-29 00:00:00 | Pensford to Chewton Keynsham | 8.7 | 1067 |  | 03:38:00 | 00:34:00
 |  | 2022-06-26 00:00:00 | [NAME] | 7 | 1022 |  | 03:34:00 | 00:46:00
 |  | 2022-09-25 00:00:00 | Wentwood Reservoir Loop from Llanvaches | 5.4 | 1063 |  | 02:29:00 | 00:38:00
 |  |  | 2023
Spreadsheet: 26769d1219250267-maximum-and-minimum-dates-based-on-condition-maxdate
Sheet: Sheet1

Identity | From Date | To Date | No. Widgets
1 | 2007-03-01 00:00:00 | 2007-04-30 00:00:00 | 40 |  |  |  | 2768-01-01 00:00:00 |  | 420
1 | 2007-05-01 00:00:00 | 2007-06-30 00:00:00 | 50
1 | 2007-07-01 00:00:00 | 2007-08-29 00:00:00 | 60
1 | 2007-08-30 00:00:00 | 2007-10-30 00:00:00 | 50
1 | 2007-10-31 00:00:00 | 2007-12-31 00:00:00 | 50
1 | 2008-01-01 00:00:00 | 2008-02-29 00:00:00 | 40 |  | Start | 2007-03-01 00:00:00 |  | Widgets of Identity 1 | 420
1 | 2008-03-01 00:00:00 | 2008-04-30 00:00:00 | 60 |  | End | 2008-06-30 00:00:00
1 | 2008-05-01 00:00:00 | 2008-06-30 00:00:00 | 70 |  | Days | 488 |  | Widgets per day | 0.860655737704918
2 | 2007-03-01 00:00:00 | 2007-03-31 00:00:00 | 30
2 | 2007-04-01 00:00:00 | 2007-04-30 00:00:00 | 50
2 | 2007-05-01 00:00:00 | 2007-05-31 00:00:00 | 90
2 | 2007-06-01 00:00:00 | 2007-06-30 00:00:00 | 90
2 | 2007-07-01 00:00:00 | 2007-07-31 00:00:00 | 87
2 | 2007-08-01 00:00:00 | 2007-08-31 00:00:00 | 65
2 | 2007-09-01 00:00:00 | 2007-09-30 00:00:00 | 30 |  | Start | 2007-03-01 00:00:00 |  | Widgets of Identity 1 | 1242
2 | 2007-10-01 00:00:00 | 2007-10-31 00:00:00 | 89 |  | End | 2008-06-30 00:00:00
2 | 2007-11-01 00:00:00 | 2007-11-30 00:00:00 | 42 |  | Days | 488 |  | Widgets per day | 1.112704918032787
2 | 2007-12-01 00:00:00 | 2007-12-31 00:00:00 | 434
2 | 2008-01-01 00:00:00 | 2008-01-31 00:00:00 | 34
2 | 2008-02-01 00:00:00 | 2008-02-29 00:00:00 | 34
2 | 2008-03-01 00:00:00 | 2008-03-31 00:00:00 | 4
2 | 2008-04-01 00:00:00 | 2008-04-30 00:00:00 | 53
2 | 2008-05-01 00:00:00 | 2008-05-31 00:00:00 | 60
2 | 2008-06-01 00:00:00 | 2008-06-30 00:00:00 | 80