{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Simple Invoice","Sheet1"],"not_rendered":{"images":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Simple Invoice","index":0,"n_rows":54,"n_cols":8,"rows_kept":54,"merged":[[2,1,2,7],[7,5,7,7],[8,5,8,7],[9,5,9,7],[10,5,10,6],[44,2,44,7],[45,1,45,7],[46,1,46,7],[47,1,47,7],[48,1,48,3],[49,1,49,2],[50,1,50,2],[51,1,51,7],[52,1,52,5],[52,6,52,7],[53,2,53,4]]}
[]
[null,"Mini Map-Makers Global CIC"]
[null,"Order Form Collins Atlases and Books"]
[null,"Please complete"]
[null,"Contact Name"]
[null,"School Name"]
[null,"Street Address"]
[null,"City,",{"$nulls":3},"Invoice number as follows:"]
[null,"County",{"$nulls":3},"School Name and Date in 6 number format 120322"]
[null,"Postcode",{"$nulls":3}," eg Delbany120322"]
[null,"Phone",{"$nulls":3},"Invoice No:"]
[null,"E-mail",null,"add in req volumes",{"$nulls":3},{"$f":"TODAY()","v":"2023-06-26"}]
[null,"Visit https://harpercollins.co.uk/  for more details on books"]
[null,"Book Title","ISBN","Volume","RRP","Discount","Discounted Rate","AMOUNT"]
[null,"PRIMARY KS1 and KS2 BOOKS"]
[null,"First Atlas (4+)","978-0-00-848593-1",null,{"v":5.99,"d":"£5.99"},{"v":0.4,"d":"40%"},{"v":3.59,"d":"£3.59"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Primary Atlas (7-11)","978-0-00-848594-8",null,{"v":7.99,"d":"£7.99"},{"v":0.4,"d":"40%"},{"v":4.79,"d":"£4.79"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Junior Atlas (8+)","978-0-00-855646-4",null,{"v":8.99,"d":"£8.99"},{"v":0.4,"d":"40%"},{"v":5.39,"d":"£5.39"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"WORLD AROUND US Collins Primary Geography Pupil Book 1 and 2 (Primary Geography)","978-0-00-756358-6",null,{"v":9.5,"d":"£9.50"},{"v":0.4,"d":"40%"},{"v":5.7,"d":"£5.70"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"WORLD AROUND US Collins Primary Geography Teacher’s Book 1 and 2 (Primary Geography): First edition","978-0-00-756363-0",null,{"v":27,"d":"£27.00"},{"v":0.4,"d":"40%"},{"v":16.2,"d":"£16.20"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"INVESTIGATION Collins Primary Geography Pupil Book 3 (Primary Geography)","978-0-00-756359-3",null,{"v":9.5,"d":"£9.50"},{"v":0.4,"d":"40%"},{"v":5.7,"d":"£5.70"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"INVESTIGATION Collins Primary Geography Teacher’s Book 3 (Primary Geography): First edition","978-0-00-756364-7",null,{"v":27,"d":"£27.00"},{"v":0.4,"d":"40%"},{"v":16.2,"d":"£16.20"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"MOVEMENT Collins Primary Geography Pupil Book 4 (Primary Geography)","978-0-00-756360-9",null,{"v":9.5,"d":"£9.50"},{"v":0.4,"d":"40%"},{"v":5.7,"d":"£5.70"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"MOVEMENT Collins Primary Geography Teacher’s Book 4 (Primary Geography)","978-0-00-756365-4",null,{"v":27,"d":"£27.00"},{"v":0.4,"d":"40%"},{"v":16.2,"d":"£16.20"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"CHANGE Collins Primary Geography Pupil Book 5 (Primary Geography)","978-0-00-756361-6",null,{"v":9.5,"d":"£9.50"},{"v":0.4,"d":"40%"},{"v":5.7,"d":"£5.70"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"CHANGE Collins Primary Geography Teacher’s Book 5 (Primary Geography)","978-0-00-756366-1",null,{"v":27,"d":"£27.00"},{"v":0.4,"d":"40%"},{"v":16.2,"d":"£16.20"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"ISSUES Collins Primary Geography Pupil Book 6 (Primary Geography)","978-0-00-756362-3",null,{"v":9.5,"d":"£9.50"},{"v":0.4,"d":"40%"},{"v":5.7,"d":"£5.70"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"ISSUES Collins Primary Geography Teacher’s Book 6 (Primary Geography)","978-0-00-756367-8",null,{"v":27,"d":"£27.00"},{"v":0.4,"d":"40%"},{"v":16.2,"d":"£16.20"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"UK in Maps: Explore the UK – past, present and future (Collins Primary Atlases): Third edition","978-0-00-855648-8",null,{"v":7.99,"d":"£7.99"},{"v":0.4,"d":"40%"},{"v":4.79,"d":"£4.79"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"World in Maps: Explore the world – past, present and future (Collins Primary Atlases): Third edition","978-0-00-855647-1",null,{"v":7.99,"d":"£7.99"},{"v":0.4,"d":"40%"},{"v":4.79,"d":"£4.79"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"World in Maps Activities (Collins Primary Atlases): First edition","978-0-00-756371-5",null,{"v":39.99,"d":"£39.99"},{"v":0.4,"d":"40%"},{"v":23.99,"d":"£23.99"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Collins Children’s Picture Atlas: Ideal way for kids to learn more about the world: Third edition","978-0-00-832032-4",null,{"v":7.99,"d":"£7.99"},{"v":0.4,"d":"40%"},{"v":4.79,"d":"£4.79"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[]
[null,"SECONDARY KS3+ BOOKS"]
[null,"School Atlas (11-14)","978-0-00-848595-5",null,{"v":9.99,"d":"£9.99"},{"v":0.4,"d":"40%"},{"v":5.99,"d":"£5.99"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Student Atlas (14-16)","978-0-00-843024-5",null,{"v":10.99,"d":"£10.99"},{"v":0.4,"d":"40%"},{"v":6.59,"d":"£6.59"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Collins Key Stage 3 Geography – Geographical Enquiry Student Book 1","978-0-00-741103-0",null,{"v":17.99,"d":"£17.99"},{"v":0.4,"d":"40%"},{"v":10.79,"d":"£10.79"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Collins Key Stage 3 Geography – Geographical Enquiry Teacher's Book 1","978-0-00-741115-3",null,{"v":70,"d":"£70.00"},{"v":0.4,"d":"40%"},{"v":42,"d":"£42.00"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Collins Key Stage 3 Geography – Geographical Enquiry Student Book 2","978-0-00-741116-0",null,{"v":17.99,"d":"£17.99"},{"v":0.4,"d":"40%"},{"v":10.79,"d":"£10.79"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Collins Key Stage 3 Geography – Geographical Enquiry Teacher's Book 2","978-0-00-741117-7",null,{"v":70,"d":"£70.00"},{"v":0.4,"d":"40%"},{"v":42,"d":"£42.00"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Collins Key Stage 3 Geography – Geographical Enquiry Student Book 3","978-0-00-741118-4",null,{"v":17.99,"d":"£17.99"},{"v":0.4,"d":"40%"},{"v":10.79,"d":"£10.79"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,"Collins Key Stage 3 Geography – Geographical Enquiry Teacher's Book 3","978-0-00-741119-1",null,{"v":70,"d":"£70.00"},{"v":0.4,"d":"40%"},{"v":42,"d":"£42.00"},{"$f":"Invoice[[#This Row],[Volume]]*Invoice[[#This Row],[Discounted Rate]]","v":{"v":0,"d":"£0.00"}}]
[null,null,"Total number:",{"$f":"SUM(Invoice[Volume])","v":0},null,"BACS","Total to pay",{"$f":"SUM(H16:H42)","v":{"v":0,"d":"£0.00"}}]
[null,null,"Total Number:",{"$f":"SUM(Invoice[Volume])","v":0},null,"Credit card","Total to pay",{"$f":"SUM(H16:H42)*0.04+(SUM(H16:H42))","v":{"v":0,"d":"£0.00"}}]
[null,null,"Please DELETE/CROSS OUT the Method of payment NOT being used before sending "]
[null,"THANK YOU FOR YOUR SUPPORT!"]
[null,"#GettingChildrenMapping"]
[null,"Please Pay (with your Invoice Number above as Reference)"]
[null,"Mini Map-Makers Global CIC"]
[null,"Sort Code: 60-01-16"]
[null,"Account Number: 45347417"]
[null,"Once payment is received - your order is placed and we will inform you of delivery!"]
[null,"Mini Map-Makers Global CIC, The Old Woodyard, 39 Bedford Road, Little Houghton, NN7 1AB",{"$nulls":4},"Registered England: 12894493 "]
[null,"www.minimapmakers.com","alice@minimapmakers.com",{"$nulls":3},"Tel: 07470067531"]

{"sheet":"Sheet1","index":1,"n_rows":3,"n_cols":1,"rows_kept":3}
["Collins Primary Geography Pupil Book 1 and 2 (Primary Geography)"]
["Primary Geography - Collins Primary Geography Pupil Book 1 and 2 (Primary Geography): First edition"]
["Primary Geography - Collins Primary Geography Pupil Book 3 (Primary Geography): First edition"]