I would like to provide all my members 35 000 ordinary consumers with high energy bills) with a system for keeping track of their use of energy and water by reporting meter readings every month. The readings are compensated for day of reading and also the local temperature during the month ("degree-days")
In step one I am only looking for management of meter readings & graphic representation per month of consumption. No consideration of prices and tariffs are needed.
I need to work on a project with a state map with associated counties. On clicking a county, it should give the summary stats of crime for that county on a box on the page. On double clicking a county a new page with detail crime summary for that county should pop up.
I have SQL database and ASP web pages. I want to make some statistics for tables in the database, and if possible I want also some charts such as MS Excel. Is there an easy way to do so in ASP (using Macromedia Dreamweaver) ?
I am trying to do basic statistics for a site. all I want is a list of unique hits (per page) by date. I would prefer to do the statistic software in asp but I don't want to have to change all the pages to .asp so I want something that could be hit using a hidden image or javascript. Does anyone have similar code they have done?
I want to keep control of the statistics about my website, but I don 't want to loose previous hits (if I 'm not mistaking they are kept in the log-files?). I want to know how many visitors are online.
how many visitors my website (a specific page) has had today, this month and the total amount of visitors. This cannot appear however on the page itself, but on a password-protected page.
Can you think of a few possible ideas of displaying the data, and giving the SQL query(s) for it? Something like, SELECT AVG(loadtime) AS averageload FROM stats.
I know very little about log files, but I really want some accurate way to track users on my site: referrals,hits/sessions, browser types, etc. I think the best way to do that is via the log files which I can see on the webserver but I don't know the best way to access and analyse them.
I have build a content management system based on Access/ASP and I'd like to try and incorporate site stats.
In database exist survey results. Specific results from multiple choice - multiple answer survey (checkbox) are in tbl_results table (example excerpt):
table answers has ID numbers of answered answers, delimited. Anybody has solution to use those ID numbers as foreign key against table tbl_answers, in order to make possibility to make query for better statistics .
I would like to do is to generate statistics from my access db.
Within the db there are fields for each of the 11 plaers in the team each week, i.e. p1, p2, p3 ...... in each one will be a name, i.e Bill Bloggs but the name could appear in any one of the 11 fields.
What I would like to do is count the number of occurances of bill bloggs in the 11 fields and return it on my site as a table, i.e.;
I have on my website tutorials. There are 6 tutorials. I have a table in my databse for registered users. I wish to know the statistics for these users. That is the time each user has spend on each of these tutorials. eg. a statistics like
Authorized user1: Tutorial1: 30 min. Tutorial 2: 15 min. . .
Like this. I have allotted about 100 hours for each user, so I need to maintain this statistics so that I come to know that how many hours have been used and how many hours are still left. Can somebody guide me how to go about it.