Processing Excel Data with Powershell

When a new customer signs up for Productioneer, Mi4 imports their historical data from their previous system into their new Productioneer environment so that they can have a comprehensive view of their assets. Typically our customers are switching from another system like GRT, FieldDirect, Merrick, etc and the data is relatively straightforward for us to import.

Sometimes we have clients that weren’t using a field data capture system at all and were keeping track of their production in Excel. Normally these companies only have 20 or so wells and manually manipulating the Excel spreadsheets into an importable format isn’t too labor intensive.

An exception to this rule was a new client we on-boarded, let’s call them Hakamada Resources because their actual name isn’t really pertinent to the blog post and this Juzo Itami movie I just watched was really good.

Continue reading “Processing Excel Data with Powershell”

Tools of the Trade: Keyboards

The pen is mightier than the sword they say, but for programmers, the keyboard is our tool of choice.

Using the keyboard is the main method we put our thoughts/ideas/code into being. One can even say that the keyboard is an extension of a programmer. With the vast array of keyboard choices, programmers can find the best fit keyboard for their workflow.

Keyboard Sizes

60% keyboard - iKBC New Poker ii
Keyboards come in various sizes that can accommodate your desk space, typing preference or aesthetic. Many are familiar with the standard or full-size ANSI OR ISO keyboards but there are other “compact” formats available. Some examples of compact keyboards:

  1. Tenkeyless – keyboard without numpad
  2. 60% keyboard – generally a keyboard without numpad and F row
  3. 40% keyboard – minimalist keyboard with letters and some modifiers

These compact keyboards may have programmable layers where the numeric row or F row functionality can be accessed. On some, you can create macros that can easily run scripts or simplify hotkey combos with less key presses. EFFICIENCY! Continue reading “Tools of the Trade: Keyboards”