tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 719796d1613820466-logic-updates-to-existing-formulas-duplicates-exclusion-lookups-samplep-update-1-ans
Sheet: SHIP

ID |  |  | type | rec count |  | [NAME] |  | [NAME] |  |  | Counts |  |  |  |  | Counts:
1163603 |  |  | Final | 302404597 |  | Net Down |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value:302,404,597
1163603 |  |  | Final | 302404597 |  | Net Down |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value:302,404,597
1172600 |  |  | A | 0 |  | Post 100% |  | A |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | INT | 35360098 |  | Post 100% |  | C D w/o I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | Final | 50039 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1172600 |  |  | Final | 50039 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> Column Q is duplicating the counts currently | Expected Value: 50,039
1179778 |  |  | Final | 11431902 |  | Post 100% |  | C D w/ I |  | Final Reject Sample |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> "Rej" is found in Column K for this ID | Expected Value: 11431902
1179778 |  |  | Final | 393559 |  | Post 100% |  | C D w/ I |  | Final |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 -> "Rej" is found in Column K for this ID | Expected Value: 11431902
1224113 |  |  | Final | 21429 |  | Post 100% |  | C D w/ I |  | Final
1226191 | BB of B |  | Final | 90076559 |  | Net Down |  | C D w/ I |  | Final
1226191 | BB of B |  | Final |  |  | Net Down |  | Rp |  | Final
1226572 | AAA |  | INT | 33882484 |  | Post 100% |  | C D w/o I |  | Final
1226572 | AAA |  | Final | 249975 |  | Post 100% |  | C D w/ I |  | Final
Spreadsheet: e15f8b29-ac1d-464c-a56c-461f26354109
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
FGHBS | Test | FGHBS | Gamma-Hydroxybutyric Acid (GHB), Serum-Forensic | Gamma-Hydroxybutric Acid | Gas Chromatography/Flame Ionization Detection (GC-FID) Gas Chromatography/Mass Spectrometry (GC/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 5 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 5 mL of serum refrigerated. Note:  1. Indicate serum on request form. 2. Label specimen appropriately (serum).   [NAME] blood in a green-top (sodium heparin) tube(s). ([NAME] tube is not acceptable.) Spin down and send 5 mL of sodium heparin plasma refrigerated. Note:  1. Indicate plasma on request form. 2. Label specimen appropriately (plasma). | 1.2 mL  Note: Submission of the | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, sodium heparin Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range: Negative (ug/mL)   Gamma-Hydroxybutyric Acid, Serum The clinical effects of Gamma-Hydroxybutyric Acid have been associated with the following concentrations: Wakefulness:  <52 ug/mL Light sleep:  52 - 156 ug/mL Moderate sleep:  156 - 260 ug/mL Deep sleep:  >260 ug/mL   Test Performed by: Medtox Laboratories, Inc.                                       402 W. County Road D                                        St. Paul, MN 55112 | Monday through Friday | 5 days | 7 - 11 days | 1 | 82491 |  |  |  |  | Medtox Laboratories, Inc
FGHBS | Result | Z1217 | Gamma-Hydroxybutyric Acid (GHB) | Gamma-Hydroxybutyric Acid (GHB) | Alphanumeric |  |  |  |  | ug/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: kam_keiser__17854__quotesheet
Sheet: 11-29

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
11/29 - 9:30 | Jan '02 | APB | HSC | Jan '02 | 10,000/d | -.03 @ -.0275
11/29 - 9:30 | Jan '02 | APB | HSC | Jan '02 - Mar '02 | 10,000/d | -.03 @ -.025
11/29 - 9:30 | Jan '02 | APB | Waha | Jan '02 - Mar '02 | 10,000/d | -.135 @
11/29 - 13:30 | Jan '02 | Prebon | Permian | Jan '02 - Mar '02 | 10,000/d | -.16 @ -.15
11/29 - 13:30 | Jan '02 | Natsource | Permian | Jan '02 - Mar '02 | 10,000/d | -.16 @ -.15
11/29 - 13:30 | Jan '02 | APB | Permian | Jan '02 - Mar '02 | 10,000/d | -.145 @ -.135
11/29 - 13:30 | Jan '02 | Prebon | Waha | Jan '02 - Mar '02 | 10,000/d | -.135 @ -.125
11/29 - 13:30 | Jan '02 | Natsource | Waha | Jan '02 - Mar '02 | 10,000/d | -.14 @ -.125
11/29 - 13:30 | Jan '02 | APB | Waha | Jan '02 - Mar '02 | 10,000/d | -.135 @ -.125
Spreadsheet: 867419d1714244096-convert-cell-to-date-dates2
Sheet: Sheet1

Code | Name | Publish date | Date in Excel format
TSLA | [NAME] | Jun 13, 2025, 4 PMEDT
TSLA | [NAME] | Apr 21, 2025, 4 PMEDT
TSLA | [NAME] | Jan 22, 2025, 4 PMEST
TSLA | [NAME] | Oct 16, 2024, 6 AMEDT
TSLA | [NAME] | Jul 17, 2024, 6 AMEDT
TSLA | [NAME] | Jun 13, 2024, 4 PMEDT
TSLA | [NAME] | Apr 23, 2024, 4 PMEDT
TSLA | [NAME] | Jan 24, 2024, 4 PMEST
TSLA | [NAME] | Jan 02, 2024, 12 PMEST
TSLA | [NAME] | Oct 18, 2023, 4 PMEDT
TSLA | [NAME] | Jul 19, 2023, 4 PMEDT
TSLA | [NAME] | Apr 19, 2023, 4 PMEDT
TSLA | [NAME] | Jan 25, 2023, 4 PMEST
TSLA | [NAME] | Oct 19, 2022, 4 PMEDT
TSLA | [NAME] | Jul 20, 2022, 4 PMEDT
TSLA | [NAME] | Apr 20, 2022, 4 PMEDT
TSLA | [NAME] | Jan 26, 2022, 4 PMEST
TSLA | [NAME] | Oct 20, 2021, 4 PMEDT
TSLA | [NAME] | Jul 26, 2021, 4 PMEDT
TSLA | [NAME] | Apr 26, 2021, 4 PMEDT
TSLA | [NAME] | Jan 27, 2021, 4 PMEST
TSLA | [NAME] | Oct 21, 2020, 4 PMEDT
TSLA | [NAME] | Jul 22, 2020, 4 PMEDT
TSLA | [NAME] | Apr 29, 2020, 4 PMEDT
TSLA | [NAME] | Jan 29, 2020, 4 PMEST
TSLA | [NAME] | Oct 23, 2019, 4 PMEDT
TSLA | [NAME] | Jul 24, 2019, 4 PMEDT
TSLA | [NAME] | Apr 24, 2019, 5 PMEDT
TSLA | [NAME] | Jan 30, 2019, 4 PMEST
TSLA | [NAME] | Oct 24, 2018, 4 PMEDT
TSLA | [NAME] | Aug 01, 2018, 4 PMEDT
TSLA | [NAME] | May 02, 2018, 4 PMEDT
TSLA | [NAME] | Feb 07, 2018, 4 PMEST
TSLA | [NAME] | Nov 01, 2017, 4 PMEDT
TSLA | [NAME] | Aug 02, 2017, 4 PMEDT
TSLA | [NAME] | May 03, 2017, 4 PMEDT
TSLA | [NAME] | Feb 22, 2017, 2 PMEST
TSLA | [NAME] | Oct 26, 2016, 4 PMEDT
TSLA | [NAME] | Aug 03, 2016, 4 PMEDT
TSLA | [NAME] | May 04, 2016, 4 PMEDT
TSLA | [NAME] | Feb 10, 2016, 4 PMEST
TSLA | [NAME] | Nov 03, 2015, 4 PMEST
TSLA | [NAME] | Aug 05, 2015, 4 PMEDT
TSLA | [NAME] | May 06, 2015, 4 PMEDT
TSLA | [NAME] | Feb 11, 2015, 4 PMEST
TSLA | [NAME] | Nov 05, 2014, 5 PMEST
TSLA | [NAME] | Jul 31, 2014, 12 AMEDT
TSLA | [NAME] | May 07, 2014, 12 AMEDT
TSLA | [NAME] | Feb 19, 2014, 12 AMEST
TSLA | [NAME] | Nov 05, 2013, 12 AMEST
TSLA | [NAME] | Aug 07, 2013, 12 AMEDT
TSLA | [NAME] | May 08, 2013, 12 AMEDT
TSLA | [NAME] | Feb 20, 2013, 12 AMEST
TSLA | [NAME] | Nov 05, 2012, 12 AMEST
TSLA | [NAME] | Jul 25, 2012, 12 AMEDT
TSLA | [NAME] | May 09, 2012, 12 AMEDT
TSLA | [NAME] | Feb 15, 2012, 12 AMEST
TSLA | [NAME] | Nov 02, 2011, 12 AMEDT
TSLA | [NAME] | Aug 03, 2011, 12 AMEDT
TSLA | [NAME] | May 04, 2011, 12 AMEDT
TSLA | [NAME] | Feb 15, 2011, 12 AMEST
TSLA | [NAME] | Nov 09, 2010, 12 AMEST
PrevNext
Spreadsheet: 866456d1713366146-alternative-to-filter-filter-formula-excel-help
Sheet: Pipe Takeoff

 |  |  |  | THERE CAN BE THOUSANDS OF ROWS THAT LOOK LIKE BELOW |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEED THIS VALUE FROM PIPE LIST PRICING
 |  |  |  | [NAME] | Ins Thick | Feet | 90s | 45s | Misc | Valves | Flanges | Tees | Reducers | Ins Type |  | Manufacturer |  |  |  | COST
 |  |  |  | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POLY-ASJ |  | DUNA |  |  |  | 4.22
 |  |  |  | 10 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MW |  | SPI |  |  |  | 32.692
Spreadsheet: 705778d1606304423-average-last-n-rows-based-on-conditions-sampleb
Sheet: Sheet1

Player | Desc | Total | Workings | Divisor | Result |  | FORMULA | Expected Result
Player A |  | 2
Player A |  | 29
Player A |  | 3
Player A |  | 5
Player A |  | 3
Player A |  | 9
Player A |  | 8
Player A | NB | 3
Player A | NB | 1
Player A |  | 22
Player B | DNQ | 0
Player B |  | 0
Player B |  | 2
Player B |  | 5
Player B | DNQ | 0
Player B |  | 7
Player B |  | 0
Player B | DNQ | 0
Player B |  | 5
Player B |  | 1
Player B | DNQ | 0
Player B | DNQ | 0
Player B | DNQ | 0
Player B | NB | 3
Player B | NB | 12
Player B | NB | 12
Player B | NB | 16
Player B | NB | 4 |  |  |  |  |  | 0 | C29+C28+C27+C26+C25)/0
Player B | NB | 0 |  |  |  |  |  | 0 | C30+C29+C28+C27+C26/0
Player B | NB | 9 |  |  |  |  |  | 0 | C31+C30+C29+C28+C27/0
Player B |  | 0
Player B | NB | 1
Player B | DNQ | 0
Player B | DNQ | 0
Player B |  | 2
Player B |  | 0
Player B | DNQ | 0
Player B |  | 2
Player B | DNQ | 0
Spreadsheet: benjamin_rogers__1294__Caledonia
Sheet: Book Income Statement

 | Income Statement
 |  |  | 1
 | Revenues
 | Energy Revenues
1 | Capacity Revenues
 | Variable Energy Payment
 | Block Payment
 | Energy Margin
 | Ancillary Services
 | Fees
 | Total Revenue
 | EXPENSES
 | Variable Expenses:
 | Fuel and start up fuel
3 | Water Treatment
3 | FERC Fee
3 | Variable Maintenance
 | Total Variable O&M
 | Total Variable Expenses
 | Per Start Expenses:
5 | Major [NAME]
4 | Start-Up Fuel
 | Total Per Start Expenses
 | Fixed Expenses:
2 | Payroll & Burden
2 | Other O&M Expenses
12 | Admin Fee
 | Marketing Fee
9 | O&M Fee
 | Total Fixed Expenses
 | Fixed [NAME]:
6 | Total Insurance
7 | Utilities: Start Up Costs
7 | Utilities: Facility Loads
7 | Interconnection Fees
7 | Gas Pipeline Metering Station
7 | Miscellaneous
 | Total Fixed G&A
8 | Property Taxes |  | 0
 | Operating Taxes
8 | Franchise Tax
 | TOTAL EXPENSES
 | EBITDA
11 | Book Depreciation & Amortization
 | EBIT
 | Interest Expense
10 | Interest Income
 | Net Interest Expense
 | EBT
 | Book Provision for Taxes
 | After Tax Book Income
 | NPV of 2001 EBT |  | 0 | 0
 | NPV of 2001 Earnings |  | 0 | 0
Spreadsheet: 135402d1326023142-cells-with-conditional-formatting-or-data-validation-lists-not-sorting-properly-example-of-conditional-formatting-problem
Sheet: Sheet1

 | Entry # | [NAME] | [NAME] | [NAME] | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 | 1 | Water/Sewage | Monthly | 1 | Paid | Paid | Paid
 | 2 | Electricity | Monthly | 3 | Paid | Paid | Paid
 | 3 | Cell Phone | Monthly | 8 | Paid | Paid | Paid
 | 4 | Cable | Monthly | 10 | Paid | Paid | Paid
 | 5 | Internet | Monthly | 10 | Paid | Paid | Paid
 | 6 | Gas | Monthly | 24 | Paid | Paid | Paid
 | 7 | House Insurance | Annual | 2012-01-20 00:00:00 | Paid
 | 8 | Car Insurance | Annual | 2012-03-19 00:00:00 |  |  | Paid
 | 9 | Property Taxes | Annual | 2012-06-30 00:00:00
 | 10 | Life Insurance | Annual | 2012-10-25 00:00:00
Spreadsheet: 691443d1597690659-shifting-average-function-when-adding-a-new-column-sample-10-week-average-workbook
Sheet: Example

 | Last Week
 | Inside Sales | 2020-06-08 00:00:00 | 2020-06-15 00:00:00 | 2020-06-22 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 10 Week Avg. | QTD Average
 | [NAME] | 3 | 3 | 2 | 1 | 0 | 2 | 2 | 2 | 4 | 0
 | [NAME] | 11 | 4 | 2 | 6 | 2 | 3 | 3 | 2 | 2 | 1
 | Suzanne | 7 | 10 | 1 | 4 | 1 | 0 | 1 | 1 | 0 | 0
 | Jessica | 0 | 9 | 1 | 2 | 1 | 3 | 2 | 3 | 3 | 4
 | [NAME] | 1 | 3 | 1 | 4 | 1 | 0 | 2 | 5 | 2 | 3
 | [NAME] | 0 | 0 | 0 | 2 | 0 | 1 | - | - | - | 0
 | Anne | 0 | 3 | 4 | 2 | 3 | 1 | 2 | 0 | 2 | 0
 | Veronica | 2 | 0 | 0 | 2 | 0 | 5 | 2 | 1 | 3 | 1
 | [NAME] | 2 | 3 | 2 | 1 | 1 | 2 | 0 | 1 | 1 | 3
 | [NAME] | 4 | 3 | 4 | 2 | 3 | 2 | 3 | 1 | 2 | 1
 | Inside Total | 30 | 38 | 17 | 26 | 12 | 19 | 17 | 16 | 19 | 13
 | This Week
 | Inside Sales | 2020-06-08 00:00:00 | 2020-06-15 00:00:00 | 2020-06-22 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 10 Week Avg. | QTD Average
 | [NAME] | 3 | 3 | 2 | 1 | 0 | 2 | 2 | 2 | 4 | 0 | 1
 | [NAME] | 11 | 4 | 2 | 6 | 2 | 3 | 3 | 2 | 2 | 1 | 8
 | Suzanne | 7 | 10 | 1 | 4 | 1 | 0 | 1 | 1 | 0 | 0 | 0
 | Jessica | 0 | 9 | 1 | 2 | 1 | 3 | 2 | 3 | 3 | 4 | 4
 | [NAME] | 1 | 3 | 1 | 4 | 1 | 0 | 2 | 5 | 2 | 3 | 0
 | [NAME] | 0 | 0 | 0 | 2 | 0 | 1 | - | - | - | 0 | -
 | Anne | 0 | 3 | 4 | 2 | 3 | 1 | 2 | 0 | 2 | 0 | 2
 | Veronica | 2 | 0 | 0 | 2 | 0 | 5 | 2 | 1 | 3 | 1 | 3
 | [NAME] | 2 | 3 | 2 | 1 | 1 | 2 | 0 | 1 | 1 | 3 | 1
 | [NAME] | 4 | 3 | 4 | 2 | 3 | 2 | 3 | 1 | 2 | 1 | 2
 | Inside Total | 30 | 38 | 17 | 26 | 12 | 19 | 17 | 16 | 19 | 13 | 21
Spreadsheet: 41468d1239942197-matching-data-book1
Sheet: Sheet1

CustCode | Sale
221000000133 | 20000
221000000232 | 30000
221000000232 | 40000
221000000406 | 50000
221000000497 | 60000
221000000620 | 70000
221000000638 | 80000
221000000661 | 90000
221000000679 | 100000
221000000836 | 110000
221000000976 | 120000
221000001149 | 130000
221000001206 | 140000
221000001388 | 150000
221000001495 | 160000
221000001495 | 170000
221000001578 | 180000
221000001669 | 190000
221000001867 | 200000
221000002014 | 210000
221000002394 | 220000
221000002428 | 230000
221000002477 | 240000
221000002493 | 250000
221000002733 | 260000
221000002782 | 270000
221000002972 | 280000
221000003137 | 290000
221000003350 | 300000
221000003442 | 310000
221000003681 | 320000
221000003756 | 330000
221000003855 | 340000
221000003863 | 350000
221000003939 | 360000
221000003988 | 370000
221000004077 | 380000
221000004366 | 390000
221000004366 | 400000
221000004366 | 410000
221000004432 | 420000
221000004432 | 430000
221000004432 | 440000
221000004507 | 450000
221000004507 | 460000
221000004531 | 470000
221000004606 | 480000
221000004606 | 490000
221000004614 | 500000
221000004614 | 510000
221000004614 | 520000
221000004788 | 530000
221000004838 | 540000
221000004853 | 550000
221000005033 | 560000
221000005108 | 570000
221000005108 | 580000
221000005108 | 590000
221000005108 | 600000
221000005124 | 610000
221000005249 | 620000
221000005272 | 630000
221000005306 | 640000
221000005454 | 650000
221000005959 | 660000
221000006239 | 670000
221000006254 | 680000
221000006312 | 690000
221000006338 | 700000
Spreadsheet: 3cd92380-7d17-4679-a9d6-5927a0f1b625
Sheet: Sheet1

Table 6--Cottonseed oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | Million pounds
2011/12 | 165 | 755 | 10.34710675614 | 930.34710675614 |  | 571.6191067561399 | 258.728 | 830.34710675614 | 100
2012/131 | 100 | 800 | 19.9174 | 919.9174 |  | 599.2454 | 220.672 | 819.9174 | 100
2013/142 | 100 | 630 | 0.3 | 730.3 |  | 420.3 | 210 | 630.3 | 100
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2014-03-11 21:12:24.930000
Spreadsheet: 3e048d59-6997-4b19-86a4-ef075abe804b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Crtique Presentation Schedule | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
EDU 6519 |  |  |  |  |  |  |  | Fall 2013
Class # | 3 | 5 | 6 | 7 | 9 | 10 | 12 | 13
[NAME] | X
Bell | X
[NAME] | X
Doyle, H | X
Doyle, L |  | X
Drakes |  | X
Elam |  | X
Erves |  | X
Fleming |  |  | X
Florence |  |  | X
Gallion |  |  | X
Hatch |  |  | X
Herring |  |  |  | X
Holland |  |  |  | X
Hubb |  |  |  | X
[NAME] |  |  |  | X
Lockhart |  |  |  |  | X
McDonald |  |  |  |  | X
Martin, A |  |  |  |  | X
Martin, J |  |  |  |  | X
Merrick |  |  |  |  |  | X
[NAME] |  |  |  |  |  | X
Singleton |  |  |  |  |  | X
[NAME] |  |  |  |  |  | X
[NAME] |  |  |  |  |  |  | X
Townsend, M |  |  |  |  |  |  | X
Townshend, M |  |  |  |  |  |  | X
Tullos |  |  |  |  |  |  | X
Walls |  |  |  |  |  |  |  | X
Watts |  |  |  |  |  |  |  | X
West |  |  |  |  |  |  |  | X
[NAME] |  |  |  |  |  |  |  | X
Spreadsheet: 94459d1294262216-excel-2007-return-max-date-in-column-based-on-lookup-in-adjacent-column-proj-135030-mvsis-dec-10-draft
Sheet: 4-1-2-18 All

 |  |  |  |  |  |  |  |  |  |  | 08/25/09
 |  |  |  |  |  |  |  |  |  |  | 4-1-2-18
 |  |  |  |  |  |  |  |  |  |  | 09:43 AM
 | AP Invoice List
 |  |  |  |  |  |  |  |  |  |  | Justice
 |  |  |  |  |  |  |  |  |  |  | 1 of 1 |  |  |  | 1 of 1
 |  |  |  |  |  |  |  |  |  |  | Page #
 | Job in list 1897, Vendor in list 28371,1339,25915,24585,22491
 | 24761,26576,13166
Ven# | Vendor | Invoice # | Invoice Date |  | Description | Amount Paid |  | Total | Retention | Invoice Net
1339 | Concrete Cutting Unlimited Inc | 54969 | 09/27/10 |  | 1897/Subcontracted | 43142.4 |  | 55200 | 5520 | 0
1339 | Concrete Cutting Unlimited Inc | 54969 | 09/27/10 |  | 1897/Subcontracted | 773.6 |  | 55200 | 5520 | 0
1339 | Concrete Cutting Unlimited Inc | 54969 | 09/27/10 |  | 1897/Subcontracted | 5764 |  | 55200 | 5520 | 0
22491 | Pac-Con Construction, Inc | 9901178 | 09/30/10 |  | 1897/Subcontracted | 22554 |  | 25060 | 2506 | 0
22491 | Pac-Con Construction, Inc | 9901181 | 10/25/10 |  | 1897/Subcontracted | 40915.8 |  | 45462 | 4546.2 | 0
22491 | Pac-Con Construction, Inc | 9901183 | 11/26/10 |  | 1897/Subcontracted | 0 |  | 55987.67 | 5598.77 | 50388.9
24585 | Sapphire Electric Inc. | CO1 1897 | 09/30/10 |  | 1897/Subcontracted/CO 1 | 139.5 |  | 155 | 15.5 | 0
24585 | Sapphire Electric Inc. | 564207 | 10/20/10 |  | 1897/Subcontracted | 7380.36 |  | 8200.4 | 820.04 | 0
26576 | Terra West, Inc | 1002101 | 06/15/10 |  | 1897/Subcontracted | 1070 |  | 1070 | 0 | 0
28371 | Vic Salazar Communications | 103 | 07/31/10 |  | 1897/Subcontracted | 1890 |  | 2100 | 210 | 0
Spreadsheet: 66c2eb0b-f0ab-42ed-98af-dbbb09b3b567
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
6923 | 46796 | Polina | [NAME] | RUS | 0 | 00:16:31 | 00:00:00 | 00:40:07 | 00:02:18 | 00:21:48 | 1 | 01:20:44
Spreadsheet: 715124d1611579619-formula-for-making-numbers-in-random-order-change-to-ascending-order-ascending-numbers
Sheet: Arkusz1

Random numbers |  |  |  |  | In ascending order
 |  |  |  |  | 2 | 3 | 6 | 7
 |  |  |  |  | 3 | 4 | 8 | 10
 |  |  |  |  | 4 | 7 | 11 | 12
 |  |  |  |  | 3 | 4 | 16 | 20
 |  |  |  |  | 2 | 8 | 8 | 12
 |  |  |  |  | 3 | 4 | 4 | 16
1 |  | 1 | 1 |  | 1 | 1 | 1 | 17
Spreadsheet: 89925d1289668286-placing-a-list-of-ranged-numbers-book1
Sheet: Sheet1

A | B | C
3 | 9 | 9
8 | 190 | 10
7 | 92 | 11
3 | 119 | 11
7 | 129 | 12
7 | 39 | 12
5 | 409 | 13
2 | 139 | 13
Spreadsheet: 779739d1652079332-populate-calendars-based-on-office-location-daf-office-scheduling-draft-aligw
Sheet: AP

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2 | 3 | 4 | 5 | 6 | 7
 | Maddy | Jasmine | Jasmine | [NAME] | Jasmine
 | Tania | Maddy | Tania | [NAME] | Maddy
 | Natasha | Tania | Natasha | Jasmine | Tania
 | Hayley | Hayley | Hayley | Maddy | Hayley
 |  |  | Leigh | Tania
 |  |  | [NAME] | Natasha
 |  |  |  | Hayley
 | Jasmine | Jasmine | Jasmine | [NAME] | Jasmine
 | Maddy | Maddy | Maddy | Jasmine | Maddy
 | Natasha | Tania | Tania | Maddy | Tania
 | Hayley | Natasha | Natasha | Tania | Natasha
 |  | Hayley | Hayley | Natasha | Hayley
 |  |  |  | Hayley
 | Jasmine | Jasmine | Jasmine | Jasmine | Jasmine
 | Maddy | Maddy | Maddy | Maddy | Maddy
 | Tania | Tania | Tania | Tania | Tania
 | Natasha | Natasha | Natasha | Natasha | Natasha
 | Hayley | Hayley | Hayley | Hayley | Hayley
 | Jasmine | Jasmine
 | Maddy | Maddy
 | Tania | Tania
 | Natasha | Natasha
 | Hayley | Hayley
Spreadsheet: 801609d1666272932-transform-hourly-values-into-15-minutes-values-book1
Sheet: Sheet1

Hourly value |  |  | 1/4ly value
22
33 |  |  | 5.5
44 |  |  | 5.5
23 |  |  | 5.5
22 |  |  | 8.25
 |  |  | 8.25
 |  |  | 8.25
 |  |  | 8.25
 |  |  | 11
 |  |  | 11
 |  |  | 11
 |  |  | 11
 |  |  | 5.75
 |  |  | 5.75
 |  |  | 5.75
 |  |  | 5.75
 |  |  | 5.5
 |  |  | 5.5
 |  |  | 5.5
 |  |  | 5.5
Spreadsheet: 146987d1332454510-cash-flow-statement-income-statement
Sheet: Branch 1

date | initial balance | income | outcome | balance
1.2.20012 | 100000 | 10000 | 15000 | 95000
2.2.20012 | 95000 | 5000 | 0 | 100000
2012-02-07 00:00:00 | 100000 | 16000 | 1000 | 115000
Spreadsheet: 698759d1602164345-display-highest-value-based-on-date-displayif-excel_example_rain-ans
Sheet: Tabelle1

Date | Time | °C | [NAME]
2020-07-09 00:00:00 | 14:34:40 | 24545
2020-07-09 00:00:00 | 14:49:40 | 21855
2020-07-09 00:00:00 | 15:04:40 | 18045
2020-07-09 00:00:00 | 15:19:40 | 17475
2020-07-10 00:00:00 | 08:38:50 |  | 0.2
2020-07-10 00:00:00 | 08:49:40 | 17379
2020-07-10 00:00:00 | 09:03:08 |  | 0.4
2020-07-10 00:00:00 | 09:04:40 | 17284
2020-07-10 00:00:00 | 09:07:01 |  | 0.6
2020-07-10 00:00:00 | 09:19:40 | 17284
2020-07-11 00:00:00 | 16:19:40 | 16046
2020-07-11 00:00:00 | 16:21:07 |  | 0.8
2020-07-11 00:00:00 | 16:28:34 |  | 1.0
2020-07-11 00:00:00 | 16:30:55 |  | 1.2
2020-07-11 00:00:00 | 16:32:03 |  | 1.4
2020-07-11 00:00:00 | 16:3315 |  | 1.6
DATE | RAIN
2020-07-09 00:00:00 |  |  |  | Rain 09/07 | 0.0mm
2020-07-10 00:00:00 |  |  |  | Rain 10/07 | 0.6mm
2020-07-11 00:00:00 |  |  |  | Rain 11/07 | 1.0mm
2020-07-12 00:00:00
Spreadsheet: 145752d1331730316-sumif-formula-question-help-country_20120314_122017-1-
Sheet: Sheet1

UserCountry | Number of Users
United Kingdom | 1065
Switzerland | 41
France | 23
Italy | 17
Ireland | 13
Luxembourg | 12
Spain | 10
Germany | 9
Netherlands, the | 7
Belgium | 4
Austria | 3
Andorra | 2
Hungary | 2
Malta | 2
Monaco | 2
Lebanon | 1
Norway | 1
United Arab Emirates | 1
Result would be:
United Kingdom
France
Italy
Ireland
Spain
Germany
Norway
Others
Spreadsheet: 47978d1247153734-subtotal-lines-excel-help-forum-example
Sheet: Sheet1

Group | Date | Indie | Title | Distributor | Attendance
CORNWALL | APR | * | SHORT FILMS | Sony | 213
Van City | AUG 9 | * | SHORT FILMS | Sony
WATERLOO | FEB | * | SHORT FILMS | Sony | 21
OTTAWA | FEB | * | SHORT FILMS | Sony | 44
DAWSON CITY | JAN | * | SHORT FILMS | Sony | 25
COBOURG | JAN | * | SHORT FILMS | Sony | 173
[NAME] | JAN | * | SHORT FILMS | Sony | 262
HUNTSVILLE | JUL 6 | * | SHORT FILMS | Sony
OTTAWA | MAR | * | SHORT FILMS | Sony | 8
 |  | * | 32 SHORT FILMS ABOUT [NAME] Total | Sony | 746