Spreadsheet: 860909d1708939798-sum-function-not-capturing-all-amount-wip-and-po-analysis-v_1a
Sheet: Sheet1

Project No | 2023-200
Project Desciption | Breagh Onshore Compression Project - Pre Engineering
Proposal | PO Number | Account | Sum_Value | Sum_Amount_DC
WSG23-365 | [PHONE] | EFAB Industrial Solutions Ltd | 7708 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 7708 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 7708 | 19.58
 |  | Flexitallic UK Ltd | 7708 | 5774.1
 |  | Genair UK Ltd | 7708 | 5231.4
 |  | Glacier Machining Solutions Ltd | 7708 | 12796.3
 |  | HSBC Commercial Card | 7708 | 134.47
 |  | Hytorc (Unex) Ltd | 7708 | 4154.85
 |  | LFF Glamal Ltd. | 7708 | 16150.93
 |  | MDF Transport | 7708 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 7708 | 20683.5
 |  | Power Bolting Systems Ltd | 7708 | 193.27
 |  | Rollstud Ltd | 7708 | 7459.2
 |  | Speedy Asset Services | 7708 | 21280.18
 |  | Stats (UK) Ltd | 7708 | 3056
 |  | Technicruit Limited | 7708 | 199729.34
 |  | Total Rentals Solutions Ltd | 7708 | 736
 |  | Transmit Containers Ltd | 7708 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 7708 | 1158.08
 |  | Unknown | 7708 | 10567.16
 |  | WSG Industrial Services UK Ltd | 7708 | 6292.02
 | 470284536 | EFAB Industrial Solutions Ltd | 58991.2 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 58991.2 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 58991.2 | 19.58
 |  | Flexitallic UK Ltd | 58991.2 | 5774.1
 |  | Genair UK Ltd | 58991.2 | 5231.4
 |  | Glacier Machining Solutions Ltd | 58991.2 | 12796.3
 |  | HSBC Commercial Card | 58991.2 | 134.47
 |  | Hytorc (Unex) Ltd | 58991.2 | 4154.85
 |  | LFF Glamal Ltd. | 58991.2 | 16150.93
 |  | MDF Transport | 58991.2 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 58991.2 | 20683.5
 |  | Power Bolting Systems Ltd | 58991.2 | 193.27
 |  | Rollstud Ltd | 58991.2 | 7459.2
 |  | Speedy Asset Services | 58991.2 | 21280.18
 |  | Stats (UK) Ltd | 58991.2 | 3056
 |  | Technicruit Limited | 58991.2 | 199729.34
 |  | Total Rentals Solutions Ltd | 58991.2 | 736
 |  | Transmit Containers Ltd | 58991.2 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 58991.2 | 1158.08
 |  | Unknown | 58991.2 | 10567.16
 |  | WSG Industrial Services UK Ltd | 58991.2 | 6292.02
WSG23-365.1 | [PHONE] | EFAB Industrial Solutions Ltd | 62978.2 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 62978.2 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 62978.2 | 19.58
 |  | Flexitallic UK Ltd | 62978.2 | 5774.1
 |  | Genair UK Ltd | 62978.2 | 5231.4
 |  | Glacier Machining Solutions Ltd | 62978.2 | 12796.3
 |  | HSBC Commercial Card | 62978.2 | 134.47
 |  | Hytorc (Unex) Ltd | 62978.2 | 4154.85
 |  | LFF Glamal Ltd. | 62978.2 | 16150.93
 |  | MDF Transport | 62978.2 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 62978.2 | 20683.5
 |  | Power Bolting Systems Ltd | 62978.2 | 193.27
 |  | Rollstud Ltd | 62978.2 | 7459.2
 |  | Speedy Asset Services | 62978.2 | 21280.18
 |  | Stats (UK) Ltd | 62978.2 | 3056
 |  | Technicruit Limited | 62978.2 | 199729.34
 |  | Total Rentals Solutions Ltd | 62978.2 | 736
 |  | Transmit Containers Ltd | 62978.2 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 62978.2 | 1158.08
 |  | Unknown | 62978.2 | 10567.16
 |  | WSG Industrial Services UK Ltd | 62978.2 | 6292.02
WSG23-486 | [PHONE] | EFAB Industrial Solutions Ltd | 33874.8 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 33874.8 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 33874.8 | 19.58
 |  | Flexitallic UK Ltd | 33874.8 | 5774.1
 |  | Genair UK Ltd | 33874.8 | 5231.4
 |  | Glacier Machining Solutions Ltd | 33874.8 | 12796.3
 |  | HSBC Commercial Card | 33874.8 | 134.47
 |  | Hytorc (Unex) Ltd | 33874.8 | 4154.85
 |  | LFF Glamal Ltd. | 33874.8 | 16150.93
 |  | MDF Transport | 33874.8 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 33874.8 | 20683.5
 |  | Power Bolting Systems Ltd | 33874.8 | 193.27
 |  | Rollstud Ltd | 33874.8 | 7459.2
 |  | Speedy Asset Services | 33874.8 | 21280.18
 |  | Stats (UK) Ltd | 33874.8 | 3056
 |  | Technicruit Limited | 33874.8 | 199729.34
 |  | Total Rentals Solutions Ltd | 33874.8 | 736
 |  | Transmit Containers Ltd | 33874.8 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 33874.8 | 1158.08
 |  | Unknown | 33874.8 | 10567.16
 |  | WSG Industrial Services UK Ltd | 33874.8 | 6292.02
WSG23-522 | [PHONE] | EFAB Industrial Solutions Ltd | 247138.04 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 247138.04 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 247138.04 | 19.58
 |  | Flexitallic UK Ltd | 247138.04 | 5774.1
 |  | Genair UK Ltd | 247138.04 | 5231.4
 |  | Glacier Machining Solutions Ltd | 247138.04 | 12796.3
 |  | HSBC Commercial Card | 247138.04 | 134.47
 |  | Hytorc (Unex) Ltd | 247138.04 | 4154.85
 |  | LFF Glamal Ltd. | 247138.04 | 16150.93
 |  | MDF Transport | 247138.04 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 247138.04 | 20683.5
 |  | Power Bolting Systems Ltd | 247138.04 | 193.27
 |  | Rollstud Ltd | 247138.04 | 7459.2
 |  | Speedy Asset Services | 247138.04 | 21280.18
 |  | Stats (UK) Ltd | 247138.04 | 3056
 |  | Technicruit Limited | 247138.04 | 199729.34
 |  | Total Rentals Solutions Ltd | 247138.04 | 736
 |  | Transmit Containers Ltd | 247138.04 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 247138.04 | 1158.08
 |  | Unknown | 247138.04 | 10567.16
 |  | WSG Industrial Services UK Ltd | 247138.04 | 6292.02
WSG23-523 | [PHONE] | EFAB Industrial Solutions Ltd | 32362 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 32362 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 32362 | 19.58
 |  | Flexitallic UK Ltd | 32362 | 5774.1
 |  | Genair UK Ltd | 32362 | 5231.4
 |  | Glacier Machining Solutions Ltd | 32362 | 12796.3
 |  | HSBC Commercial Card | 32362 | 134.47
 |  | Hytorc (Unex) Ltd | 32362 | 4154.85
 |  | LFF Glamal Ltd. | 32362 | 16150.93
 |  | MDF Transport | 32362 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 32362 | 20683.5
 |  | Power Bolting Systems Ltd | 32362 | 193.27
 |  | Rollstud Ltd | 32362 | 7459.2
 |  | Speedy Asset Services | 32362 | 21280.18
 |  | Stats (UK) Ltd | 32362 | 3056
 |  | Technicruit Limited | 32362 | 199729.34
 |  | Total Rentals Solutions Ltd | 32362 | 736
 |  | Transmit Containers Ltd | 32362 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 32362 | 1158.08
 |  | Unknown | 32362 | 10567.16
 |  | WSG Industrial Services UK Ltd | 32362 | 6292.02
WSG23-523.1 | [PHONE] line 1 | EFAB Industrial Solutions Ltd | 37428.5 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 37428.5 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 37428.5 | 19.58
 |  | Flexitallic UK Ltd | 37428.5 | 5774.1
 |  | Genair UK Ltd | 37428.5 | 5231.4
 |  | Glacier Machining Solutions Ltd | 37428.5 | 12796.3
 |  | HSBC Commercial Card | 37428.5 | 134.47
 |  | Hytorc (Unex) Ltd | 37428.5 | 4154.85
 |  | LFF Glamal Ltd. | 37428.5 | 16150.93
 |  | MDF Transport | 37428.5 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 37428.5 | 20683.5
 |  | Power Bolting Systems Ltd | 37428.5 | 193.27
 |  | Rollstud Ltd | 37428.5 | 7459.2
 |  | Speedy Asset Services | 37428.5 | 21280.18
 |  | Stats (UK) Ltd | 37428.5 | 3056
 |  | Technicruit Limited | 37428.5 | 199729.34
 |  | Total Rentals Solutions Ltd | 37428.5 | 736
 |  | Transmit Containers Ltd | 37428.5 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 37428.5 | 1158.08
 |  | Unknown | 37428.5 | 10567.16
 |  | WSG Industrial Services UK Ltd | 37428.5 | 6292.02
WSG23-598.1 | [PHONE] line 4 | EFAB Industrial Solutions Ltd | 87655.8 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 87655.8 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 87655.8 | 19.58
 |  | Flexitallic UK Ltd | 87655.8 | 5774.1
 |  | Genair UK Ltd | 87655.8 | 5231.4
 |  | Glacier Machining Solutions Ltd | 87655.8 | 12796.3
 |  | HSBC Commercial Card | 87655.8 | 134.47
 |  | Hytorc (Unex) Ltd | 87655.8 | 4154.85
 |  | LFF Glamal Ltd. | 87655.8 | 16150.93
 |  | MDF Transport | 87655.8 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 87655.8 | 20683.5
 |  | Power Bolting Systems Ltd | 87655.8 | 193.27
 |  | Rollstud Ltd | 87655.8 | 7459.2
 |  | Speedy Asset Services | 87655.8 | 21280.18
 |  | Stats (UK) Ltd | 87655.8 | 3056
 |  | Technicruit Limited | 87655.8 | 199729.34
 |  | Total Rentals Solutions Ltd | 87655.8 | 736
 |  | Transmit Containers Ltd | 87655.8 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 87655.8 | 1158.08
 |  | Unknown | 87655.8 | 10567.16
 |  | WSG Industrial Services UK Ltd | 87655.8 | 6292.02
WSG23-609 | [PHONE] | EFAB Industrial Solutions Ltd | 14169.86 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 14169.86 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 14169.86 | 19.58
 |  | Flexitallic UK Ltd | 14169.86 | 5774.1
 |  | Genair UK Ltd | 14169.86 | 5231.4
 |  | Glacier Machining Solutions Ltd | 14169.86 | 12796.3
 |  | HSBC Commercial Card | 14169.86 | 134.47
 |  | Hytorc (Unex) Ltd | 14169.86 | 4154.85
 |  | LFF Glamal Ltd. | 14169.86 | 16150.93
 |  | MDF Transport | 14169.86 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 14169.86 | 20683.5
 |  | Power Bolting Systems Ltd | 14169.86 | 193.27
 |  | Rollstud Ltd | 14169.86 | 7459.2
 |  | Speedy Asset Services | 14169.86 | 21280.18
 |  | Stats (UK) Ltd | 14169.86 | 3056
 |  | Technicruit Limited | 14169.86 | 199729.34
 |  | Total Rentals Solutions Ltd | 14169.86 | 736
 |  | Transmit Containers Ltd | 14169.86 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 14169.86 | 1158.08
 |  | Unknown | 14169.86 | 10567.16
 |  | WSG Industrial Services UK Ltd | 14169.86 | 6292.02
WSG23-610 | [PHONE] | EFAB Industrial Solutions Ltd | 8593.57 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 8593.57 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 8593.57 | 19.58
 |  | Flexitallic UK Ltd | 8593.57 | 5774.1
 |  | Genair UK Ltd | 8593.57 | 5231.4
 |  | Glacier Machining Solutions Ltd | 8593.57 | 12796.3
 |  | HSBC Commercial Card | 8593.57 | 134.47
 |  | Hytorc (Unex) Ltd | 8593.57 | 4154.85
 |  | LFF Glamal Ltd. | 8593.57 | 16150.93
 |  | MDF Transport | 8593.57 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 8593.57 | 20683.5
 |  | Power Bolting Systems Ltd | 8593.57 | 193.27
 |  | Rollstud Ltd | 8593.57 | 7459.2
 |  | Speedy Asset Services | 8593.57 | 21280.18
 |  | Stats (UK) Ltd | 8593.57 | 3056
 |  | Technicruit Limited | 8593.57 | 199729.34
 |  | Total Rentals Solutions Ltd | 8593.57 | 736
 |  | Transmit Containers Ltd | 8593.57 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 8593.57 | 1158.08
 |  | Unknown | 8593.57 | 10567.16
 |  | WSG Industrial Services UK Ltd | 8593.57 | 6292.02
 | [PHONE] line 3 | EFAB Industrial Solutions Ltd | 37953.7 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 37953.7 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 37953.7 | 19.58
 |  | Flexitallic UK Ltd | 37953.7 | 5774.1
 |  | Genair UK Ltd | 37953.7 | 5231.4
 |  | Glacier Machining Solutions Ltd | 37953.7 | 12796.3
 |  | HSBC Commercial Card | 37953.7 | 134.47
 |  | Hytorc (Unex) Ltd | 37953.7 | 4154.85
 |  | LFF Glamal Ltd. | 37953.7 | 16150.93
 |  | MDF Transport | 37953.7 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 37953.7 | 20683.5
 |  | Power Bolting Systems Ltd | 37953.7 | 193.27
 |  | Rollstud Ltd | 37953.7 | 7459.2
 |  | Speedy Asset Services | 37953.7 | 21280.18
 |  | Stats (UK) Ltd | 37953.7 | 3056
 |  | Technicruit Limited | 37953.7 | 199729.34
 |  | Total Rentals Solutions Ltd | 37953.7 | 736
 |  | Transmit Containers Ltd | 37953.7 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 37953.7 | 1158.08
 |  | Unknown | 37953.7 | 10567.16
 |  | WSG Industrial Services UK Ltd | 37953.7 | 6292.02
WSG23-611 | [PHONE] | EFAB Industrial Solutions Ltd | 14254 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 14254 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 14254 | 19.58
 |  | Flexitallic UK Ltd | 14254 | 5774.1
 |  | Genair UK Ltd | 14254 | 5231.4
 |  | Glacier Machining Solutions Ltd | 14254 | 12796.3
 |  | HSBC Commercial Card | 14254 | 134.47
 |  | Hytorc (Unex) Ltd | 14254 | 4154.85
 |  | LFF Glamal Ltd. | 14254 | 16150.93
 |  | MDF Transport | 14254 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 14254 | 20683.5
 |  | Power Bolting Systems Ltd | 14254 | 193.27
 |  | Rollstud Ltd | 14254 | 7459.2
 |  | Speedy Asset Services | 14254 | 21280.18
 |  | Stats (UK) Ltd | 14254 | 3056
 |  | Technicruit Limited | 14254 | 199729.34
 |  | Total Rentals Solutions Ltd | 14254 | 736
 |  | Transmit Containers Ltd | 14254 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 14254 | 1158.08
 |  | Unknown | 14254 | 10567.16
 |  | WSG Industrial Services UK Ltd | 14254 | 6292.02
 | [PHONE] Line 2 | EFAB Industrial Solutions Ltd | 66138.5 | -516079.27
 |  | Enerpac UK Ltd (HTL Group) | 66138.5 | 596.75
 |  | Fedex Express Trans Ltd T/A TNT Express Trans Ltd | 66138.5 | 19.58
 |  | Flexitallic UK Ltd | 66138.5 | 5774.1
 |  | Genair UK Ltd | 66138.5 | 5231.4
 |  | Glacier Machining Solutions Ltd | 66138.5 | 12796.3
 |  | HSBC Commercial Card | 66138.5 | 134.47
 |  | Hytorc (Unex) Ltd | 66138.5 | 4154.85
 |  | LFF Glamal Ltd. | 66138.5 | 16150.93
 |  | MDF Transport | 66138.5 | 250
 |  | Metnor ( Great Yarmouth) Ltd | 66138.5 | 20683.5
 |  | Power Bolting Systems Ltd | 66138.5 | 193.27
 |  | Rollstud Ltd | 66138.5 | 7459.2
 |  | Speedy Asset Services | 66138.5 | 21280.18
 |  | Stats (UK) Ltd | 66138.5 | 3056
 |  | Technicruit Limited | 66138.5 | 199729.34
 |  | Total Rentals Solutions Ltd | 66138.5 | 736
 |  | Transmit Containers Ltd | 66138.5 | 726.4
 |  | Travelodge (FIS Payments UK Ltd DD) | 66138.5 | 1158.08
 |  | Unknown | 66138.5 | 10567.16
 |  | WSG Industrial Services UK Ltd | 66138.5 | 6292.02
Grand Total |  |  | 709246.17 | -199089.74