tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 150672d1334656231-creating-a-formula-from-an-online-calculator-rif-fas-calculation-template
Sheet: Individual illustration

STRICTLY ADDRESSEE EYES ONLY |  |  |  |  |  | Without Prejudice
For illustrative purposes only - this calculation uses the most recent bonus payment in the calculation of annualised
weekly pay.
ESTIMATE REDUNDANCY CALCULATION
Name: |  |  |  | Job Band:
Payroll ID: |  |  |  | Age: |  | 30
Date of Birth: |  |  | 1982-01-11 00:00:00 | Length of Service: |  | 8
Date of Commencement: |  |  | 2003-05-01 00:00:00 | Weekly Basic Salary |  | 425
Date of Termination (End of Consultation): |  |  |  | Average weekly Bonus/Commision
End of Notice Period Date |  |  |  | Average weekly Overtime/ Oncall
 |  |  |  | Total Average Weekly Salary
Your severance payment will be the sum total of the three elements listed below:
A) Statutory Redundancy Pay based on Age and Length of Service
(Restricted to the Statutory Maximum Limit of £430 per week)
#N/A | weeks @ | 425 |  | = |  | #N/A
Plus
B) NCR Discretionary Payment for Service
(2 weeks for each year of service up to a maximum payment of 46 weeks)
16 | x | #N/A |  |  | = | #N/A
Payments A & B up to a maximum of £30,000 should be allocated to ADP Code 171, any amount in excess of
£30,000 should be allocated to ADP Code 173.
Plus
C) Payments in Lieu of Notice
(will be reduced according to Notice Period worked - Where Notice Period is worked this is not payable upon termination)
Salary | 12 | weeks | 5100 | (ADP Code 162)
Loss of medical insurance | 12 | weeks | 73.92 | (ADP Code 175)
Loss of car | 0 | weeks | 0 | (ADP Code 157)
TOTAL |  |  |  |  |  | 5173.92
TOTAL GROSS PAYMENT |  |  |  |  |  | #N/A
TAX TREATMENT
In accordance with current Inland Revenue Guidelines:
a)  Payment in Lieu of Notice (C) will be taxed in full at normal rate and subject to National Insurance
deductions (ADP Code 162)
b)  Statutory (A) & Discretionary payments (B) up to £30,000 will be paid free of tax (ADP Code 171).
Payments above £30,000 will be taxed at your normal rate and subject to National Insurance deductions (ADP
Code 173)
If the Inland Revenue Guidelines change, resulting in a change to tax liability, it will be the individual's
responsibility to resolve this directly with the Inland Revenue.
Determination of final tax is at the sole discretion of the Inland Revenue
Spreadsheet: 844327d1696056016-add-the-number-of-data-matches-between-rows-of-dates-excel-forum-example-3
Sheet: Guest stay total by date

First Night | Last Night | Guest Name | Night | Number stayed
2023-06-09 00:00:00 | 2023-10-01 00:00:00 | A | 2023-06-09 00:00:00
2023-06-09 00:00:00 | 2023-06-12 00:00:00 | B
2023-06-09 00:00:00 | 2023-06-12 00:00:00 | C
2023-06-09 00:00:00 | 2023-10-01 00:00:00 | D
2023-06-19 00:00:00 | 2023-06-22 00:00:00 | E
2023-06-19 00:00:00 | 2023-06-22 00:00:00 | F
2023-06-19 00:00:00 | 2023-06-22 00:00:00 | G
2023-06-23 00:00:00 | 2023-06-24 00:00:00 | H
2023-06-23 00:00:00 | 2023-06-24 00:00:00 | I
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | J
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | K
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | L
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | M
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | N
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | O
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | P
2023-06-25 00:00:00 | 2023-06-29 00:00:00 | Q
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | R
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | S
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | T
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | U
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | V
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | W
2023-06-25 00:00:00 | 2023-07-01 00:00:00 | X
2023-06-25 00:00:00 | 2023-06-29 00:00:00 | Y
2023-06-25 00:00:00 | 2023-06-29 00:00:00 | Z
2023-06-25 00:00:00 | 2023-06-29 00:00:00 | AA
2023-06-25 00:00:00 | 2023-06-29 00:00:00 | AB
2023-06-25 00:00:00 | 2023-06-29 00:00:00 | AC
2023-06-30 00:00:00 | 2023-07-01 00:00:00 | AD
2023-06-30 00:00:00 | 2023-07-01 00:00:00 | AE
2023-06-30 00:00:00 | 2023-07-01 00:00:00 | AF
2023-06-30 00:00:00 | 2023-07-01 00:00:00 | AG
Spreadsheet: e8381577-0e9f-4835-b613-0a9def87573a
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
GCLIP | Test | GCLIP | Phospholipid (Cardiolipin) Antibodies, IgG, Serum | Phospholipid Ab IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT OR |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <10.0 GPL (negative) 10.0-14.9 GPL (borderline) 15.0-39.9 GPL (weakly positive) 40.0-79.9 GPL (positive) > or =80.0 GPL (strongly positive) GPL refers to IgG Phospholipid Units. One GPL unit is 1 microgram of IgG antibody.  Reference values apply to all ages. | Monday through Saturday; 4 p.m. | Same day/1 day | 3 days | 1 | 86147 |  |  |  |  | Rochester
GCLIP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
GCLIP | Result | GCLIP | Phospholipid Ab IgG, S | Phospholipid Ab IgG, S | Numeric |  |  |  |  | GPL |  |  |  |  |  |  |  |  |  | 3286-2
Spreadsheet: 333d7f91-4ce1-4fd6-b4e1-4217aca94d0e
Sheet: Exhibit A - Year 4

Section L - Attachment 7 - Price Schedule
DE-SOL-0003816
Option Year 3 (February 1, 2016 - January 31, 2017)
Total Contract
 | DPLH |  |  | Labor |  |  | Direct Labor Costs |  |  | Fringe Benefits |  |  | [NAME] |  |  | Onsite Overhead |  |  | Onsite | Total Costs
Cost Element |  |  |  | Straight | Over | Double | Straight | Over | Double |  |  |  |  |  |  |  |  |  | Overhead
 | Straight | Over | Double | Time | Time | Time | Time | Time | Time | Straight | Over | Double | Straight | Over | Double | Straight | Over | Double |  | Straight | Over | Double | Total
 | Time | Time | Time | Rate | Rate | Rate | Costs | Costs | Costs | Time | Time | Time | Time | Time | Time | Time | Time | Time | Rate | Time | Time | Time | Costs
Cost Plus Fixed Fee (CPFF) Tasks
**Prime Contractor Labor
Bargaining Employee:
Mechanic | 3630 | 100 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mobile Crane Inspector | 120
Laborer | 5625 | 150 | 90
Heavy Equipment Operator | 5625 | 150 | 90
Truck Driver | 5625 | 150 | 90
(Itemize each additional position)
Non-Bargaining Employees:
Program Manager | 1775 | 0
Operations & Maintenance Manager | 1775 | 0
Administrative Support | 1775
Shop Manager | 1775 | 0
Supply Technician | 1775 | 20
Construction Technician
(Itemize each additional position)
Subtotal (Provide Subtotals for Each) |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subcontractor Labor (If Applicable)
(Itemize for Each Position)
Subtotal (Provide Subtotals for Each) | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal CPFF Labor Related Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
Other Direct Costs:
Material |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Construction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Subtotal CPFF Costs | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
G&A (Identify G&A Rate)
Total CPFF Proposed Costs
Reserve Fee
Total  Proposed CPFF Fee
Total [NAME] | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0
A 3% increase to be added to all labor for the following options.  (All hours and material/subcontracts remain the same)
*Note:  Fuel - Contractor shall not charge in excess of $.10 per gallon surcharge for sold fuel applicable to reservation activities.  No additional G&A, handling fee, or other direct or indirect charges will apply to this cost.
**The labor categories and hours may be adjusted at the discretion of the offeror in order to comply with the offeror's position in meeting the requirements of the solicitation.
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 14b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia |  | <100 | 326
 | Europe |  |  | 172931
 | North America | 18193 | 138104 | 1979
Index | Asia | 555 | 8597 | 14158
 | Europe |  |  | 381933
 | North America | 90649 | 379863 | 64839
TOTAL |  | 109396 | 526564 | 636166
Estimated net notional amount outstanding, February 1 weekly snapshot, by product type and grade (millions of USD), all participant types, tenors and currencies, cleared and uncleared. This table will be expanded to reflect participant type  as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 882946d1731425103-filter-lists-using-check-boxes-to-show-where-jobs-are-per-steps-tick-box-testing
Sheet: Sheet1

Name | Address | Postcode | Step 1 | Step 2 | Step 3 |  |  | Step 1 |  |  |  | Step 2 |  |  |  | Step 1
NAME 1 | ADDRESS 1 | POSTCODE 1 | False | False | False
[NAME] 2 | ADDRESS 2 | POSTCODE 2 | False | False | False
NAME 3 | ADDRESS 3 | POSTCODE 3 | False | False | False
NAME 4 | ADDRESS 4 | POSTCODE 4 | False | False | False
NAME 5 | ADDRESS 5 | POSTCODE 5 | False | False | False
NAME 6 | ADDRESS 6 | POSTCODE 6 | False | False | False
NAME 7 | ADDRESS 7 | POSTCODE 7 | False | False | False
[NAME] 8 | ADDRESS 8 | POSTCODE 8 | False | False | False
NAME 9 | ADDRESS 9 | POSTCODE 9 | False | False | False
NAME 10 | ADDRESS 10 | POSTCODE 10 | False | False | False
NAME 11 | ADDRESS 11 | POSTCODE 11 | False | False | False
Spreadsheet: 249356d1373494310-flagging-reciprocal-values-in-a-diallel-table-flagging-recipricals
Sheet: Sheet1

 | A | B | C | D
A
B
C
D
Spreadsheet: 118693d1313900267-summing-and-arrays-bp
Sheet: Sheet1

Age (years) | Sex | Systolic | Diastolic
45 | M | 120 | 68
33 | F | 124 | 78
15 |  | 165 | 69
69 | F | 184 | 94
55 | F | 179 | 92
36 | M | 146 | 92
59 | M | 162 | 97 |  |  |  | I need the number of people who have either systolic >139 OR diastolic >89
51 | F | 143 | 85
41 | F | 137 | 87 |  |  |  | I also need to work out how many of those with high systolic or diastolic are M or F
74 | M | 164 | 100 |  |  |  | It would also be good to break this down into how many M have high systolic ONLY etc...
74 | F | 144 | 85
50 | F | 160 | 95
75 | F |  |  |  | Count of Diastolic | Column Labels |  |  |  |  | Count of Diastolic | Column Labels
49 | F | 123 | 68 |  | Row Labels | F | M | (blank) | Grand Total |  | Row Labels | F | M | Grand Total
76 |  | 170 | 78 |  | 137 | 2 |  | 1 | 3 |  | 90 | 1 | 1 | 2
50 | F | 117 | 78 |  | 140 |  | 1 |  | 1 |  | 91 |  | 1 | 1
54 |  | 131 | 68 |  | 141 | 2 |  |  | 2 |  | 92 | 1 | 1 | 2
20 | M | 127 | 69 |  | 143 | 1 |  |  | 1 |  | 94 | 2 |  | 2
36 | M | 96 | 67 |  | 144 | 3 |  |  | 3 |  | 95 | 2 |  | 2
23 | F | 137 | 88 |  | 145 | 1 |  |  | 1 |  | 97 |  | 1 | 1
68 | F | 186 | 86 |  | 146 | 1 | 1 |  | 2 |  | 98 |  | 1 | 1
52 | F | 141 | 76 |  | 148 | 1 |  |  | 1 |  | 100 |  | 1 | 1
28 | F | 120 | 67 |  | 149 | 1 |  |  | 1 |  | Grand Total | 6 | 6 | 12
61 | M | 173 | 90 |  | 152 | 1 |  |  | 1
66 | F | 144 | 74 |  | 154 | 1 |  |  | 1
60 | M |  |  |  | 160 | 1 | 1 |  | 2
47 | M | 126 | 80 |  | 162 |  | 1 |  | 1
46 | M | 178 | 85 |  | 164 |  | 1 |  | 1
47 | F | 121 | 70 |  | 165 |  |  | 1 | 1
70 | F | 106 | 41 |  | 170 |  |  | 1 | 1
52 |  |  |  |  | 173 |  | 1 |  | 1
48 |  | 135 | 88 |  | 178 |  | 1 |  | 1
40 | M | 135 | 87 |  | 179 | 1 |  |  | 1
49 | F | 149 | 86 |  | 184 | 1 |  |  | 1
83 |  | 137 | 68 |  | 186 | 1 |  |  | 1
48 | F | 154 | 89 |  | Grand Total | 18 | 7 | 3 | 28
65 | M | 131 | 82
63 | F
61 | M
70 | F | 146 | 95
48 | F | 148 | 76
48 | F | 144 | 77
61 | F | 124 | 76
57 | F | 145 | 94
49 | M | 140 | 98
41 | F | 116 | 68
52 | F | 152 | 90
29 | M | 160 | 91
58 | F | 141 | 86
Spreadsheet: 839461d1692006019-filter-formula-to-lookup-and-return-data-with-2-critiera-sample50-updated
Sheet: Data

Date | Employee | Pay
2022-04-05 00:00:00 | 1A | 60
2022-04-08 00:00:00 | 1B | 65
2022-04-19 00:00:00 | 1C | 70
2023-04-01 00:00:00 | 1A | 50
2023-04-05 00:00:00 | 1B | 45
2023-04-09 00:00:00 | 1C | 47
2023-04-22 00:00:00 | 2A | 51
2023-05-01 00:00:00 | 2B | 60
2023-05-06 00:00:00 | 1C | 70
2023-05-18 00:00:00 | 1B | 80
2023-05-27 00:00:00 | 2A | 90
2023-06-09 00:00:00 | 1C | 99
2023-06-10 00:00:00 | 1A | 100
2023-06-11 00:00:00 | 2B | 110
2023-06-19 00:00:00 | 2B | 60
2023-06-29 00:00:00 | 1B | 75
2023-07-05 00:00:00 | 2A | 81
2023-07-09 00:00:00 | 1C | 94
2023-07-11 00:00:00 | 1A | 95
2023-07-22 00:00:00 | 1B | 65
Spreadsheet: 758181d1638724216-vlookup-across-multiple-sheets-kod195-129-commercial-road
Sheet: V (11)

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Instructed
 |  | Variations |  |  |  |  |  |  |  |  |  |  |  | Cost Provided
Item | Column2 | Description | Qty | Unit | Rate | Extension |  |  |  |  |  |  |  | Subcontractor Only |  |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancelled
 | Variations
Item | Description |  | Qty | Unit | Rate | Extension
 |  |  |  |  |  |  |  | HOME TO VARIATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBCONTRACTOR OUTPUT SECTION |  |  | [NAME] CONSTRIUCTION SECTION
Item | Description |  | Qty | Unit | Rate | Extension |  | Subcontractor | Status | Rate | Extension | Margin % | Margin £/p | Provided | Sub Only | Instructed | Provided | Sub Only | Instructed
Note
V
*
11.01
11.02
11.03
11.04 |  |  |  |  |  |  |  |  |  | 0
11.05 |  |  |  |  |  |  |  |  |  | 0
11.06 |  |  |  |  |  |  |  |  |  | 0
11.07 |  |  |  |  |  |  |  |  |  | 0
11.08 |  |  |  |  |  |  |  |  |  | 0
11.09 |  |  |  |  |  |  |  |  |  | 0
11.1 |  |  |  |  |  |  |  |  |  | 0
11.11 |  |  |  |  |  |  |  |  |  | 0
11.12 |  |  |  |  |  |  |  |  |  | 0
11.13 |  |  |  |  |  |  |  |  |  | 0
11.14 |  |  |  |  |  |  |  |  |  | 0
11.15 |  |  |  |  |  |  |  |  |  | 0
11.16 |  |  |  |  |  |  |  |  |  | 0
11.17 |  |  |  |  |  |  |  |  |  | 0
11.18 |  |  |  |  |  |  |  |  |  | 0
11.19 |  |  |  |  |  |  |  |  |  | 0
11.2 |  |  |  |  |  |  |  |  |  | 0
11.21 |  |  |  |  |  |  |  |  |  | 0
11.22 |  |  |  |  |  |  |  |  |  | 0
11.23 |  |  |  |  |  |  |  |  |  | 0
11.24 |  |  |  |  |  |  |  |  |  | 0
11.25 |  |  |  |  |  |  |  |  |  | 0
11.26 |  |  |  |  |  |  |  |  |  | 0
11.27 |  |  |  |  |  |  |  |  |  | 0
11.28 |  |  |  |  |  |  |  |  |  | 0
11.29 |  |  |  |  |  |  |  |  |  | 0
11.3 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | To Collection
Spreadsheet: 01b59a89-96fc-4f14-b2fb-09cd8c93e461
Sheet: Sheet1

ADVANCE NOTICE OF INTENDED USE OF DEAN'S FACULTY CONFERENCE FUNDING | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Please complete all orange cells and check boxes that are applicable
Name: |  |  |  |  |  |  |  | Date of Application:
Name of conference:
Sponsoring organization or institution:
Location:
Dates: |  |  |  |  |  |  |  | Number of days:
Title of paper being presented:  (if applicable)
*  For reimbursement use the "R&D Detail Worksheet/Expense Form" must ALSO be filed within 30 days after return from the conference (send ELECTRONICALLY to [EMAIL]) with Original Receipts (send in campus mail). Please note that copies of Personal Credit Card Statements Do Not Constitute [NAME].  If you have charged any expenses to your Department Purchasing Card, a copy of the statement    showing charges to your department and COPIES of receipts must accompany your Expense Form.    If you have used a College car and/or a paid driving service, you must include a copy of the Internal Requisition from DPS, as well as a copy of charges for the driver.
EXPENSES (Please enter amounts in green cells--totals will automatically calculate):
1. Round-trip transportation
 | Airfare
 | Airport Parking
 | [NAME]
 | Car Mileage |  | miles @ | 0.565 | 0
 | Tolls en route
 | Parking at Conference
 | College Car/Driver/Car Rental
 | Train/Bus
 | Subway/Taxi
 |  |  |  |  | Total transportation expenses | 0
2. Conference registration fee
3. Miscellaneous expenses
4. Hotel and meals
 | Meals
 | Hotel |  |  |  |  | Note: Hotel expenses will not be covered for conferences less than 75 miles from your home.
 | Total Hotel & Meals |  |  |  |  | 0
TOTAL |  |  |  |  |  | 0
Please submit ALL of the following if presenting:
 | Invitation to present a paper or confirmation that the paper is scheduled for the conference
 | Program from the conference
 | Copy of the paper presented
Notes, if needed:
Spreadsheet: 85113d1285175957-adding-cells-with-numbers-and-cells-with-na-invoice
Sheet: Counter Sale Invoice

 |  |  |  | INVOICE
 |  |  | DATE:
 |  |  | INVOICE # | 100
 |  |  | FOR: | [NAME]
 | [NAME] To:
 | Valued  Customer
PART# | [NAME] |  | QTY | AMOUNT
10 |  |  | 50
20 |  |  | 100
250 |  |  | 10
260 |  |  | 5
730 |  |  | 5
740 |  |  | 10
 |  |  | SUB-TOTAL
 |  |  | WI SALES TAX
 |  |  | TOTAL
Spreadsheet: 266469d1379620825-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-county-fips-codes
Sheet: KANSAS-15

 | COUNTY | CODE
 | [NAME] | 1
 | [NAME] | 3
 | Atchison | 5
 | [NAME] | 7
 | Barton | 9
 | Bourbon | 11
 | [NAME] | 13
 | Butler | 15
 | Chase | 17
 | [NAME] | 19
 | Cherokee | 21
 | [NAME] | 23
 | [NAME] | 25
 | Clay | 27
 | Cloud | 29
 | Coffey | 31
 | Comanche | 33
 | Cowley | 35
 | Crawford | 37
 | Decatur | 39
 | Dickinson | 41
 | Doniphan | 43
 | [NAME] | 45
 | Edwards | 47
 | Elk | 49
 | Ellis | 51
 | Ellsworth | 53
 | [NAME] | 55
 | Ford | 57
 | Franklin | 59
 | Geary | 61
 | Gove | 63
 | [NAME] | 65
 | Grant | 67
 | Gray | 69
 | [NAME] | 71
 | [NAME] | 73
 | [NAME] | 75
 | Harper | 77
 | Harvey | 79
 | Haskell | 81
 | Hodgeman | 83
 | [NAME] | 85
 | [NAME] | 87
 | Jewell | 89
 | [NAME] | 91
 | Kearny | 93
 | Kingman | 95
 | [NAME] | 97
 | Labette | 99
 | [NAME] | 101
 | [NAME] | 103
 | Lincoln | 105
 | [NAME] | 107
 | Logan | 109
 | Lyon | 111
 | McPherson | 113
 | Marion | 115
 | [NAME] | 117
 | Meade | 119
 | Miami | 121
 | Mitchell | 123
 | Montgomery | 125
 | Morris | 127
 | [NAME] | 129
 | Nemaha | 131
 | Neosho | 133
 | Ness | 135
 | Norton | 137
 | Osage | 139
 | Osborne | 141
 | Ottawa | 143
 | Pawnee | 145
 | Phillips | 147
 | [NAME] | 149
 | Pratt | 151
 | Rawlins | 153
 | Reno | 155
 | Republic | 157
 | [NAME] | 159
 | Riley | 161
 | Rooks | 163
 | Rush | 165
 | [NAME] | 167
 | Saline | 169
 | Scott | 171
 | Sedgwick | 173
 | Seward | 175
 | Shawnee | 177
 | [NAME] | 179
 | [NAME] | 181
 | Smith | 183
 | Stafford | 185
 | Stanton | 187
 | [NAME] | 189
 | Sumner | 191
 | [NAME] | 193
 | Trego | 195
 | Wabaunsee | 197
 | [NAME] | 199
 | Washington | 201
 | Wichita | 203
 | Wilson | 205
 | Woodson | 207
 | Wyandotte | 209
Spreadsheet: 168937d1342633884-multiple-search-and-sumif-mock-up-v2-
Sheet: INPUT

 | PERSON | PLACE | COLOUR |  | month | 2012-01-01 00:00:00
 |  |  |  |  | YEAR | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | JACK | AUSTRALIA | RED
 | PETER | USA | BLUE
 | [NAME] | UK | RED
 | SIMON | UK | BLUE
 | [NAME] | AFRICA | YELLOW
Spreadsheet: 772253d1647112126-to-calculate-fuel-sur-charge-for-certain-customers-test-load-sheet
Sheet: Sheet2

Date | MateriUS loaded at | Customer | Destination | Ticket # | [NAME] | Base Rate | Total | FSC
2022-03-04 00:00:00 | COUCH | RMUSA | ANYWHERE,US | 7738555 | 28.26 | 11.6 | 327.816
2022-03-05 00:00:00 | VMC | RMUSAWF | ANYWHERE,US | 7738556 | 28.09 | 9 | 252.81
2022-03-06 00:00:00 | COUCH | RMUSA | ANYWHERE,US | 7738557 | 28.16 | 11.6 | 326.656
2022-03-07 00:00:00 | DUNN | ACI | ANYWHERE,US | 7738558 | 28.31 | 7 | 198.17
2022-03-08 00:00:00 | COUCH | RMUSA | ANYWHERE,US | 7738559 | 28.06 | 11.6 | 325.496
2022-03-09 00:00:00 | VMC | RMUSAWF | ANYWHERE,US | 7738560 | 27.35 | 9 | 246.15
2022-03-10 00:00:00 | DUNN | ACI | ANYWHERE,US | 7738561 | 28.28 | 7 | 197.96
2022-03-11 00:00:00 | COUCH | MSP | TARRANT,US | 7738562 | 28.22 | 11 | 310.42 | 55.87
2022-03-13 00:00:00 | RED BLUFF | MSP | TARRANT,US | 7738564 | 27.35 | 11 | 300.85 | 54.18
2022-03-14 00:00:00 | VMC | RMUSAWF | ANYWHERE,US | 7738565 | 29.05 | 9 | 261.45
2022-03-15 00:00:00 | COUCH | RMUSA | USEXANDER CITY,US | 7738566 | 28.02 | 8.35 | 233.967
2022-03-16 00:00:00 | MIDSOUTH AGG | MSP | ANYWHERE,US | 7738567 | 27.51 | 10 | 275.1 | 49.51
2022-03-17 00:00:00 | RED BLUFF | MSP | TARRANT,US | 7738568 | 28.16 | 11 | 309.76 | 55.79
2022-03-18 00:00:00 | MMONEIL | MSP | ANYWHERE,US | 7738569 | 28.05 | 8.78 | 246.279 | 44.31
2022-03-19 00:00:00 | RED BLUFF | KPC | WETUMOKA,US | 7738570 | 28 | 5 | 140
2022-03-11 00:00:00 | RED BLUFF | MSP | WETUMOKA,US | 7738571 | 28.3 | 5 | 141.5
 |  |  |  | [NAME] | 449.17 | Gross | 4094.384 | 259.66
 | Gross | 4094.384
 | 0.1 | 409.4384
 | Liability/Cargo Ins | 132
 | BC/BS | 123.98
 | W/Comp | 60
 | Aflac | 76.53
 | Sub Net | 3292.4356
 | [NAME] | 259.66
 | Net Due | 3552.0956
Spreadsheet: 38600d1236763947-detecting-same-value-in-3-cells-book1-2
Sheet: Sheet1

1st QTR | 2009-01-01 00:00:00 | Budget |  | Year-to-date
Line 1 | 1 | 100 |  | Desc | Total | Budget | [NAME] | Var. %
Line 2 |  | 125 |  | Line 1 | 3 | 405 | -402 | -0.9925925925925926 |  |  | 2009-01-31 00:00:00 | 6
Line 3 |  | 75 |  | Line 2 | 0 | 490 | -490 | -1 |  |  | 2009-02-28 00:00:00 | 11
Line 4 |  | 150 |  | Line 3 | 0 | 325 | -325 | -1 |  |  | 2009-03-31 00:00:00 | 16
1st QTR | 2009-02-28 00:00:00 | Budget |  | Line 4 | 0 | 570 | -570 | -1 |  |  | 2009-04-30 00:00:00 | 21
Line 1 |  | 100 |  |  | Date | 2009-04-30 00:00:00 |  |  |  |  | 2009-05-31 00:00:00 | 26
Line 2 |  | 125 |  |  |  |  |  |  |  |  | 2009-06-30 00:00:00 | 31
Line 3 |  | 75 |  |  |  |  |  |  |  |  | 2009-07-31 00:00:00 | 36
Line 4 |  | 135 |  |  |  |  |  |  |  |  | 2009-08-31 00:00:00 | 41
1st QTR | 2009-03-31 00:00:00 | Budget | Total | Budget | [NAME] | Var. % |  |  |  |  | 2009-09-30 00:00:00 | 46
Line 1 | 2 | 105 | 3 | 305 | -302 |  |  |  |  |  | 2009-10-31 00:00:00 | 51
Line 2 |  | 115 | 0 | 365 | -365 |  |  |  |  |  | 2009-11-30 00:00:00 | 56
Line 3 |  | 100 | 0 | 250 | -250 |  |  |  |  |  | 2009-12-31 00:00:00 | 61
Line 4 |  | 150 | 0 | 435 | -435
2nd Qtr | 2009-04-30 00:00:00 | Budget
Line 1 |  | 100
Line 2 |  | 125
Line 3 |  | 75
Line 4 |  | 135
2nd Qtr | 2009-05-31 00:00:00 | Budget
Line 1 |  | 105
Line 2 |  | 115
Line 3 |  | 100
Line 4 |  | 150
2nd Qtr | 2009-06-30 00:00:00 | Budget | Total | Budget | [NAME] | Var. %
Line 1 |  | 100 | 0 | 305 | -305
Line 2 |  | 125 | 0 | 365 | -365
Line 3 |  | 105 | 0 | 280 | -280
Line 4 |  | 125 | 0 | 410 | -410
[NAME] | 2009-07-31 00:00:00 | Budget
Line 1 |  | 100
Line 2 |  | 125
Line 3 |  | 75
Line 4 |  | 150
[NAME] | 2009-08-31 00:00:00 | Budget
Line 1 |  | 100
Line 2 |  | 125
Line 3 |  | 75
Line 4 |  | 135
[NAME] | 2009-09-30 00:00:00 | Budget | Total | Budget | [NAME] | Var. %
Line 1 |  | 75 | 0 | 275 | -275
Line 2 |  | 85 | 0 | 335 | -335
Line 3 |  | 95 | 0 | 245 | -245
Line 4 |  | 75 | 0 | 360 | -360
[NAME] | 2009-10-31 00:00:00 | Budget
Line 1 |  | 75
Line 2 |  | 75
Line 3 |  | 85
Line 4 |  | 105
[NAME] | 2009-11-30 00:00:00 | Budget
Line 1 |  | 100
Line 2 |  | 125
Line 3 |  | 75
Line 4 |  | 150
[NAME] | 2009-12-31 00:00:00 | Budget | Total | Budget | [NAME] | Var. %
Line 1 |  | 100 | 0 | 275 | -275
Line 2 |  | 125 | 0 | 325 | -325
Line 3 |  | 75 | 0 | 235 | -235
Line 4 |  | 135 | 0 | 390 | -390