{"id":68194,"date":"2023-05-11T03:00:02","date_gmt":"2023-05-11T10:00:02","guid":{"rendered":"https:\/\/www.jamasoftware.com\/?p=68194"},"modified":"2025-04-18T14:01:58","modified_gmt":"2025-04-18T21:01:58","slug":"how-to-integrate-jama-connect-with-microsoft-excel-using-the-jama-connect-interchange-jci-excel-functions-module","status":"publish","type":"post","link":"https:\/\/www.jamasoftware.com\/legacy\/blog\/how-to-integrate-jama-connect-with-microsoft-excel-using-the-jama-connect-interchange-jci-excel-functions-module\/","title":{"rendered":"How to Integrate Jama Connect\u00ae with Microsoft Excel Using the Jama Connect Interchange\u2122 (JCI)-Excel Functions Module"},"content":{"rendered":"

\"Jama<\/p>\n

\n

How to Integrate Jama Connect\u00ae<\/sup> with Microsoft Excel Using the Jama Connect Interchange\u2122 (JCI)-Excel Functions Module<\/h2>\n

Everyday, the world\u2019s most innovative companies use Jama Connect\u00ae<\/sup> to build life-changing products, software, and services. Jama Connect includes powerful requirements traceability, risk management, and test management capabilities to help our customers get their products to market faster.<\/p>\n

Jama Connect also includes numerous configuration settings \u2014 which our customers use to adapt the tool to their organization\u2019s engineering practices and achieve compliance to industry-specific standards and regulations.<\/p>\n

On top of this wide range of options, though, many of our users still require an additional level of customization to really make Jama Connect their own \u2013 this just usually requires an adjustment to the workflow logic here, or an additional calculation there.<\/p>\n

Other requirements management tools achieve this extra level of configuration using JavaScript extensions or complex propriety scripting languages that can take literally years to master (with the frustrations taking years off your life in the process!)<\/p>\n

Jama Software\u00ae<\/sup> has solved this same problem using the much more accessible, universal language of Microsoft\u00ae<\/sup> Excel formulas. Our powerful Excel Functions add-on module can be purchased with our integration platform, Jama Connect Interchange\u2122 (JCI)<\/u><\/a>.<\/strong><\/p>\n

\n

RELATED DEMO: <\/strong>Jama Connect\u00ae<\/sup> Features in Five: Jama Connect Interchange\u2122<\/a><\/span><\/span><\/h4>\n
\n

How does the JCI-Excel Functions module work?<\/h3>\n

Imagine your average Excel workbook, where formulas are applied to certain cells to perform calculations or logically transform data. Now, imagine if you could apply those same formulas directly to fields in Jama Connect. Pretty powerful, right?<\/p>\n

You can think of the JCI-Excel Functions as a calculator that runs in the background while you work in Jama Connect. As you enter fields in Jama Connect, field values are automatically sent to an Excel template where formulas are set up. Formulas are run instantly, and the resulting values are sent back to Jama Connect. Your Jama Connect users don\u2019t ever need to open an Excel workbook or even have a license to Excel to benefit from this automation.<\/p>\n

Sample JCI-Excel Functions workstreams<\/h3>\n

Last month we shared our most popular workstreams<\/a> for streamlined software development using Jama Connect and Jira.<\/p>\n

In today\u2019s blog, I\u2019d like to do the same for JCI-Excel Functions. As the Product Manager for JCI, I\u2019ve heard from numerous customers who have used this module to achieve time-saving workflow automation, streamline manual data entry, and automate complex calculations.<\/p>\n

Keep in mind that this is not an exhaustive list! If your team has another workstream they\u2019re loving, I\u2019d encourage you to post about it in the JCI Sub-Community<\/a> for others to see.<\/p>\n

\n

RELATED: <\/strong>How to Use Requirements Management as an Anchor to Establish Live Traceability in Systems Engineering<\/a><\/span><\/span><\/h4>\n
\n

Example #1 \u2013 Complex Calculations (Defect Prioritization Scenario)<\/h3>\n

Many projects incorporate complex and proprietary formulas or calculations that take years for a company to perfect. Rather than perform these calculations offline and input the results in Jama Connect manually, you can use JCI to map Jama Connect fields directly to an Excel workbook and watch the same calculations run automatically.<\/p>\n

In this simple risk calculation, a Defect\u2019s overall Risk Priority Number (RPN) is calculated using the following formula:
\nRPN = (A+B)*(C+D+E)<\/strong>, where each variable is taken from a field in the item.<\/p>\n

With JCI, fields A through E are mapped to the Excel template, where the formula is run. The resulting RPN is then automatically populated in the Calculated RPN field.<\/p>\n

\"\"<\/p>\n

Example #2 \u2013 Field Inheritance Across Items (Library Scenario)<\/h3>\n

This flexible workstream allows you to share fields or values across related items. For example, you could maintain a standard or approved \u201clibrary\u201d of items in one part of the system, and automatically populate values from that library to other items as needed.<\/p>\n

With this workstream, users no longer need to copy values across items manually. Instead, values flow automatically, and any time a field in the \u201csource\u201d item is updated, the \u201ctarget\u201d items automatically receive the update as well.<\/p>\n

In this risk analysis example, values from a standard library of hazards and harms are automatically populated to an individual risk analysis item.<\/p>\n

\"\"<\/p>\n

Example #3 \u2013 Logical Transformations (Software Development Scenario)<\/h3>\n

Use this example to update fields automatically when certain conditions are met. In the following software development scenario, we\u2019ve set up a rule stating that when all downstream user stories have a status of Development Done, the upstream software requirement in Jama Connect should also be marked as Done. This workstream simplifies life for the product manager by allowing them to see at a glance when a feature is complete.<\/p>\n

\"\"<\/p>\n

Conclusion<\/h6>\n

Jama Connect Interchange is an integration platform that seamlessly connects Jama Connect with other best-of-breed tools, like Microsoft Excel, and Atlassian Jira.<\/p>\n

JCI is built, supported, and continuously enhanced by dedicated teams at Jama Software. This means that JCI is deeply integrated with Jama Connect configurations and workflows, providing you with a smart and seamless sync.<\/p>\n

JCI supports both cloud-based and self-hosted instances of Jama Connect. If you\u2019d like to learn more about Jama Connect in general or start a free trial of our #1-rated requirements management platform, please click here<\/a>. If you\u2019re already a Jama Connect customer and would like to find out whether JCI would be a good fit for your organization, please contact your Customer Success Manager.<\/p>\n

\n

FREE DEMO: <\/strong>Click Here to Request a Demo of Jama Connect Interchange\u2122<\/a><\/span><\/span><\/h4>\n
\n

<\/p>\n

<\/div>\n