Question about Computers & Internet

1 Answer

Want to write a code in VBA for a Chart prepared in Excel

I have prepared a calculation chart in excel which calculates the steel in kgs required for the given pile.Since there are 6 different types piles with different steel requirement,i used if conditions to solve them in excel.But it is not sufficient,as I cannot write them in summary sheet.Now I calculate the steel in one sheet and then link in the summary,which consumes time,labor and is also error prone...Can you guys help me...I know I 'm being too optimistic on that score...

Posted by on

  • Rabins Sharma
    Rabins Sharma May 11, 2010

    Please mention all required details.

×

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 183 Answers

Dear Customer,

you have not define your all details,

Plz give all details than & only than some can help you ,

so,Please mention all required details

THNX

Posted on May 17, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

In my random sample I found 15 worms and 6 lady bugs in my pile of dirt.in my backyard I have a total of 1,200 worms.what do I know about the sample?What do I know about the population?how many total...


Oh geeze,, you have 480 ladybugs in all?!!!
That makes a total combined population of 1,680 critters!
And why did you only take a 1.25% sample?!!

But maybe ladybugs like living in dirt piles better than other backyard areas, so you might not have that many! ;)

Nov 07, 2014 | Office Equipment & Supplies

3 Answers

223 bullet drop chart


The best way to generate that chart is by shooting over a chrono and inputting the data into an external ballistics calculator, such as this one by Hornady:

Ballistics Calculator


It takes some work to gather the data, but it's much more accurate than any generic chart can be. I've used cards generated by a couple of different online calculators and have gotten better than acceptable results out of them with both my match barrelled 5.56 AR carbine and 7.61x51 Savage 10FCP. Good enough to ring 6" steels at 300 yards and 500 yards, respectively.

There are many other web-based calculators that can do the job, just search for "external ballistics calculator" for more.

May 26, 2014 | Optics

1 Answer

Calculate cc to horsepower


cc is a measure of volume, hp is a measure of power. There is no direct conversion between them.

A 453cc motorcycle engine will put out more power than a 453cc pile of bricks. A 453cc steam engine will put out a different amount of power.

May 22, 2014 | Office Equipment & Supplies

1 Answer

Calculate horsepower to cc


There is no direct conversion. cc is a measure of volume while horsepower is a measure of power. A 420cc engine may have enough power to drive a car down a freeway, but a 420cc pile of bricks won't.

Mar 04, 2014 | Office Equipment & Supplies

2 Answers

Yards in a pile of gravel


There are 27 cubic feet in one yard. IF your estimate of pile size is correct, you have 720 cubic feet witch is 26 yards.

Jul 21, 2013 | Fish

1 Answer

How to calculate yards in a pile of gravel


A yard of material is 3x3x3 so that is 27 cubic feet. you have a pile that is 4x15x12 and that is 720 cubic feet. So divide 720 by 27 and you get 26.66 yards

Jul 21, 2013 | Fish

1 Answer

My ti-84 calculator wont react to anything and it says garbage collecting. i think the bar on the side should move and its not moving and its been like this for several weeks. i did download a whole pile...


I remember this happening once to my TI-83. I know it's a different calculator. But it happened frequently. Without completely reconfiguring the calculator, you can remove the batteries whenever you see the message and when you start it up again, it should be okay. It may continue to display this message once in a while. I used to just remove the batteries. I don't know if it will work on your TI-84 the way it worked on my TI-83, but I hope this helped!
Please rate my solution!
- Frankie

May 05, 2011 | Texas Instruments TI-84 Plus Calculator

1 Answer

If 1cm cubes are stacked on a base which is 1cm wide and 2 1/2 cm deep how high will the pile be


Without knowing how many cubes we can't tell how high the pile will be. We do know that two 1cm cubes can fit on the base, however, two 1cm cubes can be placed on the cubes that are on the base and the tower of cubes can be stacked to an indeterminable height.

Mar 23, 2011 | Office Equipment & Supplies

1 Answer

1. calculation for excel spreadsheet macro for calculating the a right angle triangles hypotinuse and opposite side, angle given


Hello this is Baris,
First off all when you say hypotinuse I think it is a 90 Degree triangle. Total of the angles off a triangle is 180 degree. So it is a simple algebra question.

Hypotinuse is 90
Right angle is R
Left angle is L
Total is 180

Equation is 90+ R +L = 180

We are looking for R, so lets arrange our equation.

R= 180 - 90 - L
R= 90 - L

This is our formula for excel

Lets put it in the excel
Type in A1 "hypotinuse "
Type in A2 "Left Angle"
Type in A3 "Right Angle"

Type in B1 90
Type in B2 "whatever the value given for the left angle"
Type in B3 =90-B2

As soon as you change the value in the cell B2, B3 will change by itself. Hope this helps :)


Sep 27, 2009 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

130 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...