tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 760170d1640028141-vlookup-for-a-formula-result-test-bracket-1-
Sheet: Players

Players |  | Round 1 | Round 2 | Round 3 | Round 4 | Round 5 | Round 6 | Round 7 | Round 8 | Round 9 | Round 10 | Round11
1 | [NAME] | l
2 | [NAME] | l
3 | [NAME] | l
4 | Gedas | l
5 | [NAME] | l
6 | Nick | l
7 | Tiffany | l
8 | [NAME] | l
9 | [NAME] | w
10 | [NAME] | w
11 | [NAME] | w
12 | [NAME] | w
13 | [NAME] | w
14 | Jordan | w
15 | Milta | w
16 | [NAME] | w
Spreadsheet: 838823d1691425846-need-help-with-a-split-calculation-based-on-date-submit-google-docs-sample
Sheet: Transactions

 |  | Client Name | Buyer Or [NAME] | % | Net Return | Listing |  |  |  |  |  | Contract |  |  |  | Income |  |  | Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brokerage |  |  |  |  |  |  |  | Referrals
 | Status |  |  |  |  | List or Lead Date | Price | DOM | Pre - Inspection? | Price [NAME]? | Current Price | Pending Date | Pending Price | Close Date | Close Price | Gross |  |  | Total | Prelist |  |  |  |  |  |  |  | Marketing |  |  |  | Post Close |  | Total | Transaction Fee |  |  | Commission |  |  | E&O | Total | Y/N | Agreed % | Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Potential | Pending | Closed |  | Sewer Scope | Inspection | Staging | Photos | Video | Cleaning | Signage | Misc | Mailers | Social Ads | Google Ads | Misc | [NAME] | Misc |  | Potential | Pending | Closed | Potential | Pending | Closed |  |  |  |  | Potential | Pending | Closed
Property 1 | Active |  | [NAME] | 0.025 |  | 2023-06-01 00:00:00 | 1700000 |  | True | True | 1675000 | 2023-07-20 00:00:00 | 1675000 | 2023-08-01 00:00:00 | 1675000 |  |  |  |  | -358 | 0 | -2500 | -650 | -450 | 0 | -107 | 0 | -157 | -181 | -119 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | No
Property 2 | Active |  | [NAME] | 0.03 |  | 2023-07-13 00:00:00 | 899000 |  | True | False | 899000 | 2023-07-20 00:00:00 | 899000 | 2023-08-01 00:00:00 | 899000 |  |  |  |  | -275 | 0 | -3800 | -575 | 0 | -150 | -81 | 0 | -232 | -80 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | No
Property 3 | [NAME] |  | [NAME] | 0.025 |  | 2023-08-03 00:00:00 | 1650000 |  | False | False |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  |  |  |  |  |  | False | False
Spreadsheet: 848790d1699430267-peform-lookup-and-add-multiple-rows-test_file-1-
Sheet: expected_output

col1 | [NAME] | product_name | color | sales |  |  | [NAME] | product_name | color | sales
<1random> | <1random> | a | white | 20 |  | <1random> | <1random> | a | white | 20
<1random> | <1random> | a | yellow | 30 |  | <1random> | <1random> | a | yellow | 30
<1random> | <1random> | a | grey | 50 |  | <1random> | <1random> | a | grey | 50
<2random> | <2random> | b | [NAME] | 70 |  | <2random> | <2random> | b | [NAME] | 70
<2random> | <2random> | b | black | 75 |  | <2random> | <2random> | b | black | 75
<3random> | <3random> | c | blue | 80 |  | <3random> | <3random> | c | blue | 80
<4random> | <4random> | d |  |  |  | <4random> | <4random> | d
<5random> | <5random> | e |  |  |  | <5random> | <5random> | e
Spreadsheet: ef0c6df5-8d51-436d-b5f4-35c3c6a41b90
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
AMPHM | Test | AMPHM | Amphetamine-Type Stimulants, Confirmation, Meconium | Amphetamines, Confirmation, M | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Stool Container: Stool |  |  | 1 | g | Chain of custody is recommended for this test. Chain-of-Custody Meconium Kit (Supply T653) is available upon request.      Container/Tube: Stool container (Supply T288) [NAME]: 1 g (approximately 1 teaspoon) Collection Instructions: Collect entire random meconium specimen. Additional Information: 1. For chain-of-custody information, see Chain-of-Custody Meconium Kit (Supply T653). 2. Specimen that arrives with a broken seal does not meet the chain-of-custody requirements. 3. The laboratory recommends sending chain-of-custody specimens by overnight shipment. | 0.3 g (approximately 1/4 teaspoo | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Grossly bloody reject; Pink OK | Negative Positives are reported with a quantitative LC-MS/MS result. [NAME] concentrations: Amphetamine by LC-MS/MS: >50 ng/g Methamphetamine by LC-MS/MS: >50 ng/g 3,4-Methylenedioxyamphetamine by LC-MS/MS: >50 ng/g 3,4-Methylenedioxyethylamphetamine by LC-MS/MS: >50 ng/g 3,4-Methylenedioxymethamphetamine by LC-MS/MS: >50 ng/g | Monday through Friday, Sunday; Varies | 2 days |  | 2 | 82145 |  |  |  |  | Rochester
AMPHM | [NAME] | [NAME] | Meconium |  |  |  | Frozen | 14 days
AMPHM | Result | 31854 | Amphetamine | Amphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 43934-9 | Amphetamines:MCnt:Pt:Meconium:Qn:Confirm
AMPHM | Result | 31855 | Methamphetamine | Methamphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 27289-8 | Methamphetamine:MCnt:Pt:Meconium:Qn:
AMPHM | Result | 31856 | 3,4-methylenedioxyamphetamine | 3,4-methylenedioxyamphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 27244-3 | Methylenedioxyamphetamine:MCnt:Pt:Meconium:Qn:
AMPHM | Result | 31858 | 3,4-methylene-dioxyethylamphetamine | 3,4-methylene-dioxyethylamphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 27080-1 | [NAME]:MCnt:Pt:Meconium:Qn:
AMPHM | Result | 31857 | 3,4-methylene-dioxy-methamphetamine | 3,4-methylene-dioxy-methamphetamine | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 69025-5 | Methylenedioxymethamphetamine:MCnt:Pt:Meconium:Qn:Confirm
AMPHM | Result | 31882 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69050-3
AMPHM | Result | 31883 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: andy_zipper__180__DYNEGY-ICE VOL Apr30
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-28-01 thru Apr-30-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-30-01 | 35165802658 |  | Bought | NG [NAME], ID, GDD | [NAME] (NY) | Next Day Gas | May-01-01 | May-01-01 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 5000 | Daily | 5000 | MMBtus | Pimenov, V
Apr-30-01 | 211237881 |  | Sold | NG Fin BS, LD1 for IF | CNG-SP | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | El Paso Merchant Energy L.P. | 0.485 | USD / MMBtu | 10000 | Daily | 1510000 | MMBtus | Mckay, B
Apr-30-01 | 207613338 |  | Bought | NG [NAME], ID, GDD | [NAME] (non-NY) | Next Day Gas | May-01-01 | May-01-01 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 5000 | Daily | 5000 | MMBtus | Pimenov, V
Apr-30-01 | 189944776 |  | Bought | NG [NAME], ID, GDD | [NAME] (NY) | Next Day Gas | May-01-01 | May-01-01 |  |  |  | Aquila Energy Marketing Corp | 0 | USD / MMBtu | 10000 | Daily | 10000 | MMBtus | Pimenov, V
Apr-30-01 | 183007827 |  | Bought | Crude | WTI 1st line swap | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | Chase Manhattan Bank | 25.66 | USD / bbl | 10000 | Monthly | 120000 | bbl | White , B
Apr-30-01  Deals
Spreadsheet: c65abf78-4d20-4f66-9cca-9c34d91b96dd
Sheet: Opportunities to Learn

A high quality assessment should…[NAME] to Learn
(The areas below should also be discussed relative to the needs of ELLs, gifted and talented students, and students with disabilities)
4a. Does this assessment engage a student in thinking that connects to a real world, new context, situation, problem or challenge? Provide an explanation of your response below: |  | High |  | Moderate |  | Low or None
4b. To what extent do you think the knowledge and skills tested by the assessment can provide good information about what students have learned in the classroom?  Provide an explanation of your response below: |  | High |  | Moderate |  | Low or None
4c. To what degree do the results from this assessment (scores and student work analysis) foster meaningful dialogue about learning expectations and outcomes with students and parents? Provide an explanation of your response below |  | High |  | Moderate |  | Low or None
4d. To what extent do you believe the assessment can clearly communicate expectations for academic excellence (e.g., creativity, transference to other content areas or 21st Century skills) to students? Provide an explanation of your response below: |  | High |  | Moderate |  | Low or None
4e. Based on the content evaluated by the task or the set of items reviewed, to what extent do you think teachers can use the results (scores and student work analysis) to understand what competency on standard/s look like? Provide an explanation of your response below: |  | High |  | Moderate |  | Low or None
4f. Based on the content evaluated by the task or the set of items reviewed, to what extent do you think teachers can identify what purpose the assessment serves (e.g. diagnostic, report card grades, adjusting instruction, etc.)? Provide an explanation of your response below: |  | High |  | Moderate |  | Low or None
Overall Strengths and Suggestions Regarding Opportunities to Learn
Spreadsheet: 183386d1348813720-re-transfering-data-from-one-page-to-another-in-a-particular-format-easily-drawing-budget-quote-2012-example
Sheet: Quote PSC (WA) 1

 |  | Client Quote
Customer: |  |  |  |  |  | Date:
Address |  |  |  |  |  | Quote No: |  |  | -1
 |  |  |  |  |  | Compiled By:
Site Location |  |  |  |  |  | For Attention Of:
Project name:
Job Description:
QTY | Design & Supply of Playground System Includes:
Option 1
 | Sotfall and retention includes:
 | Installation and construction includes:
 |  |  |  |  |  | TOTAL (EXCL GST)
 |  |  |  |  |  | GST
 |  |  |  |  |  | TOTAL (INCL GST)
EXCLUSIONS:
Conditions
 | Signed
1.     This proposal is open to acceptance for a period of 30 days from the date shown on the
2.     It is the Client’s responsibility to indicate to our staff the location of any underground services
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
 | Customer: |  |  |  |  | Location
 | SIGNED: |  |  |  |  | Print Name:
Spreadsheet: 693810d1599161441-3-week-rolling-average-score-based-on-person-3-week-avg-question
Sheet: Sheet1

Approval Week | Person | Score
2020-08-24 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 95
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 85
2020-08-10 00:00:00 | [NAME] | 95
2020-08-03 00:00:00 | [NAME] | 100
2020-08-03 00:00:00 | [NAME] | 0
2020-08-03 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 70
2020-07-27 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 65
2020-08-17 00:00:00 | [NAME] | 100
2020-08-17 00:00:00 | [NAME] | 85
2020-08-17 00:00:00 | [NAME] | 0
2020-08-17 00:00:00 | [NAME] | 0
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 85
2020-07-27 00:00:00 | [NAME] | 95
2020-07-27 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 85
2020-08-24 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 85
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 65
2020-08-03 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 85
2020-07-27 00:00:00 | [NAME] | 100
2020-08-24 00:00:00 | [NAME] | 85
2020-08-24 00:00:00 | [NAME] | 100
2020-08-17 00:00:00 | [NAME] | 0
2020-08-10 00:00:00 | [NAME] | 100
2020-08-10 00:00:00 | [NAME] | 100
2020-08-03 00:00:00 | [NAME] | 100
2020-08-03 00:00:00 | [NAME] | 70
2020-07-27 00:00:00 | [NAME] | 100
2020-07-27 00:00:00 | [NAME] | 100
Spreadsheet: 59889d1260408943-generate-a-master-worksheet-from-individual-worksheets-rc1272
Sheet: adjustments

 | L:/Reimmeth/RCF6-30-09/Cost Reports |  |  | File Name: | RC1272
 |  |  |  | Tab: | adjustments
 |  |  |  | Pprd By: | PR
 | SUMMARY OF RCF DESK AUDIT ADJUSTMENTS
 | PROVIDER: | South Island
 | RC# | RC1272
 | REPORTING PERIOD: |  | 7/1/2008 - 6/30/2009
 | COST CENTER |  | DEBIT |  | CREDIT
 | ADMINISTRATION |  | 0
 | RESIDENT CARE & ACTIVITY |  |  |  | 0
 | DIETARY
 | LAUNDRY, HSKPG & MAINT
 | UTILITIES
 | TAXES, INSUR, & LICEN
 | COST OF CAPITAL |  | 0
 | OTHER |  |  |  | 0
 | SUB-TOTAL EXPENSES |  | 0 |  | 0
 | INCOME |  | 0 |  | 151679
 | EQUITY |  | 151679 |  | 0
 | GRAND TOTAL |  | 151679 |  | 151679
 | RCF DESK AUDIT ADJUSTMENTS
 | PROVIDER: | South Island
 | MMIS NUMBER: | RC1272
 | REPORTING PERIOD: |  | 7/1/2008 - 6/30/2009
 | ACCOUNT [NAME] |  | DEBIT |  | CREDIT
1 | Equity |  | 151679
 | Income |  |  |  | 151679
 | Increase provider's OSS/SSI income to agree with [NAME] report
2 | Income |  | 0
 | Equity |  |  |  | 0
 | Reduce provider's OSS/SSI income to agree to [NAME] report
3 | Cost of Capital |  | 0
 | Other |  |  |  | 0
 | Post building depreciation @ 40 yrs based on page 3, item 13
 | OR post building rent if either is omitted by provider
4 | Administration |  | 0
 | Resident Care and Activity |  |  |  | 0
 | To reclassify cell phone expense
5 |  |  | 0
 |  |  |  |  | 0
 | GRAND TOTAL |  | 151679 |  | 151679
Spreadsheet: 80731d1280939031-formula-that-automatically-uses-the-last-cell-in-a-row-golfpressespayment
Sheet: Sheet1

Downs
Score | Hole 1 | Hole 2 | Hole 3 | Hole 4 | Hole 5 | Hole 6 | Hole 7 | Hole 8 | Hole 9
Player1 | 4 | 4 | 5 | 3 | 4 | 4 | 5 | 4 | 3
Player2 | 3 | 4 | 3 | 4 | 3 | 4 | 3 | 4 | 3
2-Down$
Player 1
1-Down$
Player 1
Do 2 more examples below her.
Spreadsheet: 3a2e6f34-445d-4223-bd87-ae4a33c8e0f2
Sheet: Page 3

Permit No.: |  |  | WQ0019632 |  |  | Facility Name: |  | Johnston County Reclaimed Water Facility |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | PH1 - 08 |  | Field Name: |  | PH1 - 09 |  | Field Name: |  | PH1 - 10 |  | Field Name: |  | PH2 - 01
 |  |  |  |  |  | Area (acres): |  | 29.69 |  | Area (acres): |  | 2.96 |  | Area (acres): |  | 6.13 |  | Area (acres): |  | 11.87
 |  |  |  |  |  | Cover Crop: |  | Trees/Grass |  | Cover Crop: |  | Grass/Trees |  | Cover Crop: |  | Grass/Trees |  | Cover Crop: |  | Bermudagrass
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.75
 |  |  |  |  |  | Annual Rate (in): |  | 14 |  | Annual Rate (in): |  | 15 |  | Annual Rate (in): |  | 15 |  | Annual Rate (in): |  | 38.61
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset            (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 137615d1327258393-how-to-use-a-sumif-type-formula-with-words-instead-of-numbers-per-diem-airport-travel
Sheet: Sheet1

Date | Airport | City, State | Per Diem |  |  | Airport | City, State | Per Diem
 | PSP | Palm Springs, CA | 22 |  |  | SEA | Seattle, WA | 45
 | SFA | San Francisco, CA | 33 |  |  | PSP | Palm Springs, CA | 22
 | OAK | Oakland, CA | 33 |  |  | SFA | San Francisco, CA | 33
 |  |  |  |  |  | OAK | Oakland, CA | 41
Spreadsheet: sara_shackleton__36629__non terminated deals
Sheet: Sheet1

Counterparty | RMT or ENA | Date of Master Agreement | Cash Collateral -  Held/(Posted) | Accounts Receivable | Accounts Payable | Net AR and AP | Infinity MTM Valuation as 3/18/2002 | RATE AND CURRENCY | GLOBAL LIQUIDS | ENA | EW - WTI PREPAY | WEATHER | EMMISSION SO2 | TOTAL ENRON TRADING COUNTERPARTY EXPOSURE
[NAME] Treasure LLC | ENA | 1999-12-17 00:00:00 |  | 919009.92 | 0 |  | 2176513.29 | 2176513.29
Brazos VPP Limited Partnership | ENA | 2000-12-27 00:00:00 |  | 598637.49 | 0 |  | 1310114.56 | 1310114.56
Dakota LLC | ENA | 1998-12-15 00:00:00 |  | 33099.14 | 0 |  | 108793.65 | 108793.65
Destec Properties Limited Partnership |  | ?? |  | 0 | -777782.67 |  | -23611825.18 | -23611825.18
EMP Echo LLC | ENA | Deemed ISDA |  | 48151.38 | 0 |  | 292919.18 | 292919.18
Joint Energy Development Investments II Limited Partnership | ENA | 1998-03-15 00:00:00 |  | 2962384.44 | -174416.66 |  | 8104550.04 | 8104550.04
Spreadsheet: 66220d1266926898-sumproduct-across-tables-100222
Sheet: Sheet1

 | Raw data extract (there can be multiple of same items in column B with varying city allocations) |  |  |  |  | Sorting | --> user maps two variables
 |  |  |  |  |  |  |  |  |  |  |  | CITY1
 | KJFJ4 | 3432 | CITY1 |  |  | KJFJ4 | ABC |  | CITY1 | LONDON
 | [NAME] | 564 | CITY2 |  |  | 8IJDSK | ABC |  | CITY2 | PARIS
 | KJFJ4 | 5334 | CITY1 |  |  | 9KJKJ | ABC |  | [NAME] | NEW YORK |  | 9KJKJ
 | 30FFF | 7837 | CITY1 |  |  | [NAME] | DEF |  | CITY4 | BERLIN
 | 9KJKJ | 8373 | CITY4 |  |  | [NAME] | DEF |  | CITY5 | SINGAPORE
 | [NAME] | 392 | CITY2 |  |  | 333KKF | DEF |  | Sort1 | Sort2
 | 333KKF | 828 | [NAME] |  |  | 30FFF | GHI
 | 302KFK | 202 | CITY5 |  |  | 302KFK | GHI
 | Raw1 | Raw2 | Raw3
 | Output - Old
 |  |  | DEF | --> user can choose this, which will alter numbers below accordingly
 | LONDON |  | 0 | --> where formula is required to lookup sorting allocation and pick-out values from raw data accordingly
 | PARIS |  | 956
 | NEW YORK |  | 828
 | BERLIN |  | 0
 | SINGAPORE |  | 0
 | Output - New proposed
 |  |  | PARIS | --> user can choose this, which will alter numbers below accordingly
 | ABC |  | 0 | --> where formula is required to lookup sorting allocation and pick-out values from raw data accordingly
 | DEF |  | 956
 | GHI |  | 0
Spreadsheet: 233428d1367798126-same-numbers-come-out-after-doing-what-if-analysis-220
Sheet: 工作表1

Cost per thousand impression (CPM) | 5
Click-through rate (CTR) | 0.01 | percentage of visitors who click the ad after the ad is displayed
Click-to -buy rate (CTB) | 0.035 | percentage of web site visitors who make a purchase
Average order value ([NAME]) | 50 | average order value in $ excluding shipping charges and taxes
Cost per click
Revenue per click
Profit margin | 0.2
Profit per click
ROI
ROI~fn (CPM, CTR) |  | 1 | 2 | 3 | 5 | 7.5 | 10
 | 0.001 |  | 0.7500000000000003 | 0.166666666666667 | -0.2999999999999998 | -0.5333333333333332 | -0.6499999999999999
 | 0.0025 | 2.500000000000001 | 0.7500000000000003 | 0.166666666666667 | -0.2999999999999998 | -0.5333333333333332 | -0.6499999999999999
 | 0.005 | 2.500000000000001 | 0.7500000000000003 | 0.166666666666667 | -0.2999999999999998 | -0.5333333333333332 | -0.6499999999999999
 | 0.0125 | 2.500000000000001 | 0.7500000000000003 | 0.166666666666667 | -0.2999999999999998 | -0.5333333333333332 | -0.6499999999999999
 | 0.015 | 2.500000000000001 | 0.7500000000000003 | 0.166666666666667 | -0.2999999999999998 | -0.5333333333333332 | -0.6499999999999999
 | 0.02 | 2.500000000000001 | 0.7500000000000003 | 0.166666666666667 | -0.2999999999999998 | -0.5333333333333332 | -0.6499999999999999
Spreadsheet: 840861d1693070900-customers-list-with-variable-rows-for-each-customer-customers_sample-alarai-
Sheet: Hárok1

 | CustomerID | Customer Name | Date | Services | Service cost | Total cost | Status | Notes
 | A1 | [NAME] | 2023-05-06 00:00:00 | Service #1 | 20 |  | Completed & payment received
 | A1 | [NAME] |  | Service #2 | 30 |  | Completed & payment received
 | A1 | [NAME] |  | Service #3 | 11.59 |  | Completed & payment received
 | B23 | [NAME] | 2023-08-08 00:00:00 | Service #4 | 20 |  | Completed & awaiting Payment
 | B23 | [NAME] |  | Service #5 | 30 |  | Completed & awaiting Payment
 | B23 | [NAME] |  | Service #6 | 40 |  | Completed & awaiting Payment
 | B23 | [NAME] |  | Service #7 | 11.59 |  | Completed & awaiting Payment
 | B23 | [NAME] | 2023-08-08 00:00:00 | Service #13 | 10 |  | Completed & awaiting Payment
 | C1 | Name C1 | 2023-08-26 00:00:00 | Service #14 | 40 |  | Completed & awaiting Payment
 | C13 | Random name | 2023-08-29 00:00:00 | Service #8 | 20 |  | Not Completed
 | C13 | Random name |  | Service #9 | 30 |  | Not Completed
 | C13 | Random name |  | Service #10 | 40 |  | Not Completed
 | C13 | Random name |  | Service #11 | 11.59 |  | Not Completed
 | C13 | Random name |  | Service #12 | 20 |  | Not Completed
Spreadsheet: 113516d1309388586-dependant-sum-range-book1
Sheet: Sheet1

Account# | Building | Utility | Area | Metered | Percentage
12345678 | 1 | Water | 100
12345678 | 2 | Water | 200 | Y
12345678 | 3 | Water | 500
12345678 | 4 | Water | 2000
12345678 | 1 | Sewer | 100
12345678 | 2 | Sewer | 200
12345678 | 3 | Sewer | 500
12345678 | 4 | Sewer | 2000 | Y
99999999 | 1 | Water | 3000
99999999 | 2 | Water | 200
99999999 | 3 | Water | 350
99999999 | 4 | Water | 100
 |  |  |  |  | I'm trying to find the Percentage of each building, based on the area. If there is  "Y" in the metered column, then the percentage will always be 100%. However, those buildings that are metered should not be included in the percentage sum_range.
 |  |  |  |  | *The percentage sum_range ($[NAME]) in the above SUMIF formula would be based on the following conditions: 1) the account is the same. 2) the utility is the same.