Visualize Calculations in Jama Connect Interchange™ Excel Functions for Troubleshooting ← recommended

Saby
Saby
  • Updated

Published Date: April 23, 2026
Validated: Yes
Audience: Jama Connect® Users
Products and Versions Covered: 

  • Jama Connect®
    • Cloud/CVC
    • Self-hosted
  • Jama Connect Interchange™ (JCI)
  • JCI Module: Excel Functions

Summary

Often, we want to see what's going on in the Excel spreadsheet we use for JCI calculations. Both to see how we progress with calculations, and also often for troubleshooting or improvement purposes.

Resolution

This resolution uses a technique to convert the calculation spreadsheet into an HTML-tagged text stream that can serve as input for a rich text field in Jama Connect for troubleshooting purposes.

In this example, we would like to inherit field values from a Hazard item to related Risk Evaluations.

 

However, we would also like to see which content has progressed in the Excel spreadsheet we put together for the Excel integration.

To visualize the spreadsheet content, we need a field to enter cell information.

In the Organization admin section, we can define a field:

 

That will be a rich text field in the field:

 

To populate the field above, we need to use HTML tags to format our output from the Excel file.

These HTML tags are the following:

  • Table definition (start)
    <table border="1" cellpadding="1" cellspacing="0" style="border-collapse:collapse; width:500px"><tbody>
     
  • Table definition (end)
    </tbody></table>
     
  • Table row (for 4 columns)
    <tr><td>column A</td><td>column B</td><td>column C</td><td>column D</td></tr>

Now, if we wish to populate the related Hazard ID, Name, Description, and Severity in our JCI Excel spreadsheet, we would do something similar (for up to 10 related Hazards):

This is where, in columns A, B, C, and D, JCI would populate the related hazard item fields based on our JCI XLS field mapping.

This spreadsheet can be extended to pre-format our calculation visualization field for the Risk Analysis item.

Please note that "Table start HTML" (B14), "Table end HTML" (B15), and "First table heading" (B17) are standard HTML tags for formatting purposes.

Cells in E1-E10 formats related items field are populated by JCI in columns A->D.

Cell E1="<tr><td>"&A1&"</td><td>"&B1&"</td><td>"&C1&"</td><td>"&D1&"</td></tr>"  means an HTML-tagged row compiled based on column contents in columns A- D.

 

Final HTML rendered content compiled in "OUTPUT" (B19).

Output includes "Table start HTML", "First table heading", all cells from E1-E10, and "Table end HTML", 
in equation:

B19=B14&B17&E1&E2&E3&E4&E5&E6&E7&E8&E9&E10&B15

This Output cell (B19) is to be mapped to the "JCI Excel - Calculation visualization" field in JCI.

 

The result is that we can actually see the relevant content of our JCI Excel file (!) in Jama Connect for improvement and troubleshooting.

 

Note, corresponding Excel file content:

 

Additional Resources (for all external articles)

Feedback:
We welcome your input! Please sign in to leave any comments, suggestions, or ideas for improvement below.

Related to

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.