NP photo images from the BNSF photo archives. Many of these photos were used in NP advertising over the years and were taken by photographers F. Jay Haynes, Ronald V. Nixon and others. Cal State RR Museum Photo Collections. Aug 06, 2021 General NP Information Healthcare covers a wide array of topics. If you’re simply interested in everything that life as an advanced practice provider encompasses, check out these posts discussing topics from scope of practice and specialty trends to the latest in NP and PA employment issues.
Bob wrote a blog post last week, Formulas Made Easy, that I read with great interest. He uses a custom language in Notepad++ to allow for indenting formulas, editing formulas, and all the other stuff you can do in a text editor that you can’t do in Excel’s formula bar. I downloaded Notepad++ and Bob’s xml files and gave it a try.
The only thing I don’t like about it is the folding option. Folding is collapsing certain portions of the code so the rest is easier to read. I started by trying to make all of the function names Folder Open Keywords and a close parenthesis as the Folder Close Keyword. That worked OK, but didn’t work well with FALSE as FALSE is both a potential argument and the name of a function.
Then I thought that simply having an open parenthesis as the only Folder Open Keyword would be even better. However, it seems to require a space before the open parenthesis or to have it start a line to work. That still may be a better option, although it would require that I consistently line break before the open paren rather than after. Not the worst thing in the world, but not would I would do intuitively.
I ended up appending an open paren to the function names and using that as Folder Open Keywords. So ABS would be ABS(. I like the folding option this provides and it eliminates the problem with FALSE being interpreted as a function name when it’s used as an argument. Here’s how it ended up.
Pretty cool, I think. Happily, the intellisense portion works with Folder Open Keywords just like for Keywords. It remains to be seen if I’ll use it as a formula editor. But I think the next time I start counting parentheses I’ll pull this up and save myself some trouble. I pasted the above formula back in Excel and it retains the line breaks.
If you like this folding option, you can import my UDL xml file instead of Bob’s. By the way, thanks to Bob for doing all the hard work on this. I don’t know if I would have had the patience to put all those function names in there.
You can download xlf_udl.zip
I was looking for a list of the tables and fields in SAP B1 and found a great site:
The person that maintains this site also maintains a similar site for the JD Edwards application
So while I was at it I thought I would see if anyone had done something similar for Great Plains. I found a few sites.
http://dyndeveloper.com/DynModule.aspx (some info members only)
This type of information is usually available directly from the vendor, but often those resources are restricted to licensed users with a support account. The sites above are open to the public. If you know of has a similar site for another application, let me know and I will add it here.