How to use excel source in ssis jobs

...someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, ...

I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.

I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.

I need a tool that can scrape text content and tables from LinkedIn quickly and efficiently into an Excel format. The tool needs to be able to: - Extract text content and tables from LinkedIn - Export the scraped information into Excel format - Operate quickly and efficiently to meet a tight deadline The ideal candidate should have: - Experience in web scraping, particularly with LinkedIn - Proficiency in Excel - Ability to develop a tool that can operate quickly and effectively Given the urgency of this project, I need someone who can start ASAP and deliver the tool in a timely manner. Experience with rapid tool development would be a huge plus.

I need an experienced social media video editor and content creator to produce short videos for a social media advertisement. The advertisement is for an upcoming Alumni Reunion/Networking event. The videos should be less than 1 minute in length, three different videos. You can use any music that you see fit but you need to have a good eye for visuals and a knack for storytelling. Key Responsibilities: - Creating engaging, 3 short videos for Facebook, TikTok, and YouTube - Ensuring the videos are less than 1 minute in length - Using royalty-free music effectively - Showcasing strong editing and storytelling skills -The videos must relay these key information 1. Name of the event is 'Poly Networking Event' 2. The event will be held...

We are a Chinese company, we need someone in India who has an Apple ID to test downloading, registering and using our APP.

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise i...

My task requires a talented professional to locate potential buyers for my range of collectible toys. I'm aiming this line of products specifically at adults instead of the usual younger demographic. Key Responsibilites: - Develop effective strategies to find potential buyers. - Explore various channels (online/offline) to reach our audience. - Ensure buyers are genuinely interested in collectible toys. Ideal Candidate: The sought-after person for this assignment should have a background in sales or marketing, particularly within the toy industry such as die-cast models. A true understanding of the market for collectible toys and experience targeting adult consumers is vital. Incremental sales and exposure generated for similar products in...

Looking for an expert in data visualization who can show off their skills by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps...

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I am seeking a talented architect/interior designer to conceptualize a small capacity (up to 50 people) e-sport arena. This space should be multi-purpose, with areas for table top and card games, "video game tables", as well as adaptable space for B2B events or co-working. Key project elements: - The e-sport gaming area is the central focus. - A comfortable and homey interior design style is preferred. - Despite the diverse usage, the space should flow naturally and cohesively. - Incorporate dining areas where players can eat while engaging in video games. - The design should be flexible to also accommodate B2B events or transform into a co-working environment when needed. Ideal candidates should have: - Prior experience in architectural ...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attentio...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm look...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

...expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involv...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want...

...automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experi...

I need an experienced HVAC technician to install a Mr Cool air source heat pump in my backyard workshop. The ideal freelancer for this job should have: - Prior experience with installing air source heat pumps - Attention to detail, ensuring safe and effective installation - Ability to provide guidance on optimal usage and maintenance Your proposal should include an overview of your experience with similar projects, as well as an estimated timeframe for installation. Familiarity with local building codes related to HVAC installations will be appreciated. Mrcool DIY 12K BTU 4th Gen Energy Star Ductless Mini-Split Air Conditioner

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be per...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly ...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

I'm currently seeking a talented logo designer who can create a minimalist logo that will be used across my website, printed materials, and social media. The primary color scheme for the logo should be black and white. This is to ensure the logo is versatile and can be easily incorporated into various mediums. Experience in creating versatile, minimalist logos that can be used in a variety of digital and print formats is a plus. In summary, the requirements for this project are as follows: - A minimalist logo design - Suitable for website, printed materials and social media - Primary color scheme should be black and white

...processing to create a single image that combines a user's face image with clothing overlay. The specific requirements for this project are as follows: AI Technology: - The freelancer should have expertise in image processing techniques to achieve the desired result. API Preferences: - There are no specific API preferences, and the freelancer can use their discretion in selecting the most suitable API for the task. Final Output: - The final output should be a single image that contains the user's face image with clothing overlay. - The clothing overlay should include a t-shirt from a second image and pants from a third image. Ideal Skills and Experience: - Proficiency in image processing algorithms and techniques. - Familiarity wit...

I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Go...

I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scr...

...looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

...designer who can adjust my logo to fit specific dimensions of 50.8mm (height) and 20mm (width) with high density, suitable for both print and digital use. The final version of the logo should be available in JPEG, PNG, SVG, and ai formats. Key Requirements: - Adjust the size of the logo to 50.8mm (height) and 20mm (width) while maintaining visual integrity and enhancing the density for crisp display. - Deliver the adjusted logo in high resolution, suitable for both print and digital use. - Provide the final logo in JPEG, PNG, SVG, and ai file formats. - Ensure the logo is visually appealing and professional, reflecting the original branding. Ideal skills and experience for this job include: - Proficient in graphic design software...

Need 2 hours tutoring. I have a wix website and I want to understand how to add and remove blogs on the wix website. please let me know the price for 2 hours tutoring.

Convert 2 page brochure from PDF to AI files. Recreate source files from PDF for easy editing. Create a layer from each section. Copy the text from each section. i.e. each image is a layer, each text block is a layer, each text heading is a layer For reference-page1 should contain approximately 19 layers.

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love ...

I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared ...

I'm seeking a skilled developer to integrate a pixel into my WordPress website that collects the names, emails, and phone numbers of leads in real-time as soon as they visit a specific page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to sen...

I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.

...strong level of experience and skills in managing safety issues at large scale events with an expected attendance of more than 5,000. Key Responsibilities: - Develop and implement robust safety measures addressing key anticipated issues including Crowd Control, Medical Emergencies, and Fire Hazards. - Review and approve all safety arrangements and plans prior, during and after the event, - Continuously monitor safety compliance during the event. - Quality control - Auditing and monitoring - Document management - Policy and procedures implementation - Other events safety related matters Skills and Experience Required: - Proven experience in large scale event safety management. - Expert knowledge of various safety threats and first-hand experience in plannin...

...skilled freelancer to develop a Procurement Management App using PowerApps. This comprehensive app will streamline various aspects of procurement, including sales, purchases, offer comparison, offer creation, order recording, item creation, and purchase analysis. Offer Comparator: The app should allow users to upload supplier offers, compare them against existing database entries, and identify the best offers based on configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and gener...

I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong communication and negotiation skills.

I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks

I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has...