tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101903d1299956582-template-sheets-setting-formulas-cashflow-copia
Sheet: CashFlow09

Cash Flow (2009) ('000)
 | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec
Grants | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sales | 16380.5959 | 9597.2281 | 11635.4944 | 12089.1386 | 14012.6527 | 12417.7413 | 13062.9526 | 14712.1533 | 15128.3557 | 15363.4384 | 15642.9222 | 12165.009
Total Cash Inflow | 16380.5959 | 9597.2281 | 11635.4944 | 12089.1386 | 14012.6527 | 12417.7413 | 13062.9526 | 14712.1533 | 15128.3557 | 15363.4384 | 15642.9222 | 12165.009
Payments | 1020 | 700 | 540 | 255 | 624.25 | 147.52 | 666.25 | 542.63 | 852.44 | 711 | 125.5 | 252.6
Wages | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000
Advertising | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
Rent | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250
Other overhead costs | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Total Cash Outflow | 6620 | 6300 | 6140 | 5855 | 6224.25 | 5747.52 | 6266.25 | 6142.63 | 6452.440000000001 | 6311 | 5725.5 | 5852.6
Net cash flow | 9760.5959 | 3297.2281 | 5495.4944 | 6234.138600000002 | 7788.402700000002 | 6670.221300000003 | 6796.702600000002 | 8569.523299999997 | 8675.915700000001 | 9052.4384 | 9917.422199999999 | 6312.409
Opening Balance | 106061.5581 | 115822.154 | 119119.3821 | 124614.8765 | 130849.0151 | 138637.4178 | 145307.6391 | 152104.3417 | 160673.865 | 169349.7807 | 178402.2191 | 188319.6413
Closing Balance | 115822.154 | 119119.3821 | 124614.8765 | 130849.0151 | 138637.4178 | 145307.6391 | 152104.3417 | 160673.865 | 169349.7807 | 178402.2191 | 188319.6413 | 194632.0503000001
Spreadsheet: 813814d1674003727-similar-values-if-function-eh_partial-match-1-
Sheet: Sheet1

 |  |  |  |  |  |  | SM80 | #N/A
 |  |  |  |  |  |  | 190G | #N/A |  | No
 |  |  |  |  |  |  | 180G | #N/A |  | Yes
 |  |  |  |  |  |  | 150G | #N/A |  | No
 |  |  |  |  |  |  | P200 | 200 Gm |  | Yes
 |  |  |  |  |  |  | P240 | 240 Gm |  | Yes
 |  |  |  |  |  |  | 170G | 170 Gm |  | Yes
 |  |  |  |  |  |  | 170G | 170 Gm |  | Yes
 |  |  |  |  |  |  | 200G | 200 Gm |  | Yes
 |  |  |  |  |  |  | 200G | #N/A |  | Yes
 |  |  |  |  |  |  | 200G | #N/A |  | Yes
 |  |  |  |  |  |  | 200G | #N/A |  | Yes
 |  |  |  |  |  |  | 100G | #N/A |  | No
 |  |  |  |  |  |  | 180G | 180 Gm |  | Yes
 |  |  |  |  |  |  | 150G | #N/A |  | No
 |  |  |  |  |  |  | 180G | 180 Gm |  | Yes
 |  |  |  |  |  |  | 180G | #N/A |  | Yes
 |  |  |  |  |  |  | 180G | 180 Gm |  | Yes
 |  |  |  |  |  |  | N180 | 180 Gm |  | Yes
Spreadsheet: 871230d1717611285-split-uneven-number-split-weight
Sheet: Sheet1

Example
SPECIES | MSC | PRESENTATION | TOTAL WEIGHT | TOTAL VALUE | TOTAL BOXES | [NAME] | ODD BOX | BOX VALUE | TOTAL
NEPHROPS |  | WHOLE | 3546 | 14526.35 | 64
NEPHROPS |  | TAILS | 1766 | 7096.92 | 51
Results expected
SPECIES | MSC | PRESENTATION |  |  | TOTAL BOXES |  | BOX WEIGHT | BOX VALUE | TOTAL | TOTAL WEIGHT
NEPHROPS |  | WHOLE
NEPHROPS |  | WHOLE |  |  | 1
NEPHROPS |  | TAIL
NEPHROPS |  | TAIL |  |  | 1
 |  |  |  |  |  | H12 Should be G3*H12  (225.50) |  |  | 14206.5
 |  |  |  |  |  | [NAME] Should be G3*H13  (332.1) |  |  | 332.1
 |  |  |  |  |  | H14 Should be G4*H14  (136.68) |  |  | 6834
 |  |  |  |  |  | [NAME] be G4*H15  (265.32) |  |  | 265.32
Spreadsheet: 62719d1263653639-excel-2007-formula-with-one-cell-being-symbol-book1example
Sheet: Sheet1

 |  |  |  |  | Sales |  | Markdowns |  | Inventory |  | Purchases - Gross |  | Sales | Markdowns | Inventory | Purchases
Dept | Purchases | Sales | Markdowns | Inventory | TY | LY | TY | LY | TY | LY | TY | LY | 1 | 2 | 3 | 4
1 |  |  |  |  |  |  |  |  |  |  | 25.58 | 20.1
2
 | What I am hoping to do is if L6 is + or - M6 by 3 it would put a * in Q6
 | So in this example it would be *
Spreadsheet: 60802d1261398955-data-validation-problem-in-excel-problem_datavalidation-1-
Sheet: Sheet1

SL. NO | Description | UNIT BASIC  PRICE | EXCISE DUTY (Amount) | Sales Tax applicable for Supply in Areas of |  |  |  | PACKING & FORWARDING CHARGES (RS.) | FREIGHT (RS.) | TRANSIT INSURANCE (RS.) | OTHER CHARGES (RS.) | TOTAL LANDED VALUE
 |  |  |  | Madhya Pradesh |  | Chhattisgarh |  |  |  |  |  | FOR SUPPLIES IN AREAS OF
 |  |  |  | CST | VAT | CST | VAT |  |  |  |  | MP | C.G.
 |  | (Rs. Each) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.) | (Rs Each.)
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
Spreadsheet: 35976d1233708888-row-formats-and-if-function-test1
Sheet: Sheet1

SSN | LAST NAME | FIRST NAME | BIRTHDATE
123-45-5678 | SMITH | JON | 1977-10-14 00:00:00
123-45-5679 | DOE | [NAME] | 1982-02-21 00:00:00
123-45-5680 | DOE | JON | 1980-01-31 00:00:00
123-45-5681 | SMITH | [NAME] | 1980-07-27 00:00:00
123-45-5682 | SMITH | SARAH | 1980-02-24 00:00:00
123-45-5683 | DOE | ANDREW | 1988-01-24 00:00:00
123-45-5684 | DOE | STEVEN | 1985-07-07 00:00:00
123-45-5685 | DOE | SANDRA | 1989-07-08 00:00:00
Spreadsheet: sally_beck__33892__010301 consolidated
Sheet: C 01

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards C
 |  | Report C 01:
 |  | Purpose: | To capture what brokers were not confirmed with on the same day (or exceptions to your standard - please indicate standard)
 |  | Trade Date | Commodity | Broker | Quantity of transactions | Total Volume of transactions | Reason not confirmed | Key contact
ENRON NORTH AMERICA
 | Gas & Power - CA
 | Gas - US
 | Power - East
 | Power - West
 | Merchant Assets
 | South America
ENRON GLOBAL MARKETS
 | Equity Trading
 | FX and Interest Rates
ENRON INDUSTRIAL MARKETS |  | Pending | Pulp & Paper | TFS |  |  | Only 2 deals with brokers in the last few months.  Financial confirm desk has not confirmed with broker at all.  Investigating and will follow up. | Moscoso
 |  | 2000-12-22 00:00:00 | ONP #8 | TFS | 1 | 36,000 short tons | Financial desk has not confirmed with broker. Only counterparty. | [NAME]
 |  | N/A | Lumber | No brokered transactions | N/A | N/A | N/A | N/A
 |  | N/A | Steel | No brokered transactions | N/A | N/A | N/A | N/A
ENRON BROADBAND
ENRON WEATHER
EES |  | None | N/A | N/A | N/A | N/A
ENRON EUROPE
 | Australia
 | Japan
 | Enron Metals London | N/A | None | None | None | None
 | Enron Softs | N/A | None | None | None | None
 | Enron Metals NY | N/A | None | None | None | None
 | Enron Metals - Merchanting | 2000-12-29 00:00:00 | Aluminum | EML | 49 | 1867 lots | Waiting on instructions
 |  | 2000-12-29 00:00:00 | Copper | EML | 10 | 203 lots | Waiting on instructions
 |  | 2000-12-29 00:00:00 | Tin | EML | 1 | 1 lot | Waiting on instructions
 |  | 2000-12-29 00:00:00 | Zinc | EML | 4 | 23 lots | Waiting on instructions
 |  | 2000-12-29 00:00:00 | Nickel | EML | 1 | 5 lots | Waiting on instructions
 | Continental Gas | N/A | None | None | None | None
 | Credit Trading | N/A | None | None | None | None
 | Continental Power | N/A | None | None | None | None
 | Structured Commodities | N/A | None | None | None | None
 | UK Power | 2001-12-28 00:00:00 | Power, Forward | Bloomberg | 1 | 300 | Broker not yet sent | Anish Malhutra
 |  | 2001-12-28 00:00:00 | Power, Forward | GFI | 1 | 300 | Broker not yet sent | [NAME]
 |  | 2001-12-28 00:00:00 | Power, Forward | Natsource | 1 | 4200 | Broker not yet sent | [NAME]
 |  | 2001-12-28 00:00:00 | Power, Forward | [NAME] | 1 | 1200 | Broker not yet sent | [NAME]
 | UK Gas | N/A | None | None | None | None | None | None
 | Nordic Power | N/A | None | None | None | None | None | None
Spreadsheet: matt_motley__26429__EOL_Listen
Sheet: Sheet1

Cash | Bid | Offer | Basis |  | [NAME] |  | Bid | Offer | Basis
HeHub |  |  |  |  | HeHub
Socal Ehr |  |  |  |  | SoCal
[NAME] |  |  |  |  | PG&E
PG&E CtyGte |  |  |  |  | Malin
PG&E Topock |  |  |  |  | EP SJ
[NAME] |  |  |  |  | Kern/Opal
Opal |  |  |  |  | [NAME]
[NAME] |  |  |  |  | Permian
[NAME]
EPNG [NAME] |  |  |  |  |  |  |  | 1
SoCal Basis | Bid | Offer |  | Power | [NAME] |  | Nymex | Avg
[NAME] |  |  |  | [NAME] |  |  | Jun
[NAME] |  |  |  | [NAME] |  |  | Jul
Aug FF |  |  |  | Aug [NAME] |  |  | Aug
Nov-Mar FF |  |  |  | N-M Cap |  |  | [NAME]
[NAME] |  |  |  |  |  |  | Nov-Mar
Q3
Q4
Nov-Mar
 | Days | DF | [NAME] | [NAME]
2001-06-01 00:00:00 |  | 0.995162709818523
 |  | 0.989536070542894
 |  | 0.984590369119062
 |  | 0.979271653775459
 |  | 0.974244408656915
 |  | 0.969189883307044
 |  | 0.964391549410643
 |  | 0.959471263863473
 |  | 0.954654475335117
 |  | 0.950047879671858
 |  | 0.945302632886413
 |  | 0.940784497224266
 |  | 0.936120505462727
 |  | 0.931416585813483
 |  | 0.927211171489436
Spreadsheet: 875683d1722297890-weather-data-report-help-consolidated-chester-county-weather-sample-2-
Sheet: Station List

 |  |  |  |  |  |  |  |  |  |  | 1893 | 1
Chester County PA Climate Data Station Sources
# | Station Location | Coordinates | Data Range | Elevation ASL (FT) | Obs Years
1 | East Nantmeal 1 SSW | 40.11/75.73 | 2004 - Present | 685 | 20
2 | Atgen | 39.92/75.99 | 2012 - Present | 663 | 12
3 | KMQS (Coatesville) Airport | 39.98/75.87 | 2008 - Present | 659 | 16
4 | West Grove 2S | 39.86/75.84 | 2009 - Present | 650 | 15
5 | Sadsburyville | 39.98/75.88 | 1911-1922 | 649 | 12
6 | Coatesville 2W | 39.98/75.86 | 1983 - 2007 | 640 | 25
7 | Glenmoore 2SW | 40.07/75.78 | 2012 - Present | 620 | 12
8 | Glenmoore | 40.09/75.75 | 2006-2021 | 600 | 16
9 | Morgantown/Elverson | 40.09/75.54 | 1951 - 1985 | 595 | 35
10 | [NAME] |  | 1979 - 2005 | 595 | 26
11 | KOQN (West Chester) Airport | 39.99/75.58 | 2019 - Present | 465 | 5
12 | Longwood Gardens | 39.87/75.68 | 2008 - Present | 459 | 16
13 | West Grove | 39.80/75.80 | 1962-1976 | 449 | 15
14 | [NAME] | 39.74/76.05 | 2012 - Present | 440 | 12
15 | West Chester 2NW | 39.97/75.67 | 1893 - 2017 | 440 | 125
16 | [NAME] | 40.09/75.62 | 2012 - Present | 407 | 12
17 | Warwick | 40.16/75.73 | 2012 - Present | 407 | 12
18 | Devault 1W | 40.08/75.55 | 1951 -1988 | 360 | 38
19 | Westtown |  | 1894 - 1902 | 350 | 9
20 | Kennett Square 2S | 39.82/75.73 | 2009 - Present | 348 | 15
21 | Coatesville 1SW | 39.96/75.83 | 1894 -1982 | 342 | 89
22 | Kennett Square | 39.85/75.71 | 1894 -1924 | 340 | 31
23 | West Bradford | 39.94/75.52 | 2012 - Present | 335 | 12
24 | West Chester 2SE | 39.96/75.59 | 2012 - Present | 325 | 12
25 | Spring City | 40.17/75.58 | 2020 to Present | 256 | 4
26 | Downingtown 3SE |  | 2000 to 2003 | 216 | 3
27 | [NAME]  1SE | 40.07/75.47 | 2012 - Present | 197 | 12
28 | Phoenixville 1E | 40.12/75.49 | 1893 - Present | 105 | 131
Spreadsheet: 751901d1634418685-assign-work-order-to-variable-team-members-even-allocation-of-workorders
Sheet: Sheet1

WORK ORDER CASE 1 |  |  |  | TEAM |  |  |  |  |  |  | WORK ORDER CASE 2 |  |  | TEAM
10111 |  |  |  | [NAME] |  |  |  |  |  |  | 10111 |  |  | [NAME]
10112 |  |  |  | [NAME] |  |  |  |  |  |  | 10112 |  |  | [NAME]
10113 |  |  |  | Ella |  |  |  |  |  |  | 10113 |  |  | Ella
10114 |  |  |  | [NAME] |  |  |  |  |  |  | 10114 |  |  | [NAME]
10115 |  |  |  | [NAME] |  |  |  |  |  |  | 10115 |  |  | [NAME]
10116 |  |  |  |  |  |  |  |  |  |  | 10116
10117 |  |  |  |  |  |  |  |  |  |  | 10117
10118 |  |  |  |  |  |  |  |  |  |  | 10118
10119 |  |  |  |  |  |  |  |  |  |  | 10119
10120 |  |  |  |  |  |  |  |  |  |  | 10120
10121 |  |  |  |  |  |  |  |  |  |  | 10121
10122 |  |  |  |  |  |  |  |  |  |  | 10122
10123 |  |  |  |  |  |  |  |  |  |  | 10123
10124 |  |  |  |  |  |  |  |  |  |  | 10124
10125 |  |  |  |  |  |  |  |  |  |  | 10125
10126 |  |  |  |  |  |  |  |  |  |  | 10126
10127 |  |  |  |  |  |  |  |  |  |  | 10127
10128 |  |  |  |  |  |  |  |  |  |  | 10128
10129 |  |  |  |  |  |  |  |  |  |  | 10129
10130 |  |  |  |  |  |  |  |  |  |  | 10130
10131 |  |  |  |  |  |  |  |  |  |  | 10131
10132 |  |  |  |  |  |  |  |  |  |  | 10132
10133 |  |  |  |  |  |  |  |  |  |  | 10133
10134 |  |  |  |  |  |  |  |  |  |  | 10134
10135 |  |  |  |  |  |  |  |  |  |  | 10135
10136 |  |  |  |  |  |  |  |  |  |  | 10136
10137 |  |  |  |  |  |  |  |  |  |  | 10137
10138 |  |  |  |  |  |  |  |  |  |  | 10138
10139 |  |  |  |  |  |  |  |  |  |  | 10139
10140 |  |  |  |  |  |  |  |  |  |  | 10140
10141 |  |  |  |  |  |  |  |  |  |  | 10141
 |  |  |  |  |  |  |  |  |  |  | 10142
 |  |  |  |  |  |  |  |  |  |  | 10143
 |  |  |  |  |  |  |  |  |  |  | 10144
 |  |  |  |  |  |  |  |  |  |  | 10145
 |  |  |  |  |  |  |  |  |  |  | 10146
 |  |  |  |  |  |  |  |  |  |  | 10147
 |  |  |  |  |  |  |  |  |  |  | 10148
Spreadsheet: 104764d1302221884-change-range-from-another-cell-dynamic-cell-address
Sheet: Sheet1

This is for example only
Start Range at Cell: |  | 4
1.43007
1.43018
1.43014
1.4301
1.42989
1.42983 |  | I want C2 to be an input cell so that if I change it to any other number - lets say 26, it would then change the formula in C4 to be =MAX(A26:A134)
1.42995
1.43
1.43004
1.42969
NA
1.42999
1.43022
NA
1.43058
1.43058
NA
1.43058
1.43053
1.43058
1.43091
1.43107
1.43141
NA
NA
1.43151
1.4315
1.43146
1.43136
1.43156
1.43144
1.43128
1.43119
1.43103
1.43094
1.43124
1.43149
1.43172
1.43234
1.43222
NA
1.43228
1.43233
1.43214
1.43207
NA
NA
1.43204
1.43213
NA
NA
1.43246
1.43262
1.43319
1.43345
1.43344
1.4333
1.4331
1.43288
1.43241
1.43221
1.43235
1.43232
1.43227
1.43219
1.43225
1.43267
1.43284
1.4328
1.4328
1.43325
1.43304
1.43281
1.43282
1.43287
1.43307
1.433
1.43274
1.43284
1.43286
1.43273
1.43279
1.43293
NA
1.43298
1.43258
1.43259
1.43214
1.43227
1.43229
1.43221
1.43217
1.43218
1.43219
NA
1.43234
1.43239
1.43237
1.43252
1.43274
1.43304
1.43304
1.4328
1.4329
1.43274
1.43254
1.43267
1.43264
1.43274
1.4326
1.43274
1.43274
1.43216
1.43199
1.43173
1.43175
1.43166
1.43159
1.43164
1.43154
1.43076
1.43096
1.43097
1.43079
1.43095
1.43094
1.43058
1.42968
1.43016
1.43059
1.43016
Spreadsheet: 476849d1472046932-sorting-addresses-example
Sheet: Sheet1

Name | Address | Subscribe
Person 1 | 860 north 200 west | Yes
Person 2 | 865 north 200 west | No
Person 3 | 840 north 200 west | Yes
Person 4 | 845 north 200 west | Yes
Person 5 | 860 north 300 west | No
Person 6 | 835 north 200 west | No
Person 7 | 865 north 300 west | No
Person 8 | 850 north 300 west | Yes
Person 9 | 855 north 200 west | Yes
Person 10 | 845 north 300 west | Yes
Person 11 | 840 north 300 west | No
Person 12 | 855 north 300 west | Yes
Person 13 | 835 north 300 west | No
Person 14 | 850 north 200 west | Yes
Spreadsheet: 142038d1329594641-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: Byron Nelson

 |  | WEEK 7 HP Byron Nelson
 |  | Total Earnings |  |  |  | Rankings Through Week 7 | Total
 | [NAME] | 0 |  | 2 |  | [NAME]
 | [NAME] | 5000 |  | 1 |  | [NAME]
 | [NAME] | 0 |  | 3 |  | [NAME]
 |  | 0 |  | 4 |  | 0
 |  | 0 |  | 5 |  | 0
 |  | 0 |  | 6 |  | 0
 |  | 0 |  | 7 |  | 0
 |  | 0 |  | 8 |  | 0
 |  | 0 |  | 9 |  | 0
 |  | 0 |  | 10 |  | 0
 |  | 0 |  | 11 |  | 0
 |  | 0 |  | 12 |  | 0
 |  | 0 |  | 13 |  | 0
 |  | [NAME] |  | YTD
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
Spreadsheet: 863048d1710606784-how-can-i-cut-last-two-words-from-each-line-to-move-to-another-cel-separate-postcode
Sheet: Postcode

Name | Fulladdress | Postcode | Municipality
Zac Leesing Construction | 11 Bellwood Grange, [NAME], Lincoln LN3 4JD |  | [NAME]
[NAME] | 260 Conway Rd, Newport NP19 8JU |  | Newport
Zak Construction Ltd | Twenty Pence Rd, Wilburton, [NAME] |  | Wilburton
Zeen Construction Ltd | 30 Wilberforce Rd, Peterborough PEI 3JE |  | Peterborough
Zing Construction Ltd | 12 Mezzanine Floor Royal Liver Building, Suit, 10 pier Head - Seacombe, Liverpool L3 1H |  | 10 [NAME]
Zodiac Construction | 96-98 Derby Rd, Nottingham NG1 5FB |  | [NAME]
Zone Homes Ltd | 16 Standbridge Garth, Crigglestone, [NAME] |  | Crigglestone
Spreadsheet: 839989d1692347451-assorting-text-into-a-vertical-string-sample-4_2
Sheet: Sheet1

 | Room
 | WF328 |  |  | Data-->Text to Column-->Delimited-->Next-->Space-->Finish
 | WF214 |  |  | [NAME] in right-->Paste transpose Cell B3
 | TF268
 | TF254
 | WF325
 | TF305
 | WG203
 | TF322
 | TF250
 | TF213
 | WF222
 | [NAME]
 | WS134
 | TG270
 | TG128
 | TF330
 | TF301
 | WF209
 | WS316
 | TF336
 | WS213
 | WS215
 | WS206
 | TF208
Spreadsheet: 798876d1664795135-pasting-dates-do-not-change-bookings-at
Sheet: Availability

 | Theatre Planning | Booked Seats | Available Seats
 | 2022-11-01 00:00:00
 | 2022-11-02 00:00:00
 | 2022-11-03 00:00:00
 | 2022-11-04 00:00:00
 | 2022-11-05 00:00:00
 | 2022-11-06 00:00:00
 | 2022-11-07 00:00:00
 | 2022-11-08 00:00:00
 | 2022-11-09 00:00:00
 | 2022-11-10 00:00:00
 | 2022-11-11 00:00:00
 | 2022-11-12 00:00:00
 | 2022-11-13 00:00:00
 | 2022-11-14 00:00:00
 | 2022-11-15 00:00:00
 | 2022-11-16 00:00:00
 | 2022-11-17 00:00:00
 | 2022-11-18 00:00:00
 | 2022-11-19 00:00:00
 | 2022-11-20 00:00:00
 | 2022-11-21 00:00:00
 | 2022-11-22 00:00:00
 | 2022-11-23 00:00:00
 | 2022-11-24 00:00:00
 | 2022-11-25 00:00:00
 | 2022-11-26 00:00:00
 | 2022-11-27 00:00:00
 | 2022-11-28 00:00:00
 | 2022-11-29 00:00:00
 | 2022-11-30 00:00:00
 | 2022-12-01 00:00:00
 | 2022-12-02 00:00:00
 | 2022-12-03 00:00:00
 | 2022-12-04 00:00:00
 | 2022-12-05 00:00:00
 | 2022-12-06 00:00:00
 | 2022-12-07 00:00:00
 | 2022-12-08 00:00:00
 | 2022-12-09 00:00:00
 | 2022-12-10 00:00:00
 | 2022-12-11 00:00:00
 | 2022-12-12 00:00:00
 | 2022-12-13 00:00:00
 | 2022-12-14 00:00:00
 | 2022-12-15 00:00:00
 | 2022-12-16 00:00:00
 | 2022-12-17 00:00:00
 | 2022-12-18 00:00:00
 | 2022-12-19 00:00:00
 | 2022-12-20 00:00:00
 | 2022-12-21 00:00:00
 | 2022-12-22 00:00:00
 | 2022-12-23 00:00:00
 | 2022-12-24 00:00:00
 | 2022-12-25 00:00:00
 | 2022-12-26 00:00:00
 | 2022-12-27 00:00:00
 | 2022-12-28 00:00:00
 | 2022-12-29 00:00:00
 | 2022-12-30 00:00:00
 | 2022-12-31 00:00:00
Spreadsheet: 819016d1677175470-lookup-based-upon-range-book1
Sheet: Sheet1

Member | Start | END | Answer |  |  |  | EFFDT | DATAVALUE
123456 | 20220601 | 20221030 |  |  |  |  | 20221101 | R-PA003 |  | <--Lookup table
123456 | 20221101 | 20221231 |  |  |  |  | 20220101 | R-PA004
 |  |  |  |  |  |  | 20210101 | R-PA004
Spreadsheet: 700306d1603122431-count-consecutive-cells-in-reverse-above-value-test2
Sheet: general

Last First M | ID | Grade | Local ID | Instructional Setting | Ethnic Code | Year Entered | Program | PC | 8/31 | 9/7 | 9/14 | 9/21 | 9/28 | 10/5 | 10/12 | 10/19 | 10/26 | TOT
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
Spreadsheet: sally_beck__35451__EBS-Developed-Software
Sheet: Summary

 | EBS IT Production [NAME]
 | Summary Headcount 2002 - Estimated
 |  |  | MAINTENANCE | FUTURE DEVELOPMENT
 | S Y S T E M | Primary Function | ONLY | Per User Request | TOTAL
 | Trading / Front Office
 | EnFiber - Core System | Trading / Risk Management / Scheduling | 5 | 5
 | EnFiber - FACT | Deal Confirmation | 1 | 1
 | EnFiber - Real Estate | Trading | 2 | 1
 | Settlements & Tactical Systems
 | Saber | Trading Settlements | 3 | 4
 | Real Estate Billing | Tactical Settlements | 1 | 0
 | Voice Minutes | Trading & Settlements (Tactical) | 3 | 3
 | Network Operations
 | PPCS / TRP | Pooling Point Control System | 4 | 4
 | ECOMS | Circuit Provisioning | 1 | 1
 | NETS | Asset Tracking | 3 | 5
 | Remedy | Change Management & Network Problem Tracking | 2 | 2
 | Livelink | Document Management | 1 | 2
 | Global Data
 | Global Counterparty + Common Codes | Common Data | 1 | 0
 | EBS Facility | Common Data | 0.4 | 0.6
 | EBS Contract | Common Data | 0.6 | 1.4
 | Data Architecture
 | Database Management |  | 4 | 0
Spreadsheet: 828913d1683792696-add-cells-in-a-row-that-match-condition-in-an-adjacent-cell-book1
Sheet: info

 |  | SIZE
 | A2 | A3 | A4 | Task One Count | Task One Size | Task Two Count | Task Two Size | Task Three Count | Task Three Size | Task Four Count | Task Four Size | Task Five Count | Task Five Size | Task Six Count | Task Six Size | Task Seven Count | Task Seven Size | Task Eight Count | Task Eight Size | Task Nine Count | Task Nine Size | Task Ten Count | Task Ten Size | Task Eleven Count | Task Eleven Size | Task Twelve Count | Task Twelve Size | Task Thirteen Count | Task Thirteen Size | Task Fourteen Count | Task Fourteen Size | Task Fifteen Count | Task Fifteen Size
SUM |  |  |  | 12 | A2 | 138 | A4 | 14 | A2 | 142 | A3 | 32 | A2 | 88 | A3 | 27 | A4 | 25 | A3 | 66 | A4 | 18 | A3 | 44 | A3 | 33 | A4 | 16 | A3 | 25 | A4 | 26 | A2
Spreadsheet: darrell_schoolcraft__7644__OutageRequest for 403 022802
Sheet: Sheet1

Enron Transportation Services
System Outage Request/Notification
 |  |  |  |  |  | Submittal Date: ____ | 2002-01-11 00:00:00
 |  |  |  | Planned: X |  | Late: | Unplanned:
 | Region/Location: |  | [NAME]
 | Reported By: |  | [NAME] |  |  |  |  | New: | x | Revised
 | Telephone No: |  | [PHONE] or 3038 |  |  | If a Revision Enter outage ID#
 |  |  |  |  |  | or the Original Est. Start Date
 | FAX No: |  | [PHONE]
 | Starting Date: |  | 2002-02-28 00:00:00 | Time: | 16:00 | Completion Date: |  | 2002-03-01 00:00:00 | Time: | 16:00
 | Descripition of Work: |  |  | Shut unit 403 down to perform bearing and power cylinder inspection.
 | Facilities Affected
 | Compressor Station: |  | Station 4 ([NAME]) |  |  |  |  | Estimated Volume: |  | 250 to400 mcf
 |  | Units: |  |  |  |  |  | Horse Power: |  | 4000 hp
 | Services Affected
 | Mainline: |  | na |  |  |  |  | Aprox. [NAME]: |  | na
 | Branchline/Transmission: |  | na |  |  |  | Reduced Operation Pressure: |  |  | na
 |  | TBS: |  |  |  |  |  | Farmtap: |  | na
 | Comments: |  | This outage is in preparation for our April outage.
 | All Outages Fax Or E:mail To   ([NAME]) |  |  |  | fax# (713)-345-3478   Houston
 | Facility Planning               (Outage Coordinator) |  |  |  |  | fax# (402)-3987041     Omaha
 | For Unplanned Outages Add these Burst FAX Numbers ( Project Link):
 | ( For unplanned outages in the [NAME], Liberal, Mullinville & Amarillo Regions Only)
 | Oneok - Tulsa |  | [NAME] |  |  | (918) 732-1355 |  | ET&S Gas Control (Houston): |  |  | 7138539155
 | Oneok - Bushton |  | [NAME] |  |  | (316) 562-4373 |  | ET&S [NAME]: |  |  | 7136468000
 | Exxon-Mobil-Liberal |  | Ulysses |  |  | (316) 356-7580
 |  |  |  |  |  |  |  | Anadarko: |  |  | 3166294505
 | OXY-Liberal |  | [NAME] |  |  | (316) 624-7014
 | ETS - Liberal Operatons |  |  |  |  | (316) 626-2251