Google spreadsheet calculating 12-month rolling totals for travel dates

Closed Posted 5 years ago Paid on delivery
Closed

Create a Google Spreadsheet where I can enter/edit my international travel dates, and have it automatically calculate the # of days spent in each country.

One key feature is that the spreadsheet needs to look at the rolling 12-month total for days spent in each country, in addition to the annual tax year days spent in each country, and show an alert if the # of days exceed a set target.

This will be used for forward-looking date planning in addition to tracking past travels, so it needs to be easy to try out "what if" scenarios where I experiment with different travel plans/dates to avoid exceeding the set target.

I have an existing template to show what I'm thinking of in how the data could be presented.

Data Entry Data Processing Excel Microsoft Office Visual Basic

Project ID: #17194290

About the project

29 proposals Remote project Active 5 years ago

29 freelancers are bidding on average $6/hour for this job

schoudhary1553

Hello, I can help with you in your project google excel spreadhsheet help. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic. We have worked on several simi More

$5 USD / hour
(292 Reviews)
7.7
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$15 USD / hour
(211 Reviews)
6.8
archanaoswal

I have excellent command on Google Sheets. I have completed complex projects before. For instance - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo using JS More

$12 USD / hour
(70 Reviews)
5.6
c4cuteconain

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Aqib

$5 USD / hour
(36 Reviews)
5.1
pm9887

Hi, As per given details Its data entry task. I have great experience in all kind of backend support I am good in lead generation, internet research, market research, data entry, data processing and all kind of backe More

$5 USD / hour
(39 Reviews)
5.0
rhodelta

30+ years Experienced Excel/Word user based in Brisbane, Australia, with office and technical background. Good with maths, spreadsheet functions, and macros. Native English speaker fluent in US and UK English. Recen More

$20 USD / hour
(5 Reviews)
2.7
arcworth

Hi. I have gone through your requirements and would like to offer my services. I am good with spreadsheets and have used excel/google sheets on several occasions for financial planning and data manipulation. I can More

$7 USD / hour
(2 Reviews)
2.7
efrainurbinacr

The efficiency and professionalism with which I perform in each project in which I worked, always giving an extra to achieve a continuous improvement with each person and / or association with which I have worked. I ha More

$5 USD / hour
(0 Reviews)
0.0
nachomateos87

I have experience making data tables and using basic visual with application in Excel. We can carry out the work in stages as well as the payments. How it works best for you Relevant Skills and Experience Data entre, More

$4 USD / hour
(0 Reviews)
0.0
abhisheksingh005

Hi, I have extensive experience in Google Tools. I am a G-suit administrator & use google sheets, forms, drives, etc. on regular basis. With good running knowledge, street smart attitude, your work will be done wit More

$5 USD / hour
(0 Reviews)
0.0
kiruthikaM

I may be new to this job. But my prior experience will help me to do the work with 100% accuracy.

$5 USD / hour
(0 Reviews)
0.0
Duniyakhan786

I have hands on experience in desktop application development and Data Entry with one year practical knowledge of specially business logic layer and front end design and requirement gathering as well. "My Services Inc More

$5 USD / hour
(0 Reviews)
0.0
OmarChakroun

I am expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy. I am the Right person for you. available 24-7.

$2 USD / hour
(0 Reviews)
0.0
rahulbisht28

Hello Sir, I have 3 years experience in excel and google spreadsheets. I read the description and I am confident that I can complete this job successfully. I can make any number of modifications also. let s More

$3 USD / hour
(0 Reviews)
0.0
mariatsvet

Hello, Thank you for posting your project here! I would like to offer you my experience in Excel. Projects where I have participated range from analysing data with formulas, templates in Excel, different calculat More

$5 USD / hour
(0 Reviews)
0.0
thelordwin

Let's go

$3 USD / hour
(0 Reviews)
0.0
vvh007

As per my understanding it is one file and alert will be shown in the same file. The alert is by highlighting the text or background of the spreadsheet cell with required color. I have two designs in mind to make it More

$3 USD / hour
(0 Reviews)
0.0