Käynnissä

Heatload room to room caculator - air conditioner

Need to convert a Microsoft excel spreadsheet (macros need to be enabled when the excel is open) with calculations on it into a online html/JavaScript/php form that will just send all the info to an email address. I can style it with css But I just need the script working.

The calculations are under the spreadsheet which I would want kept hidden which I think it will if that's converted to JavaScript or PHP? The checkboxes are vital to the form. Basically there's two forms needed one for calculating heatload in a house and there's another spreadsheet that once the heatload is determine it will narrow down the type of wall mounted split air conditioner/s is suitable according to the results.

All the formulas are on the spreadsheet in the white area

I'll explain below how the form will work so you can have a better understanding what is required.

Steps (House Heatload form):

1. Project title is entered (input box)

2. Client enters their address and contact details (input boxes)

3. Client is required to entered ceiling height (input box)

4. Client must only select only ONE ceiling insulation (check boxes)

5. Client must select only ONE wall construction (check boxes)

6. Room column - client must be able to alter the room title to suit their house

7. Length is required on each of the selected rooms (input)

8. Width is required on each of the selected rooms (input)

9. Results of the height (ceiling height entered in step 3) and heatload is calculated using the formula in the white area below the spreadsheet (from c39- w39 to below)

10. Total area in m2, required heatload kW and required airflow L/sec should appear after the above input area are all entered

11. Client is now able to submit results to the email address of the business

Steps (Wall Mounted Split form):

1. Project title(input box)

2. Client enters their address and contact details (input boxes)

3. Client is required to entered ceiling height (input box)

4. Client must only select only ONE ceiling insulation (check boxes)

5. Client must select ONE wall construction (check boxes)

6. Room column - client must be able to alter the room title to suit their house

7. Length is required on each of the selected rooms (input)

8. Width is required on each of the selected rooms (input)

9. Client enters basic distance calculation (check boxes and input boxes)

10. Client enters the air conditioner install options (check boxes and input boxes)

11. Results of the height (ceiling height entered in step 3) and heatload is calculated using the formula in the white area below the spreadsheet (from c39- w39 below on previous spreadsheet?)

12. Automatically calculated - Total area in m2, required heatload kW and required airflow L/sec should appear after the above input area are all entered

13. Client is able to select a wall mounted split according to the kW results with the price automatically calculated depending on the above information

14. Client is now able to submit results to the email address of the business

Will need a print and reset option on both forms

Helpful resources:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

closest to what's needed but this just does just one room at a time need to do all the rooms on the one form) and it has the option to show the air conditioners from the kW results

[url removed, login to view]

I'm using converter software to get this to work but I'm having no luck as I keep getting errors which I was told will be corrected on the new version that comes out in 1 to 2 weeks but I need something for client to use this week, so it's pretty urgent too so I'll need it in a few days if that's possible? I have a small budget of $30-60AUD

Basically need the excel spreadsheet converted/replicated into an online html form using Javascript or php so the formulas work and automatically calculate like they to on the spreadsheet.

Then according to the KW heatload the user is able to select an air con model that is within the same kW with the included price of the air con and installation total calculated. Just like how the spreadsheet does.

Basically like the 2nd to last example (http://www.aircondirect.com.au/ac_direct/pages/HeatLoad.jsp ) I found but with more rooms instead of one room then the user submits to a basic php mailer form to the business' email address

Taidot: Excel, Javascript, PHP

Näytä lisää: room heat load calculation excel, hvac heat load calculation formula excel, basic heat load calculation, script air conditioner calculator, heat load form, www when to work com, www microsoft excel formulas, www kw com, spreadsheet javascript, spreadsheet in javascript, price hvac, php to jsp converter online, php to excel converter, online business step, mini project in jsp, microsoft online business, microsoft excel online, microsoft excel formulas, microsoft email for business, kw.com, i need to open online business, html to php converter, html form to spreadsheet, html 5 to css converter, height and length

About the Employer:
( 2 reviews ) Adelaide, Australia

Projektin tunnus: #503175

11 freelanceria on tarjonnut keskimäärin 149 $ tähän työhön

VALUEONWEB

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have experti Lisää

150 $ USD 3 päivässä
(205 arvostelua)
7.9
DrTech76

Hi, I am an engineer with strong knowlege in thermodynamics and air conditionning, so I am familiar with the calculations. No mistakes there. Despite that I will thoroughly review the xlsm file just for consistency. I Lisää

50 $ USD 2 päivässä
(278 arvostelua)
6.6
AStonetech

Let's get it done, we can start right now. Looking forward to work for you. Thank You.

100 $ USD 3 päivässä
(128 arvostelua)
6.4
webmindsindia

You will have no problems in selecting a winner.

150 $ USD 2 päivässä
(10 arvostelua)
6.0
darklord18

Dear Sir, See PM, Regards, Naveesh Doolhur

60 $ USD 5 päivässä
(9 arvostelua)
4.6
yezongbo

Brother .Please check the pm.

200 $ USD 2 päivässä
(10 arvostelua)
3.7
devajas

your project is [url removed, login to view] we can do. regards

350 $ USD 14 päivässä
(8 arvostelua)
3.6
mvweb

I am very interested in this project.

50 $ USD 4 päivässä
(2 arvostelua)
2.8
winix

Hi, This project is very interesting. I will be glad to work on this project. More Info supplied in PM. Thanks

150 $ USD 2 päivässä
(2 arvostelua)
2.1
DrMDodd

Please see PMB. Regards, Martin

80 $ USD 2 päivässä
(1 arvostelu)
1.8
jeffrych

3 days, delivery including : html pages with java script and php script + document how to install/customize

250 $ USD 3 päivässä
(0 arvostelua)
0.0
pavankovela

With the zeal to excel and the temperament to succeed. I would like to grow along with the Organization, Utilize my Abilities and my Confidence in the competitive world of Information Technology for the Benefits of the Lisää

200 $ USD 5 päivässä
(1 arvostelu)
0.0
mrinmoy2s

I am interested in your offer.T have already made some macro that are in good use now.I will try to give my best on my work and also try to submit quality projects that will be superior from [url removed, login to view] forward the p Lisää

50 $ USD 5 päivässä
(0 arvostelua)
0.0