Spreadsheet: 800387d1665645974-how-to-put-interval-involving-date-and-values-budget-template
Sheet: Assumptions_IPD

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96
FS ITEM | No. | JO# | Category | Segment | Group | Cluster | Project Name | Client | Start Date | End Date | Duration | Included | JV/Non-JV | [NAME] | [NAME] | [NAME] | [NAME] | Mgn (%) | DP (%) | Ret (%) | Year | Total Revenue | FS Account | Start mo. Count | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | [NAME] | M14 | M15 | M16 | [NAME] | M18 | M19 | M20 | M21 | M22 | M23 | M24 | M25 | M26 | M27 | M28 | M29 | M30 | M31 | M32 | M33 | M34 | M35 | M36 | M37 | M38 | M39 | M40 | M41 | M42 | M43 | M44 | M45 | M46 | M47 | M48 | M49 | M50 | M51 | M52 | M53 | M54 | M55 | M56 | M57 | M58 | M59 | M60 | M61 | M62 | M63 | M64 | M65 | M66 | M67 | M68 | M69 | M70 | M71 | M72 | M73 | M74 | M75 | M76 | M77 | M78 | M79 | M80 | M81 | M82 | M83 | M84 | M85 | [NAME] | M87 | [NAME] | M89 | M90 | M91 | M92 | M93 | M94 | M95 | [NAME]
REVENUE
 | 1 | AAA-000 | Plan A | IPD | Group | Water | BLUE LOCK | EGO | 2023-04-01 00:00:00 | 2024-11-30 00:00:00 |  | 1 | Non-JV |  |  | 2500 | 500 |  | 0.2 | 0.1 |  |  |  |  | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125 | 125
 | 2 |  |  | IPD
 | 3 |  |  | IPD
 | 4 |  |  | IPD
 | 5 |  |  | IPD
 | 6 |  |  | IPD
 | 7 |  |  | IPD
 | 8 |  |  | IPD
 | 9 |  |  | IPD
 | 10 |  |  | IPD
 | 11 |  |  | IPD
 | 12 |  |  | IPD
 | 13 |  |  | IPD
 | 14 |  |  | IPD
 | 15 |  |  | IPD
 | 16 |  |  | IPD
 | 17 |  |  | IPD
 | 18 |  |  | IPD
 | 19 |  |  | IPD
 | 20 |  |  | IPD
 | 21 |  |  | IPD
 | 22 |  |  | IPD
 | 23 |  |  | IPD
 | 24 |  |  | IPD
 | 25 |  |  | IPD
 | 26 |  |  | IPD
 | 27 |  |  | IPD
 | 28 |  |  | IPD
 | 29 |  |  | IPD
 | 30 |  |  | IPD
 | 31 |  |  | IPD
 | 32 |  |  | IPD
 | 33 |  |  | IPD
 | 34 |  |  | IPD
 | 35 |  |  | IPD
 | 36 |  |  | IPD
 | 37 |  |  | IPD
 | 38 |  |  | IPD
 | 39 |  |  | IPD
 | 40 |  |  | IPD
 | 41 |  |  | IPD
 | 42 |  |  | IPD
 | 43 |  |  | IPD
 | 44 |  |  | IPD
 | 45 |  |  | IPD
 | 46 |  |  | IPD
 | 47 |  |  | IPD
 | 48 |  |  | IPD
 | 49 |  |  | IPD
 | 50 |  |  | IPD
 | 51 |  |  | IPD
 | 52 |  |  | IPD
 | 53 |  |  | IPD
 | 54 |  |  | IPD
 | 55 |  |  | IPD
 | 56 |  |  | IPD
 | 57 |  |  | IPD
 | 58 |  |  | IPD
 | 59 |  |  | IPD
 | 60 |  |  | IPD
 | 61 |  |  | IPD
 | 62 |  |  | IPD
 | 63 |  |  | IPD
 | 64 |  |  | IPD
 | 65 |  |  | IPD
 | 66 |  |  | IPD
 | 67 |  |  | IPD
 | 68 |  |  | IPD
 | 69 |  |  | IPD
 | 70 |  |  | IPD
 | 71 |  |  | IPD
 | 72 |  |  | IPD
 | 73 |  |  | IPD
 | 74 |  |  | IPD
 | 75 |  |  | IPD
 | 76 |  |  | IPD
 | 77 |  |  | IPD
 | 78 |  |  | IPD
 | 79 |  |  | IPD
 | 80 |  |  | IPD
 | 81 |  |  | IPD
 | 82 |  |  | IPD
 | 83 |  |  | IPD
 | 84 |  |  | IPD
 | 85 |  |  | IPD
 | 86 |  |  | IPD
 | 87 |  |  | IPD
 | 88 |  |  | IPD
 | 89 |  |  | IPD
 | 90 |  |  | IPD
 | 91 |  |  | IPD
 | 92 |  |  | IPD
 | 93 |  |  | IPD
 | 94 |  |  | IPD
 | 95 |  |  | IPD
 | 96 |  |  | IPD
 | 97 |  |  | IPD
 | 98 |  |  | IPD
GROSS MARGIN |  |  | - |  | - |  |  |  |  |  |  | - | -
 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | 5 | 30 | 20 | 10 | 40 | 15 | 15 | 35 | 30 | 30 | 25 | 50 | 5 | 20 | 25 | 20 | 30 | 0 | 50
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98