# Csv import formula jobs

One of the major calculations is error-ing out

I need (IN EXCEL) to know when two times overlap.
Please see image for visual exa...ON THE CAKE)
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 be able to see the **formula** detail (for example =sumproduct, etc.) so that if I copy or mimic for new possible tests

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

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 ...

The on tab in my excel file does not match the exepected result and I cant see why. I just need someone to check my file.

We require 3 different sets of Macro for 3 different excel files. Please contact us to further disucss

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

I need help for someone to develop a template in excel with formulas and formatting so that I can input the data and everything will work. Need asap by Friday happy to pay

...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....)

Hello, We would like someone to write a patent for our company using standard patent template. We will provide all the details, claim, art work, etc... Previous experience required.

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 need you to develop **formula** or coding for me in excel using VBA Macro

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

...that I am sure will take minutes for someone with excel skills, I have non and not enough hours in the day to learn.
I can download data in **CSV** format I then need to **import** it to excel and create a simple **formula**
if actual number is greater than previous and greater than consensus give it a score +3
if actual number is greater than previous and smaller

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

I have some work, in an Excel spreadsheet. Help with formulas, what i would call embedded lookups. Pulling value based on multiple ranges in another sheet.

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

...PLEASE, DONT BID!!!
Check the video with the task.
Need to use the code function of wpDataTables (the function that imports excel and **csv** files) so it works for users from Frond-End too, in 2 steps(select the file and **import** it, showing it right away in the Front-End).
Also need to use the function of WooImporter plugin(the function that imports data from

A one cell **formula** for
A1 A2
24532 = 16
62453 =20
72392 = 23
Simple math
2+4+5+3+2=15
6+2+4+5+3=20
7+2+3+9+2=23

I need someone who can implement some formulas in CPLEX for optimization using c++

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

Column D has hours delivered for each day of a month, If there is a 'Yes' in column E then the hours in Column F should be D*2 rather than if blank then the result will be the same as in Column D.

Writing a pdf file in latex with the formulas. Very small so dont overbid and i need it now

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...

Create straddle at any time (start time and end time). in amibroker

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!

I need to find name of the column based on the value position in the table. Only Excel, no VBA.

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 include an indication bar on top or bottom of a Stochastic indicator

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

Hi i need transform mathematical formulas into php.

EXCEL **FORMULA** WANTO TO KNOW
COLUMNS UNDER COLUMNS REQUIRED RESULT IN ENCLOSED EXCEL
WILL GIVE 2 $