Aply a formula on a range

Philippe31 · Oct 26, 2023

Hi everyone. I'm new in VBA and i have a issue with VBA Code
I try to copie a formula on a range of cell but it's doesn'T work,
Can you help me.
It a index formula
I want the index formula to apply for the entire range.
I don't know if I went about it the right way.

VBA Code:

Sub paste_data()


Dim lastCell As Range
Dim targetRange As Range

Set lastCell = Cells(5, Columns.Count).End(xlToLeft).Offset(0, 1)
Set targetRange = Range(lastCell, lastCell.Offset(200, 0))

targetRange.FormulaR1C1 = "=IFERROR(INDEX(Billing_Summary!R1C1:R999C2,MATCH(RC3,Billing_Summary!R1C1:R999C1,0),14),"""")"

End Sub

Thank for helping
I

DanteAmor · Oct 26, 2023

Hi @Philippe31 Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

Philippe31 said:
0),14)

If you want the data in column 14, then you must increase the index range:

Rich (BB code):

Sub paste_data()
  Dim lastCell As Range
  Dim targetRange As Range
 
  Set lastCell = Cells(5, Columns.Count).End(xlToLeft).Offset(0, 1)
  Set targetRange = Range(lastCell, lastCell.Offset(200, 0))
 
  targetRange.FormulaR1C1 = "=IFERROR(INDEX(Billing_Summary!R1C1:R999C14,MATCH(RC3,Billing_Summary!R1C1:R999C1,0),14),"""")"
End Sub

----- --
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --

Philippe31 · Oct 26, 2023

DanteAmor said:
Hi @Philippe31 Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

If you want the data in column 14, then you must increase the index range:

Rich (BB code):

Sub paste_data() Dim lastCell As Range Dim targetRange As Range Set lastCell = Cells(5, Columns.Count).End(xlToLeft).Offset(0, 1) Set targetRange = Range(lastCell, lastCell.Offset(200, 0)) targetRange.FormulaR1C1 = "=IFERROR(INDEX(Billing_Summary!R1C1:R999C14,MATCH(RC3,Billing_Summary!R1C1:R999C1,0),14),"""")" End Sub

----- --
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --

Hi Dante Amor

i'T don't work for me.
I want the data from column 14 of the Billing summary sheet for which the correspondence field is the value in A (range 5 to 200).
I need to copy the values in the WBS sheet into the first column of row 5 which is empty.

The formula not be apply to the cell range. It's seem to be a range trouble...

Thank for your quick answer

DanteAmor · Oct 26, 2023

I assume you have the formula working in the cell. Then copy that formula and paste it here to review.

It would be much better if you share an example of your data from the 2 sheets and paste it here. Use the XL2BB tool.

Note XL2BB:
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Philippe31 · Oct 27, 2023

DanteAmor said:
I assume you have the formula working in the cell. Then copy that formula and paste it here to review.

It would be much better if you share an example of your data from the 2 sheets and paste it here. Use the XL2BB tool.

Note XL2BB:
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Hi. I can't download XL2bb on my computer !

I try to fond a other way

Alex Blakenburg · Oct 27, 2023

Step 1 is always to get the formula working in Excel and then worry about getting it to work using VBA.
If you provide @DanteAmor with the alternative information he asked for I am sure he can provide you with a solution

DanteAmor said:
I assume you have the formula working in the cell. Then copy that formula and paste it here to review.

ie post the code that works for you in Excel.

I am in a different time zone and about to log off.

Philippe31 · Oct 27, 2023

Alex Blakenburg said:
Step 1 is always to get the formula working in Excel and then worry about getting it to work using VBA.
If you provide @DanteAmor with the alternative information he asked for I am sure he can provide you with a solution

ie post the code that works for you in Excel.

I am in a different time zone and about to log off.

Hi M. Blakenburg.

I have this formule work in Excel

=SIERREUR(INDEX(BS!$A$1:$ZZ$17;EQUIV($A7;BS!$A$1:$A$17;0);14);"")

But i need this formula on a macro.
The macro must apply this formula on the range define in :

Dim lastCell As Range
Dim targetRange As Range

Set lastCell = Cells(5, Columns.Count).End(xlToLeft).Offset(0, 1)
Set targetRange = Range(lastCell, lastCell.Offset(200, 0))

I hope the explain will be clear and thank you for help.

Best regards

DanteAmor · Oct 27, 2023

Philippe31 said:
I have this formule work in Excel

=SIERREUR(INDEX(BS!$A$1:$ZZ$17;EQUIV($A7;BS!$A$1:$A$17;0);14);"")

Help us by providing complete information.
In which cell do you have that formula?

And in which cell do you want to start putting the formula?

I am only asking you to be consistent with the information you provide.

I understand that the target range is dynamic, but it has to start somewhere.

I understand, according to your macro that it will start in row 5, but in the formula you have cell A7:

Philippe31 said:
EQUIV($A7

Another inconsistency, in your formula you have the sheet "BS" but in your initial post the sheet is "Billing_Summary".

Philippe31 said:
INDEX(BS!

Philippe31 said:
"=IFERROR(INDEX(Billing_Summary!

Another inconsistency, in the macro the data to be compared is in column 3 (column C) and in the formula the data is in column A.

Those types of inconsistencies are what don't help me determine what the final macro would be like.

That's why I asked you for a minisheet with xl2bb, if you can't install it, at least describe how your data is in the sheets.
Or post images.

That would really help to help you.

----------------------------------------------------------
However .....
I'll make another try, assuming the formula goes in row 5. That the sheet with data is called "BS":

VBA Code:

Sub paste_data()
  Dim lastCell As Range
  Dim targetRange As Range
  
  Set lastCell = Cells(5, Columns.Count).End(xlToLeft).Offset(0, 1)
  Set targetRange = Range(lastCell, lastCell.Offset(200, 0))
  
  targetRange.Formula = "=IFERROR(INDEX(BS!$A$1:$ZZ$999,MATCH($A5,BS!$A$1:$A$999,0),14),"""")"
End Sub

I also put the formula in A1 nomenclature, that way it will be easier to understand if you want to adjust it in the macro.

----------------------------------------------------------
I hope to hear from you soon.
Respectfully
Dante Amor

Philippe31 · Oct 27, 2023

DanteAmor said:

Help us by providing complete information.
In which cell do you have that formula?

And in which cell do you want to start putting the formula?

I am only asking you to be consistent with the information you provide.

I understand that the target range is dynamic, but it has to start somewhere.

I understand, according to your macro that it will start in row 5, but in the formula you have cell A7:

Another inconsistency, in your formula you have the sheet "BS" but in your initial post the sheet is "Billing_Summary".

Another inconsistency, in the macro the data to be compared is in column 3 (column C) and in the formula the data is in column A.

Those types of inconsistencies are what don't help me determine what the final macro would be like.

That's why I asked you for a minisheet with xl2bb, if you can't install it, at least describe how your data is in the sheets.
Or post images.

That would really help to help you.

----------------------------------------------------------
However .....
I'll make another try, assuming the formula goes in row 5. That the sheet with data is called "BS":

VBA Code:

Sub paste_data()
  Dim lastCell As Range
  Dim targetRange As Range
[/QUOTE]
[RANGE=rs:25|cs:19|w:Recheche_valeur_www.xlsm|cls:xl2bb-210|s:BS|tw:2713][XR][XH][/XH][XH=w:110]A[/XH][XH=w:69]B[/XH][XH=w:755]C[/XH][XH=w:50]D[/XH][XH=w:346]E[/XH][XH=w:100]F[/XH][XH=w:100]G[/XH][XH=w:100]H[/XH][XH=w:100]I[/XH][XH=w:100]J[/XH][XH=w:100]K[/XH][XH=w:100]L[/XH][XH=w:100]M[/XH][XH=w:100]N[/XH][XH=w:100]O[/XH][XH=w:100]P[/XH][XH=w:100]Q[/XH][XH=w:100]R[/XH][XH=w:76]S[/XH][/XR][XR][XH]1[/XH][XD=ch:16.5|ff:ari|fz:12pt]1[/XD][XD=fw:b|ff:ari|fz:12pt]2[/XD][XD=fw:b|ff:ari|fz:12pt]3[/XD][XD=ff:ari|fz:12pt]4[/XD][XD=ff:ari|fz:12pt|cls:bb]5[/XD][XD=ff:ari|fz:12pt|cls:bb|nf:0]6[/XD][XD=fw:b|ff:ari|fz:12pt|cls:bb]7[/XD][XD=ff:ari|fz:12pt|cls:bb]8[/XD][XD=ff:ari|fz:12pt|cls:bb]9[/XD][XD=ff:ari|fz:12pt|cls:bb|nf:0]10[/XD][XD=fw:b|ff:ari|fz:12pt|cls:bb]11[/XD][XD=ff:ari|fz:12pt|cls:bb]12[/XD][XD=ff:ari|fz:12pt|cls:bb]13[/XD][XD=bc:FFFF00|ff:ari|fz:12pt|cls:bb|nf:0]14[/XD][XD=fw:b|ff:ari|fz:12pt|cls:bb]15[/XD][XD=ff:ari|fz:12pt|cls:bb]16[/XD][XD=ff:ari|fz:12pt|cls:bb]17[/XD][XD=ff:ari|fz:12pt|cls:bb|nf:0]18[/XD][XD][/XD][/XR][XR][XH]2[/XH][XD=ch:37.5|cls:bb][/XD][XD=cls:bb][/XD][XD=cls:bb][/XD][XD=cls:br bb][/XD][XD=h:l|fw:b|ff:ari|fz:12pt|cls:bl bt br bb]Main Contract[/XD][XD=cs:3|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb]a[/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cs:2|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb ww]b[/XD][XD=cs:3|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb ww]c[/XD][XD=cs:2|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb ww]d[/XD][XD=cs:2|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb ww]e[/XD][XD=cls:bl][/XD][/XR][XR][XH]3[/XH][XD=fw:b|bc:D8D8D8|ch:48.75|cls:bl bt br bb][/XD][XD=h:l|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww]Work Package[/XD][XD=h:l|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww]CLEF[/XD][XD=h:l|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww]Firm[/XD][XD=h:l|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] Work Package Milestone [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:0]Hrs[/XD][XD=fw:b|bc:D8D8D8|cls:bl bt br bb][/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] $ [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] F.$ [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:0]Hrs[/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] $ [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] Hrs [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] $ Main Contract Billing [/XD][XD=h:c|fw:b|bc:FFFF00|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] $ Net [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] AC Hrs [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] AC $ [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:0]Hrs[/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] $ [/XD][XD=cls:bl][/XD][/XR][XR][XH]4[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]1[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] xxx [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:99|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]99.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]1[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.0287044220325834|nf:0%]3%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:37|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        37[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:386815.25|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$               386,815[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3485|nf:#,##0_);(#,##0)]3,485[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:386815.25|nf:#,##0_);(#,##0)]386,815[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:10|nf:#,##0_);(#,##0)]10[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3485|nf:#,##0_);(#,##0)]3,485[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:386815.25|nf:#,##0_);(#,##0)]386,815[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|cls:bl][/XD][/XR][XR][XH]5[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]2[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] xxx [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:98|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]98.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]2[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.0419148967314139|nf:0%]4%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:36|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        36[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                         -[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:11|nf:#,##0_);(#,##0)]11[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|cls:bl][/XD][/XR][XR][XH]6[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]3[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] WP1 [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:65|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]65.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]3[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.0602046342784373|nf:0%]6%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:35|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        35[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:254538.75|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$               254,539[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:2303.25|nf:#,##0_);(#,##0)]2,303[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:254538.75|nf:#,##0_);(#,##0)]254,539[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:12|nf:#,##0_);(#,##0)]12[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:2303.25|nf:#,##0_);(#,##0)]2,303[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:254538.75|nf:#,##0_);(#,##0)]254,539[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|cls:bl][/XD][/XR][XR][XH]7[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]4[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] xxx [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:65|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]65.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]4[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.183343823645652|nf:0%]18%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:34|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        34[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:892455.75|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$               892,456[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:8292.15|nf:#,##0_);(#,##0)]8,292[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:892455.75|nf:#,##0_);(#,##0)]892,456[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:13|nf:#,##0_);(#,##0)]13[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:8292.15|nf:#,##0_);(#,##0)]8,292[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:892455.75|nf:#,##0_);(#,##0)]892,456[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|cls:bl][/XD][/XR][XR][XH]8[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]5[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] WP1 [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:32|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]32.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]5[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.345794848524769|nf:0%]35%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:32|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        32[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3361726.25|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$            3,361,726[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:30437.75|nf:#,##0_);(#,##0)]30,438[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3361726.25|nf:#,##0_);(#,##0)]3,361,726[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:15|nf:#,##0_);(#,##0)]15[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:30437.75|nf:#,##0_);(#,##0)]30,438[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3361726.25|nf:#,##0_);(#,##0)]3,361,726[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:-2037.75|nf:#,##0_);(#,##0)]-2,038[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|cls:bl][/XD][/XR][XR][XH]9[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]6[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] WP1 [/XD][XD=fz:12pt|cls:bl bt br bb|tx:321|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]321.00  $[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fz:12pt|cls:bl bt br bb|nf:0]6[/XD][XD=fz:12pt|cls:bl bt br bb|tx:0.223472927675396|nf:0%]22%[/XD][XD=fz:12pt|cls:bl bt br bb|tx:91|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        91[/XD][XD=fw:b|fz:12pt|cls:bl bt br bb|tx:119452.5|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$               119,453[/XD][XD=fz:12pt|cls:bl bt br bb|tx:1037.5|nf:#,##0_);(#,##0)]1,038[/XD][XD=fz:12pt|cls:bl bt br bb|tx:119452.5|nf:#,##0_);(#,##0)]119,453[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:16|nf:#,##0_);(#,##0)]16[/XD][XD=fz:12pt|cls:bl bt br bb|tx:1037.5|nf:#,##0_);(#,##0)]1,038[/XD][XD=fz:12pt|cls:bl bt br bb|tx:119452.5|nf:#,##0_);(#,##0)]119,453[/XD][XD=fz:12pt|cls:bl bt br bb|tx:56.2470980868598|nf:#,##0_);(#,##0)]56[/XD][XD=fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=cls:bl][/XD][/XR][XR][XH]10[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]7[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] hjk [/XD][XD=fz:12pt|cls:bl bt br bb|tx:321|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]321.00  $[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:17|nf:#,##0_);(#,##0)]17[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl][/XD][/XR][XR][XH]11[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]8[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] aaa [/XD][XD=fz:12pt|cls:bl bt br bb|tx:321|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]321.00  $[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:18|nf:#,##0_);(#,##0)]18[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl][/XD][/XR][XR][XH]12[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]9[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] bbb [/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:19|nf:#,##0_);(#,##0)]19[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl][/XD][/XR][XR][XH]13[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]10[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] cvvv [/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:21|nf:#,##0_);(#,##0)]21[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl][/XD][/XR][XR][XH]14[/XH][XD=bc:D9E1F2|ch:16.5|fz:12pt|cls:bl bt br bb]11[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] ddd [/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:22|nf:#,##0_);(#,##0)]22[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl][/XD][/XR][XR][XH]15[/XH][XD=bc:D9E1F2|ch:16.5|fz:12pt|cls:bl bt br bb]12[/XD][XD=h:l|fw:b|fs:i|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] eee [/XD][XD=fw:b|fs:i|cls:bl bt br bb][/XD][XD=fw:b|fs:i|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|bc:FFFF00|c:7030A0|fz:12pt|cls:bl bt br bb|tx:23|nf:#,##0_);(#,##0)]23[/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=cls:bl][/XD][/XR][XR][XH]16[/XH][XD=bc:D9E1F2|ch:15.75|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:24|nf:#,##0_);(#,##0)]24[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl][/XD][/XR][XR][XH]17[/XH][XD=bc:D9E1F2|ch:15.75|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:25|nf:#,##0_);(#,##0)]25[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl][/XD][/XR][XR][XH]18[/XH][XD=ch:15|cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=bc:FFFF00|cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD][/XD][/XR][XR][XH]19[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]20[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]21[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]22[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]23[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]24[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]25[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][/RANGE]



[RANGE=rs:20|cs:18|w:Recheche_valeur_www.xlsm|cls:xl2bb-210|s:BS|tw:2637][XR][XH][/XH][XH=w:110]A[/XH][XH=w:69]B[/XH][XH=w:755]C[/XH][XH=w:50]D[/XH][XH=w:346]E[/XH][XH=w:100]F[/XH][XH=w:100]G[/XH][XH=w:100]H[/XH][XH=w:100]I[/XH][XH=w:100]J[/XH][XH=w:100]K[/XH][XH=w:100]L[/XH][XH=w:100]M[/XH][XH=w:100]N[/XH][XH=w:100]O[/XH][XH=w:100]P[/XH][XH=w:100]Q[/XH][XH=w:100]R[/XH][/XR][XR][XH]1[/XH][XD=ch:16.5|ff:ari|fz:12pt]1[/XD][XD=fw:b|ff:ari|fz:12pt]2[/XD][XD=fw:b|ff:ari|fz:12pt]3[/XD][XD=ff:ari|fz:12pt]4[/XD][XD=ff:ari|fz:12pt|cls:bb]5[/XD][XD=ff:ari|fz:12pt|cls:bb|nf:0]6[/XD][XD=fw:b|ff:ari|fz:12pt|cls:bb]7[/XD][XD=ff:ari|fz:12pt|cls:bb]8[/XD][XD=ff:ari|fz:12pt|cls:bb]9[/XD][XD=ff:ari|fz:12pt|cls:bb|nf:0]10[/XD][XD=fw:b|ff:ari|fz:12pt|cls:bb]11[/XD][XD=ff:ari|fz:12pt|cls:bb]12[/XD][XD=ff:ari|fz:12pt|cls:bb]13[/XD][XD=bc:FFFF00|ff:ari|fz:12pt|cls:bb|nf:0]14[/XD][XD=fw:b|ff:ari|fz:12pt|cls:bb]15[/XD][XD=ff:ari|fz:12pt|cls:bb]16[/XD][XD=ff:ari|fz:12pt|cls:bb]17[/XD][XD=ff:ari|fz:12pt|cls:bb|nf:0]18[/XD][/XR][XR][XH]2[/XH][XD=ch:37.5|cls:bb][/XD][XD=cls:bb][/XD][XD=cls:bb][/XD][XD=cls:br bb][/XD][XD=h:l|fw:b|ff:ari|fz:12pt|cls:bl bt br bb]Main Contract[/XD][XD=cs:3|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb]a[/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cs:2|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb ww]b[/XD][XD=cs:3|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb ww]c[/XD][XD=cs:2|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb ww]d[/XD][XD=cs:2|h:c|fw:b|ff:ari|fz:12pt|cls:bl bt bb ww]e[/XD][/XR][XR][XH]3[/XH][XD=fw:b|bc:D8D8D8|ch:48.75|cls:bl bt br bb][/XD][XD=h:l|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww]Work Package[/XD][XD=h:l|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww]CLEF[/XD][XD=h:l|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww]Firm[/XD][XD=h:l|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] Work Package Milestone [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:0]Hrs[/XD][XD=fw:b|bc:D8D8D8|cls:bl bt br bb][/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] $ [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] F.$ [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:0]Hrs[/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] $ [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] Hrs [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] $ Main Contract Billing [/XD][XD=h:c|fw:b|bc:FFFF00|fz:12pt|cls:bl bt br bb ww|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)] $ Net [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] AC Hrs [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] AC $ [/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:0]Hrs[/XD][XD=h:c|fw:b|bc:D8D8D8|fz:12pt|cls:bl bt br bb ww|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] $ [/XD][/XR][XR][XH]4[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]1[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] xxx [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:99|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]99.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]1[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.0287044220325834|nf:0%]3%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:37|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        37[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:386815.25|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$               386,815[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3485|nf:#,##0_);(#,##0)]3,485[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:386815.25|nf:#,##0_);(#,##0)]386,815[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:10|nf:#,##0_);(#,##0)]10[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3485|nf:#,##0_);(#,##0)]3,485[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:386815.25|nf:#,##0_);(#,##0)]386,815[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][/XR][XR][XH]5[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]2[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] xxx [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:98|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]98.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]2[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.0419148967314139|nf:0%]4%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:36|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        36[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                         -[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:11|nf:#,##0_);(#,##0)]11[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][/XR][XR][XH]6[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]3[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] WP1 [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:65|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]65.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]3[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.0602046342784373|nf:0%]6%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:35|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        35[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:254538.75|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$               254,539[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:2303.25|nf:#,##0_);(#,##0)]2,303[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:254538.75|nf:#,##0_);(#,##0)]254,539[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:12|nf:#,##0_);(#,##0)]12[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:2303.25|nf:#,##0_);(#,##0)]2,303[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:254538.75|nf:#,##0_);(#,##0)]254,539[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][/XR][XR][XH]7[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]4[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] xxx [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:65|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]65.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]4[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.183343823645652|nf:0%]18%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:34|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        34[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:892455.75|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$               892,456[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:8292.15|nf:#,##0_);(#,##0)]8,292[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:892455.75|nf:#,##0_);(#,##0)]892,456[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:321321|nf:#,##0_);(#,##0)]321,321[/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:13|nf:#,##0_);(#,##0)]13[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:8292.15|nf:#,##0_);(#,##0)]8,292[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:892455.75|nf:#,##0_);(#,##0)]892,456[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][/XR][XR][XH]8[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]5[/XD][XD=h:l|bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] WP1 [/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:32|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]32.00  $[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|nf:0]5[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0.345794848524769|nf:0%]35%[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:32|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        32[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3361726.25|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$            3,361,726[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:30437.75|nf:#,##0_);(#,##0)]30,438[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3361726.25|nf:#,##0_);(#,##0)]3,361,726[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:15|nf:#,##0_);(#,##0)]15[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:30437.75|nf:#,##0_);(#,##0)]30,438[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:3361726.25|nf:#,##0_);(#,##0)]3,361,726[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:-2037.75|nf:#,##0_);(#,##0)]-2,038[/XD][XD=bc:D9E1F2|fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][/XR][XR][XH]9[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]6[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] WP1 [/XD][XD=fz:12pt|cls:bl bt br bb|tx:321|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]321.00  $[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fz:12pt|cls:bl bt br bb|nf:0]6[/XD][XD=fz:12pt|cls:bl bt br bb|tx:0.223472927675396|nf:0%]22%[/XD][XD=fz:12pt|cls:bl bt br bb|tx:91|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$                        91[/XD][XD=fw:b|fz:12pt|cls:bl bt br bb|tx:119452.5|nf:_($* #,##0_);_($* (#,##0);_($* \0022-\0022??_);_(@_)]$               119,453[/XD][XD=fz:12pt|cls:bl bt br bb|tx:1037.5|nf:#,##0_);(#,##0)]1,038[/XD][XD=fz:12pt|cls:bl bt br bb|tx:119452.5|nf:#,##0_);(#,##0)]119,453[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:16|nf:#,##0_);(#,##0)]16[/XD][XD=fz:12pt|cls:bl bt br bb|tx:1037.5|nf:#,##0_);(#,##0)]1,038[/XD][XD=fz:12pt|cls:bl bt br bb|tx:119452.5|nf:#,##0_);(#,##0)]119,453[/XD][XD=fz:12pt|cls:bl bt br bb|tx:56.2470980868598|nf:#,##0_);(#,##0)]56[/XD][XD=fz:12pt|cls:bl bt br bb|tx:0|nf:#,##0_);(#,##0)]0[/XD][/XR][XR][XH]10[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]7[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] hjk [/XD][XD=fz:12pt|cls:bl bt br bb|tx:321|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]321.00  $[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:17|nf:#,##0_);(#,##0)]17[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][/XR][XR][XH]11[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]8[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] aaa [/XD][XD=fz:12pt|cls:bl bt br bb|tx:321|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ]321.00  $[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:18|nf:#,##0_);(#,##0)]18[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][/XR][XR][XH]12[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]9[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] bbb [/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:19|nf:#,##0_);(#,##0)]19[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][/XR][XR][XH]13[/XH][XD=bc:D9E1F2|ch:15.75|fz:12pt|cls:bl bt br bb]10[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] cvvv [/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:21|nf:#,##0_);(#,##0)]21[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][/XR][XR][XH]14[/XH][XD=bc:D9E1F2|ch:16.5|fz:12pt|cls:bl bt br bb]11[/XD][XD=h:l|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] ddd [/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=fw:b|cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:22|nf:#,##0_);(#,##0)]22[/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][XD=cls:bl bt br bb][/XD][/XR][XR][XH]15[/XH][XD=bc:D9E1F2|ch:16.5|fz:12pt|cls:bl bt br bb]12[/XD][XD=h:l|fw:b|fs:i|fz:12pt|cls:bl bt br bb|nf:_ * #,##0.00_) $_ ;_ * (#,##0.00) $_ ;_ * \0022-\0022??_) $_ ;_ @_ ] eee [/XD][XD=fw:b|fs:i|cls:bl bt br bb][/XD][XD=fw:b|fs:i|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|bc:FFFF00|c:7030A0|fz:12pt|cls:bl bt br bb|tx:23|nf:#,##0_);(#,##0)]23[/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][XD=fw:b|fs:i|c:7030A0|cls:bl bt br bb][/XD][/XR][XR][XH]16[/XH][XD=bc:D9E1F2|ch:15.75|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:24|nf:#,##0_);(#,##0)]24[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][/XR][XR][XH]17[/XH][XD=bc:D9E1F2|ch:15.75|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:FFFF00|fz:12pt|cls:bl bt br bb|tx:25|nf:#,##0_);(#,##0)]25[/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][XD=bc:D9E1F2|cls:bl bt br bb][/XD][/XR][XR][XH]18[/XH][XD=ch:15|cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=bc:FFFF00|cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][XD=cls:bt][/XD][/XR][XR][XH]19[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][XR][XH]20[/XH][XD=ch:15][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][XD=bc:FFFF00][/XD][XD][/XD][XD][/XD][XD][/XD][XD][/XD][/XR][/RANGE]

[QUOTE="DanteAmor, post: 6120519, member: 439277"]

 
  Set lastCell = Cells(5, Columns.Count).End(xlToLeft).Offset(0, 1)
  Set targetRange = Range(lastCell, lastCell.Offset(200, 0))
 
  targetRange.Formula = "=IFERROR(INDEX(BS!$A$1:$ZZ$999,MATCH($A5,BS!$A$1:$A$999,0),14),"""")"
End Sub

I also put the formula in A1 nomenclature, that way it will be easier to understand if you want to adjust it in the macro.

----------------------------------------------------------
I hope to hear from you soon.
Respectfully
Dante Amor

Hi. I found a way to send you the sheet with @BB Excel

Philippe31 · Oct 27, 2023

Recheche_valeur_www.xlsm

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

2

Main Contract

a

b

c

d

e

3

Work Package

CLEF

Firm

Work Package Milestone

Hrs

$

F.$

Hrs

$

Hrs

$ Main Contract Billing

$ Net

AC Hrs

AC $

Hrs

$

4

1

xxx

99.00 $

1

3%

$ 37

$ 386,815

3,485

386,815

321,321

10

3,485

386,815

0

5

2

xxx

98.00 $

2

4%

$ 36

$ -

0

321,321

11

0

6

3

WP1

65.00 $

3

6%

$ 35

$ 254,539

2,303

254,539

321,321

12

2,303

254,539

0

7

4

xxx

65.00 $

4

18%

$ 34

$ 892,456

8,292

892,456

321,321

13

8,292

892,456

0

8

5

WP1

32.00 $

5

35%

$ 32

$ 3,361,726

30,438

3,361,726

15

30,438

3,361,726

-2,038

0

9

6

WP1

321.00 $

6

22%

$ 91

$ 119,453

1,038

119,453

16

1,038

119,453

56

0

10

7

hjk

321.00 $

17

11

8

aaa

321.00 $

18

12

9

bbb

19

13

10

cvvv

21

14

11

ddd

22

15

12

eee

23

16

24

17

25

18

19

20

BS

Aply a formula on a range

Philippe31

New Member

Excel Facts

DanteAmor

Well-known Member

Philippe31

New Member

DanteAmor

Well-known Member

Philippe31

New Member

Alex Blakenburg

MrExcel MVP

Philippe31

New Member

DanteAmor

Well-known Member

Philippe31

New Member

Philippe31

New Member

Similar threads

Forum statistics

Share this page

Aply a formula on a range

New Member

Excel Facts

Well-known Member

New Member

Well-known Member

New Member

MrExcel MVP

New Member

Well-known Member

New Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock