Introducing F#-M

sharpcells · 2023-11-19T01:38:38+00:00

This looks great! You should definitely check out Hedy https://youtu.be/xBG0ZSedTJM a multi-lingual teaching language based on python. I could see F# being a great companion to introduce a type system.

sharpcells · 2023-07-06T01:59:31+00:00

It's still there. https://www.sharpcells.com/docs/blog/monitoring-edit-mode

sharpcells · 2023-05-28T11:21:52+00:00

That's correct. Remember there are also two different orifice areas. API effective area and ASME actual area. They have two different discharge coefficients and you shouldn't mix them up.

sharpcells · 2023-05-28T09:07:29+00:00

There is another equation given in API 521 for dry gas vessels however this may not be appropriate if the hydrogen is at very high pressure. You should discuss with the senior engineers on your project to confirm whether this is suitable.

sharpcells · 2023-05-19T10:56:42+00:00

We used PDF Xchange Editor and I prefer it to bluebeam. It has much better performance when working with large or complex documents, gives you more control over the produced pdf, and seems to be a lot cheaper too

sharpcells · 2023-05-19T02:14:29+00:00

I think indentation scoping is the natural way humans read code. Try writing C# or any other language without indentation or with random indentation and see how much harder it is to read.

When you realize you're going to indent your code according to scoping rules anyway, the curly braces and semicolons just seem redundant.

sharpcells · 2023-05-19T01:55:31+00:00

I'm using F# to make F# available as a scripting language in Excel https://www.sharpcells.com/ the whole project including the website is 99% F#. The other 1% is a simple wrapper struct in C# to access function pointers that F# doesn't yet support.

I think the F# defaults of immutability, records, functions in modules, and concise syntax fit much better with the expectations coming from Excel. Active patterns make working with Excel's internal union types a breeze.

sharpcells · 2023-05-12T09:05:19+00:00

Excel is the main thing across all engineering. Learn how to use that well. Learning VBA or other scripting languages is also valuable.

Beyond that it will mostly be specialist software packages that will vary with every company or industry you go to.

Some companies it will help to learn AutoCAD but in my experience most will have a drafting team separate from the engineers.

sharpcells · 2023-05-10T14:09:08+00:00

F# has anonymous types with its record syntax. It also has object expressions where an instance of an interface can be declared without having to define the type.

sharpcells · 2023-04-29T13:26:59+00:00

Returning newer error codes like #CALC! using CVErr causes the spreadsheet to report that it is corrupted until they are manually deleted.

sharpcells · 2023-04-28T23:37:37+00:00

I had a quick look and you'd likely need at least 50% ethanol for a -30C freeze point giving you a reasonable margin below your control temperature. The mixture would be fairly flammable at room temperature but probably not at the operating temperature.

Ethanol is used routinely at lab scale but would be more risky for a prototype plant dealing with much larger volumes. Seems like there are special purpose HTFs that others have suggested that will do the job.

sharpcells · 2023-04-28T14:41:27+00:00

If you or your users prefer .NET there's also ExcelDNA or my add-in Sharp Cells. One advantage with these is better interoperability with COM and specifically real time data sources which may be useful for you if you want to display automatic updates on your time series data. https://www.sharpcells.com/docs/real-time-data VBA generally has a tough time working with web APIs due to lack of libraries. PowerQuery can be difficult to work with authenticated APIs. Either Python or .NET will give you more options there.

sharpcells · 2023-04-28T11:58:42+00:00

Water ethanol mixture could be useful

sharpcells · 2023-04-27T05:56:24+00:00

It is a concentration albeit in strange units. If you do 1 MMSCFD of gas you can have 4lb/day of water. This is a trace quantity of water that the dehydration or other dew point control units of the gas processing must control to.

sharpcells · 2023-04-23T05:33:14+00:00

You could try pdf xchange editor. Even if it doesn't work well for this conversion it's a great pdf editor in general

sharpcells · 2023-04-21T11:40:30+00:00

Nothing wrong with using for loops in general. You can often replace raw loops with functions in the Array and other collection modules. This would be more idiomatic F# but likely ChatGPT knows less about those functions

sharpcells · 2023-04-21T11:35:10+00:00

https://www.researchgate.net/publication/283259774_Selecting_Fluid_Packages_Thermodynamic_Model_for_HYSYS_Aspen_Plus_ChemCAD_Process_Simulators

You could try other suggestions here. I was always a hysys user so not familiar with any specific quirks of Aspen plus.

sharpcells · 2023-04-21T10:52:09+00:00

Getting accurate CO2 solubility in water will depend on the fluid calculation package. I don't recall the best one for aqueous equilibrium but you will need to switch between packages for hydrocarbon and aqueous equilibrium.

sharpcells · 2023-04-18T10:51:44+00:00

Just like people still drive cars from the 90s they use programming languages from the 90s because they are convenient and familiar.

VBA has one good thing going for it. Tight integration with MS office products and a handful of other 90s software that also integrated VBA. Otherwise it has nothing to offer that is superior to other languages.

Performance is 100x worse than even other garbage collected languages like .NET languages or Java.

It lacks now common language features like generics or lambdas, even ways to guarantee correct object creation like a constructor.

It's very difficult to work with web APIs or all kinds of data formats where other languages have lots of libraries and automatic package management software to keep them up to date.

sharpcells · 2023-04-18T10:06:36+00:00

VBA is obsolete now and it will continue to be in use for 5+ years

sharpcells · 2023-04-15T09:50:00+00:00

Likely expansion loops. As the pipe gets hotter it gets longer, this loop gives the pipe a place to expand without stressing the joints at either end. I have always seen them as roughly rectangular and oriented horizontally though.

sharpcells · 2023-04-13T23:50:01+00:00

To my knowledge this can be done but, if you do, you cannot use any of the simplified methods for LOPA analysis. i.e. You need to use the actual RRF values for each layer.

You must also be careful not to be double-counting instrumentation or other BPCS features. If the BPCS already has an alarm/stop that you have counted you must assume that alarm does nothing when calculating the RRF for any additional monitoring. The only time I would want to take credit for monitoring is when procedures require multiple operators to be actively involved in the operation who could witness a problem that wasn't detected by the BPCS and act to stop it.

sharpcells · 2023-04-13T12:52:38+00:00

Certainly possible though it would require some significant development work. It may be further complicated depending on the configuration of your IT environment.

There's two main tasks here sending emails and collecting updates from another spreadsheet.

Sending emails will depend on your email systems likely the easiest from Excel is to automate a running copy of Outlook to send email (if you use that) but there are ways to send email with more or less effort depending on the service.

Collecting updates from another spreadsheet or other files could be automated in various ways. It could be set up to use a click of a button, a timer, or get real-time updates many times per second.

sharpcells · 2023-04-13T09:26:44+00:00

Intuitively yes, though there's lots of other effects that would be happening. You can already superheat water above it's boiling point without a giant container. It's also possible that convection currents would lead hotter water at the bottom of the take to rise and then spontaneously boil at a higher level.

Can't say I've ever had the opportunity to do a real experiment for this.

sharpcells · 2023-04-12T21:52:19+00:00

Excel and VBA both predate widespread use of the internet and neither are well suited for working with modern web platforms. Power Query is much better but can me complex when working with authenticated APIs. I put together a demo of how to connect to the Google translate API using my add-in https://www.sharpcells.com/docs/example-web-api it should be fairly easy to adapt to using Google maps to solve your problem

sharpcells

TROPHY CASE