CellsJobs

...app calculates landing distances and brake cooling advice for Boeing aircraft. All input and output is given on 1 page. Input for some cells is given by drop down menu selection or scroll selection. Other cells get input through a numeric keypad in the left hand lower corner of the screen. Currently a fully functional Microsoft Excel worksheet is available. This worksheet has a size of about 2.3 MB and consists of 15 tabs. Those tabs contain approximately 220.000 cells of data and formulas. Formulas may be very complex and contain up to 400 characters. The first tab “Landing Distance Calculator” receives all the input and also shows all output. Many cells on the first tab are conditionally formatted and/or have data validation. Some calculations ...

A polymer electrolyte membrane fuel cell

I need a VBA subroutine to dynamically determine the range of an excel file by using Column A (LastRow = Cells(, "A").End(xlUp).Row) . When data exist in column M concatenate that data with data strings. Insert column after M with String1 & M data & String2. (Columns("m:m").Select Shift:=xlToRight Range("m1").Value = "Protection") String1 = "Arc Rating ATPV " String2 = " calories/cm²"

...jump, Spread in Humans Overall structure of HIV, definition of a retrovirus Lifecycle, CD4+ helper T cells, R4/R5 tropism HIV envelop proteins gp120 and gp41 How HIV kills infected cells Who to test, ART experienced/naive, window period. Progression of disease, Elisa testing, Western Blot CD4 counts, viral load, anti HIV and HIV antigen test Modes of transmission, majority modes in US vs World condom use, abstinence, MTCT success Progression Stages of infection, definition of AIDS, secondary infections, set point Treatment Types of ART, HAART, life expectancy, PreP VS PEP Berlin Patient (plus 2 more) “functional cure”, CRIPR Babies (germ line/inherited), Somatic cell therapy: Engineered R5 cells added back HIV in US At risk populations Black MSM, Young, ...

Statistical meta-analysis with forest plot using random and fixed effect models for data with 11 cells. All the data has been already organised.

I need 20 - 30 seconds of 3D animation showcasing: 1. Laser on skin and skin rejuvenated 2. Laser on pigmented skin area and the pigment cells break away

excel using macros and formulas to compute some data into sheet

Attached is a spreadsheet with two tabs, mostly the same info. The area of D2-L11 needs to show variable, base information. Only cells G6 and G8 should be editable by the end user (though the whole thing should be printable/exportable). For the Vendor tab, we want it to highlight when the "Map using internal software" row is ≤ the cost per year over 3 years. This needs to look beautiful and present the information in such a way that the dumbest sales person can explain the "buy or build" decision on how many mandates need to be mapped before - buy mapped content makes more sense than lease mapped content on the end users page, - map using internal software makes more sense than map using APIs on the vendors page. You'll need to give me a quote for h...

Create python script for sending mail with html table with embedded image in one of the cells. The email has to be on outlook.

I need to be able to put a formula in a cell, but also use the total of that cell to create a sum total in another cell. I am getting a circular reference pop up. I tried to enable the iterative calculation function but it did not work. I need to be able to do this in a few other cells as well.

i would like a task automation creating that uses power automate to copy certain cells of an excel sheet into a template each time a sheet is created in a certain folder in the server and each and every time a sheet is created in this folder, the information is copied on to the template and then once per day the sheet is sent by email to specific addresses and the template is cleared down ready for the next day. is there any Power automate champions out there that can do this on an hourly rate as we will have repeated work.

55 pages of addresses that need to be entered into Excel do you want me to enter those 8 cells only? Yep, that's it. I can do it quickly too as you are in a hurry Deadline is 21 hours, but I need partial progress submitted within next hour. so you want everything in 21 hours? Correct. I can deliver everything in 21 hours no problem and progress in 1 hour too

I have a vba code When the user selects from the drop-down list, a phrase appears in the two cells after which it is written: Please select I'd like to duplicate the code until row # 15 Note: The two cells are both drop-down lists ------ If = "$B$9" Then Range("c9").Value = "Please Select..." End If If = "$C$9" Then Range("D9").Value = "Please Select..." End If ----------

excel using macros and formulas to compute some data into sheet

looking for a VA to help me find contact information for a list of people that reviewed various software. Hi, please let me know if you can do this. Please fill in all cells that are blank on this sheet: You can probably google whatever info is there and find the closest one.

looking for a VA to help me find contact information for a list of people that reviewed various software. Hi, please let me know if you can do this. Please fill in all cells that are blank on this sheet: You can probably google whatever info is there and find the closest one.

excel using macros and formulas to compute some data into sheet

Hi freelancer, The idea is that i will "upload" a product in google sheets by assigning cells with different information about the product. It could be the price, shipping options, color, desiger, condition and so on. It's importent that I can upload photos to the product in the google sheet and after publish the product to all the webpages I want to sell on. I was thinking about using google sheet, gmail, and google sheet scripting. Adding a notification feature would be a great feature. So everytime i recieve a message on the website, a mail will be sent to my gmail. A seperate sheet with stock status would also be nice to add to the final solution. I'm open for ideas to other features that will make my daily work easier. Pls revert with information about...

I have a long text containing dates, times and text that needs to be converted into a format (Excel) that then can be evaluated. Input structure: - 1 text file per month containing entries grouped by day - each day contains several entries of times + text - couple of different text categories per entry Output structure - date and time per entry - corresponding text categories in the next cells Further description is in the attached Excel (containing example text and the intended output). Also attached 1 full text file of 1 month. Total amount is entries from 365 days.

A so called Html PricingTable exists, with this origin: Need to make the code cleaner, so that the configuration (such as row-content, texts, which rows have tooltip, which rows has images, and which grid-cells sould have a "yes-icon", "no-icon" or text. This could be done by moving code to a configuration-file in XML (?) or in javascript, or after discussion with you, what you suggest. PricingTable has Header-rows, and (expandable) Child-rows. See attached images for info. See also Code attached, that would need to be easier set by a config-file or similar. Everything works in code now. Code will be provided. Also project is this: 1) In config as described above, it should include: Each Header-row (text), and that headers one

Looking for a jail system that must meet specific requirements: - Anti combat log (database jailtime) - Support multiple cells (configurable, script checks cells or database to see if it is occupied and chooses first available cell) - Remove player items (returned upon release) - Goodtime system (be creative) Preferably works with Hypaste RP’s Mobile Data Terminal, but not required.

Convert text cells into numeric before plugging it in a prediction model

...selections on the customization page, under "Appearance" to have "Hide grid lines" be selected to have "Hide row and column headers" be selected to make certain "Include a download link" is NOT selected 3F) Write code to do the equivalent of manual selections on the customization page, under "Interaction" to make certain "Let people sort and filter" is NOT selected to have "Let people type into cells (their changes will not be saved)" be selected to make certain "Always start with this cell selected:" is NOt selected 3G) Write code to do the equivalent of manual selection on the customization page, under "Dimensions" to keep default values 4a) Write code to do the equivalent when working...

I need to have payrolL excel spreadsheets completed for the balance of 2019, 2020 and 2021 thus far, that have already been completed, but need the template formulas between the cells completed, so that the data can just be inputted, and then duplicated for every week of the year for 2019, 2020 and 2021 (last three and three quarter months) delivered within an extremely short time frame, preferably 24 hours, as the work is very simple, and is primarily, if not all, copy and paste, along with creating the relationship formulas for the cells.

- A building or a stand-alone house is to be considered. - The design must include solar thermal collectors and photovoltaic cells. - Try to incorporate various renewable applications such as wind, geothermal, hydropower, biomass, wave, tidal, etc. Also, try to include geothermal heat pump. - Space heating, space cooling, water heating, and electricity needs of the building should be considered. The analysis should include heating and cooling load calculations as well as the calculations of hot water and electricity needs of the building. - A complete cost analysis of the considered systems should be performed. - Consider codes and standards (ASHRAE, ASME, etc.) applicable to your design.

Need translator to convert an excel file from German to English on urgent basis. File is large (7823 cells) and needs to be translated within the shortest time.

You need to take the values from the data tab and replace them in the cells

BACKGROUND: Individual private investor wanting program to pull specific financial information from companies website SCOPE: From a User inputted company stock tick reference (EPIC), automatically pull seven items of finance data to adjacent Excel cells, and perform cross reference check for data accuracy INPUT: EPIC is a 3 or 4 letter abbreviation for stocks on London Stock Exchange, for example 'BWY' is the stock ticker for Bellway plc (a British housebuilder) OUTPUT: Pull together seven pieces of finance data from various websites, cross reference data from other websites to ensure accuracy Show cross reference check as successful or % error Following output of data in similar format to below, the data will then be used in Excel for further calculations ...

I want to load all files (12 files) in a folder on SharePoint using Power Query in EXCEL 2016. However, "SharePoint folder" is not available in the EXCEL2016 query. I want to dynamically load the values of the cells in the book (,,C.xlsx...) dynamically and read the data of all the files (,) If it is possible to get the data (,,C.xlsx...) from all the files, please write the way to do it and the query.

Hi, please let me know if you can do this. Please fill in all cells that are blank on this sheet: You can probably google whatever info is there and find the closest one.

I am searching for a javascript developer who can create a simple script with pure-javascript (not jQuery or and drag and drop plugin). I have a table with cells. Over that table there are calendar-item-divs with an absolute position. The scripts: - can drag calenderitems between the cells - can change the start en begintime of and event by resizing the left and right border - you can create an event by selecting 1 or more cells, then a test-alert has to be trigger.

I would like to design two company logos: 1. "SIBCA ENERGY" - Design me a logo that signifies the use "Energy" - Solar panels for example - Hydrogen cells/packets 2. "PING" - Design me a logo that represents the transfer of "Data/Information from one place to the other and the indicates the speed of transfer

We are looking for an electrical engineer with proven experience in ...proven experience in Homer Pro. We have 3 to 4 projects per month that need to be analysed. You will receive the data from us regarding load profiles, maximum PV capacity, number of EV cars, number and size of wind turbines, etc. Based on this information you will have to create Homer Pro simulations. We pay per project. There will occasionally also be projects with hydrogen production and fuel cells, also CHP and heat networks will have to be analyses occasionally. Ideally you have a license for Homer Pro, or you have a temporal one. We are looking for a long term cooperation, and we are looking for engineers that want to be come part of our renewable energy team. So we are looking for positive, profession...

to capture geolocation (latitude and longitude) on submiting a visit form . this visit form also have few fields such as id (numerical) , surveyor name (list of surveyors to pick),rate (numerical) etc to enter .Entries from submitted visit form data should go in google sheet including geocodes (latitude and longitude in seperate cells). app to have our logo.

Have fluorescent images of an object, there is 3 layers of cells on every image, I would like the model to learn to segment just one of those layers and output just that layer as an image for further analysis. Files will be provided to you upon your proposal.

...asked to do) carefully, your task may have different variable or population (or both) from those in the Excel Demo. For example, the task in Excel Demo may be to calculate the descriptive statistics of ATTITUDE in Population 1 using Excel build-in functions, but your task in the assignment could be to calculate the descriptive statistics of PREFERENCE in population 2 using build-in functions. All cells marked by yellow color in the Excel Demo are required to be reported in your assignment. Keep the same decimals as the Excel Demo does....

... Choose one of the unvisited neighbours iii. Remove the wall between the current cell and the chosen cell iv. Mark the chosen cell as visited and push it to the stack Randomized Kruskal 1. Create a list of all walls, and create a set for each cell, each containing just that one cell. 2. For each wall, in some random order: (a) If the cells divided by this wall belong to distinct sets: i. Remove the current wall. ii. Join the sets of the formerly divided cells. 6 Program Inputs Your program must accept a file name as a command line argument. The file will have the following format: {window size} {cell size} {generator} {solver} 3 Where: • {window size} is an integer that determines the length and width of the window. Min: 100 Max: 900 • {cell size} is an integer t...

I need the following changes made to this Google Sheet: 1. in the cells under the priority column, i need a dropdown menu in each cell that allows me to select between: low, medium, high 2. if the item in the row is checked as completed, it should be moved to the bottom of the list (row 100 and below) 3. if the priority of the row is selected as high, it should be moved to the top of the list 4. if the due date is in the next 24 hours, the row should be moved to the very top of the list (above those things selected as high priority). 5. If I add new rows to the spreadsheet, the completed tasks should still always be at the bottom. This is the work I need done right now but I want to keep

Amendment of two PCB layouts for battery packs: Implementation of polarity protection for 4.2V Li-Ion Cells Work scope: a) electrical calculation of necessary components b) selection of components c) Amending existing PCB Design or New Design d) provision of a production files The current PCB design is available as KiCAD file and contains the battery holdes, connection plug and copper lanes. PCB size 66 x 80mm / 24 x 70mm We are happy to answer specific questions. Timeframe: start: now completion: yesterday ;-) - a.s.a.p

1. Problem: Hex Game Hex is a strategy board game for two players, Red and Blue, played on a hexagonal grid, theoretically of any size and several possible shapes, but traditionally arranged in a shape of rhombus with 11×11 hexagonal cells. Figure 1 shows such a traditional Hex game board. The top and bottom edges are painted in red, called the red sides, and the left and right edges are the blue sides. Figure 1: Traditional Hex Game board. Players alternate placing red/blue markers (red markers for Red player and blue markers for Blue player) on unoccupied hexagonal spaces. Once a marker is placed, it remains until the game terminates. The goal for each player is to form a connected path of their own markers linking the opposing sides of the board marked by their colou...

...asked to do) carefully, your task may have different variable or population (or both) from those in the Excel Demo. For example, the task in Excel Demo may be to calculate the descriptive statistics of ATTITUDE in Population 1 using Excel build-in functions, but your task in the assignment could be to calculate the descriptive statistics of PREFERENCE in population 2 using build-in functions. All cells marked by yellow color in the Excel Demo are required to be reported in your assignment. Keep the same decimals as the Excel Demo does. The assignment is due 11pm Sunday of this week (the last day of the week)....

I would like to record old values from cells in Sheet1 and record it in Sheet2. Once the values in cells in Sheet1 is updated, the old values is copied in Sheet2 with timestamp. It should also copy the corresponding row label and column label of the cell that was updated.

My job is this - I am using a Gridview and have added some functionality for the clicking on cells and returning some data in an 'alert' box. However, two things. I need a little more data returned and am unsure how to access it. I then need that information made available to my modal popup instead of an alert box. Looking for someone with gridview expertise using the onclick event for cells and the retrieving of that information. Converstant in VB.Net (ASP.Net) and JQuery. I'm looking to pay around £30.00. I use AnyDesk or TeamViewer and would like the Freelancer to access my PC and complete. Thanks for looking.

converting the attached pdf file to excel file without any gaps and with merged cells but including all the data in the cell . also remove the header in each page . to apply a proper filtration.

Dear All, I would like to hire someone for a betting project. I would like to link Excel with a betting site like Winamax (). The goal is to link my choices that I entered on an excel spreadsheet with Winamax. For example, if I enter a game (let's say, Manchester United win the game on saturday against Chelsea) in an Excel cell and I do this for 20 other games in 20 other cells, I would like the combination of those 20 choices/bets to be forwarded/sent automatically on the betting site. Maybe with a Macro or a new program. Then I just have to validate my combination to finalise my bets. You will find attached an example of what I want. Many thanks in advance for your feedback and help. Best regards, Kevin.

I require a VBA macro to loop through multiple workbooks using the filename to extract data from specific cells. I would like this to be setup using an ADO connection in VBA rather than opening the workbook to improve the speed of this macro.

There is a list in Excel that contains one client per line. Each client has some data as data in cells. in one of these cells it has the address and in another the city. the other cells have other elements of it. I want to make an application that takes customer data and pins it on a Google map. in the tab of this map to pass the rest of the customer data. For this work we give $ 60 without negotiation. we want it to be ready in 10 days and someone will be able to present it to us with a screen recorder. (please for offers up to $ 60)

There is a list in Excel that contains one client per line. Each client has some data as data in cells. in one of these cells it has the address and in another the city. the other cells have other elements of it. I want to make an application that takes customer data and pins it on a Google map. in the tab of this map to pass the rest of the customer data. For this work we give $ 60 without negotiation. we want it to be ready in 10 days and someone will be able to present it to us with a screen recorder. (please for offers up to $ 60)

What to do: •Convert the image (provided attached) to the frequency form using a Fourier Transform (call it FFT1). •Take the conjugate (call it FFT2) of the FT from the first step (FFT1). •Set to zero all the values of the FT from the first step within 50 cells of the origin (call it FFT3). •Set to zero all the values of the FT from the first step NOT within 50 cells of the origin (call it FFT4)

I want to make a design for 3 cells concrete box culvert, full detailing for cross sections and wing walls Also calculations note and modelling required