tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 48106d1247260724-conditional-formatting-add-duplicates-add-matching
Sheet: Add matching

Customer Name | P/N | Amount
[NAME] | OPA2277U | 103 | 1984
[NAME] | OPA2277U | 1881
[NAME] | PTH12010WAH | 3032 | 239664
[NAME] | PTH12010WAH | 44243
[NAME] | PTH12010WAH | 192389
[NAME] | PTH12050WAH | 3088
[NAME] | PTH12050WAH | 48416
[NAME] | PTH12050WAH | 200447
[NAME] | PTN78000AAH | 1882
[NAME] | PTN78000AAH | 15655
[NAME] | PTN78000AAH | 53165
[NAME] | PTN78000HAH | 1852
[NAME] | PTN78000HAH | 15423
[NAME] | PTN78000HAH | 52367
[NAME] | PTN78060WAH | 3492
[NAME] | PTN78060WAH | 50840
[NAME] | PTN78060WAH | 204375
[NAME] | SN5404J | 21
[NAME] | SN5406J | 36
[NAME] | SN65LBC176D | 45
[NAME] | SN74LVC07ADR | 425
[NAME] | SN74LVC07ADR | 1063
[NAME] | [NAME] | 405
[NAME] | [NAME] | 660
[NAME] | SN74LVCC3245APWR | 6720
Spreadsheet: 717447d1612668178-inserting-additional-criteria-to-an-if-statement-worktimecalcef
Sheet: Sheet1

OVAL DAY | RPT | STRT | END | BRK | WT | RT | TOT RND | ST | OT | RND TME
 | 05:20:00 |  | 10:00:00 |  |  |  |  | 8
 | 13:47:00 |  | 19:05:00 |  |  |  |  | 7.5 | 2.5 | 11:15:00
Spreadsheet: 837649d1690320007-conditional-formatting-from-a-separate-range-roster-template-2023-07-25
Sheet: Summary

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  | P | C | 1B | 2B | 3B | SS | LF | LCF | RF | RCF | X
 |  |  |  | 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 | 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 | 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 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 550283d1512200859-only-those-values-are-required-which-are-to-the-left-of-stated-value-rev02
Sheet: Revised

SL No | Sequences | Output
1 | A1, [NAME], A7, A2, A8, A5 | A1, [NAME], A7, A2
2 | A3, A9, [NAME], A6, A5, A2C, A7, A4, A8 | A3, A9, [NAME], A6, A5, A2C
3 | A5, A7, [NAME], A4, B2, A0, A6 | A5, A7, [NAME], A4, B2
4 | A6, [NAME], BA2, A1 | A6, [NAME], BA2
5 | A5, A4, A6, [NAME], A9, A7, B2 | A5, A4, A6, [NAME], A9, A7, B2
6 | A1, A4, C2, A7, A8, A9, A5 | A1, A4, C2
7 | A4, C2AD, [NAME] | A4, C2AD
8 | A0, [NAME], C | A0, [NAME], C
9 | A5, A6, A7, A8, A9, D2, A0, A1 | A5, A6, A7, A8, A9, D2
10 | A0, A3, A5, D2C, A7, A8 | A0, A3, A5, D2C
11 | A7, A6, A5, A1, D2, A3, A0 | A7, A6, A5, A1, D2
12 | A0, A5, A6, A9, A3, AD2, [NAME], A7, A4 | A0, A5, A6, A9, [NAME], AD2
13 | A0, A9, A8, [NAME], A1, A3, A5, A4 | A0, A9, A8, D2
14 | A9, A6, E2, A0, A1 | A9, A6, E2
15 | A1, A9, A7, A6, EF2, A5 | A1, A9, A7, A6, EF2
16 | A5, A4, A6, [NAME], A9, A7, E2 | A5, A4, A6, [NAME], A9, A7, E2
17 | A1, A4, E2, A7, A8, A9, A5, A3 | A1, A4, E2
18 | A0, A5, A6, A9, A3, [NAME], A1 | A0, A5, A6, A9, A3, F2
19 | A0, A9, A8, FZ2, A1 | A0, A9, A8, FZ2
20 | A1, [NAME], A7, [NAME], A8, A5 | A1, [NAME], A7, F2
21 | A3, A9, [NAME], A6, A5, F2, A7, A4, A8 | A3, A9, [NAME], A6, A5, F2
22 | A5, A7, [NAME], A4, AG23, A0 | A5, A7, [NAME], A4, AG23
23 | A5, A4, A6, [NAME], A9, A7, G2, A1 | A5, A4, A6, [NAME], A9, A7, G2
24 | A7, A6, A5, A1, GF2, A3,A4 | A7, A6, A5, A1, GF2
25 | A6, [NAME], G, A1, A5 | A6, [NAME], G
Note: I have filled the Column "Output" (i.e. Column C) manually. I have retained only those values which are to the left of red coloured one's and including red coloured one's. To the right of the red coloured one's must be deleted.
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 19

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا ([NAME])
يادداشتهاي [NAME] مالي
دوره مالي شش ماهه منتهي به 31 خرداد ماه 1390
8-1 موجودی موادوکالا از اقلام زيرتشکيل [NAME]:
 |  |  |  |  |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  | ریال
لوازم یدکی |  |  |  | 1232875385 |  |  |  |  |  | 592232220
[NAME] |  |  |  | 1962349061 |  |  |  |  |  | 0
[NAME] |  |  |  | 1745994700 |  |  |  |  |  | 0
مصالح [NAME] |  |  |  | 1038080320 |  |  |  |  |  | 1958180102
آهن آلات [NAME] |  |  |  | 5506682332 |  |  |  |  |  | 0
ملزومات اداری |  |  |  | 22195431 |  |  |  |  |  | 0
مواد غذایی |  |  |  | 6234872 |  |  |  |  |  | 0
داراییهای نزد انبار |  |  |  | 20403949 |  |  |  |  |  | 0
موادولوازم مصرفی |  |  |  | 1796600549 |  |  |  |  |  | 0
کالای امانی نزد دیگران |  |  |  | 0 |  |  |  |  |  | 527170319
9- | پيش پرداختها
 | [NAME] سفارشات وپيش پرداختها ازاقلام زيرتشکيل [NAME]:
 |  | يادداشت |  | 1390/03/31 |  |  |  | 1390/03/31 |  | 1389/09/30
 |  |  |  | ریال
 | وزارت دارايی-ماليات عملکرد | 17 |  | 13525562507 |  |  |  |  |  | 22815498447
 | پیش پرداخت خرید جاری | 9-1 |  |  |  | 0 |  |  |  | 0
 | پیش پرداخت به پیمانکاران | 9-2 |  |  |  | 0
 | ساير پيش پرداختها | 9-3 |  | 12015101799
 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 1390/03/31 |  | 1389/09/30
9-1 | پیش پرداخت خرید جاری به شرح زیر میباشد :
 | دفتر مرکزی |  |  | 19611958107 |  | 0 |  |  |  | 0
 | نازک کاری موننکو |  |  | 12164428055 |  | 0 |  |  |  | 0
 | سایر |  |  | 1730602295 |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  | 1390/03/31 |  | 1389/09/30
9-2 | پیش پرداخت پیمانکاران به شرح زیر میباشد :
 | دفتر مرکزی |  |  | 2910320666 |  | 0 |  |  |  | 0
 | [NAME] |  |  | 7565670525 |  | 0 |  |  |  | 0
 | سایر |  |  | 597979127 |  | 0 |  |  |  | 0
9-3 | ساير پیش پرداختها به قرار زير مي باشد : |  |  |  |  |  |  | 1390/03/31 |  | 1389/09/30
بيمه |  |  |  | 12015101799 |  | 0 |  |  |  | 9057210375
حسابرسي |  |  |  | 0 |  | 0 |  |  |  | 398688250
 |  |  |  |  | 0
Spreadsheet: benjamin_rogers__1171__Gleason - 501F & 501FD
Sheet: Value

COPIED TO THE CONSOLIDATED FILE
Plant Summary
Capacity
Heat Rate
No. of Turbines
Operating Hours
Start Up MMBTU's
Book Income 1999 Costs
 |  | 1999
Fixed Operating Cost
Variable Operating Cost
Start Fuel
Major [NAME].
Insurance
SG&A Cost
Utility: Start Up Power
Property Taxes & Other |  | 0
Debt Service
Admin Fees
O&M Fees
Variable Revenue
Variable Energy Payment
Start Payment/Turbine
Consolidated Check
 |  | 2000
EGC EITDA
Calvert City
Plus : L/C
Less:  Interest
Difference
Spreadsheet: 166775d1341796533-comparing-and-mark-data-from-two-different-worksheet-comparing-and-mark-between-two-worksheets
Sheet: Sheet2

Serial Number | Operation Number
112439213 | 0500
112361314 | 1300
360010280 | 0240
112439221 | 0500
112329491 | 2930
112338449 | 1400
112338449 | 1500
112402340 | 0600
112402343 | 0600
Spreadsheet: 849245d1699773932-excel-map-chart-without-data-challenge_sales_by_state
Sheet: Report

State | Total Sales
West Virginia | 15572
Wisconsin | 18449
Montana | 10390
New York | 39305
Washington | 19936
Florida | 22174
Utah | 4252
Tennessee | 3751
Pennsylvania | 40215
Colorado | 19892
South Carolina | 11955
Missouri | 11460
Ohio | 28591
Minnesota | 23560
California | 29919
Nevada | 5518
Iowa | 13462
Texas | 45669
Maryland | 7324
Arkansas | 13524
Connecticut | 5168
Kansas | 18976
North Dakota | 6515
Idaho | 6941
North Carolina | 19149
New Jersey | 16991
South Dakota | 7713
Oregon | 8889
Arizona | 9783
Wyoming | 4418
New Mexico | 10000
Spreadsheet: 726190d1617103257-vlookup-that-picks-up-the-dates-against-each-of-the-sites-book2
Sheet: Sheet1

Site Name | Date |  |  | NAME | DATE
Addison Road |  |  |  | 36-52 Soprano Way | 05.03.2021
Addison Road |  |  |  | 72-92 Soprano Way | 05.03.2021
Addison Road |  |  |  | [NAME], Chitterne | 15.03.2021
36-52 Soprano Way |  |  |  | [NAME], [NAME] | 15.03.2021
36-52 Soprano Way |  |  |  | Addison Road | 25.03.2021
[NAME], College Road Estate |  |  |  | Alcock Crest, Alcock Crest Estate | 12.03.2021
36-52 Soprano Way |  |  |  | Aldeburgh Place, [NAME] | 15.03.2021
36-52 Soprano Way |  |  |  | [NAME], College Road Estate | 09.03.2021
[NAME], College Road Estate |  |  |  | [NAME], Mascroft Road | 08.03.2021
Spreadsheet: 839589d1692103899-weekly-reporting-formula-check-jul_wk4-data_test-1-
Sheet: NA

Agent's name: |  | Date:
Weekly RingCentral Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Weekly CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Previous Week Stats |  |  |  |  |  |  |  |  | Service Cloud Cases |  |  |  | Previous Week's CSC RingCentral Stats
Skills | Count | [NAME] | Sum of Hold | Sum ACW Mins | [NAME] | [NAME] | AHT | % | Service Cloud | Cases Created | Cases Closed |  | [NAME] | Count | Sum of Agent_Time | Sum of Hold | Sum of ACW | [NAME] | [NAME] | AHT
CSC - After HRS VM Messages |  |  |  |  |  |  |  |  | CSC |  |  |  | CSC - After HRS VM Messages
CSC - Email Skill |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Email Skill
CSC - Inbound Support |  |  |  |  |  |  |  |  | % |  |  |  | CSC - Inbound Support
CSC - Outbound Support |  |  |  |  |  |  |  |  |  |  |  |  | CSC - Outbound Support
Total |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 869945d1716472599-change-date-from-dd-mm-yyyy-to-mm-yyyy-example_excel2-aligw
Sheet: Data1

PERMNO | Date | LOGMB | Date_Correct | Unique
10225 | 1970-01-31 00:00:00 | 0.3444750915159587 | 1970-01-31 00:00:00
10225 | 1970-02-28 00:00:00 | 0.2296120503763776 | 1970-02-28 00:00:00
10225 | 1970-03-31 00:00:00 | 0.2296120503763776 | 1970-03-31 00:00:00
10225 | 1970-04-30 00:00:00 | 0.2296120503763776 | 1970-04-30 00:00:00
10225 | 1970-05-31 00:00:00 | 0.2296120503763776 | 1970-05-31 00:00:00
10225 | 1970-06-30 00:00:00 | 0.223333 | 1970-06-30 00:00:00
10225 | 1970-07-31 00:00:00 | 0.2296120503763776 | 1970-07-31 00:00:00
10225 | 1970-08-31 00:00:00 | 0.2296120503763776 | 1970-08-31 00:00:00
10225 | 1970-09-30 00:00:00 | 0.2296120503763776 | 1970-09-30 00:00:00
10225 | 1970-10-31 00:00:00 | 0.2296120503763776 | 1970-10-31 00:00:00
10225 | 1970-11-30 00:00:00 | 0.2296120503763776 | 1970-11-30 00:00:00
10225 | 1970-12-31 00:00:00 | 0.2296120503763776 | 1970-12-31 00:00:00
10225 | 1971-01-31 00:00:00 | 0.2296120503763776 | 1971-01-31 00:00:00
10225 | 1971-02-28 00:00:00 | 0.3970100328581173 | 1971-02-28 00:00:00
Spreadsheet: 782004d1653679883-sumproduct-error-using-2-arrays-sample-sumproduct
Sheet: Employees

name | area
red | 1
yellow | 2
blue | 3
yellow | 4 |  |  |  | Sum of | $ [NAME] | Total cost
blue | 5 |  |  |  | yellow
black | 6
red | 1
green | 2
red | 3
Spreadsheet: 5f508ba1-5bb3-4836-82cc-28db5688b2e4
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15
 |  |  |  |  |  | 2/ | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 2.995 | 3.135 | 3.636 | 2.689 | 2.7 | 2.489 | 2.877
Harvested | 2.976 | 3.103 | 3.615 | 2.617 | 2.679 | 2.468 | 2.852
 |  |  |  | Pounds per harvested acre
Yield | 6846 | 7085 | 6725 | 7067 | 7449 | 7694 | 7468
 |  |  |  | Million cwt
Beginning stocks | 29.492 | 30.419 | 36.499 | 48.467 | 41.079 | 36.423 | 32.309
Production | 203.733 | 219.85 | 243.104 | 184.941 | 199.546 | 189.886 | 213
Imports | 19.218 | 19.023 | 18.338 | 19.359 | 21.062 | 22 | 22
Total supply | 252.443 | 269.292 | 297.941 | 252.767 | 261.687 | 248.309 | 267.309
Food, industrial,
& residual 3/ | 123.77 | 119.947 | 133.603 | 107.505 | 115.105
Seed | 3.87 | 4.488 | 3.324 | 3.332 | 3.067
Total domestic use | 127.64 | 124.435 | 136.927 | 110.837 | 118.172 | 124 | 128
Exports | 94.384 | 108.358 | 112.547 | 100.851 | 107.092 | 92 | 102
Rough | 31.633 | 40.351 | 34.595 | 32.94 | 34.165 | 31.5 | 34
Milled 4/ | 62.751 | 68.007 | 77.952 | 67.911 | 72.927 | 60.5 | 68
Total use | 222.024 | 232.793 | 249.474 | 211.688 | 225.264 | 216 | 230
Ending stocks | 30.41899999999998 | 36.49900000000002 | 48.46700000000004 | 41.07900000000004 | 36.423 | 32.309 | 37.30899999999997
 |  |  |  | Percent
Stocks-to-use ratio | 13.70077108781032 | 15.6787360444687 | 19.42767582994622 | 19.40544575034959 | 16.16902834008097 | 14.95787037037037 | 16.22130434782607
 |  |  |  | $/cwt
Average farm |  |  |  |  |  | 15.70 to | 14.40 to
price 5/ | 16.8 | 14.4 | 12.7 | 14.5 | 15.1 | 16.3 | 15.4
 |  |  |  | Percent
Average
milling rate | 70.83 | 71.53 | 68.86 | 69.93 | 70 | 71 | 70.5
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated June 11, 2014.
Spreadsheet: 76070d1276642721-excel-2007-rounding-to-the-nearest-quarter-hour-2010-06-sample-timesheet
Sheet: TimeSheet

 |  |  |  |  |  | Employee Name: | Employee
 |  |  |  |  |  | Month Starting: | 2010-06-01 00:00:00
Weekly Employee Time Sheet
Day of Week | Time In | Time Out |  | Time In | Time Out | Total Hrs | Regular Hours | OT | Sick | Vac.
Balance Forward
2010-06-01 00:00:00 | 07:38:00 | 18:43:00 |  |  |  | 11.08 | no lunch taken
2010-06-02 00:00:00 | 07:47:00 | 13:16:00 |  | 14:08:00 | 17:26:00 | 5
2010-06-03 00:00:00 | 07:53:00 | 12:23:00 |  | 13:17:00 | 17:21:00 | 8.57
2010-06-04 00:00:00 | 07:43:00 | 12:09:00 |  | 13:02:00 | 17:28:00 | 8.87
2010-06-05 00:00:00 |  |  |  |  |  | 0
2010-06-06 00:00:00 |  |  |  |  |  | 33.52 | 33.52083333333334
2010-06-07 00:00:00 | 07:33:00 | 12:11:00 |  | 13:04:00 | 17:24:00 | 8
2010-06-08 00:00:00 | 07:38:00 | 12:17:00 |  | 13:12:00 | 17:11:00 | 10
2010-06-09 00:00:00 | 07:37:00 | 15:15:00 |  |  |  | 10 | left early no lunch
2010-06-10 00:00:00 | 07:52:00 | 17:16:00 |  |  |  | 10 | mgrs mtng
2010-06-11 00:00:00 | 07:43:00 |  |  |  |  | 10.25 | HfH lunch mtng
2010-06-12 00:00:00 |  |  |  |  |  | 0
2010-06-13 00:00:00 |  |  |  |  |  | 48.25 | 40 | 8.25
2010-06-14 00:00:00 |  |  |  |  |  | 0
2010-06-15 00:00:00 |  |  |  |  |  | 0
2010-06-16 00:00:00 |  |  |  |  |  | 0
2010-06-17 00:00:00 |  |  |  |  |  | 0
2010-06-18 00:00:00 |  |  |  |  |  | 0
2010-06-19 00:00:00 |  |  |  |  |  | 0
2010-06-20 00:00:00 |  |  |  |  |  | 0
2010-06-21 00:00:00 |  |  |  |  |  | 0
2010-06-22 00:00:00 |  |  |  |  |  | 0
2010-06-23 00:00:00 |  |  |  |  |  | 0
2010-06-24 00:00:00 |  |  |  |  |  | 0
2010-06-25 00:00:00 |  |  |  |  |  | 0
2010-06-26 00:00:00 |  |  |  |  |  | 0
2010-06-27 00:00:00 |  |  |  |  |  | 0
2010-06-28 00:00:00 |  |  |  |  |  | 0
2010-06-29 00:00:00 |  |  |  |  |  | 0
2010-06-30 00:00:00 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | Total | 73.52083333333334 | 8.25 | 0 | 0
Employee Signature |  |  | Date
Approving Official |  |  | Date
Spreadsheet: john_lavorato__16616__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 140093d1328622649-daily-food-calculator-feb-food-total-values
Sheet: Main

 |  | Date | Total Cost | Daily Points |  | Montly Total
 |  | 2012-02-01 00:00:00
 |  | 2012-02-02 00:00:00 |  |  |  | Total Eaten | Total Spent | Total Remaining
 |  | 2012-02-03 00:00:00
 |  | 2012-02-04 00:00:00 |  |  |  | TARGET: $8.62
 |  | 2012-02-05 00:00:00
 |  | 2012-02-06 00:00:00
 |  | 2012-02-07 00:00:00
 |  | 2012-02-08 00:00:00
 |  | 2012-02-09 00:00:00
 |  | 2012-02-10 00:00:00
 |  | 2012-02-11 00:00:00
 |  | 2012-02-12 00:00:00
 |  | 2012-02-13 00:00:00
 |  | 2012-02-14 00:00:00
 |  | 2012-02-15 00:00:00
 |  | 2012-02-16 00:00:00
 |  | 2012-02-17 00:00:00
 |  | 2012-02-18 00:00:00
 |  | 2012-02-19 00:00:00
 |  | 2012-02-20 00:00:00
 |  | 2012-02-21 00:00:00
 |  | 2012-02-22 00:00:00
 |  | 2012-02-23 00:00:00
 |  | 2012-02-24 00:00:00
 |  | 2012-02-25 00:00:00
 |  | 2012-02-26 00:00:00
 |  | 2012-02-27 00:00:00
 |  | 2012-02-28 00:00:00
 |  | 2012-02-29 00:00:00
Spreadsheet: 094f22d1-c1ba-4d8c-9d3f-0c6c1dbd6c32
Sheet: Sheet1

Subjekt | Název subjektu | Adresa subjektu | Počet žáků denního studia k 30. 9. 2010 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  | 4-leté | 6-leté | 8-leté
1800 | Gymnázium | [NAME], [NAME] 13 | 123 | 0 | 466 | ,
1801 | Gymnázium | Boskovice, Palackého náměstí 1 | 236 | 0 | 241
2798 | Gymnázium | Brno - Řečkovice, [NAME] | 0 | 0 | 497
2803 | Gymnázium Matyáše Lercha | Brno, [NAME] 55 | 338 | 251 | 234
2806 | Gymnázium | Brno, třída Kapitána Jaroše 14 | 252 | 0 | 494
2808 | [NAME] a španělské gymnázium | Brno - Bystrc, Vejrostova 2 | 92 | 367 | 314
3800 | Gymnázium [NAME] | Ivančice, [NAME] | 122 | 0 | 231
3801 | Gymnázium | Tišnov, Na Hrádku 20 | 242 | 0 | 241
3802 | Gymnázium   T.G.Masaryka | Zastávka, U školy 39 | 127 | 0 | 229
3803 | Gymnázium | Židlochovice, Tyršova 400 | 0 | 0 | 237
3804 | Gymnázium a Základní umělecká škola | Šlapanice, [NAME] 17 | 0 | 0 | 251
4800 | Gymnázium a JŠ s právem SJZ | [NAME], Sady 28.října 1 | 254 | 0 | 299
4801 | Gymnázium [NAME] | Hustopeče, [NAME] náměstí 7 | 101 | 0 | 220
4802 | Gymnázium | Mikulov, Komenského náměstí 7 | 72 | 0 | 215
5800 | Gymnázium | Hodonín, Legionářů 1 | 224 | 0 | 231
5801 | Klvaňovo gymnázium | Kyjov, Komenského 549 | 185 | 0 | 413
5802 | Purkyňovo gymnázium | Strážnice, [NAME] 379 | 245 | 0 | 230
6800 | Gymnázium | Bučovice, Součkova 500 | 128 | 0 | 229
6801 | Gymnázium | Vyškov, Komenského náměstí 16 | 252 | 0 | 437
7800 | Gymnázium | [NAME], [NAME] 168 | 117 | 0 | 195
7801 | Gymnázium Dr. [NAME] | Znojmo, Komenského nám.4 | 361 | 140 | 224
7802 | Gymnázium a SOŠ pedagogická | Znojmo, [NAME] 3 | 114 | 0 | 266
Pozn.:
jen osmileté studium
Ostatní gymnázia  [NAME] i 6-letých a 4-letých oborů - nelze rozpočtově oddělit
Spreadsheet: 767505d1644502579-also-validate-if-file-available-or-not-in-my-located-folder-with-out-vba-please-dg-help
Sheet: Sheet1

DATA WITH ME
 |  | solved | solved | need help | ALSO VALIDATE IF FILE AVAILABLE OR NOT IN MY LOCATED FOLDER WITH OUT VBA PLEASE
SPEF-SB-16307-10-02-2022 |  |  |  |  | THIS IS HYUPERLINK IF FILE AVAIABLE IN THE FOLDER THEN APPEAR AS GD, IF NOT AVAILABLE THEN -
SPEF-SB-16305-10-02-2022
SPEF-SB-926304-10-02-2022 |  |  |  |  | HYPERLINK("file:///D:\EXP\tracking\M\GD\"&A5&"-DG.pdf","-")
LPAE-SB-840-09-02-2022 |  |  |  |  | HYPERLINK("file:///D:\EXP\tracking\M\GD\"&A6&"-DG.pdf","GD")
LPAE-SB-79839-09-02-2022
IPAE-SB-023-08-02-2022
SPEF-SB-16123-08-02-2022
SPEF-SB-16044957-05-02-2022
SPEF-SB-16122-08-02-2022
SPEF-SB-16044957-05-02-2022
 | I DON’T NEED
 | DPEF-SB- |  | LAST 11 WORDS EG -10-02-2022 OR 09-02-2022
 | IPAE-SB-
 | LPAE-SB-
 | SPEF-SB-
Spreadsheet: 33076d1229361802-help-with-bingo-spreadsheet-randomnumbers
Sheet: Sheet1

Number | Rand()
23 | 0.2179076806087492
27 | 0.2826582585259934
21 | 0.1980839837807449
58 | 0.5941317106954338
18 | 0.1788577398553617
75 | 0.7731901195071178
66 | 0.7114906794039255
74 | 0.7612894259525209
78 | 0.8347792797079068
54 | 0.5786330113524265
89 | 0.966131492180728
57 | 0.5887117069299261
87 | 0.949000758804595
34 | 0.34777921992751
73 | 0.751045908076118
25 | 0.2331902155552763
37 | 0.3724339683685758
82 | 0.8853303477827859
5 | 0.04067257473986796
63 | 0.6566835202432506
48 | 0.5001793089642099
44 | 0.4723203375056562
80 | 0.8693616430491726
22 | 0.2120233859243763
47 | 0.493000163299705
88 | 0.9659307664025523
60 | 0.6173838394657993
52 | 0.5380143936152528
6 | 0.05068669539802695
1 | 0.005362504022661863
81 | 0.876479006562152
12 | 0.111650446895303
70 | 0.7303659587708877
15 | 0.1354080888883402
7 | 0.05416797238926851
20 | 0.1949838350060857
16 | 0.1475705947674806
49 | 0.5021382114267612
65 | 0.7107014222215771
3 | 0.009994638108321574
36 | 0.3686678618261789
85 | 0.8983979949028658
39 | 0.3780349410446258
84 | 0.8924829992695964
30 | 0.2868628267062423
46 | 0.4911480820056486
76 | 0.7766403774752346
59 | 0.5964741842792254
19 | 0.1842908062724904
14 | 0.1313354021281479
8 | 0.05631130054024291
26 | 0.2446096057256636
50 | 0.5222648317426872
38 | 0.3742395449312852
61 | 0.6178977701519017
56 | 0.5853276618268533
68 | 0.714293801525784
32 | 0.2907517847249919
64 | 0.684604784145032
69 | 0.7149120883593518
35 | 0.3629467771942947
67 | 0.7116258251681471
10 | 0.08855597637263912
86 | 0.9195709556888219
33 | 0.3176828199194484
17 | 0.1743014289023039
4 | 0.02566024952693846
24 | 0.2206376040626272
11 | 0.09323649906142095
83 | 0.8869842822151708
29 | 0.2839626351922577
2 | 0.008367223163151971
40 | 0.3858256853155084
41 | 0.4053824836077116
45 | 0.4726985113352644
55 | 0.5834068236318215
79 | 0.8497418881189791
51 | 0.5264102164937912
9 | 0.08606318552299186
42 | 0.4378720213030426
53 | 0.552448217181833
77 | 0.8052679427820135
72 | 0.7477930621548174
31 | 0.2869904224621274
71 | 0.7442660005527946
62 | 0.647718428995482
43 | 0.4540181646291428
13 | 0.1237218228113921
28 | 0.2833488306818286