473,237 Members | 1,179 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,237 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 1954
----- 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...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.