Find Jobs
Hire Freelancers

Consolidate spreadsheets and create cross-reference lookup that can be posted online

$250-750 USD

Zavřený
Zveřejněno přibližně před 5 roky

$250-750 USD

Zaplaceno při doručení
Have several spreadsheets and / or PDF files with various plannograms (POGS) that need to be cross-referenced to 400-ish individual stores so that store can go into our intranet, select their store, and only see their POGS. Four different POG categories (Cigarettes, Smokeless Tobacco, Cigars, and Vaping) with varying sizes (e.g. 3 feet, 4 feet, 6 feet, short-, tall-, etc.) and varying products. For example, there are 10-ish Cigarette POGs, 25-ish Cigar POGs, 15-ish Smokeless POGs, and 7-ish Vaping POGs. An individual store would have one combination of these across the 4 categories depending on the store. Maintenance of the POGs will either be in spreadsheets or in PDF (Cigar), maintenance of the cross-reference file for the stores (i.e. what POG combination they get) will be in a spreadsheet with a column for each type of POG by category (Cigarette, Cigar, Smokeless, Vaping). We want a store to be able to get their specific POGs across each category easily and intuitively. E.g. we could create and store a PDF for each individual store and list on our intranet but we are open to suggestions. More details and file examples available upon selecting someone for this small project.
IČ projektu: 18679820

O projektu

10 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
10 freelanceři nabízejí v průměru $446 USD za tuto práci
Avatar uživatele
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$500 USD v 10 dnech
4,9 (346 recenze)
8,0
8,0
Avatar uživatele
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a POS and inventory management system - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a hotel price comparison that pulls data using the website's API - Scrape various websites like tennisinsight, pubmed You can see the reviews of the same in my profile Thanks, Archana
$300 USD v 10 dnech
4,8 (81 recenze)
5,8
5,8
Avatar uživatele
Hi,there. How are you doing? I have read your job post 'Consolidate spreadsheets and create cross-reference lookup that can be posted online' and am appling to it. I am a senior full stack developer who has been dealing with this kind of things for the past 10 years. Please contact me for more discussion. I am ready to start immediately. Thanks in advance and I am waiting for your contact.
$555 USD v 3 dnech
5,0 (2 recenze)
3,2
3,2
Avatar uživatele
Are you still looking for someone? -------- Hello, I can create you a master excel-file with dynamic cross-references to the other excel spreadsheets. However, this will not be possible for PDF files without me developing a relatively complex macro with VBA code which will increase your costs significantly. Are the PDFs a must have in your scope or are the spreadsheets your main focus? Could I have a look at an example file please? Best regards, Fuad
$366 USD v 5 dnech
5,0 (1 recenze)
1,0
1,0
Avatar uživatele
I'm new here and really need a chance . and I will finish your project quickly . and if you don't like my performance , you can not pay money
$333 USD v 5 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I am Pankaj raina
$555 USD v 10 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi, I am an expert with Excel, Data Management and Access. I have worked in a reputed MNC, my 10 years of professional experience includes analyzing & interpreting large amounts of data; creation of innovative, engaging & impactful presentations; managing team; formulating business plans; conducting market research and developing budgets. In MS-Excel, I worked on projects like Data Visualization, Dynamic Dashboards, Macro, Complex Formula, Formatting, Excel to Powerpoint/Word conversion, PDF report creation, User Forms etc. I have vast experience of creating impactful, visually appealing and user-friendly presentations. I believe my skills would be ideal for your project. I would be happy to set up a convenient time to discuss the work. Regards, Gagan
$298 USD v 5 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I am computer post graduate and hence well aware of computer applications and latest technologies.
$555 USD v 10 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Having 15 years experience of MIS in MNC
$555 USD v 10 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi Hope you're well So it seems like what you're after is the ability to maintain all 400 stores' different POGS categories in a centralized location, while allowing each individual store to lookup what their own POGS mix should be This can be done in a 2-tab Excel workbook What I would do is have all the 400 stores' data set out in a uniform manner on your maintenance tab, including store name, location, POGS mix etc. Then on the lookup tab, a very user-friendly template which allows any individual store to enter their own store number/unique identifier and be presented with their POGS mix and any other details you'd wish to present You would then be able to host this Excel workbook on your intranet for all stores to access I would break this project into the following milestones: - $111 for drafting of the proposed layout for your review - $222 for completion of spreadsheet (data entry, formulas, lookups etc) for your review - $111 once you're happy with the final piece, also inclusive of any adjustments/improvements/documentation to be made Let me know if you're interested in working together Cheers Steve
$444 USD v 2 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z UNITED STATES
Des Moines, United States
0,0
0
Členem od úno 7, 2019

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.