tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120752d1315497918-multiple-results-sample
Sheet: Earnings, etc

 |  |  |  |  |  | Earnings, ROE and IRR Analysis
 |  |  |  |  |  | at Various Cost of Funds
 |  |  |  |  |  | Cost of | After Tax | Equity | Equity |  | IRR on
 |  |  |  |  |  | Funds | Earnings | Start of Year | End of Year | ROE | Initial Equity
 |  |  |  |  | Year 1
 |  |  |  |  |  | 0.16 | 5705161.04791168 |  |  | 0.335597708700687 | 0.335597708700687
 |  |  |  |  |  | 0.14 | 6884471.48852977 |  |  | 0.404968911089987 | 0.404968911089987
 |  |  |  |  |  | 0.12 | 8063781.92914787 |  |  | 0.474340113479287 | 0.474340113479286
 |  |  |  |  | Year 2
 |  |  |  |  |  | 0.16 | 10706958.281501 |  |  | 0.471564956483131 | 0.401933944265241
 |  |  |  |  |  | 0.14 | 13098151.6284872 |  |  | 0.548396125691015 | 0.474940140699974
 |  |  |  |  |  | 0.12 | 15458682.9040174 |  |  | 0.616773755362107 | 0.543915283281728
 |  |  |  |  | Year 3
 |  |  |  |  |  | 0.16 | 11960940.4324208 |  |  | 0.357982093697708 | 0.387127500539664
 |  |  |  |  |  | 0.14 | 14468097.6622173 |  |  | 0.391213398152931 | 0.446485820096599
 |  |  |  |  |  | 0.12 | 16880030.1519626 |  |  | 0.416559807540317 | 0.500239569449149
 |  |  |  |  | Year 4
 |  |  |  |  |  | 0.16 | 12854401.1250723 |  |  | 0.283304700907234 | 0.360409740275245
 |  |  |  |  |  | 0.14 | 15340506.9793192 |  |  | 0.298159223952227 | 0.407886440910514
 |  |  |  |  |  | 0.12 | 17658774.4758161 |  |  | 0.307630782954491 | 0.449578523210628
 |  |  |  |  | Year 5
 |  |  |  |  |  | 0.16 | 14191258.8420798 |  |  | 0.243721066072987 | 0.336227434915843
 |  |  |  |  |  | 0.14 | 16736493.1144373 |  |  | 0.250579210415756 | 0.374916557526231
 |  |  |  |  |  | 0.12 | 19036158.8849298 |  |  | 0.25360827257038 | 0.408074931398327
 |  |  |  |  | Year 6
 |  |  |  |  |  | 0.16 | 12976221.5843457 |  |  | 0.179183250310237 | 0.30867117648372
 |  |  |  |  |  | 0.14 | 14849086.2978909 |  |  | 0.177774350152207 | 0.339904874311164
 |  |  |  |  |  | 0.12 | 16391052.0753443 |  |  | 0.17419234896724 | 0.366085913855252
 |  |  |  |  | Year 7
 |  |  |  |  |  | 0.16 | 9781871.92777423 |  |  | 0.114548611162839 | 0.278995130948951
 |  |  |  |  |  | 0.14 | 10441536.1551786 |  |  | 0.106138189024996 | 0.303704086751205
 |  |  |  |  |  | 0.12 | 10695796.846924 |  |  | 0.0968046334436685 | 0.323904825420644
Spreadsheet: 455992d1460585376-new-to-excel-time-difference-issue-can-anyone-help-example-001
Sheet: Sheet2

Team SF 3 | 2 |  | 02:30:00 | 02:30:00 | 16:00:00 | 14:30:00 |  | 05:00:00
 |  |  | 08:00:00 | 07:30:00 | 02:30:00 | 19:30:00 |  | 12:30:00
Team SF 4 | 3 |  | 04:00:00 | 04:00:00 | 01:00:00 | 22:30:00 |  |  | 13:00:00
 |  |  | 08:00:00 | 08:00:00 | 08:00:00 | 07:30:00 |  |  | 23:30:00
Team SF 5 | 2 |  | 03:30:00 | 03:30:00 | 03:30:00 |  | 14:00:00 | 09:00:00 | 15:30:00
 |  |  | 08:00:00 | 08:00:00 | 08:00:00 |  | 20:00:00 | 19:00:00 | 20:30:00
Team SF 6 | 2 |  | 03:30:00 | 04:30:00 | 03:30:00 |  | 04:30:00 | 04:30:00 | 03:30:00
 |  |  | 08:30:00 | 12:30:00 | 08:30:00 |  | 12:30:00 | 08:30:00 | 08:00:00
Team SF 7 | 3 |  | 07:00:00 | 04:30:00 |  |  | 04:30:00 | 13:00:00 | 15:00:00
 |  |  | 19:00:00 | 12:30:00 |  |  | 08:30:00 | 20:00:00 | 19:00:00
Team SF 8 | 3 |  | 03:30:00 | 13:00:00 | 04:00:00 | 12:00:00 | 12:00:00 |  | 13:00:00
 |  |  | 07:30:00 | 19:00:00 | 08:00:00 | 20:00:00 | 19:00:00 |  | 18:30:00
Team SF 9 | 2 |  |  | 07:00:00 |  | 14:30:00 | 04:30:00 | 05:00:00 | 04:00:00
 |  |  |  | 19:00:00 |  | 19:00:00 | 08:30:00 | 10:00:00 | 12:30:00
Team SF 10 | 2 |  | 04:00:00 | 07:30:00 |  | 18:00:00 | 12:30:00 | 04:30:00
 |  |  | 08:00:00 | 19:30:00 |  | 02:00:00 | 19:30:00 | 08:30:00
Team SF 11 | 2 |  |  | 03:30:00 | 07:00:00 | 14:00:00 | 04:30:00 | 09:30:00
 |  |  |  | 11:00:00 | 19:00:00 | 21:00:00 | 10:30:00 | 19:30:00
Prob 1 |  |  |  |  |  |  | F17 |  | F17-E18 | 20 Hrs Total |  | this is fine
 |  |  |  | This is an example |  | E18
 |  |  |  |  |  |  | H17 |  | H17 - G18 | This is 7.5 hrs and is over the 2 days and is an error
 |  |  |  |  |  | G18 |  |  |  | any sum like this must turn red if under11 hrs not included
 |  |  |  |  |  |  |  |  |  | so H17 should turn red
 |  |  |  |  |  |  | H15 |  | this is a error but is in the same day
 |  |  |  |  |  | [NAME] |  |  | 10.5 hrs so this should also be red
Prob 2 |  |  |  |  |  | F17 |  |  | F18 should turn blue if f18 -f17 equals 10 / 10.5 / 11 / 11.5 / 12
 |  |  |  |  |  | F18 |  |  | and if possible a counter to ad these blue squares up at the end of each row
 |  |  |  |  |  |  |  |  | this could also go over 2 days( i.e. over midnight )
 |  |  |  |  |  |  |  |  | example L 17 should read 2 as 2 shifts are over 10 hours
Spreadsheet: 727510d1617917998-need-to-extract-data-from-other-sheet-based-on-name-date-and-time-range-to-avoid-duplicates-varun_task-manager-copy_upload
Sheet: Data'21

 | Date | Workers Name | Activity | Start Time | End Time | Workorder | Quantity | Images | Containers | Files | Total Time | Time in Minutes | Images/Min | Quantity/Min | Containers/Min | Files/Min | Comments | Department | Location
 | 2021-02-23 00:00:00 | [NAME] | PUT AWAY RECORDS: ONSITE | 2021-02-23 09:30:15 | 2021-02-23 12:59:58
 | 2021-02-23 00:00:00 | [NAME] | PUT AWAY RECORDS: ONSITE | 2021-02-23 13:41:40 | 2021-02-23 17:00:40
Spreadsheet: 745421d1629913270-help-with-a-chart-using-define-name-to-exclude-blank-columns-values-index-for-forum-1-
Sheet: work (3)

No | Quarter
1
 | Applies
 | Column | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Yes | Z | AA
 | Count
 | Columns
 | Department
No | Quarter | [NAME] | COO | CR | EP | IT | LST | LSTS | Maint | Maint Sup | Maint Tech | Ops | Ops Sup | Ops Spt Sup | PM | PW | RS | SS | [NAME] | Tech | TS | T Spec | Waste | [NAME] | Waste Ops | Work Plng | Grand Total
1 | 2023 3Q | 6 |  |  |  |  |  |  |  |  |  | 74 | 1 |  |  |  |  |  |  |  | 22 |  |  |  |  |  | 103
2 | 2024 1Q | 2 |  | 16 |  |  |  | 7 |  | 1 | 24 | 1 |  |  |  |  |  |  | 4 | 1 |  |  |  |  |  | 1 | 57
3 | 2024 3Q | 1 |  | 5 |  |  |  |  | 1 |  | 17 | 19 | 11 |  |  | 3 |  |  |  |  |  | 2 |  |  |  | 9 | 68
4 | 2024 4Q | 2 |  |  |  |  |  |  |  |  | 20 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 13 | 36
5 | 2026 1Q | 7 | 6 | 14 |  |  | 3 | 7 | 13 |  | 52 | 48 | 41 |  | 1 |  |  | 4 |  |  |  |  |  | 5 |  | 10 | 211
6 | 2026 2Q | 4 |  | 22 | 1 |  | 26 |  |  | 11 | 8 | 52 | 20 |  | 2 |  |  | 5 |  |  |  |  | 34 | 7 |  | 2 | 194
7 | 2026 3Q | 6 |  |  |  | 1 | 9 |  |  | 3 | 34 | 8 | 5 | 4 | 6 | 1 | 1 | 2 | 3 | 1 |  |  |  | 3 | 31 | 7 | 125
 | Grand Total | 28 | 6 | 57 | 1 | 1 | 38 | 14 | 14 | 15 | 155 | 202 | 78 | 4 | 10 | 4 | 1 | 11 | 7 | 2 | 22 | 2 | 34 | 15 | 31 | 42 | 794
Spreadsheet: 727324d1617836807-formula-multi-page-and-columns-commissions-test
Sheet: Medica Commissions

Start | Name | Group | Agent | Jan | Feb | March | April | May | June | July | August | Sept | October | November | December
2021-01-01 00:00:00 |  | GT | [NAME] | 15 | 15
2021-01-01 00:00:00 |  | GT | [NAME] | 15 | 15 | Termed
2021-01-01 00:00:00 |  | GCJ | [NAME]
2021-04-01 00:00:00 |  | GS | [NAME] | NA | NA | NA
2021-04-01 00:00:00 |  | GS | [NAME] | NA | NA | NA
2021-04-01 00:00:00 |  | GS | [NAME] | NA | NA | NA
2021-02-01 00:00:00 |  | [NAME] | [NAME] | NA
2021-03-01 00:00:00 |  | S | Barb Z | NA | NA
2021-03-01 00:00:00 |  | S | Barb Z | NA | NA
2021-03-01 00:00:00 |  | S | Barb Z | NA | NA
Spreadsheet: 796666d1663428838-how-to-display-remaining-values-referenced-in-the-row-associated-of-the-targeted-value-test4
Sheet: Feuil1

Country | Bank | Code bank | Name agency | Other | Other 1 | Other 2 | Other 3 | Other 4 | Other 5 | Other 6 |  |  | Other 5
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba5 | azqffgds |  |  | daba11
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | [NAME] | azqffgds |  |  | daba12
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba7 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba8 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba9 | azqffgds
azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba10 | azqffgds
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
expected result
blo | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba11 | azqffgds
[NAME] | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | azqffgds | daba12 | azqffgds
Spreadsheet: 881404d1729501060-automate-a-packing-sheet-for-orders-test-sheet-for-excel-forum
Sheet: Sheet1

 |  |  | No. |  |  | Stitched cards | Stitched cards | String and paper art | String and paper art | rope and wire jewellery | rope and wire jewellery | [NAME] | [NAME] | Protea |  | Cabinet of Curiosities | stitching | adv crochet 6 | Knickers | stitching | Quiz | Stitching | Eclipse | Stitching | Kidney talk
 |  |  |  |  |  | D | F | I | J | M | N | Q | R | A |  | B | C | E | G | H | K | L | O | P | S
 |  |  |  |  |  | craft | craft | craft | craft | craft | craft | craft | craft | craft |  | talk | stitch | crochet | talk | stitch | quiz | stitch | talk | stitch | talk
1 | new | [NAME] kklcv | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t
2 |  | ns | 4 | 0 |  | 1 |  | 1 |  | 1 |  | 1
3 | new | fssds | 0 | 1 |  |  | 1 |  |  |  |  |  |  |  |  | DNA
4 | new | sdfsd | 0 | 1 |  |  |  |  | 1 |  |  | 1 |  |  |  |  |  | c
5 | new | r5df | 0 | 1 |  |  | 1 |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | DNA
6 | new | yuk7 | 0 | 1 |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  | t
7 | new | w3rw3r | 0 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
8 | new | fdgdfdd | 0 | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | t
9 | new | vngfhfgh | 0 | 1 |  |  |  |  |  | n
10 |  | fdhhf | 4 | 4 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  | s |  |  | s |  | s |  | s
11 |  | dfhdfs | 1 | 0 |  |  |  |  |  |  |  | dna
Packing list for parcels
ID |  | D | I | M | Q
 |  | Stitched card | String and paper | Rope and wire | Bargello bracelet
1 | [NAME] kklcv | 1 | 1 | 1 | 1
2 | ns | 1 | 1 | 1 | 1
3 | fssds | 1
4 | sdfsd | 1 |  | 1 | 1
5 | r5df |  | 1
6 | yuk7 | 1 | 1 | 1 | 1
7 | w3rw3r | 1 | 1 | 1
8 | fdgdfdd | 1 | 1 | 1 | 1
9 | vngfhfgh | 1
10 | fdhhf |  |  |  | 1
11 | dfhdfs | 1 |  | 1
 |  |  |  |  |  | 14 | 11 | 9 | 7 | 13 | 9 | 15 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | craft | kits |  | 4 | 3 | 5 | 5 | 3 | 3 | 5 |  | 0 |  | 16 | 16 | 18 | 23 | 11 | 3 | 9 | 21 | 11
 |  |  | craft | no kit
Spreadsheet: 673338d1587317194-sum-columns-conditionally-copy-of-copy-of-cashflow-2020-21-nobbyburton-
Sheet: daily 8

Date | 2020-04-01 00:00:00 |  |  | W/E |  |  |  |  |  | W/E
INCOME RECEIVED
SLA Income |  |  |  |  |  |  |  |  |  |  |  |  | Total Receipts
Other CCG income |  |  |  |  |  |  |  |  |  |  |  |  | Total Receipts
DoH |  |  |  |  |  |  |  |  |  |  |  |  | Total Receipts
SWITCH Transactions |  |  |  |  |  |  |  |  |  |  |  |  | Total Receipts
Other Income |  |  |  |  |  |  |  |  |  |  |  |  | Total Receipts
TOTAL INCOME
EXPENDITURE
Other Payments inc Direct Debit |  |  |  |  |  |  |  |  |  |  |  |  | Total Payments
Switch-Wages |  |  |  |  |  |  |  |  |  |  |  |  | Total Payments
Drafts |  |  |  |  |  |  |  |  |  |  |  |  | Total Payments
Salaries |  |  |  |  |  |  |  |  |  |  |  |  | Total Payments
Bulk Cash |  |  |  |  |  |  |  |  |  |  |  |  | Total Payments
Presented Cheques |  |  |  |  |  |  |  |  |  |  |  |  | Total Payments
BACS/CHAPS  Payments |  |  |  |  |  |  |  |  |  |  |  |  | Total Payments
Capital |  |  |  |  |  |  |  |  |  |  |  |  | Total Payments
Investments OUT |  |  |  |  |  |  |  |  |  |  |  |  | Invest
TOTAL EXPENDITURE
Spreadsheet: 850651d1701062765-conditional-formatting-problem-solving-forum-rppf-cs-dissolution-calculation-sheet-for-s1-s2-and-s3-01
Sheet: Dissolution Average

% Result of Dissolution (S1 & S2) |  |  |  |  | % Result of Dissolution (S1 + S2 +S3)
Vessel no. | Result | Limit |  |  | Vessel no. | Result | Limit
1 | 90.23 |  |  |  | 1 | 90.23
2 | 91.23 | Each unit should be equal to or more than the |  |  | 2 | 91.23
3 | 92.23 |  |  |  | 3 | 92.23
4 | 93.23 |  |  |  | 4 | 93.23 | Each unit should be more than
5 | 94.23 |  |  |  | 5 | 94.23
6 | 95.23 | % |  |  | 6 | 95.23
7 | 96.23 |  |  |  | 7 | 96.23 | %
8 | 97.23 | and |  |  | 8 | 97.23
9 | 98.23 |  |  |  | 9 | 98.23 | and
10 | 99.23 | no unit is less than |  |  | 10 | 99.23
11 | 100.23 |  |  |  | 11 | 100.23 | Not more than 2 units are less than
12 | 101.23 |  |  |  | 12 | 101.23
Average |  | % |  |  | 13 | 90.23
Minimun |  |  |  |  | 14 | 91.23
Maximum |  |  |  |  | 15 | 92.23 | %
SD |  |  |  |  | 16 | 93.23
%RSD |  |  |  |  | 17 | 94.23 | and
 |  |  |  |  | 18 | 95.23
Dissolution Acceptance Table |  |  |  |  | 19 | 96.23 | No unit is less than
Stage | Number Tested | Acceptance Criteria |  |  | 20 | 97.23
S1 | 6 | Each Unit should be Q+5% |  |  | 21 | 98.23 | %
 |  |  |  |  | 22 | 99.23
S2 | 6 | Average of 12 units (S1 + S2) is equal to or greater than Q and no unit is less than Q-15%. |  |  | 23 | 100.23
 |  |  |  |  | 24 | 101.23
 |  |  |  |  | Average
S3 | 12 | Average of 24 units (S1 + S2 +S3) is equal to or greater than Q, not more than 2 units are less than Q − 15%, and no unit is less than Q −25%. |  |  | Minimum
 |  |  |  |  | Maximum
 |  |  |  |  | SD
 |  |  |  |  | %RSD
The amount of dissolved active ingredient |  |  | Q | = | 80 | %
Observation
Spreadsheet: 489718d1479400063-set-categories-for-rows-in-a-sheet-book1
Sheet: Sheet1

Process Name |  |  | [NAME] | [NAME] | Required (Yes/No)
 | Rule Name |  | Responsible Role | Responsible Person | Required (Yes/No)
 |  | Document Name | Responsible Role | Responsible Person | Required (Yes/No)
Process One |  |  | Responsbile Role 1 | Responsible Person 1 | Yes
 | Rule One |  | Responsbile Role 1 | Responsible Person 1 | Yes
 |  | Doc_1.docx | Responsbile Role 1 | Responsible Person 1 | Yes
 |  | Doc_2.docx | Responsbile Role 1 | Responsible Person 1 | Yes
 |  | Doc_3.pdf | Responsbile Role 1 | Responsible Person 1 | No
 | Rule Two
 |  | Doc_1.docx
 |  | Doc_2.docx
 |  | Doc_3.pdf
Process Two |  |  | [NAME] | Responsible Person 2 | Yes
 | Rule Three |  | Responsbile Role 1 | Responsible Person 1 | Yes
 |  | Doc_1.docx | Responsbile Role 1 | Responsible Person 1 | Yes
 |  | Doc_2.docx | Responsbile Role 1 | Responsible Person 1 | No
 |  | Doc_3.pdf | Responsbile Role 1 | Responsible Person 1 | No
 | Rule Four
 |  | Doc_1.docx
 |  | Doc_2.docx
 |  | Doc_3.pdf
Process Three |  |  | Responsbile Role 3 | Responsible Person 3 | No
 | Rule Five |  | Responsbile Role 1 | Responsible Person 1 | No
 |  | Doc_1.docx | Responsbile Role 1 | Responsible Person 1 | No
 |  | Doc_2.docx | [NAME] | Responsible Person 1 | No
 |  | Doc_sdfsf.pdf | Responsbile Role 3 | Responsible Person 3 | No
 | Rule Six
 |  | Doc_werwrw.docx
 |  | Doc_sdfsfs.docx
 |  | Doc_dsfs.pdf
 | Statistics (manually)
 | Total number of needed processes | 2 | count how many "Yes" are for processes on column F on rows with blue background
 | Total number of needed documents | 4 | count how many documents have "Yes" on column F on the rows with orange background
 | How many documents "Responsible person 1" shall do | 8 | Count how many times "Responsible Person 1" is found on column E on the rows marked with pink
 | The idea is that this sheet is dynamic so maybe I will add Doc_asdad.dop for Rule Six.  Is there any option to mark each row and say what kind of content it is (Process, Rule, Doc) and then use these "markups" in calculations? E.g.: IF IS DOC & F4:F30 <> NO bla bla
Spreadsheet: 111671d1308010441-merging-two-worksheets-and-flagging-matching-names-merge-excel-worksheets
Sheet: Sports Players

Name | Sport | Home Team | Testing
[NAME] | Football |  | a
[NAME] | Football |  | b
[NAME] | Football |  | c
[NAME] | Football |  | d
[NAME] | Baseball |  | e
[NAME] | Baseball |  | f
[NAME] | Football |  | g
[NAME] | Football |  | h
[NAME] | Football |  | i
[NAME] | Baseball |  | j
[NAME] | Baseball |  | k
[NAME] | Basketball |  | l
Dirk Notitzki | Basketball |  | m
[NAME] | Hockey |  | n
Jean-Sebastien Giguere | Hockey |  | o
[NAME] | Hockey |  | p
[NAME] | Football |  | q
[NAME] | Basketball |  | r
Spreadsheet: 771336d1646636390-if-and-match-formulas-summing-data-from-different-columns-personas_tareas_foro
Sheet: Horas reales febrero

Task | Person | Date | Duration
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT | Ended By | Start Date | Duration
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT | Persona1 | 2022-03-03 | 00:44:49
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT | Persona1 | 2022-03-03 | 02:10:58
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT | Persona1 | 2022-03-02 | 02:56:54
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT | Persona1 | 2022-03-02 | 00:33:39
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT | Persona1 | 2022-03-02 | 01:43:30
D22009-PED Campos Obligatorios Cliente, Subcliente o CPT | Persona1 | 2022-03-01 | 02:09:47
Total |  |  | 10:19:37
D22040-ECO Ecoembes
D22040-ECO Ecoembes | Ended By | Start Date | Duration
D22040-ECO Ecoembes | Persona2 | 2022-02-24 | 01:44:00
D22040-ECO Ecoembes | Persona2 | 2022-02-22 | 04:09:00
D22040-ECO Ecoembes | Persona2 | 2022-02-07 | 00:39:45
Total |  |  | [NAME]
D22004-CROP Project Management
D22004-CROP Project Management | Ended By | Start Date | Duration
D22004-CROP Project Management | Persona3 | 2022-03-01 | 00:39:47
D22004-CROP Project Management | Persona3 | 2022-02-24 | 00:36:10
D22004-CROP Project Management | Persona3 | 2022-02-24 | 00:27:40
D22004-CROP Project Management | Persona3 | 2022-02-22 | 01:10:11
D22004-CROP Project Management | Persona3 | 2022-02-21 | [NAME]
D22004-CROP Project Management | Persona3 | 2022-02-21 | 00:33:00
D22004-CROP Project Management | Persona3 | 2022-02-21 | 00:34:32
D22004-CROP Project Management | Persona3 | 2022-02-18 | 00:35:05
D22004-CROP Project Management | Persona3 | 2022-02-16 | 00:26:50
D22004-CROP Project Management | Persona3 | 2022-02-15 | 00:43:50
D22004-CROP Project Management | Persona3 | 2022-02-08 | 01:41:14
Total |  |  | 08:55:38
Spreadsheet: 751932d1634460072-unable-to-create-linear-function-to-use-simplex-lp-makespan-hydr-
Sheet: Foglio1

Assign | time | M1 | M2 | M3
1 | 26 | 1 | 0 | 0
2 | 16 | 0 | 1 | 0
3 | 5 | 1 | 0 | 0
4 | 19 | 1 | 0 | 0
5 | 52 | 0 | 1 | 0
6 | 98 | 0 | 0 | 1
7 | 8 | 1 | 0 | 0
8 | 36 | 0 | 0 | 1
9 | 68 | 0 | 1 | 0
10 | 3 | 1 | 0 | 0
11 | 75 | 1 | 0 | 0
sumproduct
copy of objective cell
solution
Spreadsheet: 36439d1234315628-hourly-census-formula-census-ver2-
Sheet: Volume

Day | Date | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00
Thu | 2009-02-05 00:00:00 | 26 | 26 | 22 | 22 | 22 | 20 | 17 | 22 | 16 | 16 | 19 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fri | 2009-02-06 00:00:00 | 19 | 19 | 23 | 19 | 20 | 20 | 14 | 20 | 25 | 23 | 22 | 18 | 6 | 6 | 5 | 4 | 1 | 1 | 18 | 18 | 18 | 18 | 18 | 18
Spreadsheet: 137728d1327336729-multiple-if-in-sumifs-formula-duplicate
Sheet: Weekly Overview

Catergory Report MDA & SKA |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 |  |  |  |  |  |  | All | Home | Travel | Business
 |  |  |  |  |  | All | Helen | [NAME]
 | Chain | [NAME] |  |  |  | All | 2010-11 | 2011-12
 | Year | 2011-12 |  |  |  | All | Fix | Dont Fix
 | Type | Fix
 | MA | Business
 | Week | Cost | Spend
 | 31
Spreadsheet: 94488d1294290874-capture-values-over-0-and-populate-results-in-another-column-no-zeros
Sheet: Sheet2

Data 1 | Data 2 | Data 3 | Data 4
 | 2 | 2
 | 3 |  | 3
4 |  | 4
 | 5 | 5
6 |  |  | 6
 | 7 |  | 7
8 |  | 8
 | 9 | 9
10 |  |  | 10
11 |  |  | 11
12 |  | 12
13 | 13 | 13 | 13
 | 14 | 14 | 14
15 | 15 | 15
16 |  |  | 16
17 | 17 | 17 | 17
18 | 18 |  | 18
19 | 19 | 19 | 19
Spreadsheet: 0fa8b1c9-d7a3-4272-af5d-fbb6fb044c48
Sheet: UVA CME Import

NPI# | FNAME | LNAME | CREDENTIAL (MD, DO, PhD, RN, etc. ) | AFFILIATION | ZIP | [NAME] | BIRTHDATE (MUST BE FORMATTED with no slashes: MMDDYYYY) | EVENT NAME | EVENT DATE | NUMBER OF CREDITS | Are you a Resident or Fellow? (use caps Y or N) | Are you a UVA Employee?  (use caps Y or N) | Event ID (completed by CME office) | Cell Phone           [PHONE]
xxxxxxxxxxx | Test | Document | MD | University of Virginia | 22908 | [EMAIL] | 01021975 | Medical Grand Rounds | 2009-07-08 00:00:00 | 1 | N | Y |  | [PHONE]
Spreadsheet: jane_tholt__13059__bid2001A
Sheet: MAY-00

 |  |  |  |  | Bass Enterprises Production Co. |  |  |  |  | 2001-03-15 00:00:00
 |  |  |  |  | April - October 2001 Bid Package
 | FIELD |  |  |  | PIPELINE(S) | MMbtu/D |  | [NAME]. | County | State
 | NORTH WORD |  |  |  | HPL | 7000 |  | 9807 | Lavaca | Texas
 |  |  |  |  | Midcon Texas |  |  | 6007
 |  |  |  |  | Crosstex Gulf Coast
 | RAMBLER |  |  |  | TETCO | 2000 |  | Wilcox Plant-S. Tx Pool #79501 | Dewitt | Texas
 |  |  |  |  | PG&E |  |  | 553-750
 | FLORES (LA GLORIA) |  |  |  | TENNESSEE | 2000 |  | Duke's LaGloria Plant | [NAME] | Texas
 |  |  |  |  | Trunkline, NGPL |  |  | Outlet Pipes
 |  |  |  |  | Channel, Celanese
 |  |  |  |  | Tejas (Coral Mexico)
 | [NAME] |  |  |  | EPNG | 15000 |  | SRGC - KEYSTONE PLANT | Winkler | Texas
 |  |  |  |  | TRANSWESTERN
 | GOMEZ |  |  |  | OASIS | 3500 |  | WGR Gomez #4466 | Pecos | Texas
 |  |  |  |  | PG&E |  |  | WGR Gomez #504-218
 | POINTE-A-LA-HACHE, COX BAY |  |  |  | SNG | 7000 |  | SNG 0144100, 014800 | Plaquemines | Louisiana
 | WEST SANDY HOOK |  |  |  | SNG | 120 |  | SNG 048500 | Marion | Mississipi
 | [NAME] |  |  |  | EPFS | 3600 |  | 10 Meters(EPFS) | Eddy | New Mexico
 | JAL PLANT RESIDUE |  |  |  | EPNG | 2000 |  | Mainline Pool | [NAME] | New Mexico
 | POKER LAKE |  |  |  | EPNG | 1200 |  | EPNG Mainline (Waha) | Pecos | Texas
 | PYOTE FIELD |  |  |  | Oasis - Waha | 1000 |  | Waha header | Pecos | Texas
 |  |  |  |  |  |  |  | via SRGC transport
 |  |  |  | TOTAL
Spreadsheet: 127fd7c5-9fe1-4354-a658-fa190a917168
Sheet: LY110Dec20_H3K4me2_Run110412_s_

Gene | NumSNVs | BH | ObsRGYW | ExpRGYW | z-scoreRGYW | ObsWA | ExpWA | z-scoreWA | ObsRep | ExpRep | z-scoreRep | Ts/Tv
BCL2 | 72(42) | 0 | 9 | 4 | 2.33 | 23 | 9 | 4.64 | 0 | 1 | -1.31 | 50/22
IGLL5 | 21(21) | 0 | 2 | 1 | 1.13 | 8 | 2 | 3.58 | 0 | 0 | 0 | 10/11
S1PR2 | 12(12) | 0 | 3 | 1 | 2.88 | 2 | 1 | 1.51 | 0 | 0 | 0 | 9/3
MYO1E | 12(11) | 0 | 2 | 1 | 1.59 | 3 | 1 | 2.95 | 0 | 0 | -0.25 | 7/5
RPS17 | 10(7) | 1.84e-14 | 1 | 1 | 0.28 | 2 | 1 | 0.45 | 0 | 0 | 0 | 7/3
BCL7A | 9(0) | 9.54e-13 | 2 | 1 | 1.32 | 0 | 1 | -0.83 | 0 | 0 | -0.64 | 5/4
WASH3P | 9(8) | 9.54e-13 | 1 | 1 | 0.54 | 1 | 2 | -0.42 | 0 | 0 | 0 | 7/2
BTG2 | 7(7) | 3.63e-09 | 2 | 0 | 2.78 | 1 | 1 | 0.44 | 2 | 1 | 1.5 | 3/4
BACH2 | 6(3) | 2.06e-07 | 2 | 0 | 3.76 | 0 | 0 | -0.73 | 0 | 0 | -0.54 | 3/3
TCL1A | 5(5) | 6.85e-06 | 2 | 0 | 4.05 | 2 | 1 | 1.34 | 0 | 0 | 0 | 1/4
WASH1 | 4(4) | 0.000212 | 1 | 0 | 1.99 | 0 | 1 | -0.82 | 0 | 0 | 0 | 2/2
ZNF286B | 4(0) | 0.000212 | 1 | 0 | 1.42 | 0 | 1 | -0.91 | 0 | 0 | 0 | 4/0
SERPINA9 | 3(3) | 0.00397 | 1 | 0 | 1.99 | 1 | 0 | 1.18 | 0 | 0 | 0 | 2/1
NBPF3 | 3(2) | 0.00397 | 1 | 0 | 1.99 | 0 | 0 | -0.44 | 0 | 0 | 0 | 0/3
MTSS1 | 3(1) | 0.00397 | 1 | 0 | 2.84 | 0 | 0 | -0.31 | 0 | 0 | -0.74 | 2/1
MEPCE | 3(2) | 0.00397 | 1 | 0 | 2.05 | 0 | 0 | -0.47 | 0 | 0 | 0 | 1/2
EBF1 | 3(0) | 0.00397 | 2 | 0 | 4.71 | 0 | 0 | -0.55 | 0 | 0 | 0 | 1/2