google spreadsheet - How to show multiple Date/Times per location? -


  1. using google spreadsheets, need enter data structured example below.
    • there multiple "quadrants"
    • each "quadrant" can contain one or many "days",
    • each "day" can contain one or many "times".
  2. this data imported in backend db (e.g. access db, sql, mysql).
  3. question: for each day, how represent multiple times? create new row?

quadrant 1 team schedules

  • sunday
    • 10:00 - red team
    • 3:00 pm - green team
  • monday
    • 6:00 - red team
    • 10:00 - yellow team
    • 3:30 pm - green team
  • tuesday
  • wednesday
    • 6:00 pm - yellow team
  • thursday
    • 1:00 pm - red team
  • friday
  • saturday
    • 10:00 - blue team
    • 3:00 pm - red team

i’m not quite sure answer expecting wanting post image (and length!) why not comment.

poor data layout requires changes legibility or changes facilitate further processing is, imo, big issue – more than, seems, appreciated novices (see perhaps kruger-dunning). again merely opinion, think half of questions on have data layout issue, in whole or part.

some suggestions:

  1. with databases, have index (id) identify unique records (rows). added automatically.
  2. try ensure each record complete every field (nulls may cause issues). id6 seems not required.
  3. use dates rather days of week (it easier day date date day!)
  4. (personal preference – not viable) use ‘scientific’ notation dates (yyyymmdd) avoid ambiguity between ‘us’ , ‘uk’ systems – , difficulties in switching between them.
  5. use 24-hour clock (saves space am , pm, reduces ambiguity , easier process).
  6. not important nowadays should consider codes (with lookup table if desired) such yl yellow rather indeterminate length strings – saves on data storage less cost, more speed win/win.

so30554211 example


Comments

Post a Comment

Popular posts from this blog

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

How to access a php class file from PHPFox framework into javascript code written in simple HTML file? -

i've website developed using phpfox v3.0.7 . now i'm trying implement 'sse(server sent events)' 1 of php files. reference i'm giving below necessary code part of file. file titled process.class.php , present @ location /var/www/module/notification/include/service/process.class.php present on server having ip http://34.124.40.142/ . <?php /** * [phpfox_header] */ header('content-type: text/event-stream'); header('cache-control: no-cache'); defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($...
Read more

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more