hi
a,b,c,d,e pivot table colums.
f,g,h,ı,j,k my formula columns.(sample columns)
can i add my formula columns with vba "calculation field add"?
i wish to turn my formula colums to pivot table calculation field(sample colums => calculation field with vba)
my sample data is down
thx
[TABLE="width: 1420"]
<tbody>[TR]
[TD]Sub-Category 2[/TD]
[TD]base price[/TD]
[TD]Average x custumer price[/TD]
[TD]Average y custumer price[/TD]
[TD]Average z customer price[/TD]
[TD]sample col1[/TD]
[TD]sample col 2[/TD]
[TD]sample col3[/TD]
[TD]sample col4[/TD]
[TD]sample col5[/TD]
[TD]sample col 6[/TD]
[/TR]
[TR]
[TD]Appliances 1[/TD]
[TD]21,78[/TD]
[TD]29[/TD]
[TD]22[/TD]
[TD]30[/TD]
[TD]MIN(C2:E2)[/TD]
[TD]MAX(C2:E2)[/TD]
[TD]AVERAGE(C2:E2)[/TD]
[TD]C2/B2[/TD]
[TD]D2/B2[/TD]
[TD]E2/B2[/TD]
[/TR]
[TR]
[TD]Appliances 2[/TD]
[TD]21,78[/TD]
[TD]29[/TD]
[TD]29[/TD]
[TD]25[/TD]
[TD]MIN(C3:E3)[/TD]
[TD]MAX(C3:E3)[/TD]
[TD]AVERAGE(C3:E3)[/TD]
[TD]C3/B3[/TD]
[TD]D3/B3[/TD]
[TD]E3/B3[/TD]
[/TR]
[TR]
[TD]Binders and Binder Accessories 1[/TD]
[TD]2,08[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]7[/TD]
[TD]MIN(C4:E4)[/TD]
[TD]MAX(C4:E4)[/TD]
[TD]AVERAGE(C4:E4)[/TD]
[TD]C4/B4[/TD]
[TD]D4/B4[/TD]
[TD]E4/B4[/TD]
[/TR]
[TR]
[TD]Binders and Binder Accessories 2[/TD]
[TD]3,52[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]MIN(C5:E5)[/TD]
[TD]MAX(C5:E5)[/TD]
[TD]AVERAGE(C5:E5)[/TD]
[TD]C5/B5[/TD]
[TD]D5/B5[/TD]
[TD]E5/B5[/TD]
[/TR]
[TR]
[TD]Binders and Binder Accessories 3[/TD]
[TD]5,98[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]MIN(C6:E6)[/TD]
[TD]MAX(C6:E6)[/TD]
[TD]AVERAGE(C6:E6)[/TD]
[TD]C6/B6[/TD]
[TD]D6/B6[/TD]
[TD]E6/B6[/TD]
[/TR]
[TR]
[TD]Bookcases 1[/TD]
[TD]81,94[/TD]
[TD]65[/TD]
[TD]95[/TD]
[TD]80[/TD]
[TD]MIN(C7:E7)[/TD]
[TD]MAX(C7:E7)[/TD]
[TD]AVERAGE(C7:E7)[/TD]
[TD]C7/B7[/TD]
[TD]D7/B7[/TD]
[TD]E7/B7[/TD]
[/TR]
[TR]
[TD]Bookcases 2[/TD]
[TD]100,98[/TD]
[TD]88[/TD]
[TD]73[/TD]
[TD]70[/TD]
[TD]MIN(C8:E8)[/TD]
[TD]MAX(C8:E8)[/TD]
[TD]AVERAGE(C8:E8)[/TD]
[TD]C8/B8[/TD]
[TD]D8/B8[/TD]
[TD]E8/B8[/TD]
[/TR]
[TR]
[TD]Chairs & Chairmats 1[/TD]
[TD]120,98[/TD]
[TD]125[/TD]
[TD]147[/TD]
[TD]137[/TD]
[TD]MIN(C9:E9)[/TD]
[TD]MAX(C9:E9)[/TD]
[TD]AVERAGE(C9:E9)[/TD]
[TD]C9/B9[/TD]
[TD]D9/B9[/TD]
[TD]E9/B9[/TD]
[/TR]
[TR]
[TD]Chairs & Chairmats 2[/TD]
[TD]122,99[/TD]
[TD]163[/TD]
[TD]210[/TD]
[TD]196[/TD]
[TD]MIN(C10:E10)[/TD]
[TD]MAX(C10:E10)[/TD]
[TD]AVERAGE(C10:E10)[/TD]
[TD]C10/B10[/TD]
[TD]D10/B10[/TD]
[TD]E10/B10[/TD]
[/TR]
[TR]
[TD]Computer Peripherals 1[/TD]
[TD]30,98[/TD]
[TD]29[/TD]
[TD]28[/TD]
[TD]30[/TD]
[TD]MIN(C11:E11)[/TD]
[TD]MAX(C11:E11)[/TD]
[TD]AVERAGE(C11:E11)[/TD]
[TD]C11/B11[/TD]
[TD]D11/B11[/TD]
[TD]E11/B11[/TD]
[/TR]
[TR]
[TD]Computer Peripherals 2[/TD]
[TD]39,48[/TD]
[TD]52[/TD]
[TD]50[/TD]
[TD]40[/TD]
[TD]MIN(C12:E12)[/TD]
[TD]MAX(C12:E12)[/TD]
[TD]AVERAGE(C12:E12)[/TD]
[TD]C12/B12[/TD]
[TD]D12/B12[/TD]
[TD]E12/B12[/TD]
[/TR]
[TR]
[TD]Computer Peripherals 3[/TD]
[TD]49,99[/TD]
[TD]38[/TD]
[TD]39[/TD]
[TD]34[/TD]
[TD]MIN(C13:E13)[/TD]
[TD]MAX(C13:E13)[/TD]
[TD]AVERAGE(C13:E13)[/TD]
[TD]C13/B13[/TD]
[TD]D13/B13[/TD]
[TD]E13/B13[/TD]
[/TR]
[TR]
[TD]Envelopes 1[/TD]
[TD]4,48[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]MIN(C14:E14)[/TD]
[TD]MAX(C14:E14)[/TD]
[TD]AVERAGE(C14:E14)[/TD]
[TD]C14/B14[/TD]
[TD]D14/B14[/TD]
[TD]E14/B14[/TD]
[/TR]
[TR]
[TD]Envelopes 2[/TD]
[TD]5,58[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]8[/TD]
[TD]MIN(C15:E15)[/TD]
[TD]MAX(C15:E15)[/TD]
[TD]AVERAGE(C15:E15)[/TD]
[TD]C15/B15[/TD]
[TD]D15/B15[/TD]
[TD]E15/B15[/TD]
[/TR]
[TR]
[TD]Envelopes 3[/TD]
[TD]5,68[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]MIN(C16:E16)[/TD]
[TD]MAX(C16:E16)[/TD]
[TD]AVERAGE(C16:E16)[/TD]
[TD]C16/B16[/TD]
[TD]D16/B16[/TD]
[TD]E16/B16[/TD]
[/TR]
[TR]
[TD]Labels 1[/TD]
[TD]2,88[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]MIN(C17:E17)[/TD]
[TD]MAX(C17:E17)[/TD]
[TD]AVERAGE(C17:E17)[/TD]
[TD]C17/B17[/TD]
[TD]D17/B17[/TD]
[TD]E17/B17[/TD]
[/TR]
[TR]
[TD]Labels 2[/TD]
[TD]3,69[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]MIN(C18:E18)[/TD]
[TD]MAX(C18:E18)[/TD]
[TD]AVERAGE(C18:E18)[/TD]
[TD]C18/B18[/TD]
[TD]D18/B18[/TD]
[TD]E18/B18[/TD]
[/TR]
[TR]
[TD]Office Furnishings 1[/TD]
[TD]5,8646[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]MIN(C19:E19)[/TD]
[TD]MAX(C19:E19)[/TD]
[TD]AVERAGE(C19:E19)[/TD]
[TD]C19/B19[/TD]
[TD]D19/B19[/TD]
[TD]E19/B19[/TD]
[/TR]
[TR]
[TD]Office Furnishings 2[/TD]
[TD]26,2314[/TD]
[TD]22[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]MIN(C20:E20)[/TD]
[TD]MAX(C20:E20)[/TD]
[TD]AVERAGE(C20:E20)[/TD]
[TD]C20/B20[/TD]
[TD]D20/B20[/TD]
[TD]E20/B20[/TD]
[/TR]
[TR]
[TD]Office Furnishings 3[/TD]
[TD]34,4324[/TD]
[TD]45[/TD]
[TD]57[/TD]
[TD]34[/TD]
[TD]MIN(C21:E21)[/TD]
[TD]MAX(C21:E21)[/TD]
[TD]AVERAGE(C21:E21)[/TD]
[TD]C21/B21[/TD]
[TD]D21/B21[/TD]
[TD]E21/B21[/TD]
[/TR]
[TR]
[TD]Paper 1[/TD]
[TD]5,0504[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD]4[/TD]
[TD]MIN(C22:E22)[/TD]
[TD]MAX(C22:E22)[/TD]
[TD]AVERAGE(C22:E22)[/TD]
[TD]C22/B22[/TD]
[TD]D22/B22[/TD]
[TD]E22/B22[/TD]
[/TR]
[TR]
[TD]Paper 2[/TD]
[TD]5,8764[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]MIN(C23:E23)[/TD]
[TD]MAX(C23:E23)[/TD]
[TD]AVERAGE(C23:E23)[/TD]
[TD]C23/B23[/TD]
[TD]D23/B23[/TD]
[TD]E23/B23[/TD]
[/TR]
[TR]
[TD]Pens & Art Supplies 1[/TD]
[TD]2,88[/TD]
[TD]10[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]MIN(C24:E24)[/TD]
[TD]MAX(C24:E24)[/TD]
[TD]AVERAGE(C24:E24)[/TD]
[TD]C24/B24[/TD]
[TD]D24/B24[/TD]
[TD]E24/B24[/TD]
[/TR]
[TR]
[TD]Pens & Art Supplies 2[/TD]
[TD]4,84[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]MIN(C25:E25)[/TD]
[TD]MAX(C25:E25)[/TD]
[TD]AVERAGE(C25:E25)[/TD]
[TD]C25/B25[/TD]
[TD]D25/B25[/TD]
[TD]E25/B25[/TD]
[/TR]
[TR]
[TD]Rubber Bands 1[/TD]
[TD]2,18[/TD]
[TD]9[/TD]
[TD]2[/TD]
[TD]8[/TD]
[TD]MIN(C26:E26)[/TD]
[TD]MAX(C26:E26)[/TD]
[TD]AVERAGE(C26:E26)[/TD]
[TD]C26/B26[/TD]
[TD]D26/B26[/TD]
[TD]E26/B26[/TD]
[/TR]
[TR]
[TD]Rubber Bands 2[/TD]
[TD]2,62[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]MIN(C27:E27)[/TD]
[TD]MAX(C27:E27)[/TD]
[TD]AVERAGE(C27:E27)[/TD]
[TD]C27/B27[/TD]
[TD]D27/B27[/TD]
[TD]E27/B27[/TD]
[/TR]
[TR]
[TD]Scissors, Rulers and Trimmers 1[/TD]
[TD]3,68[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD]MIN(C28:E28)[/TD]
[TD]MAX(C28:E28)[/TD]
[TD]AVERAGE(C28:E28)[/TD]
[TD]C28/B28[/TD]
[TD]D28/B28[/TD]
[TD]E28/B28[/TD]
[/TR]
[TR]
[TD]Scissors, Rulers and Trimmers 2[/TD]
[TD]12,98[/TD]
[TD]19[/TD]
[TD]15[/TD]
[TD]15[/TD]
[TD]MIN(C29:E29)[/TD]
[TD]MAX(C29:E29)[/TD]
[TD]AVERAGE(C29:E29)[/TD]
[TD]C29/B29[/TD]
[TD]D29/B29[/TD]
[TD]E29/B29[/TD]
[/TR]
[TR]
[TD]Storage & Organization 1[/TD]
[TD]34,76[/TD]
[TD]49[/TD]
[TD]48[/TD]
[TD]34[/TD]
[TD]MIN(C30:E30)[/TD]
[TD]MAX(C30:E30)[/TD]
[TD]AVERAGE(C30:E30)[/TD]
[TD]C30/B30[/TD]
[TD]D30/B30[/TD]
[TD]E30/B30[/TD]
[/TR]
[TR]
[TD]Storage & Organization 2[/TD]
[TD]59,76[/TD]
[TD]55[/TD]
[TD]53[/TD]
[TD]52[/TD]
[TD]MIN(C31:E31)[/TD]
[TD]MAX(C31:E31)[/TD]
[TD]AVERAGE(C31:E31)[/TD]
[TD]C31/B31[/TD]
[TD]D31/B31[/TD]
[TD]E31/B31[/TD]
[/TR]
[TR]
[TD]Tables 1[/TD]
[TD]100,8[/TD]
[TD]62[/TD]
[TD]75[/TD]
[TD]69[/TD]
[TD]MIN(C32:E32)[/TD]
[TD]MAX(C32:E32)[/TD]
[TD]AVERAGE(C32:E32)[/TD]
[TD]C32/B32[/TD]
[TD]D32/B32[/TD]
[TD]E32/B32[/TD]
[/TR]
[TR]
[TD]Tables 2[/TD]
[TD]218,75[/TD]
[TD]121[/TD]
[TD]124[/TD]
[TD]140[/TD]
[TD]MIN(C33:E33)[/TD]
[TD]MAX(C33:E33)[/TD]
[TD]AVERAGE(C33:E33)[/TD]
[TD]C33/B33[/TD]
[TD]D33/B33[/TD]
[TD]E33/B33[/TD]
[/TR]
[TR]
[TD]Telephones and Communication 1[/TD]
[TD]20,99[/TD]
[TD]21[/TD]
[TD]30[/TD]
[TD]29[/TD]
[TD]MIN(C34:E34)[/TD]
[TD]MAX(C34:E34)[/TD]
[TD]AVERAGE(C34:E34)[/TD]
[TD]C34/B34[/TD]
[TD]D34/B34[/TD]
[TD]E34/B34[/TD]
[/TR]
[TR]
[TD]Telephones and Communication 2[/TD]
[TD]65,99[/TD]
[TD]90[/TD]
[TD]70[/TD]
[TD]91[/TD]
[TD]MIN(C35:E35)[/TD]
[TD]MAX(C35:E35)[/TD]
[TD]AVERAGE(C35:E35)[/TD]
[TD]C35/B35[/TD]
[TD]D35/B35[/TD]
[TD]E35/B35[/TD]
[/TR]
[TR]
[TD]Telephones and Communication 3[/TD]
[TD]65,99[/TD]
[TD]77[/TD]
[TD]74[/TD]
[TD]74[/TD]
[TD]MIN(C36:E36)[/TD]
[TD]MAX(C36:E36)[/TD]
[TD]AVERAGE(C36:E36)[/TD]
[TD]C36/B36[/TD]
[TD]D36/B36[/TD]
[TD]E36/B36[/TD]
[/TR]
</tbody>[/TABLE]
a,b,c,d,e pivot table colums.
f,g,h,ı,j,k my formula columns.(sample columns)
can i add my formula columns with vba "calculation field add"?
i wish to turn my formula colums to pivot table calculation field(sample colums => calculation field with vba)
my sample data is down
thx
[TABLE="width: 1420"]
<tbody>[TR]
[TD]Sub-Category 2[/TD]
[TD]base price[/TD]
[TD]Average x custumer price[/TD]
[TD]Average y custumer price[/TD]
[TD]Average z customer price[/TD]
[TD]sample col1[/TD]
[TD]sample col 2[/TD]
[TD]sample col3[/TD]
[TD]sample col4[/TD]
[TD]sample col5[/TD]
[TD]sample col 6[/TD]
[/TR]
[TR]
[TD]Appliances 1[/TD]
[TD]21,78[/TD]
[TD]29[/TD]
[TD]22[/TD]
[TD]30[/TD]
[TD]MIN(C2:E2)[/TD]
[TD]MAX(C2:E2)[/TD]
[TD]AVERAGE(C2:E2)[/TD]
[TD]C2/B2[/TD]
[TD]D2/B2[/TD]
[TD]E2/B2[/TD]
[/TR]
[TR]
[TD]Appliances 2[/TD]
[TD]21,78[/TD]
[TD]29[/TD]
[TD]29[/TD]
[TD]25[/TD]
[TD]MIN(C3:E3)[/TD]
[TD]MAX(C3:E3)[/TD]
[TD]AVERAGE(C3:E3)[/TD]
[TD]C3/B3[/TD]
[TD]D3/B3[/TD]
[TD]E3/B3[/TD]
[/TR]
[TR]
[TD]Binders and Binder Accessories 1[/TD]
[TD]2,08[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]7[/TD]
[TD]MIN(C4:E4)[/TD]
[TD]MAX(C4:E4)[/TD]
[TD]AVERAGE(C4:E4)[/TD]
[TD]C4/B4[/TD]
[TD]D4/B4[/TD]
[TD]E4/B4[/TD]
[/TR]
[TR]
[TD]Binders and Binder Accessories 2[/TD]
[TD]3,52[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]MIN(C5:E5)[/TD]
[TD]MAX(C5:E5)[/TD]
[TD]AVERAGE(C5:E5)[/TD]
[TD]C5/B5[/TD]
[TD]D5/B5[/TD]
[TD]E5/B5[/TD]
[/TR]
[TR]
[TD]Binders and Binder Accessories 3[/TD]
[TD]5,98[/TD]
[TD]7[/TD]
[TD]6[/TD]
[TD]8[/TD]
[TD]MIN(C6:E6)[/TD]
[TD]MAX(C6:E6)[/TD]
[TD]AVERAGE(C6:E6)[/TD]
[TD]C6/B6[/TD]
[TD]D6/B6[/TD]
[TD]E6/B6[/TD]
[/TR]
[TR]
[TD]Bookcases 1[/TD]
[TD]81,94[/TD]
[TD]65[/TD]
[TD]95[/TD]
[TD]80[/TD]
[TD]MIN(C7:E7)[/TD]
[TD]MAX(C7:E7)[/TD]
[TD]AVERAGE(C7:E7)[/TD]
[TD]C7/B7[/TD]
[TD]D7/B7[/TD]
[TD]E7/B7[/TD]
[/TR]
[TR]
[TD]Bookcases 2[/TD]
[TD]100,98[/TD]
[TD]88[/TD]
[TD]73[/TD]
[TD]70[/TD]
[TD]MIN(C8:E8)[/TD]
[TD]MAX(C8:E8)[/TD]
[TD]AVERAGE(C8:E8)[/TD]
[TD]C8/B8[/TD]
[TD]D8/B8[/TD]
[TD]E8/B8[/TD]
[/TR]
[TR]
[TD]Chairs & Chairmats 1[/TD]
[TD]120,98[/TD]
[TD]125[/TD]
[TD]147[/TD]
[TD]137[/TD]
[TD]MIN(C9:E9)[/TD]
[TD]MAX(C9:E9)[/TD]
[TD]AVERAGE(C9:E9)[/TD]
[TD]C9/B9[/TD]
[TD]D9/B9[/TD]
[TD]E9/B9[/TD]
[/TR]
[TR]
[TD]Chairs & Chairmats 2[/TD]
[TD]122,99[/TD]
[TD]163[/TD]
[TD]210[/TD]
[TD]196[/TD]
[TD]MIN(C10:E10)[/TD]
[TD]MAX(C10:E10)[/TD]
[TD]AVERAGE(C10:E10)[/TD]
[TD]C10/B10[/TD]
[TD]D10/B10[/TD]
[TD]E10/B10[/TD]
[/TR]
[TR]
[TD]Computer Peripherals 1[/TD]
[TD]30,98[/TD]
[TD]29[/TD]
[TD]28[/TD]
[TD]30[/TD]
[TD]MIN(C11:E11)[/TD]
[TD]MAX(C11:E11)[/TD]
[TD]AVERAGE(C11:E11)[/TD]
[TD]C11/B11[/TD]
[TD]D11/B11[/TD]
[TD]E11/B11[/TD]
[/TR]
[TR]
[TD]Computer Peripherals 2[/TD]
[TD]39,48[/TD]
[TD]52[/TD]
[TD]50[/TD]
[TD]40[/TD]
[TD]MIN(C12:E12)[/TD]
[TD]MAX(C12:E12)[/TD]
[TD]AVERAGE(C12:E12)[/TD]
[TD]C12/B12[/TD]
[TD]D12/B12[/TD]
[TD]E12/B12[/TD]
[/TR]
[TR]
[TD]Computer Peripherals 3[/TD]
[TD]49,99[/TD]
[TD]38[/TD]
[TD]39[/TD]
[TD]34[/TD]
[TD]MIN(C13:E13)[/TD]
[TD]MAX(C13:E13)[/TD]
[TD]AVERAGE(C13:E13)[/TD]
[TD]C13/B13[/TD]
[TD]D13/B13[/TD]
[TD]E13/B13[/TD]
[/TR]
[TR]
[TD]Envelopes 1[/TD]
[TD]4,48[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]MIN(C14:E14)[/TD]
[TD]MAX(C14:E14)[/TD]
[TD]AVERAGE(C14:E14)[/TD]
[TD]C14/B14[/TD]
[TD]D14/B14[/TD]
[TD]E14/B14[/TD]
[/TR]
[TR]
[TD]Envelopes 2[/TD]
[TD]5,58[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]8[/TD]
[TD]MIN(C15:E15)[/TD]
[TD]MAX(C15:E15)[/TD]
[TD]AVERAGE(C15:E15)[/TD]
[TD]C15/B15[/TD]
[TD]D15/B15[/TD]
[TD]E15/B15[/TD]
[/TR]
[TR]
[TD]Envelopes 3[/TD]
[TD]5,68[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]4[/TD]
[TD]MIN(C16:E16)[/TD]
[TD]MAX(C16:E16)[/TD]
[TD]AVERAGE(C16:E16)[/TD]
[TD]C16/B16[/TD]
[TD]D16/B16[/TD]
[TD]E16/B16[/TD]
[/TR]
[TR]
[TD]Labels 1[/TD]
[TD]2,88[/TD]
[TD]8[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]MIN(C17:E17)[/TD]
[TD]MAX(C17:E17)[/TD]
[TD]AVERAGE(C17:E17)[/TD]
[TD]C17/B17[/TD]
[TD]D17/B17[/TD]
[TD]E17/B17[/TD]
[/TR]
[TR]
[TD]Labels 2[/TD]
[TD]3,69[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]MIN(C18:E18)[/TD]
[TD]MAX(C18:E18)[/TD]
[TD]AVERAGE(C18:E18)[/TD]
[TD]C18/B18[/TD]
[TD]D18/B18[/TD]
[TD]E18/B18[/TD]
[/TR]
[TR]
[TD]Office Furnishings 1[/TD]
[TD]5,8646[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]MIN(C19:E19)[/TD]
[TD]MAX(C19:E19)[/TD]
[TD]AVERAGE(C19:E19)[/TD]
[TD]C19/B19[/TD]
[TD]D19/B19[/TD]
[TD]E19/B19[/TD]
[/TR]
[TR]
[TD]Office Furnishings 2[/TD]
[TD]26,2314[/TD]
[TD]22[/TD]
[TD]25[/TD]
[TD]27[/TD]
[TD]MIN(C20:E20)[/TD]
[TD]MAX(C20:E20)[/TD]
[TD]AVERAGE(C20:E20)[/TD]
[TD]C20/B20[/TD]
[TD]D20/B20[/TD]
[TD]E20/B20[/TD]
[/TR]
[TR]
[TD]Office Furnishings 3[/TD]
[TD]34,4324[/TD]
[TD]45[/TD]
[TD]57[/TD]
[TD]34[/TD]
[TD]MIN(C21:E21)[/TD]
[TD]MAX(C21:E21)[/TD]
[TD]AVERAGE(C21:E21)[/TD]
[TD]C21/B21[/TD]
[TD]D21/B21[/TD]
[TD]E21/B21[/TD]
[/TR]
[TR]
[TD]Paper 1[/TD]
[TD]5,0504[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD]4[/TD]
[TD]MIN(C22:E22)[/TD]
[TD]MAX(C22:E22)[/TD]
[TD]AVERAGE(C22:E22)[/TD]
[TD]C22/B22[/TD]
[TD]D22/B22[/TD]
[TD]E22/B22[/TD]
[/TR]
[TR]
[TD]Paper 2[/TD]
[TD]5,8764[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]MIN(C23:E23)[/TD]
[TD]MAX(C23:E23)[/TD]
[TD]AVERAGE(C23:E23)[/TD]
[TD]C23/B23[/TD]
[TD]D23/B23[/TD]
[TD]E23/B23[/TD]
[/TR]
[TR]
[TD]Pens & Art Supplies 1[/TD]
[TD]2,88[/TD]
[TD]10[/TD]
[TD]7[/TD]
[TD]3[/TD]
[TD]MIN(C24:E24)[/TD]
[TD]MAX(C24:E24)[/TD]
[TD]AVERAGE(C24:E24)[/TD]
[TD]C24/B24[/TD]
[TD]D24/B24[/TD]
[TD]E24/B24[/TD]
[/TR]
[TR]
[TD]Pens & Art Supplies 2[/TD]
[TD]4,84[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]MIN(C25:E25)[/TD]
[TD]MAX(C25:E25)[/TD]
[TD]AVERAGE(C25:E25)[/TD]
[TD]C25/B25[/TD]
[TD]D25/B25[/TD]
[TD]E25/B25[/TD]
[/TR]
[TR]
[TD]Rubber Bands 1[/TD]
[TD]2,18[/TD]
[TD]9[/TD]
[TD]2[/TD]
[TD]8[/TD]
[TD]MIN(C26:E26)[/TD]
[TD]MAX(C26:E26)[/TD]
[TD]AVERAGE(C26:E26)[/TD]
[TD]C26/B26[/TD]
[TD]D26/B26[/TD]
[TD]E26/B26[/TD]
[/TR]
[TR]
[TD]Rubber Bands 2[/TD]
[TD]2,62[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]MIN(C27:E27)[/TD]
[TD]MAX(C27:E27)[/TD]
[TD]AVERAGE(C27:E27)[/TD]
[TD]C27/B27[/TD]
[TD]D27/B27[/TD]
[TD]E27/B27[/TD]
[/TR]
[TR]
[TD]Scissors, Rulers and Trimmers 1[/TD]
[TD]3,68[/TD]
[TD]8[/TD]
[TD]10[/TD]
[TD]8[/TD]
[TD]MIN(C28:E28)[/TD]
[TD]MAX(C28:E28)[/TD]
[TD]AVERAGE(C28:E28)[/TD]
[TD]C28/B28[/TD]
[TD]D28/B28[/TD]
[TD]E28/B28[/TD]
[/TR]
[TR]
[TD]Scissors, Rulers and Trimmers 2[/TD]
[TD]12,98[/TD]
[TD]19[/TD]
[TD]15[/TD]
[TD]15[/TD]
[TD]MIN(C29:E29)[/TD]
[TD]MAX(C29:E29)[/TD]
[TD]AVERAGE(C29:E29)[/TD]
[TD]C29/B29[/TD]
[TD]D29/B29[/TD]
[TD]E29/B29[/TD]
[/TR]
[TR]
[TD]Storage & Organization 1[/TD]
[TD]34,76[/TD]
[TD]49[/TD]
[TD]48[/TD]
[TD]34[/TD]
[TD]MIN(C30:E30)[/TD]
[TD]MAX(C30:E30)[/TD]
[TD]AVERAGE(C30:E30)[/TD]
[TD]C30/B30[/TD]
[TD]D30/B30[/TD]
[TD]E30/B30[/TD]
[/TR]
[TR]
[TD]Storage & Organization 2[/TD]
[TD]59,76[/TD]
[TD]55[/TD]
[TD]53[/TD]
[TD]52[/TD]
[TD]MIN(C31:E31)[/TD]
[TD]MAX(C31:E31)[/TD]
[TD]AVERAGE(C31:E31)[/TD]
[TD]C31/B31[/TD]
[TD]D31/B31[/TD]
[TD]E31/B31[/TD]
[/TR]
[TR]
[TD]Tables 1[/TD]
[TD]100,8[/TD]
[TD]62[/TD]
[TD]75[/TD]
[TD]69[/TD]
[TD]MIN(C32:E32)[/TD]
[TD]MAX(C32:E32)[/TD]
[TD]AVERAGE(C32:E32)[/TD]
[TD]C32/B32[/TD]
[TD]D32/B32[/TD]
[TD]E32/B32[/TD]
[/TR]
[TR]
[TD]Tables 2[/TD]
[TD]218,75[/TD]
[TD]121[/TD]
[TD]124[/TD]
[TD]140[/TD]
[TD]MIN(C33:E33)[/TD]
[TD]MAX(C33:E33)[/TD]
[TD]AVERAGE(C33:E33)[/TD]
[TD]C33/B33[/TD]
[TD]D33/B33[/TD]
[TD]E33/B33[/TD]
[/TR]
[TR]
[TD]Telephones and Communication 1[/TD]
[TD]20,99[/TD]
[TD]21[/TD]
[TD]30[/TD]
[TD]29[/TD]
[TD]MIN(C34:E34)[/TD]
[TD]MAX(C34:E34)[/TD]
[TD]AVERAGE(C34:E34)[/TD]
[TD]C34/B34[/TD]
[TD]D34/B34[/TD]
[TD]E34/B34[/TD]
[/TR]
[TR]
[TD]Telephones and Communication 2[/TD]
[TD]65,99[/TD]
[TD]90[/TD]
[TD]70[/TD]
[TD]91[/TD]
[TD]MIN(C35:E35)[/TD]
[TD]MAX(C35:E35)[/TD]
[TD]AVERAGE(C35:E35)[/TD]
[TD]C35/B35[/TD]
[TD]D35/B35[/TD]
[TD]E35/B35[/TD]
[/TR]
[TR]
[TD]Telephones and Communication 3[/TD]
[TD]65,99[/TD]
[TD]77[/TD]
[TD]74[/TD]
[TD]74[/TD]
[TD]MIN(C36:E36)[/TD]
[TD]MAX(C36:E36)[/TD]
[TD]AVERAGE(C36:E36)[/TD]
[TD]C36/B36[/TD]
[TD]D36/B36[/TD]
[TD]E36/B36[/TD]
[/TR]
</tbody>[/TABLE]
