Battling a monster problem, with my first LAMBDA скачать в хорошем качестве

Battling a monster problem, with my first LAMBDA

This is a video walkthrough of an optimization problem from the Financial Modeling World Cup (this appeared in the round last weekend). Pardon the extremely cheesy cover picture, but it seems somewhat appropriate that a particularly daunting challenge like this would be the occasion for me to write my first LAMBDA, one of Excel's super-powered new functions. Sections 00:00 Introduction 05:48 Identifying the districts 10:18 Listing unique districts (manual approach) 11:34 Using LAMBDA to flatten a 2D array 17:12 District valuation calculations 22:00 Aside on design choices 23:16 Valuing each house (and some debugging!) 29:06 Identifying and filling vacant lots 32:42 Motivation for the optimization approach 40:01 Manual optimization 41:16 Systematic optimization Steal my LAMBDA If you want to flatten things in Excel, you're very welcome to steal the function I wrote in the video. Just create a named range called Flatten (or whatever you want to call it) and copy paste the formula below into the definition: =LAMBDA(Rng, LET( RowCnt, ROWS(Rng), ColCnt, COLUMNS(Rng), RowInd, ROUNDUP(SEQUENCE(RowCnt*ColCnt)/ColCnt,0), ColInd, SEQUENCE(RowCnt*ColCnt)-(RowInd-1)*ColCnt, INDEX(Rng,RowInd,ColInd))) Then when you want to use it, just type =Flatten(Range) where Range is a 2D array, and it will list all the items in the array in reading order (left-to-right, top-to-bottom). Dragon icon by Will-Erwin on Deviant art, used with permission - link here: https://www.deviantart.com/will-erwin... Other icons from Excel (insert → illustrations → icons)