Spreadsheet Calculator for Sampling or Baud Rates

Go To Last Post
5 posts / 0 new
Author
Message
#1
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

For anyone interested, I finally broke down and built/posted a M.S. Excel 2000 Spreadsheet (Yes I know its microsoft but thats the office suite I have access to) that can be used to calculate timer preload values (in decimal and hex) to achieve specific user input sampling rates based off a manual Crystal frequency input (For both 16 & 8 bit). Will also calculate UBRR register values for specific baud rates given the same maunal Crystal frequency input and the associated baud error rates. Will calculate the Crystal frequency required for a 0% baud error rate for a user input desired baud rate.

NOTE: This calculators require hex conversion functions found in the Excel Analysis TookPak.

If you modify Cells and and view #NAME? in the answer cells you do not have the Analysis ToolPak available. If this function is not available, run the Setup program (M.S. Office or Excel) to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

It can be found under the Lab Resources Link on this web page
http://mechatronics.me.wisc.edu

comments would be appreciated.

Erick

--
Erick L. Oberstar

Mechatronics Lab Manager/Engineer
University of Wisconsin - Madison
1513 University Ave.
Madison, WI 53706

http://mechatronics.me.wisc.edu

  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

For those without Excel, I would also look at Horst's AVRCalc project in the Academy.

Sean.

  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

AvrFreaks has kindly archived the original AvrCalc in the Tools section of this forum. AvrCalc has allways been a free tool for the AVR community. I do not terribly mind Horst, nearly copying the interface, but only that he come up with his own naming convention. This only disturbs me from an ethics point of view, and NOT any legal issues. How does the "gang" in this forum feel about these types of issues? Or am I just over reacting?

  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Sorry Erick, it just dawned on me that I replied to a thread that had absolutely nothing to do with your original post. I also must congradulate you on a very original application use for MS Excel in regards to AVRs. Please accept my public apology for this unintentional mistake.
Jack Tidwell

  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Jack,

Not a Problem! Apology Accepted! I started to worry a bit that I accidentally infinged on someone elses work until I got down to your following post.

Anyway I hope that it is of some use. I did it for some of our students that had MAC's and or PC's (but still had MS Excel) since I'm not sure if the calculator interface Horst did will run on a MAC - (doubt it but it may be possible with an emmulator)

I shoud really just do an ASP or Java online AVR calculator. Anyone have any requests for that?

Regards,

Erick