tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 124638d1318520251-formula-for-increasing-cost-per-unit-world-war
Sheet: Extras

 |  | delta |  |  |  | [NAME]: | 235
-------------- | -------------- | 1 |  |  |  | [NAME] Units: | 1410
18540000 | [NAME] | 3 |  |  |  | Current Usable Units: | 1410
-------------- | -------------- | 6
-------------- | -------------- | 13
-------------- | -------------- | 30
-------------- | -------------- | 48
-------------- | -------------- | 120
-------------- | -------------- | 3
-------------- | -------------- | 3
-------------- | -------------- | 5
-------------- | -------------- | 7
741000000 | [NAME] | 11
-------------- | -------------- | 18
-------------- | -------------- | 22
-------------- | -------------- | 41
-------------- | -------------- | 86
Spreadsheet: 85087d1285156693-how-to-remove-unwanted-rows-on-multiple-worksheets-dummy
Sheet: Need to remove exclusions

Study number | Some more data
1 | dsa
2
3 | dbd
4
5 | dbd
6
7 | d
8 | b
9 | b
10 | b
11 | dbd
12 | r
13 | gg
14
15
16 | f
17 | gr
18 | h
19 | rhe
20 | e
21 | j
22 | j
23 | df
24 | d
25 | g
Spreadsheet: 773484d1647880269-max-if-function-across-several-sheets-testing-1-
Sheet: Week1

Name | Contact Date
A | 2021-03-15 00:00:00
G | 2021-03-15 00:00:00
F | 2021-03-15 00:00:00
A | 2021-03-15 00:00:00
G | 2021-03-15 00:00:00
F | 2021-03-15 00:00:00
A | 2021-03-15 00:00:00
G | 2021-03-15 00:00:00
F | 2021-03-15 00:00:00
A | 2021-03-15 00:00:00
G | 2021-03-15 00:00:00
F | 2021-03-15 00:00:00
A | 2021-03-15 00:00:00
G | 2021-03-15 00:00:00
F | 2021-03-15 00:00:00
A | 2021-03-15 00:00:00
G | 2021-03-15 00:00:00
F | 2021-03-15 00:00:00
A | 2023-07-12 00:00:00
G | 2021-03-15 00:00:00
Spreadsheet: 797461d1663902100-sum-working-hours-by-month-sum-working-hours-by-month-1-
Sheet: Sheet1

Employee Table - Can't Modify Structure |  |  |  | HOURS EACH RESOURCE BY MONTH
Name | Start Date | End Date |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Annelise Reside | 2022-01-01 00:00:00
[NAME] | 2022-02-25 00:00:00
[NAME] | 2022-01-01 00:00:00 | 2022-04-15 00:00:00
[NAME] | 2022-03-01 00:00:00
[NAME] | 2022-01-01 00:00:00 | 2022-01-15 00:00:00
[NAME] | 2022-01-01 00:00:00 | 2022-01-31 00:00:00
[NAME] | 2022-01-01 00:00:00 | 2022-06-01 00:00:00
[NAME] | 2022-05-15 00:00:00
Orton Timbrell | 2022-01-01 00:00:00
[NAME] | 2022-09-01 00:00:00
 |  |  | TOTAL
 |  |  |  | << each cell value is determined by getting the working days for the month only for the days the employee was employed during that month
Company Holidays |  |  |  | << for example, =NETWORKDAYS(start,end,Holidays)*8 would be used to calculate the working hours in the month for each employee
2022-01-01 00:00:00 | New Year's Day |  |  | << Some employees didn't work at all during a month, hence zeros
2022-05-30 00:00:00 | Memorial Day |  |  | << Some employees worked the entire month so it's straight math between the start of the month and end
2022-07-04 00:00:00 | Independence Day |  |  | << other employees work part of the month - see "Chick"
2022-11-24 00:00:00 | Thanksgiving
2022-12-26 00:00:00 | Christmas Day |  |  | I'd like a single formula that calculates the working hours between
 |  |  |  | the each employee's eligible working time during the month
 |  |  |  | and SUMS the total hours
 |  |  |  | DESIRED OUTCOME
 |  |  |  |  | MONTH | HOURS | HD
 |  |  |  |  | 2022-01-01 00:00:00 | 920
 |  |  |  |  | 2022-02-01 00:00:00 | 656 | 656
 |  |  |  |  | 2022-03-01 00:00:00 | 1104 | 1104
 |  |  |  |  | 2022-04-01 00:00:00 | etc. | 928
 |  |  |  |  | 2022-05-01 00:00:00 |  | 928
 |  |  |  |  | 2022-06-01 00:00:00 |  | 888
 |  |  |  |  | 2022-07-01 00:00:00 |  | 800
 |  |  |  |  | 2022-08-01 00:00:00 |  | 920
 |  |  |  |  | 2022-09-01 00:00:00 |  | 1056
 |  |  |  |  | 2022-10-01 00:00:00 |  | 1008
 |  |  |  |  | 2022-11-01 00:00:00 |  | 1008
 |  |  |  |  | 2022-12-01 00:00:00 |  | 1008
Spreadsheet: 4d261371-0b01-4fc3-9cb6-6519b9888d31
Sheet: Sheet1

Release: Regional and State Employment and Unemployment (Seasonally Adjusted) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=250
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-12-20 5:37 AM CST
 | Real-Time | Period
Name: | Start | End
Regional and State Employment and Unemployment (Seasonally Adjusted) | 2012-01-24 00:00:00 | Current
Link:
[NAME] | 2012-01-24 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2012-01-24 00:00:00 | Current
Notes:
Bureau of Labor Statistics data that is seasonally adjusted by the | 2012-01-24 00:00:00 | Current
Federal Reserve Bank of St. Louis.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-01-24 00:00:00
2012-03-13 00:00:00
2012-03-30 00:00:00
2012-04-20 00:00:00
2012-05-18 00:00:00
2012-06-15 00:00:00
2012-07-20 00:00:00
2012-07-23 00:00:00
2012-08-17 00:00:00
2012-09-21 00:00:00
2012-10-19 00:00:00
2012-11-20 00:00:00
2012-12-21 00:00:00
2013-01-18 00:00:00
2013-03-18 00:00:00
2013-03-29 00:00:00
2013-04-19 00:00:00
2013-05-17 00:00:00
2013-06-21 00:00:00
2013-07-19 00:00:00
2013-08-19 00:00:00
2013-09-20 00:00:00
2013-11-22 00:00:00
2013-12-20 00:00:00
Spreadsheet: 845342d1696874552-transferring-countifs-formulas-across-multiple-cells-with-changing-data-cr-data-example_3
Sheet: Shell Table Heparin

Characteristics | N or avg | std | [NAME] No | [NAME] Yes | P value | Ratio
Age
[NAME]
[NAME]
HTN
CAD
HLD
DM
PE
DVT
CKD
COPD
Smoker |  |  | 100
BMI
[NAME]
Spreadsheet: chris_germany__2895__Enron Supply - TGP
Sheet: Tenn

TGP SUPPLY FROM ENRON
From:  [NAME]  [PHONE]
To:  [NAME] ([EMAIL]), [NAME] ([EMAIL])
Phone:   [PHONE]  clarissa
Phone:  [PHONE]  [NAME]
Phone:  [PHONE] cindy
Fax:   [PHONE]
 |  |  | Tennessee
LDC | MTR # | CONFIRM | CONTRACT #
 |  |  |  | 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 | TOTAL
Bay State | 020193 | 711 | 2025 | 31 | 0
 |  |  | 31333 |  | 31 |  |  | 0 |  |  | 31 |  |  |  |  |  |  | 0
 |  |  | 21589 |  |  |  |  | 31 |  |  | 0
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 31
Berkshire | 020292 | 682 | 2025 | 50 | 0
 |  |  | 31333 |  |  | 50 |  | 0 |  |  | 50 | 40 |  |  |  |  |  | 0
 |  |  | 21589 |  |  |  |  | 50 |  |  | 0
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 40
Boston | 020118 | 680 | 2025 | 75 | 0 | 0
 |  |  | 31333 |  | 97 | 87 |  | 97 | 97 | 97 | 89 | 68 |  | 69 | 84 | 81 | 76 | 0
 |  |  | 21589
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | 73
Ct. Natural | 020205 |  |  | 0 | 0
No. Utilities | 020206 | 711 | 2025 | 353 | 0 |  |  |  |  |  | 0 | 0
 |  |  | 31333 |  | 353 |  |  | 0 |  |  | 353 |  |  |  |  |  |  | 0
 |  |  | 21589 |  |  |  |  | 353
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 353 | 353
So. Conn. | 020126 |  | 32295 | 571 | 0 |  |  |  |  |  | 0
 |  |  | 31237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 481 | 481
 |  |  | 32295 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 519 | 519
Yankee | 020125 |  |  | 0
Yankee | 020127 |  |  | 0
Spreadsheet: 799665d1665186930-if-function-to-find-out-original-order-and-than-number-the-duplicates-per-repeat-sample
Sheet: Raw

CLIENT REF 1 | CLIENT REF 2 | CLIENT ID | REQUESTOR | ORDER ID | FIRST NAME | LAST NAME | DOB | SSN | RECEIVE DATE | CLOSED DATE | POSITION APPLIED FOR | PACKAGE NAME | COMP TP | [NAME] | CATEGORY | MINOR | CHARGE | CHARGE TYPE | [NAME] | STATE | DISP DATE | HIT SCORE | ELEMENT SCORE | CASE SCORE | SOURCE NM | PROM SUBORDER NB | Month | Week Ending | UID | duplicate check | TAT
Spreadsheet: 884112d1733096533-making-an-automatic-on-call-board-recreation-of-the-on-call-board-automatic-2025-by-flameretired-version-2-wi-drop-downs-all-in-o
Sheet: January

 |  | January
 | 2024
 | [NAME]
 | [NAME]
 | Romo
 | [NAME]
 | Orlando
 | Nick
 | [NAME]
 | Zach
 | Pando
 | [NAME]
Spreadsheet: daren_farmer__5630__HPLN1215
Sheet: Sheet1

HPLN1215.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 15, 2000
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-15 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
HPL (FM) |  | LS HPL [NAME] |  | HPL | 0 | 0
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 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: 96976d1296208439-prevent-cells-selction-of-conditionally-formatted-hidden-cells-new-invoice-template
Sheet: Welcome Letter

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dear
Thank you for choosing to advertise with Search You.  You will find enclosed with this letter the following documents:
2. A copy of your order confirmation
The order confirmation shows the details that relate to your advertising, you should check these carefully. You will find our standard terms and conditions on the back of your order confirmation.
Below you will find the details that will allow you access and view your website tools once your site is live:
 |  |  |  |  |  | Content Management System |  |  |  |  |  |  |  |  |  |  |  |  |  | Analytics Platform
Web Address: |  |  |  |  |  | design.searchyou.co.uk |  |  |  |  |  |  |  |  |  |  |  |  |  | analytics.searchyou.co.uk
Username:
Password: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | traffic
Here are the details that will allow you to access and view your email account
Web Address:
Username:
Password:
We hope this covers everything but should you need to speak to any of the team please feel free to contact us between 9.00 am and 5.30 pm Monday to Friday on (0845) 582 9880.
Have a great year and we look forward to working with you during the next 12 months!
Yours sincerely,
Spreadsheet: 692689d1598509104-multiple-matches-in-drop-down-list-product-sample-2
Sheet: Master Data

Sr No | Brand | Product | Price
1 | ABC | ABC 10 packet | 10
2 | ABC | ABC 20 packet | 18
3 | ABC Pro | ABC Pro 15 packet | 12
4 | ABC Pro | ABC Pro 25 packet | 18
5 | ABC Pro | ABC Pro 30 packet | 20
6 | ABC Plus | ABC Plus 10 Tablet | 40
7 | ABC Plus | ABC Plus 20 Tablets | 70
8 | XYZ | XYZ 15 packet | 40
9 | DEF | DEF 10 Tablet | 80
10 | DEF | DEF 20 Tablet | 130
 |  |  |  |  |  | Brand and Product - One to many relationship For example - Single brand can be mapped to one or more products.
Spreadsheet: 698776d1602170557-combining-formulas-indirect-and-lookup-and-vlookup-excel-indirect-lookup
Sheet: Overview

 | App1 | App2 | App3 | App4 | App5 |  | English formula used in B2 & B3
Data1 |  | 6 | 6 | 4 | 5 |  | =INDIRECT(B1&"!B3")
Data2 |  | 8 | 3 | 3 | 5 |  | =LOOKUP(2;1/(1-ISBLANK('App1'!B:[NAME]:B)
Data3 | 3 | 8 | 6 | 5 | 3
Data4 | 6 | 6 | 6 | 4 | 3 |  | 15 different Applications (row 1)
Data5 | 6 | 4 | 0 | 4 | 4 |  | Each application have 20 data points (col 1)
Data6 | 5 | 3 | 5 | 4 | 4 |  | There is a sheet per application
Data7 | 3 | 2 | 5 | 3 | 4
Data8 | 3 | 5 | 3 | 2 | 4 |  | I would like to get the last value of Data1, Data2, Data3 per Application
Data9 | 4 | 6 | 3 | 1 | 4 |  | but to minimize manual correction of formula.
Data10 | 6 | 6 | 4 | 1 | 2
 |  |  |  |  |  |  | So goal is formula should pick something like formula in H2 to find right sheet
 |  |  |  |  |  |  | then use formula in H3 to get last cell (all numbers)
 |  |  |  |  |  |  | then use vlookup? to get data for Data1, Data2, Data3
 |  |  |  |  |  |  | How of this possible to combine into 1 formula which can be copied out to
 |  |  |  |  |  |  | each application & data set?
Spreadsheet: 115447d1311066349-budget-calc-help-2011budget
Sheet: September

2011 Budget
Payday |  |  |  |  | Amount
1st |  |  |  |  | 0
15th
Total Monthly
Expenses |  | Product |  |  | Amount |  | Paid? | Remainder
1st |  | Ring |  |  | 100 |  | False
 |  | Easynews |  |  | 15 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Verizon |  |  | 100 |  | False
 |  | Bi-Weekly Remainder
15th |  | Chase |  |  | 54 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Insurance |  |  | 120 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Bi-Weekly Remainder
Total Monthly
Total Remainder
Spreadsheet: 35448d1233055142-copying-hyperlinks-december-2008-excel-forum-daily-accts
Sheet: 3(a)

[NAME] по счетам группы компаний "Вагриус" |  |  |  |  |  |  | 3(a)
на начало дня 3 Декабря 2008 года
[NAME] компании | Без Нал. | Нал. | Сумма
[NAME] | 60000 | 0 | 60000 |  |  | [NAME] | A5 | B16 | C16 | F16
Вагриус книги | 60000 | 0 | 60000 |  |  | Вагриус книги | A20 | B32 | C32 | F32
Вагриус правда | 71286.7 | 0 | 71286.7 |  |  | Вагриус правда | A36 | B48 | C48 | F48
Вагриус минус | 0 | 0 | 0 |  |  | Вагриус минус | A52 | B64 | C64 | F64
Плюс-минус | 0 | 0 | 0 |  |  | Плюс-минус | A68 | B80 | C80 | F80
Издательство Вагриус | 0 | 0 | 0 |  |  | Издательство Вагриус | A84 | [NAME] | C96 | F96
Вагриус плюс-минус | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A100 | B112 | C112 | F112
Общий Итог: | 191286.7 | 0 | 191286.7 |  |  |  |  | B115 | C115 | F115
 |  |  |  |  |  | [NAME] | A122 | B134 | C134 | F134
 |  |  |  |  |  | Вагриус книги | A138 | B150 | C150 | F150
Фактические РАСХОДЫ по счетам группы компаний "Вагриус" |  |  |  |  |  | Вагриус правда | A154 | B166 | C166 | F166
на конец дня 3 Декабря 2008 года |  |  |  |  |  | Вагриус минус | A170 | B182 | C182 | F182
[NAME] компании | Без Нал. | Нал. | Сумма |  |  | Плюс-минус | A186 | B198 | C198 | F198
[NAME] | 0 | 0 | 0 |  |  | Издательство Вагриус | A202 | B214 | C214 | F214
Вагриус книги | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A218 | B230 | C230 | F230
Вагриус правда | 72835.65 | 0 | 72835.65 |  |  |  |  | B233 | C233 | F233
Вагриус минус | 0 | 0 | 0
Плюс-минус | 0 | 0 | 0
Издательство Вагриус | 0 | 0 | 0
Вагриус плюс-минус | 0 | 0 | 0
Общий Итог: | 72835.65 | 0 | 72835.65
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 |  |  | -218
2 |  |  | -105
3 |  |  | -155
4 |  |  | -323
5 |  |  | -385
6 |  |  | -239
7 |  |  | -142
8 |  |  | -161
9 |  |  | -402
10 |  |  | -1692
11 |  |  | -1051
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  | 152234.63
2002-02-11 00:00:00
CBS Volume
 |  |  | -368359
Spreadsheet: 744854d1629486301-place-result-of-ifs-function-on-a-different-worksheet-example2
Sheet: Sheet1

reason | # | Vendor name | Description. | Catergory | length
1 | 275 | Excel | Excelsoftware | S
2 | 572 | Excel | ExcelsoftwareXl | B | 16
3 | 364 | Excel | [NAME] | K | 16
4 | 463 | Excel | [NAME] | p | 16
 |  | Excel | ExcelsoftwareXl | B
 |  | Excel | Excelsoftware | S
 |  | Excel | ExcelsoftwareXl | B
 |  | Excel | [NAME] | B
 |  | Excel | Excelsoftware | S
 |  | Excel | [NAME] | K
 |  | Excel | ExcelsoftwareXl | B
 |  | Excel | [NAME] | B
 |  | Excel | [NAME] | K
 |  | Excel | Excelsoftware | S
 |  | Excel | [NAME] | K
 |  | Excel | [NAME] | K
 |  | Excel | ExcelsoftwareXl | B
 |  | Excel | [NAME] | B
 |  | Excel | Excelsoftware | S
 |  | Excel | [NAME] | B
 |  | Excel | ExcelsoftwareXl | B
 |  | Excel | [NAME] | K
 |  | Excel | Excelsoftware | S
 |  | Excel | [NAME] | B
 |  | Excel | ExcelsoftwareXl | B
 |  | Excel | [NAME] | K
 |  | Excel | Excelsoftware | S
 |  | Excel | [NAME] | B
 |  | Excel | ExcelsoftwareXl | K
 |  | Excel | [NAME] | B
 |  | Excel | [NAME] | K
 |  | Excel | Excelsoftware | S
 |  | Excel | [NAME] | B
 |  | Excel | ExcelsoftwareXl | B
 |  | Excel | Excelsoftware | S
 |  | Excel | Excelsoftware | S
 |  | Excel | Excelsoftware | S
 |  | Excel | Excelsoftware | S
 |  | Excel | Excelsoftware | S
 |  | Excel | ExcelsoftwareXl | K
Spreadsheet: 759339d1639497817-return-multiple-sheet-names-in-different-fields-multiple_sheets_array
Sheet: Summary

Sheetlist | item | Type | Count | Found in Sheets
Sheet1 | BEAM01
Sheet2 | BEAM02
Sheet3 | BEAM03
Sheet4 | BEAM04
Sheet5 | BEAM06
 | Deskt01
 | Deskt02
 | Deskt03
 | Deskt04
 | Deskt05
 | DoST01
 | DoST02
 | DoST03
 | DoST04
 | DoST05
 | DoST06
Spreadsheet: 850768d1701141975-drop-down-list-to-select-rows-must-also-include-all-edpivco-sample-216-aligw
Sheet: Sheet1

Name | Score | Teacher | Filter Index |  |  | Teacher | Jones
[NAME] | 1 | Jones
[NAME] | 2 | Smith
[NAME] | 3 | Jones |  |  |  |  |  |  | Note: This solution accommodates up to 50 result rows.
 |  |  |  |  |  |  |  |  | To extend it, fill the formula down more rows.
Spreadsheet: 758986d1639216364-how-to-compute-interest-for-90day-cycle-data-entry_help-2-
Sheet: DATA ENTRY

 |  |  |  |  | totals
 |  |  |  |  |  | 90 | 180 | 270 | 360 |  |  |  |  |  |  |  | interest | 0.01
BAL FWD | TRANS DATE | INTEREST | DEPOSIT | WITHDRAWAL | BALANCE | interest 90 | interest 180 | interest 270 | interest 360 | Sum |  | direct 1% | lowest value 90 days | lowest value 180 days | lowest value 270 days
7413.28 | 2021-01-07 00:00:00 |  | 0 | 0
 | 2021-01-07 00:00:00 |  |  | 2000
 | 2021-01-25 00:00:00 |  |  | 3043.84
 | 2021-02-04 00:00:00 |  |  | 1500
 | 2021-02-26 00:00:00 |  |  | 500
 | 2021-03-31 00:00:00 |  | 21.31 | 4.26
 | 2021-05-10 00:00:00 |  | 35000
 | 2021-05-24 00:00:00 |  |  | 5000
 | 2021-05-28 00:00:00 |  |  | 4000
 | 2021-05-31 00:00:00 |  |  | 5000
 | 2021-06-03 00:00:00
 | 2021-06-09 00:00:00 |  |  | 1500
 | 2021-06-22 00:00:00 |  |  | 3000
 | 2021-07-09 00:00:00 |  |  | 3000
 | 2021-07-13 00:00:00 |  |  | 2500
 | 2021-07-16 00:00:00 |  |  | 7000
 | 2021-07-21 00:00:00 |  |  | 1000
 | 2021-08-24 00:00:00 |  |  | 1500
 | 2021-11-23 00:00:00 |  | 12000
 | 2021-12-02 00:00:00 |  |  | 2000
Spreadsheet: 694644d1599734331-multiply-a-vlookup-by-exchange-rate-with-different-rates-excel-forums-example
Sheet: The Peoples Union

1 | Ally Financial Inc. | ALLY
5 | BancorpSouth Bank | BXS
12 | Byline Bancorp, Inc. | BY
30 | Great Western Bancorp, Inc. | GWB
1 | 1895 Bancorp of Wisconsin, Inc. | BCOW
22 | Bank OZK | OZK
2 | 1st Source Corporation | SRCE
21 | Bank of the James Financial Group, Inc. | BOTJ
23 | Bank7 Corp. | BSVN
119 | Hancock Whitney Corporation | HWC
201 | Red River Bancshares, Inc. | RRBI
35 | Cambridge Bancorp | CATC
135 | IBERIABANK Corporation | IBKC
113 | Glacier Bancorp, Inc. | GBCI
33 | KeyCorp | KEY
Spreadsheet: 882589d1730977289-multiple-lookup-and-return-date-time-value-sample-sheet
Sheet: Sheet2

 |  | Sub Supplier/Shipped Date
 | [NAME] | Atr001 | Atr002 | Atr003 | Atr004 | Atr005 | Atr006 | Atr007 | Atr008 | Atr009 | Atr010 | Atr011 | Atr012 | Atr013 | Atr014 | Atr015
 | Atr001 |  | 2024-10-25 11:50:00
 | Atr002
 | Atr003
 | Atr004
 | Atr005
 | Atr006
 | Atr007
 | Atr008
 | Atr009
 | Atr010
 | Atr011
 | Atr012
 | Atr013
 | Atr014
 | Atr015
 |  |  | I need to search down Column B and across Row 4 and where the data matches, return the corresponding date and time information
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Oct28-Nov3p

Pavilion
 | 2012-10-28 00:00:00 |  |  | Thru | 2012-11-03 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-10-28 00:00:00 | 2012-10-29 00:00:00 | 2012-10-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-01 00:00:00 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 687028d1594918327-if-function-help-needed-example-etaf
Sheet: Calculator

 | Agent [NAME] | al1 |  | Guild agent?
 | Region |  |  | TPFG agent?
 |  |  |  |  |  |  |  |  | Scott | 0 | Associate
 | Number of branches | 4 |  |  |  |  |  |  | Scott | 15 | AM
 | Amount of stock | 200 |  |  |  |  |  |  | Scott | 31 | KAM
 | Average stock per branch |  |  |  |  |  |  |  | [NAME] | 0 | Associate
 |  |  |  |  |  |  |  |  | [NAME] | 21 | AM
 |  |  |  |  |  |  |  |  | [NAME] | 40 | KAM
 |  | BDM
 |  | KAM
 |  | AM |  |  | The only thing I want to change is if I populate F3 or F4 to say an agent is either [NAME] or TPFG it overwrites the AM allocated in D18. So if an agent is [NAME] the AM should be Rachel/Adam and if an agent is TPFG the AM is Jade. If neither of these apply and so the boxes are left empty the formula that's already in there should apply.
Spreadsheet: dan_hyvl__4713__Cross Timbers Master Physical 01092001
Sheet: ANEWSWP2

Master Firm Purchase/Sale Agreement
 |  | ATTORNEY:
DATE: | 2001-01-09 00:00:00 | DEAL MAKER: | [NAME]
COUNTERPARTY: | Cross Timbers Oil Company | CONTACT: | Mr. [NAME]
ADDRESS: | 810 Houston Street | TITLE:
 | Suite 2000 | PHONE:
 | Fort Worth, TX 76102-6298 | FAX:
Incorporation State |  | S&P Rating | BB-
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 30
Incorporation State
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | 15000000 | 25000000
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change
-Below = S&P/Moody's | BB- | BBB-
Financial Covenants
-Funded debt/Worth | > 2:1
-Minimum Net Worth
-EBITDA/Interest | < 2:1
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | $10MM
-Guarantor ($[NAME]) |  | $100MM
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER TERMS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923