tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3262f647-d600-4ab0-9830-097e81b2949f
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 42. OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number: $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413806K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413807L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413808R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413809T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413810A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413811C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413812F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413813J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413814K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413815L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413816R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 802507d1666886287-need-a-formula-that-will-only-perform-a-calculation-every-2-columns-example
Sheet: example

 |  |  |  |  |  |  |  |  |  |  |  |  | 20 Year Cost Calculation
Apple |  |  |  |  |  |  |  |  |  |  |  |  | Average Cost Increase |  |  | 0.02
 |  | Hardware | Model | MSRP | [NAME] | Cost | Quantity | Total Cost
 |  | Ipad | 10th G, 256GB | $599 | 0.02 | $587 | 5000 | $2,935,100
 |  | Wifi Cellular |  | $150 | 0.02 | $147 | 5000 | $735,000 |  |  |  | Year
 |  | Apple Pencil |  | $99 | 0.02 | $97 | 5000 | $485,100 |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  | Keyboard |  | $249 | 0.02 | $244 | 5000 | $1,220,100 |  |  |  | 5795300
 |  | Total |  | $1,097 |  | $1,075 |  | $5,375,300
 |  | MDM |  | MSRP |  | Cost | Quantity | Total Cost |  |  |  | 12 Year Total Cost |  | $37,645,738
 |  | XYZ |  | $84 | 0 | $84 | 5000 | $420,000 |  |  |  | 24 Year Total Cost |  | $102,535,958
 |  | Of course. See attached. So in my head, what I would like to do is tell excel for every 3 columns or nth columns perform this calculation, otherwise the value is $0.
Lenovo
 |  | Hardware | Model | MSRP | [NAME] | Cost | Quantity | Total Cost
 |  | Thinkpad | [NAME] | $1,399 | 0.15 | $1,189 | 5000 | $5,945,750
 |  |  |  |  |  |  |  |  |  |  |  | Year
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  | MDM |  | MSRP |  | Cost | Quantity | Total Cost |  |  |  | $6,365,750 | $- | $- | $- | $6,890,493 | $- | $- | $- | $8,073,310 | $- | $- | $- | $10,238,909 | $- | $- | $- | $14,055,828 | $- | $- | $- | $20,886,222 | $- | $- | $- | $33,594,177
 |  | XYZ |  | $84 | 0 | $84 | 5000 | $420,000
 |  |  |  |  |  |  |  |  |  |  |  | 12 Year Total Cost |  | $31,568,462
 |  |  |  |  |  |  |  |  |  |  |  | 20 Year Total Cost |  | $66,510,512
Spreadsheet: 75841e22-c63c-4178-9500-e19536d49b5b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42759433 | 2014-08-17 10:39:24 | ALLIES | 0 | 3 | 5 | 1294353 | gkhan | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42759570 | 2014-08-17 10:53:44 | AXIS | 1 | 5 | 2 | 1294353 | gkhan | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42761150 | 2014-08-17 14:34:22 | ALLIES | 0 | 4 | 6 | 382337 | Ace of Diamonds | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42761457 | 2014-08-17 15:00:14 | AXIS | 1 | 6 | 3 | 382337 | Ace of Diamonds | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42822160 | 2014-08-21 21:43:31 | AXIS | 0 | 3 | 6 | 1515794 | Bodega28 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42822491 | 2014-08-21 22:08:44 | ALLIES | 1 | 6 | 2 | 1515794 | Bodega28 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
42842919 | 2014-08-23 09:38:52 | ALLIES | 1 | 5 | 4 | 693006 | chamach | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
Spreadsheet: 080b0d8a-43ff-4e2f-9930-fb0786d8efeb
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42494712 | 2014-07-28 22:03:33 | AXIS | 1 | 4 | 3 | 1001447 | Matsuri | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42494994 | 2014-07-28 22:09:08 | ALLIES | 1 | 4 | 1 | 1001447 | Matsuri | 6159 | western | 1944-06-06 | 1944-06-06 | Sainte-Mère-Eglise | Sainte-Mère-Eglise
42495098 | 2014-07-28 22:20:50 | ALLIES | 1 | 5 | 3 | 681429 | Caverne | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42495332 | 2014-07-28 22:35:15 | AXIS | 0 | 1 | 5 | 681429 | Caverne | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
Spreadsheet: 86275d1286294450-automatically-updating-a-workbook-with-information-from-several-workbooks-week-1
Sheet: Sheet1

Branch Name | Week 1
Store 1 | 0.4821428571428572 | 0.01923076923076923 | 0.3 | 0.2 | 10 | 0.1298701298701299 | 6170 | 3092.4125 | 1.995206008254073
Store 2 | 0.7058823529411765 | 0.0261437908496732 | 0.2142857142857143 | 0.1111111111111111 | 4 | 0.2822580645161291 | 8600 | 5245.554999999999 | 1.639483333984679
Store 3 | 0.4864864864864865 | 0.03977272727272727 | 0.1153846153846154 | 0.1666666666666667 | 3 | 0.2318840579710145 | 3890 | 2661.26 | 1.461713624373417
Store 4 | 0.5371900826446281 | 0.06578947368421052 | 0.0% | 0.1428571428571428 | 0 | 0.2352941176470588 | 5700 | 4941.610000000001 | 1.153470225290947
Store 5 | 0.3898305084745763 | 0.02994011976047904 | 0.1 | 0.0% | 6 | 0.1142857142857143 | 2780 | 3222.8325 | 0.8625952481241269
Spreadsheet: vkaminski__40649__DigitalAsnStrip_O
Sheet: Sheet1

 | Digital Option on Asian Strip
 | Valuation Date | 2000-01-10 00:00:00 |  | no. of months in avg |  |  | Correlation Matrix
 | Average Start | 2000-06-01 00:00:00 |  | toAvgStart |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  | 1 | I
 | Average End | 2000-12-31 00:00:00 |  | toAvgEnd |  |  | 1 | 1 | 0.99 | 0.98 | 0.97 | 0.96 | 0.95 | 0.94 | 0.93 | 0.92 | 0.91 |  |  | 2 | J
 |  |  |  |  |  |  | 2 |  | 1 | 0.99 | 0.98 | 0.97 | 0.96 | 0.95 | 0.94 | 0.93 | 0.92 |  |  | 3 | K
 | Option Strike | 19 |  |  |  |  | 3 |  |  | 1 | 0.99 | 0.98 | 0.97 | 0.96 | 0.95 | 0.94 | 0.93 |  |  | 4 | L
 | Digital Payout | 2 |  |  |  |  | 4 |  |  |  | 1 | 0.99 | 0.98 | 0.97 | 0.96 | 0.95 | 0.94 |  |  | 5 | M
 | interest rate | 0.06 |  |  |  |  | 5 |  |  |  |  | 1 | 0.99 | 0.98 | 0.97 | 0.96 | 0.95 |  |  | 6 | N
 | setAvg | 0 |  |  |  |  | 6 |  |  |  |  |  | 1 | 0.99 | 0.98 | 0.97 | 0.96 |  |  | 7 | O
 | nRun | 7000 |  |  |  |  | 7 |  |  |  |  |  |  | 1 | 0.99 | 0.98 | 0.97 |  |  | 8 | P
 | Call/Put | 0 |  |  |  |  | 8 |  |  |  |  |  |  |  | 1 | 0.99 | 0.98 |  |  | 9 | Q
 |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  | 1 | 0.99 |  |  | 10 | R
 |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  | 1
 | Digital on AsnStrip
 | [NAME]
 |  |  |  |  |  |  |  | O:\research\custom\emc.dll
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | BJKKKKBBBBJJbj!
 | Contract | WTI forward | vol | Contract Maturity | tm |  | Selection
 | 2000-01-01 00:00:00 | 22 | 0.36
 | 2000-02-01 00:00:00 | 22 | 0.36
 | 2000-03-01 00:00:00 | 22 | 0.36
 | 2000-04-01 00:00:00 | 22 | 0.36
 | 2000-05-01 00:00:00 | 22 | 0.36
 | 2000-06-01 00:00:00 | 22 | 0.36
 | 2000-07-01 00:00:00 | 22 | 0.36
 | 2000-08-01 00:00:00 | 22 | 0.36
 | 2000-09-01 00:00:00 | 22 | 0.36
 | 2000-10-01 00:00:00 | 22 | 0.36
 | 2000-11-01 00:00:00 | 22 | 0.36
 | 2000-12-01 00:00:00 | 22 | 0.36
 | 2001-01-01 00:00:00 | 22 | 0.36
Spreadsheet: 758096d1638641391-how-to-extract-records-having-the-same-entry-and-exit-date-test-041221-find-records-based-on-sameday-entry-exit
Sheet: result

 | Symbol | ISIN | Entry Date | Exit Date | Quantity | Buy Value | Sell Value | Profit | Period of Holding | Turnover
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Indus Maint Certs 1

INDUSTRIAL MAINTANANCE TECHNOLOGY
Certificates
Student Name:
ID #
Industrial Maintanance Machinists Mechanic | Semester | Grade
___ BRX 120 (3) Basic Blueprint Reading
OR ___ BRX 110 (2) Basic Blueprint Reading for Machinist
OR ___ BRX 112 (4) Blueprint Reading for Machinist
OR ___ ELT 102 (2) Blueprint Reading
___ IMT 100 (3) Welding for Maintenance
AND ___ IMT 101 (2) Welding for [NAME]
OR ___ WLD 120 (2) Shielded Metal Arc Welding
AND ___ WLD 121 (2) Shielded Metal Arc Welding Lab
OR ___ WLD 152 (5) Basic Welding B
___ IMT 115 (2) [NAME] I
AND ___ IMT 116 Maintenance Machining I Lab
OR ___ CMM 114 (7) Fundamentals of Machine Tools
OR ___ CMM 110 (3) Fundamentals of Machine Tools - A
AND ___ CMM 112 (4) Fundamentals of Machine Tools - B
___ IMT 150 (3) Maintaining Industrial Equipment I
___ IMT 151 (2) Maintaining Industrial Equipment I Lab
Industrial Maintenance Electrical Mechanic
___ FPX 100 (3) Fluid Power
AND ___ FPX 101 (2) Fluid Power Lab
OR ___ ELT 265 (3) Applied Fluid Power
___ IMT 110 (3) Industrial Maintanence Electrical Principles
AND ___ IMT 111 (2) Industrial Maintenance Electrical Principles Lab
OR ___ ELT 110 (5) Circuits I
___ IMT 220 (3) Industrial Maintenance Electrical Motor Controls I
AND ___ IMT 221 (2) Industrial Maintenance Electrical Motor Controls I Lab
OR ___ EET 270 (2) Electrical Motor Controls I
AND ___ EET 271 (3) Electrical Motor Controls I Lab
OR ___ ELT 244 (4) Electrical Machinery and Controls
OR ___ IMT 120 (3) Industrial Maintenance Rotating Machinery
AND ___ IMT 121 (2) Industrial Maintenance Ratating Machinery Lab
OR ___ EET 264 (2) Rotating Machinery
AND ___ EET 265 (2) Rotating Machinery Lab
OR ___ IMT 280 (3) Advanced Programmable Logic Controllers
AND ___ IMT 281 (2) Advanced Programmable Logic Controllers Lab
OR ___ EET 276 (2) Programmable Logic Controllers
AND ___ EET 277 (2) Programmable Logic Controllers Lab
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 832247d1686210069-word-game-cows-and-bulls-cows-bulls
Sheet: Sheet1

secred word | PEAK
 |  | Cows | Bulls | Available?
1 | LIKE
2 | KITE
3 | PICK
4 | TEAK
5 | PEAK
6
7
8
9
10
 |  | Rules.
 |  | No letter should be repeated in the four letter word. (Column B)
 |  | Word is matched from B3 to B12 with cell B1. If letter is matched and in different position count as number of Cows (Column C)
 |  | Word is matched from B3 to B12 with cell B1. If letter is matched and in same position count as number of Bulls (Column D)
 |  | Once complete word is matched with Cell B1 then highlight the word .
Spreadsheet: 727273d1617812961-removing-duplicates-leaving-a-set-amount-cap-duplicates-sheet
Sheet: Sheet1

Company | [NAME]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
huawei | [EMAIL]
huawei | [EMAIL]
huawei | [EMAIL]
huawei | [EMAIL]
huawei | [EMAIL]
kbr | [EMAIL]
kbr | [EMAIL]
kbr | [EMAIL]
kbr | [EMAIL]
kbr | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
nokia | [EMAIL]
nokia | [EMAIL]
nokia | [EMAIL]
nokia | [EMAIL]
nokia | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
safarigroup | [NAME]
safarigroup | [NAME]
safarigroup | [NAME]
safarigroup | [NAME]
safarigroup | [NAME]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
tamu | [EMAIL]
tamu | [EMAIL]
tamu | [EMAIL]
tamu | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
Spreadsheet: 874800d1721309659-changing-a-period-by-a-coma-on-a-number-string-nerysprojectexcel
Sheet: Sheet4

Vendor’s inv. no. | Purchase orders | Contract no. | Amount | Invoice date | Amount FORMULA FORUM | I NEED
368438 | 20-8300-550-100 |  | 188.1 | 041624 |  | 188,10
365235 | 20-8300-550-100 |  | 47.03 | 020924 |  | 47,03
[PHONE] | 20-8300-459-103 |  | 5051.9 | 071024 |  | 5051,90
[PHONE] | NO GL |  | 89.03 | 062524 |  | 89,03
0017265 | 20-8300-459-174 |  | 1263.08 | 062024 |  | 1263,08
[PHONE] | 20-8300-451-157 |  | 935 | 071524 |  | 935,00
[PHONE] | 20.8300.459.173 |  | 3.59 | 061724 |  | 3,59
[PHONE] | 20.8300.459.173 |  | 2.57 | 062624 |  | 2,57
[PHONE] | 20.8300.459.173 |  | -48.94 | 070124 |  | -48,94
29502 | 20-8300-550-140 |  | 304.95 | 040224 |  | 304,95
1966 | 20.8300.531.167 |  | 359.93 | 032924 |  | 359,93
[PHONE] | 20-8300-230-109 |  | 320 | 062824 |  | 320,00
33081NT | 20.2130.000.174 |  | 32140 | 062524 |  | 32140,00
Spreadsheet: 856631d1705836827-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner8

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner8
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
2023-09-05 00:00:00 | MGT61102 | Tutor 1 | Video recording uploaded onto blackboard |  |  | PS to link
2023-09-06 00:00:00 | MGT61102 | Tutor 2 | Resources on blackboard |  |  | PS to complete
2023-09-11 00:00:00 | MGT61100 | Tutor 3 | (tutor to complete) |  |  | tutor to complete
Spreadsheet: 801762d1666358675-3-different-dates-formula-for-result-refunds-assistant
Sheet: Sheet1

Anniversary date | payment date | Left | Refund | Notes
25 | 1 | 15 | Yes | As B4 is less than C4 and A4 =refund
4 | 10 | 9 | No | As [NAME] is more than C5 and A5= no refund due
12 | 3 | 5 | Yes | As [NAME] is less than C6 and A6 =Refund
1 | 20 | 25 | No | As [NAME] is more than B7 and A7 = no refund due
12 | 12 | 9 | Yes | As C8 is less than B8 and A8 = refund
Spreadsheet: 00801d75-3591-4233-9454-eb162fccb10c
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 | Unnamed: 34 | Unnamed: 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev. 10/11
Center for Student Support and Education Options
Office of Quality School Choice and Funding
SF-6 Pre-School Form
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY-20
Report to Certify the Excess Cost for School District and DD Pre-School Pupils
Who Were Provided Special Education and Related Services
To be filed by educating district
Section I
A.
 |  | Educating District - City, Exempted Village, Local or DD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County |  |  |  |  |  |  |  | IRN
B.
 |  | Resident District - City, Exempted Village or Local |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County |  |  |  |  |  |  |  | IRN
Section II
Cost Per Pupil for Special Education and Related Services Provided by District A
 |  |  |  |  |  |  |  | Column C |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column D |  |  |  |  |  | Column E |  |  |  | Column F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual Cost |  |  |  |  |  | Total FTE |  |  |  | Cost Per Pupil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Students
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Served
Line 1 |  |  | Salary-Pre-school Teacher(s)
Line 2 |  |  | Administrator/Supervisor Expense
Line 3 |  |  | Maintenance, Operation Utilities Expense
Line 4 |  |  | Supplies/Material Expense
Line 5 |  |  | Equipment Expense
Line 6 |  |  | Remodeling Expense
Line 7 |  |  | Related Services for ADM
 |  |  | (A)
 |  |  | (B)
 |  |  | (C)
 |  |  | (D)
Line 8 |  |  | Contract Services
Line 9 |  |  | Total (add lines 1-8) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
City, Exempted Village, Local or DD Superintendent Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Treasurer Signature
Spreadsheet: 163635d1340383961-excel-2007-how-to-match-two-field-with-reference-field-stimulation_1
Sheet: Sheet3

Invoice# | DR | CR
a | 10
a |  | 10
b | 33
b |  | 31
c | 12
d | 22
d |  | 21
e | 43
e |  | 43
f | 16
f |  | 16
Spreadsheet: 779611d1651901828-way-to-hide-certain-dates-when-date-is-in-another-field-sample
Sheet: Sheet1

Dates - Week One |  |  |  |  |  |  | Dates - Week Two
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
All Dates
Dates - Week One |  |  |  |  |  |  | Dates - Week Two
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-05-06 00:00:00 | 2022-05-07 00:00:00 | 2022-05-08 00:00:00 | 2022-05-09 00:00:00 | 2022-05-10 00:00:00 | 2022-05-11 00:00:00 | 2022-05-12 00:00:00 | 2022-05-13 00:00:00 | 2022-05-14 00:00:00 | 2022-05-15 00:00:00
2022-05-16 00:00:00 | 2022-05-17 00:00:00 | 2022-05-18 00:00:00 | 2022-05-19 00:00:00 | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00 | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00
2022-05-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-01 00:00:00 | 2022-06-02 00:00:00 | 2022-06-03 00:00:00 | 2022-06-04 00:00:00 | 2022-06-05 00:00:00 | 2022-06-06 00:00:00 | 2022-06-07 00:00:00 | 2022-06-08 00:00:00 | 2022-06-09 00:00:00 | 2022-06-10 00:00:00 | 2022-06-11 00:00:00 | 2022-06-12 00:00:00
2022-06-13 00:00:00 | 2022-06-14 00:00:00 | 2022-06-15 00:00:00 | 2022-06-16 00:00:00 | 2022-06-17 00:00:00 | 2022-06-18 00:00:00 | 2022-06-19 00:00:00 | 2022-06-20 00:00:00 | 2022-06-21 00:00:00 | 2022-06-22 00:00:00 | 2022-06-23 00:00:00 | 2022-06-24 00:00:00 | 2022-06-25 00:00:00 | 2022-06-26 00:00:00
2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-05-06 00:00:00 | 2022-05-07 00:00:00 | 2022-05-08 00:00:00 | 2022-05-09 00:00:00 | 2022-05-10 00:00:00 | 2022-05-11 00:00:00 | 2022-05-12 00:00:00 | 2022-05-13 00:00:00 | 2022-05-14 00:00:00 | 2022-05-15 00:00:00
2022-05-16 00:00:00 | 2022-05-17 00:00:00 | 2022-05-18 00:00:00 | 2022-05-19 00:00:00 | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00 | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00
2022-05-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-01 00:00:00 | 2022-06-02 00:00:00 | 2022-06-03 00:00:00 | 2022-06-04 00:00:00 | 2022-06-05 00:00:00 | 2022-06-06 00:00:00 | 2022-06-07 00:00:00 | 2022-06-08 00:00:00 | 2022-06-09 00:00:00 | 2022-06-10 00:00:00 | 2022-06-11 00:00:00 | 2022-06-12 00:00:00
2022-06-13 00:00:00 | 2022-06-14 00:00:00 | 2022-06-15 00:00:00 | 2022-06-16 00:00:00 | 2022-06-17 00:00:00 | 2022-06-18 00:00:00 | 2022-06-19 00:00:00 | 2022-06-20 00:00:00 | 2022-06-21 00:00:00 | 2022-06-22 00:00:00 | 2022-06-23 00:00:00 | 2022-06-24 00:00:00 | 2022-06-25 00:00:00 | 2022-06-26 00:00:00
Holiday Dates
2022-04-15 00:00:00 | Good Friday
2022-04-16 00:00:00 | Saturday before Easter Sunday
2022-04-17 00:00:00 | Easter Sunday
2022-04-18 00:00:00 | Easter Monday
2022-04-25 00:00:00 | Anzac Day
2022-06-13 00:00:00 | Queen's Birthday
Spreadsheet: 135718d1326206026-track-dates-from-a-form-in-a-running-dates-table-leave-form
Sheet: Leave Form

 | Table
 | Employee ID | Agent Name English | Leave Type | Leave From | Leave To
 | 12345 | [NAME] | CL | 2012-01-10 00:00:00 | 2012-01-12 00:00:00
 | 12345 | [NAME] | PL | 2012-01-02 00:00:00 | 2012-01-05 00:00:00
 | 14923 | [NAME] | CL | 29/12/2011 | 2012-12-31 00:00:00
 | Employee ID | 2011-12-29 00:00:00
 | 12345 |  |  |  |  | PL | PL | PL | PL |  |  |  |  | CL | CL | CL
 | 14923 | CL | CL | CL
 | How do I pick cells highlighted in green automatically from the details provided in the Table?
Spreadsheet: 821851d1678943008-vstack-results-of-indirect-references-from-an-array-indirect_example_1
Sheet: data3

 |  | [NAME] | amount | account
Spreadsheet: 860721d1708708215-funky-date-lookup-dates
Sheet: Sheet1

As Is | 2023-08-14 00:00:00 |  |  |  |  |  | From date | Rate
As [NAME] | 082023 |  |  |  |  |  | 2019-01-01 00:00:00 | 0.575
 |  |  |  |  |  |  | 2020-01-01 00:00:00 | 0.56
 |  |  |  |  |  |  | 2020-09-01 00:00:00 | 0.545
 |  |  |  |  |  |  | 2021-05-31 00:00:00 | 0.56
 |  |  |  |  |  |  | 2022-01-01 00:00:00 | 0.585
 |  |  |  |  |  |  | 2022-07-01 00:00:00 | 0.625
 |  |  |  |  |  |  | 2023-02-01 00:00:00 | 0.655
 |  |  |  |  |  |  | 2024-01-01 00:00:00 | 0.67