Find Jobs
Hire Freelancers

Excel form for Travel Expense and Allowance calculation

$15-25 USD / hour

Suoritettu
Julkaistu noin 5 vuotta sitten

$15-25 USD / hour

Work flow 1. Employee details - Drop Down which automatically populates Number, Department, Manager, Designation 2. Claim details - Type DropDown: Business Trip / Non Travel - IF TRAVEL ○ Fill Start DateTime / End DateTime ○ Button active „Generate Travel Table" Travel Table: Dropdown Country / Arrival On-At (TimeStamp) / Departure On-At (TimeStamp) / AccType (Company accomodation-Own accomodation) / Food Included (Checkbox: None, Breakfast, Lunch, Dinner) / Day Allowance (Calc 1) / Night Allowance (Calc 2) Calc 1: If Country <> LEAVE then (Day Allowance as per Country in Allowance-Excellist - Deduction % as per Food Included) Every included food that spoecific day will result in a percentage deduction of the relevant day allowance. Calc 2: If AccType = "Own accomodation" then Nightallowanmce as per Country in Allowance-Excellist) 3. Expense details DropDown Country / DropDown Type (Excellist Expensetypes) / Claim Amount in Country currency / ExchangeRate (automatic by Oanda as per Startdate of travel) / Bank Amount Travel Table and Expense Detail table shall have each a summary footer. Functions: Export to PDF Button Save Travel --> Name: "ExpClaim" Employee Name- StartDate - EndDate
Projektin tunnus (ID): 18618863

Tietoa projektista

43 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
Hello GABCDubai Team , I can design this Expenses calculator tool. I will design a form as you specified to select Number, Department, Manager, Trip type etc. Will design a algorithm to calculates expenses and write a Macro script for that. And also provide the Export functionality. I have 5 years experience in Excel VBA programming and completed 400+ projects. With Regards, Sai
$15 USD 8 päivässä
4,9 (533 arvostelua)
7,8
7,8
43 freelancerit tarjoavat keskimäärin $20 USD/tunti tätä projektia
Käyttäjän avatar
Dear Employer, I understand what you require and have a good idea about the Claim and Expense work flow you are looking foor. Please message me and give me an opportunity to discuss the job with you once. I have done many such jobs and will do a perfect job for you. Do check my reviews for your kind consideration!! :) Thanks and Regards, Ash
$22 USD 40 päivässä
5,0 (300 arvostelua)
8,4
8,4
Käyttäjän avatar
Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Visual Basic. Please ping me for more discussion.
$20 USD 40 päivässä
4,9 (582 arvostelua)
8,5
8,5
Käyttäjän avatar
Dear client I have gone through the entire sprecifications detailed in the project brief. I understand it completely. I ensure I will create an user form in excel for you with all the specifications mentioned. Please contact me. Lets have a brief chat and then I will start. Roy
$20 USD 40 päivässä
4,9 (514 arvostelua)
7,5
7,5
Käyttäjän avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Nice, I think, I could help you in around 10 man hours of work. Willing to take up your project. Thank you, Regards.
$15 USD 20 päivässä
5,0 (187 arvostelua)
7,0
7,0
Käyttäjän avatar
Hello? How are you? I have good skill in this. So i ca n help you if you want. Hope to work with you. Tank you.
$27 USD 10 päivässä
4,9 (104 arvostelua)
6,8
6,8
Käyttäjän avatar
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$50 USD 40 päivässä
4,7 (95 arvostelua)
6,9
6,9
Käyttäjän avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$22 USD 30 päivässä
4,7 (104 arvostelua)
6,3
6,3
Käyttäjän avatar
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form with Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I will create macro that can populate drop downs, radio buttons and calculate results as per your requirements. Macro will also export excel reports to pdf format and save it to the desired destination. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$17 USD 40 päivässä
4,8 (147 arvostelua)
6,2
6,2
Käyttäjän avatar
I have gone through the entire workflow requirements and can create the necessary Excel form for Travel Expenses and allowance calculations. I have a very good hold on MS Excel. Here are few of my past projects: - POS and inventory management system - Delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile
$18 USD 40 päivässä
4,9 (95 arvostelua)
6,1
6,1
Käyttäjän avatar
Hi, I loved your project. I will be happy to work on "Excel form for Travel Expense and Allowance calculation". I have completely read out your project. If you like, I can do your project at fixed price- $130 too. I will take two days to do it. I am an expert data entry operator as well as excel programmer. I know VBA in advanced level. I will work for 20 hours a week. Please consider me so that i can work with you. I will eagerly wait for you PM Thanks & Regards Mst. Ruma Aktar
$15 USD 20 päivässä
4,9 (79 arvostelua)
5,8
5,8
Käyttäjän avatar
Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards. Passionate about excel automation.
$15 USD 40 päivässä
4,9 (34 arvostelua)
5,3
5,3
Käyttäjän avatar
Hi Next Employer, I am interested in your project. I hold master degree in Business Administration (Finance). I am experience data entry operator accountant and auditors having more than 9 years’ experience of data entry Microsoft Word, Excel Power Point and web scraping. I hope will be hear positive soon from you side
$15 USD 2 päivässä
4,7 (29 arvostelua)
4,7
4,7
Käyttäjän avatar
Hello Esteemed Client I am professional writer , data entry and editor , I understand your demand I know the value of time and always deliver the work on time I am a hard worker, type quickly, and can ensure your data is entered accurately I have done many professional projects before in a professional way, please check my profile reviews and portfolio! Hope to work together to build a relation based on quality.
$22 USD 40 päivässä
4,9 (22 arvostelua)
4,6
4,6
Käyttäjän avatar
Hey! Please contact me first before placing any order. I am a qualified chartered accountant and working in an Audit/Consultancy firm as an auditor from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more than 40 companies on behalf of my firm. I was also working for Pepsi-Cola International at snacks plant. It is an honour for me to assist you in this task. Hoping for a positive response from you. *Fee will be negotiable according to your expected budget. I will share my firm profile when you contact me. Thanks Regards Muhammad Zaman
$15 USD 40 päivässä
5,0 (16 arvostelua)
4,5
4,5
Käyttäjän avatar
Dear employer, Hi I have done my M.Sc. thesis using Python and MS Excel. It was about developing a numerical model for simulating fluids flow through porous media. I developed the main code in Python and developed my analyzer tools in Excel VBA. I learned lots of tricks in programming with these two great languages. I also had 2 big contracts. One of them was a contract with an educational institute and was about developing an Excel program for managing their workshops participants. I developed this program with Exel VBA. The other contract was about developing a numerical model for the search and rescue operation in the sea which I developed with C++. I have about 5 years of work experience in computer programming using different languages. It would be a great chance for me if we could collaborate with each other as I am an engineer who loves computer programming. My rating is a little low because one of my employers was a dealer and he did not want me to improve my business on this website. But honestly, I have some rules for my working life and their most important are: Be ON TIME, RESPONSIBLE, and RESPECTFUL. You can read the reviews of other employers on my profile. I am always here to answer your questions even after the project completion. It would be highly appreciated if you could send me a message so we can discuss more. Regards, Amir
$15 USD 40 päivässä
4,7 (15 arvostelua)
4,5
4,5
Käyttäjän avatar
Hello I would love to help with your very interesting travel claim spreadsheet. It sounds like it would be a great exercise and one that I believe my skills align with. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba based issues which lead me to design and implement many complex spreadsheets and macros. This helped to gain efficiencies in our daily tasks and increase our profitability and I’m sure this experience will be of use to you with your project. I look forward to working with you soon. Kind regards Steve
$22 USD 20 päivässä
5,0 (9 arvostelua)
4,2
4,2
Käyttäjän avatar
Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5 Yrs. of Experience in EXCEL & VBA. • Knowledge of FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • Macro coding for USERFORM and other COMPLEX TASKS possible. • HIGH ACCURACY. • Work in TIGHT DEADLINE. • Can start working IMMEDIATELY. Please ping me for more discussion.
$15 USD 40 päivässä
4,9 (29 arvostelua)
4,0
4,0
Käyttäjän avatar
I possess advanced level Microsoft Excel skills. I have read all of your requirements and I have prepared similar sheets as well. I can perform your job with the best professional look
$22 USD 40 päivässä
3,7 (6 arvostelua)
3,5
3,5
Käyttäjän avatar
Hi, I am a professional VBA developer with around 10 years of IT experience. I have gone through the requirement and can accomplish the task as stated in the requirement. Once awarded, I assure you of high-quality, error-free delivery with quick turnaround. Please ping me for any queries. Thanks. Regards Mohd F.
$15 USD 40 päivässä
5,0 (4 arvostelua)
1,2
1,2
Käyttäjän avatar
Hello My name i Andi i writing in my behalf of my company. Titan code have done data entry data admin exel word finance 5 and more project in data entry we have a great team they will be fast accurate Relevant Skills and Experience Have 5 people’s team experience in excel ,word, finance 5, data admin and my time will provide with best project in fast time and accurate
$22 USD 60 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan UNITED ARAB EMIRATES lippu
Dubai, United Arab Emirates
5,0
15
Maksutapa vahvistettu
Liittynyt toukok. 8, 2016

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.