tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 268186d1380485175-noob-incremental-range-variable-function-index
Sheet: ingredients

 |  |  |  |  | row number
 |  |  |  |  | from column
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 | m |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m
 |  |  |  |  |  | m | m | m | m
 |  |  |  |  |  | m | m | m
 |  |  |  |  |  | m | m
Spreadsheet: 6080d9d6-6295-411c-a2d7-a7183cc24900
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-09-13 09:42:29.840000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.895 | 101.77 | 101.645 | 101.27
3.75 | 101.667 | 101.542 | 101.417 | 101.042 |  | Note: | Refer To Price [NAME]
3.625 | 101.069 | 100.944 | 100.819 | 100.444 |  |  | For all Price Adjs
3.5 | 100.264 | 100.139 | 100.014 | 99.389
3.375 | 99.434 | 99.309 | 99.184 | 98.559
3.25 | 98.479 | 98.354 | 98.229 | 97.604
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.876 | 101.751 | 101.626 | 101.251
3.25 | 101.598 | 101.473 | 101.348 | 100.973
3.125 | 101.291 | 101.166 | 101.041 | 100.666
3 | 100.81 | 100.685 | 100.56 | 100.185
2.875 | 100.168 | 100.043 | 99.918 | 99.293
2.75 | 99.503 | 99.378 | 99.253 | 98.628
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-09-27 09:42:29.840000
30 DAY | 2012-10-12 09:42:29.840000
45 DAY | 2012-10-27 09:42:29.840000
60 DAY | 2012-11-11 09:42:29.840000
90 DAY | 2012-12-11 09:42:29.840000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 172180d1344015132-how-do-i-create-an-equation-to-produce-an-auto-fill-test
Sheet: worksheet

 |  | _____ CALCULATIONS
 |  | days | cy / t | lds/act |  | lds/days | 5ld/day | sf
 |  | 2 | 1 | 2 |  | #REF! | #REF! | 1
 | Cut and [NAME] |  | lds |  |  |  |  |  |  |  | 0 | 0 |  |  | 3840 | 3840 | 3840 | 3840
51 |  | 2 | ea. |  | 112.5 | 112.5
22 |  | 1 | ea. |  | 77.5 | 77.5
11 |  | 1 | ea. |  | 37.5 | 37.5
67 |  | 1 | ea. |  | 12.5 | 12.5
 | TOTAL |  |  |  | 240 | 240 | 1920 | 1920 | 3840 | 3840
Spreadsheet: 40791d1239193019-count-group-of-consecutive-cells-according-to-cretiria-book2
Sheet: Sheet1

2009-03-24 06:17:00 | 10.5
2009-03-24 06:27:00 | 11.3
2009-03-24 06:37:00 | 12.4
2009-03-24 06:47:00 | 11.3 |  | Min. group size: | 3
2009-03-24 06:57:00 | 10.5 |  | Value greater than: | 10
2009-03-24 07:07:00 | 11.3
2009-03-24 07:17:00 | 12.4
2009-03-24 07:27:00 | 11.3
2009-03-24 07:37:00 | 7.9
2009-03-24 07:47:00
2009-03-24 07:57:00 | 13
2009-03-24 08:07:00 | 4.8 |  | Looking for a worksheet function - WITHOUT any helpler column(s) - in order to COUNT
2009-03-24 08:17:00 | 10.5 |  | the amount of cell-groups where at least 3 Consecutive cells have a value greater than 10.
2009-03-24 08:27:00 | 11.3 |  | The answer, according to the list & criterias above is: 3
2009-03-24 08:37:00 | 12.4 |  | If a Worksheet Function is not applicable - a UDF will also be fine.
2009-03-24 08:47:00 | 8.5 |  | The list shoud, of course, remaim sorted by dates/time !
2009-03-24 08:57:00 | 9.9 |  | The formula should be flexible in order to handle other criterias as per cells E4 & E5
2009-03-24 09:07:00 | 5.6 |  | As you can see I tried to find one myself but without success
2009-03-24 09:17:00 | 11
2009-03-24 09:27:00 | 12
2009-03-24 09:37:00 | 8.5
2009-03-24 09:47:00 | 12.4
2009-03-24 09:57:00 | 11.3 |  |  |  | 0
2009-03-24 10:07:00
2009-03-24 10:17:00 | 11.3
2009-03-24 10:27:00 | 12.4
2009-03-24 10:37:00 | 11.3 |  |  |  | #N/A
2009-03-24 10:47:00 | 12.4
2009-03-24 10:57:00 | 11.3
2009-03-24 11:07:00
Spreadsheet: 806122d1669117157-suming-dynamic-array-off-column-numbers-based-of-criteria-sum-for-dynamic-number-of-columns-ans1
Sheet: Sheet1

 | 2022-04-01 00:00:00
Month Days
Stock | 2439 | 4698 | 5085 | 9629 | 9561 | 5983 | 1935 | 6451 | 2050 | 2693 | 9668 | 2349
Average Days Holding | 58 | 52 | 58 | 100 | 31 | 26 | 40 | 36 | 21 | 78 | 6 | 127
Average Stock value |  |  |  |  |  |  |  |  |  |  |  |  |  | Automate this row so consistent formula in all columns
 | FORMULA |  |  |  |  |  |  |  |  |  |  |  |  | Logic:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1) Sum stock columns that cover columns where the month days are equal to average holding days or 1 month greater if an array
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2) Multiply 1 * 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3) Divide average days for that month by sum of month days for the columns that are equal to average days or closest number of months days greater than average holding days
Spreadsheet: 862956d1710513865-in-need-of-a-flagging-formula-for-2-scenarios-that-are-tied-together-test-formula
Sheet: Sheet1

FRUIT | Count |  |  |  |  |  | FRUIT | COLOR | COMMENT
apple | 2 |  |  |  |  |  | apple | Green | FLAG
apple | 2 |  |  |  |  |  | apple | Red | FLAG |  |  | Flag
orange | 1 |  |  |  |  |  | orange | Orange
banana | 1 |  |  |  |  |  | banana | Yellow
kiwi | 3 |  |  |  |  |  | kiwi
kiwi | 3 |  |  |  |  |  | kiwi
kiwi | 3 |  |  |  |  |  | kiwi | [NAME]
grape | 2 |  |  |  |  |  | grape | Green | FLAG |  |  | Flag
grape | 2 |  |  |  |  |  | grape | Purple | FLAG |  |  | Flag
watermelon | 1 |  |  |  |  |  | watermelon | Green
melon | 2 |  |  |  |  |  | melon
melon | 2 |  |  |  |  |  | melon
Spreadsheet: 837349d1690082760-creating-a-dropdown-list-that-pulls-from-multiple-sheets-test
Sheet: Bravo

Site | Bravo
Location
Address | 1010 Waterfront St Vancouver BC, V1V 1V1
GPS | 48.1111, -124.1111
Account No | Company ID
D12-2222 | 2021
Keyholder Contact
 | Name | Phone | [NAME]
1 | [NAME] | 111-2222 | [EMAIL]
2 | Julia | 111-2223 | [EMAIL]
3 | [NAME] | 111-2224 | [EMAIL]
4 | [NAME] | 111-2225 | [EMAIL]
Security Service
Monitoring Station: | Real Security | [PHONE]
Notes
[NAME] is on Vacation for all of August
Office is closed on Wednesdays
Spreadsheet: 106238d1303409224-excel-2007-data-entry-spreadsheet-h-and-s-doc-reference-numbers
Sheet: DATA

DEPT | DOC TYPE | DOC CATEGORY | DOC NUMBER | MONTH | YEAR | DOCUMENT TITLE
AU | HS | PO | 1 | 4 | 11 | Walking Under Ladders
ECD | HS | PR | 2 | 4 | 11 | Test Document
Spreadsheet: 104526d1302107025-solved-protecting-specific-cells-on-the-worksheet-blank
Sheet: Golf 01-01

Employee Name:
Position:
Date of Interaction:
 |  |  | Overall Score
Total Points Scored |  |  | 61 |  |  |  |  |  |  |  | #N/A
Total Possible Points |  |  | 110
Criteria | Yes / No | Points  Received
1 | no | 0
2 | no | 0
3 | yes | 17
4 | yes | 17
5 | yes | 17
6 | no | 0
7 | 10 | 10 | Degree of Competency, Hospitality, and Refinement +/- 5 or ten points |  |  |  |  |  | <--------MUST PUT REASONS HERE
 | -10
 | -5
 | 0
 | 5
 | 10
Spreadsheet: 584023d1532936677-adding-a-special-character-before-specific-word-or-words-test
Sheet: test

Name | Output
chaks_REV1 | chaks_REV1
Sep | Sep
Chaks
Chaks
Chaks
Chaks
Chaks
Chaks
Chaks
Chaks
Chaks
Chaks
chaks_REV1 | chaks_REV1
chaks_REV1 | chaks_REV1
chaks_REV1 | chaks_REV1
chaks_REV1 | chaks_REV1
chaks_REV1 | chaks_REV1
chaks_REV1 | chaks_REV1
chaks_REV1 | chaks_REV1
chaks_REV1 | chaks_REV1
Spreadsheet: 1cb9387f-0700-4e29-808b-66fe2b0b1e9b
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
FSTYR | Test | FSTYR | Styrene, Occupational Exposure, Blood | Styrene, Blood | Headspace Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 20 | mL | Collect 2 tubes green-top (sodium heparin) whole blood. Send 20 mL of sodium heparin whole blood refrigerated. Collect specimen at end of shift or prior to next shift. Tubes should be filled to prevent loss of volatile compound into headspace. | 2.5 mL Note: Submission of the m | Specimens other than	Whole blood Anticoagulants other than	Sodium heparin, EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Normal (Unexposed population):    	None detected                                               Exposed: Biological Exposure Index (BEI):  	0.55 mg/L (end of shift)                                                   	0.02 mg/L (prior to next shift)                                               Toxic: 	Not established    Test Performed By:  Medtox Laboratories                                          402 W. County Road D                                          St. Paul, MN  55112 | Monday through Sunday | 7 days | 9-10 days | 1 | 84600 |  |  |  |  | Medtox Laboratories, Inc
FSTYR | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Refrigerated
FSTYR | Result | Z1179 | Styrene | Styrene | Alphanumeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 1fb6c578-01e1-4eb8-bf39-b17258587aac
Sheet: TABLE

#1 Access | 5 Year MSJC SGP Data |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Gender | # | % | # | % | # | % | # | % | # | % | # | % | %
Female |  |  |  |  |  |  |  |  |  |  | 425726
Male |  |  |  |  |  |  |  |  |  |  | 411136
Unknown |  |  |  |  |  |  |  |  |  |  | 0
Total
click here for graph
 |  |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Ethnicity | # | % | # | % | # | % | # | % | # | % | # | % | %
White |  |  |  |  |  |  |  |  |  |  | 398271
Hispanic |  |  |  |  |  |  |  |  |  |  | 318674
African American |  |  |  |  |  |  |  |  |  |  | 43085
Asian |  |  |  |  |  |  |  |  |  |  | 21251
Native American |  |  |  |  |  |  |  |  |  |  | 6071
Filipino |  |  |  |  |  |  |  |  |  |  | 23365
Pacific Islander |  |  |  |  |  |  |  |  |  |  | 2305
Multi-Race |  |  |  |  |  |  |  |  |  |  | 22553
Unknown |  |  |  |  |  |  |  |  |  |  | 1287
click here for graph
 |  |  |  |  |  |  |  |  |  |  | Service Area |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 Census |  | Recent AY
Age | # | % | # | % | # | % | # | % | # | % | # | % | %
<18 |  |  |  |  |  |  |  |  |  |  | 245217
18 & 19 |  |  |  |  |  |  |  |  |  |  | 25706
20 to 24 |  |  |  |  |  |  |  |  |  |  | 52893
25 to 29 |  |  |  |  |  |  |  |  |  |  | 52166
30 to 34 |  |  |  |  |  |  |  |  |  |  | 52145
35 to 39 |  |  |  |  |  |  |  |  |  |  | 55384
40 to 49 |  |  |  |  |  |  |  |  |  |  | 116401
50 + |  |  |  |  |  |  |  |  |  |  | 236950
Unknown |  |  |  |  |  |  |  |  |  |  | 0
Average Age | 29.07522123893805 |  | 29.62058823529412 |  | 28.19237435008666 |  | 27.62591431556949 |  | 27.09291187739463
Median Age | 22 |  | 22 |  | 22 |  | 22 |  | 22
click here for graph
 | 5 Year MSJC Data |  |  |  |  |  |  |  |  |  | Riverside County |  | Gap vs.
 | AY07-08 |  | AY08-09 |  | [NAME] |  | AY10-11 |  | AY11-12 |  | 2010 ACS* |  | Recent AY
DSPS | # | % | # | % | # | % | # | % | # | % | # | % | #
Disabilities |  |  |  |  |  |  |  |  |  |  | 105412
 |  |  |  |  |  |  |  |  |  |  | 1299857
Service Area Comparison Data from MSJC official [NAME] codes in the 2010 Census Data.
* note: DSPS comparison data is from the 2010 ACS for Riverside County, disability count for ages 18 to 64
http://www.census.gov/acs/www/about_the_survey/american_community_survey/
Spreadsheet: 34076d1231188653-updating-excel-files-old-template-to-new-template-oldtemplate-data-
Sheet: Sheet1

 | Product Code | Product Name | RD # | UPC # | Category Code | Description | LEASE | instaware | Price | Cost |  | SIZE | Weight | Thumbnail URL | Image URL |  |  | LIST | Volts | FREESHIP | CASEPACK | MIN QUAN | MFG | ENERGYSTAR | ETLLISTED | MADEUSA | NFPA | ULCERTIFIED | [NAME] | CEC | MEA | [NAME] | warranty | options | options | options | Colors available | comparision | comparision | ships
 | HBB908 | 908™ [NAME], two speed motor, 44 oz. polycarbonate container, hi/low, s/s blades, 3/8 HP motor, 120V, 60Hz, [NAME], NSF listed, 1 year warranty | 840113 | 40094-91093 | Blender, Bar Type | 908™ [NAME], two speed motor, 44 oz. polycarbonate container, hi/low, s/s blades, 3/8 HP motor, 120V, 60Hz, [NAME], NSF listed, 1 year warranty |  |  | xx | xx |  |  | 9 |  |  |  |  | 131 |  |  | ea | 1 | [NAME]
 | 6126-HBB908 | Blender Container, 44 oz., polycarbonate, with complete cutting assembly and cover, for model HBB908 | 60004 | 40094-91104 | Blender, Bar Type | Blender Container, 44 oz., polycarbonate, with complete cutting assembly and cover, for model HBB908 |  |  | xx | xx |  |  | 1.805 |  |  |  |  | 51 |  |  | ea | 1 | [NAME]
 | 98908 | Blender Repair Kit, HBB908, 908, 909, 918, 919 | 53700 | 40094-98908 | Blender, Bar Type | Blender Repair Kit, HBB908, 908, 909, 918, 919 |  |  | xx | xx |  |  | 0.118 |  |  |  |  | 28 |  |  | ea | 1 | [NAME]
Spreadsheet: 112276d1308389701-graphing-a-daily-average-780557
Sheet: Sheet1

Date | Value
2011-06-15 00:00:00 | 3.75
2011-06-15 00:00:00 | 2.12
2011-06-15 00:00:00 | 4.64
2011-06-16 00:00:00 | 5.21
2011-06-16 00:00:00 | 1.48
2011-06-17 00:00:00 | 3.85
2011-06-17 00:00:00 | 3.21
2011-06-17 00:00:00 | 5.47
2011-06-17 00:00:00 | 1.79
Spreadsheet: 830004d1684616034-conditional-formatting-to-highlight-a-valve-shown-on-a-separate-worksheet-test-conditional-formatting-copy
Sheet: Sheet1

Player | Group | Flight | Hcp
BERGER, DAVE | BLUE | N | 32.3
BEWALDA, BOB | BLUE | C | 25.5
BISHOP, DAVE | BLUE | N | N/A
BISHOP, REB | BLUE | D | 32.4
Spreadsheet: 109724d1306501121-excel-2007-specific-date-compared-to-date-range-fed-calc-v3
Sheet: Year 13

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 13:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
145 | January
146 | February
147 | March
148 | April
149 | May
150 | June
151 | July
152 | August
153 | September
154 | October
155 | November
156 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 85922d1285917252-text-into-a-cell-2010-09-28-vendas-de-animais-janeiro-2010
Sheet: F2

CLIENTE |  | IVANOV & SIN |  |  |  | Nº CONTRIBUINTE |  |  |  |  | DATA |  | 2010-01-05 00:00:00
MORADA |  |  |  |  |  |  |  |  |  |  | PRAZO PAGAMENTO |  | 0 | DIAS
CIDADE |  |  |  |  |  | TIPO PAGAMENTO |  |  |  |  | VENCIMENTO
 |  |  |  |  | DATA RECEPÇÃO |  |  |  |  | Nº FACTURA |  | 166
REF. | DESCRIÇÃO |  |  |  | QUANTIDADE |  | PREÇO TON. |  |  |  | VALORES SEM IVA
 |  |  |  |  | Unidade | Kgs. | BGL |  | EUROS |  | BGL |  | EUROS
pabt |  |  |  |  | 150 | 26589 | 25
rabt |  |  |  |  | 10 | 12345 | 2.6
 |  |  |  | TOTAIS
 |  |  |  |  |  |  |  |  | IVA |  | 0.2
 |  |  |  |  |  |  |  |  | VALOR IVA
 |  |  |  |  |  |  |  |  | VALOR COM IVA
Spreadsheet: 168522d1342482946-formula-to-calculate-if-employee-is-working-on-each-half-hour-rota
Sheet: Calculation

Time | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 1900-01-01 00:00:00 | 1900-01-01 00:30:00 | 1900-01-01 01:00:00 | 1900-01-01 01:30:00 | 1900-01-01 02:00:00
[NAME]
[NAME]
[NAME]
Total Workers
Spreadsheet: 117275d1312609343-countif-formula-count-dec-gbo-abs-dum
Sheet: Sheet1

 |  |  |  | 190
Player's Name | Index | Hdcp | Average | IND | Game 1 | IND | Game 2 | IND | Game 3 | Total | 1
[NAME] |  | 87 | 133 | abs | 127 |  | 102 |  | 128 | 420 | 2
Martin |  | 81 | 139 |  | 153 |  | 143 | abs | 115 | 486 | 3
Ian |  | 71 | 149 | dum | 138 | dum | 186 | dum | 111 | 570 | 4
Stuart |  | 61 | 159 | dec | 139 | gbo | 166 |  | 138 | 518 | 5
1 |  |  |  | example: E4 = Abs count cell E1 + G4 = blank count cell H4 + cell I4 = blank count cell J4 = 420 in Cell K4
2 |  |  |  | example: E5 = blank count cell F5+ cell G5 = blank count cell H5 + J5 = abs Count cell E1 total of 486 in cell K5
3 |  |  |  | example: E6 = dum count cell E1 + G6 = DUM count [NAME] = dum count E1 total in cell K6 = 570
4 |  |  |  | example: E7 = DEC count cell e1 + G7 = GBO count cell E1 + cell I is blank count J7 for total in cell K7 of 518
If any cells E4:E7, G4:G7, I4:I7 = GBO , DEC, DUM, ABS count cell E1
If any cells E4:E7, G4:G7, I4:I7 dount have GBO , DEC, DUM, ABS count the actually number in each cell across for totals
Spreadsheet: 287107d1388653593-conditional-formatting-dates-calculation-sample
Sheet: Front end

Start | End | Renewal
Spreadsheet: 704453d1605555925-if-formula-with-uk-statutory-redundancy-payout-1-one-to-test
Sheet: broken

 | STATUTORY REDUNDANCY PAYOUT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These arent working
 | Name |  |  | DOB | Age on date of Redundancy | Start date | In Srv. | Annual Pay pro rata'd amount for PTE |  |  | Country | Weekly Stat. Rate | Redundancy Date | Completed Years of Service | Qualification Based on Min. Years of Service | Years in Service during Age Period |  |  |  |  | [NAME] on [NAME]. Years of Service |  |  |  |  | Week's Pay Entitlement |  |  |  |  | Weekly Pay Cap | Computed Payout | Actual Subject to [NAME] |  | Minimum Year of Service |  |  | [NAME] |  | <-- Before 06/04/17 --> |  | <--On or after [NAME] -->
 |  | Job Title | Team |  |  |  |  |  | Monthly Pay | Weekly pay |  |  |  |  |  | < 22 | 22 to 40 | [NAME] 41 | Total | Check = 0 | < 22 | 22 to 40 | [NAME] 41 | Total | Check = 0 | 0.5 | 1 | 1.5 | Total | My attempt |  |  |  |  | Location | Year of Service |  | Location | Year of Service | Weekly Pay1 | Payout1 | Weekly Pay2 | Payout2
 | 1 |  |  | 1968-06-07 00:00:00 |  | 2015-12-01 00:00:00 |  | 63492 |  |  | England |  | 2020-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | England | 2 |  | England | 20 | ` | DO NOT USE | 538 | 16140
 | 2 |  |  | 1987-03-10 00:00:00 |  | 2018-09-10 00:00:00 |  | 19644.04 |  |  | England |  | 2020-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Northern Ireland | 2 |  | Northern Ireland | 20 | DO NOT USE | DO NOT USE | 560 | 16800
 | 3 |  |  | 1989-10-11 00:00:00 |  | 2019-02-01 00:00:00 |  | 27898 |  |  | England |  | 2020-12-31 00:00:00
 | 4 |  |  | 1963-10-19 00:00:00 |  | 2019-01-21 00:00:00 |  | 48100 |  |  | England |  | 2020-12-31 00:00:00
 | 5 |  |  | 1991-07-17 00:00:00 |  | 2019-07-31 00:00:00 |  | 51948 |  |  | England |  | 2020-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Redundancy pay:
 | 6 |  |  | 1981-12-17 00:00:00 |  | 2015-09-01 00:00:00 |  | 28090.4 |  |  | England |  | 2020-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.gov.uk/redundant-your-rights/redundancy-pay
 | 7 |  |  | 1980-12-09 00:00:00 |  | 2012-02-02 00:00:00 |  | 35016.8 |  |  | England |  | 2020-12-31 00:00:00
 | 8 |  |  | 1968-05-02 00:00:00 |  | 2016-11-01 00:00:00 |  | 26624 |  |  | England |  | 2020-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculate your statutory redundancy pay:
 | 9 |  |  | 1969-04-06 00:00:00 |  | 2017-05-01 00:00:00 |  | 18720 |  |  | England |  | 2020-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | https://www.gov.uk/calculate-your-redundancy-pay
 | 10 |  |  | 1993-05-14 00:00:00 |  | 2019-07-01 00:00:00 |  | 19644.04 |  |  | England |  | 2020-12-31 00:00:00
 | 11 |  |  | 1989-09-07 00:00:00 |  | 2018-02-19 00:00:00 |  | 5972.85 |  |  | England |  | 2020-12-31 00:00:00
Spreadsheet: 697810d1601552360-return-a-weeks-of-time-to-achieve-a-fixed-target-best-worst-performed-weeks-and-values-retuen-the-weeks-of-time
Sheet: Sheet1

 | Work done in mtrs
Week1 | 1500 |  | Target | weeks to be taken to reach target
Week2 | 2455 |  | 10000 |  | Weeks | Work Done Value
Week3 |  |  |  | Overall Best Performed Weeks (Top-3)
Week4 | 2512 |  |  |  | Weeks | Work Done Value
Week5 |  |  |  | Overall Worst nagative performed Weeks
Week6 | -545 |  |  |  | Weeks
Week7 | 3652 |  |  | Over all weeks (Blank) no work performed
Week8 | 1145
Week9 | -1452
Week10 | 1452
Week11 | 253
[NAME] | 656
Week13 | 2454
Week14 | -1536
Week15
Week16 | 3465