tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 877034d1723719957-possibly-a-countif-and-or-date-lookup-formula-required-grim72-sample-lookup-data-365-aligw
Sheet: Sheet1

completed_at | By Salesman | Product | Action
2024-01-03 08:31:32 | [NAME] | Van | Quote |  |  |  |  | Total Contacts | Jan | Feb | Mar
2024-01-04 07:55:50 | [NAME] | Car | Sale | 1 |  |  | [NAME] | 12 | 4 | 0 | 8
2024-01-08 07:05:42 | [NAME] | [NAME] | Sale | 1 |  |  | [NAME] | 4 | 2 | 0 | 2
2024-01-08 07:06:26 | [NAME] | Tractor | Quote | 1 |  |  | Connor | 4 | 1 | 0 | 3
2024-01-15 08:52:06 | [NAME] | Van | Quote | 1 |  |  | [NAME] | 1 | 0 | 0 | 1
2024-01-17 08:38:23 | [NAME] | Van | Quote | 1 |  |  | Cammy | 4 | 0 | 0 | 4
2024-01-24 08:00:07 | Connor | Car | Quote | 1 |  |  | TOTAL
2024-03-01 07:36:47 | [NAME] | Tractor | Quote | 3
2024-03-05 07:31:27 | [NAME] | Van | Quote | 3
2024-03-06 07:56:42 | [NAME] | Van | Quote | 3 |  |  |  | Total Sales | Jan | Feb | Mar
2024-03-07 06:22:32 | [NAME] | Van | Quote | 3 |  |  | [NAME] |  | 1 | 0 | 0
2024-03-07 12:41:49 | [NAME] | Van | Quote | 3 |  |  | [NAME] |  | 1 | 0 | 0
2024-03-07 12:48:30 | [NAME] | Van | Quote | 3 |  |  | Connor |  | 0 | 0 | 0
2024-03-07 12:56:03 | [NAME] | Van | Quote | 3 |  |  | [NAME] |  | 0 | 0 | 0
2024-03-08 06:20:15 | [NAME] | Van | Quote | 3 |  |  | Cammy |  | 0 | 0 | 3
2024-03-11 06:26:00 | [NAME] | Van | Quote | 3 |  |  | TOTAL
2024-03-15 10:29:50 | Connor | Car | Quote | 3
2024-03-21 07:48:36 | Connor | Car | Quote | 3
2024-03-21 07:55:53 | [NAME] | Tractor | Quote | 3 |  |  |  | Total Quotes | Jan | Feb | Mar
2024-03-21 09:56:48 | [NAME] | Van | Quote | 3 |  |  | [NAME] |  | 3 | 0 | 8
2024-03-22 07:18:59 | Cammy | Van | Sale | 3 |  |  | [NAME] |  | 1 | 0 | 2
2024-03-28 06:05:14 | Connor | Car | Quote | 3 |  |  | Connor |  | 1 | 0 | 3
2024-03-28 09:13:21 | Cammy | Van | Sale | 3 |  |  | [NAME] |  | 0 | 0 | 1
2024-03-29 08:19:41 | Cammy | Van | Sale | 3 |  |  | Cammy |  | 0 | 0 | 1
2024-03-29 09:24:05 | Cammy | [NAME] | Quote | 3 |  |  | TOTAL
Spreadsheet: 27269d1220427061-gas-and-milage-formula-not-working-out-gas
Sheet: Oct 08

 |  |  |  |  |  |  |  |  |  |  |  |  | 45
 | Refuel Date | [NAME] | Km | Litres  put in | Liters    over | Liters in Car | R Cost | KM/L | R cost per KM | Price Of Petrol | Date of increase
 |  | 240463 |  | (fuel added) |  |  |  | (KM)
 | 2008-08-21 00:00:00 | 240900 | 437 | 42.445 | 2.555 | 45 | 432.939 | 10.29567675815762 | 0.9907070938215102 | 10.2 | 2008-08-06 00:00:00
 | 2008-08-26 00:00:00 | 241311 | 411 | 42.65 | 2.350000000000001 | 45 | 435.03 | 9.636576787807737 | 1.058467153284671 | 10.2
 | 2008-08-29 00:00:00 | 241716 | 405 | 40.59 | 4.409999999999997 | 45 | 414.018 | 9.977827050997782 | 1.022266666666667 | 10.2
 | 2008-09-02 00:00:00 | 241907 | 191 | 16.67 | 28.33 | 45 | 170.034 | 11.45770845830834 | 0.8902303664921466 | 10.2
 | 2008-09-03 00:00:00 |  |  | 40.82 | 4.18 | 45 | 388.1982 |  |  | 9.51 | 2008-09-03 00:00:00
Spreadsheet: 223975d1364397468-conditionally-subtracting-dates-in-one-column-and-averaging-the-difference-sample_color_workbook
Sheet: Sheet1

Date | Color | [NAME]. | Arb. # | Ident. 1 | Ident. 2 |  | Color | Frequency | Av. Time Between
2013-01-23 00:00:00 | Blue |  | 1 |  |  |  | Blue
2013-01-24 00:00:00 | Black |  | 2 |  |  |  | Black
2013-01-25 00:00:00 |  |  |  |  |  |  | Pink
2013-01-28 00:00:00 |  |  |  |  |  |  | Purple
2013-01-29 00:00:00 |  |  |  |  |  |  | [NAME]
2013-01-30 00:00:00 | Pink |  | 3 |  |  |  | Orange
2013-01-31 00:00:00 |  |  |  |  |  |  | Red
2013-02-01 00:00:00 | Purple |  | 4 |  |  |  | Gray
2013-02-04 00:00:00 |  |  |  |  |  |  | White
2013-02-05 00:00:00 | [NAME] |  | 5 |  |  |  | Green
2013-02-06 00:00:00 | Orange |  | 6 |  |  |  | Violet
2013-02-07 00:00:00 | Red |  | 7 |  |  |  | Yellow
2013-02-11 00:00:00 | Gray |  | 8 |  |  |  | [NAME]
2013-02-12 00:00:00 | Pink |  | 3 |  |  |  | Teal
2013-02-13 00:00:00 | Blue |  | 1 |  |  |  | Silver
2013-02-14 00:00:00 | White |  | 9 |  |  |  | [NAME]
2013-02-15 00:00:00 | Green |  | 10 |  |  |  | Gold
2013-02-19 00:00:00 | Violet |  | 11
2013-02-20 00:00:00 | Yellow |  | 12
2013-02-21 00:00:00 | Black |  | 2
2013-02-22 00:00:00 | Blue |  | 1
2013-02-25 00:00:00 | Orange |  | 6
2013-02-26 00:00:00 | [NAME] |  | 13
2013-02-27 00:00:00 | Teal |  | 14
2013-02-28 00:00:00 | Silver |  | 15
2013-03-01 00:00:00 | [NAME] |  | 5
2013-03-04 00:00:00 | Black |  | 2
2013-03-05 00:00:00 | Purple |  | 4
2013-03-06 00:00:00 | [NAME] |  | 16
2013-03-07 00:00:00 | Gold |  | 17
2013-03-08 00:00:00 | Violet |  | 11
2013-03-11 00:00:00 | Gray |  | 8
2013-03-12 00:00:00 | Blue |  | 1
2013-03-13 00:00:00 | [NAME] |  | 13
2013-03-14 00:00:00 | Green |  | 10
2013-03-15 00:00:00 | Yellow |  | 12
2013-03-18 00:00:00 | Red |  | 7
2013-03-20 00:00:00 | Violet |  | 11
2013-03-21 00:00:00 | Pink |  | 3
2013-03-22 00:00:00 | White |  | 9
2013-03-25 00:00:00 | Orange |  | 6
2013-03-26 00:00:00 | [NAME] |  | 16
2013-03-27 00:00:00 | Black |  | 2
2013-03-28 00:00:00
2013-03-29 00:00:00
2013-04-01 00:00:00
Spreadsheet: 839103d1691661125-check-data-valid-or-not-data-validation
Sheet: Sheet1

Model | Usage | Result |  |  |  |  |  |  | Model | Lower | Upper
A | 75000 | Can be considered |  |  |  |  |  |  | A | 15000 | 50000
B | 16500 | Can be considered |  |  |  |  |  |  | B | 15000 | 50000
C | 21500 | Can be considered |  |  |  |  |  |  | C | 20000 | 65000
D | 16500 | Can be considered |  |  |  |  |  |  | D | 15000 | 50000
E | 26500 | Can be considered |  |  |  |  |  |  | E | 25000 | 70000
F | 26500 | Can be considered |  |  |  |  |  |  | F | 25000 | 70000
G | 31500 | Can be considered |  |  |  |  |  |  | G | 30000 | 150000
H | 250000 | Can't be considered |  |  |  |  |  |  | H | 50000 | 200000
I | 23000 | Can't be considered |  |  |  |  |  |  | I | 50000 | 200000
J | 51500 |  |  |  |  |  |  |  | J | 50000 | 200000
K | 330000 | Can't be considered |  |  |  |  |  |  | K | 70000 | 225000
A | 13000
B | 13000
C | 18000
D | 13000
E | 23000
F | 23000
G | 28000
H | 48000
I | 48000
J | 48000
K | 68000
Spreadsheet: 598745d1542699671-devide-numbers-and-duplicate-one-spesific-cell-number-book3
Sheet: Sheet1

1.614 | 1.545 | 1.456 | 1.357 | 1.255 | 1.16 | 1.08 | 1.022 | 0.99 | 0.986 | 1.011 | 1.065 | 1.146 | 1.255 | 1.387 | 1.536 | 1.692 | 1.843 | 1.974 | 2.072 | 2.126 | 2.133 | 2.092 | 2.006 | 1.879 | 1.716 | 1.523 | 1.309 | 1.088 | 0.876 | 0.683 | 0.517 | 0.379 | 0.267 | 0.184 | 0.136 | 0.133 | 0.182 | 0.285 | 0.435 | 0.621 | 0.825 | 1.033 | 1.23 | 1.404 | 1.545 | 1.647 | 1.706 | 1.722
1.722 | 1.7 | 1.643 | 1.56 | 1.457 | 1.346 | 1.236 | 1.137 | 1.059 | 1.007 | 0.982 | 0.985 | 1.018 | 1.079 | 1.171 | 1.292 | 1.438 | 1.599 | 1.764 | 1.916 | 2.042 | 2.128 | 2.167 | 2.155 | 2.094 | 1.987 | 1.837 | 1.65 | 1.436 | 1.208 | 0.981 | 0.771 | 0.585 | 0.428 | 0.297 | 0.193 | 0.122 | 0.093 | 0.116 | 0.198 | 0.335 | 0.515 | 0.722 | 0.938 | 1.147 | 1.337 | 1.5 | 1.626 | 1.713
1.713 | 1.756 | 1.756 | 1.718 | 1.645 | 1.545 | 1.429 | 1.308 | 1.194 | 1.098 | 1.026 | 0.981 | 0.965 | 0.975 | 1.014 | 1.084 | 1.185 | 1.317 | 1.473 | 1.641 | 1.807 | 1.953 | 2.065 | 2.133 | 2.152 | 2.119 | 2.037 | 1.909 | 1.74 | 1.539 | 1.317 | 1.089 | 0.871 | 0.673 | 0.501 | 0.357 | 0.239 | 0.152 | 0.103 | 0.104 | 0.162 | 0.278 | 0.442 | 0.638 | 0.85 | 1.06 | 1.258 | 1.434 | 1.581
1.581 | 1.692 | 1.761 | 1.786 | 1.768 | 1.711 | 1.621 | 1.507 | 1.382 | 1.258 | 1.148 | 1.059 | 0.996 | 0.959 | 0.948 | 0.964 | 1.008 | 1.084 | 1.194 | 1.333 | 1.493 | 1.659 | 1.815 | 1.945 | 2.036 | 2.081 | 2.076 | 2.023 | 1.922 | 1.78 | 1.603 | 1.399 | 1.182 | 0.967 | 0.765 | 0.586 | 0.434 | 0.309 | 0.214 | 0.153 | 0.137 | 0.172 | 0.263 | 0.402 | 0.578 | 0.774 | 0.977 | 1.173 | 1.356
1.356 | 1.517 | 1.647 | 1.74 | 1.789 | 1.793 | 1.755 | 1.68 | 1.577 | 1.457 | 1.332 | 1.214 | 1.111 | 1.03 | 0.974 | 0.943 | 0.935 | 0.954 | 1.003 | 1.084 | 1.198 | 1.337 | 1.491 | 1.643 | 1.779 | 1.885 | 1.951 | 1.973 | 1.948 | 1.88 | 1.77 | 1.623 | 1.447 | 1.252 | 1.05 | 0.855 | 0.678 | 0.525 | 0.399 | 0.301 | 0.236 | 0.208 | 0.224 | 0.288 | 0.398 | 0.546 | 0.719 | 0.905 | 1.092
1.092 | 1.273 | 1.44 | 1.583 | 1.694 | 1.764 | 1.79 | 1.772 | 1.717 | 1.632 | 1.526 | 1.408 | 1.289 | 1.178 | 1.083 | 1.009 | 0.957 | 0.928 | 0.924 | 0.946 | 0.997 | 1.078 | 1.187 | 1.317 | 1.453 | 1.584 | 1.695 | 1.776 | 1.821 | 1.826 | 1.79 | 1.715 | 1.604 | 1.462 | 1.297 | 1.119 | 0.942 | 0.776 | 0.63 | 0.509 | 0.414 | 0.347 | 0.312 | 0.312 | 0.352 | 0.433 | 0.55 | 0.694 | 0.856
0.856 | 1.025 | 1.196 | 1.359 | 1.506 | 1.627 | 1.713 | 1.758 | 1.762 | 1.729 | 1.666 | 1.579 | 1.477 | 1.365 | 1.252 | 1.147 | 1.057 | 0.987 | 0.94 | 0.914 | 0.911 | 0.932 | 0.979 | 1.053 | 1.149 | 1.26 | 1.375 | 1.483 | 1.572 | 1.636 | 1.668 | 1.665 | 1.626 | 1.553 | 1.449 | 1.32 | 1.176 | 1.026 | 0.882 | 0.752 | 0.641 | 0.552 | 0.487 | 0.446 | 0.433 | 0.452 | 0.505 | 0.592 | 0.705
0.705 | 0.839 | 0.985 | 1.135 | 1.285 | 1.426 | 1.548 | 1.644 | 1.705 | 1.729 | 1.719 | 1.678 | 1.614 | 1.53 | 1.431 | 1.323 | 1.215 | 1.115 | 1.03 | 0.965 | 0.92 | 0.894 | 0.887 | 0.9 | 0.936 | 0.995 | 1.074 | 1.167 | 1.263 | 1.355 | 1.432 | 1.487 | 1.515 | 1.512 | 1.478 | 1.414 | 1.327 | 1.222 | 1.108 | 0.993 | 0.886 | 0.79 | 0.71 | 0.647 | 0.602 | 0.579 | 0.58 | 0.611 | 0.67
Spreadsheet: 797946d1664224031-sum-up-until-new-cell-with-data-appears-then-repeat-summation-test-file-hd
Sheet: Sheet1

Produce | Quantity | Total |  | Sum up the produce until a new produce name appears
Apple | 1
 | 2
 | 2
 | 4 |  |  | with apple appearing in cell A2 and banana appearing in cell A6, the formula would only add up from B1:B5
[NAME] | 3
 | 5
 | 7 |  |  | with banana appearing in cell A6 and corn appearing in cell A9, the formula would only add up from B6:B8
Corn | 5
 | 5
 | 5
Pear | 6
 | 8
 | 9
 | 9 |  |  | Note: Apple, [NAME], Corn, & Pear, along with the blanks in between, are already being referenced with a formula
Spreadsheet: 132070d1323463101-sumifs-including-both-columns-and-rows-sumifs-test
Sheet: Sheet1

Location | Brobekk |  |  |  |  |  |  |  |  |  | Location | Type | January | February
Month | January |  |  |  |  |  |  |  |  |  | Askim | Sales | 10 | 12
 |  |  |  |  |  |  |  |  |  |  | Brobekk | Sales | 22 | 25
 |  |  |  |  |  |  |  |  |  |  | Askim | Cost | 6 | 6
 |  |  |  |  |  |  |  |  |  |  | Brobekk | Cost | 15 | 18
Sales
Cost
Margin
Spreadsheet: 757427d1638261053-return-min-value-using-index-match-minrank
Sheet: Sheet1

ID | Min | Data | Rank
44525APH235 |  | 26.4
44525APH235 |  | 26.98
44525APH235 |  | 26.71
44525APH235 |  | 27.11
44525WOL205 |  | 26.56
44525WOL205 |  | 25.86
44525WOL205 |  | 26.73
44525WOL205 |  | 26.2
44525WOL205 |  | 26.63
44525WOL205 |  | 26.17
44524KEM545 |  | 27.41
44524KEM545 |  | 27.24
44524KEM545 |  | 26.84
44524KEM545 |  | 27.68
Spreadsheet: 105754d1303039472-count-cells-with-a-specific-year-excelexample
Sheet: Sheet1

 | MasterTabel
 | Date | Distance Kilometer |  |  | Year | Number
 | 1966-07-10 00:00:00 | 517 |  |  | 1966
 | 1966-07-10 00:00:00 | 1036 |  |  | 1973
 | 1966-07-10 00:00:00 | 1437 |  |  | 1975
 | 1966-07-11 00:00:00 | 6497
 | 1973-01-01 00:00:00 | 862
 | 1973-01-02 00:00:00 | 5645
 | 1973-01-03 00:00:00 | 1437 |  |  |  |  | Here I want to add sum of kilometer for each year
 | 1973-01-04 00:00:00 | 1036
 | 1973-01-05 00:00:00 | 517
 | 1975-05-05 00:00:00 | 517
 | 1975-05-06 00:00:00 | 239
 | 1975-05-07 00:00:00 | 289
 | 1975-05-08 00:00:00 | 289
Spreadsheet: c0b2854f-f172-4f5b-877b-4a2c55932e19
Sheet: Sheet1

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF JULY 21, 2014 THROUGH JULY 25, 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, July 21, 2014
10:00:00 | CA#7597-CB | Chancellor [NAME] | Settlement Hearing | City of [NAME], et [NAME]. | [NAME]
02:00:00 | CA#8491-VCP | Vice Chancellor Parsons | Settlement Hearing | In re [NAME] | [NAME]
Tuesday, July 22, 2014
09:30:00 | CA#9574-VCL | Vice Chancellor [NAME] | Hearing | Freestone | [NAME]
09:30:00 | CA#9309-ML | Master [NAME] | Default Hearing | [NAME] v. Sinohub Inc. | [NAME]
10:00:00 | CA#9707-CB | Chancellor [NAME] | Oral Argument | Comerica Bank v. Global Payments Direct, Inc., et [NAME]. | [NAME]
10:00:00 | CA#3387-MA | Master [NAME] | RTSC Hearing | Bank One v. Lind | [NAME]
10:00:00 | CA#4889-VCG | Vice Chancellor Glasscock | Oral Argument | [NAME] Nonnie Cross | Georgetown
02:00:00 | CA#7764-VCL | Vice Chancellor [NAME] | Oral Argument | Louisiana Mun. Police Emp. [NAME]. vs Melvyn E Bergstein et al. | [NAME]
02:00:00 | CA#8528-VCN | Vice Chancellor [NAME] | Oral Argument | Ridgewood Manor II, Inc. v. DE. Manufactured Home Relocation Auth. | Dover
Wednesday, July 23, 2014
10:00:00 | CA#9609-CB | Chancellor [NAME] | Hearing | In re Allergan, Inc. [NAME] | [NAME]
10:00:00 | CA#9459-VCL | Vice Chancellor [NAME] | Oral Argument | Gidumal v. Signature Group Holdings, Inc. | [NAME]
10:00:00 | CA#9390 & 9562-ML | Master [NAME] | Hearing | IMO [NAME]. | [NAME]
01:00:00 | CA#8064-VCG | Vice Chancellor Glasscock | Oral Argument | Kops v. The Bank of New York Mellon Corp. | Georgetown
02:00:00 | CA#8447-VCL | Vice Chancellor [NAME] | Scheduling Hearing | OTK Associates, LLC, et [NAME] [NAME], et [NAME]. | [NAME]
Thursday, July 24, 2014
09:30:00 |  | Vice Chancellor Parsons | NCC Petitions |  | [NAME]
10:00:00 | CA#6546-VCL | Vice Chancellor [NAME] | Oral Argument | Lake Treasure Holdings, Ltd vs Foundry Hill GP LLC | [NAME]
10:00:00 | CA#9106-MA | Master [NAME] | Default Hearing | Cenlar FSB v. [NAME] | Dover
02:00:00 | CA#9306-VCP | Vice Chancellor Parsons | Oral Argument | Ins. Comm. v. Wilm. Trust | [NAME]
02:00:00 | CA#7393-VCN | Vice Chancellor [NAME] | Oral Argument | In re Zhongpin Inc. | Dover
Friday, July 25, 2014
09:30:00 |  | Master [NAME] | SC Petitions |  | Georgetown
Spreadsheet: errol_mclaughlin_jr__10148__Bkrqs688
Sheet: Sheet1

From: | Risk Analysis and Reporting
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  |  | Risk Management
Subject: | New Book Request (to set up book in RisktRAC)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason for Book | Administrator* | MTM | Prud | Realized
 | Star | Star VPP LP Affiliate Book | x |  |  | ZF | DESK | x | x | x | x |  | NatGas - MMBtu | no trader - affiliate book | MTM | New VPP deal w/ affiliate | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List: | emclaug
 |  | kloibl
 |  | bbajwa, [NAME]
 | BOOK WILL NOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | For questions, call:
 | [NAME] (x57197)
 | [NAME] (x31462)
 | [NAME] ([NAME])
 | [NAME] (x33102)
Spreadsheet: 139094d1328070258-pie-chart-with-summation-of-data-pie-chart
Sheet: Sheet1

amount | State |  | Add data in column A, B and right click  - Refresh below pivot
100 | AZ
200 | CA |  | Row Labels | Sum of amount
300 | AZ |  | AZ | 1000
400 | TN |  | CA | 300
600 | AZ |  | TN | 400
100 | CA |  | Grand Total | 1700
Spreadsheet: 2b9dacc0-abed-49ea-bf04-71981016a1f7
Sheet: Sheet1

ESTONIA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Year | L/person per day | Average price for 1 m3 of water and sewerage
 | 2000 | 99.20121561574518 | 0.9893523193537255
 | 2001 | 93.47594022774477 | 1.101836820778955
 | 2002 | 89.78728412892214 | 1.262255058606982
 | 2003 | 86.85388595347337 | 1.262255058606982
 | 2004 | 83.67859491673302 | 1.343422852249051
 | 2005 | 107.8779873000324 | 1.408612733756855
 | 2006 | 86.28627824661986 | 1.515345186813749
 | 2007 | 91.83324737675163 | 1.594595630999706
 | 2008 | 98.06590177749106 | 1.622077639870643
 | 2009 | 82.87234426154089 | 1.7
 | 2010 | 81.69111804926087 | 2.024721025654136
 |  |  |  | couldn't work out how to get the x-axis showing the years correctly???
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: West Power

West Power
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Power |  | West
Wehn |  | Power |  | West |  | 16000000
[NAME] |  | Power |  | West
[NAME] | * | Power |  | West
Thome | * | Power |  | West |  | 10000000
Krebs |  | Power |  | West |  | 9742219
[NAME] |  | Power |  | West
Choi |  | Power |  | West |  | 8663463
Rosman |  | Power |  | West |  | 7094465
Calger |  | Power |  | West
Wolfe |  | Power |  | West |  | 5430414
Etringer |  | Power |  | West |  | 4000000
McDonald |  | Power |  | West
Page |  | Power |  | West |  | 4000000
Slaughter | * | Power |  | West |  | 4000000
Rawson |  | Power |  | West |  | 3565507
Malowney |  | Power |  | West |  | 2105422
Buerkle | * | Power |  | West |  | 2000000
[NAME] |  | Power |  | West |  | 1914254
Scholtes |  | Power |  | West |  | 1681166
Dyer |  | Power |  | West
Cocke |  | Power |  | West |  | 750594
Ward |  | Power |  | West |  | 1757
Total
*includes $5M to be recognized 3Q for Fountain Valley (PSCO)
Spreadsheet: 267461d1380084010-if-formula-with-multiple-values-example-customer-segmentation
Sheet: Sheet1

Customer ID | Customer Name | PPV | LINEAR PACK | TVOD | Freeloader | Packer | Demander | Spectator | [NAME] | Packer Plus | Utopia
104201 | [NAME] | 0 | 3 | 0
105501 | [NAME] | 0 | 2 | 1
111701 | Wayne | 0 | 4 | 6
120901 | nathan | 0 | 2 | 0
122401 | [NAME] | 0 | 2 | 0
Spreadsheet: 793637d1661598287-pull-turn-static-values-into-a-dynamic-array-without-using-offset-excel-problem-1-2-
Sheet: Sheet1

 | [NAME] | 5
 | [NAME] | 15
Method 1
 |  | INPUT ROW |  |  | 4 |  | 7 |  |  | 10 |  |  | 15
 |  |  |  |  | 4 | 0 | 7 | 0 | 0 | 10 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 0
Spreadsheet: stacey_white__39179__E&Y Info Request - Form A
Sheet: Request List

Item # | Description | Date Requested | Enron Contact | Date Received
1 | Daily Position Report by Counterparty/by Product as of November 30, 2001 | 2002-01-10 00:00:00 | [NAME]
2 | Daily Position Reports of Selected Post Petition Dates (12/31/01 requested) | 2002-01-10 00:00:00 | [NAME]
4 | Position Reports by Product/By Tenor (maturity buckets) | 2002-01-10 00:00:00 | [NAME]
5 | Position Reports by Commodity | 2002-01-10 00:00:00 | [NAME]
6 | Representation of Setoff/Netting Issues for Each Counterparty | 2002-01-10 00:00:00 | [NAME]
7 | Inventory Values By Product/By Entity/By Location | 2002-01-10 00:00:00 | [NAME]
8 | Product Programs for Each Desk and Sample Contracts | 2002-01-10 00:00:00 | [NAME]
9 | Supporting Documentation to Review Methodology and Approaches for Valuation Models | 2002-01-10 00:00:00 | [NAME]
 | Detailed Description of  Methodology to Construct Valuation Curves by Commodity and Copy of Policy & Procedures Documentation, if [NAME] | 2002-01-10 00:00:00 | [NAME]
11 | Where Appropriate, Market Data/Third Party Broker Quotes Supporting Curves when Reviewing Transactions | 2002-01-10 00:00:00 | [NAME]
12 | Listing of Counterparties that have entered into Global Master Netting Agreements with Enron, including effective and signing dates, as well as copies of the Agreements | 2002-01-10 00:00:00 | [NAME]
13 | Listing of All Outstanding Trading Related Intercompany Transactions (Debtor and Non-Debtor Entities) | 2002-01-10 00:00:00 | [NAME]
14 | Corporate Organizational Charts and Reporting Lines Pre and Post Petition | 2002-01-10 00:00:00 | [NAME]
Spreadsheet: louise_kitchen__23038__E-Next equipment balances 11-05-01
Sheet: E-Next Summary

Equipment in E-Next Generation LLC
 | $ in 000
 | NOTE: assume all equipment stays in E-Next through the end of the facility (March 2004)
 | PROJECT NAME | EQUIPMENT | PAYMENTS TO DATE | REMAINING PAYMENTS | REMAINING PAYMENTS
 |  |  |  | (if approved for acquisition by DASH) | (if choose to cancel by 12-15-01)
 | Ft. Pierce | 1 HRSG | 506 | 12338.956 | 0
 | Columbia/Longview | 1 7FA turbine | 13328
 |  | 1 Steam turbine | 909.16
 |  | 1 HRSG | 1480
 |  | Cascade Transportation Agreement | 0 | 950 | 950
 |  | 1 Generator Step-up Transformer | 0 | 1499 | 0
 | Interest and Financing Fees |  |  |  | 13769.39187370952
 | Total
Capital Expenditures for Other Projects
 | $ in 000
 | PROJECT NAME | EQUIPMENT | PAYMENTS TO DATE | REMAINING PAYMENTS | REMAINING PAYMENTS
 |  |  |  | (if approved by DASH) | (if choose to cancel)
 | Vessel ERCs |  | 0 | 6000 | 0
Spreadsheet: 149314d1333835367-count-the-number-of-projects-completed-within-a-1-week-period-sample-13-
Sheet: Sheet1

 | A |  |  |  | B |  | C
Project Log |  |  |  | Weekly Cumulative Projects Completed
Project | Baseline | Completion |  | Week Start Date | Week End Date | #[NAME] | [NAME]
1 | 2012-03-20 00:00:00 | 2012-04-10 00:00:00 |  | 2012-04-02 00:00:00 | 2012-04-06 00:00:00
2 | 2012-03-20 00:00:00 | 2012-04-03 00:00:00 |  | 2012-04-09 00:00:00 | 2012-04-13 00:00:00
3 | 2012-04-02 00:00:00 | 2012-04-11 00:00:00 |  | 2012-04-16 00:00:00 | 2012-04-20 00:00:00
4 | 2012-04-06 00:00:00 | 2012-04-24 00:00:00 |  | 2012-04-23 00:00:00 | 2012-04-27 00:00:00
5 | 2012-04-18 00:00:00 | 2012-04-26 00:00:00 |  | 2012-04-30 00:00:00 | 2012-05-04 00:00:00
6 | 2012-05-14 00:00:00 | 2012-05-18 00:00:00 |  | 2012-05-07 00:00:00 | 2012-05-11 00:00:00
7 | 2012-05-29 00:00:00 | 2012-06-07 00:00:00 |  | 2012-05-14 00:00:00 | 2012-05-18 00:00:00
8 | 2012-05-08 00:00:00 | 2012-05-15 00:00:00 |  | 2012-05-21 00:00:00 | 2012-05-25 00:00:00
9 | 2012-05-11 00:00:00 | 2012-05-11 00:00:00 |  | 2012-05-28 00:00:00 | 2012-06-01 00:00:00
10 | 2012-06-06 00:00:00 | 2012-06-08 00:00:00 |  | 2012-06-04 00:00:00 | 2012-06-08 00:00:00
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: md

Manktelow. Trevor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 59964d1260476346-double-lookup-to-fill-an-array-example_array
Sheet: Sheet1 (2)

Line | Country |  |  |  | Imports (USA) | Argentina | 100 |  |  | <-- | DATA
1 | Chile | 1 |  |  |  | Bolivia | 200
3 | Paraguay | 1 |  |  |  | Chile | 300
5 | Colombia | 1 |  |  |  | Ecuador | 150
7 | [NAME] | 1 |  |  |  | Colombia | 200
 |  |  |  |  |  | Uruguay | 125
 |  |  |  |  |  | [NAME] | 340
 |  |  |  |  |  | Peru | 100
Tryout...
Line | Argentina | Bolivia | Chile | Ecuador | Colombia | Paraguay | Brazil | Peru |  | <-- | OUTPUT
1 | #N/A | #N/A | Chile | 1
2 | #N/A |  | #N/A | 3
3 | #N/A |  | #N/A | 0
4 | #N/A |  | #N/A | 0
5 | #N/A |  | #N/A | #N/A
6 | #N/A |  | #N/A | #N/A
7 | #N/A |  | #N/A | #N/A
8 | #N/A |  | #N/A | #N/A
Expected result:
Line | Argentina | Bolivia | Chile | Ecuador | Colombia | Paraguay | Brazil | Peru |  | <-- | The real array is much bigger, so the formula is very important.
1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0