I have a question on the engineering fee/cost for design of a residential post tensioned slab on ground. And, the question is, how much is a reasonable price? I am a transportation person and need to have someone to do the work for me. No experience and no time to do it myself.
I understand...
I have put together an EXCEL VBA macro that creates a small SAP2000 V17 model. When I save the model and attempt to run SAP I get an error that reads "ERROR DIVIDING LINE ELEMENTS", and the only way I can close SAP at this point is to "END TASK" through the task manager window. the file then...
In the output, where it gives “Total Girderline Reaction” on the pier or abutment, is the Distribution Factor already applied or should it be applied by the user????
The wording is confusing me where it says reaction is “per Lane”
when LLDF is applied the value should really be "Lanes per...
I'll appreciate any help to clarify how the pile PL/AE is incorporated into the top-down curve constructed from O-Cell data.
how do you choose "L" at various loadings? is it where the given load mobilizes along the shaft?
many thanks
I have an excel sheet that I use quite a lot. When I open it on my laptop all the Vertical page brakes are where I want them to be. the "Print Preview" displays all the colors and lines..etc.
However, when I open the very same file on my home desktop the page size is larger than the breakes and...
I am trying to translate a long hand matrix analysis for a small portal frame , 2 columns , one beam across, into an excel/VBA. how could I model/include compression only spring for one of the column bases. that is if there is an upward load the spring wont be effective.
I am working with a new computer with 2 monitors.
normally make use of the "ALT" key plus charcter codes to to superscribe the digit 2 to show a power of two, Alt+0178 will result in power of 2.
on this new machine this does not work, how can i change what the "ALT" keys do???
Many thanks
FM
I have to detail an opening in an existing tiltup (two story building).
As yet, the locations are not known but i think they will be about 10 feet wide.
I have thought of two senarios,
1-the opening falls within the width of the panel,
2- the opening falls at the joint between two adjacent...
How can I locate where the horizontal page break is using a VBA code.
In other word, I am trying to find where
ActiviSheet.HPageBreaks(2).Location is.
When you set up the page break the syntax is
ActiviSheet.HPageBreaks(2).Location = Range(Col, Row)
Col is always "A"
I want my macro to...
I just posted this question on the MS VB forum.
how could this be done through VBA in Excel? Or, can it be done?
"I am very new to VB and, am trying my hand at VB6.
I think!, I know how to creat a text file and have a string written to it.
What I am trying to do is have a column header, say...
I am very new to VB and, am trying my hand at VB6.
I think!, I know how to creat a text file and have a string written to it.
What I am trying to do is have a column header, say, starting at column 15 of the second line and have the header field limitted to 10 spaces. have another header at...
I have a worksheet with page break view. I want to be able to have a macro recognize the begining and end of each page and write info to the pages begining at the top of each page.
Can this be done? Thanks
Hello everyone,
How can i reference the last cell in a named range of cells?
I have a range, it is a part of one column, it is named say, "XYZ" I can get to the vaious cells by using
Range("XYZ").Cells(i)
how can I, Or, Can I, reference the last cell in the range right off the bat, somehow...
Hello everyone!
Assuming that we have mathematical expression with several parentheses, how can a macro be written to pick up the string and replace second level parentheses with square brakets and the higher levels with curly brackets.
I have exhausted what little programing knowledge I have...
I have asked this question before, and, the one or two responses given were general though much appreciated.
How can I protect the code in ONE single module from being accessed and viewed by the user in an EXCEL workbook and still have the VBA editor and other modules accessible.
Can a single...
I have asked this question before, and, the one or two responses given were general though much appreciated.
How can I protect the code in ONE single module from being accessed and viewed by the user in an EXCEL workbook and still have the VBA editor and other modules accessible.
Can a single...
I worked on a workbook with some number and cell formats then erased all that info. now my workbook has only about 2 8.5x11 sheets worth of info in it but the size of the file is on the order of 650kb. when I copy and paste the same info to a new file the size reduces considerablly down to about...
hi,
I am looking for help on 2 issues and will appreciate any input.
1--I have a macro which results in displaying a mathematical expression(string) in a cell using some of the string and text functions. How can Greek symbols such as PI or PHI be included within the module functions so they...
Hello everyone,
I am very new to Mathcad, I am curious to know if there is a way to display the actual values in the formulea (equations) rather than the variables to put it clearly if I define,
a=2
b=3
is it possible to have
2x3=6 rather than
a x b=6
I have looked in the menue options for...
