Find Jobs
Hire Freelancers

Create a travel reimbursement form

$25-50 USD / hour

Berlangsung
Dibuat lebih dari 7 tahun yang lalu

$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.
ID Proyek: 11702592

Tentang proyek

7 proposal
Aktif 8 tahun yang lalu
Lokasi: Alexandria, United States

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 dalam 12 hari
0,0 (0 ulasan)
0,0
0,0
7 freelancer menawar dengan rata-rata $47 USD/jam untuk pekerjaan ini
Avatar Pengguna
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 dalam 10 hari
4,9 (250 ulasan)
7,0
7,0
Avatar Pengguna
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 dalam 3 hari
5,0 (180 ulasan)
6,7
6,7
Avatar Pengguna
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 dalam 10 hari
5,0 (13 ulasan)
3,0
3,0
Avatar Pengguna
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 dalam 8 hari
5,0 (2 ulasan)
1,4
1,4

Tentang klien

Bendera UNITED STATES
Alexandria, United States
0,0
0
Memverifikasi Metode pembayaran
Anggota sejak Okt 4, 2016

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.