Wk8_Warm-up-Bundling-PSet111.xlsx

The Best WritersITEM SALESITEM PRICEPROFITBUN SALESBUN PRICEBUN PROFIT80320.10803.20WTPCOMMENT:“=IF(Ratings!B2=1,0.1,(IF(Ratings!B2=2,0.25,(IF(Ratings!B2=3,0.5,(IF(Ratings!B2=4,0.9,IF(Ratings!B2=5,1.5,””))))))))”COMMENT:“If the user rating is X then set willingness to pay Y with (X->Y): {1->.1, 2->.25, 3->.5, 4->.9, 5->1.5). Blanks are left blank.”COMMENT:“=IF(B103-Analysis!$R$26>0,B103-Analysis!$R$26,0)”COMMENT:“If Bundle WTP > Bundle Price, then return Bundle WTP Bundle Price, else return 0.”COMMENT:“=COUNT(B2:B101)*IF(Analysis!$R$26= Bundle Price”SONGCS1CS2CS3CS4CS5CS6CS7CS8CS9CS10CS11CS12CS13CS14CS15CS16CS17CS18CS19CS20CS21CS22CS23CS24CS25CS26CS27CS28CS29CS30CS31CS32CS33CS34CS35CS36CS37CS38CS39CS40CS41CS42CS43CS44CS45CS46CS47CS48CS49CS50CS51CS52CS53CS54CS55CS56CS57CS58CS59CS60CS61CS62CS63CS64CS65CS66CS67CS68CS69CS70CS71CS72CS73CS74CS75CS76CS77CS78CS79CS80CS81CS82CS83CS84CS85CS86CS87CS88CS89CS90CS91CS92CS93CS94CS95CS96CS97CS98CS99CS100Acid Tracks0.400.400.400.401.001.000.401.001.001.001.001.00Ain’t No Sunshine (When She’s Gone)1.000.400.400.401.001.000.400.400.400.401.001.000.401.001.000.401.001.000.400.40Ain’t Talkin’ ‘Bout Love0.401.000.401.001.001.001.000.401.001.000.400.401.001.000.401.00Another One Bites The Dust0.401.001.001.000.401.001.001.000.400.400.40Big City Blues1.000.401.000.400.401.000.400.400.401.001.000.400.401.000.401.00Blister In The Sun1.001.001.001.001.001.001.000.401.001.000.40Block Rockin’ Beats1.000.401.000.400.400.400.400.400.400.400.400.400.401.000.400.40Blue River1.001.000.401.001.001.001.00Boogie Nights1.001.000.401.000.400.401.001.000.401.001.000.401.001.001.00Bridge Over Troubled Water1.001.000.400.401.000.400.400.401.000.400.400.400.40Broadway Melody, The1.001.000.401.000.401.000.401.000.400.400.40California Uber Alles0.400.400.401.001.000.401.001.000.401.000.400.401.001.000.400.40Cat’s In The Cradle1.000.401.001.000.400.401.000.400.400.400.400.400.401.001.000.40Chelsea Morning1.000.400.401.000.401.000.401.000.401.001.000.400.401.001.000.400.401.001.001.001.000.400.40Circumstances0.400.400.400.400.401.001.000.401.001.00Composition No. 16 (+101)1.000.400.401.001.001.001.000.401.000.400.401.000.400.401.000.40Convolutions1.001.000.400.400.401.001.001.001.001.001.001.001.000.40Dear Mrs. Roosevelt0.401.000.401.001.001.000.401.000.401.00Deep Purple1.000.401.001.001.001.000.400.401.001.000.400.400.401.000.401.000.401.001.001.00Dirty Old Town1.001.000.400.400.401.000.400.401.000.401.001.000.400.401.000.401.000.40Don’t Let Your Mouth Write A Check That Your Ass Can’t Cash1.000.401.000.401.000.401.001.00Don’t Think Twice, It’s All Right0.400.400.401.001.001.001.001.000.401.000.401.001.000.400.401.000.400.401.001.000.40Don’t Worry ‘Bout Me1.000.400.401.001.001.001.000.400.400.401.000.401.000.400.40Donkey Serenade, The0.400.400.401.000.401.001.001.000.400.400.401.000.400.400.400.400.40Drift Away1.001.001.001.000.401.000.400.401.001.000.40Feelin’ Alright1.000.401.001.000.401.000.401.000.400.401.000.400.401.001.000.400.400.401.00Fly, Robin, Fly1.000.400.400.400.400.400.400.401.000.401.000.401.000.400.400.401.001.000.401.00Freddie Freeloader0.401.001.000.400.400.400.401.000.400.401.000.401.001.000.40Freight Train1.000.401.000.400.400.401.000.401.001.000.400.401.000.400.400.401.000.40From Hank To Hendrix0.400.400.400.401.000.401.000.401.000.401.000.400.40Give Me One Reason0.401.000.400.401.000.401.000.400.400.401.000.400.400.400.40Golden Hair1.001.001.001.000.400.401.000.401.000.401.001.001.000.400.401.000.40Heart Of Gold1.000.401.000.401.000.401.001.001.000.401.001.000.401.000.40Hello Central, Give Me Heaven0.401.000.401.000.401.000.401.000.401.000.401.000.400.401.000.401.000.400.400.401.000.40How Ya Gonna Keep ‘Em Down On The Farm (After They’ve Seen Paree)1.001.000.400.401.001.001.000.400.400.401.000.400.401.000.401.000.400.400.40I Can’t Stand My Baby1.000.401.001.000.400.401.001.001.000.400.400.400.400.401.00I Can’t Stop Loving You0.400.401.000.401.000.400.400.401.000.401.000.401.001.001.001.000.400.400.40I Could Write A Book0.401.001.000.400.400.401.000.400.401.000.400.400.400.40I Cried For You (Now It’s Your Turn To Cry For Me)1.001.001.001.001.000.401.001.001.001.001.000.401.000.40I Don’t Know How To Love Him0.401.001.001.000.400.401.000.401.000.400.401.000.400.400.401.000.40I Got Stripes0.401.001.001.000.401.001.000.401.000.401.000.400.400.400.400.400.40I Only Have Eyes For You1.000.400.400.400.400.401.001.001.000.401.000.400.400.400.401.001.001.001.000.400.400.401.000.401.00I’m Crying0.401.000.400.401.001.000.400.401.001.000.401.001.001.000.400.400.400.40I’ve Got A Tiger By The Tail1.000.401.001.000.400.400.401.001.001.000.400.400.400.401.001.000.401.00Illegal Smile1.001.000.400.401.001.001.001.001.000.400.401.000.401.001.00Immigrant Song1.000.400.401.001.001.001.000.401.001.001.001.001.00In De Ghetto1.001.001.000.401.000.400.400.400.400.400.400.401.00It Don’t Mean A Thing If It Ain’t Got That Swing0.400.400.400.400.401.001.000.400.401.000.400.400.401.000.401.00Keep The Customer Satisfied1.000.400.400.401.001.000.401.000.401.001.000.401.001.000.401.000.401.00Lady Madonna1.000.401.000.401.001.001.001.001.001.000.400.400.401.001.001.00Lark Ascending, The1.001.001.000.400.400.400.400.400.401.000.401.001.00Las Cuevas De Mario1.000.400.401.000.401.000.400.401.001.000.401.001.000.40Let The Funk Flow0.401.001.001.001.001.000.400.401.000.401.001.001.00Light Of A Clear Blue Morning0.401.001.001.001.000.400.400.401.000.401.000.400.40Living Dangerously0.400.400.400.400.401.000.400.400.400.400.401.001.000.40Love Letters In The Sand1.001.001.001.001.000.401.000.400.401.000.401.00Make Someone Happy1.000.401.001.001.000.400.400.401.001.00Manteca0.400.401.000.400.400.401.000.400.400.40Mary Anne With The Shaky Hand1.000.400.401.001.000.400.401.001.001.001.000.401.001.001.000.400.400.401.00Mellow Yellow1.000.400.400.400.401.000.401.000.401.00Mercedes Benz1.001.000.401.000.400.400.400.400.401.000.400.40Misguided Angel0.401.001.000.401.001.001.000.400.400.401.001.001.000.400.400.40Mr. Green Genes0.401.000.400.401.001.000.400.401.000.400.401.000.401.001.001.001.001.000.400.401.001.001.00Mr. Vain1.000.401.000.401.000.401.000.400.400.400.400.400.401.000.40Music Ain’t Loud Enuff1.001.000.400.400.401.000.400.400.401.000.40My Ship1.001.001.000.400.401.001.001.001.000.401.000.401.001.00Ne Me Quitte Pas (If You Go Away)1.001.000.400.401.001.001.000.401.001.000.401.001.000.401.000.401.000.401.000.400.40New York On My Mind1.000.401.001.001.000.401.000.401.000.401.000.401.000.400.401.001.001.001.000.400.40Oh Bondage, Up Yours!1.000.401.001.001.000.400.400.401.000.400.40On The Radio0.401.000.400.401.001.000.401.001.000.401.000.400.401.000.401.001.000.400.40Oye Como Va1.001.000.400.401.000.401.001.000.400.401.001.001.001.00Pack Up Your Troubles In Your Old Kit Bag0.400.401.001.001.001.000.401.001.000.401.000.401.001.000.401.000.401.001.000.40Paper Thin0.401.001.000.401.001.000.401.000.401.00Peggy Sue1.001.001.000.400.401.001.001.000.401.000.401.00Pink Moon1.001.001.001.001.000.401.001.001.001.001.001.000.401.000.401.001.00Raindrops Keep Fallin’ On My Head1.001.001.001.000.401.001.001.000.401.001.00Red0.400.401.001.000.401.000.401.001.000.400.400.400.400.400.401.00Reflections In Blue1.001.000.400.400.401.000.400.400.400.400.400.401.001.001.001.001.000.401.00Sanctuary0.401.000.401.000.400.401.000.400.400.400.401.000.400.401.001.000.401.001.00Should I Stay Or Should I Go?0.401.001.000.400.401.000.401.001.000.400.400.401.001.001.001.001.00Snowin’ In Brooklyn0.400.400.401.000.400.401.001.001.000.400.400.400.401.00Sometimes I See0.401.001.000.400.401.000.401.000.40Sound Of Da Police0.401.001.000.401.000.400.400.400.401.000.400.400.401.000.401.00Stage Fright1.001.000.401.001.000.401.000.400.400.400.400.400.400.400.400.400.40Straight Life0.400.400.400.400.400.401.000.401.000.401.000.400.401.001.001.001.000.40Summer Wages0.400.400.400.401.000.400.400.401.000.401.000.40Sweet Soul Music0.400.400.400.400.401.000.400.400.401.001.000.401.00That Old Black Magic0.401.001.000.400.401.001.001.000.400.401.001.001.001.000.401.000.401.000.401.000.400.401.00This Magic Moment0.400.401.000.400.400.401.001.000.401.001.000.401.000.401.001.000.400.40Three To Get Ready0.401.000.401.001.000.400.401.001.001.000.401.001.001.000.400.401.00Trolley Song, The1.000.401.000.401.001.001.000.401.000.401.000.401.000.401.001.000.401.000.400.401.000.40True Blue Lou1.001.001.000.401.001.000.401.000.401.000.400.400.400.40Wash Your Face In My Sink0.401.001.001.001.001.001.000.401.000.400.400.40Wayward Wind, The0.400.401.001.000.401.000.400.401.001.000.400.400.401.001.001.000.40West 22nd Street Theme0.401.001.000.400.401.000.400.401.000.400.401.000.401.000.400.401.000.401.000.401.00When I Call Your Name0.400.400.400.400.400.400.401.001.000.400.400.400.401.000.400.40When The Sun Goes Down1.001.000.400.401.001.001.000.400.400.401.001.000.400.401.000.400.401.000.40Whoomp! (There It Is)0.400.401.001.000.400.400.401.001.000.401.001.000.401.00Yellow Rose Of Texas0.401.001.001.001.001.000.401.000.400.400.40You Make Me Feel Mighty Real1.000.401.001.001.001.001.000.401.000.401.001.001.000.400.400.400.401.000.401.001.001.00COMMENT:“=IF((WTP!B2=””),””,(IF(WTP!B2-Analysis!$B$26>0, WTP!B2-Analysis!$B$26,””)))”COMMENT:“If cell is blank, leave blank. Else, if WTP BestPrice >0, return WTP BestPrice, else return blank.