by

Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
Greg Elin
@gregelin
(I'm on mute).
I can't hear Robert very well.
Marc Jones
@marctjones_gitlab
I think we are trying to create a entry point for developers, so i think the models. Since they are bite size.
better sound?
Greg Elin
@gregelin
Yes, better sound. Thx.
What's the expected timeline on developers working on the model and when that work delivers value to persons?
Greg Elin
@gregelin
I didn't hear the entire hypothesis...
But I agree with TESTING an assumption.
Owen Barton
@grugnog_gitlab
H0: We can transparently change data in all models at once.
(could also try to change "formulas" instead of "data")
Greg Elin
@gregelin
What is the biggest risk, and what can we build to test our solution to remove the risk?
LOL
That is a reasonable test. I support the spreadsheet interaction b/c it is important to have something interacting with the new code
I agree with Stahlman...
Marc Jones
@marctjones_gitlab
+1
Greg Elin
@gregelin
BRB, post schedule pls...
Denton Gentry
@DentonGentry
About to resume.
Marc Jones
@marctjones_gitlab
We are back
@gregelin ^
Denton Gentry
@DentonGentry
Owen Barton
@grugnog_gitlab
Added my notes to http://codeearth.net/wiki/index.php/Hackathon_Wed_Notes - feel free to add other notes to this page also!
Denton Gentry
@DentonGentry

One thought, though I think the solution is simple: when Researcher A goes to work on a model and needs to update code on the HTTP server to match, those changes should not go live for everyone.

Researcher A might be expected to spin up a dev instance of the HTTP server, update a URL in their Excel sheet to point to their dev instance, and go.

Alternately, there could be URL parameters to pass some kind of version indication, and Researcher A might use the same HTTP server as everyone else but set their Excel sheet to request "?v=dgentry.9.5.2018" in their URLs (for example).

Versioning might also get used to resolve some of the compatibility issues mentioned earlier today, like how many regions there are. Honestly though, I think we have other options there like named fields in JSON rather than fixed-size arrays where Excel code needs to know the definition of each column.

Owen Barton
@grugnog_gitlab
Owen Barton
@grugnog_gitlab
Denton Gentry
@DentonGentry
Nifty. I imagine the eventual interface will need to be a POST due to the size of the data structures which may be passed around, but still nifty to see it working.
Robert L. Read
@RobertLRead
@DentonGentry Yes, we were just hacking furiously to get something working. In fact before our energy was exhausted Owen got the solution above working, and I got (thanks to a free software project) the ability to make a request to his code from Excel. However, I have not yet integrated this with the DD model spreadsheet, nor have I even got it reading from cells; I am working on that now.
Robert L. Read
@RobertLRead
FYI: The VBA code that makes the request using the "MIT License", which is a open source license that does not require programmers to give their code back, unlike the GPL. Marc, the attorney, and Henry can explain all this tomorrow.
Robert L. Read
@RobertLRead
@marctjones_gitlab Can you please load this repo onto your windows machine: git@gitlab.com:RobertLRead/drawdown.git
Owen Barton
@grugnog_gitlab
@gregelin are you planning on joining us this morning - we are almost ready to start
Greg Elin
@gregelin
Yes!
Denton Gentry
@DentonGentry
We're getting zoom set up.
Greg Elin
@gregelin
Very quiet on mic right now...
Denton Gentry
@DentonGentry
Ryan is trying the mic now.
Greg Elin
@gregelin
Audio is good from Robert.
Greg Elin
@gregelin
@marctjones_gitlab There's an echo when you talk
Echo is bad...
Owen Barton
@grugnog_gitlab
@gregelin better?
Greg Elin
@gregelin
Much better. Thanks.
Greg Elin
@gregelin
+1 on the forking risk!
Nick Peters
@nickpeters_drawdown_gitlab
Thanks Greg - thoughts on this plan (essentially Owen's option b)? Any clarification needed?
Greg Elin
@gregelin
(BRB, I have a scrum call)
I'm back.
Nick Peters
@nickpeters_drawdown_gitlab
Thanks - we are taking a short break, back in ~5min
Denton Gentry
@DentonGentry

For me at least, the git@gitlab.com user identification didn't work. Cloning the repo without a user did work:

git clone https://gitlab.com/RobertLRead/drawdown.git

Denton Gentry
@DentonGentry

Possibility for integration tests of Excel: http://docs.xlwings.org/en/stable/quickstart.html

For example, a test could be:

import xlwings as xw
with xw.Book(r'/path/to/drawdown.xlsx') as workbook:
sheet1 = workbook.sheets['Sheet1']
cell_A1 = sheet1.range('A1').value
ASSERT_EQ(cell_A1, 37)

...and gitter removed all of the spaces.
xlwings is distributed under a BSD 3-clause license.
Greg: we're all currently sitting around the table, typing.
Greg Elin
@gregelin
(Ok, away from keyboard for a moment...)