471,603 Members | 1,581 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,603 software developers and data experts.

replacing an Excel based html chart



I suggested to a friend that a css controlled table would be
preferrable to
the existing chart produced in Excel stored at
http://www.delmarcottages.ca/cottage...gebookings.htm
They mentioned that the Excel chart is not appearing with columns
correct when viewed with Firefox.

My suggestion is stored at
http://www.delmarcottages.ca/cottage.../booking2.html and the
booking2.css is in that directory also. (this page is not visible by
menu
links, its there for storage at the moment)

I suggested using copy and paste for the string that would insert the
word -booked- and directed them to use Notepad++ with colour coding so
this could be located easily

They are not skilled in any html or stylesheet stuff. I wondered if
this routine was simple enough or if there is something else to be
considered. They update this chart about once a month.

I had to resort to setting up an account in google since my server has
turned off all newsgroups following the high level of 'sporge' that
has flooded some newsgroups.

Rose Weir
..
Nov 24 '07 #1
2 1881
----- Original Message -----
From: "RoseW" <wd****@gmail.com>
(snip)
>
I suggested to a friend that a css controlled table would be
preferrable to
the existing chart produced in Excel stored at
http://www.delmarcottages.ca/cottage...gebookings.htm
They mentioned that the Excel chart is not appearing with columns
correct when viewed with Firefox.

My suggestion is stored at
http://www.delmarcottages.ca/cottage.../booking2.html and the
booking2.css is in that directory also.
(snip)
They are not skilled in any html or stylesheet stuff. I wondered if
this routine was simple enough
(snip)

Rose,

Even though they are not familiar with HTML, they should be able to detect
the repeating patterns in the markup and do a cut and paste as you suggest.
To make that a bit less confusing to them, I'd suggest adding new CSS
classes, rather than using inline styling, thus:

In the CSS, add:

td.booked {
background-color: #508fc4 ;
color: white ;
}
td.month {
background-color: #508fc4 ;
color: black ;
font-weight: bold ;
}
td.week {
font-weight: bold ;
}
In the HTML, replace:
<td style="background: #508fc4" ><b>Aug</b></td>
with
<td class="month">Aug</td>

and replace
<td><b>18-25</b></td>
with
<td class="week">18-25</td>

and replace (this is the most important one):
<td style="background: #508fc4;color:#FFFFFF">booked</td>
with
<td class="booked">booked</td>

In each case you would be specifying a styling class with a name that is
meaningful to the user, instead of technical style info that is likely to
confuse them. This also fulfills the philosophical goal of separating the
content (in HTML) from the styling (in CSS).

If this still proves to be too complex for the user, you could annotate the
source such that for each booking (and I would update the page as bookings
came in, not just monthly...) they changed only one obvious line, something
like:

<!-- To specify a slot as booked, replace the current line with the
following one. -->
<td class="booked">booked</td>

<!-- To cancel a booking, replace the current line with the following
one. -->
<td>available</td>
:
:
:
<tr>
<td class="month">July</td>
<td class="week">7-14</td>

<!-- Week of July 7-14, Cottage 1 -->
<td>available</td>

<!-- Week of July 7-14, Cottage 2-->
<td class="booked">booked</td>

<!-- Week of July 7-14, Cottage 3 -->
<td>available </td>

<!-- Week of July 7-14, Cottage 4 -->
<td>available</td></tr>

<tr>

Advantages to the user:
1. Will work in all modern browsers.
2. Significant reduction in file size (less storage space, faster upload
to server, faster response to clients)
3. Improved confidence that they are in control, not the stupid
technology.

And if all else fails, get them to use Word instead of Excel; there is
nothing here that warrants using a spreadsheet.

Chris Beall
Nov 24 '07 #2
On Nov 24, 6:46 pm, "Chris Beall" <Chris_Be...@prodigy.netwrote:
----- Original Message -----
From: "RoseW" <wdm...@gmail.com>
(snip)
I suggested to a friend that a css controlled table would be
preferrable to
the existing chart produced in Excel stored at
http://www.delmarcottages.ca/cottage...gebookings.htm
They mentioned that the Excel chart is not appearing with columns
correct when viewed with Firefox.
My suggestion is stored at
http://www.delmarcottages.ca/cottage...oking2.htmland the
booking2.css is in that directory also.
(snip)
They are not skilled in any html or stylesheet stuff. I wondered if
this routine was simple enough
(snip)

Rose,

Even though they are not familiar with HTML, they should be able to detect
the repeating patterns in the markup and do a cut and paste as you suggest.
To make that a bit less confusing to them, I'd suggest adding new CSS
classes, rather than using inline styling, thus:

In the CSS, add:

td.booked {
background-color: #508fc4 ;
color: white ;
}
td.month {
background-color: #508fc4 ;
color: black ;
font-weight: bold ;
}
td.week {
font-weight: bold ;
}

In the HTML, replace:
<td style="background: #508fc4" ><b>Aug</b></td>
with
<td class="month">Aug</td>

and replace
<td><b>18-25</b></td>
with
<td class="week">18-25</td>

and replace (this is the most important one):
<td style="background: #508fc4;color:#FFFFFF">booked</td>
with
<td class="booked">booked</td>

In each case you would be specifying a styling class with a name that is
meaningful to the user, instead of technical style info that is likely to
confuse them. This also fulfills the philosophical goal of separating the
content (in HTML) from the styling (in CSS).

If this still proves to be too complex for the user, you could annotate the
source such that for each booking (and I would update the page as bookings
came in, not just monthly...) they changed only one obvious line, something
like:

<!-- To specify a slot as booked, replace the current line with the
following one. -->
<td class="booked">booked</td>

<!-- To cancel a booking, replace the current line with the following
one. -->
<td>available</td>
:
:
:
<tr>
<td class="month">July</td>
<td class="week">7-14</td>

<!-- Week of July 7-14, Cottage 1 -->
<td>available</td>

<!-- Week of July 7-14, Cottage 2-->
<td class="booked">booked</td>

<!-- Week of July 7-14, Cottage 3 -->
<td>available </td>

<!-- Week of July 7-14, Cottage 4 -->
<td>available</td></tr>

<tr>

Advantages to the user:
1. Will work in all modern browsers.
2. Significant reduction in file size (less storage space, faster upload
to server, faster response to clients)
3. Improved confidence that they are in control, not the stupid
technology.

And if all else fails, get them to use Word instead of Excel; there is
nothing here that warrants using a spreadsheet.

Chris Beall- Hide quoted text -

- Show quoted text -
Thank you for your input.
The last 4 Advantage points are the type of words I was looking for as
part of the 'why change' <grin>
Also, bringing to attention the annotation routine. I had forgotten
about that within the html context.
I wasn't sure about creating the specific classes but I was aware that
in the copy paste or whatever that errors could evolve with the whole
in-line formatting structure.
Thank you for taking the time, I appreciate the suggestions and will
apply them plus the convincing 'advantages'
Rose
Nov 25 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
reply views Thread by LiuLi | last post: by
6 posts views Thread by frankplank | last post: by
14 posts views Thread by pmud | last post: by
1 post views Thread by Randall Arnold | last post: by
reply views Thread by pmclinn | last post: by
3 posts views Thread by toffee | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by MichaelMortimer | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.