New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Additional Column in Morphological Spreadshet #251

Closed
jb10016 opened this Issue Apr 22, 2018 · 4 comments

Comments

2 participants
@jb10016
Copy link
Collaborator

jb10016 commented Apr 22, 2018

@philipbaileynar @MattReimer One really useful addition (that hopefully wouldn't be too difficult to address) - would be the inclusion of a further column (or two if you incorporate an error margin) into the morphological spreadsheet budget calc in order to represent gravel extraction/augmentation.

My suggestion is simply to add this (these) and set them to zero so they change nothing in our output, but provide a space for users to incorporate these additional terms should they have data.

This is a pretty common operation in NZ, where the councils often have information on permitted extraction volumes and use that within a more elaborate budget calc. If we simply set these numbers to zero in our spreadsheet, it would leave them to add these and sort out the effects on the transport rates, but would be useful in giving them space and prompt to do so.

@jb10016 jb10016 added the enhancement label Apr 22, 2018

@philipbaileynar

This comment has been minimized.

Copy link
Contributor

philipbaileynar commented Apr 23, 2018

Adding the additional column is straightforward. Saving and restoring the values to the GCD project is a little more work, but certainly doable.

This is an enhancement and out of scope for now.

@jb10016 can you provide a morphological spreadsheet showing the additional column and any ensuing calculations please.

@jb10016

This comment has been minimized.

Copy link
Collaborator

jb10016 commented Apr 24, 2018

I think my vision for this is not to influence the GUI at all ... only the saved version of the spreadsheet, which would contain two additional columns ... one for extraction/augmentation and the other for the associated error. These should both be set to zero. This provides space for a user to incorporate any additional information, but means no changes to the interface or new calcs. If we wanted to be more elaborate, the save spreadsheet button could contain a radio button/tick box asking whether to include these columns or not, but I really don't think we should go further than that.

@philipbaileynar

This comment has been minimized.

Copy link
Contributor

philipbaileynar commented Jul 31, 2018

@jb10016 Please review the following implementation. It's easy to change the column heading text, but be aware that space is tight! Note that cells O13 and P13 contain Sum() formulae that automatically tally the values in the respective columns. No other cells in the spreadsheet refer to the cells in columns O and P.

2018-07-31_112308

@philipbaileynar

This comment has been minimized.

Copy link
Contributor

philipbaileynar commented Aug 22, 2018

Issue implement. Closing.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment