Rows工作

I am looking for a freelancer proficient in Excel who can efficiently handle data entry tasks. These tasks involve inserting text, numbers, and dates into Excel tables for a set of up to five tables. Each table will feature six columns and a variable number of rows. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in data entry - High attention to detail - Familiarity with text, numerical, and date-focused data - Ability to work within specific formats and structures. Your role is critical in ensuring these tables are filled accurately and promptly. Clear communication and commitment to the deadline are also imperative in this project.

I require an experienced data entry specialist with proficiency in Microsoft Excel to assist me. The tasks involve: - Inputting and organizing relatively small amounts of data (less than 100 rows) - Analyzing data and generating reports Ideally, the freelancer should be familiar with Excel formulas and macros. Good data interpretation skills and attention to detail are needed to accurately analyze and reports the results. A capacity for hard work is also appreciated, as I am dedicated to this work and will need someone who can keep up.

I need an expert to masterfully apply and tweak formulas and functions across entire rows and columns within my Excel spreadsheet. Your tasks will be to: - Implement formulas and functions - Apply them to entire rows and columns Ideal skills and qualifications for this job would include advanced proficiency in Excel, especially in applying lookups and mathematical functions like SUM, AVERAGE, COUNT. Proven experience with similar projects is highly preferred.

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

Hello I have excel file with many products link in side by side and product serial number in column 1 can you make alll links into rows as per there respective serial number?

... Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num, Owner 1 name, Owner 1 aka pxt_own When the account number is listed twice, as in rows 81 and 82 will become owner 1 and owner 2 for account number 0010190000027. This data will become columns of data in the master file Parcel_tieback - don't use this file Permits - don't use this file Real_acct - 1,048,577 lines. This is the 'master'. The other text files will be merged

As the owner of a large SQL Server database, I'm looking for the expertise to convert my SQL Server code to Redshift SQL. The database in question is greater than 10GB and primarily contains valuable customer data. The ideal freelancer for this project should: - Have a strong understanding of SQL and Redshift - Exper...customer data. The ideal freelancer for this project should: - Have a strong understanding of SQL and Redshift - Experience in data conversion of Stored procedures, views, functions etc., specifically from SQL Server to Redshift - Familiarity with transforming and restructuring customer data Your job will be to ensure the correct and efficient migration of all customer data without loss of any rows. Be prepared to handle the larger data volume of this SQL ...

As a client, I need someone proficient in handling Google Sheets to manually enter text data. This project entails working with a document containing less than 100 rows and 10 columns. Ideal Skills & Experience: - Proficient in Google Sheets - Attention to detail - Experience in data entry Your job will be to ensure accurate and efficient data entry of the given text. This task should be completed with minimal errors and in a timely manner. Experience and efficiency in handling similar data entry tasks is highly valued.

I am in need of an Excel expert who can successfully create rows in an Excel sheet with a dropdown list that allows multiple choices. These choices should be exclusively filled with text data. Key project tasks include: - The text data should be extracted from pre-existing Excel sheets that I will provide. - Any row that utilizes these dropdown lists must be color-coded differently, with the format contingent on differing data values. Ideal skills for this job would primarily include advanced knowledge of Excel or a similar spreadsheet software. Familiarity with text data extraction and color-based conditional formatting would also be of advantage. Previous experience managing similar tasks and a keen eye for detail would make you a standout candidate.

Looking for a developer to help me create a custom CRM management system to follow up with clients. Need to be able to add notes, select next follow up date, and as...like to offer subscription to it for other real estate team leaders like me, who don't have a perfect solution to assign company leads to their staff and oversee them. I didn't figure out yes where I should sell this service, in Salesforce Marketplaces, HubSpot Marketplaces, or on my own website. Looking for ideas. I tried to use a free version of HubSpot and it has way too many features, tables, rows, etc. I would like to simplify it, add Twilio for SMS capabilities, and add Chat GPT to analyze notes for each lead to suggest what to talk about at next follow up. Please let me know if this is something you ...

I need to restore a table from the database. I noticed someone was trying to exploit the database and some records are lost. There is no backup... can we restore this from the ibdata file using a restoring tool? Need to retrieve deleted rows.

...React. Your job is to develop a file file uploaded should handle a server call on init, exchange apiTokens (REST API is provided) and if the token is valid, then display a file uploader button. If the user click on the file uploader he/she can do the following steps within a wizard: - Select the csv/xls/json file - Select worksheet (optional) - Display preview table for the first 6 rows - Map headers to headers coming from the REST API - Data validation - Data upload Ideal Skills * Proficiency in JavaScript, particularly VanillaJs, Angular, and React * Experience in developing file uploader libraries * Able to work on an exciting and urgent project * Knowledge in file upload functional elements * Clean code Full brief:

I require a meticulous professional to aid in text and numerical data entering into an Excel file. - Data Entry Scope: The workload involves entering 850 rows/5 columns of data into 1 workbook/28 sheets . This is a one-time assignment needing immediate attention. - Skill Set: The ideal candidate would have experience in data entry and a keen eye for detail to ensure accuracy. Proficiency in Excel is a necessity. Looking forward to a productive engagement.

I need an urgent developer who can work on this following fixes - 1. In this login Section Add Header and Footer from this page 2. In this page fixes - 1. In this login Section Add Header and Footer from this page 2. In this page Remove Extra Parameters which I will mention 3. In the Product Details Page For Example in this page - Segregate the parameters table into 2 rows 4. Lastly on Product listing Page Filter Criteria I want to add Filters like the one on this page - Timeline - 4-5 hours Budget - 3k

...where symbol is a string and date is in format yyyy-mm-dd 1) the directory contains a large number of CSV files that are named like: data20210315.csv. These files will change so please do not hardwire the file names I give you as examples into your code. You should get a dynamic list and sort them by dates before you read each one of them to construct the dirionary. 2) there are thousands of rows in the CSV file and each row is to be processed and put into a large dictionary indexed by [date][symbol] for example AllData['2021-03-15']['AALBF'] and the next level of keys and values one example of a row is: 20210315|AALBF|Aalberts Industries NV Ordinar|S|OTC|45227|54284||0|999.99||-16.68|-9057|2019-12-31 you should turn this into a dictionary...

...formatting and styling - Data extraction from documents The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is defined to have the text hidden. If I deactivate the "Show all" function again, the rows whose checkboxes were deactivated should no longer be visible. So ultimately I want to be able t...

Looking for an expert in Excel 2019 or Office 365 to assist me in analyzing a small dataset of fewer than 1000 rows. The task involves: - Using advanced Excel formulas and functions - Data analysis and interpretation - Creating compelling visual representations of the processed data Strong proficiency in Excel 2019 or Office 365, a deep understanding of Excel formulas, functions and data visualization techniques are absolute necessities for this project. Previous experience with data analysis in Excel will be advantageous. The work should be delivered promptly and meticulously.

I hope to engage an Excel user who can construct an easy-to-use formula for automatically duplicating rows based on a stated quantity in a selective column. Here's what I need: - A formula that reads a specific column and replicates the entire row underneath based on the quantity listed in that column. Ideal Candidate Characteristics: - Has basic knowledge or is at least a beginner level with Excel to create such a formula confidently. - Experience with Excel formulas is a must. You should be able to present verifiable examples of your prior work where you successfully developed Excel formulas. Please include your previous experience with Excel formulas in your proposal. If possible, providing an example of a similar work where you successfully accomplished row duplicatio...

请注册或者登录后来查看详情。

In this project, I require assistance in extracting numerical data from an existing excel sheet and placing it into a table. The extracted information should maintain the current format present in the excel sheet, without any additional emphasis on alphabetical or ascending numerical order. The ultimate aim is to create a table where the extracted data will be allocated to both rows and columns. - Ideal Skills: Proficiency in Excel and data visualization, keen attention to detail, good understanding of data organization and manipulation. - Experience: Previous work involving data extraction or conversion from excel to other formats is bit of a necessity here.

More details: What specific data do you need to fill in the Excel sheet? search for startups in 2023 you will see relevant info to fill in. What type of information are you looking to fill in for each startup? will need to create a free crunch base account and fill details in excel What specific details do you need to fill in for each startup on the Crunchbase account? Company description, Founder names, Funding details, etc. I will provide sample sheet for 2023.

I am in need of a freelancer with excellent attention to detail to enter both text and numerical data from PDF files into an Excel sheet. The work involves: - Typing data from PDF files into Excel. - The Excel sheet has between 50 and 100 columns and rows. The perfect candidate will have: - Experience in data entry - Accurate typing skills - An excellent understanding of Excel - Previous experience with PDF to Excel data transfer. All information required for this project is contained in the PDF files. Accuracy and adherence to the format and structure are vital. This is a straightforward task, yet attention to detail is crucial.

More details: What is the main goal of setting up the Power BI data model? Create interactive dashboards What type of data sources will be used for the Power BI data model? Excel spreadsheets What is the complexity level of the data in the Excel spreadsheets? Medium with multiple columns and rows

Given Three Spreadsheets (attached) - Sales 2022, Sales 2023, and VAT records. I need someone to copy the "Customer Field" from VAT records into the Sales 2023 and 2022 speadsheets. The first three rows in Sales 2023 are complete already. i.e. 20/12/2022 DXEFWQLLOV7 - AWV- SP 4,221.22 GDC (USA) Means that you look for a transaction on 20/12/2022 for 4,221.22 on the VAT records sheet, and copy the customer name accross to the Sales 2023 spreadsheet. The transactions should be all in order., and there should be about 300 in total. No accoutancy skills required, just copy / paste. - it's an easy job. payment will be on completion, please show your work after doing the first 20, so that I can make sure you have understood the job. Rules as per always, never b...

I need a sketchup dynamic component for customers to do shading and site layout for solar arrays. The configuration variables are module width(text entry), module length(text entry), module column(text entry), module rows(2;3;4;5), array tilt angle(degrees), front edge ground clearance(text entry), pole size (6;8;10)inches, pole spacing (15;17.5;19.75;22.5)ft.

...for my book club. The Sheet should be designed to import 10-20 fields from a Google Form and automatically sort relevant information where necessary. I can share the form I've created, but the general idea is book title/author/cover art/genre/review/reviewer/recommendations ... I would like drop-down menus to expand and collapse categories under genres, with clean space around the columns and rows. The ideal candidate for this project should possess the following skills and experience: - Proven experience in form design and Google Sheets - A strong understanding of automated calculations in Sheets - The ability to develop an aesthetically appealing, minimalistic visual design. Creativity is welcomed. The goal is to move from a giant, manually updated Google Doc to for...

I am looking for an experienced data analyst who is well-versed in PySpark to clean up a medium-sized dataset in a CSV file format. The file contains between 10k-100k rows, and your primary role will be to: - Remove duplicate data entries - Deduplicate the dataset - Handle missing values - Aggregate the resultant data Your proficiency in using PySpark to automate these processes efficiently will be critical to the success of this project. Therefore, prior experience in handling and cleaning similar large datasets would be beneficial. Please note, this project requires precision, meticulousness, and a good understanding of data aggregation principles.

You need to collect local business details out of Facebook groups and put them in an excel file. Data fields are: Source (posting url) Kind of business (like “painter” for instance) Name of business Contact Person Name (optional) Phone if available Email if available Phone is preferred but if not possible then email is ok. Please make your offer for 100 data rows aka 100 businesses and mention the word Australia at the beginning of your application so I know you have been reading the instructions. We will provide the local Facebook groups where the businesses post. Some of them you need to join first, others are open.

请注册或者登录后来查看详情。

More details: What type of data do you need to type into the Excel sheet? Numbers How many columns and rows are there in the Excel sheet? 10-20 Would you like me to create any specific formulas or functions within the Excel sheet? Summation formulas, Average formulas, Lookup and reference formulas

This vital task entails cleaning and sorting two CSV files of approximately 100,000 rows and second one of about 1.5million rows using pyspark (Python) in Jupyter Notebook(s). The project consists of several key tasks: Read in both datasets and then: - Standardizing data to ensure consistency - Removal of duplicate entries - Filtering columns we need - Handling and filling missing values - Aggregating data on certain groupings as output Important requirement: I also need unit tests to be written for the code at the end. Ideal Skills: Candidates applying for this project should be adept with Pyspark in Python and have experience in data cleaning and manipulation. Experience with working on datasets of similar size would also be preferable. Attention to detail in ensuring ...

I need someone to fill in the spreadsheet below 3 times now and 3 times a week after that. I will pay (escrow...attachments. Excel Spreadsheet: Time Speed Bottom Left - 1 zip files: Snapshots Part 1 and Part 2 contain 516 JPEGs. WHAT NEEDS TO BE DONE: Look at JPEG Snapshot_5. There are 3 numbers: Time: 3000 Speed: 1.5 Bottom Left: 70 (Ignore the number 000 at the bottom right.) Look at the Excel Spreadsheet and the zip file Snapshots Part 1. Two of the rows are filled in with the numbers on the first two jpegs in the zip file. Your job is to fill in all rows of the spreadsheet using the 2 zip files of jpegs. (There is also an extra column and row to write any problems, questions or comments you may have.) Spam Bot test: 1. When can you start? 2. How long can you work on...

... I have included an image showing the "reasoning" columns (D-J) which needs to be split into 3 sets of data (K-Q), (R-X) & (Y-AE) I already did the first row manually. For this job you need to split the cells into the target rows and also have a QA step and recombines the split data into a "QA Check" concatenation. Then a final check to verify that the original = QA check. This is to verify no data was lost. Here is a read only link to the sheet: https://docs.google.com/spreadsheets/d/1TiyKKNjrEHeCrNySmmiD9xWQXTjd1OAh-8fUluSLRR0/edit#gid=420694380 rows 4-509 need to be done. Only work with the new fields, do not edit the original data This needs to be done with formulas, not manually. For an excel/google sheet expert this should be a 1...

I urgently require a SQL query for my php code. It should basically delete rows from two tables

I'm looking for a professional who can efficiently input a variety of data types into an Excel spreadsheet. The data will be both text and numeric, along with dates. Key Project Details: - The spreadsheet will contain less than 100 columns and rows. - Data will be sourced from online resources. - Please ensure accurate data entry and review all entries for completeness and consistency before delivery. Ideal Skills: - Proficient in Excel - Attention to detail - Strong research ability and adept at sourcing information online - Accurate data entry skills

I need a freelancer who excels in Excel to carry out some basic data entry tasks of 7 columns in 75 rows. I attach the excel sheet. Please note that you will get the information from the first page of the reports attached here. The pdf file name is the project id identifier. Note: appraisal_complete is basically closing date appraisal. You don't have to add any additional information apart from the ones I asked for in the excel. In essence, you will be entering numeric and date data, with formatting required for the date data. This task is simple, therefore no complex formulae or data validation will be needed. Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience in data entry This should be a straightforward job for someone with the abo...

...sheet to a new sheet called "BORSE-TIROCINI". In this case there must be a button in the sheet that allows you to open a new userform, the "userform3" where, thanks to a search box, some fields of a record of your choice present in the "CEL ANNUALE" sheet can be retrieved and entered as such. data in the " BORSE-TIROCINI " sheet by inserting them in the first free row of the table and sorting the rows in alphabetical order according to the "surname" column. Clarifications: 1) For the realization of this project I will provide the excel file with the userform1 ready, except for the functions described above (part 1 and part 2) 2) in each sheet there is data formatted as tables. All columns managed via userform1 (all sheets with ...

For this project I need an ...file). The program should: 1) Use pyperclip to 2) search the data file for the value in the clipboard. 3) If that clipboard value is: a) found - copy the entire line from the data file to the clipboard b) not found - save the string "None" to the clipboard. 4) This should operate quickly and not open a console to the desktop when used. This program should operate with a dataset of up to 20,000 rows. So I can avoid the bot bids, please mention the word "Acer" when bidding. Any bids from Russia will be eliminated. English language, prior experience, reasonable price and completion in such projects will be considered as an added advantage. Your winning bid and satisfactory outcome can also qualify you for future projects. Thanks f...

As the owner of an existing MySQL database, I'm currently experiencing issues related to oversized databases which needs to deleted not needed files. While I'm currently unsure about the exact number of records or rows. Ideal candidate for this project will have: - Deep expertise and experience with MySQL databases - Proven track record of mitigating issues related to large data volumes - Ability to potentially develop a sustainable, long-term solution to prevent future issues - Strong communication skills to guide me through the process Tasks would include: - Assessing the existing database and identifying the main areas causing high data volume - Implementing efficient strategies to optimize the database - Testing the database to ensure the issue is resolved Through...

...Language: CSS Backend: Framework: Node.js Database: MySQL The web page should consist of three pages, all linked and accessible by clicking on the grid. Below are the details for each page: Page 1: Store level Monthly Sales Sum Display monthly sales sum where stores are in the rows and months are in the columns. Page 2: Store-wise Highest Hierarchy2_id Product Sales Display product sales for each store based on the highest hierarchy2_id. Page 3: Store-Hierarchy Matrix Display counts of products sold with stores in rows and hierarchy levels in columns. Additional Requirements: Add a scroll feature where missing. Implement a feature where clicking on a store column in the first page navigates to the second page, displaying store-wise details only for that specific store....

I'm seeking an experienced freelancer with a strong background in Word automation and document editing. Using the “Account #” as the reference point, I want the highlighted values in the paragraph below to be automatically looked up from the values within Table above. Each quarter the Table above will change in terms of the values in the two right columns, and the number of rows will also change. I would like the paragraph to again automatically lookup the referenced values from the new Table. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing....

Scope: The project entails processing a dataset comprising 1850 rows, with each row containing 3 cells of data. Additionally, 634 folders are to be meticulously prepared as part of the project requirements. Estimated Delivery Period: I anticipate completing the project within a timeframe of 3-5 days, ensuring timely submission of deliverables to meet your expectations and project deadlines.

I am in the need of an experienced Vue developer who can make some specific modifications to a Vue template that I'm working with. The task at hand involves: LAYOUT CUSTOMIZATION - Adjusting the header and footer - Rearranging the sections of my template(slot items need to be properly aligned) - Altering the font styles - Rows and columns need to be formatted based on conditions FUNCTIONALITY ENHANCEMENTS - Implementing a search feature into the template Having prior experience in Vue.js, strong CSS knowledge and an eye for good layout design is a must. Experience with implementing search features is also highly desirable. Please provide examples of Vue.js work where you've done similar tasks. This is a one-time project but could lead to more work in the future if d...

...just concentrate on the 45 day one. 3. The Power Automate flow should iterate through the rows in an example spreadsheet I can provide. 4. Filter the data based on certain criteria. I have a number of other criteria, but I’m certain I can add additional ones that I need once the framework is in place. So, for the flow I’m asking you to create I would need to filter the spreadsheet for: 1. invoice date (so if doing the 45 day flow, all invoices that are at least 45 days old), 2. filter out any rows that have text in any of the following headers: Hold until, Payment Plan, No reminder, leaving only the blank columns, 3. If the ‘Sent 45 days’ column has a date in, remove these also, leaving only the blank rows (for the later flows, like the one s...

I'm seeking a proficient Excel expert capable of creating an efficient lookup file for me. The premise is to compare product names and SKU numbers across a medium-sized dataset, ranging from 101 to 1000 rows. Time efficiency is paramount, as the project needs to be completed ASAP. Ideal bidders will have: - Outstanding proficiency in Excel, particularly in creating and managing lookup files. - Exceptional attention to detail to ensure accuracy in comparing product names and SKU numbers. - Ability to deliver a fast turnaround time as this project needs immediate attention. Thank you in advance for your time and bid.

Hello, I need a Python or other programming language expert that can import my Excel file using libraries like pandas and openpyxl and then manipulate data as per my requirements below. - The data is Food recipes of around 30 columns x 50,000 rows (in 3 different files) - Consider 3 main parts of recipe 1. Ingredients, 2. Steps, 3. Other info I need modification in 1st part (ingredients only) - I need you to give me a new cleaned Excel/database file of the list of ingredients in all total 3 files - Add a primary key to identify all ingredients and write this key in the recipe database instead of the name ONLY EXPERTS WHO HAVE FULL CONFIDENCE SHOULD APPLY, its not something a new person can do

I need an expert in woocomerce to customize my store in order to allow customer-specific pricing. Each customer will have their own unique pricing, which will be pulled from the database <customerPriceTable>rows consisting of [customer id], [sku], and [price]. Key Functions include: 1. Hide prices and cart from guests 2. Hide prices for items that customer does not have in the <customerPriceTable> 3. Request: If a customer does not have a price, they should be able to request it by clicking a button on the product page. 4. Admin Notification: As soon as a customer requests a price, a message should be sent to the store admin. 5. Database Logging: The request should also be logged in the database for future reference. Ideal skills for this job include: - Proficien...

I require a skilled data entry specialist to handle an Excel sheet that involves the aid of typing in a combination of different data forms: Numbers, Text, and Dates. - The sheet you'll be working with houses 10 - 50 columns and rows, so attention to detail is paramount. Ideal skills include: - Excellent knowledge and experience in Excel - Ability to accurately and swiftly handle data entry - Proficiency in handling multiple data types This project focuses strictly on data entry alone and does not require any data analysis skills.

I require a skilled data entry specialist to handle an Excel sheet that involves the aid of typing in a combination of different data forms: Numbers, Text, and Dates. - The sheet you'll be working with houses 10 - 50 columns and rows, so attention to detail is paramount. Ideal skills include: - Excellent knowledge and experience in Excel - Ability to accurately and swiftly handle data entry - Proficiency in handling multiple data types This project focuses strictly on data entry alone and does not require any data analysis skills.

40k rows of data checking as discussed