Closed

Google spreadsheet calculating 12-month rolling totals for travel dates

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.

Skills: Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic

See more: 12 month spreadsheet, google spreadsheet finance tse, spreadsheet calculating aluvial gold, mlsca google spreadsheet, manuale per google spreadsheet, commands google spreadsheet finance, google optimization adwords promotion month, google spreadsheet access table, use google spreadsheet access table, spreadsheet calculating tiered rates, php form google spreadsheet, google finance google spreadsheet, google spreadsheet data entry, google spreadsheet functions manual, php mysql data google spreadsheet

About the Employer:
( 0 reviews ) United States

Project ID: #17194290

31 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
(261 Reviews)
7.6
$5 USD / hour
(299 Reviews)
7.5
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
(203 Reviews)
6.8
$5 USD / hour
(42 Reviews)
5.9
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
(38 Reviews)
5.3
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
(35 Reviews)
5.0
$5 USD / hour
(36 Reviews)
4.6
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
(30 Reviews)
4.7
$5 USD / hour
(25 Reviews)
4.8
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.4
jayryan0612

Hello there! Stop looking somewhere else, you're looking at the right profile! It's me! I was a Quality Assurance Engineer for 3 years in a Japanese company with a strict way of learning environment before I came More

$6 USD / hour
(1 Review)
0.6
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
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
$6 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
$5 USD / hour
(0 Reviews)
0.0
$5 USD / hour
(0 Reviews)
0.0
thelordwin

Let's go

$3 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