They decided to start a war knowing their defensive tools were already critically low... Was the plan really all just hubris thinking Iran would just rollover in 24 hours? Even a child playing a FPS knows to reload their weapon before going on the attack.
I don't think I am capable of understanding the mindset of seeing Trump and how little he has given to his supporters and the clear damage he is doing across everything, being on the outside and thinking "I want that."
I can understand experiencing hard times and wanting change, but to look at Trumpism and see it as an oasis I cannot understand. What do they have that you want? What do you think he will offer you that he won't rescind?
None of these were really helpful or achieved what i needed. Articles weren't clear on how to apply these functions to datasets that weren't perfect matches to the examples shown.
Essentially, i want to merge all duplicates of project id, task name, task start date, task end date into a single row with the hours being a total of each duplicate row
I had to make my drop down list data a table in the other sheet, and then in the cell i wanted to be the relative drop down i did Data Validation > List and within source i entered =INDIRECT("TaskLists[" & $K2 & "]") referencing the table i created.
I tend to lean towards it being humidity since we have only noticed it happened in the last couple of weeks where temperatures in this area are higher than normal, humid and our AC has not been working for months (just had it repaired today).
Yeah i think the format of the sheet I was using was out of whack based on all my attempts at correcting it, I was able to paste into a brand new sheet and got the results I needed using another users suggestion of =TEXT(B2, "0.000") which was a success! Thanks for the guidance!
yeah it absolutely has to have the .000 because it will be using that to reference another database to sync based on that client id. How do I convert numbers to strings?
Not coming off as obtuse, and i'll try my best to explain the issue but I do understand what you are saying.
The goal is I am doing an import of clients into our system for an integration so the info syncs correctly and we sync using the Client ID, which is case sensitive.
When I imported the data into my system, i want to import the Client ID - 1105416.000 (what i see in the cell). When using my importer tool to match the corresponding fields in our system with the field in the spreadsheet, the value example the importer tool is showing is Client ID - 1105416, which is incorrect. I ran a small sample to test and it imported as 1105416, but it has to be 1105416.000
Awesome, did more digging and it turns out it's an HRV and likely not something I need to be running during the summer months as I don't need more warm air circulating and we keep windows open often enough to naturally exchange the air.
Unfortunately with the house layout there isn't a good spot to put a fan at the top of the stairs as it will block the narrow hallway that exists between the bedrooms as well can't put it on the stairs because they are spiral.
Yeah not the most handy person and electrical freaks me out so expecting the higher cost of having a professional do it but luckily where i live (Canada) there are federal programs that offer rebates on things like this if the options we choose are eco friendly so, might be expensive but we should get money back providing we follow the regulations.
Yeah I think the split isn't enough for the house, not sure how they withstood the humid temperatures through the summer, especially the kids rooms. Can't see how many BTU's the current system is but probably going to need to upgrade that unit and add more wall units. Unsure what to do about the kids rooms at night though with there doors closed there is no way the cold air will get in and a fan will only push the hot air around. We have a portable AC that looks like a mini-fridge, but my concern is leaving that in room with the toddler as I want to avoid an accident of it falling onto her.
Ah good point, I didn't think of the consequences of mixing the different air temperatures through the ducts. Ideally I would like to avoid blowing mold all throughout my children's bedrooms.
They decided to start a war knowing their defensive tools were already critically low... Was the plan really all just hubris thinking Iran would just rollover in 24 hours? Even a child playing a FPS knows to reload their weapon before going on the attack.
I don't think I am capable of understanding the mindset of seeing Trump and how little he has given to his supporters and the clear damage he is doing across everything, being on the outside and thinking "I want that."
I can understand experiencing hard times and wanting change, but to look at Trumpism and see it as an oasis I cannot understand. What do they have that you want? What do you think he will offer you that he won't rescind?
Thanks! Just bought a Bissell Little Green pro heat cleaner on sale to tackle this.
Is there any tutorial you can link me to better understand this process? Unsure what VBA is.
None of these were really helpful or achieved what i needed. Articles weren't clear on how to apply these functions to datasets that weren't perfect matches to the examples shown.
Essentially, i want to merge all duplicates of project id, task name, task start date, task end date into a single row with the hours being a total of each duplicate row
I figured it out!
I had to make my drop down list data a table in the other sheet, and then in the cell i wanted to be the relative drop down i did Data Validation > List and within source i entered =INDIRECT("TaskLists[" & $K2 & "]") referencing the table i created.
Yeah it goes back in place and fits perfectly once i push it back into place. I'll go the glue and nail route. Thanks!
I tend to lean towards it being humidity since we have only noticed it happened in the last couple of weeks where temperatures in this area are higher than normal, humid and our AC has not been working for months (just had it repaired today).
This worked exactly as I needed it to. Thanks so much!
Yeah i think the format of the sheet I was using was out of whack based on all my attempts at correcting it, I was able to paste into a brand new sheet and got the results I needed using another users suggestion of =TEXT(B2, "0.000") which was a success! Thanks for the guidance!
yeah it absolutely has to have the .000 because it will be using that to reference another database to sync based on that client id. How do I convert numbers to strings?
Not coming off as obtuse, and i'll try my best to explain the issue but I do understand what you are saying.
The goal is I am doing an import of clients into our system for an integration so the info syncs correctly and we sync using the Client ID, which is case sensitive.
When I imported the data into my system, i want to import the Client ID - 1105416.000 (what i see in the cell). When using my importer tool to match the corresponding fields in our system with the field in the spreadsheet, the value example the importer tool is showing is Client ID - 1105416, which is incorrect. I ran a small sample to test and it imported as 1105416, but it has to be 1105416.000
ChatGPT gave me the same suggestion but didn't fix the issue.
Awesome, did more digging and it turns out it's an HRV and likely not something I need to be running during the summer months as I don't need more warm air circulating and we keep windows open often enough to naturally exchange the air.
Unfortunately with the house layout there isn't a good spot to put a fan at the top of the stairs as it will block the narrow hallway that exists between the bedrooms as well can't put it on the stairs because they are spiral.
Yeah not the most handy person and electrical freaks me out so expecting the higher cost of having a professional do it but luckily where i live (Canada) there are federal programs that offer rebates on things like this if the options we choose are eco friendly so, might be expensive but we should get money back providing we follow the regulations.
Yeah I think the split isn't enough for the house, not sure how they withstood the humid temperatures through the summer, especially the kids rooms. Can't see how many BTU's the current system is but probably going to need to upgrade that unit and add more wall units. Unsure what to do about the kids rooms at night though with there doors closed there is no way the cold air will get in and a fan will only push the hot air around. We have a portable AC that looks like a mini-fridge, but my concern is leaving that in room with the toddler as I want to avoid an accident of it falling onto her.
Ah good point, I didn't think of the consequences of mixing the different air temperatures through the ducts. Ideally I would like to avoid blowing mold all throughout my children's bedrooms.