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

Array and simple queries

Given two numbers N and M. N indicates the number of elements in the array A[](1-indexed) and M indicates number of queries. You need to perform two types of queries on the array A[] . You are given queries. Queries can be of two types, type 1 and type 2. Type 1 queries are represented as 1 i j : Modify the given array by removing elements from i to j and adding them to the front. Ty

View Solution →

Median Updates

The median M of numbers is defined as the middle number after sorting them in order if M is odd. Or it is the average of the middle two numbers if M is even. You start with an empty number list. Then, you can add numbers to the list, or remove existing numbers from it. After each add or remove operation, output the median. Input: The first line is an integer, N , that indicates the number o

View Solution →

Maximum Element

You have an empty sequence, and you will be given N queries. Each query is one of these three types: 1 x -Push the element x into the stack. 2 -Delete the element present at the top of the stack. 3 -Print the maximum element in the stack. Input Format The first line of input contains an integer, N . The next N lines each contain an above mentioned query. (It is guaranteed that each

View Solution →

Balanced Brackets

A bracket is considered to be any one of the following characters: (, ), {, }, [, or ]. Two brackets are considered to be a matched pair if the an opening bracket (i.e., (, [, or {) occurs to the left of a closing bracket (i.e., ), ], or }) of the exact same type. There are three types of matched pairs of brackets: [], {}, and (). A matching pair of brackets is not balanced if the set of bra

View Solution →

Equal Stacks

ou have three stacks of cylinders where each cylinder has the same diameter, but they may vary in height. You can change the height of a stack by removing and discarding its topmost cylinder any number of times. Find the maximum possible height of the stacks such that all of the stacks are exactly the same height. This means you must remove zero or more cylinders from the top of zero or more of

View Solution →

Game of Two Stacks

Alexa has two stacks of non-negative integers, stack A = [a0, a1, . . . , an-1 ] and stack B = [b0, b1, . . . , b m-1] where index 0 denotes the top of the stack. Alexa challenges Nick to play the following game: In each move, Nick can remove one integer from the top of either stack A or stack B. Nick keeps a running sum of the integers he removes from the two stacks. Nick is disqualified f

View Solution →