Find Jobs
Hire Freelancers

Create a travel reimbursement form

$25-50 USD / hour

Σε Εξέλιξη
Αναρτήθηκε πάνω από 7 χρόνια πριν

$25-50 USD / hour

I need a little help in finalizing the design of a standardized excel travel reimbursement form. I believe I need to have someone put some "if" equations into the spreadsheet. This is because for certain reimbursement items we have a maximum dollar value that we can submit and sometimes our receipts/charges are greater than the maximum allowed. If our receipts exceed the maximum amount, we need to charge the maximum allowed. I need some programming so that when the actual expense numbers are entered into cells, they are compared to the maximum allowed value and the lower of the two numbers is used in the calculation. The trick is that the location (the column) in which one of the two numbers (food and lodging) may appear in two different places (food column and lodging column). The maximum value that we can charge will always be in the allotted per diem column. Not all expense rows will have a maximum value - just the meals and lodging expense values will be compared to the maximum value.
Ταυτότητα εργασίας: 11702592

Σχετικά με την εργασία

7 προτάσεις
Ενεργός/ή 7 χρόνια πριν
Τοποθεσία: Alexandria, United States

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
I work as a data analyst/software developer in the defense industry. I want to pick up extra cash while further developing my skills. My full-time job is to develop automated tools/forms/templates/processes/etc for the Business Management organization within the company I work for. Since January 2016, one of my projects has been to develop a comprehensive Travel Tool which receives user inputs to calculate a full breakdown of trip costs. To calculate these costs, I've had to develop rates using cost history. Unfortunately, I cannot sample most of my work as it is considered proprietary information, but I would be happy to share some of my own personal projects. I am highly capable with Microsoft Excel and Microsoft Access. My day job consists of writing formulas and VBA code in Excel and Access in order to bring spreadsheets to life. I have the skills, the interest, and the ingenuity to develop a solution for your problem. I am brand new to this website, but I assure you that I have the necessary experience for this job.
$44 USD σε 12 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
7 freelancers are bidding on average $47 USD/ώρα for this job
Avatar Χρήστη
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$50 USD σε 10 ημέρες
4,9 (250 αξιολογήσεις)
7,0
7,0
Avatar Χρήστη
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. They speak for themselves. Best regards
$50 USD σε 3 ημέρες
5,0 (180 αξιολογήσεις)
6,7
6,7
Avatar Χρήστη
Hi there. I am Rammi. I read your description and I understand that you need some formulas written for certain columns/cells in an excel sheet. I have a lot of experience in working with formulas in excel sheet and also we can finalize your design. Please ping me so we can discuss further. Thank you. Rammi.
$70 USD σε 10 ημέρες
5,0 (13 αξιολογήσεις)
3,0
3,0
Avatar Χρήστη
I am located in Rockville, Maryland, close to the metro and thus within easy reach of Alexandria. I have experience working with US government projects, especially budgets and compliance requirements related to travel, food and lodging (e.g. per diem). Most importantly I am an expert with Excel and can pretty much make a template do what you want it to through the use of advanced formulas (nested IF statements, etc.), drop boxes, or -- if necessary -- VBA macros. I believe it would take me no more than 8 hours of work time to create the fully functional reimbursement form that you've described; I could have it to you by the end of the week, at the latest.
$36 USD σε 8 ημέρες
5,0 (2 αξιολογήσεις)
1,4
1,4

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Alexandria, United States
0,0
0
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Οκτ 4, 2016

Επαλήθευση Πελάτη

Άλλες δουλειές από αυτόν τον πελάτη

I would like to hire an Excel Expert
$30-250 USD
Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.