Rows tabs työt
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
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...
...terpenes) 5 slots when hovering over the products slot a picture of each item should appear Dotted around the menu i want an offers menus like 'stoners special' which is a mix off all items on the menu for a set price , and also an appealing 'care package' button which redirects to a products page with ten options patreons and customers a like can send care packages to fellow stoners as gifts Tabs homepage / The Menu (as described above) should fit the whole page /screen no need for scrolling The Shop ( basically a head shop with bongs grinders clothing and even food The Mysteries ( A page like a blog/ where i upload my video content ) About page Contact page and any pages you deem necessary Overview: Create a visually captivating me...
...the typography and color scheme: The current state of these elements aren't as appealing as I'd like them to be. Your input on what fonts and colors would make our site attractive is necessary. - Streamline the layout and navigation design: We anticipate a website that provides a seamless browsing experience for our visitors. An interactive design that encapsulates this is required. - Add new tabs/pulldown menu: These should enhance faster navigation through our platforms. Speed is of the essence; therefore, the ability to quickly understand project needs and execute them would be appreciated. Proficiency in UX/UI design, ability to work under pressure, and a keen eye for detail are key skills required for this role. Please note, this project needs to be completed at...
... 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 have a flutter app already designed as 4 tabs views with all details, I want to redesign it with a design I already have.
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....
1) My website website information ...content within the red box to display the corresponding detailed content. Click again to exit the detailed content and return to the main product page interface. Current Situation: shows the current product page information on my website. Each tab content needs to be manually expanded, and the content is very long. Users need to scroll to the bottom to view it all. To view other tabs, users need to scroll up for a long time. b) Optimize Product Information Layout on Two Pages Problem: The product information layout on the two pages in is not aligned. Goal: Optimize the layout for consistency and readability. Pleae check c) some some modifiction on product page , Communicate in detail after confirmation
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 urgent need of a dedicated virtual assistant fluent...Proficiency with Microsoft Excel and an understanding of its usage for data management. - An acute attention to details to ensure data accuracy. - Proficient typing speed for quick data entry. - Data management and administration experience are beneficial. I will provide the sources from where the data is and can be accessed for input into an Excel workbook I have built. See attached workbook. The tabs are broken out by states here in the USA. Please note that this project will require some degree of versatility, as information and data will come in various formats and sources. Flexibility in handling these variations is important for smooth operation. Reliable time management skills are crucial to meet the deadline...
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...
...this project should possess the following skills: - Experience in web app development - Knowledge of sports statistics/scores - Familiarity with Live Score API - Ability to translate API data into user-friendly interfaces - Good eye for modern and sleek design. UX requirements (Root) ** The navigation and information is very similar to OneFootball app. it should have a tabbar navigation, with Two Tabs as root navigation: (Calendar Screen) and (Competitions Screen) - (Calendar Screen) -- It shows a scrollable calendar view on top. When a date is selected, it shows a list of games for that date -- When a game is selected, it navigates to (Game Screen) - (Game Screen) -- Show the Home and Away team on top --- When either team is selected, it navigates to (Team Screen) -- Shows th...
I'm in need of a proficient developer to design a web-based rental management system geared towards tracking office equipment leases and Payments. Specific responsibilities include: - Creating a property listing feature to advertise available office equipment - Developing a tenant management module to monitor equipment usage and condition - Integrating a payment tracking functionality to keep tabs on rental fees The ideal candidate for this role should have considerable experience in web development and a solid understanding of rental management systems. Any familiarity with office equipment will be considered an advantage. I look forward to checking out your proposals.
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
...tailored specifically for our auto repair shop. As the owner of an auto repair business, we understand the importance of streamlined operations and effective inventory management. We need a comprehensive software solution that allows us to: Track Sales: Monitor daily, weekly, and monthly sales figures, including detailed breakdowns of services rendered and products sold. Manage Inventory: Keep tabs on inventory stock items, including real-time updates on quantities, reorder levels, and supplier information. Ability to manually adjust inventory levels as needed. In/Out Stock Management: Efficiently handle the movement of inventory in and out of stock, with easy-to-use features for manual input and tracking. Key Requirements: Experience in developing software solutions for sm...
I'm seeking an experienced freelancer to fix several issues with my existing website () focusing mostly on minor problems. Please put word "human" in your proposal, so I know ...across the site to be fixed. Pictures to be aligned when browsing. When clicked on picture there should be option to move pictures left and right with arrows (on side in the middle). To have small circles below pics representing each picture. • Products page (ie Windows) should have product name(Windows) to be on the left side in the same line with the products names navigation bar (vs above the tabs as is) • Change favicon • Make it mobile responsive. We're also open to changing our design completely, to a new layout/design recommendation regardless of technology us...
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 need someone who is savvy in Excel and spreadsheets. My project involves the following: - Analysis and creating reports from a myriad of data sources which are of medium complexity. - Formulating and implementing functions to streamline the data analysis process. - Design and formatting of the spreadsheet is vital as I'm looking for a complex workbook setup with multiple tabs. -Creating metrics with sales, operation and payroll data The ideal candidate should have proficiency in data analysis, formula creation, and spreadsheet design. A keen eye for detail and the ability to handle complexities will also prove beneficial for the completion of the project.
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...
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.
I'm looking for a seasoned Excel expert who can effectively assist us in cleaning up a medium-sized data set of 1,000 - 10,000 rows. The data is relatively simple with few columns but requires some attention to detail nonetheless. The ideal candidate should: - Be experienced in removing duplicates from data sets. - Possess skills in formatting data to enhance readability and accessibility. - Have solid competency in filtering data to focus on relevant information. These three skills are crucial as we work towards having a clean, seamless, and usable data set. Accuracy, efficiency, and the ability to pay close attention to detail will be key in the potential freelancer. This is a task that requires a deep understanding of Excel functionalities coupled with practical experience...
Hello. I have some Excel Sheets whereby I have some tables in them. I want to protect the sheet. However, when I do so, I notice that I cannot add additional rows to my tables. I need to be able to lock my sheets and add additional rows to my tables when I need them. It is worth noting that I am also copying data from one table to another on a separate sheet sometimes. I want someone to solve this problem for me, and make me a small video to show me how to do it. I need it explained in perfect English in a way that I understand. In simple terms. I am not a coder or anything like this. Although I am good at using Excel. I made a video for you to check, it is a short video. I have the link on the pdf document.
I am seeking an individual with proficient skills in Excel and a keen eye for detail. Your main task will be translating handwritten documents containing text, numbers, and dates into formatted Excel spreadsheets. This will require: - Accurate data transcription from handwritten documents into Excel - Filling out more than 20 columns and rows per sheet - Proofreading and immediate correction of errors The ideal candidate should have extensive experience in Excel and data entry, plus superb attention to detail. Knowledge and practice in inputting handwritten data would also be beneficial. Make sure to include any relevant data transcription experience in your proposal.
I need a specialist to create a software solution that can streamline order management and provide a comprehensive vision on customer data. Key responsibilities: 1. **Order Management:** - Implementation of order tracking to keep tabs on project progression - Setting up automated notifications, easing the process of updating customer information regarding their orders - Developing a system to organise orders by date and time, using a priority approach 2. **Customer Data Management:** - Building up customer profiles with inclusive data about all interactions - Recording order history, to provide an overview of customer orders - Establishing customer communication logs, maintaining a good record of all customer communication The apt freelancer should ...
I am in need of a proficient Excel automation specialist. This job requires updating an existing workbook with new data, automating the creation of rows, columns, and formulas and allowing for an undated workbook to be downloaded without having to re-create all the formulas etc. I am open to the choice of programming language used for the Excel automation, eager to discuss your expertise and preference. Here are the expected tasks: - Modify an existing workbook with new information - Automate the import of current workbooks - Automate the creation of rows, columns, and formulas The frequency of these tasks will be dictated by our data download schedule which is done on an as-needed basis per job schedule. Ideal candidates will have a solid background in Excel automation and...
I require a comprehensive spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the following aspects: - Fees - Number of transactions closed - Average price point - Stock options - Agent attraction For the 'number of transactions closed', I wish to use a preset value for each brokerage. Moreover, I want the 'fees' data structure to be tiered. Candidates with excellent Excel skills are preferred. It's also beneficial if you have a good understanding of real estate brokerage fees and structures. Attention to detail is essential as the spreadsheet needs to allow for a deep and thorough analysis.
...and experienced PHP developer who will create a simple PHP script for a MySQL database. Details: * The script must be able to accept a list of codes, that can be easily inputted through copy-pasting into a text box. Each code must be listed on a new line. * For every inputted code, the script should locate the corresponding entry in the MySQL database, where codes are structured as separate rows. * Once matched, the code's associated value must be altered to a specified number, which will be inputted into a second text box as part of the script interface. Additional Requirements: * If a code cannot be found within the database, the PHP script should skip that particular code and a warning message should be displayed to the user. Key Skills: * Proficiency in PHP and M...
I need a freelancer with proficiency in data input, specifically text data into CSV files. The project involves: - Entering less than 1000 rows of text data into a CSV file. - Ensuring accuracy and precision in every entry. - Maintaining confidentiality of the data. Skills Required: - Proficient in using CSV files - Superb attention to detail - Conversant in English to understand text data Experience: - Proven track record in data input jobs. - Experience with CSV files will be given preference. This project is straightforward and requires high attention to detail and precision.
Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the
...created and added to the context of the website to draw visitor's attention and increase user interaction. - Blog Page Enhancement: Both content editing and layout improvement are required on the blog pages. The goal is to ensure a visually appealing and reader-friendly environment that holds the attention of the visitor. - Plugin Revision: An existing plugin which provides extra details on content tabs needs editing. The objective is to adjust its display to align with our specifications. Ideal candidates will be experienced in graphic design (for banner creation), content editing, website layout design, and have a high level of technical proficiency to handle the plugin modification. An understanding of user experience elements is also highly valuable to this project. ...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I need a web application developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and...
I need a web application developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and...
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 am in need of a Python wizard who can scrap textual content from a specific website and save the data...scraping script can handle errors and won't crash. - Can design the script in a way that it respects the terms of the website and avoids the potential of getting blocked. - Are meticulous and careful in ensuring the accuracy of data being scraped. - Include a fully commented file explaining all functions - Include a function that allows me to define the number of rows from the input file to be scanned, or to use -1 to input all rows. Your role will involve accessing my chosen website, pinpointing the textual content needed, and constructing a Python script to automate this task. Deliverables will be the output file for each script, and the python scripts to allow m...
I'm in need of a skilled freelancer to develop a multi-page spreadsheet for handling financial data. This is a complex task, necessitating expertise in working with calculation formulas and data validation. Key Responsibilities: - Incorporating comprehensive calculation formulas into the spreadsheet - Implementing rigorous data validati...Proven experience with financial data management - Expertise in creating validation rules and complex calculation formulas To apply for this project, please present a detailed project proposal. Project summary is as follows: format attached concept draft to sort expense codes from tab EXPENSES at each month end to appear as summary on relevent tabs 101, 102 etc. Property allocations identified on EXPENSES needs to follow through on the ...
I'm looking for a data analyst who will take the text data in my CSV file and streamline it for import into a database. My project will involve the following tasks: - Consolidating vast amounts of text data, approximately 23,000 rows, 140 columns (CSV). - Cleaning up any discrepancies, repetitions, and inaccuracies, - Organizing the cleaned data into fields provided by me. - Deduplicate data. - Simplify some data to reduce the total number of permutations. e.g. "Dark earth green" and "Pine forest green" would become "Green". This data is from the scraping of an ecommerce store with physical products. The ideal candidate for this project will have strong experience with text data management and data cleaning in spreadsheets. Being detail-oriented...
