japacible / DashTricks-Pakistan

Android application focused on vaccine cold chain management in Pakistan.
13 stars 6 forks source link

5.20 Code Freeze #49

Closed japacible closed 10 years ago

japacible commented 10 years ago

Code freeze for demo on Wednesday. Deadline: EOD 5.20

software-dov commented 10 years ago

Did we ever determine which level in the AdminHierarchy sheet corresponds to the smallest region we’re showing on the map?

software-dov commented 10 years ago

What are the fridge age groups?

On May 24, 2014, at 2:59 PM, Jennifer Apacible japacible@gmail.com wrote:

Heyo! (ccing Daniel and Austin)

So to pass data to the WebView, this is the information I came up with that we need at the moment... am I missing anything? I bolded stuff that won't be used by the webview, but I need for the native-android-sidebarthing

Exploration Map:

  • Facilities
    • District they're in
    • Amount (mL) deficient
    • % deficient
  • Total number of facilities
  • Total number of facilities per district
  • Total % deficient facilities
  • List of facilities per district
    • Amount (mL) deficient
    • % deficient

Simulation Map: Before and after versions of:

  • Facilities
    • District they're in (should not change :D)
    • Amount (mL) deficient (may change)
    • % deficient (may change)
  • Total number of facilities
  • Total number of facilities per district
  • Total % deficient facilities
  • List of facilities per district
    • Amount (mL) deficient
    • % deficient

Fridge Bar Graph:

  • Fridge
  • Fridge age
  • Fridge facility location
  • Lists of fridges in each age group

Facilities w/Need Bar Graph:

  • Total # facilities
  • Total "In Need" facilities count (could pull "OK" facilities count with total - in need)
  • List of "In Need" facilities

Punjab Bar Graph:

  • Districts of Punjab
  • Number of facilities in each district
  • % of facilities passing "OK" in each district
  • List of facilities for each district, with a flag on whether or not they're passing

Note: It is still uncertain what Fahad wants regarding the facilities w/need bar graph and the Punjab only bar graph. Daniel's trying to clear that up. In the meantime, I'd like to make sure the data can be accessed for both of these situations.

Let me know if this makes sense!

danluna commented 10 years ago

Dov, do you know up to around what age the refrigerators are at?

Take a look at Jennifer's prototype charthttps://drive.google.com/#folders/0BxBq3eRbZAvEYjdJbndkX1NHMDQ

The age groups are one year intervals: 0-1, 1-2, 1-3, etc...

Do you think these are good intervals according to the DB data?

On Sun, May 25, 2014 at 10:20 PM, InsaneFisherman notifications@github.comwrote:

What are the fridge age groups?

On May 24, 2014, at 2:59 PM, Jennifer Apacible japacible@gmail.com wrote:

Heyo! (ccing Daniel and Austin)

So to pass data to the WebView, this is the information I came up with that we need at the moment... am I missing anything? I bolded stuff that won't be used by the webview, but I need for the native-android-sidebarthing

Exploration Map:

  • Facilities
  • District they're in
  • Amount (mL) deficient
  • % deficient
  • Total number of facilities
  • Total number of facilities per district
  • Total % deficient facilities
  • List of facilities per district
  • Amount (mL) deficient
  • % deficient

Simulation Map: Before and after versions of:

  • Facilities
  • District they're in (should not change :D)
  • Amount (mL) deficient (may change)
  • % deficient (may change)
  • Total number of facilities
  • Total number of facilities per district
  • Total % deficient facilities
  • List of facilities per district
  • Amount (mL) deficient
  • % deficient

Fridge Bar Graph:

  • Fridge
  • Fridge age
  • Fridge facility location
  • Lists of fridges in each age group

Facilities w/Need Bar Graph:

  • Total # facilities
  • Total "In Need" facilities count (could pull "OK" facilities count with total - in need)
  • List of "In Need" facilities

Punjab Bar Graph:

  • Districts of Punjab
  • Number of facilities in each district
  • % of facilities passing "OK" in each district
  • List of facilities for each district, with a flag on whether or not they're passing

Note: It is still uncertain what Fahad wants regarding the facilities w/need bar graph and the Punjab only bar graph. Daniel's trying to clear that up. In the meantime, I'd like to make sure the data can be accessed for both of these situations.

Let me know if this makes sense!

— Reply to this email directly or view it on GitHubhttps://github.com/japacible/DashTricks-Pakistan/issues/49#issuecomment-44158087 .

software-dov commented 10 years ago

The oldest refrigerator is from 1974. The median is around 2000.

On May 25, 2014, at 10:36 PM, Daniel Luna notifications@github.com wrote:

Dov, do you know up to around what age the refrigerators are at?

Take a look at Jennifer's prototype charthttps://drive.google.com/#folders/0BxBq3eRbZAvEYjdJbndkX1NHMDQ

The age groups are one year intervals: 0-1, 1-2, 1-3, etc...

Do you think these are good intervals according to the DB data?

On Sun, May 25, 2014 at 10:20 PM, InsaneFisherman notifications@github.comwrote:

What are the fridge age groups?

On May 24, 2014, at 2:59 PM, Jennifer Apacible japacible@gmail.com wrote:

Heyo! (ccing Daniel and Austin)

So to pass data to the WebView, this is the information I came up with that we need at the moment... am I missing anything? I bolded stuff that won't be used by the webview, but I need for the native-android-sidebarthing

Exploration Map:

  • Facilities
  • District they're in
  • Amount (mL) deficient
  • % deficient
  • Total number of facilities
  • Total number of facilities per district
  • Total % deficient facilities
  • List of facilities per district
  • Amount (mL) deficient
  • % deficient

Simulation Map: Before and after versions of:

  • Facilities
  • District they're in (should not change :D)
  • Amount (mL) deficient (may change)
  • % deficient (may change)
  • Total number of facilities
  • Total number of facilities per district
  • Total % deficient facilities
  • List of facilities per district
  • Amount (mL) deficient
  • % deficient

Fridge Bar Graph:

  • Fridge
  • Fridge age
  • Fridge facility location
  • Lists of fridges in each age group

Facilities w/Need Bar Graph:

  • Total # facilities
  • Total "In Need" facilities count (could pull "OK" facilities count with total - in need)
  • List of "In Need" facilities

Punjab Bar Graph:

  • Districts of Punjab
  • Number of facilities in each district
  • % of facilities passing "OK" in each district
  • List of facilities for each district, with a flag on whether or not they're passing

Note: It is still uncertain what Fahad wants regarding the facilities w/need bar graph and the Punjab only bar graph. Daniel's trying to clear that up. In the meantime, I'd like to make sure the data can be accessed for both of these situations.

Let me know if this makes sense!

— Reply to this email directly or view it on GitHubhttps://github.com/japacible/DashTricks-Pakistan/issues/49#issuecomment-44158087 .

— Reply to this email directly or view it on GitHub.

danluna commented 10 years ago

So what do you think? 3 or 4, maybe 5 year intervals?

software-dov commented 10 years ago

Sounds good.

On May 25, 2014, at 10:51 PM, Daniel Luna notifications@github.com wrote:

So what do you think? 3 or 4, maybe 5 year intervals?

— Reply to this email directly or view it on GitHub.

danluna commented 10 years ago

Whoa I just saw the conversation here about my commit having stripped the Facility and Refrigerator class yesterday. Sorry about that. Everything is OK now in regards to those classes?

software-dov commented 10 years ago

I’ve re-clothed them with the fields that seem to be convenient. Not really sure what’s going on there, but they now have code and fields again.

On May 25, 2014, at 10:58 PM, Daniel Luna notifications@github.com wrote:

Whoa I just saw the conversation here about my commit having stripped the Facility and Refrigerator class yesterday. Sorry about that. Everything is OK now in regards to those classes?

— Reply to this email directly or view it on GitHub.

danluna commented 10 years ago

Ok thanks. Yeah I was getting so many build errors with those classes and I must have left things out of order. Thanks for the fix.

software-dov commented 10 years ago

The smallest regions on the map are districts, and I've nuked the regional boundaries we had between at the demo (the ones that had white borders). The image on our paper draft is the current regional distribution I'm working with, which SHOULD in theory be districts, though incredibly outdated.

Sent from my iPhone

On May 25, 2014, at 13:38, Dov Shlachter zygomorph125@gmail.com wrote:

Did we ever determine which level in the AdminHierarchy sheet corresponds to the smallest region we’re showing on the map?

software-dov commented 10 years ago

Data accessor can now provide refrigerators partitioned by age to native Android, other data accessor patterns fleshed out.

software-dov commented 10 years ago

No demonstrable progress made today due to OS.

software-dov commented 10 years ago

Connected with Brian viz. backend/internal model, shouldered responsibility for the paper.

software-dov commented 10 years ago

Has anyone emailed Trevor?

Also, when and how and wtf are we doing for the poster?

Begin forwarded message:

From: Ruth Anderson rea@cs.washington.edu Subject: [Cse481k_sp14] Capstone Change Talks (fwd) Date: May 27, 2014 at 8:37:17 PM PDT To: cse481k_sp14@uw.edu

Folks,

Can you please send these to Trevor by Friday at the latest.

Reminder that a draft of your slides is due this Friday at 5pm. A heads up that both the change talks and the poster session will be filmed.

Ruth

---------- Forwarded message ---------- Date: Tue, 27 May 2014 18:08:20 -0700 From: Trevor Perrier tperrier@cs.washington.edu To: Ruth Anderson rea@cs.washington.edu Cc: Richard Anderson anderson@cs.washington.edu Subject: Capstone Change Talks

Hi Ruth,

Can you ask the capstone groups to email me a brief (2-4 sentence) description of their project for the Change website and mailing list?

I would like these descriptions by Friday.

Thanks,

japacible commented 10 years ago

Oh, I think we forgot about emailing Trevor.

@Venture- is doing presentation slides (see #77). Brian, can you email Trevor as well? Feel free to send us a draft too!

japacible commented 10 years ago

Also, poster draft isn't due until next Friday the 6th. Let's deal with it after the weekend.

software-dov commented 10 years ago

Revisions to paper.

software-dov commented 10 years ago

Hi Fahad,

Yes, I am somewhat stuck in hooking up the spreadsheet read-in to the ui. When I try to load the file on the tablet, there is a pause as if something is going on, but the debugger doesn’t halt on any of the breakpoints I set, and none of my debugging printlns show up on the console. As a result, I think my method isn’t getting called.

Any advice or light you could shed on the matter would be greatly appreciated, Dov

On Jun 3, 2014, at 1:03 AM, Fahad Pervaiz fahadp@cs.washington.edu wrote:

Hi Dov,

I have not received any update from you recently. I hope you were able to resolve the database issue. Let me know if you are stuck at some point.

Good Luck with presentation!

Fahad

On Fri, May 30, 2014 at 1:49 AM, Dov Shlachter zygomorph125@gmail.com wrote: Revisions to paper.

japacible commented 10 years ago

@InsaneFisherman let's discuss the db issue in #99

software-dov commented 10 years ago

Use the attached Pakistan_Sample.xls instead of the one sent out. It has slight format modifications that make parsing easier.

software-dov commented 10 years ago

More modifications to Pakistan_Sample.xls, more extensive. Certain unimportant columns were deleted, and various null entries were backfilled with -1

On Jun 4, 2014, at 11:53 PM, Dov Shlachter zygomorph125@gmail.com wrote:

Use the attached Pakistan_Sample.xls instead of the one sent out. It has slight format modifications that make parsing easier.