We need the assistance of an advanced Excel practitioner. The file has a worksheet for: - core data o The core data includes: service type/normal/overtime rates/rates by consultant type. Rates, minimum duration, billing increments (i.e. hourly, per 15 minutes and per minute) vary based on the service type - source data o The source
The purpose of this project is to be able to work out the days in between the date in which we received the order to the date we placed it on the freight truck. In the attached file are three sheets. One has the invoice number (Sale), the other two (EFM & TOLL) are the data of the freight trucks. The sheet with “EFM” has a few different freight companies
I'm looking for someone that could develop and/or customize an Instagram analytics and management SaaS platform. Adding twitter & Facebook scheduling capabilities. The source code is the following: [log ind for at se URL] It needs to include all the features available and listed in HootSuite/IconoSquare, therefore a detailed report (analytics) is a must. Below the features needed: [log i...
...is based on a mathematical formula, that an admin can edit from the backend. The formula is calculated on some fields that an admin will edit in some custom made fields. Step 2. The user will have to complete two other fields that will connect to the formula that I mentioned earlier. Step 3. Explaining the formula Formula = a + b + c + d + e + f + g
I need some one to do a maths formula program and then translate to a expert advisor for automated trading for forex for me, some one ready for changes as there might be some changes. The maths formula is pretty simple but the contractor need to learn so calculations, pls be ready for it
Hello I have a Excel file which have 3000+ Rows. Work is simple you need to use formula which less 5 in every row value. That's so simple if you knew have excel experience. Will pay Rs.200 + 5 Star Review
Hi, I wanted to buy baby products from pharmacies that I want to import to China. I'm looking for agents , can anyone help? I am interested in Nestle Alfare , Nestle Althera，Neocate lcp and Neocate junior also other baby milk powder with cheaper price . If you are an pharmacy owner ， it will be good and help me a lot, if u can contact pharmacy and we can work together. Thanks.
Need a formula to display yesterday's date in this format: date_shipped:2018-8-31 date_shipped:",CONCATENATE(YEAR(TODAY()),"-",MONTH(TODAY()),"-",DAY(TODAY()-1))," I use this Excel formula to get yesterday's date for our tracking numbers. I need to show that the date shipped was Yesterday. For ex. Today is Aug 1, 2018. The formu...
Hi, We have an in-house process mapping Excel. Looking for a very advanced Excel expert to help us manipulate drawn objects based on formulas. To be precise, when the activity field is not Blank show the object with a number inside, if the field is Blank, hide the drawn object.
Hello i need a formula regarding temperature i have voltage ,current,resistance so if the material is semiconductor (example :SiC(silicon carbide)) i need to find the temperature from (voltage,current ,resistance ) need an excel sheet for certain voltage,current ,resistance what is the temperature of material
We have a handful of ingredients we want to try to use (and possibly add or remove some) to make the most effective, safe...all-natural cleaner possible. Like to keep costs to $250-300 and must be tested on leather, soy leather, vinyl and possibly other materials and send us a bottle of formula to test as well as the formula. Need to start asap. Thx
The company name is "Formula Trading Ltd" I have attached a Logo concept. Please place your concepts.
I have a few dax formulas to get me attrition by date selected. However, if we didn't hire anyone in that time period the calculation is off. I have a calculation to count new hires, one for terminations, one for the start of the month headcount (before any new hires or terminations) and the average headcount. The average headcount is (start of the month headcount - terminations + new hires +...
...require an excel worksheet to manage investors, our assets and their [log ind for at se URL] tool also needs to produce regular reporting using templates that we can amend or add to from time to time. All the data analysis needs to be done in excel so does not require any development other than providing a series of clickable buttons that invokes the excel functions
We are looking for consultants to help us with some urgent short term projects. Using your well established, expert cosmetic formulation skills, you will assist us in reformulating existing products to meet key product performance criteria. This may including sourcing raw materials in line with our strict ethical requirements.
I need (IN EXCEL) to know when two times overlap. Please see image for visual example. Below is written example. 1) You will notice that Sales Person 3 and Sales Person 4 both worked a shift. 2) There was overlap from 08:03 thru 08:21 3) There was no overlap from 8:00 to 08:03 4) There was no overlap from 8:21 to 08:22 I need to know (REQUIRED) 1)
i have csv files, in one file is categories for opencart, in another file is products. Problem is, in categories file , all categories have numeric ID. but in product file categories have also numeric ID, but subcategories is just as text. i need it to import in opencart (i have module) , but i need it convert categories and subcategories in opencart>style>to>import
...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 automatically generated
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).
...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 used to get the records only for a date period I want The Name column list here is automatically generated from finding
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 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
PROJECT: FAST ECOMMERCE [log ind for at se URL] specializes in selling and distributing automotive and machinery components. Our online catalogue needs to be updated to an ecommerce platform and the exchange of information should be quick and seamless. Users will be able to shop online, seamlessly checkout, and then conveniently have their favorite merchandise
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: [log ind for at se 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 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 am im need of building several databases for my company over the next month. As I get further into the project I need help with the complex formula. I have a good understanding of Excel, but when it comes to very complex formulas I need some help. Basically I am looking for someone that can hop on a screen share video conference occasionally and I
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 provided Excel template and columns H:M to identify winning (Yellow highlighted) and losing (Red 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
...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. [log ind for at se URL] An Expert in Excel should take no