We are selling windows and doors. And to support that we need two small functions.
First try to look at the attached two Excel files.
return boolean GetApprovelForSize (string model, int width,? int height)
This function must look if the size is aproved for production.
True = the price is found
False = the price is not found
return int GetPriceFromExcel(string model, int width,? int height)
The function must based on model, height and width find the price from an Excel sheet.
I will also need a prototype for the test. A webpage width? 4 fields? (model, height, width, radio button for function 1 (name: Get? a price)? or function 2(Name: get size approvel)? and a result after submit.