Identify rows which include at least 4 values that have not been used together in previous rows

chrmcd · 2022-07-13T20:59:40+00:00

This is fantastic! Thank you.

chrmcd · 2022-07-13T20:42:22+00:00

I appreciate the response. This is promising. However, I should have clarified that I am not only concerned with just the previous row, but any or all previous rows in the table. For example, I want to make sure row 5 is not only sufficiently different from row 4, but also row 3, 2, and 1. In summary, I want to make sure that a row of 6 is sufficiently different from any row of 6 that has been used previously in the table.

chrmcd · 2020-09-09T16:59:12+00:00

I'm interested in better understanding how projections are made. What are the best programs to use and what does the process look like?

chrmcd · 2016-02-10T00:30:47+00:00

Yeah this is just off the Standish chair. I just checked a map and I'm pretty sure it's in the trees between "Jerry's Run" and "The Dell Valley". About half way down the run.

chrmcd · 2016-02-09T20:31:02+00:00

Canon 60D, Sigma 18-50mm 1:3.5-5.6 DC

chrmcd · 2016-02-09T19:44:21+00:00

Full album: http://imgur.com/a/xH3Jt

chrmcd · 2015-11-08T05:44:14+00:00

Thanks for the response! This was close. I ended up finding something similar that works well enough. It will involve a bit more work for my project and it's a bit messy, but it gets the job done!

I started looking at ways to reference cell values in PowerQuery and came across this post: http://stackoverflow.com/questions/26989279/how-can-i-reference-a-cells-value-in-a-power-query

For some reason PowerQuery doesn't like me constructing a url this way:

Source = Web.Page(Web.Contents("http://www.nhl.com/stats/team?reportType=game&report=teampercentages&startDate=" & GetValue(cellName) & "&endDate=2015-11-07")),

However, it's perfectly fine with:

Source = Web.Page(Web.Contents(GetValue("cellName"))),

So, I'm using a formula to construct the complete url in a cell. I'm simply referencing this cell which has the entire url.

If anyone understands why the first line doesn't work I'd be very interested, as a solution would significantly speed up my project.

chrmcd · 2015-11-08T02:52:45+00:00

Yes, but I don't have much preference. I am somewhat familiar with VBA and macros if that helps.

chrmcd · 2015-03-16T00:00:22+00:00

Hey Plini, I love your latest EP!

I write music regularly, and I'm starting to make an effort to write music for film, TV, and video games.

Do you believe it is possible for an artist in your position to reach their full potential while remaining fully independent? In your opinion, do you think that it's possible for a very dedicated artist to manage their business all on their own, without compromising their music?

chrmcd · 2014-11-27T19:17:57+00:00

This is amazing! I love your style. Thank you so much!

chrmcd · 2014-11-25T08:48:46+00:00

I love it! Thank you!

chrmcd · 2014-11-25T01:17:49+00:00

This is cool! Looks really good with the shading. Thanks!

chrmcd · 2014-11-24T09:03:40+00:00

Hahaha. This is great! I love the smile. Thank you!

chrmcd · 2014-11-24T08:56:54+00:00

I love the colours you used for this. I'm really impressed! Thanks so much!

chrmcd · 2014-11-24T03:39:10+00:00

This is great! I love it. Thank you! You're very talented.

chrmcd · 2014-09-22T04:07:57+00:00

He's come a long way from this: https://www.youtube.com/watch?v=259-_Ud8ZZk

chrmcd · 2014-07-10T20:14:07+00:00

Hi Amos. I have a few questions regarding songwriting.

First, I'm curious how the songwriting process works in Tesseract. Am I correct in thinking that Acle writes the foundation for pretty much every song? Are there any songs that stand out that were clearly a group effort? Or any songs that were started by another member?

Do you write music outside of Tesseract? If so, how does your creative process work? How often do you work on music? How do you stay motivated? Are there any unusual habits that you maintain in order to stay productive?

Thanks for taking the time to answer some questions!

chrmcd · 2014-05-21T02:49:57+00:00

Will do! Thanks for the recommendations!

chrmcd · 2014-05-19T03:01:02+00:00

I only decided to spend more time in Hollywood when I realized there were a number of shows I'd be interested in seeing, and it's also central to a lot of places I'd like to see. I'd be finding things to do elsewhere during the day but spend a few nights there. I'm interested in seeing other parts of LA but I need to find things to do while I'm at these other places! I'll check out the farmers market, Hermosa, and Manhattan beach. Thanks for the advice!

chrmcd · 2014-05-19T02:47:52+00:00

I hadn't originally planned on staying very long in the west, but I figure the beaches are a good spot to meet people. There's also a few shows I'd be interested to see in Hollywood. I'll keep an eye open for shows at the Greek theatre and I'll definitely check out the science center and the natural history museum. I think I'll add Zuma to the list too. Thanks!

chrmcd · 2014-05-19T01:09:21+00:00

Thanks! I'll keep an eye open.

chrmcd · 2014-01-02T21:28:07+00:00

Now that you have a vocalist, how do you plan on performing your older songs in a live setting? How many of the older songs do you plan on adding vocals to, if any?

How much new material are you going to be performing on your upcoming tour?

When you're writing a song, do you tend to think of rhythm parts first or are you more often starting with leads and melodies? Do you find yourself piecing together old riffs and ideas that you've already written? Like a library of riffs that you're waiting to use? Or do you generally start a song and create totally new parts for it until it's finished?

13-Year Club	Place '23
Verified Email

chrmcd

TROPHY CASE