SPSW - Coursework from BPP - Kitchens
Adele69
Registered Posts: 320
For those who have done the Spreadsheet Software module with BPP books and course material. I'm struggling through the question on Kitchens, as part of the additional coursework. We got a handout with the questions, the files and a printout of answers. The printout of the answer has no formulas, so no real help in getting the answer.
The Kitchens workboot comprises four worksheets: Order Details, Types, Prices and Data. The last can be ignored as this was copied into prices as part of the earlier tasks. In the Order Details sheet there are two tables. The first table has a cell C5 for Style (these are listed in types: 2 = White, 3 = Pine, 4 = Beech, 5 = Oak, 6 = Teak). The second table has several columns for Unit, Description, Quantity, Price, Total Price. Unit and Description are defined, the others are calculated from lookups and sums.
The Price is based on the value in Prices, and the particular column is based on Type, so a lookup within a lookup, but I'm getting a value error presumably because one lookup is showing text not number. This was my formula attempt which gave me an error.
I have an exam on Tuesday. Last week was college half term (same holidays as schools - really inconvenient). I was fairly confident after doing the AAT practice assessment before looking at this, and without the answers my confidence has evaporated.
image of Kitchens worksheets on Photobucket
The Kitchens workboot comprises four worksheets: Order Details, Types, Prices and Data. The last can be ignored as this was copied into prices as part of the earlier tasks. In the Order Details sheet there are two tables. The first table has a cell C5 for Style (these are listed in types: 2 = White, 3 = Pine, 4 = Beech, 5 = Oak, 6 = Teak). The second table has several columns for Unit, Description, Quantity, Price, Total Price. Unit and Description are defined, the others are calculated from lookups and sums.
The Price is based on the value in Prices, and the particular column is based on Type, so a lookup within a lookup, but I'm getting a value error presumably because one lookup is showing text not number. This was my formula attempt which gave me an error.
=VLOOKUP(B8,Prices!A3:H36,(VLOOKUP('Order Details'!$C$5,Types!$A$3:$B$8,2,FALSE)),FALSE)
I have an exam on Tuesday. Last week was college half term (same holidays as schools - really inconvenient). I was fairly confident after doing the AAT practice assessment before looking at this, and without the answers my confidence has evaporated.
image of Kitchens worksheets on Photobucket
0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 319 NEW! Qualifications 2022
- 157 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 92 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 274 Tax
- 136 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership