tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60839d1261420795-how-can-i-remove-column-and-row-headers-and-change-background-forum-example
Sheet: Funding Worksheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leasing Source | Agreement Type | Yes/No | Purchase Option | Frequency | Equipment | Round | Billing Desc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ETCS | Cost-Per | Yes | $1.00 to East Texas Copy | Monthly | New | Up | Black Copies
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GA | Maint Only | No | FMV | Quarterly | Used | Down | Color Copies
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Straight Lease |  | $1.00 to Customer | Semi-Annual | Mix | NA | Black Prints
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | Annual |  |  | Color Prints
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | Other |  |  | Scans
 | FUNDING DETAIL WORKSHEET for April 2007 Fundings
 | (for non property tax inclusive transactions)
 |  |  |  | Today's Date |  |  |  |  |  |  |  |  |  | Contract Start Date (Installation) |  |  |  |  | Pmt Due Day
 |  |  |  | Customer Name |  |  |  |  |  |  |  |  |  |  |  | Tax Exempt?
 |  |  | Contract Details and Terms: |  |  |  |  | FUNDING SOURCE = ETCS
 |  |  |  | Funding Source |  | ETCS |  |  |  |  | GA Application # |  |  |  |  |  | Agreement #
 |  |  |  | Base Pmt Freq |  |  |  |  |  |  | [NAME] |  |  |  |  |  | Lease Type
 |  | BLACK COPIES
 |  |  |  | Copies Incl in Base |  |  |  |  |  |  | [NAME] |  |  | per copy
 |  | COLOR COPIES
 |  |  |  | Copies Incl in Base |  |  |  |  |  |  | [NAME] |  |  | per copy
 |  |  |  | Agreement Type |  |  |  |  |  | Security Deposit Collected
 |  | Include Pers Prop Tax (PPT) in Rates? |  |  |  |  |  |  |  | Install City |  |  |  |  |  |  | Install County
 |  |  |  |  |  | 2096.01
 |  |  |  |  |  |  |  | L O A N   D E T A I L S
 |  |  |  |  |  | New Equipment Cost
 |  |  |  |  | + | Buyout to other Leasing Company
 |  |  |  |  | = | Total Equipment Cost
 |  |  |  |  |  | [NAME] (in months)
 |  |  |  |  | x | Rate Factor |  |  |  | 0 |  |  | Funding Rate Factor
 |  |  |  |  |  | Funding Rate Factor
 |  |  |  |  | = | Equipment Payment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0983 |  | [NAME]
 |  |  |  |  |  | [NAME] to ETCS |  |  |  |  |  |  |  |  |  |  | 0.95 |  | [NAME]
 |  |  | Special Instructions/Additional Comments
Spreadsheet: 674491d1587874046-pivot-table-subtotals-would-like-variance-for-the-above-2-rows-subtotal-how-to-get-the-difference-total-for-the-2-rows-abovev2-carla77-
Sheet: Sheet4

Sum of Volumes |  | Period
Department | Year | 1 | 2 | 3 | 4
Depart A
 | 2018-19 | 4 | 2 | 4
 | 2019-20 | 4 |  | 11
 | [NAME] | 0 | -2 | 7 | 0
Depart B
 | 2018-19 | 6 | 7 | 5 | 3
 | 2019-20 |  | 7 |  | 5
 | [NAME] | -6 | 0 | -5 | 2
Spreadsheet: 02ef238b-4e1e-412a-a940-4deaa273cf2c
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
12/10/2011 | Gymnastics | Gold-Blue Meet (Pittsburgh, Pa.) | 12:00 AM | 4 p.m.
01/08/2012 | Gymnastics | Maryland | 12:00 AM | W, 195.1-194.225
01/08/2012 | Gymnastics | Penn State | 12:00 AM | L, 195.775-195.1
01/15/2012 | Gymnastics | Rutgers | 12:00 AM | W, 193.425-191.65
01/21/2012 | Gymnastics | at Bowling Green | 12:00 AM | W, 193.475-193.225
01/29/2012 | Gymnastics | [NAME] | 12:00 AM | W, 195.775-193.125
01/29/2012 | Gymnastics | Towson | 12:00 AM | W, 195.775-190.875
02/03/2012 | Gymnastics | at Michigan | 12:00 AM | L, 194.65-194.05
02/12/2012 | Gymnastics | Ohio State | 12:00 AM | L, 195.45-195.175
02/12/2012 | Gymnastics | Auburn | 12:00 AM | W, 195.175-193.65
02/12/2012 | Gymnastics | [NAME] | 12:00 AM | W, 195.175-191.775
02/18/2012 | Gymnastics | vs. Rutgers (College Park, Md.) | 12:00 AM | W, 194.8-191.7
02/18/2012 | Gymnastics | William & Mary (College Park, Md.) | 12:00 AM | W, 194.8-191.175
02/18/2012 | Gymnastics | at Maryland | 12:00 AM | W, 194.8-194.55
[NAME] | Gymnastics | at New Hampshire | 12:00 AM | L, 195.75-194.225
03/03/2012 | Gymnastics | at Denver | 12:00 AM | W, 194.175-194.1
03/03/2012 | Gymnastics | vs. Missouri (Denver, Colo.) | 12:00 AM | W, 194.175-194.025
03/03/2012 | Gymnastics | vs. Western Michigan (Denver, Colo.) | 12:00 AM | W, 194.175-193.825
03/10/2012 | Gymnastics | Arkansas | 12:00 AM | W, 195.675-195.125
03/16/2012 | Gymnastics | at LSU | 12:00 AM | L, 196.85-194.9
03/24/2012 | Gymnastics | EAGL Championship (Pittsburgh, Pa.) | 12:00 AM | First Place, 196.475
04/07/2012 | Gymnastics | NCAA Regional Championships (Auburn, Ala.) | 12:00 AM | Fifth place, 195.9
04/20/2012 | Gymnastics | [NAME] (Duluth, Ga.) | 12:00 AM | TBA
12/06/2012 | Gymnastics | Gold-Blue Meet | 12:00 AM | 7 p.m.
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5318

5318 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 158824d1338403079-getting-list-of-names-with-close-matches-close-matches
Sheet: Sheet1

[NAME] | [NAME]
[NAME] | [NAME], DDS
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | United Union
500 | 500
Spreadsheet: 799727d1665237495-averageif-of-last-5-entries-leadtimetest
Sheet: Feuil1

 |  | (Ctrl + ;) (Ctrl + Shift + ;) |  |  |  |  |  |  |  |  |  |  | Business hours |  |  | Holidays
Projet |  | Received | Appointment | # of options | Lead-time | time/option |  | All requests |  |  |  |  | Start | 8:00:00 |  | 2022-10-10 00:00:00
522-231 Bezos |  | 2022-10-05 15:40:00 | 2022-10-07 09:30:00 | 1 |  |  |  | Last 10 |  |  |  |  | End | 16:00:00 |  | 2022-12-25 00:00:00
122-210 Musk |  | 2022-10-05 09:00:00 | 2022-10-07 09:30:00 | 3 |  |  |  | Current week |  |  |  |  |  |  |  | 2022-12-26 00:00:00
522-234  Jobs |  | 2022-10-05 10:30:00 | 2022-10-07 13:00:00 | 2 |  |  |  | Time/options (weekly) |  |  |  |  | Month |  |  | 2023-01-01 00:00:00
122-210 Edison |  | 2022-10-05 13:45:00 | 2022-10-11 09:00:00 | 2 |  |  |  | Current month |  |  |  |  | 2022-10-01 00:00:00 | 2022-10-31 00:00:00 |  | 2023-01-02 00:00:00
5 |  | 2022-10-05 14:41:00 | 2022-10-11 09:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  | 2023-04-10 00:00:00
5 |  | 2022-10-05 14:47:00 | 2022-10-11 09:00:00 | 8 |  |  |  | Elon |  |  |  |  | Week |  |  | 2023-05-22 00:00:00
5 |  | 2022-10-05 15:05:00 | 2022-10-11 09:00:00 | 2 |  |  |  | Last 5 |  |  |  |  | 2022-10-03 00:00:00 | 2022-10-11 00:00:00 |  | 2023-06-24 00:00:00
5 |  | 2022-10-05 15:45:00 | 2022-10-11 09:00:00 | 1 |  |  |  | Current week |  |  |  |  |  |  |  | 2023-07-01 00:00:00
5 |  | 2022-10-06 15:40:00 | 2022-10-11 09:00:00 | 1 |  |  |  | Time/options (weekly) |  |  |  |  | Reference | Colleague |  | 2023-09-04 00:00:00
5 |  | 2022-10-06 09:00:00 | 2022-10-11 09:00:00 | 2 |  |  |  | Current month |  |  |  |  | 1 | Elon |  | 2023-10-09 00:00:00
5 |  | 2022-10-06 10:30:00 | 2022-10-11 09:00:00 | 1 |  |  |  |  |  |  |  |  | 5 | [NAME] |  | 2023-12-25 00:00:00
1 |  | 2022-10-06 13:45:00 | 2022-10-11 09:00:00 | 4 |  |  |  | [NAME] |  |  |  |  |  |  |  | 2023-12-26 00:00:00
1 |  | 2022-10-06 14:41:00 | 2022-10-11 09:00:00 | 6 |  |  |  | Last 5
1 |  | 2022-10-06 14:47:00 | 2022-10-11 09:00:00 | 1 |  |  |  | Current week
1 |  | 2022-10-06 15:05:00 | 2022-10-11 09:00:00 | 1 |  |  |  | Time/options (weekly)
1 |  | 2022-10-07 15:45:00 | 2022-10-11 09:00:00 | 1 |  |  |  | Current month
1 |  | 2022-10-07 14:41:00 | 2022-10-11 09:00:00 | 3
1 |  | 2022-10-07 14:47:00 | 2022-10-11 09:00:00 | 2
1 |  | 2022-10-07 15:05:00 | 2022-10-11 09:00:00 | 1
Spreadsheet: 94566d1294341010-a-simpler-way-to-do-nested-vlookups-capital-plan-help
Sheet: RawData

Timestamp | Project Name | Project Number | Department | Priority | Date of Completion | Description | Justification | Contact Person | Type of Project | Category | Useful Life | Total Expenditures | Date of Expenditure #1 | Expenditure #1 | Expenditure #1 Amount | Date of Expenditure #2 | Expenditure #2 | Expenditure #2 Amount | Date of Expenditure #3 | Expenditure #3 | Expenditure #3 Amount | Date of Expenditure #4 | Expenditure #4 | Expenditure #4 Amount | Date of Expenditure #5 | Expenditure #5 | Expenditure #5 Amount | Date of Expenditure #6 | Expenditure #6 | Expenditure #6 Amount | Date of Expenditure #7 | Expenditure #7 | Expenditure #7 Amount | Date of Expenditure #8 | Expenditure #8 | Expenditure #8 Amount | Date of Expenditure #9 | Expenditure #9 | Expenditure #9 Amount | Date of Expenditure #10 | Expenditure #10 | Expenditure #10 Amount | Total of Project Funding Sources | Date of Funding Source #1 | Funding Source #1 | Funding Source #1 Amount | Date of Funding Source #2 | Funding Source #2 | Funding Source #2 Amount | Date of Funding Source #3 | Funding Source #3 | Funding Source #3 Amount | Date of Funding Source #4 | Funding Source #4 | Funding Source #4 Amount | Date of Funding Source #5 | Funding Source #5 | Funding Source #5 Amount | Funding Source #6 | Date of Funding Source #6 | Funding Source #6 Amount | Date of Funding Source #7 | Funding Source #7 | Funding Source #7 Amount | Date of Funding Source #8 | Funding Source #8 | Funding Source #8 Amount | Date of Funding Source #9 | Funding Source #9 | Funding Source #9 Amount | Date of Funding Source #10 | Funding Source #10 | Funding Source #10 Amount | Date of Funding Source #11 | Funding Source #11 | Funding Source #11 Amount | Date of Funding Source #12 | Funding Source #12 | Funding Source #12 Amount | Date of Funding Source #13 | Funding Source #13 | Funding Source #13 Amount | Date of Funding Source #14 | Funding Source #14 | Funding Source #14 Amount | Date of Funding Source #15 | Funding Source #15 | Funding Source #15 Amount | Key
2011-01-06 10:49:37 | Test | 1234 | Administration | 3 | 2015 | Ice cream stand | Ice Cream is yummy | Brock | A tasty one | Delicious | Until it melts | 1000 | 2011 | Cart | 200 | 2011 | Ice Cream | 200 | 2012 | Staff | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 2011 | Mom | 100 | 2011 | Dad | 100 | 2012 | [NAME] | 100 | 2013 | Grandpa | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Administration1
Spreadsheet: 99108d1297862261-summing-across-multiple-sheets-764625_markvdh
Sheet: SUMMARY

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
NET OPERATING INCOME |  |  | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000
ADDITIONAL COSTS |  |  | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000 | -3000
Spreadsheet: 24668d1215367058-gradient-calculations-baboon
Sheet: Sheet1

 |  |  | Method 1 Individual Distances |  |  | Method 2 Cumulative Distances
Distance | Reciprocal Gradient |  | Rise / Fall over Leg | [NAME] |  | Rise / Fall over Leg | [NAME]
100 | -61 |  | -1.639344262295082 | -61 |  | -1.639344262295082 | -61
130 | -100 |  | -1.3 | -78.24874511991077 |  | -0.3 | -67.03296703296704
200 | 400 |  | 0.5 | -176.2768817204301 |  | 0.175 | -113.3565621370499
400 | 65 |  | 6.153846153846154 | 223.4485334057577 |  | 3.076923076923077 | 304.7436051399063
Spreadsheet: 40481d1238780187-excel-2007-compare-and-show-only-the-different-value-cells-as-result-compare-2-1-version-1-
Sheet: Details

 | Master Data |  |  | To Check |  |  | Result
 | Request_A | Item_A |  | Request_B | Item_B |  | Request_Final | Item_Final
 | 10051 | 10 |  | 10051 | 10 |  | 10051 | 20 |  |  |  | 1005110 | 1005110 |  | 1005120
 | 10051 | 20 |  | 10052 | 10 |  | 10053 | 10 |  |  |  | 1005120 | 1005210 | 1005120 | 1005310
 | 10052 | 10 |  | 10053 | 20 |  | 10054 | 30 |  |  |  | 1005210 | 1005320 |  | 1005430
 | 10053 | 10 |  | 10054 | 10 |  | 10056 | 10 |  |  |  | 1005310 | 1005410 | 1005310 | 1005610
 | 10053 | 20 |  | 10054 | 20 |  | 10057 | 20 |  |  |  | 1005320 | 1005420 |  | 1005720
 | 10054 | 10 |  | 10055 | 20 |  | 10060 | 30 |  |  |  | 1005410 | 1005520 |  | 1006030
 | 10054 | 20 |  | 10055 | 30 |  |  |  |  |  |  | 1005420 | 1005530
 | 10054 | 30 |  | 10070 | 50 |  |  |  |  |  |  | 1005430 | 1007050 | 1005430
 | 10055 | 20 |  |  |  |  |  |  |  |  |  | 1005520
 | 10055 | 30 |  |  |  |  |  |  |  |  |  | 1005530
 | 10056 | 10 |  |  |  |  |  |  |  |  |  | 1005610 |  | 1005610
 | 10057 | 20 |  |  |  |  |  |  |  |  |  | 1005720 |  | 1005720
 | 10060 | 30 |  |  |  |  |  |  |  |  |  | 1006030 |  | 1006030
 | 10070 | 50 |  |  |  |  |  |  |  |  |  | 1007050
Spreadsheet: 840599d1692855040-xlookup-partial-criteria-formula-not-working-sample54-aligw
Sheet: Sheet1

Table 3 |  | Table 1 |  |  |  |  | Table 2
Card List |  | Date | Card | Balance |  |  | Date | Balance Total
xxxx1705 |  | 2023-08-15 05:29:12 | xxxx1705 | 901 |  |  | 2023-08-10 00:00:00
xxxx9050 |  | 2023-08-15 05:29:12 | xxxx9050 | 574 |  |  | 2023-08-11 00:00:00
xxxx1647 |  | 2023-08-15 03:37:16 | xxxx1647 | 182 |  |  | 2023-08-12 00:00:00
 |  | 2023-08-14 11:14:48 | xxxx1705 | 475 |  |  | 2023-08-13 00:00:00
 |  | 2023-08-14 10:26:36 | xxxx9050 | 209 |  |  | 2023-08-14 00:00:00
 |  | 2023-08-14 10:20:25 | xxxx1647 | 573 |  |  | 2023-08-15 00:00:00
 |  | 2023-08-13 19:52:55 | xxxx1705 | 182
 |  | 2023-08-13 18:55:29 | xxxx9050 | 574
 |  | 2023-08-13 09:57:04 | xxxx1647 | 392
 |  | 2023-08-12 21:07:32 | xxxx1705 | 482
 |  | 2023-08-12 21:07:32 | xxxx9050 | 100
 |  | 2023-08-12 11:30:02 | xxxx1647 | 902
 |  | 2023-08-11 22:02:42 | xxxx1705 | 471
 |  | 2023-08-11 07:39:49 | xxxx9050 | 884
 |  | 2023-08-11 05:42:34 | xxxx1647 | 200
 |  | 2023-08-10 00:00:00 | xxxx1705 | 288
 |  | 2023-08-10 08:31:08 | xxxx9050 | 597
 |  | 2023-08-10 05:37:10 | xxxx1647 | 160
Spreadsheet: 585382d1533738694-time-calculation-book2
Sheet: BasicWorkDurationReport

Monthly Status Report (Basic Work Duration)
 |  |  |  |  |  |  |  |  |  |  |  | Jul 01 2018  To  Jul 31 2018
Days | 1 S | 2 M | 3 T | 4 W | 5 Th | 6 F | [NAME] | 8 S | 9 M | 10 T | 11 W | 12 Th | 13 F | 14 St | 15 S | 16 M | 17 T | 18 W | 19 Th | 20 F | 21 St | 22 S | 23 M | 24 T | 25 W | 26 Th | 27 F | 28 St | 29 S | 30 M | 31 T
 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
Status | WO | P | P | P | P | P | P | WO | P | P | P | P | P | A | WO | P | P | P | P | ½P | P | WOP | P | P | P | P | P | P | WO | P | A
InTime |  | 07:21 | 07:43 | 07:38 | 07:24 | 07:25 | 08:44 |  | 07:44 | 07:31 | 07:44 | 07:36 | 07:32 |  |  | 08:09 | 07:23:00 | 07:28 | 08:00:00 | 10:50 | 09:48 | 08:00:00 | 09:11 | 10:16 | 09:15 | 09:46 | 09:04 | 09:39 |  | 09:35 | 10:00:00
OutTime |  | 20:38 | 20:32 | 21:02 | 21:06 | 21:30 | 21:17 |  | 20:12 | 20:16 | 21:00 | 20:23 | 16:16 |  |  | 20:20:00 | 21:10 | 08:00:00 | 22:14 | 21:11 | 08:00:00 | 19:38 | 20:59 | 21:13 | 21:22 | 21:26 | 20:24 | 20:25 |  | 21:29 | 21:30:00
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remark
Extra hrs. | 00:00:00 |  |  |  |  |  |  | 00:00:00 |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total no of hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | night stay |  |  | night stay |  |  |  |  |  |  |  |  |  |  | 2 | Night Stay
Spreadsheet: 52293d1251992395-multiple-formulae-in-a-cell-an-algorithm-698153-named-formulas
Sheet: Sheet1

Ta | 20 | This is the other parameter and will vary in the Y axis (I.e. Columns)
RH | 0.5 | This is one parameter and will vary in the X axis (I.e. Rows)
Stage 1 | 1.169523458199631 | B4: =0.611 * RH * EXP(17.27 * Ta / (Ta + 237.3)) |  | Example sheet would look like:
Stage 2 | 9.26767591256879 | B5: =(116.9 + 237.3 * LN(Var1)) / (16.78 - LN(Var1)) |  |  |  | RH
Stage 3 | 1168.283933856763 | B6: =611.2 * EXP(17.67 * (Var2 / (243.5 + Var2))) |  |  |  | -10 | -5 | …
Stage 4 | 0.007255355760456579 | B7: =0.622 * Var3/(101.325 * 1000 - Var3) |  | Ta | 1 | FinalVal | FinalVal | FinalVal
Final Value | 7.203094745501687 | B8: =1000 * Var4 / (1 + Var4) |  |  | 2 | FinalVal | FinalVal | FinalVal
 |  |  |  |  | 3 | FinalVal | FinalVal | FinalVal
 |  |  |  |  | … | FinalVal | FinalVal | FinalVal
Spreadsheet: 1474a546-1e41-494a-abb4-8eb36a6d89c0
Sheet: 1995

TYPE OF PERMIT | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YR TOTAL
-------------- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --------
SINGLE FAMILY DET. | 50 | 74 | 54 | 68 | 89 | 67 | 91 | 67 | 60 | 75 | 69 | 73
$ [NAME] | 6095729 | 8803962 | 6530501 | 9117582 | 12097911 | 9258202 | 11487358 | 9706047 | 9463644 | 11520512 | 9234929 | 11065245
SINGLE FAMILY ATT. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DUPLEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MULTI FAMILY UNITS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RESIDENTIAL ADD. | 10 | 9 | 12 | 10 | 43 | 81 | 30 | 37 | 18 | 29 | 8 | 14
$ [NAME] | 55210 | 18100 | 61305 | 21850 | 156914 | 295131 | 115148 | 129503 | 42274 | 111531 | 38877 | 53624
COMMERCIAL | 0 | 1 | 2 | 0 | 2 | 1 | 2 | 2 | 1 | 1 | 1 | 0
$ [NAME] | 0 | 345000 | 4650000 | 0 | 410175 | 2950000 | 255000 | 102000 | 750000 | 293000 | 325000 | 0
COMMERCIAL ADD/F.O. | 5 | 3 | 8 | 6 | 3 | 1 | 5 | 5 | 3 | 4 | 3 | 2
$ [NAME] | 55700 | 28675 | 2279400 | 66000 | 7178 | 15000 | 70600 | 44200 | 90000 | 86500 | 4400 | 113500
INDUSTRIAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PUBLIC BUILDINGS | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 320000 | 0 | 0 | 0 | 0 | 0 | 0
PUBLIC BLDG. ADD. | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 340000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TEMPORARY OFFICE | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 2 | 1 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1000 | 11000 | 1000 | 0
ACCESSORY BLDG. | 5 | 3 | 8 | 9 | 5 | 6 | 1 | 6 | 1 | 5 | 3 | 1
$ [NAME] | 5550 | 2000 | 7850 | 13900 | 5000 | 3780 | 400 | 9195 | 250 | 4498 | 3460 | 500
POOLS | 9 | 8 | 9 | 17 | 14 | 19 | 14 | 14 | 12 | 10 | 9 | 3
$ [NAME] | 179400 | 126185 | 136100 | 293500 | 194900 | 345300 | 258820 | 259800 | 245564 | 230400 | 181765 | 49000
SPAS | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0
$ [NAME] | 0 | 0 | 6500 | 0 | 3000 | 0 | 0 | 0 | 0 | 100 | 500 | 0
FENCES | 25 | 86 | 76 | 59 | 75 | 47 | 44 | 57 | 34 | 51 | 37 | 34
$ [NAME] | 24650 | 80138 | 73920 | 63255 | 72385 | 37475 | 46796 | 38775 | 33436 | 48275 | 40750 | 35465
SPRINKLER | 34 | 34 | 33 | 53 | 45 | 47 | 34 | 51 | 35 | 43 | 40 | 42
$ [NAME] | 37600 | 39630 | 40380 | 75136 | 59750 | 62925 | 42350 | 68941 | 36200 | 51900 | 70325 | 51600
SIGNS | 14 | 17 | 6 | 20 | 3 | 7 | 12 | 11 | 11 | 9 | 10 | 4
$ [NAME] | 5550 | 26644 | 1400 | 14045 | 1500 | 8200 | 7335 | 33502 | 2940 | 11345 | 6360 | 3128
MOVING | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 0
DEMOLITION | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0
$ [NAME] | 0 | 300 | 1000 | 0 | 0 | 0 | 0 | 1000 | 1000 | 0 | 0 | 0
TOTAL PERMITS
TOTAL DOLLAR VALUE
Spreadsheet: 735141d1622717359-count-weeks-in-sequential-year-gas-week
Sheet: Gas Week

 |  |  |  |  |  |  |  |  |  |  | CLOSE! |  |  |  | Start of week one
Date | Day of Week | Week Number |  | Date | Day of Week | SHOULD BE |  | WEEKNUM | ISOWEEKNUM |  | Formula 1 |  | Formula 2 |  | First Friday of the year
2018-01-01 00:00:00 |  |  |  | 2018-12-24 00:00:00
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  |  |  | 2019-12-24 00:00:00
 |  |  |  | 2020-12-24 00:00:00
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
Spreadsheet: 115118d1310735804-extract-unique-data-and-concatenate-book
Sheet: SOCKS

No. | Item Code | Description | DATE
1 | C-458-11 | Socks X1 | 2011-07-06 00:00:00
2 | C-458-11 | Socks X2 | 2011-07-06 00:00:00
3 | C-458-11 | Socks X3 | 2011-07-06 00:00:00
4 | C-458-11 | Socks X4 | 2011-07-08 00:00:00
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
Spreadsheet: 737199d1624278020-multi-match-between-two-spreadsheets-multi-match
Sheet: payment file

analtype | analcode | company | nostro | subdate | batch | subbatch | currency | doc-id | [NAME] | type | accno | amount | dbcr | Supplier | suppname | payeename | [NAME] | transdate | modified | baccno | value-date
Submission Code | 8005 | 8005 | 40000000 | 2021-05-18 00:00:00 | CB032301 | 7631 | GBP | CPSB01 | 1 | B | 8005000 | 84 | D |  | Mr [NAME] | Mr Monday | 999999 | 2021-05-18 00:00:00 | no | 99999999 | ?
Submission Code | 8005 | 8005 | 40000000 | 2021-05-18 00:00:00 | CB032301 | 7631 | GBP | CPSB01 | 2 | B | 8005000 | 193 | D |  | Mr [NAME] | Mr Tuesday | 999999 | 2021-05-18 00:00:00 | no | 99999999 | ?
Submission Code | 8005 | 8005 | 40000000 | 2021-05-18 00:00:00 | CB032301 | 7631 | GBP | CPSB01 | 3 | B | 8005000 | 20 | D |  | Mr [NAME] | Mr Wednesday | 999999 | 2021-05-18 00:00:00 | no | 99999999 | ?
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: Adult Ed

 | 2009-10 |  |  | 2010-11 | % | DSABASE | DSABASE | DSAM200 | DSAM200 | DSAM300 |  | DSAE670 |  | DSAE671 |  | DSAE601 |  | [NAME] | % CHG | [NAME] | % CHG
 | WK PROGRAM | ACTUAL | % CHG | WK PROGRAM | CHG | 2011-12 | 2012-13 |  |  |  |  | 2011-12 | 2012-13 | 2011-12 | 2012-13 | 2011-12 | 2012-13
If using Adult HS Enrollment & Enrollment Growth:
ADULT EDUCATION | 21170456 | 21170456 |  | 22673833
 |  | FY2010 L01 |  | FY 2011 L01 |  |  |  | FY 2012 | FY 2013
[NAME] Enrollment - Regular
[NAME] Enrollment - Corrections |  | 5731 |  | 5936
[NAME] Enrollment - Total
AHS Projected Enrollment
Enrollment projections above for 2011, 2012, 2013 made using average enrollment growth for Fiscal Years 2006 through 2010
 |  |  |  |  |  | Projected |  | Projected |  | Projected
 |  |  |  | FY 2010 Actual |  | FY 2011 |  | FY 2012 |  | FY 2013
 | Corrections | 0.0078 |  | 4750
 | Regular | 0.0269 |  | 20400
 | Total | 0.0224
L01
workbook | FY 2010 | FY 2011
funding | 21170456 | 22673833
enrollment | 31096 | 33029
should have been | 21203570 | 22726778
Per pupil
funded enrollment
difference
Spreadsheet: 129984d1321997933-using-vlookup-when-column-data-changes-preserve-old-value-test1
Sheet: Sheet2

# to lookup |  | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT
12345
 | THIS PERIOD NOV - OCT WILL NOT CHANGE (BASED ON PROJECT).  I NEED THE DATA INSIDE TO UPDATE EACH MONTH, YET PRESERVE PREVIOUS MONTHLY DATA
CURRENT FC DATA
 |  | PART # | DESCR | ORDER# | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT
 |  | 12345 | [NAME] | YYY | 111 | 222 | 333 | 444 | 555 | 656 | 777 | 888 | 999 | 1010 | 1111 | 1212
EX.  IT IS NOW DEC, AND I HAVE NEW FC OF;
NEW FC |  | PART # | DESCR | ORDER# | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV
 |  | 12345 | [NAME] | YYY | 222 | 333 | 444 | 555 | 656 | 777 | 888 | 999 | 1010 | 1111 | 1212 | 3232
HOW CAN I GET DEC-OCT ABOVE TO AUTO UPDATE WITH NEW FC, WHILE NOV REMAINS THE SAME?
 |  | `