<< [[resource/dailies/24-05-27|prev]] [[resource/dailies/24-05-29|next]] >>
## Work
[[resource/sprints/meet - 24-05-28 - sprint standup]]
- [x] commute to d:240528 s:0618 etc:5 t:62
- [x] commute back d:240528 s:1607 etc:5 t:66
- [x] plan d:240528 s:0729 etc:5 t:9
- [x] comm, teams d:240528 s:1547 etc:5 t:18
- [x] qb, prod support d:240528 s:0821 etc:5 t:5
- [x] aca, prod s d:240528 s:1553 etc:5 t:6
- resend 72481 payroll data
```sql
select * from SyncStreamPayrollTable
update SyncStreamPayrollTable set PayrollRecordSent = null
where (accountNumber = 50040 and [Work Ending Date] = '5-3-2024') or
(accountNumber = 43040 and [Work Ending Date] = '12-15-2023') or
(accountNumber = 43040 and [Work Ending Date] = '2-9-2024') or
(accountNumber = 43040 and [Work Ending Date] = '3-8-2024') or
(accountNumber = 43040 and [Work Ending Date] = '4-5-2024') or
(accountNumber = 43040 and [Work Ending Date] = '4-19-2024') or
(accountNumber = 43040 and [Work Ending Date] = '5-3-2024') or
(accountNumber = 9000 and [Work Ending Date] = '4-18-2024') or
(accountNumber = 9000 and [Work Ending Date] = '4-20-2024') or
(accountNumber = 5040 and [Work Ending Date] = '5-3-2024') or
(accountNumber = 11240 and [Work Ending Date] = '4-5-2024') or
(accountNumber = 11240 and [Work Ending Date] = '4-19-2024') or
(accountNumber = 11240 and [Work Ending Date] = '3-22-2024') or
(accountNumber = 11240 and [Work Ending Date] = '3-8-2024') or
(accountNumber = 11240 and [Work Ending Date] = '4-20-2024') or
(accountNumber = 11240 and [Work Ending Date] = '4-6-2024') or
(accountNumber = 11240 and [Work Ending Date] = '3-23-2024') or
(accountNumber = 11240 and [Work Ending Date] = '3-9-2024') or
(accountNumber = 73180 and [Work Ending Date] = '4-26-2024') or
(accountNumber = 73180 and [Work Ending Date] = '5-10-2024') or
(accountNumber = 59125 and [Work Ending Date] = '4-27-2024') or
(accountNumber = 81040 and [Work Ending Date] = '8-31-2023') or
(accountNumber = 78100 and [Work Ending Date] = '2-23-2024') or
(accountNumber = 9050 and [Work Ending Date] = '4-26-2024') or
(accountNumber = 40020 and [Work Ending Date] = '5-3-2024') or
(accountNumber = 10025 and [Work Ending Date] = '5-3-2024') or
(accountNumber = 29000 and [Work Ending Date] = '3-8-2024') or
(accountNumber = 38100 and [Work Ending Date] = '2-16-2024') or
(accountNumber = 38100 and [Work Ending Date] = '2-2-2024') or
(accountNumber = 63130 and [Work Ending Date] = '3-8-2024') or
(accountNumber = 47070 and [Work Ending Date] = '1-31-2022') or
(accountNumber = 47070 and [Work Ending Date] = '2-15-2022') or
(accountNumber = 47070 and [Work Ending Date] = '2-28-2022') or
(accountNumber = 47070 and [Work Ending Date] = '3-15-2022') or
(accountNumber = 47070 and [Work Ending Date] = '3-31-2022') or
(accountNumber = 47070 and [Work Ending Date] = '5-31-2022') or
(accountNumber = 47070 and [Work Ending Date] = '6-15-2022') or
(accountNumber = 47070 and [Work Ending Date] = '8-31-2022') or
(accountNumber = 47070 and [Work Ending Date] = '9-15-2022') or
(accountNumber = 47070 and [Work Ending Date] = '9-30-2022') or
(accountNumber = 47070 and [Work Ending Date] = '10-31-2022') or
(accountNumber = 47070 and [Work Ending Date] = '11-15-2022') or
(accountNumber = 47070 and [Work Ending Date] = '11-30-2022') or
(accountNumber = 47070 and [Work Ending Date] = '12-15-2022') or
(accountNumber = 47070 and [Work Ending Date] = '1-31-2023') or
(accountNumber = 47070 and [Work Ending Date] = '2-15-2023') or
(accountNumber = 47070 and [Work Ending Date] = '2-28-2023') or
(accountNumber = 47070 and [Work Ending Date] = '3-15-2023') or
(accountNumber = 47070 and [Work Ending Date] = '3-31-2023') or
(accountNumber = 47070 and [Work Ending Date] = '5-15-2023') or
(accountNumber = 47070 and [Work Ending Date] = '5-31-2023') or
(accountNumber = 47070 and [Work Ending Date] = '10-31-2023') or
(accountNumber = 47070 and [Work Ending Date] = '11-15-2023') or
(accountNumber = 47070 and [Work Ending Date] = '11-30-2023') or
(accountNumber = 47070 and [Work Ending Date] = '12-15-2023') or
(accountNumber = 47070 and [Work Ending Date] = '1-31-2024') or
(accountNumber = 47070 and [Work Ending Date] = '2-15-2024') or
(accountNumber = 47070 and [Work Ending Date] = '2-29-2024') or
(accountNumber = 47070 and [Work Ending Date] = '3-15-2024') or
(accountNumber = 47070 and [Work Ending Date] = '4-15-2024') or
(accountNumber = 70190 and [Work Ending Date] = '4-24-2024') or
(accountNumber = 34000 and [Work Ending Date] = '2-24-2024') or
(accountNumber = 51045 and [Work Ending Date] = '3-1-2024') or
(accountNumber = 40040 and [Work Ending Date] = '5-8-2024') or
(accountNumber = 50140 and [Work Ending Date] = '4-5-2024') or
(accountNumber = 5070 and [Work Ending Date] = '5-2-2024') or
(accountNumber = 61060 and [Work Ending Date] = '3-2-2024') or
(accountNumber = 23080 and [Work Ending Date] = '5-3-2024') or
(accountNumber = 13120 and [Work Ending Date] = '5-3-2024') or
(accountNumber = 78080 and [Work Ending Date] = '3-1-2024') or
(accountNumber = 50030 and [Work Ending Date] = '5-10-2024') or
(accountNumber = 62090 and [Work Ending Date] = '5-3-2024') or
(accountNumber = 75070 and [Work Ending Date] = '4-26-2024') or
(accountNumber = 75070 and [Work Ending Date] = '4-12-2024') or
(accountNumber = 35040 and [Work Ending Date] = '4-28-2024') or
(accountNumber = 99980 and [Work Ending Date] = '1-29-2020') or
(accountNumber = 99980 and [Work Ending Date] = '11-3-2021') or
(accountNumber = 99980 and [Work Ending Date] = '1-25-2022') or
(accountNumber = 99980 and [Work Ending Date] = '6-17-2022') or
(accountNumber = 99980 and [Work Ending Date] = '11-16-2022') or
(accountNumber = 99980 and [Work Ending Date] = '3-16-2023') or
(accountNumber = 99980 and [Work Ending Date] = '10-27-2022') or
(accountNumber = 99980 and [Work Ending Date] = '10-7-2020') or
(accountNumber = 99980 and [Work Ending Date] = '11-10-2022') or
(accountNumber = 99980 and [Work Ending Date] = '6-30-2021') or
(accountNumber = 99980 and [Work Ending Date] = '7-20-2023') or
(accountNumber = 99980 and [Work Ending Date] = '6-3-2020') or
(accountNumber = 99980 and [Work Ending Date] = '3-9-2022') or
(accountNumber = 99980 and [Work Ending Date] = '2-24-2021') or
(accountNumber = 99980 and [Work Ending Date] = '2-10-2021') or
(accountNumber = 99980 and [Work Ending Date] = '11-2-2022') or
(accountNumber = 99980 and [Work Ending Date] = '9-23-2020') or
(accountNumber = 99980 and [Work Ending Date] = '3-2-2023') or
(accountNumber = 99980 and [Work Ending Date] = '10-20-2021') or
(accountNumber = 99980 and [Work Ending Date] = '6-2-2021') or
(accountNumber = 99980 and [Work Ending Date] = '2-20-2022') or
(accountNumber = 99980 and [Work Ending Date] = '10-13-2022') or
(accountNumber = 99980 and [Work Ending Date] = '6-29-2022') or
(accountNumber = 99980 and [Work Ending Date] = '7-6-2023') or
(accountNumber = 99980 and [Work Ending Date] = '5-20-2020') or
(accountNumber = 99980 and [Work Ending Date] = '6-16-2021') or
(accountNumber = 99980 and [Work Ending Date] = '3-18-2022') or
(accountNumber = 99980 and [Work Ending Date] = '1-27-2021') or
(accountNumber = 99980 and [Work Ending Date] = '2-16-2023') or
(accountNumber = 99980 and [Work Ending Date] = '2-23-2022') or
(accountNumber = 99980 and [Work Ending Date] = '1-15-2020') or
(accountNumber = 99980 and [Work Ending Date] = '10-6-2021') or
(accountNumber = 99980 and [Work Ending Date] = '4-13-2022') or
(accountNumber = 99980 and [Work Ending Date] = '9-9-2020') or
(accountNumber = 99980 and [Work Ending Date] = '6-15-2022') or
(accountNumber = 99980 and [Work Ending Date] = '9-29-2022') or
(accountNumber = 99980 and [Work Ending Date] = '5-19-2021') or
(accountNumber = 99980 and [Work Ending Date] = '5-6-2020') or
(accountNumber = 99980 and [Work Ending Date] = '2-9-2022') or
(accountNumber = 99980 and [Work Ending Date] = '6-22-2023') or
(accountNumber = 99980 and [Work Ending Date] = '2-2-2023') or
(accountNumber = 99980 and [Work Ending Date] = '10-19-2022') or
(accountNumber = 99980 and [Work Ending Date] = '1-13-2021') or
(accountNumber = 99980 and [Work Ending Date] = '9-3-2022') or
(accountNumber = 99980 and [Work Ending Date] = '1-1-2020') or
(accountNumber = 99980 and [Work Ending Date] = '8-26-2020') or
(accountNumber = 99980 and [Work Ending Date] = '9-22-2021') or
(accountNumber = 99980 and [Work Ending Date] = '5-25-2023') or
(accountNumber = 99980 and [Work Ending Date] = '5-5-2021') or
(accountNumber = 99980 and [Work Ending Date] = '5-9-2022') or
(accountNumber = 99980 and [Work Ending Date] = '6-1-2022') or
(accountNumber = 99980 and [Work Ending Date] = '4-22-2020') or
(accountNumber = 99980 and [Work Ending Date] = '6-4-2022') or
(accountNumber = 99980 and [Work Ending Date] = '12-30-2020') or
(accountNumber = 99980 and [Work Ending Date] = '1-26-2022') or
(accountNumber = 99980 and [Work Ending Date] = '9-8-2021') or
(accountNumber = 99980 and [Work Ending Date] = '1-19-2023') or
(accountNumber = 99980 and [Work Ending Date] = '10-5-2022') or
(accountNumber = 99980 and [Work Ending Date] = '5-18-2022') or
(accountNumber = 99980 and [Work Ending Date] = '4-21-2021') or
(accountNumber = 99980 and [Work Ending Date] = '12-29-2021') or
(accountNumber = 99980 and [Work Ending Date] = '5-11-2023') or
(accountNumber = 99980 and [Work Ending Date] = '4-8-2020') or
(accountNumber = 99980 and [Work Ending Date] = '1-12-2022') or
(accountNumber = 99980 and [Work Ending Date] = '1-5-2023') or
(accountNumber = 99980 and [Work Ending Date] = '12-16-2020') or
(accountNumber = 99980 and [Work Ending Date] = '2-7-2022') or
(accountNumber = 99980 and [Work Ending Date] = '6-30-2022') or
(accountNumber = 99980 and [Work Ending Date] = '9-21-2022') or
(accountNumber = 99980 and [Work Ending Date] = '8-25-2021') or
(accountNumber = 99980 and [Work Ending Date] = '5-4-2022') or
(accountNumber = 99980 and [Work Ending Date] = '3-5-2022') or
(accountNumber = 99980 and [Work Ending Date] = '4-20-2022') or
(accountNumber = 99980 and [Work Ending Date] = '4-7-2021') or
(accountNumber = 99980 and [Work Ending Date] = '3-25-2020') or
(accountNumber = 99980 and [Work Ending Date] = '8-21-2022') or
(accountNumber = 99980 and [Work Ending Date] = '3-11-2020') or
(accountNumber = 99980 and [Work Ending Date] = '4-27-2023') or
(accountNumber = 99980 and [Work Ending Date] = '12-15-2021') or
(accountNumber = 99980 and [Work Ending Date] = '1-11-2023') or
(accountNumber = 99980 and [Work Ending Date] = '12-2-2020') or
(accountNumber = 99980 and [Work Ending Date] = '12-22-2022') or
(accountNumber = 99980 and [Work Ending Date] = '9-7-2022') or
(accountNumber = 99980 and [Work Ending Date] = '8-31-2023') or
(accountNumber = 99980 and [Work Ending Date] = '4-13-2023') or
(accountNumber = 99980 and [Work Ending Date] = '2-26-2020') or
(accountNumber = 99980 and [Work Ending Date] = '3-24-2021') or
(accountNumber = 99980 and [Work Ending Date] = '12-1-2021') or
(accountNumber = 99980 and [Work Ending Date] = '12-28-2022') or
(accountNumber = 99980 and [Work Ending Date] = '3-31-2022') or
(accountNumber = 99980 and [Work Ending Date] = '9-16-2022') or
(accountNumber = 99980 and [Work Ending Date] = '8-10-2022') or
(accountNumber = 99980 and [Work Ending Date] = '11-18-2020') or
(accountNumber = 99980 and [Work Ending Date] = '8-24-2022') or
(accountNumber = 99980 and [Work Ending Date] = '4-26-2022') or
(accountNumber = 99980 and [Work Ending Date] = '12-8-2022') or
(accountNumber = 99980 and [Work Ending Date] = '4-6-2022') or
(accountNumber = 99980 and [Work Ending Date] = '8-17-2023') or
(accountNumber = 99980 and [Work Ending Date] = '11-30-2022') or
(accountNumber = 99980 and [Work Ending Date] = '3-30-2023') or
(accountNumber = 99980 and [Work Ending Date] = '3-10-2021') or
(accountNumber = 99980 and [Work Ending Date] = '12-14-2022') or
(accountNumber = 99980 and [Work Ending Date] = '2-12-2020') or
(accountNumber = 99980 and [Work Ending Date] = '10-21-2020') or
(accountNumber = 99980 and [Work Ending Date] = '9-15-2023') or
(accountNumber = 99980 and [Work Ending Date] = '11-17-2021') or
(accountNumber = 99980 and [Work Ending Date] = '11-4-2020') or
(accountNumber = 99980 and [Work Ending Date] = '7-27-2022') or
(accountNumber = 99980 and [Work Ending Date] = '11-24-2022') or
(accountNumber = 99980 and [Work Ending Date] = '6-17-2020') or
(accountNumber = 99980 and [Work Ending Date] = '8-3-2023') or
(accountNumber = 99980 and [Work Ending Date] = '5-22-2022') or
(accountNumber = 99980 and [Work Ending Date] = '3-23-2022')
```
- [x] sprint d:240528 s:1043 etc:5 t:3
- [x] qb, ml #leadGeneration , meet d:240528 s:0905 etc:5 t:99
- what are the target metrics
- #leadGeneration/inputs user ranked chance of success
- will need to define the bands ourselves, how many bands do you want
- estimated profitability -> version2
- the more standard the process, the more accurate the results #important
- how much does process modification impact the model success
- do you want to get recommendations about other sales techniques? e.g. number of calls, specific AE to decision maker interactions, type of interaction (in person, call, email), how does pushing a specific carrier impact success.
- how important is estimated profitability in decision making #leadGeneration/questions
- should we focus on LOB quoting success/failure or specific plan quoting success/failure #leadGeneration/questions
- what operational data: AE, geography? what aspects define a school
- how do we enter temporal data?
- assumptions
- only look at complete quotes?
- example
- [quoted 3 plans and chose 1](https://quotebook.setseg.org/QuoteBook/plans/list/411/vision/1236)
- 1 view for all the inputs
- 1 record per: quoted lob
- time stamped at time of quote creation
- semi-failure = changes in plans for quoting
- #laurenPickelman do we make changes to pitch mid quote to improve a sale likelihood. e.g modifying plan parameters, adding carriers, adjusting plans in anyway
- certain quote processes give better results
- feature change in plan with combining or breaking out segments = group wide change (y/n) #leadGeneration/questions
- MVP is correlation matrix
- rope #arashAlam in after I have the quote lob - success view
- active product lines, length of product
- AE, hard cap
- active plan details
- fte, tiv
- [x] sd d:240528 s:0806 etc:5 t:14
- Delete Processed CLaims Files -> ran successfully since, intermittent issues
- (EB) Online Enrollment Tracker
- QB OE Data to CRM
- Call SSIS GCM Manual Membership
**sprint** ![[resource/weeklies/24-05-20 to 24-06-02.md#Sprint Todos]]
## Personal
promoting thoughts:: #whatDoesThisPersonNeedRightNow #solutionOrient #howCouldISayThisKinder #beSorry #dontTakeOfffense #focusOnProgress #loveYourSuffering #validateAndConnect #assumeContentedness
priorities:: #financialFreedom #innerHarmony #family #physicalHealth #social
#affirmations::
- I embody a positive and supportive attitude that empowers those around me [[affirmations#^2378d7]]
- [x] [[ingest text and call data]] d:240528 s:0737 etc:5 t:12
- [x] pull conversation range from texts for therapy d:240528 s:0826 etc:15 t:28
- #ai/goodUse/softwareDevelopment obsidian [chatGPT 4o](https://chatgpt.com/share/02fff576-b17f-45b6-bd7c-fc574267a8f1)
- [[person date text filter]]
- [x] fix obsidian git d:240528 s:1056 etc:5 t:40
- #ai/debugging/bad [chatgpt 4o](https://chatgpt.com/share/02c0b44e-a3e5-41ad-9265-ec67042cbf68)
- re-cloned repo and copied over existing folder
- sync took a little bit of work
- [x] games d:240528 s:1109 etc:5 t:20
- [x] nap d:240528 s:1209 etc:5 t:24
### Daily Habits
- [x] review soc d:240529 s:1545 etc:20 t:10
- [x] [[daily snapshot]] d:240529 s:1545 etc:5 t:1
- ![[daily snapshot 24-05-27.png]]
- Fighting. Pictured here is Charlie's staticky hair after trying out the inflatable couch. The kids took 5 minutes of trying to share this before starting to fight and me putting it away.
- [x] stl, n, f, black d:240528 s:0551 etc:6 t:5
#### Solo Morning
- [x] drink fiber water d:240528 s:0510
- [x] daily promotions, priorities, and affirmations d:240528 s:0525 etc:5 t:13
- [x] shower etc:12
- [x] meds, 2 visbiome etc:1 d:240528 s:0530
#### Family Morning
- [x] eat, oatmeal
- [x] meds: 10mg Escitalopram d:240528 s:0615
- [x] vitamins: 450mcg A, 900mg C, 150mcg D3,15mg E, 11mg Zinc d:240528 s:0615
weekly![[resource/weeklies/24-05-20 to 24-06-02.md#Personal Todos]]
## Stream of Consciousness
- Dad conversation
- large audience, hold attention and send message to those who don't understand or not in the mindset
- if you were starting out in your career what advice would you give yourself about how to gain and hold the attention of a diverse group of people?
- nature based retreats find an audience that can speak on the same issue reasonably well. Familiar lingo industry
- keep a group's attention. What is your base audience into Dave Ramsey those who want to mind their money
- educator before entertainer
- Dave Ramsey jr.
- dads developed the relationship between money and work at 10 with a paper route for a paper called `Grit`. People bought paper because they saw a kid trying to do something. An old lady across town wanted to talk. He played with trains at another guy's house. He was selling himself as much as the paper #dad/childhood
- grandad and dad went on business sales trips. Customer said they like doing business with Dad. Dad said can you say why. customer said Jeff we can trust you if you say you'll do something you'll try your hardest. dad said It dawned on me I don't have to be the best I just have to be honest and put in the work.
- Johnny held firm to a 2 month job quote when pressed by a customer who said a competitor in Canada could do a job in 6 weeks. The Canada company took 3 months and the customer came back promised a stable relationship with Valley.
- dad said you don't have to be the smartest but you do need integrity can get away 1 or 2 times but after that your done.
- dad was too customer focused
- dad broke down when a customer pushed way way too hard. He got helped from from his team. Johnny said firstly your not gonna talk to my brother anymore, secondly here is when we can have this order out. The customer agreed without a fight and dad was flabbergasted #dad/history #mentalHealth
- I don't want to disappoint people. Dad will work harder rather than miss a deadline
- harsh inner critic dad says this is the devil
- belief vs. faith dad doesn't see a difference
- surrender the outcome to the relationship with God or self
- the spirit is within us and Dad and I are talking about the same thing now.
## Records
emotions::{"time":"5:12","valence":52,"arousal":46,"emotions":[]}