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', }; 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' }; module.exports = { fieldToCellMap, fieldToCellMapOld, };