The Accountant - Google Top Interview Questions


Problem Statement :


Spreadsheets often use this alphabetical encoding for its columns: "A", "B", "C", ..., "AA", "AB", "AC", ..., "ZZ", "AAA", "AAB", "AAC", ....

Given a column number n, return its alphabetical column id. For example, given 1, return "A". Given 27, return "AA".

Constraints

1 ≤ n < 2 ** 31

Example 1

Input

n = 1

Output

"A"

Example 2

Input

n = 2
Output

"B"

Example 3

Input

n = 26

Output

"Z"

Example 4

Input

n = 27

Output

"AA"



Solution :



title-img




                        Solution in C++ :

string solve(int n) {
    string result;
    while (n > 0) {
        // Since in code 'A' + 25 = 'Z'
        n--;

        // Get the remainder to identify
        // the current character to be
        // added to the column number
        int curr = n % 26;

        // Divide by 26 to process the
        // next character
        n = n / 26;

        // Update the result with the
        // current character
        result.push_back(curr + 'A');
    }

    // Since we are adding the most
    // significant character to the end
    // of the string, reverse it before
    // returning
    reverse(result.begin(), result.end());

    return result;
}
                    


                        Solution in Java :

import java.util.*;

class Solution {
    public String solve(int A) {
        String s = "";
        int counter = 0;
        while (A > 0) {
            counter = (A - 1) % 26;
            char a = (char) ('A' + counter);
            s = a + s;
            A = (A - 1) / 26;
        }
        return s;
    }
}
                    


                        Solution in Python : 
                            
class Solution:
    def solve(self, n):

        ans = ""

        # because we have 1 based indexing
        # we need to scale 1-27 to 0-26 each time
        # so, we use n-1
        while n >= 1:
            ans += chr((n - 1) % 26 + ord("A"))
            n = (n - 1) // 26

        return ans[::-1]
                    


View More Similar Problems

Castle on the Grid

You are given a square grid with some cells open (.) and some blocked (X). Your playing piece can move along any row or column until it reaches the edge of the grid or a blocked cell. Given a grid, a start and a goal, determine the minmum number of moves to get to the goal. Function Description Complete the minimumMoves function in the editor. minimumMoves has the following parameter(s):

View Solution →

Down to Zero II

You are given Q queries. Each query consists of a single number N. You can perform any of the 2 operations N on in each move: 1: If we take 2 integers a and b where , N = a * b , then we can change N = max( a, b ) 2: Decrease the value of N by 1. Determine the minimum number of moves required to reduce the value of N to 0. Input Format The first line contains the integer Q.

View Solution →

Truck Tour

Suppose there is a circle. There are N petrol pumps on that circle. Petrol pumps are numbered 0 to (N-1) (both inclusive). You have two pieces of information corresponding to each of the petrol pump: (1) the amount of petrol that particular petrol pump will give, and (2) the distance from that petrol pump to the next petrol pump. Initially, you have a tank of infinite capacity carrying no petr

View Solution →

Queries with Fixed Length

Consider an -integer sequence, . We perform a query on by using an integer, , to calculate the result of the following expression: In other words, if we let , then you need to calculate . Given and queries, return a list of answers to each query. Example The first query uses all of the subarrays of length : . The maxima of the subarrays are . The minimum of these is . The secon

View Solution →

QHEAP1

This question is designed to help you get a better understanding of basic heap operations. You will be given queries of types: " 1 v " - Add an element to the heap. " 2 v " - Delete the element from the heap. "3" - Print the minimum of all the elements in the heap. NOTE: It is guaranteed that the element to be deleted will be there in the heap. Also, at any instant, only distinct element

View Solution →

Jesse and Cookies

Jesse loves cookies. He wants the sweetness of all his cookies to be greater than value K. To do this, Jesse repeatedly mixes two cookies with the least sweetness. He creates a special combined cookie with: sweetness Least sweet cookie 2nd least sweet cookie). He repeats this procedure until all the cookies in his collection have a sweetness > = K. You are given Jesse's cookies. Print t

View Solution →