Scratch
archived forums
#1 2012-10-19 09:33:15
- Molybdenum
- Scratcher
- Registered: 2012-06-17
- Posts: 1000+
MS Excel "programs" (with no macros)
Anyone make these? I have GoL, binary list to chars, food chain animation (plots the 3 different creatures!), and more.
Here's a prime factorizer to get started:
Start with a blank sheet.
Turn on iterative calculations (file/office button, options, formulas (left), check enable iterative calculations, set max iterations to 1).
Set A1 to a (smallish) number, set B1 to 0.
Set A3 to this: =IF($B$1=0,"///",IF(MOD($A$30,$A$31)=0,A4,A3))
Drag-fill to A28.
Set A29 to FACTORS
Set B29 to =IF(A30=1,"Done factoring!","Factoring…")
Set A30 to =IF(B1=0,A1,IF(MOD(A30,A31)=0,A30/A31,A30))
Set A31 to =IF(B1=0,2,IF(A30=1,A31,IF(MOD(A30,A31)=0,A31,IF(A31>SQRT(A30),A30,IF(A31=2,A31+1,A31+2)))))
Set C1 to MS EXCEL PRIME FACTORIZER MADE BY MOLYBDENUM
To use, set B1 to 0, set A1 to the number you want to factor, and set B1 to 1.
Hold F9. The prime factors of the number should come out of the bottom, and when the "Factoring..." display says "Done factoring!", the program is done.
Discuss these.
Last edited by Molybdenum (2012-10-19 10:10:48)
"The Enrichment Center is required to remind you that you will be baked, and then there will be cake."
(|Balls and Platforms: Stay on!|) (|NaOS-H: An operating system... Or is it?|)
Offline
#2 2012-10-19 09:36:50
- mythbusteranimator
- Scratcher
- Registered: 2012-02-28
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
O_o
clicky
Offline
#3 2012-10-19 10:16:29
- Molybdenum
- Scratcher
- Registered: 2012-06-17
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
Alternatively, you can set the max iterations to 32767, and it will compute the factors (almost) instantly when you set B1 to 1.
"The Enrichment Center is required to remind you that you will be baked, and then there will be cake."
(|Balls and Platforms: Stay on!|) (|NaOS-H: An operating system... Or is it?|)
Offline
#4 2012-10-19 17:53:03
- Molybdenum
- Scratcher
- Registered: 2012-06-17
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
Bump.
"The Enrichment Center is required to remind you that you will be baked, and then there will be cake."
(|Balls and Platforms: Stay on!|) (|NaOS-H: An operating system... Or is it?|)
Offline
#5 2012-10-20 09:26:17
- Molybdenum
- Scratcher
- Registered: 2012-06-17
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
Bump!
"The Enrichment Center is required to remind you that you will be baked, and then there will be cake."
(|Balls and Platforms: Stay on!|) (|NaOS-H: An operating system... Or is it?|)
Offline
#6 2012-10-21 01:49:15
- nathanprocks
- Scratcher
- Registered: 2011-04-14
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
This sounds cool. I might try it on my other laptop in a few minutes (MS Office is on my other laptop and I don't want to buy it again just for my Macbook 
).
Offline
#8 2012-10-22 17:22:59
- scratchisthebest
- Scratcher
- Registered: 2009-02-08
- Posts: 500+
Re: MS Excel "programs" (with no macros)
I'll have to try that out later when I have the time.
Right now I have an adder.
C1: =A1+B1
Oh wow that was so hard to make
bye 1.4, we all loved you. but we all outgrew the site. 2.0 is a welcome change.
Offline
#9 2012-10-22 20:01:23
- cocolover76
- Scratcher
- Registered: 2011-10-09
- Posts: 500+
Re: MS Excel "programs" (with no macros)
C1: =CONCATENATE(A1+B1, A2+B2, A3+B3)
C2: =CONCATENATE(A1*B1, A2*B2, A3*B3)
C3: =CONCATENATE(A1/B1, A2/B2, A3/B3)
D2: =CONCATENATE((C1+C2)+C3, (C1*C2)*C3, (C1/C2)/C3)
D2 is random numbers and periods, if A1 A2 A3 B1 B2 and B3 are random numbers from 1 to 10.
Offline
#10 2012-10-22 22:14:56
- Laternenpfahl
- Scratcher
- Registered: 2011-06-24
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
hi coco 
also wat
Offline
#11 2012-10-27 10:02:02
- Molybdenum
- Scratcher
- Registered: 2012-06-17
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
Bump.
"The Enrichment Center is required to remind you that you will be baked, and then there will be cake."
(|Balls and Platforms: Stay on!|) (|NaOS-H: An operating system... Or is it?|)
Offline
#12 2012-10-28 16:39:59
Re: MS Excel "programs" (with no macros)
My mum used to make worksheets in Excel as her job. She is the master of Excel.
Offline
#13 2012-12-11 19:51:15
- Firedrake969
- Scratcher
- Registered: 2011-11-24
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
How the heck do you do these? I can to arithmetic.
Click the sign.
Offline
#14 2012-12-11 20:21:30
- Laternenpfahl
- Scratcher
- Registered: 2011-06-24
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
Excel should have checkboxes like numbers
Offline
#15 2012-12-11 21:04:39
- Firedrake969
- Scratcher
- Registered: 2011-11-24
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
Molybdenum wrote:
Anyone make these? I have GoL, binary list to chars, food chain animation (plots the 3 different creatures!), and more.
Here's a prime factorizer to get started:
Start with a blank sheet.
Turn on iterative calculations (file/office button, options, formulas (left), check enable iterative calculations, set max iterations to 1).
Set A1 to a (smallish) number, set B1 to 0.
Set A3 to this: =IF($B$1=0,"///",IF(MOD($A$30,$A$31)=0,A4,A3))
Drag-fill to A28.
Set A29 to FACTORS
Set B29 to =IF(A30=1,"Done factoring!","Factoring…")
Set A30 to =IF(B1=0,A1,IF(MOD(A30,A31)=0,A30/A31,A30))
Set A31 to =IF(B1=0,2,IF(A30=1,A31,IF(MOD(A30,A31)=0,A31,IF(A31>SQRT(A30),A30,IF(A31=2,A31+1,A31+2)))))
Set C1 to MS EXCEL PRIME FACTORIZER MADE BY MOLYBDENUM
To use, set B1 to 0, set A1 to the number you want to factor, and set B1 to 1.
Hold F9. The prime factors of the number should come out of the bottom, and when the "Factoring..." display says "Done factoring!", the program is done.
Discuss these.
Is there a website you can learn this?
How do you do if, repeat, loops, etc?
Last edited by Firedrake969 (2012-12-11 21:19:32)
Click the sign.
Offline
#16 2012-12-11 21:32:50
- funelephant
- Scratcher
- Registered: 2010-07-02
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
or make jeopardy with hyperlinks
nicki begs to differ
Offline
#17 2012-12-11 21:40:07
- Firedrake969
- Scratcher
- Registered: 2011-11-24
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
funelephant wrote:
or make jeopardy with hyperlinks
How do you do it? I would upload what I know but...
Click the sign.
Offline
#18 2012-12-12 19:55:52
- Firedrake969
- Scratcher
- Registered: 2011-11-24
- Posts: 1000+
Re: MS Excel "programs" (with no macros)
Firedrake969 wrote:
Molybdenum wrote:
Anyone make these? I have GoL, binary list to chars, food chain animation (plots the 3 different creatures!), and more.
Here's a prime factorizer to get started:
Start with a blank sheet.
Turn on iterative calculations (file/office button, options, formulas (left), check enable iterative calculations, set max iterations to 1).
Set A1 to a (smallish) number, set B1 to 0.
Set A3 to this: =IF($B$1=0,"///",IF(MOD($A$30,$A$31)=0,A4,A3))
Drag-fill to A28.
Set A29 to FACTORS
Set B29 to =IF(A30=1,"Done factoring!","Factoring…")
Set A30 to =IF(B1=0,A1,IF(MOD(A30,A31)=0,A30/A31,A30))
Set A31 to =IF(B1=0,2,IF(A30=1,A31,IF(MOD(A30,A31)=0,A31,IF(A31>SQRT(A30),A30,IF(A31=2,A31+1,A31+2)))))
Set C1 to MS EXCEL PRIME FACTORIZER MADE BY MOLYBDENUM
To use, set B1 to 0, set A1 to the number you want to factor, and set B1 to 1.
Hold F9. The prime factors of the number should come out of the bottom, and when the "Factoring..." display says "Done factoring!", the program is done.
Discuss these.Is there a website you can learn this?
How do you do if, repeat, loops, etc?
Click the sign.
Offline