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

    • You raise a good point here regarding heat/climate. The recent dry spell has caused the ground to dry up and move. Just as this movement causes cracks in the walls of people’s homes, it also causes water pipes underground to fracture, hence the recent uptick in reported leaks and the heightened workload for TW
    • It  might have been a stop on a car i think as there was a car with blue police tape on it and smashed windows on drivers side a few doors from my house but I didn't see or hear anything 
    • Silver ring with blue stone found in Dulwich Park today. Please contact me at 07438359765 
    • Does it deal at all with the question of the anticipated per capita future costs of necessary repairs to or upgrading of the ?still largely old underground piping across their area, and how that compares with future risks existing in other areas?  I wonder too whether the latest apparent concentrated spate of leaks is attributable at all to the heat. TW say that they have not made any dividend payments to external shareholders (among them a Candian teachers pension fund) since 2017.    There have been like payments, though, to their holding companies (?Kemble, and Thames ?something), reportedly I think to service debts to them. Thames Water annual company reports are available online.  Ofwat have also published about leakage.
Home
Events
Sign In

Sign In



Or sign in with one of these services

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