Excel vba open csv file jobs
...reports and handle GMB setup tasks promptly. Excellent communication skills and attention to detail. Deliverables: Daily Report with 20–30 researched businesses, including key details and GMB optimization gaps. Fully optimized Google Business Profiles for clients, completed within agreed timelines. Budget: Monthly Budget: $300 (approximately $10/day for research and profile setup). Rate structure: Open to hourly or project-based payments within this budget....
I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.
I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics
I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice
My current ICTFAX installation on a Linux server has issues. While I can send faxes with...features, and user registration are not working correctly. The original service provider has become unresponsive, and I'm looking for an experienced professional who could either fix my existing setup or install a reliable open-source alternative on my server. Critical Features to Fix or Add: - Mail-to-Fax and Fax-to-Mail functionality - User Registration System I am open to both options - repairing ICTFAX or switching to a new web app. The ideal candidate for this job should have extensive experience with ICTFAX and Linux servers, as well as expertise in installing and managing open-source web applications. Please note that I am not interested in any contracted services o...
...camera ha bisogno di molti armadi per riporre i nostri vestiti, mi piacerebbe una soluzione ad ante scorrevoli dove si nasconde nell'ultimo metro una scrivania per lavorare in smart working. - La casa deve avere anche dei soppalchi posizionati in alcuni punti del controsoffitto per riporre valigie ecc. - Una disposizione open space per lo spazio abitativo. I candidati ideali avrebbero una forte esperienza nella progettazione architettonica moderna con un portafoglio di case open space. Il tuo ruolo comporterebbe la creazione di piani e visualizzazioni dettagliati, lavorando a stretto contatto con me per garantire che il progetto finale soddisfi la mia visione. Non ho molto budget per realizzare il lavoro quindi ho bisogno che non ci siano troppi lavori di falegnameri...
...House API () with a Microsoft Access database using VBA. The goal is to retrieve directors' and secretaries' names and store them in a table, using company numbers from another table. Below are the detailed requirements: Requirements: 1- API Connection Setup: Establish a connection to the Companies House API using VBA in MS Access. Let me know what API type and credentials for authentication are needed. 2- Data Retrieval: Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database. Ensure the data is accurately parsed and stored in a new table (Optional). 3- Automation: Develop a VBA script to automate the data retrieval process. Additional Notes: Include instructions on how to use
We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.
I need a logo for my welding and fabrication... reflecting the nature of the work we do. Key Points: - The design should be modern and sleek, while still embodying a classic and traditional rustic and industrial style. - Creativity is key, as I have not specified particular elements to include in the logo. However, the designer's understanding of the field may inspire the incorporation of relevant elements. - As for color scheme, I'm open to suggestions. However, a mix of metallic shades and earth tones could work well. Skills and Experience: - Proven experience in logo design, particularly in the industrial sector. - Strong understanding of both modern design principles and traditional rustic aesthetics. - Excellent communication skills for discussing design ...
I'm looking for a talented motion graphic artist to create an engaging video for my song cover. The final product will be used on both YouTube and Spotify, so it needs to meet the specifications for bo...final product will be used on both YouTube and Spotify, so it needs to meet the specifications for both platforms. Key requirements: - Experience in creating motion graphic videos, ideally for music - Understanding of the rhythm and mood of hip hop music - Ability to create visually captivating content that will hold viewers' attention on both platforms The exact style of the motion graphics is open to your creative interpretation, as I have not settled on a specific approach. I am looking for someone who can bring a fresh perspective and create a compelling video that c...
I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and DirectQuery modes.
I'm seeking a professional who can assist me in migrating my e-commerce site from WooCommerce to a better platform. The current WooCommerce platform has become bloat...who can assist me in migrating my e-commerce site from WooCommerce to a better platform. The current WooCommerce platform has become bloated with too many plugins, which has led to performance issues. I need a new platform that is efficient, easy to navigate, and doesn't require excessive reliance on plugins. We are considering these options : 1.) Hydrogen by Shopify 2.) Sylius 3.) BigCommerce Open SaaS (Headless Option) 4.) OroCommerce If you have others we will consider those also. ALL options MUST be self hosted ! I am looking for a professional who can deliver a high-quality, efficient site that meets...
I'm seeking a top-tier web designer to cre...provide: - Expert-level design capabilities - Strong web development skills - Understanding of SEO principles (for geo-specific targeting) - Ability to deliver high-quality work that can be showcased in your portfolio. The gallery section will need to be flexible and adaptable, potentially incorporating features like a slideshow view, grid view, and zoom-in functionality for the artwork, though I'm open to your professional recommendations. The main focus is on design, but I also require comprehensive SEO support and Google My Business setup. Your ability to deliver 'everything that's asked of and more' is essential for this project. This is a unique opportunity to demonstrate your top-tier talent and create a...
I'm nearing the completion of a Dotnet core application designed to send prompts to an Open API and retrieve responses in HTML format for a viewer. I need some assistance with the final touches. - Main Task: - I need help primarily with the integration of the application with the Open API, specifically focusing on error handling and retry logic. - API Details: - The Open API I am working with is a RESTful API. I am looking for someone who is experienced with Dotnet core and has a strong understanding of RESTful APIs. Prior experience with error handling and retry logic in API integration is a plus. Your help will be invaluable in ensuring the final product is robust and reliable.
Please Sign Up or Login to see details.
...Amazon PAAPI, eBay API, or AliExpress product data extraction. Knowledge of automation tools like Zapier or Make (Integromat). Strong understanding of affiliate marketing workflows. Preferred Skills: Experience with Python or other scripting languages for API integrations. Knowledge of Odoo’s XML-RPC or for custom integrations. Ability to suggest and implement scalable solutions. Budget: Open to discussion based on experience and proposed solution. Timeline: ASAP If you have the skills and experience to deliver this project, please submit your proposal with: Examples of similar projects you’ve completed. Your proposed approach and tools. Estimated timeline and cost....
I have a project in CodeIgniter that was running perfectly, but now it's giving some errors. - Authentication emails aren't sending. - Emails aren't working. - Bulk upload of CSV files aren't working (Some Socket Issue In Network Tab). The application is installed on a VPS and I am using CWP Panel. Therefore, I need an expert in CodeIgniter who is also familiar with CWP Panel. Please type "CI" at the top of your bid so I can see you aren't a bot. Thank you.
I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.
...me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experience with QI projects - Ability to presen...
...Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week to start, with the potential to scale up. Budget: Open to proposals (please specify your hourly rate or fixed-price options). Preferences: Experience Level: Intermediate to Advanced. Location: Can work...
I'm looking for a unique, custom design for my lake home. The key elements of this project include: - A design style that blends seamlessly with the natural lakeside environment - An open floor plan to maximize the use of space and encourage a free flow between different areas of the home The home should feature: - Large windows that offer stunning views of the lake and allow plenty of natural light to fill the home - main floor living with second floor guest space - attached garage with both lakeside and roadside access - maximum of 40 feet wide Ideal candidates for this project should have: - Extensive experience in home design, particularly with lake homes - Experience designing for small or narrow lots that maximize living space - A keen understanding of how to incorpor...
Freelance Opportunity: AP Script Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and id...
...fields: Auto-filled: Requester Name, Department, Date & Time, Sequential Request Number (per department). User Inputs: Area (dropdown, multi-selection) Line (dropdown, multi-selection, filtered by Area) Room (dropdown, multi-selection, filtered by Line) Equipment (dropdown, multi-selection, filtered by Room) Priority Level (dropdown, single selection) Description (text field) Attachment (optional file upload) All fields (except attachment) are mandatory. Approval Workflow: Requests are submitted by any user but require approvals as follows: Department Manager: Approve, Reject, or Comment (send back to requester) Editable approval Engineering Manager: Approve, Reject, or Assign to Section Head (with auto-tracking of assignment date/time) Notifications for approvals/rejections...
I am looking for a professional contractor to link my bedroom ensuite with my house via a covered walkway. The link does not require a door into the courtyard. Key Specifications: - Type of Connection: The connection should be a covered walkway with flat roof. - Material: The walkway should be constructed predominantly with glass or in wooden joinery or open to ideas. - Style: It should adhere to a modern aesthetic. The ideal candidate will have extensive experience in designing and constructing modern, high-quality glass structures. A keen understanding of safety standards and building regulations is essential. A portfolio showcasing similar projects will be advantageous. The successful bidder will be able to deliver a structurally sound, visually appealing internal walkway th...
We are looking for a Full-time independent Node/React js freelancer with the following skill set for one of our clients. SUMMARY: - Over 6.5 years of professi...Created Typescript reusable components and services to consume REST APIs using Component-based architecture. TECHNOLOGIES: Node.js | Angular | React.js | | Java script | TypeScript DATABASE SQL | PL/SQL| MySQL | PostgreSQL | MongoDB | Amazon DynamoDB PM TOOLS: GIT | SVN | JIRA Monthly Remuneration: INR 75-80K Duration : 3 Months with very high possibility for extension. You should be open for an interview with a highly technical CTO. Please apply with your complete profile & examples of your best work. This position is ONLY for Full-time freelancers based in India. Agencies please don't waste your & o...
I'm looking for a QuickBooks Online expert to assist with matching over 201 open bills to transaction ledgers. The task involves handling multiple currencies as well. Ideal Skills and Experience: - Proficiency in QuickBooks Online - Experience with bill matching - Familiarity with multi-currency transactions - Attention to detail - Timeliness and efficiency
I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.
I'm seeking assistance with modifying a flat file database. The task primarily involves updating existing records. This is a one-time project.
13 Editable supplement labels in Photoshop files, fully open with all aspects editable.
Looking for a Python programmer to do the following: User will press a button. program will activate an output that will turn off at a preset time by the system (Regardless if the user continues to press in the input) The system will then wait a preset time before it will allow the input to activate the out put. Example: Preset on time := 10 Sec. (This should be a retentat...the user presses the input or 'on time' (10 seconds has been reached) The user can try and press the input in after this but the output will not turn on. until the wait time has reach. Every time they press the input the system will log date and time. Every time the output is on the system will log duration, date and time This will need to be exported to a database where it can be retrieved in a CSV...
I'm looking for someone to develop a practical file for a BTech Computer Science and Engineering workshop. The file will be primarily for educational purposes. Key Components of the Practical File: - A well-structured written section that includes theory explanations - Diagrams relevant to the workshop content - White blank pages for additional notes or observations - Diagrams that will help visualize complex concepts Ideal Freelancer: - a strong background in computer science and engineering - Excellent writing skills - Experience creating educational materials
I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience
I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets
...Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer selecte...
I'm looking for an expert Java developer who can assist me with a project focused on creating a specific web application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Res...implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets meeting the topic lsited in the excel sheet but at the same time implementing the skills and knowledge toward completing the assignment. Please only contanct me once you go through the assignment and the excel...
...tools (we prefer After Effects). - Ability to create custom graphics and storyboard designs. - Strong skills in adding music and sound effects to elevate the video. - A creative and collaborative mindset with attention to detail. - A portfolio showcasing your best work, particularly custom animated videos. WHAT WE PROVIDE - A detailed script and professional voiceover. - Clear instructions and open communication to ensure smooth collaboration. WHAT WE ARE LOOKING FOR - Individuals or teams with a passion for creating visually stunning, engaging animated videos. - Commitment to meeting deadlines and delivering high-quality work. - A willingness to establish a long-term working relationship for future projects. THE QUALITY WE EXPECT https://www
...enter the details of a new opportunity Required fields: title (string) description (text) status (enum: Open, In Progress, Closed) customerName (string) opportunityType (enum: Help Request, Handover, Cover Request) startDate: (timestamp, applicable to Handover and Cover Request only) endDate: (timestamp, applicable to Cover Request only) createdAt (timestamp, auto-generated) updatedAt (timestamp, auto-generated) List Opportunities A table or list displaying existing opportunities Each item should show the title, status, customerName, type, and createdAt. In addition it should be possible to see the full details of an opportunity. Update an Opportunity A way to change an opportunity’s status (Open → In Progress → Closed) Bonus Features (Optional but Encourag...
I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)
I need a professional who can help me extract data...POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fees itemized separately. This is essential for my accoun...
I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets
...protection for data privacy. • Ability to switch profiles within the app. 6. Third-Party Integration: • Integration with Google Fit, Apple Health, and potentially Strava. 7. Social Sharing: • Generate shareable summaries of activity and achievements. • Optional integration with social platforms (e.g., Instagram, Facebook). 8. Data Export: • Export health and activity data in formats like CSV and PDF. 9. Future AI Integration: • Enable personalized insights using AI for health improvement and activity optimization. Technical Requirements • Use the SDK provided by the smart ring manufacturer, which supports Flutter and both iOS and Android platforms. • Ensure secure storage and handling of health data, adhering to GDPR standards....
...in need of an engaging, whimsical, cartoonish-style mural featuring local historic buildings (Glen Echo Park in Glen Echo, Maryland). This mural is to be used for an invitation for our annual fundraising gala. Key Aspects: - Style: The mural should be cartoonish, not overly realistic or abstract (please see attached) - Content: It would be a map of about 7 buildings in the park, with the center open for invitation copy - Color Scheme: The mural should predominantly use cool tones, such as blues, greens, and purples. The theme is Midsummer’s Night Dream (so lots of trees, flowers and fairies throughout). Ideal Skills and Experience: - Proficiency in mural design and illustration. - Experience in creating cartoonish-style artwork. - Good understanding of local historic bui...
...contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who can help prepare a comprehensive Excel workbook that includes all necessary formulas for financial analysis across various aspects of...
I'm looking for a professional teste...my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and Scrum for project management. Experience with secur...
I'm currently developing an iOS app that leverages the Screentime API and Family Controls. This app involves tracking usage, implementing parental controls, and setting up app restrictions. I'm seeking a seasoned Swift developer who can help troubleshoot coding issues and assist with the setup of specific code segments on a pay-per-qu...optimize performance and address any potential coding issues. Ideal Candidate: - You must be an expert in Swift, with extensive experience in Xcode and iOS development. - Prior experience working with the Screentime API and Family Controls will be a significant advantage. - You should be able to assist with bug fixing, feature implementation, and performance optimization. I'm keen to maintain an open tab and pay as queries arise. I l...
...management features to view, edit, and update customer orders, assign orders to delivery agents, and manage products by adding, removing, or editing listings. There should also be tools for delivery management, such as notifying agents of assigned orders and allowing them to update the status of deliveries. Reports and analytics should be available for sales data, with an option to download reports in CSV format. Additionally, a mobile-friendly delivery agent portal should be created to let agents view their assigned orders and mark them as delivered. For the technical specifications, I prefer using PHP for the backend, with Laravel or CodeIgniter as the framework. The frontend can be developed using HTML, CSS, and JavaScript, with Bootstrap for responsiveness. MySQL should be u...
...within the Priority Pass network of lounges) The compiled data will be delivered in a well-organized CSV file, suitable for analysis and integration into other platforms. Scope of Work: - Conduct thorough online research using search engines and reliable travel resources to identify airport lounges globally. Collect key information for each lounge, such as: - Lounge Name - Airport Name & 3-Letter Airport Code (IATA) - Terminal and other location details - Access Type (e.g., airline-specific, membership programs, or pay-per-use) - Operating Hours - Amenities and services offered - Ensure all data is accurate, up-to-date, and categorized appropriately. Deliverables: - A structured CSV file containing the compiled lounge data, with columns clearly labe...
...communication skills in Hindi and English. Creative thinker who can suggest unique promotional strategies. Able to meet tight deadlines and manage multiple tasks efficiently. Duration: This will be a project-based role starting immediately and continuing until two weeks after the release of the music video. If this collaboration is successful, I plan to work with you for future projects as well. Budget: Open to negotiation based on experience and results. Please provide your rates for this project. How to Apply: Send me your portfolio or examples of successful music/entertainment PR campaigns you’ve managed. Mention any media contacts or platforms you can access. Share your proposed PR strategy briefly for a Hindi music video launch. Looking forward to working with a pas...
I am looking for a professional freelancer to help me with my project. The specifics of the project haven't been detailed yet, but I am open to discussing potential options.