Google sheets parse csv työt

Olen itsenäinen yrittäjä, joka toimii ilman välikäsiä ja mikä tarjoaakin lukuisia etuja, ja on etuus työskennellä omien intohimojen parissa. Saat nämä kaikki saman katon alta: Brändin nostot, google kampanjat eli : hakusana ,performance max sekä shopping verkkokaupat kampanjat, verkkosivut, SEO-optimointi sekä AI –kaverin hyöty sisällön luomisessa. Edulliseen Freelancer -hintaan! -Mika

web-lomakkeelta tulevaa .csv-imuotoista tietoa pitäisi lukea FreeCADiin, sen pohjalta avata ja päivittää oikea malli ja piirustus ja lähettää niistä exportit takaisin asiakkaalle. Csv-puoli on kunnossa ja paikka minne exportit menee. FreeCADin komentaminen siis puuttuu

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

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.

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.

Firstname lastname company email City

File attached

I'm looking for an expert in Google Ads to review my account. - I'm aiming to generate more leads, so I need a thorough analysis of why the account isn't performing as well as it used to. - I need you to compare the current state of the account to a previous time when it was delivering good results. - I need you to identify all the changes that have been made to the account since that time. - I need a detailed understanding of the effect of these changes on the account's performance. The ideal freelancer for this project would have: - Extensive experience with Google Ads - A proven track record of lead generation through Google Ads - Strong analytical skills and the ability to interpret data and derive meaningful insights - Excellent communica...

...call for my Google ad campaign. The ad has already been created, this project specifically concerns the conversion tracking. - Business Name Setup: The business name needs to be set up according to Google guidelines. I'll provide the specific name for you to configure. - Website Conversion Tracking: I need conversions to be tracked via form submissions on my website. - Phone Call Tracking: Calls from Google Ads are to be tracked to a phone number on my website. Ideal Skills: - Proficient in Google Ad conversion tracking setup - Experience with Google ad guidelines and requirements - Strong understanding of website and phone call tracking - Attention to detail to ensure accurate tracking Your high-quality setup will be instrumental in measuring...

I am in need of a skil...would include: - Creating a channel - Automating video uploading, thereby saving me time and effort - Enhancing video SEO to ensure maximum visibility - Managing keyword research to increase the chances of my videos being discovered - Implementing a system for analytics tracking to provide me with important data on video performance Ideally, the system should be compatible with YouTube API, Google Sheets and Zapier. This way, it can integrate seamlessly with my existing tools and workflows. Overall, the primary goal of this project is to boost my channel's subscriber count and views. A successful applicant will have experience in YouTube management, video SEO, and API integrations. Your expertise in automation tools such as Zapier would be a ...

I have a Google Sheets file with a substantial list of 1007 products and I need this list to be organized into a final master list, integrating image links from two specific tabs. Key Tasks: - Create a final list of the 1007 products - Add the following details: CATEGORY, PRODUCT NAME, ABV, PRICE, Image Links - Integrate image links to the products from two separate tabs Ideal Skills and Experience: - Proficient in Google Sheets - Experienced with data organization and management - Strong attention to detail - Familiarity with handling a large volume of data in a systematic manner This project is time-sensitive and requires completion as soon as possible. A freelancer who can dedicate the necessary time and attention to ensure accurate and efficient completio...

I'm in need of a skilled developer who can create a sophisticated SERP analysis tool specifically for Google. - Your main task will be to develop a tool that can accurately analyze Google's search engine results pages (SERPs). - I'm looking for someone who has experience in developing software that can parse and interpret SERP data effectively. - While I'm not looking for a full suite of features, ensuring that the tool can provide a comprehensive SERP analysis is crucial. - The tool should be user-friendly, intuitive, and capable of generating clear and concise reports based on the analysis conducted. Given the nature of the project, expertise in web scraping and data analysis would be highly beneficial. Familiarity with Google's search algori...

I'm looking for a reliable real estate phone assistant who can help with various tasks and communicate effectively in English. Key Responsibilities: - Answering calls and inquiries from potential clients - Scheduling appointments with clients and other professionals - Sending a basic form and helping clients fill it out Requirem...with clients and other professionals - Sending a basic form and helping clients fill it out Requirements: - Fluency in English is a must - Good communication and phone etiquette - Basic understanding of real estate terminology would be a plus The ideal candidate should be organized, proactive, and able to work independently. The assistant will be expected to interact with our systems through Google Sheets so familiarity with this applicatio...

...suppliers, products, and purchase orders from various data formats (CSV, XML, JSON) and seamlessly import them into Microsoft Dynamics GP 2016. This will greatly enhance the efficiency of our purchasing workflow and eliminate the need for manual data entry. Ideal Skills and Experience: - **Microsoft Dynamics GP 2016 Proficiency**: A thorough understanding of Microsoft Dynamics GP 2016 is essential for this project. Previous experience working with this ERP system is a must. - **Database Manipulation**: Given the preference for direct database manipulation, the selected freelancer should be proficient in creating secure, efficient, and reliable integrations. - **Data Formats**: The ability to work with multiple data formats, such as CSV, XML, and JSON, is crucial. - **API...

I'm in need of a freelancer who can help me parse my VCF file and convert it to a different format. The main goal of this task is to extract the genotype information from the file. input will be VCF file (from ONT whole genome run) and csv file with columns containing rsID, chromosome number, position. output will be same as input csv file, with extra column showing genotype from VCF at the given position can run on Mac shell so either perl or python would be fine. Ideal Skills & Experience: - Proficient in parsing VCF files and understanding genotype data - Experience in converting files to various formats like CSV, TXT, and XLS - Attention to detail to ensure accurate extraction of the data - Knowledge of any data validation methods would be a plus. ...

I'm seeking a professional who can assist me with populating a Google Sheets spreadsheet with text data from existing databases. This is for the purpose of conducting detailed data analysis. Key Responsibilities: - Locate and extract image links from existing databases - Ensure accurate and error-free input into the Google Sheets - Paste the image links into the right product row Ideal Skills and Experience: - Proficient in using Google Sheets and extracting data from databases - Strong attention to detail to ensure data accuracy - Familiarity with data analysis techniques is a plus - Ability to organize and structure data effectively for analytical purposes I'm looking for someone who can work efficiently and provide high-quality res...

...can create a Windows GUI application. This app should be capable of opening and editing a pre-formatted CSV file. Key Features: - The app should have interfaces for inputting free-form English text in certain fields and selecting options from drop-down menus in others. - It must offer normal file saving and opening functionalities. - The design should incorporate a professional and corporate-looking splash screen graphic and an about page. User Interaction: I aim for a straightforward user experience. The app should be intuitive and easy to navigate without the need for an extensive guided walkthrough. Ideal Skills: - Proficiency in Windows GUI app development - Experience working with CSV files and handling user inputs - Strong understanding of UI/UX design, especially...

I'm in need of a skilled Shopify developer with solid experience in data import from Excel. Specifically, you'll be dealing with: - Product data import into my Shopify site from a URL download of a CSV - Importing simple data, without dealing with variants or complex attributes. - syncing of the products in the CSV with Shopify products would happen every 24 hours automatically - If an existing product on Shopify is not found on the CSV download, its status on Shopify needs to be changed to "draft" or "inactive". The ideal candidate should have: - Strong Shopify development skills - Familiarity with Excel or similar data management tools - Experience with product data migration or import Success in this project would mean a seamless in...

I'm in need of a Python GUI software to automate sending messages through Google Voice. The software should be able to perform the following functions: - Send messages to individual contacts on Google Voice - Support precise date and time scheduling for these messages -Automated Sending with customized message example: message example {name} and {adsress} -Custom delay settings for each message -Multiple Profile Sender (custom threads) with multiple Proxy support (enable/disable proxy) -Auto login accounts - Auto Skip Terminated Accounts -License system for users -Sending reports Ideal Skills and Experience: - Proficient in Python programming - Experience in developing GUI applications - Familiarity with Google Voice API is a definite plus - Strong understandin...

Detailed Functionality Description Authentication and User Management User Authentication with NextAuth and Google: Integration with NextAuth to enable user login via Google. Secure OAuth2 authentication flow to ensure user data protection. User registration through Google account, streamlining the sign-up process. Account and Subscription Management: Each account can manage one school, which can have multiple locations (campuses). Admin dashboard to manage subscriptions and assign school management capabilities to each account. Ability to sell subscriptions, where each subscription corresponds to a single school with its own set of locations, teachers, and resources. Role-based access control: Admin Role: Full access to manage the school, including locations, teache...

...statistical analysis: You should be able to generate valuable insights from the data and present it in a clear and comprehensive manner. - Proficiency in working with survey data: You will be dealing with survey data, so experience in this particular field is highly preferred. - Familiarity with spreadsheet software: The data is in a spreadsheet format, so proficiency in software like Excel or Google Sheets is a must. Your primary objective will be to provide a detailed description of the data which includes calculating the central tendencies, measures of dispersion, and other relevant statistical indicators. You will also need to present this information in a visually appealing format that is easy to understand and digest. I am looking for a freelancer who is not only...

...issues with the instant quote form to ensure accurate rate calculation and smooth functionality. - Incorporate Google Maps powered dropdown suggestions for city and state inputs to enhance user experience. ** SEO and Security Setup: - Implement comprehensive SEO strategies to improve organic search visibility and ranking. - Set up SSL through GoDaddy to ensure the website is secure and trusted by visitors. ** Database Management: - Integrate Google Sheets with the MySQL database so that the rates can be updated weekly via Google Sheets instead of directly through the cPanel, simplifying maintenance and updates. - Ensure seamless data synchronization between Google Sheets and the MySQL database to keep the quote system a...

Post a testimonial on Google Business Link below from the Text file along with your own comments from ChatGPT. Google Maps link: Multiple Winners possible!!

I'm seeking a professional to build a system that creates aggregates Google business ratings for security installation services and Reviews for my site pages. Key Requirements: - Aggregating Business Ratings: The system should specifically focus on collecting the business ratings of security installation services available on Google. Data Points: The key data points that need to be collected include each business's overall rating and star reviews listed on Google SERPs. for Ideal Candidate: - Proficient in Web Scraping: Experience extracting and aggregating data from websites is essential. - Familiar with Google API: Knowledge of Google's API for harvesting ratings and review stars would be a plus. - Data Analytics Skills: Ability to process...

Necesito a alguien que tenga 20 teléfonos con cuentas gmail, para participar durante 14 días como testers de una prueba cerrada de Google play. Con la finalidad de pasarla a producción lo antes posible.

...navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed within the dashboard interface. - Menu Navigation: Implement a user-friendly menu system that allows for intuitive navigation throughout the dashboard. - Dynamic Data Population: Enable dynamic data population based on user selections. When a specific month is ...

We're looking to recruit a rockstar virtual assistant to execute admin tasks with SPEED. Plenty of room for advancement and long-term employment if you’re competent, hard-working, and efficient. Skills required: - Excellent English is a MUST - Knowledge of Google sheets - Basic knowledge of Wordpress - Flexibility with working time and hours Job roles include but are not limited to… - Scraping basic information from website lists - Navigate Wordpress and add needed information Note - put the number ‘88’ in your application so we know you’ve taken the time to read this description!! Required personal attributes: - Strong work ethic - Focus and efficiency - Great English skills Expect a long term role with plenty of room for growth. ...

I'm seeking a professional with expertise in financial documents, specifically balance sheets and profit & loss statements. - You'd be responsible for updating these documents with new figures - no structural or comprehensive changes required. - The modification will be minor, focused on figures and data. - Your role is to maintain the integrity of the documents while reflecting the new information accurately. Ideal candidates will have experience in: - Financial accounting, specifically with balance sheets and profit & loss statements. - Attention to detail, ensuring accuracy in the modification process. - Proficiency with financial software/tools would be an advantage. Your expertise in this area will be crucial to ensure our financial documents re...

...launch a Google and Meta Ads campaign, with the primary objective of generating more leads and sales for my business. The focus will be on a nationwide scale, giving our campaign a wide reach across the country. Here is what I specifically need for this project: - Ad Campaign Development: Coming up with effective Google and Meta ads that specifically target a certain age group to generate leads and sales. You'll need to craft compelling ad copies that can attract and engage this demographic. - Ad Campaign Management: It's not just about creating the ads, but also about managing them. The ideal freelancer should have excellent monitoring skills to ensure our ads perform optimally, making necessary tweaks and adjustments on the go. Skills and Experience: - Ex...

...Name, Address 1, City, State, Zip, Technician Sheet 2:Technicians Tab Name, Starting Address, Starting City, Starting State, Starting Zip, Ending Address, Ending City, Ending State, Ending Zip Some of these fields can be blank. Useful validation for the user will be required. See this documentation regarding the json format The XLS sheets will correspond to the "jobs" and "vehicles" data types in the json. Examples of data validation (some examples but not all) - 1. Missing field on a work order (return "[name if present, line item] is missing [field]") 2. Missing starting or ending technician (return "[name if present, line item] is missing [field]" 3. Technician name listed on the WO not found in the technician list (return

I'm looking for a Google Shopping expert who can help me boost the conversion rate and sales of my WooCommerce e-commerce store. My Store selling is Ayurvedic medicine men's category. Key Points: - The current conversion rate and sales volume of my store is low. I aim to significantly improve both. - The primary goals of this campaign are to increase my store's conversion rate and sales. Ideal Freelancer: - Experience with Google Shopping campaigns. - Proven track record of improving conversion rates and sales for e-commerce businesses. - Proficient in WooCommerce, as my store is built on this platform.

Dear translator, We are a company that develops live streaming and video chat apps. We are looking for native translators in various languages for a localization project regarding the FAQ sections of our apps. We will be sharing a Sheets file with the texts that contains HTML codes and placeholders, Therefore, this project requires a lot of close attention to detail and preferably, past experience working with HTML codes. The file has two tabs. The first one needs to be localized, while the second tab needs to be proofread. The tone of the translations should be friendly, inviting, and informal. The first tab is 1800-words-long, but a considerable amount of the answers has repetitions. The second tab is 932 words-long in English. Ideally, we will be asking you to install at lea...

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I'm looking for a skilled professional to help me set up Google Ads for my WordPress webpage. Key Responsibilities: - Setting up Google Ads account for lead generation - Identifying the best keywords to target - Creating compelling ad copies - Monitoring and optimizing the campaign for maximum lead generation I need someone who has: - Proven experience in setting up Google Ads campaigns, especially for lead generation - Extensive knowledge of WordPress and its integration with Google Ads Please be ready to show examples of past successful campaigns. Your insights on strategy and proposed budget are welcome. Thank you in advance.

I'm in need of a Python developer to create a script that will convert data from a Google Sheet into individual text files. Key Requirements: - Data Handling: You should have experience in handling data from Google Sheets, and be able to efficiently transfer it to text files. - Unique ID Generation: The script should include a mechanism for generating a unique ID for each text file. This ID should be randomly generated. - Custom Header or Footer: Each text file should have a custom header or footer. Ideal Skills: - Proficiency in Python - Experience with Google Sheets API - Strong understanding of data handling and file creation - Knowledge of random ID generation - Ability to add custom header or footer to files

I am looking for a proficient PPC manager who has in-depth knowledge and experience with Google Ads. The ideal candidate possesses: - A strong understanding of Google Ads platform - Mastery in sales-oriented PPC strategies For this project, the focus is on the retail sector. Key responsibilities will include: - Planning and implementing Google Ads campaigns targeted at my specific audience - Turning the PPC campaigns into revenue-generating strategies - Monitoring campaign progress, adjusting tactics as required to maximize results If you have excelled in similar roles in the retail sector and enhanced ROI by generating sales or leads, I'd love to hear from you.

...of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced knowledge in Google Sheets: You must be...

I'm looking for an SEO expert who can guarantee that my website moves to the first page of Google search results. Key project requirements include: - Currently, my website is not ranking on the first page of Google. - I'm specifically looking for both on-page and off-page SEO services. Ideal candidates should have: - Proven experience in moving websites to the first page of Google. - Expertise in both on-page and off-page SEO. - A solid understanding of the local market to help reach our target audience. Please provide examples of previous work and your strategy for achieving this goal.

...consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data from these var...

I'm looking for a professional to help me fix my sitemap on Google Search Console. Currently, I'm experiencing two issues: “Missing URLs in sitemap” and “Errors in sitemap.” Key Project Details: - Less than 10 pages are currently missing from the sitemap. - There have been no recent changes to the website that could have affected the sitemap. Ideal Freelancer: - Must have experience in resolving sitemap issues on Google Search Console. - Should have a good understanding of website structure and indexing. - Proficient in identifying and rectifying errors in the sitemap. - Strong communication skills to explain the resolved issues and ensure future sitemap stability.

I'm in need of a skilled designer who can take my content and branding elements and craft them into a visually stunning presentation. Key Requirements: - Google Slides: The format of the slides must be on Google Slides - Client Pitch: The primary purpose of these slides is to pitch to potential clients, so it's crucial they're engaging and convincing. - Creative and Engaging: I want the slides to be not just professional but also creative and visually captivating. Ideal Skills: - Proficient in Google Slides - Strong design skills, with a portfolio that demonstrates creative and engaging design - Understanding of client pitch presentations and how to structure them for maximum impact If you're a designer with a knack for creating persuasive, vi...

...In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open to suggestions and modification...

I am looking for a skilled data analyst to compile and analyze raw ad spend data from Google Ads and Facebook Ads. This data will be used in correlation with sales data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpret...

I'm seeking an experienced Python developer who can help me with a project involving parsing a set of mixed data structures from text files. The data is not overly complex, but it does contain a variety of structures. The size of the files is less than 1 GB. Your responsibilities will predominantly include: - Developing a Python script to parse the text data - Converting the parsed data into JSON format Ideal skills for this task include: - Strong Python programming skills - Experience in parsing text data - Background in working with JSON data - Ability to handle mixed data structures - Understanding of efficient file handling methods, for processing less than 1GB of data If you have a proven track record in similar projects and can showcase a deep understanding of Python, ...

As a business professional, I'm looking to hire a freelancer experienced in Google Ads and Google Shopping Ads to help me boost product sales with a focus on the adjustable pedestal market. Key Responsibilities: - Develop and implement a targeted advertising strategy to reach a B2B audience effectively. - Optimize Google Ads and Google Shopping Ads to drive conversions and boost product sales in the adjustable pedestal industry. - Provide regular reports and analysis on the performance of the campaigns. Ideal Skills and Experience: - Proven experience in managing Google Ads and Google Shopping campaigns, with a focus on the B2B market. - Solid understanding of the adjustable pedestal industry and its audience. - Ability to optimize ad campa...

I have a Google My Business listing and am striving to attract more customers. I'm looking for someone to help me increase my Google Business reviews. Key Responsibilities: - Formulate a strategy for increasing reviews - Implement the strategy effectively - Monitor and report on the progress Experience: - Proven track record of increasing Google Business reviews - Strong understanding of digital marketing and customer engagement - Excellent communication and people skills Please note that I am not currently encouraging customers to leave reviews.

I need an expert in Google My Business to assist in optimizing my existing business profile. I am looking to improve the business information section of my profile. Specifically, I am interested in optimizing the following areas: - Business Description - Operating Hours - Contact Information - Product or Service Details The ideal candidate would come with a wealth of knowledge on how to fully optimize a Google My Business profile to make it more engaging and visible to potential clients. Experience in SEO, digital marketing, and Google's ranking algorithm will be greatly appreciated. Excellent communication skills will be essential, to understand my needs and objectives fully before making changes to the existing profile.

...does not have a website yet. We therefore need top-quality leads to contact, and they have to meet 2 criteria: 1. The business should NOT have a website (Facebook, free websites etc. are ok) 2. The business MUST HAVE a contact phone AND e-mail. The businesses need to be in the home service business in the UK (Plumbing, Electrician, Roofer, Mason, Painter, Cleaner, Pest control, etc.) We need a CSV file with the following columns): BUSINESS TYPE BUSINESS NAME BUSINESS ADDRESS BUSINESS ZIP BUSINESS CITY BUSINESS LOCALITY (IF APPLICABLE) BUSINESS E-MAIL BUSINESS PHONE BUSINESS SOCIAL LINKS (IF APPLICABLE) SOURCE FOR INFO! (this is the source where you got the info from) I say high-quality leads because when we cold-called samples earlier half of them had websites and some was w...