Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Reading a quotation...

Reading a quotation...

Scheduled Pinned Locked Moved The Lounge
csharpjavascriptcloudcsslinq
38 Posts 19 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Sander RosselS Sander Rossel

    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

    J Offline
    J Offline
    Jacquers
    wrote on last edited by
    #7

    Correct to how many decimal places? ;) ;P

    Sander RosselS 1 Reply Last reply
    0
    • Sander RosselS Sander Rossel

      Correctness is a feature, after all ;)

      Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

      P Offline
      P Offline
      PIEBALDconsult
      wrote on last edited by
      #8

      Correctness costs money and hinders performance.

      1 Reply Last reply
      0
      • J Jacquers

        Correct to how many decimal places? ;) ;P

        Sander RosselS Offline
        Sander RosselS Offline
        Sander Rossel
        wrote on last edited by
        #9

        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

        J Richard DeemingR L N 4 Replies Last reply
        0
        • Sander RosselS Sander Rossel

          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

          J Offline
          J Offline
          Jacquers
          wrote on last edited by
          #10

          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.

          F Sander RosselS J 3 Replies Last reply
          0
          • Sander RosselS Sander Rossel

            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

            Richard DeemingR Offline
            Richard DeemingR Offline
            Richard Deeming
            wrote on last edited by
            #11

            At least in the UK, it's perfectly fine to do it either way: 17.5 Calculation of VAT on invoices - rounding of amounts[^] Calculating per line makes it easier to deal with invoices where different products attract different VAT rates. And if you calculate and round per line, you sometimes end up paying slightly less VAT. :)


            "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

            "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

            G 1 Reply Last reply
            0
            • Sander RosselS Sander Rossel

              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

              Z Offline
              Z Offline
              ZurdoDev
              wrote on last edited by
              #12

              Sander Rossel wrote:

              If it's any less correct than "correct" it's not correct

              That is the most true statement I've ever read.

              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.

              S 1 Reply Last reply
              0
              • Richard DeemingR Richard Deeming

                At least in the UK, it's perfectly fine to do it either way: 17.5 Calculation of VAT on invoices - rounding of amounts[^] Calculating per line makes it easier to deal with invoices where different products attract different VAT rates. And if you calculate and round per line, you sometimes end up paying slightly less VAT. :)


                "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

                G Offline
                G Offline
                GuyThiebaut
                wrote on last edited by
                #13

                So in practice you could get that new car invoice to be itemised by the atom and because HMRC allows you to round down there would be no VAT to pay :-D

                “That which can be asserted without evidence, can be dismissed without evidence.”

                ― Christopher Hitchens

                OriginalGriffO D 2 Replies Last reply
                0
                • Sander RosselS Sander Rossel

                  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

                  OriginalGriffO Offline
                  OriginalGriffO Offline
                  OriginalGriff
                  wrote on last edited by
                  #14

                  You're starting to sound like EA Games ... DownLoadableCorrectness, anyone?

                  "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!

                  "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                  "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                  Sander RosselS 1 Reply Last reply
                  0
                  • G GuyThiebaut

                    So in practice you could get that new car invoice to be itemised by the atom and because HMRC allows you to round down there would be no VAT to pay :-D

                    “That which can be asserted without evidence, can be dismissed without evidence.”

                    ― Christopher Hitchens

                    OriginalGriffO Offline
                    OriginalGriffO Offline
                    OriginalGriff
                    wrote on last edited by
                    #15

                    I have a small feeling HMRC may see it slightly differently ... :~

                    "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!

                    "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                    "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                    1 Reply Last reply
                    0
                    • Sander RosselS Sander Rossel

                      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

                      J Offline
                      J Offline
                      Jacquers
                      wrote on last edited by
                      #16

                      Search results I saw on a page recently: About 18 games found :laugh:

                      K 1 Reply Last reply
                      0
                      • Sander RosselS Sander Rossel

                        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

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #17

                        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.

                        K 1 Reply Last reply
                        0
                        • G GuyThiebaut

                          So in practice you could get that new car invoice to be itemised by the atom and because HMRC allows you to round down there would be no VAT to pay :-D

                          “That which can be asserted without evidence, can be dismissed without evidence.”

                          ― Christopher Hitchens

                          D Offline
                          D Offline
                          Daniel Pfeffer
                          wrote on last edited by
                          #18

                          GuyThiebaut wrote:

                          itemised by the atom

                          That would be a long invoice. :)

                          Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.

                          1 Reply Last reply
                          0
                          • J Jacquers

                            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.

                            F Offline
                            F Offline
                            fd9750
                            wrote on last edited by
                            #19

                            Not around here as mathematically correct rounding is applied here. 4,99 and 4,98 will result in 5,00. 4,96 and 4,97 will become 4,95. Unless you pay with your debet/credit card then it remains whatever it is.

                            1 Reply Last reply
                            0
                            • J Jacquers

                              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.

                              Sander RosselS Offline
                              Sander RosselS Offline
                              Sander Rossel
                              wrote on last edited by
                              #20

                              Over here, in a store (for example, supermarket), VAT is included in the product price. So 500 gr. (pre-packaged) grapes costs €2.19 incl. VAT. If you buy two packs, you pay €4.38. If you pay cash everything is rounded to 5 cents, so €4.38 would become €4.40, but €4.37 would be €4.35. I can't remember the last time I paid cash at a store :D This particular company sold meat (wholesale), so a customer would order five ribs, but they would pay per kg. The customer gets an estimated price, based on what my customer sent them, then that customer would weigh everything again, and that weight was invoiced. Naturally, you don't know the VAT until the actual invoice. And since the VAT isn't included in the individual prices, like in a supermarket, you really can't do anything other than calculate VAT over the entire invoice :D It's how I invoice too, and pretty much every business in the Netherlands.

                              Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                              1 Reply Last reply
                              0
                              • OriginalGriffO OriginalGriff

                                You're starting to sound like EA Games ... DownLoadableCorrectness, anyone?

                                "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!

                                Sander RosselS Offline
                                Sander RosselS Offline
                                Sander Rossel
                                wrote on last edited by
                                #21

                                EA, it's in the game (provided you bought all DLCs)! :D

                                Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                                1 Reply Last reply
                                0
                                • Z ZurdoDev

                                  Sander Rossel wrote:

                                  If it's any less correct than "correct" it's not correct

                                  That is the most true statement I've ever read.

                                  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.

                                  S Offline
                                  S Offline
                                  Slacker007
                                  wrote on last edited by
                                  #22

                                  18 Reasons One is Executed for Witchcraft during the 'Burning Times'[^] :laugh: :laugh: Just realized you are a lefty. Keeping an eye on this one.

                                  Z 1 Reply Last reply
                                  0
                                  • Sander RosselS Sander Rossel

                                    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

                                    L Offline
                                    L Offline
                                    Lost User
                                    wrote on last edited by
                                    #23

                                    There is a thing called "Summenerhaltendes Runden" ;)

                                    It does not solve my Problem, but it answers my question

                                    Sander RosselS 1 Reply Last reply
                                    0
                                    • J Jacquers

                                      Search results I saw on a page recently: About 18 games found :laugh:

                                      K Offline
                                      K Offline
                                      kalberts
                                      wrote on last edited by
                                      #24

                                      Our local newspaper reported that "approximately five candidates" had failed this public exam. (The same local newspaper also once told about this guy who had one a huge prize in an English lottery: Until this, he had been selling fish and ships at a London street.)

                                      1 Reply Last reply
                                      0
                                      • S Slacker007

                                        18 Reasons One is Executed for Witchcraft during the 'Burning Times'[^] :laugh: :laugh: Just realized you are a lefty. Keeping an eye on this one.

                                        Z Offline
                                        Z Offline
                                        ZurdoDev
                                        wrote on last edited by
                                        #25

                                        Slacker007 wrote:

                                        Just realized you are a lefty. Keeping an eye on this one.

                                        Thanks. :laugh: :thumbsup:

                                        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.

                                        1 Reply Last reply
                                        0
                                        • Sander RosselS Sander Rossel

                                          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

                                          H Offline
                                          H Offline
                                          honey the codewitch
                                          wrote on last edited by
                                          #26

                                          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

                                          Sander RosselS 1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups