Posted by Rik Wasmus on 01/08/08 15:40

On Tue, 08 Jan 2008 16:36:20 +0100, donh <donhartuk@gmail.com> wrote:

> Hi Group,
>
> I normally use excel and have no knowledge as yet of php. I have an
> excel spreadsheet which is used for monitoring staff levels and
> availability. Dates (per month) along top, Workers at site in rows
> down left, their availability at intersections of rows and columns.
> The sheet works well until you try to share over a corporate network,
> and I think it would be better off in a database, ie mysql. I know a
> little about access and have been able to get a similar look using
> Pivot tables in Access but would like to get the database web based
> using a mix of php mysql if I can.
>
> Can php make mysql look like a spreadsheet table as described above?

Yes, COM on Windows platform.

> The benefit Excel brings to the workers is the ability to see who is
> working for the whole month at a given location and how it affects
> staffing levels, I really would like to try and keep a consistent look
> if I can.

You also might want to check wether having MySQL as an external (ODBC)
datasource isn't more efficient. One time download, always up to date, but
more network traffic/setup on the computer required.
--
Rik Wasmus

[Back to original message]