Excel macros log web query jobs

I'm looking for a detail-oriented professional to manually add 150 invoices to my QuickBooks within a 48-hour timeframe. All invoices are in digital format, primarily a mix of PDF and Excel, with some being scanned copies. Key Responsibilities: - Accurately inputting each detail from the invoices into QuickBooks - Associating each invoice with the corresponding customer name - Attaching the invoice to its respective entry in QuickBooks Necessary Skills: - Proficient in QuickBooks - Strong attention to detail - Excellent data entry skills - Able to work under tight deadlines Ideal Candidate: - Has experience with manual data entry from digital invoices - Can ensure complete accuracy and integrity of data input - Is dedicated to meeting the 48-hour deadline invoices will be ...

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

...overview transcoding server, change ports for streaming, rtmp/hls/http etc), see if reverseproxy is installed, show reverseproxy ip adres, possible change main server ip adress, reinstall reverseproxy - nginx settings / possible restart nginx/ change streaming ports /rtmp ports/ etc / admin pass change - firewall block, maxmind api, geo block, country block, lock user to X country connect, user log activity (invalid creds, blocked logs, bruteforce attacks, block single ip, block subnet) - Overview blocked ips, Overview Whitelisted ip adresses/add/delete Stream Checkker, Connection Checker in C++ communicate realtime with frontend dashboard - means check, if user restreamer, check user max allowed logins (open connections at same time) - means (check user realtime, connectio...

I'm looking for a skilled developer to transform my MS Excel files into a functional web application. Key Requirements: - The web application should be focused on data entry and form submission. - It should be compatible with desktop only. Ideal Skills: - Proficient in web application development. - Experience with data entry and form submission interfaces. - Understanding of desktop compatibility requirements.

...utilization) Memory usage (RAM, swap) Disk activity (IOPS, free space, read/write operations) Network traffic (bandwidth usage, errors, dropped packets) Service uptime Service-Level Metrics Web services (HTTP/HTTPS status, performance, visitor statistics) Database performance (MySQL/MariaDB with query statistics) Mail servers (queues, processed/deferred emails, etc.) DNS server health FTP server status cPanel/DirectAdmin-specific service metrics Backup monitoring (jetbackup) Website monitoring Security and Logs User login activity Firewall rule statistics System and error log monitoring Mail log monitoring Apache log analysis Deliverables A fully configured monitoring setup for both cPanel and DirectAdmin servers. Multiple visually appealing d...

I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.

I'm looking for a professional Excel macro developer who can help me create a macro that extracts specific information from one Excel file and organizes it into another new Excel file. Key Requirements: - The Macro should be able to extract specific information from Sample A and make it into an organized Excel file exactly like Sample B. - NOTE: Sample A will have Comments on what specific information will be extracted and become Sample B. Hover over them to view the comments - NOTE 2: If some of the information in Sample A is Blank, then leave them blank for Sample B Ideal Skills: - Proficient in Excel, especially in creating and implementing macros. - Experience with data organization and manipulation in Excel. - Strong attention t...

I am looking for a skilled C++ developer to enhance my project by adding new features. The main task involves integrating a Winsock API console function to display live logs in a text format. Ideal skills and experience: - Proficient in C++ - Experienced in API integrations, specifically Winsock - Capable of adding new features to existing code - Able to format logs into text for console display - Strong problem-solving skills for code enhancement and optimization

The objective of this project is to produce an instructional video utilizing Kali Linux to transmit an observer file to a WhatsApp number. This endeavor is intended solely for educational purposes. The following requirements must be met: 1. Kali Linux must be accessed via Oracle Virtual Machine. 2. The video should detail the process of creating the file in formats such as PDF, JPG, Excel, Word, or even video or audio files. 3. The file must be recognized as safe by WhatsApp and Android security measures. 4. The file should enable the sender to view the gallery photos and camera of the WhatsApp Android device. 5. The file must not contain any malicious algorithms. To receive payment, you must demonstrate that you have successfully completed the aforementioned steps. 1. The...

I'm looking for a data vendor who can provide a list of homeowners in Los Angeles, California, who have expressed interest in home improvement within the last two weeks. The list should include: - Name and contact details - Property details - Type of home improvement needed - List phone numbers for quick contact. Please deliver the list in an Excel spreadsheet. Ideal candidates for this project should have experience in data collection and analysis. They should be able to provide accurate, up-to-date information in a timely manner. Knowledge of the home improvement sector would be a plus.

I'm looking for a skilled Power BI professional who can create multiple operational reports. The data primarily comes from Excel spreadsheets and will be processed through Power BI. Your proficiency in Excel is crucial. Key Responsibilities: - Create operational reports in Power BI - Utilize Excel spreadsheets and Power BI as primary data sources Preferred Skills: - Mastery in Excel - Expertise in Power BI - Experience in creating operational reports Ideal Candidate: - Able to create visualizations such as bar charts and graphs, pie charts and doughnut charts, and heatmaps.

...crafting compelling and persuasive proposals to secure new projects and clients. Our proposal templates need to be completed and altered per client using CHAT GPT and midjourney/pinterest to help complete the design. No lead gen required, we have that sorted for you. You will have access to our generic email inbox to create the draft emails for us to approve, also access to our canva and midjourney log ins. This will be ongoing work and looking to start with 5 hours per week. Key Responsibilities: - Writing project proposals tailored to the photography industry. Ideal Skills and Experience: - Exceptional writing and communication skills in English - Previous experience in proposal writing, particularly in the photography sector, is highly desirable. - Ability to understand and ...

I'm seeking a proficient SQL developer with extensive experience in Sage X3 ERP. The task is to craft a query that compiles an Inventory Valuation by Date across multiple warehouses. The valuation method is FIFO. Key Requirements: - Expert in SQL with a focus on writing complex queries within Sage X3. - Deep understanding of Sage X3's data structure, particularly inventory and valuation data. - Ability to retrieve accurate inventory valuation details broken down by date. - Skill in referencing the correct tables and fields, and applying all necessary joins and conditions. The query should accurately reflect FIFO inventory valuation across multiple locations. Experience with this ERP system is crucial for success in this role.

Need Freelancer for development of excel spreadsheet tool for financial projections, scenario analysis and presentation materials for same. Spreadsheet function is to calculate cash position and standard EBIT/EBITDA information from 2023 to 2040 (pre-revenue through profitability) for a (renewable energy) technology development and licensing company: not manufacturer, not a software developer, nor SAS provider. The basic financial structure includes simple operating cost structure, project-based revenues, non-operating income, minimal capex and equity infusion. Project Revenue Types are: • License payments based on milestones related to tangible progress for design, construction and commissioning of commercial and annual annuities (royalties) based on plant capacity (or ...

I need assistance exporting quotes from an Excel price list into a Word document. The quotes should be organized by product category. The exported quotes should include the following details: - Product name and price - Vendor information - Quote expiration date Ideal skills for the job include: - Proficiency in Excel and Word - Attention to detail - Organizational skills

Please Sign Up or Login to see details.

I'm looking for an Excel expert to create a variable tracking Excel file for me. I will be inputting a list of 1000 or more 3-digit numbers (ranging from 1-5) like 123, 231, 542, etc. Key Requirements: - Track the movement of each digit (whether it's +1,2,3, or 4 or -1,2,3,4, and also 0 when the number remains the same in the next sequence). - Provide a tally of movements for each digit in each position. For example, digit 1 in position 1 moved +1 75 times into the next sequence, +2 100 times, and so on. - Allow me to constantly update the list of 1000 numbers. - I will be copying and pasting the numbers into the file. Outputs/Reports Needed: - A summary table that presents the movements in a clear and comprehensible manner. - Please use standard formatt...

I'm seeking a detailed contact list of roofing, restoration, and mitigation companies located in California & Florida. The list should be compiled into an Excel sheet and include: Construction Companies: 1. Mitigation 2. Restoration 3. Reconstruction 4. Roofing 5. Water, Fire, Hail Damage. - Company name and address - Phone number and email - Key contact person's name and role - Specific roles such as Owner, Sales Managers, and HR Ideal skill set for the job includes proficiency in data collection and Excel, and ideally, some experience or understanding of the insurance roofing and restoration industry.

I need help analyzing a list of companies in Excel and identifying duplicates based on specific criteria. Your task will also involve assigning MTAuIDs to these companies according to a set of rules. Key Requirements: - Identify duplicate companies based on their Business Name - Assign different MTAuIDs to Joint Ventures - Assign the same MTAuID to DBAs, CEOs/Presidents, Trade Name companies, AKA companies, and divisions The list of companies includes additional key attributes such as Address, Email, Website, Phone numbers, and Type of Business. Please provide a description of your approach and the code you will use to solve this problem. Ideal candidates should have experience with data analysis, coding, and understanding of business structures.

I'm looking for a freelancer to assist with a copy paste and data entry project. The data is mixed - both numeric and textual - and is currently stored in various online sources. Ideal Skills: - Proficiency in Excel - Experience with Tally ERP software - Strong attention to detail - Ability to work with mixed data types - Prior experience with online data sourcing The final output needs to be in an Excel spreadsheet. Please ensure you can access and work with online data sources before bidding.

I'm seeking a data entry expert to assist with entering menu information. Specifics about the menu type, the data format, and the manner in which it will be provided are yet to be determined, but the need is immediate. Ideal Skills and Experience: - Proficient in data entry - Excellent attention to detail - Able to work under time pressure - Familiarity with common data entry software (Excel, Word, etc.)

I'm looking for an experienced data scraper who can gather information from various social media platforms. Ideal Skills: - Proficient in web scraping techniques - Familiarity with social media platforms - Excel data management skills The scraped data needs to be compiled in an Excel format. The specifics of the data to be scraped will be discussed in further detail with the chosen freelancer. Please include relevant experience in your proposal.

I'm encountering a problem with a MySQL query that joins multiple tables. The query is returning incorrect data, and I need a skilled developer to help identify the issue and debug the query.

Please Sign Up or Login to see details.

I'm looking for a skilled data parser who can extract product information from a specified website and organize it into an Excel spreadsheet. The data that needs to be extracted includes product descriptions. Ideal candidates for this project should: - Have experience with web scraping and data parsing - Be proficient in Excel - Have an eye for detail to ensure all data is correctly captured and organized.

...analytical skills and the ability to interpret quantitative and qualitative data. •Knowledge in validating information sources and critically analyzing data. •High level of English proficiency (C1 or higher) with advanced writing and editing skills in English. •Experience working with business intelligence reports, impact metrics, or financial analysis (preferred). •Familiarity with data analysis tools (Excel, Power BI, Tableau, etc.) is a plus. •Attention to detail and ability to manage multiple reports simultaneously. Key competencies: •Critical thinking and ability to detect inconsistencies. •Accuracy and attention to detail. •Ability to synthesize and communicate clearly. •Autonomy and proactivity in problem-solving. •Adaptab...

I need my Excel worksheet polished for print. The project involves enhancing the current layout of the worksheet, specifically to optimize it for printing. Key Requirements: - Adjusting the page layout and margins to ensure the worksheet is print-friendly. - Creating a green color scheme that is suitable for printing. Ideal candidate should have: - Proficient Excel skills especially in layout enhancement. - Experience in creating print-friendly documents.

I'm looking to create a Telegram bot with an admin side that allows me to sell physical products. The bot should be able to log all user actions, with a separate group for tracking this data. Key Features: - Admin Interface: Allows me to add items for sale. - User Interaction: A welcome message with buttons for 'Profile', 'Shop', and 'Top-Up'. - User Profiles: If a user doesn't have a profile, they should be prompted to create one with their name, street, city, and zip code. This data should be saved in phpMyAdmin. - Account Top-Up: Users need to be able to top up their accounts in Euros using cryptocurrencies. The options for cryptocurrency are Bitcoin (BTC), Ethereum (ETH), and Litecoin (LTC). Their balance should be visible in their profil...

I'm looking for a detailed Excel spreadsheet that covers the top 20 social media accounts for every sports team across the NBA, AFL (Australian rules football), NFL, MLB, IPL and international cricket. The accounts should span Twitter, Instagram, TikTok, and news outlets. Specific Requirements: - Top 20 Twitter accounts - Top 20 Instagram accounts - Top 20 TikTok accounts - Top 20 news outlet accounts - top 20 journalists covering the team - top 20 player accounts Each entry should include: - Account name - Profile link - Number of followers - Engagement metrics - Average post frequency: The average number of posts per day or week. Ideal Skills: - Proficiency in Excel - Familiarity with social media platforms - Ability to gather and analyze engagement metrics - ...

...growing team. Professional development and growth opportunities. To Apply: When applying for this role please include reference ATCMAX250127B when you provide an overview of top 4 reasons you feel you're suitable for this North American role. All applicants must past up to 2 levels of practical assessments to be considered for this which includes an Excel assessment. If you're not highly proficient in analyzing large amounts of data in Excel or equivalent, please don't apply....

...or PayPal). Option to purchase a 30-day license for application usage. After payment confirmation, the system must automatically generate a login and password for the user. 4️⃣ Automatic Credential Generation The back-end should generate temporary login credentials after purchase. These credentials must be automatically sent to the user’s registered email. The user must use these credentials to log in to the desktop application. 5️⃣ License Control System The website must maintain a database of active licenses. Implement a 30-day expiration timer for each generated license. Once the license expires, the user must be notified and blocked from accessing the application until they renew their subscription. 6️⃣ Communication Between Website and Desktop Application Develop an AP...

Troubleshoot excel xlookup formula

I would like to make a custom search engine that can be used internally as a research tool. The goal would be to upload digital documents (word files, .pdfs, audio files, videos, articles, blogs, etc). Everything we upload would be transcribed by openai api, and then would be completely searchable by the search engine. The results from user query would tell the user where they would be able to find the information they are looking for and provide a clickable link taking them to whatever it is they need to look at.I will have about 300 podcasts, 20 .pdf books, and an entire blog site as the initial items to use, but we would also want to be able to upload more documents in the future that could be added to the search engines knowledge base. More details: What kind of search fu...

...into an Excel spreadsheet. You'll be dealing with: - Data Fields: Name, Address, Email Your tasks will include: - Data Entry: Inputting the specified data fields into Microsoft Excel - Data Cleaning: Ensuring the data is accurate and free from errors - Data Validation: Adhering to unique data validation rules as instructed Ideal skills and experience for the job: - Proficiency in Microsoft Excel - Experience in data entry and data cleaning - Attention to detail for data accuracy - Ability to meet deadlines - Familiarity with data validation rules Please be prepared to adhere to: - Expected Format: Data must be entered in Excel - Accuracy Standards: High level of accuracy is required - Deadlines: Timely completion of the project - Specific Software: ...

I'm looking for someone to send my cover letter and resume to a list of recruiters. Details: - The email addresses are in an Excel spreadsheet. - I want the emails to be personalized with each recruiter's name, but not tailored to their specialization. - I would like email to come from a gmail address Ideal skills for this project: - Proficiency in Excel - Excellent written communication skills - Ability to personalize mass emails - Familiarity with email services such as Gmail or Outlook

...Work alongside the best, elevate your skills, and accomplish things you never thought possible. * Shape the Future: Directly contribute to innovations that will redefine how things are done in the commercial real estate tech industry. If you’re not confident you’re in the top 5%, please don’t apply. We’re looking for exceptional developers who thrive on high-stakes challenges and are ready to excel in a fast-paced, dynamic environment. About Us ======== We’re a rapidly growing startup in the commercial real estate tech space, and we're looking for a Laravel Developer who’s not just skilled – but hungry to take on challenges, move fast, and make an impact. We're a small but mighty team, and we need someone who thrives in a hig...

I'm in need of a freelancer who can assist with data entry from PDF documents. The job entails copy-pasting information from these documents into Excel. Ideal Skills and Experience: - Proficiency in Excel - Experience with data entry - Attention to detail - Ability to handle PDF documents - Good copy-pasting skills

I'm looking for a skilled professional who can convert my existing Excel/Numbers order form into an online order entry system. This project will involve creating both a basic version and a database-driven version of the order form. Key Requirements: - The online order form should be integrated with a custom Order Entry System. - It would need to replicate the tabs on the excel and the basic formulas - It should have the capacity to store customer data, specifically contact information and details pertaining to my business clients and schools. Ideal Skills and Experience: - Proficiency in Excel and Numbers - Experience in developing online order systems - Knowledge of database management - Understanding of customer data storage solutions Please no...

I'm looking for someone to extract stock symbols (tickers) for companies listed on the NSE and BSE, and enter them into an Excel spreadsheet. I need this done just once, so there's no need for ongoing updates. Skills and experience ideal for this job include: - Proficiency in data entry and Excel - Familiarity with stock markets, particularly NSE and BSE - Ability to accurately extract and input data.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I'm looking for a freelancer who can download numerical data from a specific website and organize it in an Excel spreadsheet. The data is updated daily every 3 min, so this will be a regular task. Requirements: - Download and organize all available numerical data columns from the website into Excel. - This task needs to be done daily in sync with the website's updates. Ideal Skills: - Proficiency in Excel and web data extraction. - Attention to detail and ability to follow daily schedules.

I have a 10 page annual report that i need populating from excel. The task is very simple max 1 hr. I will send you a word document that requires you to put in 2024 numbers from excel. and check the notes are corresponding to Balance Sheet, P&L and etc. general check for casting and cross casting. These accounts are not audited and they are fairly simple.

I need assistance in linking my website () to a MySQL database on Hostinger. This involves connecting website buttons and data capture from user interactions. I aim to integrate 1 to 2...data capture from user interactions. I aim to integrate 1 to 2 of my websites into this system. Key Data Points to Capture: - User contact details (Name, email and type of contact) - Paypal Donations - Other Forms of Donation - Petitions Additionally, I require a simple method for data export, primarily as an Excel file. Ideal Skills for this Job: - Proficiency in MySQL - Experience with Hostinger - Web development skills - Ability to set up data capture from website interactions - Excel data manipulation skills Please include examples of similar projects you've worked on in y...

...) # Move or confirm final files are in 'output' folder # (If run_sentiment_analysis already places them there, no extra step needed.) if __name__ == "__main__": main() ``` 2. **``** - Must list all Python dependencies, including: - **requests** or **httpx** (for API calls). - **beautifulsoup4** or **newspaper3k** (for web scraping, if applicable). - **openai** or another LLM integration library (for GPT-4). - **matplotlib**, **plotly**, or **altair** (for chart generation). - Additional libraries for CSV handling or data manipulation, e.g., **pandas**. 3. **`` (Optional)** - For system-level packages like `poppler-utils` if you need PDF extraction or any other system dependency

...furniture showrooms located in different cities. Key Features to Include: - A comprehensive product catalog with purchasing capabilities. The app should be able to showcase a wide range of electronic items like mobiles, refrigerators, TVs, etc., along with furniture. - User registration and login functionalities. The app should have a secure user authentication system, requiring users to register and log in before making a purchase. The app will only require the following payment method: - Credit/Debit Card Ideal Skills and Experience: - Proficient in iOS and Android app development. - Strong programming skills with a focus on building user-friendly applications. - Prior experience with developing e-commerce applications will be an added advantage. - Knowledge of secure use...

I'm looking for an Excel expert to create a sheet for data analysis, specifically for financial data (MahaRERA CA Form 03). The sheet should leverage pivot tables to help dissect and interpret the data effectively. The data and format will be provided. Ideal skills and experiences for this job include: - Advanced knowledge of Excel, particularly with pivot tables - Experience in financial data analysis - Ability to create user-friendly, functional Excel sheets.

I need a PHP-based web software for logging call records. The software should be able to: - Log Calls: Capture and store call details. - Search and Filter: Allow users to sift through records effortlessly. - Generate Reports: Produce comprehensive reports on demand. In terms of call details, we specifically need to log the 'Caller ID'. User authentication is crucial for this software. There should be distinct roles for an admin and standard users, ensuring secure access to the software. Ideal candidate should have extensive experience with PHP and web-based software development. Having a background in developing call logging software is a plus. Strong knowledge in implementing user authentication and admin control features is essential.

I'm seeking a talented app developer to create an engaging, cross-platform, real-time anonymous chat application for iOS, Android, and Web. This app is aimed at enabling casual conversations while prioritizing user privacy and security. Key Features: - User Authentication: A robust sign-up/log-in process to ensure each user's identity is secure. - End-to-End Encryption: Implementing top-notch encryption for all messages, ensuring privacy and security. - Message Deletion: Users should have the ability to delete their messages, providing them with control over their conversations. User Interaction Features: - Voice Messaging: Incorporating a feature that allows users to send voice messages. - GIF Support: Adding a fun element to the chats with GIF integration. - Rea...

the usual - thanks! 6-11 redone and the tables in excel. Thanks a tonne as always TP.

...individual who can gather contact details of all kids football and rugby teams, aged between 6 to 18, within a 30-mile radius of PE72AR. The details should be compiled in an Excel format. Key Requirements: - Sources: Contact details should be sourced from official club websites, social media pages, local school websites and general internet searches. - Teams: The search should encompass both football and rugby teams. - Contact Details: The primary focus should be on collecting email addresses, with contact names also being a bonus. Ideal Skills: - Proficient in data gathering and internet research. - Familiarity with Excel and data entry. - Understanding of youth sports teams, particularly football and rugby. - Ability to work independently and deliver quality results in...