Sas excel jobs

...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...

I can write code in VBA for moving rows (orders) from one sheet to the next upon entering specific data in a cell or any other event. Client will explain the rules for moving data in each particular sheet.

I have a CSV/Excel file containing product prices that I need adjusted. All product prices need to be increased by 20%. If the price is $0 then do not update and leave it at $0.

Architectural design - ongoing work: Architectural design of Self storage building and associated infrastructure. Software: • Revit 3D modelling • Lumion Rendering • Autocad • Excel Skills: • Experienced in architectural drafting and design • Knowledge and experience with Australian codes and standards • Full architectural drawing sets including: • Ability to create comprehensive fire safety and evacuation plans • Designing for energy-efficient and sustainable construction o Site plans o Self-storage unit layouts o Floor plans o Elevations o 3D views o Sections o Landscape plans o Traffic management plans o Window and door schedules o Cut and fill plans o Demolition plans o Office and amenity fitout o Construction details • Conve...

...connections. Target Audience: Businesses in Mississauga and the GTA, including but not limited to: ✅ Plumbing companies ✅ Electrical contractors ✅ HVAC companies ✅ Landscaping services ✅ Roofing companies ✅ Delivery & logistics businesses ✅ Mobile auto repair & detailing services ✅ Any business with fleet vehicles Deliverables: The freelancer will provide a detailed, organized list in Google Sheets or Excel, including: ? Business Name ? Industry Type ? Company Address ? Contact Person (Owner/Manager/Decision Maker) ? Phone Number ? Email Address ? Company Website Requirements: ✔ Proven experience in B2B lead generation ✔ Ability to source verified, up-to-date contact details ✔ Familiarity with Mississauga/GTA business landscape is a plus ✔ Strong research skills & a...

I need a professional to test my VBA on MAC. You will be testing for macro execution, user interface elements and data processing on MAC as we develop on PC but have mac clients. Skills: - Proficient in VBA - Experienced with testing/running VBA on MAC - Excellent problem-solving skills.

...newcomers from various countries seeking health insurance in Switzerland. Ideal Skills and Experience: - Proven experience in data entry - Familiarity with public services preferred - Ability to handle sensitive data with confidentiality - Experience with database management - Attention to detail and accuracy - Knowledge of health insurance processes and terminologies The data should be entered in Excel format. The project will involve entering between 100 entries for the beginning. The project should be completed within the shortest possible timeframe. Please include the following data validation requirements: newcomers coming in Switzerland and requiring health insurance. The data should be organized by the newcomer's country of origin. Please include accuracy checks ...

I'm looking for an expert in Excel to assist me with some formulas related to numerical data. The primary goal is to help me with summing and averaging calculations.

I'm in need of an Excel expert who can assist with fixing my spreadsheet and importing a proposal sheet. Specific tasks include: - Creating templates - Inserting data - Design and layout I'm experiencing some issues with my current spreadsheet that have not been resolved, so I would also appreciate a review of this. Ideal candidate should be proficient in Microsoft Excel, have experience with spreadsheet troubleshooting, and capable of assisting with proposal sheet preparation.

I'm seeking a native professional translator to translate an English text into Arabic (KSA). The text contains a list of 870 words linked to DIY tools, with a 27 % repetition rate. The lists are marketing phrases intended for the web and tools for professionals (like grinders, drills, hammers, etc.). Deliverables: - The translated text must be delivered in an Excel spreadsheet + SDLXLIFF (or TMX). - The job has to be completed by Friday, 7th, at 17:00 CET. Tone: - The translated marketing phrases should have an informal tone. Terminology: - There are no specific terminologies or keywords that need to be kept in English. Ideal Skills: - Strong proficiency in English and Arabic (KSA) - Experience with translating technical and marketing content - Familiarity with DIY tools...

I require a proficient web scraper to gather contact details from websites. The final data needs to be formatted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in web scraping tools and techniques - Experience in data collection from websites - Ability to organize and format data into Excel - Attention to detail to ensure data accuracy

I need an expert in Excel to help automate calculations and report generation for my civil engineering projects. Key Tasks: - Automating calculations: This includes a variety of mathematical operations and civil engineering specific calculations. - Streamlining report generation: I want to simplify the process of creating reports from the data and calculations. Ideal Skills: - Proficiency in Excel: You should have advanced knowledge of Excel, including familiarity with its more complex functions and tools. - Civil Engineering Expertise: A strong understanding of civil engineering principles and calculations is crucial. - Automation Skills: Experience in automating tasks in Excel will be key to the success of this project. Please provide examples of similar p...

I'm looking for an Excel expert to create a daily fantasy sports sheet for basketball. This sheet should include current season player statistics, as well as an optimal lineup complete with captain and vice captain. Key Requirements: - Proficiency in Excel - Understanding of basketball and daily fantasy sports - Ability to source and incorporate up-to-date player statistics Ideal Skills: - Data analysis - Fantasy sports strategy - Excel VBA (for automation) Please note, this project is focused solely on the current basketball season.

I need someone to help me with data entry on my WordPress site. The task involves transferring data from another site into my WordPress site. The job involves 600 products, specifically car wrap films. Dat...my WordPress site. The job involves 600 products, specifically car wrap films. Data to be transferred includes: - Product descriptions - Price variations - Product Images I have some images, but will need assistance in sourcing additional ones. The data from the source site is in a CSV/Excel format. Ideal skills and experience for this job: - Proficiency in WordPress - Excellent data entry skills - Experience with product data entry - Ability to source product images - Familiarity with handling CSV/Excel files. Please ensure you have the necessary skills before bi...

I need assistance with entering mixed data (both text and numerical) from scanned documents into an Excel spreadsheet. The data does not require any specific formatting and can be entered in a standard table format. Ideal skills and experience for the job: - Proficient in Excel - Detail-oriented - Experience with data entry - Ability to transcribe information accurately from scanned documents

I'm looking for a detail-oriented freelancer to assist with a simple data entry project. The task involves copying text data from a digital Excel file into online database records. Ideal Skills: - Proficiency in Excel - Attention to detail - Good understanding of text data - Ability to maintain data confidentiality Experience: - Prior data entry experience preferred - Familiarity with handling digital files Other: - Can perform duties during normal Mountain Standard Time working hours - English-speaking Please bid if you can meet these requirements. Thank you.

I have 15 Excel documents containing survey data tables. Each document has multiple tabs with tables. You will need to: - Format all tables uniformly, ensuring they have the same headers and layout - Set the headers to be bold and centered - Adjust the tables to have uniform column widths After formatting, please return the files as: - A neatly formatted Excel document - A merged PDF of all the tables Ideal candidates for this project should have: - Strong Excel skills and experience with data formatting - Attention to detail to ensure all tables are formatted identically - Ability to create a merged PDF from Excel Please note, the headers should be bold and centered, and all tables should have uniform column widths. Ensure the table font style is uniform ...

I'm looking for a web scraping expert who can extract Over/Under lines (all lines , not only the main one) for all MBL (Baseball) and NHL (Hockey) games from the past 5 seasons. The data should be delivered in an Excel (XLSX) format. Key Requirements: - Expertise in web scraping - Proficient in data handling and Excel - Familiarity with MBL and NHL data - Ability to extract specific betting lines The ideal freelancer for this project would be detail-oriented, with a proven track record in web data extraction, particularly in the sports and betting domain. The ultimate goal is to get comprehensive, clean data for analysis.

I'm in need of a male who speaks Telugu and Hindi fluently. Your job will be to call various barber shops in Hyderabad and gather information about their services, specifically service names and pricing. This will include: - Understanding and noting down the different services offered, such as hair cuts, shaves, head mass...include: - Understanding and noting down the different services offered, such as hair cuts, shaves, head massages, etc. - Inquiring about the pricing for these services Once you have collected this data, you will need to upload all of it to the admin panel of my web app. This will involve: - Manually inputting each detail The ideal candidate should be comfortable with: - Data entry - Working with Excel - Using Google Experience in similar tasks will b...

...or loss, and the system finds the price differences in BTC at different time frames to create a supposed buy or sell at a certain past existing price to reach that goal. • The system will recreate a past possible operation to achieve the desired profit or loss goal, considering long or short trades. • The results should reflect the reality of the markets and can be realized with a formula in an Excel sheet. • The trade results should appear in the client's portfolio in BTC, ETH, and other cryptocurrencies. • Profit and losses should appear in EUR, USD, and BTC and be added or deducted from the client's account. • It should look like past existing trading, increasing or decreasing the portfolio value. • The account should show the invested m...

...pipeline for Excel uploads, and provide a management interface for querying the data. Requirements 1. Azure SQL Database Setup Deploy an Azure SQL Database (PaaS) instance. Create three tables using data from provided Excel sheets. Define appropriate data types, constraints, and indexing for optimised performance. Provide SQL scripts for table creation and initial data import. 2. Azure Virtual Machine (VM) for Management Provision an Azure Virtual Machine (Windows-based) to serve as a management server. Install and configure Microsoft SQL Server Management Studio (SSMS) for querying the database. Ensure secure remote access via RDP with proper firewall rules. 3. Data Pipeline with Azure Data Factory (ADF) Set up an Azure Data Factory (ADF) pipeline to upload and process...

I have a Word document containing names, emails, numbers, specialties, subspecialties, states, and cities. I need this data entered into an Excel spreadsheet with separate sheets for each category. Key requirements: - Proficient in Excel and data entry - Attention to detail to ensure data is accurately transferred - Ability to organize data into separate sheets by category

...involve using Excel Solver to tackle various complex problems related to inventory management and demand forecasting. Key Objectives: - Apply linear programming and integer linear programming models to optimize and simulate supply chain scenarios. - The primary goals are to minimize costs, maximize efficiency, and optimize resource allocation. Constraints: - The model must account for various budget, capacity, and time constraints. Ideal Skills: - Proficiency in Excel Solver and mathematical modelling. - Strong understanding of supply chain management, particularly in inventory management and demand forecasting. - Expertise in linear programming and integer linear programming. - Ability to work within specified constraints. Experience: - Proven track record of using ...

I am in need of an advanced Excel developer to create a sophisticated spreadsheet for budgeting purposes. The spreadsheet should have the following features: - Revenue forecast - Budget variance analysis - Deal profitability and margin assessment - Expense tracking: Monitor and categorize all expenses with ease. - Break-even analysis: Calculate the break-even point for budgeting purposes. The spreadsheet will primarily handle manual data entry. The ideal freelancer for this project should have extensive experience in developing complex Excel spreadsheets, particularly for budgeting. They should also be adept at creating user-friendly interfaces for manual data input. Knowledge of financial modeling and data analysis will be a plus.

...Data: I have some initial data and calculations prepared, but it's only partial. - Explanation: I require both steps and final results to be explained to me. Ideal Skills and Experience: - Proficient in Excel and familiar with 2023 National Building Code, Alberta Canada Edition. - Experience in dealing with thermal and structural calculations. - Ability to explain complex concepts in a simple, understandable way. - Hands-on experience with building projects. This is an urgent task, and I would appreciate swift responses. Thank you. The final deliverables should be provided in an Excel spreadsheet. Please provide written explanations of both the steps and final results in a supporting document. The supporting document should contain an in-depth explanation of step...

...ability to handle various data tasks efficiently. Key Responsibilities: - Inputting inventory data into spreadsheets and databases. - Identifying and rectifying any errors in the data. - Organizing and updating records on a daily basis. - Ensuring all information is handled with the utmost confidentiality. Skills Needed: - Proficient typing speed and accuracy. - Basic understanding of Microsoft Excel and Google Sheets. - Exceptional attention to detail. - Self-sufficient and able to work independently. Qualifications: - A high school diploma or equivalent is required. - Previous experience in data entry is not necessary, but it will be advantageous. Ideal candidates will be reliable, trustworthy, and able to maintain privacy of sensitive information. The work will involve da...

I'm looking for a freelancer who can independently manage and accurately transfer information from various sources into an Excel spreadsheet. The specific sources will include paper documents, spreadsheets, and online forms. The ideal candidate should have experience with data entry, attention to detail, and proficiency in Excel. Key Skills Required: - Data entry - Excel proficiency - Attention to detail

...of customers, orders, and inquiries, enabling quick management. Manage Product Catalogue/Categories: Allows the admin to add, edit, delete, search, and filter product categories. Manage Product Items: Enables the admin to manage all products, including adding, editing, deleting, searching, and filtering. Manage Customers: Provides tools to add, edit, delete, import/export customer details (Excel format), view related orders/payments, search and filter customers, and view all chats. Coupon Code Management: Allows the admin to create and manage coupon codes. Account Settings/Logout: Admin account settings for notifications, password changes, and logout. B. Order and Shipping Management: Manage Shipping: Provides tools to view related orders/payments, search and filter,...

I have an Excel with 5 soccer leagues and I would like the games and the position in the classification of each team to be updated every day. It would be to associate Excel with the Internet and refresh the sheet with a button. My budget is 15 euros.

I need assistance with data entry, specifically handling numerical data sourced from online databases. The specific format for the entered data will be confirmed later but it is likely to be an Excel spreadsheet or a CSV file. Ideal Skills: - Proficiency in data entry - Experience with numerical data - Familiarity with online databases - Attention to detail - Ability to work efficiently and accurately

...and detail-oriented freelancer skilled in MS Excel for manual data input and preliminary data cleaning. Key Responsibilities: - Manual data input: Accurately transcribing data into Excel spreadsheets. - Data Cleaning: Primarily focused on removing duplicates from the dataset. Ideal Skills: - Proficiency in MS Excel - Strong attention to detail - Experience with data entry and data cleaning tasks The dataset is expected to have up to 1,000 rows. The project should be completed within a week. Please ensure data formatting to meet specified standards. Please follow common data formatting practices for clarity and consistency. No additional data cleaning tasks are required other than removing duplicates. The final output should be provided in an Excel workboo...

I'm looking for an expert who can integrate AI logic into Excel to automate complex calculations and enhance my Excel sheet's capabilities. The project primarily revolves around automating tasks with the help of AI. Key Requirements: - Expertise in Excel and AI - Proficiency in automating complex calculations - Experience in integrating AI logic into Excel - Experience in integrating machine learning models into Excel - Experience in creating custom functions in Excel - Familiarity with optimization algorithms and their implementation in Excel - Proficiency in scripting or programming languages such as Python or VBA In addition to the automation, I would also like the AI to assist in optimizing certain functions or formulas, sp...

I'm in need of a spreadsheet that can effectively track employee tasks. The spreadsheet should include the following details for each task: - Assigned...details for each task: - Assigned Employee: It should be clear who is responsible for each task. - Name of Task: A column for the name of the task. - Notes: A space for any relevant notes about the task. - Ongoing: A column to indicate whether the task is ongoing. - Link to SharePoint: A space for a link to the relevant SharePoint page. The ideal freelancer for this project should be proficient in Excel and have experience creating spreadsheets for task tracking. They should also be able to create a user-friendly, intuitive layout. The spreadsheet should also be repeated for 2026 etc at the bottom so we can track matters tha...

I'm looking for someone to help with a data entry task. The data will need to be entered into an Excel spreadsheet.

I need an expert in MySQL for data analysis. The primary focus is descriptive analysis using data from CSV/Excel files. Key Responsibilities: - Analyze data from provided CSV/Excel files using MySQL. - Conduct descriptive and predictive data analysis to extract insights. Ideal Skills: - Proficiency in SQL. - Strong background in data analysis, particularly descriptive analysis. - Experience working with data from CSV/Excel files.

I'm looking for a skilled designer who can convert an existing Excel line graph into a more visually appealing format using a specific colour template. Additionally, I need another graph, which is currently an image, to be redrawn and converted into the same colour scheme. Both graphs need to be delivered as new images compatible for inclusion in a Canva document, with a transparent background mask Key Requirements: - Convert an Excel line graph and an existing image of a graph into a format (note I have roughly done this so just needs to be redrawn properly using consistent line weights etc) - Implement a specific colour template using multiple Hex codes that will be provided - Make both graphs the same width/height (ie: same size) - Deliver final images in JPEG form...

I'm looking for an Excel Power Query expert who can assist me loop functionality needed asap . - Proficient in Excel and Power Query - Experienced in data transformation tasks - Ability to create calculated columns Please include your relevant experience in your bid.

I'm looking for an expert in AWS and data processing to create an automated system for generating and sending extensive Excel reports based on credit card transactions data stored in an S3 datalake. Key Requirements: - Extract and process data using AWS Lambda - Generate 40 comprehensive reports on a weekly basis - Implement extensive data transformations and aggregations into the reports Ideal Skills: - Proficiency in AWS, particularly S3 and Lambda - Strong experience in data processing and transformation - Excellent skills in Excel - Prior experience in generating automated reports

I'm looking for a skilled VBA expert to assist with Excel automation. Key Responsibilities: - Automate data entry processes - Implement custom data validation rules Ideal Candidate: - Proficient in Excel and VBA - Experienced with creating and implementing custom validation rules - Able to deliver efficient, streamlined automation solutions

Doing a database search for the selected databases and sending an excel sheet containing the search results

...should be compatible with both Android and Windows, and the primary purpose of this service is for backup and restoration of my files. Key Requirements: - Cloud Storage: The main function of the software will be to backup and restore my files securely. - Automatic Backups: The software should come with a feature that allows for automatic backups at set intervals. - Data Management: I have an Excel sheet filled with data that I want to manage through this app or software. The data should be converted and organized into a database that I can easily navigate and manipulate. Ideal Skills and Experience: - Proficiency in software development for both Android and Windows. - Experience with creating cloud storage solutions. - Ability to design user-friendly interfaces for data manage...

...- Assist in preparing consulting reports and presentations for healthcare clients. - Analyze data to identify business growth opportunities. - Support client projects with detailed research and strategic recommendations. **Requirements:** - Pursuing/completed a degree in Healthcare Management, Business, or Analytics. - Strong analytical and problem-solving skills. - Proficiency in Excel, PowerPoint, and data visualization tools. **What You’ll Gain:** - First-hand experience in healthcare consulting with AI integration. - Training on business scaling strategies using data-driven insights. - Internship certificate and performance-based reference letters. --- ### **Whiz Tech Internship Policy (Key Highlights)** 1. **Unpaid Internship:** All roles a...

...intake with calories , exercise, weight etc 2) Booking tickets and cancellation 3) Arranging parties etc. I would like to start with Tracking nutrition. In this task, Myself and Wife will share audio notes of the food we took , screenshot of exercise app , etc and this needs to be tracked on an excel sheet ( along with calorie input etc) on a daily basis. We can keep sharing this on a whatsapp group and at the end of a day (or every 2-3 days) the excel sheet needs to be updated. I will share a sample excel sheet we use for calorie tracking , calorie value will be there for the usual foods we take in that sheet. For new ones you need to use websites like nutritionix or apps like healthifyme to get the information. For Body weight tracking - We will share photos of...

We need an excel fully automated document for the insurance industry that can carry out the following system functions: 1) Excel to receive a word presentation from admin staff for 1 products called Rural Combined which will will contain a lot of data e.g. policyholder details, risk information e.g. names, dates of birth, property information, (risk addresses, sums insured), claims. 2) the risk information is extrapolated from the word (presumably into a CSV file and automatically driven into an excel rating calculator where it will undergo a number of functions to calculate a premium based on a set underwriting criteria where there will be rates built into the system The document will then produce a premium. 3) The information can then be merged back into a word ...

...personal assistant/accountant for my engineering company. This role involves a blend of administrative and financial responsibilities. Key Responsibilities: - Managing schedules and appointments - Handling financial records and bookkeeping - Processing invoices and payments - Preparing and submitting expense reports Essential Skills: - Proficiency in accounting software, particularly QuickBooks and Excel - Excellent organizational skills - Strong communication abilities -Familiar with google drive/sheets/earth Experience in the engineering sector would be a plus, but not necessary. What is crucial is your ability to handle the finances of a growing company with precision and professionalism. Role is for one big data entry project to start along with 1-2 hours a day of on-goin...

I'm in need of a data entry expert who can assist me in compiling and entering mixed data sourced from online databases into a database. Ideal Skills and Experience: - Proficient ...a focus on mixed data (both numeric and textual) - Experience working with online databases - Familiarity with database software and tools - Detail-oriented with a strong focus on accuracy - Able to manage time effectively to meet deadlines - Experience in querying databases using SQL or other querying languages - Strong skills in data cleaning and preparation - Expert proficiency in Microsoft Excel or Google Sheets for data manipulation Your role will involve: - Sourcing mixed data from various online databases - Accurately entering this data into a database The expected volume of data to be pro...

I'm seeking an Excel expert who can help me create a spreadsheet for analyzing viewing and analysing our machine assets and what stage of 'hire' they are on. Should have the ab ability to pick an asset and see the next 6-12 months, or pick a month, set of month, have one view of all assets etc Key Tasks: - Design a user-friendly Excel spreadsheet tailored for viewing and analyzing - Focus on tracking the 'Asset Hire Status'. The ideal freelancer should have: - Extensive experience with Excel, particularly in designing spreadsheets for data analysis. - Strong understanding of operational metrics. - Ability to create a spreadsheet that can track specific metrics effectively.

...methodical approach ensures that all data is correctly inputted and organized. - Data Cleansing: I can enhance the quality of your data by identifying and correcting errors, ensuring consistency and reliability in your datasets. 2. Excel Proficiency - Advanced Excel Skills: I possess extensive knowledge of Microsoft Excel, including advanced functions, pivot tables, and data visualization techniques. This allows me to not only input data but also analyze and present it effectively. - Macros and Automation: I can streamline data processes through automated solutions using Excel macros, saving you time and reducing manual errors. 3. Attention to Detail - Thorough Review Process: I am meticulous in my work and perform multiple checks to ensure completeness an...

...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'm seeking a skilled mobile app developer to create an iOS application to manage my loan business. The app should handle various loan parameters and client data,...automate calculations and notifications. Key Features: - Client data management - Loan amount tracking - Interest calculation - Timeframe for repayments - Notification system for due payments - Investor tracking for each loan - Capital totals for investors - Monthly interest calculations for each investor - Active/settled loan status toggle - Automatic Excel database updates Ideal Skills: - iOS App development - Database management - Excel integration - Notification system implementation - Financial software development experience The app should support manual data entry. Please note that I want this ap...