In article <f8ba1423-09e7-48d0-9677-18aa0393cc10n@googlegroups.com>,
Martyn Ellis <martyn.ellis12@gmail.com> wrote:
> Hi Dave

> So sorry for having (unintentionally) suggested that you might like to
> try sucking some proverbial eggs - I'm afraid that I hadn't fully
> grasped from your initial message what it was that you're trying to
> achieve. Having seen your last message, I realise that you were way
> ahead of me already as regards the niceties of !Eureka.

Martyn.
I honestly didn't reply from that angle, I just appreciated you taking the
time to make a useful suggestion. :-)

I'm always up for a bit of learning even in my dotage. :-) (Rhenium).
So no eggs were consumed during the chat. :-)

> Only thing to add is that, having had a quick scan through the !Eureka
> manual earlier today, I did find mention of a function 'DAYS360', which
> seems to work and use syntax very much like your Excel one - except that
> (very bizarrely) it calculates the number of days between two dates on
> the assumption that a year consists of 12 months of 30 days each!!
> Definitely no mention of a 'DAYS' function exactly like the one in
> Excel. Why that should be there but not the precise function that you're
> looking for is a bit of a mystery - except that I guess it was a whole
> lot easier to program!

Indeed, that is a really weird function, which I did use in the past with
an added +5 to get a closer answer. =DAYS360(C26,B26)+5 :-(

I do have a copy of the Eureka manual, unfortunately in the past when we
were doing a major redecoration, it was, with a lot of other stuff boxed
up and put in the loft out of the way, but never brought down again...

My oh my, the amount of stuff that gets consigned to the loft in a life
time can be boggling. (Well the married bit of the lifetime).

I'm waffling again... But I must pop up into the loft and bring a few
manuals back down again.

> Anyway, good luck with trying to sort out the tidying up of your sheets.

> Cheers
> Martyn Ellis

Thanks, appreciated the conversation.

Dave

--

Dave Triffid

In article <5a8673f864dave@triffid.co.uk>,
Dave <dave@triffid.co.uk> wrote:
> In article <f8ba1423-09e7-48d0-9677-18aa0393cc10n@googlegroups.com>,
> Martyn Ellis <martyn.ellis12@gmail.com> wrote:
> > Hi Dave

> > So sorry for having (unintentionally) suggested that you might
> > like to try sucking some proverbial eggs - I'm afraid that I
> > hadn't fully grasped from your initial message what it was that
> > you're trying to achieve. Having seen your last message, I
> > realise that you were way ahead of me already as regards the
> > niceties of !Eureka.

Don't worry Martyn, I'm the leader of that club, having mistaken
Dave's level of questioning so many times we've become good friends
over it!

> Martyn. I honestly didn't reply from that angle, I just appreciated
> you taking the time to make a useful suggestion. :-)

I used PipeDream for many years - for text, spreadsheets and
databases. It was my workhorse program. (I only started using a BBC B
because I couldn't type accurately, had no secretary and it was better
than Tippex.) [Does anyone remember Tippex?]

I discovered a lot of useful tricks over the years. One, is that if I
use numerical slots,
and put the date into A1 (as 17.3.23) it shows as <17 Mar 2023>
If in A2 I insert A1+7 the slot returns <24 Mar 2023>.
If in A3 I insert A2-A1 the slot returns <7>

Is there no such facility in Eureka?

(At this point, Martyn, I usually discover I've totally misunderstood
the nature of the question.)

> I'm always up for a bit of learning even in my dotage. :-)
> (Rhenium). So no eggs were consumed during the chat. :-)

I daren't get Pipedream to do the sum. It's nearly +10 years.

Michael Harding
Rev. Preb. M.D. Harding riscos@mdharding.org.uk

In article <5a8685a47ariscos@mdharding.org.uk>,
M Harding <riscos@mdharding.org.uk> wrote:

[Snip]

> ...than Tippex.) [Does anyone remember Tippex?]

Hi Michael, what fun... :-)
Yes, I still have a bottle of Tippex correction fluid here on my office
desk... Mmnn! Come to think about it, I also have a Tippex snail
correction tape, and still use both... :-)

> I discovered a lot of useful tricks over the years. One, is that if I
> use numerical slots,
> and put the date into A1 (as 17.3.23) it shows as <17 Mar 2023>
> If in A2 I insert A1+7 the slot returns <24 Mar 2023>.
> If in A3 I insert A2-A1 the slot returns <7>

> Is there no such facility in Eureka?

Yes that works the same in Eureka providing you've set the cell to display
a date as "dd mmm yyyy" (Sans quotes).

> (At this point, Martyn, I usually discover I've totally misunderstood
> the nature of the question.)

[Snip]

Michael, you were kind of on the same track as our chat, though we were
specifically noting the lack off, or the inaccurate results of a Function.

But then I'm quite often confused myself, as you know. :-/

The original question was about the function. "=Days(cell,cell)" Which for
some reason does not exist in Eureka.

Followed by a similar but inaccurate function "=DAYS360(C2,B2)" which I
modified to make the inaccurate result a little closer to reality.
"=DAYS360(C2,B2)+5"

This of course can be overcome in Eureka by using the formula...

"=$B$2-$C$2" Where B2 has todays date "=TODAY()" and C2 has the start date
"17 Mar 2022" (Sans quotes).

Anyway, whatever... It's nice to chat with friends.

Dave

--

Dave Triffid

In message <5a8685a47ariscos@mdharding.org.uk>
M Harding <riscos@mdharding.org.uk> wrote:

> [Does anyone remember Tippex?]

My screen used to be covered in it.

David

In article <b628b7865a.DaveMeUK@BeagleBoard-xM>,
David Higton <dave@davehigton.me.uk> wrote:
> In message <5a8685a47ariscos@mdharding.org.uk>
> M Harding <riscos@mdharding.org.uk> wrote:

> > [Does anyone remember Tippex?]

> My screen used to be covered in it.

8-)

Michael Harding
Rev. Preb. M.D. Harding riscos@mdharding.org.uk

In article <5a86a4ee87dave@triffid.co.uk>,
Dave <dave@triffid.co.uk> wrote:
> In article <5a8685a47ariscos@mdharding.org.uk>,
> M Harding <riscos@mdharding.org.uk> wrote:

> [Snip]

> > ...than Tippex.) [Does anyone remember Tippex?]

> Hi Michael, what fun... :-) Yes, I still have a bottle of Tippex
> correction fluid here on my office desk... Mmnn! Come to think
> about it, I also have a Tippex snail correction tape, and still use
> both... :-)

> > I discovered a lot of useful tricks over the years. One, is that
> > if I use numerical slots,

> > and put the date into A1 (as 17.3.23) it shows as <17 Mar 2023>
> > If in A2 I insert A1+7 the slot returns <24 Mar 2023>.
> > If in A3 I insert A2-A1 the slot returns <7>

> > Is there no such facility in Eureka?

> Yes that works the same in Eureka providing you've set the cell to
> display a date as "dd mmm yyyy" (Sans quotes).

In Pipedream any numerical slot is a date slot if presented as e.g.
27.3.23

> > (At this point, Martyn, I usually discover I've totally
> > misunderstood the nature of the question.)

> [Snip]

> Michael, you were kind of on the same track as our chat, though we
> were specifically noting the lack off, or the inaccurate results of
> a Function.

> But then I'm quite often confused myself, as you know. :-/

> The original question was about the function. "=Days(cell,cell)"
> Which for some reason does not exist in Eureka.

> Followed by a similar but inaccurate function "=DAYS360(C2,B2)"
> which I modified to make the inaccurate result a little closer to
> reality. "=DAYS360(C2,B2)+5"

> This of course can be overcome in Eureka by using the formula...

> "=$B$2-$C$2" Where B2 has todays date "=TODAY()" and C2 has the
> start date "17 Mar 2022" (Sans quotes).

> Anyway, whatever... It's nice to chat with friends.

Par for the course then: I didn't grasp the subtleties. In this
instance I plead Covid and being 'with the fairies'. I've already
sent a response today to the wrong person.

Michael Harding
Rev. Preb. M.D. Harding riscos@mdharding.org.uk

In article <b628b7865a.DaveMeUK@BeagleBoard-xM>,
David Higton <dave@davehigton.me.uk> wrote:
> In message <5a8685a47ariscos@mdharding.org.uk>
> M Harding <riscos@mdharding.org.uk> wrote:

> > [Does anyone remember Tippex?]

> My screen used to be covered in it.

> David

Hehe! Do you remember the origins of that joke, I do, but these days one
is not allowed to repeat it in a public space.

That said, very appropriate considering it is St Patrick's day. :-)

Dave

--

Dave Triffid