I need someone to find research grants and start up proposals for electric car manufacturers, battery, creation of economical alternative energy technology’s. I am seeking funding for the creation of a prototype electric vehicle and the stage two development of a manufacturing plant. I need as many grants option as possible along with the requirements to get the funding. I need at least 10-15 funding options for a company in California, united states and also the top ten competitors in electric car production
Need an Excel Macro(s) written that will:
First, when Excel is opened will let us load a CSV file that allows the simple running of the needed macros.
1. Take the existing UNIX Date/Time Field: 2009-08-03 15:40:42 and split it into two different fields (Start Date and Start Time)and applies that change to all data in that column. Eastern Standard time if possible.
2. A macro that will ask the start time (this is for the listing time of an auction in the future) and the number of minutes auctions should be spaced apart and the row numbers affected. Once answered, the macro will make the first auction “Start Time” for the rows selected the time identified and will then make the next “Start Time” x min after the first. Objective is that if there are 5 or 500 items to list for auction that we have control on time spacing them apart. We need control over affected rows as we may wish to make the first 20 auctions 5 min apart and the second 20 10 min apart.
3. Final Macro will re-create the Unix Time Date Field but containing the new “Start Date and Start Time”, in the same location as the original field and delete the individual fields (Start Date and Start Time)as no longer needed. At the same time it will modify another UNIX field (also containing the same formatted data but will be set to 48 hours after the data in the “start date” and “start time”. No need to convert this data out of UNIX unless necessary.
4. A simple macro to create a CSV file
Happy to clarify any questions.
David
PS.
Categories: Programming Tags: and start, and start time, and the, apart, Auction, conv, Data, date, date and, date conv, date conv programming, Excel, excel macro, excel macro unix, field, fields start date, First, Macro, macro unix, macro unix date, make the, min, start, start date, start time, the first, the same, time, UNIX, unix date, unix date conv
