Articles
Practical notes on natural gas, automation, and building better systems — from the Process IQ team.
Confining NGINX
Securing NGINX on Kubernetes: A Deep Dive into Security Context This post is about securing one of the best web servers out there: NGINX. When running NGINX on …
Read articleHow to make money in Natural Gas with Python
In one of the previous posts, we were talking about simple gas storage model as a business opportunity. That model has one serious drawback: it does not take …
Read articleMachine learning with Python and C#
This post is about practical challenges with data science. At Process IQ we like Python and friends. It is a great language: it is expressive, easy to read and comes …
Read articleTesting Service Workers with Puppeteer
Warning: Technical content inside 😉 Service Worker is a JavaScript that your browser runs in the background. It is not part of the web page, rather it allows to add …
Read articleTurbocharging Excel
Aka: Fast data retrieval from a database. In a lot of enterprises that Process IQ had a pleasure to work with, there is always an Excel spreadsheet that implements a …
Read articleFaking It At Work: Testing with Javascript and Faker
As known as: Generating test data. Here at Process IQ we are obsessed with automated testing to ensure our customers get top notch products and service. We do all of …
Read articleSeasons Greetings from us
Read articleScenario analysis for Natural Gas options
Using Excel for decision making again! When trading or pricing options, there is always a dilemma what would be best structure for given assumed market scenario. …
Read articleHow to make your boss happy
By speeding up that boring reconciliation with Excel. A very frequent activity in any business is checking if an invoice, order list or any other data sets are …
Read articleTaking chances in Monte Carlo
MathJax.Hub.Config({ tex2jax: { inlineMath: [ ['$','$'], ["\\(","\\)"] ], processEscapes: true } }); One of the cool ways to learn few tricks with Excel is to use …
Read articleHelp! My python code is slow
TLDR: List comprehension is faster then append Ok, so this isn’t a picture of a python snake (this is a boa constrictor), but it is the same story with append …
Read articleHow to make money in Natural Gas with Excel
MathJax.Hub.Config({ tex2jax: { inlineMath: [ ['$','$'], ["\\(","\\)"] ], processEscapes: true } }); One of the strategies is to buy cheap summer gas, store it for …
Read articleHelp! My Excel is too slow
Quick tip for those who suffer with slow Excel syndrome (SES). The main culprit are typically too much data and large number of volatile functions. We can talk how …
Read articleAI: No more dumb systems!
Almost everybody in professional setting has come to a brick wall caused by a computer system. Either it is a problem with a cumbersome data entry or a difficulty to …
Read articleA little bit of Excel Automation
Excel applications are the good, the bad and the ugly of trading or logistics process. Spreadsheets are great as a simple database with couple of formulas to act as …
Read article