Find Jobs
Hire Freelancers

Ammo Compatibility Chart

$30-250 USD

Closed
Posted over 4 years ago

$30-250 USD

Paid on delivery
US Army Logistics Officer, we mainly transport ammunition to training units. Based on army regulation, certain types of ammo cannot be transported on the same truck or trailer. I am looking to create “trucks” on excel and “pallets” on the backs of said trucks. I would ideally be able to “place” a pallet of ammo on a truck. If I place 2 pallets of ammo on a truck that are not compatible, I would like the “pallets” (cells) to highlight red.
Project ID: 20380351

About the project

15 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average $113 USD for this job
User Avatar
Hello, I can automate it using VBA macros. How I picture it, there would be a separate row for each truck. It could have some information like the delivery date etc., but the most important is that the last columns would be for pallet 1, pallet 2, etc. Each pallet column would have a dropdown list in its cells from which ammo type can be selected. Based on a table of ammo pairs that can't be transported together, the macro would automatically highlight the cells where unallowed combination appears. Also, the macro could generate value in the Compatible column, to easily filter the data set by compatibility status. Another idea is a circle Excel shape on the top row, to show whether all items are compatible (green color) or not (red color). Best regards, Ryszard
$50 USD in 3 days
5.0 (64 reviews)
5.3
5.3
User Avatar
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$40 USD in 1 day
4.8 (28 reviews)
5.0
5.0
User Avatar
Hi Your Charts Specialist here. Graduated recently from California, USA; I have been doing numerous marketing and research projects. I feel I will be comfortable to work with you and perform tasks as per the quality standards with revisions as per the demand. I have done my internships in Canada Australia and United States. As having experience, I can provide you the best content as per demand. I am strategic, goal oriented, and always work with an end goal in mind. I have been creating unique, interactive, and beautiful content for over 2 years and have worked for clients and companies around the world--And sometimes I do designs just for myself :) I have command over different academic referencing styles including Harvard, APA, MLA , Oxford and Chicago. I am able to write and carry out extensive research in different areas and provide quality work as per client’s requirements. My clients range from undergraduate to PHD. I have covered different academic fields including business management, HRM, organizational and business strategy, Marketing, Medical, Nursing and International relation. I am also specialized in social media content, website content, blog, advertising material, and sales pages. Providing unique content consistently is not an easy task, especially on a variety of niches. Feel free to inbox for more details and budget. Regards
$200 USD in 3 days
5.0 (1 review)
2.8
2.8
User Avatar
Hi, I can easily create a python program that will take an excel or CSV file as an input, follow the rules of pallet and trucks combinations, and then output a new excel or CSV file with the desired requirements, which is highlighting in this case. You can easily use the program in one click, no prerequisites required. I have few questions regarding the form of data and how the rules will be given. Please contact me if you are interested
$40 USD in 1 day
4.9 (5 reviews)
3.0
3.0
User Avatar
::: Ammo Compatibility Chart ::: Hi, I have read and understood the requirements of your project. I am an expert in EXCEL, VBA etc. Moreover, I hold Master's in Project Management and have managed many projects like this. I also have very good reputation on freelancer. Please contact me for further discussion.
$30 USD in 2 days
5.0 (2 reviews)
1.1
1.1
User Avatar
Hello, I have read about what you require and I assure you that I am the best candidate for you. For quality service, kindly consider me. Thank you.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I read the description and that's a really easy task for me. It can be done in Excel. I can ensure you that I can do this within a day. Pay me after you are satisfied with my work Message me to discuss further. Thanks
$100 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Here's the most experienced & talented person you can hire for this job. I can do this perfectly. So I'm waiting for a favourable response sir. Relevant Skills and Experience 5 years of experience. Degree in software engineering. Diploma in English. Diploma in information technology. EdHat international higher diploma. Diplom in graphic designing.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi! This is right up my alley. I've done a lot of work with Excel. Please let me know more about your project!
$140 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
It's easy to overthink this one. I can create an Excel spread sheet that when you select the first item on the truck, the next selections will only be what's allowed. Very possible!! No warnings, only the ability to choose what can go next. Of course, once you remove an item, other items will be allowed. Just need the list of incompatibles. I'm in America and speak American English, so communication isn't an issue.
$75 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Esteemed sir/mme The job you propose can be done easily, with adequated formulas for this specific case. By the description you make, i shoud be able to do do it for you, within a day, but i can only be sure after i see the details, as for instance, how many pallets can a truck transport at max. Message me if you will discuss some details, as well as a different solution i can propose. Kind regards
$140 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would love to do this project. seems very simple to me(just validate 1 column?) Might have few question later or just an example on paper. 100% satisfaction guaranteed. Let me know
$200 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Cleveland, United States
0.0
0
Member since Jul 17, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.