tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 727768d1618082394-withdrawal-balance-spreadsheet-need-help-with-formula-test
Sheet: TEST

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Initial withdrawal of $20,000 when the balance reaches over $30,000 and second withdrawal will be done again within 7 days of previous withdrawal with similar criteria.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third withdrawal has to be done after 7 days of 2nd withdrawal (given that first withdrawal was done within 7 days of second withdrawal)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Starting 3rd withdrawal - minimum balance to remain in the bank is $10,000 and rest can be withdrawn. 4th withdrawal to be made after the balance reaches over $30,000 and the withdrawal amount will be $20,000.
 |  |  |  |  | Date | Starting Balance | Bet Amount | Winning | Result | Balance |  |  | Bet | Win | 30000 | Withdrawal | Balance
Starting Balance | 1500.7 |  |  |  |  |  |  | 1513.65 | W
Starting Date | 2021-04-05 00:00:00 |  |  |  |  |  |  | 1807.36 | W
Current Balance |  |  |  |  |  |  | 538.55 |  | W
Goal
[NAME]
Level 1 | 1000
Level 2 | 2000
Level 3 | 3000
Level 4 | 4000
Level 5 | 5000
Level 6 | 7500
Level 7 | 10000
Level 8 | 15000
Level 9 | 20000
Level 10 | 25000
Level 11 | 30000
Level 12 | 35000
Level 13 | 40000
Level 14 | 45000
Level 15 | 50000
Level 16 | 60000
Level 17 | 70000
Level 18 | 80000
Level 19 | 90000
Level 20 | 100000
Level 21 | 125000
Level 22 | 150000
Level 23 | 200000
Level 24 | 250000
Level 25 | 300000
Level 26 | 350000
Level 27 | 400000
Level 28 | 450000
Level 29 | 500000
Level 30 | 550000
Level 31 | 600000
Level 32 | 700000
Level 33 | 800000
Level 34 | 900000
Level 35 | 1000000
Spreadsheet: kimberly_watson__20574__Fuel Hedge Cal 02 Strategy
Sheet: Fuel Cal 02

Target Prices as of August 6, 2001
Volume MMBtu/d | Target Hedge Price - Bullish Market   EP Permian Basis Adjusted Price | Target Hedge Price - Bearish Market   EP Permian Basis Adjusted Price | Hedge Transaction Date | Term of Hedge | Confirmed Hedged Price | Comments
5000 | 5.05 | 5.05 | 2002-01-12 00:00:00 | Cal 2002 | 5.05 | Hedge complete
5000 | 3.5 | 3.25 | 2001-08-10 00:00:00 | Cal 2002 | 3.46 | Hedge complete.  As we evaluate the signals of the market place through technical analysis, we are watching the NYMEX prompt continuation price so that if prompt price closes above $3.355, then we have a good chance to observe more bullish price scenarios.  If NYMEX prompt price closes below $2.6150, then we have a greater chance of pushing into more bearish prices.  Therefore, the prices in blue represent target bullish prices (EP Permian Basis Adjusted) in which we feel comfortable in triggering.  The prices in red represent target bearish prices (EP Permian Basis Adjusted) that we would want to lock-in to protect against a more powerful decline in prices.  Currently, the most bearish NYMEX Cal 02 price estimate is $2.476 which translates to a most bearish Permian Basis Adjusted price of $2.366.
5000 | 3.65 | 3.25 |  |  |  | See comment above
5000 | open | open |  | monthly/seasonally |  | Due to the total amount of fuel overcollection estimated at 21,000 [NAME]/d, it is our recommendation to enter 2002 with this 5,000 [NAME]/d plus any other fuel identified during the year and lay out a monthly/seasonal strategy for hedging.  These target prices will be identified in Nov/Dec 2001.
Average price for 15,000 [NAME]/d | 4 | 3.92 |  |  |  | Cal 02 Perm Strip $3.389 (EP Permian)
Spreadsheet: 82181d1282204456-problem-with-offset-count-formula-query
Sheet: Clubs

Club
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Spreadsheet: 61589d1262526555-two-y-axis-both-using-same-data-series-frost-20iwi-20graphsv1-1-
Sheet: 1- sbm

 | WDR Zone 1 |  | WDR Zone 2 |  | WDR Zone 3 |  | WDR Zone 4
 | Cambridge | London | Grendon Underwood | Wallingford | [NAME] | [NAME] | [NAME] | Rawtenstall
None | 23.15 | 16.5 | 89.36 | 52.45 | 49.81 | 41.84 | 48.68 | 45.82
WF | 79.86 | 68.25 | 109.46 | 83.5 | 94.57 | 79.69 | 69.9 | 92.7
MW | 78.09 | 68.2 | 109.46 | 83.86 | 94.57 | 80.32 | 70.17 | 86.17
EPS | 80.5 | 68.59 | 109.76 | 84.44 | 95.75 | 81.21 | 70.67 | 93.87
PF | 79.73 | 68.97 | 109.82 | 84.22 | 96.56 | 81.48 | 71.73 | 87.33
SBM free water saturation (Wf) |  |  |  | 190 | kg/m3 | 190 is 100%
75% of Wf Fmax |  |  |  | 142.5 | kg/m3
 |  |  | 50 | 95
 |  |  | 25 | 47.5
 |  |  |  |  |  | Wf | 190
 |  |  |  |  |  | 1% of Wf | 1.9
Spreadsheet: 168730d1342551887-help-needed-to-organize-jumbled-data-into-multiple-columns-excelsampleproblem
Sheet: Real Data

712 | Other 7 | S/M BP | Comm | WC | Defend | FT | cart
CT | Grow | S/MBP | Mab | 113 | CPII | PT | PRXX
FRT | CT | Enter | Other 1 | PC | TP | 612 | PRIV
FRT | Grow | Comm | Mab | LBP | 812 | WC | PRXXVI
Spreadsheet: 6283ff44-bf76-4347-b680-3b047179955c
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 6 | 2981 | 2835 | 2552 | 2197
6 - 15 | 4321 | 4572 | 4487 | 4124
15 - 25 | 5251 | 4311 | 4664 | 4835
25 - 40 | 10804 | 10752 | 8840 | 7386
40 - 65 | 26279 | 24730 | 22562 | 20667
65 und mehr | 17246 | 17379 | 18326 | 19030
Insgesamt | 66882 | 64579 | 61431 | 58239
%
unter 6 | 4.457103555515685 | 4.389971972312981 | 4.154254366687828 | 3.772386201686155
6 - 15 | 6.460632158129243 | 7.079700831539665 | 7.304129836727386 | 7.081165541990762
15 - 25 | 7.851140815167011 | 6.675544681707676 | 7.592257980498446 | 8.30199694362884
25 - 40 | 16.15382315122156 | 16.6493751838833 | 14.39012876235126 | 12.68222325245969
40 - 65 | 39.29158817021023 | 38.29418231932981 | 36.72738519639921 | 35.48652964508319
65 und mehr | 25.78571214975629 | 26.91122501122656 | 29.83184385733587 | 32.67569841515136
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 791126d1660163507-conditional-formatting-color-for-one-cells-dates-based-on-another-cells-date-book1
Sheet: Sheet1

Data | Data | Data | Data | Data | Posicheck On | Test Due
Data | Data | Data | Data | Data | 2021-09-03 00:00:00
Data | Data | Data | Data | Data | 2021-09-03 00:00:00
Data | Data | Data | Data | Data | 2021-07-25 00:00:00
Data | Data | Data | Data | Data | 2021-08-17 00:00:00
Spreadsheet: joe_quenet__15073__PJM
Sheet: DJ PJM Electricity Index

 | DATE |  |  |  | Firm On Peak |  | MW |  | [NAME]
 | 2001-10-18 00:00:00 |  |  |  | 26.93 |  | 2600 |  | 41600
 | 2001-10-17 00:00:00 |  |  |  | 25.28 |  | 2750 |  | 44000
 | 2001-10-16 00:00:00 |  |  |  | 26.48 |  | 900 |  | 14400
 | 2001-10-15 00:00:00 |  |  |  | 26.31 |  | 1050 |  | 16800
 | 2001-10-14 00:00:00
 | 2001-10-13 00:00:00
 | 2001-10-12 00:00:00 |  |  |  | 23.51 |  | 2100 |  | 33600
 | 2001-10-11 00:00:00 |  |  |  | 23.98 |  | 1350 |  | 21600
 | 2001-10-10 00:00:00 |  |  |  | 25.31 |  | 1800 |  | 28800
 | 2001-10-09 00:00:00 |  |  |  | 28.25 |  | 1800 |  | 28800
 | 2001-10-08 00:00:00 |  |  |  | 29.17 |  | 3850 |  | 61600
 | 2001-10-07 00:00:00
 | 2001-10-06 00:00:00
 | 2001-10-05 00:00:00 |  |  |  | 28.6 |  | 1950 |  | 31200
 | 2001-10-04 00:00:00 |  |  |  | 28.93 |  | 1350 |  | 21600
 | 2001-10-03 00:00:00 |  |  |  | 27.5 |  | 900 |  | 14400
 | 2001-10-02 00:00:00 |  |  |  | 26.01 |  | 1000 |  | 16000
 | 2001-10-01 00:00:00 |  |  |  | 24.71 |  | 2050 |  | 32800
 | 2001-09-30 00:00:00
 | 2001-09-29 00:00:00
 | 2001-09-28 00:00:00 |  |  |  | 23.73 |  | 3450 |  | 55200
 | 2001-09-27 00:00:00 |  |  |  | 24.58 |  | 3200 |  | 51200
 | 2001-09-26 00:00:00 |  |  |  | 25.14 |  | 3600 |  | 57600
 | 2001-09-25 00:00:00 |  |  |  | 25.91 |  | 3650 |  | 58400
 | 2001-09-24 00:00:00 |  |  |  | 26.97 |  | 5450 |  | 87200
 | 2001-09-23 00:00:00
 | 2001-09-22 00:00:00
 | 2001-09-21 00:00:00 |  |  |  | 25.63 |  | 5300 |  | 84800
 | 2001-09-20 00:00:00 |  |  |  | 26.12 |  | 2600 |  | 41600
 | 2001-09-19 00:00:00 |  |  |  | 26.66 |  | 2600 |  | 41600
Spreadsheet: 221228d1363432129-what-formula-used-to-scale-the-same-code-a-value-on-different-days-scalare-valore
Sheet: Foglio2

Code | color | order | Hours | remaining hours | data
112233 | yellow | 120 | 15 |  | 11:03:13 | E2 <--155-15
100360 | red | 250 | 10 |  | 11:03:13 | E3<--100-10
23444 | green | 132 | 25 |  | 11:03:13 | E4<--200-25
112233 | yellow | 120 | 30 | 110 | 12:03:13 | E6<---140-30=110
100360 | red | 250 | 8 | 82 | 12:03:13 | E7<--90-8=82
23444 | green | 132 | 15 | 160 | 12:03:13 | E8<--175-15=160
100360 | red | 250 | 12 | 70 | 12:03:13 | E10<--82-12=70
Spreadsheet: 681803d1591759960-date-appear-in-cell-only-if-certain-time-met-demobook
Sheet: Sheet1

BLANK | BLANK | BLANK | BLANK | BLANK | Last licenced | 2 Months | [NAME]
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-09-13 11:46:38
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-05-25 11:02:49
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-09 09:02:53
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-07-09 08:09:22
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-06-04 10:30:22
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-22 08:00:04
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-09-02 10:40:29
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-09-02 10:39:24
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-21 12:21:26
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-20 09:26:08
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-08 17:03:20
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-19 10:32:31
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-14 08:35:09
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-03-26 12:04:25
BLANK | BLANK | BLANK | BLANK | BLANK | 2020-01-20 00:00:00
BLANK | BLANK | BLANK | BLANK | BLANK | 2020-01-25 00:00:00
BLANK | BLANK | BLANK | BLANK | BLANK | 2020-02-22 00:00:00
Spreadsheet: 3158724d-efae-4b45-92f6-9a17506f4307
Sheet: Sheet1

Prilog 1. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Razdoblje izvještavanja: |  |  |  | 01.01.2012. |  | do | 30.06.2012.
Tromjesečni financijski izvještaj poduzetnika TFI-POD
Matični broj (MB): |  | 03051773
Matični broj subjekta ([NAME]): |  | 040060543
Osobni identifikacijski broj (OIB): |  | [PHONE]
Tvrtka izdavatelja: |  | LAGUNA NOVIGRAD DD
Poštanski broj i mjesto: |  | 52466 |  |  | NOVIGRAD
Ulica i kućni broj: |  | ŠKVERSKA 8
Adresa e-pošte: |  | [EMAIL]
Internet adresa: |  | www.laguna-novigrad.hr
Šifra i naziv općine/grada: |  | 291 | NOVIGRAD
Šifra i naziv županije: |  | 18 | ISTARSKA |  |  |  | Broj [NAME]: | 316
 |  |  |  |  |  |  | ([NAME])
Konsolidirani izvještaj: |  | NE |  |  |  | Šifra NKD-a: |  | 5510
[NAME] subjekata konsolidacije (prema MSFI): |  |  |  | Sjedište: |  |  | MB:
Knjigovodstveni servis:
Osoba za kontakt: |  | PALFI FABIJANA
 |  | (unosi se samo prezime i ime osobe za kontakt)
Telefon: |  | 052/858-617 |  |  |  | Telefaks: | 052/726-622
Adresa e-pošte: |  | [EMAIL]
Prezime i ime: |  | BOKULIĆ ZRINKA
 |  | (osoba ovlaštene za zastupanje)
 | Dokumentacija za objavu:
 | 1. [NAME] izvještaji (bilanca, račun dobiti i gubitka, izvještaj o novčanom tijeku, izvještaj o [NAME]
 | [NAME] i bilješke uz financijske izvještaje)
 | 2. Međuizvještaj poslovodstva,
 | 3. [NAME] osoba odgovornih za sastavljanje izvještaja izdavatelja.
 |  |  |  | M.P. |  | (potpis osobe [NAME])
Spreadsheet: 848898d1699508704-multiple-criteria-lookup-with-a-range-help
Sheet: 3 Oct

Installer | Product | Actual Area | Skirting | Trainer | Trainer rate | [NAME] rate
Ajay | Adhoc | 0 | N
Ajay | Adhoc | 0 | N
Ajay | Adhoc | 0 | N
Ajay | With Skirting | 0 | Y | Y
Ajay | Adhoc | 0 | N
Dipu | With Skirting | 500 | Y
[NAME] | With Skirting | 52 | Y
[NAME] | With Skirting | 160 | Y
[NAME] | With Skirting | 349 | Y
Muthiah | Adhoc | 0 | N
Muthiah | Adhoc | 0 | N
Muthiah | Adhoc | 0 | N
Muthiah | Adhoc | 0 | N
Muthiah | Adhoc | 0 | N
PAUL | Adhoc | 0 | N
PAUL | With Skirting | 0 | Y
Raja | Adhoc | 15 | N
Raja | With Skirting | 0 | Y
RASEL | With Skirting | 300 | Y
Rasu | Adhoc | 0 | N
Rasu | With Skirting | 124 | Y
[NAME] | With Skirting | 435 | Y
SAW | With Skirting | 129 | Y
Suresh | Adhoc | 0 | N
Suresh | Adhoc | 0 | N
Suresh | Adhoc | 0 | N
Suresh | Adhoc | 0 | N
Suresh | Adhoc | 0 | N
TANZIL | With Skirting | 250 | Y
TANZIL | Herringbone | 250 | Y
TANZIL | Herringbone | 250 | Y
Spreadsheet: 871572d1718020375-formula-error-in-generating-repteated-sequence-book2
Sheet: Sheet2

 | Region | Employee | Product | Location
 | Region-1 | EMP-1 | PRO-1 | Central Region |  |  | Central Region
 | Region-1 | EMP-2 | PRO-2 | Central Region |  | [NAME] | Eastern Region |  | 1 |  | 1 |  |  | 1
 | Region-1 | EMP-3 | PRO-4 | Central Region |  | Region-3 | Eastern Region |  | 2 |  | 2 |  |  | 2
 | Region-1 | EMP-4 | PRO-2 | Central Region |  | [NAME] | Eastern Region |  | 3 |  | 3 |  |  | 3
 | Region-1 | EMP-5 | PRO-1 | Central Region |  | Region-4 | Western Region |  | 1 |  | 1 |  |  | 1
 | Region-1 | [NAME] | PRO-2 | Central Region |  | Region-6 | Western Region |  | 2 |  | 2 |  |  | 2
 | [NAME] | EMP-1 | PRO-3 | Eastern Region |  | Region-5 | Western Region |  | 3 |  | 3 |  |  | 3
 | [NAME] | EMP-2 | PRO-2 | Eastern Region
 | [NAME] | EMP-3 | PRO-3 | Eastern Region
 | [NAME] | EMP-4 | PRO-2 | Eastern Region
 | Region-4 | EMP-1 | PRO-3 | Western Region
 | Region-4 | EMP-2 | PRO-2 | Western Region
 | Region-4 | EMP-3 | PRO-3 | Western Region
 | Region-4 | EMP-4 | PRO-2 | Western Region
 | Region-6 | EMP-1 | PRO-3 | Western Region
 | Region-6 | EMP-2 | PRO-1 | Western Region
 | Region-6 | EMP-3 | PRO-3 | Western Region
 | Region-6 | EMP-4 | PRO-2 | Western Region
 | Region-5 | EMP-1 | PRO-1 | Western Region
 | Region-5 | EMP-2 | PRO-3 | Western Region
 | Region-5 | EMP-3 | PRO-3 | Western Region
 | Region-3 | EMP-1 | PRO-1 | Eastern Region
 | Region-3 | EMP-2 | PRO-3 | Eastern Region
 | Region-3 | EMP-3 | PRO-3 | Eastern Region
 | Region-3 | EMP-4 | PRO-1 | Eastern Region
 | Region-3 | EMP-5 | PRO-3 | Eastern Region
 | Region-3 | [NAME] | PRO-1 | Eastern Region
 | Region-3 | EMP-7 | PRO-3 | Eastern Region
 | Region-3 | EMP-8 | PRO-3 | Eastern Region
 | [NAME] | EMP-1 | PRO-1 | Eastern Region
Spreadsheet: 75790d1276342175-random-totals-callrand
Sheet: Sheet1

 |  |  | 25000
 |  |  | 20000
2 |  |  | 10000
 | 48000 |  | 8000
 |  |  | 32000
 |  |  | 16500
 |  |  | 7500
 |  |  | 21000
 |  |  | 11500
 |  |  | 16000
 |  |  | 11000
 |  |  | 5500
 |  |  | 24500
 |  |  | 30500
 |  |  | 40000
 |  |  | 75000
 |  |  | 13200
 |  |  | 19000
 |  |  | 17500
 |  |  | 55000
Spreadsheet: 0bf57b7d-6786-4cda-92e6-c39a1c6e22da
Sheet: Sheet1

Chapter I: SUMMARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Chart: Inflation Forecast
Period | annual inflation rate  (end of period) | lower bound of the variation band | upper bound of the variation band | annual inflation target
 | annual percentage change
2010Q4 | 7.96 | 2.5 | 4.5 | 3.5
2011Q1 | 8.01
2011Q2 | 7.93
2011Q3 | 4.77
2011Q4 | 4.59 | 2 | 4 | 3
2012Q1 | 3.32
2012Q2 | 2.97
2012Q3 | 3.31
2012Q4 | 3.46 | 2 | 4 | 3
2013Q1 | 3.53
2013Q2 | 3.46
Note: Variation band is ±1 percentage point around the central target.
Source: NIS, NBR projections
Spreadsheet: 126812d1319953375-problem-converting-text-to-numbers-test-workbook
Sheet: buyers sale 1

Invoice Total
500.59
1100.16
155.71
370.08
290.40
1093.39
10461.74
1539.36
1041.02
947.04
1367.28
4396.80
6984.00
6481.78
Spreadsheet: 99946d1298473428-confused-by-circular-reference-warning-book3
Sheet: Sheet1

Points Won | Points Lost | Balance |  | Won | Lost
23575 | 3950 |  |  | 21025 | 3550
18325 | 6270 |  |  | 15775 | 5870
17700 | 4600 |  |  | 15150 | 4200
16875 | 4350 |  |  | 14325 | 3950
Spreadsheet: 756772d1637768300-add-a-period-to-cell-if-a-value-if-not-leave-blank-aew-letter-copy
Sheet: Sheet1

SSN | 123456789 |  |  |  |  | Open AEW
Address | [NAME]8675309 Lane NE Jenny, MN 12345
Date |  |  |  |  |  | Download AEW/FY2021
Date
Award |  |  |  |  |  | [NAME]
AEW Date (Use DOC)
POA |  |  |  |  |  | 21-22, 214
Type
Contention |  |  |  |  |  | Letter Data
Letter Name
VBMS-A Remarks |  |  |  |  |  | Do Calculator
Letter Dates
Letter Dates |  |  |  |  |  | Do Letter
Calculator Name |  |  |  | AEW Dated
Letter [NAME] |  |  |  | Grant, BEST PCLTRS |  | Save Letter/FY2021/PCLTR/Break
Second AEW
Contention |  |  |  |  |  | Print Calculator/FY2021
VBMS-A Remarks
 |  |  |  |  |  | Upload Calculator
 |  |  |  |  |  | Save Letter Creator/FY2021
 |  |  |  |  |  | CEST Claim
 |  |  |  |  |  | VBMS-A
Spreadsheet: phillip_m_love__30648__9908_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  | -620000 |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | 1433750
2 |  | Liquidations |  |  |  | -1264666 |  | 0 |  |  |  |  |  |  |  |  |  | -1433750 |  | 0 |  | -36109
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | -1247850 |  |  |  |  |  |  |  | -1229127
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  | -96674 |  |  |  |  |  |  |  |  |  | 1300000 |  | 32229
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  | -706500
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  | 706500
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -48342
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  | 174878 |  |  |  | 1433750
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 15000 |  |  |  |  |  |  |  |  |  |  |  | -15000 |  | 0
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 744319d1629148553-subtract-2-cells-if-amount-in-cell-b-is-greater-than-cell-c-i-need-the-sum-to-go-alt-cell-sample-worksheet
Sheet: June 2021

Subscriptions | [NAME] | [NAME] | Difference
Gas
Gas |  | 35
Net Flix |  | 12.99
Cox |  | 175.59
HBO Max | 14.99
Disney Plus | 8.89
MS Office | 11.06
You Tube | 9.99
Spotify | 12.99
Billie | 10
Sprint | 135.83
Discovery plus | 7.78
Chewy | 56.71
Totals |  |  | 44.66 | luci owes
Spreadsheet: 144585d1331050916-excel-2007-vlookup-for-cells-and-then-in-one-of-them-i-need-a-drop-down-menu-to-pick-between-2-states-book1
Sheet: Sheet1

Grower number | [NAME] | State | variety | boxes
1384 | [NAME] | MI | Peach | 50
1384 | [NAME] | NY
Worksheet
Grower Number | [NAME] | State | Variety | boxes
1384 | [NAME] |  | peach | 50
I put in Grower Number and then using vlookup bob comes in automatically but with state there is 2 different states,
I want to have it give me a drop down menu so I can pick what state bob is bringing these peaches from otherwise with
vlookup it will only pick the top one because it can't figure it out that there are 2 with different states. I would like
it to have do vlookup but then give me the option of putting the state in from a drop down menu.
Spreadsheet: 681013d1591296494-complicated-formula-needed-to-find-value-in-a-range-with-multiple-variables-consolidated-rules-sample-file-
Sheet: What I want results to be

 |  |  |  |  |  | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00
 |  |  |  |  | Event Guests | 10 | 15 | 15 | 10 | 45 | 45 | 45
 |  |  |  |  | Total Guests | 80 | 86 | 85 | 86 | 86 | 86 | 86
 |  |  |  |  | Occupied rooms | 80 | 80 | 80 | 80 | 80 | 80 | 80
Business name 1
Department | Status | Unit of Measure | Shift | Code | Position | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
 | Active | n/a | n/a | 10a | Night Auditor
 | Active | Event Guests | Shift 1 | 12b | Planner | 8 | 16 | 16 | 8 | 24 | 24 | 24
 | Active | Event Guests | Shift 2 | 12b | Planner | 8 | 16 | 16 | 8 | 24 | 24 | 24
 | Active | Event Guests | Shift 3 | 12b | Planner | 8 | 8 | 8 | 8 | 16 | 16 | 16
 | Inactive | n/a | n/a | 61a | Manager
 | Active | Total Guests | Shift 1 | 51a | Receptionist | 16 | 16 | 16 | 16 | 16 | 16 | 16
 | Active | Total Guests | Shift 2 | 51a | Receptionist | 16 | 16 | 16 | 16 | 16 | 16 | 16
 | Active | Total Guests | Shift 3 | 51a | Receptionist | 16 | 16 | 16 | 16 | 16 | 16 | 16
 | Inactive | n/a | n/a | 31a | Engineer
 | Active | Occupied rooms | n/a | 40a | [NAME] | 24 | 24 | 24 | 24 | 24 | 24 | 24
 | Active | Occupied rooms | n/a | 40b | Server | 34.29 | 34.29 | 34.29 | 34.29 | 34.29 | 34.29 | 34.29
Spreadsheet: 771889d1646907953-need-a-formula-that-changes-when-i-type-in-a-third-cell-ex-excel-formula-help
Sheet: Sheet1

[NAME] | Product | Nr 1 | Nr 2 | Nr 3 | Orderdate | Confirmed Week # | weeks in transportation | Estimated week # delivery | Status | ETA at Costumer week #
 |  |  |  |  |  | 24 | 3 |  | on schedule | 24+3
[NAME] | Product | Nr 1 | Nr 2 | Nr 3 | Orderdate | Confirmed Week # | weeks in transportation | Estimated week # delivery | Status | ETA at Costumer week #
 |  |  |  |  |  | 24 | 3 | 26 | dly | 26+3
Spreadsheet: 67459d1268083450-multiple-criteria-for-sumproduct-copy-of-example
Sheet: Sheet1

Bucket Type | PM | Schedule Type
Base | N/A | DETAIL |  | 2
Base | Blank | FUNCT
Transco | [NAME] | DETAIL
Transco | [NAME] | DETAIL
Path | [NAME] | BASIC
Base | [NAME] | BASIC
I am looking for a formula that will look for the word "BASE" in column A and looks for "N/A" and or "Blank" in column B.  Then it totals how many are "DETAIL" and "Funct" from column C
It needs to total: 2 (items in red)
They are "Base" and "N/A" and or "Blank" and equal detail and funct
Spreadsheet: 85384d1285434822-find-smallest-num-in-array-smallest-among-all
Sheet: Sheet1

Sl No | Value |  | Smallest |  | Desired Result
1 | 4 |  |  |  | 4
2 | 5 |  |  |  | 5
3 | 5 |  |  |  | 6
4 | 6 |  |  |  | 7
5 | 6
6 | 6
7 | 7
Spreadsheet: 128295d1320900197-compare-multiple-columns-with-multiple-sheets-sample-1-
Sheet: Sheet1

 |  |  | number | caller | number | receiver
 |  |  | 841122333 | number 1 | 844563219 | number 2
 |  |  | 849456321 | number 3 | 841122333 | number 1
 |  |  | 847896543 | number 4 | 841122333 | number 1
 |  |  | 841122333 | number 1 | 844563219 | number 2
Spreadsheet: 133316d1324329914-repeat-list-of-names-by-number-of-ballots-purchased-book2
Sheet: Sheet1

Name | Tickets | Cum. Count |  | List
[NAME] | 2
[NAME] | 4
[NAME] | 6
[NAME] | 4