WindowOnInfinity

I'm having difficulty working out how to get Scrapy to observe (and try to achieve) a URL per second limit (e.g. 10 URLs/s)

DOWNLOAD_DELAY seems to be a minimum, so if I set to 0.1 some sites will have a much slower crawl rate than 10 URLs/s. Changing CONCURRENT_REQUESTS doesn't seem to make much difference (e.g. marginal difference between 10 and 100 CONCURRENT_REQUESTS).

My expectation was that a high number of CONCURRENT_REQUESTS would mean getting close to the DOWNLOAD_DELAY. I'm not getting close to memory or CPU limits so I don't think that is the issue.

To try to achieve 10 URLs/s I can set DOWNLOAD_DELAY to a much lower value (or zero) but this means sometimes there are far more r

A song I heard maybe five years ago. The chords and piano riff are this:

http://onlinesequencer.net/766177

If that isn't 100% accurate, it is at least 95%.

It was a slow piano-based song about someone who had died, which I came across on an obituary page (it wasn't someone who I knew, so I can't go back to that page). American female singer, with a slight hip-hop feel. Vocals were recorded in an almost telephone-voice style (all middle, not much treble or bass). I don't remember there being any beat but there might have been. Song was quite sparse, no more than piano/possible beat and vocals.

Lyrics almost certainly included "I'm missing you" or something close, and definitely included a

Forgive me if this post is unsuitable - it seemed like the best place to ask.

Over in Tip of my tongue we're trying to identify a song. This is proving tricky!

One thing we do know is that the song is (mostly?) in English, but the singer has a very strong accent, possibly eastern-European. You can hear it below:

http://picosong.com/w3CMs/

It would be a great help if someone was able to suggest what country the singer may be from - or to rule out countries that don't match the accent. It's possible the lyrics are not all in English, also.

Any suggestions appreciated! In the

After a few weeks with a Pebble Time Steel, I wanted to share a few thoughts with you hardcore Pebblers ;)

I love the device, because it's good at several things that matter to me:

• It's like a watch
• Always on
• Convenient notifications
• Control music
• Noticeable vibrations
• Daylight readable
• Basic/automatic fitness/sleep tracking
• Switch the straps easily

I have no issue with the fact that the Pebble relies on a phone. It's a small window view of what my phone would nag me about that I can view more conveniently.

What would make this a perfect device for me are a few things:

• Make the black black. I'm used to an AMOLED screen where black is practically in distinguishable fro

I'm having an odd problem with Excel occasionally hanging when I try copy/paste operations.

if I copy text from a source outside of Excel, then I can paste fine. If I try to copy a cell, or a cell's contents , the worksheet will freeze, and eventually become responsive, bit with nothing on the clipboard.

See here for a screen recording: http://imgur.com/a/lH8pv - after I press copy, I'm clicking the mouse but nothing occurs.

Would appreciate any help in pinning this down. I've tried disabling Excel/Com Add-ins, and there's nothing in the Event Viewer, so not sure where to start! If I exit Excel/restart, it will work, but will eventually start doing this again.

Any help much appreciated!

I saw a [post on r/kickstarter/](https://www.reddit.com/r/kickstarter/comments/3yl48e/someone_just_kickstarted_a_documentary_about_a/) for a documentary. After a little look, the subject certainly looks mysterious, and thought it might be of interest here.

Warren Chaney, has had an apparently illustrious career including films, TV and books. But it certainly doesn't seem right when you dig into it.

The biggest film referenced is called "America: A Call to Greatness", with some major stars like Charlton Heston. There's a clip on YouTube here:

https://www.youtube.com/watch?v=CHi8Xl9a_yQ

This is

Does anyone know of a way to format font colour and size in a CONCATENATE result? This is fixed for each result (i.e. formatting is the same for each concatenation result, although each concatenated item needs different formatting).

I've tried playing with a custom format which seems to make colour possible, but is extremely fiddly. Is there a way I could have an additional column which formats the results? Do I need to write some VB (and will this work?). Any ideas appreciated!

u/arnfada posted [this in r/NameThatSong](https://www.reddit.com/r/NameThatSong/comments/3ca4sj/help_me_find_out_this_old_song/) where it doesn't have much traction.

The song is heard in a documentary, on a record player that is broken/sped up:

https://www.youtube.com/watch?v=vu-PPKbQSEU#t=5m50s

I grabbed the audio and slowed it down:

http://picosong.com/ms3a/

Careful if you're using headphones, as there is loud dialogue which interrupts. I don't know if the record is flipped over, but a faster section appears about halfway through, which I slowed down twice. I don't think I got the speed quite right, but it's enough to hear the song and some lyrics, which include:

• I will (give?) t

New here, so hopefully I'm getting this right!

I have steam keys for Fez, Antichamber and Guacamelee! Gold Edition going spare. I'll pick recipients randomly.

All you need to do is:

• Make sure you're eligible (and post your Steam ID as per the rules)
• Post which game you'd like
• Tell me your favourite song

Good luck! I'll send keys to the winners tomorrow :)

Edit: thanks to everyone for posting and sharing such a wide range of songs :)

The winners were:

• u/trebont - Guacamelee
• u/GazPumped - Antichamber
• u/TheVetNoob - Fez

Thanks again!

Does include the dreaded GFWL although the devs apparently plan to remove it.