don't worry be happy S:\Business Office\Business Analyst\Traction Rec Data\Active Membership Export.xlsx export Active Members 171042924_Sheet export Active Members 171042924 Sheet Promoted Headers Changed Type UID MID Full Name Type DOB Counts Towards Units Home Branch Discount Recurring Bill Email Gender Last Check-In Date ImageURI Created FirstName MiddleName LastName NickName Barcode MaritalStatus Race BirthDate Age HomeAddress HomeAddressLine2 HomeCity HomeState HomeZip PrimaryPhone AltPhone EmergencyPhone EmergencyContact CorporateID HealthPlanID Employer JobTitle BusinessAddress BusinessAddressLine2 BusinessCity BusinessState BusinessZip BusinessPhone AssociationEmployee Donor Volunteer BoardMember CampaignVolunteer CampaignProspect ReferralType HouseholdIncome YearsInCommunity HealthNeeds HomeOwner Interests VolunteerInterests BillingCycle Payment Type PrimaryMemberFirstName PrimaryMemberLastName PrimaryMemberBirthdate PrimaryMemberEmail PrimaryMemberAge Removed Columns Filtered Rows Youth (2 Max) Youth (3 Max) Removed Columns1 Filtered Rows1 monthly Removed Columns2 Merged Queries export Current active units 171 PrimaryMemberID Expanded export Current active units 171 Termination Date Discount Expires NextBillDate Recurring Member Pays Recurring Discount Amount Recurring Subsidy Amount Total Membership Amount Reordered Columns Merged Queries1 Unit ID Expanded export Current active units 1 Termination Date.1 Discount Expires.1 Renamed Columns Term date all discount expires all Reordered Columns1 Removed Columns3 Renamed Columns1 Monthly Amount to bill Reordered Columns2 Replaced Value Replaced Value1 Replaced Value2 Replaced Value3 Replaced Value4 Replaced Value5 Replaced Value6 Replaced Value7 Replaced Value8 Replaced Value9 Replaced Value10 Replaced Value11 Replaced Value12 Replaced Value13 Replaced Value14 Sorted Rows Replaced Value15 Replaced Value16 Two Senior Adult Household (65+) Two Senior Household Replaced Value17 Youth (1 Max) Youth Replaced Value18 Adult (26-64) Adult Replaced Value19 Senior Adult (65+) Senior Replaced Value20 Young Adult (18-25) Young Adult Duplicated Column Type - Copy Replaced Value21 Replaced Value22 Two Adult Household Reordered Columns3 Renamed Columns2 Category Replaced Value23 Added Custom Membership_Status Active Added Custom1 Start_Date 1/1/2020 Reordered Columns4 Added Custom2 Location Dahl Family YMCA Reordered Columns5 Renamed Columns3 End_Date Added Index Index Reordered Columns6 Added Prefix MM en-US Removed Columns4 Filtered Rows2 Removed Columns5 Filtered Rows3 Healthy Living Membership (User Code and Form Required before activation) Healthy Living Membership (User Code and Form Required before activation) 50% Flexible Pricing PROGRAM ONLY Healthy Living Membership 011 code only (User Code and Form Required before activation) La Crosse County Waiver La Crosse County Waiver 30% Flexible Pricing PROGRAM ONLY La Crosse County Waiver 40% Flexible Pricing PROGRAM ONLY La Crosse County Waiver 50% Flexible Pricing PROGRAM ONLY La Crosse County Waiver 70% Flexible Pricing PROGRAM ONLY La Crosse County Waiver 70% Flexible Pricing PROGRAM ONLY (formally 80%) La Crosse County Waiver 70% Flexible Pricing PROGRAM ONLY (formally 90%) Sorted Rows1 Added Index1 Index.1 Reordered Columns7 Added Prefix1 D Duplicated Column1 Discount - Copy Reordered Columns8 Renamed Columns4 Discount Type Replaced Value24 30% Flexible Pricing Percentage Replaced Value25 40% Flexible Pricing Replaced Value26 50% Flexible Pricing Replaced Value27 60% Flexible Pricing Replaced Value28 70% Flexible Pricing Replaced Value29 Percentage (formally 75%) Replaced Value30 Percentage (formally 80%) Replaced Value31 Percentage (formally 90%) Replaced Value32 Active Military 50% (Must reapply every 6 months) Replaced Value33 Percentage PROGRAM ONLY CW - Western Technical College (C-$76 Y-10) CW - Western Technical College (C-$76 Y-10) Replaced Value34 70% Flexible Pricing PROGRAM ONLY CW - Western Technical College (C-$76 Y-10) Replaced Value35 Dollar Replaced Value36 CW - 203 LLC (C-$14 young adult $20 family Y-$10) Replaced Value37 CW - Allergy Associates (C-$20 Y-$10) Replaced Value38 CW - Altra Credit Union - VISIT Replaced Value39 CW - Altra Federal Credit Union (C-$15 Y-$7.50) Filtered Rows5 70% Flexible Pricing PROGRAM ONLY La Crosse County Waiver Replaced Value40 CW - Associated Bank (Y-$8.33 C-reimburses employee directly) Replaced Value41 CW - Bangor School District (C-$10 Y-$5) Replaced Value42 CW - Brickl Bros. Inc. (C-$100% - Y-$10.00) Replaced Value43 CW - Chart Energy & Chemical (C-$8.33 Y-$4.17) Replaced Value44 CW - Citizens State Bank (C-$15 Y-$7.50) Replaced Value45 CW - CompRex LLC (C- varies depending on membership type Y-$10.00) Replaced Value46 CW - Dahl Automotive (C-$15 Y-$7.50) Replaced Value47 CW - Dairyland Power (C-$16.67 Y-$8.33) Replaced Value48 CW - Davy Engineering (C-$6.00 Y-$2.00) Replaced Value50 CW - Festival Foods Adult (Y-$4.17 C-reimburses employee directly $100) Replaced Value49 CW - Elevate Media (100% discount) Replaced Value51 CW - Festival Foods Family (Y-$6.00 C-reimburses employee $150 directly) Replaced Value52 CW - Gillette Pepsi (C-$15 Y-$7.50) Replaced Value53 CW - Governmental Employees Credit Union (G.E.C.U.) -- (C-50% Y-$10) Replaced Value54 CW - Inland Packaging (C-$8.33 Y-$4.17) Replaced Value55 CW - La Crosse Sign Company (C-50% Y-$10.00) Replaced Value56 CW - JF Brennan (C-$12.50 Y-$6.00) Replaced Value57 CW - L.B. White (C-$10 Y-$5) Replaced Value58 CW - Live Aligned (C- max $56 Y $10) Replaced Value59 CW - My Innovative Ser. (C-50% after 90 days employed Y-$10.00) Replaced Value60 CW - Morrie's LaCrosse Volkswagen / Audi (C-60% Y-$10.00) Replaced Value61 CW - Midwest Family Broadcasting (50% discount) Replaced Value62 CW - Neighborhood Family Clinics - (C-$50% Y-$10) Replaced Value63 CW - Northwestern Mutual (C-$20 Y-$10) Replaced Value64 CW - River Architects (C-$20 Y-$10) Replaced Value65 CW - River Bank (C-$10 Y-$5) Replaced Value66 CW - Rivoli21 LLC d.b.a. Rivoli Theatre (C-$100% - Y-$10.00) Replaced Value67 CW - S & S Cycle (C-$10 Y-$4.17) Replaced Value68 CW - Schneider Heating/AC (C-$18 Y-$9) Replaced Value69 CW - The Insurance Center (C-$5 Y-$2.50) Replaced Value70 CW - Vendi Advertising (C-12.50 Y-$6) Replaced Value71 CW - Viking Electric Supply (Y-$8.33) Replaced Value72 CW - WKBT News 8 (50%) Replaced Value73 CW - WXOW TV 19 ($56.00 discount. Must have letter from Dave Booth) Replaced Value74 Dollar Percentage PROGRAM ONLY Replaced Value75 Dollar (formally 90%) Replaced Value76 CW - Yahnke Dental (C-$46 Y-$6) Replaced Value77 Child Care Center - Family (50% discount) Replaced Value78 College Membership (50% off) Replaced Value79 DARE Discount (25% off one youth type. Must present proof) Replaced Value80 Deployed Military Family (100%. Must show deployment papers) Replaced Value81 Employee - Full-Time Exempt (directors) Replaced Value82 Employee - Full-Time Hourly Replaced Value83 Percentage Percentage PROGRAM ONLY Replaced Value84 Employee - Part-Time Replaced Value85 Replaced Value86 Replaced Value87 Employee - Retired (100% discount. Need HR approval) Replaced Value88 Gundersen Onalaska PT Replaced Value89 Internal Membership Referral Replaced Value90 Military (50% off while applying for DOD Military Outreach Membership) Replaced Value91 Military (6 months at 50%for Title 32) Replaced Value92 Project Live/Onability Replaced Value93 Renew Active (100% Discount) Filtered Rows7 Maple Leaf 2021 Filtered Rows6 Inclusa (Ask have you been authorized by your care team?) Replaced Value94 School Age Care - Family Membership (25% discount) Replaced Value95 Silver & Fit (100% Discount) Replaced Value96 Senior Preferred Filtered Rows8 Tai Chi Veterans Group (8 Week 100%) Reordered Columns9 Added Custom3 Custom Duplicated Column2 Custom - Copy Duplicated Column3 Custom - Copy - Copy Duplicated Column4 Custom - Copy - Copy - Copy Reordered Columns10 smile love let Source = Excel.Workbook(File.Contents() null true) # Source{Item=Kind=}Data Table.PromoteHeaders(# PromoteAllScalars=true) Table.TransformColumnTypes(#{{ Int64.Type} { type text} number} datetime} date} any} Int64.Type}}) Table.RemoveColumns(#{ }) Table.SelectRows(# each (Type <> and Type )) (BillingCycle Table.NestedJoin(#{}#{}JoinKind.LeftOuter) Table.ExpandTableColumn(# } Table.ReorderColumns(#{ Table.RenameColumns(#{{ }}) Table.ReplaceValue(##date(2024 4 12)#date(2024 1)Replacer.ReplaceValue{}) 7)#date(2024 6)#date(2024 5)#date(2024 3 15)#date(2024 9)#date(2024 4)#date(2024 2)#date(2024 14)#date(2024 13)#date(2024 3)#date(2024 11)#date(2024 10)#date(2024 25)#date(2024 Table.Sort(#{{ Order.Ascending}}) 8)#date(2024 Table.ReplaceValue(#Replacer.ReplaceText{}) Table.DuplicateColumn(# ) Table.AddColumn(# Table.AddIndexColumn(# 1 1) Table.TransformColumns(# {{ & Text.From(_ text}}) Table.RemoveColumns(#{}) (Discount null)) Discount Discount Type "") }) in