tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 768569d1645027775-count-different-type-of-text-and-give-me-text-and-sum-of-numbers-create-state-list-and-count-aligw
Sheet: English (2)

September |  |  |  |  | Calculation date
 |  | Start date | End date | STATE | 2021-09-30 00:00:00
 | Anne | 2021-01-01 00:00:00 |  | NY
 | Nina |  | 2021-09-30 00:00:00
 | [NAME] | 2021-03-01 00:00:00 | 2021-08-01 00:00:00 | FL
 | [NAME] | 2021-08-07 00:00:00 | 2021-10-31 00:00:00 | MO
 | [NAME]
 | Sigrid | 2021-09-09 00:00:00 | 2021-11-30 00:00:00 | NY
 | [NAME] | 2019-03-31 00:00:00 | 2021-09-02 00:00:00
 | Heida | 2021-09-02 00:00:00
 | Sandra | 2021-10-03 00:00:00 | 2021-12-31 00:00:00
 | Eva | 2022-11-03 00:00:00
 |  |  | NY | 2
 |  |  | FL | 1
 |  |  | MO | 1
 |  | How to get excel to give me this result?
Spreadsheet: 840144d1692482483-need-to-calculate-average-over-a-date-range-using-several-variables-dummy-report
Sheet: Sheet1

Date From: | 2022-06-01 00:00:00
Date To: | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2022-10-01 00:00:00 | 2023-04-01 00:00:00
Employee | Target |  | Employee | Date 1 | Pos 1 | Date 2 | Pos 2 | Date 3 | Pos 3 |  | Position | Target 1 | Target 2 | Target 3 | Target 4
Richie |  |  | Richie | 2020-01-01 00:00:00 | Assistant Consultant | 2022-12-01 00:00:00 | Consultant |  |  |  | Director | 5 | 5.5 | 6
Palmer |  |  | Palmer | 2020-01-01 00:00:00 | Director |  |  |  |  |  | Associate Director | 4 | 4.5 | 5
[NAME] |  |  | [NAME] | 2020-01-01 00:00:00 | Senior Consultant | 2023-04-01 00:00:00 | Associate Director |  |  |  | Senior Consultant | 3 | 3.5 | 4
Milligan |  |  | Milligan | 2020-01-01 00:00:00 | Consultant | 2022-08-01 00:00:00 | Senior Consultant | 2023-02-01 00:00:00 | Associate Director |  | Consultant | 2 | 2.5 | 3
 |  |  |  |  |  |  |  |  |  |  | Assistant Consultant | 1 | 1.5 | 2
Spreadsheet: 470722d1468606448-how-to-make-a-check-box-pay-worksheet
Sheet: Pay Report

Pay Rate: | 77.73
Airbus Rate: | 1.014
Int'l Ovrd: |  |  | IO | Trip | Block | Credit | MUP | JRM | TXR | SIC | VAC | Eff. Credit
Manual Ovrd: |  |  |  | F4882B | 2:33:00 | 9:00:00 | 2
 |  |  |  | F4894 | 10:03:00 | 17:51:00 | 3
Airbus Ovrd: |  |  |  | F4938 | 7:53:00 | 13:30:00 | 3 |  |  |  | x
Int'l Ovrd: |  |  |  | F4882B | 2:33:00 | 9:00:00 | 2 |  |  | x
Junior Pay: |  |  |  | F4894 | 10:03:00 | 17:51:00 | 3 | x
Overtime: |  |  |  | F4938 | 7:53:00 | 13:30:00 | 3
Regular: | 36 |  |  | F4362 | 0:00:00 | 18:38:00 |  |  | x
Total Hours: |  |  |  | RLS | 0:00:00 | 4:00:00
 |  |  |  | F4064 | 9:41:00 | 10:07:00
Holiday: |  |  | x | F4361 | 7:28:00 | 7:28:00
Hotel Buy Back:
Retro / Other:
Total Pay:
VAC Start: | 45
VAC Remaining:
Block/Credit:
Effective Pay: |  |  |  | Totals:
 |  |  | Edit: Pay Rate, Airbus Rate, Manual Ovrd (for int'l trips as part of another pairing, Holiday, Hotel Buy Back, [NAME], VAC Start, Trip, Block, Credit, Enter: Days MUP (not hours). Put an "X" for JRM, TXR, SIC and/or VAC. Effective Credit will tally automatically. IO: International Override. Put an "X" if the trip is considered Int'l Ovrd for 8%.
Spreadsheet: 119872d1314806915-pull-rows-by-cell-value-to-another-sheet-in-workbook-book4
Sheet: Sheet1

Date | Code | Amt
2011-08-01 00:00:00 | BC | 4900
2011-08-01 00:00:00 | BC | 189
2011-08-08 00:00:00 | CS | 427
2011-08-08 00:00:00 | CA | 636
2011-08-08 00:00:00 | BC | 421
2011-08-08 00:00:00 | MC | 522
2011-08-09 00:00:00 | BC | 250
2011-08-09 00:00:00 | CS | 444
Spreadsheet: c364d63c-2421-4da0-ad83-77e68ac0db08
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
FBUS | Test | FBUS | Buspirone ([NAME]) | Buspirone ([NAME]) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] is not acceptable.) Spin down and send 3 mL  of sodium heparin plasma refrigerated. Note:	1. Trough levels are most reproducible. 		2. Indicate plasma on request form. 	3. Label specimen appropriately (plasma).   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 3 mL of serum refrigerated. Note:	1. Trough levels are most reproducible. 		2. Indicate serum on request form. 	3. Label specimen appropriately (serum). | 0.6 mL Note:  Submission of the | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Therapeutic and toxic ranges have not been established.      Expected serum buspirone concentrations in patients taking  recommended daily dosages: up to 10.00 ng/mL.      Test performed by: Medtox Laboratories, Inc.                                       402 W. County Road D                                       St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
FBUS | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FBUS | Result | Z1186 | Buspirone | Buspirone | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 456783d1461060479-calculating-a-moving-average-problem-with-blank-cells-average-problem-with-blank-cells-monitoring-example-ans
Sheet: Example

 | Date | Moving Average (12 months) | Volatile Formula |  | Non Volatile Formula |  | JohnTopley formula
 | 2015-12-21 00:00:00
 | 2016-02-08 00:00:00
 | 2016-04-11 00:00:00
 | 2015-12-31 00:00:00
 | 2016-01-29 00:00:00
Spreadsheet: 875616d1722219422-how-to-keep-a-drop-down-table-list-from-changing-drogersdk-excel-drop-down-list
Sheet: Inputs

 | HOLD Property Analysis Worksheet - 30 Year
 | Prepared By
 | Client Name
 | Property Address | 3255 Warrensville Center Road
 | Fix drop downs again
 | Units | Length | [NAME] | Square Feet
 | 101
 | 201
 | [NAME]
 | Total Building Apartment Interiors
 | Rooms
 | Common Area 1st Floor
 | Common Area 2nd Floor
 | Garage
 | Living Room
 | Dining Room
 | Kitchen
 | Bedroom 1
 | Bedroom 2
 | Bathroom
 | Room Measurements | Length | [NAME] | Total Sq Ft | Lineal Feet
 | Living Room | 20 | 10
 | Kitchen | 12 | 12
 | Bathroom | 9 | 10
 | Master [NAME] | 9 | 10
 | 2nd Bedroom | 9 | 10
 | 3rd Bedroom | 9 | 10
 | 4th Bedroom | 9 | 10
 | Basement | 9 | 10
 | Hallways | 9 | 10
 | Ceiling Height | 7
 | Totals
 | Cabinets
 | Cabinet wall to wall width |  | 2
 | Building Square Feet
Spreadsheet: louise_kitchen__22554__Hot List Update 07-24-01 - Management
Sheet: E-Commerce 50+

Deal Description Sheet - 7/24/01
[NAME]
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Andex | [NAME] | Andex | ATS accounting services and software. | 20000 | 2001-07-12 00:00:00 | 0.5 | 2001-07-01 00:00:00 | Andex has elected to pursue other options for their production management, however, [NAME] is interested in several ATS products.
Preston | [NAME] | Preston Energy | Sale of ATS software and/or ASP.  Enron commision from ATS. | 40000 | 2001-06-19 00:00:00 | 0.8 | 2001-09-01 00:00:00 | Preston is expected to purchase several of the ATS products.
Columbia Natural Resources | [NAME] |  | Application Service Provider, gas and liquids, E&P accounting, forecasting. | *$250,000 | 2001-04-16 00:00:00 | 0.5 | 2001-09-30 00:00:00 | ENA missed the supply deal, but is working on the outsourcing.  Lost to AEP who bid 3 1/4 for the pool gas.  ENA bid 1/4. CMR will start trading this summer.
VR84 | Nelson Ferries | Continental Land & Fur (CL&F) | ATS E&P accounting services and commodity management services | *$10,000 | 2001-07-13 00:00:00 | 0.9 | 2001-10-01 00:00:00 | ATS is currently providing E&P accounting services on VR 84.  CL&F has an additinoal 300 wells producing 100 mmcfd that they could take in kind.
Mariner | [NAME] | Mariner | Integrated outsourcing products. | *$100,000 | 2001-07-24 00:00:00 | 0.5 | 2001-10-01 00:00:00 | Luncheon with [NAME] in August.
Project Deep Blue Sea | [NAME] | Ocean Energy | Integrated outsourcing products and operations related to Harve Pipeline System. | *$500,000 | 2001-06-11 00:00:00 | 0.5 | 2001-11-01 00:00:00 | Project meeting scheduledfor July 26th with Ocean, Enron and HMS to outline project scope and other project parameters.
 |  |  |  |  |  |  |  | * Accrual
Spreadsheet: 15054ca4-c67a-4378-a7ad-f88d8555cc63
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Bransje:Malere
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Eikeland [NAME] | Nedre Ulsetskogen 50 | 5119 | Ulset | 951 51 053
[NAME] | Skålevikv. 60 | 5178 | Loddefjord | 55 50 96 50 | 55 50 96 51
[NAME] og Byggtapetsering | Lyngv. 8 | 3260 | Larvik | 988 54 676
[NAME] maler- og byggtapetserfirma AS | [NAME]. 16 | 3117 | [NAME] | 33 31 55 45
[NAME] | Østadv. 26 | 1712 | Grålum | 951 27 333
Skilbrei Rune Maler AS | Tunav. 7 | 6817 | Naustdal | 996 92 267
Kallevik [NAME] | Kallevikv. 49 | 5563 | Førresfjorden | 900 45 013
[NAME] | Låkegutua 16 | 2074 | Eidsvoll Verk | 951 54 555
Academica Malerentreprenøren AS | [NAME] 23 | 0580 | Oslo | 23 06 78 90
[NAME] Malerforretning | [NAME]. 81B | 5161 | Laksevåg | 55 51 70 70 | 55 51 70 75
Malefryd AS | Furukollen 27 | 1900 | Fetsund | 63 88 50 90
[NAME] Malermester AS | Lienv. 113 | 3580 | Geilo | 32 09 60 80 | 32 09 60 89
[NAME] |  | 6216 | Geiranger | 911 56 298 | 70 26 07 04
Lilleøen Alf Ivar | [NAME] v 46 | 7053 | Ranheim | 918 60 005
[NAME] | Haakon VII's g 1 | 0161 | Oslo | 915 57 514
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 63946d1264793509-count-non-blank-non-numeric-non-zero-non-space-non-error-text-cells-2007-for-excel-forum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Uni-word |  |  |  | 1
 |  |  |  |  |  |  |  |  | 0 |  |  |  | 1
 |  |  |  |  |  |  |  |  | -- |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | Two words |  |  |  | 3
 |  |  |  |  |  |  |  |  | Test |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | We are 3 |  |  |  | 5
 |  |  |  |  |  |  |  |  | Test |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  | ^^^ |  | ^^^
 |  |  |  |  |  |  |  |  |  |  | Actual |  | Desired
 |  |  |  |  |  |  |  |  |  |  | Output |  | Output
Spreadsheet: sally_beck__35756__MgmtSum-Q1-0222
Sheet: GM-WklyChnge

ENRON NORTH AMERICA
1ST QUARTER 2000 DETAIL OF GROSS MARGIN
WEEKLY CHANGE
 |  |  |  |  |  |  | Actual | Deals | Forecast | Total
Business Team |  | DPR* | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin
Gas Trading
Power Trading
Financial Drift
Financial Trading
Canada
Coal
Weather
Emissions
Insurance Group
Executive Trading
Total Trading & Risk Management
East Midstream
West Midstream
Industrial Downstream - Paper
Industrial Downstream - Chemicals
Midstream IPP
Upstream E&P
Asset Management
Mexico
Executive Origination
Total Origination
Genco
Generation Investments
Gas Assets
Gas Assets - Trading
Total Assets
Principal Investing
Restructuring
Canada - Investing
Total Investing
Commercial Transactions Group
Office of the Chairman
Other Interest Related Charges
Overview
Total
* Excludes Cap. Charge & Operating Costs
 |  |  |  | Deals Added: | Louis Dreyfus Services |  | Assets | 132
 |  |  |  |  | Tri-Union Services |  | Assets | 100
 |  |  |  | Deals Changed:
 |  |  |  | Deals Removed: | Great River |  | East Orig | -800
 |  |  |  | Deals Completed: | Velsicol - GL |  | Assets | -100
 |  |  |  |  | 2 Deals |  | Assets | -115
Gas
Power
Genco
Drift
Financial
Emerging Businesses
Spreadsheet: 51327d1250868380-data-validation-list-with-only-non-blank-cells-696609
Sheet: Sheet1

 |  |  | A |  | Salesmen
 |  |  | B |  | Dynamic Salesmen
 |  |  | C
 |  |  | D
 |  |  | E
 |  |  | F
 |  |  | G
 |  |  | H
 |  |  | I
 |  |  | J
 |  |  | K
 |  |  | L
 |  |  | M
 |  |  | N
 |  |  | O
 |  |  | P
 |  |  | Q
 |  |  | R
 |  |  | S
 |  |  | T
 |  |  | U
 |  |  | V
 |  |  | W
 |  |  | X
 |  |  | Y
 |  |  | Z
Spreadsheet: 883457d1732082972-finding-an-item-that-is-in-stock-and-has-not-been-returned-rent
Sheet: Sheet1

 | Question |  |  | Expected Result
Operation | Goods | Number |  | Goods | Number
Rent | Book | 10 |  | Book | 2
Rent | [NAME] | 5 |  | Pencil | 3
Rent | Pencil | 3
Back | Book | 8
Back | [NAME] | 5
 | No auxiliary columns please
 | No [NAME] please
Spreadsheet: 793364d1661431889-function-for-adding-strings-in-one-cell-together-and-rounding-money-amount-on-2-decimals-function-aligw
Sheet: function

name | date | Moneyamount | function | Preferred function result
[NAME] | 2022-06-19 00:00:00 | 100 |  | [NAME] | 19-6-2022 | €100
[NAME] | 2022-06-20 00:00:00 | 101 |  | [NAME] | 19-6-2022 | €101
[NAME] | 2022-06-21 00:00:00 | 102 |  | [NAME] | 19-6-2022 | €102
[NAME] | 2022-06-22 00:00:00 | 103 |  | [NAME] | 19-6-2022 | €103
[NAME] | 2022-06-23 00:00:00 | 104 |  | [NAME] | 19-6-2022 | €104
[NAME] | 2022-06-24 00:00:00 | 105 |  | [NAME] | 19-6-2022 | €105
[NAME] | 2022-06-25 00:00:00 | 106 |  | [NAME] | 19-6-2022 | €106
Spreadsheet: darron_c_giron__8050__2000
Sheet: February 2000

Done after bid-week:
Telerate/Price Basis/Quotes/Deals/OTC/Pub Posting
Pull up Crude Merc value & update cell E9 |  |  |  |  | Date,F5,%Nxavcprompt,F3
Update following cells from Gas Market Report
 |  | Note: Insert the #'s in blue to calculate the customer price
 |  | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 |  | 29.298 | 2.41 | 2.61 | 2.36 | 2.43
CPR# | Sitara # | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 | 27258 | E21728 | 2,500/day | 506767 | 7/95-12/2001
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 | 106622 | E11400 | 2,500/day | 506767 | 1/92-12/2003
CPR# | Sitara # | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 | 106624 | E22656 | 7,000/day | 506767 | 1/95-12/2001
CPR# | Sitara # | TAGG # | Southern | Facility | Term | Calculated Price
394674 | 27253 | E21977 | 10,000/day | 506766 | 6/96-4/2002
CPR# | Sitara # | TAGG # | Agave/Yates | Facility | Term | Calculated Price
93788 | 27245 | E20337 | 10,000/day | 58649 | 1/93-12/2002 |  | * moved to Central desk for March
 |  | Last Update:
Spreadsheet: 134fc95f-ec3a-4517-8b5a-c146d12274b8
Sheet: Sheet1

Brock Wellness Fitness Challenge | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Please fill in the information below and return a summary of names and point totals for your department each month.  Save this document as an .xls (EXCEL) file and return to [EMAIL] by Wednesday, June 13,2012
Participants and team leaders may access this form at  brocku.ca/hr-ehs/environment-health-safety/health-wellbeing
Department:
Department TOTAL: | 0 |  | ◄ | - return the number of total participants and total points for your department to [EMAIL] by Wednesday, June 13,2012
 | 0 |  | ◄ | - number of participants
Participant Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Activity for the purpose of this challenge includes the use of your large muscles rhythmically over a period of time such as walking, jogging, cycling, swimming, stepping, for a minimum of 10-15             minutes each session
- Activity can take place on or off campus but must take place in the days points are awarded
- This competition will be completed June 12, 2012
Brock Wellness Committee email:    [EMAIL]
Spreadsheet: 172066d1343973362-find-text-string-in-range-of-cells-sample-sheet
Sheet: Plan Data

Plan Title | Data Tags | Organization
Plan 556 | Home, School | ORG A
Plan 557 | Health, R&D | ORG B
Plan 558 | School | ORG C
Plan Plan 559 | Aviation | ORG A
Plan 560 | Steal, Development, Remanufacturing, Old | ORG B
Plan 561 | Travel, Aviation | ORG C
Plan 562 | Cruise, Travel | ORG D
Spreadsheet: 107374d1304559257-finding-the-lowest-values-and-matching-matching
Sheet: Sheet1

Date | Time | Open | High | Low | Close | CCI | Lowest Low | Lowest CCI
2010-03-01 00:00:00 | 02:00:00 | 1.3635 | 1.3645 | 1.3596 | 1.3596 | -21.83426443202631
2010-03-01 00:00:00 | 03:00:00 | 1.3595 | 1.3599 | 1.3525 | 1.3542 | -279.427549195002
2010-03-01 00:00:00 | 04:00:00 | 1.3541 | 1.355 | 1.3508 | 1.351 | -271.8139744892108
2010-03-01 00:00:00 | 05:00:00 | 1.3509 | 1.3537 | 1.3505 | 1.3529 | -180.7037362453484
2010-03-01 00:00:00 | 06:00:00 | 1.353 | 1.3546 | 1.3515 | 1.3518 | -128.1928877819229
2010-03-01 00:00:00 | 07:00:00 | 1.3517 | 1.3533 | 1.346 | 1.3477 | -148.9127071201555
2010-03-01 00:00:00 | 08:00:00 | 1.3478 | 1.3519 | 1.3472 | 1.351 | -106.2097860242362 | 1.346 | -279.427549195002 | This would be True.
If the lowest low of the past six candles doesn't have the lowest cci over the same period in the same row, then the formula equals "TRUE".
Spreadsheet: 101396d1299536177-extract-correct-denomination-of-bills-money-counter-remove-large-bills-remove-money
Sheet: Sheet1

 |  |  |  |  | 150
 |  |  | hand | remove | remain
 | helper row |  | 0
 | bill | 100 | 6
 | tens | 100 | 10
 | fives | 100 | 10
 | bill | 50 | 3
 | bill | 20 | 1
 | bill | 10 | 3
 | QR | 10 | 4
 | [NAME] | 5 | 5
 | DR | 5 | 8
 | NR | 2 | 8
 | [NAME] | 1 | 3
 | PR | 0.5 | 8
 | qaurter | 0.25 | 4
 | Dimes | 0.1 | 4
 | Nickel | 0.05 | 9
 | Pennies | 0.01 | 9
Spreadsheet: 668490d1584869821-extract-rows-data-with-3-conditions-q2-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Done |  |  | Desired results
 |  | X | X |  | X |  | X |  | Option 1 |  |  | Option 2
 | Name | A1 | B1 | C1 | D1 | E1 | F1
 | AAAAA | X |  | X | X |  | X
 | DSAS |  | X |  | X | X
 | EEED | X | X |  |  |  | X
 | CCFF | X | X |  | X | X
 | AZAS |  |  | X | X
 | ABMLIG | X |  | X |  |  | X
 | QASD | X | X | X
 | FGHK | X | X |  | X | X
 | zzzzz | X |  | X | X
 | WRTYU |  | X |  |  |  | X
 | In option 1 - are extracted from B4:B13 marked "X" for ALL C3:H3
 | In option 2 - I would like to extract the same B4:B13 marked "X" but ONLY for C3:H3 marked "X" in C2:H2
Spreadsheet: 747989d1631814797-formula-for-tiered-pricing-based-on-an-average-excel-example
Sheet: Sheet1

 | Total average  kilos | Trees | Price per Kilo Tier 1 | Tier 1 level (kgs) | Price per Kilo Tier 2 | [NAME] level (kgs) | Price per kilo [NAME]
 | 37 | 26 | 2.5 | 25 | 1.25 | 30 | 0.75
 | For every average kilo of walnuts harvested per tree, I have to pay $2.50 per kilo up to 0-25 kilos, $1.25 for 26-30 and .75 for every kilo over 30.
 | I am trying to write a formula that would calculate the total amount due.
 | In this example 26 trees were harvested for an average of 37 kilos per tree, my total cost would be:
 | [NAME] |  | [NAME] | Marginal Pricing
 | 0 | 25 | 2.5 | 2.5
 | 25 | 30 | 1.25 | -1.25
 | 30 | No cap | 0.75 | -0.5
 |  |  |  | Kilos per tree | 37
 |  |  |  | Trees | 26
 |  |  |  | Total Amount Due
Spreadsheet: 674370d1587804318-summations-between-a-date-range-2020-04-24-oeldere3-pt-674330d1587759212-summations-between-a-date-range-old-feedlot-head-day
Sheet: Sheet1

Month Beginning | 2020-04-01 00:00:00
Period Ending | 2020-04-24 00:00:00
Lot | HR7496 | Harris1
Total Head Days
Correct Summation should be | 294 | 2808
[NAME] (3)
Subtotal (2)
Date | Harris1 | HR7496 | Harris3 | criteria |  |  | Oeldere Pivot Table (1)
2020-04-01 00:00:00 | 145 | 0 | 0 |  |  |  | criteria | yes
2020-04-02 00:00:00 | 143 | 0 | 0
2020-04-03 00:00:00 | 143 | 0 | 0 |  |  |  | Som van Harris1 | Som van HR7496
2020-04-04 00:00:00 | 143 | 0 | 0 |  |  |  | 2808 | 294
2020-04-05 00:00:00 | 143 | 0 | 0
2020-04-06 00:00:00 | 143 | 0 | 0
2020-04-07 00:00:00 | 143 | 0 | 0
2020-04-08 00:00:00 | 143 | 0 | 0
2020-04-09 00:00:00 | 143 | 0 | 0
2020-04-10 00:00:00 | 143 | 0 | 0
2020-04-11 00:00:00 | 143 | 0 | 0
2020-04-12 00:00:00 | 143 | 0 | 0
2020-04-13 00:00:00 | 143 | 0 | 0
2020-04-14 00:00:00 | 143 | 0 | 0
2020-04-15 00:00:00 | 134 | 0 | 0
2020-04-16 00:00:00 | 134 | 0 | 0
2020-04-17 00:00:00 | 134 | 0 | 0
2020-04-18 00:00:00 | 134 | 0 | 0
2020-04-19 00:00:00 | 134 | 0 | 0
2020-04-20 00:00:00 | 134 | 0 | 0
2020-04-21 00:00:00 | 0 | 0 | 0
2020-04-22 00:00:00 | 0 | 0 | 0
2020-04-23 00:00:00 | 0 | 147 | 0
2020-04-24 00:00:00 | 0 | 147 | 0
2020-04-25 00:00:00 | 0 | 147 | 0
2020-04-26 00:00:00 | 0 | 147 | 0
2020-04-27 00:00:00 | 0 | 147 | 0
2020-04-28 00:00:00 | 0 | 147 | 0
2020-04-29 00:00:00 | 0 | 147 | 0
2020-04-30 00:00:00 | 0 | 147 | 0
 | 0 | 0 | 0
Spreadsheet: 61832d1262754174-inserting-names-numbers-into-individual-notes-oscar-notes
Sheet: Data

1 Private | 0
2 Private | 755 |  |  |  |  |  |  |  | Name: | Private
3 Private | 130 |  |  |  |  |  |  |  | Phone Number: | 555-5555
4 Private | 360 |  |  |  |  |  |  |  | Minutes per week: | 90
5 Private | 840 |  |  |  |  |  |  |  | Total minutes: | 630
6 Private | 0
7 Private | 0
8 Private | 825
9 Private | 570
10 Private | 1195
11 Private | 0
12 Private | 0
13 Private | 280
14 Private | 825
15 Private | 0
16 Private | 315
17 Private | 0
18 Private | 450
19 Private | 1405
20 Private | 920
21 Private | 30
22 Private | 910
23 Private | 0
24 Private | 815
25 Private | 0
26 Private | 0
27 Private | 320
28 Private | 653
29 Private | 416
30 Private | 0
31 Private | 1260
32 Private | 0
33 Private | 0
34 Private | 0
35 Private | 560
36 Private | 0
37 Private | 140
38 Private | 2124
39 Private | 630
40 Private | 1005
41 Private | 700
42 Private | 445
43 Private | 220
44 Private | 1360
45 Private | 575
46 Private | 400
47 Private | 755
48 Private | 315
49 Private | 0
50 Private | 565
51 Private | 720
52 Private | 828
53 Private | 670
54 Private | 720
55 Private | 735
56 Private | 335
57 Private | 640
58 Private | 425
59 Private | 450
60 Private | 210
61 Private | 630
62 Private | 825
63 Private | 590
64 Private | 230
65 Private | 745
Spreadsheet: 805230d1668596983-divide-as-whole-number-and-allocate-to-month-column-book1-19-ans
Sheet: Sheet1

Item | Start Date | Months | Finish Date | Qty | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
1 | 2023-02-01 00:00:00 | 3 |  | 70
2 | 2023-01-01 00:00:00 | 2 |  | 23
3 | 2023-04-01 00:00:00 | 3 |  | 14
4 | 2023-05-01 00:00:00 | 4 |  | 16
Spreadsheet: 1f94b8aa-00c2-4aaa-9796-efaf66f97745
Sheet: Sheet1

Northwest Conference Standings (3-13-10) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | OVERALL |  | CONFERENCE |  | OVERALL | CONF.
TEAM | OVERALL |  | CONFERENCE |  | OVERALL | CONFERENCE
[NAME] | 15 | 8 | 7 | 1 | 0.6522 | 0.875
LIBBY | 14 | 6 | 6 | 2 | 0.7 | 0.75
POLSON | 14 | 8 | 5 | 3 | 0.6364 | 0.625
RONAN | 2 | 19 | 1 | 7 | 0.0952 | 0.125
WHITEFISH | 2 | 19 | 1 | 7 | 0.0952 | 0.125