// [NOTE] moved all the constants here to make it easier to update

export const postalCode = {
  'al': 'AL', 'ak': 'AK', 'az': 'AZ', 'ar': 'AR', 'ca': 'CA', 'co': 'CO', 'ct': 'CT',
  'de': 'DE', 'fl': 'FL', 'ga': 'GA', 'hi': 'HI', 'id': 'ID', 'il': 'IL', 'in': 'IN',
  'ia': 'IA', 'ks': 'KS', 'ky': 'KY', 'la': 'LA', 'me': 'ME', 'md': 'MD', 'ma': 'MA',
  'mi': 'MI', 'mn': 'MN', 'ms': 'MS', 'mo': 'MO', 'mt': 'MT', 'ne': 'NE', 'nv': 'NV',
  'nh': 'NH', 'nj': 'NJ', 'nm': 'NM', 'ny': 'NY', 'nc': 'NC', 'nd': 'ND',
  'oh': 'OH', 'ok': 'OK', 'or': 'OR', 'pa': 'PA', 'ri': 'RI', 'sc': 'SC',
  'sd': 'SD', 'tn': 'TN', 'tx': 'TX', 'ut': 'UT', 'vt': 'VT', 'va': 'VA', 'wa': 'WA',
  'wv': 'WV', 'wi': 'WI', 'wy': 'WY'
};

export const stateToPostalCode = {
  'alabama': 'AL', 'alaska': 'AK', 'arizona': 'AZ', 'arkansas': 'AR',
  'california': 'CA', 'colorado': 'CO', 'connecticut': 'CT',
  'delaware': 'DE', 'florida': 'FL', 'georgia': 'GA', 'hawaii': 'HI',
  'idaho': 'ID', 'illinois': 'IL', 'indiana': 'IN', 'iowa': 'IA',
  'kansas': 'KS', 'kentucky': 'KY',
  'louisiana': 'LA',
  'maine': 'ME', 'maryland': 'MD', 'massachusetts': 'MA', 'michigan': 'MI', 'minnesota': 'MN', 'mississippi': 'MS', 'missouri': 'MO', 'montana': 'MT',
  'nebraska': 'NE', 'nevada': 'NV', 'new hampshire': 'NH', 'new jersey': 'NJ', 'new mexico': 'NM', 'new york': 'NY', 'north carolina': 'NC', 'north dakota': 'ND',
  'ohio': 'OH', 'oklahoma': 'OK', 'oregon': 'OR',
  'pennsylvania': 'PA',
  'rhode island': 'RI',
  'south carolina': 'SC', 'south dakota': 'SD',
  'tennessee': 'TN', 'texas': 'TX',
  'utah': 'UT',
  'vermont': 'VT', 'virginia': 'VA',
  'washington': 'WA', 'west virginia': 'WV', 'wisconsin': 'WI', 'wyoming': 'WY',
};
export const specificTwoLetters = {
  'of': 'of',
  'to': 'to',
  'in': 'in',
  'on': 'on',
  'at': 'at',
  'by': 'by',
  'an': 'an',
  'or': 'or',
  'as': 'as',
  'so': 'so',
    // unique two letters
  'us': 'US',
  'bg': 'BG',
  'td': 'TD',
  'm4': 'M4',
  'po': 'PO',

};
export const specificNames = {
  "and": "and",
  "llp": "LLP",
  "llc": "LLC",
  "plc": "PLC",
  "n.a.": "N.A.",
  
  'usa': 'USA',
  // unique names
  'jpmorgan': 'JPMorgan',
  'lvnv': 'LVNV',
  'pnc': 'PNC',
  'm&t': 'M&T',
  "cks": "CKS",
  'cbe': 'CBE',
  'cit': 'CIT',
  'rsh': 'RSH',
  'dba': 'DBA',
  'spv': 'SPV',
  'uhg': 'UHG',
  'bmo': 'BMO',

};

export const fields = [
  'today', 'currentDate', 'currentDateMM-DD-YYYY',
  // client info
  'clientFirstName', 'clientMiddleName', 'clientLastName','SSN',
  'homeAddress', 'homeCity', 'homeState', 'homeZip',
  'homeCounty', 'homePhone', 'cellPhone', 'email',
  'dob', 'alias', 'clientNamePrefix', 'clientNameSuffix',
  'SSNLastFour', 'dmcName',
  'client2FirstName', 'client2MiddleName', 'client2LastName','client2SSN',
  'client2homeAddress', 'client2homeCity', 'client2homeState','client2homeZip',
  'client2homeCounty', 'client2homePhone', 'client2cellPhone','client2email',
  'client2dob', 'client2alias', 'client2NamePrefix','client2NameSuffix',
  'SSN2LastFour',
  // case info
  'caseDesignation', 'caseCounty', 'caseState', 'caseDivisionDesignation', 'caseDivisionLocation',
  'caseNumber', 'casePlaintiff', 'caseDefendant', 'caseOpposingCounsel',
  'caseSuitAmount', 'caseSuitTheory', 'caseOriginalCreditor', 'caseAccountNumber',
  'caseAnswerDate', 'caseDivisionNumber', 'caseDivisionJudge', 'discoCosDate', 'discoCosDateString', 'discoResponseCosDate', 'discoResponseCosDateString','discoDueDays',
  'caseFilingDate', 'caseFilingAttorney', 'caseAccLastFour',
  
  'caseOCAddressLine1', 'caseOCAddressLine2', 'caseOCFileNumber', 'caseOCPhone', 'caseOCFax', 'caseOCEmail',
  'caseAttybarMO', 'caseAttybarKS','caseAttyAddressLine1', 'caseAttyAddressLine2', 'caseAttyPhone', 'caseAttyFax', 'caseAttyEmail', 'caseAttyEmail2', 'caseAttyFirm',

   'caseAnswerDateOnly','caseFilingDateString','caseAnswerDateYYYY-MM-DD', 'caseAnswerDateTime', 'caseAnswerDateString', 'caseAnswerFiledDate', "caseAnswerFiledDateString",
  'caseAppearanceInfo', 'caseDisposition', 'caseDispositionDate', 'caseDispositionDateString',

 'casePlaintiffFileName',
  // settlement info
  'settlementOffer', 'settlementOfferAmount','settlementOfferPercent', 'settlementOfferPercentExpected', 'settlementOfferPercentCurrent', 'settlementOfferExpected', 'settlementOfferCurrent',
  'settlementAmount', 'settlementInstallmentAmount', 'settlementInstallmentAmountString', 'settlementFirstPaymentDate', 'settlementInstallmentNo', 'settlementInterestRate', 'settlementCaseCosts', 'settlementTotalInterest',
  'settlementPayee', 'paymentOptions',
  'settlementPaymentDate',
  'settlementPaymentDate00','settlementPaymentDate01','settlementPaymentDate02','settlementPaymentDate03','settlementPaymentDate04','settlementPaymentDate05','settlementPaymentDate06','settlementPaymentDate07','settlementPaymentDate08','settlementPaymentDate09',
  'settlementPaymentDate10','settlementPaymentDate11','settlementPaymentDate12','settlementPaymentDate13','settlementPaymentDate14','settlementPaymentDate15','settlementPaymentDate16','settlementPaymentDate17','settlementPaymentDate18','settlementPaymentDate19',
  'settlementPaymentDate20','settlementPaymentDate21','settlementPaymentDate22','settlementPaymentDate23','settlementPaymentDate24','settlementPaymentDate25','settlementPaymentDate26','settlementPaymentDate27','settlementPaymentDate28','settlementPaymentDate29',
  'settlementPaymentDate30','settlementPaymentDate31','settlementPaymentDate32','settlementPaymentDate33','settlementPaymentDate34','settlementPaymentDate35','settlementPaymentDate36','settlementPaymentDate37','settlementPaymentDate38','settlementPaymentDate39',
  'settlementPaymentDate40','settlementPaymentDate41','settlementPaymentDate42','settlementPaymentDate43','settlementPaymentDate44','settlementPaymentDate45','settlementPaymentDate46','settlementPaymentDate47','settlementPaymentDate48','settlementPaymentDate49',
  'settlementPaymentDate50','settlementPaymentDate51','settlementPaymentDate52','settlementPaymentDate53','settlementPaymentDate54','settlementPaymentDate55','settlementPaymentDate56','settlementPaymentDate57','settlementPaymentDate58','settlementPaymentDate59',
  'settlementPaymentDate60',
  
  'settlementPaymentAmount00','settlementPaymentAmount01','settlementPaymentAmount02','settlementPaymentAmount03','settlementPaymentAmount04','settlementPaymentAmount05','settlementPaymentAmount06','settlementPaymentAmount07','settlementPaymentAmount08','settlementPaymentAmount09',
  'settlementPaymentAmount10','settlementPaymentAmount11','settlementPaymentAmount12','settlementPaymentAmount13','settlementPaymentAmount14','settlementPaymentAmount15','settlementPaymentAmount16','settlementPaymentAmount17','settlementPaymentAmount18','settlementPaymentAmount19',
  'settlementPaymentAmount20','settlementPaymentAmount21','settlementPaymentAmount22','settlementPaymentAmount23','settlementPaymentAmount24','settlementPaymentAmount25','settlementPaymentAmount26','settlementPaymentAmount27','settlementPaymentAmount28','settlementPaymentAmount29',
  'settlementPaymentAmount30','settlementPaymentAmount31','settlementPaymentAmount32','settlementPaymentAmount33','settlementPaymentAmount34','settlementPaymentAmount35','settlementPaymentAmount36','settlementPaymentAmount37','settlementPaymentAmount38','settlementPaymentAmount39',
  'settlementPaymentAmount40','settlementPaymentAmount41','settlementPaymentAmount42','settlementPaymentAmount43','settlementPaymentAmount44','settlementPaymentAmount45','settlementPaymentAmount46','settlementPaymentAmount47','settlementPaymentAmount48','settlementPaymentAmount49',
  'settlementPaymentAmount50','settlementPaymentAmount51','settlementPaymentAmount52','settlementPaymentAmount53','settlementPaymentAmount54','settlementPaymentAmount55','settlementPaymentAmount56','settlementPaymentAmount57','settlementPaymentAmount58','settlementPaymentAmount59',
  'settlementPaymentAmount60',

  'settlementRemaingBalance00','settlementRemaingBalance01','settlementRemaingBalance02','settlementRemaingBalance03','settlementRemaingBalance04','settlementRemaingBalance05','settlementRemaingBalance06','settlementRemaingBalance07','settlementRemaingBalance08','settlementRemaingBalance09',
  'settlementRemaingBalance10','settlementRemaingBalance11','settlementRemaingBalance12','settlementRemaingBalance13','settlementRemaingBalance14','settlementRemaingBalance15','settlementRemaingBalance16','settlementRemaingBalance17','settlementRemaingBalance18','settlementRemaingBalance19',
  'settlementRemaingBalance20','settlementRemaingBalance21','settlementRemaingBalance22','settlementRemaingBalance23','settlementRemaingBalance24','settlementRemaingBalance25','settlementRemaingBalance26','settlementRemaingBalance27','settlementRemaingBalance28','settlementRemaingBalance29',
  'settlementRemaingBalance30','settlementRemaingBalance31','settlementRemaingBalance32','settlementRemaingBalance33','settlementRemaingBalance34','settlementRemaingBalance35','settlementRemaingBalance36','settlementRemaingBalance37','settlementRemaingBalance38','settlementRemaingBalance39',
  'settlementRemaingBalance40','settlementRemaingBalance41','settlementRemaingBalance42','settlementRemaingBalance43','settlementRemaingBalance44','settlementRemaingBalance45','settlementRemaingBalance46','settlementRemaingBalance47','settlementRemaingBalance48','settlementRemaingBalance49',
  'settlementRemaingBalance50','settlementRemaingBalance51','settlementRemaingBalance52','settlementRemaingBalance53','settlementRemaingBalance54','settlementRemaingBalance55','settlementRemaingBalance56','settlementRemaingBalance57','settlementRemaingBalance58','settlementRemaingBalance59',
  'settlementRemaingBalance60',
  
  // fee info
  'fee', 'discountRate', 'installmentAmount',  'installmentDate', 'installmentNumber',
  'nameOnCard', 'cardNumber', 'securityCode', 'expiration',

  'installmentDate0', 'installmentDate1', 'installmentDate2', 'installmentDate3', 'installmentDate4', 'installmentDate5', 
  'installmentDate6', 'installmentDate7', 'installmentDate8', 'installmentDate9', 'installmentDate10',

  'installmentAmount0', 'installmentAmount1', 'installmentAmount2', 'installmentAmount3', 'installmentAmount4', 'installmentAmount5',
  'installmentAmount6', 'installmentAmount7', 'installmentAmount8', 'installmentAmount9', 'installmentAmount10',

  'feeRemainingBalance0', 'feeRemainingBalance1', 'feeRemainingBalance2', 'feeRemainingBalance3', 'feeRemainingBalance4', 'feeRemainingBalance5',
  'feeRemainingBalance6', 'feeRemainingBalance7', 'feeRemainingBalance8', 'feeRemainingBalance9', 'feeRemainingBalance10',


  'billingAddress', 'billingZip',
  // debt collector info
  'debtCollector1Name', 'debtCollector1Creditor', 'debtCollector1Account', 'debtCollector1Amount', 'debtCollector1AddressLine1', 'debtCollector1AddressLine2','debtCollector1AccLastFour', 
  'debtCollector2Name', 'debtCollector2Creditor', 'debtCollector2Account', 'debtCollector2Amount', 'debtCollector2AddressLine1', 'debtCollector2AddressLine2', 'debtCollector2AccLastFour',
  'debtCollector3Name', 'debtCollector3Creditor', 'debtCollector3Account', 'debtCollector3Amount', 'debtCollector3AddressLine1', 'debtCollector3AddressLine2', 'debtCollector3AccLastFour',
  'debtCollector4Name', 'debtCollector4Creditor', 'debtCollector4Account', 'debtCollector4Amount', 'debtCollector4AddressLine1', 'debtCollector4AddressLine2', 'debtCollector4AccLastFour',
  'debtCollector5Name', 'debtCollector5Creditor', 'debtCollector5Account', 'debtCollector5Amount', 'debtCollector5AddressLine1', 'debtCollector5AddressLine2', 'debtCollector5AccLastFour',
  'debtCollector6Name', 'debtCollector6Creditor', 'debtCollector6Account', 'debtCollector6Amount', 'debtCollector6AddressLine1', 'debtCollector6AddressLine2', 'debtCollector6AccLastFour',
  'debtCollector7Name', 'debtCollector7Creditor', 'debtCollector7Account', 'debtCollector7Amount', 'debtCollector7AddressLine1', 'debtCollector7AddressLine2', 'debtCollector7AccLastFour',
  'debtCollector8Name', 'debtCollector8Creditor', 'debtCollector8Account', 'debtCollector8Amount', 'debtCollector8AddressLine1', 'debtCollector8AddressLine2', 'debtCollector8AccLastFour',
  'debtCollector9Name', 'debtCollector9Creditor', 'debtCollector9Account', 'debtCollector9Amount', 'debtCollector9AddressLine1', 'debtCollector9AddressLine2', 'debtCollector9AccLastFour',
  'debtCollector10Name', 'debtCollector10Creditor', 'debtCollector10Account', 'debtCollector10Amount', 'debtCollector10AddressLine1', 'debtCollector10AddressLine2', 'debtCollector10AccLastFour',
  'debtCollector11Name', 'debtCollector11Creditor', 'debtCollector11Account', 'debtCollector11Amount', 'debtCollector11AddressLine1', 'debtCollector11AddressLine2', 'debtCollector11AccLastFour',
  'debtCollector12Name', 'debtCollector12Creditor', 'debtCollector12Account', 'debtCollector12Amount', 'debtCollector12AddressLine1', 'debtCollector12AddressLine2', 'debtCollector12AccLastFour',
  'debtCollector13Name', 'debtCollector13Creditor', 'debtCollector13Account', 'debtCollector13Amount', 'debtCollector13AddressLine1', 'debtCollector13AddressLine2', 'debtCollector13AccLastFour',
  'debtCollector14Name', 'debtCollector14Creditor', 'debtCollector14Account', 'debtCollector14Amount', 'debtCollector14AddressLine1', 'debtCollector14AddressLine2', 'debtCollector14AccLastFour',
  'debtCollector15Name', 'debtCollector15Creditor', 'debtCollector15Account', 'debtCollector15Amount', 'debtCollector15AddressLine1', 'debtCollector15AddressLine2', 'debtCollector15AccLastFour',
  'debtCollector16Name', 'debtCollector16Creditor', 'debtCollector16Account', 'debtCollector16Amount', 'debtCollector16AddressLine1', 'debtCollector16AddressLine2', 'debtCollector16AccLastFour',
  'debtCollector17Name', 'debtCollector17Creditor', 'debtCollector17Account', 'debtCollector17Amount', 'debtCollector17AddressLine1', 'debtCollector17AddressLine2', 'debtCollector17AccLastFour',
  'debtCollector18Name', 'debtCollector18Creditor', 'debtCollector18Account', 'debtCollector18Amount', 'debtCollector18AddressLine1', 'debtCollector18AddressLine2', 'debtCollector18AccLastFour',
  'debtCollector19Name', 'debtCollector19Creditor', 'debtCollector19Account', 'debtCollector19Amount', 'debtCollector19AddressLine1', 'debtCollector19AddressLine2', 'debtCollector19AccLastFour',
  'debtCollector20Name', 'debtCollector20Creditor', 'debtCollector20Account', 'debtCollector20Amount', 'debtCollector20AddressLine1', 'debtCollector20AddressLine2', 'debtCollector20AccLastFour',
  'debtCollector21Name', 'debtCollector21Creditor', 'debtCollector21Account', 'debtCollector21Amount', 'debtCollector21AddressLine1', 'debtCollector21AddressLine2', 'debtCollector21AccLastFour',
  'debtCollector22Name', 'debtCollector22Creditor', 'debtCollector22Account', 'debtCollector22Amount', 'debtCollector22AddressLine1', 'debtCollector22AddressLine2', 'debtCollector22AccLastFour',
  'debtCollector23Name', 'debtCollector23Creditor', 'debtCollector23Account', 'debtCollector23Amount', 'debtCollector23AddressLine1', 'debtCollector23AddressLine2', 'debtCollector23AccLastFour',
  'debtCollector24Name', 'debtCollector24Creditor', 'debtCollector24Account', 'debtCollector24Amount', 'debtCollector24AddressLine1', 'debtCollector24AddressLine2', 'debtCollector24AccLastFour',
  'debtCollector25Name', 'debtCollector25Creditor', 'debtCollector25Account', 'debtCollector25Amount', 'debtCollector25AddressLine1', 'debtCollector25AddressLine2', 'debtCollector25AccLastFour',
  'debtCollector26Name', 'debtCollector26Creditor', 'debtCollector26Account', 'debtCollector26Amount', 'debtCollector26AddressLine1', 'debtCollector26AddressLine2', 'debtCollector26AccLastFour',
  'debtCollector27Name', 'debtCollector27Creditor', 'debtCollector27Account', 'debtCollector27Amount', 'debtCollector27AddressLine1', 'debtCollector27AddressLine2', 'debtCollector27AccLastFour',
  'debtCollector28Name', 'debtCollector28Creditor', 'debtCollector28Account', 'debtCollector28Amount', 'debtCollector28AddressLine1', 'debtCollector28AddressLine2', 'debtCollector28AccLastFour',
  'debtCollector29Name', 'debtCollector29Creditor', 'debtCollector29Account', 'debtCollector29Amount', 'debtCollector29AddressLine1', 'debtCollector29AddressLine2', 'debtCollector29AccLastFour',
  'debtCollector30Name', 'debtCollector30Creditor', 'debtCollector30Account', 'debtCollector30Amount', 'debtCollector30AddressLine1', 'debtCollector30AddressLine2', 'debtCollector30AccLastFour',
  'notes',
];

export const fieldToCellMap = {
  // client info
  clientFirstName: 'A3', clientMiddleName: 'B3', clientLastName: 'C3', SSN: 'D3',
  homeAddress: 'A5', homeCity: 'B5', homeState: 'C5', homeZip: 'D5', 
  homeCounty: 'A7', homePhone: 'B7', cellPhone: 'C7', email: 'D7',
  dob: 'A9', alias: 'B9', clientNamePrefix: 'C9', clientNameSuffix: 'D9',
  SSNLastFour : 'A11', dmcName: 'B11',
  client2FirstName: 'A14', client2MiddleName: 'B14', client2LastName: 'C14', SSN2: 'D14',
  client2homeAddress: 'A16', client2homeCity: 'B16', client2homeState: 'C16', client2homeZip: 'D16',
  client2homeCounty: 'A18', client2homePhone: 'B18', client2cellPhone: 'C18', client2email: 'D18',
  client2dob: 'A20', client2alias: 'B20', client2NamePrefix: 'C20', client2NameSuffix: 'D20',
  SSN2LastFour: 'A22',
  // case info
  caseDesignation: 'A27', caseCounty: 'B27', caseState: 'C27', caseDivisionDesignation: 'D27',
  caseNumber: 'A29', casePlaintiff: 'B29', caseDefendant: 'C29', caseOpposingCounsel: 'D29',
  caseSuitAmount: 'A31', caseSuitTheory: 'B31',  caseOriginalCreditor: 'C31', caseAccountNumber: 'D31',
  caseAnswerDate: 'A33', caseDivisionNumber: 'B33', caseDivisionJudge: 'C33', discoCosDate: 'D33',
  caseFilingDate: 'A35', caseFilingAttorney: 'B35', caseAccLastFour: 'C35', caseOCFileNumber: 'D35',
  caseAnswerFiledDate: 'A37', caseDisposition: 'B37', caseDispositionDate: 'C37',
  // settlement info
  settlementAmount: 'A46', settlementInstallmentAmount: 'B46', settlementFirstPaymentDate: 'C46', settlementInstallmentNo: 'D46',
  // fee info
  fee: 'A54', installmentAmount: 'B54', installmentDate: 'C54',
  nameOnCard: 'A56', cardNumber: 'B56', securityCode: 'C56', expiration: 'D56',
  billingAddress: 'A58', billingZip: 'B58',
  // debt collector info
  debtCollector1Name: 'A68', debtCollector1Creditor: 'B68', debtCollector1Account: 'C68', debtCollector1Amount: 'D68', debtCollector1AddressLine1: 'A70', debtCollector1AddressLine2: 'C70', 
  debtCollector2Name: 'A74', debtCollector2Creditor: 'B74', debtCollector2Account: 'C74', debtCollector2Amount: 'D74', debtCollector2AddressLine1: 'A76', debtCollector2AddressLine2: 'C76',
  debtCollector3Name: 'A80', debtCollector3Creditor: 'B80', debtCollector3Account: 'C80', debtCollector3Amount: 'D80', debtCollector3AddressLine1: 'A82', debtCollector3AddressLine2: 'C82',
  debtCollector4Name: 'A86', debtCollector4Creditor: 'B86', debtCollector4Account: 'C86', debtCollector4Amount: 'D86', debtCollector4AddressLine1: 'A88', debtCollector4AddressLine2: 'C88',
  debtCollector5Name: 'A92', debtCollector5Creditor: 'B92', debtCollector5Account: 'C92', debtCollector5Amount: 'D92', debtCollector5AddressLine1: 'A94', debtCollector5AddressLine2: 'C94',
  debtCollector6Name: 'A98', debtCollector6Creditor: 'B98', debtCollector6Account: 'C98', debtCollector6Amount: 'D98', debtCollector6AddressLine1: 'A100', debtCollector6AddressLine2: 'C100',
  debtCollector7Name: 'A104', debtCollector7Creditor: 'B104', debtCollector7Account: 'C104', debtCollector7Amount: 'D104', debtCollector7AddressLine1: 'A106', debtCollector7AddressLine2: 'C106',
  debtCollector8Name: 'A110', debtCollector8Creditor: 'B110', debtCollector8Account: 'C110', debtCollector8Amount: 'D110', debtCollector8AddressLine1: 'A112', debtCollector8AddressLine2: 'C112',
  debtCollector9Name: 'A116', debtCollector9Creditor: 'B116', debtCollector9Account: 'C116', debtCollector9Amount: 'D116', debtCollector9AddressLine1: 'A118', debtCollector9AddressLine2: 'C118',
  debtCollector10Name: 'A122',  debtCollector10Creditor: 'B122', debtCollector10Account: 'C122', debtCollector10Amount: 'D122', debtCollector10AddressLine1: 'A124', debtCollector10AddressLine2: 'C124',
  debtCollector11Name: 'A128', debtCollector11Creditor: 'B128', debtCollector11Account: 'C128', debtCollector11Amount: 'D128', debtCollector11AddressLine1: 'A130', debtCollector11AddressLine2: 'C130',
  debtCollector12Name: 'A134', debtCollector12Creditor: 'B134', debtCollector12Account: 'C134', debtCollector12Amount: 'D134', debtCollector12AddressLine1: 'A136', debtCollector12AddressLine2: 'C136',
  debtCollector13Name: 'A140', debtCollector13Creditor: 'B140', debtCollector13Account: 'C140', debtCollector13Amount: 'D140', debtCollector13AddressLine1: 'A142', debtCollector13AddressLine2: 'C142',
  debtCollector14Name: 'A146', debtCollector14Creditor: 'B146', debtCollector14Account: 'C146', debtCollector14Amount: 'D146', debtCollector14AddressLine1: 'A148', debtCollector14AddressLine2: 'C148',
  debtCollector15Name: 'A152', debtCollector15Creditor: 'B152', debtCollector15Account: 'C152', debtCollector15Amount: 'D152', debtCollector15AddressLine1: 'A154', debtCollector15AddressLine2: 'C154',
  debtCollector16Name: 'A158', debtCollector16Creditor: 'B158', debtCollector16Account: 'C158', debtCollector16Amount: 'D158', debtCollector16AddressLine1: 'A160', debtCollector16AddressLine2: 'C160',
  debtCollector17Name: 'A164', debtCollector17Creditor: 'B164', debtCollector17Account: 'C164', debtCollector17Amount: 'D164', debtCollector17AddressLine1: 'A166', debtCollector17AddressLine2: 'C166',
  debtCollector18Name: 'A170', debtCollector18Creditor: 'B170', debtCollector18Account: 'C170', debtCollector18Amount: 'D170', debtCollector18AddressLine1: 'A172', debtCollector18AddressLine2: 'C172',
  debtCollector19Name: 'A176', debtCollector19Creditor: 'B176', debtCollector19Account: 'C176', debtCollector19Amount: 'D176', debtCollector19AddressLine1: 'A178', debtCollector19AddressLine2: 'C178',
  debtCollector20Name: 'A182', debtCollector20Creditor: 'B182', debtCollector20Account: 'C182', debtCollector20Amount: 'D182', debtCollector20AddressLine1: 'A184', debtCollector20AddressLine2: 'C184',
  debtCollector21Name: 'A188', debtCollector21Creditor: 'B188', debtCollector21Account: 'C188', debtCollector21Amount: 'D188', debtCollector21AddressLine1: 'A190', debtCollector21AddressLine2: 'C190',
  debtCollector22Name: 'A194', debtCollector22Creditor: 'B194', debtCollector22Account: 'C194', debtCollector22Amount: 'D194', debtCollector22AddressLine1: 'A196', debtCollector22AddressLine2: 'C196',
  debtCollector23Name: 'A200', debtCollector23Creditor: 'B200', debtCollector23Account: 'C200', debtCollector23Amount: 'D200', debtCollector23AddressLine1: 'A202', debtCollector23AddressLine2: 'C202',
  debtCollector24Name: 'A206', debtCollector24Creditor: 'B206', debtCollector24Account: 'C206', debtCollector24Amount: 'D206', debtCollector24AddressLine1: 'A208', debtCollector24AddressLine2: 'C208',
  debtCollector25Name: 'A212', debtCollector25Creditor: 'B212', debtCollector25Account: 'C212', debtCollector25Amount: 'D212', debtCollector25AddressLine1: 'A214', debtCollector25AddressLine2: 'C214',
  debtCollector26Name: 'A218', debtCollector26Creditor: 'B218', debtCollector26Account: 'C218', debtCollector26Amount: 'D218', debtCollector26AddressLine1: 'A220', debtCollector26AddressLine2: 'C220',
  debtCollector27Name: 'A224', debtCollector27Creditor: 'B224', debtCollector27Account: 'C224', debtCollector27Amount: 'D224', debtCollector27AddressLine1: 'A226', debtCollector27AddressLine2: 'C226',
  debtCollector28Name: 'A230', debtCollector28Creditor: 'B230', debtCollector28Account: 'C230', debtCollector28Amount: 'D230', debtCollector28AddressLine1: 'A232', debtCollector28AddressLine2: 'C232',
  debtCollector29Name: 'A236', debtCollector29Creditor: 'B236', debtCollector29Account: 'C236', debtCollector29Amount: 'D236', debtCollector29AddressLine1: 'A238', debtCollector29AddressLine2: 'C238',
  debtCollector30Name: 'A242', debtCollector30Creditor: 'B242', debtCollector30Account: 'C242', debtCollector30Amount: 'D242', debtCollector30AddressLine1: 'A244', debtCollector30AddressLine2: 'C244',
  notes: 'A63',
};

export const fieldToCellMapOld = {
  clientFirstName: 'A3', clientMiddleName: 'B3', clientLastName: 'C3', SSN: 'D3',
  client2FirstName: 'A5', client2MiddleName: 'B5', client2LastName: 'C5', SSN2: 'D5', 
  homeAddress: 'A7', homeCity: 'B7', homeState: 'C7', homeZip: 'D7',
  homeCounty: 'A9', homePhone: 'B9', cellPhone: 'C9', email: 'D9',
  dob: 'A11', alias: 'B11', clientNameSuffix: 'C11',
  caseDesignation: 'A15', caseCounty: 'B15', caseState: 'C15', caseDivisionDesignation: 'D15',
  caseNumber: 'A17', casePlaintiff: 'B17', caseDefendant: 'C17', caseOpposingCounsel: 'D17',
  caseSuitTheory: 'B19', caseSuitAmount: 'A19', caseOriginalCreditor: 'C19', caseAccountNumber: 'D19',
  caseAnswerDate: 'A21', caseDivisionNumber: 'B21', caseDivisionJudge: 'C21', discoCosDate: 'D21',             
  fee: 'A25', installmentAmount: 'B25', installmentDate: 'C25',
  nameOnCard: 'A27', cardNumber: 'B27', securityCode: 'C27', expiration: 'D27',
  billingAddress: 'A29', billingZip: 'B29',
  settlementAmount: 'A32', settlementInstallmentAmount: 'B32', settlementFirstPaymentDate: 'C32', settlementInstallmentNo: 'D32',
  debtCollector1Name: 'A39',  debtCollector1Creditor: 'B39', debtCollector1Account: 'C39', debtCollector1Amount: 'D39',
  debtCollector1AddressLine1: 'A41', debtCollector1AddressLine2: 'C41', debtCollector2Name: 'A45', 
  debtCollector2Creditor: 'B45', debtCollector2Account: 'C45', debtCollector2Amount: 'D45',
  debtCollector2AddressLine1: 'A47', debtCollector2AddressLine2: 'C47',
  debtCollector3Name: 'A51',  debtCollector3Creditor: 'B51', debtCollector3Account: 'C51', debtCollector3Amount: 'D51',
  debtCollector3AddressLine1: 'A53', debtCollector3AddressLine2: 'C53',
  debtCollector4Name: 'A57',  debtCollector4Creditor: 'B57', debtCollector4Account: 'C57', debtCollector4Amount: 'D57',
  debtCollector4AddressLine1: 'A59', debtCollector4AddressLine2: 'C59',
  debtCollector5Name: 'A63',  debtCollector5Creditor: 'B63', debtCollector5Account: 'C63', debtCollector5Amount: 'D63',
  debtCollector5AddressLine1: 'A65', debtCollector5AddressLine2: 'C65',
  debtCollector6Name: 'A69', debtCollector6Creditor: 'B69', debtCollector6Account: 'C69', debtCollector6Amount: 'D69',
  debtCollector6AddressLine1: 'A71', debtCollector6AddressLine2: 'C71',
  debtCollector7Name: 'A75',  debtCollector7Creditor: 'B75', debtCollector7Account: 'C75', debtCollector7Amount: 'D75',
  debtCollector7AddressLine1: 'A77', debtCollector7AddressLine2: 'C77',
  debtCollector8Name: 'A81',  debtCollector8Creditor: 'B81', debtCollector8Account: 'C81', debtCollector8Amount: 'D81',
  debtCollector8AddressLine1: 'A83', debtCollector8AddressLine2: 'C83',
  debtCollector9Name: 'A87',  debtCollector9Creditor: 'B87', debtCollector9Account: 'C87', debtCollector9Amount: 'D87',
  debtCollector9AddressLine1: 'A89', debtCollector9AddressLine2: 'C89',
  debtCollector10Name: 'A91', debtCollector10Creditor: 'B91', debtCollector10Account: 'C91', debtCollector10Amount: 'D91', debtCollector10AddressLine1: 'A93', debtCollector10AddressLine2: 'C93',
  debtCollector11Name: 'A95', debtCollector11Creditor: 'B95', debtCollector11Account: 'C95', debtCollector11Amount: 'D95', debtCollector11AddressLine1: 'A97', debtCollector11AddressLine2: 'C97',
  debtCollector12Name: 'A101', debtCollector12Creditor: 'B101', debtCollector12Account: 'C101', debtCollector12Amount: 'D101', debtCollector12AddressLine1: 'A103', debtCollector12AddressLine2: 'C103',
  debtCollector13Name: 'A105', debtCollector13Creditor: 'B105', debtCollector13Account: 'C105', debtCollector13Amount: 'D105', debtCollector13AddressLine1: 'A107', debtCollector13AddressLine2: 'C107',
  debtCollector14Name: 'A109', debtCollector14Creditor: 'B109', debtCollector14Account: 'C109', debtCollector14Amount: 'D109', debtCollector14AddressLine1: 'A111', debtCollector14AddressLine2: 'C111', debtCollector15Name: 'A113', debtCollector15Creditor: 'B113', debtCollector15Account: 'C113', debtCollector15Amount: 'D113', debtCollector15AddressLine1: 'A115', debtCollector15AddressLine2: 'C115', debtCollector16Name: 'A117', debtCollector16Creditor: 'B117', debtCollector16Account: 'C117', debtCollector16Amount: 'D117', debtCollector16AddressLine1: 'A119', debtCollector16AddressLine2: 'C119', debtCollector17Name: 'A121', debtCollector17Creditor: 'B121', debtCollector17Account: 'C121', debtCollector17Amount: 'D121', debtCollector17AddressLine1: 'A123', debtCollector17AddressLine2: 'C123', debtCollector18Name: 'A125', debtCollector18Creditor: 'B125', debtCollector18Account: 'C125', debtCollector18Amount: 'D125', debtCollector18AddressLine1: 'A127', debtCollector18AddressLine2: 'C127', debtCollector19Name: 'A129', debtCollector19Creditor: 'B129', debtCollector19Account: 'C129', debtCollector19Amount: 'D129', debtCollector19AddressLine1: 'A131', debtCollector19AddressLine2: 'C131', debtCollector20Name: 'A133', debtCollector20Creditor: 'B133', debtCollector20Account: 'C133', debtCollector20Amount: 'D133', debtCollector20AddressLine1: 'A135', debtCollector20AddressLine2: 'C135', debtCollector21Name: 'A137', debtCollector21Creditor: 'B137', debtCollector21Account: 'C137', debtCollector21Amount: 'D137', debtCollector21AddressLine1: 'A139', debtCollector21AddressLine2: 'C139', debtCollector22Name: 'A141', debtCollector22Creditor: 'B141', debtCollector22Account: 'C141', debtCollector22Amount: 'D141', debtCollector22AddressLine1: 'A143', debtCollector22AddressLine2: 'C143', debtCollector23Name: 'A145', debtCollector23Creditor: 'B145', debtCollector23Account: 'C145', debtCollector23Amount: 'D145', debtCollector23AddressLine1: 'A147', debtCollector23AddressLine2: 'C147', debtCollector24Name: 'A149', debtCollector24Creditor: 'B149', debtCollector24Account: 'C149', debtCollector24Amount: 'D149', debtCollector24AddressLine1: 'A151', debtCollector24AddressLine2: 'C151', debtCollector25Name: 'A153', debtCollector25Creditor: 'B153', debtCollector25Account: 'C153', debtCollector25Amount: 'D153', debtCollector25AddressLine1: 'A155', debtCollector25AddressLine2: 'C155', debtCollector26Name: 'A157', debtCollector26Creditor: 'B157', debtCollector26Account: 'C157', debtCollector26Amount: 'D157', debtCollector26AddressLine1: 'A159', debtCollector26AddressLine2: 'C159', debtCollector27Name: 'A161', debtCollector27Creditor: 'B161', debtCollector27Account: 'C161', debtCollector27Amount: 'D161', debtCollector27AddressLine1: 'A163', debtCollector27AddressLine2: 'C163', debtCollector28Name: 'A165', debtCollector28Creditor: 'B165', debtCollector28Account: 'C165', debtCollector28Amount: 'D165', debtCollector28AddressLine1: 'A167', debtCollector28AddressLine2: 'C167', debtCollector29Name: 'A169', debtCollector29Creditor: 'B169', debtCollector29Account: 'C169', debtCollector29Amount: 'D169', debtCollector29AddressLine1: 'A171', debtCollector29AddressLine2: 'C171',
  notes: 'B31'
};