Cnet excel working pivot tables jobs

I need to optimize a MySQL query. I've been reading the docs about optimization in MySQL docs but It's been hard for me to comprehend it. I have two tables: vehicles CREATE TABLE `vehicles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `metadata` json DEFAULT NULL, `created_at`

I want a small project to Shopping _items buy and sell Tables Supplier , Buy_Main , Buy _Item Customer , Sell_Main , Sell_Item Receipt_voucher define_Items Status same like this URL [login to view URL] I attached an example file PHP and MySQL

I am trying to run a formula on google sheet but it is not working. Need help. This is the formula: [login to view URL] I want to run formula correctly in cell C1 Can pay ₹50 only Indians only

Accounting Excel Project - transferring figures from raw data sheet (new figures and combinations every month) into a monthly Overheads MM/YY file in order to get away from manual checking and "Edit links" as this process does not pick up new data. Full Excel task project written up on Word file is attached!! The below is taken from the full Word

I have some skills likely data entry spreadsheet.

I need a freelancer to store some data in ms excel. I'll give information to you then you can store it. I need 100% accuracy and need a efficient freelancer.

Only need to redesign first page of website into something neater. Image of products in order from left to right on same alignment. Same as in the category 'shop'. Image in center. Also solve issue of theme problem. Upon pressing the image of the items or add to cart. It doesn't lead to the supposed Add to cart website. Should be a problem of theme after i updated the theme.

Brand Name: Tapping Carpentry About the brand and product: The brand is as much about Andy (Tapping) as it is his carpentry. He makes bespoke furniture such as dining tables, coffee tables, outdoor storage, doors, interior woodwork (e.g. currently providing woodwork for a crossfit gym aswell as homes and businesses) etc but people seem to want to pay more

I need someone who can check all messages on my inbox and reply to them. I'll give you a standard template. I prefer German or USA freelancers.

A public web site (web app...Three types of roles users (Admin, Visitor and Registered) with specfic privileges Notes: 1. SRS document will be available to the winning bidder (Use Cases, Mockups, DB Tables) 2. DB ERD already created but not completed, and it is able to be modified as the developer see suitable Time frame: Limited based on agreement

...to pdf and then exported to excel. The exported data is not properly arranged in excel - data is not properly arranged in cells, some cells are merged which should not have been merged etc. Needs help organizing this data properly in excel. It's a few thousand lines of data. I have the data in paper, pdf, word and excel. Whoever gets the project will

Create drop down lists in 2 Excel sheets (Incoming an Outgoing). See pictures. 1. Drop down lists with products from Inventory sheet. (on Incoming and Outgoing sheets) 2. Drop down list with countries from Inventory sheet. (on Incoming sheet)

H...in Excel document . Basically we need to create a sample project plan (tasks / subtasks) and the time it would take to complete the tasks so that we can estimate the number of resources we need to complete the IT project. Looking for someone who can connect to my computer and walk me thru the steps in completing the task using Microsoft Excel.

I need data entry for ( TASI ) which is Saudi Arabia Stock Market with full analysis of all stocks that is updated in live with p/e ratio , stock predict direction and everything possible in professional stock analysis Please bid if you read the project and understand it and have ability to do it professionally [login to view URL]

I have a file that I need to have some work done on. It's basically an accounting type workbook. We can negotiate a rate. If we're allowed to talk [Removed for encouraging offsite communication which is against our Terms and Conditions -Section 13:Communication With Other Users] so I can explain exactly what I'm looking for, that would be great.

I need data entry for ( TASI ) which is Saudi Arabia Stock Market with full analysis of all stocks that is updated live with p/e ratio , stock predict direction and everything possible. Please bid if you read the project and understand it and have ability to do it professionally

Need help setting up and configuring network, IP tables, routing

Please add the properties on the files marked -1 and -2 to the end of the spreadsheet marked -3 (remove any duplicates) but don't remove any details. Please identify the location of each serviced apartment in the combined list with a number on the map. After you have completed 5 of these then please send the combined spreadsheet and map so I can see if that's what I need.

I have some work, data to be converted from PDF To excel

Please Sign Up or Login to see details.

...[login to view URL] Login ID: saikatghosh@[login to view URL] Password: Saikat@123@ (Case sensitive) Your deliverable for part (b) is a working dashboard. Coding language is .php , and database tables should be in MySQL ************************************************************************************************* Please bid only if you have

...amf messages which is beyond my skill level. Please see the attached Project Briefing for more detail on the target site. The data itself can be taken from html tables or from an excel file if you can manage to get the API to respond, it is up to you. This might lead to other jobs and ongoing maintenance/modification requests. I will only provide

We're working on a project for a client where we have to explain our ability to source, consolidate, ship, clear, warehouse, and deliver to end users food products. We have to explain to the client how we're going to do these things and need to punch up our response with some high quality, themed graphics - we want everything to look the same. The

50 excel files to be merged into 1 excel sheet after comparing the files since some files have few columns less. Those files have to be identified. Finally filtering,sorting and searching should be possible without any errors.

Need an excel or access to calculate the labor and equipment cost of projects . Currently build in excel, need a better way to automate and calculate multiple projects.

...on it. Just FYI I briefly loaded a new test template just to see what happens. I could go into the listing details. So, I assume that the j-business directory extension is working. But there are issues with some other stuff. I have Cpanel access and Joomla admin access. You're bidding for fixing the template/Joomla issue. Visit [login to view URL] to

...computer adaptive logic and the question bank. Question bank should be editable for admin so that I can add new questions/ delete existing questions. The questions may have graphs,tables, images etc. At the end of the exam there will be a scoring ( I will give logic). This entire project has to start from scratch as I don’t have any platform to host. I will

I need want to complete some data entry projects of content writing in MS word and excel in spreadsheet. I'll give the data and tell you the about the project.

I have python 2.7 (make sure xlrd, etc works). In the attached excel file, I have different sheets. Out of them, 16 sheets I want one column data to be printed in 16 different txt file. TxD0 - Column C (start from C5) TxD1 - Column C (start from C5) TxD2 - Column C (start from C5) TxD3 - Column C (start from C5) Tx2gG0 - Column C (start from C5)

Looking for a highly skilled excel expert to assist me in creating formulas on an adhoc basis whilst I create a financial model

...fullstack developer. I am currently working on a project. The project has a new Ruby on Rails backend. I also have a AWS account to use DynamoDB Database. However, I am having troubles connecting the Rails backend to AWS DynamoDB. I just need your help to integrate and setup the environment so that I could start creating tables on my terminal from Rails. Let

...fullstack developer. I am currently working on a project. The project has a new Ruby on Rails backend. I also have a AWS account to use DynamoDB Database. However, I am having troubles connecting the Rails backend to AWS DynamoDB. I just need your help to integrate and setup the environment so that I could start creating tables on my terminal from Rails. Let

Working off an excel list of contact names and email addresses, find the contact's title online and fill it in next to the contact name/email address on a spreadsheet. Most of the contacts are government employees who work for public schools. The ideal freelancer will be ok working with highly repetitive steps. Attention to detail is key as you can

Hi. I would like to combine 4 word files into 1 word file and convert it into pdf and save it under today’s date. Users would like to run a macro and have this done on a daily basis. The naming convention of the 4 word files will be as ‘Work of xyz 06-15-2019’. We would then need to convert these 4 into 1 word file and convert into pdf & put it in the respective month’...

I will give you access to the MySQL database. You have to use 6-7 tables and link to a dashboard to display the progress and results for a field activity. The dashboard will allow the user to select the State, the Hub, City and a cluster within the city, or the whole state or city and then filter between two dates. The data is pulled up accordingly

Quick/Immediate Micro Job: Make HTML Templates Mobile Friendly I have a few html templates for email newsletters. They are made with tables - and as such look bad on mobile / Do not scale properly. The simple job is to convert them into responsive templates that scale for mobile. Beware: This an EMAIL TEMPLATE, so you can not use remote loading scripts

I need a online portal, where one can login and changes field and value...and all can see last changes and login. and admin can create users.

I have a dataset (two tables), I need to clean them.

...morning. This is a small app managing 16 units only in excel. I want it to print form, such as annual and monthly balance sheets, reports, keep data, late fees, show late fees, who's late, to browse through the different sheets(month),etc. I already have the frame of the program, it is advanced. An excel expert can tweak it a little bit to his/her convenience

im looking to make some customization on joget ce to - make it works on oracle db r12 (creating tables automatically) - make a plugin to have extra form elements ( spreadsheet , advanced grid ) please if don't have experience on joget bpmn don't propose a bid

hi, i would like to clean some of my excel table and make some groups and a table.

..."Point of sale" system running on windows 7 built with VB.net and Mysql 2005 Database, i need an Android app that connects to the SQL database fetch tables in that DB and the ability to "Edit some tables" with Admin privilege. Features : - Access DB Locally & remotely "over 4G network". - Selecting DB after successful authentication. - Right to...

Quick/Immediate Micro Job: Make HTML Templates Mobile Friendly I have a few html templates for email newsletters. They are made with tables - and as such look bad on mobile / Do not scale properly. The simple job is to convert them into responsive templates that scale for mobile ONLY BID IF YOU CAN DO IT IMMEDIATELY. It is supposed to be a job of

I am trying to send automated emails after user registration, from Joomla! using SMTP. However, when I enter my server's email SMTP settings in the Joomla! system configuration, it does not work. I need someone to figure out why it does not work, and to fix this.

i need to copy data from website to excel file like company name - address - telephone - area- open and close time and paste to excel file but these website with Arabic language need to collect 10000 company data

You need to add some information to the other columns of this file. The information are included in the prior columns. content for Column M: * you need to put here the figure here, which is found in column F. For example, in column F „50 ML" then you need to fill in column M „50" content for Column O: * you need to check if in column H you find one of these words, if so you n...

I have some work, in an Excel spreadsheet. I need a freelancer to insert some data to the excel spreadsheet. I'll give data for you then you can store the data.

...someone to program the database interactions. What I need: 1) Query and write database locally in SQLite 2) Synchronize three local tables with database in remote MySQL (you can use TTimer) 3) Synchronize SQLite tables with a remote MySQL by TTimer indicating the status of connection Deliver project running and with source code, and send me components

...of the product range is available for customization when ordering and is done in Excel. The orders forms include higher level excel functions such as index and match functions, conditional formatting requirements and various lookups. This task suits higher level Excel competency and also includes some macro requirements. It is also preferable to have

We have a system working that needs to be faster, and work smoothly