Will Shafferman 0 Posted September 1, 2016 Share Posted September 1, 2016 Hello - Here is my scenario... I have project notes in evernote with time estimates attached to individual tasks (see attached). I have manually added these to get the total time for each projects. I have a weekly time budget in excel (see attached) Here is what I want to accomplish... I want to be able to update total project times in EN, and then have the "Updated Time" column in excel automatically update to reflect the amount of time remaining in the project. So... What must I do or change to accomplish this? Thanks! Will Sample Weekly Budget.xlsx Link to comment
Level 5* DTLow 5,736 Posted September 1, 2016 Level 5* Share Posted September 1, 2016 6 hours ago, Will Shafferman said: Here is my scenario... I have project notes in evernote with time estimates attached to individual tasks (see attached). I have manually added these to get the total time for each projects. I have a weekly time budget in excel (see attached) Here is what I want to accomplish... I want to be able to update total project times in EN, and then have the "Updated Time" column in excel automatically update to reflect the amount of time remaining in the project. So... What must I do or change to accomplish this? afaik There's noting built in to EN to link data to a spreadsheet Since we're using Macs, we can use AppleScript to extract the numbers from EN the next step is to use Applescript to update the spreadsheet I don't have experience with this, but I'm sure its do-able Are you sure EN is the best place to store these numbers? My process would be to keep all the number stuff in the spreadsheet Link to comment
Recommended Posts
Archived
This topic is now archived and is closed to further replies.