Bean (Hitt Consulting) said...
Weird, it must a version difference. I'm using Excel 2002. What are you using ?
Bean.
I am seeing the same thing in Microsoft Office 2004(Mac)
the cell contents shows ="$"&DEC2HEX(J3,2)
The Help File says the following;
"DEC2HEX - Converts a decimal number to hexadecimal. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in."
I just went to Excel, opened an empty workbook (apparently there have been some glitches when opening a live spreadsheet and turning on the Analysis Tools) and pulled down the "Tools" menu, the selected "Add-ins" and from the Add-ins window selected "Analysis Tools - VBA". Close and exited Excel. then brought it back up with Bean's Tile sheets and it works just fine.
enjoy ...
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
cheers ... brian riley, n1bq, underhill center, vermont
See the K107 Serial LCD Controller at www.wulfden.org/k107/
Post Edited (Brian Riley) : 8/14/2006 5:26:33 PM GMT
I was on a really long, boring, stupid support call where I spent a lot of time just waiting for the other people to do thier thing and I used the time to play around with some existing code and make a new tile editor to support this excellent driver that Terry wrote. Now you don't have to have Excel or download anything to make your tiles.
I tried to make it simulate the appearance of video scan lines so you can really get a good feel for what the result will look like. You may want to view it from a few feet away since the boxes needed to be big in order to be easy to click.
Let me know if there are any changes I can make to get it into a format that is easier to use.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
---
James Newton, Host of SXList.com james at sxlist,com 1-619-652-0593 fax:1-208-279-8767
SX FAQ / Code / Tutorials / Documentation: http://www.sxlist.com Pick faster!
A need has been fufilled thanks to Bean and James!
James,
You asked for any changes to make it better. Is it possible to leave the code in Decimal format? Otherwise, you need to add $ in front of each Hex set of characters for SX/B (e.g. DATA 123, 60, 23, 23, 23, 34, 55, 10· -->
Confirmed...On my Home Excel 2003 the Hex fields show "#NAME?" and the comment tool-text-tip says "The field contains unrecognized text".· Weird.· But, OTOH it looks as though the problem has been taken care of in other ways.·
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔ Chris Savage Parallax Tech Support csavage@parallax.com
James,
Thanks for the kind words, and feel free to put the driver on sxlist (if you haven't already).
Chris, is seems in Excel 2003 you must have analysis tools loaded ???
Bean.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Cheap 4-digit LED display with driver IC·www.hc4led.com
hammerhead74000 said...
Or, you could build a small VM, that ran bytecode from the EEPROM (or better yet, FRAM) for the game logic. Crank the SX up all the way to 80Mhz and you should have plenty of performance for it.
Now, Bean, why couldn't you build up the game machine with a second SX28 and a 24LC256 and use the second chip to read data from the EEPROM and program the main chip SX48/SX28? Of the 4 pins of ICSP (SXKey, two are Vdd and Vss, so all you need to do at the appropriae time using, say, a DPDT switch is connect two of the programming processors pins to Osc1 and Osc2 on the game machine and then have a single or double 7 seven segment display and some buttons to select games number one to 12 or more, and read it from the serial eeprom and program the game chip, then switch it baqck to run the game.
Is there any reason thsi cannot work ... sort of an SX-stache!
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
cheers ... brian riley, n1bq, underhill center, vermont
See the K107 Serial LCD Controller at www.wulfden.org/k107/
Just to let everyone know...I have modified Bean's PONG game into 2 Player and updated my Video Game Console. See the link with a picture and the new PONG 2 Player SXB code:
All of the game programs like PONG, DRIVE, FLIP-IT, ect. show the techniques to display basic graphics and text. Bean can fill you in on any specifics. Keep in mind this is in Black and White only as it runs on any SX chip. At·< $3·for an SX chip, it's very reasonable for simple graphics/text/gaming. The propeller is much more complicated to program but can also offer more capability (in color too). If you know any SX Assembly language you should also look at this link for SX28 gaming in some color: http://www.rickard.gunee.com/projects/video/sx/gamesys.php
The hardware for the video game console (in this link - not the SX video module) is nothing more than an SX chip (SX-28/48/52) with the required output lines (RA, RB, RC) and some resistors, Atari joystick (or buttons) and that's about it. See·original link below:
It is a serial interfaced (Tx and Rx with custom commands to a micro-controller) LCD screen and was thinking of integrating your game system into this display - if possible.
The main video display code is meant for NTSC/PAL output so to interface it to a serial LCD would be to re-write the whole thing. If you read the product page for the LCD on the Parallax site it has a special list of commands that you would use to communicate with the display. You would have to redo all the display code to translate it into those commands sent serially. It is very possible for you to do this, but it may bot be as easy as you would think. Good luck!
Hey Bean, do you have any plans on making this color compatible instead of just black and white? I have no experience with TV signals so I don't really know how difficult it would be...
I don't really mind the B&W, but it would be really cool to have a full color version of breakout...jut a thought!
Yeah for color I would recommend the Propeller chip.
I've done color on the SX, but it's very difficult. It requires a custom frequency crystal and an external SRAM chip.
It's just SOOO much easier with the propeller.
Bean.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
My goal is to live forever...Or die trying.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - www.hittconsulting.com ·
Eh, no problem. I was just curious if if was possible. Cool to know it is though!
And T & E Engineer, that first page was exactly what I envisioned when I thought about this. Pretty amazing stuff...to think none of this was possible (to do at home at least) 10 years ago...wow
I was thinking about makeing a version of the mere mortal video driver for the XGS Pico.
I just ordered one, so it will take a couple weeks before I have it ready.
Does anyone have the XGS Pico that would want to try it out ?
I was thinking of getting the·MMVGD back out again and possibly adding a Parallax 'Sound Pal' that I bought already. Do you think this would improve any of the SX-28 video performance since the audio part would not be utilized on the MMVGD? I'm thinking it would not show any significant performance improvements either way.
Comments
Your's looks great. However, I did see a problem in the HEX column in that it had errors stating:
Post Edited (T&E Engineer) : 8/14/2006 12:57:07 PM GMT
Bean.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Cheap 4-digit LED display with driver IC·www.hc4led.com
Low power SD Data Logger www.sddatalogger.com
"You're braver than you believe, stronger than you seem, and smarter than you think" Christopher Robin to Pooh
·
Excel 2003
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Chris Savage
Parallax Tech Support
csavage@parallax.com
I am seeing the same thing in Microsoft Office 2004(Mac)
the cell contents shows ="$"&DEC2HEX(J3,2)
The Help File says the following;
"DEC2HEX - Converts a decimal number to hexadecimal. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in."
I just went to Excel, opened an empty workbook (apparently there have been some glitches when opening a live spreadsheet and turning on the Analysis Tools) and pulled down the "Tools" menu, the selected "Add-ins" and from the Add-ins window selected "Analysis Tools - VBA". Close and exited Excel. then brought it back up with Bean's Tile sheets and it works just fine.
enjoy ...
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
cheers ... brian riley, n1bq, underhill center, vermont
See the K107 Serial LCD Controller at
www.wulfden.org/k107/
Post Edited (Brian Riley) : 8/14/2006 5:26:33 PM GMT
http://www.sxlist.com/techref/ubicom/tilecalc.htm
I tried to make it simulate the appearance of video scan lines so you can really get a good feel for what the result will look like. You may want to view it from a few feet away since the boxes needed to be big in order to be easy to click.
Let me know if there are any changes I can make to get it into a format that is easier to use.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
---
James Newton, Host of SXList.com
james at sxlist,com 1-619-652-0593 fax:1-208-279-8767
SX FAQ / Code / Tutorials / Documentation:
http://www.sxlist.com Pick faster!
A need has been fufilled thanks to Bean and James!
James,
You asked for any changes to make it better. Is it possible to leave the code in Decimal format? Otherwise, you need to add $ in front of each Hex set of characters for SX/B (e.g. DATA 123, 60, 23, 23, 23, 34, 55, 10· -->
DATA $FF, $A0, $CE, ...etc)
Thanks.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Chris Savage
Parallax Tech Support
csavage@parallax.com
Thanks for the kind words, and feel free to put the driver on sxlist (if you haven't already).
Chris, is seems in Excel 2003 you must have analysis tools loaded ???
Bean.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
Cheap 4-digit LED display with driver IC·www.hc4led.com
Low power SD Data Logger www.sddatalogger.com
"You're braver than you believe, stronger than you seem, and smarter than you think" Christopher Robin to Pooh
·
Tools - Add ins - Analysis Tools VBA.
Save it.
http://www.sxlist.com/techref/ubicom/tilecalc.htm
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
---
James Newton, Host of SXList.com
james at sxlist,com 1-619-652-0593 fax:1-208-279-8767
SX FAQ / Code / Tutorials / Documentation:
http://www.sxlist.com Pick faster!
This is·awesome! It perfectly cuts and pastes in to SX/B (SX-KEY v3.2). Great job!
Thanks.
Now, Bean, why couldn't you build up the game machine with a second SX28 and a 24LC256 and use the second chip to read data from the EEPROM and program the main chip SX48/SX28? Of the 4 pins of ICSP (SXKey, two are Vdd and Vss, so all you need to do at the appropriae time using, say, a DPDT switch is connect two of the programming processors pins to Osc1 and Osc2 on the game machine and then have a single or double 7 seven segment display and some buttons to select games number one to 12 or more, and read it from the serial eeprom and program the game chip, then switch it baqck to run the game.
Is there any reason thsi cannot work ... sort of an SX-stache!
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
cheers ... brian riley, n1bq, underhill center, vermont
See the K107 Serial LCD Controller at
www.wulfden.org/k107/
http://forums.parallax.com/showthread.php?p=600796
Thanks.
I have 3 of them on their way (I began with propeller but need more I/O for some stuff)
Very good work btw, I deffo could'nt do it.
How does it compare to the props tv out? Can it display text quite easily? or do you have to draw it tile by tile?
Sorry I am very new to this.
DJH
However, if all you want is text and simple graphics then you should really look at Bean's SX Video Module: http://www.sxvm.com/·or a newer link: http://hittconsulting.com/products/sxvideomodule/
The hardware for the video game console (in this link - not the SX video module) is nothing more than an SX chip (SX-28/48/52) with the required output lines (RA, RB, RC) and some resistors, Atari joystick (or buttons) and that's about it. See·original link below:
http://forums.parallax.com/showthread.php?p=598779
Good luck.
Has anything else become of this. I know you are very busy working on the latest SX/B beta updates but thought I would check.
I have a new display very similar to the Parallax oLED 128 GMD1:
http://www.parallax.com/detail.asp?product_id=27925
It is there latest LCD model uLCD-320-PMD2:
http://www.4dsystems.com.au/
It is a serial interfaced (Tx and Rx with custom commands to a micro-controller) LCD screen and was thinking of integrating your game system into this display - if possible.
Comments?
I don't really mind the B&W, but it would be really cool to have a full color version of breakout...jut a thought!
-Dan
http://www.rickard.gunee.com/projects/video/sx/howto.php
http://www.parallax.com/sx/projects/projects_xgamestation.asp
However, the simplest shot at color is through a Propeller chip or better yet a Hydra.
http://www.parallax.com/propeller/index.asp
http://www.parallax.com/detail.asp?product_id=32360
I've done color on the SX, but it's very difficult. It requires a custom frequency crystal and an external SRAM chip.
It's just SOOO much easier with the propeller.
Bean.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
My goal is to live forever...Or die trying.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
www.hittconsulting.com
·
And T & E Engineer, that first page was exactly what I envisioned when I thought about this. Pretty amazing stuff...to think none of this was possible (to do at home at least) 10 years ago...wow
I just ordered one, so it will take a couple weeks before I have it ready.
Does anyone have the XGS Pico that would want to try it out ?
Bean.
▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔▔
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
www.iElectronicDesigns.com
·
I was thinking of getting the·MMVGD back out again and possibly adding a Parallax 'Sound Pal' that I bought already. Do you think this would improve any of the SX-28 video performance since the audio part would not be utilized on the MMVGD? I'm thinking it would not show any significant performance improvements either way.