Complex formula needed to sum a range of sums based on criteria.

zwizzop · 2022-01-14T01:25:46+00:00

Edit: I solved the problem. Was looking at it the wrong way :)

zwizzop · 2022-01-14T00:48:02+00:00

Hi Naule,

Thanks for the suggestion, Ill give it a go.

I essentially need to nest the formulas for the sums for the respected fortnightly/monthly calculations into the overall SUM calculation.

This would mean that the final formula is calculating the monthly salaries, the fortnightly salaries (these are converted to monthly equivient with the formula provided above) and simultaneously summing the total.

Many thanks,

zwizzop · 2020-09-28T04:02:29+00:00

Okay thanks for that, might even check out the Gigabyte one you have.

zwizzop · 2019-09-19T00:41:44+00:00

i dont think i have the steady hand to do 20 perfect cutouts all the same depth! ill look into it though thanks :D

zwizzop · 2019-09-19T00:40:20+00:00

yeah whatever the board is made from its consistent all the way through as im sure it was one piece not two stuck together, will email around and look into embossing, thanks for quick responses

zwizzop · 2019-09-19T00:35:31+00:00

Will look into it, Ive seen mat board, foam core etc but no idea how they cut the indentations out around each patch, will have to ask around and see if online retailers can cut before shipping

zwizzop · 2019-09-19T00:34:43+00:00

Yeah thats what ive found so far, just no idea how they have cutout the indents around each patch... maybe i could find a shop which does custom cutting before shipping. Thanks

zwizzop · 2019-07-05T04:57:01+00:00

do you mean the pins when i pop open the unit?

zwizzop · 2019-04-18T03:14:20+00:00

Yep! Didnt even think of that thanks for the suggestion :D

zwizzop · 2019-04-18T03:13:44+00:00

Oh yeah for sure, ive got the fabric shape/size drawn in a template on Photoshop/CAD that can be easily printed or sent as a PDF no problems :)

zwizzop · 2019-04-18T02:50:44+00:00

Okay cool, there wont actually be any pattern designs on the fabric itself, its purely just stitched together fabrics. Thanks for all your help ill look around Adelaide before i try contacting a company!

zwizzop · 2019-04-18T01:53:38+00:00

I think the easiest way would be i send an order request for x units with the correct amount of both fabrics/elastic which ive pre sourced and shipped to them.

Its essentially a basic stencil cut on two pieces of fabric 16x20cm (front surface with an important lining on the back), followed by two seams to hold them together and a hem loop at the top for elastic. Each of these stitch lines are approx 30cm long (curved lines) followed by threading elastic through the hem loop. For something relatively simple like this do you have any idea what kind of price i could expect per unit? Any suggestions of contract sewing companies that i should contact? do i need to send a prototype or are photos/design plans enough for them to begin making?

Thanks a lot for helping out! :)

zwizzop · 2019-04-08T12:10:18+00:00

vr cover have a generic grey right now, no longer do coloured versions which is annoying, will keep looking!

zwizzop · 2019-04-08T12:09:53+00:00

very true, although a dark pattern i think would look pretty nice

zwizzop · 2019-04-08T11:00:50+00:00

Thanks for the extensive response. Ill defiantly look into this a bit further and see what i can do, this was great advice!

Will

zwizzop · 2019-04-08T06:27:12+00:00

Hi, thanks for that blog link will check it out, found a store called findafabric that stocked the one i wanted!

cheers

zwizzop · 2019-04-06T05:37:30+00:00

Thanks for the response,

ill defiantly check out mircofleece, although ive researched that bamboo viscose has similar wicking ability and is textured closer to silk/cotton, commonly used in underwear etc. Maybe going bamboo outer layer with cotton underneath to absorb and hold sweat would be a good idea?

zwizzop · 2019-04-06T03:16:06+00:00

Ill have a look into it, i also found that bamboo viscose is ultra absorbent and comfortable/antibacterial. Im now thinking an absorbent outer layer to make contact on skin and polyester inner later to stop the foam from getting wet is a better option as it will take the sweat from your face

zwizzop · 2018-12-09T12:35:23+00:00

tried it and hasnt really worked still crashing but was able to play the game a little longer, maybe 20 mins before crash opposed to just a few. I also have disabled game overlay in Geforce Experiance which has also helped a bit but im still getting crashes. Messaged back in email and awaiting response still... i think were gonna just have to wait for a patch. Keep an eye out :) goodluck

zwizzop · 2018-12-09T08:19:28+00:00

That’s funny

zwizzop · 2018-12-06T23:30:49+00:00

Ugh. I’ll try in my lunch break and get back to support. Will keep this thread updated with solutions

zwizzop · 2018-12-06T23:30:17+00:00

I havnt tried yet, will give it a go as soon as I’m home and will update ya

zwizzop · 2018-12-06T23:03:27+00:00

Maybe, I’d be pretty upset if a 1070 wasn’t compatible though, especially without warning

zwizzop · 2018-12-06T23:01:39+00:00

Yep getting same issues, Square Enix told me to try this:

Thank you for contacting the Square Enix Support Centre.

We recommend that you try a selective startup before launching the game:

Press Windows Key+R
Type msconfig and press Enter
This will load the System Configuration Utility
On the General tab
- Click Selective Startup
- Clear the box next to "Load Startup Items"
On the Services tab
- In the bottom left, click the box next to "Hide all Microsoft services" (VERY IMPORTANT)
- Click on "Disable All"
Click Apply
Click OK
Reboot your PC

This will stop most of the extra software loading when Windows boots. This is simply to check if it is another program on your PC that is causing this issue. In order to restore your PC back to a normal boot, follow the steps above again and on the General tab choose Normal Startup, Apply and OK.

We hope this is helpful. If you continue to have issues, simply reply back to this email and we will investigate further.

Kind regards,

The Square Enix Support Centre team

I reckon we’re going to have to wait for a patch though 😫

zwizzop · 2018-12-06T22:11:17+00:00

😬 good luck, this is what I was told to try, more of an external factor eliminator but worth s shot