Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Benzadeus

#1
Tetris / I made a Tetris game on Microsoft Excel
September 26, 2016, 03:08:59 AM
Quote from: eevor
I'm on phone so haven't tried it yet, but this is awesome!
Are the formulas available or hidden? I'd love to see how it's done underneath.
Thanks. There are no formulas. I only used VBA prograaming. VBA (Visual Basic for Applications) is a programming language inside Office applications such as Excel that allow automation and much more.
#2
Tetris / I made a Tetris game on Microsoft Excel
September 25, 2016, 01:44:34 AM
Well, I'm not coding a full modern Tetris. This is just for fun. I'm just leveraging Excel to another level.
Try seeing this as a spreadsheet, not as a Tetris game... so, I'm sorry.
#3
Tetris / I made a Tetris game on Microsoft Excel
September 24, 2016, 05:59:29 PM
Hello!

I work as an Excel developer and I made a Tetris game on Microsoft Excel.
Some of the challenges to make a playable game was to bypass Windows default keyboard settings to allow keyboard customization.
I am not fully versed on Tetris hardcore players concepts like DAS, SRS and so on, but I tried hard to make a playable game. By the way, I made the game just to show the power of Microsoft Excel.
[sorry for the bad english]

Download link: Tetricell

#4
Strategy/Help / Hand of hard drop key
July 28, 2011, 09:40:58 AM
Hello,

I've searched this question, but I couldn't find anything related to it.

I'd like to know if you guys set the hard drop key in the same hand you move the pieces or in the same hand that rotate the pieces.
Which set do you think is better to play fast?

In my first impression, I noticed that fast players use the hard drop key in the same hand they move the pieces... am I right?

Scientifically thinking, I would say that the opposite hand would be better to improve speed.
#5
1 - Export spreadsheet to Excel format.
2 - At range BK2, enter formula =SUM(IF(ISERROR(MID(C2:BJ2,1,2)-MID(C2:BJ2,5,2)),"",MID(C2:BJ2,1,2)-MID(C2:BJ2,5,2)))/COUNTA(C2:BJ2) and press SHIFT+CTRL+ENTER.
3 - Copy the formula until range BK51.

Now you have AVG points per match of all players.