Thread: why>?

why do you guys use excel?

how do you survive the 65k row limit?
it just boggles my mind; i hate excel more than anything

i think that all your spreadsheet dorks should be homeless; on the side
of the street--

-Aaron

Because the abacus is too difficult to master.

We hate it also.
That is, until we get the no limit on rows

Many of us are homeless. Contributions are welcome.
Send all to me and I will spend it on Wild Turkey.

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
<aaron.kempf@gmail.com> wrote in message
news:1148332296.581383.267130@j33g2000cwa.googlegroups.com...
> why do you guys use excel?
>
> how do you survive the 65k row limit?
> it just boggles my mind; i hate excel more than anything
>
> i think that all your spreadsheet dorks should be homeless; on the side
> of the street--
>
> -Aaron
>

Because in this newsgroup you usually meet polite and very helpfull people
Because if I have to use more than 65536 rows I use Access
Because my boss gives me a big smile when I make sth fancy for her in excel
Because that really turns me on
Because I save my coworkers many hours of work when making a nice and
usefull workbook
Because....
Because....
Because...
Because in this newsgroup you usually meet polite and very helpfull people
Because in this newsgroup you usually meet polite and very helpfull people
Because in this newsgroup you usually meet polite and very helpfull people
Because in this newsgroup you usually meet polite and very helpfull
people!!!!!!

<aaron.kempf@gmail.com> skrev i melding
news:1148332296.581383.267130@j33g2000cwa.googlegroups.com...
> why do you guys use excel?
>
> how do you survive the 65k row limit?
> it just boggles my mind; i hate excel more than anything
>
> i think that all your spreadsheet dorks should be homeless; on the side
> of the street--
>
> -Aaron
>

i just dont understand the value proposition.

i dont understand; do they spawn you guys in grade school?

where did you guys learn that it's socially acceptable to use this
ridiculous program??

aaron.kempf@gmail.com wrote...
>i just dont understand the value proposition.
>
>i dont understand; do they spawn you guys in grade school?
>
>where did you guys learn that it's socially acceptable to use this
>ridiculous program??

Evolution is hard. If there are a lot more Excel users than Access or
DBMS users, there'll be more Excel users to reproduce. After a few
generations, the point becomes moot. Maybe velociraptors were better
creatures by most objective criteria, but humans and rats (who share
common ancestors, for some perhaps not all that remote) have the planet
today. Fairness and objectivity have nothing to do with it.

Adapt or die.

Hello:

Because for people who know how to use a spreadsheet appropriately, the 65K limit is
meaningless. But then give the quality of the capitalizations in your post (it appears you
could not find the shift key on the keyboard) you probably would have problems with the 65K
limit.

Pieter Vandenberg


aaron.kempf@gmail.com <aaron.kempf@gmail.com> wrote:
: why do you guys use excel?

: how do you survive the 65k row limit?
: it just boggles my mind; i hate excel more than anything

: i think that all your spreadsheet dorks should be homeless; on the side
: of the street--

: -Aaron

yeah evolution is hard you idiot excel users need to evolve or die

the 65k limit is not meaningless.
it is a glass ceiling that you're stuck with and you can't do anything
about.

it's a travesty that you guys can't do anything with large datasets.

im not saying 'its not fair'

im saying that i dont understand why new people continue to get into
excel; but they won't get into Access or SQL Server.

i've never been at a company that has half of the sql server people
that we need.

but everywhere i've been; everyone knows excel.

is it the colleges that do this to us?

i just dont understand the value proposition.
i claim that if you build a database; and you build reports off of this
data; then you have the freedom to grow this into a larger, more
critical application.

i dont see oracle having an excel upsizing wizard anytime soon.

i just dont understand why you guys use excel; it seems to me like it's
a dead end street.

once you have a xls that is 10mb; what are you supposed to do with it?
you can't email it around.. you can't burn it onto a CD (since it has
countless paths to other spreadsheets; etc)

i just wish that excel had some real reporting capabilities.
i dont like shrink to fit; i think that it needs about 10x more
options.

i dont like pulling data OUT of excel. it never works.

i dont like pivotTables in Excel; they are much much much more powerful
in Office Web Components and they're faster and more portable.
i think that im going to make a real application where office web
components -- just a shell around owc where people can save their
spreadsheets in XML format TODAY.

not in office 2007.

today--

maybe i'll make an addin for access that makes owc act and behave just
like a normal form or report.

so that i can spoonfeed you kids into using a real -- tangible--
portable-- efficient system.


i just dont get the ROI that all you guys have spent millions upon
billions of hours in creating spreadsheets-- what is supposed to happen
to those spreadsheets when your company merges?

you sit there and recreate stuff by hand 24x7.

i re-use functionality; i re-use tables in hundreds of applications.

excel is worthless from what i see; and i just dont understand why
newbies use excel.

is it easier to use than accesss? NO.

is it better, longterm than access? NO.

does it scale, does it utilize multiple processors?

will excel 2007 allow 2 people to edit the same spreadsheet??

aaron.kempf@gmail.com wrote...
>yeah evolution is hard you idiot excel users need to evolve or die

The dinosaur telling the rodent to evolve. Let's just wait a bit and
count numbers of users. Won't prove which is better, but in the end
that doesn't matter.

yeah. the dinosaur is me?

you idiots copy and paste the same function a trillion friggin times a
year and you call me obsolete?

copy and paste
followed by more
copy and paste
followed by more
copy and paste
followed by more
copy and paste
followed by more
copy and paste
followed by more
copy and paste
followed by more
copy and paste


doesn't it have an endpoint?
isn't there supposed to be a happy ending for excel dorks?

how many times per day do you copy and paste?

how many excel virii have been found-- in the wild?

yes, i am a dinosaur.
in the same context that a mainframe is a dinosaur.

IBM takes databases very very seriously.

i just wish that there were more than 1 type of spreadsheet program;
maybe microsoft would have some incentives to make it better.

as it is; it's just ridiculous that microsoft hasn't added any new
funcitonaliy to excel in 10 years and you script kiddies sit there and
still use it.

if Microsoft were to take Excel-- and pull an ADP- keep all the data in
SQL Server and render is in a XLP file-- then maybe i would let you
guys keep on abusing you companies.. by submitting timecard after
timecard.. you claim that you do 'work'

when all you do is copy and paste.

you guys have thousands of copies of similiar functions; different
arguments.

if the UN were to change the calendar; and now we have 13 months-- then
all you kids will have to do about a billion things to make your
spreadsheets work.

i only have to change something in one place.

it's all about centralization; and i can do more work than 100
spreadsheet dorks.

i can leverage existing data.

you guys copy and paste existing data.

don't get me wrong-- i've seen some really really exciting solutions
using VSTO.
this is at least a step in the right direction.

but it's not fast enough ; it's not integrated-- and it's impossible to
purchase.

can't MS just include the vsto toolset with excel or something; give it
FUNCTIONALITY?

can't MS include some 'for each worksheet' functions?

i am just stunnned that the disease that is known as excel-- hasn't
been eradicated.

why doesn't the bill and melinda gates foundation give us all a vaccine
against Excel?
pay for all you kids to learn a real tool-- like SQL Server or Crystal
Reports or ASP or something?

Point made. Now, what is the purpouse of your post?

If it is for our enlightment, I would like to hear your suggestions about
how we can deal with clients/bosses that want some simple task done in Excel.
Some of the terms and expressions you have used before may not be appropiate
in those conversations, I am afraid.

Miguel.

aaron.kempf@gmail.com wrote...
>yeah. the dinosaur is me?

Got it in one! You're improving. Perhaps there's hope after all.

>you idiots copy and paste the same function a trillion friggin times a
>year and you call me obsolete?
>
>copy and paste
>followed by more
>copy and paste
>followed by more
>copy and paste
>followed by more
>copy and paste
>followed by more
>copy and paste
>followed by more
>copy and paste
>followed by more
>copy and paste

No doubt you actually typed all the forgoing.

>doesn't it have an endpoint?
....

Do your useless posts in Excel newsgroups? Entropy is forever.

>how many excel virii have been found-- in the wild?

Not all that many. More Word viruses than Excel ones because, surprise,
there are more .DOC files than .XLS files. Virus writers target the
most used applications in order to get the greatest effect. Start
giving the average business PC user more than just read access to
server-based DBMSs and you give virus writers new incentives to target
DBMSs. At the very least, Excel and Word serve as useful decoys.

>yes, i am a dinosaur.
>in the same context that a mainframe is a dinosaur.

Much more in the Control Data Corp sense than the IBM one.

>IBM takes databases very very seriously.

And it also sells a spreadsheet, Lotus 123. Your point being?

>i just wish that there were more than 1 type of spreadsheet program;
>maybe microsoft would have some incentives to make it better.

Now we agree on something. Nothing works as well as market share below
60% to get Microsoft to do anything worthwhile. Without competition,
Excel will get SmartArt and color gradients and a bigger grid that'll
cause more problems than it'll solve.

BTW, do you have any idea how many fields per table Access 2007 will
provide? Excel 2007 will have 16,384 columns. If Access doesn't keep
up, there'll be worse headaches coming.

>as it is; it's just ridiculous that microsoft hasn't added any new
>funcitonaliy to excel in 10 years and you script kiddies sit there and
>still use it.

Unfair. They added the OLAP cube interface and VBA6 in Excel 2K. Both
significant. However, nothing to warrant more than a minor version
number increase since then.

>if Microsoft were to take Excel-- and pull an ADP- keep all the data in
>SQL Server and render is in a XLP file-- then maybe i would let you
>guys keep on abusing you companies.. by submitting timecard after
>timecard.. you claim that you do 'work'
....

Ah, so you're still nonexempt. That explaims much.

>if the UN were to change the calendar; and now we have 13 months-- then
>all you kids will have to do about a billion things to make your
>spreadsheets work.
>
>i only have to change something in one place.

In the DBMS source code. Unless, of course, someone happened to
hardcode the former 12 month names for a drop-down list, in which case
you'd need to check all your forms and revise as needed.

>it's all about centralization; and i can do more work than 100
>spreadsheet dorks.
....

If only most spreadsheet users did the same, dull, dead-end grunt work
you do.

>can't MS include some 'for each worksheet' functions?
....

You mean something other than

For Each ws In SomeWorkbook.Worksheets

?

Does VSTO completely ignore Excel's object model, or are you just
ignorant of what Excel's OM provides?

Just wait till you see the copy/paste when there are more rows than access.


--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Harlan Grove" <hrlngrv@aol.com> wrote in message
news:1148412519.644184.253660@g10g2000cwb.googlegroups.com...
> aaron.kempf@gmail.com wrote...
>>yeah. the dinosaur is me?
>
> Got it in one! You're improving. Perhaps there's hope after all.
>
>>you idiots copy and paste the same function a trillion friggin times a
>>year and you call me obsolete?
>>
>>copy and paste
>>followed by more
>>copy and paste
>>followed by more
>>copy and paste
>>followed by more
>>copy and paste
>>followed by more
>>copy and paste
>>followed by more
>>copy and paste
>>followed by more
>>copy and paste
>
> No doubt you actually typed all the forgoing.
>
>>doesn't it have an endpoint?
> ...
>
> Do your useless posts in Excel newsgroups? Entropy is forever.
>
>>how many excel virii have been found-- in the wild?
>
> Not all that many. More Word viruses than Excel ones because, surprise,
> there are more .DOC files than .XLS files. Virus writers target the
> most used applications in order to get the greatest effect. Start
> giving the average business PC user more than just read access to
> server-based DBMSs and you give virus writers new incentives to target
> DBMSs. At the very least, Excel and Word serve as useful decoys.
>
>>yes, i am a dinosaur.
>>in the same context that a mainframe is a dinosaur.
>
> Much more in the Control Data Corp sense than the IBM one.
>
>>IBM takes databases very very seriously.
>
> And it also sells a spreadsheet, Lotus 123. Your point being?
>
>>i just wish that there were more than 1 type of spreadsheet program;
>>maybe microsoft would have some incentives to make it better.
>
> Now we agree on something. Nothing works as well as market share below
> 60% to get Microsoft to do anything worthwhile. Without competition,
> Excel will get SmartArt and color gradients and a bigger grid that'll
> cause more problems than it'll solve.
>
> BTW, do you have any idea how many fields per table Access 2007 will
> provide? Excel 2007 will have 16,384 columns. If Access doesn't keep
> up, there'll be worse headaches coming.
>
>>as it is; it's just ridiculous that microsoft hasn't added any new
>>funcitonaliy to excel in 10 years and you script kiddies sit there and
>>still use it.
>
> Unfair. They added the OLAP cube interface and VBA6 in Excel 2K. Both
> significant. However, nothing to warrant more than a minor version
> number increase since then.
>
>>if Microsoft were to take Excel-- and pull an ADP- keep all the data in
>>SQL Server and render is in a XLP file-- then maybe i would let you
>>guys keep on abusing you companies.. by submitting timecard after
>>timecard.. you claim that you do 'work'
> ...
>
> Ah, so you're still nonexempt. That explaims much.
>
>>if the UN were to change the calendar; and now we have 13 months-- then
>>all you kids will have to do about a billion things to make your
>>spreadsheets work.
>>
>>i only have to change something in one place.
>
> In the DBMS source code. Unless, of course, someone happened to
> hardcode the former 12 month names for a drop-down list, in which case
> you'd need to check all your forms and revise as needed.
>
>>it's all about centralization; and i can do more work than 100
>>spreadsheet dorks.
> ...
>
> If only most spreadsheet users did the same, dull, dead-end grunt work
> you do.
>
>>can't MS include some 'for each worksheet' functions?
> ...
>
> You mean something other than
>
> For Each ws In SomeWorkbook.Worksheets
>
> ?
>
> Does VSTO completely ignore Excel's object model, or are you just
> ignorant of what Excel's OM provides?
>

Don

Excel will NEVER hold more rows than Access.

I have a billions rows in access-- all the time.

I use Access Data Projects-- the grown-up version of Access.

-Aaron