tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 747528d1631554557-formula-to-automatically-calculate-the-current-pto-accrual-by-paycheck-date-pto-for-year-to-last-pay-date-chocolista-
Sheet: Data

A1: Enter employee name
A2: Enter starting [NAME]
A3: Enter starting PTO hours, if any
A4: Enter hours gained per 2 weeks
A5: Enter PTO Used since the starting date
A6: =A3+TRUNC((TODAY()-A2)/14,0)*A4 - A5 (this is the total PTO remaining)
What this does: Calculate the number of days between TODAY and the "start date". Divide by 14 and round down to get the number of 2-week periods that have occurred. Multiply by the # hours they earn every 2 weeks. Add to whatever they started with, and subtract what they've used.
You might consider keeping an individual log for each employee with the date and hours used. Just recording a number (i.e. "40 hours used") can get messy if an employee challenges you on its the accuracy. Cell A5 would then just be a SUM of the hours in this log.
2016-04-30 00:00:00 | 2016-05-01 00:00:00
2017-04-30 00:00:00 | 2017-05-01 00:00:00
2018-04-30 00:00:00 | 2018-05-01 00:00:00
2019-04-30 00:00:00 | 2019-05-01 00:00:00
2020-04-30 00:00:00 | 2020-05-01 00:00:00
2021-04-30 00:00:00 | 2021-05-01 00:00:00
Specific Date
Employee | Accrual Level Start Date | Days | Years | PTO
Adams, [NAME] | 2021-07-12 00:00:00
Barnes, [NAME] | 2021-08-02 00:00:00
Jones, Greg | 2021-01-01 00:00:00
[NAME], [NAME] | 2021-01-01 00:00:00
[NAME], [NAME] | 2021-01-20 00:00:00
Spreadsheet: 837478d1690201276-formula-needed-for-income-tax-calculation-spreadsheet-as-per-the-attachment-it-calculation-formula
Sheet: Sheet1

EXAMPLE |  | FORMULA NEEDED AS PER BELOW CRITERIA
VALUE | RESULT
285475 | 0 | If "Value" is Less than 3,00,000, then "Result" should be 0
485765 |  | If "Value" is more than 3,00,000 but Less than 6,00,000, then "Result" should be (=15,000+(Value-3,00,000)*5%)
755675 |  | If "Value" is more than 6,00,000 but Less than 9,00,000, then "Result" should be (=45,000+(Value-6,00,000)*10%)
1152850 |  | If "Value" is more than 9,00,000 but Less than 12,00,000, then "Result" should be (=90,000+(Value-9,00,000)*15%)
1350600 |  | If "Value" is more than 12,00,000 but Less than 15,00,000, then "Result" should be (=1,50,000+(Value-12,0,0000)*20%)
1750500 |  | If "Value" is more than 15,00,000, then "Result" should be (=1,50,000+(Value-15,00,000)*30%)
 |  | * So, if the "Value" is input as any number between 0-1500001, then the result should be based on the above required Criteria
Spreadsheet: 290763d1389969977-items-out-of-sequence-sequence-compliance
Sheet: Sheet2

 | These items cover 1 order
 | [NAME] | [NAME] |  | Manually Identified Errors | Comments
 | 1 | 1 |  |  | Orders should be picked in ascending order, not necessarily sequentially. (e.g. 1,2,5,6 is fine)
 | 3 | 1 |  |  | Product types ([NAME]) should be grouped (i.e. all 1s together, all 2s together etc.)
 | 5 | 1
 | 6 | 1 |  |  | This order has a non-compliance rate of
 | 2 | 2 |  | x
 | 4 | 2 |  | x
 | 7 | 2
 | 8 | 2
 | 9 | 4
 | 10 | 4
 | 11 | 4
 | 59 | 4 |  | x
 | 12 | 5
 | 15 | 5
 | 16 | 5
 | 17 | 5
 | 18 | 5
 | 19 | 5
 | 20 | 5
 | 21 | 5
 | 22 | 5
 | 23 | 5
 | 24 | 5
 | 25 | 5
 | 27 | 5
 | 28 | 5
 | 29 | 5
 | 30 | 5
 | 31 | 5
 | 32 | 5
 | 33 | 5
 | 34 | 5
 | 36 | 5
 | 38 | 5
 | 39 | 5
 | 40 | 5
 | 41 | 5
 | 42 | 5
 | 43 | 5
 | 44 | 5
 | 45 | 5
 | 46 | 5
 | 47 | 5
 | 48 | 5
 | 50 | 5
 | 51 | 5
 | 52 | 5
 | 53 | 5
 | 54 | 5
 | 55 | 5
 | 56 | 5
 | 57 | 5
 | 60 | 5
 | 62 | 5
 | 63 | 5
 | 64 | 5
 | 65 | 5
 | 66 | 5
 | 13 | 14 |  | x
 | 14 | 15 |  | x
 | 35 | 15 |  | x
 | 49 | 15 |  | x
 | 26 | 16 |  | x
 | 37 | 16 |  | x
 | 58 | 16 |  | x
 | 61 | 16 |  | x
Spreadsheet: 456141d1460655152-duplicate-result-duplicate-score
Sheet: Sheet1

 | Game 1 | Game 2 | Game 3 | Game 4 | Game 5 | Game 6
PLAYER 1 | 215 | 212 | 178 | 131 | 156 | 150
PLAYER 2 | 166 | 158 | 166 | 168 | 154 | 163
USER 1 | 144 | 169 | 162 | 191 | 171 | 170
USER 2 | 171 | 170 | 215 | 212 | 135 | 170
PLAYER 3 | 148 | 209 | 161 | 173 | 168 | 183
PLAYER 4 | 198 | 150 | 188 | 200 | 174 | 168
USER 3 | 180 | 149 | 167 | 195 | 215 | 192
USER 4 | 163 | 170 | 181 | 137 | 148 | 160
MIX DOUBLE BOWLING RESULT
HIGHEST PINFALL
PLAYER NAMES_________
PLAYER NAMES_________
PLAYER NAMES_________
Spreadsheet: 154430d1336422065-link-cells-to-a-different-workbook-file-question-mergebooks
Sheet: Sheet1

Path | [NAME] |  |  |  |  |  |  | [NAME]
 | [[NAME]! |  |  |  |  |  |  | [[NAME]!
Date | Description | Qty. Used | Total Time | [NAME] | [NAME]/m sqft | Charged Rate |  | [[NAME]!
 |  |  |  |  |  |  |  | [[NAME]!
 |  |  |  |  |  |  |  | [[NAME]!
 |  |  |  |  |  |  |  | [[NAME]!
 |  |  |  |  |  |  |  | [Lookup File7.xlsx]Sheet1'!
 |  |  |  |  |  |  |  | [[NAME]!
Spreadsheet: louise_kitchen__22823__SSMB Benefit Estimates For NETCO
Sheet: Adjusted Maximum Est.

Below is the overall # of EEs by $ [NAME] and the avg salary in that range for Netco EEs.
[NAME] (USD) | # of EEs in $ [NAME] | [NAME] in $ [NAME] | Total | Employee Only Adjusted Rate |  | SSMB Adjusted Range Dollars | Difference To Make Whole
< $25,000 |  | 22033
$25,000 - $39,999 |  | 33318
$40,000 - $59,999 |  | 48312
$60,000 - $79,999 |  | 69487
$80,000 - $99,999 |  | 87026
$100,000 - $149,999 |  | 117576
$150,000 - $199,999 |  | 163709
$200,000 - $299,999 | 0 | 213335
$300,000 - $499,999 | 0 | 352500
>$500,000 | 0 | 750000
Totals
[NAME] (USD) | # of EEs in $ [NAME] | [NAME] in $ [NAME] | Total | Employee Spouse Adjusted Rate |  | SSMB Adjusted Range Dollars | Difference To Make Whole
< $25,000 | 0 | 22033
$25,000 - $39,999 |  | 33318
$40,000 - $59,999 |  | 48312
$60,000 - $79,999 |  | 69487
$80,000 - $99,999 |  | 87026
$100,000 - $149,999 |  | 117576
$150,000 - $199,999 |  | 163709
$200,000 - $299,999 | 0 | 213335
$300,000 - $499,999 | 0 | 352500
>$500,000 | 0 | 750000
Totals
[NAME] (USD) | # of EEs in $ [NAME] | [NAME] in $ [NAME] | Total | Employee & Children Adjusted Rate |  | SSMB Adjusted Range Dollars | Difference To Make Whole
< $25,000 | 0 | 22033
$25,000 - $39,999 |  | 33318
$40,000 - $59,999 |  | 48312
$60,000 - $79,999 |  | 69487
$80,000 - $99,999 |  | 87026
$100,000 - $149,999 |  | 117576
$150,000 - $199,999 |  | 163709
$200,000 - $299,999 |  | 213335
$300,000 - $499,999 | 0 | 352500
>$500,000 | 0 | 750000
Totals
[NAME] (USD) | # of EEs in $ [NAME] | [NAME] in $ [NAME] | Total | Employee & Family Adjusted Rate |  | SSMB Adjusted Range Dollars | Difference To Make Whole
< $25,000 |  | 22033
$25,000 - $39,999 |  | 33318
$40,000 - $59,999 |  | 48312
$60,000 - $79,999 |  | 69487
$80,000 - $99,999 |  | 87026
$100,000 - $149,999 |  | 117576
$150,000 - $199,999 |  | 163709
$200,000 - $299,999 |  | 213335
$300,000 - $499,999 |  | 352500
>$500,000 |  | 750000
Totals
Grand Total US
Average
< $25,000
$25,000 - $39,999
$40,000 - $59,999
$60,000 - $79,999
$80,000 - $99,999
$100,000 - $149,999
$150,000 - $199,999
$200,000 - $299,999
$300,000 - $499,999
>$500,000
Spreadsheet: 270966d1381768695-advanced-lookup-to-count-cells-in-a-column-that-meet-criteria-diagnostics-tracking
Sheet: Report 1

Project Number | Site ID | Projected Date | Actual Date |  | Study | # Flagged Sites
114 | 1 | 2012-11-28 00:00:00 | 2012-10-23 10:23:57 |  |  | Insert formula that counts the number of occurrences that the conditional formatting formula is met
114 | 2 | 2012-12-04 00:00:00 | 2012-11-05 15:52:30 |  |  | 3
118 | 3 |  | 2012-10-23 10:31:10 |  |  | 2
118 | 4 |  | 2012-11-05 15:39:23 |  |  | 2
118 | 5 |  | 2012-10-24 15:38:21 |  |  | 1
115 | 6 |  | 2012-11-07 10:32:01
116 | 7
116 | 8 |  | 2012-11-05 16:03:14
116 | 9 |  | 2012-10-24 16:05:36
117 | 10 |  | 2012-11-07 10:32:26
115 | 11 |  | 2012-11-05 15:46:32
Spreadsheet: 843598d1695383144-formula-to-calculate-positive-and-negative-cells-book-1
Sheet: Sheet1

 |  |  | Jan | Feb | Mar | Apr | May | Total
 | [NAME] | A | 1 | 1 | -3 |  | 2
 |  | B | -2 | -2 | 2 | 3 | 1
 |  | C | 1 |  |  | -2 | 1
 |  | D | 4 | -1 | -14 | 10 | 3
 | Derek | A | 2 | 2 | 2 | 2 | 2
 |  | B | -1 |  | 3 | -1 | -1
 |  | C | 1 | 1 | 2 | 2 | 3
 |  | D | 4 | -2 | 8 | -3 | -4
 | [NAME] | A | 1 | 3 | 3 | -4 | -2
 |  | B | 2 | 2 | -2 | 1 | 2
 |  | C | -6 | -6 | 3 | 4 | 3
 |  | D | 1 | 2 | 3 | -2 | -1
 | [NAME]? |  |  |  |  |  |  |  |  | Expected Result
 | Positive | A |  |  |  |  |  |  |  | Positive | A
 |  | B |  |  |  |  |  |  |  |  | B
 |  | C |  |  |  |  |  |  |  |  | C
 |  | D |  |  |  |  |  |  |  |  | D
 | Negative | A |  |  |  |  |  |  |  | Negative | A | 0 | 0
 |  | B |  |  |  |  |  |  |  |  | B
 |  | C |  |  |  |  |  |  |  |  | C |  |  | 0 |  | 0
 |  | D |  |  |  |  |  |  |  |  | D | 0
Spreadsheet: 781479d1653368429-index-match-formula-with-nested-error-test-that-has-an-error-that-is-unsolvable-forum-test-2021-22-accounts
Sheet: Macquarie Bank -  Personal

 |  | Tax Year Ending : |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | Opening Balance : | 44451.16999999999 | Change this amount each year!!! |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | Personal Income : |  |  |  |  |  |  |  |  |  |  | 5
 |  | Personal Expenses : |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  | Business Income : |  |  |  |  |  |  |  |  |  |  | 8
 |  | Business Expenses : |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | Net Position (Personal + Business) : |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  | Available Line Count = |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  | First Summary Cell = | E524 | Use Find Command and enter this value |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  | 17
Account Source | Account Source Unique Number | Bank Statement Order Number | Date | Description | Category | Account Number | Account Group Number | Memo | Debit/Withdrawals | Credits/Deposits | Balance |  | 18
Macquarie Bank - Personal |  |  |  | Opening Balance | Opening Balance Equity | 1026 |  |  |  |  |  |  | 19
Macquarie Bank - Personal |  | 1 |  |  |  |  |  |  |  |  |  |  | 20
Macquarie Bank - Personal |  | 1 |  |  |  |  |  |  |  |  |  |  | 21
Spreadsheet: 871496d1717930400-modifying-table-to-be-more-dynamic-book3-1-
Sheet: lepingud

Number | Name | [NAME] | Üürilepingu kood | Code | Kinnistu aadress | Kinnistu piirkond | Client | Start year | End year | Kap.komp | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | 2042 | 2043 | 2044
5 | Name5 |  |  | SEEMNE200 |  |  | Client1 | 2018-01-01 00:00:00 | 2029-10-31 00:00:00
6 | Name6 |  |  | PURAVIKU4 |  |  | Client2 | 2020-01-01 00:00:00 | 2024-10-31 00:00:00
0.05
192 | Months
Spreadsheet: 600556d1543843542-need-multiple-cell-value-in-single-cell-based-on-unique-material-id-example
Sheet: Required Data Format

Material # | PO & Order QTY
49
50 |  | Data required this way
51
52
53
54
55
56
59
60
63
64
65
66
68
69
70
Spreadsheet: 706388d1606673463-sort-a-column-by-last-name-test-project-ans
Sheet: Email Invites

No Response From  -  71 | Alphabetical
[NAME] |  | duplicate
[NAME]
[NAME] |  | duplicate
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Mai-Lynn Freeman
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Archie Naranjo
[NAME]
Page Parkinson
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Todd Donato
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 119093d1314195815-random-number-generation-with-an-average-tigeravatar-example-for-ejp520
Sheet: Sheet1

Random Number Generator
Lower Bound | 1500 |  | 1888
[NAME] | 1900 |  | 1899
How many | 100 |  | 1756
Must Average | 1700 |  | 1707
 |  |  | 1805
Invalid set.  [NAME] for new set |  |  | 1844
 |  |  | 1832
 |  |  | 1624
 |  |  | 1868
 |  |  | 1546
 |  |  | 1579
 |  |  | 1725
 |  |  | 1565
 |  |  | 1781
 |  |  | 1668
 |  |  | 1684
 |  |  | 1707
 |  |  | 1742
 |  |  | 1565
 |  |  | 1539
 |  |  | 1767
 |  |  | 1831
 |  |  | 1739
 |  |  | 1849
 |  |  | 1725
 |  |  | 1672
 |  |  | 1579
 |  |  | 1882
 |  |  | 1897
 |  |  | 1703
 |  |  | 1576
 |  |  | 1677
 |  |  | 1678
 |  |  | 1863
 |  |  | 1745
 |  |  | 1554
 |  |  | 1883
 |  |  | 1840
 |  |  | 1687
 |  |  | 1712
 |  |  | 1833
 |  |  | 1870
 |  |  | 1524
 |  |  | 1670
 |  |  | 1572
 |  |  | 1658
 |  |  | 1762
 |  |  | 1838
 |  |  | 1807
 |  |  | 1502
 |  |  | 1666
 |  |  | 1686
 |  |  | 1608
 |  |  | 1639
 |  |  | 1829
 |  |  | 1567
 |  |  | 1801
 |  |  | 1592
 |  |  | 1678
 |  |  | 1609
 |  |  | 1732
 |  |  | 1625
 |  |  | 1829
 |  |  | 1611
 |  |  | 1751
 |  |  | 1698
 |  |  | 1760
 |  |  | 1860
 |  |  | 1830
 |  |  | 1543
 |  |  | 1814
 |  |  | 1763
 |  |  | 1856
 |  |  | 1762
 |  |  | 1855
 |  |  | 1577
 |  |  | 1580
 |  |  | 1510
 |  |  | 1638
 |  |  | 1504
 |  |  | 1827
 |  |  | 1544
 |  |  | 1793
 |  |  | 1573
 |  |  | 1834
 |  |  | 1542
 |  |  | 1598
 |  |  | 1697
 |  |  | 1640
 |  |  | 1550
 |  |  | 1654
 |  |  | 1768
 |  |  | 1601
 |  |  | 1701
 |  |  | 1691
 |  |  | 1590
 |  |  | 1764
 |  |  | 1570
 |  |  | 1639
 |  |  | 1432
Spreadsheet: 13884c16-a548-48a1-9da5-8dc7345a2d05
Sheet: Sheet1

Offense Category | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
by Gang Involvement, 2011
[NAME] | Total Offenses2 | Offense Category1
 |  | Assault Offenses | Homicide Offenses | Kidnapping/ Abduction | [NAME], Forcible | Robbery
Total | 1386742 | 1226300 | 3633 | 15310 | 69356 | 72143
[NAME] | 1500 | 1310 | 4 | 6 | 36 | 144
Other Gang | 2797 | 2374 | 29 | 64 | 57 | 273
None/Unknown | 641033 | 561284 | 1960 | 6738 | 33615 | 37436
1Gang Involvement is collected for only 11 NIBRS offense types.  See Methodology for more information.
2Gang Involvement will not add to Total Offenses because this data element is not mandatory and is not reported by all law enforcement agencies.
Spreadsheet: 682204d1591963917-cell-value-dependent-on-tablename-within-a-cell-shift-pattern-calculator
Sheet: Standard Patterns

Pattern1
Week Number | Monday Start | Monday Finish | Tuesday Start | Tuesday Finish | Wednesday Start | Wednesday Finish | Thursday Start | Thursday Finish | Friday Start | Friday Finish | Saturday Start | Saturday Finish | Sunday Start | Sunday Finish
1 | 12:00:00 | 20:00:00 | 08:00:00 | 16:00:00 | 08:00:00 | 16:00:00 | 07:00:00 | 15:00:00 | 08:00:00 | 16:00:00 | RD | RD | RD | RD
2 | 07:00:00 | 15:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 16:00:00 | 08:00:00 | 16:00:00 | 08:00:00 | 16:00:00 | RD | RD | RD | RD
3 | 08:00:00 | 16:00:00 | 07:00:00 | 15:00:00 | 08:00:00 | 16:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 16:00:00 | RD | RD | RD | RD
4 | 08:00:00 | 16:00:00 | 08:00:00 | 16:00:00 | 07:00:00 | 15:00:00 | 08:00:00 | 16:00:00 | 12:00:00 | 20:00:00 | 08:00:00 | 16:00:00 | 08:00:00 | 16:00:00
5 | RD | RD | RD | RD | 12:00:00 | 20:00:00 | 08:00:00 | 16:00:00 | 07:00:00 | 15:00:00 | RD | RD | RD | RD
pattern2
Week Number | Monday Start | Monday Finish | Tuesday Start | Tuesday Finish | Wednesday Start | Wednesday Finish | Thursday Start | Thursday Finish | Friday Start | Friday Finish | Saturday Start | Saturday Finish | Sunday Start | Sunday Finish
1 | RD | RD | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | RD | RD | RD | RD
2 | 07:00:00 | 17:00:00 | RD | RD | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | RD | RD | RD | RD
3 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | RD | RD | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | RD | RD | RD | RD
4 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | RD | RD | 07:00:00 | 17:00:00 | RD | RD | RD | RD
5 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | 07:00:00 | 17:00:00 | RD | RD | RD | RD | RD | RD
Spreadsheet: 221681d1363638121-sumif-with-horizontal-sum-range-sumproducttest
Sheet: Sheet1

 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | TOTAL
A | 77111.34933737968 | 49131.78821280086 | 39501.17260133398 | 8241.93415010036 | 97486.34900449398 | 12126.09361900494 | 43740.80090783494 | 61135.87054977697 | 880.8203588510866 | 67669.29758048861 | 89390.24101083059 | 48429.56510082069
B | 16684.01175719415 | 12374.2622359449 | 41734.61028670498 | 58792.50042135702 | 5213.884315680506 | 9667.959589827035 | 80970.69980275362 | 56373.9152527625 | 83354.60691900532 | 58719.86167260833 | 95534.29969323888 | 54071.74514385609
C | 61048.95632105106 | 39342.39374972591 | 47570.74681909569 | 87661.3693970292 | 83357.07358208291 | 54258.98504988506 | 72720.81589077876 | 90744.00038975549 | 1152.287784955108 | 50131.24952779921 | 35945.15328272196 | 86182.74570445727
D | 40703.9246409484 | 55823.03402750074 | 74721.40984555635 | 66601.42683291093 | 99905.66152691779 | 27788.82628407736 | 82613.92820380881 | 65098.78759318314 | 61674.58163786215 | 40108.14547806195 | 56038.8472319654 | 10618.9579100156
E | 22725.96174590069 | 7757.900217592595 | 2704.628084594563 | 56655.10271792328 | 94641.05037081597 | 58429.71673429751 | 15497.00189897938 | 84562.64958325699 | 53900.24778050694 | 70989.4288159148 | 87004.72893951091 | 84132.2610621436
F | 66592.49453951778 | 13088.6395843096 | 64016.74076259926 | 65188.83377581257 | 17775.49712614541 | 22488.50450557651 | 74342.82933944066 | 72853.50147669746 | 4269.96642400086 | 82645.70926234216 | 40260.90750419212 | 81994.8427156979
G | 10650.86806156503 | 51398.00065384055 | 80869.50072191475 | 45196.17750628716 | 33112.05981271648 | 66874.49645107017 | 19152.2254581445 | 20659.45689850244 | 27621.6717998789 | 27008.83636435285 | 93910.5295812661 | 86304.94594715886
 | 6 | <-- ALL VALUES WITH HEADER LESS THAN OR EQUAL TO THIS
D |  | =SUMPRODUCT(--(A2:A8=A11),--(B1:M1<=B10),B2:M8)
^-- THIS ROW
Spreadsheet: 465866d1465920719-aligning-half-rowws-of-data-with-common-cell-bank-statement-vrs-cashbook1
Sheet: Sheet1

1 | 2016-03-02 00:00:00 | PARTIAL SF REDISCOUNT | 4000 |  | 1 | 2016-03-01 00:00:00 | [NAME] | 4000
2 | 2016-03-15 00:00:00 | SF REDEMPTION IFO AUGUSTINE KINGSFORD AIDOO | 4000 |  | 2 | 2016-03-14 00:00:00 | [NAME] | 4000
 |  |  |  |  | 3 | 2016-03-29 00:00:00 | Evans  Agyenim Boateng | 4000
3 | 2016-03-31 00:00:00 | PAYMENT FOR SF | 4000 |  | 4 | 2016-03-30 00:00:00 | [NAME] | 4000
 |  |  |  |  | 5 | 2015-11-30 00:00:00 | [NAME] Dwaah [NAME]  Beatrice Boakye | 4015.72
 |  |  |  |  | 6 | 2016-02-23 00:00:00 | UPPER AMENFI RURAL BANK LTD	JOHN [NAME] KUBI | 4019.4
 |  |  |  |  | 7 | 2016-02-22 00:00:00 | [NAME] | 4029.18
 |  |  |  |  | 8 | 2016-02-26 00:00:00 | [NAME] | 4065.39
 |  |  |  |  | 9 | 2016-03-11 00:00:00 | [NAME] | 4167.83
4 | 2016-02-03 00:00:00 | DEAFT ISSUED TO GLOBAL EVANGELICAL CO-OP CRED | 4178.49 |  | 10 | 2016-02-02 00:00:00 | Global Evangelical Coop Credit Union-Amakom | 4178.49
 |  |  |  |  | 11 | 2015-12-02 00:00:00 | Osei  Anane Adutwum | 4183.4
5 | 2016-03-24 00:00:00 | CASH DEPOSIT BY SUSSANA ADUMATIA | 4192.38 |  | 12 | 2016-03-24 00:00:00 | Sussana  Adumatta | 4192.39
Spreadsheet: 849926d1700289503-consolidate-table-with-array-formulas-testconsolidatetableefnov23
Sheet: Sheet1

 |  | Project Month | Ref Number | Commodity | Value |  | Project Month | Ref Number | Commodity | Value |  |  | Ref Number | Commodity | Value
 |  | 1 | 100552 | Beans | 5000 |  |  | 100552 | Beans |  |  | 1 | 100552 | Beans | 5000
 |  | 1 | 100589 | Corn | 12000 |  | 1 | 100589 | Corn | 12000 |  | 1 | 100589 | Corn | 12000
 |  | 1 | 110170 | Emergncy Fd | 380 |  | 1 | 110170 | Emergncy Fd | 380 |  | 1 | 110170 | Emergncy Fd | 380
 |  | 1 | 100566 | Oil | 40 |  | 1 | 100566 | Oil | 40 |  | 1 | 100566 | Oil | 40
 |  | 2 | 100552 | Beans | 940 |  | 2 | 100552 | Beans | 1460 |  | 2 | 100552 | Beans | 1460
 |  | 2 | 100605 | Bulgur | 2000 |  | 2 | 100605 | Bulgur | 2000 |  | 2 | 100605 | Bulgur | 2000
 |  | 2 | 110472 | Corn-Soy Blend | 90 |  | 2 | 110472 | Corn-Soy Blend | 90 |  | 2 | 110472 | Corn-Soy Blend | 90
 |  | 2 | 110452 | Emergency Fd | 90 |  | 2 | 110452 | Emergency Fd | 90 |  | 2 | 110452 | Emergency Fd | 90
 |  | 2 | 100552 | Beans | 520 |  | 2 | 100566 | Oil | 150 |  | 2 | 100566 | Oil | 150
 |  | 2 | 100566 | Oil | 150 |  | 3 | 100553 | Beans | 850 |  | 3 | 100553 | Beans | 850
 |  | 3 | 100553 | Beans | 850 |  | 3 | 100576 | Corn | 2000 |  | 3 | 100576 | Corn | 2000
 |  | 3 | 100576 | Corn | 2000 |  | 3 | 110170 | Emergncy Fd | 120 |  | 3 | 110170 | Emergncy Fd | 120
 |  | 3 | 110170 | Emergncy Fd | 120 |  | 3 | 100566 | Oil | 400 |  | 3 | 100566 | Oil | 400
 |  | 3 | 100566 | Oil | 400 |  | 4 | 100552 | Beans | 1200 |  | 4 | 100552 | Beans | 1200
 |  | 4 | 100552 | Beans | 1200 |  | 4 | 100589 | Corn | 250 |  | 4 | 100589 | Corn | 250
 |  | 4 | 100589 | Corn | 250 |  | 4 | 110170 | Emergncy Fd | 380 |  | 4 | 110170 | Emergncy Fd | 380
 |  | 4 | 110170 | Emergncy Fd | 380 |  | 4 | 110472 | Corn-Soy Blend | 20 |  | 4 | 110472 | Corn-Soy Blend | 20
 |  | 4 | 110472 | Corn-Soy Blend | 20 |  | 4 | 100566 | Oil | 630 |  | 4 | 100566 | Oil | 630
 |  | 4 | 100566 | Oil | 40 |  | 5 | 100552 | Beans | 900 |  | 5 | 100552 | Beans | 900
 |  | 4 | 100566 | Oil | 590 |  | 5 | 100589 | Corn | 40 |  | 5 | 100589 | Corn | 40
 |  | 5 | 100552 | Beans | 900 |  | 5 | 110170 | Emergncy Fd | 500 |  | 5 | 110170 | Emergncy Fd | 500
 |  | 5 | 100589 | Corn | 40 |  | 5 | 110472 | Corn-Soy Blend | 750 |  | 5 | 110472 | Corn-Soy Blend | 750
 |  | 5 | 110170 | Emergncy Fd | 500 |  | 5 | 100566 | Oil | 1200 |  | 5 | 100566 | Oil | 1200
 |  | 5 | 110472 | Corn-Soy Blend | 750
 |  | 5 | 100566 | Oil | 1000
 |  | 5 | 100566 | Oil | 200
Spreadsheet: john_griffith__15828__10_24_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21.5 | 225 | 237 | 54.8 | 57.7 | 0.76 | 2001-10-24 10:01:00
 | CL F2 | 22 | 335 | 350 | 51.4 | 53.7 | 0.73 | 2001-10-24 10:01:00
 | CL G2 | 22 | 417 | 436 | 50.1 | 52.4 | 0.71 | 2001-10-24 10:01:00
 | CL H2 | 22 | 460 | 475 | 47.8 | 49.4 | 0.67 | 2001-10-24 10:01:00
 | CL J2 | 22 | 490 | 510 | 45.6 | 47.5 | 0.64 | 2001-10-24 10:01:00
 | CL K2 | 22 | 515 | 530 | 43.4 | 44.6 | 0.61 | 2001-10-24 10:01:00
 | CL M2 | 22 | 525 | 540 | 41.1 | 42.3 | 0.58 | 2001-10-24 10:01:00
 | CL N2 | 22 | 535 | 555 | 39.1 | 40.6 | 0.55 | 2001-10-24 10:01:00
 | CL Q2 | 22 | 545 | 560 | 37.6 | 38.7 | 0.53 | 2001-10-24 10:01:00
 | CL U2 | 22 | 550 | 565 | 36.3 | 37.3 | 0.51 | 2001-10-24 10:01:00
 | [NAME] | 22 | 550 | 565 | 34.5 | 35.5 | 0.48 | 2001-10-24 10:01:00
 | CL X2 | 22 | 552 | 567 | 33.3 | 34.2 | 0.47 | 2001-10-24 10:01:00
 | [NAME] | 21.5 | 555 | 575 | 33.1 | 34.3 | 0.46 | 2001-10-24 10:01:00
 | CL M3 | 21.5 | 550 | 570 | 27.8 | 28.9 | 0.38 | 2001-10-24 10:01:00
 | CL Z3 | 21.5 | 550 | 570 | 24.8 | 25.7 | 0.34 | 2001-10-24 10:01:00
Spreadsheet: 1041d9e8-6a63-4dc0-8765-95bbbf273237
Sheet: Sheet1

Unnamed: 0 | CONTRA COSTA COUNTY PUBLIC WORKS | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | REQUEST FOR CONSTRUCTION STAKING |  |  |  |  |  |  |  |  | PAGE ___ OF ___
PROJECT |  |  |  |  |  |  |  |  | REQUEST NO.
 | TYPE OF | STAKES ARE |  | [NAME] |  |  |  |  |  | DATE (mm/dd/yy)
PRIORITY* | STAKING | ORIG. | RESET | LINE, STATION TO STATION, LANE, SIDE, ETC. |  |  |  |  |  | AREA WILL BE READY FOR STAKES | STAKES WILL BE USED
*If no priority number is given, staking will be done in order listed and/or received.
COMMENTS
REQUESTED BY (Contractor's Rep) |  |  |  |  |  | DATE | APPROVED BY (Resident Engineer) |  |  | DATE | TIME