Vba excel scripts collection työt
...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...
...: (403) <!doctype html> <html> <head><meta charset='utf-8'> <title>Error • Udemy</title> </head> <body> Forbidden <script>(function(){if (!) return;var js = "window['__CF$cv$params']={r:'885cdcdf3f9f9180',t:'MTcxNjA0NTk1Ny4wMzIwMDA='};_cpo=('script');_cpo.nonce='',_cpo.src='/cdn-cgi/challenge-platform/scripts/jsd/',('head')[0].appendChild(_cpo);";var _0xh = ('iframe'); = 1; = 1; = 'absolute'; = 0; = 0; = 'none'; = 'hidden';(_0xh);function handler() {var _0xi = || ;if
For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!
I need an individual from Mexico City who can conduct a comprehensive market research focusing on the black beans industry. The research will cover a...current distribution networks, challenges, and opportunities. - wholesale market of agricultural products - Agricultural supermarket - Ideal Candidate: - Located in Mexico City for on-ground research. - Strong background in market research and analysis is a plus. - Understanding of the food industry, specifically beans, is a plus. - Proficient in Spanish and English for accurate data collection and reporting. - Excellent communication skills to interact with different stakeholders. This is a part-time position with a flexible schedule, suitable for an individual who can dedicate time to this project alongside other co...
I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.
I need a freelancer to design and administer a survey aimed at collecting statistical data from university students. The mai...and student engagement. Your responsibilities: - Design a survey that comprehensively captures information about students level of engagement when technology used during their academic activities. - Implement this survey and ensure a high response rate from the students. Ideal skills: - Previous experience in research design specifically targeting student demographics - Proficiency in data collection, interpretation and representation. - Familiarity with advanced technology trends in an academic setting. With the results, we can leverage technology more effectively for higher student engagement. Please include former similar academic survey projects in...
...demonstrating how someone can easily hire an item through our platform. Key Project Requirements: - Motion Graphics: The videos should be created in a motion graphics style. - Length: Each video should ideally be 1-2 minutes long. - Script: I already have fully prepared scripts for each video, so the main task would be to bring these scripts to life. Ideal Skills and Experience: - Proven experience in creating high-quality explainer videos, especially in the motion graphics style. - Ability to work with and enhance fully prepared scripts. - Strong communication skills to ensure the videos effectively convey the messages and instructions. Please provide examples of previous relevant work in your bid. Your understanding of our business and vision will also be highl...
I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.
I'm searching for a skilled ServiceNow developer to assist with crafting custom applications and configuring workflows and approvals. Your primary focus will be client scripts and business rules. Your tasks would include: - Creating client-side validations - Automating field calculations Experience with integrating external systems is beneficial, but not mandatory for this project. There's 2 days strict deadline, giving you the flexibility to ensure top-quality results.
I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...
I'm seeking a skilled Wix developer who can swiftly cus...content management system (CMS) for seamless content updates - Implementing a suitable system for content categorization, ensuring a clear and organized blog structure - Integrating a system for content collection, allowing for easy and effective content uploads The ideal candidate for this project will have: - Proficiency in Wix development, with a portfolio that demonstrates successful blog customizations - Strong experience in setting up and customizing CMS on Wix - A knack for organizing and categorizing content effectively - Experience in integrating and customizing content collection systems on Wix Your ability to navigate Wix's platform swiftly and deliver a tailored business blog setup will be cruci...
...Integrating WhatsApp Cloud API: The first phase of this project would involve setting up the WhatsApp Cloud API, including the integration of a websocket webhook for real-time communication. - Developing Automation Scripts: I will need you to create Python scripts that can automate various communication tasks on my behalf. This might involve sending messages, responding to specific triggers, or even managing contacts. Skills and Experience: - Proficiency in Python: You should be an expert in Python programming, as this will be the primary language used in the automation scripts. - Experience with API Integration: Previous experience working with WhatsApp Cloud API or similar cloud-based communication APIs would be a plus. - Understanding of Websockets: Since we...
...through OTP) c) GST Number (if available ) d) Google map location (if available) after successful registration customer can login and request quotations 3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the products in quotation. Admin can edit the prices manually and can share and download the requ...
I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.
As the project owner, I'm seeking a professional skilled in Pine Script with experience in retrieving code from private scripts on Trading view. The key objectives of this project include: - Extracting the Pine Script code from a specific invite-only script (the script name will be shared privately upon project commencement). Unfortunately, it's currently unknown which specific script to be used, but clarity will be provided as the project progresses. - Discern the implemented functions within the script. The functionalities mainly centered around recognizable trading indicators like Moving averages, Pivots, Fibonacci and MACD. - The code extraction should consider compatibility with variable timeframes. Whilst exact timeframes aren't specified yet, flexibility sho...
I have an excel file, need add product categorie on a column - budget 100€
I am looking for a team of talented individuals to support the growth and quality of my YouTube channel content. The core roles I am looking to fill are: - Script Writers (Telugu & English): You should have a strong command of your respective language and the ability to craft engaging scripts. The channel's content spans across Educational, Movies and Music genres, so an understanding or interest in these areas will be beneficial. The ideal candidate should be able to generate quality scripts on a weekly basis. - Marketing Expert: I am seeking a marketing professional who can strategize, execute and optimize plans to increase the channel's visibility and drive engagement. Experience in YouTube channel marketing and a strong understanding of the YouTube algorit...
I'm looking for a professional who can help me enlist my collection of leather bags and wallets onto existing e-commerce site like amazon, flipkart, ebay, shopify etc. I also need help with managing the online selling process. Ideal Skills and Experience: - Prior experience with leather goods is a plus - Proficiency in e-commerce platforms and product listing - Strong understanding of e-commerce marketing and selling strategies - Excellent written communication for product descriptions - Familiarity with various payment processing methods Key Responsibilities: - Enlisting the available leather goods onto the e-commerce platform - Creating engaging product listings with attractive product images, detailed descriptions, and accurate price information - Managing the online sell...
...analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an...
As a Python Developer, I'm intent on automating specific repetitive tasks related to file management and organization. Key Responsibilities: - Develop scripts in Python to automate repetitive file management tasks. These tasks are slowing down our productivity and we need a solution to streamline them. - Implement an effective, reliable and user-friendly automated system that requires minimal manual intervention. - Ensure the system is highly secure and can handle large volumes of data effectively. The ideal candidate will have: - Proficiency in Python programming language and experience in automation.
fichier sur Excel reproduire le même identique sur Excel avec calcul automatique
I'm currently working with an existing Python code and need a professional to review and improve upon it. I'm not certain what version it is therefo...working with an existing Python code and need a professional to review and improve upon it. I'm not certain what version it is therefore freelancer with knowledge in both Python 2 and Python 3 is preferred. Ideal Skills: • Proficient in Python coding • Experience in code optimization • Excellent debugging skills Work Scope includes but not limited to: • Code review: Inspect existing Python scripts • Troubleshooting: Identify and fix any code errors • Optimization: Enhance code for better efficiency and performance The successful candidate should be able to work independently based on t...
Hello, I need complet the Amazon categories catalogue excel in french
I'm seeking a skilled individual who can help me implement an IoT solution within a month timeframe. Key Aspects: - Device Connectivity & Communication: The chosen candidate should have a sound understanding of MQTT (Message Queuing Telemetry Transport) and how to use it to integrate various IoT devices. - Data Collection & Analytics: Proficiency in handling data streams from these devices, ensuring seamless collection, storage, and basic analytics. - User Interface & Experience: Creating a clear, intuitive UI to monitor and interact with the IoT data is essential. Ideal Skills: - Proficient in Java, MySQL, and Tomcat - Experience with MQTT and IoT SCADA is a plus - Strong background in designing user-friendly interfaces - Able to deliver quality work withi...
I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.
...a dedicated virtual assistant, primarily focused on cold calling and telemarketing, with the main aim of achieving sales conversions. Your job will also involve providing communication support. Responsibilities will include: - Conducting cold calls - Implementing telemarketing strategies - Providing high ticket closure - Assisting with communication tasks. I'll provide you with cold calling scripts and product information guides to aid your efforts. Ideal candidates will have: - Strong phone handling skills - Sales conversion capabilities - Excellent communication abilities - Proven experience in telemarketing and cold calling - Knowledge of high ticket closure strategies. We're looking for someone who can effectively use provided resources to drive successful ...
I'm struggling with QuickBooks Snappt, needing help with troubleshooting issues related to printing PDFs. Additionally, I'd like to streamline my paystub downloading process to avoid the need for printing, looking to have them saved directly as PDFs. Key Responsibilities: - Troubleshoot QuickBooks Snappt: I need assistance to ensur...need for printing. This should enhance efficiency and save time in the long run. Ideal Skills and Experience: - Proficiency in QuickBooks: Experience with QuickBooks, especially Snappt, is fundamental for this project. - Troubleshooting Abilities: A proven track record of resolving technical issues related to printing and formatting PDFs. - Automation Expertise: Skilled in developing software or scripts for automating processes, in this case...
I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
I am seeking a professional to develop a software that can efficiently extract and present the scripts used on a list of URLs provided. The software should be able to handle up to 1000 URLs at a time and run specifically on Windows. Key requirements include: - Extracting scripts: The software should be able to seamlessly access the provided URLs and list the scripts used on each page. - Bulk processing: The software should be capable of handling a significant amount of URLs, up to 1000 at once. - Windows compatibility: It is essential that the software is designed to run on Windows OS. Website Accessibility: - Restricted access: Websites that require restricted access or login should be identified and reported separately. The software should skip such pages and indic...
I am looking for a well-qualified freelancer to help me develop a motivational app using AI. The user interface required for the app will be a mobile application. We will also need an admin panel to manage user subscriptions. Additionally, AI scripts need to be incorporated into the app as well. The purpose of the app is to motivate users and encourage them to reach their goals. The freelancer I choose to work with must possess advanced experience in both mobile application development and AI programming. They should be comfortable working with both UI/UX design and backend development to ensure that the app functions correctly. Project Brief -
I need someone with good Shopify experience to help me add a new collection to my store. The purpose of this task is to add products to the store and display them.
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
...product pages are easily shareable to maximize viral potential. Currently, the WordPress site is in development on a VPS, and this project will be conducted in a test environment before being deployed to production. We aim to collaborate with other teams working on related projects to ensure a smooth integration What You’ll Do: Integrate BigBuy API for product synchronization. Develop automation scripts using ChatGPT for content generation. Create and upload promotional videos to YouTube. Automate blog post creation with enriched product descriptions and videos. Optimize the site for SEO and ensure easy sharing across social media. Skills Needed: WordPress development (PHP, HTML, CSS, JavaScript) API integration (BigBuy, OpenAI, YouTube) SEO best practices Python/Node.j...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I need an individual from Mexico City who can conduct a comprehensive market research focusing on the black beans industry. The research will cover as...Identify key players, their pricing strategies, and market positioning. - Distributors: Explore current distribution networks, challenges, and opportunities. Ideal Candidate: - Located in Mexico City for on-ground research. - Strong background in market research and analysis. - Understanding of the food industry, specifically beans, is a plus. - Proficient in Spanish and English for accurate data collection and reporting. - Excellent communication skills to interact with different stakeholders. This is a part-time position with a flexible schedule, suitable for an individual who can dedicate time to this project alongside other co...
...industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with task management tools and software. - Excellent organizational and time-management skills. - Strong communication skills - you should be comfo...
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...
...identify suitable apps for purchase, based on their category, features, and potential. Your ability to assess apps in terms of their quality, user base and potential for monetization will be crucial. Your familiarity with the Google Play Store and the App Store will be a major asset in this project. This is a unique opportunity for an individual with a keen eye for app potential to curate a collection of apps across various categories, excluding finance and wallpapers. If you have a track record of successful app acquisition and can demonstrate your understanding of the app ecosystem, I look forward to receiving your bid....
I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include a diverse range of providers...
1. *Data Collection and Analysis:* Gather historical and real-time cryptocurrency market data, cleaning and processing it for meaningful insights. 2. *Algorithm Development:* Utilize Python's machine learning libraries to create predictive models capable of identifying potential trading opportunities. 3. *Risk Management Integration:* Implement risk mitigation strategies within the algorithm to minimize potential losses during volatile market conditions. 4. *Backtesting and Optimization:* Test the algorithm's performance using historical data to refine and optimize its effectiveness. 5. *Live Testing and Deployment:* Gradually introduce the algorithm to live market conditions, continuously monitoring and fine-tuning its performance.
I'm seeking an experienced designer to Create a collection of 9 engaging t-shirt designs inspired by Catholic bible quotes as specified and symbolism. The designs should resonate with the target audience, primarily adults who are looking at showcasing their faith and evangelising. All designs are to be monochrome. Please find attached some examples of existing tshirts on the market that we would like to show as an example for ours. Please find below the 9 quotes to be designed on the tshirts: 1. "I can do all things through him who strengthens me." - Philippians 4:13 2. "Love one another as I have loved you." - John 13:34 3. "The Lord is my shepherd; there is nothing I shall want." - Psalm 23:1 4. "Be still and know that I am God." -...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...
...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
...someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websites, an...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I'm looking to obtain contact information, specifically email addresses and physical addresses, of local jewellery shops from multiple countries. This information will be primarily used for a marketing campaign. The ideal freelancer for this job should possess: - Proficiency in web research and data collection - Proven experience in lead generation - Knowledge about the jewellery shop industry. I'm particularly interested in local artisans, as opposed to high-end luxury shops or exclusively online retailers. Please apply if you are confident in gathering accurate and quality data from various resources.
