Write an Iphone / Ipad Database Appliacation

I work for the railroad and I need to design an application that keeps track of our trips. There is various data for each trip This application data needs to be able to be track, sort, search, view, edit, delete perform calculations, run various reports on the data which will include pie charts, graphs etc. I would like the main view to be like a calendar which you can quickly view what your month looks like. I would like to also be able to filter the way we see that data. Specific date ranges. 1st -15th (we call this the first half) and 16th - 31st (this is the second half). The data needs to saved somewhere in the cloud either using a drop box account or perhaps Google drive. We will need to be able to add events to the calendar the events can be a Trip or Layoff or Vacation Day This is a sample of the data used for each trip Train ID (Text) This is the main part of the event so if your looking at a calendar or list the train ID is what we want shown. CREW: (Text basically putting in whom you worked with. This we will need to discuss how to handle as their can be various variables) Start Date/Time (Date & Time) Start Location (Editable list which users can select add to edit delete) End Date/Time (Date & Time) End Location (Editable list which users can select add to edit delete) ** This will also flag our AFHT if our end location is different from our home location which we will setup in the settings. Previous Time Off (Calculated) Previous Trips End Date & Time - New trips Start Date/Time AFHT (This field will be used to calculate if the previous time off was away from home terminal or at the home terminal) Total hours on duty (Calculated) HRS:MINS Train Category (Editable list which users can select add to or and edit and delete) Service Location (Editable list which users can select add to or and edit and delete) Miles (Number) Pay (Currency) Hourly Rate (Calculation Pay / Time on duty) So heres a summary for a trip based on the above info Train ID KLBDIX 23 Engineer: JP Doe Conductor: DR Thomas Previous Time Off: 24:30 (HRS:MINS) Start 8/31/14 0800 Start Location SP760 End 8/31/14 2000 End Location SP563 Total time on duty 12.00 Miles: 198 Pay: $300.00 Hourly Rate: $25.00 These events may be able to be combined into one event, but we need to track the hours for the different layoff types. You will have layoffs which are compensated (PAID) some that are not compensated (UNPAID) some which count towards our attendance and some which dont. This is sample data for a Layoff Layoff Type (Editable list users can add to edit delete usually will be a 2 letter code example is LS, LK,LT LP ) we will need to discuss this field in more detail Layoff Date/Time Markup Date/Time Time Off LS Layoff Date/Time 8/31/14 Markup Date/Time 09/31/14 Timeoff: 24:00 This is sample data for Vacation Layoff Type (Editable list users can add to edit delete usually will be a 2 letter code example is LV, PL ) we will need to discuss this field in more detail Layoff Date/Time Markup Date/Time Time Off Pay LV Layoff Date/Time 8/31/14 Markup Date/Time 09/31/14 Timeoff: 24:00 Pay $190.00 Its alot to swallow but I am trying to give as much detail as possible.