473,473 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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 1964
----- 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet...
0
by: LiuLi | last post by:
Hi, Recently, I developed some code to export DataGrid to excel base on the html stream technology. But that one works only with worksheet cell. Is there any way to output Excel Chart based on...
0
by: mscir | last post by:
Date: Thu, 08 Jul 2004 17:02:27 -0700 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <10ero4l3kp2qa65@corp.supernews.com> Reply-To: mscir@usa.com User-Agent: Mozilla/5.0...
6
by: frankplank | last post by:
Hi *, I'm wondering if it is possible to create a C# object, and reference it *explicitly* in an excel document. I imagine this will be more possible if I programmatically populate the excel...
14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
1
by: Robin Tucker | last post by:
Heres and interesting problem: I have a VB.NET program that creates reports via. Word Automation. This all works fine. What I want to do as part of this report generation process is to embed a...
1
by: Randall Arnold | last post by:
I'm converting a vbscript program to vb.net. Witht he exception of .net idiosyncrasies, most of it is working well with the same code. My only problem is that some properties and methods are...
0
by: pmclinn | last post by:
The code below takes the data from the S column and grabs all the data and graphs it. The problem is this example grabs 500 cells worth of data and some of these cells = nothing. How do I rescope...
3
by: toffee | last post by:
Hi all, I got a pre-formatted spreadsheet. would it be possible using js to copy the data from a table on the current webpage, open the spreadsheet and paste the content ? if so, anyone got any...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.