tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a2a2b3c2-785e-4f79-bd0c-32af632cd556
Sheet: Output 3

PROJECT TITLE | Implementation of the Agricultural Model Intercomparison and Improvement Project (AgMIP) for South Asia and Sub-Saharan Africa
OUTPUT 3 | Indicator | Baseline (2011) | Milestone (2012) | Milestone (2013 | Target (2014) | Assumptions
Strengthened capacity of researchers (PIs) in Sub-Saharan Africa and South Asia to access and use crop and economic models. | Increased knowledge base and capacity to simulate impacts and adaptation of the SUB-SAHARAN AFRICA and S Africa researchers. | 0 | Successful completion of at least one study visit to each developing region PI. | Successful completion of simulations for developing region [NAME]. | 20 PIs capable of simulations, including adaptation strategies to the standard required. | Mitigation and adaptation decisions for climate change impacts on agriculture will be made in consultation with local researchers and specialists.
 |  | Source:  [NAME] website: www.agmip.org, training reports from site visits, quality assurance and quality control of simulation results by team leaders.
 | Indicator | Baseline (2011) | Milestone (2012) | Milestone (2013 | Target (2014) | Researchers will be supported by their home institutions to continue crop and economic model applications.
 | Number of calibrated crop and/or economic models actively run by each developing region PI. | 0 – 1 | Calibration of first (crop or economic) model for local conditions. | Calibration of second (crop or economic) model for local conditions. | Additional 1 – 3  calibrated models run.
 |  | Source:  [NAME] website: www.agmip.org.
IMPACT WEIGHTING | Indicator | Baseline (2011) | Milestone (2012) | Milestone (2013 | Target (2014) | RISK RATING
0.1 | Number of Sub-Saharan and South Asian researchers able to participate in AgMIP data analysis, research and/or assessment methods. | 0 - 10 | 20-30 | 50-80 | 120 + | medium
 |  | Source:  [NAME] website: www.agmip.org, training reports from site visits, assessment of uptake by team leaders.
INPUTS (£) | DFID (£) | Govt (£) | Other (£) | Total (£) | DFID SHARE (%)
INPUTS (HR) | DFID (FTEs)
Spreadsheet: 65855d1266502359-delete-duplicate-rows-based-only-2-columns-filter
Sheet: Sheet1

Company | Person Name | Age |  |  | Company | Person Name | Age
Barclays | [NAME] | 21 |  |  | Barclays | [NAME] | 21
Barclays | [NAME] | 23 |  |  | Barclays | [NAME] | 23
Barclays | [NAME] | 22 |  |  | Barclays | [NAME] | 22
Barclays | [NAME] | 25 |  |  | Natwest | [NAME] | 22
Natwest | [NAME] | 22 |  |  | Natwest | [NAME] | 21
Abbey | [NAME] | 30 |  |  | Abbey | [NAME] | 30
Natwest | [NAME] | 21 |  |  | Abbey | [NAME] | 29
Abbey | [NAME] | 34
Abbey | [NAME] | 35
Natwest | [NAME] | 26
Natwest | [NAME] | 26
Barclays | [NAME] | 40
Abbey | [NAME] | 29
Natwest | [NAME] | 23
Spreadsheet: 676019d1588608588-how-to-average-last-n-entries-from-table-sample
Sheet: Sheet1

 |  |  |  |  | GRAHAM | 1283 |  | STEVE | 1512
 |  |  |  |  | STEVE | 1506 |  | SHAWN | 1427
 |  |  |  |  | BOB | 1501 |  | GRAHAM | 1278
 |  |  |  |  | STEVE | 1501 |  | BOB | 1509
 |  |  |  |  | BOB | 1496 |  | SHAWN | 1443
 |  |  |  |  | GRAHAM | 1268 |  | STEVE | 1491
 |  |  |  |  |  | Average last 3
 |  |  |  |  | STEVE
 |  |  |  |  | GRAHAM
 |  |  |  |  | BOB
 |  |  |  |  | SHAWN
Spreadsheet: 769684d1645635783-irr-and-xirr-functions-slow-down-my-spreadsheet-example-book
Sheet: Sheet1

 |  |  | Date |  | 2021-12-31 00:00:00
 |  |  | Outflows |  | -5 | -6 | -4.5 | -2.763088638117284 | -21.23548747086388 | -1 | 0 | -2 | 0 | 0 | -1 | 0 | 0
 |  |  | Inflows |  | 0 | 0 | 15 | 0 | 12 | 15 | 0 | 0 | 1 | 15 | 2 | 15 | 2
 |  |  | Net Cash Flows
 |  |  |  | IRR
 |  |  |  | XIRR
 |  |  |  | Multiple of Invested Capital
 |  |  |  | Question: | While its not totally evident here in a small workbook, in a larger model with circular logic and more calculations, the speed of the the worksheet with and without the IRR & XIRR functions is materially slower with IRR or XIRR
 |  |  |  |  | is there an alternative?
Spreadsheet: 45381d1244116485-counting-by-2-or-more-criteria-example-2
Sheet: Summary

Date | Cathy |  |  |  | [NAME] |  |  |  | Dawn |  |  |  | [NAME] |  |  |  | [NAME]
 | S Jobs Opened | W Jobs Opened | s Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed
2009-05-01 00:00:00
2009-05-02 00:00:00
2009-05-03 00:00:00
2009-05-04 00:00:00
2009-05-05 00:00:00
2009-06-01 00:00:00
2009-06-02 00:00:00
2009-06-03 00:00:00
2009-06-04 00:00:00
2009-06-05 00:00:00
Spreadsheet: 850567d1700929215-sumifs-not-pulling-second-criteria-sample-1-bsb-
Sheet:  activity by month

Medic | 2023-01-01 00:00:00
Dicaprio
[NAME]
[NAME]
Styron
Papalski
Witte
Jones
Kautz
Spreadsheet: 23c6ca8d-c7a8-4c98-93c7-d6ab9371a31c
Sheet: IF

LastName | Amount Owe | Invoice Date | Current or Overdue (90 Days) | Amount Over $2,000
[NAME] | 239.85 | 2007-12-30 00:00:00
Abram | 345 | 2008-01-06 00:00:00
Abshire | 6000 | 2008-03-07 00:00:00
Acosta | 4509 | 2008-03-10 00:00:00
Acosta | 3021 | 2007-11-01 00:00:00
Adams | 322 | 2007-06-08 00:00:00
Adkins | 509.98 | 2008-06-19 00:00:00
Aggers | 32 | 2008-10-09 00:00:00
Agreda | 456 | 2008-01-06 00:00:00
Aguilar | 420.85 | 2008-05-17 00:00:00
Aguirre | 1033 | 2008-03-07 00:00:00
[NAME] | 1100 | 2008-03-07 00:00:00
[NAME] | 3200 | 2008-10-09 00:00:00
Alfaro | 309.05 | 2008-11-04 00:00:00
[NAME] | 16.09 | 2008-03-25 00:00:00
Alouache | 166.95 | 2008-04-06 00:00:00
Alper | 320 | 2008-08-08 00:00:00
[NAME] | 500 | 2007-08-10 00:00:00
Amador | 240 | 2007-02-28 00:00:00
Ammossow | 245 | 2008-03-19 00:00:00
Amodeo | 340.5 | 2007-04-15 00:00:00
Anaya | 350 | 2008-04-15 00:00:00
Andersen | 650 | 2008-06-07 00:00:00
[NAME] | 1500 | 2008-08-08 00:00:00
Andersson | 1250 | 2007-08-08 00:00:00
[NAME] | 1000 | 2008-10-05 00:00:00
Araiza | 1300 | 2007-10-27 00:00:00
Arce | 2005 | 2008-09-09 00:00:00
Aralize | 2000 | 2007-09-05 00:00:00
Arvizu | 235 | 2007-09-15 00:00:00
Ascion | 230 | 2006-03-05 00:00:00
Asuncion | 195 | 2006-06-07 00:00:00
Atillo | 155 | 2008-07-08 00:00:00
Atkins | 105.65 | 2006-10-01 00:00:00
Auble | 12.89 | 2007-10-26 00:00:00
Albertson | 34.9 | 2008-05-06 00:00:00
Avner | 309 | 2007-11-08 00:00:00
Ayala | 34 | 2008-11-05 00:00:00
[NAME] | 1209 | 2008-11-03 00:00:00
Bachrach | 3500 | 2007-10-08 00:00:00
Spreadsheet: 158485d1338280133-matching-items-quantity-and-price-from-2-diferent-sheets-sample
Sheet: Sheet2

 | ITEM | QTY | PRICE
 | 2181 | 1 | 0.13
 | 3705 | 1 | 17.07
 | 3739 | 3 | 6.38
 | 4532 | 1 | 2.5
 | 4615 | 1 | 4.28
 | 4865 | 1 | 8.19
 | 4885 | 1 | 41.8
 | 4924 | 1 | 0.69
 | 4925 | 1 | 2.95
 | 5333 | 1 | 41.83000000000001
 | 5603 | 0 | 0
 | 9357 | 3 | 1.04
 | 13728 | 2 | 118.54
 | 13771 | 7 | 4.84
 | 13772 | 13 | 17.29
 | 17904 | 2 | 54.19
 | 17955 | 113 | 88.25999999999999
 | 17973 | 7 | 23.95
 | 20131 | 1 | 665.47
 | 20853 | 60 | 160.6
 | 20857 | 282 | 699.36
 | 20866 | 60 | 203.4
 | 20871 | 50 | 300.2
 | 20882 | 122 | 645.38
 | 20887 | 10 | 71.42
 | 20890 | 18 | 180
 | 20892 | 38 | 479.35
 | 20896 | 13 | 200.2
 | 26010 | 1 | 0
 | 26247 | 5 | 0.7
 | 26298 | 3 | 65.81
 | 26347 | 1 | 25.45
 | 26389 | 4 | 6.38
 | 26397 | 1 | 101.1
 | 30275 | 0 | 0
 | 41024 | 330 | 24.09
 | 49147 | 0 | 0
 | 49175 | 1 | 0.4
 | 50353 | 40300 | 5430.2
 | 51090 | 1 | 0.37
 | 51279 | 2 | 17.53
 | 52286 | 4000 | 52
 | 52287 | 2500 | 72.5
 | 52288 | 100 | 4.8
 | 52289 | 50 | 4
 | 58906 | 100 | 1.5
 | 58907 | 50 | 2.15
 | 58910 | 2500 | 100
 | 58911 | 3000 | 105
 | 59196 | 8 | 30.32
 | 59665 | 1 | 0.35
 | 60143 | 2 | 0.9
 | 60579 | 1 | 0
 | 62893 | 1 | 197.8
 | 70123 | 2 | 2.07
 | 70421 | 3 | 0.15
 | 70446 | 2 | 0.12
 | 70716 | 3 | 73.80000000000001
 | 71473 | 0 | 0
 | 71723 | 2 | 780
 | 71789 | 3 | 0.16
 | 71799 | 1 | 4.73
 | 73154 | 1 | 4.07
 | 74143 | 1 | 0.32
 | 74154 | 1 | 0.11
 | 74157 | 16 | 2.13
 | 74473 | 2 | 0
 | 74479 | 3 | 108.04
 | 74668 | 0 | 0
 | 74681 | 7 | 7.2
 | 74718 | 2 | 18.99
 | 74719 | 2 | 21.59
 | 74729 | 1 | 27.04
 | 75213 | 2 | 20.58
 | 75706 | 3 | 1.29
 | 75710 | 2 | 0.42
 | 75719 | 2 | 1.34
 | 76021 | 1 | 2.63
 | 76036 | 3 | 3.59
 | 76227 | 1 | 5.35
 | 76296 | 2 | 27.44
 | 76452 | 1 | 10.64
 | 76486 | 1 | 0.48
 | 76487 | 6 | 1.54
 | 76491 | 4 | 4.25
 | 76594 | 3 | 18.11
 | 87618 | 650 | 585
 | 87619 | 295 | 442.5
 | 87620 | 20 | 38
 | 87621 | 20 | 70
 | 93876 | 2 | 4.57
 | 93885 | 1 | 5.37
 | 200342 | 2 | 0
 | 200350 | 0 | 0
 | 200351 | 0 | 0
 | 201049 | 1 | 0.85
 | 201172 | 1 | 32.55
 | 201207 | 1 | 0.16
 | 201247 | 1 | 13.62
 | 201414 | 1 | 44.01
 | 201543 | 1 | 0
 | 201594 | 2 | 19.3
 | 202067 | 0 | 0
 | 202087 | 1 | 21.38
 | 202093 | 2 | 2.07
 | 202094 | 3 | 43.02
 | 202141 | 0 | 0
 | 202157 | 5 | 18.51
 | 202171 | 0 | 0
 | 202172 | 0 | 0
 | 202175 | 1 | 0.29
 | 202180 | 0 | 0
 | 202227 | 0 | 0
 | 202260 | 1 | 80.07000000000001
 | 202306 | 0 | 0
 | 202416 | 2 | 650
 | 202629 | 4 | 27.18
 | 202756 | 0 | 0
 | 202764 | 0 | 0
 | 203086 | 27 | 87.86000000000001
 | 203153 | 0 | 0
 | 203378 | 1 | 4.07
 | 203852 | 3 | 70
 | 203862 | 1 | 48.16
 | 205318 | 3 | 39.84999999999999
 | 206019 | 1 | 60.28
 | 206103 | 0 | 0
 | 206121 | 3 | 3.22
 | 206125 | 1 | 6.65
 | 206130 | 0 | 0
 | 206145 | 11 | 5.280000000000001
 | 206210 | 1 | 4.33
 | 206211 | 1 | 10.4
 | 206292 | 11 | 70.18
 | 206293 | 5 | 51.59
 | 206303 | 2 | 2.21
 | 206305 | 13 | 0.49
 | 206499 | 1 | 41
 | 206502 | 2 | 26.94
 | 206506 | 1 | 79
 | 206615 | 2 | 14.95
 | 206627 | 1 | 17.84
 | 206647 | 1 | 52
 | 206648 | 1 | 32
 | 206652 | 1 | 0
 | 206659 | 1 | 63
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: SE-LRC-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  LRC
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 10167711 | 17389462
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2625789 | 4594435.52
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 12793500 | 21983897.52
 | Purchases:
6 |  | 3rd Party / Inter Enron | -3999526 | -6884435
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -9003725 | -15955875
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -13003251 | -22840310
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 914166 | 1586850
12 |  | Purchases | -624569 | -1133654
 | Total Intra CTS Sales / Purchases |  | 289597 | 453196
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 882877 | 1447917
18 |  | W/D (Purchase from Stg) | -625025 | -1025040
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -625025 | -1025040
 | Total Storage: |  | 257852 | 422877
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -397698 | -697548.7274850741
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 123381.248
 | Total Transport Revenue: |  | 0 | 123381.248
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 0
31 |  | Prior Month Book Balance | 0 | 0
 |  | Total MTM Income | 0 | 0
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 0
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | -3000000
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL
Spreadsheet: 2f342f08-b55f-4ff6-b633-8b91d5c219da
Sheet: Sheet1

Table S3 | Unnamed: 1 | Unnamed: 2
Genes Selected in the Co-Variation Correlation Assay
Synaptic incoming connectivity signatures |  | Synaptic outgoing connectivity signatures
che-2 |  | ace-1
daf-28 |  | ace-2
[NAME] |  | bra-1
mec-12 |  | cat-1
mgl-2 |  | cat-2
mps-1 |  | ceh-23
pef-1 |  | che-3
slt-1 |  | daf-28
sup-9 |  | dat-1
unc-30 |  | deg-1
unc-5 |  | dop-2
unc-93 |  | egl-3
 |  | glr-8
 |  | gpa-14
 |  | gpa-16
 |  | gpa-2
 |  | gpa-3
 |  | gpa-9
 |  | hcp-3
 |  | ida-1
 |  | ina-1
 |  | [NAME]
 |  | kin-29
 |  | kvs-1
 |  | lin-11
 |  | mab-9
 |  | mdl-1
 |  | mec-7
 |  | nlp-11
 |  | nlp-6
 |  | osm-3
 |  | osm-9
 |  | pef-1
 |  | rig-1
 |  | sem-4
 |  | ser-4
 |  | sra-10
 |  | sra-11
 |  | sre-37
 |  | sup-9
 |  | tax-2
 |  | tax-4
 |  | [NAME]
 |  | tph-1
 |  | ttx-3
 |  | unc-30
 |  | unc-5
 |  | unc-53
 |  | unc-6
 |  | unc-8
 |  | unc-93
 |  | vab-15
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: EPFS

 | El Paso/TW Eddy Rec
 | 78093
Day | Measured | Scheduled
1 | 31118 | 31456
2 | 26432 | 31456
3 | 27387 | 31394
4 | 31954 | 31456
5 | 31066 | 34456
6 | 37507 | 36936
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
2002-01-31 00:00:00 |  |  | 100993
2002-02-06 00:00:00
CBS Volume
 |  |  | 62232
Spreadsheet: 101773d1299813190-draft-day-registration-help-team-draft
Sheet: Player Rank

Team | A | B | C | D | E | F | G | H
Messages
1
Spreadsheet: 551455d1512958528-cell-colour-formatting-with-multiple-arguments-colour
Sheet: Sheet2

 |  | Milestone | Task | Completed
 |  | Patch Cable | Buy cables | True
 |  |  | Install cables | True
 |  |  | Label cables | True
 |  | Install Equipment | Buy devices | True
 |  |  | Asset register | False
 |  |  | Install devices | False
 |  | Delivery | Trial run with client | False
 |  |  | Training | False
 |  |  | [NAME] | False
Spreadsheet: daren_farmer__5736__HPLN0222
Sheet: Sheet1

[NAME] |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
 |  |  |  |  |  | REVISION #1
SUBJECT:  TXU FUELS NOMINATION - February 22, 2001
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-02-22 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 20
 |  | 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: 219127d1362672012-help-with-a-formula-function-if-its-possible-admit-dc-2013
Sheet: 10

Admission and Discharges
2013
Date: | 2013-01-10 00:00:00
ADMISSIONS |  |  |  |  |  |  | DISCHARGES
Room # | Name | Time | From | Status | Telemetry Box # |  | Room # | Name | Time | To
318 | z | 00:10:00 | ED |  |  |  | 317 | a | 10:20:00
IC02 | x | 03:05:00 | ED |  |  |  | 335 | s | 12:55:00
IC06 | y | 10:02:00 | ED |  |  |  | 210 | d | 13:45:00
322 | b | 13:45:00 | OR |  |  |  | 336 | f | 12:30:00
215 | a | 17:09:00 | ED |  |  |  | IC03 | g | 11:52:00
306 | c | 18:59:00 | ED |  |  |  | 306 | h | 13:10:00
 |  |  |  |  |  |  | 327 | j | 13:20:00
 |  |  |  |  |  |  | 309 | k | 14:20:00
 |  |  |  |  |  |  | 315 | l | 13:30:00
 |  |  |  |  |  |  | 214 | q | 14:20:00
 |  |  |  |  |  |  | 326 | e | 10:00:00
 |  |  |  |  |  |  | 216 | r | 17:00:00
 |  |  |  |  |  |  | 331 | t | 17:20:00
 |  |  |  |  |  |  | IC02 | y | 15:00:00
 |  |  |  |  |  |  | 201 | p | 15:45:00
 |  |  |  |  |  |  | 205 | o | 15:00:00
 |  |  |  |  |  |  | 207 | k | 16:20:00
 |  |  |  |  |  |  | 320 | l | 16:55:00
 | How many admits: 0001-0200: | 1 | How many  From ED | How many inpt | Total # Admits |  |  | How many d/c: 0001-0200: | 0 | Total #  Discharges
 | How many admits: 0201-0400: | 1 | 5 | 0 | 6 |  |  | How many d/c: 0201-0400: | 0 | 18
 | How many admits: 0401-0600: | 0 | How many  From CDU | How many obs |  |  |  | How many d/c: 0401-0600: | 0
 | How many admits: 0601-0800: | 0 | 0 | 0 |  |  |  | How many d/c: 0601-0800: | 0
 | How many admits: 0801-1000: | 0 | How many from ASU |  |  |  |  | How many d/c: 0801-1000: | 1
 | How many admits: 1001-1200: | 1 | 0 |  |  |  |  | How many d/c: 1001-1200: | 2
 | How many admits: 1201-1400: | 1 | How many from OR |  |  |  |  | How many d/c: 1201-1400: | 6
 | How many admits: 1401-1600: | 0 | 1 |  |  |  |  | How many d/c: 1401-1600: | 5
 | How many admits: 1601-1800: | 1 | How many from CV |  |  |  |  | How many d/c: 1601-1800: | 4
 | How many admits: 1801-2000: | 1 | 0 |  |  |  |  | How many d/c: 1801-2000: | 0
 | How many admits: 2001-2200: | 0 | How many DA |  |  |  |  | How many d/c: 2001-2200: | 0
 | How many admits: 2201-2400: | 0 | 0 |  |  |  |  | How many d/c: 2201-2400: | 0
ROOM TRANSFERS |  |  |  |  |  |  | TELEMETRY - ON / OFF
Room # | Name | To Room # |  |  |  |  | Room# | Name | On/Off | Box #
 | Maloney
Spreadsheet: 698945d1602261225-logic-using-if-statements-with-percentages-example-increase
Sheet: Sheet1

Sold | Increased | Manual Increase % | Projected | Manual Increase Qty |  | What [NAME] should return
20 | 0.1 |  |  |  |  | 21
5 | 0.18 |  |  |  |  | 5
200 | 2 |  |  |  |  | 270
425 | 1.42 |  |  |  |  | 531
612 | 0.68 |  |  |  |  | 704
998 | 0.49 |  |  |  |  | 1098
7 | 0.05 |  |  |  |  | 7
14 | 0.2 |  |  |  |  | 15
874 | 2.5 |  |  |  |  | 1180
95 | 0.22 |  |  |  |  | 100
Range |  | Increase
0 | 0.25 | 0.05
0.250001 | 0.5 | 0.1
0.500001 | 1 | 0.15
1.000001 | 2 | 0.25
2.000001 | 100 | 0.35
I want to write logic into the formula for Column "D". I first want to be able to Put in a manual Increase if desired into Column "E". IF I don't wan to do that then I want to put in an Increase by Percentage in Column "C".
After that I want to automatically increase Column "D" based on the logic written into "IF" statements. So it will look in Column "B" and increase Column "D" based off the ranges in the table
I don't want to use a table, just "IF" Statements. I just can't figure out how Excel sees the percentages. Any help would be appreciated. Thanks,
Spreadsheet: 768936d1645206987-need-help-with-a-challenging-lookup-match-type-of-situation-example-file
Sheet: DATA

 |  |  |  | Expected Result of formula
ORIGIN CITY | ORIGIN ST | DEST CITY | DEST ST | MATCH LINE
BIRMINGHA | AL | ELMIRAGE | AZ | 6
BIRMINGHA | AL | SANBERNAR | CA | N
CHICAGO | IL | BIGLIFT | CO | 1
CHICAGO | IL | LAUREL | MT | 1
CHICAGO | IL | PEARLAND | TX | 1
CHICAGO | IL | SANBERNAR | CA | 2
CORCHRIST | TX | KANCITY | KS | N
BIRMINGHA | AL | RICHMOND | CA | 3
BIRMINGHA | AL | SANBERNAR | CA | N
CHICAGO | IL | KANCITY | KS | 1
CHICAGO | IL | KENT | WA | 1
CHICAGO | IL | ORILLIA | WA | 1
CHICAGO | IL | PEARLAND | TX | 1
CHICAGO | IL | PORTERSIX | OR | 1
CHICAGO | IL | RICHMOND | CA | 1
CHICAGO | IL | SANBERNAR | CA | 2
CORCHRIST | TX | ALLIANCE | TX | N
 |  |  |  | N= NO MATCH
Spreadsheet: 34303d1231461417-returning-first-instance-of-zero-example1
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Expected Result
1111 | 684 | 651 | 198 | 354 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | May
2222 | 1 | 0 | 0 | 0 | 0 | 0 | 45 | 65 | 222 | 0 | 0 | 0 |  | Feb
3333 | 98 | 465 | 16 | 5143 | 513 | 21 | 68 | 987 | 68 | 45 | 0 | 0 |  | Nov
4444 | 8 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Mar
Spreadsheet: 715468d1611721165-need-help-correcting-an-accrual-formula-shareable-time-sheet
Sheet: Sheet1

TIMESHEET
EMPLOYEE'S NAME: |  |  |  |  |  |  |  | FOR THE PAY PERIOD: |  |  |  |  | to
EMPLOYEE'S SIGNATURE: |  |  |  |  |  |  |  | BATTALION CHIEF SIGNATURE:
 |  |  |  |  |  |  |  | CHIEF SIGNATURE:
DAY: | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | TOTAL
DATE: | 2021-01-18 00:00:00
 | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
Regular Time (Hrs)
Overtime (Hrs)
Vacation (Hrs)
[NAME] (Hrs)
Holiday Pay (Hrs)
Total:
 |  |  |  |  |  | Disclaimer: Time-and-a-half is only paid after 106 total hours. Anything under 106 will be paid at straight time……….^^
 |  |  |  |  | 2015-03-05 00:00:00 |  | Prior Balance |  | Used This Period |  | Added This Period |  | Total Remaining
 |  |  |  |  | Vacation (Days): |  |  | - |  | + |  | =
 |  |  |  |  | [NAME] (Days): |  |  | - |  | + |  | =
 |  |  |  |  | Comp Time (Days): |  |  | - | 0 | + | 0 | =
 | NOTES:
Spreadsheet: 61534d1262428899-excel-2007-hours-calculation-example-hours-2
Sheet: TUESDAY

 | 01/01.10 | Agency Drivers Hours Tuesday
Names | Agency Supplier | Comments | Start Time | Finish Time | [NAME] | Paid Hours | O/T Hours
PRESSURE VAN DRIVERS ONLY
SMITH | agency 1 |  | 06:00:00 | 17:00:00
JONES | agency 1 |  | 07:00:00 | 17:00:00
[NAME] | agency 1 |  | 08:00:00 | 20:00:00
 |  |  |  |  |  |  |  |  |  | agency 1
 |  |  |  |  |  |  |  |  |  | agency 2
 |  |  |  |  |  |  |  |  |  | agency 3
LGV DRIVERS ONLY |  |  |  |  |  |  |  |  |  | agency 4
 |  |  |  |  |  |  |  |  |  | agency 5
 |  |  |  |  |  |  |  |  |  | agency 6
PEW | agency 2 |  | 12:00:00 | 20:00:00
PHEW | agency 2 |  | 12:00:00 | 22:00:00
BARNEY | agency 2 |  | 10:00:00 | 23:00:00
McGREW | agency 2 |  | 09:00:00 | 19:00:00
Spreadsheet: 438148d1451788871-trouble-deleting-duplicates-shipment-calculation
Sheet: Staffing Requirements

Staffing Scheduling Program
Period Start | Staff Required | Staff Provided |  | Starts At | Ends At | Staff Level
04:00:00 | 6 |  |  | 04:00:00 | 13:00:00 | 3
05:00:00 | 6 |  |  | 05:00:00 | 14:00:00 | 3
06:00:00 | 6 |  |  | 06:00:00 | 15:00:00 | 0
07:00:00 | 10 |  |  | 07:00:00 | 16:00:00 | 0
08:00:00 | 10 |  |  | 08:00:00 | 17:00:00 | 4
09:00:00 | 10 |  |  | 09:00:00 | 18:00:00 | 0
10:00:00 | 10 |  |  | 10:00:00 | 19:00:00 | 0
11:00:00 | 10 |  |  | 11:00:00 | 20:00:00 | 0
12:00:00 | 12 |  |  | 12:00:00 | 21:00:00 | 5
13:00:00 | 12 |  |  | 13:00:00 | 22:00:00 | 0
14:00:00 | 13 |  |  | 14:00:00 | 23:00:00 | 3
15:00:00 | 14 |  |  | 15:00:00 | 1900-01-01 00:00:00 | 2
16:00:00 | 15 |  |  | 16:00:00 | 1900-01-01 01:00:00 | 0
17:00:00 | 15 |  |  | 17:00:00 | 1900-01-01 02:00:00 | 5
18:00:00 | 15 |  |  | 18:00:00 | 1900-01-01 03:00:00 | 0
19:00:00 | 15 |  |  | 19:00:00 | 1900-01-01 04:00:00 | 0
20:00:00 | 10 |  |  | 20:00:00 | 1900-01-01 05:00:00 | 0
21:00:00 | 10 |  |  | 21:00:00 | 1900-01-01 06:00:00 | 0
22:00:00 | 5 |  |  | 22:00:00 | 1900-01-01 07:00:00 | 0
23:00:00 | 5 |  |  | 23:00:00 | 1900-01-01 08:00:00 | 0
1900-01-01 00:00:00 | 5 |  |  | 1900-01-01 00:00:00 | 1900-01-01 09:00:00 | 0
1900-01-01 01:00:00 | 5 |  |  | 1900-01-01 01:00:00 | 1900-01-01 10:00:00 | 0
1900-01-01 02:00:00 | 5 |  | Varience | 1900-01-01 02:00:00 | 1900-01-01 11:00:00 | 5
Total Staff Hours |  |  |  |  | Total Staff:
Spreadsheet: 881570d1729679415-highlight-closest-value-hammyk-show-difference-cf-365-aligw
Sheet: Example

NO: | LN1: | LN2: |  | PIN1 | PIN2 | PIN READ:
1 | 2245.49 | 2229.9 |  | 2489 | 252.2 | 2236.8
2 | 2237.55 | 2246.39 |  | 2519 | 279.7 | 2239.3
3 | 2159.98 | 2421.63 |  | 2674 | 242.4 | 2431.6
4 | 2285.18 | 2249.69 |  | 2508 | 220.8 | 2287.2
5 | 2300.39 | 2311.6 |  | 2564 | 246
6 | 1139.12 | 1167.35 |  | 1416 | 244.1 | 1171.9
7 | 1202.1 | 1167.87 |  | 1451 | 248.7 | 1202.3
8 | 1178.85 | 1189.09 |  | 1414 | 217.6
THE FORMULA WOULD SHOW THE CLOSEST TO PIN READ (EITHER LN1 OR LN2 IN EACH ROW)
NO: | LN1: | LN2: |  | PIN1 | PIN2 | PIN READ:
1 | 2245.49 | 2229.9 |  | 2489 | 252.2 | 2236.8
2 | 2237.55 | 2246.39 |  | 2519 | 279.7 | 2239.3
3 | 2159.98 | 2421.63 |  | 2674 | 242.4 | 2431.6
4 | 2285.18 | 2249.69 |  | 2508 | 220.8 | 2287.2
5 | 2300.39 | 2311.6 |  | 2564 | 246
6 | 1139.12 | 1167.35 |  | 1416 | 244.1 | 1171.9
7 | 1202.1 | 1167.87 |  | 1451 | 248.7 | 1202.3
8 | 1178.85 | 1189.09 |  | 1414 | 217.6