Interactive Sales & Inventory Google Sheets

$30-250 AUD

Abgeschlossen

Veröffentlicht

vor etwa 2 Monaten

$30-250 AUD

Bezahlt bei Lieferung

I'm in need of a Google Sheets expert, equipped with knowledge and experience in setting up interactive dashboards and complex formulas. Your task would be to create a robust Google Sheets template for showcasing my sales data (manually inputted data) from sales on eBay and offline sources such as Facebook Marketplace. I've created a basic one which you can see in this screenshot: [login to view URL] I have some formulas ready to go: [login to view URL] Sell through rate: [login to view URL] Buy again: [login to view URL] I imagine Daily Sales & Expenses, Monthly Sales & Expenses and Buy Again sheets would be locked. The Dashboard sheet would utilize graphs and things like that. It would also be good to have a user-friendly form that the user can fill out for a new piece of inventory or to report a new sale. Key Responsibilities: - Create a specialized Google Sheet that allows me to input, track and visualize my sales data in a comprehensive manner. - The Google Sheets template should include the facility to list and view items that need to be repurchased if certain metrics are achieved. Project Specifics: - Data representation for daily and monthly sales is to be included, although the client did not specify a preference on the type of chart/graph to be used. - An automated system should be set up to highlight items that need to be repurchased based on a combination of 'profit margin' and 'sell through rate'. Ideal Skills: - Proficiency in Google Sheets - Experience in creating interactive dashboards - Knowledge in optimization formulas for automated calculations - eCommerce experience, specifically with eBay, is a big plus.

Projekt-ID: 37947193

Über das Projekt

184 Vorschläge

Remote Projekt

Aktiv vor 1 Monat

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@amokhtar70

I have done a similar project to a former client. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein https://www.freelancer.com/projects/excel/Stock-Tracking-Solution/reviews

$180 AUD in 4 Tagen

5,0

(47 Bewertungen)

5,5

184 Freelancer bieten im Durchschnitt $132 AUD für diesen Auftrag

@schoudhary1553

As an experienced Full Stack Developer with 7+ years of expertise in Excel, Google Sheets, and data scraping, I am perfectly equipped for your specific needs. Throughout my career, I've had the privilege of serving major corporations like Metlife GOSC, DXC Technologies, and Elite Services, developing a profound understanding of complex formulas and automation techniques- which aligns perfectly with your project requirements. Having operations experience on popular e-commerce platforms like eBay further adds to my suitability. My promise to deliver the best speed without compromising on quality is not just a claim but something I practice. I assure you that I will present an interactive Google Sheet with optimized formulas that provide comprehensive data tracking and visualization. My proficiency in creating elaborate yet user-friendly dashboards is appreciated by my past clients and would be tailored to suit your specific needs too. Additionally, expect an automated feature that intelligently identifies inventory needing repurchase based on predetermined metrics – such as 'profit margin' and 'sell through rate.'

$180 AUD in 4 Tagen

4,9

(644 Bewertungen)

8,6

@techplusintl

Hi there, ★★★ Google Apps Script / Sheets / Forms / VBA Expert ★★★ 9+ Years of Experience ★★★ I've read requirements and ready to work on your project. I am capable of developing both script-based and formula-based spreadsheets, as well as anything related to Google Services, Integration, and Automation. My Services: ✔️ Google sheets automation ✔️ Google Form, Google Docs, Apps ✔️ Google apps script ✔️ Automate google calendar ✔️ Creating bulk google calendar events from google sheet ✔️ Auto-generate reports from google sheets ✔️ Gmail automation (Auto send or delete emails from Gmail) ✔️ Integration of all Google services (spreadsheets, calendar, maps, Gmail, etc.) and other third-party APIs ✔️ Dashboard design and automation ✔️ Formulas, Fix your data, Filters, Queries ✔️ Conditional formatting, Crush Duplicates ✔️ REGEX, Countif, VLookup, Hlookup, Index Match ✔️ Interlinking Sheets or other Google sheets sheets ✔️ Importing Data from Websites and other Google Sheets ✔️ Manage Drive From Sheet ✔️ Pivot charts, Pivot Tables, Dashboards As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

$250 AUD in 7 Tagen

4,8

(376 Bewertungen)

8,2

@admk80

Dear Mathew C. Greetings I have seen your posted job and I feel very much interested to work with you. I have read the things that you want. I consider myself perfect match for this job because I am working as a Web Developer since the last 10 years. I can assure you that my skills will not let you down. I have learnt almost all the languages such as the languages such as JavaScript, Excel, Google Sheets, HTML and PHP etc. and gathered some excellent skills on Web Developing. I believe that what will take me far from my competitors is my experience. I have been working as a web developer for the last four years and have proved myself many times. You can search work histories and their ratings to be sure. I am confident that I can be a good employee for you because I know what you want. You can have a check on my profile, Portfolio, Work History and Feedbacks to satisfy your needs. I can assure you that I will do my best to do your job. Yours Faithfully Mr. Arshad

$200 AUD in 7 Tagen

4,8

(271 Bewertungen)

7,4

@kazemmojtama

Hello, good time Hope you are doing well I'm expert in MATLAB/Simulink, Python, HTML5, CSS3, Java, JavaScript and C/C#/C++ programming and by strong mathematical and statistical background, have good flexibility for solve your project. I have many experience practical and theoretical in implementation different algorithms (such as: state estimation and Kalman filter, design controller, analysis closed loop stability, signal and systems, signal processing, heuristic optimization, fuzzy logic, neural network and machine/deep learning fields). Evidence of this claim exist in the portfolio. I have read your project description and I can help you (without any plagiarism). Please send me the details of your project. Thanks for attention 100% Jobs Completed, 100% On Budget, 100% On Time ⭐⭐⭐⭐⭐ 5-star reviews

$250 AUD in 7 Tagen

5,0

(12 Bewertungen)

7,2

@Michashica29

Hi there, I can help you with that & I can provide virtual assistance for daily office work. Experienced Virtual Assistant for more than 7 years working with different companies around the globe, managing their website from different platform specifically eBay and Neto/Maropost. I can also do Internet Research/Web Search, Data Entry, Web Scrapping, Data mining, Copy Typing, Data Processing, Database Managing, Email Sending/Handling, Bookkeeping, Editing, Transcribing, Language Translation, SEO(Search Engine Optimization), HTML, Photoshop, Social Media Marketing, Email Marketing & Project Manager & Social Media Manager. I like working with sharp deadlines with high-quality data. I am an adaptable and quick learner, willing to learn and to be trained, hardworking, and multi-tasking, I am willing to start immediately. Please feel free to visit my profile and check my reviews or send me a message anytime & I am looking forward to working with you soon. :) Sincerely Monica M.

$50 AUD in 1 Tag

5,0

(10 Bewertungen)

6,8

@durgesh8527

As an experienced full-stack developer with over a decade of experience, I am confident that I am the right fit for your project. My level of proficiency in Google Sheets and knowledge in setting up interactive dashboards allow me to utilize complex formulas and optimize automated calculations, which is exactly what you need for your project's robust inventory and sales management system. In regard to your project specificity, my extensive expertise in eCommerce, specifically with eBay, not only aligns well with your project but also brings added value to the table. I understand the importance of visualizing data comprehensively for better decision making. Therefore, I assure you to implement the most suitable graph or chart dynamically based on your data representation requirements. Beyond just technical aptitude, my commitment to excellent communication and strict deadline adherence is a value-addition I offer. These qualities will ensure that you get constant updates on project progress and receive a high-quality product within the agreed timeframe. Let me help streamline your sales and inventory management systems ensuring smooth tracking and visualization of all relevant metrics.

$140 AUD in 7 Tagen

4,6

(131 Bewertungen)

7,0

@rashidamjad

Hi there, I'm thrilled to apply for your Interactive Sales & Inventory Google Sheets project. With 4-5 years of experience in JavaScript, Google Sheets, Excel, HTML and PHP, I'm confident in my ability to bring valuable insights and expertise to your initiative. Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Feel free to check out my profile, showcasing my portfolio, past jobs, and client reviews. It reflects the quality and professionalism I bring to every project. My goal is to provide a competitive budget without compromising on quality. Thanks for considering my proposal. I'm eager to collaborate and contribute to your project's success. Let me know if you need any more information. Best regards, Rashid Amjad

$250 AUD in 8 Tagen

5,0

(29 Bewertungen)

6,1

@izhanali77

Hello, I see that you need Interactive Sales & Inventory Google Sheets, and trust me, my expertise makes me the best candidate for this task. I offer the best quality work within an affordable budget! Check out my 5-star Reviews & Portfolio from my profile: ✅ https://www.freelancer.pk/u/izhanali77, Let's connect in chat so that we can discuss further in detail.

$250 AUD in 1 Tag

5,0

(32 Bewertungen)

5,7

@sonarkaushik

Dear Client, I am writing to express my interest in collaborating with you on your project posted in Freelancer. Based on the project details provided, I assure you that I have the skills and expertise required to deliver high-quality work within the specified timeframe. I am confident in my ability to deliver exceptional results for your project. I am committed to maintaining open lines of communication, delivering on time, and ensuring your complete satisfaction. Waiting to hear from you. With thanks regards

$99 AUD in 7 Tagen

4,5

(72 Bewertungen)

6,1

@dealzdekho

Dear Client, I am a seasoned PHP developer with over 6 years of experience, specializing in creating robust and efficient solutions. I have thoroughly reviewed your project requirements for setting up an Interactive Sales & Inventory Google Sheets template and I am confident in my ability to deliver a high-quality solution. I am keen on discussing the details of your exciting project further and would love to connect with you in chat to explore how we can collaborate to bring your vision to life. Your project aligns perfectly with my expertise in PHP, JavaScript, Excel, HTML, and Google Sheets, making me well-suited to handle the complexities of creating interactive dashboards and implementing complex formulas. I am looking forward to the opportunity to work together and create a tailored Google Sheets template that meets your specific needs. Please feel free to reach out to me so we can discuss the project in more detail. Best regards, Soham

$140 AUD in 7 Tagen

4,9

(22 Bewertungen)

4,9

@freelancer22to00

As a self-proclaimed "forever learner," I've made it my mission to excel in all things related to data analysis. My proficiency in Google Sheets, paired with a knack for simplifying complex information into user-friendly interfaces, makes me the ideal candidate for creating your interactive sales and inventory sheets. On top of that, I boast a strong background in eCommerce, specifically with platforms like eBay. Your project demands an expert who is adept at not only setting up interactive dashboards but also at incorporating intricate formulas- both of which I have extensive experience in. The screenshots you shared showcase your basic design, and I can assure you that with my expertise, we can transform it into a powerful tool tailored exactly to your needs. Furthermore, as your project requires an automated system that intelligently identifies underperforming items needing replenishment, my knowledge in optimization formulas will come into play here. For me, it's not just about creating a template; it's about creating a solution that streamlines your work processes and helps you make informed business decisions. So let's take this dive together and update your inventory management to professional levels!

$250 AUD in 2 Tagen

5,0

(6 Bewertungen)

4,8

@trm66614

Hi there, Good evening I am Talha. I have read you project details i saw you need help with HTML, PHP, Google Sheets, Excel and JavaScript I am excited to submit my proposal for your project, which focuses on a comprehensive project plan. To begin, we will thoroughly understand your project's objectives and requirements, ensuring alignment on scope and goals. We will provide a clear and realistic project timeline with manageable milestones to ensure timely completion Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Thanks Regards. Talha Ramzan

$30 AUD in 12 Tagen

5,0

(8 Bewertungen)

4,8

@GKEvans

Hello, I would like to help you with your project. I have looked at your screenshots. I have Google Sheets experience that includes macro development. I can create a dashboard for you and some forms to enter new products, inventory and sales. I have a BEng in Software Engineering and I am a qualified accountant.

$140 AUD in 7 Tagen

5,0

(3 Bewertungen)

4,9

@Nilufer2024

Hi, Mathew C.! I have worked with similar projects so that I can provide you with a satisfied result. Having confirmed the job posting "Interactive Sales & Inventory Google Sheets", I truly feel that you're looking for expert in PHP, HTML, Google Sheets, Excel and JavaScript. I am fully available to get started on your project immediately and you will find it interesting to discuss the project details. Regards Nina.

$120 AUD in 2 Tagen

5,0

(3 Bewertungen)

4,4

@noureen23

With over 15 years of experience in database design, complex SQL scripting, and data analytics, I am a seasoned expert when it comes to managing and transforming complex datasets. My extensive expertise in using the Google Suite, especially Google Sheets, aligns perfectly with your project requirements. I have an intricate understanding of how to create interactive dashboards that can easily accommodate manifold datasets. My proficiency in crafting formulas, utilizing advanced functions such as Vlookups and pivot tables, and creating insightful graphs makes me well-equipped for building a robust sales and inventory tracking system on Google Sheets. Via these skills, I am also experienced at laying out an attractive and user-friendly interface that will make everyday users feel comfortable inputting their sales data or reporting new inventory. I assure you that setting up metrics like the 'profit margin' and 'sell through rate' for highlighting items that need re-purchasing will be available. Let's make your data actionable!

$70 AUD in 10 Tagen

5,0

(15 Bewertungen)

4,4

@dillonmarszal

Hello. I am a SR. WEB DEVELOPER who can certainly make your idea into real! I have enough experience in HTML, Excel, JavaScript, Google Sheets and PHP. I am waiting your reply here, please don't hesitate contact me anytime. Thanks.

$200 AUD in 7 Tagen

5,0

(6 Bewertungen)

4,2

@sajidjasi

As someone with a strong background in data analytics and visualization, your project hits every point I'm passionate about. I've been using Google Sheets for several years now and have become exceptionally skilled at creating interactive dashboards and complex formulas. In fact, some of the formulas you've shared are already quite similar to ones I've built in the past. On top of that, I have an intimate understanding of working within the eCommerce sector, specifically with eBay. This understanding not only aids me in interpreting your vision but also allows me to implement more context-specific designs that align better with your business's needs. Moreover, my skills extend beyond just creating spreadsheets - I'm adept at utilizing graphing tools for comprehensive data representation and implementing automated systems to ease administrative tasks. I'm able to build on your existing foundation seen via the screenshots you provided and improve upon it to exceed your expectations. In the end, my goal is to deliver a robust and user-friendly Google Sheets template that will optimize your sales tracking and inventory management process.

$30 AUD in 2 Tagen

4,6

(23 Bewertungen)

4,5

@PauloLosinada

Hi Mathew C. It seems like you're looking for a senior engineer who can complete the project - Interactive Sales & Inventory Google Sheets. I am writing to express my keen interest in your project since I have definitely worked on the similar projects in the past. Proven Track Record: I have a solid track record of successfully completing projects similar to yours, with positive feedback from satisfied clients. Technical Expertise: My extensive experience in IT development equips me with the skills needed to navigate the complexities of HTML, PHP, JavaScript, Google Sheets and Excel. Deadline Commitment: I understand the importance of timelines and am committed to delivering your project on schedule. With over 7 years of experience in IT development, I have successfully delivered projects similar to yours. My expertise spans a range of technologies and platforms, and I am confident in my ability to provide you with high-quality work within the specified deadline. I am eager to discuss your project further and explore how my skills align with your vision. A conversation would allow me to better understand your specific requirements and share insights on how we can achieve your goals. Best regards, Paulo

$250 AUD in 7 Tagen

5,0

(2 Bewertungen)

3,8

@zubairmbafinance

Helo, As an MBA Finance professional, I specialize in Excel-based financial analysis. I offer expertise in financial modeling, data analysis, reporting, process automation, training, and consultation. With a commitment to quality and efficiency, I aim to optimize your financial operations and drive informed decision-making. Let's discuss how I can support your business goals. Best regards, Zubair Yaseen

$100 AUD in 4 Tagen

4,8

(17 Bewertungen)

3,6

@InvokeByte

I will create interactive Sales Inventory sheet for your tasks. I will provide you solutions to automate your manually tasks too. I had already completed projects related to inventory. You can review my profile. Connect with me so I assist you in details.

$200 AUD in 7 Tagen