Since we're all just making up stuff, I mostly agree with Ben that if
a spreadsheet is the right tool, then use that tool. There are a few
spreadsheets that support version control internally, like Google Docs
and Microsoft Office Version Tracking.

In addition, there are the elite tools of graybeard grognards like
Emacs org-mode spreadsheets and your truly best option 'sc' [1],
because these have plain-text version-control system friendly formats
from the get-go. `sc` is the only way I spreadsheet. n00bs.

Jay

1. man page from FreeBSD:
https://www.freebsd.org/cgi/man.cgi?query=sc&apropos=0&sektion=0&manpath=FreeBSD+6.0-RELEASE+and+Ports&format=html

On Fri, Oct 21, 2016 at 12:16 PM, Ben Greenman
<benjaminlgreen...@gmail.com> wrote:
> I vote that you stick with Excel & change the version control protocol.
>
> Maybe:
> http://stackoverflow.com/a/17106035/5237018
>
> On Fri, Oct 21, 2016 at 9:22 AM, Matthias Felleisen <matth...@ccs.neu.edu>
> wrote:
>>
>>
>> See Claire’s paper on cKanren. Scheduling is one of her examples (though
>> small scale).
>>
>>
>>
>> > On Oct 21, 2016, at 7:18 AM, Robby Findler <ro...@eecs.northwestern.edu>
>> > wrote:
>> >
>> > Whaaaa? You're not going to design your own language and implement a
>> > syntax colorer in DrRacket for it so they can tell immediately when
>> > something goes wrong?  ;)
>> >
>> > Robby
>> >
>> >
>> > On Fri, Oct 21, 2016 at 12:21 AM, 'John Clements' via Racket Users
>> > <racket-users@googlegroups.com> wrote:
>> >> Yet another totally off-topic question for you extremely smart people.
>> >> Well, it’s a language design question, so it’s not *too* off-topic.
>> >>
>> >> I’m temporarily serving as my department’s scheduler (don’t ask).
>> >> Currently, the planning for the future schedule is done using an Excel
>> >> spreadsheet. I try not to hate Microsoft products for knee-jerk reasons, 
>> >> but
>> >> the simple fact is that this format is completely not git-versionable.
>> >>
>> >> This file has to be shared with non-programmers, though it doesn’t
>> >> necessarily have to be *edited* by non-programmers, just read.
>> >>
>> >> I’m currently thinking that the best compromise may be YAML. E.G.
>> >>
>> >> # 2017-2018 schedule:
>> >> alincoln : {fall: [304, 428], winter: [409, special], spring: []} #
>> >> maybe theater?
>> >> gwashington: {fall: [224, 287, 110], winter: sabbatical, spring: [789]}
>> >> # might be able to hire stuffy?
>> >> stuffy: {fall: [234,234,234], winter: [235, 235, 235]}
>> >> …
>> >>
>> >> It looks like a fairly dense format, it’s a text file so it’s
>> >> versionable in a sane way, and you could be fairly flexible in your 
>> >> parsing.
>> >>
>> >> To be fair, sexprs also look pretty good:
>> >>
>> >> ;; 2017-2018 schedule
>> >> ((alincoln ((fall (304 428)) (winter (409 special)) (spring ()))) ;;
>> >> maybe theater?
>> >> (gwashington ((fall (224 287 110)) (winter sabbatical) (spring (789))))
>> >> ;; might be able to hire stuffy?
>> >> (stuffy ((fall (234 234 234)) (winter 235 235 235))))
>> >>
>> >> Also note that there’s no need for this file to contain any information
>> >> about times and rooms, just a mapping from instructor/quarter
>> >> to classes taught, with room for comments.
>> >>
>> >> I thought hard about scribble and JSON (and xml, yecch), but I think
>> >> that YAML and sexps are the two viable candidates, and I’m guessing that 
>> >> if
>> >> non-programmers have to edit it, they’ll be less likely to botch the YAML
>> >> one.
>> >>
>> >> Any opinions?
>> >>
>> >> John
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> You received this message because you are subscribed to the Google
>> >> Groups "Racket Users" group.
>> >> To unsubscribe from this group and stop receiving emails from it, send
>> >> an email to racket-users+unsubscr...@googlegroups.com.
>> >> For more options, visit https://groups.google.com/d/optout.
>> >
>> > --
>> > You received this message because you are subscribed to the Google
>> > Groups "Racket Users" group.
>> > To unsubscribe from this group and stop receiving emails from it, send
>> > an email to racket-users+unsubscr...@googlegroups.com.
>> > For more options, visit https://groups.google.com/d/optout.
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Racket Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to racket-users+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Racket Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to racket-users+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



-- 
Jay McCarthy
Associate Professor
PLT @ CS @ UMass Lowell
http://jeapostrophe.github.io

           "Wherefore, be not weary in well-doing,
      for ye are laying the foundation of a great work.
And out of small things proceedeth that which is great."
                          - D&C 64:33

-- 
You received this message because you are subscribed to the Google Groups 
"Racket Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to racket-users+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to