Columns jobs

I am currently experiencing some issues with a Google Sheets array formula that is pulling the wrong data from columns G, H, I, and J. I need a skilled and experienced freelancer who is adept at Google Sheets formula manipulation to help me rectify this. Here is what needs to be done: - Identify why the formula is pulling incorrect data and address the issue. - Correct the array formula such that it accurately matches and places data from the correct columns. Deep understanding of array formulas and error troubleshooting in Google Sheets is a prerequisite for this project. An ability to work quickly and accurately is also key.

I want a software, written in php Laravel, VUE3, using Vuexy Dashboard Template that I will provide to freelancer. Tempalte version: I can provide hosting environment for development. We will cre...will provide to freelancer. Tempalte version: I can provide hosting environment for development. We will create a MVP at first, to test and try the concept. Many thing will be configured directly in database through phpmyadmin. The short description of the project: A database management system with dynamic columns. Users will have access to advanced table plugin where they can see and edit values. details in attached document

...managing calibration data in our system and compare new data with the calibration data. Key Objectives: - Develop a stored procedure to generate a calibration table (avg + stdev) - Implement another procedure for creating a score table, which will be linked to the calibration data Calibration Table Requirements: - The calibration table should include the following columns: ID, Value, CalibratedValue, StandardDeviation. These columns are critical for our system's calibration functionality. Score Table - This table will check the difference from new data to calibration data Ideal Candidate: - Proficient in MySQL and SQL programming - Experience in developing stored procedures - Strong understanding of database architecture and data management - Attention to detail ...

We're working with Pivot grid, and it's a good library, but no longer supported and my team has no real ReactJS skills or time to learn. As such I'm in need of a proficient ReactJS Developer who can make some specific modifications to the library, including nice and automatic resizing of rows and columns based on the data contained, as well as handling dynamic resizing of column width by the user.. Your responsibility will primarily be: - Updating the Pivot grid library to include a column resizing feature - Updating to automatically wrap / detect content sizing between data cells and row cells - Ensuring compatibility with the latest version of ReactJS as we wish to keep our resources contemporarily adept. Your experience and skills should ideally include: ...

Require experienced ...commercial levels are to be presented as an open shell structure (open floor-plate) with minimisation of internal structural columns. - Underground Loading dock and carpark design requires well designed structural columns so as to optimise car-parking - Require concrete roof structure engineering and roof storm-water management plan with detention tanks and hydraulic engineering Design and documentation to include: Footing & foundations Basement retaining walls and Shoring (piles / capping beam / shotcrete) of adjoining boundaries Slabs on ground including driveway slabs All suspended reinforced concrete slabs and beams, including concrete or blockwork balustrades All columns, walls, stairs, balustrades and lift Onsite tank and pits Co...

I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.

i need 2 menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. example: STARTERS - ONION BHAJI - 4.50 - Our own onion fritters with salad and sauce. Contains gluten. i have started the process for u to make life easier no time wasters if u do nice job i can give u more menus in the future

Require experienced ...commercial levels are to be presented as an open shell structure (open floor-plate) with minimisation of internal structural columns. - Underground Loading dock and carpark design requires well designed structural columns so as to optimise car-parking - Require concrete roof structure engineering and roof storm-water management plan with detention tanks and hydraulic engineering Design and documentation to include: Footing & foundations Basement retaining walls and Shoring (piles / capping beam / shotcrete) of adjoining boundaries Slabs on ground including driveway slabs All suspended reinforced concrete slabs and beams, including concrete or blockwork balustrades All columns, walls, stairs, balustrades and lift Onsite tank and pits Co...

I have a massive inventory I need help with. I want to transfer the data from the website to an Excel spreadsheet. This involves both text and numeric data, which includes fields such as Vendor N...Proficiency in Excel - Experience in data entry - Attention to detail - Good organizational skills - Ability to follow instructions accurately If you have a good internet connection, a reliable computer, and a decent amount of time to spare, this task is right for you. Please provide a reasonable estimate of how long it will take you to complete the transfer of the 2280 inventory items. I need columns L, M, N, O, R, S, T, U to be filled out. I need this to be done in 2-3 days. Google Link here for explanation >

I need to add a multiple select dropdown check box to my ads placement form in my application. It is a php script from phpbrobid. I have data in my mysql table. Table columns are id, name, and parent id. The is multiple levels of parent child relation. Display the data in the table till the last level. And note the following: - One can select or unselect all child fields by selecting or unselecting the parent - Dropdown for each parent no matter the level. - The multiple select dropdown check box should work in the ads placement form of the phpprobid script. - Will provide access to the script and table of sample data with multi-level parent child relation. - See attachment for example select dropdown check box. Remember what I am looking for is multiple level.

I need an expert to transfer influencer data including names, Instagram handles, and emails from Modash to Google Sheets. This includes: - Opening Instagram accounts listed on the Modash platform - Copy-pasting the 3 pieces of specified data to their respective columns in Google Sheets N.B. The project involves the gathering of 500 rows of above information. Given the nature of the project, speed and a thorough attention to detail is required. The candidate will also need an Instagram account, to be able to search for profiles, and Instagram installed on their phone, for accounts where email can only be accessed on the phone app. Modash account login will be provided. This job will suit a freelancer who is detail-oriented, organized, and experienced in data transfer activities ...

...existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), category (optional - extract SKUs from all categories if null), sub_category (optional - extract all SKUs from all subcategories if null), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of SKUs with the following columns (category, sub_category, brand, sku_name, description, competitor_name, datetime, location, url, nsp, psp, stock_count (if...

I need to transform the fashade of this building without altering its structural integrity. I was thinking to do something with the existing arches and i attach some photos for inspiration but ofcourse i am open to your creative suggestions We cannot alter openings (doors or windows) and we cannot remove any structual ellements i.e columns Please include your input for the garden and pavements etc... I have some more photos from drone if you think ot would be better This is the beginning of a large project for the renovation of a hotel so successful candidates will have the oportunity for allot more work... Thanks

for my online bookstore, I need: in admin part in order details need to add two columns and hide few other

I require an expert for systematic detailing of steel structures - including beams, columns, connections, bracings, and plates. The project will demand the execution of: • General arrangement drawings, • Fabrication drawings, • Erection drawings. Alongside the technical accuracy, I look forward to incorporating aesthetics while maintaining strength, stability, and functionality of the steel structures. Ideal candidates should have: • Proficiency in steel structures design and fabrication. • Adeptness in architectural aesthetics. • Acute attention to detail and practicality. This project requires a union of engineering acumen with an eye for aesthetics.

I'm looking for a professional developer to implement an OCR (Optical Character Recognition) script that can accurately extract text from digital photos. These photos have complex layouts with multiple columns of text. This task will require: - A thorough understanding of OCR technology - Proven experience with image recognition and processing - An ability to handle complex layouts and formatting Accuracy is key in this project, as the ultimate goal is to eliminate manual data entry and ensure the text is easily readable post-extraction. With your bid, please share relevant samples of your past OCR projects specifically handling complex layouts for a solid reference.

...this project are: - Expertise in data curation, specifically in regard to financial data. - Familiarity with CSV (Comma Separated Values) format, as this is the desired output format. - Stock data will be sourced from a specific location that I will provide. - Proficiency in compiling data is required. I will need one csv file for each stock (symbol). The CSV files would have the following columns (please do not alter the casing of the column headers - all characters should be in lowercase): - symbol - date - open - high - low - close - volume Data source: Instructions: 1. Select "Security wise price volume data" in Type field in the dropdown 2. Enter the symbol of the stock in the symbol field 3. Click on "custom" button below 4. Specify

1. Dynamic block should generate array of rectangles with dimension of w x h. 2. Input values are : w= width of rectangle, h= height of rectangle, C=number of columns, R= number of rows, A= space between columns, B = space between rows. 3. Each rectangle has the same multiline text attached. Position and size of text is given in sample file. TExt is same for every rectangle, will be edited manually later. Since lots of people don't read this easy description i will save my time and ask you why sky is blue, on which you have to reply : because I have read the description. That means that you understand the project fully and can start working on it. Version ACAD 2007

Let's summarize what we need. 3D modeling of a villa in Revit: 1. Copy architectural model to construction: - Levels - Axes - Columns - Walls - Ceilings 2. Adding column sections - Wall sections - Beam sections 3. Connecting columns to ceilings 4. Linking beams to levels 5. Openings: windows and doors 6. Tables of quantities for concrete + blocks + iron.

I require a civil engineer, proficient in CAD, calculating the load-bearing capacities of both columns and beams. Ideal Skills & Experience: - Proficiency in AutoCAD - Degree in civil engineering - Knowledge of residential building regulations - Expertise in structural calculations related to column and beam load-bearing capacities

I am in need of a Python script that can read CSV files and push the data into SQL Server Management Studio database. Key Requirements: - The script should be versatile enough to handle multiple CSV files. - It should map the CSV file column names to the respective SQL Server database table columns. - I would like to have two versions - one for single CSV files and one for bulk import to optimize performance when dealing with a large volume of data. Key Skills: - Proficiency in Python to develop the script. - Familiarity with SQL Server Management Studio to manage the database. - Previous experience with CSV file handling and database import/export is a plus.

I need a graphic designer who can create a basic restaurant menu template in Affinity Publisher or provide the document in apub format. It is very important that I have full access to make changes to the final document. The template should have the following specifications: - Be in a 16:9 aspect ratio - Include 3 vertical sections and one footer area...Experience in the following areas would be ideal: - Graphic Design - Affinity Publisher - Understanding of restaurant menu design The project is time-sensitive, so quick turnaround is crucial. I have attached a Card that shows our color scheme, and I have attached an example of our current menu. We do not want to keep the squiggly line circles, we want it to be straight, but relaxed vertical columns. Thank you very much for rea...

I'm seeking an expert in Excel who can efficiently merge two sets of numerical data sourced from different spreadsheets. Key tasks include: - Cleaning similar columns to create a unique identifier for perfect merging - Conducting statistical analysis on the merged data to find the mean, median, mode Ability to analyze data meticulously, professional experience in using Excel and familiarity with advanced statistical functions are essential for this project. Stringent attention to details is appreciated, as the data to be handled is delicate and the outcomes crucial. An understanding of data cleaning techniques in Excel would be an added bonus.

I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured Excel document crafted with an underst...

In need of an Excel whizz to immediately help in cleaning up my spreadsheet which has become cluttered and confusing. The main task will be: - Formatting cells and columns: Your experience in making spreadsheets intuitive, organized, and easy-to-read will be key. Expertise in creating visually appealing and easy-to-navigate cell and column formats is crucial. Though the specific type of cell and column formatting was not specified, the ability to quickly adapt and modify to different formatting styles would be a plus. Please note, this task is time-sensitive and requires prompt completion. If you have a proven track record of quick turnaround times on similar projects, don't hesitate to apply. Your efficiency and attention to detail will be prized.

I am seeking a professional with strong expertise in Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file. Key Requirements: - Experience in Python programming - Proficiency in Excel VBA - Demonstra...B/C/E to be populated. - The setup should be easy to execute when needed by click of few buttons and automatically looping until all rows in excel are submitted by API. - The final deliverable should be in .xlsx format. ATTACHED: - Partial response of JSON API shown in attached screen shot - Format of excel file which shows how the image urls listed on column and other columns to populate. Please submit your bid if you have a strong background in this area.

...patterns to help us understand consumption trends. - Implementing anomaly detection techniques to flag any irregular or unexpected behavior in our system. - Providing actionable recommendations for energy optimization based on the patterns and anomalies identified. Details about the data: I want to have 3 tables: Real time data table: The data will be captured directly from sensors at the form of columns, for example, Device 1, device 2 , device 3, and rows are time captured at growing rate of 1s. the value of the row is the energy consumed of that device at that exact second. This will be a large table. Hourly Data Table: Aggregate data hourly to feed into the anomaly detection model, stored in the 'Hourly' table, to identify significant deviations. Daily Data Table...

I need your help in creating an automated script or formula that can run multiple find-&-replace functions, at the same time, on an Excel spreadsheet that could regularly include 1,000 to 5,000+ records. Specifically, I will run this routine on the physical address column of data (not on the Company Name or City or State columns). In the attached .xlsx file, I would run the routine for all of a Column B. Here are the 20 specific tasks involved: 1. If a cell contains the word "Ave" or "Ave.", it should be replaced with "Avenue". 2. If a cell contains the word "Blvd" or "Blvd.", it should be replaced with "Boulevard". 3. If a cell contains the word "Ct" or "Ct.", it should be replaced with "C...

Very simple project - need an excel wiz who can remove some duplicate entries & total up some columns. Only bid if you are an excel wiz & very experiened in excel

I need to add a multiple select dropdown check box to my ads placement form in my application. It is a php script from phpbrobid. I have data in my mysql table. Table columns are id, name, and parent id. The is multiple levels of parent child relation. Display the data in the table till the last level. And note the following: - One can select or unselect all child fields by selecting or unselecting the parent - Dropdown for each parent no matter the level. - The multiple select dropdown check box should work in the ads placement form of the phpprobid script. - Will provide access to the script and table of sample data with multi-level parent child relation. - See attachment for example select dropdown check box. Remember what I am looking for is multiple level.

"The work you do for us is confidential and you will never speak of the work you do" Preamble for Supplier Website Scraping Contract We are seeking a professional to perform scraping of our suppliers' websites. The mission consists of exhaustively collecting all data for each product, organizing it into distinct columns, including the link to the product and a link to the corresponding images (one link for each image). Each product-related information must be recorded in a separate column. It is important to note that depending on the brand, the information may vary. Therefore, the number and type of details may differ. Sometimes, details may be represented by logos. In this case, please provide the name of the logo (this is always indicated in the image field). The...

I need immediate assistance with converting 50 invoices into an Excel sheet. The information to be transcribed includes the following columns: Date, CIF, Company Name, and Amount. Ideal Skills: - Proficiency in Excel - Attention to detail - Fast and accurate data entry skills The project has to be completed within 1 day. No specific formatting requirements are needed at this time. Once completed, I will review the Excel file.

3D modeling of a villa in Revit: 1. Copy architectural model to construction: - Levels - Axes - Columns - Walls - Ceilings 2. Adding column sections - Wall sections - Beam sections 3. Connecting columns to ceilings 4. Linking beams to levels 5. Openings: windows and doors 6. Tables of quantities for concrete + blocks + iron.

We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the pr...

I need a VA with Wix store experience, a keen eye fo...You'll be tasked with: - Keyword Optimization: Adjust the product titles on my Wix store to ensure they are optimized for search engines. Experience with SEO would be beneficial for this. - Database Creation: Develop a comprehensive database for all my products. This will include attributes like Product names, Product prices, and Product URLs. - Formatting: The database should contain separate columns for each product attribute. Strong organizational skills and experience with data entry would be ideal. Ultimately, the goal is to streamline the management of my product listings for a smoother business operation. Prior experience with Wix and creating product databases will be a major advantage. Let’s optimize my ...

I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.

Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer orders, inventory, and shipping. Key Features...customer. - Inventory level reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the tables. 6. Create ERD inside MS Access and join the tables based on the ERD 7. Create min 3 queries using...

...setting up the Twitter API and need a custom script written for Google Sheets. Here are the specific requirements for the project: Project Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionality to fetch tweets within a specific date range through an added menu in Google Sheets. 3. Data Integrity: - Ensur...

...Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and movement pattern columns are not as important but if you could also select them that would be great. If there is equipment clearly used then select it from the dropdown, it is likely to only be Dumbbell, Barbell, Bench or Resistance band The first sheet separates out the exercises by “movement type”, many of these coincide with the movementPatterns columns. The exception to this is the &ld...

I would like to change our "Dedicated Server " " product page to have a layout more like the one of our competitor "Hetzner" We use the "hostlab" template f... We use the "hostlab" template from Themeforest : The idea is to have buttons on the top of the page like 'AMD Servers" "Intel Servers" "Budget Servers" "Storage Servers" Once clicked, these buttons would load the corresponding Server and details displayed in vertical columns instead of horizontal ones as it is now. Having the same king of drop down menu as hetzner to show/hide some features is also a plus.

I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates and seek clarif...

Project Duration: 1 Hour Project Type: Python Script Modification Project Level: Normal Server Type: Ubuntu 22.04 Number of Changes Required: 1 Project Overview: We have an existing Python script that allows us to upload a CSV with two columns: Prompt Output The script then submits each “Prompt” to the OpenAI API, inserts the output into the “Output” column. We would like one change made to the existing script. Change Required: We would like to add one more column to the CSV file, “Id”, it will be the first column. We use “Id” as our own reference number for the row This column and its value should be retained in the output file. 5* FEEDBACK WILL BE LEFT FOR YOU

...data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accurately. - Experience with design: To create visually appealing tables using borders and shading. - Organizational skills: A m...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

I need an experienced Python developer with solid skills in webscraping to gather data from the Premier League's stats page (). The required task involves capturing all available statistics and organizing them into rows and columns within a single CSV file: every season is a row, with different statistics as columns. Applicants should be able to provide the following: - Evidence of past work, particularly related to webscraping. - Their robust experience in Python language and relevant industries. - Detailed project proposals outlining strategy and timeline. Given specified needs, Python is the preferred programming language for this project. Previous experience in similar webscraping projects is desirable, demonstrating your ability to

Hi, I need to create a new script based on our existing scripts. Have two parameters: one for sheet ID and and one for collection. When you run the script, it extracts all data from that collection and puts it into a sheet tab with DateTime as tab name. Also can handle collections within a collection and create them as separate columns on the sheet.

I need a skilled python developer to create a JSON to Excel converter. Key Requirements: - You'll be working with Flat JSON data - How to handle missing data is up to you - Mapping of JSON fields to Excel columns is flexible Ideal Skills: - Proficient in Python - Experience with JSON parsing - Excel manipulation skills I'm open to suggestions on the best way to map the data, so please include your ideas in your bid. Let me know if you have any questions.

This project is open only to individuals. Agencies need not apply. Freelancers with no rating need not apply. Generic copy-paste responses will be marked as spam. Your past freelance feedback should clearly show that you have completed similar tasks...deliver results fast, as the project needs to be completed ASAP. Please note that the sole requirement is to extract the body of the news articles with no need for the title, date or author. Let me know your approach and estimated timeframe for completion and budget. I give you (English only) - Google News search keywords, (possibly 500K-1M news articles) You give me - excel file with two columns (possibly split excel file based on year/month) A- URL to the news article B- article body (no photo, video or XML tags, ONLY text of...

I am in need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensive experience in manipulating and formatting excel reports. I am...

I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I appreciate your...