Spreadsheet: 821922d1678989681-solved-help-with-dropdowns-and-fetching-info-via-indirect-new-pricing-matrix-v10-for-help
Sheet: Packages Info

 | Package Category | Package Name | [NAME] | Comparable Package | Price | New or Old | Location | Travel Fees Apply | Subjects | Min Time | [NAME] time | Time x to y | GST | PST | Total w/ Tax | Files | [NAME] | Option 1 | Option 2 | Option 3 | Choice of: Aggregate | Prints 1 | Prints 2 | Canvases | Collages | Albums | Other | Setups | Notes or Limitations | Available Upgrades and Extras 1 | Available Upgrades and [NAME] | Perks
 | Babies | The Baby Basic |  | The Baby Basic | 400 | Old | Studio or Photog Loc Choice | ? | 1 (just baby) | 00:00:00 | 00:45:00 |  |  |  |  | 10 |  |  |  |  |  | 8x10 print |  |  |  |  |  | 2 setups with 2 outfits
 | Babies | The Baby |  | The Baby Basic | 499 | New | Studio Only | No | ? | 00:30:00 | 01:00:00 |  |  |  |  | 10 |  |  |  |  |  | 4x6 print collection of selected files |  |  |  |  |  | 3 backdrops and use of outfits (if available). | For babies 5 - 13 months ? No balloons or themes. Is not a cakesmash. | Add Mini Family Session for $299 (WHAT IS THAT?)
 | Babies | The Baby Silver |  | The Baby Silver | 500 | Old | Studio or Location | Yes | 3 subjects | 00:00:00 | 01:30:00 |  |  |  |  | 15 |  |  |  |  |  | 8x10 print
 | Cakesmash | The Cake |  | The Cake | 499 | Old | Studio or Location | Yes | 1 (just baby) | 00:00:00 | 01:00:00 |  |  |  |  | 10 |  |  | 12x12 Collage | Print Package B (2 5x7s, 2 8x10s) |  |  |  |  |  |  |  | smash setup only |  | Splash session for $50 and 2 extra files |  | [NAME]
 | Cakesmash | The Cake |  | The Cake | 600 | New | Studio Only | No | 1 (just baby) | 00:45:00 | 01:00:00 |  |  |  |  | 10 |  | Mounted 8x10 |  |  |  | 4x6 print collection of selected files |  |  |  |  |  | Just the smash. |  | Splash session for $50 and 2 extra files |  | [NAME]
 | Cakesmash | The Party |  | The Party | 600 | Old | Studio or Location | Yes | 1 (just baby) | 00:45:00 | 02:00:00 |  |  |  |  | 20 |  | 11x14 Canvas | 12x12 Collage | Print Package B (2 5x7s, 2 8x10s) |  | 8x10 print |  |  |  |  |  | pre smash, cake 2-3 outfits. |  | Splash session for $50 and 2 extra files |  | [NAME]
 | Cakesmash | The Party |  | The Party | 700 | New | Studio and Outdoor Location | ? | 1 (just baby) | 00:45:00 | 01:30:00 |  |  |  |  | 15 |  | 11x14 Canvas | 12x12 Collage | Print Package B (2 5x7s, 2 8x10s) |  | 4x6 print collection of selected files |  |  |  |  |  | pre-smash setup and smash. 2-3 outfits allowed. |  | Splash session for $50 and 2 extra files |  | [NAME]
 | Cakesmash | The Celebration |  | The Celebration | 700 | Old | Studio or Location | Yes | 6 subjects | 00:00:00 | 02:00:00 |  |  |  |  | 25 |  | 11x14 Canvas | 12x12 Collage | Print Package B (2 5x7s, 2 8x10s) |  | 8x10 print |  |  |  |  |  | Family/sibling setup , pre-smash, cake smash. 3 outfits for baby 1 for others. |  | Splash session for $50 and 2 extra files |  | [NAME]
 | Cakesmash | The Celebration |  | The Celebration | 850 | New | Studio and Outdoor Location | ? | Up to 6, parents & sibilings only | 00:45:00 | 01:30:00 |  |  |  |  | 20 |  | 11x14 Canvas | 12x12 Collage | Print Package B (2 5x7s, 2 8x10s) |  | ? (no 8x10 print) |  |  |  |  |  | Family/sibling setup , pre-smash, cake smash. 3 outfits for baby 1 for others. |  | Splash session for $50 and 2 extra files |  | [NAME]
 | Dance | The Basic |  | The Basic | 425 | Old | Studio or Photog Loc Choice | ? | 1 subject | 00:00:00 | 01:00:00 |  |  |  |  | 8 |  |  |  |  |  | 8x10 print |  |  |  |  |  | 1 backdrop, 2 outifts (footwear changes allowed) | No flour, paint, or liquid sessions without additional fees.
 | Dance | The [NAME] |  | The Basic | 500 | New | Studio or Photog Loc Choice | ? | 1 subject | 00:00:00 | 01:00:00 |  |  |  |  | 10 |  |  |  |  |  | 8x10 print |  |  |  |  |  | 1 backdrop, 2 outifts (footwear changes allowed) | Includes use of studio fabrics, skirts, wings, and the option of monochome backgrounds. Does not include flour, paint, or liquid sessions | Add headshots for $150
 | Dance | Dancer's Portfolio |  | Dancer's Portfolio | 575 | Old | Studio or Location | Yes | 1 subject | 00:00:00 | 02:00:00 |  |  |  |  | 15 |  | 11x14 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 8x10 print |  | 11x14 canvas |  |  |  | 3-4 look changes | No flour, paint, or liquid sessions without additional fees. | 1 additional dancer can be added for $75
 | Dance | Dancer's Portfolio |  | Dancer's Portfolio | 600 | New | Studio or Location | Yes | 1 subject | 00:00:00 | 02:00:00 |  |  |  |  | 15 |  | 11x14 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 8x10 print |  |  |  |  |  | 3-4 look changes | Includes use of studio fabrics, skirts, wings, and the option of monochome backgrounds. Does not include flour, paint, or liquid sessions | Add headshots for $150
 | Dance | Advanced Creative |  | Advanced Creative | 1120 | Old | Studio or Location | ? | 1 subject | 00:00:00 | 04:00:00 |  |  |  |  | 25 |  | 16x24 Canvas | 16x20 Collage | Print Package C (1 9×12, 2 8×10’s, 2 5×7’s) |  | 8x10 print |  | 11x14 canvas |  |  |  |  | Allows for location changes. [NAME], liquid, and paint options allowed. | Additional dancer's can be added at $75 and 5 extra files.
 | Dance | Group Creative Session |  | Group Creative Session | 1200 | Old | Studio or Location | ? | Up to 4 | 00:00:00 | 04:00:00 |  |  |  |  | 20 |  |  |  |  |  | 4 10x15 prints |  |  |  |  |  |  | Allows for location changes. [NAME], liquid, and paint options allowed.
 | Family | The Family Basic Bronze |  | The Family Basic Bronze | 475 | Old | Studio or Location | Yes | 3 subjects (3 subjects+ mo) | 00:00:00 | 00:45:00 |  |  |  |  | 10 |  |  |  |  |  | 8x10 print
 | Family | Mommy & Me |  | n/a | 500 | New | ? | ? | 2 (5+ mo up) | ? | ? |  |  |  |  | 5 |  |  |  |  |  | 4x6 print collection of selected files |  |  |  |  |  | 2-3 looks |  |  |  | Use of up to 3 gowns
 | Family | The Family Bronze |  | The Family Basic Bronze | 575 | New | Studio or Photog Loc Choice | Yes | 3 subjects | 00:00:00 | 00:45:00 |  |  |  |  | 10 |  |  |  |  |  | 4x6 print collection of selected files
 | Family | The Family Silver |  | The Family Silver | 575 | Old | Studio or Location | Yes | 6 subjects | 01:30:00 | 02:00:00 |  |  |  |  | 15 |  | 11x14 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 8x10 print
 | Family | The Family Gold |  | The Family Gold | 685 | Old | Studio or Location | Yes | 12 subjects | 01:30:00 | 02:00:00 |  |  |  |  | 20 |  | 11x14 Canvas | Print Package C (1 9×12, 2 8×10’s, 2 5×7’s) |  |  | 8x10 print
 | Family | The Family Silver |  | The Family Silver | 725 | New | Studio or Location | Yes | 6 subjects | 01:00:00 | 01:15:00 |  |  |  |  | 15 |  | 11x14 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 4x6 print collection of selected files
 | Family | The Platinum Group |  | The Platinum Group | 775 | Old | Studio or Location | Yes | 18 subjects | 01:30:00 | 02:00:00 |  |  |  |  | 20 |  | 16x20 Canvas | Print Package C (1 9×12, 2 8×10’s, 2 5×7’s) |  |  | 2 8x10 prints
 | Family | The Family Gold |  | The Family Gold | 825 | New | Studio or Location | Yes | 12 subjects | 01:30:00 | 02:00:00 |  |  |  |  | 15 |  | 11x14 Canvas | Print Package C (1 9×12, 2 8×10’s, 2 5×7’s) |  |  | 4x6 print collection of selected files
 | Family | The Platinum Group - Extended Family |  | The Platinum Group | 950 | New | Studio or Location | Yes | 18 subjects | 00:00:00 | 02:00:00 |  |  |  |  | 20 |  | 11x14 Canvas | Print Package C (1 9×12, 2 8×10’s, 2 5×7’s) |  |  | 4x6 print collection of selected files
 | Headshots | The Basic Package |  | The Basic Package | 350 | Old | Studio w/ Location UG | ? | 1 subject | 01:00:00 | 02:00:00 |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  | Certain outfit stipulations | Location for $50 | Add additional subj for $75 +2 files
 | Headshots | [NAME] |  | The Basic Package | 399 | New | Studio w/ Location UG | Yes | 1 subject | 00:00:00 | 00:45:00 |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  | Certain outfit stipulations. | Location for $50 | Add additional subj for $50 +1 files, does not increase time.
 | Headshots | The Portfolio Package |  | The Portfolio Package | 475 | Old | Studio w/ Location UG | ? | 1 subject | 00:00:00 | 00:45:00 |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  | Certain outfit stipulations | Location for $50 | Add additional subj for $75 +2 files
 | Headshots | [NAME] |  | The Portfolio Package | 575 | New | ? | ? | 1 subject | 01:00:00 | 02:00:00 |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  | Certain outfit stipulations | [no location upgrade info] | Add additional subj for $75 +2 files
 | Kids | The Bronze Basic |  | The Bronze Basic | 400 | Old | Studio or Photog Loc Choice | No | 1 subject | 00:00:00 | 00:45:00 |  |  |  |  | 8 |  |  |  |  |  | 8x10 print |  |  |  |  |  | 2 with 2 outfits
 | Kids | The Silver Basic |  | The Silver Basic | 475 | Old | Studio or Photog Loc Choice | No | 3 subjects | 00:00:00 | 00:45:00 |  |  |  |  | 10 |  |  |  |  |  | 8x10 print
 | Kids | The [NAME] |  | The Bronze Basic | 499 | New | Studio or Photog Loc Choice | No | 1 subject | 00:00:00 | 00:45:00 |  |  |  |  | 10 |  |  |  |  |  | 4x6 print collection of selected files |  |  |  |  |  | 2 setups with 2 outfits
 | Kids | The Silver |  | The Silver Basic | 575 | New | Studio or Photog Loc Choice | No | 3 subjects | 00:45:00 | 01:00:00 |  |  |  |  | 10 |  |  |  |  |  | 8x10 print | 4x6 print collection of selected files
 | Kids | The Gold |  | The Gold | 575 | Old | Studio or Location | Yes | 6 subjects | 01:30:00 | 02:00:00 |  |  |  |  | 15 |  | 11x14 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 8x10 print
 | Kids | The Platinum |  | The Platinum | 775 | Old | Studio or Location | Yes | 15 subjects | 00:00:00 | 02:00:00 |  |  |  |  | 20 |  | 16x20 Canvas | Print Package D (1 11×14, 2 8×10s, 4 5×7s) |  |  | 2 8x10 prints
 | Maternity | The Belly Basic |  | The Belly Basic | 525 | Old | Studio or Location | Yes | 2 subjects | 00:00:00 | 01:00:00 |  |  |  |  | 10 |  |  |  |  |  | 8x10 print |  |  |  |  |  | 2 setups |  |  |  | Use of 1 maternity gown
 | Maternity | The Bello Solo Bronze |  | The Belly Basic | 650 | New | ? | ? | Mama only | 01:00:00 | 01:30:00 |  |  |  |  | 10 |  |  |  |  |  | 4x6 print collection of selected files |  |  |  |  |  | 2 backdrops |  | $200 for hair and makeup |  | 2-3 gowns
 | Maternity | The Belly Silver |  | The Belly Silver | 700 | Old | Studio or Location | Yes | 6 subjects | 00:00:00 | 02:00:00 |  |  |  |  | 20 |  | 11x14 or 10x15 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 8x10 print |  |  |  |  |  | 3-5 setups |  |  |  | Up to 3 maternity gowns
 | Maternity | The Belly Silver |  | The Belly Silver | 750 | New | Studio or Location | Yes | Mama + 1 | 00:00:00 | 02:00:00 |  |  |  |  | 15 |  |  |  |  |  | 8x10 print | 4x6 print collection of selected files |  |  |  |  |  |  | $200 for hair and makeup |  | 2-3 gowns
 | Maternity | The Belly Gold |  | The Belly Gold | 900 | New | Studio or Location | ? | 6 subjects | 00:00:00 | 02:30:00 |  |  |  |  | 15 |  | 11x14 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 4x6 print collection of selected files |  |  |  |  |  |  |  | $200 for hair and makeup |  | "Recommended max" 4
 | Maternity | The Belly Gold |  | The Belly Gold | 950 | Old | Studio AND Location | Yes | 6 subjects | 00:00:00 | 04:00:00 |  |  |  |  | 25 |  | 11x14 or 10x15 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 2 5x7s, 1 8x10 print |  |  |  |  |  |  |  |  |  | Up to 4 maternity gowns
 | Maternity | The Belly Platinum |  | n/a | 1150 | New | Studio AND Location | No | 6 subjects | 00:00:00 | 04:30:00 |  |  |  |  | 20 |  | 11x14 Canvas | Print Package B (2 5x7s, 2 8x10s) |  |  | 4x6 print collection of selected files |  |  |  |  | 1 Fine Art Image |  |  | $200 for hair and makeup |  | Up to *** gowns
 | Newborn | The Basic Wrapped |  | The Basic Wrapped | 450 | Old | Studio Only | n/a | 1 (just baby); no twins or triplets | 00:00:00 | 00:45:00 |  |  |  |  | 5 |  |  |  |  |  | 8x10 print |  |  |  |  |  | 1 wrapped | Baby must be 3 weeks or younger, no addons allowed.
 | Newborn | The Wrapped |  | The Basic Wrapped | 550 | New | Studio Only | n/a | Just baby (no twins) | 00:00:00 | 00:45:00 |  |  |  |  | 5 |  |  |  |  |  | 4x6 print collection of selected files |  |  |  |  |  | 1 wrapped setup, excludes hanging | Baby must be 3 weeks or younger, no addons allowed. | $200 for hair and makeup |  | Gown usage?
 | Newborn | The Basic Bronze |  | The Basic Bronze | 575 | Old | Studio Only | n/a | 1 (just baby) | 01:30:00 | 02:00:00 |  |  |  |  | 10 |  |  |  |  |  | 8x10 print |  |  |  |  |  | 3 | n/a |  | Add sibling set up for $50 (1 post 2 siblings [NAME])
 | Newborn | The [NAME] |  | The Basic Bronze | 675 | New | Studio Only | n/a | Just Baby | 00:00:00 | 02:00:00 |  |  |  |  | 10 |  |  |  |  |  | 4x6 print collection of selected files |  |  |  |  |  | 3 set ups (excludes hanging) |  | $200 for hair and makeup |  | Gown usage?
 | Newborn | The Silver Collection |  | The Silver Collection | 725 | Old | Studio Only | n/a | 5 subjects | 00:00:00 | 03:00:00 |  |  |  |  | 20 |  | 11x14 Canvas | 10x20 Collage | Print Package B (2 5x7s, 2 8x10s) |  | 8x10 print |  |  |  |  |  | up to 5 | Immediate family only
 | Newborn | The Silver Collections |  | The Silver Collection | 800 | New | Studio Only | n/a | Baby + parents, or baby + 2 siblings | 00:00:00 | 00:00:00 |  |  |  |  | 15 |  |  |  |  |  | 4x6 print collection of selected files |  |  |  |  |  | up to 5 including baby in arms and detail |  | $200 for hair and makeup |  | Gown usage?
 | Newborn | The Gold Collection |  | The Gold Collection | 850 | Old | Studio Only | n/a | 6 subjects | 00:00:00 | 04:00:00 |  |  |  |  | 25 |  | 11x14 Canvas | 10x20 Collage | Print Package B (2 5x7s, 2 8x10s) |  | 2 8x10 and 2 5x7s prints |  |  |  |  |  | Up to 6 | Immediate family only
 | Newborn | The Gold Collection |  | The Gold Collection | 950 | New | Studio Only | n/a | 6 subjects, immediate fam only | 00:00:00 | 00:00:00 |  |  |  |  | 15 |  | 11x14 Canvas | 10x20 Collage | Print Package B (2 5x7s, 2 8x10s) |  | 4x6 print collection of selected files |  |  |  |  |  | up to 6 including baby in arms and detail | Immediate family only. | $200 for hair and makeup |  | Gown usage?
 | Newborn | The Platinum Collection |  | The Platinum Collection | 1150 | Old | Studio Only | n/a | 6 subjects | 00:00:00 | 04:00:00 |  |  |  |  | 35 |  | 11x14 Canvas | 10x20 Collage | Print Package B (2 5x7s, 2 8x10s) |  | 2 8x10 and 2 5x7s prints |  |  |  | 6x8 mini album |  | up to 6 | Immediate family only
 | Newborn | The Platinum Collection |  | The Platinum Collection | 1250 | New | Studio Only | n/a | 6 subjects | 00:00:00 | 04:00:00 |  |  |  |  | 20 |  | 11x14 Canvas | 10x20 Collage | Print Package B (2 5x7s, 2 8x10s) |  | 4x6 print collection of selected files |  |  |  | Mini album (size?) |  | up to 8 including baby in arms and detail |  | $200 for hair and makeup |  | Gown usage?