tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 328092d1403785818-subtotal-in-an-array-forumla-counting-unique-and-repeat-values-disregarding-blanks-hire-analysis
Sheet: DATA

Venue Hire Analysis 2014/15
Incomplete
Arr # | Event Start Date | Event End Date | Event Type | Customer | Hours Used | Total Attendees | Room A | Room B | Room C | Other | ROOM HIRE INCOME | Company A (I) | Other Supplier (I) | Tea & Coffee (I) | Bar Takings | CATERING INCOME | Technical Assistance | Externally Hired Equipment | Internally Hired Equipment | TECH / EQUIPMENT INCOME | TOTAL INCOME | Company A (E) | Other Supplier (E) | Tea & Coffee (E) | Bar Stock Cost | CATERING EXPENDITURE | Flowers | Externally Hired Equipment (E) | RESOURCE EXPENDITURE | Stage Crew | Technical | Stewards | Bar Staff | STAFFING EXPENDITURE | TOTAL EXPENDITURE | GROSS PROFIT / LOSS | Gross Profit Margin | Catering Profit Margin | Total Gross Average | Total Catering Average
1 | 2014-04-04 00:00:00 | 2014-06-20 00:00:00 | Sessional | A |  |  |  |  |  | 162
2 | 2014-04-07 00:00:00 | 2014-04-07 00:00:00 | Sessional | K |  |  |  |  |  | 20
3 | 2014-04-09 00:00:00 | 2014-04-09 00:00:00 | Sessional | L |  |  |  |  |  | 20.83
4 | 2014-05-05 00:00:00 | 2014-05-08 00:00:00 | Sessional | M |  |  |  | 76.67
5 | 2014-05-13 00:00:00 | 2014-05-13 00:00:00 | Conferences | N |  |  | 106.67
6 | 2014-05-24 00:00:00 | 2014-05-24 00:00:00 | Weddings | I |  |  |  | 250
7 | 2014-05-24 00:00:00 | 2014-05-24 00:00:00 | Weddings | I |  |  | 354.17 |  |  |  |  | 703.13 |  |  | 633.33 |  |  |  | 258.33 |  |  | 624.75 |  |  | 219.82 |  |  |  |  |  |  | 39 | 76.375
8 | 2014-05-27 00:00:00 | 2014-05-30 00:00:00 | Sessional | J |  |  |  |  |  | 333.33
9 | 2014-06-04 00:00:00 | 2014-06-04 00:00:00 | Sessional | C |  |  |  |  |  | 40
10 | 2014-06-08 00:00:00 | 2014-06-08 00:00:00 | Sessional | A |  |  |  |  |  | 24
11 | 2014-06-11 00:00:00 | 2014-06-11 00:00:00 | Sessional | D |  |  |  |  |  |  |  |  | 71.1 |  |  |  |  |  |  |  |  |  | 71.1
12 | 2014-06-20 00:00:00 | 2014-06-20 00:00:00 | Sessional | E |  |  |  |  |  | 60 |  |  | 40
13 | 2014-06-22 00:00:00 | 2014-06-22 00:00:00 | Community Performances | F |  |  | 505.83 |  |  |  |  |  |  |  | 343.24 |  | 216.67 |  | 108.33 |  |  |  |  |  | 78.48 |  |  |  |  |  |  | 42.25 | 42.25
14 | 2014-06-24 00:00:00 | 2014-06-24 00:00:00 | Sessional | C
15 | 2014-06-25 00:00:00 | 2014-06-25 00:00:00 | Sessional | C
16 | 2014-06-27 00:00:00 | 2014-06-27 00:00:00 | Functions | G |  |  | 389.17
17 | 2014-07-04 00:00:00 | 2014-07-04 00:00:00 | Sessional | B
18 | 2014-07-10 00:00:00 | 2014-07-10 00:00:00 | Sessional | H |  |  | 255
19 | 2014-07-12 00:00:00 | 2014-07-12 00:00:00 | Sessional | B |  |  |  | 150
Total
Spreadsheet: e1b5375e-4238-4920-816c-231b16a0f310
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-09-13 13:22:58.850000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 102.02 | 101.895 | 101.77 | 101.395
3.75 | 101.917 | 101.792 | 101.667 | 101.292 |  | Note: | Refer To Price [NAME]
3.625 | 101.319 | 101.194 | 101.069 | 100.694 |  |  | For all Price Adjs
3.5 | 100.514 | 100.389 | 100.264 | 99.639
3.375 | 99.684 | 99.559 | 99.434 | 98.809
3.25 | 98.729 | 98.604 | 98.479 | 97.854
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.125 | 102 | 101.875 | 101.5
3.25 | 101.848 | 101.723 | 101.598 | 101.223
3.125 | 101.541 | 101.416 | 101.291 | 100.916
3 | 101.06 | 100.935 | 100.81 | 100.435
2.875 | 100.418 | 100.293 | 100.168 | 99.543
2.75 | 99.753 | 99.628 | 99.503 | 98.878
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-09-27 13:22:58.850000
30 DAY | 2012-10-12 13:22:58.850000
45 DAY | 2012-10-27 13:22:58.850000
60 DAY | 2012-11-11 13:22:58.850000
90 DAY | 2012-12-11 13:22:58.850000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 163129d1340201847-percent-change-in-pivot-tables-problem
Sheet: Sheet1

 |  | Row Label | Sum of 2011 | sum of 2010 | sum of 2009
 |  | AL | 29.5 | 29.6 | 29.8
 |  | AZ | 31.6 | 61.62 | 31.56
 |  | CA | 24.5 | 24.6 | 27.8
 |  | CT | 33.2 | 34.3 | 34.67
 |  | DC | 57.8 | 28.9 | 87.88
Spreadsheet: 492767d1481258717-working-with-a-large-amount-of-email-address-lists-with-duplicate-addresses-working-with-a-large-amount-of-email-address-lists-with-duplicate-addresses
Sheet: Sheet1

List 1 | List 2 | List 3 | List 4
Kelly | [NAME] | [NAME] | [NAME]
[NAME] | Vince | Sandra | [NAME]
[NAME] | [NAME] | Kelly | [NAME]
[NAME] | [NAME] | Sandra | [NAME]
[NAME] | Elsie | Rachel | Vince
[NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | Elsie
[NAME] | Elsie | Elsie | Rachel
[NAME] | Rachel | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 24e310ca-f2f3-415f-afc4-6dde69cd438a
Sheet: Summary

Summary of Resources required for Project
Financial Resources
Summary Fund Heading | Fund Heading | Full Economic Cost | BBSRC Contribution | % BBSRC Contribution
Directly Incurred | Staff |  |  | 0.8
 | Travel & Subsistence |  |  | 0.8
 | Other Costs |  |  | 0.8
 | Sub-total
Directly Allocated | Investigators |  |  | 0.8
 | Estate Costs |  |  | 0.8
 | Other Directly Allocated |  |  | 0.8
 | Sub-total
Indirect Costs | Indirect Costs |  |  | 0.8
Exceptions | Other Costs |  |  | 1
 | Sub-total
 | Total
Spreadsheet: 683917d1593049020-deferred-revenue-for-saas-company-deferred-revenue
Sheet: Financials

 | Financials
 |  | FY2018A |  | 1Q19A | 2Q19A | 3Q19A | 4Q19A | FY2019A |  | 1Q20A | 2Q20P | 3Q20P | 4Q20P | FY2020P
 | Income Statement
 | Revenue | 811472.664708383
 | Cost of Goods Sold | 486883.59882503 |  | 84711.88271008887 | 184657.1975092889 | 206126.6948797669 | 213157.7758935003 |  |  | 317880.7724262272
 | Gross Profit
 | Sales & Marketing | 1211969.85829668 |  | 542156.0493445689 | 507807.2931505446 | 549671.1863460451 | 603947.031698251 |  |  | 731125.7765803224
 | Research & Development | 1188830.004972567 |  | 474386.5431764977 | 553971.5925278667 | 618380.0846393007 | 639473.327680501 |  |  | 709933.7250852407
 | General & Administrative | 1213921.279235573 |  | 423559.4135504444 | 550627.2376155776 | 660752.6851386932 | 712903.222166432 |  |  | 752193.544383075
 | Depreciation and Amortization | 16229.45329416766 |  | 3388.475308403555 | 9232.859875464446 | 13741.77965865113 | 14210.51839290002 |  |  | 21192.05149508181
 | Total Operating Expenses
 | Operating Income
 | Summary Balance Sheet
 | ASSETS
 | Cash | 34950000 |  | 34211814.0246916 | 32997372.42727026 | 31752276.774256
 | Total Current Assets
 | Fixed Assets | 50000 |  | 50000 | 50000 | 50000 | 50000 |  |  | 50000
 | Total Assets
 | LIABILITIES & EQUITY
 | Deferred Revenue | 0 |  | 620592.6233614222 | 750804.2128455999 | 867292.0075612437 | 770311.8656290425 |  |  | 1690209.92968035
 | Total Liabilities | 0
 | Total Equity |  |  | 33641221.40133017 | 32296568.21442465 | 30934984.76669475
 | Total Liabilities & Equity
 | Free Cash Flow (Cash Burn) | -2884395.74426727 |  | -738185.9753084035 | -1214441.597421342 | -1245095.653014257
Spreadsheet: ec324292-479a-4981-ad24-80cc787eb6e1
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
BILIT | Test | BILIT | Bilirubin, Total, Serum | Bilirubin Total, S | Photometric, Diazonium Salt (DPD) | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Amber vial (Supply T192) [NAME]: 0.5 mL Collection Instructions: Protect specimen from light. Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Males 12 months: 0.1-0.9 mg/dL > or =24 months: 0.1-1.0 mg/dL Reference values have not been established for patients who are <12 months of age. Females 1-11 years: 0.1-0.9 mg/dL > or =12 years: 0.1-1.0 mg/dL Reference values have not been established for patients who are <12 months of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82247 |  |  |  |  | Rochester
BILIT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
BILIT | Result | BILIT | Bilirubin Total, S | Bilirubin Total, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 1975-2 | Bilirubin:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 95235d1294866060-nested-if-statments-test-timesheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  |  |  | 2011-02-01 00:00:00
Date |  |  |  |  |  |  | Time in | Lunch in | Lunch out | Time out | (other) | Total Hrs | (hidden) | Hrs-O/U
 |  | Does | not | works |  |  | 08:00:00 |  |  | 14:00:00
 |  | Dose | not | works |  |  | 08:00:00 |  |  | 18:00:00
 |  | This | row | does | work |  | 08:00:00 |  |  | 14:00:00
 |  | This | row | does | work |  | 08:00:00 |  |  | 18:00:00
Spreadsheet: 164520d1340803133-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test
Sheet: Wednesday Timesheeet

 |  |  | TRI TOOL INC. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SERVICES
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  |  | 1 | If required, has the site specific training been completed?
 |  |  |  | 2 | If permits are required, do you have the proper papers?
 |  |  |  | 3 | Is Scaffolding correct and safe?
 |  |  |  | 4 | If lockout is required, has the proper procedure been followed?
 |  |  |  | 5 | Do you know the emergency signals?
 |  |  |  | 6 | Do you know the escape routes and assembley points?
 |  |  |  | 7 | Are safety glasses required?
 |  |  |  | 8 | Is a face sheild required?
 |  |  |  | 9 | Is a hard hat required?
 |  |  |  | 10 | Are flame resistant clothes required?
 |  |  |  | 11 | Is hearing protection required?
 |  |  |  | 12 | Are safety toed shoes required?
 |  |  |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  |  | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 315ee1fc-10b9-4dd6-a85d-01f8d24e3d8b
Sheet: Publishers (Poetry)

Publisher (Poetry) | Titles | Percentage
Shearsman Books | 5
Ugly Duckling | 5
Zephyr Press | 5
Action Books | 4
Chelsea Editions | 4
Arc Publications | 3
Archipelago | 3
Cross-Cultural Communications | 3
New York Review Books | 3
White Pine | 3
Anomalous Press | 2
Anvil Press | 2
Bitter Oleander Press | 2
BOA Editions | 2
Calypso Editions | 2
Copper Canyon | 2
FSG | 2
New Directions | 2
Open Letter | 2
Tavern Books | 2
[NAME] | 2
University of Chicago | 2
Akashic Books | 1
Almost Island | 1
Biblioasis | 1
Bloodaxe | 1
Book Thug | 1
Burning Deck Press | 1
Carnegie Mellon Press | 1
Chax Press | 1
Chin Music Press | 1
Coach House Books | 1
[NAME] | 1
Dos Madres Press | 1
[NAME] | 1
Editions [NAME] | 1
Harvard University Press | 1
[NAME] | 1
Milkweed | 1
Omnidawn | 1
Otis Books | 1
[NAME] | 1
Red Dragonfly Press | 1
Seagull Books | 1
Sixteen Rivers Press | 1
Stork Press | 1
[NAME] | 1
Tsar Publications | 1
Wave Books | 1
Yale University Press | 1
Spreadsheet: b7114eaa-91c1-4ecb-ada3-1b2f0d7db832
Sheet: Sheet1

DEMOCRATIC STATE REPRESENTATIVES - BELKNAP COUNTY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Page 1 of 2
District No. 1 (1) | [NAME], d | [NAME], Jr., r | Wendelboe, r |  | [NAME]
Center Harbor | 36
New Hampton | 73 |  | 1
TOTALS | 109
District No. 2 (2) | [NAME], d | Morrison, d | Cioffi, r | Fields, r | Leighton, r | Tobin, r | [NAME], r |  | [NAME]
Sanbornton | 63 | 116 | 1 | 6 |  | 15 |  |  | 3
[NAME] | 93 | 115
TOTALS | 156 | 231 | 1 | 6 |  | 15
District No. 3 (2) | Mucci, J., d | Mucci, S., d | [NAME], r | Nedearu, r |  | [NAME]
Meredith | 117 | 131 | 1 | 1 |  | 2
District No. 4 (5) | Arsenault, d | [NAME], d | Morin, d | Reever, d | Wood, d | Dewhirst, r
[NAME] | 69 | 56 | 57 | 67 | 67
[NAME] | 68 | 48 | 55 | 58 | 62
[NAME] 3 | 81 | 69 | 71 | 85 | 83
[NAME] | 66 | 57 | 61 | 70 | 65
[NAME] | 56 | 44 | 51 | 60 | 54
[NAME] 6 | 60 | 50 | 56 | 61 | 58 | 1
TOTALS | 400 | 324 | 351 | 401 | 389
 | DEMOCRATIC STATE REPRESENTATIVES - BELKNAP COUNTY
District No. 4 (5) | Flanders, r | Krahulec, r | Rosen, r | [NAME], r | [NAME], r |  | [NAME] |  | Page 2 of 2
[NAME] |  | 2 | 1 |  |  |  | 4
[NAME] |  |  |  |  |  |  | 1
[NAME] 3 |  |  |  |  |  |  | 2
[NAME] |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  | 2
[NAME] 6 |  |  |  |  |  |  | 1
TOTALS
District No. 5 (7) | Aselton, Jr., d | Bourbeau, d | Frost, d | [NAME], d | Morin, Jr., d | Warmington, d | Willoughby, d | Allen, r | Boyce, r
Alton | 76 | 82 | 87 | 78 | 75 | 79 | 83
Barnstead | 80 | 100 | 101 | 90 | 77 | 84 | 93
Belmont | 64 | 59 | 66 | 63 | 72 | 58 | 63
Gilford | 120 | 110 | 169 | 156 | 137 | 136 | 123
TOTALS | 340 | 351 | 423 | 387 | 361 | 357 | 362
District No. 5 (7) | [NAME], r | [NAME], r | Keniston, r | [NAME], r | Pilliod, r | Shibley, r | [NAME], r | [NAME], r | [NAME]
Alton |  |  | 1 | 2 | 1 |  |  |  | 2
Barnstead |  |  |  |  |  |  |  |  | 4
Belmont |  |  |  |  |  |  | 1
Gilford | 1 |  | 2 | 11 | 4 |  | 2 | 2 | 3
TOTALS
District No. 6 (1) |  | [NAME], r | [NAME]
Gilmanton |  | 1 | 5
Spreadsheet: 692314d1598275137-find-values-from-columns-of-your-choice-dynamic-search2
Sheet: Sheet1

 |  |  |  |  |  | Should find if Result in C:C is in E:E or vice versa
 | Result1 | Result2 | Result3 | Value | Result2
 | BUS | TAXI | BUS | CAR
 | CAR | CAR | BUS | BUS |  |  | [NAME] should find these values
 |  | TAXI |  | TAXI
 |  | CAR |  | RUN
 |  | MIX
 |  | RUN
Spreadsheet: thomas_martin__39674__ifmonth2
Sheet: Sheet1

Please enter your name and a contact phone number on the line below before sending:
Your name and phone number here, 713-xxx-xxxx
Inside FERC's Gas Market Report monthly bidweek price file.
When done, e-mail to BOTH [EMAIL] AND [EMAIL]
or fax to [PHONE], attention: [NAME]
Prices must be sent to INSIDE FERC by 3:30 pm EASTERN TIME on the last business day of the month or
they might not be included.  If you have problems, call [PHONE] ([NAME])
SURVEY / WORKBOOK  NOTES:
* The essential fields to fill out below are the price, volume, date and price source (your company name) fields.
* Add the specific pipeline names and delivery points in column A as you go.
* We round the volumes to the nearest thousand, and truncate the last three zeros,
ie, 15,320 [NAME]/day is entered as just 15; likewise, 3,000 MMBtu/day, as 3, etc.
* Only report FIXED-PRICED,  BASELOAD DEALS negotiated during BIDWEEK. NO EFPs or basis deals.
* SPECIFICALLY EXCLUDED from the survey should be "Trigger" deals that were
negotiated prior to bidweek and "fixed" during bidweek, "Basis" deals that
are struck either during bidweek or prior to bidweek then priced off the
NYMEX expiry but "fixed" before that using futures contracts, or any other
deals in which the price is derived from something other than negotiation at the
time the price is fixed.  Also excluded are exchanges of futures for physicals (EFPs).
* In the last two columns on the right, please report a low and a high for BASIS DEALS during BIDWEEK
at each pricing point. The basis should be reported as plus or minus values to the last day NYMEX
[NAME] price, ie., minus a half cents is -0.05, etc.
* Please do not change the format of the file or put formulas in the cells, just values.
Thank you for participating, [NAME]. Any questions, call me at [PHONE]
 | Price | Volume | Date | Price Source | IF Reporter | Comments | Bidweek Basis Low | Bidweek Basis High
example:
ANR Louisiana | 2.02 | 15 | 1998-12-24 00:00:00 | Your Company | [NAME] | counterparty, etc. | -0.0525 | 0.0125
 | 2.01 | 5 | 1998-12-29 00:00:00 | company name | [NAME] | counterparty, etc.
 | 1.99 | 7 | 1998-12-30 00:00:00 | company name | [NAME] | counterparty, etc.
 | Price | Volume | Date | Price Source | IF Reporter | Comments | Bidweek Basis Low | Bidweek Basis High
ANR Louisiana
ANR Okla., etc.
Spreadsheet: 473487d1470237476-sumifs-function-exclude-duplicate-in-one-of-the-column-sample
Sheet: Sheet4

 | Invoice date | Divn | Dept | Salesman Code | Receipt date | Voucher No | Invoice Amt
 | 2016-01-02 00:00:00 | 10 | 12 | 48 | 2016-05-14 00:00:00 | [NAME] | 5940
 | 2016-01-02 00:00:00 | 19 | 12 | 657 | 2016-02-08 00:00:00 | CRV-[PHONE] | 129.12
 | 2016-01-02 00:00:00 | 10 | 12 | 657 | 2016-06-11 00:00:00 | PDCRV-[PHONE] | 1750
 | 2016-01-02 00:00:00 | 19 | 12 | 657 | 2016-06-11 00:00:00 | PDCRV-[PHONE] | 962
 | 2016-01-03 00:00:00 | 10 | 12 | 72 | 2016-01-06 00:00:00 | CRSARTN-[PHONE] | 3850
 | 2016-01-03 00:00:00 | 14 | 12 | 72 | 2016-01-06 00:00:00 | PDCRV-[PHONE] | 1975
 | 2016-01-03 00:00:00 | 10 | 12 | 72 | 2016-02-06 00:00:00 | PDCRV-[PHONE] | 9792
 | 2016-01-03 00:00:00 | 10 | 12 | 48 | 2016-05-14 00:00:00 | [NAME] | 1512
 | 2016-01-03 00:00:00 | 10 | 12 | 48 | 2016-05-14 00:00:00 | [NAME] | 5940
 | 2016-01-03 00:00:00 | 10 | 12 | 647 | 2016-07-12 00:00:00 | PDCRV-[PHONE] | 8171.87
 |  |  |  |  | 2016-07-05 00:00:00 | PDCRV-[PHONE] | 18250
Spreadsheet: 790534d1659772910-search-table-given-dates-and-numbers-as-criteria-help-given-aligw
Sheet: Sheet1

VOLUME DISCOUNT PER ITEM TABLE BASED ON INVOICE DATE
VOLUME PER ITEM: |  | 12000 | <<-- GIVEN | CHANNEL: |  | EU | <<-- GIVEN
INVOICE DATE: |  | 2022-01-15 00:00:00 | <<-- GIVEN | VOLUME DISCOUNT: |  |  | <<<--- HELP W/ THIS FORMULA
 |  |  |  | EXCEL 365 FORMULA: |  |  | <<<--- OK
The above EXCEL 365 [NAME] works fine. However, I need a working formula for those not running Excel 365. I need help @ G3 - To search a table with date ranges and number ranges using INDEX MATCH or other ways.
SORT DATE THEN VOL ASCENDING
VOL | FR_DATE | TO_DATE | EU | DL | DR | TB | PL | RM
0 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.03 | 0 | 0 | 0 | 0 | 0
5000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.06 | 0 | 0 | 0 | 0 | 0
10000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.09 | 0 | 0 | 0.03 | 0.03 | 0
15000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.12 | 0 | 0 | 0.06 | 0.06 | 0
20000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.09 | 0.09 | 0
25000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.12 | 0.12 | 0
30000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.15 | 0.15 | 0
999999999 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.15 | 0 | 0 | 0.15 | 0.15 | 0
0 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.02 | 0 | 0 | 0 | 0 | 0
5000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.04 | 0 | 0 | 0 | 0 | 0
10000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.06 | 0 | 0 | 0.02 | 0.02 | 0
15000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.08 | 0 | 0 | 0.04 | 0.04 | 0
20000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.06 | 0.06 | 0
25000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.08 | 0.08 | 0
30000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
999999999 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
Spreadsheet: 118795d1314019363-use-value-in-one-cell-to-paste-a-corresponding-row-estimate
Sheet: Take off

Job Name: |  | 0
Estimate Number: |  | 0
 |  | (feet) |  | (in) | (in) | (lb/ft) | UNIT | WGT | TOTAL | MISC
[NAME] |  | LGT | QTY | WDT | THK | WGT | $ | $ | WEIGHT | $
= | = | = | = | = | = | = | = | = | = | =
W250x49
Spreadsheet: 166435d1341585022-rearrange-data-from-horizontal-to-vertical-to-use-it-in-a-pivot-transpose-test
Sheet: As Is

 | Month/Code | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Cost Centre | Division | M1 | M2 | M3 | M4 | I1 | I2 | S1 | S2 | S3 | [NAME] | M1 | M2 | M3 | M4 | I1 | I2 | S1 | S2 | S3 | [NAME]
52001000 | Corporate Center | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
52001022 | Corporate Center | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 5 | 0 | 0 | 0 | 0
52001032 | Corporate North-East | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0
52001037 | Corporate North-East | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
52001044 | Corporate North-East | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52001020 | Corporate North-West | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1
52001033 | Corporate North-West | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52001040 | Corporate North-West | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
52001026 | Corporate South | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52001045 | Corporate South | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52001008 | Corporate South-East | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
52001016 | Corporate South-East | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52001034 | Corporate South-West | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 0
52001038 | Corporate South-West | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52001030 | Corporate West | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
52001046 | Corporate West | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 376538d1423635202-assistance-in-linking-cells-into-several-worksheet-full-price-list-sample
Sheet: AMOS

Address : 60 Benoi Road F2 #02-11, SINGAPORE (629906)
Telephone : (65) 6265 8662            Fax : (65) 6265 7616
E-mail : [EMAIL]                 GST Reg No. 200708233N
No | IMPA No | ITEM | [NAME] | UNIT | AMOS | Remark
1