Can't DataOne computer add?

[perumal]

Why doesn't BSNL also give the total bandwidth usage for the month (up-to-the-day) on the top apart from the individual records? I get irritated by adding my daily usage in KB and dividing by 1024 to get my daily usage in MB and then adding it to the up-to-date cumulative MB. At present I copy / paste my daily records on to a MS-Word file (pastes as a table) and then add using the table formula. Each table can be attached to the earlier one by just deleting the line space in between them.May be this is also a ploy to cheat the customer who finds it difficult to add. Or am I missing a point here?

 

[vikikivi]

Yeah I added manually and somewhere i had put an extra zero in the middle of some number. Damn !! I reached 1040 MB by 24th itself. I was wasting time in my RELIANCE DIALUP till 31st. On aug 1st , i rechecked the total and it was just 920 MB. Tat xtra ZERO somewhere , cost me a lot !! I wasted 120 MB. Damn

 

[bugatti]

I too, am quite peeved with this format of presentation by bsnl. Why the heck are they presenting data in KB? I am not relying on the dataone site figures for now as I use DU meter but if large scale discrepancies turn up then I might have to go the manual way too.

 

[skfg60]

I am really surprized how you people living day with this all sort of counting bytes then divididing by 1024, all disgusting.

 

[abdulrahman004]

..Only if u had a BSNL connection u cud understand

 

[bugatti]

skfg60, seems like you are the long lost brother/close relative of shakuntala devi. Pray, how else do we calculate the data usage presented on the dataone site?

 

---

[puja399]

Can't someone write a program that can read the webpage and autocalculate the download?

 

[perumal]

How I make the computer add for me:1. Start MS-Word and then only2. Start Internet Explorer, login and go to the account details page3. Select the day's records right from the first column4. Copy the day's records into clipboard (ctrl+c)4. Paste into Word (on top) - ctrl+v - and you will paste a table automatically5. Delete the blank line and the tables get automatically merged6. First time insert the formula : Table, Formula, =SUM(ABOVE)/10247. Next time onwards just click on the total and do the same as step 6 and you don't need to enter the formula.Screen shot attached.All these crap can be avoided if only they give the total. But for the time being it helps me a lot to keep myself in control. Dial-up meter info shows a higher figure for me. So I go for the 'actuals'.

 

[Sushubh]

excel would be easier. it even can logon to that page download the latest version of the table and update the cells with the formulaes.

 

[vikikivi]

No. Copy , paste didnt work for me. Coz the format is something else. I even tried changing the format to number and tried many other formats. But excel didnt recognize it as a number field itself.

 

[Sushubh]

tried telling excel that the fields are numbers?

 

[skfg60]

Don't calculate the data consumed too frequently as it will also consume some bytes. If you calculate on daily basis, at the end of the month it may add another 0.5 MB i.e. Rs. 1.00 extra. Pathetic ..............

 

[srrao]

I use DU and kept on comparing DU data with BSNL and always found DU reported more than BSNL.Sandeep

 

[vin]

Originally posted by [email protected] 7 2005, 03:27 PM
No. Copy , paste didnt work for me. Coz the format is something else. I even tried changing the format to number and tried many other formats. But excel didnt recognize it as a number field itself.
[snapback]20246[/snapback]

[/quote]

Copy the portion to be added from excel to a MSword page.

On the word page EDIT->REPLACE Replace box will open. select "MORE".
then select "SPECIAL"

In the options select "WHITE SPACE" In the" FINDWHAT" Line "^w" will appear

Leave the "REPLACE WITH" line emty.

Now apply "REPLACE ALL". Replcement message will appear.

Copy the portion, paste back in a seperate excel column and add by excel formula.

 

[rooo12]

there will be one space after the number which you have to delete for excel to recognise flow column as number