After 15 years of relative bliss (at least in this specific area), I will soon
be required to charge user fees to recover the operating costs for our NMR
facility. I've spent some time playing around with the built in accounting
options in OpenVnmrJ 3.1 and TopSpin 4.1.4 and I must say that I'm deeply
underwhelmed. That means I need to process the log files directly to
get the data that I'm interested in.
I have successfully done some quick and dirty processing of the log files to
at least get some rough statistics on how sample times per user, start/stop
time distributions, etc. (vnmrsys/Automation/auto*/logfile for OVJ and
/opt/topspin4.1.4/prog/curdir/changer/inmrchanger/*hist for TS) However,
my current approach is messy and too much of a hack for real accounting.
*Before embarking on a writing myself a better processing script, I figured
I should check here to see what kind of scripts people have already created
for extracting information from OVJ and TS.*
(Details for those interested)
My goal is to generate a CSV file that gives me a list of each sample submitted,
the operator username who submitted the sample, the date and time that the
sample was started, and the total instrument time that the sample took.
My goal is to have a per sample charge and then a flat rate per minute on top
of that (with the typical "off hours" being cheaper than "busy hours").
The primary problems with the built in software are
1) OVJ per sample charge isn't actually a per sample charge. For example,
a sample submitted with a proton, carbon, and COSY will trigger several "go"
charges during the lock and shim stage (it appears to apply a "go" charge for
every iteration of the automated shimming!) and then several go charges for
each of the protocols (i.e., it appears to charge a "go" for the automated gain
setting and then one for the actual acquisition).
2) The TopSpin .csv generation appears to be useless - most of the fields are
blank (no info about individual operators within a group, etc.) The
summary file provides a lot of useful data, but then I would have to convert
that .tmp file into a CSV format. Even then, there doesn't appear to be
a way to have a per sample charge, just a flat rate per time. It also
appears that there is no account taken for the time to lock, tune, shim, etc.
(that's where having a fixed per sample charge would be helpful).
I can't use anything that's tied to a scheduling page or a resource request
page because we don't schedule the instruments (they have auto-samplers).
I want the charges to reflect actual usage vs. incomplete/inaccurate user-provided
data. I guess I should note that all my systems run on RedHat, so Windows-based
scripts aren't directly helpful (although the logic/approach might be useful).
I'm interested to see what tools people have already come up with.
-Scott
-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#386): https://urldefense.com/v3/__https://ammrl.groups.=
io/g/main/message/386__;!!PvDODwlR4mBZyAb0!VmskHbo0s-mof80rIqAYzyb-3dIaYRUY=
HFw13cs6cjcH_SVOgi2R2H8gHOuiUx7liYD7JQugDvArZe57uQ4$
Mute This Topic: https://urldefense.com/v3/__https://groups.io/mt/100419616=
/7559972__;!!PvDODwlR4mBZyAb0!VmskHbo0s-mof80rIqAYzyb-3dIaYRUYHFw13cs6cjcH_=
SVOgi2R2H8gHOuiUx7liYD7JQugDvArUe9LLDc$
Mute #question:
https://urldefense.com/v3/__https://ammrl.groups.io/g/main/m=
utehashtag/question__;!!PvDODwlR4mBZyAb0!VmskHbo0s-mof80rIqAYzyb-3dIaYRUYHF=
w13cs6cjcH_SVOgi2R2H8gHOuiUx7liYD7JQugDvArXMKUG8w$
Mute #varian:
https://urldefense.com/v3/__https://ammrl.groups.io/g/main/mut=
ehashtag/varian__;!!PvDODwlR4mBZyAb0!VmskHbo0s-mof80rIqAYzyb-3dIaYRUYHFw13c=
s6cjcH_SVOgi2R2H8gHOuiUx7liYD7JQugDvAr9B3ZGUw$
Mute #varianagilent:
https://urldefense.com/v3/__https://ammrl.groups.io/g/m=
ain/mutehashtag/varianagilent__;!!PvDODwlR4mBZyAb0!VmskHbo0s-mof80rIqAYzyb-=
3dIaYRUYHFw13cs6cjcH_SVOgi2R2H8gHOuiUx7liYD7JQugDvAr0CiFnn0$
Mute #bruker:
https://urldefense.com/v3/__https://ammrl.groups.io/g/main/mut=
ehashtag/bruker__;!!PvDODwlR4mBZyAb0!VmskHbo0s-mof80rIqAYzyb-3dIaYRUYHFw13c=
s6cjcH_SVOgi2R2H8gHOuiUx7liYD7JQugDvArnqUmpQc$
Group Owner: main+owner_at_ammrl.groups.io
-=-=-=-=-=-=-=-=-=-=-=-
Received on Fri Jul 28 2023 - 15:27:45 MST