Formula's for Pain Gain Calculations NEC

Hi, I have been tasked with completing a pain gain share for my client and looking to have something like the below link.

however struggling to get the ranges and was wondering if anyone had any tips


Need to make an excel sheet like the below link
http://widgets.builtintelligence.com/nec3-calc/

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

	C	D	E	F	G	H	I	J	K
18			1. Total Price	$ 1,000,000
19			2. Final PWDD	$ 1,400,000
20			Saving	$ -
21			Overrun	$ (400,000)
22							Data Table
23	From	3. To	4. Share %	Amount in range	Contractor's Share		Final/Total	Final PWDD	120.5%
24		90%	10%	$ -	$ -		0%	$ -	12%
25	90%	110%	30%	$ (100,000)	$ (30,000)		90%	$ 900,000	93%
26	110%	125%	50%	$ (150,000)	$ (75,000)		110%	$ 1,100,000	107%
27	125%		60%	$ (150,000)	$ (90,000)		125%	$ 1,250,000	115%
28				$ (400,000)	$ (195,000)		999%	$ 9,990,000	464%
29
30				5. Total Pmt	$ 1,205,000

The calculations were more complicated that I thought they'd be. The workbook is at https://app.box.com/s/qia6jtnueehtjeizmo7ii1qv1xrwpipj