tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 104770d1302224896-question-about-linking-formulas-from-one-page-to-another-new-accts-payable-2011
Sheet: Sep

september expenses
total
advertising
date | po# | suppplier.description | amount
subtotal
x
educational
date | po# | suppplier.description | amount
subtotal
x
supplies. blanks
date | po# | suppplier.description | amount
subtotal
x
supplies. designs
date | po# | suppplier.description | amount
subtotal
s
supplies. notions
date | po# | suppplier.description | amount
subtotal
supplies. machinery
date | po# | suppplier.description | amount
subtotal
supplies. office
date | po# | suppplier.description | amount
subtotal
etsy maintenance
date | po# | suppplier.description | amount
subtotal
website maintenance
date | po# | suppplier.description | amount
subtotal
shipping
date | po# | suppplier.description | amount
subtotal
utilities
date | po# | suppplier.description | amount
subtotal
Spreadsheet: 762970d1641920640-sum-of-values-across-multiple-sheets-morayman-sum-of-vls-mltpl-sheets
Sheet: MAR

2022-02-28 00:00:00 |  |  | 2500
2022-02-28 00:00:00 |  |  | 54.01600000000001
2022-02-28 00:00:00 |  |  | 1750
2022-03-01 00:00:00 |  |  | 3500
2022-03-01 00:00:00 |  |  | 932.45
2022-03-01 00:00:00 |  |  | 1284
2022-03-01 00:00:00 |  |  | 750
2022-03-01 00:00:00 |  |  | 20
2022-03-01 00:00:00 |  |  | 1250
2022-03-01 00:00:00 |  |  | 350
2022-03-01 00:00:00 |  |  | 550
2022-03-02 00:00:00 |  |  | 4.037696
2022-03-04 00:00:00 |  |  | 150
2022-03-04 00:00:00 |  |  | 11
2022-03-06 00:00:00 |  |  | 2278.62
2022-03-06 00:00:00 |  |  | 2323
2022-03-07 00:00:00 |  |  | 2030
2022-03-07 00:00:00 |  |  | 2523
2022-03-07 00:00:00 |  |  | 1750
2022-03-08 00:00:00 |  |  | 80
2022-03-08 00:00:00 |  |  | 80
2022-03-10 00:00:00 |  |  | 7
2022-03-10 00:00:00 |  |  | 2651
2022-03-13 00:00:00 |  |  | 16.98
2022-03-13 00:00:00 |  |  | 3885.5
2022-03-14 00:00:00 |  |  | 1750
2022-03-15 00:00:00 |  |  | 16
2022-03-16 00:00:00 |  |  | 300
2022-03-18 00:00:00 |  |  | 155.85
2022-03-21 00:00:00 |  |  | 2030
2022-03-21 00:00:00 |  |  | 2523
2022-03-21 00:00:00 |  |  | 1750
Spreadsheet: 1b9e9f51-63b9-4227-adc9-ea6db8263da6
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
SHBG | Test | SHBG | [NAME] (SHBG), Serum | [NAME], S | Automated Chemiluminescent Immunometric Assay | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | CHILDREN Males Tanner Stages*	Mean Age	Reference Range (nmol/L) Stage I	7.1	31-167 Stage II	11.5	49-179 Stage III	13.6	5.8-182 Stage IV	15.1	14-98 Stage V	18.0	10-57 *Puberty onset (transition from Tanner stage I to Tanner stage II) occurs for boys at a median age of 11.5 (+/-2) years. For boys, there is no definite proven relationship between puberty onset and body weight or ethnic origin. Progression through Tanner stages is variable. Tanner stage V (young adult) should be reached by age 18.  Females Tanner Stages*	Mean Age	Reference Range (nmol/L) Stage I	7.1	43-197 Stage II	10.5	7.7-119 Stage III	11.6	31-191 Stage IV	12.3	31-166 Stage V	14.5	18-144 *Puberty onset (transition from Tanner stage I to Tanner stage II) occurs for girls at a median age of 10.5 (+/-2) years. There is evidence that it may occur up to 1 year earlier in obese girls and in African American girls. Progression through Tanner stages is variable. Tanner stage V (young adult) should be reached by age 18.  ADULTS	 Males: 10-57 nmol/L Females (non-pregnant): 18-144 nmol/L | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 84270 |  |  |  |  | Rochester
SHBG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SHBG | Result | SHBG | [NAME], S | [NAME], S | Numeric |  |  |  |  | nmol/L |  |  |  |  |  |  |  |  |  | 13967-5
Spreadsheet: andy_zipper__511__11_27_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 53 | 100 | 200 | 69 | 115.1 | 3.01 | 2001-11-26 14:53:00
 | HO F2 | 54 | 700 | 790 | 57.8 | 65.3 | 2.09 | 2001-11-27 10:35:00
 | HO G2 | 54 | 1000 | 1100 | 56.8 | 62.5 | 2.03 | 2001-11-27 10:35:00
 | [NAME] | 53 | 1150 | 1240 | 55.5 | 59.8 | 1.92 | 2001-11-27 10:35:00
 | HO J2 | 53 | 1220 | 1320 | 51.6 | 55.8 | 1.79 | 2001-11-27 10:35:00
 | HO K2 | 52 | 1280 | 1380 | 49.3 | 53.2 | 1.68 | 2001-11-27 10:35:00
 | HO M2 | 53 | 1320 | 1420 | 45.3 | 48.8 | 1.57 | 2001-11-27 10:35:00
 | HO N2 | 54 | 1350 | 1450 | 42.5 | 45.7 | 1.5 | 2001-11-27 10:35:00
 | HO Q2 | 55 | 1370 | 1490 | 39.7 | 43.2 | 1.43 | 2001-11-27 10:35:00
 | HO U2 | 56 | 1440 | 1540 | 38.7 | 41.4 | 1.41 | 2001-11-27 10:35:00
 | [NAME] |  |  |  | 38.4 | 42.2 | 1.42 | 2001-11-15 14:53:00
 | HO X2 |  |  |  | 37.9 | 40.3 | 1.38 | 2001-11-15 14:53:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: 690415d1597089228-ifs-formula-book1
Sheet: Sheet1

Symbol | Budget | EAC | Total
 | 2000 | 1560 | 1232
 | 198 | 0 | 13
 | 1330 | 1364 | 922
 | 1144 | 1144 | 411
 | 3665 | 4662 | 3688
 | 485 | 485 | 43
Spreadsheet: 293286d1390936416-cannot-format-cells-into-currency-1-1-2014-copy
Sheet: WSP-Summary

WATERSHED PROTECTION
 |  | WATERSHED WIDE |  |  | SUB-WATERSHEDS |  |  | CONSTITUENCY BUILDING |  |  | TRANSITION |  |  | TOTAL
 |  | 2013 | 2014 | 2015 | 2013 | 2014 | 2015 | 2013 | 2014 | 2015 | 2013 | 2014 | 2015 | 2013 | 2014 | 2015
ACTUAL | BUDGET | 5700000 | 5700000 | 5700000 | 7500000 | 7500000 | 7500000 | 5526974 | 5500000 | 5500000 | 500000 | 500000 | 500000
 | Prior Year Commitments | 203500 | 176000 | 0 | 0 | 0 | 0 | 495000 | 180000 | 0 | 0 | 0 | 0
 | Available
 | % Remaining
 | Current Year Commitments | 3062000 | 800000 | 0 | 1844000 | 192500 | 0 | 3519000 | 2420250 | 0 | 0 | 0 | 0
 | Total Commitments
 | Available
 | % Remaining
PIPELINE | Pending Final Approval
 | Total Commitments and Pending Final Approval
 | Available
 | % Remaining
 | In Process
 | Total Commitments, Pending, In Process
 | Available
 | % Remaining
 | Note: Budgets for 2014 and 2015 are assumed.
 | In Process = Staff Development, LOI, Invited Inquiries
Spreadsheet: 816731d1675795408-how-to-use-lookup-get-multiple-results-and-add-the-results-to-a-single-cell-textjoin-pd-sample
Sheet: Shift

PSID | Rcd | Name | Earn ID | PP | Fund | Dept | S/C | Acct | Hours | Rate | Amount Due
 |  | BARBA, V | SHGRV | 2023-01-01 00:00:00 | 47205 | 43426 | 0 | 601935 | 176
 |  | BEST, R | SHSWG | 2023-01-01 00:00:00 | 90000 | 43425 | 0 | 601935 | 6
 |  | BEST, R | SHGRV | 2023-01-01 00:00:00 | 90000 | 43425 | 0 | 601935 | 190
 |  | CALDERA, M | SHSWG | 2023-01-01 00:00:00 | 90000 | 43425 | 0 | 601935 | 4
Spreadsheet: 808779d1670647513-counting-rows-between-specific-events-book1-27-ans-2
Sheet: Sheet1

WHEEL 1 | WHEEL 2 | WHEEL 3 |  | Delay |  |  | DELAY | TIMES
B | G | R |  |  |  |  | 0 | 0
G | B | R |  |  |  |  | 1 | 2
B | B | B |  |  |  |  | 2 | 0
B | R | R |  |  |  |  | 3 | 0
R | B | G |  |  |  |  | 4 | 0
B | G | B |  |  |  |  | 5 | 0
B | S | R |  |  |  |  | 6 | 0
S | B | B |  |  |  |  | 7 | 0
S | B | R |  |  |  |  | 8 | 0
R | G | R |  |  |  |  | 9 | 0
R | G | G |  |  |  |  | 10 | 0
R | G | R |  |  |  |  | 11 | 0
G | R | R |  |  |  |  | 12 | 0
S | S | S |  |  |  | S | 13 | 0
B | G | R |  |  |  |  | 14 | 0
G | B | B |  |  |  |  | 15 | 0
B | R | G |  |  |  |  | 16 | 1
S | R | B |  |  |  |  | 17 | 0
R | R | B |  |  |  |  | 18 | 0
B | B | B |  |  |  |  | 19 | 0
R | R | B |  |  |  |  | 20 | 0
G | G | G |  |  |  |  | 21 | 0
B | G | G |  |  |  |  | 22 | 0
R | R | R |  |  |  |  | 23 | 0
B | G | R |  |  |  |  | 24 | 0
G | R | R |  |  |  |  | 25 | 0
S | R | R |  |  |  |  | 26 | 0
B | B | R |  |  |  |  | 27 | 0
R | G | G |  |  |  |  | 28 | 0
R | G | R |  |  |  |  | 29 | 0
G | R | G |  |  |  |  | 30 | 0
B | R | R
G | B | R
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 2Replace Costs-Results 16-20

Table 5.2.16.  Replacement Costs (Years 16 to 20)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 16 | 17 | 18 | 19 | 20
 |  |  | Total Present Value of Replacment Costs (Years 16 to 20):
 |  |  |  |  |  |  | Total Present Value of Replacement Costs (Life of Project):
Spreadsheet: 09f230b7-4a27-4e79-bbad-1309b705e9d0
Sheet: Sheet1

Guaranteed Rural Housing (GRH) Processing | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
State: | AL |  | Is your GRH loan origination: Centralized, Regionalized, Decentralized? | Centralized
 |  | State GRH Coordinator: | [NAME]
 |  | Address | Housing Section, Ala State Office
 |  |  | 4121 [NAME], Suite 601
 |  |  | Montgomery, AL 36106
 |  | Telephone #/Extension | [PHONE]
 |  | Fax # | [PHONE]
 |  | E-mail | [EMAIL]
 |  | GRH Processing Office: | Alabama GRH Processing Office
 |  | Point of Contact: | [NAME], Area Director
 |  | Address | USDA Rural Development, GRH
 |  |  | 819 Cook Ave NW, [NAME] 150
 |  |  | Huntsville, AL  35801
 |  | Telephone #/Extension | [PHONE] x4
 |  | Fax # | [PHONE]
 |  | E-mail | [EMAIL]
 |  | Counties served: | entire State of Alabama
Spreadsheet: 18cd0df1-ccd3-46fc-96f5-8a2f496a3552
Sheet: Sheet1

Date - 2011 | Location | Event | Complex | Contact for Information
March, 12 | Dothan, AL | Verizon Uniform Tournament | Westgate
March, 19 | Auburn, AL | Worth Tournament | Auburn - Exit 51
March, 26 | Enterprise, AL
April, 9 | Troy, AL
May, 7 | Dothan, AL | Iron Man | Westgate
May, 21 | Troy, AL
June, 4 | Enterprise, AL
June, 11 | Dothan, AL | Iron Man | Westgate
June, 25 | Troy, AL
Spreadsheet: 763597d1642263792-look-for-last-instance-of-a-phrase-and-return-column-header-dashboard-setup
Sheet: testing

 | Site A | 1-UX | 2-Design | 3-BRD | 4-TSD |  | Site B | 1-UX | 2-Design | 3-BRD | 4-TSD
 | Feature 2 | done | in progress |  |  |  | Feature 1 | done | done | in progress
 | Feature 3 | in progress |  |  |  |  | Feature 2 | done | done | done | inprogress
 | Feature 1 |  |  |  |  |  | Feature 3
 | master | Site A | Site B
 | Feature 1
 | Feature 2
 | Feature 3
 |  | index(header,aggregate(14,6,column(only specific headers that can be answered)/(index(range of options w/o features,match(feature name,feature list,0),)>0),1)), "Not Started Yet")
 |  | IFERROR(INDEX($5:$5,AGGREGATE(14,6,COLUMN($C$5:$F$5)/(INDEX($C$6:$F$8,MATCH(B14,$B$6:$B$8,0),)>0),1)),"Not started yet")
Spreadsheet: 82839d1282840066-data-collection-problems
Sheet: Sheet1

 | Departments
Expense Head | FF | GG | LL | ODM | RR | SS | GTM | US
Air Fares | 3487.1 | 553.3 |  | 565 | 355.29 | 150 | 465.1
Car Fuel | 22.42 |  |  | 672.67
Car Mileage | 372.7 | 139.21 | 2700.55 | 2638.2 |  | 1572.48 |  | 1285.54
Parking | 117.84 | 50.1 | 41.7 | 92.69 |  | 177.9 | 16
Entertainment | 780.68 |  | 37 | 1959.78 | 653.63 | 561.07 | 1060.62 | 10
Events |  | 5704.36
Hotels | 4197.72 | 580 | 3853.62 | 5356.9 | 478.76 | 1323.11 | 127 | 200
[NAME]. | -1508.59 | 795.51 | 208.08 | 220.43 | 47.02
Rail Fares | 837.25 | 521.8 | 844.3 | 1319 | 73.5 | 445.7 | 445.9 | 47.9
Tolls | 13.9 |  | 45 |  |  | 10
Staff Entertaining | 168.32 | 535.79 | 423.62 | 423.74 | 421.9 | 52.92 | 176.8499999999985
Staff [NAME] | 241.98 |  | 55.75 | 91.11 | 200 |  | 121.61
Party | 4504.64 | 756.96 | -2718.66 | 2534.8 | -23.7 | 1218.35 | 142.81 | -252.9
Taxi / Bus Fares / travel | 1198.25 | 13.5 | 1544.8 | 1017.36 | 211.99 | 204.1 | 590.83 | -40.6
Grand Total | 14434.21 | 9650.529999999999 | 7035.759999999999 | 16891.68 | 2418.39 | 5715.630000000001 | 3146.719999999998 | 1249.94
 | Result
 | Items | Amounts
 | SS | 1.6K Car Mileage, 1.3K Hotels, 1.2K Party,0.5 Entertainment
 | US | 1.3K Car Mileage, 0.2 Hotels, 0.04K Misc
 | FF | 3.5K Air Fares, 4.2K Hotels, 4.5K Party, 1.2K Taxi/Bus/Travel
 | ODM | 2.6K Car Mileage, 2K Entertainment,5.4K Hotels,,2.5K Party
 | GTM | 1.1K Entertainment, 0.6 Taxi/Bus/Travel, 0.5K Air Fares, 0.4K Rail Fares
Spreadsheet: 868452d1715183314-excel-pickup-wrong-data-formula-error
Sheet: MRP

Quantity in CTN |  |  |  |  |  |  |  |  |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual
Retail SKU | IB SKU | Description | vendor | vendor_name | Brand | Classification | Category | Type | Ctn/ Pallet | Category | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
A1 | K2 | Apple | 33 | XX | kitty | test | apply | A | 24 | New
Spreadsheet: 60705d1261224145-display-data-in-the-first-row-copy-of-sample-20data1-1-
Sheet: Main

S.No | CREDITOR | CREDITOR NAME | Transaction Date | PURCHASES | PAYMENTS
1 | CREDITOR 2 | CREDITOR FGH | 2009-02-12 00:00:00 | 1500 |  | 1
2 | CREDITOR 3 | CREDITOR JKL | 2009-03-12 00:00:00 |  | 2580 | 1
3 | CREDITOR 3 | CREDITOR JKL | 2009-03-12 00:00:00 | 125 |  | 2
4 | CREDITOR 1 | CREDITOR ABC |  | 1500 |  | 1
5 | CREDITOR 1 | CREDITOR ABC |  |  | 1250 | 2
6 | CREDITOR 3 | CREDITOR JKL | 2009-03-01 00:00:00 | 150 |  | 3
7 |  |  |  |  |  | 0
8 |  |  |  |  |  | 0
9 |  |  |  |  |  | 0
10 |  |  |  |  |  | 0
11 |  |  |  |  |  | 0
12 |  |  |  |  |  | 0
13 |  |  |  |  |  | 0
14 |  |  |  |  |  | 0
15 |  |  |  |  |  | 0
16 |  |  |  |  |  | 0
17 |  |  |  |  |  | 0
18 |  |  |  |  |  | 0
19 |  |  |  |  |  | 0
20 |  |  |  |  |  | 0
21 |  |  |  |  |  | 0
22 |  |  |  |  |  | 0
23 |  |  |  |  |  | 0
24 |  |  |  |  |  | 0
25 |  |  |  |  |  | 0
Spreadsheet: 863661d1711063717-index-match-formula-aggregate_min-excel-function
Sheet: MIN Function

 | Construction Month | Project Status | Project Field Area | [NAME] | Well Name (Project Type) | Activity ID | Activity Status | WBS Code | IP - Well year | IP - Extension | IP - Field Name | IP - Iteration Number | IP - Job Category | IP - Job Status | IP - Primary Job Type | IP - Rig Name | IP - Scope Funding | IP - Scope Job Type | IP - Secondary Job Type | IP - Well API Number | IP - Well Type | IP - Wells Name | IP - WOA | Activity Name | START | (*)Start | FINISH | (*)Finish |  | DATE Range: | 2024-01-01 00:00:00 | 2024-12-31 00:00:00
 | 2023-12-31 00:00:00 | In Progress | AC | TBD | Porter 69G | IP.AC.9380 | Not Started | IP - AC.1.193.5.2 | 2024 | Not Reviewed | AC | 4TH | Workover | TBD | TBD | TBD | TBD | Assessment | TBD | 403724225 | Gas Storage | Porter 69G |  | Workover - 4th | 2023-12-15 08:00:00 | 2023-12-15 08:00:00 | 2024-01-24 17:00:00 | 2024-01-24 17:00:00
Spreadsheet: eric_saibi__9739__011402R
Sheet: Gallagher 02

Owner Name |  | PSI Energy, Inc.
Station Name |  | R Gallagher Power Station
Unit Name |  | R Gallagher 02
NERC Region |  | ECAR
State |  | IN
Fuel Type |  | Coal
Capacity |  | 150 MW
Start Date |  | 2002-01-14 00:00:00
End Date |  | 2002-01-20 00:00:00
Prv. Start Date |  | 2002-02-03 00:00:00
Prv. End Date |  | 2002-02-16 00:00:00
Comments |  | Reliability work
SIC |  | 4911
Plant ID |  | 1010443
Unit ID |  | 1005360
Outage ID |  | 16932
Spreadsheet: 16a5840b-89f7-4c77-b352-fd9229293f58
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (5 Entries):
 | 7 Biotechnology 7.13 Genomics 7.13.4 Systems for microarrays production
No. | Company | Country | City | [NAME] | Hall/Booth
1 | BioFluidix GmbH | Germany | Freiburg | 79110 | B1.523
2 | European Biotech Network | Belgium | Dolembreux | 4140 | A3.254
3 | GeSiM Gesellschaft für Silizium-Mikrosysteme mbH | Germany | Großerkmannsdorf | 01454 | A3.300
4 | [NAME] GmbH | Germany | [NAME] | 72636 | A3.241/340
5 | Zinsser Analytic GmbH | Germany | Frankfurt | 60489 | B1.511
Spreadsheet: 190c1f53-7fca-407c-b0d1-3470b2f1b4fe
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33
 |  |  |  |  |  |  | MONTHLY TIME DISTRIBUTION REPORT (HOURS)
 |  |  |  |  |  |  |  |  |  | FISCAL YEAR
 |  | MONTH/YEAR
 |  | DAYS OF THE MONTH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
PROGRAMS | Acct. Code | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Hours |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CERTIFICATION
 |  |  |  |  |  |  | I CERTIFY THAT THIS IS A TRUE AND CORRECT |  |  |  |  |  |  |  |  |  |  |  |  |  | I HEREBY CERTIFY THAT THE EMPLOYEE WAS PRESENT
 |  |  |  |  |  |  | REPORT OF THE ACTUAL HOURS I WORKED |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AND WORKING AS INDICATED BY THIS REPORT.
 |  |  |  |  |  |  | DURING THIS PERIOD.
 |  |  |  |  |  |  | EMPLOYEE NAME |  |  |  |  |  |  |  |  |  |  |  |  |  | SUPERVISOR NAME
 |  |  |  |  |  |  | EMPLOYEE SIGNATURE |  |  |  |  |  |  |  |  |  |  |  |  |  | SUPERVISOR SIGNATURE
INSTRUCTIONS:  List the actual hours you have worked under the Program Area that applies.
Spreadsheet: 131031d1322697089-vlookup-copy-of-december
Sheet: 27

 |  |  |  | 2011-12-27 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 767955d1644755518-matching-data-between-2-dates-sampledataset
Sheet: Action

Unique ID | Start | End
121358 | 2017-09-12 00:00:00 | 2018-05-22 00:00:00
121359 | 2017-09-12 00:00:00 | 2018-05-22 00:00:00
145575 | 2017-09-12 00:00:00 | 2018-05-22 00:00:00
216672 | 2019-11-18 00:00:00 | 2020-02-04 00:00:00
250862 | 2019-08-28 00:00:00 | 2019-11-21 00:00:00
1003137 | 2018-10-31 00:00:00 | 2019-01-24 00:00:00
1003569 | 2022-01-21 00:00:00 | NULL
1008893 | 2019-03-27 00:00:00 | 2020-11-03 00:00:00
Spreadsheet: 179232d1347089930-generating-sets-of-random-real-numbers-sample-pgee
Sheet: Sheet1

 | Example of Variables | Additional Notes | Example of Results
Number of Random Numbers per Set | 5 | Could be up to 30 |  |  | AVG
Average | 5 | Could be any real number | 5.89 | 6
Lowest Random Number | 1 | Could be any real number | 4.5 | 3
Highest Random Number | 8 | Could be any real number | 3.25 | 5.2
Number of Sets | 2 | Could be up to 50 | 3.4 | 4.89
 |  |  | 8 | 5.7
Spreadsheet: 100436d1298817840-list-of-invoices-giving-an-interest-per-month-list-array
Sheet: Sheet1

I NEED A MONTHLY LIST OF INVOICE WITH PENDING INTEREST. IF DURATION IS LESS THAN A MONTH I CANNOT COUNT INTEREST TWO MONTHS. IF DURATION IS TWO MONTHS, I CANNOT COUNT INTEREST THREE MONTHS. ETC.
 | Invoice # | start | duration days | month | end | Interest
 | January
 | 1 | 2011-01-01 00:00:00 | 33 | 2 | 2011-02-03 00:00:00 | 20
 | 2 | 2011-01-04 00:00:00 | 32 | 2 | 2011-02-05 00:00:00 | 40
 | 3 | 2011-01-15 00:00:00 | 19 | 1 | 2011-02-03 00:00:00 | 5
 | 4 | 2011-01-25 00:00:00 | 72 | 3 | 2011-04-07 00:00:00 | 300
 | February |  |  |  |  | …
 | 5 | 2011-02-03 00:00:00 | 61 | 3 | 2011-04-05 00:00:00 | 450
 | 6 | 2011-02-06 00:00:00 | 85 | 3 | 2011-05-02 00:00:00 | 300
 | 7 | 2011-02-09 00:00:00 | 10 | 1 | 2011-02-19 00:00:00 | 50
 | 8 | 2011-02-20 00:00:00 | 36 | 2 | 2011-03-28 00:00:00 | 100
 | March |  |  |  |  | …
 | 9 | 2011-03-02 00:00:00 | 27 | 1 | 2011-03-29 00:00:00 | 80
 | 10 | 2011-03-05 00:00:00 | 27 | 1 | 2011-04-01 00:00:00 | 50
 | 11 | 2011-03-18 00:00:00 | 32 | 2 | 2011-04-19 00:00:00 | 150
 | 12 | 2011-03-23 00:00:00 | 69 | 3 | 2011-05-31 00:00:00 | 300
 | 13 | 2011-03-31 00:00:00 | 33 | 2 | 2011-05-03 00:00:00 | 200
 |  |  |  |  | TOT | 2045
CONDITIONS A:Z BELOW HAVE TO BE SATISFIED AT SAME TIME PER EACH MONTH
Condition | January | February | March
A | invoice not starting after month of January | invoice not starting after month of February | invoice not starting after month of March
B | invoice not ending before month of January | invoice not ending before month of February | invoice not ending before month of March
C | invoice with 1 month duration cannot start before Jan 1st | invoice with 1 month duration cannot start before Feb 1st | invoice with 1 month duration cannot start before MArch 1st
D | invoice with 2 month duration cannot start before December 1st, 2010 | invoice with 2 month duration cannot start before Jan 1st, 2011 | invoice with 2 month duration cannot start before Feb 1st, 2011
E | invoice with 3 month duration cannot start before November 1st, 2010 | invoice with 3 month duration cannot start before Dec 1st, 2010 | invoice with 3 month duration cannot start before Jan 1st, 2011
F | invoice with 4 month duration cannot start before October 1st, 2010 | invoice with 4 month duration cannot start before Nov 1st, 2010 | invoice with 4 month duration cannot start before Dec 1st, 2010
etc | etc | etc | etc
THIS IS HOW IT SHOULD BE | INTEREST
January |  | FORMULA BELOW DOESN’T WORK
1 | 10
2 | 20
3 | 5
4 | 100
February
1 | 10
2 | 20
4 | 100
5 | 150
6 | 100
7 | 50
8 | 50
March
4 | 100
5 | 150
6 | 100
8 | 50
9 | 80
10 | 50
11 | 75
12 | 100
13 | 100
APRIL
5 | 150
6 | 100
11 | 75
12 | 100
13 | 100
MAY
12 | 100
TOT | 2045
Spreadsheet: 82115d1282150569-macro-to-auto-fill-rows-based-on-one-cell-value-fruit-example
Sheet: Main Sheet

Key | Fruit | Number of items | Unit Price | Total Price
1 | Oranges | 5 | 0.4 | 2
1 | Lemons | 0 | 0.6 | 0
2 | Apples | 4 | 0.2 | 0.8
2 | Limes | 0 | 0.6 | 0
3 | Bananas | 6 | 0.7 | 4.199999999999999
4 | Plums | 2 | 0.9 | 1.8
Key | Animals | Number of items | Unit Price | Total Price
0 | Cows | 0 | 1.4 | 0
1 | Sheep | 6 | 4.6 | 27.6
1 | Pigs | 0 | 6.7 | 0
2 | Horses | 2 | 2.2 | 4.4
2 | Clocks | 0 | 3.3 | 0
Spreadsheet: 40237d1238543351-sort-pivot-table-formula-what-example1
Sheet: Sheet1

 | Data
AV | Sum of Q1 | Sum of Q2 | Sum of Q3 | Sum of Q4
1 | 8 | 14 | 20 | 2
2 | 12 | 18 | 24 | 6
3 | 10 | 16 | 22 | 4
4 | 8 | 14 | 20 | 2
5 | 10 | 16 | 22 | 4
6 | 12 | 18 | 24 | 6
7 | 0 | 0 | 0 | 0
8 | 0 | 0 | 0 | 0
9 | 0 | 0 | 0 | 0
10 | 5 | 8 | 11 | 2
11 | 6 | 9 | 12 | 3
12 | 0 | 0 | 0 | 0
Grand Total | 71 | 113 | 155 | 29