Skip to main content
nbitla1-Visitor
1-Visitor
Sep 11, 2014 9:19 PM UTC
Solved

Not able to edit the final analysis results in already developed spreadsheet.

Hello, I have a spreadsheet which was developed by anohter firm and was made to use. I was able to make the dit to the spread shett the way i wanted it but when it came to the results at the end, I am not able to edit the already exisiting table (matrix) that is provided by the developer. Can someone please help me on how I can edit the "Analysis Results" on the last 2 page of the attached file. Thank you

-Nav

P.S: I am trying to edit/delete few sections in the "Analysis Criteria" in last 2 pages.

Werner_E
Werner_EAnswer
25-Diamond I
Sep 11, 2014 11:19 PM UTC

Can you please advice me on how I can edit the the variables R1 and R2?

There is a hidden but fortunately not password protected area right above "Analysis Results" where the text is defined and calculations are done.

I made is visible in the attached sheet. Double click the yellow bar and enjoy.

View in thread

6 replies

RichardJ19-Tanzanite
19-Tanzanite
Sep 11, 2014 9:43 PM UTC

If you grab the table and move it to the right you will see that it is an evaluation, and the variable and evaluation operator were hidden under a blank region. So you can't edit them. You need to edit the statements that are used to create the variables R1 and R2.

Translate
    nbitla1-VisitorAuthor
    1-Visitor
    Sep 11, 2014 10:06 PM UTC

    Hey Richard, thank you. I have seen that R1 and R2 are hidden under a blank region. If I type "R1 = "on the right it gives me the matrix. Giving me the number of rows and columns and I cannot do anything further thne that I wanted to delete few statements and do few edits.

    I want to edit the variables R1 and R2. Like I want to delete the whole " Section A1-A1: Compressive Stess Left Edge" and all the corresponding information of it.

    And I wanted to edit " Section A2- A2 : Maximum Average Shear Stress" to " Section A2- A2: Uniform Average Shear Stress". And things like that.

    Can you please advice me on how I can edit the the variables R1 and R2?

    Thank you.

    Translate
    Werner_E
    Werner_E25-Diamond IAnswer
    25-Diamond I
    Sep 11, 2014 11:19 PM UTC

    Can you please advice me on how I can edit the the variables R1 and R2?

    There is a hidden but fortunately not password protected area right above "Analysis Results" where the text is defined and calculations are done.

    I made is visible in the attached sheet. Double click the yellow bar and enjoy.

    Translate
      Terms & ConditionsAccessibility statement