• <ins id="pjuwb"></ins>
    <blockquote id="pjuwb"><pre id="pjuwb"></pre></blockquote>
    <noscript id="pjuwb"></noscript>
          <sup id="pjuwb"><pre id="pjuwb"></pre></sup>
            <dd id="pjuwb"></dd>
            <abbr id="pjuwb"></abbr>
            posts - 21, comments - 2, trackbacks - 0, articles - 0

            POJ 2273 An Excel-lent Problem

            Posted on 2011-09-05 21:53 acpeng 閱讀(489) 評論(0)  編輯 收藏 引用 所屬分類: ACM程序

            把整數轉化為excel對應的列值http://poj.org/problem?id=2273
            Description

            A certain spreadsheet program labels the columns of a spreadsheet using letters. Column 1 is labeled as ``A", column 2 as ``B", ..., column 26 as ``Z". When the number of columns is greater than 26, another letter is used. For example, column 27 is ``AA", column 28 is ``AB" and column 52 is ``AZ". It follows that column 53 would be ``BA" and so on. Similarly, when column ``ZZ" is reached, the next column would be ``AAA", then ``AAB" and so on.

            The rows in the spreadsheet are labeled using the row number. Rows start at 1.

            The designation for a particular cell within the spreadsheet is created by combining the column label with the row label. For example, the upper-left most cell would be ``A1". The cell at column 55 row 23 would be ``BC23".

            You will write a program that converts numeric row and column values into the spreadsheet designation.

            Input

            Input consists of lines of the form: RnCm. n represents the row number [1,300000000] and m represents the column number, 1<=m<=300000000. The values n and m define a single cell on the spreadsheet. Input terminates with the line: R0C0 (that is, n and m are 0). There will be no leading zeroes or extra spaces in the input.

            Output

            For each line of input (except the terminating line), you will print out the spreadsheet designation for the specified cell as described above.

            Sample Input

            R1C1
            R3C1
            R1C3
            R299999999C26
            R52C52
            R53C17576
            R53C17602
            R0C0
            

            Sample Output

            A1
            A3
            C1
            Z299999999
            AZ52
            YYZ53
            YZZ53
            

            Source

            Greater New York 2004

            進制轉化問題,把列數改成26進制輸出,分別用A,B...Z代替1,2,3...這里base[0]='Z',表示n與26余數為0時的取值,但進位問題需要注意,分余數是否為0兩種情況分析。
            代碼:
            #include<stdio.h>
            #define R 26
            char base[30]="ZABCDEFGHIJKLMNOPQRSTUVWXYZ";
            void fun(int N)
            {
                
            int i=0,j; char str[10];
                
            while(N>R)
                
            {
                    str[i
            ++]=base[N%R];
                    N
            =N%R==0?N/R-1:N/R;
                }

                str[i]
            =base[N];
                
            for(j=i;j>=0;j--)
                    printf(
            "%c",str[j]);
            }

            int main()
            {
                
            int m,n;
                
            while(scanf("%*c%d%*c%d",&m,&n)!=EOF)
                
            {
                    getchar();
                    
            if(m==0 && n==0)break;
                    fun(n);
                    printf(
            "%d\n",m);
                }

                
            return 0;
            }

            国产免费久久精品丫丫| 久久青草国产手机看片福利盒子| 国产精品xxxx国产喷水亚洲国产精品无码久久一区 | 久久99国产精品二区不卡| 日本道色综合久久影院| 亚洲国产精品嫩草影院久久 | 丁香五月网久久综合| 一本色道久久88综合日韩精品 | 四虎国产永久免费久久| 97精品伊人久久大香线蕉| 亚洲一区中文字幕久久| 国产成年无码久久久免费| 久久成人永久免费播放| 91精品国产综合久久婷婷| 免费久久人人爽人人爽av| 99热精品久久只有精品| 91精品国产色综合久久| 狠狠色婷婷久久综合频道日韩 | 久久久久国产成人精品亚洲午夜| 久久综合九色综合网站| 久久久午夜精品| 色综合久久久久综合99| 久久久精品久久久久久| 国产精品免费久久久久久久久| 久久91精品久久91综合| 91精品国产高清久久久久久io| 人妻无码αv中文字幕久久琪琪布| 亚洲精品NV久久久久久久久久| 久久露脸国产精品| 日韩十八禁一区二区久久| 久久久久一级精品亚洲国产成人综合AV区 | www.久久热.com| 久久精品国产69国产精品亚洲| 成人资源影音先锋久久资源网| 国产精品岛国久久久久| www.久久热| 久久本道久久综合伊人| 亚洲欧洲精品成人久久曰影片| 久久天天躁狠狠躁夜夜2020老熟妇 | 午夜精品久久久内射近拍高清 | 久久激情亚洲精品无码?V|