Page 1 of 1

SEQUENCE OF TURN

PostPosted: Wed May 30, 2018 10:17 am
by ImperiumLafayette
1.)Read turn results
2.)Transfer data from turn results to various spreadsheets
3.)Write out 91 orders into my turnsheet spreadsheet
4.)Copy and save to .csv spreadsheet (set with Tab as field delimiter)
5.)Upload .csv file to Takamo Input Page
6.)Fix up Input page (Empire #, Empire Name, Turn Number and first three orders which for some reason never transfer over).
7.)Save .TAK copy of turn to my computer
8.)Submit turn to game
9.)Review rules and read more messages on Forum
10.)Say "Oh, crap!
11.)Redo some of the orders on my turnsheet spreadsheet
12.)Do #4-8 again
13.)Review rules and read more messages on Forum
14.)Say "Oh, crap!
15.)Redo orders on my turnsheet spreadsheet
16.)Do #4-8 again
17.)Review rules and read more messages on Forum
18.)Say "Damn %$#@*%&$*@#$", grab bottle of vodka..... :cry:

Re: SEQUENCE OF TURN

PostPosted: Thu May 31, 2018 9:49 pm
by Tregonsee
Umm, you might want to look at the spreadsheets created by Playtakamo, then you don't need to make up new spreadsheets.

What is .csv file? Never heard of it.

I just import last weeks .tak file into the input page, look at my turn, write some notes in the notes column for this next turn, and then make changes or keep orders as needed and then resubmit.

HMU

Re: SEQUENCE OF TURN

PostPosted: Thu May 31, 2018 11:18 pm
by ImperiumLafayette
those playtakamo spreadsheets just sit there like a lump. Mine figures what I need to build to reach max on my worlds. :D

Re: SEQUENCE OF TURN

PostPosted: Thu May 31, 2018 11:29 pm
by CHARON EMPIRE
If you want to send me an e-mail at charon22@mrtc.com I'd be more than happy to help you with any turn question. If needed I can send you my phone number to answer any questions you might have but don't want to write out.

Re: SEQUENCE OF TURN

PostPosted: Fri Jun 01, 2018 11:46 am
by Thom
ImperiumLafayette wrote:1.)Read turn results
2.)Transfer data from turn results to various spreadsheets
3.)Write out 91 orders into my turnsheet spreadsheet
4.)Copy and save to .csv spreadsheet (set with Tab as field delimiter)
5.)Upload .csv file to Takamo Input Page
6.)Fix up Input page (Empire #, Empire Name, Turn Number and first three orders which for some reason never transfer over).
7.)Save .TAK copy of turn to my computer
8.)Submit turn to game
9.)Review rules and read more messages on Forum
10.)Say "Oh, crap!
11.)Redo some of the orders on my turnsheet spreadsheet
12.)Do #4-8 again
13.)Review rules and read more messages on Forum
14.)Say "Oh, crap!
15.)Redo orders on my turnsheet spreadsheet
16.)Do #4-8 again
17.)Review rules and read more messages on Forum
18.)Say "Damn %$#@*%&$*@#$", grab bottle of vodka..... :cry:


The reason the first three actions don't import correctly is because the first three lines, first boxes of your spread sheet should be: (don't need to include the <====== Player ID goes here note. That is just to show you what needs to be in each first column box.

E000 <==== Player ID goes here
Name <==== Empire Name goes here
Turn# <==== Turn number goes here

it will import just fine after you save it as a tab delimited file after that.

Sorry, I should have put that somewhere but I didn't know you were using a spreadsheet to do your turn. I did a template for the blind players that needed to use a spreadsheet to do their turns. I could send that to you if you want. It really only adds the first three lines to the sheep and then column headers and then the actions.

Re: SEQUENCE OF TURN

PostPosted: Fri Jun 01, 2018 4:53 pm
by ImperiumLafayette
Thanks Thom! That works perfectly.

Main reason I'm using my own spreadsheets is that everything is already built from last time I played. I just copy and paste from the text files and the spreadsheet calculates what I need to build to max out a world.

Another thing to ask is that on the text file for the planets (what you can download each turn from playTakamo) there are four columns not shown on the turnsheet. They are "C","S","D","DL", all at the end of a planet's line of information. What are they for?

Imperium Lafayette
Bringing Confused to Entire Galaxy!

Re: SEQUENCE OF TURN

PostPosted: Fri Jun 01, 2018 6:22 pm
by Cestodial Hegemony
C = smuggling center (only shown to smugglers)
S = your spy is on the planet
D = your diplomat is on the planet
DL = your diplomat's level

Re: SEQUENCE OF TURN

PostPosted: Sat Jun 02, 2018 7:23 am
by ImperiumLafayette
Thanks CH!

And a big "DUH" to me!

IL
Having A Bowl Of Saturday Morning "Uhhhhhh......."

Re: SEQUENCE OF TURN

PostPosted: Tue Jun 05, 2018 9:16 pm
by R. Ritnour
lol