Posted by The Natural Philosopher on 01/08/08 15:52

donh 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?

Not alone no, but you can sure make an HTML table look as ghastly as a
spreadsheet.


> 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.
>
> Any pointers would be appreciated.

Displaying alphanumerics in tables is something web does well.

Doing on the fly computation between cells is javascript.

Not exactly sure what the application is, but it sounds like nasic
php/mysql and a knowledge of HTML will get youy there. May take time and
effort tho.

Displaying the data is a lot easier than writing a form to enter in INTO
the database the first time..

>
> Don

[Back to original message]