|
|
Posted by donh on 01/09/08 08:06
On 9 Jan, 00:58, NC <n...@iname.com> wrote:
> On Jan 8, 7:36 am, donh <donhar...@gmail.com> wrote:
>
>
>
> > 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, but it may be too much work for your situation. I would
> recommend that you simply save your Excel spreadsheet as an HTML file
> and upload it onto your corporate network. If you are the only one
> making changes to the source spreadsheet, it should work. There's no
> need to build a DB-driven application out of it, unless there are
> multiple users that have to make changes...
>
> Cheers,
> NC
Thanks for your reply. Sadly I'm not the only person to enter data,
as local managers have the need to update local staffing levels. It
was this diversity of user and lack of sharing of live data that is
making Excel difficult to use in this instance.
Regards
Don
Navigation:
[Reply to this message]
|