tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 88838d1288668881-formula-to-find-three-different-criteria-and-then-sum-any-matches-copy-of-sample-spreadsheet
Sheet: Data

 |  | LOCATION ONE | LOCATION ONE | LOCATION TWO | LOCATION TWO | LOCATION THREE | LOCATION THREE
Name | Size | $ | OH | $ | OH | $ | OH
JACK FIVE | 30 | 999 | 0 | 0 | 0 | 0 | 0
RETRO BILLY | 33 | 29 | 67 | 13 | 42 | 1 | 3
OLD JACK | 30 | 125 | 435 | 44 | 163 | 7 | 120
[NAME] | 34 | 167 | 358 | 80 | 235 | 6 | 166
RANDY ONE | 36 | 284 | 369 | 86 | 361 | 9 | 237
Spreadsheet: 686066d1594338738-lookup-code-within-a-large-name-and-return-values-look-up-v2
Sheet: Sheet1

 | VALUES |  | Desired Answers
6008 |  |  | 20 |  |  | LOOKUP TABLE
06062 |  |  | 35 |  |  | 06-HE-06008A | RENT | 20
06063A |  |  | 22 |  |  | 06-HE-06008A | FEE | 1
02119 |  |  | 32 |  |  | 06-HE-06062A | RENT | 35
3102 |  |  | 43 |  |  | 06-HE-06062A | FEE | 2
3013 |  |  | 22 |  |  | T1-L3-06063 | RENT | 22
06073 |  |  | 28 |  |  | 06-SS-002119 | RENT | 32
11501 |  |  | 27 |  |  | T1-L3-03102 | RENT | 43
 |  |  |  |  |  | 470-1-003013 | RENT | 22
 |  |  |  |  |  | 06-SO-006073 | RENT | 28
 |  |  |  |  |  | T1-L3-011501 | FEE | 2
 |  |  |  |  |  | T1-L3-011501 | RENT | 27
 | to look values from lookup table and picking up ones only related to "RENT"
 |  |  |  |  |  | 09-DA-009022
 |  |  |  |  |  | 229-1-009010
 |  |  |  |  |  | 703-1-006080
 |  |  |  |  |  | 703-1-006080
 |  |  |  |  |  | 06-CR-006082
 |  |  |  |  |  | T1-L3-031228
 |  |  |  |  |  | T1-L3-031228
 |  |  |  |  |  | 470-1-006032
Spreadsheet: errol_mclaughlin_jr__10142__coal summay01-09-01
Sheet: Options

EnronOnline | Transaction Summary Report -3 | Internals Included |  | Generated on:   1/9/01 3:47:50 PM
[NAME] Id | Time | Customer | Commodity Group | Product Type | Product | Buy Volume | Sell Volume | Option Delta | Units | Currency | Price | Ext User Id | Int User Id | Risk Book | Collateral Flag | Enron Entity | Contract # | Bridge | Deal ID | [NAME] ID | Begin Date | End Date
Swap
753351 | 2001-01-09 09:08:18 | Natural Gas Price (Non-Affiliate) | Natural Gas | US Gas Fin Swap | US Gas Swap      Nymex                   Mar01           USD/MM |  | 17500 |  | MMBtu | United States Dollar | 8.975 | MMAGGI | JARNOLD | NG-Price | Y | Enron North America Corp. |  | TAGG |  | 11360 | 2001-03-01 00:00:00 | 2001-03-31 00:00:00
Option
753350 | 2001-01-09 09:08:18 | Power Midwest Gas (Mark to Market) | Natural Gas | US Gas Fin Opt Call | US Gas Fin Opt   NYMEX        EC9.0      Mar01           USD/MM-L |  | 100 |  | MMBtu/Lots (Options) | United States Dollar | 1.235 | ADM32017 | MMAGGI | NG-Price | N | Enron North America Corp. |  | TAGG | QK3903.1 | 75645 | 2001-03-01 00:00:00 | 2001-03-31 00:00:00
YESTERDAY
750210 | 2001-01-08 11:44:35 | Natural Gas Price (Non-Affiliate) | Natural Gas | US Gas Fin Swap | US Gas Swap      Nymex                   Mar01           USD/MM | 17500 |  |  | MMBtu | United States Dollar | 9.005 | MMAGGI | JARNOLD | NG-Price | Y | Enron North America Corp. |  | TAGG |  | 11360 | 2001-03-01 00:00:00 | 2001-03-31 00:00:00
750243 | 2001-01-08 11:58:47 | Natural Gas Price (Non-Affiliate) | Natural Gas | US Gas Fin Swap | US Gas Swap      Nymex                   Mar01           USD/MM | 17500 |  |  | MMBtu | United States Dollar | 9.02 | MMAGGI | JARNOLD | NG-Price | Y | Enron North America Corp. |  | TAGG |  | 11360 | 2001-03-01 00:00:00 | 2001-03-31 00:00:00
750297 | 2001-01-08 12:07:35 | Natural Gas Price (Non-Affiliate) | Natural Gas | US Gas Fin Swap | US Gas Swap      Nymex                   Mar01           USD/MM |  | 17500 |  | MMBtu | United States Dollar | 9.05 | MMAGGI | JARNOLD | NG-Price | Y | Enron North America Corp. |  | TAGG |  | 11360 | 2001-03-01 00:00:00 | 2001-03-31 00:00:00
Spreadsheet: 721259d1614612602-turn-numbers-into-positive-negative-then-average-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | MANUAL |  |  |  | DATA
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | y
 |  |  |  |  |  |  |  |  |  |  |  |  | text | text
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | y
 |  |  |  |  |  |  |  | result:
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | y
 |  |  | BETTER?
 |  |  |  |  |  |  |  |  |  |  |  |  | text
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | y
 |  |  |  |  |  |  |  |  |  |  |  |  |  | text
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | n
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | n
Spreadsheet: 761212d1640723251-need-formula-to-output-multiple-data-in-one-cell-from-workbook-copy-of-2022-reston-team-vacation-calendar
Sheet: Murdock

Employee Name: |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flex Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Personal Business
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carryover Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purchased Days |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vac | Flex | Sick | PB | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOURS | HOURS | HOURS | HOURS | Days
 | 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 | Taken | Taken | Taken | Taken | Taken
Jan |  |  | H
Feb
Mar
April
May |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
June
July |  |  |  | H
Aug
Sept |  |  |  |  | H
Oct
Nov |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
Dec |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subtotals:
Categories |  |  |  | Symbols to Enter |  |  |  |  | Notes:
Vacation HOURS |  |  |  | (# of hours)V |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining Time:
Sick HOURS |  |  |  | (# of hours)S |  |  |  |  | 2
[NAME] |  |  |  | (# of hours)FH |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining Days:
Personal Business |  |  |  | (# of hours)PB |  |  |  |  | 4
Other Days |  |  |  |  |  |  |  |  | 5
Funeral DAYS |  |  |  | FL |  |  |  |  | 6
Leave DAYS |  |  |  | L |  |  |  |  | 7
Other DAYS |  |  |  | O |  |  |  |  | 8
Half Funeral DAYS |  |  |  | HFL |  |  |  |  | 9
Half Leave DAYS |  |  |  | HL |  |  |  |  | 10
Half Other DAYS |  |  |  | HO
[NAME] |  |  |  | VTO |  |  |  | 1 Volunteer Time Off Day allowed
Spreadsheet: rick_buy__32843__Summary Oct 08
Sheet: summary 0924

SUMMARY BY WEEK FOR  09/04-09/07
TOTAL ISSUES
Category |  | Description
A |  | Deal Capture |  |  |  |  |  |  |  | 2
B |  | Deal Valuation |  |  |  |  |  |  |  | 1
C |  | Breakdown in Officializing Process- Human
D1 |  | Breakdown in Officializing Process- IT (UK) |  |  |  |  |  |  |  | 4
D2 |  | Breakdown in Officializing Process- IT (US)
E |  | Curve Issues
F |  | Uncontrollable-System Needs to Change
G |  | Miscellaneous |  |  |  |  |  |  |  | 3
H |  | Not identified
Breakdown By Group |  |  |  |  |  |  |  | # of Issues |  | Biggest Problem
EIM
EGM
EEL |  |  |  |  |  |  |  | 8
EA-CAN
EA - GAS
EA - POWER
EES
EBS
Other |  |  |  |  |  |  |  | 1
TOTAL ISSUES
Spreadsheet: 835652d1688700521-looking-to-count-months-dependent-of-factors-in-other-cells-2023-log
Sheet: Totals

Number of Files Received
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
EA
IA
LoGS Ext.
RM
SM
SM / IA
Totals
Number of Files Processed
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
EA
IA
LoGS Ext.
RM
SM
SM / IA
Totals
Spreadsheet: 08a17671-afd5-456b-8c25-7e2ea205cb6f
Sheet: Sheet1

PEKN Purchase Request Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
P.O. #: |  |  |  |  | Professor:
Supplier: |  |  |  |  | Account #:
Date: |  |  |  | Order requested by:
 |  |  |  | Contact Ext. #
Source cheaper supplier?
 |  |  |  |  | Price
Item No. | Catalogue No. | Description |  | Quantity | Each | Total | Availability
1
2
3
4
5
6
7
8
9
10
 |  |  |  |  |  | 0
 |  | Date ordered
 | Contact Name or [NAME]
 | Confirmation # |  |  | Signature
Additional Charges (Dry Ice, Shipping etc.)
Spreadsheet: 719315d1613616694-possible-indirect-function-needed-or-any-feasible-method-indirect-match-other-sheets
Sheet: 48-000046549

Client ID | Client Name | Account | Name | Group Name | Invoice No | Description Total | Charge Type | Random | Random | Random | Random | Random | Random | Random | Random | Random | CCY | Invoice Charge
48 | Example | 64597987000 | Example |  | 46549 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | USD | 781115.46
48 | Example | 0046-997897658 | Example |  | 467989 | Surcharge |  |  |  |  |  |  |  |  |  |  | USD | 5.87
Spreadsheet: 357236d1415348410-need-to-filter-top-10-and-ignor-hidden-values-efb
Sheet: Sheet1

 | class 1 | class 2 |  | Result
 | alpha | 94
 | delta | 90
 | alpha | 73
 | [NAME] | 69
 | [NAME] | 59
 | delta | 56
 | kilo | 53
 | delta | 45
 | delta | 30
 | delta | 29
 | [NAME] | 13
 | alpha | 1
 | delta | -2
 | alpha | -7
 | [NAME] | -18
 | alpha | -19
 | delta | -25
 | alpha | -30
 | delta | -41
 | alpha | -45
 | delta | -61
 | kilo | -61
 | delta | -65
 | delta | -76
 | Total
Spreadsheet: daren_farmer__5594__HPLN1122
Sheet: Sheet1

HPLN1122.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - November 22, 2000
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-11-22 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 0 | 0
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | HPL | 30 | 30
Enron (S) |  | LS HPL [NAME] |  | HPL | 30 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 771955d1646931712-vba-how-to-automatically-update-data-range-in-a-chart-jubingge-automatically-update-range
Sheet: Sheet1

 | Start year | 2016
 | End year | 2021
Chart Data
sales
cost
profits
Source Data
sales | 250 | 220 | 300 | 220 | 340 | 250 | 220 | 200
cost
profits
Spreadsheet: 214449d1360920628-interest-calculator-for-unequal-monthly-installment-sample-attached-parv
Sheet: Sheet1

Rate of Interest |  | 0.12
Month | MI | Total Interest | Principal
1 | 2500
2 | 5000
3 | 3500
4 | 4000
5 | 3000
6 | 3200
7 | 4600
8 | 5500
9 | 6600
10 | 4100
11 | 2800
12 | 3700
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: AUSTRALIA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 851795d1701932609-need-help-with-adding-multiple-leaves-for-an-employee-employee-attendance-record-2023
Sheet: Company Holidays

 | Company holidays
 | Company holidays | Description
 |  | New Year's Day
 |  | Eid-Ul-Fitr
 |  | Eid-Ul-Fitr
 |  | Eid-Ul-Fitr
 |  | Eid-Ul-Fitr
 |  | [NAME]
 |  | Eid-Ul-Adha
 |  | Eid-Ul-Adha
 |  | Eid-Ul-Adha
 |  | [NAME]
 |  | Rabi-Al-Awwal
 |  | UAE National Day
 |  | UAE National Day
 |  | UAE National Day
Spreadsheet: 677847d1589553630-conditional-format-on-timeline-not-working-right-project-planner-2-
Sheet: ProjectPlan

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [42]
 |  |  |  | Project Start: | 2020-01-02 00:00:00
 |  |  |  | Display: | Monthly
 |  |  |  | Display Period: | 1
 | TASK DESCRIPTION | [NAME] TO | [NAME] | STATUS | INITIATE START | INITIATE END | DEFINE & DESIGN START | DEFINE & DESIGN END | BUILD & DELIVER START | BUILD & DELIVER END | CLOSURE START | CLOSURE END | ACTUAL START | ACTUAL END | ACTUAL DAYS
 | Contract Management Platform
 | Contract Management Platform | BOB |  | LIVE | 2020-01-10 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | 2020-08-19 00:00:00 | 2020-08-20 00:00:00 | 2020-10-06 00:00:00 | 2020-10-07 00:00:00 | 2020-12-20 00:00:00 | 2020-01-10 00:00:00 | 2020-12-20 00:00:00
 | DATA ENANBLERS PROGRAMME
 | Data Visualisation (Discovery) | TOM |  | HOLD
 | Data Governance (Implementation) | GEOFF |  | LIVE
Spreadsheet: 150074d1334268097-consolidate-text-example
Sheet: Month

Day | Program | Category | Task | Note
1 | Ian | FSA | Scrub on MT | Worksheet from Linda Z
1 | Ian | Database | PI Reports
1 | [NAME] | Purchase Card | Reconciliation
2 | [NAME] | Post Inspection | PSO Report | Quarterly
2 | Ian | Database | PI Insp Reports
2 | Ian | FSA | Pre-Mist Updates
3 | Greg | Work Order | Outstanding Report | 6 months
3 | Ian | Database | Meeting for Review
3 | [NAME] | Posts | Update on Posts Times
3 | Ian | FSA | Scrub Ut
Spreadsheet: 844595d1696362076-if-cell-contains-a-formula-then-return-formula-but-if-it-has-a-number-then-return-amount-amount-formula
Sheet: Sheet1

Amount/Formula | 2016
amount | 36
amount | 56
formula
amount | 63
amount | 25
amount | 36
formula
formula
Amount/Formula | 2016
 | 36
 | 56
 | 92
 | 63
 | 25
 | 36
 | 124
 | 216
Spreadsheet: 801896d1666462638-conditional-formatting-based-on-multiple-criteria-muke41-bsb-
Sheet: Sheet1

Date | Date+28 | Data
2022-09-01 00:00:00
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
 |  | x
Spreadsheet: 114205d1310007090-merging-two-worksheets-and-setting-a-migration-date-missingnumbers
Sheet: Sheet1

First List |  | List of all 100 | Vlookup
1 |  | 9 |  | <<[NAME] and sort
2 |  | 22
3 |  | 40
4 |  | 56
5 |  | 80
6 |  | 100
7 |  | 99
8 |  | 98
10 |  | 97
11 |  | 96
12 |  | 95
13 |  | 94
14 |  | 93
15 |  | 92
16 |  | 91
17 |  | 90
18 |  | 89
19 |  | 88
20 |  | 87
21 |  | 86
23 |  | 85
24 |  | 84
25 |  | 83
26 |  | 82
27 |  | 81
28 |  | 79
29 |  | 78
30 |  | 77
31 |  | 76
32 |  | 75
33 |  | 74
34 |  | 73
35 |  | 72
36 |  | 71
37 |  | 70
38 |  | 69
39 |  | 68
41 |  | 67
42 |  | 66
43 |  | 65
44 |  | 64
45 |  | 63
46 |  | 62
47 |  | 61
48 |  | 60
49 |  | 59
50 |  | 58
51 |  | 57
52 |  | 55
53 |  | 54
54 |  | 53
55 |  | 52
57 |  | 51
58 |  | 50
59 |  | 49
60 |  | 48
61 |  | 47
62 |  | 46
63 |  | 45
64 |  | 44
65 |  | 43
66 |  | 42
67 |  | 41
68 |  | 39
69 |  | 38
70 |  | 37
71 |  | 36
72 |  | 35
73 |  | 34
74 |  | 33
75 |  | 32
76 |  | 31
77 |  | 30
78 |  | 29
79 |  | 28
81 |  | 27
82 |  | 26
83 |  | 25
84 |  | 24
85 |  | 23
86 |  | 21
87 |  | 20
88 |  | 19
89 |  | 18
90 |  | 17
91 |  | 16
92 |  | 15
93 |  | 14
94 |  | 13
95 |  | 12
96 |  | 11
97 |  | 10
98 |  | 8
99 |  | 7
100 |  | 6
 |  | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
Spreadsheet: 694979d1599931427-sumproduct-formula-test
Sheet: Rank Summary

Players
a
Covid-20
DDStacks
Eastcoast007
Ethan14
FatStack
[NAME]
hayward13
Justaaz
KRoke
Lucky
Mary_G1
Sara
Spillie1
Sunshine23
Whip-it
b
c
d
e
f
g
h
i
j
k
l
m
n
Spreadsheet: 174354d1345035354-population-of-excel-calendar-from-a-list-multiple-entries-on-one-day-calendar-template-1
Sheet: Sample

 | 2011-01-01 00:00:00
 | 1
Spreadsheet: 756543d1637621366-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: Hours

Name | MON | TUE | WED | THU | FRI | SAT | SUN
[NAME] | 7.5 | 7.5 | 7.5 | 8.5 | 8.5 | 8.5 | 5.5
SCOTT | 6 | 6 | 6 | 6 | 6 | 6 | 5.5
ADAM | 7 | 7 | 7 | 7 | 7 | 7 | 5.5
SEAN | 7.5 | 7.5 | 7.5 | 8.5 | 8.5 | 8.5 | 5.5
Spreadsheet: 877099d1723775633-array-search-using-multiple-criteria-by-row-and-column-headings-xlookup-in-array-table-with-error-handling-
Sheet: Sheet1

Size | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4
100x25 | 1692 | 1456 | 980 | 824
100x33 | 1585 | 1364 | 1025 | 876
100x38 | 1866 | 1550 | 1014 | 856
103x25 | 1789 | 1456 | 1028 | 816
125x25 | 1789 | 1456 | 1024 | 816
125x33 | 1576 | 1528 | 1025 | 883
125x38 | 2367 | 1690 | 1055 | 897
150x25 | 1923 | 1582 | 1024 | 816
150x33 | 1576 | 1528 | 1025 | 883
150x38 | 2367 | 1690 | 1055 | 897
175x25 | 1920 | 1572 | 1032 | 858
175x33 | 1578 | 1529 | 1023 | 884
175x38 | 2368 | 1690 | 1057 | 898
200x25 | 1920 | 1572 | 1032 | 858
200x33 | 1578 | 1529 | 1023 | 884
200x38 | 2368 | 1690 | 1057 | 898
250x25 | 1920 | 1650 | 1543 | 1543
50x25 | 1692 | 1456 | 980 | 824
50x38 | 1866 | 1550 | 1014 | 856
[NAME] | 1680 | 1478 | 992 | 816
75x38 | 2367 | 1690 | 1055 | 897
[NAME]
Supplier: | Supplier 7
[NAME]: | 250x25
Value |  | <<< Here is your formula…
I need a formula to retrieve the resulting price of: ($B$30 = Row1) & ($B$31 = ColumnA) resulting in a match within the array for "Supplier 4" & "150x38" ===>>> returning the value 897
Spreadsheet: 90470d1290177233-using-solver-function-ayk8_data_version_1
Sheet: Book Boxes

 | Book Boxes
 | Title | Weight | Cost | Sale Price | Number of Books per Box | Profit per Book | Total Profit | Total Weight
 | [NAME], JK Rowling | 5 | 9 | 17
 | The Lord of the Rings, JRR Tolkien | 4 | 8 | 13
 | Chronicles of Narnia, CS Lewis | 3.5 | 7 | 11
 | A Series of Unfortunate Events, [NAME] | 3 | 6 | 9
 | [NAME] and the Chocolate Factory, [NAME] | 2.5 | 5 | 7
 | A Wrinkle in Time, [NAME] | 1 | 4 | 6
 | Total
 | ***20 books or less per box |  |  | ***Total weight must be equal to or less than 50 pounds
 | ***Three different authors must be in the box
 | ***Between 4 and 8 from each author must be in the box
Spreadsheet: andrea_ring__51__RFPloadinfo
Sheet: Sheet1

[NAME]
Facility: | Conover, NC |  |  |  | Facility: | Elkhart, Indiana
Utility: | Piedmont Natural Gas |  |  |  | Utility: | NIPSCO (Northern Indiana Public Service Co.)
Rate: | 103 Large General Service |  |  |  | Rate: | 338
Month | Dth |  |  |  | Month | Dth
2001-08-01 00:00:00 | 580 |  |  |  | Aug | 2680
2001-07-01 00:00:00 | 620 |  |  |  | July | 2530
2001-06-01 00:00:00 | 800 |  |  |  | Jun | 2715
2001-05-01 00:00:00 | 820 |  |  |  | May | 3020
2001-04-01 00:00:00 | 1625 |  |  |  | Apr | 3740
2001-03-01 00:00:00 | 4825 |  |  |  | Mar | 5365
2001-02-01 00:00:00 | 4420 |  |  |  | Feb | 5530
2001-01-01 00:00:00 | 5500 |  |  |  | Jan | 5780
2000-12-01 00:00:00 | 5650 |  |  |  | Dec | 5580
2000-11-01 00:00:00 | 3040 |  |  |  | Nov | 3450
2000-10-01 00:00:00 | 540 |  |  |  | Oct | 2650
2000-09-01 00:00:00 | 450 |  |  |  | Sep | 2440
Facility: | Russellville, KY
Utility: | Western Kentucky Gas Co.
Rate: | T-2
Month | Mcf
2001-08-01 00:00:00 | 6600
2001-07-01 00:00:00 | 6450
2001-06-01 00:00:00 | 8135
2001-05-01 00:00:00 | 8325
2001-04-01 00:00:00 | 8900
2001-03-01 00:00:00 | 13090
2001-02-01 00:00:00 | 12580
2001-01-01 00:00:00 | 15370
2000-12-01 00:00:00 | 16050
2000-11-01 00:00:00 | 12100
2000-10-01 00:00:00 | 10750
2000-09-01 00:00:00 | 8570
Spreadsheet: 838134d1690767693-headcount-of-people-in-unit-headcount-in-unit
Sheet: Sheet1

 | [NAME] | Departure |  | Date | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Person 1 | 2023-06-01 23:06:00 | 2023-06-02 05:10:00 |  | 2023-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
Person 2 | 2023-06-02 09:07:00 | 2023-06-05 13:18:00 |  | 2023-06-02 00:00:00 | 2 | 2 | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1
Person 3 | 2023-06-01 10:55:00 | 2023-06-02 02:15:00 |  | 2023-06-03 00:00:00
Person 4 | 2023-06-03 01:02:00 | 2023-06-03 12:20:00 |  | 2023-06-04 00:00:00
Person 5 | 2023-06-02 18:43:00 | 2023-06-06 15:00:00 |  | 2023-06-05 00:00:00
Person 6 |  |  |  | 2023-06-06 00:00:00
Person 7 |  |  |  | 2023-06-07 00:00:00
Person 8 |  |  |  | 2023-06-08 00:00:00
Person 9 |  |  |  | 2023-06-09 00:00:00
Person 10 |  |  |  | 2023-06-10 00:00:00
Person 11 |  |  |  | 2023-06-11 00:00:00
Person 12 |  |  |  | 2023-06-12 00:00:00
Person 13 |  |  |  | 2023-06-13 00:00:00
Person 14 |  |  |  | 2023-06-14 00:00:00
Person 15 |  |  |  | 2023-06-15 00:00:00
Person 16 |  |  |  | 2023-06-16 00:00:00
Person 17 |  |  |  | 2023-06-17 00:00:00
Spreadsheet: 0dd58f3e-7d13-45b3-a09f-490e8ba0c07b
Sheet: Sheet1

City of Albuquerque | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Vendor E-Pay Payment Form
I here by authorize the CITY OF ALBUQUERQUE to initiate Accounts Payable payments through
their Corporate Credit Card program (E-Payables)
 |  |  |  |  | *Required Informaton
VENDOR INFORMATION
NEW: |  |  |  |  | UPDATED:
COMPANY/ORGANIZATION  NAME: |  |  |  |  |  |  |  |  | *
COMPANY/ORGANZIATION PHONE: |  |  |  |  |  |  |  |  | *
COMPANY ADDRESS: |  |  |  |  |  |  |  |  | *
CITY / STATE |  |  |  |  |  |  |  |  | *
ZIP CODE |  |  |  |  |  |  |  |  | *
CARD HOLDER NAME (PRINT): |  |  |  |  |  |  |  |  | *
CARD HOLDER PHONE: |  |  |  |  |  |  |  |  | *
CARD HOLDER EMAIL: |  |  |  |  |  |  |  |  | *
AUTHORIZED [NAME] (PRINT): |  |  |  |  |  |  |  |  | *
AUTHORIZED SIGNATURE: |  |  |  |  |  |  |  |  | *
PHONE NUMBER: |  |  |  |  |  |  |  |  | *
TITLE: |  |  |  |  |  |  |  |  | *
DATE: (MM/DD/YYYY): |  |  |  |  |  |  |  |  | *
ADDITIONAL EMAIL ADDRESS:
ADDITONAL EMAIL ADDRESS:
PLEASE RETURN THE ORIGINAL E-PAY FORM DIRECTLY TO THE ADDRESS BELOW TO
INITIATE PROCESSING SET UP YOU WILL BE ESTABLISHED AS AN E-PAY VENDOR AND
PAYMENTS WILL BE MADE VIA YOUR CORPORATE CREDIT CARD UPON COMPLETION OF
THE BANK VERIFICATION PROCESS. (POSTING TO YOUR ACCOUNT 48 HOURS FROM DATE
OF TRANSFER
Questions regarding this form of your E-Pay transactions should be directed to the Accounts
Payable department at the address/number below:
DFAS Accounts Payable Office
City of Albuquerque |  |  |  |  | Phone: | (505) 768-3471
PO Box 1985 |  |  |  |  | Fax: | (505) 768-6476
Albuquerque, NM  87103 |  |  |  |  | E-Mail: | [EMAIL]