Transfering data over multiple Workbooks; Excel 2010

Da3d4lu5

New Member
Joined
Oct 2, 2013
Messages
2
Hi Guys!,
This is my First post so please be Gentle!

Ok im setting up a new 'database' at work for customer orders and model specs

Ive got the following excel spreadsheets: Samples below
AutoCAD - Sheets: AutoCAD - Data Table for AutoCAD
Customer order - Sheets; customer order & summary - What the dealer will recieve to do customer orders and send back to the Manufacturer (us)
Colours and variables - Sheets; Colours & Variables - Inputs for various sheets
MSMF (Model Specifications Master File) - Sheets: Master Template - Has model and Size eg Camper 19', Camper 21'
PDF Master File - Excel Spreadsheet its sheets for each model and size, that will be used to output model specification pdfs

What needs to happen: FILES UNDERLINED

The MSMF File has all our model specs which can be changed from a drop down box using values from Variables sheet in Colours & Variables, this is essential as items are changed about once a year eg; from 2 annex lights to 3 and stops stupid inputs if typed out eg; 7 annex lights.


The Dealer will be sent the above files in folders which will be locked except for Customer order.
When the dealer opens Customer order it will prompt for a customer name and file directory and save a new file with the surname as the file and open it.
The Dealer will type out info like dealership, dealer & select a model from a drop down list and the 'Model Specifications Column' (C) will input the data from the corresponding MSMF file and lock the data from being modified. Some of the options like layout & upholstery colour need to be selected by dropdown boxes by the dealer using column C & D, using the Colours & Variables file.
If the customer wants to change specs from default they will type it in column D. Column E & F are for customer specific items (ie; where they want a double power point moved to).
Column G is for ammendments and needs to be locked from any data until the manufacturer has received the initial order and processed the information (As combinations that don't work can't be shown, its a VERY long logic test - trust me its easier to do it by person) and if the order is accpeted the information in column D,E & F will be locked and G column will be unlocked and the file sent to the dealer.
If the Dealer enters data in the Ammendment column G excel automatically saves it as SURNAME-AMMENDMENT when the file is saved and keeps the original in the state is was before being opened.

Once the Customer file is on our server (In its own folder) we require the following
The AutoCAD file will self populate the required data from the Customer order. The drawing guys will link this file to their AutoCAD drawing

I also need to link the PDF Master File to MSMF for its cell values.

If the Colours and Variables is changed, all other excel files update
If the MSMF is changed all corresponding excel files change

Is it possible to setup a system where the Customer file can be shared between dealer and Manufacturer?
I'm concerned about the linked sheets when the Customer Order is sent from the Dealer to the Manufacturer

I've tried linking through VBA but my programming are rusty as.

Below is pretty much all the info in the various i may have forgotten afew if so sorry.

Thanks in advance for any replies!

Regards,
Da3d4lu5

AutoCAD
CHASSIS
SOFT FURNISHINGS
TYPEWATER TANKSSEAT BACKS
COUPLINGGAS CYCLINDERSSEAT BASES
CHASSIS RAISER
A' FRAME MESH BASKETUPHOSTERY TYPE
GALVANIZED UNDER LINING
WHEELS
TYRES
SUSPENSION TYPE
BUMPER BAR
ELECTRICAL
COLOURS
ANNEX LIGHTBATTERY & CHARGERFURNITURE
WATER LEVEL GUAGEWALLS
TOW PLUGOCH INSERT
ANDERSON PLUGPICTURE FRAME
WIRING FOR SOLARCURTAINS
SOLAR PANELPELMETS
INTERNAL LIGHTINGBENCHTOP
ANTENNAEDGE
TVSPLASHBACK
LINO
OUTSIDE
SHELL
ALUMINIUMDECALS
ROOF HEIGHTWINDOWSAWNING
BOOTDOORSMISCELLANEOUS
INSULATIONCHECKERPLATE
ROOF HATCHVINYL
AIR CONGLOSS SIDES
AWNINGJ MOULD
OUTSIDE CLADDING
CHASSIS
FURNITURE
PLUMBING
COOKINGMIXER TAP
MICROWAVELOCKABLE WATER FILLERS
RADIOKITCHEN SINK
SPEAKERSHWS
FRIDGE
HANDLES

<tbody>
</tbody>




ORDER FORM

DATE
DEALER
CUSTOMER
MODELDREAMRUNNER
SHOW SPECIAL
CONFIGURATIONMODEL SPECIFICATIONSADDITIONAL OPTIONCUSTOMER SPECIFIED #1CUSTOMER SPECIFIED #2AMMENDMENT
FRONT
BEDROOM STYLEN.S
BED
KITCHENDoor Side
SEATINGOffside
ENSUITE
BUNKSN/A
DOOR POSITION
X-COUNTRY FEATURESNo
PLATINIUM REARNo
DREAMRUNNER REARNo
INTERNAL COLOURS
FURNITURE
WALLS
BLINDSN/A
CURTAINS
BENCHTOPLAMINEX_DIAMOND_GLOSSCOLOUR
EDGES
SPLASHBACKBRANDCOLOUR
LINO
CARPETN/A
UPHOLSTERY
UPHOLSTERY BRAND
SEAT COLOUR
BACKS COLOUR
UPHOLSTERY TYPEPillow
22" SEAT BASENo
FOOTRESTNo
HIGH BACKNo
LOOSE CUSHION TO RETURNNo
WALL PADDINGNo
DIVIDING CURTAINNo
CRASH PAD COLOURMatch to Seat Base
DOONA COLOURNone
MAGAZINE RACKNo
EXTRA MATERIALNo
CUSTOMER REQUEST #1----
CUSTOMER REQUEST #2----
EXTERNAL COLOURS
J MOULDBlack
OUTSIDE CLADDINGWhite
SPATSBlack
DECALSStandard
AWNINGCharcoal
CENTRE SUPPORTNo
OFFSIDE SAIL TRACKNo
CHECKER PLATESides only
GLOSS SIDESNo
VINYLTo Top of BootBlack
CHASSIS DETAILS
TYPESupagalSupagal
6" A FRAME & CHASSISNoNo
COUPLINGStandardStandard
CHASSIS RAISER2"
A FRAME MESH BASKETNo
TAP ON A FRAMEYes - Door Side
GALVANIZED UNDERLININGYes
PULL OUT STEPNone
WHEELS15 x 245
TYRES8 Ply LT
BRAKES12" Electric
SUSPENSION TYPEStraight Axle
AL-KO ESCNo
BUMPER BARLoop 3 Arm
BUMPER BAR ACCESSORIESNone
WATER TANK No. & SIZE2 x 95 lt
WATER TANK POSITIONStandard
GAS BOTTLES2 x 9kg
OUTRIGGER ACCESSORIESToolbox
STONE SHIELDNo
MAX ATMN/A
CUSTOMER REQUEST #3---
CUSTOMER REQUEST #4---
EXTERNAL ELECTRICS
EXTERNAL 240v POWER POINT1 (Standard)
ADDITIONAL EXTERNAL 240v POWER POINT - DOOR SIDENone
ADDITIONAL EXTERNAL 240v POWER POINT - OFF SIDENone
EXTERNAL 12v POWER POINT1 (Standard)
ADDITIONAL EXTERNAL 12v POWER POINT - DOOR SIDENone
ADDITIONAL EXTERNAL 12v POWER POINT - OFF SIDENone
EXTERNAL T.V POINTStandard
ADDITIONAL EXTERNAL T.V POINTNone
T.V HUTCHStandard
ANNEX LIGHTS1
ADDITIONAL ANNEX LIGHTS - DOOR SIDENone
ADDITIONAL ANNEX LIGHTS - OFF SIDENone
SECURITY DOOR LIGHTBargman Assist Handle - Light
ANDERSON PLUGx 1
TOW PLUG7 Pin Flat
REVERSING CAMERANo
ADDITIONAL BOOT ELECTRICS
CUSTOMER REQUEST #5----
CUSTOMER REQUEST #6----
INTERNAL ELECTRICS
WIRING FOR SOLARNo
SOLAR PANEL1 x 120w
SOLAR CONTROLLERStandard
WATER LEVEL GUAGEYes - in Overhead Cupboard
NUMBER OF BATTERIESNone
BATTERY TYPEStandard
BATTERY POSITIONStandard
BATTERY CHARGERStandard
BATTERY CHARGER POSITIONStandard
BATTERY MONITORStandard
INVERTERNo
EXPLORER PLUGNo
ADDITIONAL BEDROOM ELECTRICS----
ADDITIONAL KITCHEN ELECTRICS----
ADDITIONAL DINING ELECTRICS----
ADDITIONAL ENSUTIE ELECTRICS----
ADDITIONAL BUNK ELECTRICS----
RADIOStandard
INTERNAL SPEAKERSStandard (4) - Starlite (2)
EXTERNAL SPEAKERSStandard (2)
T.VStandard
ADDITIONAL T.VNo
ADDITIONAL T.V BRACKETNo
ANTENNAWinegard
EXTERNAL FEATURES
SECURITY DOORStandard 1750
BBQWebber Q with Stand
GAS BAYONETNo
PICNIC TABLENo
BIKE RACK ON REAR WALLNo
AUXLLIARY SHOWERNo
MAGIC EYENo
CHROME GRAB HANDLES FRONTStandard 300mm
CHROME GRAB HANDLES REARStandard 900mm
CUSTOMER REQUEST #7----
CUSTOMER REQUEST #8----
INTERNAL FEATURES
AIR CONDITIONINGIBIS
HATCHESDometic Mini Hatch
HANDLESStandard Push Button
DOORSURBAN_REPUBLICCOLOUR
WINDOWSDOMETIC S4
PELMETSNo
****TAIL RAILSNo
ASSIST HANDLEHinged Side
HOT WATER SERVICESuburban
CUSTOMER REQUEST #9----
CUSTOMER REQUEST #10----
BEDROOM
BED SIZE0
INNERSPRINGYes
PIILOWTOPNo
BED BOLSTERNo
BED HEAD CUPBOARD (FRONT WINDOW DELETED)No
ROBE STYLE0
MIRRORS ON ROBE DOORSYes
SHELVES IN ROBENone
CORNER CABINET DOOR SIDEStandard
CORNER CABINET OFFSIDEStandard
DRAWER UNDER BEDYes - x1
HEATERNo
HEATER OUTLET POSITONNone
DIVIDING CURTAINNo
CONCERTINA DOORNo
ADDITIONAL BEDROOM ELECTRICS----
CUSTOMER REQUEST #11----
CUSTOMER REQUEST #12----
KITCHEN
TYPE0
OVER HEADStandard
SINK TYPERound
SINK COVERNo
OVENSwift - Full Oven
MICROWAVESwift
PULL-OUT PANTRYYes
3 DOOR PANTRYNo
WINE COOLERNo
ADDITIONAL KITCHEN ELECTRICS----
CUSTOMER REQUEST #13----
CUSTOMER REQUEST #14----
FRIDGE
TYPERM4601
INSERT COLOURMatching Laminate
OVERHEAD CUPBOARD ACCESSFlap
FULL HEIGHT PANTRYYes
CUSTOMER REQUEST #15----
DINING
SEATING TYPE0
END ACCESS TO UNDER SEATINGDrawer
FOOT RESTNo
SHELVES IN OHCNo
OHC INSERTSTimber
TABLE TYPETri-Fold
TABLE TO BED CONVERSIONNo
HIGH BACKSNo
LOOSE CUSHION TO RETURNNo
WALL PADDINGNo
ADDITIONAL DINING ELECTRICS----
CUSTOMER REQUEST #16----
CUSTOMER REQUEST #17----
ENSUITE
STYLE0
SHAVING CABINETNo
WASHING MACHINEFront Load
BASIN TYPERound
DRAWERS UNDER SINKYes - Left
DOOR UNDER SINKYes - Right
SHOWER SIZEStandard
TOILETStandard
TOILET ROLL HOLDERNo
ADDITIONAL TOWEL RAILNo
HEATED TOWEL RAILNo
LINEN CUPBOARD CONFIGURATIONDoor above & below
SHELVES IN LINEN CUPBOARDNo
LOOSE BATHROOM ACCESSORIESNo
ADDITIONAL ENSUITE ELECTRICS----
CUSTOMER REQUEST #18----
CUSTOMER REQUEST #19----
BUNK
NUMBER OF BUNKSN/A
BED HEADWall End
DVD PLAYERNo
TV CONNECTIONNo
DRAWERS UNDER BEDYes
ALUMINIUM LADDERNo
FRONT LOAD WASHING MACHINE IN ROBENo
SHELVES IN ROBENo
BI-FOLD TOP BUNKNo
LARGE WINDOWNo
WALL PADDINGNo
CONTSATINANo
DIVIDING CURTAINNo
PRIVACY CURTAINNo
EXTERNAL ACCESS LOCKER (2 BUNK ONLY; BESIDE DRAWERS, UNDER BUNK)No
ADDITIONAL ENSUITE ELECTRICS----
CUSTOMER REQUEST #20----
CUSTOMER REQUEST #21----

<tbody>
</tbody>
MSMF


MODELBULLETD-LITEDREAMRUNNERDREAMRUNNER
SIZE15' x 7' TO 15' x 7'6"19'6" x 7'9"14' x 7'9"17'6" x 7'9"
CONFIGURATIONADDITIONAL OPTIONADDITIONAL OPTIONADDITIONAL OPTIONADDITIONAL OPTION
FRONT
BEDROOM STYLE
BED
KITCHEN
SEATING
ENSUITE
BUNKSN/AN/AN/AN/A
DOOR POSITION
X-COUNTRY FEATURESNoNoNoNo
PLATINIUM REARNoNoNoNo
DREAMRUNNER REARNoNoNoNo
INTERNAL COLOURS
FURNITURE
WALLS
BLINDSN/AN/AN/AN/A
CURTAINS
BENCHTOPBRANDBRANDBRANDBRAND
EDGES
SPLASHBACKBRANDBRANDBRANDBRAND
LINO
CARPETN/AN/AN/AN/A
UPHOLSTERY
UPHOLSTERY BRAND
SEAT COLOUR
BACKS COLOUR
UPHOLSTERY TYPEPillowPillowPillowPillow
22" SEAT BASENoNoNoNo
FOOTRESTNoNoNoNo
HIGH BACKNoNoNoNo
LOOSE CUSHION TO RETURNNoNoNoNo
WALL PADDINGNoNoNoNo
DIVIDING CURTAINNoNoNoNo
CRASH PAD COLOURMatch to Seat BaseMatch to Seat BaseMatch to Seat BaseMatch to Seat Base
DOONA COLOURNoneNoneNoneNone
MAGAZINE RACKNoNoNoNo
EXTRA MATERIALNoNoNoNo
CUSTOMER REQUEST #1
CUSTOMER REQUEST #2
EXTERNAL COLOURS
J MOULDBlackBlackBlackBlack
OUTSIDE CLADDINGWhiteWhiteWhiteWhite
SPATSBlackBlackBlackBlack
DECALSStandardStandardStandardStandard
AWNINGCharcoalCharcoalCharcoalCharcoal
CENTRE SUPPORTNoNoNoNo
OFFSIDE SAIL TRACKNoNoNoNo
CHECKER PLATESides onlySides onlySides onlySides only
GLOSS SIDESNoNoNoNo
VINYLTo Top of BootTo Top of BootTo Top of BootTo Top of Boot
CHASSIS DETAILS
TYPESupagalSupagalSupagalSupagal
6" A FRAME & CHASSISNoNoNoNo
COUPLINGStandardStandardStandardStandard
CHASSIS RAISERNoneNoneNoneNone
A FRAME MESH BASKETNoNoNoNo
TAP ON A FRAMEYes - Door SideYes - Door SideYes - Door SideYes - Door Side
GALVANIZED UNDERLININGNoNoNoNo
PULL OUT STEPNoneNoneNoneNone
WHEELS15 x 20515 x 20516 x 26515 x 205
TYRES8 Ply LT8 Ply LT8 Ply LT8 Ply LT
BRAKES10" Electric10" Electric12" Electric10" Electric
SUSPENSION TYPE2" Drop Axle2" Drop AxleStraight Axle2" Drop Axle
AL-KO ESCNoNoNoNo
BUMPER BARStraight 2 ArmStraight 2 ArmStraight 2 ArmStraight 2 Arm
BUMPER BAR ACCESSORIESNoneNoneNoneNone
WATER TANK No. & SIZE1 x 95lt1 x 95lt2 x 95 lt1 x 95lt
WATER TANK POSITIONForwardForwardRearForward
GAS BOTTLES1 x 9kg1 x 9kg2 x 9kg1 x 9kg
OUTRIGGER ACCESSORIESNoneNoneNoneNone
STONE SHIELDNoNoNoNo
MAX ATMN/AN/AN/AN/A
CUSTOMER REQUEST #3
CUSTOMER REQUEST #4
EXTERNAL ELECTRICS
EXTERNAL 240v POWER POINT111 External & 1 in T.V Hutch1
ADDITIONAL EXTERNAL 240v POWER POINT - DOOR SIDENoneNoneNoneNone
ADDITIONAL EXTERNAL 240v POWER POINT - OFF SIDENoneNoneNoneNone
EXTERNAL 12v POWER POINT1 External & 1 in T.V Hutch1 External & 1 in T.V HutchIn T.V Hutch1 External & 1 in T.V Hutch
ADDITIONAL EXTERNAL 12v POWER POINT - DOOR SIDENoneNoneNoneNone
ADDITIONAL EXTERNAL 12v POWER POINT - OFF SIDENoneNoneNoneNone
EXTERNAL T.V POINT1 External & 1 in T.V Hutch1 External & 1 in T.V HutchIn T.V Hutch1 External & 1 in T.V Hutch
ADDITIONAL EXTERNAL T.V POINTNoneNoneNoneNone
T.V HUTCHStandardStandardStandardStandard
ANNEX LIGHTS1111
ADDITIONAL ANNEX LIGHTS - DOOR SIDENoneNoneNoneNone
ADDITIONAL ANNEX LIGHTS - OFF SIDENoneNoneNoneNone
SECURITY DOOR LIGHTBargman Assist Handle - LightBargman Assist Handle - LightBargman Assist Handle - LightBargman Assist Handle - Light
ANDERSON PLUGNoNoNoNo
TOW PLUG
REVERSING CAMERANoNoNoNo
ADDITIONAL BOOT ELECTRICS
CUSTOMER REQUEST #5
CUSTOMER REQUEST #6
INTERNAL ELECTRICS
WIRING FOR SOLARNoNoNoNo
SOLAR PANELNoNoNoNo
SOLAR CONTROLLERNoNoNoNo
WATER LEVEL GUAGEYes - in Overhead CupboardYes - in Overhead CupboardYes - in Overhead CupboardYes - in Overhead Cupboard
NUMBER OF BATTERIES1111
BATTERY TYPEStandardStandardStandardStandard
BATTERY POSITIONBootBootBootBoot
BATTERY CHARGERStandardStandardStandardStandard
BATTERY CHARGER POSITIONBootBootBootBoot
BATTERY MONITORStandardStandardStandardStandard
INVERTERNoNoNoNo
EXPLORER PLUGNoNoNoNo
ADDITIONAL BEDROOM ELECTRICS
ADDITIONAL KITCHEN ELECTRICS
ADDITIONAL DINING ELECTRICS
ADDITIONAL ENSUTIE ELECTRICS
ADDITIONAL BUNK ELECTRICS
RADIOStandard CD PlayerStandard CD/DVD PlayerStandard CD/DVD PlayerStandard
INTERNAL SPEAKERS2242
EXTERNAL SPEAKERSNoneNoneNoneNone
T.VStandardStandardStandardStandard
ADDITIONAL T.VNoNoNoNo
ADDITIONAL T.V BRACKETNoNoNoNo
ANTENNAWinegardWinegardJackWinegard
EXTERNAL FEATURES
SECURITY DOORStandard 1750Standard 1750Standard 1750Standard 1750
BBQNoNoNoNo
GAS BAYONETNoNoNoNo
PICNIC TABLENoNoYesNo
BIKE RACK ON REAR WALLNoNoNoNo
AUXLLIARY SHOWERNoNoYesNo
MAGIC EYENoNoNoNo
CHROME GRAB HANDLES FRONTStandard 300mmStandard 300mmStandard 300mmStandard 300mm
CHROME GRAB HANDLES REARStandard 900mmStandard 900mmStandard 900mmStandard 900mm
CUSTOMER REQUEST #7
CUSTOMER REQUEST #8
INTERNAL FEATURES
AIR CONDITIONINGNoneNoneIBISNone
HATCHESDometic Mini HatchDometic Mini HatchFiamaDometic Mini Hatch
HANDLESStandard Lever LatchStandard Lever LatchStandard Lever LatchStandard Lever Latch
DOORSTIMBERTIMBERTIMBERTIMBER
WINDOWSDOMETIC S4DOMETIC S4DOMETIC Bubble (S4)DOMETIC S4
PELMETSNoNoNoNo
****TAIL RAILSNoNoNoNo
ASSIST HANDLENoneNoneNoneNone
HOT WATER SERVICESuburbanSuburbanSuburbanSuburban
CUSTOMER REQUEST #9
CUSTOMER REQUEST #10
BEDROOM
BED SIZE0000
INNERSPRINGYesYesYesYes
PIILOWTOPYesYesYesYes
BED BOLSTERNoNoNoNo
BED HEAD CUPBOARD (FRONT WINDOW DELETED)NoNoNoNo
ROBE STYLE0000
MIRRORS ON ROBE DOORSYesYesYesYes
SHELVES IN ROBENoNoNoNo
CORNER CABINET DOOR SIDEReturnReturnReturnReturn
CORNER CABINET OFFSIDEReturnReturnReturnReturn
DRAWER UNDER BEDNoNoNoNo
HEATERNoNoNoNo
HEATER OUTLET POSITONNoneNoneNoneNone
DIVIDING CURTAINNoNoNoNo
CONCERTINA DOORNoNoNoNo
ADDITIONAL BEDROOM ELECTRICS
CUSTOMER REQUEST #11
CUSTOMER REQUEST #12
KITCHEN
TYPE0000
OVER HEADL - Shaped returnL - Shaped returnL - Shaped returnL - Shaped return
SINK TYPESquareSquareSquareSquare
SINK COVERNoNoNoNo
OVENSwift - Cooktop - RecessedSwift - Cooktop - RecessedSwift - Cooktop - RecessedSwift - Cooktop - Recessed
MICROWAVESwiftSwiftSwiftSwift
PULL-OUT PANTRYYesYesYesYes
3 DOOR PANTRYNoNoNoNo
WINE COOLERNoNoNoNo
ADDITIONAL KITCHEN ELECTRICS
CUSTOMER REQUEST #13
CUSTOMER REQUEST #14
FRIDGE
TYPERMD8551RMD8551RMD8551RMD8551
INSERT COLOUR
OVERHEAD CUPBOARD ACCESSNoneNoneNoneNone
FULL HEIGHT PANTRYNoNoNoNo
CUSTOMER REQUEST #15
DINING
SEATING TYPE0000
END ACCESS TO UNDER SEATINGDrawerDrawerDrawerDrawer
FOOT RESTNoNoNoNo
SHELVES IN OHCNoNoNoNo
OHC INSERTSTimberTimberTimberTimber
TABLE TYPETri-FoldTri-FoldTri-FoldTri-Fold
TABLE TO BED CONVERSIONNoNoNoNo
HIGH BACKSNoNoNoNo
LOOSE CUSHION TO RETURNNoNoNoNo
WALL PADDINGNoNoNoNo
ADDITIONAL DINING ELECTRICS
CUSTOMER REQUEST #16
CUSTOMER REQUEST #17
ENSUITE
STYLE0000
SHAVING CABINETNoNoNoNo
WASHING MACHINEFront LoadFront LoadFront LoadFront Load
BASIN TYPERoundRoundRoundRound
DRAWERS UNDER SINKYes - LeftYes - LeftYes - LeftYes - Left
DOOR UNDER SINKYes - RightYes - RightYes - RightYes - Right
SHOWER SIZEStandardStandardStandardStandard
TOILETStandardStandardStandardStandard
TOILET ROLL HOLDERNoNoNoNo
ADDITIONAL TOWEL RAILNoNoNoNo
HEATED TOWEL RAILNoNoNoNo
LINEN CUPBOARD CONFIGURATIONDoor above & belowDoor above & belowDoor above & belowDoor above & below
SHELVES IN LINEN CUPBOARDNoNoNoNo
LOOSE BATHROOM ACCESSORIESNoNoNoNo
ADDITIONAL ENSUITE ELECTRICS
CUSTOMER REQUEST #18
CUSTOMER REQUEST #19
BUNK
NUMBER OF BUNKSN/AN/AN/AN/A
BED HEADWall EndWall EndWall EndWall End
DVD PLAYERNoNoNoNo
TV CONNECTIONNoNoNoNo
DRAWERS UNDER BEDYesYesYesYes
ALUMINIUM LADDERNoNoNoNo
FRONT LOAD WASHING MACHINE IN ROBENoNoNoNo
SHELVES IN ROBENoNoNoNo
BI-FOLD TOP BUNKNoNoNoNo
LARGE WINDOWNoNoNoNo
WALL PADDINGNoNoNoNo
CONTSATINANoNoNoNo
DIVIDING CURTAINNoNoNoNo
PRIVACY CURTAINNoNoNoNo
EXTERNAL ACCESS LOCKER (2 BUNK ONLY; BESIDE DRAWERS, UNDER BUNK)NoNoNoNo
ADDITIONAL ENSUITE ELECTRICS
CUSTOMER REQUEST #20
CUSTOMER REQUEST #21

<tbody>
</tbody>



PDF MASTER FILE


C:\Users\graeme\AppData\Local\Temp\msohtmlclip1\01\clip_image003.png

<tbody>
</tbody>
14’ x 7’9 – Dreamrunner
Shower/Toilet – Ensuite Caravan
SPECIFICATIONS AS @ 6/02/2013
Standard Crusader Features - InteriorStandard Crusader Features - Exterior
• L.E.D. LIGHTS• DOMETIC ROLL OUT AWNING
• NEW SOFT OPERATING CUPBOARD DOOR STRUTS• INTERLOCKING SMOOTH WHITE ALUMINIUM PANELS
•SWIFT MICROWAVE• 2 X LOCKABLE WATER FILLERS
• MIXER TAPS IN BASIN, SHOWER & SINK• MAINS PRESSURE WATER FILLER
• LIGHT ABOVE SINK• EASY DROP JACKS
• DRAWERS ON ROLLERS• JACKING POINTS
• PIANO HINGES• TAP ON ‘A’ FRAME
• HEAVY DUTY VINYL FLOORING• ABS THERMOPLASTIC FRONT BOOT LINER
• HIGH DENSITY FOAM SEATING• TINTED DOUBLE GLAZED WINDOWS
• FLAP / DRAWER UNDER SEATING• SHADE TO FRONT WINDOW (WHERE APPLICABLE
• BEDSPREAD – QUEEN SIZE & DOUBLE BED ONLY• TRIPLE LOCK SECURITY DOOR
• INNERSPRING MATTRESS (QS & DBL BED ONLY)• STYLISH WHEEL SPATS
• SINGLE BED FOAM MATTRESSES (NO BEDSPREADS)• EXTERNAL POWERPOINT
• 12 VOLT RANGEHOOD• EXTERNAL TV POINT
• CHECKER PLATE DROP STEP & KICK PLATE &• EXTERNAL 12 VOLT POWER POINT
• STEP LIGHT• TV ANTENNA INPUT PLUG
• FIRE EXTINGUISHER• BARGMAN ASSIST HANDLE-LIGHT
• SMOKE DETECTOR• LED TAIL LIGHTS
• LCD FLAT SCREEN TV & BRACKET• BOOT LIGHT
• ENTRY DOOR GRAB HANDLE• INSULATED ROOF & WALLS
• WATER FILTER• FRONT & REAR CHROME GRAB HANDLES
• 120 AH BATTERY PACK & PROTECTOR
Dreamrunner Interior Features• 40 AMP BATTERY CHARGER / TRANSFORMER
• MODERN STYLE HANDLES• 2 X MINI ROOF HATCHES - Excluding Starlite & 14' Dreamrunner
• DOMETIC RMD8551 - 3 WAY FRIDGE ( INSULATED CAVITY)
• RECESSED GAS & ELECTRIC COOKTOPDreamrunner Exterior Features
• 12 VOLT PUMP• 4’’ X 2’’ SUPERGAL CHASSIS
• MIXER TAP AT SINK• 2500kg SINGLE AXLE
• FULL HEIGHT SPLASH BACKS• 15” X 235 ALUMINIUM ALLOY WHEELS
• FULL HEIGHT SLIDE OUT PANTRY• 8 PLY LIGHT TRUCK TYRES
• 2 X WATER TANK GAUGES• 2” RAISER TO CHASSIS
• MIRRORED WARDROBE DOOR (ENSUITE)• 12” ELECTRIC BRAKES
• DECORATIVE CURTAINS ONLY• 2 X 9kg GAS BOTTLES
• FULL COVER CURTAINS AVAILABLE AS AN OPTIONAL EXTRA• 2 X 95 LITRE WATER TANK
• ELECTRIC NORTH – SOUTH LIFT UP QUEEN SIZE BED• STRAIGHT BUMPER BAR & SPARE WHEEL
• DVD / CD / RADIO & 4 SPEAKERSWITH REMOVABLE BRACKET
• VARIOUS UPHOLSTERY STYLES• BRAKE SAFE
• TIMBER MOULDING (WHERE APPLICABLE)• VINYL PEBBLE GUARD TO TOP OF BOOT
• CHECKER PLATE SIDES
• 1 X ANNEX LIGHT
• PICNIC TABLE
• TV ANTENNA
• ROOF AIR CONDITIONER
• 2 X MINI ROOF HATCHES
• OUTSIDE SHOWER
• FULL THROUGH TUNNEL BOOT
• GAS / ELECTRIC HOT WATER SERVICE
• TRAILMATE JACK
The manufacturer reserves the right to alter specifications without notice

<tbody>
</tbody>

COLOURS AND VARIABLES


STANDARDNoYes
STANDARDNoneYes
STANDARDN/ACustomer Specified
STANDARDStandardCustomer Specified
STANDARDNoneCustomer Specified
STANDARDNoCustomer Specified
STANDARDNone12
STANDARDNox 1x 2
STANDARDNoneStandardCustomer Specified
STANDARDDoor SideOffside
STANDARDNone12
UPHOLSTERY TYPEPillowPleatedStandardWedge
FRONTStandardTourline
BEDROOM STYLENew Style RobesOld Style RobesNew Style Robes with Corner Cupboards
BEDQueenDoubleKing SingleSingleCustom SizeN.SE.W
KITCHENAngle KitchenL - Shaped KitchenStraight Kitchen
SEATINGCafé DinetteCafé LoungeClub LoungeL - LoungeReclinersStraight Lounge
ENSUITENew Style EnsuiteStandard
BUNKSN/A23456
DOOR POSITIONFrontCentreRear
CHECKER PLATEFront to top of bootFront to bottom of windowFront to top of windowSides onlyFront to top of boot & SidesFront to bottom of window & SidesFront to top of window & SidesFront to top of boot & 600 SidesFront to bottom of window & 600 SidesFront to top of window & 600 Sides
TYPESupagalHot Dipped GalvanizedAluminium
6" A FRAME & CHASSISNoA FRAMEA FRAME & CHASSIS
COUPLINGStandardAL-KOHitchmasterHylandMchitchCustomer Specified
CHASSIS RAISERNone2"4"6"
A FRAME MESH BASKETNoYes
TAP ON A FRAMEYes - Door SideYes - with shield - Door SideYes - OffsideYes - with shield - Offside
GALVANIZED UNDERLININGNoYes
PULL OUT STEPNoneG&STechnoOmniCustomer Specified
WHEELS15 x 20515 x 23516 x 24516 x 265
TYRES8 Ply LT
BRAKES10" Electric12" Electric
SUSPENSION TYPEStraight AxleControl RiderSimplicity2" Drop AxleCruisemasterSimplicity with AL-KO ESC
AL-KO ESCYesNo
BUMPER BARLoop 2 ArmLoop 3 ArmLoop 4 ArmStraight 2 ArmStraight 3 ArmStraight 4 Arm
BUMPER BAR ACCESSORIESNoneBike RackExtra Spare WheelGenerator BoxHayman Reese RecieverJerry Can HolderToolbox
WATER TANK No. & SIZE1 x 60lt2 x 60lt3 x 60lt4 x 60lt1 x 95lt2 x 95 lt3 x 95 lt4 x 95lt
WATER TANK POSITIONForwardRearForward & RearCustomer Specified
GAS BOTTLES1 x 9kg2 x 9kg
OUTRIGGER ACCESSORIESNoneJerry Can HolderToolboxJerry Can Holder & Toolbox
STONE SHIELDNoCUB Stone ShieldCustomer Specified
T.V HUTCHStandardEntertainment
T.V HUTCH ELECTRICS11 External & 1 in T.V HutchIn T.V Hutch
SECURITY DOOR LIGHTBargman Assist Handle - LightLava Lamp HandleCustomer Specified
TOW PLUG7 Pin Flat7 Pin Round12 Pin Flat
REVERSING CAMERANoSafety DaveWaecoPolarisCustomer Specified
SHELVES IN ROBENoneYes - x1Yes - x 1 - RemovableYes - x2
CORNER CABINET DOOR SIDENoneStandardReturnFull HeightStandard with OHCReturn with OHC
CORNER CABINET OFFSIDENoneStandardReturnFull HeightStandard with OHCReturn with OHC
DRAWER UNDER BEDNoYes - x1Yes x 2No - Flap - x1No - Flap - x2Customer Specified
HEATERNoGas - DometicGas - TrumaDieselCustomer Specified
SOLAR PANELNo1 x 120w2 x 120w3 x 120w1 x 150w2 x 150w3 x 150w
SOLAR CONTROLLERNoStandardISC-3020ISC-3022ISC-3030ISC-3032ISC 3040ISC-3042Customer Specified
WATER LEVEL GUAGEYes - in Overhead CupboardYes - Mounted on WallDrifter Panel
NUMBER OF BATTERIESNone1234
BATTERY TYPEStandardAGMGELCustomer Specified
BATTERY POSITIONStandardBootChassis
BATTERY CHARGERStandardCustomer Specified
BATTERY CHARGER POSITIONStandardBootCupboardOverhead CupboardUnder FridgeUnder OvenCustomer Specified
CRASH PAD/BED HEADMatch to Seat BaseCustomer Specified
RADIOStandard CD PlayerStandard CD/DVD PlayerBluetoothFusion 600Fusion 700Customer Specified
INTERNAL SPEAKERSNone245678
EXTERNAL SPEAKERSNone234
ANTENNANoneWinegardJack
SECURITY DOORStandard 1750 LHHStandard 1750 RHHLarge 1908 LHHLarge 1908 RHH
BBQNoWebber Q with StandSovereign Hooded Slide outCustomer Specified
GAS BAYONETNo1 to Front1 to Rear1 Front, 1 Rear
CHROME GRAB HANDLES FRONTNoneStandard 300mmPlastic
CHROME GRAB HANDLES REARNone300mmPlastic
AIR CONDITIONINGNoneIBISDometicHerron 2.2Herron QTruma Climaster
HATCHESDometic Mini HatchDometic Midi HatchFantasticFiamaCustomer Specified
HANDLESStandard Lever LatchStandard Push Button
WINDOWSDOMETIC Bubble (S4)DOMETIC S7 with Mini Double BlindsDometic S7 with Comfort Blind
PELMETSNoTimberMaterial Wrapped
ASSIST HANDLENoneDoor Handle SideDoor Hinged Side
HOT WATER SERVICESuburbanTrumaInstantenousCustomer Specified
OVER HEADStandardL - Shaped returnDropped 75mmDropped 100mm
SINK TYPERoundSquare
OVENSwift - Full OvenSwift - Full Oven - RecessedSwift - CooktopSwift - Cooktop - RecessedDometic OvenCustomer Specified
TYPEStandardRM2350RM2453RM2553RMD8551RML8551RM4601RM4605RM4805Vitrofrigo DP2600
INSERT COLOURMatching PlyMatching LaminateBlack GlossWhite GlossBrushed Aluminium LaminateCustomer Specified
OVERHEAD CUPBOARD ACCESSNoneDoorFlap
FULL HEIGHT PANTRYNoYesPantry above & 2 Drawers below
END ACCESS TO UNDER SEATINGDrawerFlapNone
SHELVES IN OHCNoYesYes - RemovableSwiftCustomer Specified
OHC INSERTSTimberBlack GlassGlassLeadlight
TABLE TYPETri-FoldStandard
WASHING MACHINENoneFront LoadTop LoadCustomer Specified
BASIN TYPELarge reccessedSmall reccessedLarge Semi-RecessedSmall Semi-RecessedRound Salad BowlSquare Salad Bowl
DRAWERS UNDER SINKNoYes - LeftYes - RightYes - Both
DOOR UNDER SINKNoYes - LeftYes - RightYes - Both
SHOWER SIZEStandardLargeToilet & Shower Combo
TOILETStandardToilet & Shower Combo
ADDITIONAL TOWEL RAILNoYes - x1Yes - x2
LINEN CUPBOARD CONFIGURATIONDoor above & belowDoor above & Drawers belowSingle Door
SHELVES IN LINEN CUPBOARDNoYes - x1Yes - x1 - RemovableYes - x2Yes - x2 - Removable
BED HEADWall EndPartition
VINYLTo Top of BootTo Bottom of WindowTo Top of Window

<tbody>
</tbody>
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,215,459
Messages
6,124,944
Members
449,198
Latest member
MhammadishaqKhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top