skysight-inc/HackerNews huggingface dataset:
Ask HN: Where do you find good testers?
We've been working on a new webapp targeted at news junkies and smart(er) people. We're at the phase where we're using it internally and it seems (relatively) stable. Not quite ready for an HN launch, but we need 30-40 quality testers so we can look at some performance data and get some feedback.

How do you round up testers for your apps? We've got CS undergrad profs handing out invite codes at the local college, and we've enlisted several IRC hangouts we frequent, but so far results have been underwhelming. We've got a few really promising testers, but social apps tend to require a 'critical mass' to get things rolling. Where are all the testers hiding?

(If you want to sign up, http://tinyurl.com/newsbeta). More interested in stories about finding testers for your webapp.
It probably takes him a bit more than 30 mins, and a bit less than 1 hr. Most people average 15mph or a little less biking. It obviously depends on how in shape you are, what kind of bike you ride, and how urban the ride is. I rode 5 miles every day over a summer and it was a pretty consistent 20 minutes. (even with some hills and stoplights.)
When you look at upload speed or total possible transfer it hasn't improved as much as the number on the broadband package says, it's not even close to 50% a year, more like 20% at best.

For example here in UK/Virgin Cable I have decent 20 MBit down, and only puny 768 kbit up, with all kinds of arbitrary caps on top of that if I actually decide to use this for more than email.
You can retain formulas when you add a row but it only works if you add a row before the last row where your formula applies.

You can do what you're wanting with dynamic named ranges.

From reading some of your other responses it seems like you don't want to sum the entire row, maybe because you have the sum listed at the bottom of the dataset or something. With a dynamic named range you can add rows to the bottom of the range, and you also get a nice name to reference it by. It works by using offset and count/counta to deliver a range based on how many occupied cells there are (depending on if you use count or counta).

There are a few ways of doing it listed here: http://www.ozgrid.com/Excel/DynamicRanges.htm

In my experience you can do an incredible amount of things in Excel before you even break into doing stuff in VBA. You just have to look at any of the numerous resources out there that have tricky formulas available.
Eating fruit and veggies will increase your costs. You need certain number of calories a day, and price per calorie of most fruits and veggies is easily 10x higher than of bread, rice, chicken meat, ramen, fast foods etc.
So you're saying that C# is high level and Objective-C isn't?
As HN has grown, stuff on the homepage tends to change too frequently for me any more. If there isn't a comment modded up to 10, I'll rarely click the link.
So don't think mass market. I was approached to build a product. Part of that product is some hardware I can either buy off the shelf and design around, or I can design my own to do exactly what I need for this project and for future projects. I've been seriously thinking about open sourcing the design since it's just one module in the entire product and I know others would find it useful.

If anyone here has similar ideas, let me know. It would be great to start a SourceForge like site for hardware.
"Good artists copy, Great artists steal" - Pablo Picasso
I always have this opened in a tab:

http://wiki.lessthandot.com/index.php/Category:Microsoft_SQL...

It's not exactly a beginner's tutorial but I like it because it covers a lot of use cases. Also, it's short and to the point.

I hope you find it useful.
all the time. i find hacker news to still be the only community that im truly vested in, with no trolling, and overall good content.

a lot of the time i might have seen the article, but want to read the comments, so ill come here. If i haven't read the article, ill read the comments first if i want some backstory/alternate framing of the story.
1.) automatic smart chart creation - the spreadsheet guesses the kind of data I'm inputting and builds a chart on the fly.

2.) UI that values datasets over data points, or some sort of functionality that defines a dataset. Since most tasks deal with sets as a whole (and not individual points) this would result in a much cleaner, quicker interface. Also, you could start treating a dataset like a black box instead of a TON of cells with meaningless value, and thereby gain access to a lot of shortcuts not possible currently. This should allow easy data entry, dataset searching, and will keep all your scripting in your view. Best of all, there's no need to manipulate cells at all with a dataset approach.
It's actually simpler than naming a range because you can use the names of the rows and columns that you have in the header of the table.

It's a moot point since you don't have a Mac but from what you describe, Numbers does what you're missing.

I saw in one of your later comments that you were also talking about multiple tables on the same page. Numbers actually manages tables as independent objects of a page. So, in a table you can ask for the sum of a whole column without getting the numbers from another unrelated table on the same page. That's something that always bothered me in Excel.
Yep mostly.

1. comments if more than 4-5 would most always reflect the thoughts and opinions that I myself would be going through if I do read the article.

2. Checking out comments is quicker (in terms of load time and reading time) and less clutter on the flow as you have remained on a familiar website with only selectively moving out to a new website or web page.
KDE has that too. I suspect Xfce has it, too. There's got to be some widget that enables such functionality on Windows or even OSX, considering you can do it from the API.
Here are some references I review whenever I need to work with C++.

* The GNU C++ Library Documentation - http://gcc.gnu.org/onlinedocs/libstdc++/spine.html

* Scott Meyers TR1 Information - http://www.aristeia.com/EC3E/TR1_info.html

* Association of C & C++ users - http://accu.org

* C++ Library Reference http://www.cplusplus.com/reference/

* Guru of the Week archive - http://www.gotw.ca/gotw/index.htm

These are a little older:

* Lysator (Linköping, Sweden) - http://www.lysator.liu.se/c/index.html

* Brad Appleton's C++ Links - http://www.cmcrossroads.com/bradapp/links/cplusplus-links.ht...
I mentioned that I was working on secure online backups on my blog back in 2006, and by the time I was ready for beta testers I had a long list of people who had emailed me to express interest. Once I had all of those people testing tarsnap and still wanted more testers, I posted again to my blog and submitted that post here and to reddit, which brought me many more testers. Recently it seems that every time I've posted to my (personal) blog there has been a spike in signups; presumably people come to my blog, see my earlier posts about tarsnap, and then get interested.

I don't know how useful my experience is to you, since the sort of experienced *nix users who appreciate tarsnap are generally far more cliquey than "news junkies" -- but you asked for my experience, so here it is. :-)
The "toggle word wrap" FF add-on just sticks this into whatever page you're looking at, I think. Works great.
Can't think of a concrete example at the moment, but there have been cases when I had to make a financial model with a lot of columns (and rows) where a recursive algorithm would have presented the result I was looking for using a lot less cells.
The RSS feed also has links to the comments.
I've been playing guitar and singing for a good number of years. I'm working on my second music video. It's the song Patience by Guns n' Roses. My first music video was Across the Universe by the Beatles. I don't have very good "stage presence" in my first video but the one I'm working on now will be much better. Here's my first video:

http://www.youtube.com/watch?v=u7zro5VpUf0&feature=chann...
16GB of RAM is cheap to purchase if you're buying in 1GB or 2GB DIMMs, but try and buy 4GB DIMMs and it starts getting really expensive.

eg, $50 for 2x2GB vs $250 for 1x4GB.
That's the thing - that method exists but.. it's not default, and something as simple as resizing a window should be seamless by default without the need for hacks.

As a hacker, I love Linux to bits and it beats OS X and Windows in a crazy number of ways. As a user (and it's a hat I proudly wear quite often) I find the UI glitches infuriating, especially as it makes it so hard to recommend to other users I know (because I'll inevitably get the "why can't I resize windows properly?" question 100 times a year).
Earth on the Brink of an Ice Age - Pravda.Ru
"There is no truth in News, and there is no news in Truth."

http://plancksconstant.org/blog1/2007/09/there_is_no_truth_i...
http://www.michaeltotten.com/ this journalist travels all over warzones and is independant.
Get Win7 with Microsoft BizSpark
software entrepreneurs: you can get the beta version of Win7 with your Bizspark subscription.
drop me a mail if you need an invitation to join BizSpark julienco at microsoft.com (Bizspark is a program for software entrepreneurs, providing Software, support and visibility to hi-po prokjects).
http;//codorniou.wordpress.com
Hi Gregg, I like your setup, would you mind describing it a bit more? like a mini tutorial or schema drawing, so it could reproduced easily by another geek like me :)

Or I'll take it as a challenge, and as soon as I've got some time I'll try to do something kind-of like your setup ;)
What's up at Heroku
This is exactly the kind of maintenance issue that makes me occasionally hate using Ubuntu.

Oh look! My flash player suddenly stopped working! I get to do six hours of forum combing and troubleshooting, whoppee!
Not at all.

In an environment where the government decides what is prudent, there is no incentive for a bank to say "We are sounder than our competitors because we keep more reserves". Why not? Because they would be competing against the government for their definition of soundness.

Sure it could happen theoretically, but it would be a tremendous competitive disadvantage.

The way it is today, any bank that is legally allowed to operate is considered equally sound by borrowers and investors, and banks have no incentive to try to prove to customers that they are actually more sound than their competitors.

In a highly regulated environment, that works for all banks because they know that if there is a major economic downturn everyone will get bailed out.

Notice that all banks were required to accept TARP loans whether they needed them or not. Why? To avoid SIGNALING which banks were hurting and which were not. Why? To avoid capital flowing to the banks that were actually sound!

Why? Well, partly because government wants to avoid a crash, and partly to keep the status quo going strong. Also, consider what all of the major industry players in banking want... what does any firm want? No competition. They were all happy to share a big market and to have as few as possible attributes on which to have to compete for business.

Simple, smart, behaviorally sensible regulations make sense, but the SEC has been notoriously behind the curve for years. The missing piece has been to regulate appropriately while allowing there to be an incentive for banks to actually compete on the basis of soundness. The decision not to let the concept of bank soundness enter the brains of mere citizens must be a knee-jerk reaction to the great depression.

Instead, in exchange for various political concessions, banks were given every incentive to be extremely leveraged. Consider the impact of the GSEs on housing prices, MBS prices, etc? The implicit guarantee of Fannie and Freddie alone probably led to banks thinking (rightly, it turns out) that any housing related crash's impact on banks would be bailed out.

Side note: Are the banks going to be better off after the bailout? Of course they will be. The desired "sweet spot" for most firms is to be in a heavily regulated, heavily protected industry, as it means that there are huge barriers to entry and the profits (though sometimes essentially set by regulators) roll in year after year. See the military industrial complex for an example of the idealized sort of model.

Market forces have been very far from banking for a long time. Why else would financial services be the biggest donors to both parties. Libertarians are not opposed to regulations, just not ones that create perverse incentives and lead to massive bailouts! Any time a firm would rather spend its money on lobbyists and campaign contributions rather than innovation, there is a big problem.
Yes. Actually, this is one reason I like the socialite firefox plugin for reddit. Letting me access the comments directly from the link is exactly what I need. Going back to the main page to find the comments link after I've read the link is a pain in the ass.

Maybe I could hack this together for HN....
In overture, you could buy the search results, though. Apparently, the founders looked at that and said "don't be evil."
For an rsync-like solution that also handles the tar-ing and (GnuPG) encryption of whatever directory you want to backup, take a look at duplicity (if you're on some Linux flavor). http://duplicity.nongnu.org/

It is a command-line solution, and simple to throw in cron. In addition, you can use it to back things up to S3 directly. It's great.
I thought something similar when reading this thread and thought it would make a nice bookmarklet.

http://code.cohitre.com/snippets/hackernews.html

It opens the comments and original article in side by side iframes for easy previewing.
Cal alum designs social network for China youth
Open? Looking for a critique on an open strategy for a startup
Depends on the link. Often the title is something like "Five reasons Ruby on Rails is dead" that just indicates what area the discussion is going to be in. Then I'm often interested to see the discussion, but not so interested to see the blog post itself.
How is spending money you don't have helpful? How can this NOT cause harm?
Or else the ability to save it as text (XML) in a way that will work with SVN so that we can have multiple people working on an Excel sheet saved that way and SVN will be able to merge it. When you try that with Excel, you get all kinds of conflicts in extra data that it's saving in the headers.
Right, sorry, 2017 is the year the total paid to retirees is greater than the incoming contributions.

Medicare is already running in the red, by the way.
Ironic but I love this one,

A witty saying proves nothing.
- Voltaire
Ask HN:  Help This Startup Find A New Revenue Model?
oh, I should've checked. Try indigoviolet@gmail.com
Is there any evidence ( even anecdotally ) that drug use and spying are related?

The government security clearance process seems to be very focused on recreational drug use history.
Both hanssen and Ames came up inconclusive in their polys. But they were able to cleverly explain them away. Coming up inconclusive is easy, passing outright is hard. To get a job at an intel shop you must pass. The problem with Ames and hanssen was in the organization, not the poly.
I would like to do conditional formatting on one column based on the contents of another column.
Essentially it allows you to favorite an item to refer back to later. It's like Twitter favorites, but beside each item, it also shows who 'liked' it.
I'm currently starting a project on App Engine because it's free, but I'd much rather work with Rails. The free version of Heroku still incurs EC2 costs, right?
add adsense or have a mission once a month to raise funds in exchange for points
"But that suggests he's (at least somewhat) cynical about the military."

He is cynical about the opinions many civilians have about the military.
I always get bitten when I need to look up some c++ STL on cplusplus reference. I end up checking mails, checking news, checking share prices etc. I haven't broken the habbit....yet.
Those figures sound suspect to me, given the immense volume of searches performed on Google. I would guess that there's some double-counting going on.

All else aside, figures like those are all derived on the assumption that electricity is produced in a CO2 generating fashion. If we can figure out a better means of power generation, then all of these contributors get better at once.
Perhaps something around event or product based missions e.g Partner with X Corp, who to celebrate the release of product Y run a that requires the novel use of Y etc. Otherwise, what vaksel said...
It's only a matter of time until gas goes back up in price. Let's not wait until then to figure out how to make good, efficient cars at a price that people can pay. Even if oil were to stay cheap for years to come, this isn't a problem we can solve at the drop of a hat.
I'm surprised how many people read the comments first. Should I pull the beginning of the leading comment text up onto the front page with the link, like Gmail does with the beginning of the message body?

Or would that mess up the clean look, and fill up mobile screens too fast? There are other possible solutions short of that. E.g. I could add a button people can click on to say that an article is linkbait, or mistaken, or whatever, and display icons to indicate this.
I live in Malibu, where we have those all-too-famous wildfires on a regular basis. Several of my neighbors have quietly told me that they really wouldn't care if their house burned down - yeah, they will lose some nice stuff, but they will also find themselves in a position where they don't have to think about the house, and taking care of it, and paying for the people who take care of it, and so on. Sometimes it is nice to just cut everything out and start over.

After all, isn't this how modern-day America came about? Lots of people cutting out everything from their former lives in Europe/Asia/etc and making a decision to come to America to see if they can make it work?
BackupPC http://backuppc.sourceforge.net/ is probably what you're looking for, although I can't tell you about the encryption part. I am just starting to look into serious backup solutions myself.
Of course! Always actually.

Even crap articles have good comment threads.

I wish the comment links were more prominent.
Here's an article that reviews two possibly relevent open source tools - http://www.linux.com/feature/154149

Unison File Synchronizer: http://www.cis.upenn.edu/~bcpierce/unison

DirSync Pro: http://directorysync.sourceforge.net/
I was thinking of something with 'WOOT' ? Maybe doing something where people win prizes daily (for solving missions)

-P
How about this: http://www.bygsoftware.com/Excel/SQL/UsingSql.html

Or: http://www.exceluser.com/explore/msquery1_1.htm
For those who didn't get the parent's joke: http://www.somethingawful.com/flash/shmorky/babby.swf
Much of the point of advertising is to convince (or remind) those who are not already convinced (or aware). Advertising is not advertising if you are hitting people eager to see your message - that's marketing.
Du lịch miệt vườn trước cơ hội lớn
General-purpose list grouping function in Common Lisp
Freeze multiple, unconnected columns and rows.

That way I could view the descriptions at the top and the sums at the bottom while I'm scrolling through any point in a spreadsheet.
But it looks like the important thing is that they have found a way to automatically map this syntax to Objective C method names.

EDIT: Or, as the MacRuby docs put it:

"MacRuby has a modified version of the parser which detects calls or method definitions using one regular argument, and other arguments using the key/value pair syntax. It will reconstruct the Objective-C full selector if needed. The method name that will be used in the Ruby VM is the same as the Objective-C selector."

http://www.macruby.org/trac/wiki/HowDoesMacRubyWork
I think I do the opposite. If it sounds like it's going to be ridiculous/controversial/unusual I like to read it myself first and see what my unbiased thoughts are. If it sounds like something easy to agree with I usually just want to see if anyone has a unique perspective on it.
that's so simplistic.

Back home, (ex-communist country), at the early 90s, the infrastructure was in pieces. I remember it took about 1.2 hrs, to travel 30 miles between the two biggest cities (one is a port, the other is the capital), of the country, on a two lane windy road. It was prone to accidents, traffic, frustration (every time when we wanted to go to the beach it was clogged).

The gov. had no money. It had to borrow some from FMN, and foreign dona tors, and build a highway, a modest 4 lane highway. That 70 minutes turned in to 25-mins. Transport became much much easier, faster, and traffic manageable. And shipments a lot easier.

The huge relief that came from the new road war worth the interest on that borrowed money, (money my government didn't have at the time), paid and more.

If you spending on things that have clear future net economic output, there is nothing wrong with borrowing from future income.

..
The problem is when the government borrows money (from future generations output), on dubious projects, or even worse, WARS.
That site is utterly brilliant. Isn't that Firefox icon beside the website name a bit random, though?
You can't tell whether you got the right answer.

My rule of thumb is that any interesting spreadsheet has a mistake. Anyone who uses a spreadsheet and doesn't independently know the answer "close enough" is living in a fool's paradise.
1. Really, really great looking graphs. Excel fails so hard at this it's unbelievable.

2. Easy navigation. The giant spreadsheet model is a very simple metaphor but sometimes I'd like a way to jump to different parts of it more easily.

3. Not be a spreadsheet. The one-big-sheet model might be better represented as a bunch of smaller tables floating in space with formulas interconnecting them. The letter/number convention has been around since the very first spreadsheet, surely we can do better.

4. Understand the internet. RSS, live stock quotes, etc. The address of a cell ought to be internet-compatible somehow, e.g. http://myspreadsheets.com/daily_report/C2 or http://myspreadsheet.com/daily_report/mynamedtable?x=Jan2007.... Google Docs does something like this, I think.

5. Allow scripting in a language that doesn't completely suck. Javascript or python would be good choices.
just as cool is Microsoft's Seadragon demo:

http://livelabs.com/seadragon/
Think is hiring
Though my company is not YC-funded, I am hiring. You can see the positions here:

https://www.thinkcomputer.com/corporate/jobs.html

The company is located in Palo Alto, CA next to Stanford.
Security vulnerability in Safari
By this logic, any loan anyone has ever taken has been a bad idea.
This makes some sense -- I guess I was thinking mostly of the devastation of fishing stock that has occurred over the last few decades in areas that aren't managed. However, I'd question whether the notion of fishing rights is truly libertarian. It obviously requires a fair amount of government intervention and management, to the extent that the more extreme anarcho-capitalist types would find it unpalatable.
Nope! I don't think so. The last time I tried creating an app. I didn't find any such stuff

Anyway I too would like to confirm this with those who've used their free platform to some good use (unlike be creating an app to display my name).

Me and a friend are planning to develop our app on Heroku. I surely don't want to use EC2 here. Coz Me and my friend are students and have no credit cards (and live in a place where credit cards are not liked so much. No idea why.) So we've to try and bootstrap our app with just our paypal money we made thru some projects. Hope their commercial payment methods includes Paypal.
+1 vote for banning AlleyInsider.
You don't have to trick it in Excel 2003. If you have 10 rows (i.e. c1 thru c10) and in c11 you have the sum if you right click on row 11 and insert row it will insert a row above 11 and update your formula for you in c11 to include the new row.