UK Social research job to suit Excel programmer (not necessarily VBA)

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Duncan Smith

    UK Social research job to suit Excel programmer (not necessarily VBA)



    Duncan Smith


  • Peter Hansen

    #2
    Re: UK Social research job to suit Excel programmer (not necessarilyVBA)

    Duncan Smith wrote:
    [color=blue]
    > http://www.man.ac.uk/news/vacancies/research.html#581[/color]

    Sorry, but what's the connection to Python?

    Comment

    • Duncan Smith

      #3
      Re: UK Social research job to suit Excel programmer (not necessarily VBA)


      "Peter Hansen" <peter@engcorp. com> wrote in message
      news:40B8991F.4 010207@engcorp. com...[color=blue]
      > Duncan Smith wrote:
      >[color=green]
      > > http://www.man.ac.uk/news/vacancies/research.html#581[/color]
      >
      > Sorry, but what's the connection to Python?[/color]

      There is (I am told) a significant amount of work automating Excel.
      Unfortunately this isn't clear from the job description (I didn't write it).
      I know from experience that this can be achieved admirably using Python (and
      Mark Hammond's extensions). Personally I would like to see the work done in
      Python, but that depends on who applies and whether those who make the
      decisions can be convinced that it's an appropriate language (well, moreso
      than VBA). It's certainly not a full-time programming job (due to the
      social science / modelling component), but it does need someone who can
      write good maintainable code.

      Duncan


      Comment

      • William Park

        #4
        Re: UK Social research job to suit Excel programmer (not necessarily VBA)

        Duncan Smith <buzzard@urubu. freeserve.co.uk > wrote:[color=blue]
        >
        > "Peter Hansen" <peter@engcorp. com> wrote in message
        > news:40B8991F.4 010207@engcorp. com...[color=green]
        > > Duncan Smith wrote:
        > >[color=darkred]
        > > > http://www.man.ac.uk/news/vacancies/research.html#581[/color]
        > >
        > > Sorry, but what's the connection to Python?[/color]
        >
        > There is (I am told) a significant amount of work automating Excel.
        > Unfortunately this isn't clear from the job description (I didn't
        > write it). I know from experience that this can be achieved admirably
        > using Python (and Mark Hammond's extensions). Personally I would like
        > to see the work done in Python, but that depends on who applies and
        > whether those who make the decisions can be convinced that it's an
        > appropriate language (well, moreso than VBA). It's certainly not a
        > full-time programming job (due to the social science / modelling
        > component), but it does need someone who can write good maintainable
        > code.[/color]

        Bash, Awk, Python are all good tools, and Math/Engineering would be good
        background to have. But, this is job for local undergraduate students,
        not outside programmer or consultants. :-)

        --
        William Park, Open Geometry Consulting, <opengeometry@y ahoo.ca>
        Slackware -- because I can type.

        Comment

        • has

          #5
          Re: UK Social research job to suit Excel programmer (not necessarily VBA)

          "Duncan Smith" <buzzard@urubu. freeserve.co.uk > wrote in message news:<c9a9k4$ff r$1@news5.svr.p ol.co.uk>...[color=blue]
          > "Peter Hansen" <peter@engcorp. com> wrote in message
          > news:40B8991F.4 010207@engcorp. com...[color=green]
          > > Duncan Smith wrote:
          > >[color=darkred]
          > > > http://www.man.ac.uk/news/vacancies/research.html#581[/color]
          > >
          > > Sorry, but what's the connection to Python?[/color]
          >
          > There is (I am told) a significant amount of work automating Excel.
          > Unfortunately this isn't clear from the job description (I didn't write it).
          > I know from experience that this can be achieved admirably using Python (and
          > Mark Hammond's extensions).[/color]

          If it's any help, the Mac version of Excel can also be scripted via
          Apple events. The most common language for this is AppleScript [no
          comment:p], but Apple Event Manager bridges are also available for
          Perl (see Mac::Glue at <http://search.cpan.org/~cnandor/>) and
          MacPython (see appscript at
          <http://freespace.virgi n.net/hamish.sanderso n/appscript.html> ; not
          quite finished but getting there).

          Comment

          Working...