tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 753132d1635263959-index-match-formula-for-duplicate-values-pq-duplicate-index-matches-aligw
Sheet: Date Order

Part | Due |  |  |  | Part | Due
 |  |  | Should be: |  | AG22155 | 2019-01-04 00:00:00
 |  |  |  |  | SP18475 | 2019-01-04 00:00:00 |  | 2019-01-04 00:00:00 | 2019-01-04 00:00:00 | 2019-01-07 00:00:00 | 2019-01-10 00:00:00 | 2019-01-13 00:00:00 | 2019-01-14 00:00:00 | 2019-01-17 00:00:00 | 2019-01-17 00:00:00 | 2019-01-22 00:00:00 | 2019-01-23 00:00:00 | 2019-01-28 00:00:00 | 2019-01-29 00:00:00 | 2019-01-29 00:00:00 | 2019-01-31 00:00:00 | 2019-01-31 00:00:00 | 2019-02-04 00:00:00 | 2019-02-04 00:00:00 | 2019-02-06 00:00:00 | 2019-02-14 00:00:00 | 2019-02-15 00:00:00 | 2019-02-16 00:00:00 | 2019-02-16 00:00:00 | 2019-02-17 00:00:00 | 2019-02-17 00:00:00 | 2019-02-17 00:00:00 | 2019-02-24 00:00:00 | 2019-02-26 00:00:00 | 2019-02-26 00:00:00 | 2019-02-27 00:00:00 | 2019-02-27 00:00:00
 |  |  |  |  | BX35640 | 2019-01-07 00:00:00 |  | SP18475 | AG22155 | BX35640 | SE25509 | LS18007 | RQ33652 | DT20254 | XJ28600 | LT21272 | YV31055 | XR24765 | SI15345 | TB15510 | JF34904 | BK36701 | [NAME] | ZS11542 | XA32691 | CC20434 | GQ18803 | MW33367 | NF34465 | GD38853 | JU13976 | NR26220 | OX17453 | SG20341 | WA14608 | OS14484 | QY34954
 |  |  |  |  | SE25509 | 2019-01-10 00:00:00
 |  |  |  |  | LS18007 | 2019-01-13 00:00:00
 |  |  |  |  | RQ33652 | 2019-01-14 00:00:00
 |  |  |  |  | DT20254 | 2019-01-17 00:00:00
 |  |  |  |  | XJ28600 | 2019-01-17 00:00:00
 |  |  |  |  | LT21272 | 2019-01-22 00:00:00
 |  |  |  |  | YV31055 | 2019-01-23 00:00:00
 |  |  |  |  | XR24765 | 2019-01-28 00:00:00
 |  |  |  |  | SI15345 | 2019-01-29 00:00:00
 |  |  |  |  | TB15510 | 2019-01-29 00:00:00
 |  |  |  |  | BK36701 | 2019-01-31 00:00:00
 |  |  |  |  | JF34904 | 2019-01-31 00:00:00
 |  |  |  |  | [NAME] | 2019-02-04 00:00:00
 |  |  |  |  | ZS11542 | 2019-02-04 00:00:00
 |  |  |  |  | XA32691 | 2019-02-06 00:00:00
 |  |  |  |  | CC20434 | 2019-02-14 00:00:00
 |  |  |  |  | GQ18803 | 2019-02-15 00:00:00
 |  |  |  |  | MW33367 | 2019-02-16 00:00:00
 |  |  |  |  | NF34465 | 2019-02-16 00:00:00
 |  |  |  |  | GD38853 | 2019-02-17 00:00:00
 |  |  |  |  | JU13976 | 2019-02-17 00:00:00
 |  |  |  |  | NR26220 | 2019-02-17 00:00:00
 |  |  |  |  | OX17453 | 2019-02-24 00:00:00
 |  |  |  |  | SG20341 | 2019-02-26 00:00:00
 |  |  |  |  | WA14608 | 2019-02-26 00:00:00
 |  |  |  |  | OS14484 | 2019-02-27 00:00:00
 |  |  |  |  | QY34954 | 2019-02-27 00:00:00
Spreadsheet: 744724d1629396784-multiple-match-variable-combine-with-left-function-
Sheet: Sheet1

3-4 ID | First Name | Last Name |  |  | First Name | Last Name | 3/4
KFQ4459 | [NAME] | DAVENPORT |  |  | [NAME] | Anzardo
RPU9224 | [NAME] | DAVENPORT |  |  | [NAME] | [NAME]
IWJ7582 | MISTI | DAVENPORT |  |  | [NAME] | Davenport
HZE7419 | ROBIN | DAVENPORT |  |  | Orlando | [NAME]
ABC123 | [NAME] | DAVENPORT
Spreadsheet: 537417d1505061652-record-a-cell-value-and-date-before-closing-excel-bare-net-worth-calc
Sheet: Net Worth Calculator

 | Net Worth Calculator
 |  |  |  | Estimated Net Worth:
 |  |  |  | Net cash equivelant :
 | Assets |  |  | Liabilities
 | Property | Estimated Current Value |  | Loan Balances | Estimated Current Value
 | Current Value of Home | 50000 |  | Left to Pay on Mortgage | 20000
 | Current Value of Holiday Home in France | 50000 |  |  | 0
 | Current Value of Vehicle{s}
 | [NAME] | 25000
 | Car2 Ford | 10000
 | Car3 Lotus | 5000
 | Car4 Mini | 3000
 | [NAME] | 2000
 | Car6 lambo | 1000
 | Personal Items
 | Jewelry | 200 |  | Car loans | 10000
 | Furniture | 1000 |  | Business Loans | 2000
 | Electronics | 3000 |  | Student loans | 0
 | Artwork/Antiques | 500 |  | Other loans | 0
 | Garage Equipment | 400
 | Other | 0 |  | Other Outstanding Debt
 | Cash or Cash Equivalent |  |  | Credit card debt | 5000
 | Main account Holder |  |  | Money Owed to Family/Friends | 10
 | Account1 | 1000 |  | Other debt | 0
 | Account2 | 1000
 | Account3 | 1000
 | Account4 | 1000
 | Account5 | 1000
 | Account6 | 1000
 | Account7 | 1000
 | Account8 | 1000
 | Account9 | 1000
 | Account10 | 1000
 | Account11 | 1000
 | [NAME] | 1000
 | Other | 0
 | Pension | 0
 | Second account holder
 | Account1 | 1000
 | Account2 | 1000
 | Account3 | 1000
 |  | 0
 | Other | 0
 |  | 0
 | Funds
 | Peer to Peer Investments | 50
 | SHARES 1 | 2500
 | SHARES 2 | 500
 | Individual stock shares | 1000
 |  | 0
 | Other Investments
 | Premium Bonds | 5000
 | Stocks | 1000
 | Total Assets |  |  | Total Liabilities
Spreadsheet: 837322d1690042788-how-do-you-provide-points-based-on-a-defined-lookup-targets-table-points-based-on-value
Sheet: Targets

 |  | Target |  | Pts |  | 0.09
[NAME] | Test | 0.1 | <= | 10 |  | 0.1 |  | 0.1 | <= | 10
[NAME] | Test | 0.13 | <= | 5 |  | 0.11 |  | 0.13 | <= | 5
[NAME] | Test | 0.17 | <= | 2 |  | 0.12 |  | 0.17 | <= | 2
[NAME] | Test | 0.99 | > | 0 |  | 0.13 |  | 0.99 | <= | 0
Area2 | Test | 0.12 | <= | 10 |  | 0.14
Area2 | Test | 0.15 | <= | 7 |  | 0.15
Area2 | Test | 0.19 | <= | 4 |  | 0.16
Area2 | Test | 0.19 | > | 0 |  | 0.17
[NAME] | Test2 | 30 | <= | 10 |  | 0.18
[NAME] | Test2 | 40 | <= | 5
[NAME] | Test2 | 45 | <= | 2
[NAME] | Test2 | 45 | > | 0
Area2 | Test2 | 20 | <= | 10
Area2 | Test2 | 30 | <= | 7
Area2 | Test2 | 35 | <= | 4
Area2 | Test2 | 35 | > | 0
Spreadsheet: 73577d1274214793-data-list-formatting-scott_test1
Sheet: Sheet1

 |  | T | 25
 |  | TA | 10
 |  | HLTA | 12.5
 |  | [NAME] | 27.5
Interventions | Delivered by (initials) | Type of staff | Length of session (Hrs) | Frequency per week | Length of provision (weeks) |  | Cost per intervention | Number of pupils | Cost per pupil |  | Evaluation (Value for Money)                                 Compare cost against pupil outcomes | VFM
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13
[NAME] |  |  |  |  |  |  | 0 |  | 0
scott1 |  |  |  |  |  |  | 0 |  | 0
scott2 |  |  |  |  |  |  | 0 |  | 0
[NAME] |  |  |  |  |  |  | 0 |  | 0
Spreadsheet: 874440d1721040642-return-value-from-a-cell-in-a-range-based-on-data-validation-book1
Sheet: Sheet1

[NAME] | Currency | Site Survey Costs | On-Site Manager Local Costs | On-Site Manager All Inclusive Costs | On-Site Rate | Site Survey
Same Day Rig | CHF | 2115 | 3075 | 5000 | Local | Yes
Previous Day Rig | DKK |  |  |  | All Inclusive | No
 | EUR | 1715 | 2710 | 4405 | No Onsite Required
 | GBP | 1455 | 2430 | 3950
 | SEK | 22100 | 29410 | 47760
 | USD | 2310 | 3075 | 5000
Spreadsheet: 786568d1657277938-counting-values-from-multiple-tables-ranges-with-same-fields-but-differing-records-count-help
Sheet: Team 1

Team 1
 | Role 1 | Role 2 | Role 3 | Total
Job 1 | 3 | 5 | 6
Job 2 | 10 | 2 | 7
Job 3 | 6 | 11 | 5
Total
Spreadsheet: 825251d1681213229-help-obtaining-a-result-of-zero-__help-result-should-be-0
Sheet: Sheet1

 |  | Inventory |  |  |  |  |  |  | This result is incorrect since I haven't made some of the items yet but will be OK when the formula below is fixed.
 | RETAIL | Made | Sold | Qty LEFT | Mat & Labour Value EA | Openning Value | Closing Value | PROFIT per item
 | 21 | 1 |  |  | 4.89
 | 21 | 3 | 2 |  | 4.54
 | 21 | 2 | 2 |  | 4.44
 | 21 | 5 | 2 |  | 5.79
 | 21 | 1 |  |  | 5.44
 | 21 |  |  |  | 5.44 |  |  |  | This result should be zero since I haven't made the item yet but have already got the costs to make it .  What is the formula to return a "zero"?
 | 21 |  |  |  | 4.51
 | 21
 | 21
Spreadsheet: 78969d1279215684-how-to-identify-the-top-3-for-each-category-help
Sheet: Sheet1

 |  |  |  |  | Expected Result of top 3 customers for each category
 | category | customer |  |  |  | category | Top | Second | Third
0G34 | a | 200 | 2010-W20 |  | 0G34 | a | 264 | 200 | 167
0G34 | a | 4 | 2010-W20 |  | 0G54 | b | 2 | NA | NA
0G34 | a | 264 | 2010-W20 |  | 0G60 | c | 80 | 30 | 10
0G34 | a | 167 | 2010-W20 |  | 0G62 | e | 370 | 180 | 150
0G34 | a | 3 | 2010-W20 |  | 0J11 | f | 1400 | 150 | 30
0G54 | b | 2 | 2010-W20 |  | 0J14 | g | 1990 | 300 | 235
0G60 | c | 30 | 2010-W20
0G60 | c | 10 | 2010-W20
0G60 | c | 80 | 2010-W20
0G60 | c | 1 | 2010-W20
0G62 | e | 150 | 2010-W20
0G62 | e | 2 | 2010-W20
0G62 | e | 180 | 2010-W20
0G62 | e | 370 | 2010-W20
0J11 | f | 150 | 2010-W20
0J11 | f | 1400 | 2010-W20
0J11 | f | 50 | 2010-W20
0J11 | f | 3 | 2010-W20
0J11 | f | 30 | 2010-W20
0J14 | g | 20 | 2010-W20
0J14 | g | 300 | 2010-W20
0J14 | g | 40 | 2010-W20
0J14 | g | 45 | 2010-W20
0J14 | g | 235 | 2010-W20
0J14 | g | 1990 | 2010-W20
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 63150 | 59999
2 | 64643 | 60000 |  |  |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 65488 | 60000 |  |  |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 61296 | 60000 |  |  |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 |  |  |  |  |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 |  |  |  |  |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
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
2002-01-31 00:00:00 |  |  |  |  | 466236.13
2002-02-04 00:00:00
CBS Volume
 |  |  | 20760
Spreadsheet: 55798d1255979006-resolved-hyperlink-generic-hyperlink
Sheet: Sheet1

File: | See List |  | File List
Description: |  |  | [NAME]
 |  |  | LINEA2FMRASSTFILE
Output (created): | ExtractUsingLineTwoCases |  | LINEA2NEVRASSTFILE
 |  |  | [NAME]
Input (used): |  |  | LINEA2AFMRASSTFILE
 |  |  | [NAME]
Layout: | [NAME] |  | LINEA2BCURRASSTFILE
 | line2CaseSufx |  | LINEA2BFMRASSTFILE
 | Filler-space |  | LINEA2BNEVRASSTFILE
 | line2CaseSts |  | LINEA2CCURRASSTFILE
 | Filler-space |  | [NAME]
 | line2CaseType |  | LINEA2CNEVRASSTFILE
 | Filler-space |  | LINEA2DNEVERASSTFILE
 | line2casestseffdt |  | LINEA2EFILE
 | Filler-space |  | LINEA2FCURRASSTFILE
 | line2caseid |  | LINEA2FFMRASSTFILE
 | Filler-space |  | [NAME]
 | line2ActiveOrder |  | [NAME]
 | Filler-space |  | [NAME]
 | line2OfcCd |  | LINEA2GNEVERASSTFILE
 | Filler-space |  | LINEA2HCURRASSTFILE
 | line2RspCnty |  | LINEA2HFMRASSTFILE
 | Filler-space |  | LINEA2HNEVERASSTFILE
 | line2SprvsUnit |  | LINEA2ICURRASSTFILE
 | Filler-space |  | LINEA2IFMRASSTFILE
 | line2WorkerID |  | LINEA2INEVERASSTFILE
 |  |  | [NAME]
Spreadsheet: 0eeeecb1-9bc4-422e-8009-b04dc6c4269e
Sheet: TABLE

#1 Access | 5 Year MSJC TEM 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 | 27.03116883116883 |  | 27.28238341968912 |  | 26.94643259059194 |  | 26.76818298637882 |  | 26.38652373660031
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: 594375d1539715047-show-rows-with-specific-text-in-a-column-in-another-file-ef1211_task-assigneed-to
Sheet: Team B

Team B | S no | Work
Spreadsheet: kimberly_watson__20634__tw_priority_rate
Sheet: 9911-9912

Transwestern Pipeline Company
Contracts Under the Global Settlement
Priority Rates (Reservation and Demand Surcharges)
Contract | Shipper | Receipt to Delivery | Reservation | Shared Cost | TCR II No. 1 | TCR II No. 2 | GRI Demand | Total |  | Commodity
Number | Name | Area | Rate | Surcharge | Surcharge | Surcharge | Surcharge | Rate |  | Rate
8255 | Southern California Gas Company | East of Thoreau to California (W. of Thoreau) | 0.3168 |  | 0.0051 | 0.0007 | 0.0076 |  |  | 0.0233
20834 | Citizens Utilities Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - | -
20835 | Conoco Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - | -
21175 | Pacific Gas & Electric Company(Gas) | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - | -
26677 | El Paso Energy Marketing Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - | -
26371 | Duke Energy Trading and Marketing. LLC | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - | -
25923 | Texaco Natural Gas Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - | -
20715 | Southern California Gas Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1031 | - | - | - | -
20747 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0369 | 0.0052 | 0.0007 | 0.0076 |  |  | 0.0159
20748 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0369 | 0.0052 | 0.0007 | 0.0047 |  |  | 0.0159
21165 | Pacific Gas & Electric Company(Gas) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0443 | 0.005 | 0.0007 | 0.0076 |  |  | 0.0159
26678 | El Paso Energy Marketing Company | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0443 | 0.0051 | 0.0007 | 0.0076 |  |  | 0.0159
26372 | Duke Energy Trading and Marketing. LLC | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0443 | 0.0051 | 0.0007 | 0.0076 |  |  | 0.0159
25924 | Texaco Natural Gas Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2554 | 0.0443 | 0.0053 | 0.0007 | - |  |  | 0.0159
20822 | Citizens Utilities Company | Thoreau/San Juan Pt. to East of California (W. of Thoreau) | 0.1647 | 0.0369 | 0.0023 | 0.0003 | 0.0047 |  |  | 0.0159
NOTE --- | Per CBS Negotiated Rate System, the termination date for the rates listed above are as follows:
 | Reservation | 1999-10-31 00:00:00
 | SCS | 2001-10-31 00:00:00
 | TCR II No. 1 | 2005-10-31 00:00:00
 | TCR II No. 1 | 2006-10-31 00:00:00
 | GRI Demand | N/A **
 | ** Calculation made every year to determine which contracts are High Load vs. Low Load
Spreadsheet: 885141d1734556879-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-example
Sheet: BooKRef Team E

Team A
Surname | First name | Number | [NAME] | Task A | Part of Task A completed | Next part of Task A | x1 | Task B | Part of Task B completed | Next part of Task B | x2 | Task C | Part of Task C completed | Next part of Task C | [NAME] | Task D | Part of Task D completed | Next part of Task D
 |  |  |  | M05 IME | BSC-IME
 |  |  |  | M05 IME | BSC-SF
 |  |  |  | M07 IME | BSC-TR1
 |  |  |  | M06 IME | ADV-TR1
Spreadsheet: 185301d1349632627-tricky-puzzle-sum-and-indirect-formula-issue-resource_allocation_asim
Sheet: ISP899

Project Name: Consumption
Project ID: ISP877 | (Person hrs / week ending Sun)
Resource Types & Named Individuals | Mar |  |  |  | Apr |  |  |  |  | May |  |  |  | June |  |  |  |  | July |  |  |  | August |  |  |  | September |  |  |  |  | October |  |  |  | November |  |  |  | December |  |  |  |  | Jan |  |  |  | Feb |  |  |  |  | Totals
 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00 | 2012-05-27 00:00:00 | 2012-06-03 00:00:00 | 2012-06-10 00:00:00 | 2012-06-17 00:00:00 | 2012-06-24 00:00:00 | 2012-07-01 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | 2012-07-29 00:00:00 | 2012-08-05 00:00:00 | 2012-08-12 00:00:00 | 2012-08-19 00:00:00 | 2012-08-26 00:00:00 | 2012-09-02 00:00:00 | 2012-09-09 00:00:00 | 2012-09-16 00:00:00 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00 | 2012-10-07 00:00:00 | 2012-10-14 00:00:00 | 2012-10-21 00:00:00 | 2012-10-28 00:00:00 | 2012-11-04 00:00:00 | 2012-11-11 00:00:00 | 2012-11-18 00:00:00 | 2012-11-25 00:00:00 | 2012-12-02 00:00:00 | 2012-12-09 00:00:00 | 2012-12-16 00:00:00 | 2012-12-23 00:00:00 | 2012-12-30 00:00:00 | 2013-01-06 00:00:00 | 2013-01-13 00:00:00 | 2013-01-20 00:00:00 | 2013-01-27 00:00:00 | 2013-02-03 00:00:00 | 2013-02-10 00:00:00 | 2013-02-17 00:00:00 | 2013-02-24 00:00:00 | 2013-03-03 00:00:00
Project Management
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 7 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
Unassigned
Total PM
[NAME] (signature):
DBA SQL
Insert names
Unassigned
Total DBA SQL
Resource Manager (signature):
DBA Oracle
Insert names
Unassigned
Total DBA Oracle
Resource Manager (signature):
Networking
Insert names
Unassigned
Total Networking
Resource Manager (signature):
Client Devices
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 37 | 28 | 14
Will Waters |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Total Client Devices
Resource Manager (signature):
Business Applications
[NAME]
Total Business Applications
Dom Twist (signature):
Core Services
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.7 |  | 7 |  |  |  |  | 14 | 7
Total Core Services
[NAME] (signature):
Security
Insert names
Unassigned
Total Security
Resource Manager (signature):
Systems Integration
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  | 7 |  |  | 14
Unassigned
Total System Integration
[NAME] (signature):
Spreadsheet: 842816d1694794303-adding-data-to-table-daily-and-sum-totals-every-2-weeks-dro-template-payments-revised
Sheet: Top Sheet for Payment

 |  | Aug 25th - Sept 5th |  | Aug 28-30 |  | Aug 31 - Sept 5
OP # | SAP # | Total Hours | Total $ Payment to be Made | Total Hours | Total $ Payment to be Made | Total Hours | Total $ Payment to be Made
2722 | 2722
9362 | 106019
8317 | 114247
5651 | 119731
5774 | 121564
5952 | 125179
6019 | 126132
6134 | 127876
6224 | 129485
6233 | 129879
7896 | 131202
7959 | 131965
8105 | 133300
8378 | 140375
8395 | 140774
8442 | 142781
8438 | 142786
8463 | 142959
8498 | 143810
8790 | 145508
8801 | 145510
8812 | 146288
8903 | 147146
9188 | 149308
9183 | 149346
9208 | 149586
9246 | 150501
9307 | 150578
9249 | 150813
9304 | 151238
9399 | 153551
9581 | 157108
9485 | 157277
9599 | 158564
9731 | 163314
5721 | 120396
5906 | 124120
5982 | 125524
6063 | 126975
9181 | 145122
8805 | 146284
8964 | 147134
9169 | 149313
9210 | 149591
9223 | 150059
9247 | 150812
9338 | 151788
9394 | 153216
9402 | 153585
9492 | 156365
9508 | 157490
9538 | 157874
9526 | 157887
9625 | 159397
9635 | 159650
9713 | 162355
9704 | 162358
9786 | 164853
9854 | 166030
Spreadsheet: 766657d1643987549-calculate-up-to-this-day-composite-sum-to-this-day-aligw
Sheet: Whole Month

 | EMPLOYEE | SALES | UP TO THIS DAY
2021-01-01 00:00:00 | Yoan | 100
2021-01-01 00:00:00 | Yola | 125
2021-01-01 00:00:00 | Smith | 150
2021-01-01 00:00:00 | [NAME] | 175
2021-01-02 00:00:00 | Yoan | 25
2021-01-02 00:00:00 | Yola | 50
2021-01-02 00:00:00 | Smith | 75
2021-01-02 00:00:00 | [NAME] | 80
2021-01-03 00:00:00 | Yoan | 50
2021-01-03 00:00:00 | Yola | 100
2021-01-03 00:00:00 | Smith | 150
2021-01-03 00:00:00 | [NAME] | 200
2021-01-04 00:00:00 | Yoan | 100
2021-01-04 00:00:00 | Yola | 125
2021-01-04 00:00:00 | Smith | 150
2021-01-04 00:00:00 | [NAME] | 175
2021-01-31 00:00:00 | Yoan | 200
2021-01-31 00:00:00 | Yola | 250
2021-01-31 00:00:00 | Smith | 300
2021-01-31 00:00:00 | [NAME] | 350
Spreadsheet: 729724d1619287636-how-many-ids-in-column-a-match-two-criteria-in-column-b-free-and-paid
Sheet: Sheet1

User ID | Account type
23 | Free
24 | Free
25 | Free
25 | Paid
23 | Free
24 | Free
25 | Paid
23 | Paid
24 | Free
Spreadsheet: 141095d1329094621-salary-increase-spreadsheet-help-example_salary
Sheet: Sheet1

 | Band Level | 1 | 2 | 3 | 4 | 5
Performance % = 1 |  | 1 | 2 | 2 | 2 | 2
Performance % = 2 |  | 2 | 2.5 | 2.5 | 3 | 3
Performance % = 3 |  | 2.5 | 3 | 3 | 4 | 4
Performance % = 4 |  | 3 | 4 | 3 | 4 | 4
Performance % = 5 |  | 4 | 4 | 3 | 4 | 4
 | Current Band | Performance | % Increase
Employee 1 | 1 | 3 | 2.5
Employee 2 | 2 | 4 | 4
Spreadsheet: 692724d1598525263-multiple-spreadsheet-values-required-and-data-returned-over-48hrs-excel-forum
Sheet: WIP Formula

Emp No |  | Name | 48+ Hrs | 10.08.2020 | 17.08.2020 | 24.08.2020
1 | [NAME] | Smith |  |  |  | 49
2 | [NAME] | Jones |  | 56.03
3 | Bobbi | [NAME] |  |  | 48 | 51
4 | [NAME] | Singh |  | 49.71 |  | 62
5 | [NAME] | [NAME] |  | 49.86 | 53
6 | Bertie | Davies |  |  | 47.5
7 | Obi | Stanley |  |  | 49.23
8 | Bobba | [NAME]
9 | [NAME] | Bloggs |  |  | 56 | 47.08
‘=COUNTIFS(10.08.2020!$A$2:$A$750,$A2,10.08.2020!$E$2:$E$750,>=48)
Spreadsheet: 31224d1227024206-marking-grid-points-matrix_example
Sheet: Drivers

Row | Column
1 | 4
1 | 9
1 | 11
3 | 15
3 | 16
4 | 24
4 | 17
5 | 32
5 | 33
5 | 30
6 | 35
9 | 20
9 | 21
9 | 11
9 | 1
9 | 4
10 | 13
12 | 14
12 | 17
12 | 19
12 | 37
13 | 12
13 | 25
14 | 38
14 | 34
14 | 33
18 | 17
19 | 13
22 | 13
22 | 29
22 | 11
23 | 35
23 | 17
24 | 17
24 | 23
25 | 32
26 | 13
26 | 22
27 | 18
27 | 4
28 | 12
28 | 20
30 | 22
30 | 9
31 | 14
31 | 19
31 | 29
32 | 27
32 | 1
34 | 19
34 | 16
34 | 21
34 | 7
35 | 27
36 | 16
36 | 10
38 | 39
38 | 1
39 | 15
39 | 24
39 | 15
40 | 4
40 | 15
40 | 24