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

    • Per Cllr McAsh, as quoted above: “We are currently updating our Enforcement Policy and changes will allow for the issuing of civil penalties ranging from £175 to £300 for visible smoke emissions, replacing the previous reliance on criminal prosecution. " Is anyone au fait with the Clean Air Act 1993, and  particularly with the state of 'Smoke Control' law and practice generally?  I've just been looking  through some of it for the first time and, afaics, the civil penalties mentioned  were introduced into the Clean Air Act, at Schedule 1A, in May 2022.  So it seems that, in this particular,  it's a matter of the enforcement policy trailing well behind the legislation.  I'm not criticising that at all, but am curious.  
    • Here's the part of march46's linked-to Southwark News article pertaining to Southwark Council. "Southwark Council were also contacted for a response. "Councillor James McAsh, Cabinet Member for Clean Air, Streets & Waste said: “One of Southwark’s key priorities is to create a healthy environment for our residents. “To achieve this we closely monitor legislation and measures that influence air pollution – our entire borough apart from inland waterways is designated as a Smoke Control Area, and we also offer substantial provision for electric vehicles to promote alternative fuel travel options and our Streets for People strategy. “We as a council support the work of Mums for Lungs and recognise the health and environmental impacts of domestic solid fuel burning, particularly from wood-burning appliances. “We are currently updating our Enforcement Policy and changes will allow for the issuing of civil penalties ranging from £175 to £300 for visible smoke emissions, replacing the previous reliance on criminal prosecution.  “This work is being undertaken in collaboration with other London boroughs as part of the pan-London Wood Burning Project, which aims to harmonise enforcement approaches and share best practice across the capital.” ETA: And here's a post I made a few years ago, with tangential relevance.  https://www.eastdulwichforum.co.uk/topic/278140-early-morning-drone-flying/?do=findComment&comment=1493274  
    • The solicitor is also the Executor. Big mistake, but my Aunt was very old, and this was the Covid years and shortly after so impossible to intervene and get a couple of close relatives to do this.  She had no children so this is the nephews and nieces. He is a single practitioner, and most at his age would have long since retired - there is a question over his competence Two letters have already gone essentially complaining - batted off and 'amusingly' one put the blame on us. There are five on our side, all speaking to each other, and ideally would work as a single point of contact.  But he has said that this is not allowed - we've all given approval to act on each others behalf. There are five on her late husband's side, who have not engaged with us despite the suggestion to work as a team, There is one other, who get's the lion's share, the typicical 'friend', but we are long since challenging the will. I would like to put another complaint together that he has not used modern collective communication (I expect that he is incapable) which had seriously delayed the execution of the will.   I know many in their 80s very adept with smart phones so that is not an ageist comment. The house has deteriorated very badly, with cold, damp and a serious leak.  PM me if you want to see the dreadful condition that it is now in. I would also question why if the five of us are happy to work together why all of us need to confirm in writing.             The house was lived in until Feb 23, and has been allowed to get like this.
    • Isn’t a five yearly electricity safety certificate one of the things the landlord must give for a legal tenancy?
Home
Events
Sign In

Sign In



Or sign in with one of these services

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