tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 600094d1543461222-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T1 Cine

First name | Surname | ID number | Institution | Department | Email address | Assignment: CINE1 - Think Like a Cinematographer | Quiz: CINE1 - Lesson Quiz (ref. lesson 2) | Assignment: Professionalism | Assignment: T1 CINE Lesson 2 Assignment (composition, 12 stills) | Assignment: T1 CINE FINAL EXAM | Attendance: Attendance | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | - | 70 | - | - | - | - | 87
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | - | - | - | - | - | - | -
Muxin | [NAME] |  |  |  | [EMAIL] | - | 97.5 | - | - | - | - | 94
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | - | - | - | - | - | - | 100
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | - | 100 | - | - | - | - | 89
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | - | 77.5 | - | - | - | - | 82
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | - | 100 | - | - | - | - | 98
Yichao | Fu |  |  |  | [EMAIL] | - | - | - | - | - | - | -
Junjie (Riol) | He |  |  |  | [EMAIL] | - | 100 | - | - | - | - | 89
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | - | 100 | - | - | - | - | 94
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | - | 100 | - | - | - | - | 96
[NAME]) | [NAME] |  |  |  | [NAME] | - | 100 | - | - | - | - | 90
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | - | 100 | - | - | - | - | 96
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | - | 100 | - | - | - | - | 71
[NAME]) | [NAME] |  |  |  | [EMAIL] | - | - | - | - | - | - | -
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | - | 70 | - | - | - | - | 76
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | - | - | - | - | - | - | 76
[NAME]） | Xiao |  |  |  | [EMAIL] | - | 50 | - | - | - | - | 77
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | - | 67.5 | - | - | - | - | 78
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | - | 100 | - | - | - | - | 87
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | - | 97.5 | - | - | - | - | 90
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | - | 90 | - | - | - | - | 100
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | - | 90 | - | - | - | - | 89
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | - | - | - | - | - | - | 80
Spreadsheet: 88272d1288135343-excel-2007-filter-out-discrepancies-db-example
Sheet: Sheet1

Hotel Name | HotelCity | HotelCounty | HotelCountry
Hotel 1 | Ab11 7 | Aberdeen | Scotland
Hotel 2 | Ab11 7 | Aberdeen | Scotland
Hotel 3 | Ab11 7 | Aberdeen | Scotland
Hotel 4 | Ab11 7 | Aberdeen | Scotland
Hotel 5 | [NAME] | Greater-London | England
Hotel 6 | Abbotskerswell | [NAME] | England
Hotel 7 | [NAME] | Bedfordshire | England
Hotel 8 | Aberaeron | Ceredigion | Wales
Hotel 9 | Aberargie | Perth-and-Kinross | Scotland
Hotel 10 | Abercairny | Perth-and-Kinross | Scotland
Hotel 11 | Abercairny | Perth-and-Kinross | Scotland
Hotel 12 | Aberconway | Conwy | Wales
Hotel 13 | Aberconway | Conwy | Wales
Hotel 14 | Aberdeen | Aberdeen | England
Hotel 15 | Aberdeen | Aberdeen | Scotland
Hotel 16 | Aberdeen | Aberdeen | Scotland
Hotel 17 | Aberdeen | Aberdeen | Scotland
Hotel 18 | Aberdeen | Aberdeen | Scotland
Hotel 19 | Aberdeen | Aberdeen | Scotland
Hotel 20 | Aberdeen | Aberdeen | Scotland
Hotel 21 | Aberdeen | Aberdeen | Scotland
Hotel 22 | Aberdeen | Aberdeen | Scotland
Hotel 23 | Aberdeen | Aberdeen | Scotland
Hotel 24 | Aberdeen | Aberdeen | Scotland
Hotel 25 | Aberdeen | Aberdeen | Scotland
Hotel 26 | Aberdeen | Aberdeen | Scotland
Hotel 27 | Aberdeen | Aberdeen | Scotland
Hotel 28 | Aberdeen | Aberdeen | Scotland
Hotel 29 | Aberdeen | Aberdeen | Scotland
Hotel 30 | Aberdeen | Aberdeen | Scotland
Hotel 31 | Aberdeen | Aberdeen | Scotland
Hotel 32 | Aberdeen | Aberdeen | Scotland
Hotel 33 | Aberdeen | Aberdeen | Scotland
Hotel 34 | Aberdeen | Aberdeen | Scotland
Hotel 35 | Aberdeen | Aberdeen | Scotland
Hotel 36 | Aberdeen | Aberdeen | Scotland
Hotel 37 | Aberdeen | Aberdeen | Scotland
Spreadsheet: 02e5e6bb-d0a2-4b92-bad7-235fb9eb0998
Sheet: Sheet1

Category | FY01 | FY02 | FY03 | FY04 | FY05 | %(04-05) | %(01-05) | FY06 | %(05-06) | %(01-06)
Vols. Add
cklist | 1638 | 1372 | 1152 | 859 | 922 | 0.07 | -0.44 | 853 | -0.07 | -0.48
binding | 5508 | 4368 | 4795 | 3886 | 4129 | 0.06 | -0.25 | 2808 | -0.32 | -0.49
firm ord | 3629 | 3308 | 2961 | 2880 | 3786 | 0.31 | 0.04 | 4148 | 0.1 | 0.14
approv. | 2901 | 3991 | 3354 | 2967 | 2934 | -0.01 | 0.01 | 3347 | 0.14 | 0.15
st. ord. | 232 | 219 | 181 | 243 | 182 | -0.25 | -0.22 | 144 | -0.21 | -0.4
gifts | 2607 | 1865 | 2147 | 2465 | 3453 | 0.4 | 0.32 | 3134 | -0.09 | 0.2
total | 16515 | 15123 | 14590 | 13300 | 15406 | 0.16 | -0.07 | 14434 | -0.06 | -0.13
Vols.wtdr. | 1940 | 4584 | 1684 | 896 | 868 | -0.03 | -0.55 | 813 | -0.06 | -0.58
III Activity
bib.new | 97 | 387 | 159 | 121 | 141 | 0.17 | 0.45 | 37 | -0.74 | -0.62
bib.upd. | 18965 | 22773 | 16346 | 17636 | 14652 | -0.17 | -0.23 | 14243 | -0.03 | -0.25
bib.del. | 3507 | 23160 | 8258 | 3846 | 3336 | -0.13 | -0.05 | 614 | -0.82 | -0.82
item new | 10424 | 10330 | 10097 | 8244 | 7418 | -0.1 | -0.29 | 9474 | 0.28 | -0.09
item upd. | 29982 | 20109 | 5753 | 15874 | 13848 | -0.13 | -0.54 | 6647 | -0.52 | -0.78
[NAME]. | 6367 | 10850 | 9645 | 3950 | 1669 | -0.58 | -0.74 | 1415 | -0.15 | -0.78
ord. New |  | 4383 | 6007 | 6122 | 7017 | 0.15 |  | 7404 | 0.06
ord.upd. |  | 3878 | 10370 | 12551 | 13124 | 0.05 |  | 17980 | 0.37
ord.del. |  | 2407 | 8226 | 10539 | 6850 | -0.35 |  | 8310 | 0.21
checkins | 41033 |  |  |  | 21000 |  | -0.49 | 18485 | -0.12 | -0.55
Non-book
mfilm | 544 | 611 | 576 | 224 | 190 | -0.15 | -0.65 | 173 | -0.09 | -0.74
mfiche | 16064 | 15204 | 13767 | 15266 | 2740 | -0.82 | -0.83 | 0
media |  | n/a | 283 | 207 | 290 | 0.4 |  | 453 | 0.56
Catalog
LC | 7146 | 7033 | 6081 | 6139 | 5340 | -0.13 | -0.25 | 7713 | 0.44 | 0.08
edit. | 9107 | 5960 | 8573 | 6264 | 7420 | 0.18 | -0.19 | 6824 | -0.08 | -0.25
orig. | 1553 | 1377 | 674 | 1270 | 1313 | 0.03 | -0.15 | 1576 | 0.2 | 0.01
Inventory
bcod scan |  |  | 15899 | 11547 | 19457 | 0.69 |  | 20023 | 0.03
corr. |  |  | 968 | 915 | 1487 | 0.63 |  | 1573 | 0.06
items fnd |  |  | 276 | 748 | 362 | -0.52 |  | 249 | -0.31
Vols./proc. | 17029 | 16265 | 14928 | 13487 | 13750 | 0.02 | -0.19 | 15215 | -0.11 | 0.11
Spreadsheet: 63ee95f8-2b16-47c0-b8ef-28dd2949341a
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
TPPA | Test | TPPA | [NAME] by TP-PA, Serum | [NAME] by TP-PA, S | Particle Agglutination | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Monday through Friday; 9 a.m. | Same day/1 day | 4 days | 1 | 86780 |  |  |  |  | Rochester
TPPA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
TPPA | Result | 61480 | [NAME] by TP-PA, S | [NAME] by TP-PA, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24312-1 | Treponema pallidum [NAME]:ACnc:Pt:Ser:Ord:Aggl
Spreadsheet: 99316d1297978255-excel-2007-inserting-vertical-line-into-chart-trial_2
Sheet: Sheet1

Scale 1 | [NAME] | COMPOSITE [NAME] | Scale 3 | [NAME] | Scale 5 | [NAME] | Scale 7 | [NAME] | CORE SCALES
1 | 2 | 0 | 3 | 4 | 5 | 6 | 7 | 9 | 0
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
Spreadsheet: 784950d1656025781-count-unique-id-numbers-with-a-condition-count-unique
Sheet: Summary

Date | Week Number | Unique | Value
2022-01-01 00:00:00
2022-01-02 00:00:00
2022-01-03 00:00:00
2022-01-04 00:00:00
2022-01-05 00:00:00
2022-01-06 00:00:00
2022-01-07 00:00:00
2022-01-08 00:00:00
2022-01-09 00:00:00
2022-01-10 00:00:00
2022-01-11 00:00:00
2022-01-12 00:00:00
2022-01-13 00:00:00
2022-01-14 00:00:00
2022-01-15 00:00:00
2022-01-16 00:00:00
2022-01-17 00:00:00
2022-01-18 00:00:00
2022-01-19 00:00:00
2022-01-20 00:00:00
2022-01-21 00:00:00
2022-01-22 00:00:00
2022-01-23 00:00:00
2022-01-24 00:00:00
2022-01-25 00:00:00
2022-01-26 00:00:00
2022-01-27 00:00:00
2022-01-28 00:00:00
2022-01-29 00:00:00
2022-01-30 00:00:00
2022-01-31 00:00:00
Spreadsheet: 705890d1606361606-roundup-not-working-for-ranges-in-same-row-roundup
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | CONDITIONAL FORMATTING
 | No. | Name | COURSE 1 | COURSE 2 | COURSE 3 | COURSE 4 | COURSE 5 | COURSE 6 | COURSE 7 | COURSE 8 | COURSE 9 | Q1 | Q2 | Q3 | Q4
 | 1 | EMP 1 | 2020-01-01 00:00:00 | 2020-01-01 00:00:00
 | 2 | EMP 2 | 2020-01-01 00:00:00
 | 3 | EMP 3 | 2020-01-01 00:00:00
 | 4 | EMP 4 | 2020-01-01 00:00:00 |  | 2020-03-07 00:00:00
 | 5 | EMP 5 | 2020-01-01 00:00:00 |  | 2020-03-07 00:00:00
 | 6 | EMP 6 | 2020-01-01 00:00:00 |  | 2020-03-07 00:00:00
 | 7 | EMP 7 | 2020-01-01 00:00:00 |  | 2020-03-07 00:00:00
 | 8 | EMP 8 | 2020-01-01 00:00:00 |  | 2020-03-07 00:00:00
 | 9 | EMP 9 | 2020-01-01 00:00:00 |  | 2020-03-07 00:00:00
 | 10 | EMP 10 | 2020-01-01 00:00:00 |  | 2020-03-07 00:00:00
 | No. | Name | COURSE 1 | COURSE 2 | COURSE 3 | COURSE 4 | COURSE 5 | COURSE 6 | COURSE 7 | COURSE 8 | COURSE 9 | Q1 | Q2 | Q3 | Q4
 | 1 | EMP 1 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00 | 2020-07-01 00:00:00
 | 2 | EMP 2 | 2020-07-02 00:00:00 | 2020-04-02 00:00:00 | 2020-12-25 00:00:00
 | 3 | EMP 3 | 2020-07-03 00:00:00 | 2020-04-03 00:00:00 | 2020-12-25 00:00:00
Spreadsheet: 0bcd5ad7-934f-4994-970e-0b8702bcabb7
Sheet: 16b

 |  | TOTAL
Product |  | HY** | IG | Other
Index Tranche* | Asia
 | Europe
 | North America
Index | Asia
 | Europe
 | North America
TOTAL |  | N/A*** | N/A | N/A
Estimated swap dollar volumes, week ending May 24, by product type (total value of trades in millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for product grade descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 216756d1361881313-help-with-if-formula-book2
Sheet: START SHEET

 |  |  |  |  |  | PTA | PTB | PTC | PTD | PTE | PTF | PTG | PTH | PTJ | PTK | PTL
 |  |  |  | QTY |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
 |  |  |  | AMP |  | 630A | 0 | 0 | 0 | 0 | 0 | 0 | 1250A | 0 | 0 | 0
Spreadsheet: 692634d1598470513-formula-to-evaluate-two-criteria-and-pull-data-if-both-met-scheduling-dummy-file
Sheet: Ave Delivery

Community | Avg. Breakfast Deliveries | Additional  Labor/hrs | Avg. Lunch Deliveries | Additional  Labor/hrs | Avg. Dinner Deliveries | Additional  Labor/hrs | Total Deliveries | Total Additional hrs w/ dbl occ | Total Weekly hours
Arrowhead Valley
[NAME] | 22 | 2.5 | 39 | 4 | 39 | 4
[NAME]
Cactus Valley | 32 | 3.5 | 32 | 3.5 | 32 | 3.5
[NAME] | 54 | 5.5 | 64 | 6.5 | 64 | 6.5
Captial Oaks | 40 | 4 | 55 | 5.5 | 55 | 5.5
Chartiers Bend | 15 | 0.75 | 20 | 2 | 20 | 2
Chenal Pines | 26 | 3 | 11 | 0.25 | 7 | 0.25
Copper Springs | 42 | 4.5 | 42 | 4.5 | 42 | 4.5
Coronado Villa | 44 | 4.5 | 44 | 4.5 | 44 | 4.5
[NAME] | 35 | 3.5 | 45 | 4.5 | 45 | 4.5
[NAME] | 4 | 0.25 | 8 | 0.5 | 8 | 0.5
Emerald Oaks | 48 | 5 | 48 | 5 | 48 | 5
Huntley Springs | 11 | 0.75 | 11 | 0.75 | 11 | 0.75
Lake Forest Village | 10 | 0.25 | 12 | 0.75 | 12 | 0.75
[NAME] | 60 | 6 | 60 | 6 | 60 | 6
[NAME] | 35 | 3.5 | 45 | 4.5 | 45 | 4.5
Oak Park | 30 | 4 | 30 | 4 | 30 | 4
Parkside Village | 31 | 3 | 35 | 3 | 32 | 3
Providnet Crossings | 53 | 5.5 | 53 | 5.5 | 53 | 5.5
Red Hills Village | 28 | 3 | 30 | 3 | 30 | 3
Red Rock Point | 40 | 4 | 40 | 4 | 40 | 4
Reflection Ridge | 45 | 4.5 | 45 | 4.5 | 45 | 4.5
Riverstone | 60 | 6 | 60 | 6 | 60 | 6
Robinwood | 30 | 4 | 47 | 4 | 47 | 4
[NAME] | 19 | 2 | 26 | 3 | 26 | 3
[NAME] | 35 | 3.5 | 35 | 3.5 | 35 | 3.5
[NAME] | 43 | 2 | 40 | 4.5 | 40 | 4.5
[NAME]
South Hills Square | 1 | 0.25 | 2 | 0.25 | 1 | 0.25
[NAME] | 30 | 4 | 57 | 6 | 57 | 6
Stone River | 8 | 0.25 | 24 | 2.5 | 24 | 2.5
Towne Center
Vickery Rose | 26 | 3 | 44 | 4.5 | 44 | 4.5
Walnut Grove | 30 | 3 | 30 | 3 | 30 | 3
Totals
Spreadsheet: 76767d1277254554-find-and-replace-worldcup2010final-1-
Sheet: Sheet2

 | Algeria | ALG
 | Argentina | ARG
 | Australia | AUS
 | Brazil | BRA
 | Cameroon | CAM
 | Chile | CHI
 | Côte d'Ivoire | CIV
 | Denmark | DEN
 | England | ENG
 | France | FRA | out
 | Germany | GER
 | Ghana | GHA
 | Greece | GRE
 | Honduras | HON
 | Italy | ITA
 | Japan | JAP
 | Korea DPR | KOR
 | Korea Republic | KOR
 | Mexico | MEX
 | Netherlands | NED
 | New Zealand | NZL
 | Nigeria | NIG
 | Paraguay | PAR
 | Portugal | POR
 | Serbia | SRB
 | Slovakia | SVK
 | Slovenia | SVN
 | South Africa | RSA
 | Spain | ESP
 | Switzerland | SUI
 | Uruguay | URU
 | USA | USA
Spreadsheet: 768814d1645132464-leadtime-for-jobs-based-on-available-resources-leadtime-for-jobs-based-on-available-resources
Sheet: Sheet3

Table 1
Worker category | Number of workers in worker category | Available from date | Available to date | Percent capacity when available %
Worker category 1 | 1 | 2007-01-01 00:00:00 | 2030-01-01 00:00:00 | 1
Worker category 2 | 2 | 2022-02-17 00:00:00 | 2022-04-15 00:00:00 | 0.4
Worker category 3 | 1 | 2022-08-06 00:00:00 | 2023-10-15 00:00:00 | 0.9
Worker category 4 | 3 | 2024-12-04 00:00:00 | 2025-03-30 00:00:00 | 0.3
Worker category 5 | 1 | 2022-03-03 00:00:00 | 2022-05-17 00:00:00 | 1
Table 2
Availability from date
Availability to date
Worker category 1
Worker category 2
Worker category 3
Worker category 4
Worker category 5
SUM FTEs (Full time employees) in period
Networkdays in period
Duration if all available resources divide work between them [net work days]
Table 3
Jobs | Man days required pr. job (net work days) | Start date of job | Duration if all available resources divide work between them [net work days] | Duration if all available resources divide work between them [gross days] | Finish date of job
Job 1 | 200 | 2022-02-22 00:00:00
Spreadsheet: 774228d1648314094-formula-to-evenly-sort-data-example2
Sheet: Sheet4

Example input |  |  |  | Example when sorted
ID | RANK | helper |  | ID | RANK | helper
1018 | RANK1 |  |  | 1018 | RANK1
1014 | RANK1 |  |  | 1050 | RANK2
1010 | RANK1 |  |  | 1048 | RANK2
1050 | RANK2 |  |  | 1046 | RANK2
1048 | RANK2 |  |  | 1042 | RANK2
1046 | RANK2 |  |  | 1040 | RANK2
1042 | RANK2 |  |  | 1038 | RANK2
1040 | RANK2 |  |  | 1014 | RANK1
1038 | RANK2 |  |  | 1036 | RANK2
1036 | RANK2 |  |  | 1034 | RANK2
1034 | RANK2 |  |  | 1032 | RANK2
1032 | RANK2 |  |  | 1028 | RANK2
1028 | RANK2 |  |  | 1024 | RANK2
1024 | RANK2 |  |  | 1020 | RANK2
1020 | RANK2 |  |  | 1010 | RANK1
1016 | RANK2 |  |  | 1016 | RANK2
1012 | RANK2 |  |  | 1012 | RANK2
1044 | RANK2 |  |  | 1044 | RANK2
1030 | RANK2 |  |  | 1030 | RANK2
1026 | RANK2 |  |  | 1026 | RANK2
Spreadsheet: 863099d1710667659-extracting-unique-data-from-repeating-parameters-in-excel-dynamic-approach-needed-nilaakash_1
Sheet: Sheet1

Parameter-a | Parameter-b | Data |  | My code | [NAME] set |  | Data output ([NAME]) |  |  |  |  | Average | Median | Standard Deviation
a1 | b1 | 75 |  | (not fully dynamic) |  | b1 |  | 92 |  |  |  |  | ? | ?
a1 | b1 | 92 |  |  | a1 | b2 |  | 31 | 75 |  |  | 55.66666666666666
a1 | b2 | 61 |  |  | a2 | b1 |  | 1931 | 1808 |  |  | 1273.666666666667
a1 | b2 | 31 |  |  | a2 | b2 |  | 1350 | 1268 | 1105 |  | 1574.5
a1 | b2 | 75
a2 | b1 | 82
a2 | b1 | 1931
a2 | b1 | 1808
a2 | b2 | 2575 |  | Your code |  | b1 | 75 | 92
a2 | b2 | 1350 |  | (dynamic) | a1 | b2 | 61 | 31 | 75
a2 | b2 | 1268 |  |  | a2 | b1 | 82 | 1931 | 1808
a2 | b2 | 1105 |  |  | a2 | b2 | 2575 | 1350 | 1268 | 1105
Spreadsheet: 813501d1673821852-how-to-add-another-series-to-calculation-depending-on-how-many-data-points-i-have-twr-calculation-
Sheet: Sheet1

 |  |  |  |  |  |  | rate of return |  |  |  | account balances |  |  | all amounts are in usd
 | starting balance | deposit/withdrawl | ending balance | sub period rate of return |  | january |  |  |  | date | [NAME] | itrade | total
2023-01-01 00:00:00 | 9223 |  | 10000 |  |  | february |  |  |  | 2023-01-01 00:00:00 | 1601 | 7622
2023-01-13 00:00:00 |  | 5000 | 17000 |  |  | march |  |  |  | 2023-02-01 00:00:00
2023-01-31 00:00:00 |  |  | 15000 |  |  | april |  |  |  | 2023-03-01 00:00:00
2023-02-05 00:00:00 |  |  |  |  |  | may |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  | june |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  | july |  |  |  | 2023-06-01 00:00:00
 |  |  |  |  |  | august |  |  |  | 2023-07-01 00:00:00
 |  |  |  |  |  | september |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  |  | october |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  |  | november |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  | december |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  | 2023-12-01 00:00:00
 |  | ((1+E3)*(1+E4)*(1+E5)-1) |  | formula for rate of return is add 1 to sub period rate of return and multiply by all others in same month then subtract 1 from the product
 |  |  |  | start balance at month beginning and end balance before deposit is nessesary. As is end balance at end of the month
 |  |  |  | balance will be combined balances across trading platforms.
Spreadsheet: 797756d1664132211-substitute-and-get-randbetween-from-cell-reference-query-to-get-substitute-and-randbetween-in-one-hd
Sheet: Query

 | Range min | Range [NAME] | Multiples |  |  |  | ROW | 2 | 3 | 4
This is actually to be written as 6-10 >>>> | 60 | 100 | 10
This is actually 100-200   >>>> | 60 | 100 | 5
This is actually 1-1000  >>>>> | 100 | 200 | 2
Spreadsheet: 884724d1733975469-count-if-of-non-zero-s-in-column-that-also-are-not-duplicates-in-another-column-unique-count-etaf
Sheet: Sheet1

Fruit | User | Column3 | Column4
Apple | User1 | 100
Apple | User2 | 0
[NAME] | User3 | 50
[NAME] | User4 | 60
[NAME] | User1 | 70
[NAME] | User4 | 0
Durian | User4 | 0
Durian | [NAME] | 10
Eggplant | [NAME] | 0
Spreadsheet: 113a16d3-2d0d-4aa5-96d5-4ee83b5c8638
Sheet: Audit Summary

Audit Summary |  | Name of Auditee:
 |  | Date of audit:
Section | Questions | Total # in Section | # of C | #of CAN | # of IAR | # of NA | Question # of any CAN or IAR
1 | General Questions
1.1 | Management Responsibility | 3
1.2 | Food Safety Plan or Risk Assessment | 2
1.3 | Raw Material Sourcing | 2
1.4 | Documentation & Recordkeeping | 3
1.5 | Worker Education & Training | 2
1.6 | Traceability | 2
1.7 | Recall Program | 1
1.8 | Corrective Actions | 1
1.9 | Self Audits | 1
1.1 | Agricultural Chemicals/Plant Protection Products | 3
1.11 | Water/Ice | 8
1.12 | Containers, Bins | 6
1.13 | Facility, Equipment, Tools | 11
1.14 | Storage | 6
1.15 | Waste Material | 1
1.16 | Outside Grounds | 1
1.17 | [NAME] | 1
1.18 | Leaks/Lubricants | 1
1.19 | Equipment and Utensil Construction | 3
1.2 | Temporary Repairs | 1
1.21 | Worker Health/Hygiene and Toilet/Handwashing Facilities | 19
1.22 | Temperature Control | 1
1.23 | Packing and [NAME] | 2
1.24 | Pest and Animal Control | 3
1.25 | Sampling/Testing | 4
2 | Packinghouse | 6
3 | Transportation  (Packinghouse to Customer)
3.1 | Temperature Control | 4
3.2 | Equipment Sanitation and Maintenance | 3
4 | Global Markets Addendum
4.1 | Food Safety Plan & Documentation | 11
4.2 | Food Defense | 3
5 | USDA [NAME]
5.1 | Active and Effective Traceability and Recall Program | 2
5.2 | Approved Suppliers | 3
5.3 | Food Safety Plan or Quality Manual | 1
5.4 | Containers or [NAME] with GAP&GHP logo | 2
C, Compliant with requirement; CAN, Corrective action needed to address nonconformance; IAR, Immediate action required because of imminent food safety risk; N/A, not applicable or not needed.
NOTE: | Section 4 is not a component of the Produce GAPs Harmonized Food Safety Standard and is offered only as a service to those auditees who need to conform to the Global Markets Primary Production Assessment
 | Section 5 is not a component of the Produce GAPs Harmonized Food Safety Standard and is performed for those operations approved to use the USDA GAP&GHP logo.
For internal use only |  |  | [NAME] appropriate box with an "X". |  |  | Reviewers Name
Audit Results Meets USDA Acceptance Criteria
Audit Results Do Not Meet USDA Acceptance Criteria
Spreadsheet: 696621d1600923662-how-to-efficiently-manage-trapping-value-and-n-a-errors-example-level-1-10-country-carnival-and-level-6-10-state-challenge-7th-and-8th-november-202
Sheet: Vault

Level 1 - 10 - Country Carnival & Level 6-10 State Challenge - 7th & 8th November 2020 Session 1 Gymnastics Club ABC & Gymnastics Club [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Please select one gymnast for the Springiest Vault Novelty Award | Please select one gymnast considered for the Sportmanship Novelty Award | Please select one gymnast considered for the Superhero Costume Novelty Award
Club | Comp Number | First Name | Last Name | Level | Judge 1 |  | Judge 2 |  | D Score | Neutral Deduction | Average | E Score | [NAME] | Springiest Vault | Sportmanship | Superhero Costume | Scratch | Award Bagged
 |  |  |  |  | Vault 1 | Vault 2 | Vault 1 | Vault 2
ABC | 1111 | Gymnast | One | 3 | 1 | 1 | 0.5 | 1 | 10 |  |  |  |  |  |  |  |  | Yes
ABC | 2222 | Gymnast | Two | 4 | 1 |  | 0.5 |  | 10
ABC | 3333 | Gymnast | Three | 5 |  |  |  |  | 10
XYZ | 9999 | Gymnast | One | 3 | 1 | 0.5 |  |  | 10
XYZ | 8888 | Gymnast | Two | 3 | 1 |  |  |  | 10
XYZ | 7777 | Gymnast | Three | 4 |  |  |  |  | 10
XYZ | 6666 | Gymnast | Four | 4 |  |  |  |  | 10
XYZ | 5555 | Gymnast | Five | 5 |  |  |  |  | 10
XYZ | 4444 | Gymnast | Six | 5 |  |  |  |  | 10
 |  |  |  |  | There may be one or two judges,
 |  |  |  |  | If only Judge 1 then Judge 1 scores either one or two vaults (Depending if the gymnast attempts two vaults or just does one), if the gymnast does 1 vault then that is the score, if they do 2 vaults then the highest score is recorded from judge 1
 |  |  |  |  | If there are two judges and the gymnasts only does 1 vault (column F & column H) then the average of that 1 vault is recorded.
 |  |  |  |  | If there are two judges and the gymnasts only does 2 vaults (column F & column H and also column G & column I) then the highest average score is recorded from vault 1 & vault 2.
Spreadsheet: 739172d1625566273-vba-locking-cells-based-on-checkbox-radio-button-selection-locking-cells
Sheet: Projections

Generation
Direct Self-Consumption
Export
Electricity Unit Rate |  |  |  |  |  |  | System Cost |  |  | 5000
Estimated Electricity Annual Use (kWh) |  |  |  |  |  |  | Deposit |  |  | 0
Export Tariff |  |  |  |  |  |  | Payment Type |  |  | Loan @ 9.7%
Panel Degradation |  |  |  | 0.00925 |  |  | Annual Interest Rate
Fuel Inflation |  |  |  | 0.051 | ONS CPI 2008 - 2020 |  | Payment Terms (years) |  |  | 5
Gas Inflation |  |  |  | 0.033 | ONS CPI 2008 - 2020 |  | Annual Loan Repayment
Year | SAP | Export | Self-Consumption (solar and/or battery) | Battery (overnight charging) | Total Annual Benefit (capped at 90% of the previous Grid usage) | Rep. Costs | Monthly Payment | Total Yearly Payment | Net Annual Benefit | Net Position
1
2
3
4
5
 |  |  |  |  |  | -1500
 |  |  |  |  |  | -1000
Spreadsheet: 787629d1657898499-calculating-average-based-on-year-sample
Sheet: Sheet1

 |  | Price | Total Shares |  | Amount Invested
2010-01-01 00:00:00 | 2500 | 81.84 | 31 |  | 2537.04 |  |  | 2010
2010-07-01 00:00:00 | 2500 | 69.78 | 36 |  | 2512.08
2011-01-01 00:00:00 | 2500 | 81.68 | 31 |  | 2532.08
2011-07-01 00:00:00 | 2500 | 62.5 | 40 |  | 2500
2012-01-01 00:00:00 | 2500 | 38 | 66 |  | 2508