Feb. 21st, 2013

radlilim: (NOH8)
I got to do something at work today that I normally don't get to do, be creative.

For that last few months of 2012 I had been becoming more and more creative on setting up the collection sites at work. This lead to me being wrong on how the system worked some times and breaking it on others. So my 2013 resolution for work was to stop being creative on ways to use our system. To stick to vanilla set ups for projects. (Which can be a bit boring and non-challenging.)

Today I focused on a problem we've been having for a while. There is a certain style for author blocks on papers that a lot of our clients use. It has all of the authors listed out, with footnote numbers following them, which match up to a list of affiliations below. This is normally a manual process to set up by the layout person.

Today I figured out how to do it (mostly) programmaticly. It involves like 9 tabs in excel and a lot of formulas. Next I will do some testing on live data to figure out how long it takes me to clean up the data this way, and if that time is less than the manual process, then I've saved us money. Nice feeling to accomplish something. However my head is buzzing with being full of data now. I kinda want a nap or a shot.

July 2015

S M T W T F S
   1234
5 6 7891011
12 131415161718
19202122232425
262728293031 

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Apr. 3rd, 2026 11:45 am
Powered by Dreamwidth Studios