codeforces 1 B. Spreadsheets

http://codeforces.com/problemset/problem/1/B 题意:给出了两种表格的表示方法。要求互相转化。 思路:直接模拟即可。注意和一般的进制转化不同的是,26进制对应的是1到26而不是0到25,所以要记得处理下借位。

/* ***********************************************
Author :111qqz
Created Time :2015年12月13日 星期日 19时46分09秒
File Name :code/cf/problem/1B.cpp
************************************************ */

#include <cstdio>
#include <cstring>
#include <iostream>
#include <algorithm>
#include <vector>
#include <queue>
#include <set>
#include <map>
#include <string>
#include <cmath>
#include <cstdlib>
#include <ctime>
#define fst first
#define sec second
#define lson l,m,rt<<1
#define rson m+1,r,rt<<1|1
#define ms(a,x) memset(a,x,sizeof(a))
typedef long long LL;
#define pi pair < int ,int >
#define MP make_pair

using namespace std;
const double eps = 1E-8;
const int dx4[4]={1,0,0,-1};
const int dy4[4]={0,-1,1,0};
const int inf = 0x3f3f3f3f;

char st[100];
int a26[100];
int a10[100];

void pre()
{
    a26[0]=1;
    for ( int i = 1 ;i<=5; i++)
    {
	a26[i] = a26[i-1]*26;
//	cout<<"i:"<<i<<" "<<a26[i]<<endl;
    }
    a10[0] = 1;
    for ( int i = 1 ; i<=7 ; i++)
    {
	a10[i] = a10[i-1]*10;
    }
}
void solve()
{
    cin>>st;
    int len = strlen(st);
    int p1=-1,p2=-1;
    for ( int i = 0 ; i < len ; i++)
    {
	char ch = st[i];
	if (ch>='A'&&ch<='Z')
	{
	    if (p1==-1)
	    {
		p1 = i ;
	    }
	    else
	    {
		p2 = i;
		break;
	    }
	}
    }
    if (p2-p1==1||p2==-1)
    {
	int dig = 0 ;
	int alp = 0;
	int sum = 0 ;
	int sum2 = 0 ;
	for ( int i = len -1 ; i>= 0 ; i--)
	{
	    char ch = st[i];
	    if (!isdigit(ch))
	    {
		sum += (ch-'A'+1)*a26[alp];
		alp++;
	    }
	    else
	    {
		sum2+= (ch-'0')*a10[dig];
		dig++;
	    }
	}
	printf("R%d\n",sum2,sum);
    }
    else
    {
	int dig1 = 0 ;
	int dig2 = 0;
	int sum1 = 0 ;
	int sum2 = 0 ;
	int p = 1;
	for ( int i = len-1 ; i>= 0 ; i-- )
	{
	    char ch = st[i];
	    if (isdigit(ch))
	    {
	//	cout<<"ch:"<<ch<<endl;
		if (p)
		{
		    sum1+=(ch-'0')*a10[dig1];
		  //  cout<<"sum1:"<<sum1<<endl;
		    dig1++;
		}
		else
		{
		    sum2+=(ch-'0')*a10[dig2];
		    dig2++;
		}
	    
	
	    }
	    else
	    {
		p = 0 ;
	    }
	}
//	cout<<"sum1:"<<sum1<<" sum2:"<<sum2<<endl;
	    int cnt = 0 ;
	    int b[50];
	    while(sum1)
	    {
		cnt++;
		b[cnt] = sum1;
		sum1/=26;
//		cout<<"sum1::::"<<sum1<<endl;
	    }
//	    cout<<"cnt:"<<cnt<<endl;
	    for ( int i = 1 ; i <= cnt -1 ; i ++)
	    {
		if (b[i]<=0)
		{
		    b[i]+=26;
		    b[i+1]--;
		}
	    }
	    while (b[cnt]==0) cnt--;

	    for ( int i = cnt ; i >=1 ; i--)
	    {
		
	//	cout<<"b[i]:"<<b[i]<<endl;
		cout<<char(b[i]+'A'-1);
	    }
	    cout<<sum2<<endl;


	

    }


}
int main()
{
	#ifndef  ONLINE_JUDGE 
	freopen("code/in.txt","r",stdin);
  #endif

	pre();
	int T;
	cin>>T;
	while (T--)
	{
	    solve();
	}

  #ifndef ONLINE_JUDGE  
  fclose(stdin);
  #endif
    return 0;
}