Juniper (Digital Marketing)

Looking for something else? Click here to navigate to the Digital Marketing home page on Confluence!



Juniper Reporting

In order to cut down on the amount of manual editing that needs to be done in the client sheets every time we run the SEO Quarterly reports, we’ve made a (hopefully temporary) master google sheet that will house all of the google trend data. Every quarter, reps will come to this document and find the relevant formulas to put into the Google Trend Import tab of the client sheet, so that this data auto populates how we need it to work for Ninja Cat.

These formulas are broken up into Regions and Verticals.

Google Trend Import tab Set Up

Here is an example of what the basic template for this tab should look like. You will have column A as the “Week” column. Then columns B - E, with titles “one, two, three, four”. This is how it is mapped into Ninja Cat, so it must match exactly. Row 2 in these columns is where you will be putting the formulas provided below.

In column F, you have “number” with numbers 1-4. You should never need to change this, it’s only for filtering purposes in the report.

Column G is where you will match the keywords with the numbers in Column F. If Column B - “one” - is Motorcycles, you will put Motorcycles first. Unless you are changing what trends you want to show every quarter, then you should also only need to set this up once and never touch it again. Here is a finished tab to show you what that will look like.

In this example “one”/1 is Motorcycles, “two”/2 is ATVs, “three”/3 is Powersports, and “four”/4 is Polaris For Sale.

Now that we have the base tab set up, below are the formulas you will need to plug in to make the data show up in your report. All you need to do is copy and paste.

For generating quarterly reports you will need the following formulas:

Northwest

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northwest!AL2:AL52")

Southwest

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southwest!AL2:AL52")

Mid-Atlantic

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Mid-Atlantic!AL2:AL52")

West

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","West!AL2:AL52")

Midwest

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Midwest!AL2:AL52")

Northeast

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Northeast!AL2:AL52")

Southeast

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Southeast!AL2:AL52")

British Columbia

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","British Columbia!AL2:AL52")

Prairie Provinces

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Prairie Provinces!AL2:AL52")

Ontario

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Ontario!AL2:AL52")

Quebec

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Quebec!AL2:AL52")

Atlantic Provinces

Motorcycle=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!A2:A52")
ATV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!B2:B52")
UTV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!C2:C52")
Dirt Bike=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!D2:D52")
Travel Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!E2:E52")
Fifth Wheel=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!F2:F52")
Motorhome=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!G2:G52")
Toy Hauler=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!H2:H52")
RV=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!I2:I52")
Tractors=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!J2:J52")
Combines=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!K2:K52")
Harvesters=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!L2:L52")
Lawn mowers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!M2:M52")
Cars For Sale=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!N2:N52")
Vans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!O2:O52")
Sedans=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!P2:P52")
SUVs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!Q2:Q52")
Harley-Davidson=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!R2:R52")
Softail=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!S2:S52")
Cruiser=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!T2:T52")
Dump Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!U2:U52")
Excavators=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!V2:V52")
Backhoes=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!W2:W52")
Dozers=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!X2:X52")
Boats=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!Y2:Y52")
Jet Ski=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!Z2:Z52")
PWC=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AA2:AA52")
Pontoon Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AB2:AB52")
Wake Boat=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AC2:AC52")
Utility Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AD2:AD52")
Cargo Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AE2:AE52")
Dump Trailer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AF2:AF52")
Commercial Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AG2:AG52")
Truck Dealer=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AH2:AH52")
Semi Truck=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AI2:AI52")
Home Medical Equipment=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AJ2:AJ52")
Medical Supply Store=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AK2:AK52")
Lift Chairs=IMPORTRANGE("1iy6_zO6q-xKDyqzIrhy2jCTCIJ0vFOx8CLcZR4ZC1pQ","Atlantic Provinces!AL2:AL52")