programming with excel

A spot for all things TestTube
Post Reply
19683
Posts: 151
Joined: Wed Jun 05, 2013 12:15 pm

programming with excel

Post by 19683 »

How do you generate codes using excel?
Binomial Theorem: ((a+b)^n)= sum k=0->k=n((n!(a^(n-k))(b^k))/(k!(n-k)!))
A Random Player
Posts: 523
Joined: Mon Jun 03, 2013 4:54 pm

Re: programming with excel

Post by A Random Player »

Use the if statement. The rest is trial and error. :P (You don't even need the if statement!)
Also try turning on iterative calculations. This is very inconsistent though.
This forum doesn't allow .xlsx attachments though, so I can't attach any of the stuff I've made.
Andy, could you try allowing .xlsx?
$1 = 100¢ = (10¢)^2 = ($0.10)^2 = $0.01 = 1¢ [1]
Always check your units or you will have no money!
User avatar
robly18
Posts: 413
Joined: Tue Jun 04, 2013 2:03 pm

Re: programming with excel

Post by robly18 »

You can do programming with excel? Well don't that beat all, I gotta try that out.
19683 (it would be much easier to just call you numbers), you can just upload your stuff into a website like, say, mediafire I believe.
Convincing people that 0.9999... = 1 since 2012
A Random Player
Posts: 523
Joined: Mon Jun 03, 2013 4:54 pm

Re: programming with excel

Post by A Random Player »

robly18 wrote:You can do programming with excel? Well don't that beat all, I gotta try that out.
19683 (it would be much easier to just call you numbers), you can just upload your stuff into a website like, say, mediafire I believe.
Nah, without the VBA it's not easy to do 3+d arrays. In fact even control structure isn't straightforward - It's more like a Turing machine or cellular automaton than a programming language.

Oh and mediafire isn't very safe sometimes, even if you click the right link. I'd recommend describing the things in the cells, or waiting for Andy to enable .xlsx.
$1 = 100¢ = (10¢)^2 = ($0.10)^2 = $0.01 = 1¢ [1]
Always check your units or you will have no money!
User avatar
testtubegames
Site Admin
Posts: 1148
Joined: Mon Nov 19, 2012 7:54 pm

Re: programming with excel

Post by testtubegames »

A Random Player wrote:I'd recommend describing the things in the cells, or waiting for Andy to enable .xlsx.
Added! (I think)
A Random Player
Posts: 523
Joined: Mon Jun 03, 2013 4:54 pm

Re: programming with excel

Post by A Random Player »

testtubegames wrote:
A Random Player wrote:I'd recommend describing the things in the cells, or waiting for Andy to enable .xlsx.
Added! (I think)
Yep, it works! Here's one of mine:
Excel Prime Factorizer.xlsx
First, enable editing. If it errors with "circular reference", try closing any other excel spreadsheets. To use it, set A1 to the number to the number to be factored, and set B1 to 0, then 1. Hold F9, and wait.
$1 = 100¢ = (10¢)^2 = ($0.10)^2 = $0.01 = 1¢ [1]
Always check your units or you will have no money!
User avatar
robly18
Posts: 413
Joined: Tue Jun 04, 2013 2:03 pm

Re: programming with excel

Post by robly18 »

Seems like it feels a lot like some of them first computers.
Do want.
Convincing people that 0.9999... = 1 since 2012
Post Reply