Aply a formula on a range

P

Philippe31

New Member
Joined
Oct 26, 2023
Messages
9
Office Version
  1. 2021
Platform
  1. Windows
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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Hi @Philippe31 Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.


Philippe31 said:
0),14)
Click to expand...
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
----- --
 
Upvote 0
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
----- --
Click to expand...

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
 
Upvote 0
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.
 
Upvote 0
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.
Click to expand...
Hi. I can't download XL2bb on my computer !

I try to fond a other way :)
 
Upvote 0
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.
Click to expand...
ie post the code that works for you in Excel.

I am in a different time zone and about to log off.
 
Upvote 0
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.
Click to expand...
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
 
Upvote 0
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);"")
Click to expand...
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
Click to expand...

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

Philippe31 said:
INDEX(BS!
Click to expand...
Philippe31 said:
"=IFERROR(INDEX(Billing_Summary!
Click to expand...

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
:cool:
 
Upvote 0
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
:cool:
Click to expand...
Hi. I found a way to send you the sheet with @BB Excel
 
Upvote 0
Recheche_valeur_www.xlsm
ABCDEFGHIJKLMNOPQR
1123456789101112131415161718
2Main Contractabcde
3Work PackageCLEFFirm Work Package Milestone Hrs $ F.$ Hrs $ Hrs $ Main Contract Billing $ Net AC Hrs AC $ Hrs $
41 xxx 99.00 $13%$ 37$ 386,8153,485386,815321,321321,321103,485386,81500
52 xxx 98.00 $24%$ 36$ -00321,321321,321110000
63 WP1 65.00 $36%$ 35$ 254,5392,303254,539321,321321,321122,303254,53900
74 xxx 65.00 $418%$ 34$ 892,4568,292892,456321,321321,321138,292892,45600
85 WP1 32.00 $535%$ 32$ 3,361,72630,4383,361,7261530,4383,361,726-2,0380
96 WP1 321.00 $622%$ 91$ 119,4531,038119,453161,038119,453560
107 hjk 321.00 $17
118 aaa 321.00 $18
129 bbb 19
1310 cvvv 21
1411 ddd 22
1512 eee 23
1624
1725
18
19
20
BS
 
Upvote 0
You must log in or register to reply here.

Similar threads

weefatb0b
  • Solved
VBA add a criteria to a Sum function
2 3 4
Replies
31
Views
1K
Peter_SSs
Peter_SSs
N
  • Question
Select Method of Range Class Failed with Table
Replies
4
Views
198
NorthbyNorthwest
N
H
  • Solved
Copy and paste each Sheet as paste special values and retaining same format
Replies
5
Views
458
howard
H
F
  • Solved
Record formulas in VBA from spreadsheet cell
Replies
5
Views
221
Micron
M
J
  • Question
Combining 2 separate codes into one
Replies
0
Views
404
julhs
J

Forum statistics

Threads
1,215,102
Messages
6,123,097
Members
449,096
Latest member
provoking

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top