Spreadsheet: 122237d1316689863-excel-2007-insert-a-column-based-on-a-cells-value-col-insert-upld
Sheet: CRYSTAL_PERSIST

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME] Version="4" ConsolidateParameter="True" WebServiceURL="http://boapp:8080/dswsbobje/services/session" CMSName="BOAPP.carolinahandling.com%3A6400"><AddinModuleData ID="CRADDIN"><Reports><Report reportTitle="SVCS 02.  5 - Customer Equipment Expe
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nses by Category Type" cms="cms" cuid="AWdwUfPjJC1Ej5mjwgxJRK4" connection_id="1" viewpoint_id="1" free_layout="False" relational_business_view="False" depends_on_metadata="False" ReportPath="/Service Department/Customers/External"><Container ContainerCUID
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ="" ContainerKind="1"/><ReportDefinition><ViewFields/><GroupConditionFields><RelationalField fieldName="EQUIPMENT_DIM.SERIAL_NBR" FormulaForm="{EQUIPMENT_DIM.SERIAL_NBR}" fieldKind="1" fieldType="11" RecurringFormulaField="False" DisplayName="SERIAL_NBR"/>
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME] fieldName="SERVICE_CFPM_FACT.DOCUMENT_NUMBER" FormulaForm="{SERVICE_CFPM_FACT.DOCUMENT_NUMBER}" fieldKind="1" fieldType="11" RecurringFormulaField="False" DisplayName="DOCUMENT_NUMBER"/><RelationalField fieldName="SERVICE_CFPM_FACT.OFS_ID"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FormulaForm="{SERVICE_CFPM_FACT.OFS_ID}" fieldKind="1" fieldType="6" RecurringFormulaField="False" DisplayName="OFS_ID"/></GroupConditionFields><DrillBackFields/><ViewFilters/><Parameters><ParameterField fieldName="Start Date" FormulaForm="{?Start Date}"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DisplayName="Start Date" BindType="4" FieldType="9" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="2011-1-1T0:0:0"/></CurrentValues></ParameterField><ParameterField fieldName="End Date" FormulaForm="{?End Date}
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | " DisplayName="End Date" BindType="4" FieldType="9" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="2011-8-31T0:0:0"/></CurrentValues></ParameterField><ParameterField fieldName="Customer Number" FormulaForm="{?C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ustomer Number}" DisplayName="Customer Number" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="80601229"/></CurrentValues></ParameterField><ParameterField fieldName="Want details only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ?" FormulaForm="{?Want details only?}" DisplayName="Want details only?" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="1"/></CurrentValues></ParameterField><ParameterField fieldName=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Exclude Catagory:" FormulaForm="{?Exclude [NAME]:}" DisplayName="Exclude Catagory:" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="-1"/></CurrentValues></ParameterField><Parameter
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Field fieldName="Action/Job Codes" FormulaForm="{?Action/Job Codes}" DisplayName="Action/Job Codes" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="C"/></CurrentValues></ParameterFiel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d><ParameterField fieldName="Street" FormulaForm="{?Street}" DisplayName="Street" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="*"/></CurrentValues></ParameterField><ParameterField
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | fieldName="City" FormulaForm="{?City}" DisplayName="City" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="*"/></CurrentValues></ParameterField></Parameters></ReportDefinition><Views/>
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <ReportXViews><View view_id="2" id="1" group_path_is_null="False" Conceal_data_when_saving="False" Inherit_report_part_formatting="False" Keep_user_format="True" Instance_by_user="False" Username="" Refresh_DB="True" Use_specific_instance="False" specific_
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]"" specific_instance_description="" Use_Report_Saved_Data="False" Logon_User_Instance="False" Need_format="False" Custom_view_name="SVCS 02.  5 - Customer Equipment Expenses by Category Type Report Part" Last_refresh_status="1" Last_refresh_d
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | escription="" Last_refresh_time="2011-9-22T10:21:34" Last_refresh_time_taken="4250"><ReportPart data_context="" topn_data_context="" record_no="-1" object_name="CrossTab1" type="22" id="1" formula="" in_table="False" view_context="" section_name="ReportHea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | derSection1" page="1" uses_view_context="False" instancekind="15" object_value_type=""/><Regions><Region name="HHeading" LOGICAL_COL_START="2" LOGICAL_COL_END="2" LOGICAL_ROW_START="1" LOGICAL_ROW_END="1" DataRowCount="1" DataColCount="7"><LayoutManager [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nkRows="True" LinkCols="False" Version="1.0" RegionName="HHeading"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region name="VHeading" LOGICAL_COL_START="1" LOGICAL_COL_END="1" LOGICAL_ROW_START="2" LOGICAL_ROW_END="2" Da
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | taRowCount="5" DataColCount="3"><LayoutManager LinkRows="False" LinkCols="True" Version="1.0" RegionName="VHeading"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region name="DataGrid" LOGICAL_COL_START="2" LOGICAL_COL_END
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ="2" LOGICAL_ROW_START="2" LOGICAL_ROW_END="2" DataRowCount="5" DataColCount="7"><LayoutManager LinkRows="True" LinkCols="True" Version="1.0" RegionName="DataGrid"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region name=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Space" LOGICAL_COL_START="1" LOGICAL_COL_END="1" LOGICAL_ROW_START="1" LOGICAL_ROW_END="1" DataRowCount="1" DataColCount="3"><LayoutManager LinkRows="False" LinkCols="False" Version="1.0" RegionName="Space"><CustomRows Axis="Row"/><CustomColumns Axis="Col
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | umn"/></LayoutManager></Region></Regions></View></ReportXViews><ReportPartsContained><ReportParts Conceal_data_when_saving="False" Inherit_report_part_formatting="False" Keep_user_format="False" Instance_by_user="False" Username="" Refresh_DB="False" Use_s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pecific_instance="False" specific_instance_cuid="" specific_instance_description="" Use_Report_Saved_Data="False" Logon_User_Instance="False" Need_format="True"><ReportPart data_context="" topn_data_context="" record_no="-1" object_name="CrossTab1" type="2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2" id="1" formula="" in_table="False" view_context="" section_name="ReportHeaderSection1" page="1" uses_view_context="False" instancekind="15" object_value_type=""/></ReportParts></ReportPartsContained><OrgReportParts><ReportParts Conceal_data_when_saving=
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "False" Inherit_report_part_formatting="False" Keep_user_format="False" Instance_by_user="False" Username="" Refresh_DB="False" Use_specific_instance="False" specific_instance_cuid="" specific_instance_description="" Use_Report_Saved_Data="False" Logon_Use
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r_Instance="False" Need_format="True"/></OrgReportParts><ReportPartViews/><ReportPageViews/><DetailViews/><ParameterBindings/></Report><Report reportTitle="SVCS 02.  5 - Customer Equipment Expenses by Category Type" cms="cms" cuid="AWdwUfPjJC1Ej5mjwgxJRK4"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | connection_id="2" viewpoint_id="1" free_layout="False" relational_business_view="False" depends_on_metadata="False" ReportPath="/Service Department/Customers/External"><Container ContainerCUID="" ContainerKind="1"/><ReportDefinition><ViewFields/><GroupCon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ditionFields><RelationalField fieldName="EQUIPMENT_DIM.SERIAL_NBR" FormulaForm="{EQUIPMENT_DIM.SERIAL_NBR}" fieldKind="1" fieldType="11" RecurringFormulaField="False" DisplayName="SERIAL_NBR"/><RelationalField fieldName="SERVICE_CFPM_FACT.DOCUMENT_NUMBER"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FormulaForm="{SERVICE_CFPM_FACT.DOCUMENT_NUMBER}" fieldKind="1" fieldType="11" RecurringFormulaField="False" DisplayName="DOCUMENT_NUMBER"/><RelationalField fieldName="SERVICE_CFPM_FACT.OFS_ID" FormulaForm="{SERVICE_CFPM_FACT.OFS_ID}" fieldKind="1" fieldTy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pe="6" RecurringFormulaField="False" DisplayName="OFS_ID"/></GroupConditionFields><DrillBackFields/><ViewFilters/><Parameters><ParameterField fieldName="Start Date" FormulaForm="{?Start Date}" DisplayName="Start Date" BindType="4" FieldType="9" AllowMultip
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | leValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="2010-1-1T0:0:0"/></CurrentValues></ParameterField><ParameterField fieldName="End Date" FormulaForm="{?End Date}" DisplayName="End Date" BindType="4" FieldType="9" AllowMultip
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | leValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="2010-12-31T0:0:0"/></CurrentValues></ParameterField><ParameterField fieldName="Customer Number" FormulaForm="{?Customer Number}" DisplayName="Customer Number" BindType="4" Fi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="80601229"/></CurrentValues></ParameterField><ParameterField fieldName="Want details only?" FormulaForm="{?Want details only?}" DisplayName="Want detai
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ls only?" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="1"/></CurrentValues></ParameterField><ParameterField fieldName="Exclude Catagory:" FormulaForm="{?Exclude [NAME]:}" Display
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name="Exclude [NAME]:" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="-1"/></CurrentValues></ParameterField><ParameterField fieldName="Action/Job Codes" FormulaForm="{?Action/Job C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | odes}" DisplayName="Action/Job Codes" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="C"/></CurrentValues></ParameterField><ParameterField fieldName="Street" FormulaForm="{?Street}" D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | isplayName="Street" BindType="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="*"/></CurrentValues></ParameterField><ParameterField fieldName="City" FormulaForm="{?City}" DisplayName="City" Bind
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type="4" FieldType="11" AllowMultipleValues="False" IsOptional="False"><CurrentValues><DiscreteValue type="2" value="*"/></CurrentValues></ParameterField></Parameters></ReportDefinition><Views/><ReportXViews><View view_id="2" id="1" group_path_is_null="Fal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | se" Conceal_data_when_saving="False" Inherit_report_part_formatting="False" Keep_user_format="True" Instance_by_user="False" Username="" Refresh_DB="True" Use_specific_instance="False" specific_instance_cuid="" specific_instance_description="" Use_Report_S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | aved_Data="False" Logon_User_Instance="False" Need_format="False" Custom_view_name="SVCS 02.  5 - Customer Equipment Expenses by Category Type Report Part (1)" Last_refresh_status="1" Last_refresh_description="" Last_refresh_time="2011-9-22T10:23:39" Last_
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | refresh_time_taken="5688"><ReportPart data_context="" topn_data_context="" record_no="-1" object_name="CrossTab1" type="22" id="1" formula="" in_table="False" view_context="" section_name="ReportHeaderSection1" page="1" uses_view_context="False" instanceki
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nd="15" object_value_type=""/><Regions><Region name="HHeading" LOGICAL_COL_START="2" LOGICAL_COL_END="2" LOGICAL_ROW_START="1" LOGICAL_ROW_END="1" DataRowCount="1" DataColCount="6"><LayoutManager LinkRows="True" LinkCols="False" Version="1.0" RegionName="H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heading"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region name="VHeading" LOGICAL_COL_START="1" LOGICAL_COL_END="1" LOGICAL_ROW_START="2" LOGICAL_ROW_END="2" DataRowCount="6" DataColCount="4"><LayoutManager [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | alse" LinkCols="True" Version="1.0" RegionName="VHeading"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region name="DataGrid" LOGICAL_COL_START="2" LOGICAL_COL_END="2" LOGICAL_ROW_START="2" LOGICAL_ROW_END="2" DataRowCoun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t="6" DataColCount="6"><LayoutManager LinkRows="True" LinkCols="True" Version="1.0" RegionName="DataGrid"><CustomRows Axis="Row"/><CustomColumns Axis="Column"/></LayoutManager></Region><Region name="Space" LOGICAL_COL_START="1" LOGICAL_COL_END="1" LOGICAL_
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROW_START="1" LOGICAL_ROW_END="1" DataRowCount="1" DataColCount="4"><LayoutManager LinkRows="False" LinkCols="False" Version="1.0" RegionName="Space"><CustomRows [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | iews><ReportPartsContained><ReportParts Conceal_data_when_saving="False" Inherit_report_part_formatting="False" Keep_user_format="False" Instance_by_user="False" Username="" Refresh_DB="False" Use_specific_instance="False" specific_instance_cuid="" specifi
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | c_instance_description="" Use_Report_Saved_Data="False" Logon_User_Instance="False" Need_format="True"><ReportPart data_context="" topn_data_context="" record_no="-1" object_name="CrossTab1" type="22" id="1" formula="" in_table="False" view_context="" sect
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ion_name="ReportHeaderSection1" page="1" uses_view_context="False" instancekind="15" object_value_type=""/></ReportParts></ReportPartsContained><OrgReportParts><ReportParts Conceal_data_when_saving="False" Inherit_report_part_formatting="False" Keep_user_f
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ormat="False" Instance_by_user="False" Username="" Refresh_DB="False" Use_specific_instance="False" specific_instance_cuid="" specific_instance_description="" Use_Report_Saved_Data="False" Logon_User_Instance="False" Need_format="True"/></OrgReportParts><R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eportPartViews/><ReportPageViews/><DetailViews/><ParameterBindings/></Report></Reports></AddinModuleData></CrystalAddin>