{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Partner Instructions","Reporting Form","Formulae","columns","Checklist","Proration Calc","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":87,"n_cols":8,"rows_kept":87,"cut":false,"hidden":true,"merged":[[88,1,88,10],[38,1,39,9],[81,1,82,10],[63,1,63,10],[61,1,61,9],[65,1,65,10],[67,1,67,10],[69,1,69,10],[79,1,79,10],[86,1,86,10],[0,1,0,10],[54,1,54,10],[58,1,59,9],[32,1,32,10],[4,3,4,5],[5,3,5,5],[5,7,5,8],[6,3,6,5],[56,1,56,10],[8,7,8,8],[27,1,27,10],[22,1,22,10],[11,1,11,5],[20,1,20,10],[6,7,6,8],[7,3,7,5],[7,7,7,8],[8,3,8,5],[49,1,49,10],[77,1,77,10],[84,1,84,10],[71,1,71,10],[73,1,73,10],[75,1,75,10]]}
[null,"CISCO SYSTEMS, INC.                                                                                                                     INSTRUCTIONS FOR COMPLETING WSCA CONTRACT SALES VOLUME AND FEE REPORTING FORM"]
[]
[null,"Reporting and Fee Remittance Schedule"]
[]
[null,"Quarter",null,"Quarter Date Range",null,null,null,"Report Due Date"]
[null,"Q1",null,"January 1 through March 31",null,null,null,"April 30th"]
[null,"Q2",null,"April 1 through June 30",null,null,null,"July 31st"]
[null,"Q3",null,"July 1 through September 30",null,null,null,"October 31st"]
[null,"Q4",null,"October 1 through December 31",null,null,null,"January 31st"]
[]
[]
[null,"Submit Your Quarterly WSCA Submission's Adobe (pdf) file and/or Excel file to:",null,null,null,null,null,"Email Your WSCA Questions to:"]
[]
[null,"Phyllis Brown"]
[null,"wsca_reporting@cisco.com",null,null,null,null,null,"wsca-help@cisco.com"]
[null,"Phone:",null,"904/996-1318"]
[]
[]
[null,"Submitting Your Quarterly WSCA Report:  IMPORTANT!"]
[]
[null,"IF you are reporting WSCA sales activity for the quarter, you will need to print, sign, scan and submit the completed 'Reporting Form' tab as an Adobe (.pdf) file along with this completed Excel file to the Submission email address shown above."]
[]
[null,"IF you are reporting NO WSCA sales activity for the quarter, you will need ONLY submit this Excel file with the completed header information in the 'Reporting Form' tab to the email address shown above.  NOTE:  You MUST indicate NA in the \"Partner PO#  for Invoicing\" field (line 8) before sending this file."]
[]
[]
[null,"Instructions for Completing the Reporting Form:"]
[]
[null,"•  Authorized Signature:  By signing, you are certifying as to the accuracy of this report.  A signature is only required If you are reporting WSCA Sales Volume for the quarter."]
[]
[]
[null,"Header Line(s) Instructions:"]
[]
[null,"Enter required information in highlighted areas at the top section of this form as follows: "]
[]
[null,"•  Partner / Reseller Company Name:  Enter Channel Partner or Reseller Company name"]
[]
[null,"•  Sales Volume Report for the State of:  ",null,null,null,"Enter name of US State. (Select from Drop Down List)"]
[]
[null,"•  Prime Contract No (Contract ID):  Enter US State Prime Contract Number (this is the prime contract between US State and Cisco).  All sales and revenue data reported on this form shall be only those sales associated with this US state prime contract number."]
[]
[]
[null,"•  Quarter-End Date:  Enter quarter-end date of your reporting quarter. (Select from Drop Down List)"]
[]
[null,"•  Partner/Reseller Contact Name:  Enter Channel Partner or Reseller Company Contact Name"]
[]
[null,"•  Partner/Reseller Contact Phone:  Enter Channel Partner or Reseller Company Contact Phone"]
[]
[null,"•  Partner/Reseller Contact Email:  Enter Channel Partner or Reseller Company Contact Email"]
[]
[null,"•  Partner/Reseller Purchase Order# for Invoicing:  Enter Your Purchase Order Number for Invoicing by Cisco for Fees.  IF you are reporting No WSCA Sales THEN ENTER:  NA"]
[]
[]
[null,"Detail Line(s) Instructions:"]
[]
[null,"•  Cisco Sales Order or Transaction ID.:  Enter the Sales Order Number assigned if the order went direct -OR- the Transaction ID associated with the Order if the order went through distribution."]
[]
[null,"•  Partner PO for Transaction:  Enter Partner Order Number associated with the order submitted to Cisco/Distributor. "]
[]
[null,"•  End Customer Name:  Enter purchasing Public Sector entity's name as shown on order placed with your company."]
[]
[]
[null,"•  Buyer's Purchase Order Number:  Enter Buyer's purchase order number placed with your company."]
[]
[null,"•  Cisco Product ID:  Enter actual part number entered on your Purchase Order as submtted to Cisco/Distributor.  For Basic Install and Config Services enter \"Basic Install and Config Services\" as your Cisco Product ID."]
[]
[null,"•  Product Line Quantity:  Enter actual quantity for each Product ID."]
[]
[null,"•  Product List Price:  Enter actual Product Line List Price for each Product ID."]
[]
[null,"•  Product Line Discount %:  Enter actual discount percentage for each Product ID."]
[]
[null,"•  Service Line Quantity:  Enter actual quantity for each Product ID."]
[]
[null,"•  Service Line List Price:  Enter actual Service Line List Price for each Product ID."]
[]
[null,"•  Service Line Discount %:  Enter actual discount percentage for each Product ID."]
[]
[null,"•  Basic Install And Config Services Quantity:  Enter actual Hours for each deployment."]
[]
[null,"•  Basic Install And Config Services Hourly Rate:  Enter actual Hourly Rate as quoted on the Special Discount Letter to the state of Utah."]
[]
[null,"•  Invoice Subtotals:  The fields within these columns are automatically calculated based on reported items, quantities, units prices, sold, delivered and invoiced during the reported period.  Each line may have ONLY ONE product type: Product or Service or Basic Install and Config."]
[]
[]
[null,"•  WSCA Remittance Amount:  This is the WSCA administrative fee due and payable to the State of Utah (WSCA lead state and prime contract owner).  The fee is based on 0.5% of the total value of all items sold, delivered and invoiced.  All fee amounts in these fields are automatically calculated."]
[]
[null,"•  State Remittance Amount:  This may or may not apply to you.  This is the administrative fee due and payable to the Participating State if they impose an administrative fee on WSCA sales activity.  The fee amount varies by state.  The fee is based on a percentage of the total value of all items sold, delivered and invoiced.  All fee amounts in these fields are automatically calculated."]

{"sheet":"Partner Instructions","index":1,"n_rows":69,"n_cols":6,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"CISCO SYSTEMS, INC.  ",null,"REFERENCES"]
[null,"CONTRACT SALES VOLUME & FEE REPORT INSTRUCTIONS"]
[null,null,null,"For any Reporting Web Portal Help, contact:  "]
["STEP:","If you are reporting SALES for the quarter/month:",null,"cmo-portal@cisco.com "]
[1,"Complete and submit separate sales reports for each contract your company is authorized to sell under."]
[2,"Log into the Cisco Public Sector Contract Sales Reporting Web Portal (link on the right ->) and download the most recent reporting template from the reports section.",null,"Cisco Sales Volume Reporting Portal"]
[3,"Click on \"Reports\" along the top nav bar. Click on \"upload report\" button.",null,"https://cisco.datagainservices.com/"]
[4,"Select the correct Contract from the list, click next on the top right hand side. Select the Reporting Year and period. "]
[5,"Click the \"Browse\" button to navigate to the completed Report file on your hard drive and select the file. Or drag and drop the file into the grey box. ",null,null,null,"Service SKU prefixes:"]
[6,"Click the \"Done\" button (top right hand side).",null,null,null,"AS-"]
[7,"Review the Report submission details.  If correct, click the \"Confirm\" button.  If incorrect, click the \"Cancel\" button and repeat steps 1-7.",null,null,null,"A-FLEX-"]
[null,null,null,null,null,"ASF-"]
["STEP:","If you are reporting NO $0 SALES for the quarter/month:",null,null,null,"A-WEBEX-"]
[1,"Log into the Cisco Public Sector Contract Sales Reporting Web Portal (link on the right ->).",null,null,null,"CIC-"]
[2,"Click on \"Reports\" along the top nav bar. Click on \"upload report\" button.",null,null,null,"CON-"]
[3,"Select the correct Contract from the list, click next on the top right hand side. Select the Reporting Year and period. ",null,null,null,"CTIR-"]
[4,"Select the checkbox for \"No Sales\".",null,null,null,"CTSA-"]
[5,"Click the \"Done\" button (top right hand side).",null,null,null,"CX-"]
[6,"Review the Report submission details.  If correct, click the \"Confirm\" button.  If incorrect, click the \"Cancel\" button and repeat steps 1-6.",null,null,null,"CX-"]
[null,null,null,null,null,"E2F-SEC-"]
[null,"Read and understand the CERTIFICATION Message:  ",null,null,null,"E2-N-"]
[null,"By submitting this report on behalf of my company, I certify the following:  ",null,null,null,"E2SF-C-"]
[1,"The report submitted is complete and accurate.",null,null,null,"E3A-HXDP-"]
[2,"Payment for applicable Administrative Fees owed pursuant to the submitted report will be paid within 30 days of receipt of the Cisco Invoice.  ",null,null,null,"E3A-TE-"]
[null,null,null,null,null,"E3C-WEBEX-"]
["ROW:","Header Section Field Descriptions:",null,null,null,"E3H-TE-"]
[1,"Partner Name:  Enter Partner/Reseller Full Legal Company Name.",null,null,null,"E3H-WEBEX-"]
[2,"State/Contract ID:  Select from drop-down list the US State the sales data being reported is in reference to.",null,null,null,"E3N-DNAS-"]
[3,"Reporting Period Ending Date: Select from the drop-down list and choose the quarter/month (whichever is applicable) end date of the sales data that is being reported. As an example, we will assume it is October 7th, ####, and we are going to be reporting for Q3CY## so we will select 09/30/####.",null,null,null,"E3N-SPACES-"]
[4,"Contact Name:  Enter Partner/Reseller Company Contact Name.",null,null,null,"E3-SEC-"]
[5,"Contact Phone:  Enter Partner/Reseller Company Contact Phone #.",null,null,null,"FLMESH-SERVICE"]
[6,"Contact Email:  Enter Partner/Reseller Company Contact Email. Email will be used as POC for any issues.",null,null,null,"HXDP-"]
[7,"Partner PO# for Admin Fee Invoicing: Enter Reseller’s valid PO# that will be issued to pay for applicable Contract Admin Fees. Enter placeholder PO# (ex. NVPDataComCTQ3CY##) if PO# is not available.",null,null,null,"KT-"]
[8,"Spreadsheet Message: NO ENTRY REQUIRED - If any header or detail section cell is blank or is identified to have a problem, an error message will appear in this row. ",null,null,null,"OSS-"]
[null,null,null,null,null,"PPS-"]
["COL:","Detail Section Field Descriptions:",null,null,null,"SD-"]
["A","Spreadsheet Message: NO ENTRY REQUIRED - If any detail section cell is blank or is identified to have a problem, a descriptive error message will appear in the “Spreadsheet Message” column for the applicable row. ",null,"Valid Exception Entries:",null,"SP-"]
["B","Cisco Sales Order or Transaction ID:  Enter the Sales Order Number assigned if the order went direct -OR- the Transaction ID associated with the Order if the order went through distribution.",null,"N/A",null,"SVS-"]
["C","Partner PO Number (To Cisco or Disti):  Enter Partner's Purchase Order Number associated with the order submitted to Cisco/Distributor. ",null,"1) “WEB ID ########” (MarketPlace number) - If a Cisco SO has not yet been generated, enter the MarketPlace number assigned to the order.\n2) “N/R” (Not Retained) – allowed if you are a Cisco Certified National Direct Integrator only.(ie. CDW or GovConnection)\n3) “N/A” (Not Applicable) – Valid only for Basic Install & Config orders being reported",null,"SVS-"]
["D","Partner PO Date (To Cisco or Disti): Enter the date of Partner’s Purchase Order associated with the order submitted to Cisco/Distributor. Must be in MM/DD/YYYY format.",null,"N/A” (Not Applicable) – Valid only for Basic Install & Config orders being reported",null,"SVTRN-"]
["E","Customer Name: Enter purchasing Public Sector Customer name EXACTLY as shown on order placed with Partner",null,"For Basic Install and Config orders enter the last date of the reporting period (03/31/####, 06/30/####, 09/30/####, 12/31/####). \nN/A is not allowed.",null,"TIS-"]
["F","Partner Assigned Customer ID: if your Company uses a unique # for your Customers, enter it here. ",null,"None",null,"TRN-"]
["G","Customer Type: Select from Drop-Down List the type of Purchasing Public Sector Entity associated to the order.",null,"“N/A” (Not Applicable) – If a unique # is not assigned to customers, this does not apply\nFor Oregon MUST input the end customer’s email address.",null,"TS-"]
["H","Partner to Customer Invoice Number for Transaction: Enter Partner's invoice number to the Purchasing Entity associated to the order.",null,"Note: You must select a category from the drop down list. You will not be allowed to type in this field.",null,"WTY-"]
["I","Partner to Customer Invoice Date for Transaction:   Enter the date of Partner's invoice number to the Purchasing Entity associated to the order. Must be in MM/DD/YYYY format.",null,"Reporting based on Customer PO Date: “TBD” (To Be Determined) - If the order has been submitted to Cisco/Disti but the Public Sector Customer has not yet been invoiced. \nReporting based on Customer Invoice Date: Does not allow TBD in this column."]
["J","Customer's PO Number:  Enter Customer’s purchase order number placed with Partner.",null,"Reporting based on Customer PO Date: If the order has been submitted to Cisco/Disti but the Public Sector Customer has not yet been invoiced, enter the last date of the reporting period (ie. 12/31/#### for an order being reported in Q4CY##)."]
["K","Customer's PO Date: Enter the date of Customer’s purchase order number placed with Partner.",null,"1) Signed SOW – must include Signed SOW number\n2) Signed Quote – must include Signed Quote number\n3) P-Card/Credit Card Purchase – must include the confirmation number"]
["L","Customer Ship To Date: Enter the date the item(s) shipped/will ship to the customer. Must be in MM/DD/YYYY format.",null,"None"]
["M","Customer Ship To Name: Enter the contact name that was listed on the Public Sector Customer’s shipping label or ordering documentation.",null,"Reporting based on Customer PO Date: If the order has been submitted to Cisco/Disti but there is no confirmed shipment date to the  Public Sector Customer, enter the last date of the reporting period (ie. 12/31/#### for an order being reported in Q4CY##)."]
["N","Customer Ship To Address - Street: Enter the number and full street name that was listed on the Public Sector Customer’s shipping label or ordering documentation. PO boxes are not allowed.",null,"None"]
["O","Customer Ship To Address - City: Enter the City name that was listed on the Public Sector Customer’s shipping label or ordering documentation.",null,"None"]
["P","Customer Ship To Address - State: Enter the state that was listed on the Public Sector Customer’s shipping label or ordering documentation.",null,"None"]
["Q","Customer Ship To Address - Zip: Enter the zip code that was listed on the Public Sector Customer’s shipping label or ordering documentation.",null,"None"]
["R","Customer Bill-To Name: Enter the name that was listed on the Public Sector Customer’s purchase order as the Bill-To.",null,"None"]
["S","Customer Bill-To Address - Street: Enter the number and full street name that was listed on the Public Sector Customer’s purchase order as the actual Bill-To.",null,"None"]
["T","Customer Bill-To Address - City: Enter the full City name that was listed on the Public Sector Customer’s purchase order as the actual Bill-To.",null,"None"]
["U","Customer Bill-To Address - State: Enter the state that was listed on the Public Sector Customer’s purchase order as the actual Bill-To.",null,"None"]
["V","Customer Bill-To Address - Zip: Enter the zip code that was listed on the Public Sector Customer’s purchase order as the actual Bill-To.",null,"None"]
["W","Type of Sale:  Select from Drop-Down List the type of sale. Credits should be identified as such in this column. If Type of Sale does not correlate to the SKU being entered in Column X, an error message will appear in Column A. Please ensure this matches the Customer Type Column for SMARTnet services.",null,"None"]
["X","Product/Service SKU OR \"Basic Install & Config\":  Enter the EXACT SKU for Product/Service per the published  contract Pricelist.  For BI&C, enter “Basic Install & Config”.  *Refer to the current pricelist posted on the Cisco.com Contract website. ",null,"None"]
["Y","Product/Service Description OR \"Basic Install & Config\":  Enter the EXACT Description for Product/Service per the published contract Pricelist OR for BI&C, enter “Basic Install & Config”.  *Refer to the current pricelist posted on the Cisco.com Contract website.",null,"Enter “Basic Install & Config” - For Authorized Partner Services"]
["Z","Prod/Srvc Qty OR BI&C Hours: Enter the actual quantity for each Product/Service SKU OR Total number of Basic Install & Config Hours.",null,"1) Enter “Basic Install & Config” - For Authorized Partner Services\n2) If Credits: Return was identified in Column  X,  type “RMA#”(and include the RMA number) "]
["AA","Unit List Price OR BI&C Hourly Rate per Contract Price List:  Enter the Unit List Price based on the time of customer PO for each Product/Service SKU per the published Contract Price List OR Partner’s Basic Install & Config NTE Hourly Rate. *Refer to the contract price lists posted on the Cisco.com Contract website. DO NOT USE CCW or DISTI PRICING\nContract Price Lists: https://cisco.com/go/cmo-contracts",null,"If SKU is a credit, enter a negative quantity."]
["AB","Product/Service/ BI&C Total Net Amount: Enter the total net selling price for each Product/Service SKU OR Partner’s Basic Install & Config Hourly Rate.",null,"Notes:\n1) Product/Service SKU per the published Contract Price List on the applicable Cisco.com contract Website. \n2) Please ensure you are using the correct Contract Price List based on the customer’s PO date.\n3) BI&C Hourly Rate must not exceed published rates on the applicable Contract docs"]
["AC","Product/ Service Discount %:   NO ENTRY REQUIRED- This column calculates the sales discount based on reported items’ Unit List Price and Total Net Amount entered in columns AA-AB. All amounts in this column are automatically calculated. ",null,"N/A"]
["AD","Product/Service Unit Net Price OR BI&C Hourly Rate: NO ENTRY REQUIRED - Net selling price for each Product/Service SKU OR Partner’s Basic Install & Config Hourly Rate.",null,"Note: This needs to meet or exceed the contracts minimum required discounts"]
["AE","Contract Admin Fee Amount:  NO ENTRY REQUIRED-This column calculates the Contract administrative fee due and payable to the Contract Administrator. The fee amount is based on a percentage of the Net Purchase Price.  All fee amounts in this column are automatically calculated.",null,"N/A"]
["AF","State Admin Fee Amount:  (IF APPLICABLE), NO ENTRY REQUIRED-This column calculates the State Administrative fee due and payable to the Participating State if they impose an administrative fee on contract sales activity.  The fee amount varies by state and is based on a percentage of the Net Purchase Price   All fee amounts in this column are automatically calculated.",null,"N/A"]
[null,null,null,"N/A"]

{"sheet":"Reporting Form","index":2,"n_rows":110,"n_cols":32,"rows_kept":110,"cut":false,"hidden":false,"merged":[[7,1,7,9],[6,27,6,31],[1,2,1,4],[4,2,4,3],[0,0,0,1],[1,0,1,1],[0,2,0,4],[3,2,3,4],[6,2,6,3],[2,0,2,1],[2,2,2,3],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[5,2,5,4]]}
["Partner Name:"]
["State/Contract ID:",null,null,null,null,null,"Reporting Rows"]
["Reporting Period Ending Date:",null,null,null,null,null,100]
["Contact Name:"]
["Contact Phone:"]
["Contact Email:"]
["Partner PO#  for Admin Fee Invoicing:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals"]
[{"$f":"IF(ISTEXT(C1), IF(COUNTBLANK(C1:C7)>0,\"WARNING:\",\"\"),\"\")&IF(SUMPRODUCT(--(LEN(INDIRECT(\"A10:A\"&G3+9))>0))>0,\"WARNING:\",IF($AB$8 < 0, \"WARNING:\", \"\"))","v":""},{"$f":"IF(ISTEXT(C1), IF(COUNTBLANK(C1:C7)>0,\"Input your Company's submission information in all input cells on rows 1 through 7.  \",\"\"),\"\")&IF(SUMPRODUCT(--(LEN(INDIRECT(\"A10:A\"&G3+9))>0))>0,\"You Must Correct \"&SUMPRODUCT(--(LEN(INDIRECT(\"A10:A\"&G3+9))>0))&\" Row\" & IF(SUMPRODUCT(--(LEN(INDIRECT(\"A10:A\"&G3+9))>0))>1,\"s\",\"\") & \" With ERRORS Below BEFORE Submitting Your File To CISCO.\",\"\")\n& IF($AB$8 < 0, \" Total Sales must never be negative\", \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Totals:",{"$f":"SUM(AB10:AB109)","v":0},null,null,{"$f":"SUM(AE10:AE109)","v":{"$error":"#N/A"}},{"$f":"SUM(AF10:AF109)","v":{"$error":"#N/A"}}]
["Spreadsheet Message","Cisco Sales Order\nor Disti Transaction ID","Partner PO Number\n(To Cisco or Disti) ","Partner PO Date\n(To Cisco or Disti) ","Customer Name","Partner Assigned Customer ID","Customer Type","Partner to Customer Invoice\nNumber for Transaction","Partner to Customer Invoice\nDate for Transaction","Customer PO Number","Customer PO Date","Customer Ship To Date","Customer Ship To Name","Customer Ship To Address - Street","Customer Ship To Address - City","Customer Ship To Address - State","Customer Ship To Address - Zip","Customer Bill-To Name","Customer Bill-To Address - Street","Customer Bill-To Address - City","Customer Bill-To Address - State","Customer Bill-To Address - Zip","Type of Sale","Product/Service SKU \nOR  \n\"Basic Install & Config\" ","Product/Service Description \nOR  \n\"Basic Install & Config\" ","Prod/Srvc Qty \nOR \nBI&C Hours ","Unit List Price OR BI&C Hourly Rate per Contract Price List","Product/Service/ BI&C \nTotal Net Amount","Product/ Service Discount %","Product/Service Unit Net \nPrice OR BI&C Hourly Rate","Contract Admin Fee Amount","State Admin Fee Amount"]
[{"$f":"IF(  AND(COUNTBLANK( $B10:$AB10 )  <> 27,COUNTBLANK( $B10:$AB10 )  >0),\n\"\" & COUNTBLANK( $B10:$AB10 ) & \" Empty Column\" & IF(COUNTBLANK( $B10:$AB10 ) > 1,\"s\",\"\") & \" on this row. \",\nIF( AND( LEFT( W10, 1 ) = \"S\", ISTEXT( VLOOKUP( LEFT( X10, FIND(\"-\",X10,1) ), ServicePrefixTable, 1, 0 ) ) = FALSE, ISTEXT(VLOOKUP(LEFT( X10, FIND(\"-\",X10,FIND(\"-\",X10,1)+1)), TwoDashServicePrefixTable, 1, 0)) = FALSE),\n\"ERROR: If Column W indicates a 'Service' Type, then the SKU in Column X MUST CONTAIN a Service SKU Prefix. Refer to instructions tab for SKU prefixes.\",\nIF( AND((ISNA(_xlfn.XLOOKUP(X10,ServiceSKUExceptions,ServiceSKUExceptions))), LEFT( W10, 1 ) = \"P\", OR( ISTEXT( VLOOKUP( LEFT( X10,FIND(\"-\",X10,1)), ServicePrefixTable, 1, 0 ) ) ) ),\n\"ERROR: If Column W indicates a 'Product' Type, then the SKU in Column X MAY NOT CONTAIN a Service SKU Prefix. Refer to instructions tab for SKU prefixes.\",\nIF(AND($AA10 < 0), \"ERROR: Unit List Price (AA) cannot be negative\",\nIF(AND(OR($W10=\"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)\",$W10=\"Credits->Error Shipping/Order (Incl RMA# in col Y)\",$W10=\"Credits->Subject to Cisco CMO Approval\"),OR($Z10>0,$AB10>0)),\n\"Column Z (Quantity) and Column AB (Total Net Price) must be negative for credits\",\nIF(AND(NOT(OR($W10=\"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)\",$W10=\"Credits->Error Shipping/Order (Incl RMA# in col Y)\",$W10=\"Credits->Subject to Cisco CMO Approval\")),OR($Z10<0,$AB10<0)),\n\"Column Z (Quantity) and Column AB (Total Net Price) must be positive for non-credits\",\"\"\n))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(OR(AA10=\"\",AD10=\"\"),\"\",(AA10-AD10)/AA10)),0,IF(OR(AA10=\"\",AD10=\"\"),\"\",(AA10-AD10)/AA10))","v":""},{"$f":"IFERROR(ROUND(AB10/Z10,9),0)","v":0},{"$f":"ROUND(AB10*VLOOKUP(C$2,State_Ref,2,0),9)","v":{"$error":"#N/A"}},{"$f":"ROUND(AB10*VLOOKUP(C$2,State_Ref,3,0),9)","v":{"$error":"#N/A"}}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(OR(AA11=\"\",AD11=\"\"),\"\",(AA11-AD11)/AA11)),0,IF(OR(AA11=\"\",AD11=\"\"),\"\",(AA11-AD11)/AA11))","v":""},{"$f":"IFERROR(ROUND(AB11/Z11,9),0)","v":0},{"$f":"ROUND(AB11*VLOOKUP(C$2,State_Ref,2,0),9)","v":{"$error":"#N/A"}},{"$f":"ROUND(AB11*VLOOKUP(C$2,State_Ref,3,0),9)","v":{"$error":"#N/A"}}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"IF(  AND(COUNTBLANK( $B42:$AB42 )  <> 27,COUNTBLANK( $B42:$AB42 )  >0),\n\"\" & COUNTBLANK( $B42:$AB42 ) & \" Empty Column\" & IF(COUNTBLANK( $B42:$AB42 ) > 1,\"s\",\"\") & \" on this row. \",\nIF( AND( LEFT( W42, 1 ) = \"S\", ISTEXT( VLOOKUP( LEFT( X42, FIND(\"-\",X42,1) ), ServicePrefixTable, 1, 0 ) ) = FALSE, ISTEXT(VLOOKUP(LEFT( X42, FIND(\"-\",X42,FIND(\"-\",X42,1)+1)), TwoDashServicePrefixTable, 1, 0)) = FALSE),\n\"ERROR: If Column W indicates a 'Service' Type, then the SKU in Column X MUST CONTAIN a Service SKU Prefix. Refer to instructions tab for SKU prefixes.\",\nIF( AND((ISNA(_xlfn.XLOOKUP(X42,ServiceSKUExceptions,ServiceSKUExceptions))), LEFT( W42, 1 ) = \"P\", OR( ISTEXT( VLOOKUP( LEFT( X42,FIND(\"-\",X42,1)), ServicePrefixTable, 1, 0 ) ) ) ),\n\"ERROR: If Column W indicates a 'Product' Type, then the SKU in Column X MAY NOT CONTAIN a Service SKU Prefix. Refer to instructions tab for SKU prefixes.\",\nIF(AND($AA42 < 0), \"ERROR: Unit List Price (AA) cannot be negative\",\nIF(AND(OR($W42=\"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)\",$W42=\"Credits->Error Shipping/Order (Incl RMA# in col Y)\",$W42=\"Credits->Subject to Cisco CMO Approval\"),OR($Z42>0,$AB42>0)),\n\"Column Z (Quantity) and Column AB (Total Net Price) must be negative for credits\",\nIF(AND(NOT(OR($W42=\"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)\",$W42=\"Credits->Error Shipping/Order (Incl RMA# in col Y)\",$W42=\"Credits->Subject to Cisco CMO Approval\")),OR($Z42<0,$AB42<0)),\n\"Column Z (Quantity) and Column AB (Total Net Price) must be positive for non-credits\",\"\"\n))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"IF(  AND(COUNTBLANK( $B74:$AB74 )  <> 27,COUNTBLANK( $B74:$AB74 )  >0),\n\"\" & COUNTBLANK( $B74:$AB74 ) & \" Empty Column\" & IF(COUNTBLANK( $B74:$AB74 ) > 1,\"s\",\"\") & \" on this row. \",\nIF( AND( LEFT( W74, 1 ) = \"S\", ISTEXT( VLOOKUP( LEFT( X74, FIND(\"-\",X74,1) ), ServicePrefixTable, 1, 0 ) ) = FALSE, ISTEXT(VLOOKUP(LEFT( X74, FIND(\"-\",X74,FIND(\"-\",X74,1)+1)), TwoDashServicePrefixTable, 1, 0)) = FALSE),\n\"ERROR: If Column W indicates a 'Service' Type, then the SKU in Column X MUST CONTAIN a Service SKU Prefix. Refer to instructions tab for SKU prefixes.\",\nIF( AND((ISNA(_xlfn.XLOOKUP(X74,ServiceSKUExceptions,ServiceSKUExceptions))), LEFT( W74, 1 ) = \"P\", OR( ISTEXT( VLOOKUP( LEFT( X74,FIND(\"-\",X74,1)), ServicePrefixTable, 1, 0 ) ) ) ),\n\"ERROR: If Column W indicates a 'Product' Type, then the SKU in Column X MAY NOT CONTAIN a Service SKU Prefix. Refer to instructions tab for SKU prefixes.\",\nIF(AND($AA74 < 0), \"ERROR: Unit List Price (AA) cannot be negative\",\nIF(AND(OR($W74=\"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)\",$W74=\"Credits->Error Shipping/Order (Incl RMA# in col Y)\",$W74=\"Credits->Subject to Cisco CMO Approval\"),OR($Z74>0,$AB74>0)),\n\"Column Z (Quantity) and Column AB (Total Net Price) must be negative for credits\",\nIF(AND(NOT(OR($W74=\"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)\",$W74=\"Credits->Error Shipping/Order (Incl RMA# in col Y)\",$W74=\"Credits->Subject to Cisco CMO Approval\")),OR($Z74<0,$AB74<0)),\n\"Column Z (Quantity) and Column AB (Total Net Price) must be positive for non-credits\",\"\"\n))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(OR(AA75=\"\",AD75=\"\"),\"\",(AA75-AD75)/AA75)),0,IF(OR(AA75=\"\",AD75=\"\"),\"\",(AA75-AD75)/AA75))","v":""},{"$f":"IFERROR(ROUND(AB75/Z75,9),0)","v":0},{"$f":"ROUND(AB75*VLOOKUP(C$2,State_Ref,2,0),9)","v":{"$error":"#N/A"}},{"$f":"ROUND(AB75*VLOOKUP(C$2,State_Ref,3,0),9)","v":{"$error":"#N/A"}}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,{"$error":"#N/A"},{"$error":"#N/A"}]
["Total Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AB10:AB109)","v":0},null,null,{"$f":"SUM(AE10:AE109)","v":{"$error":"#N/A"}},{"$f":"SUM(AF10:AF109)","v":{"$error":"#N/A"}}]

{"sheet":"Formulae","index":3,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Row Count","Last Used Row"]
["Reporting Interval Assigned:",{"$f":"VLOOKUP('Reporting Form'!$C$2,B$3:E$1000,4,0)","v":{"$error":"#N/A"}},null,null,null,"Contract Type of Sale: (NC, CO, ALL)",null,null,null,"Type of Sale (NC, CO, ALL):",{"$f":"VLOOKUP('Reporting Form'!$C$2,B$3:F$1000,5,0)","v":{"$error":"#N/A"}},null,null,100,"IF(  AND(COUNTBLANK( $B10:$AB10 )  <> 27,COUNTBLANK( $B10:$AB10 )  >0),\n\"\" & COUNTBLANK( $B10:$AB10 ) & \" Empty Column\" & IF(COUNTBLANK( $B10:$AB10 ) > 1,\"s\",\"\") & \" on this row. \",\nIF( AND( LEFT( W10, 1 ) = \"S\", ISTEXT( VLOOKUP( LEFT( X10, FIND(\"-\",X10,1) ), ServicePrefixTable, 1, 0 ) ) = FALSE, ISTEXT(VLOOKUP(LEFT( X10, FIND(\"-\",X10,FIND(\"-\",X10,1)+1)), TwoDashServicePrefixTable, 1, 0)) = FALSE),\n\"ERROR: If Column W indicates a 'Service' Type, then the SKU in Column X MUST CONTAIN a Service SKU Prefix. Refer to instructions tab for SKU prefixes.\",\nIF( AND((ISNA(XLOOKUP(X10,ServiceSKUExceptions,ServiceSKUExceptions))), LEFT( W10, 1 ) = \"P\", OR( ISTEXT( VLOOKUP( LEFT( X10,FIND(\"-\",X10,1)), ServicePrefixTable, 1, 0 ) ) ) ),\n\"ERROR: If Column W indicates a 'Product' Type, then the SKU in Column X MAY NOT CONTAIN a Service SKU Prefix. Refer to instructions tab for SKU prefixes.\",\nIF(AND($AA10 < 0), \"ERROR: Unit List Price (AA) cannot be negative\",\nIF(AND(OR($W10=\"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)\",$W10=\"Credits->Error Shipping/Order (Incl RMA# in col Y)\",$W10=\"Credits->Subject to Cisco CMO Approval\"),OR($Z10>0,$AB10>0)),\n\"Column Z (Quantity) and Column AB (Total Net Price) must be negative for credits\",\nIF(AND(NOT(OR($W10=\"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)\",$W10=\"Credits->Error Shipping/Order (Incl RMA# in col Y)\",$W10=\"Credits->Subject to Cisco CMO Approval\")),OR($Z10<0,$AB10<0)),\n\"Column Z (Quantity) and Column AB (Total Net Price) must be positive for non-credits\",\"\"\n))))))"]
["State","Contract ID","Contract Remit %","State Remit %","Rep Interval (Q/M)","No Cloud(NC), Cloud Only(CO), All(All)",{"$f":"TODAY()","v":45666},null,null,"Type of Sale - No Cloud (NC)","Type of Sale - Cloud Only (CO)","Type of Sale - ALL (ALL)","Purchasing Entity Type"]
["ALASKA","AK – #AR2477",2.5000000000000001E-3,1.4999999999999999E-2,"Q","CO",null,null,null,"Product->Hardware","Product->Cloud","Product->Hardware","Gov-State"]
["ALASKA","AK - NVP AR3227",2.5000000000000001E-3,1.4999999999999999E-2,"Q","ALL",{"$f":"YEAR(G3)","v":2025},null,null,"Product->Software License(s)","Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)","Product->Software License(s)","Gov-County"]
["ALABAMA","AL - ALJP 2022-071",0,0,"Q","ALL",{"$f":"MONTH(G3)","v":1},null,null,"Services->SMARTnet->Education->1-YR & 2-YR","Credits->Error Shipping/Order (Incl RMA# in col Y)","Product->Cloud","Gov-Local (City, Parish, Township)"]
["ALABAMA","AL - ALJP2019-034",0,0,"Q","ALL","QED","MED",null,"Services->SMARTnet->Education->3-YR & 4-YR","Credits->Subject to Cisco CMO Approval","Services->SMARTnet->Education->1-YR & 2-YR","Edu-HE"]
["ARKANSAS","AR - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",{"$f":"EOMONTH(DATE(YEAR(G3-90),MOD(_xlfn.CEILING.MATH(MONTH(G3)/3,1)*3-4,12)+1,1),0)","v":45657},{"$f":"EOMONTH(H18,0)","v":45596},null,"Services->SMARTnet->Education->5-YR+","Services->Other Technical Services","Services->SMARTnet->Education->3-YR & 4-YR","Edu-K-12"]
["CALIFORNIA","CA - NVP AR3227",2.5000000000000001E-3,1.2500000000000001E-2,"Q","ALL",{"$f":"EOMONTH(DATE(YEAR(G3),_xlfn.CEILING.MATH(MONTH(G3)/3,1)*3,1),0)","v":45747},45626,null,"Services->SMARTnet->Government->1-YR & 2-YR",null,"Services->SMARTnet->Education->5-YR+","Non-Profit"]
["COLORADO","CO - NVP #AR3227",2.5000000000000001E-3,0.01,"Q","ALL",{"$f":"EOMONTH(DATE(YEAR(G3),MOD(_xlfn.CEILING.MATH(MONTH(G3)/3,1)*3-10,12)+1,1),0)","v":45838},45657,null,"Services->SMARTnet->Government->3-YR & 4-YR",null,"Services->SMARTnet->Government->1-YR & 2-YR","Healthcare"]
["CONNECTICUT","CT - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL",{"$f":"EOMONTH(DATE(YEAR(G3),MOD(_xlfn.CEILING.MATH(MONTH(G3)/6,1)*6-10,12)+1,1),0)","v":45930},45688,null,"Services->SMARTnet->Government->5-YR+",null,"Services->SMARTnet->Government->3-YR & 4-YR","American Indian Tribes"]
["DISTRICT OF COLUMBIA","DC - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL",null,45716,null,"Services->Advanced/Combined Svs",null,"Services->SMARTnet->Government->5-YR+"]
["DELAWARE","DE - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL",null,45747,null,"Services->Other Technical Services",null,"Services->Advanced/Combined Svs"]
["FLORIDA","FL - NVP AR3227",2.5000000000000001E-3,7.0000000000000001E-3,"M","ALL",null,45777,null,"Services->Training/Learning Credits",null,"Services->Other Technical Services"]
["FLORIDA","FL - NVP AR3227- City of Palm Coast",2.5000000000000001E-3,0,"Q","ALL",null,null,null,"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)",null,"Services->Training/Learning Credits"]
["GEORGIA","GA - GA NEIT Cloud",1.4999999999999999E-2,0,"Q","CO",null,null,null,"Credits->Error Shipping/Order (Incl RMA# in col Y)",null,"Credits->Damaged or Dead on Arrival (Incl RMA# in col Y)"]
["GEORGIA","GA 99999-SPD-T20120501-0006",1.4999999999999999E-2,0,"Q","ALL",null,"+= 3 Months",null,"Credits->Subject to Cisco CMO Approval",null,"Credits->Error Shipping/Order (Incl RMA# in col Y)"]
["GEORGIA","GA 99999-SPD-SPD0000219-0002",0.01,0,"Q","ALL",null,{"$f":"DATE(YEAR($G$3),MONTH($G$3)-3,1)","v":45566},null,"Basic->Install & Config",null,"Credits->Subject to Cisco CMO Approval"]
["HAWAII","HI - NVP AR3227",2.5000000000000001E-3,1.4999999999999999E-2,"Q","ALL",null,{"$f":"DATE(YEAR($G$3),MONTH($G$3)-2,1)","v":45597},null,null,null,"Basic->Install & Config"]
["IOWA","IA - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,{"$f":"DATE(YEAR($G$3),MONTH($G$3)-1,1)","v":45627},null,"Begin Service Prefixes"]
["IDAHO","ID - NVP AR3227",2.5000000000000001E-3,1.2500000000000001E-2,"Q","ALL",null,{"$f":"DATE(YEAR($G$3),MONTH($G$3),1)","v":45658},null,"AS-"]
["INDIANA","IN - PA-12921",0,0,"Q","NC",null,{"$f":"DATE(YEAR($G$3),MONTH($G$3)+1,1)","v":45689},null,"ASF-"]
["KANSAS","KS - NVP AR3227 ",2.5000000000000001E-3,5.0000000000000001E-3,"Q","ALL",null,{"$f":"DATE(YEAR($G$3),MONTH($G$3)+2,1)","v":45717},null,"CTIR-"]
["KENTUCKY","KY – KETS Network MA 758 2100000651",0,0,"Q","NC",null,{"$f":"DATE(YEAR($G$3),MONTH($G$3)+3,1)","v":45748},null,"CTSA-"]
["KENTUCKY","KY – KETS Server MA 758 2000000719",0,0,"Q","NC",null,null,null,"CX-"]
["KENTUCKY","KY - NVP AR3227 ",2.5000000000000001E-3,5.0000000000000001E-3,"Q","ALL",null,null,null,"CIC-"]
["KENTUCKY","KY - UK-1704-17A",0,0,"Q","NC",null,null,null,"CON-"]
["LOUISIANA","LA - NVP AR3227 #4400021188 UC",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,"CX-"]
["LOUISIANA","LA - NVP AR3227 #4400021189 ",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,"HXDP-"]
["MICHIGAN","MI - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,"KT-"]
["MISSOURI","MO – #AR2477",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,"OSS-"]
["MISSOURI","MO - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,"PPS-"]
["MONTANA","MT - NVP AR3227",2.5000000000000001E-3,1.4999999999999999E-2,"Q","ALL",null,null,null,"SVS-"]
["NORTH CAROLINA","NC - DPI E-rate",0,0,"Q","NC",null,null,null,"SD-"]
["NORTH CAROLINA","NC - ITS-204X",0,0,"Q","NC",null,null,null,"SP-"]
["NEBRASKA","NE - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,"SVS-"]
["NEW HAMPSHIRE","NH - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL",null,null,null,"SVTRN-"]
["NEW JERSEY","NJ - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL",null,null,null,"TIS-","Service Exceptions","Special Service/Product Prefixes, 2nd dash"]
["NEW MEXICO","NM - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,"TRN-","SD-IE-1GB=","A-FLEX-"]
["NEVADA","NV - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,"TS-","SD-IE-4GB","A-WEBEX-"]
["NEW YORK","NY - NYS Umbrella PM20800",7.4999999999999997E-3,0,"M","ALL",null,null,null,"WTY-","SD-IE-4GB=","E2F-SEC-"]
["OHIO","OH - 533110-3",7.4999999999999997E-3,0,"Q","NC",null,null,null,null,"SD-X45-2GB-E-RF","E2-N-"]
["OHIO","OH - 534612",7.4999999999999997E-3,0,"Q","NC",null,null,null,"End Service Prefixes",null,"E2SF-C-"]
["OKLAHOMA","OK - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,null,null,"E3A-HXDP-"]
["OREGON","OR - NVP AR3227",2.5000000000000001E-3,0.02,"Q","ALL",null,null,null,null,null,"E3A-TE-"]
["RHODE ISLAND","RI - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,null,null,"E3C-WEBEX-"]
["SOUTH DAKOTA","SD - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL",null,null,null,null,null,"E3H-TE-"]
["TENNESSEE","TN - NVP AR3227",2.5000000000000001E-3,0.01,"Q","ALL",null,null,null,null,null,"E3H-WEBEX-"]
["TEXAS","TX - DIR-TSO-4167",7.4999999999999997E-3,0,"M","ALL",null,null,null,null,null,"E3N-DNAS-"]
["TEXAS","TX - DIR-CPO-5347",7.4999999999999997E-3,0,"M","ALL",null,null,null,null,null,"E3N-SPACES-"]
["UTAH","UT - NVP AR3227",2.5000000000000001E-3,2.5000000000000001E-3,"Q","ALL",null,null,null,null,null,"E3-SEC-"]
["VIRGINIA ","VA - 7365172JC",0,0,"Q","NC",null,null,null,null,null,"FLMESH-SERVICE-"]
["VERMONT","VT - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL",null,null,null,null,null,"End Special Service/Product Prefixes, 2nd dash"]
["WASHINGTON","WA - NVP AR3227",2.5000000000000001E-3,1.4999999999999999E-2,"Q","ALL"]
["WISCONSIN","WI - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL"]
["WYOMING","WY - NVP AR3227",2.5000000000000001E-3,0,"Q","ALL"]

{"sheet":"columns","index":4,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["Cisco Sales Order or Transaction ID"]
["Partner PO Number (To Cisco or Disti) "]
["Partner PO Date (To Cisco or Disti) "]
["Partner to Purchasing Entity's Invoice Number for Transaction"]
["Partner to Purchasing Entity's Invoice Date for Transaction"]
["Purchasing Entity's PO Number"]
["Purchasing Entity's PO Date"]
["Puchasing Entity Type"]
["Purchasing Entity Name"]
["Purchasing Entity Contact Address"]
["Product or Service (P or S)?"]
["Cisco Product or Service SKU (ensure this is the SKU from the Cisco Posted MSRP Pricelist)"]
["Cisco Product or Service Description (ensure this is the Description from the Cisco Posted MSRP Pricelist)"]
["Product/Svc Line Quantity"]
["Product/Svc Line List Price"]
["Product/Svc Line Discount %"]
["Product/Svc Line Goods Value"]
["Basic Install And Config Services Quantity"]
["Basic Install And Config Services Hourly Rate"]
["Basic Install And Config Services Value"]
["Total Sales Volume"]
["WSCA Remittance Amount"]
["State Remittance Amount"]

{"sheet":"Checklist","index":5,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[null,"Reporting Template Completion Checklist"]
[]
["Report Completion:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Report Validation Completion:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Price List Check:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Credits:"]
[]
[]
[]
[]
[]
[]
[]
["General Requirements:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Checklist Completed By: ","_________________________",null,null,"Date Completed: ____________________"]

{"sheet":"Proration Calc","index":6,"n_rows":401,"n_cols":11,"rows_kept":401,"cut":false,"hidden":false,"merged":[[6,0,6,5],[6,6,6,9]]}
["Instructions:"]
["1) Fill in the start and end dates (columns A and B) with the service dates from the customer quote/PO. All contract pricing is based on a 12 month (1 year) duration."]
["2) Fill in columns C-F from the customer quote/PO and the contract price list (column E). Ensure Contract Unit List Price matches the Contract Price List."]
["3) On the Sales Volume Report use the quantity calculated in column J and ensure the Contract Unit List Price matches the Contract Price List. "]
["4) If you need additional help review the FAQ.",null,null,"FAQ"]
["5) This tool only applies to calculating prorated service SKUs (SMARTnet, Maintenance, etc…)."]
["Input Data Here",null,null,null,null,null,"Calculated Fields"]
["Start Date","End Date","SKU (Column X)","Original Quantity (Column Z)","Contract Unit List Price (Column AA)","Total Net Amount (Column AB)","Discount","Unit Net Price","# of Days","Prorated Qty to Use on Report"]
[43583,44074,"CON-SNT-WSC3851E",1,976,1181.6300000000001,{"$f":"((E9-(F9/J9))/E9)","v":0.1018281229174996},{"$f":"(F9/J9)","v":876.61575203252039},{"$f":"1+(_xlfn.DAYS(B9,A9))","v":492},{"$f":"(I9/365)*D9","v":1.3479452054794521},"EXAMPLE - Over 1 Year"]
[43583,44074,"CON-SNT-WSC3851E",2,976,2363.2399999999998,0.10183572404371595,876.60833333333323,492,2.6958904109589041,"EXAMPLE - Over 1 Year with 2 SKUs purchased"]
[44075,45900,"CON-SNT-WSC3851E",1,976,3855.2,0.21043263964950712,770.61774370208104,1826,5.0027397260273974,"EXAMPLE - 5 Year SKU"]
[44123,44196,"CON-SNT-WSC296FP",1,661.83,115.11,0.14211761736805936,567.77229729729731,74,0.20273972602739726,"EXAMPLE - Less than 1 Year"]
[43900,44196,"CON-SSC4P-AF240CSX",3,2993.69,6577.08,0.10000217854404503,2694.3144781144779,297,2.441095890410959,"EXAMPLE - Less than 1 Year with 3 SKUs purchased"]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0,"Fill in the green"]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$f":"((E73-(F73/J73))/E73)","v":{"$error":"#DIV/0!"}},{"$f":"(F73/J73)","v":{"$error":"#DIV/0!"}},{"$f":"1+(_xlfn.DAYS(B73,A73))","v":1},{"$f":"(I73/365)*D73","v":0}]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$f":"((E137-(F137/J137))/E137)","v":{"$error":"#DIV/0!"}},{"$f":"(F137/J137)","v":{"$error":"#DIV/0!"}},{"$f":"1+(_xlfn.DAYS(B137,A137))","v":1},{"$f":"(I137/365)*D137","v":0}]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$f":"((E201-(F201/J201))/E201)","v":{"$error":"#DIV/0!"}},{"$f":"(F201/J201)","v":{"$error":"#DIV/0!"}},{"$f":"1+(_xlfn.DAYS(B201,A201))","v":1},{"$f":"(I201/365)*D201","v":0}]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$f":"((E265-(F265/J265))/E265)","v":{"$error":"#DIV/0!"}},{"$f":"(F265/J265)","v":{"$error":"#DIV/0!"}},{"$f":"1+(_xlfn.DAYS(B265,A265))","v":1},{"$f":"(I265/365)*D265","v":0}]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$f":"((E329-(F329/J329))/E329)","v":{"$error":"#DIV/0!"}},{"$f":"(F329/J329)","v":{"$error":"#DIV/0!"}},{"$f":"1+(_xlfn.DAYS(B329,A329))","v":1},{"$f":"(I329/365)*D329","v":0}]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$f":"((E393-(F393/J393))/E393)","v":{"$error":"#DIV/0!"}},{"$f":"(F393/J393)","v":{"$error":"#DIV/0!"}},{"$f":"1+(_xlfn.DAYS(B393,A393))","v":1},{"$f":"(I393/365)*D393","v":0}]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]
[null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1,0]

{"sheet":"Version","index":7,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Version","Date"]
[17,45666]