tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163941d1340559951-if-formula-greater-than-less-than-required-please-help-shizant-example
Sheet: Sheet1

1.15 | 0.64 |  |  | IF
0.6 | 0.62
2.5 | 1.61
1.2 | 0.9
0.4 | 0.32
0.75 | 0.93
1.15 | 0.64 |  |  | MAX
0.6 | 0.62
2.5 | 1.61
1.2 | 0.9
0.4 | 0.32
0.75 | 0.93
Spreadsheet: 726651d1617352966-adding-conditions-to-dropdown-list-dropdown-list-ans
Sheet: 工作表1

Name | Date | Type | Ref No. |  |  |  |  | Name |  | Month |  | REF
[NAME] | 2021-03-01 00:00:00 | A | 8340643 |  | Name | [NAME] |  | [NAME] |  | 2021-01-01 00:00:00
[NAME] | 2021-02-01 00:00:00 | B | 7355055 |  | Month | 2021-03-01 00:00:00 |  | [NAME] |  | 2021-02-01 00:00:00
[NAME] | 2021-05-16 00:00:00 | C | 1947563 |  | Ref | 1369455 |  | [NAME] |  | 2021-03-01 00:00:00
Derek | 2021-07-12 00:00:00 | A | 1375037 |  |  |  |  | Derek |  | 2021-04-01 00:00:00
[NAME] | 2021-06-19 00:00:00 | B | 5852746 |  |  |  |  | [NAME] |  | 2021-05-01 00:00:00
[NAME] | 2021-03-05 00:00:00 | C | 1369455 |  |  |  |  | [NAME] |  | 2021-06-01 00:00:00
[NAME] | 2021-08-09 00:00:00 | C | 4792640 |  |  |  |  |  |  | 2021-07-01 00:00:00
[NAME] | 2021-05-07 00:00:00 | B | 3519495 |  |  |  |  |  |  | 2021-08-01 00:00:00
[NAME] | 2021-03-03 00:00:00 | B | 7351385 |  |  |  |  |  |  | 2021-09-01 00:00:00
[NAME] | 2021-09-09 00:00:00 | A | 4847491 |  |  |  |  |  |  | 2021-10-01 00:00:00
[NAME] | 2021-05-16 00:00:00 | B | 4829576 |  |  |  |  |  |  | 2021-11-01 00:00:00
[NAME] | 2021-07-12 00:00:00 | C | 1584458 |  |  |  |  |  |  | 2021-12-01 00:00:00
[NAME] | 2021-06-19 00:00:00 | A | 7318348
[NAME] | 2021-03-05 00:00:00 | C | 4803486
[NAME] | 2021-08-09 00:00:00 | B | 5750673
Derek | 2021-05-07 00:00:00 | B | 6351945
[NAME] | 2021-03-03 00:00:00 | A | 7450662
[NAME] | 2021-09-09 00:00:00 | C | 1334957
[NAME] | 2021-03-03 00:00:00 | C | 3721345
[NAME] | 2021-09-09 00:00:00 | B | 2710484
[NAME] | 2021-05-16 00:00:00 | B | 8504314
Derek | 2021-07-12 00:00:00 | A | 9568745
[NAME] | 2021-06-19 00:00:00 | B | 8320583
[NAME] | 2021-03-05 00:00:00 | C | 1371310
Spreadsheet: 742702d1627981892-if-formula-not-returning-correct-results-if-formula
Sheet: Sheet1

 | worker 1 |  | 50
 | worker 2 |  |  |  | 100
Spreadsheet: 55d15b8e-3b02-422b-907d-012b17e39b6a
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
CEAPT | Test | CEAPT | Carcinoembryonic Antigen (CEA), [NAME] | CEA, Peritoneal Fluid | Immunoenzymatic Assay | Plastic screw-cap vial: PlScr |  |  | 2 | mL | Container/Tube:  Plain, plastic, screw top tube [NAME]: 2 mL | 0.5 mL (Samples <0.5 mL may be r | Hemolysis	Mild OK, Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; Varies | Same day/1 day | 3 days | 1 | 82378 |  |  |  |  | Rochester
CEAPT | [NAME] | PERITONE | Peritoneal |  |  |  | Frozen | 90 days
CEAPT | Result | CEAPN | CEA, Peritoneal Fluid | CEA, Peritoneal Fluid | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
CEAPT | Result | SITED | Site | Site | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39111-0 | Body site:[NAME]:Pt:^Patient:Nom:
Spreadsheet: andy_zipper__163__DYNEGY-ICE VOL Apr6
Sheet: E-Mail

 | 2001-04-06 00:00:00
 | Intercontinental Exchange |  |  | Enron's Activity on ICE
 | Commodity | Volume |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  | ECC
 |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  | EPM | POWER
 |  |  |  | ENA | POWER
 |  |  |  | ENA | US NATURAL GAS
 |  |  |  | ENA | COAL
 |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: 37738d1235753760-reformating-data-layout-bangemd
Sheet: Sheet2

Count of Fld2 | Column Labels
Row Labels | 1 | 2 | 3 | 4 | 5 | 6 | Grand Total
a |  | 1 | 1 | 1 |  | 1 | 4
b | 1 |  | 1 | 1 |  |  | 3
c | 1 | 1 | 1 |  | 1 |  | 4
Grand Total | 2 | 2 | 3 | 2 | 1 | 1 | 11
Spreadsheet: 0e824cb8-52f0-4d7b-9ae6-7e26c96acc88
Sheet: Sheet1

[NAME OF HOSPITAL] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Inpatient Statistics
[YR1] - [YR10]
ITEMS | HISTORICAL |  |  |  |  | INTERIM |  | FORECAST
 |  |  |  |  |  |  |  | DURING CONSTRUCTION |  |  | COMPLETION
 | [YR1] | [YR2] | [YR3] | [YR4] | [YR5] | As of [MM] | Annualized | [YR6] | [YR7] | [YR8] | [YR9] | [YR10]
Total [NAME] (same as Hospital License)
Medical/Surgical
ICU/CCU
OB/GYN
Behaviorial Health, Psych, Rehab
[NAME] care
Other (specify)
Other (specify)
Total, Adult & Pediatric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Newborn
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Beds In Service
Medical/Surgical
ICU/CCU
OB/GYN
Behaviorial Health, Psych, Rehab
[NAME] care
Other (specify)
Other (specify)
Total, Adult & Pediatric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Newborn
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Occupancy Rate
Medical/Surgical
ICU/CCU
OB/GYN
Behaviorial Health, Psych, Rehab
[NAME] care
Other (specify)
Other (specify)
Total, Adult & Pediatric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Newborn
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
(1) Data is requested for the prior five years (Historical), the current year (Interim), the year(s) of construction, and two full years after completion of construction (Forecasted).
(2) If the above data is available elsewhere in substantially the same form, you may submit such schedule therefore.
(3) Replace [YRX] with Actual Year (ex. 2005)
FAST - 1(A)
Spreadsheet: 49062d1248344374-sum-fields-on-multiple-tabs-cc-submission-re-cap-sheet
Sheet: US Income

 | RENT COLLECTED |  |  |  |  | CURRENCY | ROE
 | GL: 2014 ???? This is relocation costs inside Canada |  |  |  |  | USD | 1.12
 | GL | SN | RANK | LAST NAME | [NAME] | US | CDN
 | 5201 | A12 345 678 | PTE | BLOGGINS | RENT | 500 | 560
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  | TOTAL VOUCHERS: | 500 | 560
 |  | DO NOT MANUALLY ENTER INFORMATION HERE, IT WILL POPULATE FROM INFORMATION ABOVE
 |  |  | GL | FUND | COST CENTRE | INTERNAL ORDER | TOTAL
 |  |  | 5201 | L101 | 1234AA | 123456 | 560
Spreadsheet: 72652d1273341216-search-multiple-worksheets-acme-schedules
Sheet: RESIDENCE SECTION

WORK CATEGORY CODES: |  |  |  |  | DIVISION/ [NAME]:
W – WORK           SA – SPECIAL ASSIGNMENT    SL – SICK LEAVE
DO – DAY OFF        HW – HOLIDAY WORKED        AV – ADVANCE |  |  |  |  | STORE 1811
AL – ANNUAL LEAVE   WT – WORK/TRAVEL
 |  | PERIOD COVERED |  |  | SHIFT:
 |  |  |  |  | RESDIENCE SECTION
 | NAME | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THRUSDAY | FRIDAY | SATURDAY
1 | M. CRAFT | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | M. CRAFT | M. CRAFT | M. CRAFT | M. CRAFT | M. CRAFT | M. CRAFT | M. CRAFT
2 | [NAME] | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
3 | A. ALIAM | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | A. ALIAM | A. ALIAM | A. ALIAM | A. ALIAM | A. ALIAM | A. ALIAM | A. ALIAM
4 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL SOT:
PREPARED BY |  |  |  |  | SIGNATURE
BRAD PITT |  |  |  |  | [NAME]
Spreadsheet: errol_mclaughlin_jr__10278__BLANKBOOKREQUEST-Chase1229
Sheet: Sheet1

From: | Risk Analysis and Reporting
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  |  | Risk Management
Subject: | New Book Request (to set up book in RisktRAC)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason for Book | Administrator* | MTM | Prud | Realized
 | Chase X | Chase - Stoneville - Mahonia PrePay |  |  | x | 5 | TranscoZ3 | x | x | x |  |  | NatGas - MMBtu | no trader - prepay deal | MTM | New Prepay deal | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List: | emclaug
 |  | kloibl
 |  | bbajwa
 | BOOK WILL NOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | For questions, call:
 | [NAME] (x57197)
 | [NAME] (x31462)
 | [NAME] ([NAME])
 | [NAME] (x33102)
Spreadsheet: fc221cd6-c311-42f7-b7d1-d8ebcdbf8310
Sheet: non-GAAP Net Inc & Op Inc

The NASDAQ OMX Group, Inc.
Reconciliation of GAAP Net Income, Diluted Earnings Per Share, Operating Income and Operating Expenses
to Non-GAAP Net Income, Diluted Earnings Per Share, Operating Income and Operating Expenses
(in millions, except per share amounts)
(unaudited)
 |  | Three Months Ended
 |  | September 30, |  | June 30, |  | September 30,
 |  | 2011 |  | 2011 |  | 2010
GAAP net income attributable to NASDAQ OMX: |  | 110 | 43 | 92 |  | 101
Non-GAAP adjustments:
Merger and strategic initiatives |  | 3 |  | 29 |  | 1
Extinguishment of debt |  | 6 |  | 0 |  | 0
Asset retirements |  | 0 |  | 0 |  | 2
Workforce reductions |  | 0 |  | 0 |  | 2
Other |  | 0 |  | 0 |  | -1
Total non-GAAP adjustments |  |  |  | 29 |  | 4
Adjustment to the income tax provision to reflect non-GAAP adjustments(1) |  | -3 |  | -9 |  | -2
Significant tax adjustments, net |  | 5 |  | 0 |  | -2
Total non-GAAP adjustments, net of tax |  |  |  | 20 |  | 0
Non-GAAP net income attributable to NASDAQ OMX: |  |  |  | 112 |  | 101
GAAP diluted earnings per common share: |  | 0.61 |  | 0.51 |  | 0.5
Total adj. from non-GAAP net income above |  | 0.06 |  | 0.11 |  | 0
Non-GAAP diluted earnings per common share: |  | 0.67 |  | 0.62 |  | 0.5
 |  | Three Months Ended
 |  | September 30, |  | June 30, |  | September 30,
 |  | 2011 |  | 2011 |  | 2010
GAAP operating income: |  | 195 |  | 158 |  | 165
Non-GAAP adjustments:
Merger and strategic initiatives |  | 3 |  | 29 |  | 1
Extinguishment of debt |  | 6 |  | 0 |  | 0
Asset retirements |  | 0 |  | 0 |  | 2
Workforce reductions |  | 0 |  | 0 |  | 2
Other |  | 0 |  | 0 |  | -1
Total non-GAAP adjustments |  |  |  | 29 |  | 4
Non-GAAP operating income |  |  |  | 187 |  | 169
Total revenues less transaction rebates, brokerage,
clearance and exchange fees |  | 438 |  | 416 |  | 372
Non-GAAP operating margin (2)
(1) We determine the tax effect of each item based on the tax rules in the respective jurisdiction where the transaction
occurred.
(2) Non-GAAP operating margin equals non-GAAP operating income divided by total revenues less transaction rebates,
brokerage, clearance and exchange fees.
Spreadsheet: gstorey__12046__TDS Design Suggestions
Sheet: Gas Daily

Gas Daily Issue:
FP (Fxd Price) | FP Adj |  | F-O-M | [NAME]
0 | 0.01 |  | IF-HeHub | GDP-HeHub
The way it works today:
For a fixed price deal, no problem--system knows to pull the FP number.
For an indexed deal, system knows that if FP = 0, it must pull the F-O-M price (in this case IF-HeHub), which is equal to Price + Basis,
+ FP Adj (Index Adjustment)
- For Valuation:
[NAME], mid is Price + Basis + GDP-Curve
Past NX1, mid is a fixed price, which is manually put into Excel by Book Administrators, and is equal to Price + Basis (+ FP Adj maybe)
So, curves show up as follows:
2001-03-01 00:00:00 | 5.25
2001-03-02 00:00:00 | 5.25 | manually entered into Excel by Book Administrators
2001-03-03 00:00:00 | 5.25 | Deal values change based on changes in this number
thru  31-Mar-01 | 5.25
2001-04-01 00:00:00 | 0.01
2001-05-01 00:00:00 | 0.01
 | 0.01
 | 0.01 | Deal value only changes if change made to GDP Curve
 | 0.01
 | 0.01
2014 | 0.01
Issues:
Traders do not have direct access to GDP curves--they must call their Book Administrators to have these changed.
Because risk assigned is "M", system views index deals as fixed price, assigning a much higher risk to them than necessary.
Proposed:
Set up new Pub Code I.e. [NAME], with risk of "I" instead of "M"
For valuation, system must look first for GDP-HeHub "M"--if a price is there, use that--if no price, look to GDP-HeHub "I".
All forward month Gas Daily deals will have risk assigned of "I"; once a fixed price is set by the traders for prompt month, the
risk will need to switch to "M". ???????
At the same time Gas Daily deals change from risk of "I" to "M", all FOM Index risk should also switch to "M".
After these two categories have switched from an "I" risk to an "M" risk, the Total column in TDS should include them as Fixed Price risk.
Prior to this "M" designation, the index positions will NOT add into the TOTAL Fixed Price risk column.
Give Traders direct access to GDP curves--they will update them along with all other curves.
This gives traders control, plus they know that once they set a fixed price under the GDP-HeHub "M" column it turns to Fixed Price risk.
In new TDS Position screens, Gas Daily index deals would show up both in the [NAME] category and [NAME] category.
Spreadsheet: 694483d1599639486-how-to-count-repeating-purchase-from-different-year-testrpt
Sheet: Repeat 2018

No | Name
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 34950d1232403973-lock-cell-value-once-calculated-budget-spreadsheet
Sheet: SummarySheet

Account Balances: |  | Giving | Savings | Mortgage | Rent | Heat | Internet | Food | Gas | Car misc | Insurance | Clothes | Entertainment | Extra
 |  | 490 | 900 | 0 | 1000 | 240 | 180 | 530 | 575 | 900 | 183 | 300 | 565 | 582
 |  | Credit |  | Debit
Date | Place | Amount | Type | Amount | Type
2008-01-17 00:00:00 | Paycheck | 3300 | Paycheck
2009-01-18 00:00:00 | Kum & Go |  |  | 25 | Gas
2009-01-19 00:00:00 | HyVee |  |  | 40 | Food
2009-01-20 00:00:00 | WalMart |  |  | 30 | Food
2009-02-20 00:00:00 | Paycheck | 3300 | Paycheck
2009-02-25 00:00:00 | Rent |  |  | 500 | Rent
2009-03-21 00:00:00 | Paycheck | 3300 | Paycheck
2009-02-23 00:00:00 | Fix computer | 75 | Other
2009-02-25 00:00:00 | Good cause |  |  | 500 | Giving
2009-02-27 00:00:00 | Wok in Motion |  |  | 35 | Entertainment
2/30/09 | New Couch |  |  | 800 | Extra
2009-03-03 00:00:00 | Totally sick TV |  |  | 1500 | Extra
2009-03-05 00:00:00 | Something nice |  |  | 25 | Extra
Spreadsheet: 712832d1610440442-how-to-add-formula-for-dynamic-drop-down-list-to-data-validation-share-excel-sheet-with-questions
Sheet: Active data sheet

Unique drop-down for Primary Category | Dependent drop-down for Secondary Category
Bird |  |  | Issue | Dependent drop-down not working. [NAME] works in B3 when [NAME] is pressed, but not on cells below or in data validation
Animal
Plant
Plant
Fish |  |  | Essential | Needs to work in excel 2010
Bird |  |  |  | Drop down list limited to actual values (i.e. no blank options
Bird |  |  |  | If "type" is added to T_Category, then the options are automatically updated
Bird
Country
 |  |  |  | I followed the following 2 videos:
 |  |  |  | 1) https://www.youtube.com/watch?v=7fYlWeMQ6L8 - extract unique items for dynamic data validation drop down list
 |  |  |  | 2) https://www.youtube.com/watch?v=gu4xJWAIal8 - find multiple matches & dependent drop down list (unsorted tabular data set)
 |  |  |  | Thanks!!
Spreadsheet: 491029d1480271215-adding-cumulative-weekly-totals-avk-excel-forum-question1
Sheet: 11-30-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY:
Rank | Employee | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1
2
3
4
5
6
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS (Today):
 |  |  |  | TIME (Week End Total): |  |  |  |  |  |  |  | HEARINGS (Week End Total):
Spreadsheet: 830863d1685182916-vlookup-not-working-when-substituted-with-nested-if-statements-petrol-conveyance-calculation
Sheet: PETROL CONVEYANCE without Rate

 | DATE | Kilometer | Amount | Rate | My rate | PRICE CHART
 | 2022-07-01 00:00:00 | 1100 |  |  |  | Kilometer | Price
 | 2022-07-04 00:00:00 | 485 |  |  |  | 0-120 | 2.75
 | 2022-07-05 00:00:00 | 48 |  |  |  | 120-240 | 1.95
 | 2022-07-06 00:00:00 | 85 |  |  |  | 240-350 | 1.75
 | 2022-07-07 00:00:00 | 449 |  |  |  | 350-1000 | 1.5
 | 2022-07-08 00:00:00 | 249 |  |  |  | >1000 | 1.4
 | 2022-07-11 00:00:00 | 425
 | 2022-07-12 00:00:00 | 297
 | 2022-07-13 00:00:00 | 229
 | 2022-07-14 00:00:00 | 50
 | 2022-07-15 00:00:00 | 651
 | 2022-07-18 00:00:00 | 349
 | 2022-07-19 00:00:00 | 320
 | 2022-07-20 00:00:00 | 280
 | 2022-07-21 00:00:00 | 919
 | 2022-07-22 00:00:00 | 903
 | 2022-07-25 00:00:00 | 132
 | 2022-07-26 00:00:00 | 108
 | 2022-07-27 00:00:00 | 46
 | 2022-07-28 00:00:00 | 1010
 | 2022-07-29 00:00:00 | 577
Spreadsheet: 792697d1661087540-remove-plurals-from-a-list-of-keywords-excelforum-solution-request-2
Sheet: Title War (2)

Keywords (14) | Search Volume |  | Normalized Keywords (9) | Search Volume
gardening | 72139 |  | garden tool
garden tools | 61899 |  | gardening | 72139
gardening tool box | 58372 |  | gardening tool box
gardening tool set | 54854 |  | gardening tool set | 54854
gardening tools | 39262 |  | gardening tool
garden tool | 13016 |  | gardening gift |  |  |  |  | GUIDE
gardening tool | 10561 |  | garden tools for gardening | 10442 |  |  |  | Removed Keywords' (i.e. [NAME]) - Search Volume will be added to the Normalized (i.e. singular) keywords
garden tools for gardening | 10442 |  | gardening supply
gardening tool boxes | 9956 |  | garden hand tools | 3030 |  |  |  | For instance:
gardening gifts | 8741 |  |  |  |  |  |  |  | gardening tools | 61899
gardening gift | 3850 |  |  |  |  |  |  |  | gardening tool | 13016
gardening supplies | 3143 |  |  |  |  |  |  | Answer: | gardening tool | 74915
garden hand tools | 3030
gardening supply | 2679
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0125

 | Date: | 2013-01-25 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 12 | 58.08
 | 11:00:00 | 47 | 309.88
 | 12:00:00 | 101 | 608.75
 | 13:00:00 | 60 | 344.23
 | 14:00:00 | 39 | 226.5
 | 15:00:00 | 34 | 129.39
 | 16:00:00 | 38 | 258.93
 | 17:00:00 | 52 | 419.91
 | 18:00:00 | 56 | 476.71
 | 19:00:00 | 55 | 331.54
 | 20:00:00 | 26 | 188.8
 | 21:00:00 | 32 | 192.4
 | 22:00:00 | 38 | 198.95
 | 23:00:00 | 16 | 120.94
 | 1900-01-01 00:00:00 | 13 | 110.19
 | 1900-01-01 01:00:00 | 19 | 183.49
 | 1900-01-01 02:00:00 | 15 | 127.93
 | 1900-01-01 03:00:00 | 6 | 38.94
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 851699d1701870027-fetching-data-from-another-sheet-sample-1-
Sheet: Sheet1

Name | Value
Thing 1 | 1000
Thing 2 | 1250
Thing 3 | 1500
Thing 4 | 1750
Thing 5 | 2000
Thing 6 | 2250
Thing 7 | 2500
Thing 8 | 2750
Thing 9 | 3000
Thing 10 | 3250
Thing 11 | 3500
Thing 12 | 3750
Thing 13 | 4000
Thing 14 | 4250
Thing 15 | 4500
Thing 16 | 4750
Thing 17 | 5000
Thing 18 | 5250
Thing 19 | 5500
Thing 20 | 5750
Thing 21 | 6000
Thing 22 | 6250
Thing 23 | 6500
Thing 24 | 6750
Thing 25 | 7000
Thing 26 | 7250
Thing 27 | 7500
Thing 28 | 7750
Thing 29 | 8000
Thing 30 | 8250
Thing 31 | 8500
Thing 32 | 8750
Thing 33 | 9000
Thing 34 | 9250
Thing 35 | 9500
Thing 36 | 9750
Thing 37 | 10000
Thing 38 | 10250
Thing 39 | 10500
Thing 40 | 10750
Spreadsheet: 768649d1645062867-find-and-extract-the-website-link-from-range-of-cells-question-find-the-website-link
Sheet: Sheet1

Link1 | Link2 | Link3 | Link4 | Website (desired output)
https://twitter.com/1RoyaltyFinance
https://discord.com/invite/YK9C2g9V | https://t.me/gemstonefin | https://twitter.com/GemstoneFIn
https://discord.com/invite/ZkwmrsmBjS | https://twitter.com/CprosOffical
https://discord.gg/EPUJ5g7s6E | https://twitter.com/7ombfinance
https://discord.gg/gNck2abDVb | https://t.me/CometFinanceANN | https://twitter.com/CometFinance88
https://discord.com/invite/JrNGTp8sgE | https://twitter.com/ygg_finance
https://discord.gg/B9QTTcsE7F | https://t.me/printerfinancial | https://twitter.com/FinancePrinter | https://bsc.printer.financial/ | https://bsc.printer.financial/
https://twitter.com/ViosFinance
https://discord.gg/zDv4gyfxjH | https://t.me/BourbonDao | https://twitter.com/financebourbon | http://bourbondefi.com/ | http://bourbondefi.com/
https://discord.com/invite/zW66nhnBam | https://twitter.com/Forkfinance_ | https://www.forkfinance.com/ |  | https://www.forkfinance.com/
https://discord.com/invite/qrrQ4rKwtT | https://t.me/PartialFinance | https://twitter.com/PartialFinance | https://partial.finance/ | https://partial.finance/
https://discord.gg/5cA9MVQtjZ | https://.twitter.com/FinanceDevilx | https://devilx.finance/ |  | https://devilx.finance/
https://discord.gg/dWfd7rvbhV | https://twitter.com/BrrFinance | https://brrfinance.com/ |  | https://brrfinance.com/
https://twitter.com/dantefinance |  |  |  | ETC
https://discord.gg/TX8et2xSUQ | https://twitter.com/hyehfinance | https://hyeh.finance/
https://discord.com/invite/tQ2yBUJQ | https://t.me/+nMMoPYnE3_kxZjQ0 | https://twitter.com/BulFinance | https://bul.finance/
https://discord.com/invite/degenfinance | https://twitter.com/Degenfinancee | https://tombdegen.com/
https://discord.com/invite/akR7kpYMds | https://t.me/+KDlYhwRj5B9iYjI8 | https://twitter.com/ScarfaceFinance | https://scarface.finance/
https://discord.gg/x446WTzphe | https://t.me/polarisfinance | https://twitter.com/PolarisFinance_ | https://polarisfinance.io/
https://discord.gg/R27R2eb2jC | https://twitter.com/4PureOcean | https://www.pure-ocean.net/
https://discord.gg/veWvZt7qJV | https://twitter.com/zilla_finance | https://zillafinance.io/
https://t.me/peeldefi | https://twitter.com/PeelDefi | https://www.peeldefi.com/
https://discord.gg/QfVV5Ywprk | https://t.me/snowtombofficial | https://twitter.com/snow_tomb | https://www.frozentomb.finance/
https://discord.gg/gRz82229xw | https://twitter.com/finance_bat | https://batfi.xyz/
https://twitter.com/ZombiedotMoney | https://zombie.money/
https://t.me/+bczMZtCTlmEzMWZh | https://twitter.com/1ombfinance | https://1omb.finance/
https://discord.gg/QmFF3vsCQd | https://t.me/FarmThatChicken | https://twitter.com/farmthatchicken | https://mychicken.farm/