Microsoft Office Forums Doing simple maths between boxes
 Register FAQ Search Today's Posts Mark Forums Read

#1
09-30-2020, 12:40 AM
 JOC Windows 8 Office 2010 Novice Join Date: Sep 2020 Posts: 1
Doing simple maths between boxes

I am coming to Visio from a standing start, but am very familiar with other MS Office tools and quite happy in Excel and Access. I don't have VBA skills though.

I am trying to build a flow chart that will do some simple calculations. I can fathom how to build the 'picture' of the chart, and can see where I can add data to the boxes and have worked out how to add a new data field and type, but could do with a shunt in the right direction as to how to add in simple mathematical links between the boxes - even a link to an online 'how to' would be useful,. I have searched and searched the net and cannot find the seemingly simple thing I'm after.

I am setting up a fairly complex flow diagram to how how various contributing operations link together into a final whole operation. I want to track data relating to each operation, for example kW of electricity. So for the office operation, I might have 4 boxes linked to/feeding the 'Office' box, say: computers, light bulb 1, light bulb 2 and air conditioning. I've made a field to hold a value for the kW of electricity in each box.

Where and how (syntax would be great) can I implement a calculation that will show total electricity consumed by the office, i.e. the sum of computers, light bulb 1, light bulb 2 and air conditioning. I assumed I could put the calculation into the office kW field, i.e. the equivalent of Office kW=(computers;kW)+(light bulb 1;kW)+(light bulb 2;kW)+(air conditioning;kW), however it doesn't seem that simple.

My aim is to produce a finished flow diagram that perhaps tracks several values, maybe water consumption, electricity use, waste generation and then be able to see how varying values in one area changes the values in another.

The complexity of Visio seems to provide the possibility of doing this, but I need this confirmed and could do with some brief instructions (or where to find them) to get started (I'm a quick study and a shove in the right direction would be great). To begin with the basic maths would be useful, I can revisit niceties like changing the colour of the boxes with the values later.

If Visio isn't the tool to do this that would also be useful to know and I'll run it up in Excel, but I can't believe that Visio wasn't built for this.

Many thanks
#2
09-30-2020, 06:17 PM
 Guessed Windows 10 Office 2016 Expert Join Date: Mar 2010 Location: Canberra/Melbourne Australia Posts: 1,982

Visio is built for tasks like this but it takes a lot of setting up to make sure all the elements on the page (shapes) contain the same fields that you want to track.

Visio comes in different flavours. The more expensive Visio Professional allows you to link shapes to an embedded database (essentially a spreadsheet) which records all the values in all the fields. If you have Visio Standard, you might need to make more use of macros to compile the data.

What version of Visio do you have? If you start by supplying a sample visio file with some shapes, I can have a look and make suggestions on where you should start.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post macropod Word 0 04-08-2018 04:58 PM 1Kurgan1 Word 2 10-31-2016 01:20 AM olson109 Word 5 03-12-2014 01:02 AM fcsungard Word 5 06-01-2012 01:16 AM PCC Word 1 05-16-2009 05:22 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:54 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top