Jump to content

Recommended Posts

Wonder if anyone can tell me if there is a way of doing this? I have a series of values (which could be either negative or positive) that will add up to Zero. However I don?t know which are positive or which are negative.


Is there a way of calculating how these numbers being one way or the other will add up to Zero and if there is more than one way of doing it?


I?m being lazy here as I should be able to deduce which is a negative or a positive and am just looking for a quicker option.

Link to comment
https://www.eastdulwichforum.co.uk/topic/83508-excel-query/
Share on other sites

ed_pete: (2 x (2^(n-1)) a.k.a 2^n, and not sure where - 2 comes from, are you maybe forgetting all/no - or all/no +?


With no further restrictions, reckon Jeremy's right.


There are some vaguely similar counting/summing problems which you can do in order of n steps, but these tend to have a kind of "ordering" implicit in them, such as finding the point in a set which gives two parts, the sums of each respective part giving minimal absolute difference.

Link to comment
https://www.eastdulwichforum.co.uk/topic/83508-excel-query/#findComment-927552
Share on other sites

Jeremy Wrote:

-------------------------------------------------------

> Are you talking about methodically assigning

> +ve/-ve signs to each number until you reach a

> solution?

>

> Easy to code in VBA.. but if your data set is

> large, you might find it surpisingly slow to

> compute.


We're talking about less than 40 values which already have a plus or minus assigned to them as a result of a reconciliation. However these add up to over ?4,000 in value. By a process of deduction, a plus or a minus can be reversed depending of the reason it is what it is in the first place. With the correct alterations the sum of the numbers will be zero.


May be easy to code in VBA if you know how.

Link to comment
https://www.eastdulwichforum.co.uk/topic/83508-excel-query/#findComment-927556
Share on other sites

Jeremy Wrote:

-------------------------------------------------------

> You can do it using Excel "Solver"

>

> Example here - very similar to what you need to

> do

> http://www.k2e.com/tech-update/tips/147-using-exce

> l-to-identify-entries-that-add-to-a-specific-value


Thanks Jeremy. Will try that after eating my rice cakes with peanut butter and banana.

Link to comment
https://www.eastdulwichforum.co.uk/topic/83508-excel-query/#findComment-927578
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Latest Discussions

    • Did you see my post above where iD suggested to someone else with your problems that it could be a sim or device issue? Why are you so sure it isn't your phone that has developed a fault? Phones can and do go wrong (reinstalling the app would not help if your phone itself is faulty). To test this out:  Have you tried your SIM card in somebody else's phone? If they don't have connection problems, then the fault is with your phone (though see below - your SIM card could be faulty, in which case this test wouldn't work). Have you tried somebody else's SIM card in your phone? If you still have the same connection problems, then the fault is with your phone. Both of those tests would tell you if the problem was with your phone rather than the network. Only if  the connection problems continued would the problem probably be with the iD network. Have you asked for another SIM card to try out (with the same phone number, obviously!) in case your SIM card has become faulty? Have you tried their live chat (link above) which they say can help with further troubleshooting? These things would be quite quick and easy to do, and could save you a lot of time and inconvenience changing providers!
    • In my case, internet doesn’t work even in London, incoming cals disconnect b4 u can even pick up calls!  Reinstalled ap & now even worse! Can however, access where I am regarding billing etc. Been with them 4 for years - been bad for over a year.. blamed my phone etc- lucky for me, can just change & leave, hopefully without any delay as only SIM pay as you go… Must be just unlucky….. would not recommend them now to anyone - if all else fails will just very very reluctantly ho to one of the big 4 & take a contract, which seems to have to be 4 two years or just might decide to not have a phone at all..            
    • Yes, my brother lived in that area and had to change to something other than Vodafone. He didn't just have a "weak" signal. He had no signal at all.
    • Apparently it is a very old and ill cat and about to be "euthanised"  - euphemism. My understanding is that it wasn't actually lost, just wandering around near its home as cats do, but people thought it was lost  because the poor thing looked so terrible. The owner was tracked down, but only after loads of posts from people trying to catch it and take it to various places for stray cats. I got my information from the "other" East Dulwich Forum, but I've got no reason to believe it isn't true. Irrelevant, but my partner and I once took a very thin and ill looking cat to Celia Hammond because it kept coming into my house for weeks and looked terrible,  and we (wrongly) assumed it had no home. That cat also turned out to have an owner. And yes it was ill, but being treated by a vet. It's lovely that people care about animals, but it's very easy to make mistakes like this. Having said which, many years ago when our  cat died, a couple of days later another cat started sitting  on our  doormat every day (three floors up in a Scottish tenement) and refused to leave, so eventually we took him in ...... 
Home
Events
Sign In

Sign In



Or sign in with one of these services

Search
×
    Search In
×
×
  • Create New...