tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 156417d1337282127-excel-2007-need-to-create-batting-order-depending-on-stats-and-cant-have-a-player-twice-in-line-up-softball-stats-monday-night
Sheet: Game 8

 | Game # | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Total
 | Date | 2012-07-09 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JBC |  |  |  |  |  |  |  | 0 | 0 | 0
 | Location | Jamestown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Vintage Church |  |  |  |  |  |  |  | 0 | 0 | 0
 | Opponent | New Vintage Church
 | Result | Loss
# | Name | G | AB | H | 1B | 2B | 3B | HR | BB | ROE | SAC | R | RBI | BA | OBP | SLG | OPS
1 | Scott |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
2 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
3 | Jared |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
4 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
5 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
6 | Joel |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
7 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
8 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
9 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
10 | Kris |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
11 | [NAME] |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  | n/a | n/a | n/a | n/a
 | TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | n/a | n/a | n/a | n/a
 | MAX
Spreadsheet: 698422d1601979020-vlookup-with-a-varying-range-example
Sheet: Sheet1

Raw Data |  |  |  |  |  |  |  |  |  |  |  | Ordered Data |  |  |  |  |  | Desired Outcome
2020-07-27 00:00:00 |  |  | 2020-07-28 00:00:00 |  |  | 2020-07-30 00:00:00 |  |  | 2020-08-03 00:00:00 |  |  |  | 2020-07-27 00:00:00 | 2020-07-28 00:00:00 | 2020-07-30 00:00:00 | 2020-08-03 00:00:00 |  |  | 2020-07-27 00:00:00 | 2020-07-28 00:00:00 | 2020-07-30 00:00:00 | 2020-08-03 00:00:00
225C | 121.05317 |  | PRW02 | 125.08688 |  | 250B | 120.51 |  | PRW02 | 125.08686 |  | 225C |  |  |  |  |  | 225C | 121.05317 | 121.053 | 121.05322 | 121.05315
230B | 120.84021 |  | PRW01 | 125.30799 |  | 255B | 120.43578 |  | 250B | 120.50998 |  | 230B |  |  |  |  |  | 230B | 120.84021 | 120.84002 | 120.84012
230C | 120.97009 |  | 255B | 120.43556 |  | 255A | 120.54805 |  | 225C | 121.05315 |  | 230C |  |  |  |  |  | 230C | 120.97009 | 120.96984 | 120.97003
250B | 120.50985 |  | 250B | 120.5097 |  | PRW01 | 125.30763 |  | PRW01 | 125.30774 |  | 250B |  |  |  |  |  | 250B | 120.50985 | 120.5097 | 120.51 | 120.50998
255A | 120.5478 |  | 230C | 120.96984 |  | 225C | 121.05322 |  | 255A | 120.54777 |  | 255A |  |  |  |  |  | 255A | 120.5478 |  | 120.54805 | 120.54777
255B | 120.43571 |  | 230B | 120.84002 |  | 230B | 120.84012 |  |  |  |  | 255B |  |  |  |  |  | 255B | 120.43571 | 120.43556 | 120.43578
PRW01 | 125.30785 |  | 225C | 121.053 |  | 230C | 120.97003 |  |  |  |  | PRW01 |  |  |  |  |  | PRW01 | 125.30785 | 125.30799 | 125.30763 | 125.30774
PRW02 | 125.08686 |  |  |  |  |  |  |  |  |  |  | PRW02 |  |  |  |  |  | PRW02 | 125.08686 | 125.08688 |  | 125.08686
Spreadsheet: 04219bf9-30ec-404c-9c7e-005a6ab69431
Sheet: Sheet1

10-041 SOD
PROPOSAL SCHEDULE
Variations from the aforementioned Specifications may be acceptable provided such differences are noted on the bid and are deemed to be advantageous to the City.
Any substitution from brand names mentioned must be proved to be equal and may be considered for award by the Purchasing Agent and requesting department if so proven.
 | [NAME] | Brokers Grass
[NAME] | UNIT PRICE | UNIT PRICE
419 BERMUDA
1A.  DELIVERED | 1.75 | -
1B.  PICKED-UP | 1.75 | 1.79
COMMON BERMUDA
1A.  DELIVERED | 1.75 | -
1B.  PICKED-UP | 1.75 | 1.79
RALEIGH ST. AUGUSTINE
1A.  DELIVERED | 2.3 | -
1B.  PICKED-UP | 2.3 | 2.39
TEX-TURF 10 BERMUDA
1A.  DELIVERED | no bid | -
1B.  PICKED-UP | no bid | -
CAVILIER ZOYSIA GRASS
5A.  DELIVERED | 3.55 | 3.5
609 BUFFALO or PRAIRIE GRASS
1A.  DELIVERED | 3.3 | -
1B.  PICKED-UP | 3.3 | 3.5
PALMETTO ST. AUGUSTINE
1A.  DELIVERED | 2.75 | -
1B.  PICKED-UP | 2.75 | 2.5
 | 2 - 3 DAYS LEAD TIME | -
 | BRANCHES IN CARROLLTON & Dallas within 10 miles of City | I-35
 | 4 Pallets per order | -
Spreadsheet: 106975d1304107622-output-customer-name-for-a-specific-date-range-copy-of-sample-1
Sheet: Sheet1

First Name | Last Name | Date |  | First Name | Last Name
FName 1 | LName1 | 2011-04-19 00:00:00 |  |  |  |  | 2011-04-26 00:00:00
FName 2 | LName2 | 2011-04-02 00:00:00 |  |  |  |  | 2011-04-27 00:00:00
FName 3 | LName3 | 2011-04-27 00:00:00
FName 4 | LName4 | 2011-04-19 00:00:00
FName 5 | LName5 | 2011-04-25 00:00:00
FName 6 | LName6 | 2011-04-26 00:00:00
FName 7 | LName7 | 2011-04-26 00:00:00
FName 8 | [NAME] | 2011-04-26 00:00:00
FName 9 | LName9 | 2011-04-27 00:00:00
FName 10 | [NAME] | 2011-04-19 00:00:00
FName 11 | [NAME] | 2011-04-27 00:00:00
FName 12 | LName12 | 2011-04-19 00:00:00
FName 13 | LName13 | 2011-04-18 00:00:00
FName 14 | [NAME] | 2011-04-27 00:00:00
Spreadsheet: ed4a1ccd-7747-4298-b8db-c28ffcedfe11
Sheet: CAGNY PR - Net Rev FY

GAAP to Non-GAAP Reconciliation
Net Revenues to Organic Net Revenues
For the Twelve Months Ended December 31,
($ in millions, except percentages) ([NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Change
 | As Reported (GAAP) |  | Impact of [NAME] (1) |  | Impact of Acquisitions (2) |  | Impact of Integration Program |  | Impact of Accounting Calendar Changes (3) |  | Impact of Currency |  | Organic (Non-GAAP) |  |  | As Reported (GAAP) |  | Organic  (Non-GAAP)
2011
Kraft Foods North America | 25188 |  | -91 |  | -117 |  | 0 |  | -294 |  | -136 |  | 24550 |  |  | 0.051 |  | 0.048
Kraft Foods Europe | 13356 |  | 0 |  | -201 |  | 0 |  | -403 |  | -632 |  | 12120 |  |  | 0.149 |  | 0.046
Kraft Foods Developing Markets | 15821 |  | 0 |  | -379 |  | 1 |  | -183 |  | -397 |  | 14863 |  |  | 0.162 |  | 0.112
Kraft Foods | 54365 |  | -91 |  | -697 |  | 1 |  | -880 |  | -1165 |  | 51533 |  |  | 0.105 |  | 0.066
2010
Kraft Foods North America | 23966 |  | -547 |  | 0 |  | 0 |  | 0 |  | 0 |  | 23419
Kraft Foods Europe | 11628 |  | 0 |  | 0 |  | 0 |  | -45 |  | 0 |  | 11583
Kraft Foods Developing Markets | 13613 |  | -105 |  | 0 |  | 1 |  | -148 |  | 0 |  | 13361
Kraft Foods | 49207 |  | -652 |  | 0 |  | 1 |  | -193 |  | 0 |  | 48363
(1)  Impact of divestitures includes for reporting purposes Starbucks CPG business.
(2)  Impact of acquisitions reflects the incremental January 2011 operating results from our Cadbury acquisition on February 2, 2010.
(3)  Includes the impacts of accounting calendar changes and the 53rd week of shipments in 2011.
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 7793 | 6031 |  |  | 1235 | 1150 | 1431 | 1283
2 | 7791 | 6031 |  |  | 1177 | 1150 | 1453 | 1283
3 | 5994 | 6031 |  |  | 1174 | 1150 | 1499 | 1283
4 | 7564 | 6031 |  |  | 1155 | 1150 | 1461 | 1283
5 | 7266 | 6031 |  |  | 1111 | 1150 | 1436 | 1283
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 355533
2001-08-05 00:00:00
CBS Volume
 |  |  | 140156
Spreadsheet: 62929d1263914508-sumproduct-would-anyone-have-any-ideas-excel-help
Sheet: Sheet1

Region | Current Headcount | Average Cost per Head | No. hours saved PA | No. Hours worked per annum | Savings (€)
Country 1 | 16.6 | 27583.6758144 | 73.31155250305248 | 1650
Country 2 | 15.6 | 13843.00170528 | 73.3115525030525 | 1650
Country 3 | 59 | 17746.248 | 25 | 1650
Country 4 | 17.2 | 22703.4576144 | 73.3115525030525 | 1650
Country 5 | 14.4 | 80000 | 73.3115525030525 | 1650
Country 6 | 6.2 | 13953.78 | 50 | 1650
Country 7 | 8.38 | 87762.48924 | 73.31155250305248 | 1650
Country 8 | 49.20616 | 95480.496 | 73.31155250305248 | 1650
Country 9 | 0 | 0 | 0 | 0
Country 10 | 35.84 | 90000 | 73.31155250305248 | 1650
Country 11 | 0 | 0 | 0 | 0
Country 12 | 0 | 0 | 0 | 0
Country 13 | 0 | 0 | 0 | 0
 |  |  |  | 1650
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -1797
3531 | -600626 | -295084
60667 | -427042
60749 | 948128 | 82875
61206
61334 | -25143
62960
INDEX
2001-07-31 00:00:00 |  |  | 704039.33
2001-08-22 00:00:00
CBS Volume
 |  |  | 80036
Spreadsheet: 214331d1360866107-building-complex-sales-projections-could-use-some-help-sales-projections-sample
Sheet: Transaction Volumes

Transaction Volume | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals
Smith & Wesson |  | 1166.666666666667 | 2333.333333333333 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500
ABC Company |  |  | 833.3333333333334 | 1666.666666666667 | 2500 | 3333.333333333333 | 4166.666666666667 | 5000 | 5000 | 5000 | 5000 | 5000
Total Transactions | 0 | 1166.666666666667 | 3166.666666666667 | 5166.666666666667 | 6000 | 6833.333333333334 | 7666.666666666667 | 8500 | 8500 | 8500 | 8500 | 8500
Spreadsheet: larry_campbell__20964__Kingman3
Sheet: Netting

[NAME]
RED ROCK EXPANSION PROJECT
KINGMAN COMPRESSOR STATION
Table 3
NETTING CALCULATIONS
Existing Compressor Engines
 |  |  |  | Heat Rate | [NAME]
Unit | Model | hp Rating | Type | Btu/hp-hr | [NAME]/hr
101 | [NAME] 616KVT | 4000 | 4 Cycle [NAME] | 7500
102 | [NAME] 616KVT | 4000 | 4 Cycle [NAME] | 7500
103 | [NAME] 616KVT | 4000 | 4 Cycle [NAME] | 7500
121 | [NAME] | 451 | 4 Cycle [NAME] | 7500
122 | [NAME] | 451 | 4 Cycle [NAME] | 7500 | 3.38
[NAME] (07/00) for 4-Cycle Rich <90% Load
Nox | 2.27 | lb/MMBtu
CO | 3.51 | lb/MMBtu
VOC | 0.0296 | lb/MMBtu
PM | 0.0194 | lb/MMBtu
SO2 | 0.000588 | lb/MMBtu
Historical Operating Hours
 | Year | 101 | 102 | 103 | 121 | 122
 | 2000 | 8549 | 7212 | 6540 | 1600 | 0
 | 1999 | 2427 | 2241 | 2724 | 0 | 0
 | 1998 | 6702 | 6252 | 6449
 | 1997 | 122 | 263 | 191
 | 1996 | 325 | 331 | 242
 | 1995 | 94 | 89 | 42
 | 1994 | 1068 | 253 | 1119
 | 1993 | 1413 | 1801 | 1671
 | 1992 | 3737 | 3292 | 2945
 | 1991 | 7545 | 7147 | 7437
2000-1999 Average
Last 2-Year Emissions Average
Unit | Nox (tpy) | CO (tpy) | VOC (tpy) | PM | SO2
101
102
103
121
122 | 0 | 0 | 0 | 0 | 0
Total
Contemporaneous Emission Increases (tpy)
Turbine
[NAME]
TOTAL
Contemporaneous Emission Decreases (tpy)
Net Change (Increase - Decrease) (tpy)
Assumptions
1. Turbine PM and SO2 emission factors from [NAME] (04/00).
2. Proposed NOx, CO, and VOC emissions based on 80/20 split.  Turbine will operate at 100% load 80% of the time
and 64% load 20% of  the time.
3. Contemporaneous increases are from proposed turbine and generator engine.
4. Contemporaneous decreases are from permanent shutdown of Units 101, 102, 103, 121 and 122.
Spreadsheet: 42147d1240703304-if-cell-x-0-then-copy-range-of-cells-test-book111
Sheet: Sheet1

 |  | Ref no |  | 987654321 | Ref no 2 |  | 123456789
 |  | Pest type |  | Rats | Job Type |  | One Of Treatment
 |  | Invioce Address |  |  |  |  |  |  | Site Address
 |  | Contact name |  | mr smith |  |  |  |  | Site Contact
 |  | Client: |  | a company |  |  |  |  | Client:
 |  | Address: |  | 11 brookbond st |  |  |  |  | Site Address:
 |  | Address: |  | town |  |  |  |  | Site Address:
 |  | Address: |  | district |  |  |  |  | Site Address:
 |  | Postcode |  | wt3 8hy |  |  |  |  | Site Postcode
 |  | [NAME] |  | 213654789 |  |  |  |  | Site Tel
 |  |  |  | Add materials and labour per visit then enter total number of visits
 |  | Rodent control materials |  |  |  |  |  |  | Insect Control Materials
 |  | Ref | Qty | Description | Price | Order | Total |  | Ref | Qty | Description | Price | Order | Total
 |  |  | 2.5 | Brodifacoum 2.5kg blocks | 25 | 1 | 10 |  |  | 12 |  | 26.76 | 0 | 0
 |  |  | 7.5 | [NAME] 50g sachets | 50 | 0 | 0 |  |  | 1 |  | 31.82 | 0 | 0
 |  |  | 10 | Brodifacoum 10kg  loose | 50 | 0 | 0 |  |  | 1 |  | 6.6 | 2 | 13.2
 |  |  | 25 | Brodifacoum  25kg sack | 100 | 0 | 0 |  |  | 1 |  | 18.62 | 0 | 0
 |  |  | 25 | Brodifacoum   25kg  Sewer Bait | 100 | 0 | 0 |  |  | 1 |  | 43.84 | 0 | 0
 |  |  | 1 |  |  | 0 | 0 |  |  | 1 |  | 69.06 | 0 | 0
 |  |  | 1 |  |  | 0 | 0 |  |  | 1 |  | 94.28 | 0 | 0
 |  |  | 1 |  |  | 0 | 0 |  |  | 1 |  | 119.5 | 0 | 0
 |  |  | 1 |  |  | 0 | 0 |  |  | 1 |  | 144.72 | 0 | 0
 |  |  | 2 |  |  | 0 | 0 |  |  | 1 |  | 169.94 | 0 | 0
 |  |  |  | Rodent Materials Total |  |  | 10 |  |  |  | Insect Materials Total |  |  | 13.2
 |  | Labour Per Visit |  |  |  |  |  |  |  |  | Visits
 |  | Number of Men |  | Number of Hrs | [NAME] |  | Total Hrs |  |  | Total No Of Visits |  | 1
 |  | 2 |  | 1 | 10 |  | 2
 |  |  |  | Total Labour Cost |  |  | 20
 |  |  |  | Total Materials Cost |  |  | 23.2
 |  |  |  | Sub Total |  |  | 43.2
 |  |  |  | VAT @ | 15 | % | 6.48
 |  |  |  | Total |  |  | 49.68000000000001
 |  |  |  |  |  | Additional Details
 |  |  |  |  |  |  |  |  | Rats |  | Annual Contract
 |  |  |  |  |  |  |  |  | Mice |  | Short Term Contract
 |  |  |  |  |  |  |  |  | Cockroaches |  | One Of Treatment
 |  |  |  |  |  |  |  |  | Ants |  | Additional Treatment
 |  |  |  |  |  |  |  |  | Wasps
Spreadsheet: 08c063f8-d7da-4fab-991e-2052d1088ffc
Sheet: Sheet1

Unnamed: 0 | To Sort, press all at same time: CTRL+SHIFT+S | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | 20 Closest Lots Data Ranked by FAR | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  |  |  |  |  | for:  (ADDRESS)
 | Address | Data Source |  | Lot Size in |  |  | Garage |  |  | FAR
 | (Optional) | (Ex: Co. Assessor's Office) | APN | net sq. ft. | Floors | House | /Carport | Total | FAR | Rank
 |  |  |  |  |  |  |  | 0 |  | 1 | Largest
 |  |  |  |  |  |  |  | 0 |  | 2
 |  |  |  |  |  |  |  | 0 |  | 3
 |  |  |  |  |  |  |  | 0 |  | 4
 |  |  |  |  |  |  |  | 0 |  | 5
 |  |  |  |  |  |  |  | 0 |  | 6
 |  |  |  |  |  |  |  | 0 |  | 7
 |  |  |  |  |  |  |  | 0 |  | 8
 |  |  |  |  |  |  |  | 0 |  | 9
 |  |  |  |  |  |  |  | 0 |  | 10
 |  |  |  |  |  |  |  | 0 |  | 11
 |  |  |  |  |  |  |  | 0 |  | 12
 |  |  |  |  |  |  |  | 0 |  | 13
 |  |  |  |  |  |  |  | 0 |  | 14
 |  |  |  |  |  |  |  | 0 |  | 15
 |  |  |  |  |  |  |  | 0 |  | 16
 |  |  |  |  |  |  |  | 0 |  | 17
 |  |  |  |  |  |  |  | 0 |  | 18
 |  |  |  |  |  |  |  | 0 |  | 19
 |  |  |  |  |  |  |  | 0 |  | 20
 |  |  |  |  |  |  |  | 0 |  | 21 | Smallest
 |  |  |  |  |  |  | Average/Mean Total of House + Garage  Size (including project proposal): | 0
 |  |  |  |  |  |  | Average/Mean FAR (including project proposal): |  |  | Revised 8-21-07
 |  |  |  |  |  | 20 Closest Lots Data Ranked by Size
 |  |  |  |  |  | for:  (ADDRESS)
 | Address | Data Source |  | Lot |  |  | Garage
 | (Optional) | (Ex: Co. Assessor's Office) | APN | Size | Floors | House | /Carport | Total | Rank
 |  |  |  |  |  |  |  | 0 | 1 | Largest
 |  |  |  |  |  |  |  | 0 | 2
 |  |  |  |  |  |  |  | 0 | 3
 |  |  |  |  |  |  |  | 0 | 4
 |  |  |  |  |  |  |  | 0 | 5
 |  |  |  |  |  |  |  | 0 | 6
 |  |  |  |  |  |  |  | 0 | 7
 |  |  |  |  |  |  |  | 0 | 8
 |  |  |  |  |  |  |  | 0 | 9
 |  |  |  |  |  |  |  | 0 | 10
 |  |  |  |  |  |  |  | 0 | 11
 |  |  |  |  |  |  |  | 0 | 12
 |  |  |  |  |  |  |  | 0 | 13
 |  |  |  |  |  |  |  | 0 | 14
 |  |  |  |  |  |  |  | 0 | 15
 |  |  |  |  |  |  |  | 0 | 16
 |  |  |  |  |  |  |  | 0 | 17
 |  |  |  |  |  |  |  | 0 | 18
 |  |  |  |  |  |  |  | 0 | 19
 |  |  |  |  |  |  |  | 0 | 20
 |  |  |  |  |  |  |  |  | 21 | Smallest
 |  |  |  |  |  |  | Average/Mean House [NAME] (including project proposal): | 0
 |  |  |  |  |  |  |  |  |  | Revised 8-21-07
 | Parcels Omitted
 | from 20 Closest Lots Data
 |  |  |  | Optional Information
 | Address | Property Use |  | Lot |  |  | Garage |  |  | Data Source
 | (Optional) | (Ex. Comm., Multi-Family) | APN | Size | Floors | House | /Carport | Total | FAR | (Ex. Co. Assessor's)
 |  |  |  |  |  |  |  |  |  | Form posted 8-20-07
Spreadsheet: john_arnold__15204__KCS VPP Volumes
Sheet: crude

KCS VPP Volumes
Crude
 | Total | Total
 | Monthly | Daily
Month | [NAME] | [NAME]
2001-02-01 00:00:00 | 55747.63421100604
2001-03-01 00:00:00 | 53341.06926063549
2001-04-01 00:00:00 | 51057.39323207742
2001-05-01 00:00:00 | 48890.00982738396
2001-06-01 00:00:00 | 46832.68990060494
2001-07-01 00:00:00 | 44879.55097734807
2001-08-01 00:00:00 | 43025.03794943051
2001-09-01 00:00:00 | 41263.90487789922
2001-10-01 00:00:00 | 39591.19784162399
2001-11-01 00:00:00 | 38002.23877236663
2001-12-01 00:00:00 | 36492.61022071705
2002-01-01 00:00:00 | 36004.59521872499
2002-02-01 00:00:00 | 34618.12063306775
2002-03-01 00:00:00 | 33293.79854790089
2002-04-01 00:00:00 | 32041.89373929686
2002-05-01 00:00:00 | 30851.07307008313
2002-06-01 00:00:00 | 29718.20126820315
2002-07-01 00:00:00 | 28640.31917359387
2002-08-01 00:00:00 | 27614.63430827536
2002-09-01 00:00:00 | 26638.51200431283
2002-10-01 00:00:00 | 25709.46705972781
2002-11-01 00:00:00 | 24825.15589429106
2002-12-01 00:00:00 | 23983.36917888534
2003-01-01 00:00:00 | 22756.98104824573
2003-02-01 00:00:00 | 22006.01470204304
2003-03-01 00:00:00 | 21291.11179877965
2003-04-01 00:00:00 | 20610.56265707997
2003-05-01 00:00:00 | 19962.75989429659
2003-06-01 00:00:00 | 19346.19350458133
2003-07-01 00:00:00 | 18707.4103279764
2003-08-01 00:00:00 | 18099.57056294542
2003-09-01 00:00:00 | 17519.39729782609
2003-10-01 00:00:00 | 16965.41988123845
2003-11-01 00:00:00 | 16436.25217766528
2003-12-01 00:00:00 | 15930.58743915596
2004-01-01 00:00:00 | 15491.29687609817
2004-02-01 00:00:00 | 15027.26384256652
2004-03-01 00:00:00 | 14583.28365485502
2004-04-01 00:00:00 | 14158.32111415589
2004-05-01 00:00:00 | 13751.39927609601
2004-06-01 00:00:00 | 13361.59598376844
2004-07-01 00:00:00 | 12988.04061729969
2004-08-01 00:00:00 | 12629.91104577165
2004-09-01 00:00:00 | 12286.43076829088
2004-10-01 00:00:00 | 11956.86623190155
2004-11-01 00:00:00 | 11640.52431487788
2004-12-01 00:00:00 | 11336.74996471052
2005-01-01 00:00:00 | 10594.46225576748
2005-02-01 00:00:00 | 10349.06370508045
2005-03-01 00:00:00 | 10112.33519334319
2005-04-01 00:00:00 | 9883.87124266133
2005-05-01 00:00:00 | 9663.287536828107
2005-06-01 00:00:00 | 9450.219765863507
2005-07-01 00:00:00 | 9244.322534904079
2005-08-01 00:00:00 | 9045.268333826298
2005-09-01 00:00:00 | 8852.746564190447
2005-10-01 00:00:00 | 8666.462620284692
2005-11-01 00:00:00 | 8486.137021230901
2005-12-01 00:00:00 | 8311.504591285186
2006-01-01 00:00:00 | 8093.068797730671
2006-02-01 00:00:00
Total
Spreadsheet: 337295d1407313189-formula-to-copy-last-6-cells-with-data-football-form-guide-form-guide
Sheet: Sheet1

 | Form Guide |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last 6 matches |  |  |  |  |  | Wins | Draws | Total Pts
Arsenal | W | D | W | W | L | D | W | W | D | L | D | W | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | D | L | D | W | W
[NAME] | D | L | D | W | D | L | L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | D | W | D | L | L
Burnley
Chelsea
Crystal Palace
Everton
Hull
Leicester
Liverpool
Man City
Man Utd
Newcastle
QPR
Southampton
Stoke
Sunderland
Swansea
Tottenham
WBA
West Ham
Spreadsheet: 0f5d1feb-673f-48ff-af58-740d1807e773
Sheet: 1.20

Table 1.20: Life expectancy at birth for total population, by country, sex and years
Country | Year | Male | Female | Total
Bahrain
 | 1999 | 71.1 | 75.3 | 72.9
 | 2005 | 72.1 | 76.3 | 73.8
 | 2007 | 73.1 | 77.3 | 74.8
 | 2011 | 74.7 | 76.1 | 75.3
Egypt
 | 2000 | 66.7 | 71 | 68.9
 | 2005 | 68.8 | 73.5 | 71
 | 2010 | 68.2 | 70.9 | 69.6
 | 2012 | 69 | 71.7 | 70.4
Iraq
 | 1997 | 85 | 59 | 58.5
 | 2008 | 59.1 | 62.2 | 60.6
 | 2011 | 67.4 | 70.6 | …
Jordan
 | 2002 | 70.6 | 72.4 | 71.5
 | 2007 | 71.6 | 74.4 | 73
 | 2008 | 71.6 | 74.4 | 73
Morocco
 | 2004 | 70.6 | 73 | 71.7
 | 2005 | 70.8 | 73.2 | 72
 | 2007 | 71.2 | 73.7 | 72.4
 | 2010 | 71.8 | 74.4 | 73.1
 | 2012 | 72.2 | 74.9 | 73.5
Oman
 | 1999 | … | … | 72.5
 | 2005 | 73.2 | 75.4 | 74.28
 | 2007 | 70.4 | 73.6 | 72
 | 2009 | 70 | 75.7 | 72.7
 | 2010 | 73.6 | 77 | 76.1
 | 2011 | 73.1 | 77.7 | 75.4
Palestine
 | 1997 | 70.2 | 71.7 | 71.1
 | 2005 | 71.7 | 73 | 72.4
 | 2007 | 70 | 72.6 | 71.3
 | 2010 | 70.8 | 73.6 | 72.4
 | 2012 | 71 | 74.1 | 72.7
Table 1.17: Life expectancy at birth for total population, by country, sex and years (continued)
Country | Year | Male | Female | Total
Qatar
 | 2006 | 76.7 | 77.2 | 77
 | 2007 | 77.6 | 77.9 | 77.6
 | 2010 | 78 | 78.7 | 78.2
 | 2011 | 76.5 | 81 | 78.6
Saudi Arabia
 | 2005 | 72 | 74 | 73
 | 2007 | 72.2 | 74.3 | 73.3
 | 2009 | 72.5 | 74.7 | 73.5
 | 2010 | 72.6 | 74.9 | 73.7
 | 2012 | 72.8 | 75.2 | 73.9
Sudan
 | 2008 | 56.5 | 59.6 | 57.1
Syrian Arab Republic
 | 2004 | 71.9 | 73.8 | 72.8
 | 2005 | 71 | 75 | 73
 | 2009 | 71.6 | 74.7 | 73.1
Tunis
 | 2005 | 71.6 | 75.5 | 73.5
 | 2007 | 72.3 | 76.2 | 74.2
 | 2009 | 72.5 | 76.5 | 74.5
 | 2010 | 72.7 | 76.6 | 74.7
 | 2011 | 72.9 | 76.9 | 74.9
United Arab Emirates
 | 1999 | 75.8 | 77.4 | 76.6
 | 2000 | 76.2 | 80.6 | 78
 | 2005 | 76.7 | 79.1 | 77.9
 | 2007 | 75.6 | 78.6 | 76.9
 | 2009 | 76.2 | 80.1 | 77.7
Yemen
 | 1999 | 60.4 | 61.3 | 59.5
 | 2004 | 60.2 | 62 | 61.1
 | 2005 | 61.1 | 62.9 | 62
 | 2007 | 61.1 | 62.9 | 62
 | 2009 | 61.1 | 62.9 | 62
 | 2010 | 62.1 | 63.9 | 63
 | 2012 | 62.1 | 63.9 | 63
Spreadsheet: 830043d1684663498-help-with-if-calculation-formula-deemed-selling-price
Sheet: Sheet1

 | Kindly ask for help with excel formula to produce the desirwd solution below. The current formular on row 9 is working but if cell [NAME] is blank it is not working.
 |  | Passenger motor [NAME] | Machinery | Curent YR | Asset 1 | Asset 2 | Asset 3
 | Cost | 15000 | 40000 | 15000
 | [NAME] | 10000 |  | 20000
 | Actual selling price | 9000 | 40000 | 9000
 | [NAME] selling price
 | Desired Solution
 |  | Passenger motor [NAME] | Machinery | Curent YR | Asset 1 | Asset 2 | Asset 3
 | Cost | 15000 | 40000 | 15000
 | [NAME] | 10000 |  | 20000
 | Actual selling price | 9000 | 40000 | 9000
 | [NAME] selling price |  | 40000