tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 013803b7-d9f3-4229-8d59-1b8266be0bc2
Sheet: Sheet1

Registration form Battle of Utrecht 5 october 2014 Netherlands | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
All registrations need to be received, complete, before 21 september 2014 sunday to:[EMAIL]
Organisation: |  |  |  |  |  |  |  |  |  |  | City:
Address: |  |  |  |  |  |  |  |  |  |  | Telephonenumber:
Zip code: |  |  |  |  |  |  |  |  |  |  | E-mail:
Name coaches |  |  |  |  |  | Name umpires |  |  |  | License: |  | Grade |  | E-mail umpire
 |  |  |  |  |  |  |  |  |  |  |  | Gup / Dan
1) |  |  |  |  |  | 1
2) |  |  |  |  |  | 2
3) |  |  |  |  |  | 3
4) |  |  |  |  |  | 4
Nr: |  | Name: |  | First name |  | Date of birth |  | Gender |  | Grade |  | Weight |  | Lenght |  | Category |  | Sparring |  | Patterns |  | Pre
 |  |  |  |  |  | Day / Month / Year |  | Male / Female |  | Kup / Dan |  | Kg. |  | Cm. |  | Jun / Sen. |  |  |  |  |  | Arranged | fill in
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes / No |  | Yes / No |  | Yes / No | team number 1-2-3…
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 883048d1731530286-extracting-the-time-in-and-out-for-the-employee-report-book1
Sheet: Expected result

Production / Fulfillment/OPEX | Mon, Oct 28
 | In | Out
[NAME] | 23:20:00 | 09:34:00
[NAME] | 22:54:00 | 08:00:00
Divine Ale | 22:50:00 | 08:01:00
[NAME] | 22:51:00 | 08:00:00
IT Support | 22:53:00 | 08:00:00
Production | 22:15:00 | 08:00:00
[NAME] | 22:30:00 | 08:00:00
[NAME] | 22:32:00 | 08:00:00
[NAME] | 22:34:00 | 08:00:00
[NAME] | 22:35:00 | 08:00:00
[NAME] | 22:36:00 | 08:00:00
9600 [NAME] Reyes | 22:37:00 | 08:00:00
9602 [NAME] | 22:41:00 | 08:00:00
Spreadsheet: 839305d1691813976-excel-formula-to-calculate-stock-transaction-sample-67-
Sheet: Sheet1

Date | Type | Stock | Transacted Units | Transacted Price (per unit) | Comm | Cls Fee | Tdg Fee | Buying Fee | SGX SI Fee | GST Fee | Fees | Stock [NAME] | Previous Units | Cumulative Units | Transacted Value | Previous Cost | Cost of Transaction | Avg Stock Price | Cumulative Cost | Gains/Losses from Sale | [NAME]  %
2023-05-03 00:00:00 | Buy | ABC | 300 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 |  | 1
2023-05-22 00:00:00 | Div | ABC | 300 | 0.42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2023-11-08 00:00:00 | Div | ABC | 300 | 0.48 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2023-08-12 00:00:00 | Buy | ABC | 400 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 | 34.01000000000001 | 1
2023-08-15 00:00:00 | Buy | ABC | 500 | 32.44 | 27.25 | 3.16 | 0.73 | 0 | 0.35 | 2.52 | 34.01000000000001 | 1
 |  |  |  |  |  |  |  |  |  |  | Expected Result |  | 700 | 1200 | 16254.01 | 22776.02 |  |  | 39030.03
Spreadsheet: kate_symes__19132__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-18 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832
 | 2001-04-17 00:00:00 |  | 273.89 | 15536 | 203.31 | 7832 | 337.92 | 120 | 157.38 | 965
 | 2001-04-16 00:00:00 |  | 379.99 | 21296 | 356.66 | 8480 | 359.26 | 135 | 202.5 | 100
 | 2001-04-15 00:00:00 |  | 368.33 | 1200 | 350 | 0 | 400 | 50 | 325 | 25 |  | 357.42 | 27864
 | 2001-04-14 00:00:00 |  | 369.89 | 22096 | 344.35 | 6848 | 365.25 | 505 | 346 | 0
 | 2001-04-13 00:00:00 |  | 369.89 | 22096 | 343.87 | 6048 | 392.86 | 420 | 421.33 | 60
 | 2001-04-12 00:00:00 |  | 411.66 | 16160 | 376.19 | 5352 | 431.44 | 1740 | 339.62 | 419
 | 2001-04-11 00:00:00 |  | 386.02 | 10560 | 337.56 | 7552 | 391.16 | 540 | 372.42 | 291
 | 2001-04-10 00:00:00 |  | 379.15 | 19760 | 331.04 | 9192 | 398 | 621 | 337.4 | 615
 | 2001-04-09 00:00:00 |  | 311.43 | 19600 | 264.75 | 6584 | 334.15 | 437 | 337.5 | 100
 | 2001-04-08 00:00:00 |  | 273.75 | 1600 | 255 | 0 | 349.76 | 1330 | 342.22 | 135 |  | 264.68 | 20136
 | 2001-04-07 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 293.05 | 1559 | 279.89 | 435
 | 2001-04-06 00:00:00 |  | 291.19 | 18496 | 225.83 | 11824 | 290.88 | 400 | 227.31 | 325
 | 2001-04-05 00:00:00 |  | 348.81 | 22560 | 266.94 | 2480 | 259.38 | 200 | 158.94 | 610
 | 2001-04-04 00:00:00 |  | 314.36 | 18160 | 238.83 | 8040 | 307.45 | 455 | 246.52 | 460
 | 2001-04-03 00:00:00 |  | 305.4 | 18160 | 224.33 | 7200 | 300.45 | 350 | 288.25 | 1310
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504 | 294.16 | 942 | 216.95 | 351
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 | 2001-03-19 00:00:00 |  | 397.48 | 26800 | 342.53 | 7360 | 398.47 | 1222 | 145.95 | 454
 |  |  |  |  |  | ..
Spreadsheet: 92832d1292363676-i-need-some-help-with-2-crucial-exam-questions-excel-vragen
Sheet: Sheet1

Question 3
Selling icecreams in the period 2008-2010 |  |  |  |  | Which year was the best for selling ice-creams? Use IF and MAX functions to solve this problem?
 | 2008 | 2009 | 2010 |  | Year
January | 82 | 92 | 89
February | 87 | 81 | 92
March | 87 | 65 | 77
April | 103 | 365 | 230
May | 382 | 406 | 399
June | 412 | 354 | 389
July | 364 | 602 | 480
August | 584 | 393 | 380
September | 406 | 112 | 300
October | 104 | 74 | 80
November | 70 | 69 | 78
December | 75 | 58 | 66
Question 4 | Use if and AND functions to solve this question |  |  | Name | Age | Income per year
Age | Income/ per year |  |  | [NAME] | 39
0-25 | 30000 |  |  | de Boer | 42
26-50 | 40000 |  |  | de Vries | 51
51-67 | 50000 |  |  | [NAME] Vaart | 65
68-120 | 40000 |  |  | [NAME] | 78
Question 6
Make an simulation game in excel throwing 100 times with a dice. Use if and random functions to create this program
How many times appear each outcome of the dice? What is the simulation probability of each outcome?
What is the expected value of the dice according to this simulation?
Result |  | Outcome | How many times appear each outcome
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | Total
 |  | Expected Value
Spreadsheet: 220814d1363273122-trying-to-figure-out-best-way-to-write-formula-book4
Sheet: Sheet1

 | January | February | March | April | May | June | July | August | September | October | November | December | Total | YTD
Receipts
Actual 2013 | 643209 | 665290
Projected | 605891 | 731021 | 497902 | 767000 | 663060 | 983204 | 1267144 | 1833038 | 1268972 | 1385752 | 1278142 | 1113088
[NAME]
2012 Actual | 650640 | 585007 | 612614 | 654069 | 652564 | 801971 | 1336486 | 1614350 | 1303850 | 1274715 | 1337073 | 1515194
Spreadsheet: 590385d1537078042-display-corresponding-name-for-same-number-kench-bsb-
Sheet: Sheet1

1 | Name | Product A | Product B | Total | Helper Column |  | Rank | Score | Name
2 | [NAME] | 90 | 29 | 119 |  |  | 1
3 | [NAME] | 20 | 8 | 28 |  |  | 2
4 | [NAME] | 98 | 101 | 199 |  |  | 3
5 | Teresa | 0 | 0 | 0 |  |  | 4
6 | Melisa | 66 | 53 | 119 |  |  | 5
Spreadsheet: 758059d1638613321-sumifs-with-date-problem-accounts-test
Sheet: Categories

[Categories]
[Balance]
[Transfer]
***** INCOME *****
Flat 1
Flat 2
Flat 3
Flat 4
Flat 5
Flat 6
Flat 7
Flat 8
Flat 9
1 Mews
2 Mews
3 Mews
4 Mews
5 Mews
6 Mews
Income Other
Sundry Debtors - 2014
Consolidated Receipt
***** SCHEDULE 1 *****
Building Insurance inc Public Liability
Engineering Insurance - Lift
Electricity
Water
Cleaning
Maintenance
Electrical Repairs
Door Entry System
Fire Systems Maintenance
Lift Contract
[NAME]
External Decoration Reserve
Internal Decoration Reserve
Gardening
Telephone
Accountancy/Annual Returns YTC
Sundry Expenses
Fire Risk Assessment
General Risk Assessment
Portable Appliance Testing
10 Year Planned Maintenance Schedule
Out of Hours Emergency Service
Legal Expenses Insurance
Management Fees
Professional Fees
Interest Received
***** SCHEDULE 2 *****
Gates Maintenance
Directors Insurance
Accountancy/Annual Returns
Legal Expenses Insurance
Company Secretary
Legal Expenses Insurance
Postage & Copying
Engineering Insurance - Gates
Insurance inc Public Liability - Courtyard
Annual Safety Tests
Parking - General Repairs
Painting
Weed Control
Electricity - Courtyard
***** SCHEDULE 3 - GARAGES *****
Garages - General Repairs
Insurance - Garages
Creditors
Consolidated Payment
Transfer Funds
Spreadsheet: 685829d1594217287-highlight-when-a-patient-needs-to-be-transferred-to-another-hospital-medical
Sheet: Drop Down Menus

Hospital Sites | Column1 | Primary Treatment | Column2 | Adjuvant Treatment | Column3
ASPH | Primary | Surgery | 3 | PORT
ESH | Recurrence | Radiotherapy | 6 | Palliative Radiotherapy
FPH | Progression | Chemo/Radiotherapy | 6 | Palliative Chemotherapy
NHH | No Cancer Diagnosed | Chemotherapy | 6 | BSC
QVH |  | Monitor | 1
RSCH |  | Transfer Care | 1
Private |  | Palliative Radiotherapy | 4
Other |  | Palliative Chemotherapy | 4
 |  | BSC | 1
Spreadsheet: 161843d1339651344-copy-paste-data-with-matching-criteria-from-different-sheet-for-help-form
Sheet: Receipt

Date | item Code | Description | UOM | [NAME] | Qty Received
2012-06-01 00:00:00 | 5262 | HIGH SPEED DIESEL | LTR | OB | 481
2012-06-05 00:00:00 | 5262 | HIGH SPEED DIESEL | LTR | 232 | 1000
2012-06-07 00:00:00 | 5262 | HIGH SPEED DIESEL | LTR | 1214 | 190
2012-06-08 00:00:00 | 5262 | HIGH SPEED DIESEL | LTR | 5823 | 200
2012-06-10 00:00:00 | 5262 | HIGH SPEED DIESEL | LTR | 9937 | 15000
Spreadsheet: 06c89f04-af0a-4e0e-b3e0-0f4a38830d98
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Calculate pounds needed for Commodity Processing | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Commodity Processing vs. Purchased | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
Processor Name |  | AAA Chicken Processor
Commodity Code |  | A522
Commodity Value per pound |  | 0.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Commodity Processing |  |  |  |  | Purchased Cost
Product Code | Product Description | Commodity Code | Finished Case Weight | serving size (oz) | Estimated No of Servings | \ | Servings Per Case | = | Total Finished Cases Needed | X | Amount of Commodity DF per case (in pounds) | = | No of Commodity Pounds need to order | Processing Fee per case | Processing Fee Per Serving | Value of Commodity DF per case | Commodity Value per Serving | Total Cost per Serving for Processing | Purchased Case Price | Cost per serving | Best Deal
99999 | Chicken Nugget Spicy | A522 | 30 | 3.56 | 10000 |  | 135 |  | 74.07407407407408 |  | 22.93 |  | 1698.518518518518 | 24.1 | 0.1785185185185185 | 14.9045 | 0.1104037037037037 | 0.2889222222222222 | 47.36 | 0.3508148148148148 | Commodity Processing
99976 | [NAME] | A522 | 30 | 2.05 | 7500 |  | 234 |  | 32.05128205128205 |  | 36 |  | 1153.846153846154 | 28.75 | 0.1228632478632479 | 23.4 | 0.1 | 0.2228632478632478 | 50 | 0.2136752136752137 | Purchase
 |  |  |  |  |  | TOTAL Commodity Pounds Needed |  |  |  |  |  | 2852.364672364673
Spreadsheet: 900ab232-c19d-47e5-977b-af1724a72197
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42278047 | 2014-07-13 04:35:00 | AXIS | 1 | 7 | 3 | 1562796 | johnatrva | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42278232 | 2014-07-13 04:52:29 | ALLIES | 0 | 4 | 7 | 1562796 | johnatrva | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42278409 | 2014-07-13 05:27:31 | AXIS | 0 | 3 | 10 | 979406 | homez | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42278641 | 2014-07-13 06:22:39 | ALLIES | 0 | 7 | 10 | 979406 | homez | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42279037 | 2014-07-13 06:53:01 | AXIS | 1 | 5 | 0 | 1529214 | bionkansoue | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
42279312 | 2014-07-13 07:40:55 | AXIS | 0 | 2 | 6 | 1602211 | Spaceman2 | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
42374785 | 2014-07-20 06:42:16 | AXIS | 1 | 4 | 3 | 1604992 | player1604992 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42374896 | 2014-07-20 07:04:50 | ALLIES | 1 | 4 | 3 | 1604992 | player1604992 | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42375084 | 2014-07-20 07:36:32 | AXIS | 1 | 7 | 5 | 1362585 | NEMAUS | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42375269 | 2014-07-20 08:05:08 | ALLIES | 0 | 1 | 7 | 1362585 | NEMAUS | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42375514 | 2014-07-20 08:26:08 | ALLIES | 1 | 6 | 5 | 1362585 | NEMAUS | 7471 | mediterranean | 1942-06-05 | 1942-06-05 | Into the Cauldron | Le Chaudron
42375746 | 2014-07-20 08:59:33 | AXIS | 0 | 2 | 6 | 475647 | Steelie | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42375993 | 2014-07-20 09:20:15 | AXIS | 0 | 1 | 6 | 1573406 | sylvbarbe | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42376119 | 2014-07-20 09:40:51 | ALLIES | 1 | 6 | 4 | 1573406 | sylvbarbe | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42376294 | 2014-07-20 10:18:59 | ALLIES | 0 | 5 | 10 | 1607258 | player1607258 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 732150d1620798776-formula-needed-to-assign-a-number-based-on-value-and-then-add-those-numbers-formula-help
Sheet: Sheet1

"AH4" |  | "AV4" |  | "BJ4" | "BK4" |  | "CD4" | "CE4" | "CF4" |  | "DF4"
0.16 |  | 0.15 |  | 0.13 | 0.13 |  | 0.1 | 0.1 | 0.1 |  | 21
"AH5" |  | "AV5" |  | "BJ5" | "BK5 |  | "CD5" | "CE5" | "CE5" |  | "DF5"
0.13 |  | 0.12 |  | 0.13 | 0.13 |  | 0.15 | 0.15 | 0.15 |  | 17
 |  | total cells: | 20
 |  |  |  |  |  | "AG4" | "AH4" |  | "AU4" | "AV4" |  | "BI4" | "BJ4" | "BK4" |  | "CC4" | "CD4" | "CE4" | "CF4" |  | "DF4"
 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 | 9 |  |  |  |  |  | "3" |  |  | "3" |  |  | "3" | "3" |  |  | "3" | "1" | "1"
 | 22
 | 15
 | 16
 | 18
 | 73
 | 14
 | 1
 | 5
 | 7
 | 2
 | 94
 | 100
 | 13
 | 2
 | 5
 | 2
 | 11
 | 2
Spreadsheet: phillip_m_love__30152__9905_OA
Sheet: CE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | 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 | 46055997 | 105225079
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 20240342 | 46092175
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 66296339 | 151317254
 | Purchases:
6 |  | 3rd Party / Inter Enron | -39778827 | -89690039 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -26987857 | -61385107
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 333756 | 726383
 | Total Purchases: |  | -66432928 | -150348763
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 2812410 | 6475934
14 |  | Cash Out | -2858336 | -6575369
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | -45926 | -99435
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 182515 | 413524.96556
23 | Fuel: |  | -333756 | -726383
 | Transport Expense:
24 |  | Commodity | 0 | -83193
25 |  | Demand | 0 | -2261341
 | Total Transport Expense: |  | 0 | -2344534
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | 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 | 1086087
31 |  | Prior Month Book Balance | 0 | -2230799
 |  | Total MTM Income | 0 | -1144712
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 2293654.05882353
34 |  | Originations | 0 | 106310.5
35 |  | Broker Fees | 0 | -10679
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 1385895
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 331813
 |  | TOTAL INTRA-MTH
Spreadsheet: darrell_schoolcraft__7220__saledoc11_6TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2001-11-27 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 11/28/01 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.43
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
11/28/01 | 11/28/01 | 20000 |  | 20000 |  | 20000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
California Border |  |  | 10487 |  | 20000 |  |  |  | 22940
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 841309d1693496958-match-date-on-two-different-pages-and-paste-data-in-columns-copy-of-ef-file
Sheet: 12-4 Night

 | CR1 | Priority | Headcount | QI
1 | Alinity RV | 16 | 0.25 | Xavier
2 | Alinity RV | 15 | 0.25 | Dezree
3 | Alinity RV | 14 | 0.25 | Noemy
4 | Alinity RV | 13 | 0.25 | [NAME]
5 | Alinity RV | 12 | 0.25
12 | [NAME] | 17 | 0.25
13 | [NAME] | 18 | 0.25
9 | Architect RV | 11 | 0.25
15 | [NAME] | 20 | 0.5
17 | Architect RV | 10 | 0.25
31 | Architect RV | 9 | 0.25
8 | Architect RV | 8 | 0.25
10 | Architect RV | 7 | 0.25
11 | [NAME] | 19 | 0.33
18 | Architect RV | 6 | 0.25
19 | Architect RV | 5 | 0.25
20 | [NAME] | 21 | 0.5
21 | Architect RV | 4 | 0.25
22 | Architect RV | 3 | 0.25
23 | Architect RV | 2 | 0.25
7 | Architect SC | 1 | 0.25
Total
 | CR2 | Priority
73 | 8ul PQ-4hours | 1 | 1
74 | Side Cassette | 1
78 | PP3 | 2
79 | V102 | 3
77 | PP1 | 4 | 0.25
87 | [NAME] | 5
53 | Architect RV | 6 | 0.2
61 | [NAME] | 10 | 0.5
66 | [NAME] | 9 | 0.5
84
86 | [NAME] | 8 | 0.25
62 | NP 227 | 16 | 0.25
63 | NP 104 | 15 | 0.25
67 | NP 228 | 14 | 0.25
88 | [NAME] | 11 | 0.25
107
108 | Alinity [NAME] Key3 | 12 | 0.2
109
Total
Grand Total
Spreadsheet: 35959d1233693939-exlcusion-test
Sheet: Sheet1

index | name | address
121213 | dd | 123 main
559494 | dd | 124 main
54548 | dd | 125 main
154888 | dd | 126 main
7884454 | dd | 127 main
14545 | dd | 128 main
Spreadsheet: 24479d1214913448-colour-cells-based-on-condition-book2
Sheet: Sheet1

2008-04-25 00:00:00 | 1 | S23450 | SSL | 2007-10-15 00:00:00 | Atkins | extension of Body- Atique Latif | 22257.61
2008-04-25 00:00:00 | 2 | NA | BCV | 2008-05-01 00:00:00 | Atkins | extension of body - [NAME] | 21600
2008-04-25 00:00:00 | 3 | NA | SSL | 2008-04-01 00:00:00 | CCD | New starter and extension of body - Adrian Wheatley | 61158.53
39563 | 4 | NA | BCV | 39569 | Metro Selection | ` | 14937
39563 | 5 | NA | SSL | 39314 | Interfleet | New starter of Body - Bruce Littlewood | 50000
39563 | 6 | NA | SSL | 39571 | Interfleet | Extension of Body Bruce Little wood | 17822
39563 | 7 | NA | SSL | 39566 | URS | New starter of Body - Carlton Stephenson | 7600
39563 | 8 | B71626 | BCV | 39559 | Griffens | New starter of [NAME] | 11550 | 1 | GILLESPIE, [NAME] | B71626 | 051425 | 000836 | GIFFEN GROUP PLC | Electrical Engineer [NAME] |  |  |  | 11550 | GILLESPIE, [NAME]
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A35

TABLE A35   FREQUENCY OF PRICE SPIKES IN THE NEW ENGLAND THIRTY-MINUTE OPERATING RESERVE MARKET AFTER ISO-NE REVISIONS
PRICE EQUALS OR EXCEEDS | FY 00/99 | FY 99/98
 | # of hours
 | % of available hours
100 | 17 | NA
 | 0.00194
250 | 3 | NA
 | 0.00034
500 | 0 | NA
 | 0
750 | 0 | NA
 | 0
1000 | 0 | NA
 | 0
Source:  ISO-NE Website (www.iso-ne.com).
FY 00/99: 8/16/1999-8/15/2000
FY 99/98: 8/16/1998-8/15/1999
Spreadsheet: 792474d1660917474-multiple-conditional-format-to-compare-rows-with-a-target-cell-example-sheet
Sheet: Sheet1

Score | ALL | A* | A | B | C | D | E | U
0.691176470588235 | 0.58 | 0.92 | 0.76 | 0.59 | 0.52 | 0.36 | 0.26 | 0.26 |  | I need to compare each row (B1 --> I1) with the value in the same row but column A
0.720588235294117 | 0.53 | 0.86 | 0.75 | 0.58 | 0.45 | 0.31 | 0.12 | 0.09
0.647058823529411 | 0.38 | 0.77 | 0.57 | 0.38 | 0.28 | 0.15 | 0.11 | 0.07
0.426470588235294 | 0.3 | 0.84 | 0.46 | 0.23 | 0.15 | 0.06 | 0.04
0.88235294117647 | 0.79 | 1.25 | 1.07 | 0.9 | 0.66 | 0.48 | 0.22 | 0.1
1.10294117647058 | 1.01 | 2.07 | 1.48 | 1.11 | 0.65 | 0.4 | 0.15 | 0.04
0.794117647058823 | 0.62 | 0.84 | 0.75 | 0.62 | 0.56 | 0.51 | 0.39 | 0.34
1.29411764705882 | 1.04 | 2.19 | 1.55 | 0.97 | 0.68 | 0.39 | 0.28 | 0.07
1.30882352941176 | 1.22 | 1.81 | 1.4 | 1.21 | 1.09 | 0.95 | 0.83 | 0.64
0.441176470588235 | 0.48 | 0.7 | 0.53 | 0.51 | 0.43 | 0.38 | 0.33 | 0.22
Spreadsheet: 81151d1281416645-return-a-value-for-a-number-that-falls-between-two-numbers-within-a-large-array-excel_example
Sheet: traffic

road_id | location | carrway_start_m
48 | 620
48 | 1100
48 | 1300
5029 | 10
280 | 30
280 | 250