This is just quick lookup of values from one table, finding the corresponding value in a second table, and then replacing it for the original value. The only issue is that the original values are part of a single field, so the field needs to be parsed first, the value substituted, and then reassembled.

Looking for a solution to obtain the average of one column related to one year and compare with values of another year.
Please check the attachement in excel file. Tab named "FactInvoicing" is the unique fact table and tab named "Target" is the pivot table that i want to obtain as result.
I'm looking a complete example in power bi to resolve this

...ROTOCOL
Please have a look into it and I need values for battery,location,lock/unlock as an android app.
I can provide MAC address .
Please read below forum:
[login to view URL]
Here is the code for Android where we can get values,but its in Kotlin,need in Android studio:
https://github

we are using Opencart 3.0.2.0. we need to select with a query values inside a shell because the custom fields in OC are in a shell in a row in oc_orders table.
I would like to select in orders table the custom fields. the select command in MySql gives me all the data in shell.
For example
I have in customer 4 custom fields mobile phone , VAT. company

Good day,
we are looking for a developer who can help us to implement a java script code on one of our sites.
Platform: Shopify
Here, variables should be filled with data from Shopify and sent to another service provider. Sample code is available.
Here is the instructions:
We sell products through Shopify: [login to view URL]
We would like to work with Sovendus. Here it concerns, after the purch...

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.

I have 2 lists in excel. The first list contains 3 columns with random numbers such as below;
0.381323, 0.371693, 0.246983
The second list also contains 3 random numbers and an integer for example;
66461, 0.382561083, 0.371066183, 0.246372737
I need to find the closest match to all 3 numbers from the first list in the second list and return the integer beside them.
I have attached the...

I am looking for an excel tool where a user can input 10 values, it is converted to XML where it then calls an external website, the XML is pasted in a submitted, what is returned is a XML string which then is converted back in to Excel with highlight on specific values returned from the XML.
I have an example of this file that DOESN'T WORK. And I

For a given database with start dates, end dates, and values, I would like a query which calculates (pro-rates) this into different calendar months. Refer to attached sample Excel - the yellow highlight mimics the database. The output (query) should come from a query compatible with MS Access (SQL) and be a timespan of the rest of the 2018 calendar

...post)
a) clear and exact values for end user
b) problem solving we do for end user
c) how can we help to end user with each blog post
from each of blog post.
If you will take a look at these article [login to view URL]
you will see SEMrush Review (Table of Contents) - values which Semrush give to end

Generate html page from json values. This is the page I want to achieve:
[login to view URL]
this is the json:
[login to view URL]
This can be either done from php or javascript.
This is simple and I need this done today

I need some code that will loop a json file and read the objects in a vb.net procedure. All I want is the code you do not need to write an entire project. All I want is for you to loop the file and write each value to the console. I could go to StackOverflow but I need it done as soon as possible

We are writing a Web Application and need someone to help as when we submit the form
We are not get...are writing a Web Application and need someone to help as when we submit the form
We are not getting the values of a ListBox that is part of our form. We need all items
in the Listbox to be passed back to the controller as we need to use those values.

The study investigates a group of 20 patients who were treated with a resection of Haglunds deformity, reinsertion of the Achilles tendon. In one group the Achilles tendon was partially detached, in the other group the tendon was completely detached and reinserted into bone.
The Pain felt ( VAS) (1-10) was documented pre,- und postoperatively
THe AOFAS hindfoot score ( 0-100) was also documented ...

...scripting (PHP/Python) and/or MYSQL programing to provide me with the script/code and/or MYSQL queries that I can run on my store's database to convert the database tables and data values from Opencart v1.5.6 database to the proper format to Transfer/Migrate all of the e-commerce store data including customers, product, category, order history, inventory, and

I have part of a crane boom that I need a CFD run on using ANSYS Fluid. The goal is to find the torque values acting around a certain point along the boom from a range of windspeed values and angles. For the project I just need someone to do up step-by-step instructions on how to setup the simulation in ANSYS that I can use to model all of the different

I have an image that I need ...image that I need a line drawn on automatically via JS based on entered values.
I am in need of someone who has previous work with canvas work and can start work now.
Most of it is built, however the line generation system needs to be altered slightly.
You enter input values:
Draws lines on image based on the input

An animated GIF has been created to show our company values. The GIF has a white line applied to the outside of the line which means that when it is applied on a coloured background you can see this outline.
We would like the animated GIF resupplied without the white keyline outline on the animated line (the line just needs to be one colour only with

We have 8 company values, I need a logo to go beside each value and then a display to link all values together,(or if you can link them without a logo that is ok, as long as it look professional) please look at construction company pages and values to get an understanding. Our values that we need logos for are:
Innovation
Professionalism
Dependability

I am looking for a designer to help me bring my company&#039;s Mission, Vision statement and Values list to life. We would like everything incorporated into one image so that it can be printed in various places and in different sizes.
We would want something tailored to our industry - agriculture and I would really love to see something designed around

...step.
3- Generate a pool p that holds values from [1,p] (i.e. p is an array that holds values from 1 to 10000, the values in p must be randomly distributed such that p(1,643,2,44,5,6,438,…) )
Then each node should random pick values v from p (i.e. if v = 150, then each nodes should randomly pick 150 values from p, v(2,66,522,…) )
4- The n...

Add new values from textbox to existing values in database, i want all values inserted into textbox to store in database keeping the old values while adding new values with a / all in one column php mysql

...scripting (PHP/Python) and/or MYSQL programing to provide me with the script/code and/or MYSQL queries that I can run on my store's database to convert the database tables and data values from Opencart v1.5.6 database to the proper format to Transfer/Migrate all of the e-commerce store data including customers, product, category, order history, inventory, and

...number, value: 47PM1118D1133. The script should then output that the field does contain this value.
There should also be a section of the code, where the user enter the input values as variables, instead of having to input it in the command line. This section should be able to be commented out, incase user does not want to use this option. For ex. It would

See below. I need the five values of the Squares put into the Data Window.
With 1 meaning Red, 2, Meaning Blue and 3 Meaning Yellow. Simple.
Attached is a pic to show you want I mean. [login to view URL]

Hello.
I have some files with data in cells splitted by semicolon, and I need to unstack them into rows, using first column as identifier.
Examples of initial data and what i need to achieve is enclosed
I need sources - eg - Excel formula, VBA code or Python code to complete work on own files
Budget -10$ - any offers above will be reported

I will provide the URL to a website from which I will need you to write down around 1500 values into an Excel sheet.
Example of values: 225.77, 24.9, 158.44 etc....
All instructions will be provided to the right candidate.

...scripting (PHP/Python) and/or MYSQL programing to provide me with the script/code and/or MYSQL queries that I can run on my store's database to convert the database tables and data values from Opencart v1.5.6 database to the proper format to Transfer/Migrate all of the e-commerce store data including customers, product, category, order history, inventory, and

...scripting (PHP/Python) and/or MYSQL programing to provide me with the script/code and/or MYSQL queries that I can run on my store's database to convert the database tables and data values from Opencart v1.5.6 database to the proper format to Transfer/Migrate all of the e-commerce store data including customers, product, category, order history, inventory, and

A simple search tool which searches all values in 1 workbook in other work books and display than in which excel file, workbook and cell you can find that value. Should also be possible to give in an error margin i.e. + or - 10, if you have a value of 1000 in a work book than it searches in the other worksbooks and files for all matches between 990

The db doesn't want to bring up the values from the models to display them back to the form fields in views. Using codeigniter website. I have controller, models, views and URL address to check yourself.

I need a web form created. See attached picture for all fields and requirements.
Upon pressing "submit" I need the values sent to a python script. I have the script written, I just need a way to get all those values into the script.
This cannot be made with PHP. Looking for a quick turnaround.

I have several drawings which need to be converted into checksheets for production. The scope of work is shown below;
- Open the provided drawing which contains inspection points.
- Take the numbers at each inspection points into prepared excel template (for example, 10 +0.02/-0.05).
- Capture the picture with the inspection point and save in the predefined name, for example, [login to view URL], ...

...
I need an 84 day Delicious and Varied Meal Plan based on the Ketogenic Diet with nutritional values for each meal.
With 5 meals per day (breakfast, snack, lunch, snack, and dinner) and each meal with the nutritional value. For example : Nutritional values: Kcal: 401 Protein: 22.3g, Carbs: 52.6g, Dietary Fiber: 10.4g, Fats: 13.7g
The meal plan needs