tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031W
COMPANY NAME    Harper Mechanical Corp.
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-2000 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
LT Notes Receivable |  | 0 |  | -8000 |  |  |  |  |  |  |  |  |  | 72000 |  | 0035
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
Country club deposit |  | 12550 |  |  |  |  |  |  |  |  |  |  |  | -12550 |  | 0163
Dep w/State of Florida |  | 177991 |  |  |  |  |  |  |  |  |  |  |  | -177991 |  | 0163
Purchase contract |  | 96494
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 845848d1697183661-how-to-solve-error-n-a-in-my-project-my-project-vlookup-and-hlookup
Sheet: File Latihan

[NAME] | No. Pemesanan | [NAME] | [NAME] | [NAME]
2021-03-06 00:00:00 | 106
2021-03-02 00:00:00 | 102
2021-03-04 00:00:00 | 101
2021-03-05 00:00:00 | 101
2021-03-10 00:00:00 | 110
2021-03-03 00:00:00 | 103
2021-03-08 00:00:00 | 108
2021-03-09 00:00:00 | 109
2021-03-01 00:00:00 | 101
2021-03-07 00:00:00 | 107
Spreadsheet: 749922d1633097543-conditional-formatting-how-to-color-other-columns-excelforum_help_workbook
Sheet: Sheet1

Next 30 Day | Most Recent 30 Day |  |  | Next 30 Day | Most Recent 30 Day |  | Report Date | 2021-09-15 00:00:00
2021-09-29 00:00:00 |  |  |  | 2021-09-29 00:00:00
2021-10-10 00:00:00 |  |  |  | 2021-10-10 00:00:00
2021-09-07 00:00:00 |  |  |  | 2021-09-07 00:00:00
2021-10-01 00:00:00 |  |  |  | 2021-10-01 00:00:00
2021-10-03 00:00:00 |  |  |  | 2021-10-03 00:00:00
2021-09-16 00:00:00 |  |  |  | 2021-09-16 00:00:00
2021-09-17 00:00:00 | 2021-09-03 00:00:00 |  |  | 2021-09-17 00:00:00 | 2021-09-03 00:00:00
2021-09-08 00:00:00 |  |  |  | 2021-09-08 00:00:00
2021-09-25 00:00:00 |  |  |  | 2021-09-25 00:00:00
2021-09-10 00:00:00 |  |  |  | 2021-09-10 00:00:00
2021-09-29 00:00:00 |  |  |  | 2021-09-29 00:00:00
2021-10-11 00:00:00 | 2021-09-03 00:00:00 |  |  | 2021-10-11 00:00:00 | 2021-09-03 00:00:00
2021-07-29 00:00:00 | 2021-08-30 00:00:00 |  |  | 2021-07-29 00:00:00 | 2021-08-30 00:00:00
 |  |  |  | (these columns is how I want it to work)
Spreadsheet: 691780d1597865302-1-set-of-columns-to-look-at-a-different-set-and-determine-if-they-need-reviewed-if-statement
Sheet: Sheet1

a | VS RVU |  |  |  |  | Review - Yes or No
IP Number | L071 | L074 | L075 | L076 |  | L071 | L074 | L075 | L076
1525 |  |  |  |  |  |  | Review
40084
496 |  |  |  |  |  | Review |  | Review | Review
58954 |  |  |  |  |  | Review |  | Review
62521 |  |  |  |  |  | Review |  | Review | Review
64544
702 |  |  |  |  |  | Review | Review
87961 |  |  |  |  |  | Review |  | Review
90430
91335 |  |  |  |  |  | Review | Review
Spreadsheet: 840146d1692486904-need-to-calculate-average-over-a-date-range-using-several-variables-dummy-report
Sheet: Sheet1

Date From: | 2022-06-01 00:00:00
Date To: | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 2022-10-01 00:00:00 | 2023-04-01 00:00:00
Employee | Target |  | Employee | Date 1 | Pos 1 | Date 2 | Pos 2 | Date 3 | Pos 3 |  | Position | Target 1 | Target 2 | Target 3 | Target 4
Richie |  |  | Richie | 2020-01-01 00:00:00 | Assistant Consultant | 2022-12-01 00:00:00 | Consultant |  |  |  | Director | 5 | 5.5 | 6
Palmer |  |  | Palmer | 2020-01-01 00:00:00 | Director |  |  |  |  |  | Associate Director | 4 | 4.5 | 5
[NAME] |  |  | [NAME] | 2020-01-01 00:00:00 | Senior Consultant | 2023-04-01 00:00:00 | Associate Director |  |  |  | Senior Consultant | 3 | 3.5 | 4
Milligan |  |  | Milligan | 2020-01-01 00:00:00 | Consultant | 2022-08-01 00:00:00 | Senior Consultant | 2023-02-01 00:00:00 | Associate Director |  | Consultant | 2 | 2.5 | 3
 |  |  |  |  |  |  |  |  |  |  | Assistant Consultant | 1 | 1.5 | 2
Spreadsheet: 4f0e57d8-c8ce-4ed7-af8f-48709c6e39de
Sheet: TDIP Cohort 1 Yr 4

Grant: |  | Title 1A Targeted District Improvement
CFDA # |  | 84.010
GRANT NUMBER: |  | 5010
FISCAL YEAR: |  | 2013-14
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]-866-6724  or  [EMAIL]
Questions regarding grant: |  | [NAME]6389 or [EMAIL]
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - September 15, 2014
Code | District Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY  2013 | AUGUST  2013 | SEPTEMBER  2013 | OCTOBER  2013 | NOVEMBER  2013 | DECEMBER  2013 | JANUARY  2014 | FEBRUARY  2014 | [NAME]  2014 | APRIL  2014 | MAY  2014 | JUNE  2014 | JULY  2014 | AUGUST  2014 | SEPTEMBER  2014
0070-99 | Westminster 50 | 122862 |  |  |  |  |  |  |  | 11600 |  | 50400 | 14290
0120-99 | Englewood 1 | 38660 |  |  |  |  |  | 38660
1540-99 | [NAME] 11 JT | 127962
1620-99 | Aguilar 6 | 100000 |  |  |  |  |  |  | 28040 |  |  |  | 70955
1810-99 | [NAME] | 131496 |  |  |  |  |  |  |  |  |  | 47924
2035-99 | Montezuma 1 | 35128
2405-99 | Ft. Morgan RE-3 | 137956 |  |  |  |  |  | 3333 |  | 19840 | 10664 |  | 3656
2530-99 | [NAME] RE-2 | 60729
Spreadsheet: 119385d1314363497-get-the-rating-automatically-new-microsoft-excel-worksheet
Sheet: Sheet1

 |  | 2.702587244283995 | ME
 |  | 3.088235294117647 | ME
 |  | 1.778947368421053 | AE |  |  | 1.00 -1.49 |  | EE
 |  | 1.73125 | AE |  |  | 1.50 - 2.49 |  | AE
 |  | 3.043405275779376 | ME |  |  | 2.50 - 3.49 |  | ME
 |  | 2.978636702722865 | ME |  |  | 3.50 - 4.49 |  | BE
 |  | 3.222358175750835 | ME |  |  | >=4.50 |  | UN
 |  | 2.422522982635342 | ME
 |  | 2.712061994609165 | ME
 |  | 3.05625 | ME
Spreadsheet: 691987d1597998480-countif-and-vlookup-assistance-excel-help
Sheet: Sheet1

 | Colour | Item | Baseline Date | F'cst Date
 | Blue | T-Shirt | 2020-08-20 00:00:00
 | White | T-Shirt |  |  |  | ???
 | Orange | T-Shirt |  |  |  | =if(D:D,"Jeans"(countifs(E:E,">"&I1,E:E,"<='&J1)
 | Blue | Jeans |  |  |  | =COUNTIFS($E$5:$E$19,">"&I1,$E$5:$E$19,"<="&J1)+
 | White | Jeans |  |  |  | =COUNTIFS(D5:D19,"Jumper")+COUNTIFS($E$5:$E$19,">"&I1,$E$5:$E$19,"<="&J1)
 | Orange | Jeans |  |  |  | =if(C2:C16,"Jumper"(countifs($D$2:$D$16,">"&H17,$D$2:$D$16,"<="&I17)))
 | Blue | Jumper
 | White | Jumper
 | Orange | Jumper
 | Blue | Socks
 | White | Socks
 | Orange | Socks
 | Blue | Shorts
 | White | Shorts
 | Orange | Shorts
 |  |  |  |  |  |  | 2020-08-14 00:00:00
 |  |  |  |  | ALL | BL
 |  |  |  |  |  | F'cst
 |  |  |  |  |  | Cumulative BL
 |  |  |  |  |  | Cumulative F'cst
 |  |  |  |  |  |  | 2020-08-14 00:00:00
 |  |  |  |  | Jumper | BL
 |  |  |  |  |  | F'cst
 |  |  |  |  |  | Cumulative BL
 |  |  |  |  |  | Cumulative F'cst
 |  |  |  |  |  |  | 2020-08-14 00:00:00
 |  |  |  |  | Socks | BL
 |  |  |  |  |  | F'cst
 |  |  |  |  |  | Cumulative BL
 |  |  |  |  |  | Cumulative F'cst
Spreadsheet: 531ec075-759b-4e4b-b74d-0bf658bd0798
Sheet: Sheet1

Sample Location: | Unnamed: 1 | FLOW | Unnamed: 3 | BOD | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | TSS | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | AMMONIA | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | ARSENIC | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | CADMIUM | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | [NAME] | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | COPPER | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | CYANIDE | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | LEAD | Unnamed: 45 | Unnamed: 46 | Unnamed: 47 | Unnamed: 48 | MERCURY | Unnamed: 50 | Unnamed: 51 | Unnamed: 52 | Unnamed: 53 | MOLYBDENUM | Unnamed: 55 | Unnamed: 56 | Unnamed: 57 | Unnamed: 58 | NICKEL | Unnamed: 60 | Unnamed: 61 | Unnamed: 62 | Unnamed: 63 | SELENIUM | Unnamed: 65 | Unnamed: 66 | Unnamed: 67 | Unnamed: 68 | SILVER | Unnamed: 70 | Unnamed: 71 | Unnamed: 72 | Unnamed: 73 | ZINC | Unnamed: 75 | Unnamed: 76 | Unnamed: 77 | Unnamed: 78 | OIL & GREASE | Unnamed: 80 | Unnamed: 81 | Unnamed: 82 | Unnamed: 83 | Unnamed: 84 | Chlorides | Unnamed: 86 | Unnamed: 87 | Unnamed: 88 | Unnamed: 89 | Total  Phosphorus | Unnamed: 91 | Unnamed: 92 | Unnamed: 93 | Unnamed: 94 | Conductivity | Unnamed: 96 | Unnamed: 97 | Unnamed: 98 | Unnamed: 99 | Sodium | Unnamed: 101 | Unnamed: 102 | Unnamed: 103 | Unnamed: 104 | Unnamed: 105 | Unnamed: 106 | Unnamed: 107
 |  |  |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated |  |  |  | Used in | Calculated
Sample Date |  | MGD |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day |  | < | mg/L | Calculation | lbs/day
Column Averages =>
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: OOC

Office of the Chair
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90006622 | HILLIS-HUMLICEK, KIMBERLY | [NAME] | ASSTEX-CS
90104420 | KITCHEN, LOUISE | Chief Operating Officer | MC-C
90012745 | LAVORATO, JOHN J | President & CEO | MC-C
90006336 | SCHOPPE, TAMMIE J | [NAME] | ASSTEX-CS
90006897 | TAYLOR, [NAME] | [NAME] | ASSTEX-CS
90013019 | WHALLEY, [NAME] | President and COO | MC-C
 |  | Employees
Spreadsheet: 749883d1633079029-formula-to-calculate-nssa-deductions-on-due-date-nssa-due-dates
Sheet: Sheet1

Kindly asking for a formula to calculate NSSA deductions on due date.
How to calculate NSSA deductions
If any employee earn less the ceiling, multiply basic salary by 4.5%
If any employee earn more than the ceiling, multiply ceiling by 4.5%
Period | January | February | March | April | May | June | July | August | September | October | November | December
NSSA RATES | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045
Ceiling | 5000 | 6000 | 8000 | 8000 | 8500 | 9000 | 9500 | 10000 | 10500 | 11000 | 11500 | 11500
Pay due date | 2021-01-25 00:00:00 | 2021-02-25 00:00:00 | 2021-03-25 00:00:00 | 2021-04-25 00:00:00 | 2021-05-25 00:00:00 | 2021-06-25 00:00:00 | 2021-07-25 00:00:00 | 2021-08-25 00:00:00 | 2021-09-25 00:00:00 | 2021-10-25 00:00:00 | 2021-11-25 00:00:00 | 2021-12-25 00:00:00
Desired Outcome
NSSA Deductions
Name | Date | Period | Basic Salary | Amount Paid | Deductions
[NAME] | 2021-08-25 00:00:00 | August | 8000 | 8000
[NAME] | 2021-08-25 00:00:00 | August | 11000 | 11000
[NAME] | 2021-08-15 00:00:00 | August | 20000 | 10000
[NAME] | 2021-08-25 00:00:00 | August | 20000 | 10000 | 0
[NAME] | 2021-08-15 00:00:00 | August | 9000 | 4000
[NAME] | 2021-08-25 00:00:00 | August | 9000 | 5000 | 0
[NAME] | 2021-08-25 00:00:00 | August | 16000 | 9000
[NAME] | 2021-09-10 00:00:00 | August | 16000 | 7000 | 0
Note: [NAME] and [NAME] were partly paid in advance and on due date. [NAME] was partly paid on due date and in arrears on 10/9/21
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -55850 | -55438
2 | -43999 | -43938
3 | -29392 | -29570
4 | -59280 | -59683
5 | -59827 | -59683
6 | -58120 | -57497
7 | -52462 | -52789
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  | 40121
 | 2001-08-07 00:00:00
CBS Dollars
 |  |  | -273307
Spreadsheet: 699187d1602447818-current-form-formula-team-charts-2020-21-sample
Sheet: Sheet1

Home only: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | Current W | Current D | Current L | Current unbeaten | Current winless | Current drawless
Bath City | W
Billericay Town | L
Braintree Town | L
Chelmsford City | D
[NAME] | W
Concord Rangers | D
[NAME] | W
Dorking Wanderers | W
[NAME]
[NAME] | L
Ebbsfleet United | D
Hampton & Richmond Borough | D
Havant & Waterlooville | D
[NAME] | L
Hungerford Town | W
Maidstone United | W
Oxford City | W
Slough Town | W
St Albans City | W
Tonbridge Angels | L
Welling United
Spreadsheet: 801089d1666080821-generate-list-based-on-multiple-criteria-list-active-projects-by-engineer-list-active-projects-by-engineer-eamono
Sheet: Sheet1

 | Status |  |  |  | Internal Code | customer name | project name | engineers assigned |  | List of what projects [NAME] is working on
 | Design |  |  |  | PLS2209166 | customer a | project name a | [NAME], TJ, [NAME] |  | [NAME]
 | TBA |  |  |  | PLS2209167 | customer b | project name b | [NAME], [NAME]
 | Lost |  |  |  | PLS2209168 | customer c | project name c | [NAME]
 | Feasibility |  |  |  | [NAME] | [NAME] | project name d | [NAME]
 | Lost |  |  |  | PLS2209170 | customer e | project name e | [NAME]
 |  |  |  |  |  | Option 1 |  |  |  |  | Option 2
 |  |  |  |  |  |  | project name a
 |  |  |  |  |  | [NAME] | project name d |  |  |  | [NAME]: project name d
 |  | List of ACTIVE projects [NAME] is working on
 |  | [NAME]
 |  | CONCATENATE(Internal Code b, project name b)
 |  | CONCATENATE(Internal Code d, project name d) |  |  |  | End Goal: list of active projects [NAME] works on. From Column B (status), any of "Design","Quoting","Feasibility","Post Design" are considered active
 |  | etc… |  |  |  | I've figured out how to get a list of internal codes for projects [NAME] works on. However, AND() doesn't return an array like IF() does, so it doesn't fit in my formula
 |  |  |  |  |  | I want to say IF cell[X,I] contains "[NAME]" AND cell[X,B] is one of "Design","Quoting","Feasibility","Post Design" then return true, RETURN AN ARRAY
 |  |  |  |  |  | Where I'm at now:
 |  |  |  |  |  | Current: | Expected: | infuriating, because hardcoding it works as expected:
 |  |  |  |  |  |  | False
 |  |  |  |  |  | True | True
 |  |  |  |  |  | True | False
 |  |  |  |  |  | False | False
 |  |  |  |  |  | True | True
 |  |  |  |  |  | False | False
Spreadsheet: 772164d1647029062-assign-points-in-a-calendar-2022-hourly-calendars-test
Sheet: Calendar

Name | Employee 3 |  |  |  | Payroll ID No. |  |  |  | Status |  |  | Ttl Pts |  |  |  |  | Total Available
January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March |  |  |  |  |  |  |  | April
Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat
 |  |  |  |  |  | 2022-01-01 00:00:00 |  |  |  | 2022-02-01 00:00:00 |  |  |  |  |  |  |  | 2022-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2022-04-01 00:00:00
 |  |  |  |  |  |  |  | 0 | 0
 |  |  | Test -->
May |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  | August
Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat
2022-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2022-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2022-07-01 00:00:00 |  |  |  | 2022-08-01 00:00:00
September |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thur | Fri | Sat
 |  |  |  | 2022-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2022-10-01 00:00:00 |  |  |  | 2022-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00
Spreadsheet: 724361d1616128622-check-multiple-dates-in-range-book2-8-ans
Sheet: Expenditure P90_P50

 | Project Name:
 | Project No:
 | Expenditure Profile Base Amount:
Mths | Item | Start Date | Complete Date
 | Initiation
18 | Strategic Assessment | 2020-06-01 00:00:00 | 2021-11-30 00:00:00
24 | Concept
 | Concept Development exc. Property Acquisitions
 | Property Acquisitions
18 | Delivery Readiness
 | Delivery Readiness exc. Property Acquisitions
 | Property Acquisitions
24 | Delivery
6 | Finalisation
 | Finalisation exc. Credited Cost
 | Cost Amount Credited to Project ( '-ve value - should schedule end of the project cash-flow)
 | Total Estimate Base Amount
 | Cash Flow Base (Current $):
 | Expenditure Profile P50:
Mths on base | Item | Start Date | Complete Date
 | Initiation |  |  |  | =$[NAME]<SUMPRODUCT(($B$69:$B$85=$B36)*($C$69:$C$85)) | =$[NAME]>SUMPRODUCT(($B$69:$B$85=$B36)*($D$69:$D$85))
3 | Strategic Assessment | 2020-06-01 00:00:00
3 | Concept
 | Concept Development exc. Property Acquisitions
 | Property Acquisitions
6 | Delivery Readiness
 | Delivery Readiness exc. Property Acquisitions
 | Property Acquisitions
3 | Delivery
3 | Finalisation
 | Finalisation exc. Credited Cost
 | Cost Amount Credited to Project ( '-ve value - should schedule end of the project cash-flow)
 | Total Estimate P50
 | Total cost distribution
 | Adjustment factor excluding property:
 | Total cost distribution excluding property
 | Adjustment factor for property:
 | Property cost distribution
 | Cost Amount Credited to Project
 | Cash Flow P50:
 | Expenditure Profile P90:
Mths on base | Item | Start Date | Complete Date
 | Initiation
6 | Strategic Assessment | 2020-06-01 00:00:00
6 | Concept
 | Concept Development exc. Property Acquisitions
 | Property Acquisitions
12 | Delivery Readiness
 | Delivery Readiness exc. Property Acquisitions
 | Property Acquisitions
6 | Delivery
6 | Finalisation
 | Finalisation exc. Credited Cost
 | Cost Amount Credited to Project ( '-ve value - should schedule end of the project cash-flow)
 | Total Estimate P90
 | Total cost distribution
 | Adjustment factor excluding property:
 | Total cost distribution excluding property
 | Adjustment factor for property:
 | Property cost distribution
 | Cost Amount Credited to Project
 | Cash Flow P90:
Spreadsheet: 713836d1610966210-evaluate-date-range-for-last-date-in-year-semi-annual-quarter-and-year-daterange-ans
Sheet: Sheet5

Dates | YrEnd | Semi Annual end | Qtr end | Month end
2006-01-03 00:00:00
2006-01-13 00:00:00
2006-01-30 00:00:00
2006-01-31 00:00:00
2006-02-01 00:00:00
2006-02-02 00:00:00
2006-02-24 00:00:00
2006-02-27 00:00:00
2006-02-28 00:00:00
2006-03-01 00:00:00
2006-03-10 00:00:00
2006-03-20 00:00:00
2006-03-31 00:00:00
2006-04-03 00:00:00
2006-04-18 00:00:00
2006-04-19 00:00:00
2006-04-20 00:00:00
2006-05-01 00:00:00
2006-05-16 00:00:00
2006-05-30 00:00:00
2006-05-31 00:00:00
2006-06-01 00:00:00
2006-06-27 00:00:00
2006-06-28 00:00:00
2006-06-29 00:00:00
2006-06-30 00:00:00
2006-07-03 00:00:00
2006-07-05 00:00:00
2006-07-17 00:00:00
2006-08-01 00:00:00
2006-08-24 00:00:00
2006-09-01 00:00:00
2006-09-05 00:00:00
2006-09-20 00:00:00
2006-09-29 00:00:00
2006-10-02 00:00:00
2006-10-19 00:00:00
2006-10-27 00:00:00
2006-11-01 00:00:00
2006-11-30 00:00:00
2006-12-01 00:00:00
2006-12-26 00:00:00
2006-12-27 00:00:00
2006-12-28 00:00:00
2006-12-29 00:00:00
2006-12-30 00:00:00
2006-12-31 00:00:00
2007-01-01 00:00:00
2007-01-02 00:00:00
2007-01-03 00:00:00
Spreadsheet: 5608e4db-d384-40db-8481-b9fb6487ab7d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
3158 | 12776 | [NAME] | [NAME] | MEX | 0 | 00:08:49 | 00:00:22 | 00:15:00 | 00:00:29 | 00:08:53 | 1 | [NAME]
3158 | 17361 | Marina | Saucedo | MEX | 0 | 00:09:05 | 00:00:22 | 00:14:49 | 00:00:28 | 00:10:59 | 2 | 00:35:43
3158 | 76188 | Amalia Isabel | [NAME] | MEX | 0 | 00:09:58 | 00:00:22 | 00:15:29 | 00:00:27 | 00:11:37 | 3 | 00:37:53
3158 | 17235 | Judge | Jones | USA | 0 | 00:09:43 | 00:00:37 | 00:17:04 | 00:00:46 | 00:10:28 | 4 | 00:38:38
3158 | 17360 | [NAME] | Flores | MEX | 0 | 00:10:07 | 00:00:24 | [NAME] | 00:00:34 | 00:11:05 | 5 | [NAME]
3158 | 17363 | Neyra Ninel | Gutierrez | MEX | 0 | 00:10:34 | 00:00:24 | 00:16:03 | 00:00:32 | 00:11:40 | 6 | 00:39:13