tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 684938d1593622934-sumproduct-returning-value-error-bankstest
Sheet: Log

 | TIME RECORDING FOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FISCAL YEAR: |  |  |  |  |  | 2020-07-01 00:00:00
 | ACTIVITY CODES
 | 1 | Plan Review |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | Research |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  | Break/Lunch
 | 2 | Discipline Review (BU, EL, PL, ME, EN) |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  | Correspondence (Email/Phone Calls) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  |  | AAB Review
 | 3 | Level One Application |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | Discussion |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  | IB Review
 | 4 | LPG/F&C |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | Miscellaneous |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  | Board Meeting
 | 5 | Duplicate Certificates of Occupancy |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  | RTK/Subpoenas
 | Date |  | Time |  | Time Spent | Calendar Week | Fiscal Week |  | Activity Code |  | File Number |  |  |  |  |  | Review Type F/P |  | # Sheets Total |  |  |  | Notes
 |  |  | Start | Stop
 | 2020-07-03 00:00:00 |  | 8:30:00 | 12:00:00 |  |  |  |  | 1
 | 2020-07-05 00:00:00 |  | 8:30:00 | 12:00:00 |  |  |  |  | 1
 | 2020-07-06 00:00:00 |  | 8:30:00 | 12:00:00 |  |  |  |  | 1
 | 2020-07-04 00:00:00 |  | 8:30:00 | 12:00:00 |  |  |  |  | 1
 | 2020-07-03 00:00:00 |  | 8:30:00 | 12:00:00 |  |  |  |  | 1
Spreadsheet: 711275d1609585766-countif-with-data-validation-workbook
Sheet: Dates for month

Dates
Spreadsheet: 154424d1336420434-sumif-problem-with-subtotals-sumif-problem
Sheet: Sheet1

ship_zip | Weight | Use of Semis if over 18000lbs | [NAME] | [NAME]/gl | [NAME]/gl | Reefer 7hrs/day * consumption | Total Fuel Cost | Zones
90058
90003 | 397 |  | 6.1 |  |  |  |  | 1
90003 | 1083.8 |  | 1.6 |  |  |  |  | 1
90037 | 3485.83 |  | 3.2 |  |  |  |  | 1
90044 | 1387.64 |  | 2.3 |  |  |  |  | 1
90003 | 773.62 |  | 1.6 |  |  |  |  | 1
90001 | 423.69 |  | 2.1 |  |  |  |  | 1
90058 |  |  | 4.4
 | 7551.58 | 0 | 21.3 | 3.276923076923076 |  | 3.5 | 0
90058
90003 | 699 |  | 7.2 |  |  |  |  | 1
90059 | 240 |  | 3.6 |  |  |  |  | 1
90731 | 2320.35 |  | 14.1 |  |  |  |  | 2
90710 | 955.67 |  | 6.9 |  |  |  |  | 2
90745 | 2598 |  | 2.6 |  |  |  |  | 2
90502 | 2925.5 |  | 1.8 |  |  |  |  | 2
90247 | 495.72 |  | 4.2 |  |  |  |  | 1
90061 | 294.9 |  | 3.8 |  |  |  |  | 1
90058 |  |  | 10.1
 | 10529.14 | 0 | 54.3 | 8.353846153846153 |  | 3.5 | 0
Spreadsheet: 143755d1330549258-filter-a-rollup-workbook-by-month-with-data-from-other-workbook-tu-tracking
Sheet: Rollup

Tune up Tracking
 | T/U Entered | Booked T/U's | Bk % | Completed T/U's | Run % | [NAME] | Rev per T/U | Jobs > $2k | Close %
Store 1
Store 2
Store 3
Store 4
Store 5
Store 6
Spreadsheet: 161880d1339667468-excel-2007-counting-date-in-specific-month-by-month-book1
Sheet: Sheet1

 |  | 6 | 7 | 8 | 9 | 10
2012-06-28 00:00:00 | 2012-07-03 00:00:00 | 3 | 2 | 0 | 0 | 0
2012-06-13 00:00:00 | 2012-06-15 00:00:00 | 2 | 0 | 0 | 0 | 0
2012-06-20 00:00:00 | 2012-10-05 00:00:00 | 11 | 31 | 31 | 30 | 4
Spreadsheet: 228806d1366216200-copying-data-between-sheets-based-on-unique-ids-excel-example-sheet
Sheet: Network Bandwith Information

Site ID (Site Code) | Cascade site | WAN Site ID | Network Bandwidth | Network Technology | IDM Population | IDM Contractor Population | 17 Lat | 18 Lng
mum |  |  |  | VPN |  |  | saxa | m,ms.[NAME],f
dad |  |  |  | VPN |  |  | saa | mnmm n
work |  |  | 100 | Ethernet |  |  | sdadad | mn,mn,h
pop |  |  | 100 | Ethernet | 84 | 6 | sdsada | sd,mnsf
boib |  |  |  | VPN | 3 | 1 | sdsada | m.,m.;llo
nil |  |  | 1.544 | T1 | 1 | 1 | sadsada | nmplk;l
wdew |  |  | 1.544 | T1 | #N/A | #N/A | j.,l;oi;ok | [NAME]
wewe |  |  | 2.048 | E1 | 29 | 3 | ,.,k.lk;lk;l | lklknlks
Spreadsheet: 3bdb3f73-c6ac-4f18-bd43-1c66f48d0374
Sheet: Sheet1

Table 1--Wheat: U.S. market year supply and disappearance, 11/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Item and unit |  |  | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13
 | Area: Planted | Million acres | 57.334 | 60.46 | 63.193 | 59.168 | 53.593 | 54.409 | 55.736
 | Harvested | Million acres | 46.8 | 50.999 | 55.699 | 49.893 | 47.619 | 45.705 | 48.991
 | Yield | Bushels per acre | 38.6 | 40.2 | 44.9 | 44.5 | 46.3 | 43.7 | 46.3
 | Supply: Beginning stocks | Million bushels | 571.19 | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62
 | Production | Million bushels | 1808.416 | 2051.088 | 2499.164 | 2218.061 | 2206.916 | 1999.347 | 2269.117
 | Imports 1/ | Million bushels | 121.862 | 112.631 | 126.971 | 118.59 | 96.92 | 112.064 | 130
 | Total supply | Million bushels | 2501.468 | 2619.872 | 2931.953 | 2993.156 | 3279.473 | 2973.657 | 3141.737
 | Disappearance: Food use | Million bushels | 937.911 | 947.865 | 926.769 | 918.92 | 925.641 | 941.387 | 950
 | Seed use | Million bushels | 81.869 | 87.615 | 78.045 | 69.471 | 70.889 | 76.271 | 73
 | Feed and residual use | Million bushels | 117.059 | 15.962 | 255.219 | 149.85 | 131.864 | 163.866 | 315
 | Total domestic use | Million bushels | 1136.839 | 1051.442 | 1260.033 | 1138.241 | 1128.394 | 1181.524 | 1338
 | Exports 1/ | Million bushels | 908.476 | 1262.612 | 1015.415 | 879.278 | 1288.833 | 1049.513 | 1100
 | Total disapperance | Million bushels | 2045.315 | 2314.054 | 2275.448 | 2017.519 | 2417.227 | 2231.037 | 2438
 | Ending stocks | Million bushels | 456.153 | 305.818 | 656.505 | 975.637 | 862.246 | 742.62 | 703.737
 | CCC inventory 2/ | Million bushels | 41
 | Stocks-to-use ratio |  | 22.3023 | 13.2157 | 28.8517 | 48.3583 | 35.6709 | 33.2859 | 28.8653
 | Loan rate | Dollars per bushel | 2.75 | 2.75 | 2.75 | 2.75 | 2.94 | 2.94 | 2.94
 | Contract/direct payment rate | Dollars per bushel | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52 | 0.52
 | Farm price 3/ | Dollars per bushel | 4.26 | 6.48 | 6.78 | 4.87 | 5.7 | 7.24 | 7.75-8.45
 | Government payments | Million dollars | 1120 | 1118
 | Market value of production | Million dollars | 7694.734 | 13289.326 | 16625.759 | 10654.115 | 12827.254 | 14475.2723 | 18379.8477
Latest market year is projected; previous market year is estimated. Totals may not add due to rounding. 1/ Includes flour and selected other products expressed in grain-equivalent bushels. 2/ Stocks owned by USDA's Commodity Credit Corporation (CCC). Most CCC-owned inventory is in the Bill Emerson Humanitarian Trust.
3/ U.S. season-average price based on monthly prices weighted by monthly marketings. Prices do not include an allowance for loans outstanding and government purchases. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Date run: 11/9/2012
Spreadsheet: 756514d1637607547-talling-time-based-on-duration-totaling-time-dexter2-
Sheet: Sheet3

 |  |  |  |  | 05:20:00 |  |  | Count of time |  |  | Shift 1 | 05:45:00 | 08:47:00
 |  |  |  |  | 05:30:00 |  |  |  |  |  | Shift 2 | 10:05:00 | 14:48:00
 |  |  |  |  | 09:22:00 |  |  |  |  |  | Shift 3 | 15:34:00 | 17:55:00
 |  |  |  |  | 13:40:00 |  |  |  |  |  |  |  |  |  | Start | End
 |  |  |  |  | 18:28:00 |  |  |  |  |  |  | 05:20:00 | 05:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 05:30:00 | 06:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 06:30:00 | 07:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 08:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 | 09:22:00
 |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 | 10:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 | 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | 12:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 13:30:00 | 13:40:00
 |  |  |  |  |  |  |  |  |  |  |  | 13:40:00 | 14:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 14:30:00 | 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 16:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 16:30:00 | 17:30:00
 |  |  |  |  |  |  |  |  |  |  |  | 17:30:00 | 18:28:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 169879d1343084686-adding-a-column-representing-the-sequence-of-duplicates-in-a-specific-column-question
Sheet: Sheet1

Patient ID | SEQ
1 | 1
1 | 2
2 | 1
3 | 1
4 | 1
4 | 2
5 | 1
6 | 1
7 | 1
8 | 1
9 | 1
10 | 1
10 | 2
11 | 1
12 | 1
13 | 1
14 | 1
15 | 1
16 | 1
17 | 1
18 | 1
18 | 2
18 | 3
19 | 1
19 | 2
Spreadsheet: 38757d1236889202-sum-using-multiple-criteria-double-sumif-1
Sheet: last year data

Vendor | Department | Style # | 2008 actual Units | Cost | 2008 actual dollars
vendor 1 | mens knits | 123 | 25000 | 5.25 | 131250
vendor 1 | mens knits | 124 | 25000 | 4.67 | 116750
vendor 1 | [NAME] | 125 | 25000 | 4.58 | 114500
vendor 1 | [NAME] | 126 | 25000 | 3.36 | 84000
vendor 1 | mens pants | 127 | 25000 | 3.36 | 84000
vendor 2 | mens pants | 128 | 25000 | 3.36 | 84000
vendor 2 | mens jackets | 129 | 25000 | 4.66 | 116500
vendor 2 | mens jackets | 130 | 25000 | 4.66 | 116500
vendor 2 | womens knits | 131 | 25000 | 5.25 | 131250
vendor 2 | womens knits | 132 | 25000 | 4.67 | 116750
vendor 2 | womens sweater | 133 | 25000 | 4.58 | 114500
vendor 3 | womens sweater | 134 | 25000 | 3.36 | 84000
vendor 3 | womens pants | 135 | 25000 | 3.36 | 84000
vendor 3 | womens pants | 136 | 25000 | 3.36 | 84000
vendor 3 | womens jackets | 137 | 25000 | 4.66 | 116500
vendor 3 | womens jackets | 138 | 25000 | 4.66 | 116500
Spreadsheet: 679500d1590456198-extract-data-based-on-text-string-contents-organizing-results-sample-pipeline-workbook_1
Sheet: Consolidated Data

 | Applications Out | In Process | Submitted | PreApproved TBD | Approved | Docs Out | Closed | Post Closing | Applications Out - Now Closed | Dormant | Cancelled | Leads
 | Tester1, [NAME] and Tester2, [NAME] | Sample, Marvin |  | Joe Sample & Tim Sample | Patrick & Alexander Sample |  |  |  | [NAME] | Sample, Remi and [NAME] | [NAME] and [NAME] | [NAME]
 | This data is manually input, to show desired outcome.
 | Goal:  show the results from the previous sheet (Data-Pipeline) and paste to this page, starting with row 2 and moving down.
Spreadsheet: 1e75cca2-14f0-4bd0-8186-fb6b524589a1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HBAB | Test | HBAB | Hepatitis B Surface Antibody, Qualitative/Quantitative, Serum | [NAME], S | Chemiluminescent Immunoassay (CIA) | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down and remove serum from clot. Additional Information: Date of draw is required.  Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Plasma | HEPATITIS B SURFACE ANTIBODY Unvaccinated: negative Vaccinated: positive   HEPATITIS B SURFACE ANTIBODY, QUANTITATIVE Unvaccinated: <5.0 mIU/mL Vaccinated: > or =12.0 mIU/mL   See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday; Varies | 1 day | 2 days | 1 | 86706 |  |  |  |  | Rochester
HBAB | [NAME] | SST | Serum SST |  |  |  | Frozen
HBAB | Result | HB_AB | [NAME], S | [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22322-2
HBAB | Result | HBSQN | [NAME], Quantitative, S | [NAME], Quantitative, S | Alphanumeric |  |  |  |  | mIU/mL |  |  |  |  |  |  |  |  |  | 16935-9
Spreadsheet: 878566d1725659175-need-formulas-to-get-average-of-monthly-productivity-per-person-productivity-changes_v3
Sheet: Productivity Changes

START DATE | END DATE | Person 1 |  | START DATE | END DATE | Person 2 |  | START DATE | END DATE | Person 3
2024-09-02 00:00:00 | 2024-09-30 00:00:00 | 0.67509266 |  | 2024-09-02 00:00:00 | 2025-01-07 00:00:00 | 0 |  | 2024-09-02 00:00:00 | 2024-09-24 00:00:00 | 0.29166667
2024-10-01 00:00:00 | 2024-10-31 00:00:00 | 0.43217768 |  | 2025-01-08 00:00:00 |  | 1 |  | 2024-09-25 00:00:00 | 2024-10-04 00:00:00 | 0.79166667
2024-11-01 00:00:00 | 2024-11-03 00:00:00 | 0.28217768 |  |  |  |  |  | 2024-10-05 00:00:00 |  | 1
2024-11-04 00:00:00 | 2024-12-31 00:00:00 | 0.22063922
2025-01-01 00:00:00 | 2025-01-08 00:00:00 | 0.3384615399999999
2025-01-09 00:00:00 | 2025-01-31 00:00:00 | 0.53846154
2025-02-01 00:00:00 | 2025-02-14 00:00:00 | 0.78846154
2025-02-15 00:00:00 |  | 0.85
Spreadsheet: 791607d1660482538-formula-to-return-name-of-activity-of-if-between-2-dynamic-dates-lookup
Sheet: Sheet1

 |  |  | Which user made the activity for this company within 2 daysprior to the case? |  |  |  | Activity Data
Case ID | Company ID | Date | Activity Created? |  |  |  | Company ID | Activity Date | Activity Created By
833216 | Company 1 | 2022-03-02 00:00:00 | Multiple |  |  |  | Company 1 | 2022-03-01 00:00:00 | User 1
194763 | Company 1 | 2022-03-15 00:00:00 | User 3 |  |  |  | Company 1 | 2022-03-01 00:00:00 | User 2
533576 | Company 1 | 2022-03-16 00:00:00 | NA |  |  |  | Company 1 | 2022-02-01 00:00:00 | User 3
524082 | Company 2 | 2022-03-17 00:00:00 | NA |  |  |  | Company 2 | 2022-03-01 00:00:00 | User 1
348995 | Company 3 | 2022-03-18 00:00:00 | User 4 |  |  |  | Company 3 | 2022-03-12 00:00:00 | User 5
 |  |  |  |  |  |  | Company 1 | 2022-03-16 00:00:00 | User 3
 |  |  |  |  |  |  | Company 3 | 2022-03-18 00:00:00 | User 4
 |  |  |  |  |  |  | Company 1 | 2022-03-17 00:00:00 | User 3
Spreadsheet: 273833d1382931158-lookup-like-function-and-double-linear-interpolation-need-help-look-up-20and-20double-20linear-20interpolation-2-
Sheet: Sheet1

 |  | lower | upper |  | B
Pressure | 25
Temperature | 37 |  |  |  |  |  | Pressure (psi)
Volume |  |  |  |  |  |  | 10 | 20 | 30 | 40 | 50
 |  |  |  |  |  | 10 | 5 | 6 | 7 | 8 | 8
 |  |  |  |  | Temperature | 20 | 6 | 7 | 8 | 9 | 9
 |  |  |  |  | (deg C) | 30 | 8 | 9 | 10 | 11 | 11
 |  |  |  |  |  | 40 | 10 | 12 | 14 | 16 | 16
 |  |  |  |  |  | 50 | 10 | 12 | 14 | 16
 | Double Linear Interpolation
Spreadsheet: 857926d1706779997-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-01-feb-v1
Sheet: OT

PSID | Rcd | Name | Earn ID | PP | Fund | Dept | S/C | Acct | EOT Rate | Hours | Amount Due | Period Ending | Column1
 |  | CALDERA | OTPR | 2023-11-01 00:00:00
 |  | CALDERA | OTPR | 2023-11-01 00:00:00
 |  | CALDERA | OTPR | 2023-11-01 00:00:00
 |  | CALDERA | HG6 | 2023-11-01 00:00:00
 |  | CALDERA | OTST | 2023-11-01 00:00:00 |  |  |  |  |  |  |  | Default
 |  | COSTA | OTPR | 2023-11-01 00:00:00
 |  | COSTA | OTPR | 2023-11-01 00:00:00
 |  | COSTA | HG6 | 2023-11-01 00:00:00 |  |  |  |  |  |  |  |  | Why included… It's December.  Which 12 is it (green cells)
Total
 | 0 | CALDERA | HG6 | 2023-11-11 00:00:00 | 10 |  |  |  |  |  | ORANGE:  Can these oddities not be included somehow in an extension of the tables starting in column K?
22222 | 0 | CALDERA | OTPR | 2023-11-11 00:00:00 | 2
22222 | 0 | CALDERA | OTPR | 2023-11-18 00:00:00 | 2
22222 | 0 | CALDERA | CTO | 2023-11-18 00:00:00 | 3 | Why is this not in the OT table above?
22222 | 0 | CALDERA | OTPR | 2023-11-25 00:00:00 | 2
66666 | 0 | COSTA | OTPR | 2023-11-04 00:00:00 | 8.5
66666 | 0 | COSTA | HG6 | 2023-11-18 00:00:00 | 12
66666 | 0 | COSTA | OTPR | 2023-11-18 00:00:00 | 35.3
66666 | 0 | COSTA | HG6 | 2023-12-02 00:00:00 | 12 | Does this have to be excluded, 'cos it ends in december?
Spreadsheet: 473222d1470118702-dates-according-year-in-cell-with-data-validation-my-book
Sheet: Φύλλο1

 |  |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  | Current year | 2017 |  |  | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00
Can I have only the first dates of every month
according the selected year in  cell current year?
The cell with grey color has data validation
If I select another year 2022, I want dates in yellow area like this |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 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: 864282d1711502136-date-wise-data-output-in-index-function-new-inward-and-outward-ramesh-h-and-m-
Sheet: INPUT DATA

INPUT DATA
S NO | MATERIAL | FROM | SEND TO | FOR PROCESS | DATE | DC NO | SIZE  3/6 | SIZE 6/9 | SIZE 9/12 | SIZE 12/18 | SIZE 1.5/2 | SIZE 2/3 | SIZE 3/4 | SIZE 4/5 | SIZE 5/6 | SIZE 6/7 | QUANTITY | UNIT
1 | AAA | YYY | [NAME] | MMM | 2024-02-21 00:00:00 | TBC |  |  |  | 180 | 180 |  |  |  | 180 | 180
2 | AAA | YYY | [NAME] | MMM | 2024-02-24 00:00:00 | TBC |  |  |  | 180 | 180 |  |  |  | 180 | 180
3
4
5 | CCC | [NAME] | ZZZ | NNN | 2024-02-28 00:00:00 | TBC |  | 82 | 82 | 246 | 246 |  |  |  | 82 | 82
6
7
8
9
10
11
12
13
14
15
16
17 | AAA | [NAME] | YYY | MMM | 2024-02-23 00:00:00 | 3017 |  |  |  | 85 | 92 |  |  |  |  | 43
18 | AAA | [NAME] | YYY | MMM | 2024-02-24 00:00:00 | 3018 |  |  |  | 85 | 92 |  |  |  |  | 43
19
20
21
22
23
24
25 | CCC | ZZZ | [NAME] | NNN | 2024-02-28 00:00:00 | 3624 |  | 82 | 39
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
Spreadsheet: 125437d1319031066-require-a-formula-for-getting-a-specific-text-from-the-table-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Emp Code | 4
 |  |  |  | When i Enter the emp code, the staus of term has to come in the concerned box. (For ex: when emp code 1 is given, the term starting status 'poor' should come in that box)
 |  |  |  |  |  |  |  |  | Term Starting Status | poor
 |  |  |  |  |  |  |  |  | Term 2 Status
 |  |  |  |  |  |  |  |  | Term 3 Status
 |  |  |  |  |  |  |  |  | Term 4 Status
 | Emp Code | Name | Term | Term Status
 | 1 | AAAAAAAAAA | Starting | Poor
 | 2 | BBBBBBBBBB | Starting | Better
 | 3 | CCCCCCCCCCCC | Starting | Outstanding
 | 4 | [NAME] | Starting | Good
 | 1 | AAAAAAAAAA | 2 | Outstanding
 | 2 | BBBBBBBBBB | 2 | Poor
 | 3 | CCCCCCCCCCCC | 2 | Better
 | 4 | [NAME] | 2 | Good
 | 1 | AAAAAAAAAA | 3 | Poor
 | 2 | BBBBBBBBBB | 3 | Better
 | 3 | CCCCCCCCCCCC | 3 | Good
 | 4 | [NAME] | 3 | Outstanding
 | 1 | AAAAAAAAAA | 4 | Outstanding
 | 2 | BBBBBBBBBB | 4 | Poor
 | 3 | CCCCCCCCCCCC | 4 | Good
 | 4 | [NAME] | 4 | Better
 | 1 | AAAAAAAAAA | 5 | Outstanding
 | 2 | BBBBBBBBBB | 5 | Poor
 | 3 | CCCCCCCCCCCC | 5 | Good
 | 4 | [NAME] | 5 | Better
 | 1 | AAAAAAAAAA | 6 | Outstanding
 | 2 | BBBBBBBBBB | 6 | Poor
 | 3 | CCCCCCCCCCCC | 6 | Good
 | 4 | [NAME] | 6 | Better
Spreadsheet: 833758d1687246403-restructure-zip-code-data-zip-code-example-data-set-for-365-aligw
Sheet: Data Set with Desired Results

zip | primary_city | acceptable_cities | state | county |  | DESIRED RESULTS
1093 | Whately |  | MA | Franklin County |  | Unique City | Zip Code(s) | State | County(s)
1094 | Wheelwright |  | MA | Worcester County |  |  | 1116 | MA | Hampden County
1097 | Woronoco |  | MA | Hampden County |  | East Longmeadow | 1116 | MA | Hampden County
1098 | Worthington |  | MA | Hampshire County |  | Indian Orch | 1151 | MA | Hampden County
1101 | Springfield |  | MA | Hampshire County |  | [NAME] | 1151 | MA | Hampden County
1102 | Springfield |  | MA | Hampden County |  | Longmeadow | 1106, 1116 | MA | Hampden County
1103 | Springfield |  | MA | Hampden County |  | Pittsfield | 1201, 1202, 1203 | MA | Berkshire County
1104 | Springfield |  | MA | Hampden County |  | Springfield | 1101, 1102, 1103, 1104, 1105, 1106, 1107, 1108, 1109, 1111, 1115, 1118, 1119, 1128, 1129, 1133, 1138, 1139, 1144, 1151, 1152, 1195, 1199 | MA | Hampshire County
1105 | Springfield |  | MA | Hampden County |  | Springfield Bmc | 1195 | MA | Hampden County
1106 | Longmeadow | Springfield | MA | Hampden County |  | Whately | 1093 | MA | Franklin County
1107 | Springfield |  | MA | Hampden County |  | Wheelwright | 1094 | MA | Worcester County
1108 | Springfield |  | MA | Hampden County |  | Woronoco | 1097 | MA | Hampden County
1109 | Springfield |  | MA | Hampden County |  | Worthington | 1098 | MA | Hampshire County
1111 | Springfield |  | MA | Hampden County
1115 | Springfield |  | MA | Hampden County
1116 | Longmeadow | E Longmeadow, East Longmeadow | MA | Hampden County
1118 | Springfield |  | MA | Hampden County
1119 | Springfield |  | MA | Hampden County
1128 | Springfield |  | MA | Hampden County
1129 | Springfield |  | MA | Hampden County
1133 | Springfield |  | MA | Hampden County
1138 | Springfield |  | MA | Hampden County
1139 | Springfield |  | MA | Hampden County
1144 | Springfield |  | MA | Hampden County
1151 | [NAME] | Indian Orch, Springfield | MA | Hampden County
1152 | Springfield |  | MA | Hampden County
1195 | Springfield | Springfield Bmc | MA | Hampden County
1199 | Springfield |  | MA | Hampden County
1201 | Pittsfield |  | MA | Berkshire County
1202 | Pittsfield |  | MA | Berkshire County
1203 | Pittsfield |  | MA | Berkshire County
Spreadsheet: 434ca767-58ff-47dd-a40d-af1958782cff
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259183 | 72445 | [NAME] | [NAME] | ESP | 608 | 00:50:31 | 00:07:11 | 04:14:17 | 00:01:49 | 02:34:09 | 1 | 07:47:57
259183 | 71677 | Theresa | Abbott | GBR | 609 | 01:29:14 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: chris_stokley__3870__0201 EES
Sheet: EES Wind

EES Wind ISO Settlement 02/01/2001 - 02/28/2001
 |  | EPMI Charges To Customers
Trans Type | (All)
 |  |  | Data
Customer | ID | Desc. | Expense | Revenue | Total | Volume
[NAME] | 402 | Generation Deviation | -147905.242450674 | 959.9499175140002 | -146945.29253316 | 1136.4317485
 | 487 | Allocation Excess Cost for IE | 0 | 0.21 | 0.21 | 0
 | 523 | Market Operations Charge | -809.3456000000001 | 1623.657152296 | 814.3115522960001 | -856.2719545606903
EES_2 | 402 | Generation Deviation | -139583.630481698 | 788.3900043310001 | -138795.240477367 | 1075.5712913
 | 487 | Allocation Excess Cost for IE | 0 | 0.65 | 0.65 | 0
 | 523 | Market Operations Charge | -724.4419 | 1497.8502771548 | 773.4083771548001 | -813.2533746218669
EES_3 | 402 | Generation Deviation | -77913.612460294 | 19300.436603416 | -58613.175856878 | 451.3510189000002
 | 487 | Allocation Excess Cost for IE | 0 | 0.19 | 0.19 | 0
 | 523 | Market Operations Charge | -509.3038000000002 | 951.6966033949999 | 442.392803395 | -465.1833178671574
Grand Total |  |  | -367445.576692666 | 25123.03055810681 | -342322.5461345592 | 528.6454116502856
Spreadsheet: 0554c24d-fd2a-402a-b5c0-3045d8829077
Sheet: Sheet1

Name of Project Director: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Budget Period: _______to_______ | Year 1 | Year 2 | Year 3 | Total Budget Request
Personnel
[NAME] (please list each position and % effort on the project | $ | $ | $ | $
[NAME] (at 28%)
Total Personnel
Operating Expenses
Equipment | $ | $ | $ | $
Supplies (itemize)
Printing/Postage
Travel (list separately for each trip and each person)
Books and Periodicals
Total Operating
Other
Student Training/Stipend | $ | $ | $ | $
Technical support/consulting
Dissemination and Publication costs
Renovations
Total Other
Total Direct Costs | $ | $ | $ | $
Indirect Costs | $ | $ | $ | $
Total Costs (Total Direct + Indirect Costs)
Spreadsheet: 83691d1283710539-vlookup-with-a-number-range-book1_bluseals
Sheet: B

System | Hours worked
32471 | 32
32471 | 44
32471 | 56
32471 | 68
32471 | 80
32471 | 92
32471 | 104
32471 | 116
32471 | 128
32471 | 140