# Recommended videos > **Source**: [Coherent](https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ) ## Browse Collection 1. [What is Coherent Spark?](https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/H5WYl7ZaNvgXCTrR0PTkJg.md) (Video) 2. [Crafting front end using Coherent Validation API](https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/1DMjKEJmLUV6qPqTdFKIsQ.md) (Video) 3. [Traffic Director: Rating and Rules](https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/I0g3sx3MrYnr3VdJIpQ2XA.md) (Video) 4. [Employee Benefits - Spark Shell ](https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw.md) (Video) 5. [Tech 205: Integrating with LLM](https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/FeEnXeDvUcHvqoXP5ITiCQ.md) (Video) 6. [Batch API using Python SDK (Clone)](https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/8AYIt0ikqUJ4dhFayUnlfg.md) (Video) --- # VIDEO: Employee Benefits - Spark Shell ## METADATA - id: wwkXuHO5AjyjQ9fTIawTyw - type: video - source: Coherent - content_url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw - collection_url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ ## TRANSCRIPT - time: 00:00 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=0 text: Hello, this is Ron from Coherent, and what I'm going to walk through today is how we can utilize Spark Shell to share Excel raters, or really any Excel file that requires collaboration internally through an organization, and still maintain control of the individual IP that makes this rater or this model so impactful to your organization. - time: 00:28 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=28 text: And we utilize our tool Spark Shell to do this. - time: 00:33 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=33 text: So just to start off with this, you'll see that I have up on my screen a Group Health Rater. - time: 00:39 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=39 text: It gives us the ability to quote a number of group health plans. - time: 00:43 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=43 text: And what we typically hear from peers in this space is that collaboration is often difficult. - time: 00:49 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=49 text: We're sending multiple Excel files out. - time: 00:52 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=52 text: When we make updates, we send those next ones out, and often clients tell us that there's no way to ensure that they're always using the latest and greatest version, and ultimately somebody has to reconcile this. - time: 01:05 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=65 text: Well, with Coherent Spark, we can very quickly spin up the ability to bring not only control into the space, but also make updates incredibly simple. - time: 01:17 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=77 text: So on the right side of my screen here, you're going to see the Coherent Assistant. - time: 01:21 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=81 text: So I can utilize the Coherent Assistant to create this shell or think of this shell as essentially a user interface, but it's much more than that. - time: 01:31 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=91 text: It's also an entire set of control tools that's going to put in things like traceability, be able to actually account for every single scenario that's evaluated through this process. - time: 01:46 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=106 text: So without further ado, I'm going to walk you through a couple of high-level steps here. - time: 01:51 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=111 text: Of course, we already know, how do we get started in Spark or Shell for that matter? - time: 01:55 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=115 text: Well, we have to define what our inputs and outputs are, and that's what you're going to see up here at the top. - time: 02:00 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=120 text: When we come down here to configure settings, there's some things that we can include here that are specific to Shell, things like controlling how many sheets we're going to include. - time: 02:11 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=131 text: We've got some very quick, just three steps that you can walk by that will tell you kind of the who, what, when, where for configuring this. - time: 02:20 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=140 text: I'll go ahead and close out of this. - time: 02:22 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=142 text: And you'll see that when I land at this screen, all the sheets that exist in this Excel, I can choose which ones I'm going to show, which ones I'm going to hide. - time: 02:33 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=153 text: In this case, I only want my end users that are to see a singular sheet. And we're going to call that Plan Designs. - time: 02:43 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=163 text: I'll hit next, and this is where the control portion of this comes in. - time: 02:47 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=167 text: I can do things like require logins to protect unauthorized access. - time: 02:53 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=173 text: One thing we're going to always want to do is make sure that we're selecting auto-update. - time: 02:58 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=178 text: This allows one person or multiple people in the organization, depending upon your configuration, to push updates out to the masses. - time: 03:07 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=187 text: And again, you're ensuring that that control feature is in place. - time: 03:11 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=191 text: If I make a change, it gets populated out to all the other folks within the organization. - time: 03:17 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=197 text: And then finally, if I protect this, I'm going to lock it down and ensure that I don't have errant files running around that I can't control. - time: 03:26 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=206 text: So once we've walked through this, the last thing I'm going to have here is do I want to include a submit button? - time: 03:33 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=213 text: I have a lot of clients that kind of iterate through this, and I'll show you how that looks and feels once we create the shell. - time: 03:39 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=219 text: And then at a certain point in time, when they finalize, they actually want to go through and hit submit. - time: 03:44 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=224 text: Maybe the business is going to be bound, or we're going to send a formal RFP response in the case of group health. They'll utilize that submit button to be that one point in time. - time: 03:52 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=232 text: They'll utilize that submit button to be that one point in time, and then we can use that to trigger ancillary actions downstream. - time: 04:00 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=240 text: Can also finally just include some guidance text, show folks the who, what, when, where of what they're going to be doing here. - time: 04:08 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=248 text: And I'll finally get to this last step. - time: 04:11 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=251 text: So we've hit three steps just to kind of bring you into the fray here, and I'll say create this shell. - time: 04:16 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=256 text: So this is now going to go through and prompt me to upload a model of this service into Spark. - time: 04:25 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=265 text: And I'm going to go ahead and just call this a certain name. - time: 04:30 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=270 text: We've got that version control that makes Spark so good, right? - time: 04:33 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=273 text: And this is going to then create that upload into Coherent Spark, and that's going to be what we're calling, so that's the key delineation to make here, - time: 04:42 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=282 text: So that's the key delineation to make here is we're not running Excel on the user's machine anymore. - time: 04:50 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=290 text: When we actually go and want to execute different plan scenarios, that's going to be calling Coherent Spark. - time: 04:56 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=296 text: It's going to be surfacing the latest information and bringing that down into this user interface that we've developed through shell. - time: 05:06 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=306 text: So that's converted over in that short process. - time: 05:10 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=310 text: It's now going to create the shell file. - time: 05:13 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=313 text: So the next thing it's going to ask me to do here as it goes through and creates this is it's going to ask me to save a one-off or now save the created shell. - time: 05:24 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=324 text: So I'm going to call this group health shell, and we'll save this on my account. - time: 05:31 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=331 text: And what we will then be greeted with here, you'll see that our shell is ready. - time: 05:34 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=334 text: And what do we have? - time: 05:36 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=336 text: We have a singular tab, right? - time: 05:38 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=338 text: So we brought that control piece into the ecosystem. - time: 05:42 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=342 text: Folks can't see the who, what, when, where on the back end of the Excel file. - time: 05:46 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=346 text: But if we do things like make changes to, say, our deductible, you'll see that that plan information updates nearly in real time. - time: 05:57 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=357 text: And you can do things like enforce data validation. - time: 06:00 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=360 text: We're seeing that take place here in the case of deductibles. - time: 06:03 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=363 text: If I still want to make some changes, say, to ER visit costs, I can make those iteratively. - time: 06:11 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=371 text: And then at a certain point in time, hit that submit button. - time: 06:14 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=374 text: And that's going to send that final response into Spark. - time: 06:19 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=379 text: So I hope this was a good comprehensive video on how you can leverage Spark in the group health space to increase collaboration across your organization and ensure that you're still maintaining control. - time: 06:31 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=391 text: If you have any questions, please feel free to give us a call at Coherent. - time: 06:35 url: https://coherent.portal.trainn.co/oGECFYpUljYdG0l0CZ6dMQ/wwkXuHO5AjyjQ9fTIawTyw?start_time=395 text: Thanks. ## SUMMARY # Utilizing Spark Shell for Excel Collaboration Hello, this is Raman Coherent. Today, I'm going to walk you through how we can utilize Spark Shell to share Excel raters, or any Excel file that requires collaboration within an organization, while maintaining control of the individual IP that makes this rater or model impactful to your organization. We use our tool, Spark Shell, to achieve this. ## Introduction to Group Health Rater On my screen, you can see a group health rater. It allows us to quote a number of group health plans. A common issue we hear from peers is that collaboration is difficult. Multiple Excel files are sent out, and updates require sending new versions. Clients often struggle to ensure they are using the latest version, and someone has to reconcile this. ## Benefits of Coherent Spark With Coherent Spark, we can quickly bring control into this space and make updates simple. On the right side of my screen, you'll see the Coherent Assistant. This tool creates a shell, which acts as a user interface and a set of control tools, providing traceability and scenario evaluation. ## High-Level Steps to Use Spark Shell 1. **Define Inputs and Outputs:** Start by defining what your inputs and outputs are. 2. **Configure Settings:** Configure settings specific to Shell, such as the number of sheets to include. You can choose which sheets to show or hide. For example, only show the "plan design" sheet to end users. 3. **Control Access:** Require logins to protect unauthorized access. Select auto-update to ensure updates are pushed to all users. Lock down the file to prevent uncontrolled versions. 4. **Include Submit Button:** Decide if you want a submit button for finalizing and sending responses, such as an RFP response in group health. 5. **Guidance Text:** Include guidance text to explain the process to users. ## Creating the Shell After completing the steps, create the shell. Upload a model of the service into Spark, ensuring version control. This process moves Excel operations from the user's machine to Coherent Spark, providing the latest information through the user interface developed in Shell. ## Finalizing and Using the Shell Save the created shell, for example, as "group health shell." The shell will have a singular tab, maintaining control over the Excel file. Users can make changes, such as adjusting deductibles, and see updates in real time. Data validation can be enforced, and changes can be made iteratively. Finally, the submit button sends the final response into Spark. ## Conclusion I hope this video provides a comprehensive understanding of how to leverage Spark in the group health space to increase collaboration and maintain control. If you have any questions, please feel free to contact us at Coherent. Thanks.