Terminé

Excel Macro programming for a Job cost/price calculation sheet

Overview

This spreadsheet is used to calculate the costs and selling prices for Jobs.

• Each job can have a varying number of Signs.

• When the user enters a number in the Number of Signs field, the Sign 0 tab is replicated “N” times. The tabs would be labelled Sign 1, Sign 2, Sign 3 etc.

• Sign 0 should end up hidden so it is kept as a blank template. If the user changes the Number of Signs, then the Sign 0 tab can be used to add more Sign tabs.

• The items in the In House Labour section of the Summary tab are the same on each Sign tab. We need a macro to add up all the Tot Hrs across the Sign tabs for the Tot Hrs column for each labour item.

• Summary tab - Subcontract / Install Contractors: We need a macro to pull in the Description of any items entered across the Sign tabs and the corresponding Qty. If more lines are needed, the macro would insert lines.

• Summary tab: Raw Materials/Services: This section needs a macro to pull in any item from the Raw Materials /Services section across the Sign tabs. It should pull in the Description (B42) => map to Description, Qty (F42)=> maps to Quantity, Cost (G42) => maps to Cost, Sell (J42) => maps to Price. Put a “0” in the Billable column. This could be many rows.

• Summary Tab – Raw Materials /Services: Cost and Sell. Need a macro which adds up the total cost and sell from each Sign tab.

* See the "Blank" spreadsheet for programming

* See the "Sample Data" spreadsheet to see the expected outcomes

* See the "Brief" word doc for a more detailed brief.

Compétences : Excel, Visual Basic

en voir plus : vba excel manual calculation sheet, excel macro filling excel sheet, excel vba macro programming bids, simple cost sheet format in excel, how to calculate cost per unit in excel, food cost inventory spreadsheet, cost of goods manufactured excel template, cost sheet in excel formula, food cost spreadsheet excel, product costing format, cost of production report format in excel, excel macro programming cut paste, excel macro programming outsource, excel macro expert job, excel macro contract job, excel macro side job, excel macro programming job, excel macro programming jobs, excel macro programming read pdf, ms excel macro programming

Concernant l'employeur :
( 0 commentaires ) Barden Ridge, Australia

Nº du projet : #22406534

Décerné à:

TechnoGuruu

Hi, As per requirements I will develop Automated Excel with VBA macro for you as per description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high a Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 7 jours
(81 Commentaires)
6.0

14 freelance font une offre moyenne de $371 pour ce travail

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(738 Commentaires)
8.5
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application. I plan to use a combination of formulas and VBA code to acc Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(232 Commentaires)
7.4
dgled

Hi, I can do your project. I am financial experts and a guru in Excel with extensive knowledge and expertise in advanced formulas, Pivot Tables, Tables, solver and Visual Basic Application including preparation of avai Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(87 Commentaires)
7.1
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can help you build your price calculation in your sheet please ping me for discuss more and im free now to start discuss Sir Thank you Galih

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(366 Commentaires)
7.2
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(330 Commentaires)
7.3
HardWorker1989

Hi there. Have you ever thought about having a PDF Template that fulfills all the needs you have mentioned above? Kindly review this link: [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(81 Commentaires)
6.8
shikhamehta

Hey, I reviewed the two spreadsheets and the word document you shared and can create the desired macros that will allow easy replication of Sign 0 template sheet and also calculate the summary numbers like you have de Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(98 Commentaires)
6.4
Nidhijain123

Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(101 Commentaires)
6.2
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Thank you, Regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(108 Commentaires)
6.3
atifdar

Hi there, Excel guru here with Advance Accounting background Have gone through the project description and sample spreadsheet that you’re looking for to be automated I’m confident that I’ll deliver you required auto Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(76 Commentaires)
6.2
dvcontact

Hi, Would you like to see a quick demo of your project on building an advanced spreadsheet solution for calculating the costs and selling prices for Jobs before you award the project? You can consider it professionally Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(51 Commentaires)
6.4
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(124 Commentaires)
5.9
vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(84 Commentaires)
5.7