Cellsproiecte

...select an employee and I click on a cell from table, I should be able to insert that employee in that cell. I will insert the selected employee on each cells that I click. Employee will be inserted first in database and if was inserted with success than will remain inserted in cell, otherwise an error message occur. You will understand more from picture below. If at the end I will like the page/work, than I have more work to give to the awarded freelancer so we can collaborate for others project. A very small idea about this table you can see here : (i try here to simulate something...just click on table cells). If you do not understand something...just ask! Picture design is not the final one...the final design should be much better. More details/specifi...

I need a proficient Matlab Simulink professional to simulate the current production in a semi-truck's solid oxide fuel cell. This should take into account multiple variables, specifically: - Temperature - Pressure - Fuel flow rate These should be varied at high levels in the simulation. With a requirement for medium precision, the mod...varied at high levels in the simulation. With a requirement for medium precision, the model should sufficiently represent the real-world scenario without too much granularity. The goal is to understand how these variables affect the current production. The ideal candidate should have a strong background in thermodynamics, system simulations, and Matlab Simulink. Experience in solid oxide fuel cells and vehicular simulations would be a signifi...

I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any r...

I'm in need of a detailed CAD model of a semi-truck, emphasizing the under-the-hood engine components along with a comprehensive solid oxide fuel cell, including its full design with individual cells. Requirements include: - Detailed modeling of a semi-truck's engine components - Comprehensive fuel cell design with individual cells The ideal freelancer for this project would have substantial experience in CAD modeling, particularly in the automotive sector which includes the understanding and ability to depict the complexity of semi-truck engines and fuel cells. Knowledge of the latest semi-truck specifications and an understanding of detailed fuel cell design would be advantageous.

...addressing them thoroughly. - Expected Service: I'm looking for a comprehensive maintenance service that goes beyond a routine check-up. You should be able to identify and resolve the root cause of these multiple issues, ensuring the system operates smoothly, efficiently and correctly again. Ideal Skills and Experience: - Proven Experience: Previous experience working with robotic palletising cells or similar automated systems is a must. - Troubleshooting: A deep understanding of robotic systems and the ability to diagnose and resolve complex issues is vital. - Attention to Detail: The issues have resulted in a variety of symptoms, so a meticulous approach to problem-solving is essential. - Strong Communication: I need someone who can clearly explain the issues and solutio...

I am in need of a proficient excel w...formatting is key, for which I don't have a specific preference, however, creating simple tables, color coding cells, or using pivot tables and charts are all strong possibilities for this recurring project. Since no specific criteria was given, please do include your past work, experience, and a detailed project proposal when you apply. Skills and experience preferred: - Familiarity with advanced Excel functions and formulas. - Experience with data analysis and visualization. - Strong attention to detail, particularly with data entry. - Ability to propose efficient solutions and quick at troubleshooting. - The ability to present data in a user-friendly format (simple table format, color-coded cells, pivot tables and charts, etc.) ...

...Client Name (code), Columns B-K, Row 3 contains the course 14 x units. Column A, Rows, 5 - 19 contains student names. The cells in Columns B-N, Row 5 will include the submission options with a drop down menu or alternatively. The 5 different grading options are: Not yet started Not yet submitted Submitted for marking Partially Complete - More work to submit Competent Each cell and submission option will be selected from a drop down list and needs to have a different fill colour (#b4c6e7, #ffd966, #ffff00, #fff2cc, #92d050). The row directly below the cell will show the date the option was selected and that cell will be the same color of the grade selected. All cells in the spreadsheet will need to change based on the submission option selected so cell references wo...

Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish

I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented, skilled in Excel, a...

My .csv file needs some serious help. Here’s the deal: - Columns aren't properly aligned - I’m finding incorrect entries in certain columns - There's frustratingly missing data in some cells This mess stands between me and importing the data successfully into my database. If you can efficienty wield the tools of data cleaning and if you excel at attention to detail, this could be the job for you. Skills and Experience: - Proficient in csv files management - Highly skilled in data editing, cleansing and validation Please note, I haven’t determined which software I'll use to import the .csv file. Your input on this area will be valuable! I'm open to MySQL, Oracle or MS SQL Server. Let's make things right!

...script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first cl...

...detailed 3D models based on accompanying segmented illustrations. The objective is for the top view of the 3D model to precisely match the 2D illustration. Requirements for Each Model: 3D Structures to Model: - Zona Pelucida (Embryo Wall): Sphere in grey (refer to grey in the 2D image) - Cells: Small ellipsoids, possibly deformed, in pink (refer to pink in the 2D image) - Free Floating Elements: Small spheres, transparent with a black outline Color Scheme: - Embryo Cell Wall (Zona Pelucida): Grey - Cells: Pink - Free Floating Elements: Transparent with black outline 3D Model Specifications: - Format: Voxel format with a resolution of 500x500x500 voxels, in VTK or another suitable 3D file format. - Views Required for Submission: Provide both a standard 3D view and a top...

I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm

I'm in urgent need of a skilled Excel expert to unmerge text cells in my spreadsheet. Here's what I need: - Unmerge text cells - Format the data as requested - Complete the task ASAP The ideal freelancer for this job should have: - Proven experience in Excel - Strong attention to detail - Ability to work quickly and efficiently Please submit your proposal if you can get this done right away.

...multi-column PDF document to be converted into an Excel table. The layout is moderately complex. Here are some additional details: - **Task**: The primary purpose of this conversion is data entry. As such, the Excel table must be an accurate representation of the information in the PDF. - **Layout**: The PDF contains multiple columns of text which need to be correctly mapped to the appropriate cells in the Excel spreadsheet. - **Verification**: After the conversion, manual review and correction are required to ensure that the data has been accurately transcribed. Ideal skills and competencies for this project include: - **Strong attention to detail**: Given the manual verification needed, an eye for detail is crucial. - **Excel proficiency**: A good understanding of Excel incl...

I'm in need of an expert who can assist with entering text data into an Excel spreadsheet. Key Responsibilities: - The primary task is to accurately input text data into the designated cells of an Excel file. Ideal Skills and Experience: - Proficiency in Excel, especially in handling text data. - Attention to detail and accuracy in data entry. - Previous experience in similar projects will be an added advantage. Looking forward to your bids. My typing speed is 55wpm

I have a project that involves entering text data from an Excel file into a Notion table. Key responsibilities: - Extract text data from existing Excel file or Google Sheet [3 specific cells per row. 361 rows total] - Accurately input data into a SINGLE designated field in a Notion table [361 rows total] , with each word separated by a comma. [most words already separated by a comma. This can be done with a "find and replace-all" type command] - Ensure consistency and correctness of data entries Ideal skills and experiences: - Proficient with Notion and [Google Sheets or Excel] - Excellent attention to detail - Previous experience with data entry projects.

I'm in need of an expert who can adeptly identify and fix formula errors in my spreadsheet. Currently, the main issue isn't reflecting a 10% commission in specific cells. My spreadsheet just doesn't show the correct result, which has become challenging for me. To really nail this task, you should have: - Proficient Excel skills - A strong understanding of spreadsheet formulas - Detail-oriented data management skills - Excellent problem-solving abilities Please approach this project with meticulous diligence and an eye for detail. By doing so, we can finally address the incorrect calculations of the commission in the workbook.

I'm seeking assistance with a data cleanup project using MS Excel. - The task involves deleting specific rows and columns from spreadsheets. - The data to be removed should meet particular criteria, which I'll provide. - For rows, the criteria will be either empty cells or certain values. - As for columns, the criteria will be the same. No urgent deadline, so you can work at your convenience. Ideal skills for this job include: - Advanced proficiency in MS Excel - Strong understanding of data handling - Attention to detail - Experience in data cleansing in Excel Looking forward to working with a skilled and efficient Excel freelancer.

I'm in need of an experienced engineer who has a solid background in measurement systems particularly using load cells and load cell amps and basic platform development. The objective is to develop a project which measures loads within a range of 10-20kg , with data input to an Arduino microcontroller. The ability to configure an edge device to continuously stream data to a simple BI dashboard on a desktop is also required. The successful freelancer should have the following skills and experience: - An excellent understanding of load cells and how to operate and interpret readings from them. - Extensive experience using Arduino microcontrollers and able to proficiently program and troubleshoot them. - Knowledge on how to integrate an edge device with this setup, and th...

...content from Figma frames and export it to a CSV format. User Interface: Design and implement a user-friendly interface within the plug-in for importing text, managing templates, and exporting CSV files. Import Functionality: Create functionality within the plug-in to import text content from Figma frames. The plug-in should recognize text layers based on their names and map them to corresponding cells in the CSV table. Export Functionality: Implement features for exporting the populated CSV table to a downloadable file, compatible with Marketing Cloud templates. Template Management: Develop functionality for users to save and load templates, edit existing templates, and delete templates as needed. Templates should be stored locally within the plug-in for easy access. Specif...

... How can we outperform them? - Market size and growth potential: What is the current market size? What is the potential for growth? My Company details - We are into laser source manufacturing, this source is applicable in different application in different industries. Application for automotive - Laser Welding Applications include: airbag components, fuel injectors, pressure sensors, fuel cells, batteries, seat frames, door panels, solenoids, body components, gear components, power train components, antilock brake components, hem flanges, head lights, tail lights, exhaust components, high speed remote welding, aluminum joining, polymer welding. Laser Marking / Engraving Applications include: VIN tags, radio buttons, control panels, mirrors, fuel Injectors, airbag components...

I'm looking for an expert in Excel to develop a formula capable of performing a combination of basic arithmetic operations (addition, subtraction, multiplication, division), statistical analysis (sum, average, median), and logical operations (IF statements, conditional formatting) on a large dataset containing more than 1000 cells. The entire work will only involve a single worksheet. Skills and Experience: - In-depth knowledge of Excel - Proficiency in Excel functions and formulas - Experience handling large datasets - Understanding of statistical analysis Your task will involve: - Creating a user-friendly, efficient formula - Testing the formula rigorously on provided data - Ensuring accuracy and prompt delivery Please only apply if you are highly skilled in Excel and co...

I started writing a Rust app but need some help finishing it. The task is to read CSV files, turn cells into symbols (numbers). And then add a query layer (parser combinator library -> functions -> multi core done)

...seeking a professional with extensive Excel experience who can help convert data from a spreadsheet into a more user-friendly form. Here are the key elements for this project: - Autofilling: The form should make use of specific criteria for autofilling using text. Your proficiency in creating autofill functionality is crucial. - Conditional Formatting: I require a unique approach to formatting cells containing more than one line of text. Specifically, if a cell has multiple line items, they should be combined in the same cell but placed underneath each other. - File Format: The data to be converted resides in an Excel spreadsheet, therefore your familiarity with Excel is paramount. This task requires not only technical skills in Excel but also an eye for detail and an underst...

Hello, In formula mode, Excel only shows reference to cells and not the actual number. I need an excel function that will convert formulas (Cell B4) to actual numbers (Cell C4). The attached image will explain what is needed.

...entered address to get the coordinates using Forward Geocoding. - Admin do not need to register. You can pre-register admin details in the DB. Login Screen: - Admin and Customers can use this screen to log in. Home Screen (logged in as admin): - Logout button: To logout from the app. - Fetch all the customers from Core Data and list them on the Home Screen using a Table View with custom cells showing actionable information about them: o Name o Phone o City o Process Status - The admin will use this information to approach the customers and get them onboarded for the tax filing process. - Process Status types: o AWAITED – when the admin is yet to contact the customer. o FAILEDTOREACH – when the admin tried to but could not reach the customer. Page 2 o...

...and English content. The task at hand involves mixing these two languages within the same LaTeX tables using Overleaf. The detailed project requirements are: - Ability to work with bilingual content (English and Arabic) within LaTeX. Any experience with Arabic typography is considered a plus. - Creating tables in LaTeX, which could contain a mix of both languages in the same cell or different cells, depending on the content's specifics. - The mixed content will primarily be text. The freelancer must have a clear understanding of how text, in both languages, is handled within LaTeX tables. Comfort with Overleaf and an understanding of its functionalities will be advantageous for this project. Ultimately, the goal is to create well-structured, clear, and visually appealing ...

...with a solid understanding of power system models, specifically photovoltaic cells. The primary task will be to simulate the performance of these cells under a variety of shading conditions. The models should include essential circuits and components pertinent to power systems. The ideal freelancer for this project will be adept at manipulating complex models in Matlab and Simulink, with a particular emphasis on photovoltaic power systems. Knowledge of transmission and distribution systems, power generation systems, and load and demand profiles is not necessary for this project. The end goal is to create a simulation that accurately shows the impact of various shading conditions on the performance of photovoltaic cells. You've to implement the full flowchart gi...

...with a solid understanding of power system models, specifically photovoltaic cells. The primary task will be to simulate the performance of these cells under a variety of shading conditions. The models should include essential circuits and components pertinent to power systems. The ideal freelancer for this project will be adept at manipulating complex models in Matlab and Simulink, with a particular emphasis on photovoltaic power systems. Knowledge of transmission and distribution systems, power generation systems, and load and demand profiles is not necessary for this project. The end goal is to create a simulation that accurately shows the impact of various shading conditions on the performance of photovoltaic cells. You've to implement the full flowchart g...

...the project's scope, methodology, findings, and recommendations. - Structure: Include an executive summary, introduction, methodology, results, discussion, conclusion, and references(with APA 7th Ed citations). Excel File with Calculations: - Requirement: Submit an Excel file (.xlsx) containing all the calculations related to the project. - Formula Application: Do not merely input values into cells; ensure each value is linked to the appropriate formula within Excel. This is to demonstrate the calculation process clearly and ensure accuracy and reproducibility. - Organization: Structure the Excel workbook with clearly labeled tabs for different sections of the analysis, such as cooling system efficiency, failure probability, and risk analysis. Arbre-Analyste File: - File S...

I'm in need of someone who can manipulate an Excel spreadsheet I've been working on. Specifically, I currently have the empty cells highlighted in purple using conditional formatting and I want these cells to automatically change to green as soon as some text (typically a name) is entered into these blank cells. This rule should apply to the entire sheet, not just specific columns or selected ranges. What I expect: - Excel professionals, with great expertise in conditional formatting and automation. - Prompt and efficient in completion. - Strong attention to detail. - Good communication skills to clarify any uncertainties.

I'm in need of someone who can manipulate an Excel spreadsheet I've been working on. Specifically, I currently have the empty cells highlighted in purple using conditional formatting and I want these cells to automatically change to green as soon as some text (typically a name) is entered into these blank cells. This rule should apply to the entire sheet, not just specific columns or selected ranges. What I expect: - Excel professionals, with great expertise in conditional formatting and automation. - Prompt and efficient in completion. - Strong attention to detail. - Good communication skills to clarify any uncertainties.

Endoenergy is involved in commercialisation of wearable assistive exoskeletons to help elderly people move around for normal da...dissipation, durability, water sealing and aesthetics • Design and integrate all Battery internal parts and their interconnections to the WAIST Section for operation as specified • User centred approach used in achieving the functionality of the battery system • Aesthetically pleasing design in appearance and usability for removing/re-inserting Battery Pack in WAIST Section • Design and integration of cells, sensors, electronics boards, thermal materials (conduction, insulation, covers), heat sinks, display screen, LED panels, relays, switches, and wiring • IP65 rated waterproofing method • Provision for adjustment method bei...

...assistance with typing documents from audio recordings into a spreadsheet. This task requires careful listening and fast, accurate typing skills. Ideal Skills: - Experience in transcription - High typing speed - Attention to detail - Fluency in English language (to understand the audio) The estimated amount of data to be entered into the spreadsheets is moderate, ranging between 200 to 1000 cells. Therefore, the candidate needs to be efficient and accurate to ensure all information is captured correctly from the audios. Tasks: - Listen to audio recordings - Transcribe them accurately into spreadsheets Please only bid if you have prior transcription experience and can handle a task of this magnitude, I'm hoping to complete this within a timely manner without compro...

I'm looking for a skilled professional to create a superior stock screening financial model. It revolves around the identification of in...spreadsheet's broad purpose immediately obvious? Is the output of the spreadsheet AND its meaning clear to the user? Is your analysis correct? Are there any hard-coded numbers (other than numbers that would never change in the formulas? Can the user (or developer for some of the assumptions) change each assumption and see that the model adequately reflects changes to each assumption? Are all cells and the VBA code labeled appropriately? Does the spreadsheet look aesthetically pleasing? (Yes, colors matter!) Is there evidence of sloppiness in the presentation? Have you gone beyond the minimum to add value to the analysis?

...Theoretical Framework for Renewable Energy Generation - **2.2.1 Fundamentals of Wind Power**: Cover the principles of wind energy conversion into electricity, including the mechanics of wind turbines and factors affecting their efficiency.(a specific literature will be provided) - **2.2.2 Fundamentals of Photovoltaic Power**: Discuss the principles of solar energy conversion into electricity through PV cells, including the impact of solar irradiance, panel orientation, and temperature.(a specific literature will be provided) - **2.2.3 Generation Adequacy in Renewable Energy Systems**: Introduce the concept of generation adequacy, why it is critical for renewable energy integration, and the common metrics used (LOLE and LOLP). #### 2.3 Methodologies for Calculating Wind and PV ...

...purpose of this fuel cell is for hydrogen production. Hence, any candidate should possess deep knowledge and understanding of hydrogen fuel cells and their operation. - Materials Knowledge: The ideal candidate should be comfortable working with ceramics and have experience in their utilization within fuel cell applications. - Temperature Range: The project will deal with an operating temperature range of 500-750 degrees Celsius. Thus, candidates are expected to have experience working with fuel cells operating in such high temperatures. The selected contractor should ideally have a strong background in chemical engineering, particularly in fuel cells, and excellent command on thermodynamics. Previous experience with similar projects is highly preferred. Please bi...

...comparing data from one column with information extracted from a PDF file. Specifically, I require assistance with the following tasks: Data Extraction: Extracting relevant data from a PDF file. Data Comparison: Comparing the extracted PDF data with information stored in a specific column within Google Sheets. Automated Data Entry: Automating the process of inputting specific values into designated cells within Google Sheets based on matches between the PDF data and Google Sheets data. Serial Number Assignment: Implementing a counter to assign serial numbers based on the order of products listed in the PDF. For instance, the first product listed in the PDF would be assigned a serial number of 1, the second product would have a serial number of 2, and so forth. Requirements: Pro...

Need an expert to clean up my textual data currently stored in an excel spreadsheet. This includes: - Fixing the formatting issues present in the dataset - Removing any blank cells to create a more organized and streamlined data view Please note that while the project does not require any specific end format for the text data, I'm looking for someone with a keen eye for detail who can make suggestions to improve the data readability and utility. Success in this project would involve achieving a tighter, cleaner dataset, hence your experience and familiarity with Excel and data cleaning techniques will be crucial.

I have an Excel document that needs to be updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distributed across all the sheets in the document. Key requirements include: 1. The ability to read and accurately interpret all fields from the TXT file. 2. Updated data should be posted to all sheets within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, contingent on your rec...

I have a google sheet where we put 3 paragraphs of data into 1 cell. 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 manua...

For convenience I divide the illustration of the project into 2 different parts. PART1: I have an excel file with an "CEL ANNUALE" sheet which shows some pe...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 the "CEL" prefix) have the same position in all sheets even if to the right of these columns there are columns that can be filled in directly in the Excel worksheet. 3) the excel file (columns, cells and an so on) is in italian language so a little effort will be needed to interpret the column headings 4) as soon as possible I will make the excel file available so you can study it (in the next few I will ...

...production techniques,  which would allow us to prototype green electronic COMPOSITE diodes. Project total : USD$100 Duration : 10-20 calendar days Milestone 101 : USD$20.00 PN compound #1 Durations : 5-7 days In this milestone 101, find 3-5 high quality scientific articles which teach the strength of ion generation by this composition, for solar cells, or water splitting. Compare these values to ordinary silicone solar cells. Possibly advise the percentage difference between an ordinary solar cell and this proposed PN composition, or some other metric to contrast the strength of this diode composition vs. ordinary silicon solar cell. Send copies of all papers, either full text uploaded or url addresses to obtain the papers. Dopants may improve th...

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 seeking an energy professional expert in smart grid design and demand response technologies. The ke...project is to integrate renewable energy sources into a hydrogen-based smart grid. - A key aspect to the project involves designing efficient and reliable portable power applications using fuel cells. - Proficiency in demand response technologies as a means to enhance the overall energy efficiency of the entire design is a major requirement. This project is an exciting opportunity for individuals with a background in renewable energy, electrical engineering, and sustainable technology. Prior experience in smart grid design and hydrogen technology will be a major plus. Demonstrated knowledge of fuel cells and their applications in the realm of portable power will be ...

looking for java script expert for the JavaScript Macro Development to sheet automation the task is - - Writing a JavaScript macro to duplicate the last visible sheet within a file and providing it with a new name as a part of an automated procedure. - Once duplicated and renamed, the new sheet should be moved to a specific location inside the file. - Modi...to duplicate the last visible sheet within a file and providing it with a new name as a part of an automated procedure. - Once duplicated and renamed, the new sheet should be moved to a specific location inside the file. - Modifying the contents of the copied sheet as necessary. - Implementing a notification function once the procedure is completed successfully. - Adding protection to specific cells within the sheet. more deta...

I need a cleverly-built spreadsheet that can automatically populate data into specific cells based on the input of four defining variables. I can furnish this information during subsequent discussions. Specifically, the spreadsheet should be functionally proficient in data sorting. It would mean you'd need to creatively implement sorting functions that suit my data management requirements. In your proposal, it would be very helpful to share examples of past work, especially those that demonstrate your expertise in advanced spreadsheet functions. Showcase how you have used spreadsheet functions to handle complex data management tasks. Ideal candidates for this project will possess strong experience with spreadsheet software like Excel or Google Sheets and have a keen eye f...

As the project manager, I need a well-rounded freelancer who is skilful in SolidWorks to design a liquid cooling system for electric vehicle batteries. The project will include: - An overall design for the battery enclosure, coolant flow path and heat sink design. - A focus on the battery pack, battery cells and battery management system (BMS). - Ensuring the design meets size and weight constraints, thermal performance requirements and is compatible with existing battery system components. The best fit for this project would be a freelancer with experience in automotive engineering and thermal management systems, specifically for electric vehicles. Having robust knowledge in battery technology will also be an advantage. Accuracy, attention to detail and adherence to project requi...

I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.