tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50a435ec-4609-4b19-b6a1-f0ee3c30fc51
Sheet: Hepatocyte_Model_Regulation

Regulation |  | R49 | R51 | R52 | R54 | R55 | R57 | R61 | R62 | R63 | [NAME] | R65 | R82 | R86 | R87 | R129 | R137 | R138 | R144 | R145
ATP | C00002 | 0 | -1 | -1 | -1 | 0 | -1 | 0 | 0 | -1 | 1 | -1 | -1 | 0 | 0 | 0 | 1 | -1 | 0 | 0
NADH-M | C00004-M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NADPH | C00005 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | -1 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NADP+ | C00006 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ADP | C00008 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | -1 | 1 | -1 | 0 | 0
AMP | C00020 | 0 | 1 | 0 | 0 | 0 | -1 | -1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Acetyl CoA-M | C00024-M | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 1 | 0 | 0 | 0 | 0 | 0
L-Alanine | C00041 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Glutathione | C00051 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0
[NAME] | C00073 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
Succinyl-CoA-M | C00091-M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
L-Cysteine | C00097 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
[NAME] | C00103 | 0 | -1 | -1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ribose 5 Phosphate | C00117 | 0 | -1 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GSSG | C00127 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Citrate-M | C00158-M | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cholesterol | C00187 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
Palmitate | C00249 | 0 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Glucose | C00267 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
D-Erythrose 4 Phosphate | C00279 | 0 | -1 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Glucose-6 Phosphate | [NAME] | 0 | -1 | -1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Beta-D-Fructose 6 Phosphate | C05345 | -1 | -1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fructose 1,6,Bisphosphate | C05378 | 0 | 0 | 0 | 1 | 0 | 0 | -1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 92755d1292313736-creating-a-multi-criteria-drop-down-temp2
Sheet: Sheet1

Program Name | Sales Value |  | Inventory Value |  | Impact on Product or Service quality |  | Impact on financial statement & reporting |  | Impact on Brand & market reputation
 | Criteria | Rating | Criteria | Rating | Criteria | Rating | Criteria | Rating | Criteria | Rating
Protection of Information Assets |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | Marginal | 1
Budgeting & Management reporting |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | Low | 2
Intellectual property |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | Medium | 3
Mobile phone policy & payments |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | High | 4
Revenue |  |  |  |  |  |  |  |  |  |  |  | Impact on financial statement & reporting | Extreme | 5
Fixed Assets |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | Marginal | 1
 |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | Low | 2
 |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | Medium | 3
 |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | High | 4
 |  |  |  |  |  |  |  |  |  |  |  | Impact on Product or Service quality | Extreme | 5
 |  |  |  |  |  |  |  |  |  |  |  | Inventory Value | > 1 mio < 2 mio | 1
 |  |  |  |  |  |  |  |  |  |  |  | Inventory Value | > 2 mio < 3 mio | 2
 |  |  |  |  |  |  |  |  |  |  |  | Inventory Value | > 3 mio < 5 mio | 3
 |  |  |  |  |  |  |  |  |  |  |  | Inventory Value | > 5 mio | 4
 |  |  |  |  |  |  |  |  |  |  |  | Sales Value | > 1 mio < 2 mio | 1
 |  |  |  |  |  |  |  |  |  |  |  | Sales Value | > 2 mio < 3 mio | 2
 |  |  |  |  |  |  |  |  |  |  |  | Sales Value | > 3 mio < 5 mio | 3
 |  |  |  |  |  |  |  |  |  |  |  | Sales Value | > 5 mio | 4
Spreadsheet: 810476d1671796056-autonumber-with-concatenate-issue-with-filter-ef_examp
Sheet: Incoming Shipments

Status | Transport # | HOW IT SHOULD STAY | Supplier | CRD | CRDYEAR | ETD | ETA
 |  | USB-I2023-1 | ASM | 2023-01-30 00:00:00 |  |  | 2023-01-15 00:00:00
New |  | USB-I2023-7 | AZT | 2023-02-20 00:00:00 |  |  | 2023-01-15 00:00:00
 |  | USB-I2023-2 | CFI | 2023-02-01 00:00:00 |  |  | 2023-01-16 00:00:00
New |  | USB-I2023-3 | CHIY | 2023-02-06 00:00:00 |  |  | 2023-01-17 00:00:00
 |  | USB-I2023-4 | CFI | 2023-02-06 00:00:00 |  |  | 2023-01-17 00:00:00
 |  | USB-I2023-5 | COAL | 2023-02-10 00:00:00 |  |  | 2023-01-18 00:00:00
New |  | USB-I2023-6 | [NAME] | 2023-02-17 00:00:00 |  |  | 2023-01-20 00:00:00
New |  | USB-I2023-8 | [NAME] | 2023-02-28 00:00:00
 |  | USB-I2023-9 | SPA3 | 2023-03-06 00:00:00
 |  | USB-I2023-10 | SPA4 | 2023-03-06 00:00:00
 |  | USB-I2023-11 | [NAME] | 2023-03-06 00:00:00
 |  | USB-I2023-12 | [NAME] | 2023-03-10 00:00:00
New |  | USB-I2023-13 | SPA3 | 2023-03-15 00:00:00
New |  | USB-I2023-14 | CR_ | 2023-03-20 00:00:00
Spreadsheet: 47368d1246397884-how-to-sort-2-sets-of-data-with-dates-to-correlate-each-other-book1-version-1-
Sheet: Sheet1

 | 1st Date | 1st Price | 2nd Date | 2nd Price
1 | 1996-03-18 00:00:00 | 10 | 1996-03-18 00:00:00 | 13.5
2 | 1996-03-19 00:00:00 | 10.125 | 1996-03-19 00:00:00 | 14
3 | 1996-03-20 00:00:00 | 10.125 | 1996-03-22 00:00:00 | 14
4 | 1996-03-21 00:00:00 | 10.25 | 1996-03-25 00:00:00 | 14.0625
5 | 1996-03-22 00:00:00 | 10.25 | 1996-03-26 00:00:00 | 13.25
6 | 1996-03-25 00:00:00 | 10.25 | 1996-03-27 00:00:00 | 13.1875
7 | 1996-03-27 00:00:00 | 10.25 | 1996-03-28 00:00:00 | 13.125
8 | 1996-03-28 00:00:00 | 10.25 | 1996-03-29 00:00:00 | 13.5
9 | 1996-03-29 00:00:00 | 10.25 | 1996-04-02 00:00:00 | 13.625
10 | 1996-04-01 00:00:00 | 10.375 | 1996-04-04 00:00:00 | 13.8125
 |  |  |  |  | 1st Date | 1st Price | 2nd Date | 2nd Price
 |  |  |  |  | 1996-03-18 00:00:00 | 10 | 1996-03-18 00:00:00 | 13.5
 |  |  |  |  | 1996-03-19 00:00:00 | 10.125 | 1996-03-19 00:00:00 | 14
 |  |  |  |  | 1996-03-20 00:00:00 | 10.125 | #N/A | #N/A
 |  |  |  |  | 1996-03-21 00:00:00 | 10.25 | #N/A | #N/A
 |  |  |  |  | 1996-03-22 00:00:00 | 10.25 | 1996-03-22 00:00:00 | 14
 |  |  |  |  | 1996-03-25 00:00:00 | 10.25 | 1996-03-25 00:00:00 | 14.0625
 |  |  |  |  | 1996-03-27 00:00:00 | 10.25 | 1996-03-27 00:00:00 | 13.1875
 |  |  |  |  | 1996-03-28 00:00:00 | 10.25 | 1996-03-28 00:00:00 | 13.125
 |  |  |  |  | 1996-03-29 00:00:00 | 10.25 | 1996-03-29 00:00:00 | 13.5
 |  |  |  |  | 1996-04-01 00:00:00 | 10.375 | #N/A | #N/A
 |  |  |  |  | 1996-04-02 00:00:00 | #N/A | 1996-04-02 00:00:00 | 13.625
 |  |  |  |  | 1996-04-03 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-04 00:00:00 | #N/A | 1996-04-04 00:00:00 | 13.8125
 |  |  |  |  | 1996-04-05 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-06 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-07 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-08 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-09 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-10 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-11 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-12 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-13 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-14 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-15 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-16 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-17 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-18 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-19 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-20 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-21 00:00:00 | #N/A | #N/A | #N/A
 |  |  |  |  | 1996-04-22 00:00:00 | #N/A | #N/A | #N/A
Spreadsheet: 390216d1429550792-solved-post-a-value-in-a-cell-based-off-the-value-of-an-index-cell-oeldere-390212d1429549809-post-a-value-in-a-cell-based-off-the-value-of-an-index-cell-example
Sheet: PT

[NAME] | cost
252123 | 5.52 |  |  |  | Rijlabels | Som van Cost
10-421RED | 10 |  |  |  | 10076-PPA | -47.03
10076-PPA | 2.54 |  |  |  | 10077-PPS | -16.44
10077-PPS | 1.25 |  |  |  | [PHONE] | -79.99
[PHONE] | 46.45 |  |  |  | [PHONE] | -14.62
[PHONE] | 43.25 |  |  |  | [PHONE] | -41.66
1301-FAE-0103 | 48.45 |  |  |  | 10-421RED | -36.13
221-002-08 | 12.64 |  |  |  | 1301-FAE-0103 | -17.34
221-002-10 | 15.6 |  |  |  | 221-002-08 | -9.17
2343 | 45.1 |  |  |  | 221-002-10 | -7.81
252153-5 | 10.25 |  |  |  | 2343 | -11.29
321298 | 45.5 |  |  |  | 252123 | -132.9
 |  |  |  |  | 252153-5 | -4.01
 |  |  |  |  | 321298 | -126.43
 |  |  |  |  | Eindtotaal | -544.8199999999999
Spreadsheet: 1559d893-dbda-436a-a5f5-366b6fa1c42d
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: |  |  | 2011-08-15 09:50:59.510000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.81 | 101.685 | 101.56 | 101.185
4.25 | 100.976 | 100.851 | 100.726 | 100.351 |  | Note: | Refer To Price [NAME]
4.125 | 99.829 | 99.704 | 99.579 | 99.204 |  |  | For all Price Adjs
4 | 99.34 | 99.215 | 99.09
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 101.706 | 101.581 | 101.456 | 101.081
3.625 | 101.073 | 100.948 | 100.823 | 100.448
3.5 | 100.737 | 100.612 | 100.487 | 100.112
3.375 | 100.35 | 100.225 | 100.1 | 99.725
3.25 | 99.806 | 99.681 | 99.556
 |  |  |  |  |  | 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 | 2011-08-29 09:50:59.510000
30 DAY | 2011-09-13 09:50:59.510000
45 DAY | 2011-09-28 09:50:59.510000
60 DAY | 2011-10-13 09:50:59.510000
90 DAY | 2011-11-12 09:50:59.510000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 755892d1637165799-help-wedding-planner-macbride-wedding-rev1-mcknze21-
Sheet: Data

Prawn Marie Rose with [NAME] and Wholegrain Bread
Lentil & Vegetable Soup
No Starter
N/A
[NAME] of Chicken, Black Pudding Bon Bons & Peppercorn Sauce
Traditional Piperdam Steak Pie with Puff Pastry
Vegetarian - [NAME] with Sun Dried Tomatoes, Black Olives, Rocket and Pesto
No Main
N/A
[NAME] Pudding With Hot Butter Scotch Sauce & Vanilla Ice Cream
Banoffee Cheesecake with Banana Chips
No Sweet
N/A
None
[NAME]
Nut Allergy
No Brazil Nuts
Dairy Free
Vegan
Shellfish Allergy
N/A
ACCEPT
DECLINE
YES
NO
Spreadsheet: 808828d1670677676-how-to-return-a-fixed-value-from-a-cell-which-keeps-changing-its-value-example-workbook
Sheet: Sheet1

NAMES | 2022-09-15 00:00:00 | 2022-09-22 00:00:00 | 2022-09-29 00:00:00 | 2022-10-06 00:00:00 | 2022-10-13 00:00:00 | 2022-10-20 00:00:00 | 2022-10-27 00:00:00 | 2022-11-03 00:00:00 | 2022-11-10 00:00:00 | 2022-11-17 00:00:00 | 2022-11-24 00:00:00 | 2022-12-01 00:00:00
X | y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | y
X | y |  |  | Y | Y | Y | y | y | Y | Y |  | y
X | y | Y | Y | Y | Y |  | Y | Y | Y | Y | Y | y
X | y | Y | Y | Y | y | Y | Y | Y | Y | Y | Y | Y
X |  |  | Y | Y | Y | Y | Y | y | Y | Y | Y | Y
X | y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
X |  | y | y | y | y | y |  | y |  | y | y
X | y | Y | Y | Y | Y |  | Y | Y | Y | Y | Y | Y
X | y |  |  | y |  | Y | Y |  |  | Y |  | y
X |  |  | Y | Y |  | Y | Y |  |  | Y | Y | Y
X | y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
[NAME]
% Returned
COUNT
Adjusted count | 14 | 13 | 13 | 13 | 14 | 14 | 15 | 15 | 14 | 12 | 12 | 11
Spreadsheet: 165455d1341237600-need-help-summing-quantities-of-numerous-duplicate-entries-export-sample
Sheet: Export Sample

Symbol | Security | Shares | Total
EGN | ENERGEN CORP | 100 | 100
EMR | EMERSON ELECTRIC COMPANY | 21 | 21
EV | EATON VANCE CORP | 36 | 36
FCSZX | FRANKLIN CONVERTIBLE_x000D_ SECURITIES ADVISOR CL | 4007.17 | 4007
FCSZX | FRANKLIN CONVERTIBLE_x000D_ SECURITIES ADVISOR CL | 675.989 | 676
FDN | FIRST TRUST EXCHANGE_x000D_ TRADED FUND DOW JONES_x000D_ INTERNET INDEX FUND | 140
FDN | FIRST TRUST EXCHANGE_x000D_ TRADED FUND DOW JONES_x000D_ INTERNET INDEX FUND | 242
FDN | FIRST TRUST EXCHANGE_x000D_ TRADED FUND DOW JONES_x000D_ INTERNET INDEX FUND | 650
FDN | FIRST TRUST EXCHANGE_x000D_ TRADED FUND DOW JONES_x000D_ INTERNET INDEX FUND | 300
FDS | FACTSET RESEARCH SYSTEMS_x000D_ INC | 11 | 11
FITZX | FRANKLIN FEDERAL_x000D_ INTERMEDIATE TERM TAX_x000D_ FREE INCOME ADVISOR CL | 6200.55 | 6201
FNX | FIRST TRUST MID CAP_x000D_ CORE ALPHADEX FUND | 564
FNX | FIRST TRUST MID CAP_x000D_ CORE ALPHADEX FUND | 600
FNX | FIRST TRUST MID CAP_x000D_ CORE ALPHADEX FUND | 154
FNX | FIRST TRUST MID CAP_x000D_ CORE ALPHADEX FUND | 300
FNX | FIRST TRUST MID CAP_x000D_ CORE ALPHADEX FUND | 437
FNX | FIRST TRUST MID CAP_x000D_ CORE ALPHADEX FUND | 600
FNX | FIRST TRUST MID CAP_x000D_ CORE ALPHADEX FUND | 300
Spreadsheet: 673188d1587233955-separating-regular-and-ot-hours-time-sheet
Sheet: Sheet1

 | PROCESS CHAIN | CODE | RECEIPT | GENERATOR | Fri  Mid Shift | Sat | Sun | Mon | Tue | Wed | Thu | Fri  Mid Shift | Hours
 |  |  |  |  | 12 | 12 | 12 | 12 | 12 | 4
 | Total Hours for Week
 |  |  |  | Stright Time Hours Worked |  |  |  | 4 | - | -
 |  |  |  | SPV
 |  |  |  | HOLIDAY
 |  |  |  | FLOATING HOLIDAY
 |  |  |  | JURY
 |  |  |  | [NAME]
 |  |  |  | Combined Total Hours for Week
 |  |  |  | Daily Over Time Hours Worked |  |  |  | 8 | 12 | 4
 | Total Hours for Week
Spreadsheet: 703398d1604981350-need-help-getting-a-unique-headcount-with-multiple-conditions-excelhelpfile
Sheet: Sheet1

Pass Name | Complete Date | Title Status | Employee |  |  | Headcount Per Pass | In Progress | Completed
project A |  | in progress | [NAME] |  | project A
project A |  | in progress | bob |  | project B
project A | 2020-10-07 00:00:00 | completed | ryan
project A |  | in progress | [NAME] |  | Date
project B |  | in progress | [NAME] |  | 2020-10-07 00:00:00
project B |  | in progress | Jake
project B | 2020-10-07 00:00:00 | completed | Jake |  |  | G2 should = 4
project B | 2020-10-07 00:00:00 | completed | [NAME] |  |  | G3 Should = 3
project B | 2020-10-07 00:00:00 | completed | [NAME]
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: $ mono by location

Monograph Expenditures by Location FY10 and FY11
Library | Code | Meaning | FY10 | FY11 | % change | % of total FY11 expend.
[NAME] | rinn | [NAME] | 514.06 | 478.45
[NAME] | rinxx | PELL CD ROM | 80 | 0
URI | riu23 | URI CML Kits/Media | 249.71 | 0
URI | riudv | URI Media Rm. | 8286.9 | 11232.85
URI | [NAME] | URI Reference | 48090.61 | 58493.07
URI | riuf1 | URI [NAME] | 3908.76 | 0
URI | riui | URI RI Collection | 2001.49 | 2857
URI | riuo | URI Oversize Stacks | 5964.06 | 5300.87
URI | riup | URI Serial Stacks | 201.59 | 173.18
URI | riur | [NAME] | 647.29 | 0
URI | riuu | [NAME] | 278867.82 | 258836.35
CCE | rixr | CCE Reference | 464.87 | 782.97
CCE | rixx | CCE Main Collection | 13780.93 | 9608.83
CCE | rixz | CCE Oversize | 0 | 33.47 | N/A
 |  | TOTAL
Spreadsheet: 702743d1604508442-copy-different-and-changing-length-lists-from-multiple-sheets-dept-summary-for-questions
Sheet: 2ND DIV

 |  |  |  |  | LAST NAME | FIRST NAME | TYPE 1 | TYPE 2 | TYPE 3 | TYPE 4
 |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
TYPE 1 |  |  |  |  |  |  |  | X
TYPE 2 |  |  |  |  |  |  |  |  |  | X
TYPE 3 |  |  |  |  |  |  |  |  | X
TYPE 4 |  |  |  |  |  |  | X
TOTAL |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  | X
TYPE 2
FIRST NAME | LAST NAME | START | STOP
 |  | 300 | 900
 |  | 1200 | 1400
TYPE 3
 |  | START | STOP
 |  | 6500 | 8500
 |  | 7200 | 9000
Spreadsheet: 67221d1267804140-expanding-a-complex-range-reference-removeblank-keycolumn
Sheet: Sheet1

 | Key | ITEMS |  |  | 9 | Quote View
 | 0
 | 1 | Milk |  |  | 1 | Milk
 | 1 |  |  |  | 2 | Cheese
 | 1 |  |  |  | 3 | Biscuits
 | 1 |  |  |  | 4 | Dog Food
 | 1 |  |  |  | 5 | Tea
 | 2 | Cheese |  |  | 6 | Bread
 | 3 | Biscuits |  |  | 7 | Bird Food
 | 4 | Dog Food |  |  | 8 | [NAME]
 | 5 | Tea |  |  | 9 | Steak
 | 5 |  |  |  | 10
 | 5 |  |  |  | 11
 | 6 | Bread |  |  | 12
 | 6 |  |  |  | 13
 | 7 | Bird Food |  |  | 14
 | 7 |  |  |  | 15
 | 7 |  |  |  | 16
 | 8 | [NAME] |  |  | 17
 | 8 |  |  |  | 18
 | 8 |  |  |  | 19
 | 9 | Steak |  |  | 20
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
 | 9
Spreadsheet: 193793d1352950743-track-high-score-and-transfer-info-scoresummary-max-rev2
Sheet: Bob

Scores
1 | Mukwonago
2 | [NAME]
3 | [NAME]
4 | New Berlin
5 | Slinger
6 | Pewaukee
7 | Hartford
8 | Sussex
9 | Hartland
10 | Merton
11 | Milwaukee
Spreadsheet: michelle_cash__26525__Template
Sheet: Template

UserID | Password | Group Name | Last Name | First Name | MiddleName | Mail Address | Contact | Title | Action
Spreadsheet: d00a7ee0-98ce-4030-bb0c-2b3f5c38cae7
Sheet: Sheet1

Release: Construction Spending | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=229
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-18 7:41 PM CST
 | Real-Time | Period
Name: | Start | End
Construction Spending | 2011-07-01 00:00:00 | Current
Link:
http://www.census.gov/construction/c30/c30index.html | 2011-07-01 00:00:00 | Current
Source:
US. Bureau of the Census | 2011-07-01 00:00:00 | Current
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:
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-03 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-03 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-02 00:00:00
2012-08-01 00:00:00
2012-09-04 00:00:00
2012-10-01 00:00:00
2012-11-01 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-22 00:00:00
2013-12-02 00:00:00
2014-01-02 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
2014-04-01 00:00:00
2014-05-01 00:00:00
2014-06-02 00:00:00
2014-07-01 00:00:00
2014-08-01 00:00:00
2014-09-02 00:00:00
2014-10-01 00:00:00
2014-11-03 00:00:00
2014-12-02 00:00:00
Spreadsheet: 128548d1321039453-count-formula-load-20-1-
Sheet: Sheet2

 |  | location | load | truck | driver
 |  | Friendly's | 1 | T15 | B
 |  | [NAME]'s Valley | 2 | T15 | B
 |  | [NAME]'s Valley | 3 | T15 | B
 |  | big sky | 4 | T15 | B
 |  | Lakeside | 5 | T15 | B
 |  | [NAME]'s mart | 6 | T1 | M
 |  | 457 | 6 | T1 | M
 |  | crossroads | 7 | T1 | M
Spreadsheet: 672806d1587020124-excel-2016-contain-and-copy-question-sinca
Sheet: Sheet1

H1424 | 18mm | ST22 | LKSP H1424 ST22 [NAME] 18 mm | 003EGH1424ST2218 | IF G2:G99 contains Ax and Bx then copy here | [PHONE] Lamināts 25mm Onix Pelēks U960 ST9
H1733 | 18mm | ST9 | LKSP H1733 ST9 Mainau Bērzs 18 mm | 003EGH1733ST918 | [PHONE] Lamināts 18mm [NAME]  <----- to here if both Ax and Bx apply | [PHONE] Lamināts 25mm [NAME] U156 ST9
H2033 | 18mm | ST19 | LKSP H2033 ST19 [NAME] 18 mm | 003EGH2033ST1918 | Cell above are same info like in G7 cell because it contains A3 & B3 info | [PHONE] Lamināts 25mm Ozols Beicēts H3304 ST9 (vecais)
H3326 | 18mm | ST28 | LKSP H3326 ST28 [NAME] ozols 18 mm | 003EGH3326ST2818 |  | [PHONE] Lamināts 25mm Kašmirs U702 ST2
H3395 | 18mm | ST12 | LKSP H3395 ST12 [NAME] 18 mm | 003EGH3395ST1218 |  | [PHONE] Lamināts 18mm Rieksts H3704 ST15 (vecais)
H3430 | 18mm | ST22 | LKSP H3430 ST22 Balta Aland Priede 18 mm | 003EGH3430ST2218 | From here ----> | [PHONE] Lamināts 18mm Kļava H1733 ST9
 |  |  |  |  |  | With red color letters i mark cell who contain A3&B3 info and need to copy over F3
A3 & B3 have common info in D3 so i need to find same in G column and get it in F
Spreadsheet: 49349ccb-f110-4efb-aa16-90ed1d052a6b
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
LAGGT | Test | LAGGT | Granulocyte Antibodies, Serum | [NAME], S | Indirect Immunofluorescence | Plain, Red-Top Tube: Red |  |  | 1.5 | mL | Container/Tube: Red top [NAME]: 1.5 mL Additional Information: Only pretransfusion reaction specimen is acceptable. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Serum gel tube | Not applicable | Monday, Wednesday, Friday; 7:30 a.m.-5:00 p.m. | 7 days | 15 days | 1 | 86021 |  |  |  |  | Rochester
LAGGT | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 30 days
LAGGT | Result | LAGG | [NAME], S | [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 298842d1392924249-complicated-lookup-vlookup-hlookup
Sheet: Sheet1

 | LOW | MID | HIGH
1 | 10 | 15 | 18
2 | 8 | 12 | 17
3 | 15 | 22 | 35
4 | 22 | 35 | 55
CODE | VALUE | LOOKUP
2 | 11 | LOW | what formula here?