tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 130710d1322531543-numbering-problem-numbering-problem
Sheet: Sheet1

1 | 1 | 2 | 3 |  | 2 | 3 | 4 |  | 3 | 4 | 5 |  | 4 | 5 | 6 |  | 5 | 6 | 7 |  | 6 | 7 | 8 |  | 7 | 8 | 9
2 | 1 | 2 | 4 |  | 2 | 3 | 5 |  | 3 | 4 | 6 |  | 4 | 5 | 7 |  | 5 | 6 | 8 |  | 6 | 7 | 9
3 | 1 | 2 | 5 |  | 2 | 3 | 6 |  | 3 | 4 | 7 |  | 4 | 5 | 8 |  | 5 | 6 | 9 |  | 6 | 8 | 9
4 | 1 | 2 | 6 |  | 2 | 3 | 7 |  | 3 | 4 | 8 |  | 4 | 5 | 9 |  | 5 | 7 | 8
5 | 1 | 2 | 7 |  | 2 | 3 | 8 |  | 3 | 4 | 9 |  | 4 | 6 | 7 |  | 5 | 7 | 9
6 | 1 | 2 | 8 |  | 2 | 3 | 9 |  | 3 | 5 | 6 |  | 4 | 6 | 8 |  | 5 | 8 | 9
7 | 1 | 2 | 9 |  | 2 | 4 | 5 |  | 3 | 5 | 7 |  | 4 | 6 | 9
8 | 1 | 3 | 4 |  | 2 | 4 | 6 |  | 3 | 5 | 8 |  | 4 | 7 | 8
9 | 1 | 3 | 5 |  | 2 | 4 | 7 |  | 3 | 5 | 9 |  | 4 | 7 | 9
10 | 1 | 3 | 6 |  | 2 | 4 | 8 |  | 3 | 6 | 7 |  | 4 | 8 | 9
11 | 1 | 3 | 7 |  | 2 | 4 | 9 |  | 3 | 6 | 8
12 | 1 | 3 | 8 |  | 2 | 5 | 6 |  | 3 | 6 | 9
13 | 1 | 3 | 9 |  | 2 | 5 | 7 |  | 3 | 7 | 8
14 | 1 | 4 | 5 |  | 2 | 5 | 8 |  | 3 | 7 | 9
15 | 1 | 4 | 6 |  | 2 | 5 | 9 |  | 3 | 8 | 9
16 | 1 | 4 | 7 |  | 2 | 6 | 7
17 | 1 | 4 | 8 |  | 2 | 6 | 8
18 | 1 | 4 | 9 |  | 2 | 6 | 9
19 | 1 | 5 | 6 |  | 2 | 7 | 8
20 | 1 | 5 | 7 |  | 2 | 7 | 9
21 | 1 | 5 | 8 |  | 2 | 8 | 9
22 | 1 | 5 | 9
23 | 1 | 6 | 7
24 | 1 | 6 | 8
25 | 1 | 6 | 9
26 | 1 | 7 | 8
27 | 1 | 7 | 9
28 | 1 | 8 | 9
 | 1 | 2 | 3
 |  |  |  | 4 | 5 | 6
 |  |  |  | 7 | 8 | 9
 |  |  |  | 4 | 5 | 7
 |  |  |  | 6 | 8 | 9
 |  |  |  | 4 | 5 | 8
 |  |  |  | 6 | 7 | 9
 |  |  |  | 4 | 5 | 9
 |  |  |  | 6 | 7 | 8
 |  |  |  | 4 | 6 | 7
 |  |  |  | 5 | 8 | 9
 |  |  |  | 4 | 6 | 8
 |  |  |  | 5 | 7 | 9
 |  |  |  | 4 | 6 | 9
 |  |  |  | 5 | 7 | 8
 |  |  |  | 4 | 7 | 8
 |  |  |  | 5 | 6 | 9
 |  |  |  | 4 | 7 | 9
 |  |  |  | 5 | 6 | 8
 |  |  |  | 4 | 8 | 9
 |  |  |  | 5 | 6 | 7
Spreadsheet: tracy_geaccone__40425__enron corp infomation request - Nov 2001
Sheet: EGS Burn

 |  |  |  | YTD |  | Forecast Cash Expenditures ($Millions)
 |  | Headcount Actual (9/30) |  | Cash Expenditures | ** | October |  | November |  | December |  | January |  | February |  | March | April | May | June | July | August | Sept | October | Nov | Dec |  | Comments
ETS
EGAS |  | 138 | *
PGE
EOTT
EREC
Azurix/Wessex
EEOS
Other
Analysts/Associates
Total
Depreciation & Amortization |  |  |  |  |  | 1.4 |  | 1.4 |  | 1.4 |  | 1.4 |  | 1.4 |  | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4
Taxes Other Than Income |  |  |  |  |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 |  | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3 | 0.3
Total Expenses net of Capitalized Expense
Plus:  Capital Expenditures |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other Cash Payments |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Less: DD&A
 |  |  |  |  |  | 0
Total Cash Burn Rate
* Exclude Europe Employees
** [NAME] and regional office expense.  Include DPC shared cossts.  Exclude OPIC insurance, Corp charges allocations, and consolidated operating projects.
Spreadsheet: 734723d1622433083-format-dates-if-they-are-not-in-a-given-quarter-book1
Sheet: Expenditure P90_P50 rev Jul 19

 |  |  |  |  |  |  |  |  |  |  | - |  |  | -
 |  |  |  |  |  | Manually input first month; months must correspond to table below - e.g. Dec/Mar/Jun/Sep for quarterly
 | Expenditure Profile Base Amount: |  |  |  |  | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 2021-10-01 00:00:00 | 2022-01-01 00:00:00 | 2022-04-01 00:00:00 | 2022-07-01 00:00:00 | 2022-10-01 00:00:00 | 2023-01-01 00:00:00 | 2023-04-01 00:00:00 | 2023-07-01 00:00:00 | 2023-10-01 00:00:00 | 2024-01-01 00:00:00 | 2024-04-01 00:00:00 | 2024-07-01 00:00:00 | 2024-10-01 00:00:00 | 2025-01-01 00:00:00 | 2025-04-01 00:00:00 | 2025-07-01 00:00:00 | 2025-10-01 00:00:00 | 2026-01-01 00:00:00 | 2026-04-01 00:00:00 | 2026-07-01 00:00:00 | 2026-10-01 00:00:00 | 2027-01-01 00:00:00 | 2027-04-01 00:00:00 | 2027-07-01 00:00:00 | 2027-10-01 00:00:00 | 2028-01-01 00:00:00 | 2028-04-01 00:00:00 | 2028-07-01 00:00:00
 |  |  |  |  | Current Expenditure | period 0* | period 1* | period 2 | period 3 | period 4 | period 5 | period 6 | period 7 | period 8 | period 9 | period 10 | period 11 | period 12 | period 13 | period 14 | period 15 | period 16 | period 17 | period 18 | period 19 | period 20 | period 21 | period 22 | period 23 | period 24 | period 25 | period 26 | period 25 | period 26 | period 27 | Total
 | Item |  | Start Date | Complete Date | 0 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 | Initiation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | True
 | Strategic Assessment |  | 2020-01-01 00:00:00 | 2021-03-01 00:00:00 | 2475000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2475000 | False
 | Concept |  | 2020-10-01 00:00:00 | 2022-06-01 00:00:00 | 1780446 | 2967410 | 2967410 | 1780446 | 1780446 | 593482 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11869640 | False
 | Delivery Readiness
 | Property Acquisitions |  | 2021-07-01 00:00:00 | 2023-01-01 00:00:00 |  |  |  |  | 7385949.75 | 3692974.875 | 2707555.9 | 738594.9749999996 | 123412 | 123412 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14771899.5 | False
 |  |  |  |  | Hi,
 |  |  |  |  | I am looking for some formulas to check if the expenditure values (Col G to AJ) are on the given period as defined by the start date and the complete date (Col D & E). So, if Jun-22 (Row 10) is the complete date, last value should be on the Jul-22 quarter. But last value is on Apr-22 quarter. So, i want to use conditional formatting to highlight it in red. Similarly, for item on Row 14 last expense entry should be on the Jan-23 quarter and as it doesn't meet the criteria, should be highlighted red.
Spreadsheet: 819203d1677286681-get-the-last-18-numbers-and-highlight-or-list-down-the-difference-last-18-numbers
Sheet: Sheet1

No.
4
9
21
20
22
27
14
27
8
23
0
5
3
1
18
9
33
10 |  | Below are the last 18 numbers not in ascending order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Below are the last 18 numbers in ascending order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | difference in the last 2 rows
28 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
17 |  | 17 | 28 | 10 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 27 | 14 | 22 | 20 | 21 | 4 |  | 0 | 1 | 3 | 4 | 5 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
3 |  | 17 | 28 | 10 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 27 | 14 | 22 | 20 | 21 | 4 |  | 0 | 1 | 3 | 4 | 5 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
6 |  | 6 | 17 | 28 | 10 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 27 | 14 | 22 | 20 | 21 |  | 0 | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
22 |  | 22 | 6 | 17 | 28 | 10 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 14 | 27 | 20 | 21 |  | 0 | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
10 |  | 10 | 22 | 6 | 17 | 28 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 14 | 27 | 20 | 21 |  | 0 | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
21 |  | 21 | 10 | 22 | 6 | 17 | 28 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 14 | 27 | 20 |  | 0 | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
13 |  | 13 | 21 | 10 | 22 | 6 | 17 | 28 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 14 | 27 |  | 0 | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 13 | 14 | 17 | 18 | 21 | 22 | 23 | 27 | 28 | 33 |  | 20 | 13
11 |  | 11 | 13 | 21 | 10 | 22 | 6 | 17 | 28 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 14 |  | 0 | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 11 | 13 | 14 | 17 | 18 | 21 | 22 | 23 | 28 | 33 |  | 27 | 11
16 |  | 16 | 11 | 13 | 21 | 10 | 22 | 6 | 17 | 28 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 |  | 0 | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 11 | 13 | 16 | 17 | 18 | 21 | 22 | 23 | 28 | 33 |  | 14 | 16
Spreadsheet: 04cf6079-2572-440f-8027-56a1ae1977db
Sheet: T36

الجدول 36: [NAME] السنوي للسكان، 2000-2010
Table 36: Annual population growth rate, 2000-2010
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | البلد
Bahrain | … | … | … | … | … | … | … | … | 6.18 | 6.79 | 4.25 | -2.73 | البحرين
Egypt | … | … | … | … | … | … | … | 2.02 | … | … | … |  | مصر
Iraq | … | … | … | … | … | … | … | 2.9 | 2.9 | 2.9 | ... |  | العراق
Jordan | 2.5 | 2.5 | 2.4 | 2.6 | 2.3 | 2.3 | 2.3 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 | الأردن
Kuwait | 3.46 | 3.47 | 3.47 | 3.48 | 3.48 | 3.51 | 3.64 | 3.49 | 3.47 | 3.43 | 3.42 |  | الكويت
Lebanon | … | … | … | … | … | … | … | … | … | … | … |  | لبنان
Oman | ... | 3.182959251325144 | 2.423833196041315 | 7.8 | 3.193802158649859 | 3.860818289302429 | 2.719387509033069 | 6.458401078437376 | 4.51718772268552 | 10.6886380407808 | ... |  | عمان
Palestine* | ... | ... | ... | ... | ... | ... | ... | 2.86 | 2.87 | 2.88 | 2.9 | … | فلسطين*
Qatar | ... | ... | ... | 0.06 | 0.12 | 0.14 | 0.15 | 0.17 | 0.19 | 0.13 | 0.046 | 0 | قطر
Saudi Arabia | ... | ... | ... | ... | 2.38 | 2.36 | 2.32 | 2.28 | 2.23 | 2.18 | 2.13 | 2.08 | المملكة العربية السعودية
Sudan** | … | … | … | … | … | … | … | … | 2.827 | … | … |  | السودان**
Syrian Arab Republic | 2.5 | 2.5 | 2.4 | 2.4 | 2.1 | 1.9 | 2.4 | 2.4 | 2.4 | 2.4 | … |  | سوريا
United Arab Emirates | … | … | … | … | … | … | … | … | 2.23 | 2.18 | … | … | الإمارات العربية المتحدة
Yemen | … | … | … | … | 3 | … | … | … | … | … |  |  | اليمن
* for nationals only |  |  |  |  |  |  |  |  |  |  |  |  | * للمواطنين فقط
** 1993-2008 |  |  |  |  |  |  |  |  |  |  |  |  | ** 2008-1993
Spreadsheet: 547117d1510343392-formatting-issues-v-look-up-error
Sheet: Working

Supplier | FOB | SKU # | Old PTR | New PTR | New Military | New Wholesaler
New Belgium [NAME] Imperial IPA 2/12 LNNR | 23.79 | 6430 | 30.55 | 35.65 | 35.01 | 24.62
NEW BELG ABBEY ALE 4/6 NR | 26.42 | 7903 |  | 39.96 | 39.32 | 27.25
New Belgium Trippel 4/6 LNNR | 26.42 | 6013 | 31.96 | 39.96 | 39.32 | 27.25
New Belgium [NAME] Imperial IPA 4/6 NR | 26.42 | 8320 | 31.96 | 39.96 | 39.32 | 27.25
New Belgium Trippel 1/6 BBL *** | 63.5 | 6501 | 73 | 99 | 98 | 65.02
NEW BELG VOODOO RANGER IMPERIAL 1/6 BBL | 63.5 | 8321 |  | 99 | 98 | 65.02
New Belgium Le Terrior 12/22 ounce NR | 94 | 6106 | 125.91 | 136 | 135.41 | 94.74
New Belgium La Folie 1/6 BBL *** | 110.76 | 8499 | 120 | 179 | 178 | 112.28
New Belgium Le Terrior 1/6 BBL *** | 110.76 | 6123 | 120 | 179 | 178 | 112.28
New Belgium [NAME] Ale 1/6 BBL*** | 110.76 | 6451 | 120 | 179 | 178 | 112.28
New Belgium Transatlantique Kriek 1/6 BBL*** | 110.76 | 6448 | 150 | 179 | 178 | 112.28
New Belgium Felix 1/6 BBL *** | 136.48 | 6502 | 150 | 229 | 228 | 138
New Belgium [NAME]*** | 136.48 | 6449 | 150 | 229 | 228 | 138
New Belgium Clutch Ale 12/22 ounce NR | 94 | 6505 | 135 | 136 | 135.41 | 94.74
New Belgium [NAME] oz NR | 94 | 7099 | 135 | 136 | 135.41 | 94.74
New Belgium La Folie 12/22 ounce NR | 94 | 8505 | 135 | 136 | 135.41 | 94.74
New Belgium [NAME] Ale 12/22 ounce | 94 | 6452 | 135 | 136 | 135.41 | 94.74
New Belgium Transatlantique Kriek 12/22 ounce NR | 94 | 8335 | 135 | 136 | 135.41 | 94.74
New Belgium [NAME] | 111 | 7098 | 170 | 179 | 178 | 112.52
Spreadsheet: 143732d1330540431-need-help-making-a-formula-to-keep-track-of-current-week-example-worksheet
Sheet: Sheet1

Packing Supplies |  | Week Of:
Envelopes | Cost | Lead Time |  |  | Week 1 | Week 2 | Week 3 | Week 4
24 x 24 | $82.58/cs |  | GOOD | 125/cs | 100 | 100
14.5" x 19" Gray Fastpak | $61.25/cs |  | ORDER | 250/cs | 51
14.5 x 19 Lip & Tape | 0.21 |  | ORDER |  | 49
14.5 x 19 Poly Mailer | 0.28 |  | ORDER | 250/cs | 23
20 x 6.25 x 3 | 0.81 |  | ORDER |  | 38
14.5 x 19 (ID) + 2" Flap | 0.23 |  | GOOD | 250/cs | 150
10 x 13 Fastpak Mailers | 0.2065 |  | GOOD | 500/cs | 250
10 x 13 (ID) + 2" Flap | 0.26 |  | GOOD | 500/cs | 150
Spreadsheet: kate_symes__18386__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]
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 | 2000-12-19 00:00:00 |  | 471.25 | 7824 | 408.97 | 312 | 547.65 | 3749 | 506.72 | 1005
 | 2000-12-18 00:00:00 |  | 372.89 | 7600 | 321.88 | 1600 | 378.62 | 360 | 328.33 | 150
 | 2000-12-17 00:00:00 |  |  |  |  |  | 368.41 | 1404 | 355.96 | 663 |  | 321.88 | 4800
 | 2000-12-16 00:00:00 |  | 317.57 | 11504 | 272.19 | 1112 | 374.92 | 642 | 339.88 | 168
 | 2000-12-15 00:00:00 |  | 317.59 | 11424 | 272.19 | 1112 | 364.78 | 598 | 477.91 | 763
 | 2000-12-14 00:00:00 |  | 459.34 | 7024 | 342.87 | 1712 | 380.91 | 1574 | 283 | 1890
 | 2000-12-13 00:00:00 |  | 700.87 | 7824 | 485.4 | 1712 | 391.35 | 1561 | 349.97 | 318
 | 2000-12-12 00:00:00 |  | 956.16 | 9024 | 636.87 | 2712 | 526.56 | 322 | 355.87 | 412
 | 2000-12-11 00:00:00 |  | 3322.42 | 5744 | 2166.67 | 600 | 1285.47 | 695 | 451.85 | 621
 | 2000-12-10 00:00:00 |  |  |  |  |  | 595.02 | 1607 | 516.15 | 975 |  | 2125 | 2400
 | 2000-12-09 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 423.26 | 1913 | 496.71 | 380
 | 2000-12-08 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 604.06 | 1877 | 475.29 | 433
 | 2000-12-07 00:00:00 |  | 628.75 | 8000 | 490 | 1000 | 664.04 | 2134 | 377.22 | 552
 | 2000-12-06 00:00:00 |  | 360.3 | 13200 | 283.68 | 3800 | 417.71 | 480 | 254.49 | 195
 | 2000-12-05 00:00:00 |  | 278.15 | 16000 | 234.69 | 3200 | 305.36 | 1340 | 275 | 1155
 | 2000-12-04 00:00:00 |  | 276.46 | 14800 | 247.86 | 4200 | 261.33 | 1471 | 225.6 | 1552
 | 2000-12-03 00:00:00 |  | 268.33 | 1200 | 231.67 | 600 | 222.94 | 425 | 200 | 70 |  | 249.41 | 10200
 | 2000-12-02 00:00:00 |  | 264.7 | 26400 | 217.08 | 2400 | 223.95 | 2144 | 203.49 | 506
 | 2000-12-01 00:00:00 |  | 264.7 | 26400 | 217.08 | 2400 | 235.86 | 1637 | 204.07 | 800
 | 2000-11-30 00:00:00 |  | 254.19 | 17760 | 205.14 | 2800 | 244.29 | 175 | 204.3 | 465
 | 2000-11-29 00:00:00 |  | 251.79 | 21056 | 202.81 | 3200 | 244.89 | 1103 | 191.93 | 1385
 | 2000-11-28 00:00:00 |  | 252.35 | 10256 | 206.11 | 1800 | 215.95 | 1135 | 187.84 | 670
 | 2000-11-27 00:00:00 |  | 235.87 | 16160 | 212.32 | 3080 | 195.74 | 370 | 163.55 | 1325
 | 2000-11-26 00:00:00 |  | 230 | 400 | 210 | 0 | 200.64 | 1079 | 180.57 | 795 |  | 212.93 | 8400
 | 2000-11-25 00:00:00 |  | 207.54 | 16400 | 188.08 | 2400 | 202.61 | 1152 | 170.89 | 875
 | 2000-11-24 00:00:00 |  | 207.54 | 16400 | 188.08 | 2400 | 191.81 | 802 | 145.28 | 853
 | 2000-11-23 00:00:00 |  | 212.5 | 0 | 180 | 0 | 208.12 | 1305 | 217.64 | 635 |  | 185.86 | 8400
 | 2000-11-22 00:00:00 |  | 246.28 | 13760 | 206.3 | 2000 | 256.8 | 1685 | 214.31 | 180
 |  |  |  |  |  | ..
Spreadsheet: andy_zipper__535__11_28_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL F2 | 19 | 195 | 205 | 61.5 | 64.7 | 0.75 | 2001-11-28 10:10:00
 | CL G2 | 19.5 | 325 | 340 | 57.4 | 60.1 | 0.72 | 2001-11-28 10:10:00
 | CL H2 | 19.5 | 390 | 405 | 54.8 | 56.9 | 0.68 | 2001-11-28 10:10:00
 | CL J2 | 19.5 | 435 | 450 | 52.4 | 54.2 | 0.65 | 2001-11-28 10:10:00
 | CL K2 | 20 | 470 | 490 | 48.5 | 50.5 | 0.62 | 2001-11-28 10:10:00
 | CL M2 | 20 | 495 | 515 | 46.6 | 48.5 | 0.6 | 2001-11-28 10:10:00
 | CL N2 | 20 | 510 | 530 | 44.3 | 46 | 0.57 | 2001-11-28 10:10:00
 | CL Q2 | 20 | 520 | 540 | 42.3 | 43.9 | 0.54 | 2001-11-28 10:10:00
 | CL U2 | 20 | 525 | 545 | 40.3 | 41.9 | 0.52 | 2001-11-28 10:10:00
 | [NAME] | 20 | 530 | 555 | 38.6 | 40.4 | 0.5 | 2001-11-28 10:10:00
 | CL X2 | 20 | 530 | 555 | 36.9 | 38.6 | 0.47 | 2001-11-28 10:10:00
 | [NAME] | 20.5 | 535 | 555 | 34.9 | 36.2 | 0.46 | 2001-11-28 10:10:00
 | CL M3 | 20.5 | 545 | 570 | 29.7 | 31 | 0.39 | 2001-11-28 10:10:00
 | CL Z3 | 20.5 | 535 | 570 | 25.8 | 27.5 | 0.34 | 2001-11-28 10:10:00
 | CL M4 | 20.5 | 520 | 585 | 23 | 25.9 | 0.32 | 2001-11-28 10:10:00
Spreadsheet: 231104d1366949113-designing-a-questionaire-macro-that-works
Sheet: List

 | Part # |  | ARM (mm) | Travel (mm) | Travel 2 (mm)
1 | 123456 |  | 100 | 50 | 45
2 | 654321 |  | 200 | 40 | 35
3 | 123654 |  | 300 | 30 | 25
4 | 456321 |  | 400 | 20 | 15
Spreadsheet: 167945d1342164922-i-want-to-send-data-in-multiple-workbook-bank-ledger
Sheet: Bank Ledger

 |  |  |  |  |  | Bank
 |  |  |  |  |  | Account Statement (A-A/C)
 |  |  |  |  |  |  |  |  |  | A/C Ref.
DATE | P# | L# | A/C | Head of A/C | Description | Cheq#/ATM | Bank/Slip# | Book # | [NAME]# | Page# | Ledger# | DEBIT | CREDIT | BALANCE | Present/Un Present | Date
2011-05-06 00:00:00 | 67 | BL-02 | Opp. | Oppening | Deposit Cash to Open Account | 5222838 | 268551 | Deposit |  | 26 | BL-02 | 5000 |  | 5000 | Oppening | 2011-05-11 00:00:00
2011-05-16 00:00:00 | 67 | BL-02 | Funds Transfer | SCB-IC | Funds transfer from SCB-IC | 2596698 | 3537536 | Deposit |  | 41 | BL-02 | 450000 |  | 455000 | Present | 2011-05-16 00:00:00
2011-05-17 00:00:00 | 67 | BL-02 | P-22 | Lbr-Ashraf-Shutring | Labour,Shuttring,Ashraf | 54689126 | HMB | A-1 | 1 | 221 | CL-10 |  | 50000 | 405000 | Present | 2011-05-17 00:00:00
2011-05-17 00:00:00 | 67 | BL-02 | P-05 | Lbr-M.Husain-Block Mason | Labour,M.Husain,Block Mason | 54689127 | HMB | A-1 | 21 | 21 | CL-10 |  | 40000 | 365000 | Present | 2011-05-17 00:00:00
2011-05-17 00:00:00 | 67 | BL-02 | P-22 | Lbr-Iqbal-Plumber | Labour,[NAME],Plumber | 54689128 | HMB | A-1 | 1 | 223 | CL-10 |  | 20000 | 345000 | Present | 2011-05-17 00:00:00
2011-05-17 00:00:00 | 67 | BL-02 | P-22 | Zulqarnain | Zulqarnain,[NAME] | 54689129 | HMB | A-1 | V-04 | 210 | CL-10 |  | 18000 | 327000 | Present | 2011-05-17 00:00:00
2011-05-17 00:00:00 | 67 | BL-02 | Funds Transfer | BAH-F | Funds transfer to F-A/C | 54689131 | HMB | A-1 |  | 27 | BL-02 |  | 1000 | 326000 | Present | 2011-05-16 00:00:00
2011-05-18 00:00:00 | 67 | BL-02 | P-22 | LP | LP | 54689136 | HMB | A-1 | V-04 | 213 | CL-10 |  | 295046 | 30954 | Present | 2011-05-19 00:00:00
2011-05-16 00:00:00 | 67 | BL-02 | P-22 | PS-Ishtiaq | PS,Ishtiaq | 54689138 | HMB | A-1 |  | 6 | PS-09 |  | 10000 | 20954 | Present | 2011-05-17 00:00:00
2011-05-16 00:00:00 | 67 | BL-02 | P-22 | Lbr-Ahmed-Steel Fixture | Labour,Ahmed,Steel Fixture | 54689140 | HMB | A-1 | 10 | 202 | CL-10 |  | 15000 | 5954 | Present | 2011-05-17 00:00:00
2011-05-16 00:00:00 | 67 | BL-02 | P-22 | PS-Ishtiaq | PS,Ishtiaq | 54689141 | HMB | A-1 |  | 6 | PS-09 |  | 5000 | 954 | Present | 2011-05-17 00:00:00
Spreadsheet: 6cbdaa25-83e9-4701-8549-c9bc85869edc
Sheet: EPR Rev Stats

Supplemental Data (Unaudited)
 | Periods Ended March 31,
Revenue Metrics | Second Quarters |  |  | Six Months
 | 2013 | 2012 |  | 2013 | 2012
In millions, unless otherwise noted
Gaming Operations
Revenues | 254.3 | 266.1 |  | 496.9 | 518.1
North America | 220.3 | 233.1 |  | 428.8 | 452.6
International | 34 | 33 |  | 68.1 | 65.5
Gross margin | 0.62 | 0.61 |  | 0.62 | 0.61
North America | 0.6 | 0.59 |  | 0.61 | 0.59
International | 0.69 | 0.75 |  | 0.69 | 0.74
Installed base ('000) | 56.7 | 56.1 |  | 56.7 | 56.1
North America | 42.59999999999999 | 42.7 |  | 42.59999999999999 | 42.7
International | 14.1 | 13.4 |  | 14.1 | 13.4
Average revenue per unit per day (0.00) | 49.26 | 52.34 |  | 47.99 | 51.75
Product Sales
Revenues | 279 | 240.8 |  | 513.7 | 421.8
North America | 200.6 | 160.8 |  | 359.5 | 263.9
International | 78.4 | 80 |  | 154.2 | 157.9
Machines | 202.4 | 161.1 |  | 359.8 | 276.8
North America | 148.7 | 101.4 |  | 250.5 | 160.5
International | 53.7 | 59.7 |  | 109.3 | 116.3
Non-machine | 76.6 | 79.7 |  | 153.9 | 145
North America | 51.9 | 59.4 |  | 109 | 103.4
International | 24.7 | 20.3 |  | 44.9 | 41.6
Gross margin | 0.52 | 0.55 |  | 0.52 | 0.53
North America | 0.53 | 0.57 |  | 0.54 | 0.55
International | 0.49 | 0.5 |  | 0.48 | 0.49
Units recognized ('000) | 14.3 | 10.2 |  | 25 | 17.5
North America | 11.1 | 6.8 |  | 18.3 | 10.6
International | 3.2 | 3.4 |  | 6.7 | 6.9
Units shipped ('000) [includes units where revenues deferred] | 14.3 | 10.5 |  | 23.7 | 17
North America | 11.1 | 6.7 |  | 18 | 10.2
New | 2.7 | 1.7 |  | 4.4 | 2.4
Replacement | 8.4 | 5 |  | 13.6 | 7.8
International | 3.2 | 3.8 |  | 5.699999999999999 | 6.8
New | 1 | 2 |  | 1.9 | 3.3
Replacement | 2.2 | 1.8 |  | 3.8 | 3.5
Average machine sales price ('000) | 14.1 | 15.8 |  | 14.4 | 15.8
North America | 13.4 | 14.9 |  | 13.7 | 15.1
International | 16.6 | 17.6 |  | 16.3 | 16.9
Interactive
Revenues | 66.7 | 34.3 |  | 119.6 | 46.9
North America | 54.8 | 21.6 |  | 96.69999999999999 | 21.7
International | 11.9 | 12.7 |  | 22.9 | 25.2
Social | 54.3 | 21.3 |  | 95.6 | 21.3
North America | 54.3 | 21.3 |  | 95.6 | 21.3
International | 0 | 0 |  | 0 | 0
IGTi | 12.4 | 13 |  | 24 | 25.6
North America | 0.5 | 0.3 |  | 1.1 | 0.4
International | 11.9 | 12.7 |  | 22.9 | 25.2
Gross margin | 0.61 | 0.54 |  | 0.6 | 0.53
North America | 0.61 | 0.58 |  | 0.61 | 0.58
International | 0.58 | 0.47 |  | 0.54 | 0.49
DoubleDown Casino® Average User Statistics*
Daily active users (DAU) ('000) | 1690 | 1350 |  | 1575 | 1350
Monthly active users (MAU) ('000) | 6276 | 4975 |  | 5596 | 4975
Bookings per DAU (0.00) | 0.37 | 0.24 |  | 0.34 | 0.24
*as a single application with multiple games, active users equal unique users
Spreadsheet: 784468d1655744888-cross-reference-data-from-2-tables-to-calculate-a-third-table-sample
Sheet: Sheet5

DATA TABLE 1 |  |  |  |  |  |  |  |  |  |  |  | Results
 |  | End Item
 |  | W | X | Y | Z |  |  |  |  |  |  |  |  | Week
Detail PN | A |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total | Validation
 | B |  | 5 | 1 |  |  |  |  |  |  |  | Detail PN | A |  |  |  |  |  |  |  |  |  |  | <-- | This is nice and clean but very manual. It isn't remotely realistic for the amount of data I have when you are talking rolling 52 weeks forecast, ~70 end items, and ~400 [NAME] PNs.
 | C | 3 |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  |  | <--
 | D |  |  | 2 |  |  |  |  |  |  |  |  | C |  |  |  |  |  |  |  |  |  |  | <--
 | E | 2 |  |  |  |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  |  |  | <-- | This long chain of adding multiplications works. When you have ~70 end items though, the formula is [NAME]. It also is a pain to update when new End Items and/or Detail PNs are added. Plus if for some reason the 2 tables get out of order with respect to each other, the formulas might return invalid results.
 | F | 1 |  | 6 |  |  |  |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  |  | <--
 | G |  | 1 |  |  |  |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  |  |  | <--
 |  |  |  |  |  |  |  |  |  |  |  |  | G |  |  |  |  |  |  |  |  |  |  | <--
DATA TABLE 2
 |  | Week
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total
End Item | W | 1 |  |  |  |  |  | 5
 | X |  |  | 5 |  |  | 1 | 5
 | Y |  |  | 6 |  |  |  | 5 | 1
 | Z |  |  |  |  | 2 | 3 | 5
Spreadsheet: drew_fossum__8687__Fixed3_113000
Sheet: ENA_#QO886.1-Expired

NORTHERN NATURAL GAS COMPANY
FUEL HEDGING BOOK
Enron North America_20
Deal #QO886.1
Prod. | Contract | Contract | Strike |  | Fuel | Floating | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  |  |  | (4) | (4) | (4)
2000-11-01 00:00:00 |  | ENA-Call Option | 0.775 |  | 500000
NNG DOES NOT MAKE PAYMENT TO ENA BECAUSE THE FLOATING PRICE IS LESS THAN THE STRIKE PRICE.
2001-12-01 00:00:00 | 4.785
2002-07-01 00:00:00 | 4.042
 |  | Floating Price