Overclockers Australia Forums

OCAU News - Wiki - QuickLinks - Pix - Sponsors  

Go Back   Overclockers Australia Forums > Software Topics > General Software

Notices

Reply
 
Thread Tools
Old 14th September 2017, 3:03 PM   #1
skymist Thread Starter
Member
 
Join Date: Mar 2002
Location: S.E Suburbs, Melbourne
Posts: 1,045
Default Simple Excel Formula?

Hi all,

I'm very much a newbie to Excel but I'm hoping someone can point me in the right direction as trying to make the process at work a bit more streamlined.

I'm wondering if there is a way I can create a formula in excel that I can input for example the below values

QTY 3 | Length: 2300mm | Width: 1150mm | Height: 2100 | Pcs Required: X

A Pc is 1000mmSQ so in this example I would need 3 (rounding up) for the length and 2 for the width - Height doesn't need to be factored in. So 5 pcs x QTY 3 = 15

Is it possible to add a greater/lesser than value to a cell so it will do it autmatically?

I've tried to make it at simple as possible.
skymist is offline   Reply With Quote
Old 14th September 2017, 3:16 PM   #2
Tinian
Member
 
Tinian's Avatar
 
Join Date: Jan 2009
Location: localhost
Posts: 11,992
Default

In excel you'd just use the roundup function to divide the length (2300) and width (1150) by the PC length (1000), sum them and then multiply by the quantity required.

e.g. =SUM(ROUNDUP(length/PC,0),ROUNDUP(width/PC,0))*qty
__________________
Never underestimate the difficulty of changing false beliefs by facts - Henry Rosovsky

Nail in my hand, from my creator
You gave me life, now show me how to live
.
Tinian is offline   Reply With Quote
Old 14th September 2017, 3:20 PM   #3
miicah
Member
 
Join Date: Jun 2010
Location: Brisbane, QLD
Posts: 4,376
Default

CEILING.MATH() is probably what you're looking for.

A1 contains 1000 (your size)
A3 is QTY, B2 Length, C3 Width
put this formula in E3 (to ignore D3 height)

=A3*(CEILING.MATH((B3/A1),1)+CEILING.MATH((C3/A1),1))
__________________
SFF Gaming>i5-4690|16GB Crucial DDR3|ASUS-H97I-PLUS mITX|EVGA GTX680|Crucial M550 M.2 256GB|Corsair RM450|Thermaltake Core V1|Edifier S550

CS:GO Videos | Motorcycle Videos
miicah is offline   Reply With Quote
Old 14th September 2017, 4:44 PM   #4
th3_hawk
Member
 
th3_hawk's Avatar
 
Join Date: Jun 2005
Location: [VIC] SE Suburbs
Posts: 1,487
Default

Am I reading this wrong or are your trying to work out the number of panels needed to cover some space?

If it's 3 length x 2 width that would make 6 panels?
__________________
"Victory goes to the player who makes the next-to-last mistake."

Got a VW? VWWatercooled
Currently for Sale: Roboking
th3_hawk is offline   Reply With Quote
Old 14th September 2017, 6:57 PM   #5
Bold Eagle
Member
 
Bold Eagle's Avatar
 
Join Date: Jun 2008
Location: Brisbane
Posts: 6,207
Default

Meaningful answers can and will be provided if you can meaningfully name your variables.

At the start of any formulas, programming, mathematics you need to clearly define your variables and constants and then you structure a formula (method) to capture/calculate that.

So be more specific in the naming of your variables so that everyone clearly understands what you are trying to achieve. Follow the KISS principle.

Pcs Required: (what is this, parts required, pieces required?!?) are you saying that a pc is a particle board (or type material) that is 1000mm x 1000mm (or 100cm x 100cm or 1M x 1M)
Length: (length of what?)
Width: ""
Height: "" - if height doesn't need to be factored in why is it even mentioned?
QTY 3: what is this

No offence but your variable naming is completely confusing (Pcs could be computers, QTY 3 could be 'quantity 3') if you can be very clear and concise about all of the variables then something very meaningful can be created.

Even if you just tell people exactly what you are trying to do then a meaningful formula can be created.

Try listing your variables in a simple list and then simply explain what they are before you start (you will find this makes everything else that follows a lot easier).
__________________
PC3: Cardboard Box, peanut dispenser, highly conc caffine intravenous drip, little monkey w "electro El Shocko rectal probe", 3DMarkVantage=276818768

Last edited by Bold Eagle; 14th September 2017 at 7:06 PM.
Bold Eagle is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +10. The time now is 8:00 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
OCAU is not responsible for the content of individual messages posted by others.
Other content copyright Overclockers Australia.
OCAU is hosted by Micron21!