tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43306d1241938859-split-numbers-and-split-words-splitt-numbers2
Sheet: Sheet1

 | FN | MN | EN
 | 333 | 333 | 333 | Numbers i put in!
 | FN |  | MN |  | EN |  |  |  | FN | MN | EN
 |  | + |  | + |  | = |  |  | 3 | 3 | 3 | 9 | Only 1 number, problem in 2 and 3 spot next line, How do i get it to put "0" in this places?
 |  | + |  | + |  | = |  |  | 9 | 0 | 0 | 9 | Now i need to get "0" in 2 and 3 spot automaticly, since its only one number!
 |  | + |  | = |  |  |  |  | 9 | 0 |  | 9 | Now i need to get "0" in 2 spot automaticly, since its only one number!
 |  |  |  |  | Total
 | FN |  | MN |  | EN |  |  |  | FN | MN | EN
 |  | + |  | + |  | = |  |  | 333 | 333 | 333 | 999 | Great! Got 3 numbers, all is well!
 |  | + |  | + |  | = |  |  | 9 | 9 | 9 | 27 | Great"! Got 2 numbers, all is well!
 |  | + |  | = |  |  |  |  | 2 | 7 |  | 9 | This one works out great, since i got numbers in all the places!
 |  |  |  |  | Total
 | FN |  | MN |  | EN |  |  |  | FN | MN | EN
 |  | + |  | + |  | = |  |  | 5 |  | 8 | 13 | Here I need to put in a formula that puts "0" in when MN dos not produse a number, so that i get a sum!
 |  | + |  | + |  | = |  |  | 1 | 3 | 0 | 4 | And in the 3 spot I need to put in a "0" since its only 13_ and lacking a 3 number!
 |  | + |  | = |  |  |  |  | 4 | 0 |  | 4 | Same here, sine I got only one digit in the last line, I need to automatickly also get "0" here if only 1 number!
 |  |  |  |  | Total
 | How i did it… But this dos not work!
 | FN |  | MN |  | EN
 |  | + |  | + |  | =
 |  | + |  | + |  | =
 |  |  |  |  | This… | Is the problem with only 2 numbers "13", on the 3 spot it dos not get a value, there is no 3 number.
 |  | + |  | = |  | So how do i get it to put "0" if there is NOT 3 number
 |  |  | This… |  | Total
Spreadsheet: 5855bece-07bd-4e4a-a7c7-0a015d3a5969
Sheet: Sheet1

State Representative (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Downloaded at 5/24/2013 12:22:39 AM
Precincts Reporting: 567/567 - Total Ballots Cast: 220479
2006 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | [NAME] | [NAME] | TOTALS
Precinct 3301 | 107 | 96 | 69 | 66 | 338
Precinct 3302 | 71 | 67 | 70 | 66 | 274
Precinct 3303 | 42 | 38 | 35 | 32 | 147
Precinct 3304 | 17 | 23 | 29 | 22 | 91
Precinct 3305 | 64 | 61 | 36 | 43 | 204
Precinct 3306 | 116 | 118 | 37 | 36 | 307
Precinct 3307 | 92 | 88 | 80 | 75 | 335
TOTAL | 509 | 491 | 356 | 340 | 1696
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 102262d1300223394-random-item-number-equals-correct-price-new-job-template
Sheet: Deposit

INVOICE
For Customer: |  |  |  |  |  | From: |  | Terms | Deposit
Name: | 0 |  |  |  |  | LaMorinda Tile and Stone
Address: | 0 |  |  |  |  | 2261 Commerce Ave., Suite B
City: | 0 |  |  |  |  | Concord, CA 94520 |  | Work Order#
Phone: | 0 |  |  |  |  | [PHONE]
Fax: | 0 |  |  |  |  | [PHONE] |  | Date | 2011-03-05 00:00:00
Phase/Date |  | Description |  |  |  |  |  |  | Price
TOTAL DUE: |  |  |  |  |  |  |  |  | 0
We Appreciate Your Prompt Payment.
Spreadsheet: 698017d1601670165-return-a-value-in-a-table-bornemann-atex-software-rev-2-1-
Sheet: DATA

[NAME] | Face ID | Face OD | FLUID | T Rating | Derating | Table | Face Material
20 | 0.1 | 0.09 | Aqueous | T1 | 440 | 1 | Carbon Vs SiC
30 | 31 | 36 | Oil Based | T2 | 290 | 2 | Carbon vs Steel
32 | 33 | 38 |  | T3 | 190 | 3
35 | 36 | 41 |  | T4 | 130
40 | 41 | 46 |  | T5 | 95
50 | 51 | 56 |  | T6 | 80
55 | 56 | 61
60 | 61 | 68
65 | 66 | 74.7
80 | 81 | 88
100 | 101 | 109
Spreadsheet: 846443d1697640960-concatenate-and-countif-to-assign-unique-id-to-duplicates-unique-subject-count-example
Sheet: Sheet2

ID | Subject | Helper Column | Unique Count | Unique Subject Count |  | Helper
12345 | ELA |  |  |  |  | CONCATENATE(A2,B2)
12345 | ELA
12345 | Health/PE
12345 | History |  |  |  |  | Unique Count
12345 | Math |  |  |  |  | COUNTIF($C$2:C2,C2)
54321 | Math
54321 | Science
54321 | Supplemental
54321 | ELA
54321 | ELA
54321 | Health/PE
23451 | History
23451 | Math
23451 | Math
34512 | Science
34512 | Supplemental
34512 | ELA
34512 | ELA
34512 | Health/PE
Spreadsheet: 142149d1329688210-summarise-data-from-multiple-sheets-based-on-dates-test-data
Sheet: Area 4

Date | reference | problem |  |  | problem a
 |  |  |  |  | problem b
2012-02-01 00:00:00 | xyz432 | problem a |  |  | problem c
2012-02-02 00:00:00 | xyz433 | [NAME] |  |  | [NAME]
2012-02-03 00:00:00 | [NAME] | [NAME]
2012-02-04 00:00:00 | xyz435 | [NAME]
2012-02-05 00:00:00 | xyz436 | problem c
2012-02-06 00:00:00 | xyz437 | problem b
2012-02-07 00:00:00 | xyz438 | problem b
2012-02-19 00:00:00 | xyz439 | problem c
2012-02-19 00:00:00 | [NAME] | problem a
Spreadsheet: 539663d1506324890-extracting-values-to-new-tab-book2
Sheet: Sheet1

Ser No | Fruit | Color | Weight | Good/Bad | helper Column
1 | Apple | red | 10 | Good
2 | Orange | orange | 20 | Bad
3 | Apple | red | 15 | Good
4 | [NAME] | yellow | 10 | Good
5 | Peach | green | 16 | Bad
6 | Apple | red | 25 | Good
Spreadsheet: 321832dc-fc90-41bc-978a-a8fa9d60427b
Sheet: Sheet1

ACSN | Advisory Council for School Nutrition
ACSP | Afterschool Care Snack Program
ADM | Average Daily Membership
ADP | Average Daily Participation
ANC | Annual National Conference
APP | Alternate Protein Product
ARM | CDE OSN Administrator’s Reference Manual
CACFP | Child and Adult Care Food Program
CAP | Corrective Action Plan
CDPHE | Colorado Dept of Public Health and Environment
CFR | Code of Federal Regulations
CCI | Child Care Institute
CN | [NAME]
CNP | Child Nutrition Programs
CPI | Consumer Price Index
CSNA | Colorado School Nutrition Association
DGA | Dietary Guidelines for Americans
DHHS | United States Department of Health and Human Services
DOD | Department of Defense
FBG | Food Buying Guide for Child Nutrition Programs
FDA | Food and Drug Administration
FDPIR | Food Distribution Program on Indian Reservations
FFVP | Fresh Fruit and Vegetable Program
FNS | Food and Nutrition Services
FSMC | Food Service Management Company
FY | Fiscal Year
HACCP | Hazard Analysis of Critical Control Points
HHFKA | Healthy, Hunger-Free Kids Act
HUSSC | HealthierUS School Challenge
HVC | Hunger Free Colorado
IDEA | Individuals with Disabilities Education Act
IEG | Income Eligibility Guidelines
IFB | Invitation for Bid
IOM | Institute of Medicine
LEA | Local Education Agency
M/MA | Meat/Meat Alternate
ME | Meal Equivalents
MPLH | Meals Per Labor Hour
MPRO | USDA Mountain Plains Regional Office
NFSMI | National Food Service Management Institute
NMP | New Meal Patterns
NPR | Non-Program Revenue
NSLA | National School Lunch Act
NSLP | National School Lunch Program
NYSP | National Youth Sports Program
OSN | Office of School Nutrition
OVS | Offer versus Serve
PLE | Paid Lunch Equity
POS | Point-of-Service
PSFU | (CDE) Public School Finance Unit
RCCI | Residential Child Care Institutes
RFP | Request for Proposal
SBP | School Breakfast Program
SFA | School Food Authority
SFSP | Summer Food Service Program
SLP | School Lunch Program
SMP | Special Milk Program or School Meal Programs
SNA | School Nutrition Association
SNAP | Supplemental Nutrition Assistance Program
SOP | Standard Operating Procedure
SY | School Year
TA | Technical Assistance
TANF | Temporary Assistance to Needy Families
USDA | United States Department of Agriculture
WGR | [NAME]
Updated 4/24/2013
Spreadsheet: 01164208-6c2b-4707-bc5a-a602e4ec34d1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 |  | Unnamed: 8 | Unnamed: 9
Applicant/Provider:
RFP No.:
Contract No.  (As Applicable): |  |  | Period: |  | to |  |  | Date Prepared:
ITEM PLEASE IDENTIFY EACH ASSET. DO NOT GROUP BY ASSET TITLE. | ACQUISITION DATE | ACQUISITION COST | USEFUL LIFE | METHOD  OF DEPRECIATION |  | PREVIOUS DEPRECIATION TAKEN | DEPRECIATION EXPENSE | % ALLOCATED | [NAME]
Total:
[NAME]/COMMENTS:
Spreadsheet: 70766d1271444688-chart-data-based-on-cell-reference-name-ranges-in-chart
Sheet: Sheet1

0.9653183347964218 | 0.08743581871969619 | 1
0.02163082821940243 | 0.5370679556076385 | 22
0.5048637415041046 | 0.07196083908026374
0.5179537443984661 | 0.7698449273849084
0.2344630999470398 | 0.9019262839755389
0.3646895164988022 | 0.6642935613382126
0.9280194805190645 | 0.8679170958529765
0.5583858164595574 | 0.6009639930457824
0.6149267512605423 | 0.8038395092339903
0.6784597175782601 | 0.8656031454676931
0.1074179905701813 | 0.6484085734124878
0.685470569711824 | 0.1658994289723108
0.2537729567243296 | 0.6898253392521303
0.4084585173675406 | 0.4984856536877014
0.444411940978312 | 0.01319510365097032
0.8978121704546638 | 0.4569965982746251
0.8480227742969477 | 0.3962658071430951
0.1416550552841143 | 0.7854984258968734
0.157750556497984 | 0.2208650190981585
0.6303073955828404 | 0.1997985660504704
0.3520193914942293 | 0.3502102846788322
0.5834566938271948 | 0.7939410882525981
0.4708957885268044 | 0.3748326679255989
0.09418412056588021 | 0.4086032684762415
0.994163541725575 | 0.2837244119520215
0.7366251284778844 | 0.02040644004164283
0.4903049518959082 | 0.3493972127028946
0.9160448321439931 | 0.7019363640763894
0.2935832029837551 | 0.1015005743751898
0.2959195973825752 | 0.3850569376106421
Spreadsheet: rick_buy__32948__raptor4b
Sheet: Summary

 | Raptor IV Daily Position Report & Summary
 | Inputs:
 | Trade Date | 2001-02-12 00:00:00 | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative
 | Today's Activity
 | Cumlative Ending
 | Notional Capacity
 | Credit Capacity
 | Remaining Governance Capacity
Spreadsheet: 829423d1684221495-need-a-formula-to-determine-the-date-the-unit-was-last-switched-on-most-recent-on-date-hd
Sheet: Sheet1

2023-05-01 00:00:00 | 3.5
2023-05-02 00:00:00 | 3.5
2023-05-03 00:00:00 | 3.5
2023-05-04 00:00:00
2023-05-05 00:00:00
2023-05-06 00:00:00
2023-05-07 00:00:00
2023-05-08 00:00:00
2023-05-09 00:00:00 | 3.5
2023-05-10 00:00:00 | 3.5
2023-05-11 00:00:00 | 3.5
2023-05-12 00:00:00 | 3.5
2023-05-13 00:00:00 | 3.5
2023-05-14 00:00:00 | 3.5
2023-05-15 00:00:00 | 3.5
2023-05-16 00:00:00
2023-05-17 00:00:00
2023-05-18 00:00:00
2023-05-19 00:00:00
2023-05-20 00:00:00 | 3.5
2023-05-21 00:00:00 | 3.5
2023-05-22 00:00:00
2023-05-23 00:00:00
2023-05-24 00:00:00
2023-05-25 00:00:00
2023-05-26 00:00:00
2023-05-27 00:00:00
2023-05-28 00:00:00
2023-05-29 00:00:00
2023-05-30 00:00:00
2023-05-31 00:00:00
Spreadsheet: 455810d1460503909-repeat-serial-number-across-multiple-pages-copy-of-certs-testing-cover-page-for-help-1
Sheet: X-Y VAL

PAGE 4 OF 7
ACCURACY VALIDATION RESULTS
NOMINAL DISTANCE ([NAME]) | 24.99985 | 49.9999 | 74.9997 | 100 | 125 | 149.9997
[NAME] (µm)
POSITION AG
RUN 1 | 24.9999 | 49.9997 | 74.9999 | 99.9996 | 124.9999 | 150.0002
RUN 2 | 24.9997 | 49.9995 | 74.9996 | 99.9996 | 124.9996 | 150
RUN 3 | 25 | 50 | 74.9999 | 99.9999 | 124.9998 | 150.0006
AVERAGE (mm)
MEASURED [NAME] (µm)
POSITION CA
RUN 1 | 25 | 50.0003 | 75.0005 | 100.0007 | 125.0007 | 150.0008
RUN 2 | 25 | 50.0004 | 75.0005 | 100.0009 | 125.0007 | 150.0008
RUN 3 | 25.0001 | 50.0005 | 75.0006 | 100.001 | 125.0008 | 150.001
AVERAGE (mm)
MEASURED [NAME] (µm)
POSITION CE
RUN 1 | 25.0003 | 50 | 75.0004 | 99.9996 | 124.9998 | 149.9987
RUN 2 | 25 | 50.0006 | 75.0002 | 99.9997 | 124.9997 | 149.9988
RUN 3 | 24.9996 | 49.9998 | 75 | 99.9991 | 124.9991 | 149.9988
AVERAGE (mm)
MEASURED [NAME] (µm)
POSITION CG
RUN 1 | 25.0004 | 50.0002 | 74.9998 | 99.9995 | 124.999 | 149.999
RUN 2 | 25.0006 | 50.0003 | 75.0001 | 99.9994 | 124.9993 | 149.9993
RUN 3 | 25.0002 | 49.9999 | 74.9999 | 99.9993 | 124.9989 | 149.9989
AVERAGE (mm)
MEASURED [NAME] (µm)
POSITION EA
RUN 1 | 25 | 50.0004 | 75.0005 | 99.9998 | 124.9994 | 149.9986
RUN 2 | 24.9992 | 49.9997 | 74.9999 | 99.9989 | 124.9987 | 149.9979
RUN 3 | 24.9994 | 49.9996 | 74.9999 | 99.999 | 124.9989 | 149.9981
AVERAGE (mm)
MEASURED [NAME] (µm)
POSITION EG
RUN 1 | 25 | 50.0008 | 75.0005 | 100.0003 | 125.0001 | 150.0006
RUN 2 | 24.9998 | 50.0006 | 75.0001 | 100.0002 | 125 | 150.0004
RUN 3 | 24.9996 | 50.0006 | 75.0001 | 100.0001 | 124.9999 | 150.0004
AVERAGE (mm)
MEASURED [NAME] (µm)
Spreadsheet: vkaminski__40933__raptor4b
Sheet: Summary

 | Raptor IV Daily Position Report & Summary
 | Inputs:
 | Trade Date |  | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative
 | Today's Activity
 | Cumlative Ending
 | Notional Capacity
 | Credit Capacity
 | Remaining Governance Capacity
Spreadsheet: 1fc124a4-7d51-4855-9fba-1abe5bb9b22b
Sheet: Page 1

Permit No.: |  |  | WQ0005279 |  |  | Facility Name: |  | Bingham Woods Mobile Home Park |  |  |  |  |  | County: | Orange |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 10.7 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 28.6 |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 705566d1606199483-generate-a-list-by-gathering-data-from-another-sheet-sample-workbook
Sheet: Delivery

 |  | Delivery Day: |  |  | 2020-11-23 00:00:00
 | Customer | Product 1 |  | Product 2 |  | Product 3 |  | Product 4 |  | Product 5 |  | Product 6 |  | Product 7 | Product 8 | Product 9 | Product 10 | Misc. Product / Discounts
 | Name | Size | Qty | Size | Qty | Size | Qty | Size | Qty | Size | Qty | Size | Qty | Qty | Qty | Qty | Qty | Item | Qty
 | Anna
 | Kelly
 | [NAME]
 | [NAME]
Spreadsheet: 867315d1714140322-add-todays-date-only-when-a-value-in-different-cell-checking-1
Sheet: Checking 2

 | [NAME] | Pension | Social Security | Total Amount in Checking | Date | 6065.48 |  |  |  | Money from Bern $325    Monthly | 2/15 gave - $325
1 | Rent
2 | House Loan |  |  |  |  |  |  |  |  | 325 | 325
3 | Electric |  |  |  | 2024-04-01 00:00:00
4 |  |  |  |  | 2024-04-01 00:00:00
5
6
7
8
9
10
11
12
13
14
15 |  |  | 1200
16
17
18
19
20
21
22
23
24
25
26
27 |  |  | 86
28
29
30 |  |  | 240
31
32
33
34 |  | 60 |  |  | 2024-04-01 00:00:00
35
36
37 |  |  | 3055
 | TOTAL BILLS
 | Checking Account
 | Extra Money
Spreadsheet: 827757d1683019439-average-timings-exercise-average-timings
Sheet: Cases

Category | Sale Date | Letter to Authority | Authority Response | Cash Received | Letter To External | Receive by External
[NAME] | 2023-03-15 00:00:00 | 2023-03-16 00:00:00 | 2023-03-18 00:00:00 | 2023-04-03 00:00:00 | 2023-03-30 00:00:00 | 2023-04-10 00:00:00
Lim | 2023-03-30 00:00:00 | 2023-03-31 00:00:00 | 2023-04-05 00:00:00 | 2023-04-19 00:00:00 | 2023-04-20 00:00:00 | 2023-04-28 00:00:00
Paf | 2023-04-10 00:00:00 | 2023-04-11 00:00:00 | 2023-04-24 00:00:00 | 2023-04-12 00:00:00 | 2023-04-25 00:00:00 | 2023-04-30 00:00:00
Lar | 2023-04-12 00:00:00 | 2023-04-12 00:00:00 | 2023-04-15 00:00:00 | 2023-04-18 00:00:00 | 2023-04-20 00:00:00 | 2023-05-01 00:00:00
Amm | 2023-02-02 00:00:00 | 2023-02-06 00:00:00 | 2023-02-23 00:00:00 | 2023-02-13 00:00:00 | 2023-03-03 00:00:00 | 2023-03-07 00:00:00
[NAME] | 2023-01-01 00:00:00 | 2023-01-03 00:00:00 | 2023-01-13 00:00:00 | 2023-01-20 00:00:00 | 2023-01-21 00:00:00 | 2023-01-29 00:00:00
Lim | 2023-01-02 00:00:00 | 2023-01-05 00:00:00 | 2023-01-08 00:00:00 | 2023-01-18 00:00:00 | 2023-01-19 00:00:00 | 2023-01-29 00:00:00
Paf | 2023-02-03 00:00:00 | 2023-02-04 00:00:00 | 2023-02-08 00:00:00 | 2023-02-11 00:00:00 | 2023-02-13 00:00:00 | 2023-02-18 00:00:00
Lar | 2023-02-04 00:00:00 | 2023-02-04 00:00:00 | 2023-02-28 00:00:00 | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-02-28 00:00:00
Amm | 2023-02-05 00:00:00 | 2023-02-05 00:00:00 | 2023-02-10 00:00:00 | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-21 00:00:00
 |  |  |  |  | PLEASE NOTE THAT THIS IS A SAMPLE. THE ACTUAL FILE HAS MORE THAN 250 ENTRIES.
Spreadsheet: 844946d1696534477-priority-task-list-book3-hd
Sheet: Top 10

Priority | Task # | Title | Desciption
1 | 1004 | Title 4 | [NAME] 4 |  |  | Title 4 | [NAME] 4
2 | 1020 | Title 20 | [NAME] 20 | 2 | 1020 | Title 20 | [NAME] 20
3 | 1006 | Title 6 | [NAME] 6 | 3 | 1006 | Title 6 | [NAME] 6
4 | 1024 | Title 24 | [NAME] 24 | 4 | 1024 | Title 24 | [NAME] 24
5 | 1016 | Title 16 | [NAME] 16 | 5 | 1016 | Title 16 | [NAME] 16
6 | 1008 | Title 8 | [NAME] 8 | 6 | 1008 | Title 8 | [NAME] 8
7 | 1018 | Title 18 | [NAME] 18 | 7 | 1018 | Title 18 | [NAME] 18
8 | 1010 | Title 10 | [NAME] 10 | 8 | 1010 | Title 10 | [NAME] 10
9 | 1028 | Title 28 | [NAME] 28 | 9 | 1028 | Title 28 | [NAME] 28
10 | 1032 | Title 32 | [NAME] 32 | 10 | 1032 | Title 32 | [NAME] 32
1
2
3
4
5 |  |  |  | What I'm getting
6
7
8
9
10
VLOOKUP(LARGE($D$2:$D$36,37-ROW()),$D$2:$F$36,2,) |  |  |  | Works on Top 20 Tab
VLOOKUP(LARGE(List!$A$2:$A$41,42-ROW()),List!$A$2:$D$41,2,) |  |  |  | Does not work on this tab
Spreadsheet: 745595d1630038624-how-to-find-the-unit-number-by-date-and-month-book2
Sheet: Sheet1

Date | Renewal | Customer | Week number | Month
2021-08-21 00:00:00 | Existing | Funnel Duo Media Sdn Bhd
2021-08-21 00:00:00 | Existing | Kinexure Sdn Bhd
2021-08-23 00:00:00 | New | Yeow & Salleh
2021-08-23 00:00:00 | Existing | Tyng & Co
2021-08-23 00:00:00 | Existing | APPLESEEDLERS CREATIVITY SDN BHD
2021-08-23 00:00:00 | New | [NAME]
2021-08-24 00:00:00 | Existing | GIFT SOUTH EAST ASIA SB
2021-08-24 00:00:00 | Existing | PERBADANAN PENGURUSAN C180
2021-08-24 00:00:00 | New | Myrimari Resources
2021-08-24 00:00:00 | Existing | RPG Commerce Sdn Bhd
2021-08-24 00:00:00 | Existing | [NAME] Bhd
2021-08-24 00:00:00 | Existing | Mediconnexions Consulting Sdn Bhd
2021-08-24 00:00:00 | Existing | Digital Penang
2021-08-25 00:00:00 | Existing | Duty Free Distribution Sdn Bhd
2021-08-25 00:00:00 | Existing | The Property Guys Sdn Bhd
2021-08-25 00:00:00 | Existing | The Makeover Guys Sdn Bhd
2021-08-25 00:00:00 | Existing | Team Fames Sdn Bhd
2021-08-25 00:00:00 | Existing | VISUAL EFX SDN BHD
2021-08-25 00:00:00 | Existing | UIE Solutions (M) Sdn Bhd
2021-08-25 00:00:00 | Existing | Stesyen Minyak Sri Pantai
2021-08-26 00:00:00 | Existing | EBL Pro Marketing
2021-08-26 00:00:00 | Existing | Amanjena Resources
2021-08-26 00:00:00 | Existing | MSLI RESOURCES SDN BHD
2021-08-26 00:00:00 | New | Untung Logistics Sdn Bhd
2021-08-26 00:00:00 | Existing | [NAME]. Bhd.
 |  | 2021-08-25 11:53:32 | [NAME] | Manual
 | New | Number of New Customer | ?? | 7
 | Existing | Number of Existing Customer | ?? | 0
 |  | Aug Sales Number
 | New | Number of New Customer | ?? | 4
 | Existing | Number of Existing Customer | ?? | 21
Spreadsheet: e33db9ca-6d79-4007-a21e-e403a0e26225
Sheet: PR_Overall Performance_6

On-going Progress Update and Disbursement Request
PROGRESS UPDATE PERIOD
Grant number:
Progress Update - Reporting Period: |  | Cycle: |  | Number:
Progress Update - Period Covered: |  | Beginning Date: |  | End Date:
Progress Update - Number:
Section 6:  Overall Performance
A.  PR's Overall Self-Evaluation of Grant Performance (including a summary of how financial performance is linked to programmatic achievements)
!  The self-evaluation should be undertaken by taking into account programmatic achievements, financial performance and program issues in various functional areas (M&E, Finance, Procurement, and Program Management, including management of sub-recipients).  See Guidelines for more detailed guidance.
B.  Planned Changes in the Program, if any
C.  External factors beyond the control of the Principal Recipient that have impacted or may impact the Program
Spreadsheet: 747062d1631199587-sumifs-with-a-dynamic-criteria-range-based-on-selection-epm-mileage-sample-sheet
Sheet: Dashboard

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Main
 |  |  | Select mileage to process |  |  |  |  |  |  |  |  |  |  | CBSSG
 | Split |  | CBSSG |  |  |  |  |  |  |  |  |  |  | HCC Conc
 |  |  |  |  |  |  |  |  |  |  |  |  |  | BCP Tender
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process5
 | London | sumif formula | sumif formula | sumif formula |  |  |  |  |  |  |  |  |  | Process6
 | Southampton | sumif formula | sumif formula | sumif formula |  |  |  |  |  |  |  |  |  | Process7
 | Newport | sumif formula | sumif formula | sumif formula |  |  |  |  |  |  |  |  |  | Process8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process12
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process15
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process16
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process19
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Process22
Spreadsheet: 670112d1585752935-updating-a-formula-for-text-split-textfunctions
Sheet: Sheet1

1) Name must have First,Middle and Last Name
2) Zip code must be the last 5 digit
3) State must have a comma before it
4) Town must have a dash before it
Full Address | First | Middle | Last Name | Address | Town | State | Zip
[NAME] 18794 [NAME], Michigan 48168
[NAME] 620 Slayton-Grand Haven, Michigan 12345
[NAME] St.-Garden City, Michigan 48135
[NAME] North Silver Pines-Bellaire, Michigan 49615
[NAME]  18794 [NAME], Michigan 48167
[NAME] 13600 S. Parce Street-Owossoa, Michigan 48667
[NAME] [NAME], Michigan 48433
Cametrious ? Brewer 5813 [NAME], Mchigan 48505
Martin ? [NAME] 7064 [NAME] Rd.-Clio, Michigan 48420
[NAME] 100th St NE.-Flushing, Michigan 48433
[NAME] ? [NAME] 303 S. Main St. Apt 80 -Clio, Michigan 48420
Roeshon D. Brown IV  12345 [NAME], Michigan 48602
Bankston D. Banks 374 River Woods Dr. -Flushing, MI 48433
Spreadsheet: e29c8a5f-da32-494b-a898-1e7b02c6f4d0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40924044 | 2014-04-10 06:06:28 | AXIS | 0 | 2 | 5 | 1551643 | Roosevelt4421 | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
41085496 | 2014-04-21 05:14:17 | AXIS | 0 | 1 | 5 | 1509525 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
Spreadsheet: 110977d1307511646-networkdays-returns-1-when-planned-date-and-completion-date-are-the-same-delta_in_days_excluding_wkd
Sheet: workdays excluding wkd

Planned completion date | Actual completion date | delta with networkdays f() | expected delta workdays
2011-05-28 00:00:00 | 2011-05-27 00:00:00 |  | 1
2011-06-01 00:00:00 | 2011-06-08 00:00:00 |  | -5
2011-04-13 00:00:00 | 2011-04-21 00:00:00 |  | -6
2011-04-27 00:00:00 | 2011-04-25 00:00:00 |  | 2
2011-05-25 00:00:00 | 2011-05-27 00:00:00 |  | -2
2011-06-03 00:00:00 | 2011-06-03 00:00:00 |  | 0
2011-06-07 00:00:00 | 2011-06-07 00:00:00 |  | 0