tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1f437508-920c-487b-9623-080fa8f53b53
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13
 |  |  |  |  |  |  | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 2.838 | 2.761 | 2.995 | 3.135 | 3.636 | 2.689 | 2.699
Harvested | 2.821 | 2.748 | 2.976 | 3.103 | 3.615 | 2.617 | 2.678
 |  |  |  | Pounds per harvested acre
Yield | 6898 | 7219 | 6846 | 7085 | 6725 | 7067 | 7449
 |  |  |  | Million cwt
Beginning stocks | 42.992 | 39.315 | 29.492 | 30.419 | 36.499 | 48.467 | 41.07900000000001
Production | 194.585 | 198.388 | 203.733 | 219.85 | 243.104 | 184.941 | 199.479
Imports | 20.581 | 23.9 | 19.218 | 19.019 | 18.336 | 19.361 | 21
Total supply | 258.158 | 261.603 | 252.443 | 269.288 | 297.939 | 252.769 | 261.558
Food, industrial,
& residual 3/ | 124.671 | 123.152 | 123.77 | 120.012 | 133.191 | 96.987
Seed | 3.408 | 3.697 | 3.87 | 4.488 | 3.324 | 3.332
Total domestic use | 128.079 | 126.849 | 127.64 | 124.5 | 136.515 | 110.102 | 125
Exports | 90.764 | 105.262 | 94.384 | 108.304 | 112.959 | 101.588 | 106
Rough | 32.112 | 37.663 | 31.633 | 40.351 | 35.146 | 32.72 | 34
Milled 4/ | 58.652 | 67.599 | 62.751 | 67.953 | 77.813 | 68.868 | 72
Total use | 218.843 | 232.111 | 222.024 | 232.793 | 249.474 | 211.69 | 231
Ending stocks | 39.315 | 29.492 | 30.419 | 36.499 | 48.46700000000004 | 41.07900000000001 | 30.55799999999999
 |  |  |  | Percent
Stocks-to-use ratio | 17.96493376530206 | 12.70598980660115 | 13.70077108781033 | 15.67873604446869 | 19.42767582994622 | 19.40526241201758 | 13.22857142857143
 |  |  |  | $/cwt
Average farm |  |  |  |  |  |  | 14.60 to
price 5/ | 9.96 | 12.8 | 16.8 | 14.4 | 12.7 | 14.5 | 15.2
 |  |  |  | Percent
Average
milling rate | 71 | 69.88 | 70.83 | 71.53 | 68.86 | 69.93 | 70.25
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated February 8, 2013.
Spreadsheet: 171528d1343758733-vba-code-not-working-with-protected-sheets-colours2
Sheet: Sheet1

 |  |  |  |  | -
 |  | Surname | Forename | N |  |  |  | R |  |  |  | Y1 |  |  |  | Y2 |  |  |  | Y3 |  |  |  | Y4 |  |  |  | Y5 |  |  |  | Y6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KEY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | red
 |  |  |  |  |  |  |  |  | r | r |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | orange
 |  |  |  |  | r |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G | green
 |  |  |  |  | R |  |  |  | r |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P | purple
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PI | pink
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | yellow
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BL | blue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GR | grey
Spreadsheet: 859193d1707660159-offseting-countif-dynamic-range-book1
Sheet: Sheet1

Win
Win
Win
Loss
Win |  |  | Win
Win |  |  | Lose
Loss
Loss
Loss
Loss
Loss
Loss
Loss
Loss
Loss
Win
Win
Spreadsheet: 877113d1723792560-find-a-specific-text-for-each-day-with-a-hyperlink-hyperlinks
Sheet: Plan1

Date | Value 1 | Value 2 |  | Obs:
01/08/2024 | -161757.38 | 161757.38 | 0
02/08/2024 | -114660.51 | 114660.51 | 0
05/08/2024 | -360862.72 | 359470.72 | -1392.000000000058
06/08/2024 | -34529 | 34529 | 0
07/08/2024 | -666121 | 666121.0000000001 | 0
08/08/2024 | -387346.42 | 387346.42 | 0
09/08/2024 | -149895.95 | 149526.35 | -369.6000000000058
12/08/2024 | -877737.9800000001 | 877735.9100000003 | -2.069999999832362
13/08/2024 | -73300.59 | 73300.59000000001 | 0
O erro está em 1 dos 2 ao lado
Incluir E-CPF Alessandro na planilha (Aguardando se encaminharam NF ou se faremos como Mov.Bancário)
[NAME]
RH verificando dif. De 0,27 ¢
Spreadsheet: 713007d1610525225-formula-to-calculate-available-stock-items-stock-control
Sheet: PURCHASING FORM

 |  | PURCHASING FORM
ITEM NO | ITEM NAME | MAKE | [NAME] | AVAILABLE | ORDER DATE | VENDOR | QUANITTY OF STOCK ORDERED | QUANITTY OF ORDERED STOCK RETURNED | AVAILABLE
1 |  |  |  |  |  |  | 3 | 1
1 |  |  |  |  |  |  | 2 | 1
2 |  |  |  |  |  |  | 5 | 1
2 |  |  |  |  |  |  | 8 | 2
3 |  |  |  |  |  |  | 4 | 3
3 |  |  |  |  |  |  | 3 | 1
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: SWGasTrans

 | SW Gas Transmission Co - contr27380
 | POI 78003 - TW/SGTC Mojave Del
Day | Measured | Scheduled
1 | -13559 | -14000
2 | -13675 | -14000
3 | -13732 | -14000
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
30
31
2001-12-31 00:00:00 |  |  | -17240
2001-01-03 00:00:00
CBS Volume
 |  |  | 5329
Spreadsheet: jeff_dasovich__14234__Vons Model
Sheet: EPS Accretion

 | Appendix 10
 | Earnings Per Share Accretion Analysis
 | WITHOUT STOCK REPURCHASE
 |  |  |  | -net income
 |  |  |  | -shares
 |  |  |  | -earnings per share
 |  |  |  | -net income
 |  |  |  | -cost savings & synergies, after tax
 |  |  |  | -total contribution of Vons
 |  |  |  | -new shares issued
 | Goodwill amortization |  |  | -net income
 | Equity in undist inc. of seller |  |  | -net income
 |  |  |  | -net income
 |  |  |  | -shares
 |  |  |  | -earnings per share
 |  |  |  | -EPS, post-transaction
 |  |  |  | -EPS, pre-transaction
 |  |  |  | -EPS accretion (dilution)
 | WITH STOCK REPURCHASE
 |  |  |  | -net income
 |  |  |  | -shares
 |  |  |  | -earnings per share
 |  |  |  | -net income
 |  |  |  | -cost savings & synergies, after tax
 |  |  |  | -total contribution of Vons
 |  |  |  | -new shares issued
 | Goodwill amortization |  |  | -net income
 | Equity in undist inc. of seller |  |  | -net income
 | Impact of buyback:
 | number of shares repurchased |  |  | -shares repurchased
 | cost of funds for repurchase |  |  | -net income
 |  |  |  | -net income
 |  |  |  | -shares
 |  |  |  | -earnings per share
 |  |  |  | -EPS, post-transaction
 |  |  |  | -EPS, pre-transaction
 |  |  |  | -EPS accretion (dilution)
Spreadsheet: 684676d1593497250-network-days-not-allocating-hours-equally-weeklyallocation
Sheet: Weekly Hours

Weekly Hours
Purpose |  | To allocate the amount of each item based on a daily amount and the number of dates in each column.
Week Start |  | 2020-06-01 00:00:00
Allocation
 |  |  |  |  |  |  | Week beginning:
 | Employee | Hrs per Day | Start | End |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | A | 1 | 2020-06-02 00:00:00 | 2020-08-14 00:00:00
 | B | 1 | 2020-06-07 00:00:00 | 2020-09-14 00:00:00
 | C | 1 | 2020-06-02 00:00:00 | 2020-08-14 00:00:00
 | D | 1 | 2020-06-02 00:00:00 | 2020-08-14 00:00:00
 | Total
Spreadsheet: bed3d3a6-2353-4de4-ad45-cda6fe60f5e4
Sheet: ADA Region 2010-2011

Region | 2010-2011 Regional Average Daily Attenance (ADA)
01 | 375976.307
02 | 96218.42400000001
03 | 48595.59600000001
04 | 1005439.121
05 | 73910.913
06 | 159572.644
07 | 156718.76
08 | 52273.02800000001
09 | 35635.81800000001
10 | 698384.894
11 | 504120.3490000001
12 | 143631.52
13 | 350905.468
14 | 47224.444
15 | 44350.82900000001
16 | 76980.213
17 | 74712.418
18 | 71547.52300000002
19 | 168406.718
20 | 370879.5130000002
Spreadsheet: 166978d1341857157-fill-cell-value-based-on-value-from-another-sheet-ty0281-oeldere-
Sheet: Client No List

Client Name | Client No.
Client1 | 1709
ABC Client | 3885
DEF Client | 4635
Alpha | 4975
Bravo | 3132
[NAME] | 3981
Delta | 1673
Echo | 4246
Foxtrot | 4021
Golf | 4021
Hotel | 4607
India | 2592
[NAME] | 5000
Kilo | 3899
Lima | 1299
[NAME] | 2966
November | 2039
[NAME] | 4973
Papa | 4973
Quebec | 3900
Romeo | 3305
Sierra | 1675
Tango | 4526
Uniform | 4065
Victor | 3761
Whiskey | 4925
[NAME] | 4925
Zulu | 2112
Spreadsheet: 455532d1460386102-duplicates-search-column-a-with-differnce-coloumn-b-example-1_etaf
Sheet: Sheet1

Food | Mixed or Single | Both [NAME] and Single
apples | M | N
apples | M | N
apples | M | N
pears | M | Y
pears | M | Y
pears | S | Y
pears | M | Y
pears | M | Y
grapes | S | N
plums | M | N
plums | M | N
plums | M | N
plums | M | N
eggs | S | Y
eggs | M | Y
eggs | M | Y
bread | M | N
oranges | M | Y
oranges | M | Y
oranges | S | Y
oranges | S | Y
fish | M | N
fish | M | N
Spreadsheet: 75165d1275680025-create-macro-to-do-vlookup-mstr-data-x-ref-exmpl
Sheet: DP 2813 - Master Data Cros

DP 2813 - Master Data Cross Reference Report
Demand Planner |  | Forecast Group 1 |  | Old Material Number | Profit Center Business Sub 1 |  | Profit Center |  | APO Product |  | Material |  | Forecasted In DP | Wholesale Price of a Wholesale Unit | Wholesale Price of a Retail Unit | Wholesale Pack In
317 | example | 190598002 | example | 0003JTD032K | PCG00311 | Example | P00554 | Example | 7000001990 | PCG00309_PCG00311_EFH_D_TIS1_SNP0015_5 | 389921 | Example | N | 0 | 0.01 | 16
317 | example | 190598003 | example | 0003JTX315N | PCG00311 | Example | P00554 | Example | 7000001990 | PCG00309_PCG00311_EFH_D_TIS1_SNP0015_5 | 390053 | Example | N | 0 | 0.01 | 16
317 | example | 190598004 | example | 0003JTX316N | PCG00311 | Example | P00554 | Example | 7000001990 | PCG00309_PCG00311_EFH_D_TIS1_SNP0015_5 | 390055 | Example | N | 0 | 0.01 | 16
317 | example | 190598006 | example | 0003JTX318N | PCG00311 | Example | P00554 | Example | 7000001990 | PCG00309_PCG00311_EFH_D_TIS1_SNP0015_5 | 390059 | Example | N | 0 | 0.01 | 16
42 | example | 190161000 | example | 0003KHB022G | PCG00311 | Example | P00554 | Example | 7000001921 | PCG00309_PCG00311_EFH_D_BAG1_SNP0012_5 | 132285 | Example | N | 0 | 0.01 | 8
42 | example | 190163000 | example | 0003KHB049Q | PCG00311 | Example | P00554 | Example | 7000001921 | PCG00309_PCG00311_EFH_D_BAG1_SNP0012_5 | 132296 | Example | N | 0 | 0.01 | 8
42 | example | 190593002 | example | 0003KHB055Q | PCG00311 | Example | P00554 | Example | 7000001921 | PCG00309_PCG00311_EFH_D_BAG1_SNP0012_5 | 132302 | Example | N | 0 | 0.01 | 8
42 | example | 190593000 | example | 0003KHB056Q | PCG00311 | Example | P00554 | Example | 7000001921 | PCG00309_PCG00311_EFH_D_BAG1_SNP0012_5 | 132303 | Example | N | 0 | 0.01 | 8
42 | example | 190162000 | example | 0003KHB096H | PCG00311 | Example | P00554 | Example | 7000001921 | PCG00309_PCG00311_EFH_D_BAG1_SNP0012_5 | 132320 | Example | N | 0 | 0.01 | 8
42 | example | 190162002 | example | 0003KHB097H | PCG00311 | Example | P00554 | Example | 7000001921 | PCG00309_PCG00311_EFH_D_BAG1_SNP0012_5 | 132321 | Example | N | 0 | 0.01 | 8
Spreadsheet: 706313d1606617606-looking-for-a-formula-to-list-staff-names-from-shift-paterns-to-days-working-roster_template_demo
Sheet: Operator Shifts

Mon to Fri | Tue to Sat | Wed to Sun | Thur to Mon | Fri to Tue | Sat to Wed | Sun to Thur |  |  |  | Working Monday | Working Tuesday | Working Wednesday | Working Thursday | Working Friday | Working Saturday | Working Sunday
a | d | f | h | k | r | z |  |  |  | a | a | a | a | a
b | e | g | i | l | s | aa |  |  |  | b | b | b | b | b
c |  |  | j | m | t | ab |  |  |  | c | c | c | c | c
 |  |  |  | n | u | ac |  |  |  | h
 |  |  |  | o | v | ad |  |  |  | i
 |  |  |  | p | w | ae |  |  |  | j
 |  |  |  | q | x |  |  |  |  | k
 |  |  |  |  | y |  |  |  |  | l
 |  |  |  |  |  |  |  |  |  | m
 |  |  |  |  |  |  |  |  |  | n
 |  |  |  |  |  |  |  |  |  | o
 |  |  |  |  |  |  |  |  |  | p
 |  |  |  |  |  |  |  |  |  | q
 |  |  |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  | t
 |  |  |  |  |  |  |  |  |  | u
 |  |  |  |  |  |  |  |  |  | v
 |  |  |  |  |  |  |  |  |  | w
 |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  | y
 |  |  |  |  |  |  |  |  |  | z
 |  |  |  |  |  |  |  |  |  | aa
 |  |  |  |  |  |  |  |  |  | ab
 |  |  |  |  |  |  |  |  |  | ac
 |  |  |  |  |  |  |  |  |  | ad
 |  |  |  |  |  |  |  |  |  | ae
Spreadsheet: 92330d1291917571-making-a-report-based-upon-other-information-pjcruiser-sample
Sheet: Sheet1

337 |  | 2010-11-14 00:00:00 | 4 | 0 | 4 | C | 20 | 3-1 | 20 3-1 | Right | 2011-01-17 00:00:00 | 25 | Y
338 |  | 2010-12-07 00:00:00 | 3 | 0 | 3 | D | 19 | 2-3 | 19 2-3 | Left | 2011-02-09 00:00:00 | 2 | Y
339 |  | 2010-10-31 00:00:00 | 5 | 0 | 5 | D | 16 | 3-3 | 16 3-3 | Right | 2011-01-03 00:00:00 | 39 | Y
340 |  | 2010-10-26 00:00:00 | 4 | 0 | 4 | C | 16 | 4-2 | 16 4-2 | Right | 2010-12-29 00:00:00 | 44 | Y
341
342 |  | 2010-10-31 00:00:00 | 4 | 0 | 4 | D | 15 | 3-4 | 15 3-4 | Right | 2011-01-03 00:00:00 | 39 | Y
343 |  | 2010-10-10 00:00:00 | 3 | 0 | 3 | C | 15 | 1-3 | 15 1-3 | Right | 2010-12-13 00:00:00 | 60 | Y
344 |  | 2010-08-27 00:00:00 | 4 | 0 | 4 | C | 14 | 2-6 | 14 2-6 | Right | 2010-10-30 00:00:00 | 104 | Y
345 |  | 2010-11-03 00:00:00 | 4 | 0 | 4 | D | 17 | 3-6 | 17 3-6 | Right | 2011-01-06 00:00:00 | 36 | Y
346 |  |  | 3 | 0 | 3 | A |  |  |  | Right |  |  | Y | [NAME] May 17 2010
347 |  | 2010-11-05 00:00:00 | 5 | 0 | 5 | D | 16 | 2-1 | 16 2-1 | Right | 2011-01-08 00:00:00 | 34 | Y
348 |  | 2010-11-19 00:00:00 | 3 | 1 | 4 | D | 16 | 2-1 | 16 2-1 | Left | 2011-01-22 00:00:00 | 20 | Y
349 |  |  |  |  |  |  |  |  |  |  |  |  | Y | [NAME]
350 |  | 2010-07-09 00:00:00 | 4 | 0 | 4 | B | 22 | 4-3 | 22 4-3 | Both | 2010-09-11 00:00:00 | 153 | Y
351 |  | 2010-11-12 00:00:00 | 3 | 0 | 3 | D | 16 | 3-5 | 16 3-5 | Both | 2011-01-15 00:00:00 | 27 | Y
352 |  | 2010-11-12 00:00:00 | 4 | 1 | 5 | C | 21 | 1-3 | 21 1-3 | Right | 2011-01-15 00:00:00 | 27 | Y
353 |  | 2010-04-16 00:00:00 | 6 | 0 | 6 | A | 20 | 4-6 | 20 4-6 | Right | 2010-06-19 00:00:00 | 237 | Y
354 |  | 2010-10-06 00:00:00 | 3 | 0 | 3 | C | 17 | 3-4 | 17 3-4 | Left | 2010-12-09 00:00:00 | 64 | Y
355
356 |  | 2010-11-05 00:00:00 | 3 | 0 | 3 | D | 16 | 2-5 | 16 2-5 | Right | 2011-01-08 00:00:00 | 34 | Y
357 |  | 2010-11-12 00:00:00 | 3 | 0 | 3 | D | 23 | 4-6 | 23 4-6 | Both | 2011-01-15 00:00:00 | 27 | Y
358 |  | 2010-08-31 00:00:00 | 6 | 0 | 6 | C | 13 | 2-2 | 13 2-2 | Left | 2010-11-03 00:00:00 | 100 | Y
359 |  | 2010-04-18 00:00:00 | 4 | 0 | 4 | A | 19 | 3-6 | 19 3-6 | Both | 2010-06-21 00:00:00 | 235 | Y
360 |  | 2010-10-08 00:00:00 | 3 | 0 | 3 | C | 21 | 3-2 | 21 3-2 | Right | 2010-12-11 00:00:00 | 62 | Y
361 |  | 2010-12-03 00:00:00 | 4 | 0 | 4 | D | 21 | 2-1 | 21 2-1 | Both | 2011-02-05 00:00:00 | 6 | Y | Great
362 |  | 2010-04-18 00:00:00 | 5 | 0 | 5 | A | 20 | 4-4 | 20 4-4 | Left | 2010-06-21 00:00:00 | 235 | Y
363 |  | 2010-11-12 00:00:00 | 4 | 0 | 4 | D | 20 | 2-1 | 20 2-1 | Left | 2011-01-15 00:00:00 | 27 | Y
Spreadsheet: 44739d1243507391-too-many-arguments-error-help-need-to-clean-up-formula-calendartest
Sheet: Booking Sheet

Name | First Name | Surname | [NAME] | Home/Work Phone | phone | Adults | Children | Breakfast | [NAME] | Departure | Nights | Estimated Cost | Discount % | Surcharge/Discount $ | Total Price | Breakfast | Linen | [NAME] |  | Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contact [NAME]
Spreadsheet: 103838d1301512952-excel-2007-trying-to-reffrence-a-cell-to-put-in-a-formula-book7
Sheet: Sheet1

1 | 75 | 65 | 0.8666666666666667
2 | 100 | 110 | 1.1
3 | 75 | 85 | 1.133333333333333
4 | 75 | 70 | 0.9333333333333333
5 | 100 | 85 | 0.85 |  | <= I woant to be able to insert an equation using the =min d1 to d5
 |  |  |  |  | and have that cell refrence the cell in colum C.  Like rigt now the equation would
 |  |  |  |  | use 85 in it's equation not .85.
 |  |  |  |  | This spread sheet is going to have multiple sections using that refrence if it is possible.
 |  |  |  |  | I am trying to make it to where I put in my values in colum C and the formulas will take care of the rest.
Spreadsheet: 101967d1300039548-problem-with-function-when-cutting-the-cell-content-and-then-pasting-to-another-cell-problem
Sheet: 1

podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
podatak 1 | podatak 2 | podatak 3 | podatak 4
Spreadsheet: benjamin_rogers__1129__R2BS
Sheet: Peakers

Round II Bidding Summary
[NAME] |  |  |  | Lincon Energy Center |  |  |  | Wheatland |  |  |  | Peaker Total
Bidder | Bid | $/kw |  | Bidder | Bid | $/kw |  | Bidder | Bid | $/kw |  | Bidder | Bid | $/kw
Allegheny Energy | 313.1 |  |  | Allegheny Energy | 373.5 |  |  | Allegheny Energy | 280.2 |  |  | Allegheny Energy | 1028
 |  |  |  |  |  |  |  | Cinergy Corp | 274.2 |  |  | PSEG | 835
 |  |  |  |  |  |  |  | DPL Inc | 230 |  |  | Duke Energy | 740
 |  |  |  |  |  |  |  | Aquilla Energy | 151
Spreadsheet: 729533d1619150001-formula-to-count-consecutive-non-zero-values-and-reset-count-after-a-non-zero-value-inventory-fifo-shrink-ans
Sheet: Sheet1

Analysis | 2021-04-22 00:00:00 | 2021-04-23 00:00:00 | 2021-04-24 00:00:00 | 2021-04-25 00:00:00 | 2021-04-26 00:00:00 | 2021-04-27 00:00:00 | 2021-04-28 00:00:00 | 2021-04-29 00:00:00 | 2021-04-30 00:00:00 | 2021-05-01 00:00:00 | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-15 00:00:00 | 2021-05-16 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00
Forecast | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572
Shrink | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86 | 0 | 0 | 0 | 103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expected Shrink
Spreadsheet: 133789d1324620947-count-max-contiguous-blank-cells-help
Sheet: Sheet1

Employee | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | [NAME] contiguos absence days count
A | x |  | x |  |  |  | x | x | x |  |  | 3
B |  |  |  | x | x |  |  |  |  | x | x | 4
C | x | x | x | x |  |  |  | x | x | x | x | 3
D | x |  | x |  | x | x | x |  |  | x | x | 2 |  |  |  |  | 5 | 6 | 0 | 0 | 0 | 10 | 11
 | x: present
 | I would like to count MAX contiguos days which employee was absent (contiguos blank cells) (no VBA)
Spreadsheet: 47884d1247060688-conditional-formatting-for-multiple-rows-testfile1
Sheet: Sheet1

Product | Jan08 | Feb08 | Mar08 | Apr08 | May08 | Jun08 | [NAME] | Aug08 | Sep08 | Oct08 | Nov08 | Dec08 | [NAME] | Feb09 | Mar09 | Apr09 | [NAME] | Jun09 | Average Sales
Test Product 1 | 141556.89 | 135108.49 | 162411.41 | 129964.84 | 131356.7 | 137854.22 | 137242.48 | 135824.63 | 153387.99 | 174055.93 | 104620.77 | 92053.28000000013 | 148887.45 | 116520.71 | 130957.86 | 109097.43 | 100047.99 | 102028.63 | 130165.4277777778
Spreadsheet: 166782d1341804749-tricky-of-sales-issue-sales-by-color-example
Sheet: Sheet1

Current Week: | Jan wk. 4 | SALES BY WEEK | Color A | Color B | Color C | Color D | Color E |  | CYCLE 1 | Color A | Color B | Color C
 | Jan wk. 1 | 1000 |  |  |  |  |  |  | Start Date: | Jan wk. 1 | Jan wk. 1 | Jan wk. 1
 | Jan wk. 2 | 2000 |  |  |  |  |  |  | End Date: |  | March wk. 5 | March wk. 4
 | Jan wk. 3 | 3000 |  |  |  |  |  |  | Continue into next cycle? | Yes | No | No
 | Jan wk. 4 | 4000 |  |  |  |  |  |  | Actual % of Sales: | 0.3 | 0.2 | 0.5
 | Jan wk. 5 | 3500 |  |  |  |  |  |  | Planned % of Sales: | 0.35 | 0.25 | 0.4
 | Feb wk. 1 | 2000
 | Feb wk. 2 | 500 |  |  |  |  |  |  | CYCLE 1 | Color A | Color D | Color E
 | Feb wk. 3 | 10000 |  |  |  |  |  |  | Start Date: |  | April wk. 1 | April wk. 1
 | Feb wk. 4 | 1500 |  |  |  |  |  |  | End Date: | April wk. 2 | April wk. 4 | April wk. 4
 | March wk. 1 | 2000 |  |  |  |  |  |  | Continue into next cycle? | Yes | No | No
 | March wk. 2 | 3500 |  |  |  |  |  |  | Actual % of Sales:
 | March wk. 3 | 4000 |  |  |  |  |  |  | Planned % of Sales: | 0.5 | 0.15 | 0.35
 | March wk. 4 | 8500
 | March wk. 5 | 500
 | April wk. 1 | 500
 | April wk. 2 | 1000
 | April wk. 3 | 1400
 | April wk. 4 | 2000
 |  |  |  |  |  |  |  |  |  |  | Yes
 |  |  |  |  |  |  |  |  |  |  | No
Spreadsheet: 552849d1513799903-make-text-white-depending-on-another-cell-white-text
Sheet: Tegra Dragout

 |  |  | Tegra
 |  |  | Base | 434.96 | No
 |  |  | Shaft | 63.4 | m
 |  |  | Cover | 165.24 | No
 |  |  | Depth | L & P |  | Excavate | C Away | Base | Shaft | Cover | Total
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | 0.5 | 1.5
 |  |  | 0.75 | 1.5
 |  |  | 1 | 1.7
 |  |  | 1.2 | 1.7
 |  |  | 1.5 | 1.9
 |  |  | 1.75 | 1.9
 |  |  | 2 | 2.1
 |  |  | 2.25 | 2.1
 |  |  | 2.5 | 2.3
Spreadsheet: 718575d1613212080-conditional-time-subtraction-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2021-01-03 05:00:00
 | FLY |  | AAA | AAA | 2021-01-03 06:05:00 | 1:35:00 | 2021-01-03 06:08:00 | 2021-01-03 08:00:00
 | FLY |  | DDD | DDD |  | 1:30:00 | 2021-01-03 08:45:00 | 2021-01-03 10:34:00
 | FLY |  | AAA | AAA | 2021-01-03 12:30:00 | 0:55:00 | 2021-01-03 12:36:00 | 2021-01-03 12:47:00
 | FLY |  | CCC | CCC |  | 1:00:00 | 2021-01-03 13:35:00 | 2021-01-03 14:36:00
Spreadsheet: 775233d1648916402-copy-values-from-one-sheet-to-another-sheet-lookup
Sheet: NEW_TOTAL

LAST DATE =
 | STAN CODE1
 | LYNN
 | LYNN CODE1
 | NEW FUND
 | ADVISORY
 | LYNN NEW FUND
 | LYNN CSTM
 | STAN NEW FUND
 | CODE2
 | TOTAL
Spreadsheet: 170075d1343153725-subtotal-function-and-excluding-some-data-datafilternjonlyformean-oeldere-
Sheet: Sheet1

 | 4.96875
Date | Qty | State | 4.96875 | month | 2.67848682406068
2012-04-02 00:00:00 | 10 | NJ | 4.96875 | 4 | 2.67848682406068 |  | [NAME] | Kolomlabels
2012-04-09 00:00:00 | 6 | NJ | 4.96875 | 4 | 2.67848682406068 |  | Rijlabels | NJ | NY | Eindtotaal
2012-04-16 00:00:00 | 8 | NJ | 4.96875 | 4 | 2.67848682406068 |  | 4 | 6.3 |  | 6.3
2012-04-23 00:00:00 | 3.5 | NJ | 4.96875 | 4 | 2.67848682406068 |  | 5 | 6 | 3.15 | 4.575
2012-04-30 00:00:00 | 4 | NJ | 4.96875 | 4 | 2.67848682406068 |  | 6 | 7.35 | 3 | 5.175
2012-05-07 00:00:00 | 5 | NJ | 4.96875 | 5 | 2.67848682406068 |  | 7 | 3 |  | 3
2012-05-14 00:00:00 | 7 | NJ | 4.96875 | 5 | 2.67848682406068 |  | Eindtotaal | 5.600000000000001 | 3.075 | 4.96875
2012-05-21 00:00:00 | 6.3 | NY | 4.96875 | 5 | 2.67848682406068
2012-05-29 00:00:00 | 0 | NY | 4.96875 | 5 | 2.67848682406068
2012-06-04 00:00:00 | 4 | NY | 4.96875 | 6 | 2.67848682406068
2012-06-11 00:00:00 | 2 | NY | 4.96875 | 6 | 2.67848682406068
2012-06-18 00:00:00 | 6 | NJ | 4.96875 | 6 | 2.67848682406068
2012-06-25 00:00:00 | 8.7 | NJ | 4.96875 | 6 | 2.67848682406068
2012-07-02 00:00:00 | 4 | NJ | 4.96875 | 7 | 2.67848682406068
2012-07-09 00:00:00 | 3 | NJ | 4.96875 | 7 | 2.67848682406068
2012-07-16 00:00:00 | 2 | NJ | 4.96875 | 7 | 2.67848682406068