Excel 12

[Amedee Van Gasse]

I'm curious about what to expect - or not to expect.
Anyone?

--
Amedee Van Gasse
http://www.amedee.be

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.

 

[Harald Staff]

Unless someone managed to fill a depressed MS employed Excel programmer with
tequila (... hmm, how hard could that be ? , this would be just
unqualified guessing. Absolutely nothing is stated anyhwere.
One can of couse hope for the continuing lack of animated gifs and blinking
cell formats.

Let's rather reverse the question: Which imaginary new features would make
you folks pay -real money- for an upgrade ?

Best wishes Harald

"Amedee Van Gasse"

 

[Amedee Van Gasse]

Harald Staff <mailto:[email protected]> leverde op 30 jun 2004 een
briljante bijdrage in <Klik op deze link
om het bericht in zijn oorspronkelijke context te lezen:

Unless someone managed to fill a depressed MS employed Excel
programmer with tequila (... hmm, how hard could that be ? , this
would be just unqualified guessing. Absolutely nothing is stated
anyhwere. One can of couse hope for the continuing lack of animated
gifs and blinking cell formats.

Let's rather reverse the question: Which imaginary new features would
make you folks pay -real money- for an upgrade ?

Best wishes Harald

Harald,

You have raised an interesting question. I hope other people will also
share their thoughts.

What I *really* would like to see:
- remove the 256 column and 65K row limit
- Fix the date system: no more switching between system 1900 and 1904
- A lot of other things related to dates/times: support for historical
data in the past, like I would like to know on what weekday Columbus
discovered the West Indies (which would be a pre-Gregorian date)
- Also support for negative times, without switching to system 1904
- A correct weeknum function that calculates ISO weeknumbers. I don't
know but I can imagine there are other functions that are not ISO.
- A file format under a LGPL-compatible license, not the patented xml
extension they use now in 2003.

Some of these things can be programmed around using vba, but they should
have been standard features.

--
Amedee Van Gasse
http://www.amedee.be

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.

 

[Norman Harker]

Hi Amedee!

Re: I would like to know on what weekday Columbus discovered the West
Indies (which would be a pre-Gregorian date)

Here's a formula solution to that one pending issue of Excel Turbo
(V28)

Day of Month A2
Month Number B2
Year Number C2
Data validated entry of Gregorian or Julian in D2

Formula:
=CHOOSE(IF(D2="Gregorian",MOD(A2+(C2-(INT((14-B2)/12)))+INT((C2-(INT((14-B2)/12)))/4)-INT((C2-(INT((14-B2)/12)))/100)+INT((C2-(INT((14-B2)/12)))/400)+INT((31*(B2+(12*(INT((14-B2)/12)))-2))/12),7),IF(D2="Julian",MOD(5+A2+C2-INT((14-B2)/12)+INT((C2-INT((14-B2)/12))/4)+INT((31*(B2+(12*INT((14-B2)/12))-2))/12),7),"Error"))+1,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

 

[Amedee Van Gasse]

Norman Harker <mailto:[email protected]> leverde op 01 jul 2004
een briljante bijdrage in <Klik op deze
link om het bericht in zijn oorspronkelijke context te lezen:

Hi Amedee!

Re: I would like to know on what weekday Columbus discovered the West
Indies (which would be a pre-Gregorian date)

Here's a formula solution to that one pending issue of Excel Turbo
(V28)

Day of Month A2
Month Number B2
Year Number C2
Data validated entry of Gregorian or Julian in D2

Formula:
=CHOOSE(IF(D2="Gregorian",MOD(A2+(C2-(INT((14-B2)/12)))+INT((C2-(INT((1
4-B2)/12)))/4)-INT((C2-(INT((14-B2)/12)))/100)+INT((C2-(INT((14-B2)/12)
))/400)+INT((31*(B2+(12*(INT((14-B2)/12)))-2))/12),7),IF(D2="Julian",MO
D(5+A2+C2-INT((14-B2)/12)+INT((C2-INT((14-B2)/12))/4)+INT((31*(B2+(12*I
NT((14-B2)/12))-2))/12),7),"Error"))+1,"Sunday","Monday","Tuesday","Wed
nesday","Thursday","Friday","Saturday")

Yeah well this proves my point. It was only a fictitious example anyway.
A good answer should have been =WEEKDAY(A1), no matter what year it is.
Or perhaps =WEEKDAY(A1,"Julian") could be acceptable.

Anyway, thanks for your formula. I will use it if I ever need to work with
historical dates (not very likely however).

--
Amedee Van Gasse
http://www.amedee.be

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.

 

[Norman Harker]

Hi Amedee!

I agree! I only did it as a curiosity. A UDF using the the same
formulas would be a much better approach and give you what you want.

You have to give Julian / Gregorian options because the date for the
changeover varied from country to country (or in the case of the USA,
the date that they became States).
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
"Amedee Van Gasse"
<nzrqrr.qvgzntjrt.ina.tnffr.qvgzntbbxjrt@orfgnngavrg.rztebhc.qbabgfcnz.or>
wrote in message

 

[JE McGimpsey]

Not quite - though I suppose you can be forgiven your US history
niggles, Norman. The date depended upon who controlled the territories.
For instance, as a possession of France, all of the Louisiana Purchase
territory technically switched in 1582, even though the English colonies
waited until Great Britain switched in 1752, and Wyoming did not become
a state until 1890. The territory of Alaska switched in 1867, when the
US purchased it from Russia, but Alaska didn't become a state until 1959.

 

[Norman Harker]

Hi JE!

Thanks for that; I was trying to simplify and screwed up! It must make
life difficult for historians trying to track exact sequences of
events sometimes. It's made worse by year numbers changing at the end
of March in the English colonies (which, by the way, we'll take off
your hands any time you like).

 

[Amedee Van Gasse]

JE McGimpsey <mailto:[email protected]> leverde op 01 jul 2004 een
briljante bijdrage in <Klik op deze link
om het bericht in zijn oorspronkelijke context te lezen:

Not quite - though I suppose you can be forgiven your US history
niggles, Norman. The date depended upon who controlled the
territories. For instance, as a possession of France, all of the
Louisiana Purchase territory technically switched in 1582, even though
the English colonies waited until Great Britain switched in 1752, and
Wyoming did not become a state until 1890. The territory of Alaska
switched in 1867, when the US purchased it from Russia, but Alaska
didn't become a state until 1959.

*sigh*
You leftponders always do it the hard way ;-)

--
Amedee Van Gasse
http://www.amedee.be

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.

 

[JE McGimpsey]

Thanks for that; I was trying to simplify and screwed up! It must make
life difficult for historians trying to track exact sequences of
events sometimes. It's made worse by year numbers changing at the end
of March in the English colonies (which, by the way, we'll take off
your hands any time you like).

As far as I'm concerned, you're welcome to them! There's a strict
"no-returns" policy, however...

 

[Amedee Van Gasse]

Harald Staff <mailto:[email protected]> leverde op 30 jun 2004 een
briljante bijdrage in <Klik op deze link
om het bericht in zijn oorspronkelijke context te lezen:

Unless someone managed to fill a depressed MS employed Excel
programmer with tequila (... hmm, how hard could that be ? , this
would be just unqualified guessing. Absolutely nothing is stated
anyhwere. One can of couse hope for the continuing lack of animated
gifs and blinking cell formats.

Let's rather reverse the question: Which imaginary new features would
make you folks pay -real money- for an upgrade ?

Modeless property dialogs, like in StarOffice/OpenOffice, Lotus 1-2-3,
Coreldraw, Dreamweaver,...

--
Amedee Van Gasse
http://www.amedee.be

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.