[ITint5] Excel Number

http://www.itint5.com/oj/#23

The row and column indices in Excel are denoted by:
A, B, C, ..., Z, AA, AB, ... AZ, BA, ...
The corresponding decimal numbers are:
1, 2, 3, ..., 26, 27, 28, ...

Implement two functions to transform decimal numbers to Excel numbers and vice versa.

Excel number is a numeral system based 26.

Comments

  1. galileovalasekMarch 3, 2022 at 9:44 PM

    New casino with slot machines in Maine: A look at casino
    But, in a nutshell, it's a modern version of 목포 출장마사지 a gambling machine, made up of 3 reel reel-style slot machines. 제주 출장마사지 The machines 울산광역 출장마사지 are also 거제 출장샵 designed for 인천광역 출장마사지

    ReplyDelete
  2. 0ininOdext-ze1995April 25, 2022 at 11:01 AM

    0ininOdext-ze1995 Mary Rivera https://wakelet.com/wake/0OrtnSO1DPzt0QxFf8F0-
    servhamrere

    ReplyDelete
  3. Wmisege-kiAugust 26, 2022 at 2:12 PM

    Yimcerbi_fu Melinda Khan There
    HDD Regenerator
    Cinema 4D
    pecttunavi

    ReplyDelete

Post a Comment

Popular posts from this blog

Maximum Gap

Given an unsorted array, find the maximum difference between the successive elements in its sorted form.  Try to solve it in linear time/space.  Return 0 if the array contains less than 2 elements. You may assume all elements in the array are non-negative integers and fit in the 32-bit signed integer range. In order to solve this in linear time, we cannot use general sorting algorithm. Here we use bucket sort. First, we scan the array to find the min and the max values.   We can then create n - 1 buckets with equal size. Suppose we have n elements in total, then we have n - 2 elements except the min and the max. Scan the array again to put the n - 2 elements into these buckets. We should have at least one empty bucket. For each bucket, we record the min and the max for all the elements within that bucket.  Finally, we scan all the buckets, and maintain the maximum gap. Note that the maximum gap between the successive elements in the sorted array can only be the gap between
Read more

[ITint5] Maximum Subarray for a Circular Array

http://www.itint5.com/oj/#8 Classic DP problem, which has also appeared in Leetcode as Maximum subarray . The only difference is, in this problem, empty subarray (where sum is 0) is allowed. So instead of return ret, we could simply return max(0, ret). http://www.itint5.com/oj/#9 Calculate the maximum subarray for a circular array. For example, [1, 3, -2, 6, -1], we should return 9 since 6 + (-1) + 1 + 3 = 9. The following solution might not be optimized. Suppose that the maximum subarray is from A[i] to A[j]. The idea is, consider the following different scenarios: i <= j: it is the same as classic problem. i > j: the sum is A[i : end] + A[start : j]. So we can use two additional arrays: left[j] = maximum subarray, starts from A[start] and ends no later than A[j] right[i] = maximum subarray, starts no earlier than A[i] and ends at A[end] The following code passes the online judge. However, we need O(4n) in time and O(2n) in space. Not sure how to improve this.
Read more

[CC150] Chapter 4 Trees and Graphs

4.1 Implement a function to check if a binary tree is balanced. For the purpose of this question, a balanced tree is defined to be a tree such that the heights of the two subtrees of any node never differ by more than one. This problem is in leetcode as  Balanced Binary Tree . 4.2 Given a directed graph, design an algorithm to find out whether there is a route between two nodes. Both BFS and DFS works. Here I use iterative BFS. 4.3 Given a sorted (increasing order) array, write an algorithm to create a binary search tree with minimal height. This problem is in leetcode as  Convert Sorted Array To Binary Search . Related problem:  Convert Sorted List To Binary Search . 4.4 Given a binary search tree, design an algorithm which creates a linked list of all the nodes at each depth (e.g., if you have a tree with depth D, you will have D linked lists). This problem is equivalent to  Binary Tree Level Order Traversal . Related problem:  Binary Tree Zigzag Level Order Traversal
Read more