Date Time

15/12/14 13:33

Author

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%dC%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%26;
		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;
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

/* ***********************************************

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%dC%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%26;

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;

}

说点什么

您将是第一位评论人！

111qqz的小窝

老年咸鱼冲锋！

Date Time

Author

Category

Tags

codeforces 1 B. Spreadsheets

说点什么