advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Any "Numbers" guys here? Need to create a sequence
Posted by: dmag
Date: May 16, 2017 08:24PM
Hi,

I need to track certain web events that repeat several times over the course of 365 days — while other events are also taking place.

I'm thinking Apple Numbers could be used to create a formula and a sequence to lay this out for a 5.5-year period.

Hope I can explain this simply.

There is a new event each day. Each individual event takes place nine times — its day 1 (initial showing), then it will repeat on days 3, 7, 14, 30, 90, 180, 270, and 365.

Tomorrow's new event starts a whole new cycle of nine, while moving up one day in the calendar.

Because of the repeats, soon there will be multiple events on the same day (initial showings plus repeats). The challenge is to forecast exactly which events are being put together on any given day, and that there is no conflicting information or problems between them.

I've been tasked to run this out for 5.5 years, starting July 1 of this year and ending Dec. 31 of 2022. I also have to factor in Feb. 29, 2020 (leap year). This will start with event #1 and end with event #1826.

I don't know a lot about Apple Numbers or Excel. Is there any way to create a formula which would run this sequence for the 5.5 years, listing all events that will be shown for each day during that period?

I know on day 7 of all this, event #7 will show for the first time, plus have repeats of day 1 and day 5. That's easy. But how about November 15 of 2021 — what events show that day, etc?

If Numbers can't do this, maybe you can suggest another way.

Thanks for the read.
Options:  Reply • Quote
Re: Any "Numbers" guys here? Need to create a sequence
Posted by: space-time
Date: May 16, 2017 10:20PM
I could probably do it in Excel, but it is too late and I had 2 glasses of wine this evening. If no one offers a solution, I will give it a shot tomorrow night.

Just curious: what religion is this?

EDIT: almost done, but I will post the solution tomorrow night after I get a chance to review it with a clear mind.

How do you want these formatted say you get a table with 9 columns with events numbers in each column? would that work?

Nov 15, 2021: event 1600, event 1598, ... event 1234? would that work?



Edited 1 time(s). Last edit at 05/16/2017 10:34PM by space-time.
Options:  Reply • Quote
Re: Any "Numbers" guys here? Need to create a sequence
Posted by: dmag
Date: May 16, 2017 10:35PM
LOL

It's not.

Just business and trying to avoid messing things up with mixed messages, old info, etc.

Thanks.
Options:  Reply • Quote
Re: Any "Numbers" guys here? Need to create a sequence
Posted by: dmag
Date: May 16, 2017 10:56PM
Sure.

Just the numbers would be enough.

If it showed:

Nov. 15, 2021 — 1600, 1598, 1234

that would be fine.

If the word event is in there, no problem. Maybe I can run a find and delete it.

Thanks.
Options:  Reply • Quote
Re: Any "Numbers" guys here? Need to create a sequence
Posted by: freeradical
Date: May 16, 2017 11:15PM
$ cal 1752
Options:  Reply • Quote
Re: Any "Numbers" guys here? Need to create a sequence
Posted by: Buzz
Date: May 17, 2017 04:35AM
You're right on about using "Numbers", but I'm not talking about Apple's spreadsheet program (per se)...
Think of the whole series as day numbers, not actual dates to start with.
For each (day) number in the series, extrapolate its nine showings.
For illustrative purposes...
Day / Showings
# - 1 - 2 - 3 - 4- 5 - 6 - 7 - 8 - 9

1 = 1, 3, 7, 14, 30, 90, 180, 270, 365
2 = 2, 4, 8, 15, 31, 91, 181, 271, 366
3 = 3, 5, 9, 16, 32, 92, 182, 272, 367
.
.
7 = 7, 9, 13, 20, 36, 96, 186, 276, 371
.
.
14 = 14, 16, 20, 27, 43, 103, 193, 283, 378
.
.
etc.

For each day number, look thru the nine showings columns to see if there's a match, if there is, add that showing's original day number to the current day's showings display field.

This would be a piece of cake in FileMaker, or other user friendly database program to generate the desired results, which could then be exported and displayed in Numbers or Excel. Probably 15 - 20 minutes, tops, but but at least two and half billable hours, because that's what the boss would think it would take trying to do the whole thing in a spreadsheet. The database can easily convert the day number series back to the corresponding dates, including leap day, without missing a beat. By using numbers for everything, dates don't even come into play until the final conversion. :-)
Good luck.
==



Edited 1 time(s). Last edit at 05/17/2017 04:36AM by Buzz.
Options:  Reply • Quote
Re: Any "Numbers" guys here? Need to create a sequence
Posted by: dmag
Date: May 17, 2017 05:57AM
Thanks Buzz, that's an interesting idea to try. I hadn't thought of it like that.

"Filemaker"

(sigh)

Hadn't thought of that name for years. I think I had it through version 7 from back in the OS9 days (???) and then got away from it.

Much appreciate your effort.
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 220
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 2330 on October 25, 2018