docs.google.com• Jun 10, 2024• 1 min read
Show HN - I made my own Perlin-like Noise in Google SheetsGreetings HN!If you're like me, you enjoy pushing the boundaries of software applications for fun and profit. In an abundance of that enterprising spirit, I've taken a unique approach to procedural generation using Google Sheets.I created a Perlin-like noise generator, which I’ve named the "tentpole noise algorithm," relying entirely on cell formulas and MOD functions for pseudo RNG with a seeded approach.Here's a breakdown of how it's structured:First Layer - Establishing Tentpoles: The initial setup involves defining high and low points using modulus operations to determine peak positions:This mimics the function of tentpoles, setting the maximum and minimum =IF(MOD(C$5,$C$1) + MOD($A7,$C$1)=0,IF(MD5(CONCATENATE($C$3,C$5,$A7))>"8",((HEX2DEC(RIGHT(MD5(CONCATENATE($C$3,C$5,$A7)),1))-5)*$C$4),0),0) Second Layer - Canvas Logic: This layer applies logic to smooth the terrain between the tentpoles, simulating the canvas stretched over them =IF(E9=0,(SUM(IF(D9=0,0,D9),IF(E8=0,0,E8),IF(F9=0,
