tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 839680d1692154239-formula-to-count-duplicate-value-as-one-test1-12-
Sheet: Sheet1

Unit No. | Element |  | Wanted a formula to calculate the duplicate entry that match the creteria A3+B3 as one entry only
A-01-01 | wall |  | The result that I wanted as below
A-01-01 | wall
A-01-01 | window |  | A-01-01 | Wall
A-01-01 | ceiling |  | A-01-01 | window
A-01-01 | fixtures |  | A-01-01 | ceiling
A-01-01 | wall |  | A-01-01 | fixtures
A-01-01 | fixtures |  | A-01-01 | ceiling
A-01-01 | ceiling
A-01-01 | ceiling
A-01-01 | ceiling
Spreadsheet: 56323d1256496921-vlookup-countif-nest-test-shirt-count
Sheet: Draft

 | BRAINTREE YOUTH BASKETBALL
 | TEAM ROSTER
 |  |  | 2ND GRADE BOYS |  |  |  | TEAM # | 1
 |  | Coach:
 |  | Phone:
 |  | [NAME]:
 |  | [NAME]: |  | (Select From -- AS, AM, AL, AX, AXX)
 |  |  |  |  | Shirt
ID # |  | Name |  | Grade | Size | Phone # | [NAME] | Parent's Names
11 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
 | 11
 | Team Shirt Summary -- |  |  | Youth Medium --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | Adult 2X Large --
 |  |  |  | [NAME] --
 |  |  |  | Total:
 |  |  | Coach's Shirt -- |  | 1
 | BRAINTREE YOUTH BASKETBALL
 | TEAM ROSTER
 |  |  |  |  |  |  | TEAM #
 |  | Coach:
 |  | Phone:
 |  | [NAME]:
 |  | [NAME]: |  | (Select From -- AS, AM, AL, AX, AXX)
 |  |  |  |  | Shirt
ID # |  | Name |  | Grade | Size | Phone # | [NAME] | Parent's Names
12 | 1
13 | 2
14 | 3
15 | 4
16 | 5
17 | 6
18 | 7
19 | 8
20 | 9
 | 10
 | 11
 | Team Shirt Summary -- |  |  | Youth Medium --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | Adult 2X Large --
 |  |  |  | [NAME] --
 |  |  |  | Total:
 |  |  | Coach's Shirt -- |  | 1
 | BRAINTREE YOUTH BASKETBALL
 | TEAM ROSTER
 |  |  |  |  |  |  | TEAM #
 |  | Coach:
 |  | Phone:
 |  | [NAME]:
 |  | [NAME]: |  | (Select From -- AS, AM, AL, AX, AXX)
 |  |  |  |  | Shirt
ID # |  | Name |  | Grade | Size | Phone # | [NAME] | Parent's Names
21 | 1
22 | 2
23 | 3
24 | 4
25 | 5
26 | 6
27 | 7
28 | 8
29 | 9
30 | 10
 | 11
 | Team Shirt Summary -- |  |  | Youth Medium --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | Adult 2X Large --
 |  |  |  | [NAME] --
 |  |  |  | Total:
 |  |  | Coach's Shirt -- |  | 1
 | BRAINTREE YOUTH BASKETBALL
 | TEAM ROSTER
 |  |  |  |  |  |  | TEAM #
 |  | Coach:
 |  | Phone:
 |  | [NAME]:
 |  | [NAME]: |  | (Select From -- AS, AM, AL, AX, AXX)
 |  |  |  |  | Shirt
ID # |  | Name |  | Grade | Size | Phone # | [NAME] | Parent's Names
11 | 1
12 | 2
13 | 3
14 | 4
16 | 5
17 | 6
18 | 7
19 | 8
20 | 9
 | 10
 | 11
 | Team Shirt Summary -- |  |  | Youth Medium --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | Adult 2X Large --
 |  |  |  | [NAME] --
 |  |  |  | Total:
 |  |  | Coach's Shirt -- |  | 1
 | BRAINTREE YOUTH BASKETBALL
 | TEAM ROSTER
 |  |  |  |  |  |  | TEAM #
 |  | Coach:
 |  | Phone:
 |  | [NAME]:
 |  | [NAME]: |  | (Select From -- AS, AM, AL, AX, AXX)
 |  |  |  |  | Shirt
ID # |  | Name |  | Grade | Size | Phone # | [NAME] | Parent's Names
22 | 1
23 | 2
24 | 3
25 | 4
26 | 5
27 | 6
28 | 7
29 | 8
30 | 9
 | 10
 | 11
 | Team Shirt Summary -- |  |  | Youth Medium --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | [NAME] --
 |  |  |  | Adult 2X Large --
 |  |  |  | [NAME] --
 |  |  |  | Total:
 |  |  | Coach's Shirt -- |  | 1
Spreadsheet: 152754d1335515558-excel-2007-counting-with-a-pivot-table-groups-not-individual-rows-pivot-counting
Sheet: Sheet1

Part | Customer |  | Part | Count of Customer
abc | [NAME] |  | abc | 6
abc | [NAME] |  | Grand Total | 6
abc | [NAME] |  |  |  |  | HOW DO I GET IT TO COUNT 3 CUSTOMERS???
abc | [NAME]
abc | [NAME]
abc | [NAME]
Spreadsheet: 786802d1657455961-sports-betting-counting-wins-losses-and-pushes-bettracker2
Sheet: Bet Input - Stats

Date | Bet | Sport | Type | Wager | Odds | Outcome | Payout
2022-07-06 00:00:00 | Blue Jays Athletics U 5.5 | MLB | Single | 2 | -120 | Win |  |  |  |  | Starting Amount | 10
2022-07-06 00:00:00 | Rockies Dodgers Parlay | MLB | Parlay | 1 | 350 | Loss |  |  |  |  | Profit/Loss |  | Wins | Losses | Push
2022-07-07 00:00:00 | Slafkovsky 1st Pick ($1 Free Bet) | NHL | Single | 1 |  | Win | 1 | Free Bet |  |  | Records | NFL
2022-07-07 00:00:00 | [NAME] Parlay | MLB | Parlay | 2 | 217 | Loss |  |  |  |  |  | MLB
2022-07-07 00:00:00 | Astros Royals Parlay | MLB | Parlay | 1 | 165 | Win |  |  |  |  |  | NHL
2022-07-07 00:00:00 | Astros Royals Parlay | MLB | Parlay | 0.86 | 800 | Loss |  |  |  |  |  | NBA
2022-07-08 00:00:00 | Phillis Cardinals Parlay | MLB | Parlay | 1 | 380 | Loss |  |  |  |  |  | NCAAF
2022-07-08 00:00:00 | Rays [NAME] | MLB | Parlay | 1 | 450 | Loss |  |  |  |  |  | NCAAB
2022-07-08 00:00:00 | NRFI Twins/Rangers Marlins/Mets | MLB | Parlay | 1 | 246 | Loss |  |  |  |  |  | F1
2022-07-09 00:00:00 | NRFI Padres/Giants ($25 Free Bet) | MLB | Single | 14.7 |  | Win |  | Free Bet |  |  |  | UFC
2022-07-09 00:00:00 | Dodgers -1.5 | MLB | Single | 1 |  |  |  |  |  |  |  | Soccer
2022-07-09 00:00:00 | [NAME] GP | F1 | Single | 2 |  |  |  |  |  |  |  |  | Amount Won
 |  |  |  |  |  |  |  |  |  |  |  | Casino | 63.09
Spreadsheet: 267996d1380342813-i-cant-accumulate-data-of-daily-production-report-into-monthly-production-report-helpp-problem
Sheet: Monthly Production report (MPR)

 | Lets solve my problem now Baby!!!!
 | September
 |  | M1 | M3 | PD
 | 2013-09-01 00:00:00
 | 2013-09-02 00:00:00
 | 2013-09-03 00:00:00
 | 2013-09-04 00:00:00
 | 2013-09-05 00:00:00
 | 2013-09-06 00:00:00
 | 2013-09-07 00:00:00
 | 2013-09-08 00:00:00
 | 2013-09-09 00:00:00
 | 2013-09-10 00:00:00
 | 2013-09-11 00:00:00
 | 2013-09-12 00:00:00
 | 2013-09-13 00:00:00
 | 2013-09-14 00:00:00
 | 2013-09-15 00:00:00
 | 2013-09-16 00:00:00
 | 2013-09-17 00:00:00
 | 2013-09-18 00:00:00
 | 2013-09-19 00:00:00
 | 2013-09-20 00:00:00
 | 2013-09-21 00:00:00
 | 2013-09-22 00:00:00
 | 2013-09-23 00:00:00
 | 2013-09-24 00:00:00
 | 2013-09-25 00:00:00
 | 2013-09-26 00:00:00
 | 2013-09-27 00:00:00
 | 2013-09-28 00:00:00
 | 2013-09-29 00:00:00
 | 2013-09-30 00:00:00
 | Total
 | Todate Total
Spreadsheet: 0b5898d4-9130-4acb-a023-0b1024b7c55f
Sheet: Purch Req

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Requisition Date
 |  |  |  |  |  |  | PURCHASE REQUISITION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Requisition No.
 |  |  |  | (Highlighted / Shaded areas  indicate required fields)
SHIP TO: |  | 1 College Circle, [NAME], NY  14454 |  |  |  | [NAME] (if different from "ATTN"): |  |  |  |  |  |  |  |  |  |  | Purchase Order No.
ATTN:
DEPT: |  |  |  |  |  |  |  |  |  |  |  | ADDITIONAL NOTES
BLDG/Rm #: |  |  |  |  |  | Need By Date: |  | Phone:
Project |  | Task | Award | Expenditure Type |  |  | Organization
 |  |  |  |  |  |  | 190 | Chairman
Vendor Name & Address |  |  |  | Alternate Vendors (if known): |  |  |  |  |  |  |  |  |  |  | IDENTIFY IF APPLICABLE
 |  |  |  | 2nd Vendor Name & Address |  |  |  |  |  |  | 3rd Vendor Name & Address
Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Radioactive Material
Address |  |  |  | Name |  |  |  |  | Name |  |  |  |  |  |  |  | (with Radiation Office Approval)
City, State, Zip |  |  |  | Address |  |  |  |  | Address
Contact Person |  |  |  | City, State, Zip |  |  |  |  | City, State, Zip |  |  |  |  |  |  |  | Chemical Requisition Form
Phone |  |  |  | Contact Person |  |  |  |  | Contact Person |  |  |  |  |  |  |  | (attached)
Fax |  |  |  | Phone |  |  |  |  | Phone
Federal ID # |  |  |  | Fax |  |  |  |  | Fax
SS # |  |  |  | Federal ID # |  |  |  |  | Federal ID #
Catalog # |  | Description |  |  |  |  |  |  |  |  |  |  | Quantity | UOM | Unit Price |  |  |  | Unit Total
 |  | Shipping Charges |  |  |  | Estimate |  |  |  | Actual |  |  | 1 | Lot
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL ORDER
As Project Director, I certify that the items requested herein are allowable,
allocable, reasonable, and necessary for the grant.  I have listed optional
suppliers (if known) or have provided a sole or single source justification
(if applicable).
X
___________, Project Director |  |  |  | Date |  |  | [NAME],                     Operations Manager (expenses over $2500) |  |  |  | Date |  | [NAME], Grants Mgmt Office, (RF Authorized Signature) |  |  |  |  |  | Date
Quote Information |  |  |  | OMB Circular A-110 |  |  |  |  |  | Purchasing Use Only |  |  |  |  |  | Internal Use Only
Quote #: |  |  |  | Expenditures of $10,000 or more involve a |  |  |  |  |  |  | Sole Source: |  |  |  |  |  | Women Owned Business
Phone Quote By: |  |  |  | bidding process as outlined in OMB Circular |  |  |  |  |  |  | Single Source: |  |  |  |  |  | Minority Owned Business
Written Quote By: |  |  |  | A-110. |  |  |  |  |  |  | Delivery Date Confirmed: |  |  |  |  |  | Small Business
Date: |  |  |  |  |  |  |  |  |  |  | NYS Contract #:
Spreadsheet: 815390d1674915550-how-to-reduce-data-automatically-by-creating-averages-when-certain-increase-is-reached-sample
Sheet: Tabelle1

A | B | average
0 | 47.676067
0.1733200000000039 | 47.502747
0.2845380000000048 | 47.391529
0.4097440000000034 | 47.516735
0.4952010000000087 | 47.602192
0.5768170000000126 | 47.520576
0.6593710000000144 | 47.60313
0.6780590000000117 | 47.584442
0.80638900000001 | 47.712772
0.9446030000000079 | 47.574558
1.061928000000002 | 47.691883
1.061974000000006 | 47.691929
1.069367000000007 | 47.684536
1.565239000000005 | 48.180408
1.685222000000003 | 48.060425
1.950659999999999 | 48.325863
1.966991 | 48.309532
2.084666999999996 | 48.191856
2.086925000000001 | 48.189598
2.236461000000006 | 48.339134
... | ... | ...
Spreadsheet: 88675d1288506724-nested-if-statement-ot-form
Sheet: Sheet1

Overtime Worksheet
Employee's name | [NAME] |  |  | Level | 5
Employee's number | 1234 |  |  | Step | 1
Travel Overtime | Date | Day | Holiday | Time In | Time Out | Overtime hours | Travel time hours | Overtime  Multiplier | Overtime Earned | Meal Allowance | Night Differential | Total Due
No | 2010-10-01 00:00:00 | Friday | 0 | 17:30:00 | 20:20:00 | 2.833333333333334 | 0 | 1.5 | 255.0000000000001 | 10 | 0 | 265.0000000000001
No | 2010-10-06 00:00:00 | Wednesday | 0 | 17:30:00 | 22:30:00 | 5.000000000000001 | 0 | 1.5 | 450.0000000000001 | 10 | #N/A | #N/A
No | 2010-10-09 00:00:00 | Saturday | 0 | 08:00:00 | 19:22:00 | 11.36666666666667 | 0 | 1.5 | 1023 | 10 | 0 | 1033
No | 2010-10-10 00:00:00 | Sunday | 0 | 10:00:00 | 13:30:00 | 3.5 | 0 | 2 | 419.9999999999999 | 0 | 0 | 419.9999999999999
No | 2010-10-11 00:00:00 | Monday | 1 | 08:00:00 | 17:00:00 | 9.000000000000002 | 0 | 2 | 1080 | 0 | 0 | 1080
 |  |  |  |  |  | 31.7 | 0 | 8.5 | 3228 | 30 | #N/A | #N/A
 |  |  |  |  | Notes:
 |  |  |  |  | Travel overtime- | this pertains to time spent on travelling while rendering overtime.  Usually this happens if an employee is to partake
 |  |  |  |  |  | in a company-sponsored event within the city or out of the country
 |  |  |  |  |  | MAX number of hours to be claimed is 12 hours
 |  |  |  |  |  | this columns is the computation of number of travel time hours earned if "Yes" is selected from column A (Travel overtime)
 |  |  |  |  |  | I think my formula works just fine but I do not know how to include the maximum 12-hour condition.  Because there
 |  |  |  |  |  | are instances in which an employee may have longer than 12-hour flight (from North America to Asia)
 |  |  |  |  |  | Only employees hired before 05Jan05 are entitled to receive a $5 meal allowance
Travel Time |  |  |  |  |  | if an employee worked beyond 7pm during holidays and weekends, he gets $10 ($5*2)
Yes |  |  |  |  |  | If he works beyond 7pm on regular working days, he's just entitled to 1 meal allowance
No |  |  |  |  |  | Regular working days and time are Monday to Friday, 8-5pm
 |  |  |  |  |  | This is an enetilement if the overtime work is rendered from 10pm until 6 am the next day.
Travel Time Question |  |  |  |  |  | The employee should have started before or exactly 10 pm for him to be eligible for this entitlement
Yes |  |  |  |  |  | This is equal to 10% of his hourly rate.
 |  |  |  |  |  | I do not exactly how to factor in the in-and-out time in the formula.
Spreadsheet: 39011d1237229816-excel-2007-opening-excel-2007-in-excel-2003-issue-test
Sheet: RM

Construct Group: Relationship with Manager
Question | Strongly agree | Agree | Disagree | Strongly disagree | Question Grand Total
Total Responses
Total Responses
Total Responses
Total Responses
Total Responses
Total Responses
Total Responses
Total Responses
Grand Total of Responses |  |  |  |  | Overall Grand Total
Overall Construct Group Summary | Strongly Agree | Agree | Disagree | Strongly disagree
Spreadsheet: 691868d1597927313-fetching-value-from-another-sheet-for-next-9-months-if-the-month-changes-testing-d1_chris
Sheet: Reference

 |  |  | TYPE 1 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00
 |  |  | A |  | 1 |  |  | 1
 |  |  | B |  |  |  |  |  |  | 1 | 1 | 2
 |  |  | C |  |  |  |  |  |  | 1 | 1
 |  |  | D |  |  |  |  |  |  |  | 1 | 2
 |  |  | E |  | 1 |  |  |  |  |  | 1
 |  |  | F
 |  |  | TYPE 2 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00
 |  |  | X |  | 1 |  |  |  |  |  |  |  | 2 | 2
 |  |  | Y |  |  |  |  |  |  | 1 |  | 1 | 2
 |  |  | Z
Spreadsheet: 730992d1620101692-split-data-between-phone-number-and-next-name-contacts-2021-04-28-16-04-52-test
Sheet: Contacts-2021-04-28-16-04-52 te

Mobile Numbers | Example | Example
[NAME]: [PHONE] Robyn: [PHONE]
di mapleson mobile: 0428 478 [NAME]: 0449 626 140 Greg Morris: 0438 480 89 [NAME]: [PHONE]
Mobile: 0409 794 138 Mobile: [PHONE]
debbie: [PHONE]
Either of the examples in B2 to C2 or B3 to I3 would be fine as a result
Spreadsheet: 814167d1674201221-if-b5-b128-contain-words-sum-left-hand-side-value-of-those-ask
Sheet: 無15%

DEBIT NOTE (分判商扣款通知)
地 盤 名 稱  : |  | 青衣青康路北一期及二期 |  |  |  | Our Outgoing Reference 信件編號  : | CSHK/BJH/G19/2023/11461
To 致 | : | 均記建築工程有限公司 |  |  |  | Debit Note Reference 扣款書編號  : | 435
Attn. 啟 | : | 孫健均先生 |  |  |  | Date  日 期  : | 2023-01-20 00:00:00
 |  |  |  |  |  | Reference Correspondence 參考文件  : | CSHK/BJH/G19/2023/11217
 |  |  |  |  |  | By Fax To 傳真到 :
 |  |  |  |  |  | By Hand / By Mail 親遞 /  郵寄 : | By Hand
Subcontract : |  | #N/A
分判工程合約
In accordance with the Subcontract Clauses, we hereby inform you that an net amount |  |  |  |  |  | 0
which will be deducted in your forthcoming payment account.
現發此分判商扣款通知書給貴公司, 根據分判合約細則將會向貴號來月之中期/尾期糧款內扣除金額 港幣 |  |  |  |  |  |  | 0
Item(項目) |  | Description | (工作描述) | Unit (單位) | Quantity(數量) | Unit Rate(單價) | Amount | (金額HK$)
1 |  | 均記無故缺席每週安全及環保巡查事宜 |  | 單 | 1 | 0 |  | 0
 |  |  |  |  |  | Total (HK$) = |  | 0
The deduction or set off will not relieve you any liability of the Subcontract.
有關是次代做所引起之損失, 我公司將按合約細則, 會於貴號來月之糧款內扣除。 但貴號仍需履行所有合約內之
工作及責任。
For and on behalf of CSHK |  |  |  |  |  | For and on behalf of CSHK
Deputy Site Manager / Project Quantity Surveyor |  |  |  |  |  | Site Manager / Project Manager
Encl. as stated (抄送)
1) |  | Q.S.
Remark: | Objection raises after 3 working days of this debit note issued in any reason will not be entertained (Unwritten objection is not accepted)
 | 此扣款書若發出後 3 個工作天仍未收到書面反對則當同意扣款論
Spreadsheet: 169548d1342933678-interesting-data-extraction-and-calculation-conundrum-example-sales-report
Sheet: Sales Report

Sales Report
Grouped by [NAME]
 |  |  |  | Margin
 |  |  |  | ------------
JMR |  |  |  | 2000
BWW |  |  |  | 507.07
JTF |  |  |  | 790.86
JDK |  |  |  | 1068.33
RJM |  |  |  | 1565.55
JFC |  |  |  | 1609.69
BAM |  |  |  | 1764.58
RVR |  |  |  | 2017.49
SML |  |  |  | 2212.25
CSA |  |  |  | 2305.53
adn |  |  |  | 3174.38
BWW/JMR |  |  |  | 2000
JTF/RJM |  |  |  | 3290
BAM/CSA |  |  |  | 1190
Spreadsheet: 91730d1291394456-need-to-add-cells-together-within-a-date-workbook2
Sheet: Sheet1

DATE | COLOUR | FREQUENCY | SUB TOTAL
2009-12-01 00:00:00 | BLACK | 5
2009-12-01 00:00:00 | WHITE | 6
2009-12-01 00:00:00 | BLUE | 9
2009-12-01 00:00:00 | RED | 2
2009-12-01 00:00:00 | YELLOW | 5
2009-12-01 00:00:00 | ORANGE | 8
2009-12-02 00:00:00 | BLACK | 5
2009-12-02 00:00:00 | WHITE | 7
2009-12-02 00:00:00 | BLUE | 4
2009-12-02 00:00:00 | RED | 5
2009-12-02 00:00:00 | YELLOW | 3
2009-12-02 00:00:00 | ORANGE | 8
2009-12-02 00:00:00 | PINK | 8
2009-12-02 00:00:00 | GREEN | 2
2009-12-02 00:00:00 | PURPLE | 6
2009-12-03 00:00:00 | BLACK | 5
2009-12-03 00:00:00 | PURPLE | 5
2009-12-03 00:00:00 | BLUE | 4
2009-12-03 00:00:00 | PINK | 2
2009-12-03 00:00:00 | YELLOW | 4
2009-12-03 00:00:00 | ORANGE | 1
2009-12-03 00:00:00 | GREEN | 2
Spreadsheet: 767846d1644673788-formula-to-copy-rows-based-on-on-three-different-criteria-sample-5-
Sheet: Result

Ref | Location | Text 1 | Full Name | First Name | Surname | email | Category
Spreadsheet: 492327d1481039773-formula-to-copy-filtered-data-to-another-tab-example-with-table
Sheet: Data

Code | Type | Number
AAA | Project | 1
BBB | Major Project | 2
CCC | Minor Project | 3
AAA | MSA Small Project | 4
BBB | Fixed Price | 5
CCC | Programme | 6
AAA | Project | 7
BBB | Major Project | 8
AAA | Minor Project | 9
BBB | MSA Standard Project | 10
CCC | Fixed Price | 11
AAA | Quote | 12
BBB | Fixed Price | 13
CCC | BAU | 14
AAA | Fixed Price | 15
BBB | Major Project | 16
AAA | Minor Project | 17
BBB | Project | 18
CCC | Programme | 19
AAA | BAU | 20
BBB | Minor Project | 21
CCC | Minor Project | 22
AAA | Fixed Price | 23
BBB | Minor Project | 24
AAA | Project | 25
BBB | Programme | 26
Spreadsheet: 668999d1585156865-move-rows-to-separate-sheets-new-budget-test
Sheet: 2100 21 7580

Date | Vendor | Item | P.O.# | Amount | Acct Code
Spreadsheet: 820439d1678108765-dax-formula-to-modify-concatenate-behavior-sampleservice-data-1-
Sheet: EmployeeList

Employee | Team
[NAME] | Financials
[NAME] | Consumer
[NAME] | Industrials
[NAME] | Financials
[NAME] | Consumer
[NAME] | Industrials
[NAME] | Financials
[NAME] | Financials
[NAME] | Financials
[NAME] | Consumer
[NAME] | Industrials
Spreadsheet: 215849d1361515165-searching-for-a-value-in-multiple-sheets-fame1
Sheet: SN8(050912-07)

3.059 | 3.017 | 3.1 | TIC | 27581 | 0.31 | 12269 | 0.47 | 2.25 |  | Propanoic acid, decyl ester
3.554 | 3.533 | 3.57 | TIC | 4193 | 0.05 | 3532 | 0.14 | 1.19 |  | ISOCHIAPIN B
3.707 | 3.653 | 3.75 | TIC | 56270 | 0.64 | 26225 | 1.01 | 2.15 |  | METHYL TETRADECANOATE
3.753 | 3.75 | 3.773 | TIC | 1924 | 0.02 | 2576 | 0.1 | 0.75 | V | Lutein
3.992 | 3.957 | 4.08 | TIC | 13332 | 0.15 | 3964 | 0.15 | 3.36 |  | E-2-Hexenyl E-2-octenoate
4.087 | 4.08 | 4.107 | TIC | 988 | 0.01 | 393 | 0.02 | 2.51 |  | 3,5,7,7-tetramethyl-11-methylidene-1,2-dioxaspiro[5.5]undec-4-en-3-ol
4.117 | 4.107 | 4.133 | TIC | 2802 | 0.03 | 1401 | 0.05 | 2 |  | POGOSTOL
4.165 | 4.133 | 4.203 | TIC | 27709 | 0.31 | 9600 | 0.37 | 2.89 | V | Phosphonic acid, dioctadecyl ester
4.213 | 4.203 | 4.22 | TIC | 5017 | 0.06 | 5612 | 0.22 | 0.89 | V | Ethyl iso-allocholate
4.227 | 4.22 | 4.253 | TIC | 4708 | 0.05 | 4089 | 0.16 | 1.15 | V | 3.alpha.,4.alpha.[NAME].[NAME]
4.323 | 4.253 | 4.37 | TIC | 46278 | 0.52 | 17174 | 0.66 | 2.69 | V | 6-Octadecenoic acid, methyl ester (CAS) Methyl 6-octadecenoate
4.432 | 4.37 | 4.487 | TIC | 34769 | 0.39 | 13214 | 0.51 | 2.63 | V | METHYL PENTADECANOATE
4.51 | 4.487 | 4.513 | TIC | 1391 | 0.02 | 995 | 0.04 | 1.4 | V | Thiophenol, 3,5-dimethyl-S-ethylthiothion-
4.588 | 4.513 | 4.64 | TIC | 533946 | 6.04 | 221210 | 8.45 | 2.41 |  | NEOPHYTADIENE
4.659 | 4.64 | 4.717 | TIC | 34660 | 0.39 | 13899 | 0.53 | 2.49 | V | Cyclopentadecanone
4.723 | 4.717 | 4.733 | TIC | 1566 | 0.02 | 2851 | 0.11 | 0.55 | V | 2-Octen-1-ol, 3,7-dimethyl-, isobutyrate, (Z)-
4.751 | 4.743 | 4.77 | TIC | 1613 | 0.02 | 2482 | 0.1 | 0.65 |  | 14.alpha.-Methyl-5.alpha.-ergosta-8,24(28)-dien-3.beta.-ol
4.808 | 4.77 | 4.89 | TIC | 53634 | 0.61 | 17292 | 0.66 | 3.1 | V | 3,7,11,15-Tetramethyl-2-hexadecen-1-ol
5.008 | 4.96 | 5.067 | TIC | 30382 | 0.34 | 11118 | 0.43 | 2.73 |  | 3,7,11,15-Tetramethyl-2-hexadecen-1-ol
Spreadsheet: 145111d1331309400-remove-blocks-of-data-with-conditions-block-test
Sheet: Sheet2

1999-01-01 00:00:00 | data | name | course | time
2000-03-02 00:00:00 | 5 | [NAME] | NEW | 320
2000-03-02 00:00:00 | 7 | Tropical King | NEW | 320
2000-03-02 00:00:00 | 4 | [NAME] | NEW | 320
2000-03-02 00:00:00 | 2 | Found At Last | NEW | 320
2000-03-02 00:00:00 | 6 | Hill Farm Dancer | NEW | 420
2000-03-02 00:00:00 | 4 | Approachable | NEW | 420
2000-03-04 00:00:00 | 6 | Baritone | WOL | 140
2000-03-04 00:00:00 | 1 | College Blue | WOL | 140
2000-03-04 00:00:00 | 3 | Aubrieta | WOL | 140
2000-03-04 00:00:00 | 5 | [NAME] | WOL | 245
2000-03-04 00:00:00 | 2 | [NAME] | WOL | 245
2000-03-04 00:00:00 | 4 | Frilly Front | WOL | 315
2000-03-04 00:00:00 | 7 | Ready To Rock | WOL | 315
2000-03-04 00:00:00 | 6 | Bramble Bear | WOL | 315
2000-03-04 00:00:00 | 3 | Aa-Youknownothing | WOL | 315
2000-03-04 00:00:00 | 4 | [NAME] | WOL | 350
2000-03-04 00:00:00 | 9 | Fusul | WOL | 350
2000-03-04 00:00:00 | 5 | Anemos | WOL | 350
Spreadsheet: 140445d1328748531-schedule-making-find-first-and-last-occurance-of-value-schedules
Sheet: Sheet1

DESIRED RESULTS BELOW
Employee A |  |  |  | Employee B |  |  |  | Employee C |  |  |  | Employee D
Date | Time In | Time Out | Hours | Date | Time In | Time Out | Hours | Date | Time In | Time Out | Hours | Date | Time In | Time Out | Hours
2012-03-01 00:00:00 | 00:00:00 | 08:00:00 | 8 | 2012-03-01 00:00:00 | 08:00:00 | 17:00:00 | 9 | 2012-03-01 00:00:00 | 17:00:00 | 22:00:00 | 5
2012-03-01 00:00:00 | 22:00:00 | 00:00:00 | 2
Spreadsheet: 0039fd5f-f8d7-4e25-98eb-246a5f21092d
Sheet: Sheet1

QUALITY INDICATORS for PROGRAM REVIEW
School to Employment Programs
Instructions for Self-Study
Purpose:
Quality Indicators are designed for school districts to assess transition services for students with developmental disabilities in school to employment programs. By using this tool, school district teams will have a common understanding of what constitutes quality programming and best practice in secondary special education and transition.  This activity will promote planning and continuous improvement to increase post-school outcomes for students.
The Quality Indicators focus on four domains:
1.  School-based Activities
2.  Work-based Activities
3.  Independent Living Activities
4.  Connecting Activities
Suggested Review Team Members:
1. Special Education Teacher(s)
2. Special Education Administration
3. Support Personnel: counselor, psychologist, transition specialist
4. Building Administration
5. CTE/career education staff
6. Student or family, if possible
Directions:
There are two formats available for review teams to use:  computer-scored review and
manually-scored review.  This is the manually-scored format.
Almost Always=occurs more than 76% of the time ~ Frequently=occurs 51%-75% of the time Sometimes=occurs 26%-50% of the time ~ Almost Never=occurs 25% or less of the time
Manually-scored format:
1. This is an Excel spreadsheet document but all calculations must be done by hand;
2. Print a hardcopy on which to work; click on File, Print, [NAME];
3. Rate each Indicator (100) as Almost Always, Frequently, Sometimes, or Almost
Never; mark an X in the corresponding box;
4. Add the total in each column and multiply the total by the weighted number indicated;
5. Add the totals of all columns (4) and enter the total in the appropriate box;
6. Copy the total to the corresponding section on the Score Sheet;
7. On the score sheet add the scores for all Indicators and enter the total;
8. Record the total ratings and divide by 300 (maximum possible points).