<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>N52 Formula Manager</Author>
  <LastAuthor>N52 Formula Manager</LastAuthor>
  <Created>4/21/2016 4:36:04 PM</Created>
  <LastSaved>4/21/2016 4:36:04 PM</LastSaved>
  <Company>N52 Formula Manager</Company>
  <Version>12.00</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>10005</WindowHeight>
  <WindowWidth>10005</WindowWidth>
  <WindowTopX>110</WindowTopX>
  <WindowTopY>125</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="10" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
 </Styles>
 <Worksheet ss:Name="Formula">
  <Table><Row>
<Cell><Data ss:Type="String">Name</Data></Cell>
<Cell><Data ss:Type="String">Formula Type</Data></Cell>
<Cell><Data ss:Type="String">Formula Description</Data></Cell>
<Cell><Data ss:Type="String">Status</Data></Cell>
<Cell><Data ss:Type="String">Status Reason</Data></Cell>
<Cell><Data ss:Type="String">Source Entity Name</Data></Cell>
<Cell><Data ss:Type="String">Source Entity Property</Data></Cell>
<Cell><Data ss:Type="String">Source Relationship</Data></Cell>
<Cell><Data ss:Type="String">Target Entity Name</Data></Cell>
<Cell><Data ss:Type="String">Target Entity Property</Data></Cell>
<Cell><Data ss:Type="String">Event</Data></Cell>
<Cell><Data ss:Type="String">Stage</Data></Cell>
<Cell><Data ss:Type="String">Display Format</Data></Cell>
<Cell><Data ss:Type="String">Auto Number Value</Data></Cell>
<Cell><Data ss:Type="String">Execution Order</Data></Cell>
<Cell><Data ss:Type="String">Message</Data></Cell>
<Cell><Data ss:Type="String">Enable PreValue Check</Data></Cell>
<Cell><Data ss:Type="String">Enable Find Function FetchXml Optimization</Data></Cell>
<Cell><Data ss:Type="String">Source Entity Property PreValue Check</Data></Cell>
<Cell><Data ss:Type="String">Category</Data></Cell>
<Cell><Data ss:Type="String">Sub Category</Data></Cell>
<Cell><Data ss:Type="String">Source Entity Property ClientSide</Data></Cell>
<Cell><Data ss:Type="String">Mode</Data></Cell>
<Cell><Data ss:Type="String">ShortCode</Data></Cell>
<Cell><Data ss:Type="String">Deployment Solution</Data></Cell>
<Cell><Data ss:Type="String">ClientSide Data Payload</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">Request - Owner on Change</Data></Cell>
<Cell><Data ss:Type="String">217890013</Data></Cell>
<Cell><Data ss:Type="String">if ([incident.vhacrm_lobidname] = &#39;Help Desk&#39; or [incident.vhacrm_lobidname] = &#39;Health Benefits&#39; or [incident.vhacrm_lobidname] = &#39;HRC&#39;,
   
     SmartFlow(
     
     SetVar(&#39;OldAuditRecord&#39;, FindValueFD(&#39;OldAuditRecords&#39;, &#39;vhacrm_requestroutingauditid&#39;)),
       
     if ( ContainsData([incident.owninguser]),
       CreateRecord(&#39;vhacrm_requestroutingaudit&#39;, 
       SetAttributeLookup(&#39;vhacrm_requestid&#39;, &#39;incident&#39;, [incident.incidentid]),
       SetAttribute(&#39;vhacrm_name&#39;, [vhacrm_requestroutingaudit.createdon]),
       SetAttributeLookup(&#39;ownerid&#39;, &#39;systemuser&#39;, [incident.ownerid])
     ),
       CreateRecord(&#39;vhacrm_requestroutingaudit&#39;, 
       SetAttributeLookup(&#39;vhacrm_requestid&#39;, &#39;incident&#39;, [incident.incidentid]),
       SetAttribute(&#39;vhacrm_name&#39;, [vhacrm_requestroutingaudit.createdon]),
       SetAttributeLookup(&#39;ownerid&#39;, &#39;team&#39;, [incident.ownerid])
     )),
       
       if(ContainsData(GetVar(&#39;OldAuditRecord&#39;)), 
       UpdateRecord(&#39;vhacrm_requestroutingaudit&#39;, ToString(GetVar(&#39;OldAuditRecord&#39;)),
         SetAttribute(&#39;vhacrm_daysassigned_number&#39;,[incident.vhacrm_daysatassignment_number]),
         SetAttributeStatus(1, 2)
        ), 
        &#39;NoOp&#39;
       ),
       
       if( ContainsData(GetVar(&#39;OldAuditRecord&#39;)),
       UpdateRecord(&#39;incident&#39;, [incident.incidentid], 
        SetAttribute(&#39;vhacrm_daysatassignment_number&#39;, &#39;0&#39;)
        ),
         &#39;NoOp&#39;) /*,
       
       SetVar(&#39;relatednote&#39;, FindValueFD(&#39;GetOwnersCaseNotesForToday&#39;, &#39;vhacrm_casenoteid&#39;, &#39;no&#39;, true)),
       
       if (GetVar(&#39;relatednote&#39;) = &#39;no&#39;,
        SetFormNotification(&#39;A completed Case Note is required when assigning or changing status.&#39;, &#39;WARNING&#39;, &#39;req&#39;),
        ClearFormNotification(&#39;req&#39;))*/,
     
     SmartFlowReturn(&#39;NoOp&#39;)
     ) ,
   
   &#39;NoOp&#39;
)</Data></Cell>
<Cell><Data ss:Type="String">0</Data></Cell>
<Cell><Data ss:Type="String">1</Data></Cell>
<Cell><Data ss:Type="String">incident</Data></Cell>
<Cell><Data ss:Type="String">ownerid</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">217890002</Data></Cell>
<Cell><Data ss:Type="String">217890001</Data></Cell>
<Cell><Data ss:Type="String">217890000</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">False</Data></Cell>
<Cell><Data ss:Type="String">True</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">217890002</Data></Cell>
<Cell><Data ss:Type="String">yld</Data></Cell>
<Cell><Data ss:Type="String">North52FormulaManagerDeploymentSolution</Data></Cell>
<Cell><Data ss:Type="String">*:CreateUpdate</Data></Cell>
</Row>

  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>6</ActiveRow>
     <ActiveCol>1</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>