Create stock control database excel일자리
개인적으로 교육연구에서 자주하는 (통계)분석 몇 개를 자동으로 할 수 있는 간단한 R 패키지를 만들고자 합니다. 테스트데이터(Treatment/Control 그룹 사전/사후 데이터 셋(csv 파일)을 종류별로 인식하여 읽어들이고, 사전데스트/사후데스트로 구분할 수 있게 변수명을 바꾸고 (예: 수집된 데이터 문항 Q1, Q2, Q3...로 되어 있는데요, 사전테스트 데이터면 Q1_pre, Q2_pre, Q3_pre...로, 사후데이터면 Q1_post, Q2_post, Q3_post...로 변환), 해당 데이터별로 제가 이미 만들어 놓은 스크립트를 돌려 (Item Analysis, ANCOVA 등의) 분석을 자동 시행하고 결과를 출력하도록 하는 간단한 패키지입니다. 데이터셋을 종류별 구분해서 읽어들이는 것이 관건인데, 제가 이 부분에서 애를 먹고 있는 중입니다. 사용자로부터 (treatment pre, treatment post, control pre, control post) 인풋을 받아 If, For 등의 Function을 쓰면 될 듯 한데 (저의 짧은 소견입니다^^;), 제가 아직 R 함수에 익숙치 않아 주로 이 부분을 R 전문가의 도움을 받고자 합니다. 구체적으로 무엇을 구현하려고 하는지는 지금까지 제가 만들어 놓은 스크립트와 관련 문건들을 파일로 참고하시면 되실 듯 합니다. 다시 한번, 도움주실 내용의 핵심은 4종류의 데이터셋을 구분하여 읽어들이는 스크립트/함수가 되겠고요, 두번 째로 중요한 것은 스크립트가 완성되면 분석별로 스크립트를 묶어 함수화하는 것이 되겠습...
The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
반응이 빠른 웹사이트가 필요합니다. 디자인 및 개발 작업이 되어야 합니다.
More details: What format would you prefer for the email addresses? Excel spreadsheet How many local authorities are you targeting? More than 50 What specific information do you need besides email addresses? Contact names, Phone numbers, Email addresses The project needs to be completed within 1 week. Please verify all email addresses to ensure accuracy. These email addresses will be used for outreach campaigns targeting local authorities. Please include the contact departments associated with each email address. Please categorize the email addresses by region. Please conduct manual verification to ensure the accuracy of the email addresses. Please treat all regions with equal priority. The primary purpose of this outreach campaign is to request collaboration. Please name the fi...
I'm looking for an Excel expert who can create a Google Sheet for tracking my cryptocurrency portfolio. The sheet should monitor Bitcoin (BTC) and Solana in real-time, displaying market prices, portfolio movements, and gain/loss metrics. It should also feature Line charts, Bar charts, and Pie charts to visualize the data. Key Requirements: - Proficiency in Excel and Google Sheets - Experience in creating real-time data tracking tools - Ability to create and integrate various types of charts Ideal Skills: - Strong understanding of cryptocurrency and market tracking - Excellent data visualization skills - Attention to detail to ensure accurate tracking of gains and losses
I'm in need of a professional who can develop a method to link multiple Word documents with various Excel files. The goal is to create a comprehensive mapping matrix to facilitate process automation. Key Requirements: - Mapping of diverse data types: This includes text, numbers, formulas, assessment questions and workbook content from the Word documents to the Excel files. - Establishing a Many-to-Many relationship: The project involves linking multiple Word docs to multiple Excel files, ensuring a well-structured and efficient mapping system. Ideal Skills: - Proficiency in Microsoft Word and Excel - Expertise in creating mapping matrices - Experience in process automation Your bid should reflect your ability to deliver a seamless, automated proc...
I am seeking a part-time remote assistant with some knowledge of the clothing retail business. As a startup, I need help across a variety of tasks. Your responsibilities will include: - Assisting with customer service: This involves handling inquiries, managing returns and exchanges, and assisting with order processing. - Inventory Management: Keeping track of stock levels, helping with restocking and reporting any issues. - Social Media Management: Assisting in promoting the business online, engaging with customers and helping to build our online presence. - Conducting market research to stay updated on industry trends and customer preferences. - Supporting email marketing campaigns, including creating newsletters and managing email lists. - Creating content for the company blog...
...this project will focus on core functionalities like order creation and invoicing, with a simplified user role system (admin and non-admin) and no external integrations. 2. Project Scope 2. Implement a search function to quickly locate orders using various filters such as customer name, order ID, or date range. 3. Allow exporting orders and invoicing data in various formats like CSV, PDF, and Excel for external reporting or bookkeeping needs. 4. Set up email or SMS notifications for important events like order creation, completion, and shipping updates. 5. Maintain a detailed log of changes and actions performed on each order, such as edits, status changes, and notes. 6. Enable bulk processing features to handle multiple orders simultaneously for operations like status updates a...
I'm in need of a professional to help me organize some legal documents and prepare various spreadsheets for legal purposes. The types of documents that need to be organized include text messages, expenses, and emails. Ideal Skills: - Document management - Spreadsheet proficiency (Excel, Google Sheets) - Attention to detail - Understanding of legal documentation processes - Confidentiality and discretion Project Requirements: - Organize text messages, expenses, and emails - Prepare spreadsheets for expense tracking, communication logs, email records - Categorize expenses by date, type of expense, and client Please keep in mind that this project requires a high degree of confidentiality and discretion. Your ability to maintain privacy while handling these sensit...
I'm looking for a graphic designer capable of creating a unique piece of artwork that emphasizes the phrase "Friends don't let Friends go to Quilt Shops Alone" and incorporates our store logo. The piece of art will primarily be used on our social media platforms. Key Requirements: - The artwork should match the style of our logo, which will be provided. - It should incorporate our store's color scheme and font style. - The designer should have experience in creating visually appealing social media content. - Understanding of our brand identity is a plus.
I need an Excel spreadsheet template for a quality control inspection report tailored for a machine shop. Key Requirements: - The template should include an inspection checklist - There should be a section for Pass/Fail criteria - The template should be user-friendly and easy to navigate - The design should be professional and suitable for a machine shop context Ideal Skills and Experience: - Proficiency in Excel - Experience with quality control processes in machine shops - Ability to create clear, concise, and professional templates
...procesador, se realizaron pruebas con Arduino Pro Micro sin buenos resultados, por lo que es necesario evaluar una mejor alternativa que garantice una respuesta rápida y sin latencia. El instrumento incluirá un sensor que modificará las notas reproducidas, además de la posibilidad de cambiar la biblioteca de sonidos para simular distintos instrumentos. También se contempla la integración de un control de volumen en tiempo real mediante una celda de carga o potenciómetro. Para la reproducción de audio, actualmente se utiliza un SparkFun WAV Trigger, aunque se está abierto a soluciones más eficientes que puedan integrarse al procesador. El objetivo principal es optimizar el diseño y programación ...
**PROYECTO: Desarrollo de Software de Facturación Electrónica para El Salvador** **1. Introducción** Se propone el desarrollo de un software de facturación electrónica conforme a la normativa vigente en El Salvador. Este sistema será 100% dedicado a la gestión de facturación electrónica, sin control de inventario, y garantizará el cumplimiento de los requisitos legales mediante el manejo eficiente de los catálogos y procesos necesarios. **2. Alcance del Proyecto** El sistema estará diseñado para facilitar la generación, validación y almacenamiento de facturas electrónicas, permitiendo a las empresas cumplir con las regulaciones gubernamentales. Se proporcionarán...
I need a professional, clean, and editable PDF document that will work seamlessly with PDF Expert on an iPad. The document should include fillable areas for text, checkboxes, and signature fields, and must be well-designed to meet a professional standard.
I'm seeking a skilled developer to m...Data Migration Strategy API Integration Authentication Logic The website will need to allow users to query our database tables for individual record counts, purchase records to download, and manage users and their data credits in an admin panel. Currently, we're migrating from InforbrightDB (MySQL compatible) to ClickhouseDB, so familiarity with this database transition would be beneficial. Please implement a modern design overhaul for the UI/UX. The expected timeline for the migration is 3-4 months. Focus on improving existing APIs and third-party integrations for better performance and reliability. It is a small, monolithic codebase. The project will use GitHub for source control management during the migration. Impr...
...take our existing pricing sheet mock-up and turn it into a polished, professional, and visually engaging PDF. This document will be a key piece for customer communication and will also be used by our sales team. The ideal design should clearly present our pricing information while aligning with our brand identity. Scope of Work: Design Enhancement: Use the provided mock-up as a foundation to create a refined, professional design that is both attractive and easy to understand. Brand Alignment: Incorporate our brand colors, typography, and design elements to ensure consistency with our overall brand identity. Layout & Visual Appeal: Improve the layout and organization of information so that it’s intuitive and engaging. Add graphic elements, icons, or illustrations as ...
online quoting system that enables commercial customers to configure and price pumps, tanks Project Summary: The goal is to develop the most cost-effective online tool for generating quotations based on tank and pump system selections. The tool should allow users to input key parameters such as tank type, pump setup, control type, and other configurable options, and automatically generate a quote with the appropriate model selection. To minimize costs, the solution should leverage a simple web application. The tool should require minimal maintenance, with an option for user authentication and tiered pricing if needed. Key features include: • Simple UI for selecting system components • Automatic lookup and model selection • Quote generation with PDF export • Adm...
...am looking for a talented graphic designer to create a visually appealing homepage layout for my new website, Wholesale.Bid. This site will focus on wholesale auctions, wholesale bidding, and liquidation inventory, providing a marketplace for businesses and resellers to find bulk deals. Key Requirements: • Design only (NO coding required). • Web layout optimized for all devices (desktop, tablet, and mobile-friendly). • Height: 3000px to accommodate detailed content. • Clear navigation sections to highlight auctions, wholesale deals, and bidding options. • Modern, engaging, and visually appealing layout. • Sections covering: • Wholesale Auctions – Bulk lots and pallet sales. • Liquidation Inventory – Overstock, closeouts...
I'm in urgent need of an Excel macros specialist who can help with data analysis and reporting on financial data. Key Requirements: - Expertise in Excel macros, specifically for data analysis and reporting. - Proficiency in handling and interpreting financial data. - Ability to create summary reports from complex datasets. Ideal candidates will have a strong background in finance and data analysis, with a track record of creating effective Excel macros. Please be prepared to showcase examples of your previous work in this area.
I'm looking for an experienced individual to help me with a WordPress backup upload. The backup is in .tar format and needs to be uploaded to my new shared hosting site. Key details: - I have full access to the new host's control panel, which is cPanel. - The task involves using shared hosting, so familiarity with this environment is essential. Ideal skills: - Proficiency in WordPress and cPanel. - Experience with .tar file handling. - Knowledge of shared hosting environments.
I'm in need of a VoIP professional who can set up and configure a private SIP panel on a cloud-based virtual setup for calling to US phone numbers. This system must be completely independent from public providers like Twilio or Plivo, allowing us full control over our communication. Key requirements include: - Extensive experience in SIP configurations and VoIP infrastructure - Ability to implement call routing and forwarding functionalities - Experience in creating secure, high-performance telephony solutions that can handle up to 50 concurrent calls Your technical proficiency will be crucial in building a reliable, self-sufficient calling system that operates seamlessly without third-party dependencies. If you have the skills and experience to deliver this private SI...
Hello I need a specialist who can create the perfect book cover for my ebook. It will be sold on Amazon kindle first but I need a cover that can be used also for paperback . It should be stylish and very attracting specially for Amazon , as kindle is in black and white. Thanks
...scripts for efficient data extraction or those with a team capable of handling bulk processing. Requirements: • Expertise in Python or other relevant programming languages for PDF parsing • Experience with libraries such as PyPDF2, PDFMiner, or similar tools • Ability to extract structured data accurately (tables, text, etc.) • Handling of different PDF formats and layouts • Data output must be in Excel (.xlsx) format per template provided. Preferred Qualifications: • Prior experience with large-scale data extraction • Strong attention to detail and data accuracy • Ability to process PDFs with varying structures • Team availability for high-volume processing (if applicable) Selection Process: • We will conduct interviews to und...
Project Overview Development of a modular stock and sales management system to list products, manage platform integrations, and track sales. The system will be scalable and flexible, allowing future integrations and continuous improvements. Scope of Work 1. System Design Backend: Laravel 11 with MySQL Frontend: Laravel Blade or Data Processing: Python (if needed) Private GitHub access (excluding database) 2. User Roles Admin: Full system control Staff: View-only for offers and disputes 3. Offer & Stock Management Draft mode for listings Platform-specific data (Fortnite, Valorant, LoL, GTA) Delivery format: [username:password:email:emailpass] 4. Platform Integrations Initial integrations: Eldorado, GameBoost, G2G Stock distribution via queue sys...
...questionnaire with set parameters need to be uploaded on the site for the visitors to take the survey with a description of the survey and its importance. Once a survey is live we need to register the records for 45 days during that time our partner NPOs work locally in promoting and awaring people to take survey. Post 45 days we need to fetch all the information into spreadsheet (Google Sheet, Excel recommend) the using Power BI, python language another team work on analizing the records and forms a detailed illustration for the data. And a well defined resource backed research paper need to publish on the site in the form of blog and a download link for the papers. Based on working description of the company I need a mature design for the website. The work will include &quo...
...segment of personal development. Skills and Experience: - Proficiency in sales, particularly in the personal development niche. - Experience with LinkedIn as a lead generation platform. - Ability to ensure lead commitment to calls. The Leads must be ready to take action, the Leads need to know why they are on the call, for a High Ticket Course in Personal Development. Must have excellent control over the English language, must be able to speak and type fluent English. Freelancer ideally from the States, Canada, or UK. The goal is to effectively book these Warm Leads into our calendar for our Sales Closer to seal the deal. The primary objective of this campaign is to boost our sales. Therefore, a successful candidate will have a track record of converting leads into sales me...
I'm looking for a professional to help me fill out an Excel sheet for a financial model. The sheet will involve data from the Income Statement, Balance Sheet, Cash Flow, Operating Working Capital, debt, depreciation, amortization, equity, shares, and various financial ratios. The annual report is available for reference. Skills and experience required: - Extensive knowledge of financial modeling - Proficiency in Excel - Ability to interpret and analyze financial statements - Experience working with financial ratios - Attention to detail.
...storytelling. ✅ Add professional voiceover (or coordinate with a voiceover artist). ✅ Incorporate 3D elements and animations to enhance the narrative. ✅ Use stock footage, AI-generated elements, or other assets when necessary. ✅ Ensure smooth pacing, engaging visuals, and professional post-production. ### **Requirements:** ? Experience in video production and storytelling. ? Proficiency in editing software (Adobe Premiere Pro, After Effects, DaVinci Resolve, etc.). ? Strong understanding of cinematic editing and pacing. ? Knowledge of 3D animation techniques is a plus. ? Ability to source and integrate high-quality stock footage. ? Strong attention to detail and ability to match the requested style. ### **Preferred Qualifications:** ✔️ Experienc...
...Tableau dashboards, allowing users to ask natural language questions and receive relevant insights based on available data. Scope of Work: Chatbot Integration: Embed a chatbot within Tableau dashboards. GPT Integration: Enable the chatbot to process natural language queries and return relevant results based on the dashboard’s data. Predictive Analytics: Implement AI-powered forecasting for sales, stock, and performance trends. Scalability & Optimization: Ensure smooth performance even with large datasets. Multi-Dashboard Support: The chatbot should be accessible across different Tableau dashboards. Requirements: Proficiency in Tableau API and Extension development. Experience with OpenAI GPT integration. Strong understanding of data analytics and predictive modeling. F...
I'm looking for a freelancer who can build a comprehensive dashboard in Excel for tracking employee performance data. Key Requirements: - The dashboard should track 16 key performance indicators (KPIs) related to equipment conditions. - Visual elements should include charts, graphs, gauges, and meters. I already make it but need to enhance and also to add more slides. Ideal Skills: - Proficient in Excel with experience in building dashboards. - Understanding of employee performance and equipment condition metrics. - Capable of creating user-friendly, visually appealing dashboards.
...appointments. Your main responsibilities will include: - Data Entry: Accurately inputting information into Microsoft Excel/Word. - Email Handling: Managing my inbox, sorting emails, and responding to necessary correspondence. - Scheduling Appointments: Coordinating my calendar and setting up meetings. - Travel Arrangements: Booking flights, hotels, and transportation for business trips. - File Management: Organizing and maintaining digital and physical files. - Document Preparation: Creating and editing reports, presentations, and other documents as needed. - Meeting Minutes: Taking detailed notes during meetings and distributing them as needed. I prefer using Microsoft Excel/Word for task management, so proficiency in these programs is essential. Communication will pri...
I'm seeking an experienced ERPNext developer and manager to assist with the setup of our entire company's manufacturing processes on ERPNext. The primary focus will be on: - Inventory Management - Production Planning - Quality Control Minimal customization of the ERPNext platform will be required. The ideal freelancer will have extensive experience with ERPNext in a manufacturing context, and will be able to facilitate a smooth and efficient setup process. Only out of the box erpnext modules to be used.
...Skills in targeted advertising to increase product visibility and sales - Ability to segment audiences for highly targeted advertising and tailored messaging. - Skills in creating engaging and effective ad content, including graphics and copy. - Proficiency in using analytics tools to measure ad performance and provide detailed reports. - Experience managing ad campaign budgets to maximize ROI and control costs. Please provide examples of previous successful campaigns you have managed, as well as your proposed strategies for this project. The ad campaign will be run for a medium-term duration of 4-6 months. The ad campaign will operate within a medium budget range of $2000-$5000. The freelancer should provide detailed insights including audience behaviour, sales attribution, an...
We are looking for a Freelance Sales Telecaller who can call potential clients from a given database and assist them in opening Demat & Trading accounts with SMIFS Limited. Your role will involve explaining the benefits of stock market investments, handling customer queries, and guiding them through the account opening process. Sales target: 100 Account per Month Key Responsibilities: ✅ Call potential leads from the provided database to pitch Demat & Trading account opening. ✅ Explain the features, benefits, and process of opening a Demat Account. ✅ Address customer queries and objections effectively. ✅ Follow up with in terested leads and ensure successful account activation. ✅ Maintain call records and update the status of leads regularly. ✅ Work towards ac...
I'm looking for a freelancer who can analyze and format my sales data into a clear, tabular Excel report. Key Requirements: - Experience with Excel is a must, especially with data formatting. - Familiarity with sales metrics and how to present them in an informative manner. - Ability to meet deadlines and provide a high-quality, easy-to-understand report. The report will primarily focus on total sales, sales by product category, and sales by region.
I'm looking for a professional who can implement a synchronization between my Firebase Database and WooCommerce Rest API. The data to be synced includes product data, order data, and customer data on a daily basis. Key Responsibilities: - Implement daily synchronization of product, order, and customer data from Firebase to WooCommerce. - Ensure the process is efficient and doesn't slow down the system. Ideal Skills: - Extensive experience with Firebase and WooCommerce Rest API. - Strong understanding of data synchronization processes. Security: - We will discuss specific security requirements for the data sync, which may include data encryption, user authentication, and access control. You should be able to demonstrate a good understanding of data security protoc...
I'm looking for an experienced Excel professional to compile a calendar for 2025 and 2026. This will include marking work tasks and deadlines, 2nd & 4th Saturdays, Sundays and all Hindu holidays. Key Requirements: - Organize data week-wise in an Excel sheet - Distinctly mark 2nd & 4th Saturdays and all Sundays - Highlight all Hindu holidays and list them in a separate column - Use Conditional Formatting and Pivot Tables to ensure easy readability and proper formatting Ideal Skills: - Proficiency in Microsoft Excel (Formulas, Conditional Formatting, Pivot Tables, etc.) - Data Entry & Processing - Attention to detail - Experience handling large datasets Deliverables: - Well-structured Excel sheet - Clearly marked week-wise data - Properly high...
I'm seeking a meticulous Data Entry Operator to assist with inputting and structuring data into Microsoft Excel. The job will entail: - Transcribing data from a variety of sources including scanned documents, PDFs, and handwritten notes into an Excel spreadsheet. - Ensuring the accuracy of the data and catching any potential errors. - Structuring the data chronologically for easy access and retrieval. - Upholding confidentiality when dealing with sensitive information. Ideal candidates should have: - A good typing speed and a high degree of accuracy. - Proven experience with Microsoft Excel or other data entry software. - An exceptional attention to detail. - The ability to meet deadlines consistently. Project Duration: 1-2 weeks (potential for extension based...
I'm looking for a professional and corporate styled store to be set up on my WordPress account. The store will cater to a diverse range of products, including physical items, digital goods, and services. Key requirements include: - Proper creation and assignment of product tags - Uploading of product images - Implementation of PayPal as the sole payment method Ideal candidates for this project should have: - Extensive experience in WordPress - Ability to design in a professional and corporate style - Skills in product tagging and image uploading - Knowledge of integrating PayPal as a payment method. Please ensure your bid reflects an understanding of these requirements. Please consider the following: integrating WooCommerce or Shopify.
...Signup/Login with email or LinkedIn. Dashboard to post and manage job listings. View and filter candidate applications. Shortlist and contact candidates directly. 6. Admin Control Panel Oversee and manage job posts, user accounts, and reported content. Analytics dashboard to monitor user activity and engagement. Ability to manage recruiter approvals and verify job postings. System to handle disputes or flagged content. Technical Requirements Frontend: React.js or for a dynamic, responsive UI. Backend: Node.js with Express or Django for handling user authentication, job posts, and resume generation. Database: PostgreSQL or MongoDB to store user data and job listings. Authentication: OAuth (Google, LinkedIn) and email/password-based login. Security: SSL encr...
I'm looking for a skilled developer to create a Windows application that scrapes data from e-commerce websites and updates it in a CSV file. Key Responsibilities: - The app should monitor and record product prices, stock levels, and sale prices. - Data should be sourced from various e-commerce websites. - Updated data should be formatted and saved in a CSV file. Ideal Skills: - Proficiency in Windows application development. - Experience with web scraping tools and techniques. - Familiarity with data formatting and file handling, particularly CSV files.
I'm looking for a Quasar/Vue application that can display a user-uploaded PDF file and highlight words from an external list. I need to provide a list of words that will highlight the words in the viewer. Key features: - Users will upload a PDF file - user will enter a word in a Quasar input box that will be...the viewer programmatically. - This is a text search function within the application not the PDF viewer. Ideal skills and experience for the job: - Proficiency in Quasar/Vue - Previous experience building PDF viewer applications - Understanding of user interface (UI) and user experience (UX) principles knowledge of The application does not require any user authentication or access control features. The application does not need to support multi-language word high...
I'm looking for a talented writer with a solid background in trading and finance to help me create engaging content for a book focused on stock market investing. The primary target of this book is novice investors, but I also want it to be appealing to more seasoned traders. Key Requirements: - Draw inspiration from 'Stock Investing Mastermind' by ZebraLearn - Produce well-researched chapters that articulate complex concepts in an accessible manner - Include theoretical concepts and practical guides - Creativity and passion for trading is a plus - Provide writing samples of past financial content. If you have experience in writing and a keen interest in the trading world, I would love to hear from you! The desired length for the book is approximately...
...Ideal candidates for this project should have: - Extensive experience in payroll and tax form preparation. - Familiarity with W-2C forms and the reasons for their use. - Ability to work meticulously and maintain a high level of accuracy. - Demonstrated track record of precision and attention to detail in payroll tasks. The employee information will be provided in a digital format such as an Excel or Spreadsheet. The W-2C forms should be completed within 2 weeks. The completed W-2C forms should be provided in PDF format. You may use any software you are comfortable with for preparing the W-2C forms. The freelancer should also review the corrected wage information to ensure its accuracy. The freelancer only needs to prepare the W-2C forms. The selected freelancer will be respons...
...of data management, customer service, marketing performance tracking, and operational workflow. ? Key Responsibilities: ✅ Google Sheets Development: Design automated dashboards for business insights✅ Shopify & Automation: Sync Shopify data to Google Sheets using ✅ Demand Forecasting: Build SKU-specific demand forecasting models✅ Inventory & Supply Chain Tracking: Automate stock tracking for both raw materials & finished goods✅ Financial & Profitability Analysis: Track fixed/variable costs, discounts, shipping profitability, and payment gateway performance✅ Customer Insights & Demographics: Analyze order trends, geographic sales, and repeat customers✅ Error Handling & Troubleshooting: Identify and correct data discrepancies✅ Customer Service Data Int...
...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...
I require an Excel expert to streamline my weekly report process. This involves merging four distinct reports - Maintenance, Operations, Supply Chain Management (SCM), and Finance - into one comprehensive Excel spreadsheet. Key tasks: - Combine the four reports into one Excel sheet on a weekly basis. - Visualize the data trends over time using a bar graph. - Ensure the graph highlights the key trends across the four departments. - Automate the import of data from each of the four reports to reduce manual input. - Develop a dashboard in Excel that displays key metrics and trends in a user-friendly format. - Generate a weekly summary report that provides insights and highlights key findings. - Set up conditional formatting or alerts to flag any significant chang...
