Thanks for the advise. I'll give it a shot, but I don't hold out much hope,
as I know it's going to be way beyond my skills. The original file has built
in at overtime % if desired to use, and an unscheduled % to use if desired.
Also, it will prioritize consecutive days off, however, it gives you the
option to accept non-consecutive days off, or decline that option, and builds
the schedules required accordingly. And, to add another 'beyond me' aspect,
if you accept non-consecutive days off, it will always make Sunday one of the
days off, e.g. Sun/Wed or Sun/Thurs. All the above is why I was hoping there
would be a way to convert the existing DOS file to Excel, but I guess that's
not going to be possible.

Thanks again for all your patience and advise.

Steve

"ilia" wrote:

If you already have data in the program, but you cannot find its data
file (or if it keeps it within the exe, which is also possible), you
won't be able to import that data into Excel. However, if you want to
build a scheduler in Excel that does something similar, that's
entirely possible. However, I would suggest you look into using
software like Microsoft Project or something.

You can set up a spreadsheet that lists employees and their days off.

Name Mon Tue Wed Thu Fri Sat Sun
xxxxx off off
xxxxx off off


Then, using a formula, you can have the number of employees
available. Supposing in the above example column B is mondays, this
will give you the number of employees who are off:

=COUNTIF($B:$B,"off")

This will give you the number of employees available on Monday:

=COUNTA($A:$A)-COUNTIF($B:$B,"off")-1

You can have another worksheet where you use a combination of MATCH()
and OFFSET() functions to calculate what you have available, what
you're using, and what's remaining.

Hope that helps at all. At the very least it will get you started.




On Nov 13, 4:07 pm, Steve wrote:
No, not that I'm aware of . Just a 61 KB size file. It's basically a day off
scheduler.

I indicate that , e.g., I need 7 employees on Sat, 3 on Sun, 8 on Mon, etc.,
and it provides a work schedule such as 2 have Sat/Sun off, 5 have Sun/Mon
off, 6 have Mon/Tue off, etc.

Thanks,



"ilia" wrote:
That's a program. Does it keep a data file somewhere?

On Nov 8, 4:58 pm, Steve wrote:
exe

"Gary''s Student" wrote:
Probably......What is the file extension of the DOS file?
--
Gary''s Student - gsnu200755

"Steve" wrote:

Sorry if this probably isn't the correct group, but I have an old DOS
employee scheduler, and would like to convert it to Excel. Is that possible,
and if so, how would I go about getting it converted. I have no idea in what
language it was written in.

Thanks in advance,

Steve- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -