tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 784913d1656008105-counting-occurrence-streaks-of-2s-between-three-1s-example
Sheet: Sheet1

 |  |  |  | 1=Win | 2=Lose | 3=Tie
 |  |  |  |  |  |  |  | Number of '2's before '1' | Number of '2's between two '1's |  | Number of '2's between three '1's | [NAME]
 |  |  |  |  | 2 |  | 1 |  |  | 1 | 4 | ???
 |  |  |  |  | 2 |  | 2 | 0 | 0 | 2 | 0
 |  |  |  |  | 2 |  | 3 | 0 | 0 | 3 | 0
 |  |  |  |  | 2 |  | 4 | 0 | 0 | 4 | 2
 |  |  |  |  | 1 |  | 5 | 0 | 2 | 5 | 3
 |  |  |  |  | 1 |  | 6 | 2 | 3 | 6 | 3
 |  |  |  |  | 1 |  | 7 | 1 | 1 | 7 | 1
 |  |  |  |  | 1 |  | 8 | 0 | 0 | 8 | 3
 |  |  |  |  | 1 |  | 9 | 0 | 3 | 9 | 3
 |  |  |  |  | 2 |  | 10 | 3 | 3 | 10 | 4
 |  |  |  |  | 2 |  | 11 | 0 | 1 | 11 | 2
 |  |  |  |  | 1 |  | 12 | 1 | 2 | 12 | 5
 |  |  |  |  | 2 |  | 13 | 1 | 4 | 13 | 9
 |  |  |  |  | 1 |  | 14 | 3 | 8 | 14 | 10
 |  |  |  |  | 1 |  | 15 | 5 | 7 | 15 | 7
 |  |  |  |  | 1 |  | 16 | 2 | 2 | 16 | 2
 |  |  |  |  | 2 |  | 17 | 0 | 0 | 17 | 2
 |  |  |  |  | 2 |  | 18 | 0 | 2 | 18 | 5
 |  |  |  |  | 2 |  | 19 | 2 | 5 | 19 | 5
 |  |  |  |  | 1 |  | 20 | 3 |  | 20
 |  |  |  |  | 1
 |  |  |  |  | 3
 |  |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  |  | 3
 |  |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  |  | 3
 |  |  |  |  | 2
 |  |  |  |  | 2
 |  |  |  |  | 2
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 16

Product* | January 3 | January 10 | January 17 | January 24 | January 31
Total Equity**
Equity Swaps | N/A | N/A | N/A | N/A | N/A
Portfolio Swaps | N/A | N/A | N/A | N/A | N/A
Forwards | N/A | N/A | N/A | N/A | N/A
Swaptions | N/A | N/A | N/A | N/A | N/A
[NAME] | N/A | N/A | N/A | N/A | N/A
TOTAL
Gross notional amount outstanding, January 31 weekly snapshot, by product type, all tenors and currencies.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**These numbers are estimates.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 740421d1626338373-multiple-dates-entries-in-a-gantt-chart-in-a-single-row-scheduler-3a-with-new-tab-
Sheet: Onc-Schedule

 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  | Select Month
Protocol | Patient Name | Type | From | To
C550-01 | [NAME] | SCR | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
ATX-101-01 | [NAME] | O/N | 2021-01-01 00:00:00 | 2021-01-03 00:00:00
ACT-001-AU-01 | [NAME] | Cap/Brain | 2021-01-03 00:00:00 | 2021-01-04 00:00:00
&&&& | [NAME] | O/N | 2021-01-04 00:00:00 | 2021-01-05 00:00:00
&&&& | [NAME] | Closed | 2021-01-05 00:00:00 | 2021-01-06 00:00:00
&&&& | Cabable Blewey | SCR | 2021-01-06 00:00:00 | 2021-01-07 00:00:00
&&&& | Cabable Blewey | SCR | 2021-01-07 00:00:00 | 2021-01-08 00:00:00
&&&& | Cabable Blewey | SCR | 2021-01-08 00:00:00 | 2021-01-09 00:00:00
&&&& | Brad Monday | SCR | 2021-01-09 00:00:00 | 2021-01-10 00:00:00
&&&& | [NAME] | SCR | 2021-01-10 00:00:00 | 2021-01-11 00:00:00
&&&& | Hello Hello | EOT | 2021-01-11 00:00:00 | 2021-01-12 00:00:00
&&&& | Bye Bye | SCR | 2021-01-12 00:00:00 | 2021-01-13 00:00:00
&&&& | PowerQuad | SCR | 2021-01-13 00:00:00 | 2021-01-14 00:00:00
&&&& | Sneaky Turtle | SCR | 2021-01-14 00:00:00 | 2021-01-15 00:00:00
&&&& | Yello Goopfish | Missed | 2021-01-15 00:00:00 | 2021-01-16 00:00:00
&&&& | Cancer is bad | SCR | 2021-01-16 00:00:00 | 2021-01-17 00:00:00
&&&& | [NAME] | SCR | 2021-01-17 00:00:00 | 2021-01-18 00:00:00
&&&& | [NAME] | Visit | 2021-01-18 00:00:00 | 2021-01-19 00:00:00
&&&& | [NAME] | SCR | 2021-01-19 00:00:00 | 2021-01-20 00:00:00
&&&& | Coffing coffee lollipops | Closed | 2021-01-20 00:00:00 | 2021-01-21 00:00:00
&&&& | [NAME] | Reconsent | 2021-01-21 00:00:00 | 2021-01-22 00:00:00
&&&& | [NAME] | SCR | 2021-01-22 00:00:00 | 2021-01-23 00:00:00
&&&& | [NAME] | Scan | 2021-01-23 00:00:00 | 2021-01-24 00:00:00
&&&& | Tarzan | SCR | 2021-01-24 00:00:00 | 2021-01-25 00:00:00
Spreadsheet: 174010d1344884684-array-formula-not-working-sample-attached-indirect-issue
Sheet: NAS

 |  |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | Total | Nov BOD
 | Retails | Touring | 3938 | 5471 | 10063 | 8910 | 9551 | 9290 | 7580 | 5688 | 7449 | 4984 | 3679 | 3909 | 80512 | 76791
 |  | Trike | 376 | 505 | 927 | 806 | 871 | 853 | 697 | 403 | 606 | 496 | 372 | 359 | 7271 | 7051
 |  | Softail | 1260 | 1882 | 3538 | 3046 | 3335 | 3076 | 2551 | 2159 | 2164 | 1640 | 1190 | 1202 | 27043 | 26198
 |  | Dyna | 918 | 1294 | 2565 | 2399 | 2623 | 2543 | 2191 | 1613 | 1853 | 1243 | 915 | 927 | 21084 | 20340
 |  | Sportster | 803 | 1541 | 2948 | 2943 | 3111 | 2706 | 2148 | 1402 | 2051 | 1261 | 963 | 841 | 22718 | 21555
 |  | VRSC | 262 | 307 | 608 | 578 | 580 | 495 | 415 | 297 | 358 | 276 | 221 | 217 | 4614 | 3799
 |  | CVO | 614 | 763 | 1075 | 1056 | 940 | 959 | 530 | 315 | 672 | 597 | 585 | 707 | 8813 | 8642
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Total HD | 8171 | 11763 | 21724 | 19738 | 21011 | 19922 | 16112 | 11877 | 15153 | 10497 | 7925 | 8162 | 172055 | 164376
Spreadsheet: 162519d1339945335-advanced-automatic-filtering-test
Sheet: filtered

futureCash | indice | currency | Equities | e_cal | currency-converter | calc | exchange | Technical
moneycontrol.com
sgxniftydowfutureslive.com
forexpros.thedailybell.com
stockmaster.in
bajarkesath.com
thongcome.com
hindi.moneycontrol.com
(direct)
kmzu.com
forexpros.com
commodityonline.com
ratgebergeld.at
manibhai.co.in
polymermis.com
indiabullion.com
thehindubusinessline.com
stocktime.ru
penditaemas999.blogspot.com
rajadvisory.com
persianrugsonline.com.au
hellenicshippingnews.com
medelle-finance.com
diendanfx.com
cahyanews.com
malaysiafutures.com
illinistatebank.com
mehmeterkek.com.tr
murugavel.com
shreelakshmionline.blogspot.com
eltee.de
welcometobazaartips.blogspot.in
aktien-blog.de
belgravecorp.com
goldprice.in.th
agriwireglobal.com
hishammarmin.com
luckystockpick.blogspot.com
moneymallfutures.com
[NAME]
mcxkingcommo.blogspot.in
bloggang.com
mcx-commodity-tips.blogspot.in
voltimes.com
americanpendulum.com
weekprofit.com
mcxcontrol.com
commodityupdatesmcx.blogspot.in
worldmarketsinfo.com
[NAME]
wmtrader.mastertopforum.org
lakshyaprofit.com
s-index.org
utusan.com.my
towntalkradio.com
tozsdearnyek.hu
providefx.com
mosebach.com
commodityvia.com
touch.forexpros.com
wavethree.in
commnewspreviews.com
davinvest.blogspot.com
onlyprofitcall.co.in
hb.cbcohio.com
psbroker.rs
internacional.companhiapropria.pt
kamafil.com
pricecapital.ie
suranatarun.blogspot.in
singstocks.com
gunjansecurities.com
bcommo.in
whumble.com
denimnifty.blogspot.in
jiignesh.blogspot.in
beleggenchat.nl
psinvest.rs
dannyzenhaguedes.net63.net
michelenista.blogspot.co.uk
research.pacific2000.co.id
commobullbear.blogspot.in
اسعار-الذهب-اليوم.com
segnaliditrading.it
google
rbsinvestment.blogspot.in
ideeanalisiborsa.investireoggi.it
fxtimes.com
tmdgold.com
equity-commoditytips.blogspot.in
bunkerportsnews.com
abszoluthozam.hu
economicdataupdate.com
images.moneycontrol.com
futuresxtrading.blogspot.co.uk
andypong.blogspot.com
mmltrader.blogspot.com
nourhammoury.com
traderupee.in
globaltechnicals.typepad.com
ntwkops01.snet.com
saraswaticonsultancyservices.com
agrocura.dk
financefutureforecast.com
codysbc.com
commodityprofittips.com
dmaworks.blogspot.com
portfolio.moneycontrol.com
xn-----btdabbf7dgs0e8geozu7a.com
bombaybulls.in
sedocfinance.net
aayeshatech.com
hadesresearch.com
startbizfree.com
1unite.com
uae-businessdirectory.com
target4gains.com
liverateindia.com
touch.kr.forexpros.com
klsetrend.blogspot.com
skid888futurestrading.blogspot.com
commoditycalls.in
profitbulls.webs.com
201.120.51.160:8080
rbdolein.com
avidano.blogspot.com
tezmanda.com
cedevansville.com
hitenenews.blogspot.in
nspforex.com
backends.moneycontrol.com
profit4u.co.in
theambrief.com
hariprasetya.blogspot.com
arkoudanews.blogspot.com
Spreadsheet: 471959d1469346048-lookup-values-from-two-columns-and-calculate-accordingly-datamodelprogressdummy
Sheet: Sheet1

Month | District | Crop |  | Month | District | Crop | Progress |  | Ditrict | Crop | Min | [NAME]
January | Ditrict1 | [NAME] |  | January | Ditrict1 | [NAME] |  |  | Ditrict1 | [NAME] | 10 | 500
February | Ditrict2 | Crop2 |  | January | Ditrict1 | Crop2 |  |  | Ditrict2 | [NAME] | 10 | 500
March | [NAME] | Crop3 |  | January | Ditrict2 | [NAME] |  |  | [NAME] | [NAME] | 10 | 500
April | Ditrict4 |  |  | January | Ditrict2 | Crop2 |  |  | Ditrict4 | [NAME] | 25 | 1000
May | Ditrict5 |  |  | January | [NAME] | [NAME] |  |  | Ditrict5 | [NAME] | 25 | 1000
June |  |  |  | January | [NAME] | Crop2 |  |  | Ditrict1 | Crop2 | 100 | 500
 |  |  |  | January | Ditrict4 | [NAME] |  |  | Ditrict2 | Crop2 | 100 | 500
 |  |  |  | January | Ditrict4 | Crop2 |  |  | [NAME] | Crop2 | 200 | 500
 |  |  |  | January | Ditrict5 | [NAME] |  |  | Ditrict4 | Crop2 | 200 | 1000
 |  |  |  | January | Ditrict5 | Crop2 |  |  | Ditrict5 | Crop2 | 300 | 1000
 |  |  |  | February | Ditrict1 | [NAME] |  |  | Ditrict1 | Crop3 | 500 | 10000
 |  |  |  | February | Ditrict1 | Crop2 |  |  | Ditrict2 | Crop3 | 1500 | 10000
 |  |  |  | February | Ditrict2 | [NAME] |  |  | [NAME] | Crop3 | 1500 | 10000
 |  |  |  | February | Ditrict2 | Crop2 |  |  | Ditrict4 | Crop3 | 250 | 10000
 |  |  |  | February | [NAME] | [NAME] |  |  | Ditrict5 | Crop3 | 125 | 10000
 |  |  |  | February | [NAME] | Crop2
 |  |  |  | February | Ditrict4 | [NAME]
 |  |  |  | February | Ditrict4 | Crop2
 |  |  |  | February | Ditrict5 | [NAME]
 |  |  |  | February | Ditrict5 | Crop2
 |  |  |  | March | Ditrict1 | [NAME]
 |  |  |  | March | Ditrict1 | Crop2
 |  |  |  | March | Ditrict2 | [NAME]
 |  |  |  | March | Ditrict2 | Crop2
 |  |  |  | March | [NAME] | [NAME]
 |  |  |  | March | [NAME] | Crop2
 |  |  |  | March | Ditrict4 | [NAME]
 |  |  |  | March | Ditrict4 | Crop2
 |  |  |  | March | Ditrict5 | [NAME]
 |  |  |  | March | Ditrict5 | Crop2
 |  |  |  | April | Ditrict1 | [NAME]
 |  |  |  | April | Ditrict1 | Crop2
 |  |  |  | April | Ditrict2 | [NAME]
 |  |  |  | April | Ditrict2 | Crop2
 |  |  |  | April | [NAME] | [NAME]
 |  |  |  | April | [NAME] | Crop2
 |  |  |  | April | Ditrict4 | [NAME]
 |  |  |  | April | Ditrict4 | Crop2
 |  |  |  | April | Ditrict5 | [NAME]
 |  |  |  | April | Ditrict5 | Crop2
 |  |  |  | May | Ditrict1 | [NAME]
 |  |  |  | May | Ditrict1 | Crop2
 |  |  |  | May | Ditrict2 | [NAME]
 |  |  |  | May | Ditrict2 | Crop2
 |  |  |  | May | [NAME] | [NAME]
 |  |  |  | May | [NAME] | Crop2
 |  |  |  | May | Ditrict4 | [NAME]
 |  |  |  | May | Ditrict4 | Crop2
 |  |  |  | May | Ditrict5 | [NAME]
 |  |  |  | May | Ditrict5 | Crop2
 |  |  |  | June | Ditrict1 | [NAME]
 |  |  |  | June | Ditrict1 | Crop2
 |  |  |  | June | Ditrict2 | [NAME]
 |  |  |  | June | Ditrict2 | Crop2
 |  |  |  | June | [NAME] | [NAME]
 |  |  |  | June | [NAME] | Crop2
 |  |  |  | June | Ditrict4 | [NAME]
 |  |  |  | June | Ditrict4 | Crop2
 |  |  |  | June | Ditrict5 | [NAME]
 |  |  |  | June | Ditrict5 | Crop2
Spreadsheet: 69090d1269601693-adding-shift-time-in-a-roster-sample-roster
Sheet: Sheet1

 | Mon 5th April |  | Tue 6th April |  | Wed 7th April |  | Thurs 8th April |  | Fri 9th April |  | Sat 10th April |  | Sun 11th April |  | Total Hours
 | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End
Employee 1 | 09:00:00 | 15:00:00 | 09:00:00 | 15:00:00 | 09:00:00 | 15:00:00 | 09:00:00 | 15:00:00 | 09:00:00 | 15:00:00 | OFF | OFF | OFF | OFF | 30
Employee 2 | 09:00:00 | 17:00:00 | OFF | OFF | 09;00 | 17:00:00 | OFF | OFF | 09:00:00 | 13:00:00 | OFF | OFF | OFF | OFF | 20
Employee 3 | 15:00:00 | 19:30:00 | 15:00:00 | 19:30:00 | 15:00:00 | 19:30:00 | 14:00:00 | 19:30:00 | 15:00:00 | 19:30:00 | OFF | OFF | OFF | OFF | 20
Spreadsheet: 705489d1606149329-need-help-in-data-dividing-and-distribution-new-microsoft-excel-worksheet
Sheet: Sheet1

 | client | volume | start month | project duration | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
 | a | 6000 | jan | 6 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: KCDL

KCDL Online
2010-2011
COUNTER-Compliant? | No
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
KCDL Online
Searches | 5 | 0 | 0 | 25 | 12 | 5 | 3 | 6 | 1 | 18 | 0 | 3 |  | 0
Web Pages Delivered | 12 | 1 | 4 | 64 | 32 | 11 | 7 | 10 | 13 | 28 | 1 | 18
Spreadsheet: kate_symes__18860__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-15 00:00:00 |  | 216.73 | 20560 | 174.7 | 10144
 | 2001-03-14 00:00:00 |  | 211.45 | 25360 | 172.67 | 8512 | 225.87 | 1552 | 157.5 | 480
 | 2001-03-13 00:00:00 |  | 211.79 | 20960 | 168.03 | 9088 | 235.45 | 33 | 150.36 | 445
 | 2001-03-12 00:00:00 |  | 263.78 | 24240 | 255.08 | 7632 | 223.3 | 996 | 176.32 | 106
 | 2001-03-11 00:00:00 |  | 265 | 0 | 230 | 200 | 219.32 | 111 | 174.9 | 264 |  | 255.41 | 23256
 | 2001-03-10 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 247.11 | 873 | 227.78 | 709
 | 2001-03-09 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 277.5 | 52 | 230.19 | 982
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624 | 282.12 | 2609 | 247.42 | 748
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 |  |  |  |  |  | ..
Spreadsheet: 709299d1608236015-minimum-sum-value-excluding-value-0-min
Sheet: sheet1

Numero |  |  |  |  | A | A | B | B | C | C
123456 |  |  |  |  | 0 | 0 | 42.58 | 3 | 55 | 4 |  |  | <--45,58
321556 |  |  |  |  | 120.12 | 40.24 | 110.58 | 2.5 | 130 | 7
51984 |  |  |  |  | 75.21 | 12.2 | 252.2 | 0 | 170 | 12
Spreadsheet: 676912d1589051974-calculate-which-person-has-2-or-more-x-in-a-row-2-or-more-x-in-row-mempien-
Sheet: Blad1

 | 2020-04-02 00:00:00 | 2020-04-09 00:00:00 | 2020-04-16 00:00:00 | 2020-04-23 00:00:00 | 2020-04-30 00:00:00 | 2020-05-07 00:00:00 | 2020-05-14 00:00:00 | 2020-05-21 00:00:00 |  | Until today |  | People with 2 X's in a row | People with 3 X's in a row | People with 4 X's in a row |  | People with 4 X's in a row until today
[NAME] | √ | √ | X | X | X | X
[NAME] | X | √ | X | X | √ | √
Mark | √ | X | X | X | X | √
Nathalie | X | √ | √ | X | X | X
Spreadsheet: 786971d1657566125-multiple-complex-duplication-solution-required-untitled-spreadsheet-1-
Sheet: Sheet1

Example |  |  |  |  |  |  | Priority order based on AP Status
Code | AP Status | CB Status | Start Date | [NAME] |  |  | 1 | Active with valid expiry date
123 | Active | active | 10.05.2021 | 10.05.2023 |  |  | 2 | active with expired expiry date
123 | Active | active | 10.03.2022 | 10.03.2024 |  |  | 3 | inactive with valid expiry date
123 | [NAME] | active |  |  |  |  | 4 | inactive with expired expiry date
123 | Inactive | active | 03.02.2018 | 03.02.2020 |  |  | 5 | in progress without or with expiry date
123 | New | active |  |  |  |  | 6 | Draft with no dates
123 | In Progress | active |  |  |  |  | 7 | New with no dates
345 | new | active
345 | In progress | active
345 | active | active | 03.03.2020 | 03.03.2022
345 | inactive | active | 02.02.2018 | 02.02.2022
567 | active | active | 04.04.2020 | 04.04.2022
789 | inactive | active | 09.07.2019 | 09.07.2021
899 | in progress | active
987 | new | active
999 | [NAME] | active
Expected Results
Code | AP Status | CB Status | Start Date | [NAME]
123 | Active | active | 10.03.2022 | 10.03.2024
345 | Active | active | 02.02.2018 | 02.02.2022
567 | active | active | 04.04.2020 | 04.04.2022
789 | inactive | active | 09.07.2019 | 09.07.2021
899 | in progress | active
987 | new | active
999 | [NAME] | active
Spreadsheet: 83645d1283622292-display-values-within-a-background-filled-cell-into-a-different-cell-sample
Sheet: Sheet1

0 | 5
1 | 6
2 | 7
3 | 8
4 | 9
5 | 10
6 | 11
7 | 12
8 | 13
9 | 14
Spreadsheet: darron_c_giron__7953__Killed Deals
Sheet: ENA PHY

 |  | Mid
Deal Num | Cash | Value
LYNN
NE9875.4 Total | 0 | 255484.5681 |  |  | ROBIN
NG3997.2 Total | 0 | 375504.0825 |  |  | VK9584.1 Total | 0 | -7363.2081 |  |  | 77421 | Schedule E
NH1179.2 Total | 0 | 413487.9701 |  |  | VS8407.4 Total | 0 | 362454.9579
NH1181.2 Total | 0 | 396410.3639 |  |  | VS8407.7 Total | 0 | 331044.4845 |  |  |  | Reclassified as Financial
NO7873.2 Total | 0 | -11789.0045 |  |  | VS8407.8 Total | 0 | 961961.151
NO7873.4 Total | 0 | 16645.5643 |  |  | VS8407.B Total | 0 | 26759.6722
QV0049.1 Total | 0 | -5890.5666 |  |  | VS8407.H Total | 0 | 568277.3813
V34057.1 Total | 0 | 24025 |  |  | VS8407.J Total | 0 | 2374582.6638
V37849.1 Total | 0 | 44950 |  |  | VS8407.L Total | 0 | 1187291.332
V43359.1 Total | 0 | 21700 |  |  | VY1883.2 Total | 0 | 51271.7027
V63990.1 Total | 0 | -2830090.1093 |  |  | VY1883.4 Total | 0 | 128179.257
V63990.2 Total | 0 | 3947003.6134 |  |  | VY1883.8 Total | 0 | 1839193.7691
V63990.3 Total | 0 | 986750.9034 |  |  | VY1883.A Total | 0 | 752335.5587
V67692.1 Total | 0 | 3773308.0658 |  |  | VY1883.C Total | 0 | 1562468.1446
D |  |  |  |  | VY1883.E Total | 0 | 640944.4461
V67692.3 Total | 0 | 945215.0118000001 |  |  | Grand Total | 0 | 47887366.25470001
V73350.1 Total | 0 | 1197617.0379
V73350.3 Total | 0 | 773256.8251
V82405.1 Total | 0 | 813055.3559999999
V82405.2 Total | 0 | 3244669.4429
V82405.5 Total | 0 | 6323195.318399999
V82405.6 Total | 0 | 1498664.8544
V82405.E Total | 0 | 2071573.6809
V82405.F Total | 0 | 1062546.5127
V82405.J Total | 0 | 129956.298
V82405.L Total | 0 | 1806351.9685
V82405.M Total | 0 | 451587.9921
MARK
V82405.P Total | 0 | 1971459.6405
[NAME] Total | 0 | 2611943.5175
V82405.V Total | 0 | 452605.7992999999
V82405.W Total | 0 | 864966.0765999999
VK6281.3 Total | 0 | 725612.2954
VK6281.4 Total | 0 | 182526.8947
VK6281.8 Total | 0 | 66899.18059999999
VK6281.F Total | 0 | 182526.8947
VK6281.G Total | 0 | 1446729.3076
VK6281.J Total | 0 | 65266.4561
VK6281.M Total | 0 | 47566.27830000001
VK6281.O Total | 0 | 559074.7874
VK6281.Q Total | 0 | 133078.7788
VK6281.T Total | 0 | 72518.2846
Spreadsheet: 737727d1624554916-need-a-single-formulas-to-calculate-net-worth-overall-gain-and-couple-of-more-parameters-money
Sheet: Portfolio

 | This is how I made my transactions |  |  |  |  | Last trading price on 24 Jun | 119.7
 | Date | Price | Side | ShareQty
 | 2021-05-25 00:00:00 | 100.4 | BUY | 250 |  | My Networth (Latest Value) | 43331
 | 2021-05-31 00:00:00 | 92.5 | BUY | 54 |  | Quantity | 362.2
 | 2021-06-03 00:00:00 | 100.75 | SELL | -14 |  | Investments | 39868
 | 2021-06-07 00:00:00 | 126.9 | SELL | -38 |  | Today's Gain | -2263 | -0.0496
 | 2021-06-10 00:00:00 | 154.1 | SELL | -27 |  | Overall Gain | 3463 | 0.0869
 | 2021-06-14 00:00:00 | 140.9 | BUY | 40
 | 2021-06-16 00:00:00 | 127.25 | BUY | 40
 | 2021-06-18 00:00:00 | 114.9 | BUY | 40
 | 2021-06-22 00:00:00 | 126.6 | SELL | -18 |  |  |  |  |  | The report below is downloaded from the website
 | 2021-06-24 00:00:00 | 119.7 | BUY | 35
 |  |  |  |  |  |  |  |  |  | Stocks Bought
 | ??? - No idea how is this calculated |  |  |  |  |  |  |  |  | PURCHASE |  |  |  | LATEST |  |  | Live Price | Change | Quantity | Latest Value | Inv. Price | Day's Gain | Overall Gain
 |  |  |  |  |  |  |  |  |  | Qty | Date | Price | Amount | Price | Value |  |  |  |  |  |  | % Change | % Change
 |  |  |  |  |  |  |  |  |  | 153 | 25-05-2021 | 100.4 | 15361.2 | 119.7 | 18314 |  | 119.7 | -6.25 | 362 | 43331 | 110.13 | -2263 | 3464
 |  |  |  |  |  |  |  |  |  | 54 | 31-05-2021 | 92.5 | 4995 | 119.7 | 6464 |  |  |  |  |  |  | -0.0496 | 0.0869
 |  |  |  |  |  |  |  |  |  | 40 | 14-06-2021 | 140.9 | 5636 | 119.7 | 4788 |  | Quantity | Inv. Price | Inv. Date | Inv. Amount | Day's Gain% | Overall Gain | Latest Value
 |  |  |  |  |  |  |  |  |  | 40 | 16-06-2021 | 127.25 | 5090 | 119.7 | 4788 |  | 35 | 119.7 | 24/06/2021 | 4190 | 219 (-4.96%) | 0 (0.00%) | 4190
 |  |  |  |  |  |  |  |  |  | 40 | 18-06-2021 | 114.9 | 4596 | 119.7 | 4788 |  | 40 | 114.9 | 18/06/2021 | 4596 | 250 (-4.96%) | 192 (4.18%) | 4788
 |  |  |  |  |  |  |  |  |  | 35 | 24-06-2021 | 119.7 | 4189.5 | 119.7 | 4190 |  | 40 | 127.25 | 16/06/2021 | 5090 | 250 (-4.96%) | -302 (-5.93%) | 4788
 |  |  |  |  |  |  |  |  |  | Stocks Sold |  |  |  |  |  |  | 40 | 140.9 | 14/06/2021 | 5636 | 250 (-4.96%) | -848 (-15.05%) | 4788
 |  |  |  |  |  |  |  |  |  | PURCHASE |  |  | SELL |  | PROFIT |  | 54 | 92.5 | 31/05/2021 | 4995 | 338 (-4.96%) | 1,469 (29.41%) | 6464
 |  |  |  |  |  |  |  |  |  | Date | Price | Qty | Date | Price |  |  | 153 | 100.4 | 25/05/2021 | 15361 | 956 (-4.96%) | 2,953 (19.22%) | 18314
 |  |  |  |  |  |  |  |  |  | 25-05-2021 | 100.4 | 14 | 2021-03-06 00:00:00 | 100.75 | 5
 |  |  |  |  |  |  |  |  |  | 25-05-2021 | 100.4 | 38 | 2021-07-06 00:00:00 | 126.9 | 1007
 |  |  |  |  |  |  |  |  |  | 25-05-2021 | 100.4 | 27 | 2021-10-06 00:00:00 | 154.1 | 1450
 |  |  |  |  |  |  |  |  |  | 25-05-2021 | 100.4 | 18 | 22/6/2021 | 126.6 | 472
 |  |  |  |  |  |  |  |  |  | Profit / Loss |  |  |  |  | 2933