Reading a quotation...
-
Excel does a lot of magic; read theoldnewthing if you want details that you never need. Fun fact; Excel has better VB than the other MS products.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
Read The Old New Thing in any case! Some posts are really entertaining (especially when he tells about crazy legacy issues), and some of it is really useful! (I made an adjustment as late as last night, based on what I read in one old entry about file system tunneling. C++ / Win32 people will find more useful stuff there, there is less of C#/dotNet. But a lot is also general, about Windows in all forms.
-
There is a thing called "Summenerhaltendes Runden" ;)
It does not solve my Problem, but it answers my question
We tried that too, but that's really not an option with prices that can easily be checked by the customer ;)
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
I wonder if by correct they mean no hacks. In some cases hacks are acceptable if undesirable. The real world (deadlines and budget) often intervenes to undercut design, leading to kludges, and also maintenance can lead to kludgy code over time. Maybe by correct they mean with as little of this as possible. If I'm reading it charitably this is how I would interpret it.
Real programmers use butterflies
Yeah, that could be true. However, that doesn't show from the context. It's really just a form that users have to fill out and since they always enter the same thing (everything is fine, if it isn't there's another form) the filling of the form has to be automated :laugh: Filling out the form regularly for all employees is a legal obligation and it could add up to thousands of forms per year. It's really stupid, expensive and time consuming, but it's bureaucracy at its finest :laugh:
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
The quotation mentions rebuilding an Excel sheet to some web application. "This process must be as simple and correct as possible." Not "as correct as possible", just correct. If it's any less correct than "correct" it's not correct :laugh: I wonder, if they mention correctness explicitly at this point, does that mean all other points are assumed to be incorrect by default? :~
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
Is it a case that parts of it are simple (but not correct) and other parts are correct (but not simple)
-
The quotation mentions rebuilding an Excel sheet to some web application. "This process must be as simple and correct as possible." Not "as correct as possible", just correct. If it's any less correct than "correct" it's not correct :laugh: I wonder, if they mention correctness explicitly at this point, does that mean all other points are assumed to be incorrect by default? :~
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
The only thing I can think of is they're warning against overengineering this process? In other words, it maybe could be made "more correct" to catch every single possible error, but the time involved in tracking down those corner cases and implementing a new part of the process is more costly than just having a human fix the spreadsheet when a corner case comes up. Still seems weird; a fix is done once, so its cost is fixed. Manual fixes have an ongoing cost over time.
-
What about "and correct if possible"? ;p Or "and correct if you pay extra for our special 'correctness module'" :cool:
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
Someone did not like the other thread and so it is locked now. I didn't take any offence to what you said and I hope you weren't offended by what I said but someone didn't like it. Anyway, I have no idea how to make it any more clear to you and no, I do not troll. So, we'll have to agree to disagree I suppose.
Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.
-
Someone did not like the other thread and so it is locked now. I didn't take any offence to what you said and I hope you weren't offended by what I said but someone didn't like it. Anyway, I have no idea how to make it any more clear to you and no, I do not troll. So, we'll have to agree to disagree I suppose.
Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.
ZurdoDev wrote:
I didn't take any offence to what you said and I hope you weren't offended by what I said but someone didn't like it.
Me neither :thumbsup:
ZurdoDev wrote:
Anyway, I have no idea how to make it any more clear to you and no, I do not troll. So, we'll have to agree to disagree I suppose.
I got a feeling we agreed on something, but some misunderstanding took it away. So let's say we give it the benefit of the doubt and agree to agree on whatever it is we agreed on ;) :laugh:
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
ZurdoDev wrote:
I didn't take any offence to what you said and I hope you weren't offended by what I said but someone didn't like it.
Me neither :thumbsup:
ZurdoDev wrote:
Anyway, I have no idea how to make it any more clear to you and no, I do not troll. So, we'll have to agree to disagree I suppose.
I got a feeling we agreed on something, but some misunderstanding took it away. So let's say we give it the benefit of the doubt and agree to agree on whatever it is we agreed on ;) :laugh:
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
-
Those little bits can add up :) Here if a product is marked as 4.99 you'll pay 4.95 at the till / cashier, due to us no longer having 2c coins. AFAIK the rounding is only done on the total, but if you wanted to save a few cents you could pay for each product individually.
If we didn't have the 1c piece (penny) here in the US, not too many cashiers would be able to round it correctly to the nearest 5c. It goes to show that we should better fund our education system. Because it is biting us in the rear.
-
I've actually had a customer who wanted VAT on invoices calculated per product, which was completely irrelevant, instead of over the complete invoice. The problem is, you're going to round VAT to two decimals, because no one ever pays €0.001. So by adding up all the VATs for each product we got rounding errors (and those rounding errors added up!). If you calculated the VAT over the entire invoice (like EVERYBODY in that business does) it wouldn't add up. But for some reason they really wanted to have the VAT per product. We went as far as to round to 16 decimal places, but we still ended up with rounding errors :laugh: Ultimately, we actually went for "as correct as possible with x decimal places." In this case "correct" was of course VAT over the entire invoice because that was the only legal kind of VAT :laugh:
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
I had a similar experience years ago. Did a report showing project costs based on hours and rates, shown for each individual on the project, then totaled up to the project, then all projects for each manager, all managers for each director, then a grand total. Since the directors, managers, etc. wanted to see the "real money", everything shown to the (U.S.) cent - no "extra" places shown. Report was pretty nice - controls so each manager or director could only see "their" projects information, could switch between various summary-levels or go all the way into the details, etc. Everyone happy until a new director comes in from HQ Sales to take place of a retiree. He insists that rather than just using the online reports that everyone else loves, it is "required" that PRINTED versions be prepared for all 5 directors every month (remember, he came from HQ so seemingly had to throw his weight around). Each monthly set ran to three 3-inch binders. It would take two admin assistants 2 weeks to get everything printed, copied, collated, and delivered. The other four directors would just sigh and throw the printed copies on a shelf. This guy, however, would go through everything with a fine-toothed comb, as evidenced by him coming to me one month and starting to ream me out because his totals shown in the report summary were off from what he got by adding up every single line-item of every project under him - by $0.02 (of his multi-million dollar monthly budget - this was a pharmaceutical company in the 1980s). Thankfully, the director I was actually working under, who also happened to be the "managing director" and a VP, plus the auditor heard the commotion and came over. Mr. "2-cents" was given a lesson on rounding in reports and asked to explain why he was wasting so much of his time, plus taking a person-month of admin assistant time and 4 feet worth of dead trees looking for these kinds of "problems" rather than actually directing his projects. The reports stopped being printed and copied, and the fine-toothed-comb director was seen out the door shortly afterward.
-
I had a similar experience years ago. Did a report showing project costs based on hours and rates, shown for each individual on the project, then totaled up to the project, then all projects for each manager, all managers for each director, then a grand total. Since the directors, managers, etc. wanted to see the "real money", everything shown to the (U.S.) cent - no "extra" places shown. Report was pretty nice - controls so each manager or director could only see "their" projects information, could switch between various summary-levels or go all the way into the details, etc. Everyone happy until a new director comes in from HQ Sales to take place of a retiree. He insists that rather than just using the online reports that everyone else loves, it is "required" that PRINTED versions be prepared for all 5 directors every month (remember, he came from HQ so seemingly had to throw his weight around). Each monthly set ran to three 3-inch binders. It would take two admin assistants 2 weeks to get everything printed, copied, collated, and delivered. The other four directors would just sigh and throw the printed copies on a shelf. This guy, however, would go through everything with a fine-toothed comb, as evidenced by him coming to me one month and starting to ream me out because his totals shown in the report summary were off from what he got by adding up every single line-item of every project under him - by $0.02 (of his multi-million dollar monthly budget - this was a pharmaceutical company in the 1980s). Thankfully, the director I was actually working under, who also happened to be the "managing director" and a VP, plus the auditor heard the commotion and came over. Mr. "2-cents" was given a lesson on rounding in reports and asked to explain why he was wasting so much of his time, plus taking a person-month of admin assistant time and 4 feet worth of dead trees looking for these kinds of "problems" rather than actually directing his projects. The reports stopped being printed and copied, and the fine-toothed-comb director was seen out the door shortly afterward.
Navanax wrote:
The reports stopped being printed and copied, and the fine-toothed-comb director was seen out the door shortly afterward.
I'm glad this story at least has a happy ending :D
Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly
