tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: drew_fossum__8687__Fixed3_113000
Sheet: ENA #QA5217.1-Expired

NORTHERN NATURAL GAS COMPANY
FUEL HEDGING BOOK
Enron North America
Deal #QA5217.1
Prod. | Contract | Contract | NNG |  | Notional | ENA |  | (Gains) and Losses
Date | Number | Name | Fixed |  | Quantity | Floating |  | (Gains) and Losses
 |  |  | Price |  |  | Price |  | Total | Realized | Unrealized
 |  |  |  |  |  | [NAME]. Onshor S.-Midpoint
 |  |  |  |  |  | [NAME] | Spread | (4) | (4) | (4)
2000-11-18 00:00:00 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
 |  | ENA | 5.855 |  | 9615
2000-11-18 00:00:00 |  | NNG |  |  | -9615 | 5.635
 |  | NNG |  |  | -9615 | 5.635
 |  | NNG |  |  | -9615 | 5.635
 |  | NNG |  |  | -9615 | 6.235
 |  | NNG |  |  | -9615 | 6.34
 |  | NNG |  |  | -9615 | 6.315
 |  | NNG |  |  | -9615 | 6.315
 |  | NNG |  |  | -9615 | 6.315
 |  | NNG |  |  | -9615 | 6.315
 |  | NNG |  |  | -9615 | 6.315
 |  | NNG |  |  | -9615 | 6.245
 |  | NNG |  |  | -9615 | 5.925
 |  | NNG |  |  | -9615 | 5.95
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 | -87778 | -89330
2 | -88047 | -88502
3 | -87233 | -80452
4 | -85404 | -89090
5 | -78965 | -79090
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-07-31 00:00:00 |  |  |  |  | 390629.78
2001-08-05 00:00:00
CBS Volume
 |  |  | 458
Spreadsheet: 875220d1721803365-resource-pool-to-dropdown-multi-reference-dropdown-list-question
Sheet: Sheet1

orange | Random1 | blue
blue | Random2 | orange
red | Random3 | red |  |  | For example: D1 should be a dropdown with the following data:
[NAME] | Random4 | [NAME] |  |  |  | Random6
orange | Random5 | red |  |  |  | Random10
blue | Random6 | [NAME] |  |  |  | Random14
red | Random7 | orange |  |  |  | Random18
[NAME] | Random8 | blue |  |  |  | Random22
orange | Random9 | blue |  |  |  | Random26
blue | Random10 | blue |  |  |  | Random30 |  | option 1 | option 2 | option 3
red | Random11 | blue |  |  |  | Random34
[NAME] | Random12 | blue |  |  |  | Random38 |  |  | Random1
orange | Random13 | blue |  |  |  | Random42 |  |  | Random3
blue | Random14 | blue |  |  |  | Random46 |  |  | Random4
red | Random15 | blue |  |  |  | Random50 |  |  | Random7
[NAME] | Random16 | blue |  |  |  |  |  |  | Random8
orange | Random17 | blue |  |  |  |  |  |  | Random5
blue | Random18 | blue |  |  |  |  |  |  | Random6
red | Random19 | blue |  |  |  |  |  |  | Random10
[NAME] | Random20 | blue |  |  |  |  |  |  | Random14
orange | Random21 |  |  |  |  |  |  |  | Random18
blue | Random22 |  |  |  |  |  |  |  | Random22
red | Random23 |  |  |  |  |  |  |  | Random26
[NAME] | Random24 |  |  |  |  |  |  |  | Random30
orange | Random25 |  |  |  |  |  |  |  | Random34
blue | Random26 |  |  |  |  |  |  |  | Random38
red | Random27 |  |  |  |  |  |  |  | Random42
[NAME] | Random28 |  |  |  |  |  |  |  | Random46
orange | Random29 |  |  |  |  |  |  |  | Random50
blue | Random30
red | Random31
[NAME] | Random32
orange | Random33
blue | Random34
red | Random35
[NAME] | Random36
orange | Random37
blue | Random38
red | Random39
[NAME] | Random40
orange | Random41
blue | Random42
red | Random43
[NAME] | Random44
orange | Random45
blue | Random46
red | Random47
[NAME] | Random48
orange | Random49
blue | Random50
 |  |  |  |  | I have 4 columns in Excel  Two first columns are column A and column B and go from 1 to 50 Column A is filled with repeating values of orange, blue, red, brown Column B is filled with random names  Column C goes from 1 to 20 and is populated with values from column A (orange, blue, red, brown) via drop down lists  I now want a column D, going from 1 to 20, to have the use of drop down lists populated with all the values from column B that are next to the value in column A that corresponds with the value in the cell next to it in column C (which will be one of the 4 values existing in column A, orange, blue, red, brown)  How can I populate my drop down lists for the column D
Spreadsheet: 827387d1682661698-how-to-make-a-consensus-list-consensus1-aligw
Sheet: Sheet1

Player # |  | Class | Strength | Experience | [NAME] |  |  | Player # | Order |  | AliGW:
1 |  | 2 | 11 | 6 | 10 |  |  | 11 | 1 |  |  | 1
2 |  | 6 | 2 | 12 | 11 |  |  | 2 | 2 |  | 2 | 2
3 |  | 11 | 10 | 4 | 1 |  |  | 6 | 2 |  | 6 | 2
4 |  |  | 12 |  |  |  |  | 10 | 2 |  | 10 | 2
5 |  |  |  |  |  |  |  | 12 | 2 |  | 12 | 2
6
7
8
9
10
11
12
13
Spreadsheet: rick_buy__32797__NP Daily Marks
Sheet: Breakdown

The New Power Company
Breakdown by Product
 |  |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS | Capacity Corr. |  |  | Per CAS |  |  |  | Per CAS
 | COB 8/27/01 | COB 8/28/01 |  | COB 8/29/01 | COB 8/29/01 | Difference |  | COB 9/4/01 | COB 9/4/01 | Difference |  | COB 9/6/01 | COB 9/6/01 | Difference |  | COB 9/10/01 | COB 9/10/01 | Difference |  | COB 9/12/01 | COB 9/12/01 | Difference |  | COB 9/17/01 | COB 9/17/01 | Difference |  | COB 9/18/01 | COB 9/18/01 | Difference | COB 9/19/01 | COB 9/20/01 |  | Daily Change
Financial MTM | 49947286 | 55858213 |  | 57692146 | 57692146 |  |  | 46484930 | 46484930 |  |  | 46043210 | 46043210 |  |  | 44910437 | 44910437 |  |  | 42269727 | 42269727 |  |  | 41763715 |  |  |  | 48406572 |  |  |  | 54912946
Gas MTM | 4691838 | 4946778 |  | 5061950 | 5061950 |  |  | 4923532 | 4923532 |  |  | 4872850 | 4872850 |  |  | 10151598 | 10151598 |  |  | 4747637 | 4747637 |  |  | 5004111 |  |  |  | 5458453 |  |  | 5910950 | 5809999
Gas Purchases |  | -596668 |  | -601718 | -601718 |  |  | -1209051 | -1209051 |  |  | -1333842 | -1333842 |  |  | -1333845 | -1333845 |  |  | -1333852 | -1333852 |  |  | -1333861 |  |  |  | -1408374 |  |  | -804194 | -804194
Gas Sales |  | 7435080 |  | 7435080 | 7435080 |  |  | 15290816 | 15290816 |  |  | 15053482 | 15053482 |  |  | 15054186 | 15054186 |  |  | 15054427 | 15054427 |  |  | 15060666 |  |  |  | 15066560 |  |  | 8027587 | 8033044
Total Gas
Power MTM | 52787394 | 54029592 |  | 54402992 | 54402992 |  |  | 53378304 | 53378304 |  |  | 7690871 | 7690871 |  |  | 48353305 | 48353305 |  |  | 46016089 | 46016089 |  |  | 37433537 |  |  |  | 45334327 |  |  | 49514316 | 51629206
Power Purchases | -82546945 | -85660468 |  | -88773990 | -18720422 |  |  | -102241362 | -19885207.79999999 |  |  | -37773032 | -19885207.79999999 |  |  | -45558719 | -19885207.79999999 |  |  | -53584206 | -19885207.79999999 |  |  | -66720218 | -19885207.79999999 |  |  | -50001684 | -19885207.79999999 |  | -6923427.8 | -7158407.8
Power Sales | 108806923 | 112835527 |  | 116864132 | 16183721 |  |  | 135064396 | 16702984 |  |  | 41539165 | 16702984 |  |  | 52171599 | 16702984 |  |  | 62833553 | 16702984 |  |  | 80573957 | 16702984 |  |  | 67422539 | 16702984 |  | 5220184 | 5267164
Total Power
Total Exposure
Treashold Amt. | -15000000 | -15000000 |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | -15000000 | -15000000 |  |  | 0 | 0 |  | 0 | 0
Collateral Posted | -87300000
Margin due to ENE
Spreadsheet: 849529d1699973485-combine-3-sheets-data-into-1-final-sheet-book1-2-1-2-
Sheet: Win Report SNGLS

Name | Score | CLASS
Spreadsheet: 525374d1498685809-count-number-of-occurrencies-for-account-number-copy-of-test-file-2-bh-mng-
Sheet: EXPECTED RESULTS

account number | name | address | attended | helper | ACCOUNT NUMBER | NAME | TIMES ATTENDED
1 | [NAME] doe | 1234 drive | 1 |  | 1 | [NAME] doe
1 | [NAME] doe | 1234 drive | 1 |  | 2 | mary
1 | [NAME] doe | 1234 drive | 1 |  | 3 | [NAME]
1 | [NAME] doe | 1234 drive | 1 |  | 4 | [NAME]
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 0
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 0
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 0
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
Spreadsheet: 845239d1696761158-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerold
Sheet: Handicaps

Team/Hcap | StartHcp
Team1
Player1 | 12 | 12 | 11 | 10 | 11 | 12 | 12 | 12 | 12
Player2 | 17 | 17 | 16 | 15 | 16 | 17 | 17 | 17 | 17
Player3 | 16 | 16 | 15 | 14 | 15 | 16 | 16 | 16 | 16
Player4 | 17 | 17 | 16 | 15 | 16 | 17 | 17 | 17 | 17
Team2
Player5 | 10
Player6 | 15
Player7 | 19
Player8 | 22
Team3
Player9 | 15
Player10 | 20
Player11 | 25
Player12 | 28
Team4
Player13 | 13
Player14 | 19
Player15 | 21
Player16 | 22
Team5
Player17 | 12
Player18 | 14
Player19 | 19
Player20 | 23
Team6
Player21 | 17
Player22 | 19
Player23 | 22
Player24 | 25
Team7
Player22 | 10
Player23 | 16
Player24 | 22
Player25 | 25
Spreadsheet: 600720d1543930127-sum-with-multiple-criteria-example
Sheet: Sheet1

P1 | 2018-12-04 00:00:00
 | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason
 | 5 | Briefing | 15 | Meetings |  |  |  |  |  |  | 12 | Meetings
 | 2 | Quality Issue | 2 | Breakdown |  |  |  |  |  |  | 5 | Breakdown
P2 | 2018-12-04 00:00:00
 | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason | Hours | Reason
 | 11 | Meetings | 3 | Briefing |  |  |  |  |  |  | 55 | Quality Issue
 | 4 | Breakdown
Spreadsheet: 581434d1531301910-compare-2-sheets-and-show-balance-bbsn
Sheet: IN HAND

CODE | CUSTOMER NAME | ADDRESS | DATE OF KEEPING | Serial Number | Item Name | Gross Weight | Net Weight | Principal | Remarks | Column1 | Column2
Spreadsheet: 08c741ef-5677-48f0-bb06-8b9dad6a9c0b
Sheet: Sheet1

Unnamed: 0 | IDR | Unnamed: 2 | OR | Unnamed: 4 | D  → D | Unnamed: 6 | D  → O | Unnamed: 8 | Unnamed: 9 | O  → O | Unnamed: 11 | O  → D | Unnamed: 13 | Unnamed: 14
Dataset | n | % | n | % | n | % | n | % | P-value | n | % | n | % | P-value
DM | 26 | 61.90476190476191 | 16 | 38.09523809523809 | 17 | 65.38461538461539 | 9 | 34.61538461538461 | - | 2 | 12.5 | 14 | 87.5 | -
Poly | 11 | 47.82608695652174 | 12 | 52.17391304347826 | 10 | 90.9090909090909 | 1 | 9.090909090909092 | 0.2236 | 0 | 0 | 12 | 100 | 0.492
NES | 23 | 67.64705882352942 | 11 | 32.35294117647059 | 22 | 95.65217391304348 | 1 | 4.347826086956522 | 0.01212 | 0 | 0 | 11 | 100 | 0.499
Spreadsheet: 71347d1272014679-need-help-with-my-report-spreadsheet-report-spreadsheet
Sheet: email data

Id | Date | Time | Day | AM / PM | Week | Profile Code | Profile Description | email address (URN) | Postal address | Town | Postcode | Channel | Data Owner | Owner (Site) | Client name | Subject line | Creative | Offer | Product | Sector | Exisiting / New client
7 | 2010-04-11 00:00:00 | 11:09:00 | Sun | 11:09:00 | 16 | P5 | Female 30 | [EMAIL] | 30 Gillingham Street | London | SW1V 1HU | email | [NAME] | getmeaticket | Getmeaticket | Savanna, win a BMW 1 Series |  |  | Online Marketing | Lifestyles | Existing |  |  |  |  |  |  |  |  |  | Webclubs | webclubs
8 | 2010-04-13 00:00:00 | 13:08:00 | Tue | 13:08:00 | 16 | P3 | Male 30 | [EMAIL] | 30 Gillingham Street | London | SW1V 1HU | email | DMRI | win4now | Win4now | Competition entry summary |  |  | Provence Holiday | Travel | Existing |  |  |  |  |  |  |  |  |  | DLG | surveys
9 | 2010-04-18 00:00:00 | 16:15:00 | Sun | 16:15:00 | 17 | P3 | Male 30 | [EMAIL] | 30 Gillingham Street | London | SW1V 1HU | email | IPT | myoffers | MyOffers | WIN a year's worth of free groceries - Closes 30th April |  |  | [NAME] | Online Marketing | Existing |  |  |  |  |  |  |  |  |  | Plumprizes | Plumprizes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
Spreadsheet: 272059d1382175388-if-cell-has-data-the-look-up-value-example-list-rovert7-191013_2
Sheet: Price list

Item | Price |  | Sub Total |  |  | Variant | Item | -- use for slight different name from item list
Charm | 0.5 |  |  |  |  | b'fly | butterfly
Letter | 0.5 |  |  |  |  | butterfly | butterfly
Box | 0.65 |  |  |  |  | butterflies | butterfly
Pillow | 0.85 |  |  |  |  | Box | Box
butterfly | 0.3 |  |  |  |  | Boxes | Box
 |  |  |  |  |  | Pillow | Pillow
 |  |  |  |  |  | [NAME] | Pillow
Spreadsheet: 168521d1342482877-formula-to-calculate-if-employee-is-working-on-each-half-hour-workhrs-from-start-and-end-rota2-1-
Sheet: Rota

 |  | Total
Employee | Start | Finish | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
[NAME] | 15:00:00 | 01:00:00
Nathan | 18:00:00 | 02:00:00
[NAME] | 15:00:00 | 23:00:00
[NAME] | 05:00:00 | 18:00:00
It might look beter like the below…
 | Employee | [NAME] | [NAME] | [NAME] | Marv
 | Start | 09:00:00 | 10:50:00 | 14:00:00 | 04:58:00
Total | Finish | 14:25:00 | 22:35:00 | 18:00:00 | 13:15:00
 | 04:00:00
 | 04:30:00
 | 05:00:00
 | 05:30:00
 | 06:00:00
 | 06:30:00
 | 07:00:00
 | 07:30:00
 | 08:00:00
 | 08:30:00
 | 09:00:00
 | 09:30:00
 | 10:00:00
 | 10:30:00
 | 11:00:00
 | 11:30:00
 | 12:00:00
 | 12:30:00
 | 13:00:00
 | 13:30:00
 | 14:00:00
 | 14:30:00
 | 15:00:00
 | 15:30:00
 | 16:00:00
 | 16:30:00
 | 17:00:00
 | 17:30:00
 | 18:00:00
 | 18:30:00
 | 19:00:00
 | 19:30:00
 | 20:00:00
 | 20:30:00
 | 21:00:00
 | 21:30:00
 | 22:00:00
 | 22:30:00
 | 23:00:00
 | 23:30:00
Spreadsheet: 714564d1611283593-latesbalance-sum-categories-forum-excel-21-jan-2021
Sheet: Épargnes Inv.

1) | [NAME] for latest balance (cells D6 to D9) |  |  |  |  | Thanks again for taking the time:) !! I appreciate it!
2) | [NAME] to update CLOSING BALANCE after each deposit/withdrawal and ANNUAL REPORT (Column G)
3) | [NAME] to know profit loss on the "ANNUAL REPORT" (Column F)
 | Solde actuel des comptes: | RED
 |  | BLUE
 |  | YELLOW
 |  | GREEN
Date | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE
2020-03-01 00:00:00 | Deposit | RED | 200
2020-03-01 00:00:00 | Deposit | BLUE | 300
2020-03-01 00:00:00 | Deposit | RED | 25
2020-03-05 00:00:00 | Withdrawal | RED | -30
2020-03-11 00:00:00 | Withdrawal | BLUE | -45
2020-03-13 00:00:00 | Withdrawal | RED | 20
2020-03-01 00:00:00 | Deposit | YELLOW | 60
2020-03-01 00:00:00 | Deposit | GREEN | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | RED | 0 | 230 |  | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | BLUE | 0 | 320 |  | 320 |  | Expected result 65$
2020-05-01 00:00:00 | Annual report (balance now at 55$) | YELLOW | 0 | 55 |  | 65 |  | Expected result -5$
2020-05-01 00:00:00 | Annual report (balance now at 77$) | GREEN | 0 | 77 |  | 77 |  | Expected result -3$
2020-06-15 00:00:00 | Withdrawal | RED | -50
2020-06-15 00:00:00 | Withdrawal | BLUE | -60
2020-06-15 00:00:00 | Withdrawal | YELLOW | -40
2020-06-15 00:00:00 | Withdrawal | GREEN | -70
2021-01-01 00:00:00 | Deposit | RED | 120
2021-01-01 00:00:00 | Deposit | BLUE | 100
2021-01-01 00:00:00 | Deposit | YELLOW | 90
2021-01-01 00:00:00 | Deposit | GREEN | 80
2020-03-01 00:00:00 | Deposit | RED | 200
Spreadsheet: 60ddcb45-7a4c-477b-89d7-cb33a3e92f80
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3843 | 14816 | Su | Pretto | AUS | 0 | [NAME] | 00:01:14 | 01:26:27 | 00:01:32 | 00:21:30 | 1 | 02:30:37
3843 | 26093 | Narelle | Talbot | AUS | 0 | 00:42:18 | 00:00:49 | 01:28:13 | 00:01:04 | [NAME] | 2 | 02:35:14
3843 | 26092 | [NAME] | [NAME] | AUS | 0 | 00:45:53 | 00:01:10 | 01:39:18 | 00:01:26 | 00:26:05 | 3 | 02:53:54
3843 | 26091 | Trish | Guy | AUS | 0 | 00:54:41 | 00:01:32 | 01:47:34 | 00:01:46 | 00:30:41 | 4 | 03:16:18
Spreadsheet: dae655a9-f50e-4761-8884-4dbe7acebde7
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Offshoreutstyr
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
[NAME] | Industriv. 40 | 1337 | Sandvika | 67 13 69 80 | 67 13 46 35
ACE Winches Norge AS | Sothammargeilen 9 | 4029 | Stavanger | 51 83 95 20
[NAME] | Øyav. 60 | 4270 | Åkrehamn | 52 84 45 20
Aukra Maritime AS | Nautnes | 6480 | Aukra | 71 17 17 00
Trelleborg Offshore Norway AS | Kalosjeg. 15 | 3055 | [NAME] | 32 23 20 00
[NAME] | Fyrstikkalléen 17 | 0661 | Oslo | 22 70 68 00 | 22 70 68 01
Maritim Service AS | [NAME] | 5450 | Sunde i Sunnhordland | 53 48 29 29 | 53 48 29 20
Marine Aluminium AS | Husøyv. 165 | 4262 | Avaldsnes | 52 84 84 00
PSSI AS | [NAME] g 6 | 3012 | Drammen | 400 04 325 | 32 89 90 91
Cosalt Offshore Norway AS | Bekhuskaien 1 | 4013 | Stavanger | 51 55 45 00
Bull industri- og skipsteknisk as | Ringeriksv. 241 | 1340 | Skui | 67 17 54 00
[NAME] | Høgslundv. 49 | 2020 | Skedsmokorset | 06706
Origo Solutions AS | Kanalarmen 12 | 4033 | Stavanger | 920 80 500
GearConsult | Griniv. 159 | 1359 | Eiksmarka | 400 08 003
Jumo AS | Storg. 2B | 1767 | Halden | 67 97 37 10 | 67 97 37 11
Apply Leirvik AS | Storhaugv. 130 | 5416 | Stord | 53 49 62 00 | 53 49 62 01
Origo Solutions AS | Teknologiv. | 4846 | Arendal | 920 80 500
Scana Offshore Vestby AS | Tverrv. 4 | 1540 | Vestby | 64 95 65 00 | 64 95 65 01
Origo Solutions AS | Skipperg. 12 | 3921 | Porsgrunn | 920 80 500
Origo Solutions AS | [NAME] | 4623 | Kristiansand | 920 80 500
Northrop Grumman [NAME] BV | Damsgårdsv. 167 | 5160 | Laksevåg | 55 94 94 94 | 55 34 52 27
Øglænd System AS | Engelsvollv. 264 | 4353 | Klepp stasjon | 51 78 81 00 | 51 78 81 60
[NAME] | Stålverksv. 1 | 0661 | Oslo | 22 70 77 00 | 22 70 77 01
Vinje Industri AS | Skibåsen 10A | 4636 | Kristiansand | 38 03 88 00
Dril-Quip Europe Ltd | Lagerv. 31 | 4033 | Stavanger | 51 44 37 00 | 51 44 37 01
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 47868d1247039966-ranking-ranges-of-differing-dimensions-example
Sheet: Sheet1

The 17:55 from BANGOR, a 2m 1f hurdle race. (Grade 5)
Pos. | Placed | Name | [NAME] | Trainer | Decimal Odds | Rank
1 | Y | [NAME] | MR O GREENALL | R LEE | 2.1 | 1
2 | Y | My Condor | J M MAGUIRE | D MCCAIN JNR | 4.5 | 2
3 | Y | Wages | T J O'BRIEN | B N POLLOCK | 9 | 4
4 |  | Prioryjo | F DAVIS | I MCMATH | 5.5 | 3
5 |  | Dream On Dreamers | P ASPELL | R C GUEST | 21 | 5
6 |  | Feels Right | [NAME] | G A HAM | 67 | 6
7 |  | Shadow Jumper | S J CRAINE | J T STIMPSON | 67 | 6
The 18:25 from BANGOR, a 2m 1f hurdle race. (Grade 4)
Pos. | Placed | Name | [NAME] | Trainer | Decimal Odds
1 | Y | Thumbs Up | J M MAGUIRE | D MCCAIN JNR | 2.75 | 1
2 | Y | Sambulando | P J BRENNAN | T R GEORGE | 9.5 | 4
3 | Y | Kack Handed | A TINKLER | H D DALY | 2.88 | 2
4 |  | Rouge Et Blanc | L ASPELL | O SHERWOOD | 9 | 3
5 |  | Dona | W HUTCHINSON | A KING | 10 | 5
6 |  | Tarvini | R P MCLERNON | [NAME] | 21 | 6
7 |  | Snark | [NAME] | SIMON EARLE | 151 | 9
8 |  | [NAME] | T SCUDAMORE | W CLAY | 34 | 7
9 |  | [NAME] | M BRADBURNE | B ECKLEY | 67 | 8
10 |  | Mister [NAME] | C POSTE | S WYNNE | 201 | 10
The 18:55 from BANGOR, a 2m 1f 110yds chase handicap race. (Grade 4)
Pos. | Placed | Name | [NAME] | Trainer | Decimal Odds
1 | Y | [NAME] Deux | P J BRENNAN | T R GEORGE | 2.5 | 1
2 | Y | Sea Robber | GERARD TUMELTY | J S SMITH | 15 | 3
3 |  | Troodos Jet | B HUGHES | MRS [NAME] SAYER | 3.75 | 2
4 |  | Lanos | [NAME] | W DAVIES | 26 | 4
The 19:25 from BANGOR, a 2m 4f 110yds chase handicap race. (Grade 3)
Pos. | Placed | Name | [NAME] | Trainer | Decimal Odds
1 | Y | Tarotino | W HUTCHINSON | A KING | 4.5 | 2
2 | Y | Thunder Rock | R P MCLERNON | [NAME] | 15 | 6
3 | Y | Sou'wester | J TIZZARD | C L TIZZARD | 7.5 | 4
4 |  | [NAME] | T J O'BRIEN | P J HOBBS | 4.33 | 1
5 |  | Almaydan | MR O GREENALL | R LEE | 17 | 7
6 |  | [NAME] | R FLINT | B RYALL | 7 | 3
7 |  | Livingonaknifedge | P ASPELL | R C GUEST | 17 | 7
8 |  | Corlande | J M MAGUIRE | D MCCAIN JNR | 10 | 5
The 19:55 from BANGOR, a 3m 110yds chase race. (Grade 6)
Pos. | Placed | Name | [NAME] | Trainer | Decimal Odds
1 | Y | Worship The Stars | MR J MAHOT | MRS M SCUDAMORE | 3.5 | 1
2 | Y | Cash In Hand | MR A WEDGE | R HARVEY | 15 | 4
3 | Y | [NAME] | MR S ROSS | S ROSS | 7 | 3
4 |  | Father Murtagh | MR G BREWER | MISS F HARTLEY | 17 | 5
5 |  | Moorlands Return | MR I POPHAM | RICHARD HAWKER | 29 | 6
6 |  | Thirtytwo Red | J GUERRIERO | R J ALFORD | 5 | 2
7 |  | Clear The Line | MR W KINSEY | S ROSS | 67 | 7
The 20:25 from BANGOR, a 2m 1f hurdle handicap race. (Grade 3)
Pos. | Placed | Name | [NAME] | Trainer | Decimal Odds
1 | Y | Toshi | M BRADBURNE | J S GOLDIE | 7.5 | 2
2 | Y | Prideus | W HUTCHINSON | A KING | 12 | 5
3 | Y | Kempley Green | T SCUDAMORE | M SCUDAMORE | 19 | 7
4 |  | Good Spirit | J M MAGUIRE | JENNIE CANDLISH | 7 | 1
5 |  | Princeful | S THOMAS | MISS V WILLIAMS | 8 | 3
6 |  | Circus of Dreams | L ASPELL | O SHERWOOD | 11 | 4
7 |  | Like A Duke | J TIZZARD | C L TIZZARD | 21 | 8
8 |  | [NAME] | M O'CONNELL | S GOLLINGS | 23 | 9
9 |  | [NAME] | GERARD TUMELTY | A KING | 15 | 6
Spreadsheet: 98255d1297246979-average-last-five-non-blank-cells-average-of-last-5
Sheet: Sheet1

Numbers | Helper Col | Helper DO
3 |  |  |  | <<Average of the Last 5 non blanks
2 |  |  |  | <<DO's Answer with helper
 |  |  |  | <<DO's Answer with no helper
5 |  |  |  | <<Canapone's Answer
4
5 |  |  | Put numbers in Column A
8 |  |  | Make sure Helper row  is filled in
 |  |  | See answer in yellow abov
5
5
6