tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 784658d1655893179-lookup-previous-price-in-price-list-previous-price-to-be-troubleshooted
Sheet: Price List

Date | Site | Supplier | P/N | MOQ | Price | Previous Price With Exact MOQ | Previous Price With Exact Or Closest MOQ
2022-06-21 00:00:00 | Paris | S1 | 123 | 10 | 12 |  |  |  | Task:
2022-06-21 00:00:00 | Paris | S1 | 258 | 30 | 16.5 |  |  |  | Lookup previous price matching with Site, [NAME], P/N and MOQ. If MOQ does not match, look for the closest (= smalest difference) salue in the previous price record instead.
2022-06-21 00:00:00 | Paris | S1 | 258 | 60 | 12.6 |  |  |  | If the previous price does not exist for the criteria above, show "-".
2022-06-21 00:00:00 | Prague | S1 | 456 | 100 | 6.8
2022-06-21 00:00:00 | Prague | S1 | 456 | 1000 | 4.5
2022-06-21 00:00:00 | Prague | S1 | 456 | 10000 | 3.8
2022-06-18 00:00:00 | London | S2 | 147 | 100 | 15
2022-06-18 00:00:00 | Paris | S2 | 123 | 20 | 10.6
2022-06-18 00:00:00 | Paris | S2 | 159 | 1000 | 14
2022-06-18 00:00:00 | Prague | S2 | 369 | 4500 | 13
2022-06-18 00:00:00 | Prague | S2 | 369 | 13500 | 10.1
2022-06-18 00:00:00 | Prague | S2 | 369 | 26000 | 8.2
2022-05-15 00:00:00 | Prague | S3 | 369 | 4500 | 12
2022-05-15 00:00:00 | Prague | S3 | 369 | 26000 | 7.4
2022-04-18 00:00:00 | Paris | S1 | 123 | 10 | 14
2022-04-18 00:00:00 | Paris | S1 | 258 | 30 | 17
2022-04-18 00:00:00 | Paris | S1 | 258 | 60 | 13
2022-04-18 00:00:00 | Prague | S1 | 456 | 100 | 6.8
2022-04-18 00:00:00 | Prague | S1 | 456 | 1000 | 4.2
2022-04-18 00:00:00 | Prague | S1 | 456 | 10000 | 3.8
2022-03-30 00:00:00 | Prague | S3 | 369 | 4500 | 13
2022-03-30 00:00:00 | Prague | S3 | 369 | 26000 | 6.5
2022-03-05 00:00:00 | London | S2 | 147 | 100 | 14
2022-03-05 00:00:00 | Paris | S2 | 123 | 20 | 14.3
2022-03-05 00:00:00 | Paris | S2 | 159 | 500 | 13 |  |  | should return 16,5 from F46
2022-03-05 00:00:00 | Prague | S2 | 369 | 6000 | 12 |  |  | should return 12 from F27
2022-03-05 00:00:00 | Prague | S2 | 369 | 13500 | 9.9 |  |  | should return 9,1 from F44
2022-03-05 00:00:00 | Prague | S2 | 369 | 26000 | 7.2
2022-03-05 00:00:00 | Paris | S2 | 159 | 100 | 20
2022-01-14 00:00:00 | Paris | S1 | 123 | 10 | 13
2022-01-14 00:00:00 | Paris | S1 | 258 | 30 | 16.5 |  |  | should return 11,2 from F33
2022-01-14 00:00:00 | Paris | S1 | 258 | 60 | 11.2
2022-01-14 00:00:00 | Prague | S1 | 159 | 200 | 17
2022-01-14 00:00:00 | Prague | S1 | 456 | 100 | 7
2022-01-14 00:00:00 | Prague | S1 | 456 | 1000 | 4.5
2022-01-14 00:00:00 | Prague | S1 | 456 | 10000 | 2.1
2021-12-22 00:00:00 | Prague | S3 | 369 | 4500 | 11
2021-12-22 00:00:00 | Prague | S3 | 369 | 26000 | 6.3
2021-12-19 00:00:00 | London | S2 | 147 | 100 | 16
2021-12-19 00:00:00 | Paris | S2 | 123 | 20 | 10.6
2021-12-19 00:00:00 | Paris | S2 | 159 | 1000 | 12
2021-12-19 00:00:00 | Prague | S2 | 369 | 4500 | 11
2021-12-19 00:00:00 | Prague | S2 | 369 | 10000 | 9.1
2021-12-19 00:00:00 | Prague | S2 | 369 | 26000 | 8.2
2021-12-19 00:00:00 | Paris | S2 | 159 | 100 | 16.5
Spreadsheet: 866091d1713026380-coordinate-conversion-1900-md-state-plane-coordinate-conversions-md-1900-2-calcs-
Sheet: Maryland Example

Calculations found here: |  | https://geodesy.noaa.gov/library/pdfs/Special_Publication_62_4.pdf
 | [NAME]. 3
 |  | Maryland Constants
 |  | L1 | 800000
 |  | L2 | 277200
 |  | L3 | 25989474.99
 |  | [NAME] | 26369112.76
 |  | L5 | 0.9999498485
 |  | L6 | 0.6276341196
 |  | L7 | 2332
 |  | L8 | 59.69369
 |  | L9 | 3.81166
 |  | L10 | 3.67392
 |  | L11 | 0
 |  |  |  | Constant
Coordinates to State Plane |  |  |  | 10^8
 | Degree | Minutes | Seconds
Φ (Lat) | 37 | 52 | 48
ʎ (Long) | 76 | 29 | 24
 |  |  |  | Lat Seconds/3600
Easting (x) |  |  | Length of meridional arc | s
Northing (y) |  |  | Radius | R
 |  |  | Degree and minutes | Φ'
 |  |  | Remainder in seconds | Φ''
 |  |  |  | [NAME]
 |  |  |  | cosΦ
 |  |  | Theta | Θ
 |  |  |  | sinΘ
 |  |  |  | sin(Θ/2)
 |  |  | Easting | x
 |  |  | Northing | y
 |  |  | Scale Factor | K
State Plane to Coordinates
 |  |  |  | x/y
Easting (x) | 595393.676 |  | Theta | Θ
Northing (y) | 800019.615 |  | Dec. Degree of Theta | Θ for ʎ
 |  |  | Long. in Seconds | ʎ
 |  |  | Long. Dec. Degree | ʎ/3600
[NAME]
Decimal Long |  |  | Radius | R
 |  |  |  | s1
 |  |  |  | s2
 |  |  |  | s3
 |  |  |  | s
 |  |  | Rectifying Latitude | w' |  | w' (decimal degrees)
 |  |  | (omega) | w'' |  | w''(decimal degrees)
 |  |  |  | w |  | w (decimal degrees)
 |  |  |  | sinw
 |  |  |  | cosw
 |  |  | Phi | Φ' |  | Φ' (decimal degrees)
 |  |  |  | Φ'' |  | Φ''(decimal degrees)
 |  |  |  | Φ |  | Φ(decimal degrees)
 |  |  | Use Theta for | cosΘ
 |  |  | these constants | sin(Θ/2)
Spreadsheet: 153225d1335808721-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: dec 12

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-12-12 00:00:00 | 2011-12-13 00:00:00 | 2011-12-14 00:00:00 | 2011-12-15 00:00:00 | 2011-12-16 00:00:00 | 2011-12-17 00:00:00
[NAME] |  | 8:30-5:30 | 8:00-5:00 | 9:00-5:00 | 8:30-5:30 | 9:15-5:15
 | off | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 9:30-5:30 |  | Christmas | 8:30-5:30 | 9:15-5:15
 | 2:00-3:00 | 2:00-3:00 | off |  | 2:00-3:00 | n/l
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | off | 9:00-5:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 1:00-2:00
Mark | 8:30-5:30 | 9:00-5:00 | 8:30-5:30 | 8:30-5:30 | 8:00-4:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00
[NAME] | 8:00-4:00 | Christmas | 8:30-5:30 | 7:00-4:00-HOMER | 9:30-5:30-counter
ctr 12-2 | 11:00-12:00 |  | 11:00-12:00 | 12:00-1:00 | 11:00-12:00
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 732276d1620854807-add-total-in-column-of-corresponding-data-data
Sheet: Sheet1

CODE | 2020 | 2021 |  |  |  | DATA FROM OTHER SYSTEM
(CODE01) GREEN |  |  |  |  |  | 2020 | TOTAL | 2021 | TOTAL
(CODE02) BLUE |  |  |  |  |  | (CODE03) RED | 60 | (CODE10) SILVER | 96 |  | DATA IS OBTAINED FROM ANOTHER SYSTEM AND PASTED INTO COLUMN G - H AND I-J.  THERE IS NOT ALWAYS DATA FOR ALL THE CODES AND THE TOTAL MUST REFLECT 0 (ZERO) IF THERE IS NO DATA OTHERWISE IT MUST REFLECT THE FIGURE IN COLUM H & J OF THE RESPECTIVE YEARS
(CODE03) RED |  |  |  |  |  | (CODE06) PURPLE | 29 | (CODE05) YELLOW | 59
(CODE04) ORANGE |  |  |  |  |  | (CODE01) GREEN | 20 | (CODE03) RED | 39
(CODE05) YELLOW |  |  |  |  |  | (CODE05) YELLOW | 16 | (CODE06) PURPLE | 29
(CODE06) PURPLE |  |  |  |  |  | (CODE10) SILVER | 16 | (CODE01) GREEN | 27
(CODE07) [NAME]
(CODE08) BROWN
(CODE09) GOLD
(CODE10) SILVER
Spreadsheet: 272912d1382545553-referencing-values-above-the-last-cell-in-a-row-dates-jacc
Sheet: Sheet1

 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00 | 2013-10-27 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00
Accumulative Absences |  |  |  |  |  |  |  |  |  |  |  |  |  | Not required to attend          (all sessions on sheet) |  | Total Individual absences up to last date entered
Dates of Each Session
[NAME] | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  | < should be 4 as student only has 4 sessions not to attend up to last date on sheet
[NAME] | n | n |  |  |  |  |  |  | n | n |  |  |  |  |  |  | < should be 2 as student has 2 sessions not to attend up to last date on sheet
[NAME] |  |  |  |  |  |  |  |  | n | n |  |  |  |  |  |  | < should be 0 as student has 0 sessions not to attend up to last date on sheet
[NAME] | n | n |  |  |  |  |  |  | n | n |  |  |  |  |  |  |  |  |  |  | <Todays Date
[NAME] | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  |  |  | 2013-10-18 00:00:00 | Dates of all sessions entered here. These then appear in each "Dates of Each Session" cells if they are =< today's date.
George | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  |  |  | 2013-10-19 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-20 00:00:00
Harold |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-21 00:00:00
Trevor |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-22 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-23 00:00:00
Mark |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-24 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-25 00:00:00
[NAME] |  |  | n | n |  |  | n | n |  |  | n | n |  |  |  |  |  |  |  | 2013-10-26 00:00:00
 |  |  |  |  |  |  |  |  |  | Sum of all the "n" on the sheet > |  |  |  |  |  |  | <Total of all individual absences entered up to last date |  |  | 2013-10-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-28 00:00:00
Total Absences up to last date entered = |  |  |  |  | < result of formula in this cell should be 13 by correctly referencing (H2) as that is the total of the accumulative absences up to the last date entered on the form (H3) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-10-30 00:00:00
 |  |  |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/963241-referencing-values-above-the-last-cell-in-a-row.html
Spreadsheet: e8c525ec-1209-4ccc-86f8-0da7661cf079
Sheet: Sheet1

Supplementary Table 1: An overview of the most complete microsporidian genomes sequenced to date including the sequencing techniques as well as key features of the genomes based on the original papers and our own analyses. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Organism | Estimated genome size | Available sequence | Number of contigs | Sequencing technology | Number of ORF | GC content | Known hosts | Reference
E. cuniculi | 2.9 Mb | 2.5 Mb | 11 chromosomes | Sanger | 1997 | 47 | rabbit, mouse, human | Katinka MD, Duprat S, Cornillot E, [NAME], Thomarat F et al. (2001) Nature 414: 450-453.
E. intestinalis | 2.3 Mb | 2.2 Mb | 11 chromosomes | Solexa | 1833 | 41 | human | Corradi N, [NAME], [NAME], Didier ES, Keeling PJ. (2010) [NAME]. [NAME]. 1: Article 77.
E. bieneusi | 6 Mb | 3.86 Mb | 1742 | Sanger | 3804* | 25 | human | [NAME], Morrison HG, [NAME], [NAME], Zhang Q et al. (2009) [NAME]. 5:e1000261
[NAME] | 7.7 - 9.8 Mb | 7.86 Mb | 5465 | 454 GS FLX | 2614 | 26 | honey bees | Cornman RS, [NAME], [NAME], Street C, Zhao Y et al. (2009) [NAME]. 5:e1000466
T. hominis | 11.6Mb1 | 8.5 Mb | 310 | 454FLX Titanium + SOLiD | 3266 | 34 | human, mosquitoes | this study
*The E. bieneusi ORF number may not be reliable as the genome data for this species (which cannot be cultured) appear to be compromised by an unknown amount of bacterial contamination - see Table S7 and Figure S9.
1This genome size estimate is based on the total length of assembled 454 reads (378,359,925bp) and the coverage estimate (32.5X).
Spreadsheet: 830551d1684968986-payment-schedule-based-on-term-60-84mo-etc-book2-8-
Sheet: Payment Plan

 |  |  |  |  |  |  |  |  |  |  | 2023-06-30 00:00:00 |  | 2024-06-30 00:00:00 |  | 2025-06-30 00:00:00 |  | 2026-06-30 00:00:00 |  | 2027-06-30 00:00:00 |  | 2028-06-30 00:00:00 |  | 2029-06-30 00:00:00 |  | 2030-06-30 00:00:00 |  | 2031-06-30 00:00:00
Account | Division | Quote | Quote Description | Purchase Cost | MSA- Monthly Payment Installment | Monthly Support | Amendment Number(s) | Amendment Net Change in Monthly Payment Installment | Confirmed TBD | [NAME] Notes | FY23 Total Months (July 1, 2022-June 30, 2023) | FY23 Total | FY24 Total Months (July 1, 2023-June 30, 2024) | FY24 Total | FY25 Total Months (July 1, 2024- June 30, 2025 | FY25 | FY26 Total Months (July 1, 2025- June 30, 2026) | FY26 Total | FY27 Total Months (July 1, 2026- June 30, 2027) | FY27 Total | FY28 Total Months (July 1, 2027- June 30, 2028) | FY28 Total | FY29 Total Months (July 1, 2028- June 30, 2029) | FY29 Total | FY29 Total Months (July 1, 2029- June 30, 2030) | FY30 Total | FY29 Total Months (July 1, 2030- June 30, 2031) | FY31 Total |  | TOTAL CAPX Project
1 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
2 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
3 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
4 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
5 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
6 |  |  |  | 500000 |  |  |  |  | 2023-11-01 00:00:00
7 |  |  |  | 500000 |  |  |  |  | 2023-09-01 00:00:00
8 |  |  |  | 500000 |  |  |  |  | 2022-07-01 00:00:00
9 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
10 |  |  |  | 500000 |  |  |  |  | 2023-06-01 00:00:00
11 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
12 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
13 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
14 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
15 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
16 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
17 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
18 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
19 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
20 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
21 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
22 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
23 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
24 |  |  |  | 500000 |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Spreadsheet: 155738d1337021806-excel-2007-field-calculation-based-on-conditional-formatting-results-and-text-dropdown-picks-r2-20sample-1-
Sheet: (Drop Down Lists)

Regions | %  Complete | Region II Groups | %  Complete | Support SubGroups | %  Complete | Response SubGroups | %  Complete | Recovery SubGroups | %  Complete | Preparedness SubGroups | %  Complete | Mitigation  SubGroups | %  Complete | Administration SubGroups | %  Complete
Region I |  | Support |  | Admin/Finance |  | Integration |  | Private |  | Legal |  | Insurance |  | External Affairs
Region II |  | Response |  | I T |  | Planning |  | Government |  | Analysts |  | Assistance |  | Counsel
Region III |  | Recovery |  |  |  | Logistics |  |  |  | Technological |  | Analysis |  | Management
 |  | Preparedness |  |  |  | Communications |  |  |  | Integration
 |  | Mitigation
 |  | Administration
 |  | Employee Types | %  Complete
 |  | Permanent |  | Yes/No
 |  | Student |  | Yes
 |  | Temporary |  | No
Spreadsheet: 820360d1678060116-how-to-tweak-formula-to-change-calendar-to-include-date-range-book_251717-4
Sheet: Sheet1

Date
Thursday |  | Event Name | Primary Contact | Event Location | Online
2023-09-28 00:00:00 |  | Event 1 ya | Contact 1 | Online
 |  | Event 6 now
Friday
2023-09-29 00:00:00
Saturday
2023-09-30 00:00:00
Sunday
2023-10-01 00:00:00
Monday
2023-10-02 00:00:00
Tuesday
2023-10-03 00:00:00
Weds
2023-10-04 00:00:00
Thursday
2023-10-05 00:00:00
Friday
2023-10-06 00:00:00
Saturday
2023-10-07 00:00:00
Sunday
2023-10-08 00:00:00
Spreadsheet: 271227d1381866805-average-of-two-columns-by-criteria-school-paper-submission-duration
Sheet: Sheet1

School 1 |  | School 2
Subject Category | No. of papers submitted | Category | No. of papers submitted |  |  | Average no. of papers submitted
Physics |  | Chemistry | 14 |  | Physics
Physics | 2 | Biology |  |  | Chemistry
Physics |  | Chemistry |  |  | Maths
Chemistry |  | Maths |  |  | Biology
Maths | 30 | Biology | 30
Biology |  | Physics | 30
Biology |  | Physics
Biology | 27 | Chemistry | 12
Chemistry |  | Biology
Chemistry | 25 | Chemistry | 51
Maths |  | Physics
Physics |  | Biology | 14
Biology | 22 | Maths | 18
Biology |  | Biology | 67
Spreadsheet: 848034d1698843301-conditional-formatting-with-transposed-data-book1
Sheet: Sheet3

 |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  | velit & dolore | nulla & sint | non & in | officia & anim | laborum. & perspiciatis | iste & sit | doloremque & rem | ipsa & illo | et & beatae | sunt & enim | quia & aspernatur | aut & quia | dolores & ratione | nesciunt. & quisquam | dolorem & dolor | consectetur, & sed | numquam & tempora | labore & magnam | voluptatem. & ad | quis & ullam | laboriosam, & aliquid | commodi & autem | iure & in | velit & nihil | vel & dolorem | quo & pariatur?
Spreadsheet: 274220d1383053500-grid-formula-aaaform
Sheet: Sheet1

WIDTH | 3.1 |  | DEPTH | 2.5 |  |  | YES
WIDTH | 3000 | 3600 | 4200 | 4800 | 5400 | 6000 | 6600
DEPTH
2500 | 3416 | 3597 | 3778 | 4032 | 4232 | 4299 | 4466
3000 | 3756 | 4003 | 4180 | 4426 | 4732 | 4946 | 5199
3500 | 4034 | 4267 | 4448 | 4813 | 4993 | 5332 | 5473
4000 | 4209 | 4519 | 4732 | 4948 | 5277 | 5596 | 5707
COST
Spreadsheet: 861317d1709216174-write-off-report-monthly-ytd-automation-scrapping-report
Sheet: Sheet2

 |  |  | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2022-02-01 00:00:00 | 2023-02-01 00:00:00 | 2022-03-01 00:00:00 | 2023-03-01 00:00:00 | 2022-04-01 00:00:00 | 2023-04-01 00:00:00 | 2022-05-01 00:00:00 | 2023-05-01 00:00:00 | 2022-06-01 00:00:00 | 2023-06-01 00:00:00 | 2022-07-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00
 |  |  | 178020.619999999 | 131118.09 | 367970.77 | 134803.9 | 443540.610000001 | 129239.57 | 127030.58 | 504315.9699999999 | 269638.390000001 | 512208.4399999998 | 174688.079999999 | 250972.69 | 188241.5 | 139643.34 | 88050.62
 |  | Month | 2022 | 2023
 |  | JAN | 178020.619999999 | 131118.09
 |  | FEB | 367970.77 | 130260.69
 |  | MAR | 443540.610000001 | 128705.97
 |  | APR | 127030.58 | 504292.38
 |  | MAY | 269638.390000001 | 512208.44
 |  | [NAME] | 174688.079999999 | 250972.69
 |  | JULY | 188241.5 | 139643.34
 |  | AUG | 115631.32 | 88050.62
 |  | SEPT | 112963.26 | 74593.61
 |  | OCT | 128622.42 | 61110.53599999999
 |  | NOV | 177984.14 | 85383.91
 |  | DEC | 254389.63 | 79407.83
Spreadsheet: 93508d1293066840-conditional-sum-on-multiple-criteria-with-only-1st-occurance-example
Sheet: Criteria

Site Improvements | Demolition | Site Preparation | Utilities | Subsurface Investigation | Earthwork | Paving & Surfacing | Landscaping | Exterior Improvements | Sewerage & Drainage
Concrete Paving | Demolition | Preparation | Site Utilities | Subsurface Investigation | Earthwork | Blocking | Landscaping | Exterior Improvements | Sewerage & Drainage
Curb & Gutter | Demolition & Structure Moving | Site Clearing | Utilities | Tunneling | Soil Treatment | Paving & Surfacing
Fencing | [NAME] | Staking | Utility Piping Materials
Improvements | Dumpsters | Survey
Landscape & Irrigation | Selective Demolition | Temporary Fencing
Retaining Wall | Solid Waste Handling
Sidewalks
Site Improvement
Site Improvements
Temporary Fence
Trash Removal
Walks
Walls
[NAME]:
0 | 5000 | 2000 | 0 | 1000 | 5000 | 25000 | 34000 | 0 | 5000
Spreadsheet: 96c58242-1445-42d4-8a57-b131e4c43f21
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Ellis | Marjorie | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Thompson | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Whitehurst-McLean | Makitta | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | Cameron | Helene | [EMAIL] | [PHONE] |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Edwards | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Hembrick | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Bullock | Marcy | [EMAIL] | [PHONE] |  | Patterson Hall 111 | Box 7642 | Raleigh | NC | 27695-7642
UNC Asheville | Vacant |  |  | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Angle | Ray | [EMAIL] | [PHONE] |  | 211 Carr Building | CB #5000 | Chapel Hill | NC | 27599-5000
UNC Greensboro | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | [NAME] 26170 |  | Greensboro | NC | 27402-6170
UNC Pembroke | Pruett | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Rakes | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
Winston-Salem State University | Sloan | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
Spreadsheet: 707684d1607422309-excel-2016-vlookup-issue-with-dropdown-raid-log
Sheet: Dropdowns

 |  |  |  |  |  |  |  |  | Risk Score | Impact Score
Actions |  |  |  |  |  |  |  |  | 1 | 1
Menu | Description |  | Menu | Description |  |  |  |  | 2 | 2
High | Complete in 1 - 2 days |  | Priority |  |  |  |  |  | 3 | 3
Medium | Complete in 1 week |  | High | This Action must be resolved for progress to be made. |  |  |  |  | 4 | 4
Low | Complete in 1 to 2 weeks |  | Medium | This impacts the project, but doesn’t stop progress. |  |  |  |  | 5 | 5
 |  |  | Low | A low impact on the project. Perhaps optional to fix.
 |  |  | Status
 |  |  | Open | In progress
 |  |  | Pending | Waiting on action by another party
 |  |  | Resolved | Resolved pending agreement from customer/sponsor
 |  |  | Closed | Closed as agreed by customer/sponsor
Risk |  |  | Catagory
Menu | Description |  | Risk
Probability |  |  | Issue
Almost Certain | Will occur
Likely | Very likely that this risk will occur/happen.
Possible | 50/50 chance that this risk will occur. |  | Status
Unlikely | Low probability that this risk will occur. |  | Open | In progress
Rare | Will not occur |  | Pending | Waiting on action by another party
 |  |  | Closed | Closed as agreed by customer/sponsor
Impact
Severe
Major | This would badly impact the project e.g. cost, delay, quality.
Moderate | A manageable impact on the project.
Minor | A low impact on the project.
Insignificant
[NAME]
Extreme | Stoppage
High | Major Risk
Medium | At risk
Low | On target
Type
Schedule
Financial
Scope
Operational
Technical
Governance
Compliance
Environmental
Reputational
Issues
Menu | Description
Priority
High | This issue must be resolved for progress to be made.
Medium | This impacts the project, but doesn’t stop progress.
Low | A low impact on the project. Perhaps optional to fix.
Status
Open | In progress
Pending | Waiting on action by another party
Resolved | Resolved pending agreement from customer/sponsor
Closed | Closed as agreed by customer/sponsor
Spreadsheet: 327d5c9d-ed92-4bdd-88f1-a76a522ea07e
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2007-04-18 | 1 | Providence | 1 | Hartford | 5 | Final | Hartford Civic Center Veterans Memorial Coliseum Hartford, CT
2007-04-20 | 2 | Providence | 4 | Hartford | 2 | Final | Hartford Civic Center Veterans Memorial Coliseum Hartford, CT
2007-04-21 | 3 | Hartford | 5 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2007-04-24 | 4 | Hartford | 1 | Providence | 5 | Final | Dunkin' Donuts Center Providence, RI
2007-04-26 | 5 | Hartford | 1 | Providence | 0 | Final | Dunkin' Donuts Center Providence, RI
2007-04-28 | 6 | Providence | 5 | Hartford | 2 | Final | Hartford Civic Center Veterans Memorial Coliseum Hartford, CT
2007-04-29 | 7 | Providence | 5 | Hartford | 4 | Final | Hartford Civic Center Veterans Memorial Coliseum Hartford, CT
2007-05-01 | 1 | Providence | 6 | [NAME] | 3 | Final | [NAME] [NAME], NH
2007-05-02 | 2 | Providence | 1 | [NAME] | 4 | Final | [NAME] [NAME], NH
2007-05-08 | 3 | [NAME] | 1 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2007-05-09 | 4 | [NAME] | 3 | Providence | 2 | Final | Dunkin' Donuts Center Providence, RI
2007-05-12 | 5 | Providence | 3 | [NAME] | 4 | Final | [NAME] [NAME], NH
2007-05-14 | 6 | [NAME] | 2 | Providence | 1 | Final | Dunkin' Donuts Center Providence, RI