Autorun for vba GUI.xlsm

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Z	AA	AB
1			Walls calculation
2	City	Lahore			North	58.11	Lahore	Sialkot	Peshawar	Abbotabad	Multan
3							31.5	32.29	34	34.18	30.2
4	Latitude	31.5	N		East	29.63	40.5	40.5	41.3	35.1	43.1				m2
5	Outdoor design dry bulb	40.5	Celsius				30.7	29.5	30.5	25.4	29.7
6	Outdoor design white bulb	30.7	Celsius		West	22.72	6.9	8.2	8.9	9.7	8.7
7	Range	6.9	Celsius
8	Ti	25	Celsius		South	54.06
9	TM	37.05
10	Value to be added(In correction)	8.05
11	R	0.357			Wall no. 4
12	U	2.8	W/m2K
13	Wall Type	Double														West						South
14		North						East
15	Hours	CLTD	CLTD(correction)	Q(watts)	Q(KW)	Hours	CLTD	CLTD(correction)	Q(watt)	Q(KW)			Hours	CLTD	CLTD(correction)	Q(watt)	Q(KW)	Hours	CLTD	CLTD(correction)	Q	Q(KW)		Toatla
16	1	11	14.16111111	2304	2.30	1	10	13.60555556	1128.771311	1.13			1	21	19.71666667	1254.295467	1.25	1	11	14.16111111	2143.539067	2.14		6.83
17	2	8	12.49444444	2033	2.03	2	8	12.49444444	1036.589089	1.04			2	15	16.38333333	1042.242133	1.04	2	8	12.49444444	1891.259067	1.89		6.00
18	3	6	11.38333333	1852	1.85	3	5	10.82777778	898.3157556	0.90			3	10	13.60555556	865.5310222	0.87	3	5	10.82777778	1638.979067	1.64		5.25
19	4	4	10.27222222	1671	1.67	4	4	10.27222222	852.2246444	0.85			4	7	11.93888889	759.5043556	0.76	4	3	9.716666667	1470.7924	1.47		4.75
20	5	20	19.16111111	3118	3.12	5	21	19.71666667	1635.773533	1.64			5	42	31.38333333	1996.482133	2.00	5	20	19.16111111	2900.379067	2.90		9.65
21	6	20	19.16111111	3118	3.12	6	21	19.71666667	1635.773533	1.64			6	42	31.38333333	1996.482133	2.00	6	20	19.16111111	2900.379067	2.90		9.65
22	7	0	8.05	1310	1.31	7	0	8.05	667.8602	0.67			7	0	8.05	512.1088	0.51	7	-1	7.494444444	1134.419067	1.13		3.62
23	8	0	8.05	1310	1.31	8	4	10.27222222	852.2246444	0.85			8	0	8.05	512.1088	0.51	8	-1	7.494444444	1134.419067	1.13		3.81
24	9	3	9.716666667	1581	1.58	9	14	15.82777778	1313.135756	1.31			9	0	8.05	512.1088	0.51	9	0	8.05	1218.5124	1.22		4.62
25	10	5	10.82777778	1762	1.76	10	26	22.49444444	1866.229089	1.87			10	2	9.161111111	582.7932444	0.58	10	2	9.161111111	1386.699067	1.39		5.60
26	11	8	12.49444444	2033	2.03	11	37	28.60555556	2373.231311	2.37			11	5	10.82777778	688.8199111	0.69	11	5	10.82777778	1638.979067	1.64		6.73
27	12	10	13.60555556	2214	2.21	12	45	33.05	2741.9602	2.74			12	8	12.49444444	794.8465778	0.79	12	11	14.16111111	2143.539067	2.14		7.89
28	13	13	15.27222222	2485	2.48	13	48	34.71666667	2880.233533	2.88			13	11	14.16111111	900.8732444	0.90	13	18	18.05	2732.1924	2.73		9.00
29	14	16	16.93888889	2756	2.76	14	47	34.16111111	2834.142422	2.83			14	15	16.38333333	1042.242133	1.04	14	25	21.93888889	3320.845733	3.32		9.95
30	15	19	18.60555556	3027	3.03	15	44	32.49444444	2695.869089	2.70			15	21	19.71666667	1254.295467	1.25	15	32	25.82777778	3909.499067	3.91		10.89
31	16	22	20.27222222	3298	3.30	16	40	30.27222222	2511.504644	2.51			16	30	24.71666667	1572.375467	1.57	16	36	28.05	4245.8724	4.25		11.63
32	17	24	21.38333333	3479	3.48	17	37	28.60555556	2373.231311	2.37			17	41	30.82777778	1961.139911	1.96	17	39	29.71666667	4498.1524	4.50		12.31
33	18	26	22.49444444	3660	3.66	18	34	26.93888889	2234.957978	2.23			18	52	36.93888889	2349.904356	2.35	18	38	29.16111111	4414.059067	4.41		12.66
34	19	27	23.05	3750	3.75	19	32	25.82777778	2142.775756	2.14			19	60	41.38333333	2632.642133	2.63	19	36	28.05	4245.8724	4.25		12.77
35	20	27	23.05	3750	3.75	20	29	24.16111111	2004.502422	2.00			20	63	43.05	2738.6688	2.74	20	32	25.82777778	3909.499067	3.91		12.40
36	21	26	22.49444444	3660	3.66	21	25	21.93888889	1820.137978	1.82			21	59	40.82777778	2597.299911	2.60	21	27	23.05	3489.0324	3.49		11.57
37	22	23	20.82777778	3389	3.39	22	21	19.71666667	1635.773533	1.64			22	50	35.82777778	2279.219911	2.28	22	23	20.82777778	3152.659067	3.15		10.46
38	23	19	18.60555556	3027	3.03	23	17	17.49444444	1451.409089	1.45			23	39	29.71666667	1890.455467	1.89	23	18	18.05	2732.1924	2.73		9.10
39	24	15	16.38333333	2666	2.67	24	14	15.82777778	1313.135756	1.31			24	29	24.16111111	1537.033244	1.54	24	14	15.82777778	2395.819067	2.40		7.91
40
41
42				Roof calculation
43	U	4.78
44	R	0.209	A	139.64
45	Roof Type	Double	Roof no.5
46
47	Hours	CLTD	CLTD(correction)	Q(watts)	Q(KW)
48	1	21	19.71666667	13160.46489	13.16046489
49	2	16	16.93888889	11306.356	11.306356
50	3	12	14.71666667	9823.068893	9.823068893
51	4	8	12.49444444	8339.781782	8.339781782
52	5	5	10.82777778	7227.316449	7.227316449
53	6	3	9.716666667	6485.672893	6.485672893
54	7	1	8.605555556	5744.029338	5.744029338
55	8	2	9.161111111	6114.851116	6.114851116
56	9	5	10.82777778	7227.316449	7.227316449
57	10	12	14.71666667	9823.068893	9.823068893
58	11	21	19.71666667	13160.46489	13.16046489
59	12	31	25.27222222	16868.68267	16.86868267
60	13	42	31.38333333	20947.72223	20.94772223
61	14	52	36.93888889	24655.94	24.65594
62	15	61	41.93888889	27993.336	27.993336
63	16	67	45.27222222	30218.26667	30.21826667
64	17	70	46.93888889	31330.732	31.330732
65	18	70	46.93888889	31330.732	31.330732
66	19	66	44.71666667	29847.44489	29.84744489
67	20	59	40.82777778	27251.69245	27.25169245
68	21	51	36.38333333	24285.11823	24.28511823
69	22	42	31.38333333	20947.72223	20.94772223
70	23	34	26.93888889	17981.148	17.981148
71	24	27	23.05	15385.39556	15.38539556
72
73
74
75			windows calculation
76	U	4.75			North	3.9
77	Sc	0.72			East	2.78
78	Window Type	Double			South	0
79					West	4.92
80
81
82
83
84		North									East								West
85	Solar Time	CLTD C	CLTD correcteed C	Q (Watt) conduction	SCL	Q Rad(watt)	Q(total)	Q kw	Solar Time	CLTD C	CLTD correcteed C	Q (watt)conduction	SCL	Q (rad)	Q(watt) Total	Q kw	Solar Time	CLTD C	CLTD correcteed C	Q(watt)Conduction	SCL	Q(rad)	Q(watt)total	Q kw	Q kW by Conduction	Q Kw by Transmission	Q Total
86	1	1	9.05	167.65125	5	20.052	187.70325	0.18770325	1	1	9.05	119.50525	9	23.1336	142.63885	0.14263885	1	1	9.05	211.4985	16	56.6784	268.1769	0.2681769	0.498655	0.099864	0.598519
87	2	0	8.05	149.12625	5	20.052	169.17825	0.16917825	2	0	8.05	106.30025	8	20.5632	126.86345	0.12686345	2	0	8.05	188.1285	15	53.136	241.2645	0.2412645	0.443555	0.0937512	0.5373062
88	3	-1	7.05	130.60125	4	16.0416	146.64285	0.14664285	3	-1	7.05	93.09525	8	20.5632	113.65845	0.11365845	3	-1	7.05	164.7585	13	46.0512	210.8097	0.2108097	0.388455	0.082656	0.471111
89	4	-1	7.05	130.60125	4	16.0416	146.64285	0.14664285	4	-1	7.05	93.09525	7	17.9928	111.08805	0.11108805	4	-1	7.05	164.7585	12	42.5088	207.2673	0.2072673	0.388455	0.0765432	0.4649982
90	5	-1	7.05	130.60125	3	12.0312	142.63245	0.14263245	5	-1	7.05	93.09525	6	15.4224	108.51765	0.10851765	5	-1	7.05	164.7585	11	38.9664	203.7249	0.2037249	0.388455	0.06642	0.454875
91	6	-1	7.05	130.60125	24	96.2496	226.85085	0.22685085	6	-1	7.05	93.09525	77	197.9208	291.01605	0.29101605	6	-1	7.05	164.7585	16	56.6784	221.4369	0.2214369	0.388455	0.3508488	0.7393038
92	7	-1	7.05	130.60125	25	100.26	230.86125	0.23086125	7	-1	7.05	93.09525	128	329.0112	422.10645	0.42210645	7	-1	7.05	164.7585	22	77.9328	242.6913	0.2426913	0.388455	0.507204	0.895659
93	8	0	8.05	149.12625	24	96.2496	245.37585	0.24537585	8	0	8.05	106.30025	148	380.4192	486.71945	0.48671945	8	0	8.05	188.1285	27	95.6448	283.7733	0.2837733	0.443555	0.5723136	1.0158686
94	9	1	9.05	167.65125	27	108.2808	275.93205	0.27593205	9	1	9.05	119.50525	145	372.708	492.21325	0.49221325	9	1	9.05	211.4985	31	109.8144	321.3129	0.3213129	0.498655	0.5908032	1.0894582
95	10	2	10.05	186.17625	31	124.3224	310.49865	0.31049865	10	2	10.05	132.71025	124	318.7296	451.43985	0.45143985	10	2	10.05	234.8685	34	120.4416	355.3101	0.3553101	0.553755	0.5634936	1.1172486
96	11	4	12.05	223.22625	33	132.3432	355.56945	0.35556945	11	4	12.05	159.12025	89	228.7656	387.88585	0.38788585	11	4	12.05	281.6085	36	127.5264	409.1349	0.4091349	0.663955	0.4886352	1.1525902
97	12	5	13.05	241.75125	35	140.364	382.11525	0.38211525	12	5	13.05	172.32525	62	159.3648	331.69005	0.33169005	12	5	13.05	304.9785	37	131.0688	436.0473	0.4360473	0.719055	0.4307976	1.1498526
98	13	7	15.05	278.80125	35	140.364	419.16525	0.41916525	13	7	15.05	198.73525	56	143.9424	342.67765	0.34267765	13	7	15.05	351.7185	59	209.0016	560.7201	0.5607201	0.829255	0.493308	1.322563
99	14	7	15.05	278.80125	34	136.3536	415.15485	0.41515485	14	7	15.05	198.73525	52	133.6608	332.39605	0.33239605	14	7	15.05	351.7185	98	347.1552	698.8737	0.6988737	0.829255	0.6171696	1.4464246
100	15	8	16.05	297.32625	32	128.3328	425.65905	0.42565905	15	8	16.05	211.94025	47	120.8088	332.74905	0.33274905	15	8	16.05	375.0885	132	467.5968	842.6853	0.8426853	0.884355	0.7167384	1.6010934