suchy

const { getColumnNumber } = require("./index");

test("A", () => {
  expect(getColumnNumber("A")).toBe(0);
});

test("B", () => {
  expect(getColumnNumber("B")).toBe(1);
});

suchy

const maxLetterInSegmentNumber = 26;

module.exports.getColumnNumber = function getColumnNumber(columnName) {
  const letters = columnName.toUpperCase().split("");

  const columnNumber = letters.reduce((columnNumber, letter, index) => {
    const reverseIndex = letters.length - 1 - index;

    const letterNumber = getLetterNumber(letter);

suchy

import {
  Button,
  ChakraProvider,
  FormControl,
  FormErrorMessage,
  FormLabel,
  Input
} from '@chakra-ui/react';
import { ActionFunction, Form, json, useActionData } from 'remix';