Need help with script - average calcs
22 posts, 6 voices
mornaistar
User
|
I have this table on a website:
I want this script to be able to calculate average clicks by each ref and put it on a new column , after the "clicks" column.
Anyone can help me on this?
Thanks alot |
Aquilax
Scriptwright
|
Ok I will help you: the average of one value is equal the the value self. |
lucideer
Scriptwright
|
Right... I'm assuming you've worded your request wrongly and you want something different. Do you want the overall average of the rows, or is there some other information outside of the table that you need to take in. Otherwise, I second what Aquilax said. |
|
mornaistar
User
|
maybe I've made a bad explanation.
sorry for my bad explanation but my english isn't that good :S |
|
mornaistar
User
|
"average of clicks the users click per day" |
|
mornaistar
User
|
http://img206.imageshack.us/img206/6154/afoiaed... Here goes another image , this one is made by a software that does the calculation part exactly like i need, in this case , i want the "2.03" to show right near the clicks value in the website table. like 114 clicks ( 2.03) |
Mikado
Scriptwright
|
You know what? Looking at number of your referrals, I think you've spammed a lot of forums with your ref links. Now you're coming to one of such forums to ask for a tool that will help you insult people more effectively. What would you expect? |
|
Aquilax
Scriptwright
|
Ah, I've forgot: asking to make a script from a picture is like asking to reach the moon with a paper sheet, you have to fold it to half only 46 times. |
|
mornaistar
User
|
mikado what are you talking about?
but as i can see this community is a bit weird when it comes to say useful things. a moderator or an admin can close this topic. have a nice day |
|
Aquilax
Scriptwright
|
Hey, how much do you know about users scripts? I think you have no idea but them! Look at the other requests, they post url and html code, you have posted a picture. If you want some help you need to give something more concrete. |
|
lucideer
Scriptwright
|
@Mikado
Beyond that, please enlighten me as to any evidence as to mornaistars guilt? @Aquilax:
how much do you know about users scripts? Well... if he mornaistar knew more about UserScripts, he might not need to post in this (the script requests) forum. He might be able to do it himself. You can't assume people posting here will know how to "post url and html code" as you say. For some people an image is the best way they can communicate. @mornaistar
|
|
mornaistar
User
|
@lucideer: thanks for the gentle reply, in fact i did not spammed the forum or any other forum in any way, all my refs were bought. I wouldn't go against the TOS in any website. @Aquilax: i'm sorry if my request wasn't that clean. but i believe posting a url won't help because this website requires an account to be on that table. once again really sorry. as it's really hard to explain what i want and i'm not sure if i can post the website html in a public way, would it be possible for you to add me on msn so i can explain it more precisely. arcaiola [@] h o t m a i l DOT com if you can't add for some reason , please post here something and i will ask admin if i can post here more about the table code itself. thanks alot |
|
mornaistar
User
|
@lucideer: i know i'm a bit confusing while explaining something sometimes http://img156.imageshack.us/img156/6852/example... does this new image help in any way?
thanks alot |
|
Aquilax
Scriptwright
|
When you are on the page press ctrl-u or from the menu-->View-->Page Source.
|
|
mornaistar
User
|
<table width="100%"><tr><td width="50"> |
|
lucideer
Scriptwright
|
Well.... I've no way of testing any code here... so. If this doesn't work, you'll have to give debugging a go yourself.
(function(){
// get an array containing a reference to the 1st cell in each row
var rowRefs=document.evaluate('//td[contains(@class,"l1 z w")]',document,null,6,null);
// initialise an object call table that will contain the table
var table={'row':[{'cell':[]}]};
// loop over our "rowRefs" array
for(var i=0,ii=rowRefs.snapshotLength;i<ii;++i){
var j=1,table.row[i].cell[0]=rowRefs.snapshotItem(i); // set 1st cell in "table" obj to 1st cell
while(currCell=table.row[i].cell[0].nextSibling){ // traverse across the DOM of each row
if(currCell.nodeType==1){
table.row[i].cell[j]=currCell; //store each cell in our "table" obj
j++; // advance counter
}
}
}
// all the above code gets an object "table" containing ONLY cells of each row, no textNodes, etc.
for(var i=0,ii=table.row.length;i<ii;++i){ // loop over our "table" obj
var startdate=table.row[i].cell[2].textContent.substr(0,10); // third cell has date
var today=new Date(); // todays date
var diff=Date.parse(today)-Date.parse(startdate); //get the difference in seconds
diff=diff/86400000; // get the difference in days
var average=row.childNodes[5]; //sixth cell
var newCell=document.createElement('td');
newCell.appendChild(document.createTextNode(average));
table.row[i].appendChild.insertBefore(newCell,table.row[i].cell[5])
}
})();
|
|
mornaistar
User
|
thanks alot, i will go test it and give feedback =) |
anonymous_user
User
|
I found this topic usefull as I "want" the same thing as described by mornaistar, I think he sums up the thing really well with the last image.
Thanks lucideer for your code, since the last time I coded something was about 10 years ago. So, i did run the script and came with this error
and... var rowRefs=document.evaluate('//td[contains(@class,"l1 z w")]',document,null,6,null); // there are more classes than l1 z w, they are four in total /*
So if anyone could help, I will also post progress as I study and read info about coding scripts. Thanks |
|
anonymous_user
User
|
Ok, I'm stuck. I cannot fix the error I described in the last post and I also don't know how to include all the 4 class when using document.evaluate, i'm not good at regexp. Could someone help? Please. |
gollum
Scriptwright
|
Without a link it's hard to test, but maybe you could make the @class lookup more general
|
|
lucideer
Scriptwright
|
As gollum says it really is like clutching in the dark without a link to test. That code I wrote above is completely untested on anything so even though I've now corrected the .cell .cells typo (thanks gollum), there could be more problems with it. @georgie
P.S. |
|
anonymous_user
User
|
I've just read your answers and going to test out the changes. About you being able to test it for yourself, as this is a https page with login, is it enough if I save a static html version of one page and put it on my webserver so you can test it?
Thanks for your time. |
</td><td><table width="100%"><tr><td>
</td><td>
</td><td>
</td><td>
</td><td>
</td></tr></table>
</td><td>
<input /></td></tr><tr><td class="l2 z x"></td></tr><tr><td class="l1 z w">3</td><td class="l1">R2670264 <td class="l2">2008/08/13 at 19:18 </td><td class="l2">33 days, 1 hours, 59 minutes </td><td class="l2">Today </td><td class="l2">32 </td><td class="l2"> 
