CALCULATION OF PLANE TRUSSES.zip
(4/9)
Description
CALCULATE OF PLANE TRUSSES
INSTRUCTIONS OF USE
THE BOOK THIS MADE UP OF 13 LEAVES:
SayFa1: LEAF TO INTRODUCE DATA AND TO SHOW THE RESULTS
SayFa2: LEAF TO STORE THE STIFFNESS MATRIX
SayFa3: LEAF TO SHOW THE RESULTS OF THE DIMENSIONAMIENT
Hoja1: CHART OF YOU PROFILE L
Hoja2: CHART OF ROUND PIPES
Hoja3: CHART OF PIPES STRUCTURAL SQUARES
Hoja4: CHART OF RECTANGULAR STRUCTURAL PIPES
Hoja5: CHART OF YOU PROFILE C
Hoja6: CHART OF YOU PROFILE DC
Hoja7: CHART OF YOU PROFILE IC
Hoja8: CHART OF COEFFICIENTS OF I BULGE
Hoja9: CHART OF PROFILES OR
Hoja10: GRAPH OF THE STRUCTURE
SAYFA1 IS THE INITIAL LEAF OF THE WORK. LATER ON, TO THE DIMENSIONAR THE STRUCTURE, THE CURSOR WAS POSITIONED IN SAYFA3
SayFa3: IT IS THE LEAF WHERE THE CURSOR IS POSITIONED THE DIMENSIONAR THE BARS OF THE STRUCTURE
GRAPH (HOJA10) IT IS THE LEAF TO WHICH WE HAVE TO GO LATER ON IF WE WANT GRAFICAR THE STRUCTURE
SayFa2: IT IS THE LEAF WHERE IT CAN CONSULT HIMSELF THE STIFFNESS MATRIX (OR TO PRINT IT IF WE WANT TO INCLUDE IT IN THE DOCUMENTATION OF THE PROJECT)
Leaves 1 at 9: BASES OF DATA WITH THE CHARACTERISTICS OF THE PROFILES TO USE IN THE I CALCULATE (THEY CAN BE CHANGED TO ADAPT IT TO THE PROFILES IN USE IN EACH COUNTRY)
(A) TO BEGIN WITH THE FIRST LEAF (SAYFA1)
IT SUITS TO PLACE A NAME TO THE STRUCTURE, BECAUSE THIS HE/SHE WILL APPEAR THEN IN ALL THE LEAVES OF PRESENTATION OF THE PROJECT AND IN THE FILE DXF (IF WE NEED TO CREATE IT)
- 1 - BUTTON KNOTS AND BARS"
BUTTON TO BEGIN
When PRESSING IT, THE LEGENDS APPEAR IN THE CORRESPONDING STALLS: I number of knots AND I number therefore of bars, they will BE THE FIRST DATA THAT I will ENTER
IF THE STRUCTURE IS ISOSTÁTICA IT WILL BE: sweep = (2xnudos)-3
HE/SHE CAN HAVE SUPPORTS OR BARS SUPERABUNDANTES IN CASE OF BEING HIPERESTATICA
It can ALSO BE A MECHANISM (you sweep <(2xnudos)-3) THAT WORKS LIKE STRUCTURE ISOSTATICA IF he/she HAS BONDS SUPERABUNDANTES
ONCE WELL-KNOWN THE NUMBER OF KNOTS AND BARS PULSE THE SECOND BUTTON, WITH WHICH I ENTER TO THE FOLLOWING PART OF THE CALCULATIONS
- 2 - COORDINATED BUTTON OF KNOTS, BONDS, CONNECTIONS, ETC."
BUTTON TO INTRODUCE THE DATA OF THE STRUCTURE
IN THIS SUBROUTINE I WILL HAVE TO INTRODUCE THE FOLLOWING DATA BY HAND TO IDENTIFY THE STRUCTURE:
1)COORDENADAS X and AND OF EACH KNOT (Columns 2 and 3)
2)LAS RESTRICTIONS OF BOND OR CONDITIONS OF it EMBROIDERS (Columns 4 and 5) PUTTING A 1 (ONE) IN EACH RESTRICTION
3)FUERZAS Fx and EXTERNAL Fy OF EACH KNOT (Columns 6 and 7)
4)CONNECTIVITY (IN WHAT KNOT it BEGINS AND IN THAT KNOT FINISHES EACH BAR) (Columns 10 and 11)
- THE VALUES OF AREA AND I MODULATE DE YOUNG THAT CHARACTERIZE TO EACH BAR (Columns 12 and 13)
- 3 - BUTTON CALCULATES STRUCTURE"
BUTTON TO INTRODUCE THE DATA OF THE STRUCTURE
HERE IT IS MADE THE I CALCULATE OF THE STRUCTURE. AMONG THE COLUMNS 20 AND 28 DE SAYFA1 ALL THE RELATIVE DATA ARE PLACED TO EACH BAR AND KNOT: LONGITUDE, INTERNAL EFFORTS, TYPE OF EFFORTS (TRACTION OR COMPRESSION) AND DISPLACEMENTS OF KNOTS
- 4 - BUTTON " DIMENSIONAMIENTO "
BUTTON FOR DIMENSIONAR THE BARS OF THE STRUCTURE
THIS BUTTON TAKES US TO SEVERAL OPTIONS:
4-1 DIMENSIONAR THE STRUCTURE WITH PROFILES L OF SAME WINGS
4-2 DIMENSIONAR THE STRUCTURE WITH STRUCTURAL PIPES
IN THIS CASE WE MEET WITH THREE POSSIBILITIES:
4-2-1 DIMENSIONAMIENTO WITH ROUND PIPE
4-2-2 DIMENSIONAMIENTO WITH SQUARE PIPE
4-2-3 DIMENSIONAMIENTO WITH RECTANGULAR PIPE
4-3 DIMENSIONAR THE STRUCTURE WITH PROFILES C
IN THIS CASE WE ALSO HAVE THREE POSSIBILITIES:
4-3-1 DIMENSIONAMIENTO WITH PROFILE SIMPLE C
4-3-2 DIMENSIONAMIENTO WITH PROFILE C BENDS WITH FACED SOULS
4-3-3 DIMENSIONAMIENTO WITH PROFILE C BENDS WITH UNITED SOULS
4-4 DIMENSIONAR THE STRUCTURE WITH PROFILES OR
(B) TO RETURN TO THE FIRST LEAF GRAPH
THERE WE WILL FIND TWO BELLBOYS:
- 1 - BUTTON " GRAFICAR "
HE/SHE DRAWS IN THAT SAME LEAF A GRAPH OF THE STRUCTURE THAT ALLOWS TO SUPPLEMENT THE DOCUMENTATION OF THE I CALCULATE
- 2 - BUTTON TO CREATE DXF"
BELIEVE A FILE DXF IN THE ROOT OF THEIR DISK C THAT ALLOWS TO MAKE A GRAPHIC PRESENTATION OF MORE PRECISION USING THE ENVIRONMENT CADCalculation Reference
Matrix structures
Calculation Preview
(4/9)
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Your spreadsheet looks very good by the way.
I send a small correction that I made to the book excel
In the graphics routine it made the error of confusing a fixed support with one motive unless had non null forces in the sense x as y. Changing the variable to evaluate solved the problem.
I WOULD LIKE THAT SOMEBODY CONTRIBUTES SOME IDEAS TO HELP IMPROVE THESE CODES.
I HAVE BEEN WORKING IN IT AND ALSO IN THE INTRODUCTION OF DATA OF KNOTS AND BARS BY MEANS OF USERFORMS AND IN IMPROVING THE ONE CENTERED OF THE DRAWINGS IN THE FILES DXF
I ADD SEVERAL CASES THAT HAS NOT BEEN POSSIBLE TO SOLVE WITH THE LEAF OF I CALCULATE PREVIOUS AND SOME NEW EXAMPLES, AMONG WHICH THERE IS A CURIOUS CASE: THE BRIDGE HELL DE PENNSYLVANIA
NOBODY SEEKS TO CALCULATE A STRUCTURE OF THIS SPAN WITH SO MUCH SIMPLIFICATION, IT IS ALONE AN ACADEMIC EXAMPLE THAT SHOWS THE EASY THING THAT IT IS THE USE OF THIS TOOL: THEN OF INTRODUCING THE ALONE DATA WE HAVE TO PRESS SOME BELLBOYS AND TO WAIT SOME SECONDS
I SUPPOSE THAT HE/SHE WILL HAVE TO REPLACE THEM IN THEIR IT PAGINATES. I APOLOGIZE HIM A THOUSAND FOR THE NUISANCES, ALTHOUGH I BELIEVE THAT IT HAD ALREADY CLARIFIED HIM THAT IT SENT THE CODES MACRO DESPROTEGIDOS BECAUSE THEY WERE SUBJECT TO MODIFICATIONS
I WOULD LIKE THAT SOMEBODY CONTRIBUTION SOME IDEAS TO IMPROVE THESE CODES