Excel script database connection jobs
I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.
I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...
I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...
I am looking for a skilled Elasticsearch expert to help with data indexing and analysis for a large dataset. The data to be indexed is primarily textual and it is sourced from database entries. Experience with database management and textual data analysis is a crucial requirement for this project. The primary tasks include: - Analyzing and indexing a large dataset from database entries - Setting up Elasticsearch for efficient data analysis - Implementing indexing strategies for textual data Proficiency in Elasticsearch, data indexing, and database management is benefit for this project. Familiarity with handling large datasets and textual data is a must.
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
My Python script is intended to scrape specific Telegram groups, but it's not functioning as expected. I need a developer to address these issues, described below. - **Issue Description**: The script is crashing when scraping certain Telegram groups, which is likely due to the fact that it's not respecting selections. The error presented is “ AttributeError: 'MessageMediaWebPage' object has no attribute 'document'” I can provide the script if you want to check how it’s working. I am open to a whole new script being made. So long as it functions in a similar way. If not familiar you can view telethon api - **Expected Behavior**: The scraping script is supposed to collect data that matches specific regex...
I am on the lookout for a tech whizz who can streamline and boost our Squid and Linux configuration to more efficiently handle a large quantity of proxies, potentially using a /48 ipv6 for each, amounting to a massive number (~65k for a /32 and 512k for a /29). Currently, we are facing: - Proxy connection issues - Resource utilization problems We are working with an enormous number of proxies, way more than 50,000. Our current server is running on Ubuntu 20. Ideal Skills and Experience: - Proven track record with Linux (Ubuntu) server management - Thorough understanding of Squid protocols - Expertise in managing high-volume proxy servers - Solid capability to optimize system resources We need someone who can provide a smooth and superfast experience to our users by resolving...
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm looking for a seasoned expert in internet connection, specifically mobile data, to help me set up a reliable network for multiple devices. This internet connection is highly needed for various purposes, including but not limited to, effective email communication, comprehensive online research, and efficient social media networking. Here are the specific requirements: 1. Internet Type: My preference is mobile data. I expect you to provide a solid solution that will offer uninterrupted internet connection and advise on a good data plan suitable for heavy usage. 2. Devices: This network should comfortably support more than five devices concurrently without compromising its speed or reliability. 3. Skills: Ideally, you should be savvy in network management, sh...
...you have a keen ear for detail? Join our team as a remote #transcriptionist and transcribe #audiorecordings into text from the comfort of your home. ?#Requirements: - Proficiency in one or more of the following languages: Odia, Manipuri, Assamese, Persian Arabic, or Gujarati. - Excellent listening skills and attention to detail. - Ability to type accurately and efficiently. - Reliable internet connection and computer/laptop. ?? #Responsibilities: - Transcribe audio recordings into text accurately and efficiently. - Adhere to project #deadlines and quality standards. - Maintain confidentiality and security of sensitive information. ? #Benefits: - Work from home with #flexiblehours. - Competitive compensation. - Opportunity for growth and advancement. - Contribute to #langu...
...of a structural engineer or a person with a relevant background in load-bearing support. The project involves the use of I beam sections, particularly an ISMB-300 beam acting as a column and another ISMB-300 beam acting as a beam. Specific Details: - The ISMB-300 beam will connect to the web of an ISMB-500 column. - The ISMB-300 beam will connect to the flange of the ISMB-500 column. - The connection will be executed by 3 - 20mm diameter bolts. - The I beam sections will be put to use in an industrial environment. - The load anticipated for these I beam sections is a medium load, ranging from 5 to 15 tons. Ideal candidates for this project should have a strong understanding of load-bearing support structures, and experience in designing and implementing such systems. Previous...
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
...developer to create a VPN application that will run on both IOS and Android. This application should support both SoftEther VPN Protocol and OpenVPN. Key features to be included: -Protocols: Support both SoftEther VPN Protocol and OpenVPN. - Data encryption: An essential feature for securing users' data - Kill switch: A crucial function that ensures users' internet traffic is cut off should the VPN connection fail - Multi-location support: The VPN should offer various server locations for users to connect to securely The ideal candidate should have experience in developing applications for both IOS and Android, as well as prior experience in VPN development. A strong understanding of network security concepts and protocols is a must. The ability to work with SoftEther...
We are seeking a skilled and motivated Cold Calling Specialist to support our digital marketing agency located in Canada, Kelowna. As a Cold Calling Specialist, your main responsibility will be following a script and calling businesses on Google Maps to get them to book an appointment with me. You will be provided with a list of leads on the goHighLevel CRM, and your task will be to reach out to these prospects via phone calls to introduce our services and secure appointments for our sales team. Skills needed: - Excellent communication skills - Proficient in cold-calling techniques - Fluent in English and Above - Able to work 30 hours minimum per week. - Familiarity with digital marketing services(Preferred but not required) - Book appointments on The CRM Your payment will be bas...
I have a medium complexity Pine Script that I'm currently using for backtesting on TradingView. I would like to convert this script into Python so that I can run backtests on my local machine. This Python script should produce the same results as the Pine script on TradingView, but handle different data resolutions (1hr to 1Day data). Key Requirements: - Convert a Pine Script into Python. - Ensure the output of the Python script matches the results produced by the Pine Script on TradingView. - The Python script should be able to handle different data resolutions from 1hr to 1Day. Ideal Skills and Experience: - Prior experience in backtesting trading strategies in Python - Proficiency in Pine Script and familiarity with T...
I am currently experiencing payment processing errors with my PayPal plugin. All of my sales are automatically cancelled and I am not being notified. -Ideal Skills/ Experience: * Proven experience in troubleshooting PayPal plugin problems * Comprehensive understanding of payment processing * Ability to identify and solve connection issues. Let's collaborate to sort this out promptly to resume normal business operations.
I'm seeking to build a website catering to pickup soccer enthusiasts. The central functionalities I wish to incorporate include: 1. User profiles: This is a pivotal feature through which players can create and manage their profiles. Skilled in form design and data management would make for a perfect fit. 2. Messaging system: An integrated messaging system will permit players to converse, coordinate, and plan games. Experience in developing seamless communication tools is beneficial. 3. Game scheduling/calendar: A calendar feature for easy game scheduling is crucial. I expect your prowess in creating intuitive date-time functionalities to shine through here. 4. Field locator/map: Leveraging mapping APIs to find nearby playing fields will be a valuable element. The ideal candidate w...
I'm seeking a skilled video editor who can rework my 1-2 hour wedding reception video. The previous editor's work is not satisfactory to me. Key requirements: - Improve transition effects: The...beauty and emotions of the event in a professional manner. Ideal skills and experience: - Proven experience in video editing, particularly with wedding videos - Proficiency in transition effects, color grading, and audio enhancement - A good eye for song selection that enhances the overall video - Strong knowledge of cinematic editing styles - An understanding of the aesthetics and emotional connection needed for wedding videos. If you're confident in your abilities to transform this video into a professional, visually stunning, and emotionally engaging piece, I look for...
I need a skilled video creator to produce one mixed media promotional videos for my learning platform. The ideal candidate will be able to handle both animated and live-action elements seamlessly, including script writing. Actually what I wanted is to show a real person using my platform https://ooro.com.au. However, a 2D Animation with voiceover would be acceptable as long as rest of the requirements are met. Platform is designed so anyone with a skill or talent can register as a mentor. This includes actual teachers. And then if someone wants help with something they are learning, they can search for a mentor, who will use video call on the platform to engage with them. As an example, trying to imagine a video where people are getting assistance from a mentor using the plat...
I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.
I'm seeking expert to assist in configuring a Site-to-Site VPN on my Zyxel USG Flex 50, ensuring secure and reliable communication between our networks. Key Tasks: - connect to a already existing site - configure usg flex to not use dhcp and other option. just need vpn. i have a box behind Ideal Skills and Experience: - Proficient with Zyxel USG series - experience in VPN connection
Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.
I need a minimal working example of PPPOS in IDF framework v4.4.7. The requeriments are: - Minimal example with SIM800L modem. - Create and configure esp_netif for PPP (create the driver, and task to receive data from modem and send to esp_netif) - Configure the modem via AT commands (PPP conection ATD*99#) - After succesfull connection, make a http request for testing. The most important thing: DO NOT USE esp_modem component. The example must do not use any component, simply the esp_netif API.
I have a Node.js script that I've been using to sort and verify emails. However, there are some issues that I need to be fixed. I'm looking for a professional who can assist me in enhancing the script. Requirements: - The script should be able to validate the existence of email mailboxes without freezing when processing a large volume of emails. - Email verification must be accurate and reliable, and the script should be able to handle a large list of emails efficiently. Key points for the project include: - Implementing a more efficient algorithm to handle large email lists without freezing. - Ensuring that the script provides accurate validation of email mailbox existence. Ideal Skills: - Strong proficiency in Node.js and email verificatio...
...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement adv...
I am in search of a skilled 2D animation professional. You will be creating a 2D-style video for the primary aim of promoting my brand. The target audience for this video is primarily adults. Key Responsibilities: - Develop a visually appealing and engaging cartoon-style 2D animation video - Clearly convey the brand's message and values - Ensure that the video is suitable for an adult audience Ideal Skills and Experience: - Extensive experience in creating 2D animations, particularly in a cartoon style - Proven track record of developing successful brand promotion videos - Excellent understanding of adult audience preferences and sensibilities - Strong communication skills to understand and translate my brand's core values into animation Your engaging and professional animatio...
...guiding users through the process in an intuitive, engaging way - Draw all steps, Incorporate high-quality images, illustrations, and/or animations to richly visualize each step and bring our process to life - Design infographics or interactive elements to explain key concepts like curing, conditioning, and grading - Utilize images of our vanilla terroir, farmers, and facilities to forge a deeper connection with our origin and story 2. Written Content: - Craft clear, concise, and evocative copy to accompany the visuals and narrate the vanilla's journey - Highlight key points of differentiation, such as our origin, traditional techniques, and quality control processes - Emphasize our commitment to sustainability, fair trade, and community support 3. Brand Alignment: - En...
I have a Pine Editor script that I believe is in a good place, but I'm hitting some error messages that I can't seem to fix. I need someone who knows their way around Pine Script and TradingView to help me get this script running smoothly. Key Requirements: - Troubleshoot and debug script errors: The main issue I'm facing is error messages when I try to run the script. I need someone to go through the script, identify the root cause of these errors, and help me fix them. - Pine Script proficiency: The ideal freelancer for this project should have a good handle on Pine Script, as it's essential for understanding and improving the script. - TradingView experience: Since the script is set to work within...
We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web
...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...
i got my code pine script i need some when to add messge to the code and ill link it to webhook to send the signals Json signals fit to Cornix bot i need it asap in hours thanks
I've been working on a Python script that I'd like to make accessible online through a web interface. This would involve uploading the script to a suitable web server and setting up a simple user interface. Key Requirements: - Deploy my Python script onto a web server, optimization for best performance. - Implement a basic but intuitive UI for the script. - Ensure it can be accessed by anyone without requiring user authentication. Ideal freelancer for this project should have: - Strong experience in deploying Python scripts to web servers. - Proficient in creating user-friendly web interfaces. - Familiarity with various web servers, especially as I'm undecided on a specific one. If you have experience in deploying Python scripts online and can...
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...
I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...
Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501
I'm in need of a skilled professional to help me create a data mining script. The task involves mining emails, data from a certain website and delivering the data in a raw text file format. Key Requirements: - Develop a data miner script that can effectively scrape email data from websites. - Ensure the script can handle multiple sources and is scalable for future needs. - Deliver the mined data in a raw text file format. Ideal Skills: - Proficiency in web scraping and data mining techniques. - Experience with developing scripts for text data mining. - Strong knowledge of scripting languages suitable for scraping like Python/BeautifulSoup, R, etc. Please provide samples of your previous similar projects or portfolio that demonstrate your ability in this area.
I'm looking for a skilled video editor who can help me create engaging review and how-to videos for products. Key Responsibilities: - Editing TikTok videos to be between 15 to 60 seconds long - Incorporating English voice-over. I will provide sample videos for you to use in the video. You can use snippets of the sample videos and cut them in small snippets for the final video. ...looking for a skilled video editor who can help me create engaging review and how-to videos for products. Key Responsibilities: - Editing TikTok videos to be between 15 to 60 seconds long - Incorporating English voice-over. I will provide sample videos for you to use in the video. You can use snippets of the sample videos and cut them in small snippets for the final video. I will provide the scri...
I'm looking for an Indian Python developer to create a script that can retrieve specific data from Telegram. Key Points: - The script should be able to fetch phone numbers and migration of users from Telegram. The ideal candidate should: - Have a strong background in Python development - Be familiar with working with API's - Have experience in web scraping - Have a good understanding of data privacy and security - Be able to deliver the project on a monthly basis. Looking forward to hearing from Python developers with relevant experience.
...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...
I'm in need of a skilled OpenCV programmer to help me with a bug in my WhatsApp automation script. Here's what you need to know: - The specific issue is that the automation isn't starting as expected. - The script is written in Node.js. - I haven't been able to locate any error messages or logs that might be related to the issue. You should ideally have experience with: - WhatsApp automation - Node.js - OpenCV Your task will be to identify the root cause of the automation failing to start and rectify it.
I'm looking for a skilled professional to set up a site-to-site VPN connection to my Azure cloud infrastructure. This setup is crucial for our business, as we have a hybrid network environment, comprising both on-premises and cloud-based resources. Key Responsibilities: - Establishing a secure and efficient site-to-site VPN connection from our on-premises network to Azure - Ensuring that both our servers and workstations can securely and seamlessly communicate with Azure resources through the VPN Skills/Experience Needed: - Proficiency in network security and VPN setups - Specific experience with establishing site-to-site VPN connections to Azure will be highly valued - Ability to configure and troubleshoot VPN connections for both servers and workstations - Strong und...
I have a YOLO v5 detection Python script, and I'm looking to turn it into an API-based web program with FastAPI. The API must support user inputs for 4 Twilio contact numbers and 4 RTSP addresses, and it should display the four video streams in a grid on a single page. Key requirements: - Convert the existing YOLO v5 detection Python script into a FastAPI-based web program. - Implement user input functionality for 4 Twilio contact numbers and 4 RTSP addresses. - Display the video streams in a grid layout on a single webpage. Ideal skills and experience: - Proficiency in Python and experience with YOLO v5 detection. - Strong knowledge of FastAPI for building web APIs. - Previous experience integrating Twilio for messaging. - Familiarity with displaying multiple video st...
I'm looking for an experienced and creative video creator who can generate an explainer video to introduce my company/brand. Key responsibilities: - Develop an original, compelling script from scratch. - Deliver an engaging video that effectively communicates our brand message. Ideal Skills: - Strong scripting and storytelling skills. - Experience in creating explainer videos. - Proficient in using video editing software. - Keen eye for details and creativity. - Understanding of branding principles. The ultimate goal of the video is to provide viewers a clear, appealing introduction to our brand. Looking forward to excellent pitches from skilled professionals.
I have a database containing over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. Example: Hannah Walker appears in the database 5 times, the script should remove the four duplicates of Hannah Walker and put all 5 serial numbers by her name.
I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.
I'm seeking a skilled developer to create a trading script that leverages the trend following strategy. The specific indicators the script should use are Moving averages, MACD, Volume Profile, ATR, and VWAP. - **Trend Identification:** The script should be able to identify trends based on 15-minute data timeframe. - **Required Expertise:** I would ideally be interested in a coder with extensive knowledge of algorithmic trading, and experience in developing trading scripts. An understanding of trend-following strategies and the mentioned indicators is a must. This engagement will necessitate a strong knowledge of financial markets and trading. If you are a detail-oriented coder and familiar with the trend-following strategy, your skills will be id...
