tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 824601d1680704590-use-vlookup-and-if-or-sort-unique-and-frequency-use-vlookup-and-if-or-sort-unique-and-frequency
Sheet: Sheet1 (2)

Worker ID | [NAME] |  |  |  | Worker ID | Consecutive Weeks
12345678 | 2022-10-09 00:00:00
12345678 | 2022-10-16 00:00:00 |  |  |  | 345987
12345678 | 2022-10-23 00:00:00 |  |  |  | 713190
12345678 | 2022-10-30 00:00:00 |  |  |  | 743911
12345678 | 2022-11-06 00:00:00 |  |  |  | 765402
12345678 | 2022-11-13 00:00:00 |  |  |  | 1645089
12345678 | 2022-11-20 00:00:00 |  |  |  | 12345678
345987 | 2023-01-01 00:00:00 |  |  |  | 66042154
345987 | 2023-01-08 00:00:00 |  |  |  | Worker ID
345987 | 2023-01-15 00:00:00 |  |  |  | 0
345987 | 2023-01-01 00:00:00
345987 | 2023-01-29 00:00:00
345987 | 2023-02-05 00:00:00
1645089 | 2022-09-25 00:00:00
1645089 | 2022-10-02 00:00:00
1645089 | 2022-10-09 00:00:00
713190 | 2023-01-01 00:00:00
713190 | 2023-01-08 00:00:00
713190 | 2023-01-15 00:00:00
713190 | 2023-01-22 00:00:00
713190 | 2023-01-29 00:00:00
125777 | 2023-01-01 00:00:00
125777 | 2023-01-08 00:00:00
125777 | 2023-01-15 00:00:00
125777 | 2023-01-22 00:00:00
125777 | 2023-01-29 00:00:00
743911 | 2022-12-18 00:00:00
743911 | 2022-12-25 00:00:00
743911 | 2023-01-15 00:00:00
765402 | 2022-12-18 00:00:00
765402 | 2022-12-25 00:00:00
765402 | 2023-01-15 00:00:00
66042154 | 2022-11-27 00:00:00
66042154 | 2022-12-04 00:00:00
66042154 | 2022-12-11 00:00:00
66042154 | 2022-12-18 00:00:00
Spreadsheet: 162227d1339770875-subscript-out-of-range-error-9-test-vnhgc
Sheet: Ciaran O'Reilly

[NAME] Reilly
Order Number | Account Code | Customer Name | Reason for Quotation | Date Received | Review Date | Date Last Edited | Quote Value | Customer Order Ref | Responsible Person | Quote Status | Created By | Notes | Todays Date | 6 Months AGO | Older than 6 months | past review | 5 days + | over 5 days no.
103484 | [NAME] | Carter Mason Electricals Ltd | Electric Radiant Panels | 26/04/2012 | 21/05/2012 | 26/04/2012 | 1525 |  | COR | Active Quotation Still Ongoing | [NAME]
96034 | CASHVAT | [NAME], | Hand Dryers | 05/12/2011 | 12/03/2012 | 23/02/2012 | 1456.1 |  | COR | Active Quotation Still Ongoing | [NAME] | This quotation is for COR_x000D__x000D_09/01/2012 15:39:12 lm_x000D_mailed COR for update_x000D__x000D_23/02/2012 11:44:41 lm_x000D_mailed for update_x000D_
104645 | CASHVAT |  | [NAME] | 21/05/2012 | 31/05/2012 | 29/05/2012 | 7000 | Blade Hand Dryers | COR | Active Quotation Still Ongoing | [NAME] | Price as per Ciaran_x000D__x000D_29/05/2012 13:01:27 took a sample on dkt 105142 on approval, account has been opened._x000D_
103444 | CASHVAT | Mr [NAME] | Electric Radiant Heaters | [NAME] | [NAME] | [NAME] | 2201.2 | Get In Line Gym | COR | Active Quotation Still Ongoing | [NAME]
104782 | CASHVAT |  | Hand Dryers | 22/05/2012 | 11/06/2012 | 22/05/2012 | 14915 | [NAME] | COR | Active Quotation Still Ongoing | [NAME] | As per Ciaran
102845 | CASHVAT | Mr [NAME] | Frost Protection | 13/04/2012 | 20/04/2012 | 17/04/2012 | 133.53 | Trace heating | COR | Active Quotation Still Ongoing | [NAME] | 16/04/2012 15:30:47 DD_x000D_Spoke with [NAME], however his customer has not been in to the branch to discuss with him yet. As soon as he does [NAME] wil be onto me to give us feedback on the prices.
105379 | PUELECTR | PU Electrical Wholesaler Ltd | Hand Dryers | 01/06/2012 | 18/06/2012 | 05/06/2012 | 619 | Stock Items | COR | Active Quotation Still Ongoing | [NAME] | as per cor
Spreadsheet: 125429d1319028434-excel-2007-moving-values-between-sheets-by-using-number-commands-copy-of-afhendingase-lar-and-loadinfo-1
Sheet: ULD1&2

Name of airline |  |  |  | Aircraft Position |  |  | Name of Airline |  |  |  | Aircraft Position
Built up by: | Hjortur |  | Origin | ULD Ident |  |  | Built up by: | Hjortur |  | Origin | ULD Ident
Total Pages: |  |  |  |  |  |  | Total Pages:
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: sally_beck__35035__MgmtSum-Q2-0410a
Sheet: web_summary

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  |  | 2ND QUARTER 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  |  |  | Expenses |  |  |  | EBIT
 |  |  |  | Deals
Business Team |  | Plan | Actual | Identified | Forecast | [NAME] |  | Plan | Forecast | [NAME] |  | Plan | Forecast | [NAME]
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
GRM -  Weather
Emissions
GRM - New Products
Executive Trading
Total Trading & Risk Mgt.
East Midstream
West Midstream
Industrial Downstream - Paper
Industrial Downstream - Chemicals
Midstream IPP
Mexico
Total Origination
Genco
Generation Investments
Gas Assets
Gas Assets - Trading
Total Assets
Principal Investing
Energy Investments
Special Assets
CTG Assets
Total Investing
Commercial Transactions Group
Office of the Chairman
Total Commercial
Group
Other Interest Related Charges
Capital Charge Offset
Overview
ENA EBIT
Interest Expense/(Income)
[NAME]
* Includes Capital Charge & Operating, Direct, and Allocated Expenses |  |  |  |  |  |  |  | Change from |  |  |  |  |  | 2000-04-01 00:00:00
 |  |  |  |  |  |  |  | DPR Change:
 |  |  |  |  |  |  |  | MPR Change:
 |  |  |  |  |  |  |  | New Deals:
 |  |  |  |  |  |  |  | Other Margin Changes:
 |  |  |  |  |  |  |  | Expenses
 |  |  |  |  |  |  |  | Total Change
Spreadsheet: 849070d1699627992-help-for-index-match-on-an-array-index-match
Sheet: Tabelle1

 |  | INPUT
 | Type | Green
 | T environment | 25 | °
 | T target | 70 | °
 | DT |  | °
 |  | 10 | 30 | 50 | 70 | 120 | DT
 | Red | 1 | 2 | 3 | 4 | 5
 | Green | 6 | 7 | 8 | 9 | 10
 | Yellow | 11 | 12 | 13 | 14 | 15
 | Blue | 16 | 17 | 18 | 19 | 20
 | Purple | 21 | 22 | 23 | 24 | 25
Spreadsheet: 000655e9-5e20-42cf-9d19-801ef69f246c
Sheet: Sheet1

TRAVEL REQUEST FORM FF-001 BCLA
NAME: |  |  |  | DEPARTMENT: |  |  |  | DATE:
[NAME] OF CONFERENCE:
[NAME] OF MEETING:
C.  IS THIS FACULTY RESEARCH TRAVEL?
 |  |  | (MUST BE CHECKED)
D.  DESCRIBE YOUR PARTICIPATION:
E.  IS YOUR PARTICIPATION: (check one)
F.  PLACE OF MEETING: |  |  |  | [NAME] DATE: |  |  |  | [NAME] DATE:
[NAME] EXPENSES:
(1)  Registration Fees (with meals)
(2)  Registration Fee (without meals)
(3)  Transportation
(4)  Hotel/Lodging
(5)  Meals
J.  TOTAL EXPENSES
K.  PLAN TO COVER MISSED CLASSES HAS BEEN FILED WITH DEPARTMENT CHAIR?: (check one)
[NAME] / APPROVAL
I understand that travel expenses reimbursement will not exceed the approved amount.
Faculty Signature: _________________________________________________________________ |  |  |  |  |  |  | Date: | ____________________________
Chair/Dean Approval: ______________________________________________________________ |  |  |  |  |  |  | Date: | ____________________________
Spreadsheet: 737563d1624469133-goal-seek-cant-change-dos-over-30-days-practice
Sheet: Sheet1

 |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | CODE SAP | SKU | jun | jul | aug | sep | oct | nov | dec
 | 2250068 | 4.5 p100 cy ltc | 2601
 |  | In Transit | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PO's |  |  |  |  |  |  | 0
 |  | Requirement | 0 | 6817.5 | 1953.5 | 0 | 6470 | 0 | 0
 |  | Demand | 2472 | 3535 | 2207 | 2409 | 1498 | 4470 | 2502
 |  | Ending Inventory
 |  | Days of Stock
 | 22014083 | 5.5 P110 ICY LTC API 10th | 4456
 |  | In Transit | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | PO's | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Requirement | 0 | 0 | 0 | 780.0000000000001 | 0 | 0 | 0
 |  | Demand | 2172 | 0 | 0 | 0 | 2133 | 1862 | 0
 |  | Ending Inventory
 |  | Days of Stock
Spreadsheet: 55348d1255470320-sorry-i-sent-the-wrong-thread-and-attachment-disregard-this-one-please-book2
Sheet: Sheet2

200 | 250 | 300 | 350 | 400 | 450 | 500 | 550 | 600 | 650 | 700 | 750 | 800 | 850 | 900 | 950 | 1000 | 1050 | 1100 | 1150 | 1200 | 1250 | 1300 | 1350 | 1400 | 1450 | 1500 | 1550 | 1600 | 1650 | 1700 | 1750 | 1800 | 1850 | 1900 | 1950 | 2000 | 2050 | 2100 | 2150 | 2200 | 2250 | 2300 | 2350 | 2400 | 2450 | 2500 | 2550 | 2600 | 2650 | 2700 | 2750 | 2800 | 2850 | 2900 | 2950 | 3000
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57
 |  | I need the data in the yellow to match the same data in yellow on sheet 2
 |  | for example cell a5 on sheet 2 should reference along with g12 on page one
 |  | I want both the carrier and the rate show up
Spreadsheet: bc228119-c133-4ede-bda9-645cd4cc9ad9
Sheet: EPR IS

CONSOLIDATED STATEMENTS OF INCOME ([NAME] and Condensed)
 | Quarters Ended |  |  | Six Months Ended
 | March 31, |  |  | March 31,
 | 2012 | 2011 |  | 2012 | 2011
(In millions, except per share amounts)
Revenues
Gaming operations | 300.4 | 269.8 |  | 565 | 522.7
Product sales | 240.8 | 207.2 |  | 421.8 | 405.5
Total revenues | 541.2 | 477 |  | 986.8 | 928.2
Costs and operating expenses
Cost of gaming operations | 118.8 | 102.4 |  | 223 | 196.4
Cost of product sales | 108.8 | 92 |  | 198.2 | 179.8
Selling, general and administrative | 109.3 | 89.10000000000001 |  | 199.1 | 171.3
Research and development | 55.3 | 48.7 |  | 102.2 | 97.60000000000001
Depreciation and amortization | 19.3 | 16.7 |  | 34.7 | 34.8
Contingent acquisition related costs | 11.7 | 0 |  | 11.7 | 0
Total costs and operating expenses | 423.2 | 348.9 |  | 768.9000000000001 | 679.9
Operating income | 118.0000000000001 | 128.1 |  | 217.8999999999999 | 248.3000000000001
Other income (expense)
Interest income | 10.8 | 13.3 |  | 22.9 | 26.6
Interest expense | -30 | -35.6 |  | -60.1 | -71
Other | -2 | -0.9999999999999999 |  | -4.800000000000001 | 3.4
Total other income (expense) | -21.2 | -23.3 |  | -42 | -41
Income from continuing operations before tax | 96.80000000000005 | 104.8 |  | 175.8999999999999 | 207.3000000000001
Income tax provision | 34.4 | 37.1 |  | 63.2 | 66.8
Income from continuing operations | 62.40000000000006 | 67.70000000000002 |  | 112.6999999999999 | 140.5000000000001
Income (loss) from discontinued operations, net of tax | -0.5 | 1.9 |  | -1.5 | 2.8
Net income | 61.90000000000006 | 69.60000000000002 |  | 111.1999999999999 | 143.3000000000001
Basic earnings (loss) per share
Continuing operations | 0.21 | 0.22 |  | 0.38 | 0.47
Discontinued operations | 0 | 0.01 |  | -0.01 | 0.01
Net income | 0.21 | 0.23 | 0 | 0.37 | 0.48
Diluted earnings (loss) per share
Continuing operations | 0.21 | 0.22 |  | 0.38 | 0.47
Discontinued operations | 0 | 0.01 |  | -0.01 | 0.01
Net income | 0.21 | 0.23 | 0 | 0.37 | 0.48
Weighted average shares outstanding
Basic | 296.7 | 298.4 |  | 297 | 298
Diluted | 298.1 | 299.9 |  | 298.6 | 299.4
Spreadsheet: 793777d1661703461-would-appreciate-help-creating-a-worksheet-for-income-expense-simple-budget-personal-finance-template
Sheet: Jan

 |  | 2022-01-01 00:00:00
 |  |  |  |  |  |  | Credit Card #2 |  |  |  |  | Credit Card #2
 | Cheque |  | Debit | Credit
Date | Number | Description | Amount | Amount |  |  | Date | Description | Amount |  |  | Date | Description | Amount
 |  |  |  |  |  |  | 2021-12-11 00:00:00 | Supermarket | 36.7 |  |  | 2022-01-15 00:00:00 | Car Repair | 234.56
 |  | Brought forward |  | 234.56 | >> from previous month |  | 2021-12-13 00:00:00 | DIY | 40.1
 |  |  |  |  |  |  | 2021-12-14 00:00:00 | Pictures | 36.3
 |  | Income |  |  | >> Monthly income |  | 2021-12-14 00:00:00 | Supermarket | 29.2
 |  |  |  |  |  |  | 2021-12-16 00:00:00 | Supermarket | 41.1
 |  | Standing Orders/Direct Debits |  |  | >> Regular Montlhly payments |  | 2021-12-17 00:00:00 | Cinema | 23.9
 |  | Debit Card Transactions |  |  | >> Montlhly Credit card [NAME] |  | 2021-12-22 00:00:00 | Supermarket | 15.3
 |  | Credit card #1 |  |  | >> Montlhly Debit card [NAME] |  | 2021-12-22 00:00:00 | Supermarket petrol | 35.7
 |  | Credit card #2 |  |  | >> Montlhly Debit card [NAME] |  | 2021-12-26 00:00:00 | Supermarket | 34
 |  |  |  |  |  |  | 2021-12-24 00:00:00 | Hotel | 44.5
 |  | Total Debits |  |  | .>> Total Monthly Outgoings |  | 2021-12-30 00:00:00 | Supermarket | 22
 |  | Total Credits |  |  | >> Total income inc Brought Forard |  | 2022-01-02 00:00:00 | Supermarket petrol | 10.4
 |  |  |  |  |  |  | 2022-01-04 00:00:00 | Garage (MOT) | 15.7
 |  | Total Balance |  |  | >> Balance (dynamic) for this month |  | 2022-01-05 00:00:00 | Supermarket | 27.3
 |  |  |  |  |  |  | 2022-01-08 00:00:00 | Supermarket | 12.9
 |  |  |  |  |  |  | 2022-01-08 00:00:00 | Supermarket | 36.4
 |  |  |  |  |  |  | 2022-01-10 00:00:00 | Supermarket | 8.6
 |  | Regular Income |  |  |  |  | 2022-01-11 00:00:00 | Supermarket | 14
 |  | Salary #1 |  | 1500
 |  | Salary #2 |  | 1000
 |  |  |  |  |  |  |  | TOTAL
 |  | Regular Outgoings |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | Standing Orders/Direct Debits
 |  | MORTGAGE | 800
 |  | ELECTRICITY | 50
 |  | GAS | 80
 |  | TELEPHONE | 47
 |  | WATER COMPANY | 43
 |  | RATES | 120
 |  | MOBILE RENTAL | 25
 |  | Debit Card Transactions
2022-01-03 00:00:00 |  | Supermarket | 6.5
2022-01-04 00:00:00 |  | Coffee #1 | 13.1
2022-01-05 00:00:00 |  | Supermarket | 47.9
2022-01-07 00:00:00 |  | Supermarket | 21.9
2022-01-07 00:00:00 |  | Cash withdrawal | 50
2022-01-09 00:00:00 |  | Supermarket | 24.2
2022-01-12 00:00:00 |  | SWTrains | 16.6
2022-01-12 00:00:00 |  | Supermarket | 15.9
2022-01-14 00:00:00 |  | Coffee #1 | 11
2022-01-16 00:00:00 |  | Asda | 43.1
2022-01-17 00:00:00 |  | Savers | 7.9
2022-01-21 00:00:00 |  | Cash withdrawal | 30
Spreadsheet: 5bb53810-967d-4938-9d56-7483ee768ba4
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
MNS | Test | MNS | Manganese, Serum | Manganese, S | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1.6 | mL | Collection Container/Tube: Plain, royal blue-top Monoject trace element blood collection tube-product #8881-307006 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 1.6 mL Collection Instructions: 1. Allow the specimen to clot for 30 minutes, and then centrifuge to separate serum from the cellular fraction. Serum must be removed from cellular fraction within 4 hours of draw. Avoid hemolysis. 2. Remove the stopper. Carefully pour specimen into a Mayo metal-free, polypropylene vial, while avoiding transfer of the cellular components of blood. Do not insert a pipet into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.4 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | 0-15 years: not established > or =16 years: 0.6-2.3 ng/mL | Tuesday, Thursday; 3 p.m. | 1 days | 6 days | 1 | 83785 |  |  |  |  | Rochester
MNS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
MNS | Result | 8413 | Manganese, S | Manganese, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5683-8
Spreadsheet: sara_shackleton__36788__Summary of All Mercado Deals
Sheet: Deals to be Assigned

SUMMARY MERCADO TRANSACTIONS FROM MAY '01
- CURVES AS OF 4/3/01 -
FINANCIAL DEALS WHICH NET POSITION
 |  |  |  |  |  | Daily |  | CONTRACT |  | NYMEX | BASIS | INDEX | TOTAL
Deal # |  | BUYER |  | SELLER |  | Quantity |  | PRICE |  | MTM | MTM | MTM | MTM |  | TERM REMAINING
NB6076.1 |  | ENA |  | MERCADO |  | 13000 |  | 2.595 |  | 13375722 | -443328 | 0 |  |  | May '01 - Aug '02
NB8744.1 |  | MERCADO |  | ENA |  | 13000 |  | 2.57 |  | -13621496 | 535493 | 0 |  |  | May '01 - Aug '02
NF1164.7 |  | ENA |  | MERCADO |  | 10000 |  | 4.9261 |  | -51783 | -162890 | 0 |  |  | May '01 - Dec '01
NF1164.B |  | ENA |  | MERCADO |  | 10000 |  | 4.8057 |  |  |  | 0 |  |  | May '01 - Nov '01
NF1164.C |  | MERCADO |  | ENA |  | 10000 |  | 4.82 |  | -23101 | -17698 | 0 |  |  | May '01 - Dec '01
NF1164.G |  | MERCADO |  | ENA |  | 10000 |  | 4.52 |  | -202250 | -336822 | 0 |  |  | May '01 - Nov '01
 |  |  |  |  |  | TOTAL
REMAINING FINANCIAL DEALS
NF1164.B |  | ENA |  | MERCADO |  | 10000 |  | 4.8057 |  | 87014 | 51131 | 0 |  |  | Dec '01
NF1164.1 |  | ENA |  | MERCADO |  | 10000 |  | 2.72 |  | 5549077 | -451830 | 0 |  |  | May '01 - Dec '01
NF1164.4 |  | ENA |  | MERCADO |  | 10000 |  | 3.44 |  | -60011 | 2641291 | 0 |  |  | Jan '02 - Aug '02
NF1164.D |  | MERCADO |  | ENA |  | 9000 |  | -0.535 |  | 0 | -94721 | 0 |  |  | May '01 - Oct '01
NF1164.E |  | MERCADO |  | ENA |  | 1000 |  | 4.475 |  | -33002 | -10525 | 0 |  |  | May '01 - Oct '01
NF1164.F |  | MERCADO |  | ENA |  | 1000, 2000 (Dec '01) |  | 4.86 |  | 32496 | 4710 | 0 |  |  | Nov '01 - Aug '02
 |  |  |  |  |  | TOTAL
Spreadsheet: 176550d1345925117-extract-unique-values-from-2-columns-dynamically-ef174_uniques_from_2_lists
Sheet: Users Input Data File

To | From |  | Account
[NAME] | [NAME]
[NAME] | [NAME]
Sandra | [NAME]
[NAME] | [NAME]
abc | Fred
xyz
[NAME]
Sandra
Spreadsheet: 862597d1710273800-changing-values-in-a-column-based-on-the-position-of-x-in-a-grid-auto-dart-sample
Sheet: Sheet1

This chart allows you to find the average impact force needed to break plastic film.  To semi-automate this process I need help changing the values in a column based on the position of “X” in a grid. In column AS (Highlighted Area) I would like to enter a zero in the row with the lowest weight that has an “X”. Once the zero is entered in the row with the lowest weight I need the rows above the zero to increase by 1 until the column is full. (Rows below the zero can = zero or be left blank) Additionally, I would like the lowest weight value that has an “X” to appear in cell B4 (Also Highlighted).  I manually entered the values in column AS to show how it will look when completed.
Sum of column AT -> |  | Weight | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Sum of "X" in each row | HELP | Product
Sum of column AR -> |  | 600
Lowest weight that an "X" appears -> |  | 570 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
Thickness -> | 0.83 | 540 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O |  | X |  |  |  | X |  | X
Dart = |  | 510 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O |  |  |  | X |  | O |  | O
 |  | 480 |  |  |  |  |  |  |  |  |  |  |  |  |  | O |  |  |  |  |  | O
 |  | 450 |  |  |  |  |  |  |  |  | X |  | X |  | O
 |  | 420 |  | X |  |  |  | X |  | O |  | O |  | O
 |  | 390 | O |  | X |  | O |  | O
 |  | 360 |  |  |  | O
 |  | 330
 |  | 300
 |  | 270
 |  | 240
 |  | 210
 |  | 180
Spreadsheet: 826143d1681821064-multiple-criteria-get-unique-value-bookx-etaf
Sheet: Sheet1

A | B | C | StartDateTime | EndDateTime | DurationinMin | Date | [NAME]
324 | 235062-22-001 | CLEANING | 2023-04-04 01:12:58.800000 | 2023-04-04 01:36:03.900000 | 23.08500000159256 | 2023-04-04 00:00:00
324 | 235062-22-001 | CLEANING | 2023-04-05 00:11:36.403000 | 2023-04-05 00:18:45.106000 | 7.145049999235198 | 2023-04-05 00:00:00
324 | 235062-22-001 | CLEANING | 2023-04-05 01:33:58.543000 | 2023-04-05 01:57:00.176000 | 23.02721666987054 | 2023-04-05 00:00:00
324 | 235062-22-001 | CLEANING | 2023-04-05 17:35:22.123000 | 2023-04-05 17:59:20.040000 | 23.96528333541937 | 2023-04-05 00:00:00
324 | 235062-22-001 | CLEANING | 2023-04-05 21:06:10.193000 | 2023-04-05 21:59:25.586000 | 53.25654999702238 | 2023-04-05 00:00:00
324 | 235062-22-001 | CLEANING | 2023-04-06 00:12:38.293000 | 2023-04-06 00:55:47.263000 | 43.14949999563396 | 2023-04-06 00:00:00 | 43.15
324 | 235062-22-001 | WASHING | 2023-04-12 11:23:35.610000 | 2023-04-12 12:49:09.093000 | 85.55804999778047 | 2023-04-12 00:00:00 | 85.56
324 | 235062-22-001 | PEALING | 2023-04-13 05:03:43.356000 | 2023-04-13 06:01:32.300000 | 57.81573333078995 | 2023-04-13 00:00:00 | 57.82
Spreadsheet: 122050d1316586952-vlookup-from-conditional-indirect-data-validation-list-test2
Sheet: Milki

Milki |  | MilkiColors
[NAME] | 134 | DSFO Deepsea Green / Foam | 401
[NAME] | 135 | GT Green Teal | 402
M.Y.O.B. | 136 | MGCR  Military Grn/Cream | 403
Man in the Mirror | 137 | OBGL Olive Brown Gold | 404
Match | 138 | [NAME]  Olive Brown / Red | 405
[NAME] | 139 | SGP Green / Pink | 406
Meritage | 140 | TM Turtle Moss | 407
 |  | MGGC Military Green /GingerCream | 408
 |  | OG Olive Gradient | 409
 |  | OBLG Olive Brown Light Green | 410
 |  | [NAME] | 411
Spreadsheet: mark_haedicke__24593__2001BUDGET-102049 ns
Sheet: Headcount

2001-2003 OPERATING & STRATEGIC PLAN
Headcount Summary
 |  | Co.
 |  | CC No. |  |  |  | Estimated |  | Year End Plan
 |  |  |  |  |  | 12/31/00 |  | 2001 |  | 2002 |  | 2003
Domestic Employees
 | Full Time |  |  |  |  | 9 |  | 9 |  | 9 |  | 9
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract
 | Total
International Employees
 | Full Time |  |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract
 | Total
Total Domestic & International
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees (1)
 | 3rd Party Contract (2)
 | Total  *
Location of Total Employees (1)
 | Domestic
 |  | 1400 Smith
 |  | [NAME] |  |  |  | 9 |  | 9 |  | 9 |  | 9
 |  | Omaha
 |  | Other
 | Expatriates |  |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | International
 | Total
Location of 3rd Party Contractors (2)
 | Domestic
 |  | 1400 Smith
 |  | [NAME]
 |  | Omaha
 |  | Other
 | Expatriates
 | International
 | Total
Total Employees by Location *
 | * Totals should tie.