Read nth row from excel in ssis työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Task 1. Take these pages away from the HTML- sitemap: Al – käyttöehdot Al – Kiinteistönvälittäjän kilpailutus Al – kiitos Al – rekisteriseloste Al – tulos Al – Välityspalkkiovertailu Task 2. Enable our text-logo () to all affiliate pages. It is not enabled on our affiliate templates now.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
I have an html form php file on my server. I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submit...form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There are various tabs in the sheet, so we need to save the data in...
I am in need of an Excel expert who can create a dynamic and well-structured line graph based on data from a questionnaire that automated itself using text and numeric data. This project requires knowledge and practical experience with: - Excel data manipulation - Advanced graphing techniques - High attention to detail. The project specifically involves working with three or more different data sets and multiple excel books. The right candidate should have a track record of creating visually stunning and effective Excel graphs that allow for easy interpretation and extraction of meaningful insights from text data. The line graph should allow for a comprehensive overview of all data sets at once. It should make it easy to identify trends ...
hey there! I am working on a project with audio narration of the Bible stories that Jesus told (also called parables). The audio would be sent over and would be a straight reading of the text. Looking for someone to create a general vibe and color palette and have a lot of fun and bring their style into it and we could do potentially 10 of these stories together. They are around 30-45 seconds long each. Some stuff I have done with other animators is up at :)
Before you respond on Freelancer.com, please take a minute to read this document in full. There is no rush. Also view our "Client profile" before you bid. We are a reputed employer with excellent previous ratings. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the subject ----------------------- This is a 4-hour project to create a 30-second to 1-minute video (time can be slightly more or less, it is up to your judgment when making the video) The deadline is sacred, we cannot extend the 4 hour timeline. ---------------- About the video ------------------- Video script: (See attached file - video ) --------- Other details ------------------------- No voiceover is required. Generic background music is ...
I'm looking for a Laravel expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data handling. I have an h...expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data handling. I have an html form php file on my server (built in laravel). I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to i...
I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.
business profit loss reporting excel(Jan, Feb & March)
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression an...
...Work:** Showcase similar projects you've spearheaded or contributed to significantly. Links or a portfolio will be highly beneficial. - **Experience Level:** I'm targeting someone with an intermediate level of experience. You should have a solid track record and be comfortable tackling the complexities of IT development without needing extensive oversight. - **Skills and Expertise:** - Proficiency in relevant programming languages (Must have: Codeigniter, WordPress, Microsoft technologies like Azure, Power Apps) - Strong understanding of the full development cycle - Experience with both front-end and back-end development (specific skills depend on the project type) - Problem-solving abilities and a keen eye for detail This collaboration could span multiple pr...
I'm in need of an office assistant residing in Pune who can support me with managing emails, scheduling appointments, and help in daily activities. The role will require 50 hours of work per week. Key responsibilities: - Responding to emails and managing my inbox - Scheduling appointments and managing my calendar - Assisting in daily activities and other office related tasks as needed The ideal candidate for this role will have: - Proven experience in managing emails and scheduling - Proficiency in Microsoft Office suite - Strong organizational skills - Previous experience in customer service would be a plus Candidate has to be from Pune, India Your ability to prioritize tasks, communicate efficiently, and maintain a high le...
I'm in need of a skilled WP Job Manager/Smyles Plugin expert to make some changes and additions to both the back-end and front-end of my website. The primary focus of this project is to modify the back-end using the Smyles Plugin. Key requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities will include: - Implementing new search criteria: Specifically, I need the ad...
...the flowchart. Simple example: See attached file The text file has 3 lines as follows: 1 circle 1.5 5.3,1.2 Begin 2 rectangle 6,2 5.3,2.5 Find node that represents the itemset 3 line 1,2 This file would mean to: 1: Draw a circle with radius 1.5 at point (5.3 across,1.2 down) with the word "Begin" in it. 2: Draw a rectangle with width 6 and height 2 at point (5.3 across,1.5 down) with the words "Find node that represents the itemset" in it. 3: Draw a line pointing from 1 to 2 I don't care how the definition works other than how general it is. The above is just to show what I mean. 1. You could provide the flowcharts that some app allows you to make manually. 2. You could provide what the attached 30 files (or a subset) show. 3. You coul...
...assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a good understanding of how general contractors operate and thin...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
I want to rank in the TOP THIRTY google results on average for the following keyword phrases Target Country is USA 1 - Accident Lawyers 2 - Truck Accident Lawyers 3 - Car Accident Lawyers 4 - Boat Accident Lawyers 5 - Construction Accident Lawyers 6 - Lyft Accident Lawyers 7 - Uber Accident Lawyers 8 - Pool Accident Lawyers 9 - Personal Injury Lawyers 10 - Motor Vehicle Accident Lawyers 11 - Personal Injury Lawyer Near Me 12 - Lawyer For Car Accident 13 - Personal Accident Lawyer 14 - Car Lawyer Accident 15 - Attorney Personal Injury Near Me 16 - Accident Lawyers Car 17 - Personal Injury Lawyer Attorney 18 - Car Accident Attorney Lawyer 19 - Accident Lawyer Near Me 20 - Lawyer For Auto Accident This is for the website The ranking must hold for 1 month before escrow
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
...offered by our HVAC company. The goal is to clearly communicate the value and benefits of our services to potential and existing customers. Project Scope: Design and Layout: Create a visually appealing and professional design that aligns with our brand identity. The pamphlet should be easy to read and navigate, with clear headings, subheadings, and bullet points. Incorporate high-quality images, icons, and graphics to enhance the visual appeal and readability. Content Integration: Use the provided content from our three service plans (Basic Care Plan, Enhanced Care Plan, and Premium Care Plan) to populate the pamphlet. Ensure the content is clearly and accurately represented, highlighting the key benefits and features of each plan. Visual Hierarchy: Establish a clear v...
I'm in need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainability - Must be labeled by hand (no machine learning or AI) by a native English speaker Task: -Open the attached spreadsheet -Read the FULL TEXT of each tweet. Also read the brand handle and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad topic -- it is...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a...
I have less than 100 pages of handwritten me...transcribed into a custom template. This project is urgent, and I require the completed transcription in less than a week. Please read this entire ad before replying. NOT FOR AUTOMATED - hand transcribing job. Key Requirements: - Transcription of less than 100 pages of handwritten medical notes and computer printouts. - Custom template formatting (specific layout or structure) - Urgent turnaround time of less than a week Ideal Skills and Experience: - Experience in medical transcription to ensure accuracy and understanding of terminology - Proficiency in creating and working with custom templates - Ability to work under pressure and meet tight deadlines So that I know you are a real person and read this,...
...seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis...
Welcome to the "From The Inside Out Wellness Center" Logo Design Challenge! We are looking for a creative and original logo design that embodies the essence of our wellness center, focusing on energy-based work and spiritual practices. Our center offers a variety of services and activities aimed at promoting holistic well-being, personal growth, and spiritual development. The design should reflect our integrative heart-centered approach, helping individuals transcend to their higher selves and empower them on their journey towards optimal health, inner peace, and spiritual enlightenment. Design Guidelines: what we consider when we assign star ratings: 1. Name of the logo must be found in the logo and it should be easily readable: From The Inside Out Wellnes...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)&...
...guidelines for various CRM processes. Ensure documentation is easy to understand and follow for both new and experienced users. Organize and structure the content logically for efficient reference. Maintain consistency in writing style, tone, and formatting across all documentation. Study the agency website () to understand the services and sub-services provided. Set up a full database of minimum 30 to 40 demo clients or sample clients in the GrowCRM system, covering all stages from leads to task completion, payment, and ticket management. Create demo data from beginning to end for the demo clients to demonstrate the CRM functionality at all levels, as per the services and offerings of the agency (). Create demo proposals for the sample clients. Update the ma...
...recreate 5 logo designs based on provided samples and instructions. This project offers an excellent opportunity for designers to showcase their creativity and attention to detail. Responsibilities: Recreate 5 logo designs using the provided JPG files and instructions in a Word document. Follow the given logo concepts, sample designs, and color combinations closely. Make minor adjustments or enhancements as per the specified instructions. Ensure high-quality output and pixel-perfection in the final designs. Requirements: Proficiency in Logo designing Ability to interpret and execute design instructions accurately. Willingness to collaborate and incorporate feedback. Compensation: Fixed budget of Rs. 1000 INR for all 5 logo designs. Positive review and recommen...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
*Please read this carefully before applying for this job.* The ideal candidate/team will have worked on YouTube automation channels before with measurable success, have extensive knowledge of Youtube guidelines/copyright rules/fair use policies, strong drawing skills. We Want to Work With You If: - You have experience in creating high quality art work. - You understand psychology behind thumbnails - You can analyze competition and their thumbnails & create your own best version - You understand how to draw viewers in with an interesting and emotional art work to use for thumbnail. - You have experience working under tight deadlines - You are committed to high quality without the need for lots of revisions. - You are organized, communicative and have fast turnaro...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I have less than 100 scanned pages of text data that need to be entered into a digital format. The scanned documents are clear and the text is legible. I am looking for a detail-oriented professional to help me with this task. Id...to be entered into a digital format. The scanned documents are clear and the text is legible. I am looking for a detail-oriented professional to help me with this task. Ideal skills and experience for this job include: - Proficiency in data entry - Attention to detail - Familiarity with working with scanned documents - Ability to accurately transcribe text - Time management skills to complete the task in a timely manner If you have experience in similar projects and feel confident in your abilities to complete this job efficiently,...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I am in need of a freelance professional who can assist with the creation of a magazine to promote a small rural town in Arizona and our RV resort. We also need you to design 6 billboards and signs for our RV resort. The magazine will be composed of: 1) A 35 page magazine/brochure containing ads for local businesses, small business features, business directory, area information, etc. The design and copywriting for each page, including ads, need to be created by you. We can provide an outline and resources for reference, as well as photos. We can give you some information about the business, some guidance/references, but will need you to write the copy (using AI is fine), 2) Design of clean and modern billboards for our marketing launch, aligning with the design of y...
I'm in need of a skilled UI/UX designer for a medical app I'm developing. The app will be available on both iOS and Android platforms, and is designed to provide users with medical opinions using AI. Key features to be included in the app are: - Diagnosis Suggestions: The app should provide users with accurate diagnosis suggestions based on their reported symptoms. - Symptom Checker: A symptom checker that helps users identify the possible medical conditions related to their symptoms. - Medical Records Storage: A secure and easy-to-use medical records storage system, allowing users to keep track of their health history. Ideal candidates for this project should have: - Proven experience in designing UI/UX for mobile applications, particularly in the m...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessa...
...invigilator with at least a Bachelor's degree to administer an on-site exam in Nottingham, UK. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for a Reader and input assistance. For this assignment, you are required to be present on-site, sit with the test taker, and read the exam content aloud. You wil...
I need to be able to create realistic tablecloth images on a table from flat images of the patterns. - Create a render template for realistic tablecloths which can be edited to change the pattern. - 2 shapes are required - rectangular and round - Ideally the table will be in a replaceable kitchen background environment - Finished image should be 4000x4000px allowing for zoom crops to be taken. - Example shape styles are attached
