Code center > Old Suggestions Awaiting Programming

Simulation tools Part 2

<< < (2/3) > >>

Botsareus:
Instead of making it "cama dilaighted(for lack of good spelling)"

Make it chr(13) & chr(10) dilaighted and desplay it using notepad.

If you still hung up on exsel no problem there:

Whats the proper format over there to get rows instead of columns, the ammount of rows should be alomst infinate, ( I think its also chr(13) & chr(10)  not sure)

Numsgil:
It's "comma deliminated" (more or less, that may be misspelled too).

I think I read in the old forum that PY tried rows too, and there was something wrong with that.

I'd recommend making each 10 or so memory locations its own field.  Play around with formatting, I'm sure you can figure out something, PY.

AZPaul:

--- Quote ---Excel can only have a maximum of 256 columns so it becomes a little tricky to upload 1000 memlocs for each bot. For one thing, you couldn't use the regular method of opening the file or else you will get memlocs wrapping around onto different lines all over the place and making a right old mess.

This will take a bit more thought than I thought, I think
--- End quote ---

That would indeed be a mess, but please don't let that get in the way.  I've already started writing a small utility to contract a .txt to a usable form for Excel. All I need is the raw data. Nothing fancy.

botID1,botName,mem1,mem2,mem3,...,mem999,end
botID2,botName,mem1,mem2,mem3,...,mem999,end
.
.
.
botIDn,botName,mem1,mem2,mem3,...,mem999,end

Include veggies if it's easier. I can throw those away in processing. I can take all "Alpha" (from botName), pull the memory locations I want and write them to another file.

I know this is a "one off" type of request.  And, yes, I realize that we are talking about a file in excess of 2 meg for the typical sim (you will not want to add this to the present "Snapshot").  Not many will ever use this capability. Please don't go through a lot of headache with options, includes, excludes and the like.  Just a raw, here it is, do what you want, now go away, kinda file.

As always, I appreciate the effort.

Thanks all.

-P

Oooh, Hey! I got stars! Wow! Maybe I'm spending too much time here?  :clap:

PurpleYouko:

--- Quote ---Oooh, Hey! I got stars! Wow! Maybe I'm spending too much time here? 
--- End quote ---

Wait till you get 5 or 6 of them and then tell us you are spending too much time here.
This place gets addictive.  :rolleyes:

I can easily enough get you a file with all the memlocs in it and I don't think it will be quite as big as you think, particularly as it will be saved as a text file.

I plan to add it to the end of the snapshot function as a extra option.

eg.

"Snapshot successfully saved. Would you like to save a memory snapshot too?" yes/no

I was also planning to save it sideways such that the robot ID would go along the top and the memory locations would go down the side. Figured it would be easier to do this way and I could also split the robots into groups of 256 to prevent wrapping around in Excel

Let me know what format would be the best for you though.

AZPaul:

--- Quote ---Wait till you get 5 or 6 of them and then tell us you are spending too much time here.
This place gets addictive.
--- End quote ---

I have experienced that.


--- Quote ---I can easily enough get you a file with all the memlocs in it and I don't think it will be quite as big as you think, particularly as it will be saved as a text file.
--- End quote ---

No way around the numbers. 1000 mem locations x 1000 bots for raw data then double for comma delimited. 2 meg.+


--- Quote ---I was also planning to save it sideways such that the robot ID would go along the top and the memory locations would go down the side. Figured it would be easier to do this way and I could also split the robots into groups of 256 to prevent wrapping around in Excel

Let me know what format would be the best for you though.
--- End quote ---

Straight forward flat file:

botID1,botName,mem1,mem2,mem3,...,mem999,end
botID2,botName,mem1,mem2,mem3,...,mem999,end
.
.
.
botIDn,botName,mem1,mem2,mem3,...,mem999,end

I've already built the utility to crunch it down to the data I will need and import properly into Excel.  All I need do is recode one handle for the specific format of the file you provide and I can be in staticstical heven.

Just think of it! The data! The charts! The graphs! Means, medians, modes, standard deviations! Ohhh I get all bubbly!  God help me I do love it so!

I gotta get out more.

And PY, what happened to your Avatar? A white box with a little red x? Have you gone sans avatrea? A political statement perhaps? A protest of the ever growing reach of the New World Order? Early onset senility? Is there great cosmic meaning to this sudden turn in the way you want the world to see you, or actually, not see you?

I do need to get out more.

Navigation

[0] Message Index

[#] Next page

[*] Previous page