tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7867__ONEOKRECAP2001
Sheet: OCT 01

INTERNAL REPORT ONLY |  |  | OCTOBER ONEOK IMBALANCE SUMMARY |  |  |  |  |  |  |  | POI 420 |  | 78109 & 71410 |  | POI 78108 |  | POI 78107 |  | 65, 62867
 | SUBLETTE | HOLCOMB | HUGOTON |  | BUSHTON PVR |  | MULLINVILLE |  | BUSHTON PROD. |  | DELHI BEAVER |  | ELLIS CO #1/#2 |  | WWD CO #1 |  | CLARK CO #1 |  | HEMPHILL/CANADIAN |  | ONEOK
 | 103132 | 103134 | TOTAL DEVIATION |  | 103135 |  | 103133 |  | 103138 |  | 106901 |  | 107444 |  | 107445 |  | 107446 |  | 108308 |  | TOTAL DEVIATION |  |  | SUBLETTE | HOLCOMB | HUGO | PVR | MULL | BUSHTON | D.BVR | ELL 1 | WWD 1 | CLK 1 | HEMP/CAN |  |  |  |  |  |  |  |  |  | ONEOK
2001-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103132 | 103134 | TOTAL | 103135 | 103133 | 103138 | 106901 | 107444 | 107445 | 107446 | 104307 |  |  |  |  |  |  |  |  |  | TOTAL DEVIATION
(EST) BEGINNING BALANCE | 42246 | -393780 |  |  | 175673 |  | 10252 |  | -9977 |  | 7647 |  | 40263 |  | -3030 |  | 15405 |  | 144771
2001-10-01 00:00:00 | 2341 | 1283 |  |  | 789 |  | 34 |  | -41 |  | 0 |  | 2232 |  | 168 |  | 263 |  | -2458
 | -25844 | 2805 |  |  | 6289 |  | 32 |  | -21 |  | 0 |  | 2510 |  | 107 |  | 390 |  | 627
 | 7101 | 341 |  |  | -1816 |  | 35 |  | -30 |  | 0 |  | 2549 |  | 144 |  | 267 |  | -2856
 | 4128 | 740 |  |  | -2673 |  | 142 |  | -16 |  | 0 |  | 2525 |  | 76 |  | 62 |  | -4494
 | 5877 | 887 |  |  | 6272 |  | 218 |  | -2 |  | 0 |  | 452 |  | -61 |  | 77 |  | 850
 | 3235 | -666 |  |  | -321 |  | 231 |  | 10 |  | 0 |  | 319 |  | 47 |  | 429 |  | 282
 | 3023 | -1769 |  |  | -597 |  | 231 |  | 11 |  | 0 |  | 448 |  | -13 |  | 382 |  | 13
 | 6224 | -1558 |  |  | 397 |  | 230 |  | -13 |  | 0 |  | 458 |  | 66 |  | 308 |  | -137
 | 7933 | -1151 |  |  | 916 |  | 231 |  | 17 |  | 0 |  | 825 |  | 27 |  | -144 |  | 277
 | 12779 | -387 |  |  | -2046 |  | 230 |  | -4 |  | 0 |  | 705 |  | 26 |  | -92 |  | -17
 | 20140 | -4281 |  |  | -5473 |  | 232 |  | -12 |  | 0 |  | 621 |  | -121 |  | -124 |  | -255
 | 8086 | 19 |  |  | -3489 |  | 231 |  | 23 |  | 0 |  | 528 |  | -108 |  | -140 |  | 11
 | 7226 | -1867 |  |  | 2234 |  | 231 |  | -4 |  | 0 |  | 491 |  | -179 |  | -129 |  | 28
 | 3467 | -501 |  |  | 6343 |  | 232 |  | -8 |  | 0 |  | 199 |  | -72 |  | -155 |  | -225
 | 12136 | 1680 |  |  | 115 |  | 232 |  | 22 |  | 0 |  | 353 |  | -38 |  | -190 |  | -394
 | 13020 | -4696 |  |  | 4291 |  | 231 |  | 14 |  | 0 |  | 259 |  | -31 |  | -162 |  | -562
2001-10-31 00:00:00
VOLUME ADJ.
OC TOBER CUMULATIVE
EST ENDING BALANCE
 |  |  |  |  |  |  |  |  |  |  | BAD DAS
 |  |  | 3161324
 |  |  | 3162595
Spreadsheet: 84047d1284048944-countif-formula-with-blank-cells-golf-calculator-2
Sheet: FORMULA TABLES

HNDCP | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
13 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
14 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
15 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0
16 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
17 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
18 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
19 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
20 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
21 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
22 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
23 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
24 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
25 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
26 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
27 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
28 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
29 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1
30 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1
31 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1
32 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1
33 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1
34 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1
35 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1
36 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
37 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
38 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
39 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
40 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Spreadsheet: 63807d1264679831-multiple_countif-multiple_countif
Sheet: Sheet1

Voltage
Site | Unit 1 | Unit 2 | Unit 3 | Unit 4 | Unit 5
BDLI05 | 24 | 24 | 24 | 48 | 24 |  | I need to count the number of units of 24 volts from (unit 2 to unit 5) when unit 1 is 24 volts. Example: Count of 24 volts units in unit 2 is 8, unit 3 is 10, unit 4 is 7, unit 5 is 6. Total count is 31 units.
BPNA15 | 24 | 24 | 24 | 48 | 48
LDPR36 | 48 | 48 | 24 | 48 | 48
KUDN41 | 24 | 48 | 24 | 48 | 48
FZBD35 | 48 | 48 | 48 | 24 | 24
DVKN95 | 48 | 24 | 48 | 24 | 24
ZHID94 | 24 | 48 | 48 | 24 | 24
BTHR65 | 48 | 24 | 48 | 24 | 48
SKHU45 | 48 | 24 | 24 | 24 | 48
CHDN52 | 48 | 24 | 24 | 48 | 24
PLPA46 | 24 | 48 | 48 | 48 | 24
KALO64 | 48 | 48 | 48 | 48 | 24
BGHR06 | 24 | 24 | 24 | 24 | 24
BGHR05 | 24 | 24 | 24 | 24 | 48
BGHR07 | 48 | 48 | 48 | 48 | 24
MTHL10 | 24 | 24 | 48 | 48 | 48
CKWS06 | 48 | 24 | 48 | 48 | 24
AMPR30 | 48 | 24 | 48 | 48 | 24
SSRL24 | 24 | 24 | 48 | 24 | 48
MROT23 | 48 | 48 | 48 | 24 | 48
DDPR08 | 24 | 48 | 48 | 48 | 48
MEHM14 | 24 | 48 | 24 | 24 | 48
KRDA33 | 24 | 48 | 24 | 24 | 48
BHNI36 | 48 | 24 | 24 | 24 | 48
BLBA49 | 24 | 24 | 24 | 48 | 48
PSMN29 | 24 | 24 | 24 | 48 | 48
MEHM21 | 48 | 48 | 24 | 48 | 48
KHKR10 | 24 | 48 | 24 | 48 | 24
PPLI69 | 48 | 48 | 24 | 48 | 24
SMCH27 | 48 | 48 | 48 | 48 | 24
KTRA05 | 24 | 48 | 48 | 24 | 24
Spreadsheet: 848469d1699202035-how-to-filter-select-specific-strings-from-a-big-database-if-and-or-search-left-example-for-forum-3-nov-2023-jacc-2_extended-2-
Sheet: Forum (3)

 |  |  |  |  |  |  |  |  |  | How can I adapt the formula to only exclude strings that start with "Method", "A method", "The Method"?
 |  |  |  |  | A
Some examples for strings that occur in the big data sheet (80 columns; 900 rows) |  |  |  |  | An |  |  |  |  | Method
 |  |  |  |  |  |  |  |  |  | A method
Attempt 1 |  |  |  |  |  |  |  |  |  | The method
Apparatus for controlling a flow of molten source material | Apparatus for controlling something different | A method for controlling a flow
A method of improving a measurement of a parameter of interest | A method of improving a measurement of a parameter of interest | A method as claimed in claim 1
A lithographic apparatus | A lithographic apparatus comprising: [NAME] and the processing arrangement of claim XXX. | Exposure apparatus
An apparatus to perform the method of any of claims 1 to 14. | An apparatus | An apparatus, comprising a component
Method for control a flow | Method for controlling a flow according to claim 1 | The method for controlling a flow according to claim 1 or 2
An apparatus according to claim 1 | An optical arrangement as claimed in claim 1 | An apparatus according to any of the preceding claims
Spreadsheet: benjamin_rogers__1071__Consolidated 2000 Peaker 8-15-00
Sheet: Summary Output

SUMMARY OUTPUT
SOURCES & USES:
Sources of Funds | % | 000 $ |  | Uses of Funds | % | 000 $
Total Equity |  |  |  | 2000 Plants
Bond Proceeds
Total Sources |  |  |  | Total Uses
FINANCING ASSUMPTIONS:
 | Tranche 1 | Tranche 2 | Tranche 3 | Total
Debt Financing Summary:
Debt Closing Date |  | 2001-01-01 00:00:00
Amount ('000 $) | 0 | 112931 | 236225
Term (yrs)
Final Maturity | #N/A | 2010-12-31 00:00:00 | 2020-12-31 00:00:00
Average Life (yrs)
Treasury Rate (%) | 0.068 | 0.065 | 0.062
Spread (%) | 0.0225 | 0.045 | 0.05
All-in Coupon Rate (%)
Interest Income Rate | 0.05
Equity Financing Summary:
Equity Closing Date | 2001-01-01 00:00:00
Amount ('000 $) | 440765.8119035805
Required After-Tax Rate of Return (%) | 0.14
DEPRECIATION ASSUMPTIONS:
 | Initial Basis (000 $)
 | 2000 | Year | Method | Residual (%)
Federal & State Tax Depreciation
Total Project Cost |  | 15 | MACRS | 0
Book Depreciation
Total Project Cost |  | 30 | SL | 0.1
SUMMARY OUTPUT:
DSCR |  |  | Min | [NAME].
Merchant Price Period
Weighted Average Heat Rate (Btu/kWh)
Summer Capacity (MW)
Salvage Value (2 x EBITDA) at the end of 20 years ($/kW)
Equity's After-Tax Returns with Salvage Value (20 yrs)
 | 2001 | 2002 | 2003 | 2004 | 2005
GenCo EBITDA (000 $)
GenCo Net Income (000 $)
[NAME] (000 $)
GenCo After-Tax Cashflow (000 $)
Spreadsheet: 183962d1349103629-excel-pivot-tables-tf-performance-2-latest-q3
Sheet: Sheet12

Ops # | Month | Date | Year | Client | Buyer | Cargo Type | Nominated Cargo Quantity (MT) | Support Craft | Invoiced Ammount ($) | Commenced Fendering | Completed Fendering | Total Fendering Time | Mooring Master
935 | February |  | 2012 | Glencore | Rainoil | AGO | 4800 | Top Fenders 1 |  | 01:36:00 | 03:48:00 | 02:12:00 | Young Ogori
929 | February |  | 2012 | Glencore | [NAME]. Ltd | AGO | 2650 | Top Fenders 1 |  | 13:10:00 | 13:36:00 | 00:26:00 | Moses Edege
924 | February |  | 2012 | Glencore | Agri | AGO | 6000 | Top Fenders 1 | 9184.72 | 05:36:00 | 06:46:00 | 01:10:00 | Moses Edege
923 | February |  | 2012 | Vitol | Agri | AGO | 6000 | Glory | 18027.08 | 12:22:00 | 13:16:00 | 00:54:00 | [NAME]
920 | February |  | 2012 | Glencore | Sirocco Shipping | AGO | 6000 | Glory | 9503.47 | 00:18:00 | 01:30:00 | 01:12:00 | Moses Edege
919 | February |  | 2012 | Vitol | Pokat | AGO | 4800 | Glory | 10861.11 | 18:30:00 | 19:18:00 | 00:48:00 | [NAME]
918 | February |  | 2012 | Vitol | Gulf Treasures | AGO | 4900 | Mensah | 10000 | 02:12:00 | 03:06:00 | 00:54:00 | [NAME]
915 | February |  | 2012 | Nimex | Vitol | AGO | 4700 | Mensah | 8000 | 15:08:00 | 16:16:00 | 01:08:00 | [NAME]
913 | February |  | 2012 | Glencore | SK Shipping | AGO | 5200 | Top Fenders 1 | 9288.89 | 01:30:00 | 02:24:00 | 00:54:00 | [NAME]
912 | February |  | 2012 | Sahara | [NAME] | AGO | 15000 | Mensah | 22365.62 | 07:46:00 | 08:44:00 | 00:58:00 | Philly Okanre
911 | February |  | 2012 | Mercuria | Mercuria | AGO | 1800 | Top Fenders 1 | 8500 | 20:28:00 | 21:36:00 | 01:08:00 | [NAME]
909 | February |  | 2012 | Glencore | Agri | AGO | 6000 | Mensah | 11944.44 | 00:14:00 | 00:54:00 | 00:40:00 | [NAME]
907 | February |  | 2012 | Mercuria | Agri | AGO | 5900 | Mensah | 10483.33 | 14:30:00 | 15:20:00 | 00:50:00 | [NAME]
906 | February |  | 2012 | Petrocam | Petrocam | AGO | 6000 | Glory | 21509.72 | 11:00:00 | 11:54:00 | 00:54:00 | Philly Okanre
904 | February |  | 2012 | Glencore | SK shipping | AGO | 2200 | Mensah | 8000 | 15:36:00 | 16:12:00 | 00:36:00 | [NAME]
901 | February |  | 2012 | Glencore | Agri | AGO | 6000 | Glory | 26566.67 | 10:58:00 | 12:12:00 | 01:14:00 | [NAME]
900 | February |  | 2012 | Agri | [NAME] | AGO | 6000 | Glory | 9810.42 | 12:30:00 | 13:24:00 | 00:54:00 | [NAME]
899 | February |  | 2012 | Glencore | Glencore | AGO | 14898 | Mensah | 16533.33 | 07:12:00 | 07:54:00 | 00:42:00 | [NAME]
898 | February |  | 2012 | Glencore | SK shipping | AGO | 5100 | Glory | 11988.89 | 09:30:00 | 10:20:00 | 00:50:00 | [NAME]
897 | February |  | 2012 | Nimex | Rahmaniyya | AGO | 8500 | Glory | 11266.67 | 07:48:00 | 08:32:00 | 00:44:00 | Goodness [NAME]
896 | February |  | 2012 | Glencore | Glencore | AGO | 8600 | Mensah | 8966.67 | 13:40:00 | 14:26:00 | 00:46:00 | [NAME]
895 | February |  | 2012 | Nimex | Nimex | AGO | 5000 | Glory | 9044.44 | 21:48:00 | 22:42:00 | 00:54:00 | Philly Okanre
894 | February |  | 2012 | Glencore | Petrocam | AGO | 15000 | Top Fenders 1 | 19437.58 | 10:46:00 | 12:24:00 | 01:38:00 | [NAME]
Spreadsheet: 740942d1626713764-auto-calculate-end-date-auto-calculate-end-date
Sheet: Sheet2

Job | Allocated Hours | start date | End Date | Date | Day | Working hours |  |  |  |  | 08:00:00 | 15:00:00
Job A | 40 | 2021-07-19 10:35:00 | ?? | 2021-07-19 00:00:00 |  | 7
Job B | 40 | 2021-07-19 12:00:00 | ?? | 2021-07-20 00:00:00 |  | 7
Job C | 50 | 2021-07-19 09:00:00 | ?? | 2021-07-21 00:00:00 |  | 7
 |  |  |  | 2021-07-22 00:00:00 |  | 7
 |  |  |  | 2021-07-23 00:00:00 |  | 0
 |  |  |  | 2021-07-24 00:00:00 |  | 0
 |  |  |  | 2021-07-25 00:00:00 |  | 0
 |  |  |  | 2021-07-26 00:00:00 |  | 7
 |  |  |  | 2021-07-27 00:00:00 |  | 7
 |  |  |  | 2021-07-28 00:00:00 |  | 7
 |  |  |  | 2021-07-29 00:00:00 |  | 0
 |  |  |  | 2021-07-30 00:00:00 |  | 7
 |  |  |  | 2021-07-31 00:00:00 |  | 7
 |  |  |  | 2021-08-01 00:00:00 |  | 0
 |  |  |  | 2021-08-02 00:00:00 |  | 7
 |  |  |  | 2021-08-03 00:00:00 |  | 7
 |  |  |  | 2021-08-04 00:00:00 |  | 7
 |  |  |  | 2021-08-05 00:00:00 |  | 7
 |  |  |  | 2021-08-06 00:00:00 |  | 0
 |  |  |  | 2021-08-07 00:00:00 |  | 7
 |  |  |  | 2021-08-08 00:00:00 |  | 0
 |  |  |  | 2021-08-09 00:00:00 |  | 7
 |  |  |  | 2021-08-10 00:00:00 |  | 7
 |  |  |  | 2021-08-11 00:00:00 |  | 7
 |  |  |  | 2021-08-12 00:00:00 |  | 7
 |  |  |  | 2021-08-13 00:00:00 |  | 7
 |  |  |  | 2021-08-14 00:00:00 |  | 7
 |  |  |  | 2021-08-15 00:00:00 |  | 7
Spreadsheet: 218236d1362406726-comibining-2-averageif-formula-book8
Sheet: Template

Mean Of Importance |  |  |  | Gender | Age
 |  | Male | 35-44
Spreadsheet: 868871d1715603762-indirect-function-within-sumifs-to-sum-column-based-on-matching-criteria-test-document-2
Sheet: Sheet1

Store code | Store Description | Product Code (Bundle) | Bundle Description | Device | Device Product code | Device Family | Brand | Bundle stock in store | Days cover | Bundle stock in transit | Days cover | Device average weekly sales | [NAME] fill | Device Forward forecast | Attach rate
 |  |  |  | Apples | 300025684 |  | Green
 |  |  |  | Bananas | 300026129 |  | Yellow
 |  |  |  | Strawberries | 300027564 |  | Red
Spreadsheet: 877470d1724302693-yahtzee-bonus-formula-yahtzee-scorecard
Sheet: Sheet1

Yahtzee
Upper Section |  | How to Score |  | Cassia |  |  | [NAME] |  |  | Greg
Ones |  | Sum of All Ones |  | 4 |  |  | 4 |  |  | 3
Twos |  | Sum of All Twos |  | 4 |  |  | 8 |  |  | 2
Threes |  | Sum of All Threes |  | 12 |  |  | 6 |  |  | 6
Fours |  | Sum of All Fours |  | 0 |  |  | 4 |  |  | 0
Fives |  | Sum of All Fives |  | 0 |  |  | 15 |  |  | 25
Sixes |  | Sum of All Sixes |  | 24
Sub Total
Bonus if >= 63 |  | Add 35
Total |  | Sum of All Total
Lower Section
3 of a Kind |  | Sum of All Dice |  | 28 |  |  | 23 |  |  | 24
4 of a Kind |  | Sum of All Dice |  |  |  |  |  |  |  | 24
Full House |  | Score 25 |  | 25 |  |  | 25 |  |  | 25
Sm Straight |  | Score 30 |  | 30 |  |  | 30
Lg Straight |  | Score 40 |  |  |  |  | 40 |  |  | 40
Yahtzee |  | Score 50 |  |  |  |  | 50 |  |  | 50
Chance |  | Sum of All Dice |  | 18
 |  | X for Each Bonus |  |  |  |  |  |  |  | X
 |  | Score 100 Per X
Total of Lower
Total of Upper
Grand Total
Spreadsheet: 807571d1669948869-adjust-array-to-column-guided-by-cell-value-test-document-eba
Sheet: Data Presentation

 | Item | 3 | 2 | 1
 | Machine Size
 | status | machine | type | size | screw
 | new | servo | electric | 100 | 5
 | new | hydraulic | oil | 200 | 10
 | new | pneumatic | air | 300 | 15
 | new | hybrid | oil-electric | 400 | 20
Spreadsheet: 105884d1303157291-averageifs-value-returned-sommaire-help
Sheet: Sommaire

Sommaire
 | Lundi | Mardi | Mercredi | Jeudi | Vendredi
20 KG
15 KG
10 KG
Spreadsheet: 764012d1642526854-order-scheduler-formula-help-required-please-order-schedule-test-jt
Sheet: Summary

WK No: | WK2 |  |  |  | [NAME]
Code: |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Product 12 | Product 13 | Product 14 | Product 15 | Product 16 | Product 17 | Product 18 | Product 19 | Product 20 | Product 21 | Product 22 | Product 23 | Product 24 | Product 25 | Product 26
 | Order Number |  | 469944 | 472923 | 469945 | 477065 | 467287 | 439127 | 463348 | 477067 | 456820
 | Quantity |  | 1820 | 1820 | 1820 | 2028 | 3042 | 3042 | 3042 | 2704 | 3042
 | Required By |  | 2022-01-24 00:00:00 | 2022-01-17 00:00:00 | 2022-01-17 00:00:00 | 2022-02-21 00:00:00 | 2022-01-24 00:00:00 | TBC | 2022-01-17 00:00:00 | 2022-02-07 00:00:00 | 2022-02-07 00:00:00
 | Notes: |  | New Order |  | Brought Forward |  | Brought Forward |  | Delayed
 | Other Details
 | Order Number |  |  | 479841 | 477064 |  | 481161 | 442911 |  | 477068 | 477069
 | Quantity |  |  | 1820 | 1820 |  | 3042 | 3042 |  | 2704 | 3042
 | Required By |  |  | 2022-03-07 00:00:00 | 2022-01-31 00:00:00 |  | 2022-02-07 00:00:00 | TBC |  | 2022-02-28 00:00:00 | 2022-03-14 00:00:00
 | Notes: |  |  | New Order | New Order |  | New Order |  |  | Amended Order
 | Other Details
 | Order Number |  |  | 468542 | 478386 |  | 481162 | 444593 |  | 479842
 | Quantity |  |  | 1820 | 1820 |  | 3042 | 3042 |  | 2704
 | Required By |  |  | 2022-01-10 00:00:00 | 2022-03-07 00:00:00 |  | 2022-03-07 00:00:00 | TBC |  | 2022-03-21 00:00:00
 | Notes: |  |  |  | New Order |  | New Order |  |  | New Order
 | Other Details
 | Order Number |  |  |  | 478387
 | Quantity |  |  |  | 1820
 | Required By |  |  |  | 2022-03-28 00:00:00
 | Notes: |  |  |  | New Order
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
Spreadsheet: 865339d1712361677-repeat-character-based-on-value-in-adjacent-cell-repeat-character-based-on-value-in-adjacent-cell
Sheet: Sheet1

 | A | 2 |  | A | 1
 | B | 3 |  | A | 2
 | C | 4 |  | B | 1
 |  |  |  | B | 2
 |  |  |  | B | 3
 |  |  |  | C | 1
 |  |  |  | C | 2
 |  |  |  | C | 3
 |  |  |  | C | 4
Spreadsheet: mary_fischer__25627__1292
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1292
COMPANY NAME    Marlin Fair Value Co.
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 716517d1612254518-calculate-difference-between-dates-only-if-a-condition-is-met-excel-help-2-ans
Sheet: Sheet1

Staff member | Date | Attendance | Frequency
XX | 2020-12-12 00:00:00 | Yes |  | Extra space in attendance column removed.
XX | 2020-12-26 00:00:00 | No
XX | 2021-01-15 00:00:00 | Yes
XX | 2021-02-03 00:00:00 | No
XX |  | Yes
XX | 2021-02-15 00:00:00 | No
XX | 2021-01-31 00:00:00 | Yes
XX | 2021-02-27 00:00:00 | No
XX | 2021-02-18 00:00:00 | Yes
XX | 2021-03-11 00:00:00 | No
XX | 2021-02-24 00:00:00 | Yes
Spreadsheet: vkaminski__40704__EB19K1~CPI for 121799_Shirley Crenshaw~IR
Sheet: Sheet1

Listed below are the cost for 55 Copy Per Minute Machines
Copier | [NAME] in Months | [NAME] | [NAME] cost | Maint cost | Images per month | Total Cost per month | Cost Per Image {CPI}
{Danka Rental Plan includes 0 images}
Canon IR550 {Digital} | 36 | 55 | 340 | 0.01 | 42315
{Danka Rental Plan includes 0 images}
Toshiba 5570 {Digital} | 36 | 55 | 375 | 0.0095 | 42315
{[NAME] CPI plan includes 18K Images}
[NAME] {Digital} | 36 | 55 |  | 0.0284 | 42315
Listed below are the cost for 65 Copy Per Minute Machines
Copier | [NAME] in Months | [NAME] | [NAME] cost | Maint cost | Images per month | Total Cost per month | Cost Per Image {CPI}
{Danka Rental Plan includes 0 images} {45 day wait @ present}
Canon IR600 {Digital} | 36 | 65 | 350 | 0.01 | 42315
{[NAME] CPI plan includes 24K Images}
Lanier 5265 {Digital} | 36 | 65 |  | 0.0095 | 42315
{Danka Rental Plan includes 0 images}
Toshiba 6570 {Digital} | 36 | 65 | 395 | 0.0095 | 42315
Current Copier @ EB2944                                          {The Base Lease charge includes 45K images}
Copier | [NAME] in Months | [NAME] | [NAME] cost | Maint cost | Images per month | Total Cost per month | Cost Per Image {CPI}
Xerox 5365 {ANALOG} | 60 | 65 | 1700 | 0.016 | 42318
Spreadsheet: 3a1a1fc7-be38-4fed-bf3c-f2ba66fc363d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
6319 | 10229 | Ragnhild | Bolstad | NOR | 0 | [NAME] | 00:00:00 | [NAME] | 00:00:00 | 00:23:18 | 1 | 01:14:34
6319 | 68876 | Ane | Hernani | ESP | 0 | 00:17:43 | 00:00:00 | [NAME] | 00:00:00 | 00:28:29 | 2 | 01:24:40
6319 | 10324 | [NAME] | [NAME] | ITA | 0 | 00:19:04 | 00:00:00 | 00:41:23 | 00:00:00 | 00:31:45 | 3 | 01:32:12
6319 | 10251 | [NAME] | Angioi | ITA | 0 | 00:18:47 | 00:00:00 | 00:44:39 | 00:00:00 | 00:56:08 | 4 | [NAME]