that's because before excel 2007 you were limited to 32k rows. excel 2007 upped the ante to at least a million rows and many more powerful formulas, enabling more sophisticated analysis. if you rejected excel a decade go because it was underpowered, then it's worth trying again.
pop quiz hot shot, which tools do you think would have been better? then I'll tell you why you're wrong. and yes, I'm "using" all those intermediate data points.
also consider how well you know option X, and how much time (i.e. money) it will cost to become equally proficient in option Y. This will dwarf any upgrade costs.
you can always just copy/paste into excel and do text to columns and choose your delimiter. I don't know excel's default behavior when opening CSVs directly when the csv isn=t separated by commas.
no, because I'm a power user in an environment with a bunch of different types of coworkers, bosses, super-bosses, and clients. everybody has excel. and in what use case would photoshop be a better option than excel?
i don't know much about libreoffice. excel i can build my fuel economy and emission models using the built in formulas, and it has the power for more than a million rows. why would I switch?
At the sort of very advanced level we're talking about above, Excel can be evil. Finding a modeling error in a spreadsheet can be very hard; even knowing that it's there can be very hard. Build a complex spreadsheet that uses the most advanced functions and keep it error free? You'd better be really good, and more than a little lucky. (LibreOffice etc. are subject to the same thing, of course.)
i agree amateurs can really go hog wild on being "fancy." I use taco bell excel programming - a couple really simple features combined in different groups to make excel models that are powerful and maintainable. world runs on this stuff, man.
I built a model to calculate the fuel consumption of locomotives on 24 routes crossing the nation. on each route, i had a record every tenth of a mile that calculated instantaneous speed, acceleration, and power. rolled it all up to aggregate fuel economy, horsepower, etc. metrics. more than 10^6 records. power user, bitch.
My wife is an Excel wizard and she's not having problems with the Mac version on her Macbook.
first, excel performance on mac is abysmal. i've manipulated literally 10^6 rows in excel 2007 and windows 7, but this would not be possible in mac. second, basic formulas like SUMIFS are missing. third, excel mac is "mostly" compatible with excel windows, which is completely different than actually compatible.
also, excel on windows is extraordinary useful if you're a power user. there's nothing like it on other platforms, and don't say excel for mac or even worse numbers for mac.
you're being sarcastic, but I think this is correct. no way JO would let NSA in. he probably told them FU. and when they complained he called Obama directly and told him to FU.
except for the fact that everybody is not spying on everybody. you think you and I will get unfettered access to all google glass streams? or that we have the sophisticated software needed to float key insights to the top? nope. This is one-sided for sure.
There has been “continued exponential growth in tasking to Facebook and Skype,” according to the PRISM slides. With a few clicks and an affirmation that the subject is believed to be engaged in terrorism, espionage or nuclear proliferation, an analyst obtains full access to Facebook’s “extensive search and surveillance capabilities against the variety of online social networking services.”
so, you enter a name to access his full facebook profile, and there's a popup - are you reasonably sure he's a terrorist? yes/no" I'm glad to know there are safeguards in place!
James R. Clapper, the nation's Director of National Intelligence, issued the following statement:
"The NSA and FBI wish to thank wish to thank Google and the glassholes for contributing to the panopticon and bringing us real-time insights into the daily activities of terrorists and potential terrorists (the two categories of citizens) nationwide."
Is this Georgia, the U.S. state? Or Georgia the country, perhaps? Or is it actually somewhere completely unrelated to anywhere called Georgia, but where the company called Georgia Power just happen to be working?
With a name like Vogtie, it sounds like former USSR! also, with the whole chernobyl thing, it makes sense that they would need a nuclear containment vessel over there. lastly, double plus good for the person above who made the nuclear wessel joke. Take me to your nuclear wessels!
Slashdot Mirror
i don't understand... are you being serious or joking? Yes, excel is THE windows killer app. yes, i'm a power user. i'm glad I made your day.
that's because before excel 2007 you were limited to 32k rows. excel 2007 upped the ante to at least a million rows and many more powerful formulas, enabling more sophisticated analysis. if you rejected excel a decade go because it was underpowered, then it's worth trying again.
pop quiz hot shot, which tools do you think would have been better? then I'll tell you why you're wrong. and yes, I'm "using" all those intermediate data points.
i agree if you have to run (or write) a macro you have already failed.
what do you want me to say? I had a million records. had to put them somewhere. a DB can hold records but it can't do the maths.
I like your black & white world; mine has fifty shades of gray.
btdubs, ftfy.
yes, but this whole article is what would YOU do; and for ME, i'm an excel power user and need excel.
also consider how well you know option X, and how much time (i.e. money) it will cost to become equally proficient in option Y. This will dwarf any upgrade costs.
you can always just copy/paste into excel and do text to columns and choose your delimiter. I don't know excel's default behavior when opening CSVs directly when the csv isn=t separated by commas.
no, because I'm a power user in an environment with a bunch of different types of coworkers, bosses, super-bosses, and clients. everybody has excel. and in what use case would photoshop be a better option than excel?
i don't know much about libreoffice. excel i can build my fuel economy and emission models using the built in formulas, and it has the power for more than a million rows. why would I switch?
At the sort of very advanced level we're talking about above, Excel can be evil. Finding a modeling error in a spreadsheet can be very hard; even knowing that it's there can be very hard. Build a complex spreadsheet that uses the most advanced functions and keep it error free? You'd better be really good, and more than a little lucky. (LibreOffice etc. are subject to the same thing, of course.)
i agree amateurs can really go hog wild on being "fancy." I use taco bell excel programming - a couple really simple features combined in different groups to make excel models that are powerful and maintainable. world runs on this stuff, man.
I built a model to calculate the fuel consumption of locomotives on 24 routes crossing the nation. on each route, i had a record every tenth of a mile that calculated instantaneous speed, acceleration, and power. rolled it all up to aggregate fuel economy, horsepower, etc. metrics. more than 10^6 records. power user, bitch.
My wife is an Excel wizard and she's not having problems with the Mac version on her Macbook.
first, excel performance on mac is abysmal. i've manipulated literally 10^6 rows in excel 2007 and windows 7, but this would not be possible in mac. second, basic formulas like SUMIFS are missing. third, excel mac is "mostly" compatible with excel windows, which is completely different than actually compatible.
Or just normal CSV, for that matter. It's a stupid simple feature which I use all the time, and Excel falls flat on its face with.
for reals? i've had no problem. you can open up CSVs directly in excel or copy/paste text into excel. how does it fall flat?
also, excel on windows is extraordinary useful if you're a power user. there's nothing like it on other platforms, and don't say excel for mac or even worse numbers for mac.
you're being sarcastic, but I think this is correct. no way JO would let NSA in. he probably told them FU. and when they complained he called Obama directly and told him to FU.
except for the fact that everybody is not spying on everybody. you think you and I will get unfettered access to all google glass streams? or that we have the sophisticated software needed to float key insights to the top? nope. This is one-sided for sure.
There has been “continued exponential growth in tasking to Facebook and Skype,” according to the PRISM slides. With a few clicks and an affirmation that the subject is believed to be engaged in terrorism, espionage or nuclear proliferation, an analyst obtains full access to Facebook’s “extensive search and surveillance capabilities against the variety of online social networking services.”
so, you enter a name to access his full facebook profile, and there's a popup - are you reasonably sure he's a terrorist? yes/no" I'm glad to know there are safeguards in place!
just because you're paranoid doesn't mean the government isn't spying on all your activities.
James R. Clapper, the nation's Director of National Intelligence, issued the following statement:
"The NSA and FBI wish to thank wish to thank Google and the glassholes for contributing to the panopticon and bringing us real-time insights into the daily activities of terrorists and potential terrorists (the two categories of citizens) nationwide."
proof of troll? also, my prior accounts haven't been used in a year. so links or stfu.
Is this Georgia, the U.S. state? Or Georgia the country, perhaps? Or is it actually somewhere completely unrelated to anywhere called Georgia, but where the company called Georgia Power just happen to be working?
With a name like Vogtie, it sounds like former USSR! also, with the whole chernobyl thing, it makes sense that they would need a nuclear containment vessel over there. lastly, double plus good for the person above who made the nuclear wessel joke. Take me to your nuclear wessels!
I became an independent thinker, and now everybody downmoderates me :(
but will it run 4 instances of crysis 3 running at 1080p on a single 4k monitor?