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

Fibonacci Numbers Tree

Shashank loves trees and math. He has a rooted tree, T , consisting of N nodes uniquely labeled with integers in the inclusive range [1 , N ]. The node labeled as 1 is the root node of tree , and each node in is associated with some positive integer value (all values are initially ). Let's define Fk as the Kth Fibonacci number. Shashank wants to perform 22 types of operations over his tree, T

View Solution →

Pair Sums

Given an array, we define its value to be the value obtained by following these instructions: Write down all pairs of numbers from this array. Compute the product of each pair. Find the sum of all the products. For example, for a given array, for a given array [7,2 ,-1 ,2 ] Note that ( 7 , 2 ) is listed twice, one for each occurrence of 2. Given an array of integers, find the largest v

View Solution →

Lazy White Falcon

White Falcon just solved the data structure problem below using heavy-light decomposition. Can you help her find a new solution that doesn't require implementing any fancy techniques? There are 2 types of query operations that can be performed on a tree: 1 u x: Assign x as the value of node u. 2 u v: Print the sum of the node values in the unique path from node u to node v. Given a tree wi

View Solution →

Ticket to Ride

Simon received the board game Ticket to Ride as a birthday present. After playing it with his friends, he decides to come up with a strategy for the game. There are n cities on the map and n - 1 road plans. Each road plan consists of the following: Two cities which can be directly connected by a road. The length of the proposed road. The entire road plan is designed in such a way that if o

View Solution →

Heavy Light White Falcon

Our lazy white falcon finally decided to learn heavy-light decomposition. Her teacher gave an assignment for her to practice this new technique. Please help her by solving this problem. You are given a tree with N nodes and each node's value is initially 0. The problem asks you to operate the following two types of queries: "1 u x" assign x to the value of the node . "2 u v" print the maxim

View Solution →

Number Game on a Tree

Andy and Lily love playing games with numbers and trees. Today they have a tree consisting of n nodes and n -1 edges. Each edge i has an integer weight, wi. Before the game starts, Andy chooses an unordered pair of distinct nodes, ( u , v ), and uses all the edge weights present on the unique path from node u to node v to construct a list of numbers. For example, in the diagram below, Andy

View Solution →