Suoritettu

convert Php to Excel Macro

1) convert the following logic into Excel Macro

$floatP25 = p_l_price($GBPPrice, $strPacketType, 0.25, $GBPPrice);

$floatP50 = p_l_price($GBPPrice, $strPacketType, 0.50, $floatP25);

$floatP75 = p_l_price($GBPPrice, $strPacketType, 0.75, $floatP50);

floatP100 = p_l_price($GBPPrice, $strPacketType, 1, $floatP75);

function p_l_price($GBPPrice, $strPacketType, $intProfitlevel, $intStartingValue) {

for ($intI = 0; $intI < 100000; $intI++) {

if (0 == $intI) {

$Selling_Price = $intStartingValue;

} else {

$Selling_Price = $Selling_Price + 0.05;

}//end else

$intp_l_price = GetProfitablePrice($GBPPrice, $strPacketType, $Selling_Price);

if ($intp_l_price > $intProfitlevel || $intp_l_price == $intProfitlevel) {

return number_format($Selling_Price, 2);

break;

}//end if

}//end for loop

}

//end function

function GetProfitablePrice($GBP_unit_price, $strPacketType, $Selling_Price) {

if ($strPacketType == 1) {

$strPacketCost = "0.90";

} elseif ($strPacketType == 2) {

$strPacketCost = "1.3";

} elseif ($strPacketType == 3) {

$strPacketCost = "2.93";

} elseif ($strPacketType == 4) {

$strPacketCost = "4.25";

}

$commisson = $Selling_Price * 0.09;

$pick_pack = 0.80;

$paypal_commision = 0.2 + ( 0.024 * $Selling_Price );

$vat = $Selling_Price - ( $Selling_Price / 1.2);

$total_cost = $GBP_unit_price + $commisson + $pick_pack + $paypal_commision + $vat + $strPacketCost;

$p_l_amt = $Selling_Price - $total_cost;

$p_l_per = 0;

if (0 != $GBP_unit_price) {

$p_l_per = $p_l_amt / $GBP_unit_price;

}

return $p_l_per;

}

Basically we are a company that sells online
We require two macro one

Get Sell Price
1) When we sell an item what price should we sell to get certain profit

for that we need to give excel

function GetSellPrice($Price,$GBPUSDConverstion,$PacketType,$ProfitRequired)


Get Purchase Price
2) When we buy an item we need to know what price should buy at.

for that we need to give excel

function GetPurchasePrice($Price,$GBPUSDConverstion,$PacketType,$ProfitRequired)

Taidot: tiedonsyöttö, Excel, PHP

Näytä lisää: excel to website converter, convert excel formula in php, excel formula to php, php excel writer, php read excel, php excel import, convert excel in php, excel sheet converter, excel macro convert weight, macro convert csv excel, convert excel macro standalone application, convert excel macro access, php excel macro script, convert excel macro access macro, excel macro convert address octets, macro convert xls excel, convert log file lfp file excel macro, convert unicode excel macro, php excel convert utf, turn excel macro php

Tietoa työnantajasta:
( 28 arvostelua ) Kidlington, United Kingdom

Projektin tunnus: #17653031

Myönnetty käyttäjälle:

vano101

Hello I know both PHP and Excel VBA, and I have extensive experience with converting code from one programming language to another programming language.

$30 USD 1 päivässä
(210 Arvostelua)
6.0

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

liangjongai

I'm interested in your project very well. I've got an experience in jobs with skills of vba and php both. Please ping me to discuss about this project.

$166 USD 1 päivässä
(228 arvostelua)
7.6
Rahulkeshwani19

Dear Sir, Ready to convert php code to excel macro Hope you are doing well. After carefully reviewing the requirements of the job description, I feel that we are very much suitable for the job. We can start worki Lisää

$100 USD 1 päivässä
(107 arvostelua)
7.0
sagarwal3005

Hi, I can start immediately to convert your code to excel macro. I can start immediately to finish within 3 hours. PLease drop a message to start and finish asap

$60 USD 0 päivässä
(99 arvostelua)
6.7
$30 USD 1 päivässä
(52 arvostelua)
5.1
RushService

Feel fee to contact me for convert Php to Excel [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment only Lisää

$30 USD 1 päivässä
(13 arvostelua)
4.6
sambestsolutions

Hi I am an Engineering undergraduate experience in PHP and excel VBA macro for more than 3 years. I can do this for you. Please message to discuss further on this Thanks Note-please check my profile for past project Lisää

$30 USD 2 päivässä
(8 arvostelua)
3.0
Mokshith30

Hi I am "VBA Developer". Expert in Web Scraping & VBA Macros.. Outlook Automation i can scrape any website.. & Python programming, Google Apps Script coding, Wordpress Developement, HTML, VB.Net I will do Lisää

$30 USD 1 päivässä
(9 arvostelua)
3.1
hsingla85

Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Champion | Understand PHP

$40 USD 1 päivässä
(6 arvostelua)
3.1
krishnaagr89

Hi,I have read your requirements of convert Php to Excel Macro and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You Lisää

$24 USD 1 päivässä
(6 arvostelua)
3.1
blizneccherkassy

Hello. I have read your requirement carefully so I think you want a macro which is called "p_l_price". I have good experience with office and I have used macro in office. Especially, excel macro has lots of functi Lisää

$35 USD 0 päivässä
(2 arvostelua)
1.1
iamtahirmalik

hello sir i am interesting in your project convert Php to Excel Macro please message me so we discuss about the project.............................................

$10 USD 1 päivässä
(5 arvostelua)
3.1
$35 USD 3 päivässä
(0 arvostelua)
0.0
ashrkhan

Hi this is Ashar.i have work with many business and IT houses i hope i can help you Contact me so we can discuss more about the project. :)

$25 USD 1 päivässä
(0 arvostelua)
0.0
smartken21

hi I've gone through your codes. let me do the work for you and I assure you job satisfaction. let's talk further on chat. regards kartik

$35 USD 1 päivässä
(0 arvostelua)
0.0
anvithanavada

I'm new to freelancing and an enthusiastic programmer. I have addressed your problem statement. I have written two functions in excel macro : 1.p_l_price 2. GetProfitablePrice Let me know if you are interested

$20 USD 0 päivässä
(1 arvostelu)
0.0
mohamedabdelgha8

I am an engineer and I have experience in software programs in addition to the financial experience in project management. I have got a full course in Excel program where I can work all the equations and everything rel Lisää

$20 USD 1 päivässä
(0 arvostelua)
0.0