Skip to main content
N
nbitla1-Visitor
1-Visitor
September 11, 2014
Solved

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

  • September 11, 2014
  • 6 replies
  • 2183 views

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.

Best answer by Werner_E

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.

6 replies

R
RichardJ19-Tanzanite
19-Tanzanite
September 11, 2014

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.

    N
    nbitla1-VisitorAuthor
    1-Visitor
    September 11, 2014

    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.

    Werner_E
    Werner_E25-Diamond IAnswer
    25-Diamond I
    September 11, 2014

    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.

      Terms & ConditionsAccessibility statement