|
Thanks for the tip 
Waddatah
|
|
|
|
|
In Excel worskheet how to find out that a particulat cell is selected or not ?
|
|
|
|
|
You posted the same question 2 hours ago. Once is enough. I think you should supply some more information in your other thread. How are you trying to access the Excel file etc?
|
|
|
|
|
In the Excel worksheet, WHen user selects cells randomly with CTRL key pressed , I need to get those cell inormation like row/column position and data in those cells.
I am able to do this when the user selects the cells sequentially like index 0,1,2 ..etc with the help of Worksheet range object.
But If I do the same selection of cells randomly using CTRL key, there is no range is available and I need to get the info of these cells.
Hope I am clear now..
Thanks,
Rajan
|
|
|
|
|
Since morning I am not able to access my database. It is marked as Suspect. The server was down in the morning and when it was on , I tried to access my database. However, now I am not able to access it. I even tried searching for the .mdf file. But, I am not able to find it. I've no latest backup of my database. Now, if I dettach the database from the server or run sp_resetStatus commnad then, the database might not get recovered. So, please help. I need to fix it asap so that I could start my work.
|
|
|
|
|
This does not seem to be a C# question. You have the wrong forum!
|
|
|
|
|
Hi,
I want to disply each row of datasource as a column of gridview control in C# windows form.
I'n new to this. can anyone help me?
thanks in advance
regards
sri
|
|
|
|
|
Hello everyone,
Here is my simple bonus assignment program. The issue I met with is, the ResultTotalReceived is larger then ResultTotalSent, which violates corporation policy and exception is thrown.
The program works in this way,
1. At source side, calculate and assign the bonus according to each worker's factor (100F for worker1 and 300F for worker2 in my sample). All figures are float type.
2. Convert the float type to string and sent to another destination to store the bonus into storage;
3. The detination side will perform basic checking rules before storing the data, e.g. the total bonus assigned should not exceed the total bonus available at source side.
In my code below,
The value of ResultTotalSent is 199.321, and the value of ResultTotalReceived is 199.321045, which is larger than ResultTotalSent.
My questions is,
1. If I want to solve this issue at source side, what is the elegant way to solve this issue? Currently, my temp solution is using ToString("F2"). Any issues with this solution?
2. Why there is such issue? It is the issue of ToString of Float class -- I have this suspecision is because ResultTotalSent is precise but after ToString conversion the result and conversion back at detination side, it is not precise?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace TestFloat
{
class Program
{
static void Main(string[] args)
{
float TotalBonus = 199.321F;
float Worker1 = 100F;
float Worker2 = 300F;
float Result1 = TotalBonus * Worker1 / (Worker1 + Worker2);
float Result2 = TotalBonus * Worker2 / (Worker1 + Worker2);
float ResultTotalSent = Result1 + Result2;
string Result1String = Result1.ToString();
string Result2String = Result2.ToString();
string ReceivedString1 = Result1String;
string ReceivedString2 = Result2String;
float Received1 = float.Parse(ReceivedString1);
float Received2 = float.Parse(ReceivedString2);
float ResultTotalReceived = Received1 + Received2;
return;
}
}
}
thanks in advance,
George
|
|
|
|
|
The reason this issue exists is because computer processors use binary for arithmetic calculations with a floating decimal point - new chips are being created which do arithmetic calculations in decimal and with these chips there is no rounding error.
You could use decimal instead of float as it has a greater precision but a smaller range(this should not cause a problem unless you are calculating M$ executive bonuses).
The issue is basically to do with how chips are constructed - with decimal arithmetic chips in the pipeline this issue will hopefully soon be history.
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
Thanks GuyThiebaut,
Why decimal will not have rounding errors? Interested to learn. 
I understand how float is represented in memory and I have read the article about float, but no knowledge about how decimal is represented.
http://docs.sun.com/source/806-3568/ncg_goldberg.html[^]
regards,
George
|
|
|
|
|
Hi,
I don't understand how it works, it's more that I have faith that it works based on a super brainy colleague's assertions.
I did find a link clickety that may illuminate the matter for you.
Regards
Guy
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
Thanks Guy!
1.
I have made some further test. I want to use float.Epsilon to check whether the result is the same -- if the differences between two float numbers are smaller than float.Epsilon, I will treat they are the same. But my code is not working. Any ideas?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace TestFloat
{
class Program
{
static void Main(string[] args)
{
float TotalBonus = 199.321F;
float Worker1 = 100F;
float Worker2 = 300F;
float Result1 = TotalBonus * Worker1 / (Worker1 + Worker2);
float Result2 = TotalBonus * Worker2 / (Worker1 + Worker2);
float ResultTotalSent = Result1 + Result2;
string Result1String = Result1.ToString();
string Result2String = Result2.ToString();
string ReceivedString1 = Result1String;
string ReceivedString2 = Result2String;
float Received1 = float.Parse(ReceivedString1);
float Received2 = float.Parse(ReceivedString2);
float ResultTotalReceived = Received1 + Received2;
if ((ResultTotalReceived - ResultTotalSent) < float.Epsilon)
{
Console.WriteLine ("Treated the same. ");
}
return;
}
}
}
2.
Your referred link is great! But it is about float calculation. My question is about Decimal. Any comments?
regards,
George
|
|
|
|
|
Hi,
All I can say is that when I googled C# decimal and float I came across an article saying always use decimal for financial calculations due to the issue you are coming up against.
Sorry I can't be of more help - busy at the moment...
Regards
Guy
Continuous effort - not strength or intelligence - is the key to unlocking our potential.(Winston Churchill)
|
|
|
|
|
Thanks all the same, Guy!
regards,
George
|
|
|
|
|
MSDN[^] briefly explains how decimal numbers are used in one paragraph. Comparing the data there to some of the data in the document Guy referenced pretty much explains it for me.
I don't have a mathematics degree and I don't claim to understand it all, but it seems to makes sense.
Bottom line - if accuracy is critical - use decimal! 
Dave
|
|
|
|
|
Thanks Dave,
My question is, I think using Decimal is a great idea to reduce rounding errors, but can not completely reduce rounding errors compared with float/double, for example, no matter how large data type you are using, you still can not represent 3 divide 10 in precise. Any comments?
regards,
George
|
|
|
|
|
I think you meant 10 divided by 3?
If so - try this:
float a = 10f;
float b = 3f;
float c = a / b;
decimal d = 10m;
decimal e = 3m;
decimal f = d / e;
Console.WriteLine("Float Result: " + c);
Console.WriteLine("DecimalResult: " + f);
There is a finite limit to the precision a computer can provide due to the way the data is stored and manipulated. After all, we want to deal with large numbers with large numbers of decimal places that we think about in base 10. A processor can in reality only deal with two numbers - 0 and 1. Putting many of these bits together gives it the apparent capability to do so much, but it's basically still just crunching 0s and 1s - which means until we stop having fractions, start thinking in binary (base 2), octal, hex ...., and have unlimited memory and processor address busses then we can never get total precision.
Dave
|
|
|
|
|
Thanks Dave,
I have tried the result is,
Float Result: 3.333333
DecimalResult: 3.3333333333333333333333333333
So, the conclusion is Decimal can reduce, not can not completely solve ths rounding issues we found in float data type computing, right?
regards,
George
|
|
|
|
|
If accurate calculation is required as it is with most payment/bonus/currency systems then always use decimal.
Dave
|
|
|
|
|
|
This is actually the subject of a book or two... and you haven't yet noticed that when using binary floating-point (as in float or double), numbers that look fairly simple (like 0.1) using decimal notation look more like PI using binary notation (0.1 converted to binary has an infinite number of binary decimals and thus cannot be represented exactly using a binary floating-point type).
In any case - here are some rules of thumb (coming from years of building business software doing monetary calculations using binary floating-point types):
- After each step in a calculation, round the result to the desired number of decimals (depends on currency - different currencies have different number of decimals - and in some cases such as invoice totals, you have no decimals depending on local traditions).
- When doing comparisons, never compare for equality (0.1 stored as a double will NOT equal 0.1 stored as a float, for instance). Instead, make sure the difference is within an acceptable range.
Examples:
double total = 0;
foreach (row in rows)
{
row.Amount = Math.Round(row.Quantity * row.UnitPrice, 2);
total = Math.Round(total + row.Amount, 2);
}
if (Math.Round(Math.Abs(a - b), 2) < 0.001)
{
}
if (Math.Round(b - a, 2) > 0.001)
{
}
And so on... Note that my using 0.001 is an assumption that any round-off errors (after rounding to two decimals, which is the norm for Swedish currency) will be less than that. Using double (and not working on extremely large amounts), this is normally true.
To a "computer math expert" (I used to be one a long time ago) these rules are somewhat naïve and over-simplified, but they do work well for simple financial calculation (such as totaling an invoice and so on). The goal in such circumstances isn't to be as mathematically accurate as possible but to get the same result a person using a financial calculator would (you don't want customers calling in telling you that you can't add properly).
The examples all fulfill that requirement.
If you're interested in more about how binary floating-point works, try looking for a good book on it - it's not a small subject(actually, it's a career for some). I take it you're a CS student? If so, ask your teacher - he or she should be able to point you in the right direction (I no longer know what's current). It's a very interesting field - at least I thought so when I studied (and worked as an assistant teacher in) numerical analysis almost 30 years ago...
Peter the small turnip
(1) It Has To Work. --RFC 1925[^]
|
|
|
|
|
Thanks Peter,
Your reply is really great! I posted my code below again. My confusion is, why the ToString method will do the rounding work? I think it should be the float number calculation which will do the rounding work.
In my sample, you can see in the float calculation,
float Result1 = TotalBonus * Worker1 / (Worker1 + Worker2);
float Result2 = TotalBonus * Worker2 / (Worker1 + Worker2);
there is no rounding in Result1 and Result2.
But in the ToString method,
string Result1String = Result1.ToString();
string Result2String = Result2.ToString();
There is rounding for Result2String. Any ideas?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace TestFloat
{
class Program
{
static void Main(string[] args)
{
float TotalBonus = 199.321F;
float Worker1 = 100F;
float Worker2 = 300F;
float Result1 = TotalBonus * Worker1 / (Worker1 + Worker2);
float Result2 = TotalBonus * Worker2 / (Worker1 + Worker2);
float ResultTotalSent = Result1 + Result2;
string Result1String = Result1.ToString();
string Result2String = Result2.ToString();
string ReceivedString1 = Result1String;
string ReceivedString2 = Result2String;
float Received1 = float.Parse(ReceivedString1);
float Received2 = float.Parse(ReceivedString2);
float ResultTotalReceived = Received1 + Received2;
if ((ResultTotalReceived - ResultTotalSent) < float.Epsilon)
{
Console.WriteLine("Treated the same. ");
}
}
}
}
regards,
George
|
|
|
|
|
Hi again,
I didn't test your code (no time), but I suspect that you see a different number of decimals in the results? If so, count the digits, not the decimals. The type float only gives you 7 digits of precision, so the ToString() stops producing decimals once you have that many significant digits (as the rest would just be zeros). If you want a different layout, use a format string with ToString().
Side note: You should use double in almost all cases, as the precision of float is usually not enough for any serious monetary calculations.
Peter the small turnip
(1) It Has To Work. --RFC 1925[^]
|
|
|
|
|
Thanks Peter,
PeterTheSwede wrote: The type float only gives you 7 digits of precision
But, Result2 as a float type, could have 9 digits in debugger, why when converting to string, it loses precision?
regards,
George
|
|
|
|
|
The reason for the 7-digit precision in ToString() is that the ULP for float is 2^-23 (approximately 10^-7). Showing more digits is generally misleading. However, the internal precision can sometimes be larger, up to a maximum of approximately nine digits, which is probably (wild guess) the reason the debugger chooses to show that many.
This is only briefly explained in the help for System.Single, but for a reasonably good definition of ULP and floating point arithmetics, look here[^].
Then again: Never use float. Use double. Except possibly at gunpoint. Consider float to be obsolete. And remember that in SQL Server, float is double and real is single (go figure).
Peter the small turnip
(1) It Has To Work. --RFC 1925[^]
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
