Hello I have a spreadsheet in a format that I want to automatically convert in another format in excel and calculate the total time. The source will always be in the "Employee attendance" format and should be converted to the Proper Format workbook. We should be able to copy new time data in the Employee Attendance format and the excel workbook Proper Format should be automaticall...
I need an excel expert to create an excel file that allows the follow: - I have 3 lists of words (40 words on each) - I need excel to randomly select 30 words (10 of each block) without repeating them. All in the same space (so I can easily copy and paste).
I am looking to take the example table and use the Records table to populate the Results tab with a kind of reports table based on date and getting distinct Name's automatically from the records tab The "Example Results I Want" tab shows what should be the end results you program into the Results tab This must work in Excel 2007 and Deadline is Thursday the 19th The Date column is ...
So i have a table of data ("Misplaced Histroical" sheet). I need a formula or code written that will take the date of the report and the feed type and look up the following samples and analysis in the table. It needs to find the samples closest to the date of the report then copy the results of the samples and paste them back into the process report
I need to pull data from a legacy Cobol application. I don't have much information about it, but...information about it, but I know it relies on .vix and .dat files for its database. What I need is a consulting about the better approach to extract data from those files and create csv files. The goal is to populate a SQL database with that legacy data.
I need the formula written for Microsoft excel that will do the following: I do not know the correct way to express my formaula professionally but i have tried to write it our below. I am willing to discuss with you any questions before you start. At this point there are 2 excel spreadsheets involved. (sheet1 and shee2) i have put this after each
...page you will find two things a. a set of long and lat defining a polygon for the city name provided. a: you will get those long and lat and put in a CSV file as one record in the following format City Name, Sub City Name, Date Retrieved, State, Points of polygon (would be lat , long | next point....)
Would like to setup a formula for the following excel file. If columns E+F is between 0-9.99, column I should be [(E+F)*4 ]+ (H*175).... (Assuming H is 1. If H is greater than 1, the second half should be (1*175) + ((H-1)*150). Also want to include the following in the same formula... If columns E+F is as below, it should be multiplied as stated below
Hi Team, I need somebody to write a complex formula that will look up barcodes and return the results accordingly. I am VERY experience in Google Sheets formula's myself, do not apply for this job if you don't have a complex understanding of Google Sheets Formulas. Watch the video of what I want: [login to view URL]
I have a spreadsheet that has needs to be sorted into multiple sheets. I don't think it's extremely complicated, but more than I can do. There are only 3 columns. I need to pull info from the first column - but not based on the entire col A info - not day, date - just the name of the city.
I need a PHP script that will allow a user to select and upload a csv file and then map the csv data to the correct fields in the database. During the import process I need the script to either insert a field into the csv file (subuserid) OR insert the subuserid into the imported records. The subuserid field is coming from a cookie. The data that
I have a excel file and a test Power BI. I need help to create a DAX formula to calculate attrition. The test file has a hire date and a term date. Need to get the start headcount by removing anyone hired during the selected month or quarter or in the future. Remove any terminated employees that were terminated during the month or quarter selected or
I have a spreadsheet, 1st column is dates & time, 2nd and 3rd column are numbers. I want to a) average the data in columns 2 & 3 when the date in column 1 matches a date in a column I've made somewhere else; I also want to find the min and max for the column 2 & 3 data. The data have been gathered every few minutes. I want to graph as avg, min or max per every 24 hour period. ...
I have a spreadsheet that i am trying to use a formula to assign a number to duplicate rows. I need someone to show me the correct formula. Easy money for someone.
Looking for a Freelancer to use...Highlight) patterns for every horse (broken down by rows) in the spreadsheet. There should only be 2 patterns/algorithms per horse. Please make sure that your solution is formula based so new data sources can use. Preferably looking for a Data Scientist, not a Data Entry person. Let me know if you have any questions
Hi Thank you for reviewing my project. This is a quick and simple project for an analyst or expert in Excel to add formula to Excel template to populate it to show the revenue received from orders placed by customers. See the video blow that describes the background and the requirements. [login to view URL] An Expert in Excel
Need formula for google sheets I have a link attach to this. - need to get the sum from T2:T49 for cell O54 but sum need to be filtered by services from column S2:S49. - need to get the sum from T2:T49 for cell O55 but sum need to be filtered by Insurance from column S2:S49. -need to get the sum from T2:T49 for cell O56 but sum need to be filtered
i am building a spread sheet for my manufacturing business. i need to select a machine and tick its options to be built with on sheet 1. Sheet 2 will need to retrieve and sort data from other sheets and produce a build plan i have a sample layout but it requires the formulas and some experience to set up properly
I need an algorithm that will find the keyword difficulty on google. Factors: -Competing pages -Search Volume -Ranking Position for example i did some seo for my website, then my website shows up on the second page, taking into consideration all the factors above it will find keyword difficulty. -Logic of scientific discovery
I have a cell in excel containing numbers 1 to 90, formatted for example as below 5,68,88 1,75 3,16,68,77 12,34,80 etc I need a formula that will count how many times a cell contains numbers specified, being 1 to 29 and also 1 to 79. These would be presented in 2 new cells as follows based on the above example: 5,68,88 1 2 1,75
I require a specific output of information from details which are in my Excel worksheet.
I have some work, in an Excel spreadsheet. I am in charge of ordering cash refills for ATM machines. The total cost is comprised of several factors, Interest, volume, truck fees etc. The job is pretty simple. My objective is to find the optimum amount for each refill and how often should the refills be. It sounds simpler than it is though. All machines have different volume (cash dispensed). Th...
I have a document with 20 entries. I send it to my coworker and he sends me a second document with notes on specific entries. Each entry has a case number assigned to it. On the first excel sheet (the original sheet) I have 20 entries. On the second document I only have 8 entries with specific case numbers. I need to merge the notes with my original document. See files!
we need to read csv file. in row metadata wise need to create as document in one folder in filenet. we need to maintian mutliple version of docuemnts. For more details we will send email if u understand requirement.
need to kno formula in excel to do columns under coulmns need to kno formula in excel to do columns under coulmns need to kno formula in excel to do columns under coulmns
The syntax (or sentence structure; that is, the way the commands are organized in the formula) of an Excel IF statement is: =IF(logic_test, value_if true, value_if_false). IF statements are used in all programming languages and, although the syntax may vary slightly, the function provides the same results.
I want a formula find the consecutive days in a column that are more than zero ( those days should be 3 or more only , if only 2 then ignore it) then I want to multiply the number of these days in the highest no ( i.e ( 4days *3 ) + ( 3days*4) = 24)) 1 3 2 2 0 1 4 1 0
...when in reality their rent is supposed to start in March. This lack of a proper formula is also a problem if a rent increase happens later in the year like in June...it will apply my increase starting in January and affects the balances Jan-May. I am hoping to find a formula that will pick from a date list and only populate the correct month. I have attached
I need a complete Data Extraction from a Prestashop instance. Get me the data inside a CSV / XLS file I need the following fields: * Product Short Description * Product Long Descritpion Tab * Product Data Sheet exploded in separated fields