Jump to content

  •     

Photo

Help On Docs

Help Docs Google

  • This topic is locked This topic is locked
15 replies to this topic

#1 Admiral General Mickey

Admiral General Mickey

    Advanced Member

  • Members
  • PipPipPip
  • 181 posts
  • LocationIsrael

Posted 13 August 2013 - 08:44 PM

Dear Citizens.

I am currently looking for people with knowledge on Google Docs Importing Formulas (API or something like that).

You can get more information by sending me a PM: http://www.erepublik...profile/6685024

 

Best Regards, Miki


Feel free to browse my web-guide for eRepublik, it's free

http://erepublik-web-guide.weebly.com/


#2 NewSaver

NewSaver

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 13 August 2013 - 09:47 PM

Good man!

 

Help him!


Edited by NewSaver, 13 August 2013 - 09:51 PM.


#3 elbandido

elbandido

    Advanced Member

  • Members
  • PipPipPip
  • 443 posts

Posted 14 August 2013 - 05:50 AM

Dear Citizens.

I am currently looking for people with knowledge on Google Docs Importing Formulas (API or something like that).

You can get more information by sending me a PM: http://www.erepublik...profile/6685024

 

Best Regards, Miki

 

Hello,

 

Can you give us more details? Which API do you use (official eR API, you have your own key)? What type of data do you need to be imported in gdoc?

 

Regards.


...always watching...

#4 St0L3n1

St0L3n1

    Advanced Member

  • Members
  • PipPipPip
  • 72 posts
  • LocationKarachi, Pakistan

Posted 14 August 2013 - 06:56 AM

Dear Citizens.

I am currently looking for people with knowledge on Google Docs Importing Formulas (API or something like that).

You can get more information by sending me a PM: http://www.erepublik...profile/6685024

 

Best Regards, Miki

 

Please be more specific what kind of data you need to import?



#5 Pitcity

Pitcity

    Advanced Member

  • Members
  • PipPipPip
  • 175 posts

Posted 14 August 2013 - 07:18 AM

 

 

 

He'll write you later;)
now... em.. can you help me pls?) what formula should i use to get my exp?))
1376464937-clip-5kb.png

Thx)


Edited by Pitcity, 14 August 2013 - 07:23 AM.


#6 elbandido

elbandido

    Advanced Member

  • Members
  • PipPipPip
  • 443 posts

Posted 14 August 2013 - 08:18 AM

He'll write you later;)
now... em.. can you help me pls?) what formula should i use to get my exp?))
1376464937-clip-5kb.png

Thx)

 

Hello,

 

If your data is from a gdoc, then you can try:

 

=REPLACE(X;7;9;"") >> where X is your cell with data

 

Regards.


...always watching...

#7 Admiral General Mickey

Admiral General Mickey

    Advanced Member

  • Members
  • PipPipPip
  • 181 posts
  • LocationIsrael

Posted 14 August 2013 - 08:21 AM

Hello,

 

Can you give us more details? Which API do you use (official eR API, you have your own key)? What type of data do you need to be imported in gdoc?

 

Regards.

 

 

Please be more specific what kind of data you need to import?

 

 

The problem is that i don't know nothing on those Formulas or how it works.
The Data i need to import is Taxes Values, Products Prices and country's bonuses (requirements and production).
I have a gDOCS file which i want to be updated "Automatically" by importing some of the data in the Docs.


Feel free to browse my web-guide for eRepublik, it's free

http://erepublik-web-guide.weebly.com/


#8 St0L3n1

St0L3n1

    Advanced Member

  • Members
  • PipPipPip
  • 72 posts
  • LocationKarachi, Pakistan

Posted 14 August 2013 - 08:49 AM

The problem is that i don't know nothing on those Formulas or how it works.
The Data i need to import is Taxes Values, Products Prices and country's bonuses (requirements and production).
I have a gDOCS file which i want to be updated "Automatically" by importing some of the data in the Docs.

 

If that is the case i suggest you to hire some pro



#9 Pitcity

Pitcity

    Advanced Member

  • Members
  • PipPipPip
  • 175 posts

Posted 14 August 2013 - 08:50 AM

I have a fully automatic GDoc :)
 thx so much)
 


Edited by Pitcity, 14 August 2013 - 09:35 AM.


#10 elbandido

elbandido

    Advanced Member

  • Members
  • PipPipPip
  • 443 posts

Posted 14 August 2013 - 09:15 AM

The problem is that i don't know nothing on those Formulas or how it works.
The Data i need to import is Taxes Values, Products Prices and country's bonuses (requirements and production).
I have a gDOCS file which i want to be updated "Automatically" by importing some of the data in the Docs.


Well I can suggest you some formulas if they will help you, but you need a lot to do from 0.

- Importing Regions and their resources:
=ImportHtml("http://www.erepublik...economy/Romania";"table";1)

- Importing Taxes by industry:
=ImportHtml("http://www.erepublik...economy/Romania";"table";3)

- Importing minimum and average Salary:
=ImportHtml("http://www.erepublik...economy/Romania";"table";4)

For Products Prices I suggest you to get a functional API with such type of data, because the data you want isn't available without to be logged in.

Regards.


...always watching...

#11 Admiral General Mickey

Admiral General Mickey

    Advanced Member

  • Members
  • PipPipPip
  • 181 posts
  • LocationIsrael

Posted 14 August 2013 - 09:25 AM

Well I can suggest you some formulas if they will help you, but you need a lot to do from 0.

- Importing Regions and their resources:
=ImportHtml("http://www.erepublik...economy/Romania";"table";1)

- Importing Taxes by industry:
=ImportHtml("http://www.erepublik...economy/Romania";"table";3)

- Importing minimum and average Salary:
=ImportHtml("http://www.erepublik...economy/Romania";"table";4)

For Products Prices I suggest you to get a functional API with such type of data, because the data you want isn't available without to be logged in.

Regards.

 

Thank you! 


Feel free to browse my web-guide for eRepublik, it's free

http://erepublik-web-guide.weebly.com/


#12 Admiral General Mickey

Admiral General Mickey

    Advanced Member

  • Members
  • PipPipPip
  • 181 posts
  • LocationIsrael

Posted 14 August 2013 - 10:44 AM

If that is the case i suggest you to hire some pro

 

 

Well I can suggest you some formulas if they will help you, but you need a lot to do from 0.

- Importing Regions and their resources:
=ImportHtml("http://www.erepublik...economy/Romania";"table";1)

- Importing Taxes by industry:
=ImportHtml("http://www.erepublik...economy/Romania";"table";3)

- Importing minimum and average Salary:
=ImportHtml("http://www.erepublik...economy/Romania";"table";4)

For Products Prices I suggest you to get a functional API with such type of data, because the data you want isn't available without to be logged in.

Regards.

 

Hey, i have managed to complete big parts on my Docs with the Formulas you gave me, Thank you very much! I made some data as: Bonuses, Taxes, requirements and Production, to be updated Automatically.
I have only 1 Data Left, the Prices in the Market (Of Every Product: Food, Weapons, FRM and WRM). 

Do you know any Formula that can Help me with this matter? It is the only thing i have left to do.

Thanks in advance.


Feel free to browse my web-guide for eRepublik, it's free

http://erepublik-web-guide.weebly.com/


#13 elbandido

elbandido

    Advanced Member

  • Members
  • PipPipPip
  • 443 posts

Posted 14 August 2013 - 12:31 PM

Hey, i have managed to complete big parts on my Docs with the Formulas you gave me, Thank you very much! I made some data as: Bonuses, Taxes, requirements and Production, to be updated Automatically.
I have only 1 Data Left, the Prices in the Market (Of Every Product: Food, Weapons, FRM and WRM). 

Do you know any Formula that can Help me with this matter? It is the only thing i have left to do.

Thanks in advance.

 

For Products Prices I suggest you to get a functional API with such type of data, because the data you want isn't available without to be logged in.

There isn't a formula for that. You need to create a json or xml feed with Prices (php and javascript skills).

 

Regards.


...always watching...

#14 Admiral General Mickey

Admiral General Mickey

    Advanced Member

  • Members
  • PipPipPip
  • 181 posts
  • LocationIsrael

Posted 04 September 2013 - 02:50 PM

Well I can suggest you some formulas if they will help you, but you need a lot to do from 0.

- Importing Regions and their resources:
=ImportHtml("http://www.erepublik...economy/Romania";"table";1)

- Importing Taxes by industry:
=ImportHtml("http://www.erepublik...economy/Romania";"table";3)

- Importing minimum and average Salary:
=ImportHtml("http://www.erepublik...economy/Romania";"table";4)

For Products Prices I suggest you to get a functional API with such type of data, because the data you want isn't available without to be logged in.

Regards.

 

Hey Elbandidi.

Today i accessed my Docs and i see that those formulas stopped to work ...

Does the formulas has changes or something ?


Feel free to browse my web-guide for eRepublik, it's free

http://erepublik-web-guide.weebly.com/


#15 elbandido

elbandido

    Advanced Member

  • Members
  • PipPipPip
  • 443 posts

Posted 04 September 2013 - 04:33 PM

Hey Elbandidi.

Today i accessed my Docs and i see that those formulas stopped to work ...

Does the formulas has changes or something ?

 

Sometimes google doc will give you an Error on formulas, but after 1h everything will be fine.


...always watching...

#16 Admiral General Mickey

Admiral General Mickey

    Advanced Member

  • Members
  • PipPipPip
  • 181 posts
  • LocationIsrael

Posted 04 September 2013 - 08:29 PM

Sometimes google doc will give you an Error on formulas, but after 1h everything will be fine.

 

Hmm seems it is working now ;)


Feel free to browse my web-guide for eRepublik, it's free

http://erepublik-web-guide.weebly.com/






Also tagged with one or more of these keywords: Help, Docs, Google

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users