Collaborate Disseminate
Charles Komanoff’s ‘Balanced Transportation Analyzer’ is the most comprehensive accounting possible of how a congestion charge in Manhattan would affect New York City. Continue reading Meet The Spreadsheet That Can Solve NYC Transit (and the Man Who Made It)
Since 2013, The Associated Press has been making an intentional effort to put data in the hands of local reporters. In the last few years, this meant assisting with Freedom of Information Act requests and putting a team of four engineers to work … Continue reading The Associated Press’ plan to put hyperlocal data in the hands of reporters
Oklahoma man holds down the arrow button on his keyboard for hours for the greater good. Or something. Continue reading It Takes Almost 10 Hours to Manually Reach the Bottom of an Excel Sheet
Last time I showed you how to set up a reasonably complex design in a spreadsheet: a common emitter bipolar transistor amplifier. Having the design in a spreadsheet makes it easy to do “what if” scenarios and see the effects on the design almost immediately.
Another advantage that spreadsheets offer is a way to “solve” or optimize equations. That can be very useful once you have your model. For Excel, you need to install the Solver add-in (go to the Excel Options dialog, select Manage Add-Ins, and select the Solver Add-In). You might also enjoy OpenSolver. You can even get …read more
Continue reading Optimizing the Spread: More Spreadsheet Circuit Design Tricks
Accountants and MBAs use spreadsheets to play “what if” scenarios with business and financial data. Can you do the same thing with electronic circuits? The answer–perhaps not surprisingly–is yes.
Consider this simple common emitter amplifier (I modeled it in PartSim, if you’d like to open it):
In this particular case, there are several key design parameters. The beta of the transistor (current gain) is 220. The amplifier has an overall voltage gain of about 3 (30/10). I say about, because unless the transistor is ideal, it won’t be quite that. The supply voltage (Vcc) is 12 volts and …read more
Yet another email that pretends to contain a spreadsheet with financial information with the subject of :Re pretending to come from random senders and email addresses with a zip attachment is another one from the current bot runs which downloads Locky ransomware They use … Continue reading → Continue reading SPAM MALWARE: “I have attached a revised spreadsheet contains” leads to #Locky
Google today announced that it is bringing some of its Google Cloud Platform and Google Apps tools a little bit closer together. BigQuery, Google’s serverless analytics data warehousing service, will now be able to read files from Google Drive and access spreadsheets from Google Sheets. There has long been something of a firewall between Google’s cloud computing services and its… Read More Continue reading Google connects BigQuery to Google Drive and Sheets
