11 ms·
Making a virtual machine in Google Sheets
- jzymbaluk 9y agoAbsolutely incredible. So when am I going to be able to play Doom on Sheets?
- HyperLinear 9y agoNot soon enough.. :)
- harel 9y agoSomeone, somewhere, has just mumbled "hold my beer"...
- agumonkey 9y agowait for Bellard to release docslinux
- vidarh 9y agoA cell per frame-buffer pixel...
- rxdazn 9y agonot really doom but 5 years ago some people made a raycasting engine on Sheets, lets you move around and everything. https://gsuite-developers.googleblog.com/2012/03/sheetcaster-3d-in-apps-script.html https://gsuite-developers.googleblog.com/2012/03/sheetcaster... https://github.com/amaury-dlv/sheetcaster https://github.com/amaury-dlv/sheetcaster
- techolic 9y agoI came in to learn how to run Windows XP in Google sheet. Not exactly disappointed though.
- _joel 9y agoCan it run Crysis though?
- qmarchi 9y agoDoom hasn't been ported yet. Have achievable goals man!
- kryptogeist 9y agoFirst Doom, then Google Sheets on Google Sheets and then Crysis!
- stereobit 9y agoHa, good one. I implemented levenshtein distance in Apps Script the other day to help some poor colleagues who were doing manual data cleaning tasks.
- agumonkey 9y agoAmazing, I did avoid hell to collegues by implementing some form of counter in VBA. My most prized coding contribution. 8 lines that evaporated hell (filtering 1000 rows in Excel to find duplicates) into fun.
- stereobit 9y agoThis is how I started as well. But we had too many typos so I had to find something a little bit 'smarter'. Next thing on my list is to implement tf–idf to help with free text categorisation.
- yesbabyyes 9y agoSounds great! Feel free to adapt this to your usecase, if useful: https://github.com/yesbabyyes/tfidf https://github.com/yesbabyyes/tfidf
- agumonkey 9y agoI did levenstein a few time at that job, indeed, anything with operator input will have errors
- k__ 9y agoThis reminds me of my work at a big corp. The admins didn't allow my team too much software, especially no compiler or something, but(!) they allowed MS Office. So what happened was, that we started to program everything we need in VBA, with Word, Excel or Access as base, depending on the needs.
- TomMarius 9y agoYeah, very usual, and these companies make me very happy - they make exceptionally well paying customers when they critically need to redo everything into a "normal" application.
- foobarbazetc 9y agoThis is the case at a lot of places. I know of global banks where billions of $ gets moved about by updating Excel spreadsheets.
- Musonius 9y agoThat's unbelievable and got me intrigued, please expand.
- SubiculumCode 9y agoI sincerely hope you are trolling.
- SubiculumCode 9y agoI hoped he was trolling because what he describes sounds outrageous. Sheez.
- foobarbazetc 9y agoI'm not trolling. It's 100% true and far more prevalent than you would expect. People always choose the path of least resistance.
- mbaha 9y ago
- indigochill 9y agoThis may sound silly, but I don't think I've actually seen a more elegant functional visualization of how computers work at that level. I could see this being used as an educational aid to introduce students to the key concepts.
- ZoFreX 9y agoIf you like this you might also like the games "Human Resource Machine" and "TIS-100", which both give a similarly visual insight into how computers work.
- michaelmior 9y agoLinks below. Worth noting that both of these are included in the Steam Summer Sale which ends in a couple hours. http://store.steampowered.com/app/375820/Human_Resource_Machine/ http://store.steampowered.com/app/375820/Human_Resource_Mach... http://store.steampowered.com/app/370360/TIS100/ http://store.steampowered.com/app/370360/TIS100/
- Beltiras 9y agoHRM looks fun. Bought it. TIS100 notsomuch to me. I can see the appeal for some thou.
- em3rgent0rdr 9y agoI'd only recommend HRM for people who haven't touched assembly before. For those that have, it is a bit of a waste of time and not very challenging...I kept hoping the problems would be harder, and maybe something that you wouldn't do in an introductory college course. TIS and Shenzhen I/O on the other hand have unique challenges and are well worth your time investment for help thinking outside of the box. Many different ways to solve the problems, unlike HRM where there is basically one obvious speed and one obvious size solution.
- 9y ago
- SonOfLilit 9y agoOh, man. This is a VM in JS ("Google Script") with a UI in Google Sheets. If I had more time I'd post a VM in Google Sheets formulas only. Anyone want to take it up? Edit: hold my beer (see my reply below)
- ulucs 9y agoThis popped into my mind https://www.youtube.com/watch?v=uNjxe8ShM-8 https://www.youtube.com/watch?v=uNjxe8ShM-8
- samfisher83 9y agoPeople have done some absolutely crazy things with Excel as well. To some people its like an OS.
- sogen 9y agoWasn't there a flight simulator or a Doom a decade ago?
- khedoros1 9y agoExcel 97 had a sort of flight simulator. Excel 2000 had a car game. Earlier versions had other little easter eggs, but I think that Microsoft cracked down on them after Excel 2000.
- mikestew 9y agoTurns out the federal government to which Microsoft sells wondered, “if they’re sneaking in flight simulators and dungeons, what else are they sneaking in?” That’s the version I was told, anyway. That, and Easter eggs are another attack vector. How much of a security audit do you think those get?
- euyyn 9y agoExcel had a flight simulator as an easter egg, but it wasn't written in Excel formulas or VBA :)
- throwaway2016a 9y agoI didn't know about App Scripts. This is very cool not just because it is a relatively clean visualization of a CPU but also because (on a personal level) it showed me what App Scripts can do. Now if only it displayed the register values in hex or binary. As an education aid in college I found it easier to visualize what was actually happening in one of those bases. Another useful feature for debuggers is to highlight the values that changed in the last step. Sometimes even highlighting the exact bit if displaying in binary. I'm not sure how doable that is in Google Sheets though. Edit: it's also a nice attention to detail that the stack shares the same heap as instructions. It might have been an easy out to put the stack in it's own column.
- tyingq 9y ago>Now if only it displayed the register values in hex or binary. I assume that's as easy as adding a few more cells with =DEC2HEX(A2) or whatever.
- XCSme 9y agoSo cool! Useless, but cool :)
- gkya 9y agoWut? It's a really nice illustration of how a computer works. Have you clicked the link?
- Mister_Snuggles 9y agoThis reminds me of a "game" that a friend and I made in Excel. The game was, roughly, a text-based adventure game. Each row in the sheet represented a "room", columns across gave names to the directions you could go and the target rooms, a description of the room, etc. I think there were other columns to mark whether the room represented the end of the game too. The UI was a bunch of buttons and cells on another tab that were manipulated by VBA code. The game was never very good, but we ended up creating quite a lot within that limited framework.
- laumars 9y agoVBA is less limited than people like the believe. When I was bored in one college lesson I was playing around with calling Win32 APIs inside a Word 97 macro. I was able to call winsock and write a simple chat application.
- Mister_Snuggles 9y agoVBA is actually a pretty amazing language. Even without diving into the Win32 APIs, there is an absolutely amazing amount of stuff that gets exposed via COM and, as a result, is easily accessible from VBA. Of course, the biggest downside to all this power is that people actually used it. This is how you end up with businesses that live and die by gigantic and virtually impenetrable Excel workbooks.
- epx 9y agoI remember of a Blackjack game implemented in SuperCalc 3 using only circular referencing and IF() as "programming" loopholes
- exabrial 9y agoFrom the "use the right tool for the job" department :D
- chubot 9y agoI can't see the code without edit access? I go to Tools -> Script Editor, click, and it does nothing. No error even. (Happens in both Firefox and Chrome.)
- briansteffens 9y agoThat's weird. You should be able to copy the document and then view the source in your copy.
- kevin2r 9y agoThanks, making a copy works. But it should show you an error like "You need permissions to edit this document" or something.
- kevin2r 9y agoYes, me too, I also wanted to see the implementation. I did submit a "Problem Report" on why you don't get visual feedback when opening the script editor and getting an error.
- j45 9y agoFun read, it reminded me of a Computing Science assignment I remember to this day - prof had us build a Russian compiler that worked with trits (0,1,2) instead of bits. A tool like this would have made traversing and visualizing it a lot easier.
- assafmo 9y agoSo much awesomeness!
- Magnificents 9y agoNeat. Reminds me of all the crazy shit people did with Excel and VBA.
- louithethrid 9y agoCloud vaping The next big step in free hosting: Milking public available turing complete services for free computation power.
- ibejoeb 9y agoI have a pretty big app that uses Sheets for free storage, apps script for processing and HtmlService to expose an json api endpoints and to serve the UI. I'm pretty happy with it. Totally free app.
- LarryPage 9y agoHaha I did the same thing to build huge scrapers.
- kalleboo 9y agoOr DDoSing http://www.behind-the-enemy-lines.com/2012/04/google-attack-how-i-self-attacked.html?m=1 http://www.behind-the-enemy-lines.com/2012/04/google-attack-...
- Fej 9y agoNow all we need is a higher-level language that compiles to Sheets VM. How hard would it be to write a C-like for this?
- SonOfLilit 9y agoNot that hard. Allow me to recommend NAND2Tetris, one of the best courses I've ever tried, that has a great practical lesson on exactly that.
- IgorPartola 9y agoI had this idea one time to use MySQL triggers to create a bunch of XOR gates and then use those as a basis for a CPU. Then eventually I could run Linux on that and rung MySQL on top of it.
- erikatoni 9y agoAwesome!!!
- stared 9y agoAnd I thought that http://www.deepexcel.net/ http://www.deepexcel.net/ (Deep Spreadsheets with ExcelNet) was mind-blowing...