tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 193255d1352773835-putting-3-columns-of-digits-together-to-make-a-whole-number-diff
Sheet: Sheet1

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
8 | 9 | 7 | 1 | 2 | 0 | 4 | 6 | 3 | 5 |  | 1 | 2 | 0 | 4 | 5 | 3 | 7 | 9 | 6 | 8 |  | 4 | 5 | 3 | 7 | 8 | 6 | 0 | 2 | 9 | 1
1 | 2 | 0 | 4 | 5 | 3 | 7 | 9 | 6 | 8 |  | 4 | 5 | 3 | 7 | 8 | 6 | 0 | 2 | 9 | 1 |  | 9 | 0 | 8 | 2 | 3 | 1 | 5 | 7 | 4 | 6
4 | 5 | 3 | 7 | 8 | 6 | 0 | 2 | 9 | 1 |  | 9 | 0 | 8 | 2 | 3 | 1 | 5 | 7 | 4 | 6 |  | 2 | 3 | 1 | 5 | 6 | 4 | 8 | 0 | 7 | 9
9 | 0 | 8 | 2 | 3 | 1 | 5 | 7 | 4 | 6 |  | 2 | 3 | 1 | 5 | 6 | 4 | 8 | 0 | 7 | 9 |  | 5 | 6 | 4 | 8 | 9 | 7 | 1 | 3 | 0 | 2
2 | 3 | 1 | 5 | 6 | 4 | 8 | 0 | 7 | 9 |  | 5 | 6 | 4 | 8 | 9 | 7 | 1 | 3 | 0 | 2 |  | 7 | 8 | 6 | 0 | 1 | 9 | 3 | 5 | 2 | 4
5 | 6 | 4 | 8 | 9 | 7 | 1 | 3 | 0 | 2 |  | 7 | 8 | 6 | 0 | 1 | 9 | 3 | 5 | 2 | 4 |  | 6 | 7 | 5 | 9 | 0 | 8 | 2 | 4 | 1 | 3
7 | 8 | 6 | 0 | 1 | 9 | 3 | 5 | 2 | 4 |  | 6 | 7 | 5 | 9 | 0 | 8 | 2 | 4 | 1 | 3 |  | 3 | 4 | 2 | 6 | 7 | 5 | 9 | 1 | 8 | 0
6 | 7 | 5 | 9 | 0 | 8 | 2 | 4 | 1 | 3 |  | 3 | 4 | 2 | 6 | 7 | 5 | 9 | 1 | 8 | 0 |  | 0 | 1 | 9 | 3 | 4 | 2 | 6 | 8 | 5 | 7
3 | 4 | 2 | 6 | 7 | 5 | 9 | 1 | 8 | 0 |  | 0 | 1 | 9 | 3 | 4 | 2 | 6 | 8 | 5 | 7 |  | 8 | 9 | 7 | 1 | 2 | 0 | 4 | 6 | 3 | 5
0 | 1 | 9 | 3 | 4 | 2 | 6 | 8 | 5 | 7 |  | 8 | 9 | 7 | 1 | 2 | 0 | 4 | 6 | 3 | 5 |  | 1 | 2 | 0 | 4 | 5 | 3 | 7 | 9 | 6 | 8
5 | 3 | 4 | 8 | 6 | 9 | 7 | 2 | 0 | 1 |  | 2 | 0 | 1 | 5 | 3 | 4 | 8 | 6 | 9 | 7 |  | 6 | 9 | 7 | 2 | 0 | 1 | 5 | 3 | 4 | 8
2 | 0 | 1 | 5 | 3 | 4 | 8 | 6 | 9 | 7 |  | 6 | 9 | 7 | 2 | 0 | 1 | 5 | 3 | 4 | 8 |  | 1 | 5 | 3 | 4 | 8 | 6 | 9 | 7 | 2 | 0
6 | 9 | 7 | 2 | 0 | 1 | 5 | 3 | 4 | 8 |  | 1 | 5 | 3 | 4 | 8 | 6 | 9 | 7 | 2 | 0 |  | 7 | 2 | 0 | 1 | 5 | 3 | 4 | 8 | 6 | 9
1 | 5 | 3 | 4 | 8 | 6 | 9 | 7 | 2 | 0 |  | 7 | 2 | 0 | 1 | 5 | 3 | 4 | 8 | 6 | 9 |  | 8 | 6 | 9 | 7 | 2 | 0 | 1 | 5 | 3 | 4
7 | 2 | 0 | 1 | 5 | 3 | 4 | 8 | 6 | 9 |  | 8 | 6 | 9 | 7 | 2 | 0 | 1 | 5 | 3 | 4 |  | 3 | 4 | 8 | 6 | 9 | 7 | 2 | 0 | 1 | 5
8 | 6 | 9 | 7 | 2 | 0 | 1 | 5 | 3 | 4 |  | 3 | 4 | 8 | 6 | 9 | 7 | 2 | 0 | 1 | 5 |  | 4 | 8 | 6 | 9 | 7 | 2 | 0 | 1 | 5 | 3
3 | 4 | 8 | 6 | 9 | 7 | 2 | 0 | 1 | 5 |  | 4 | 8 | 6 | 9 | 7 | 2 | 0 | 1 | 5 | 3 |  | 9 | 7 | 2 | 0 | 1 | 5 | 3 | 4 | 8 | 6
4 | 8 | 6 | 9 | 7 | 2 | 0 | 1 | 5 | 3 |  | 9 | 7 | 2 | 0 | 1 | 5 | 3 | 4 | 8 | 6 |  | 0 | 1 | 5 | 3 | 4 | 8 | 6 | 9 | 7 | 2
9 | 7 | 2 | 0 | 1 | 5 | 3 | 4 | 8 | 6 |  | 0 | 1 | 5 | 3 | 4 | 8 | 6 | 9 | 7 | 2 |  | 5 | 3 | 4 | 8 | 6 | 9 | 7 | 2 | 0 | 1
0 | 1 | 5 | 3 | 4 | 8 | 6 | 9 | 7 | 2 |  | 5 | 3 | 4 | 8 | 6 | 9 | 7 | 2 | 0 | 1 |  | 2 | 0 | 1 | 5 | 3 | 4 | 8 | 6 | 9 | 7
Spreadsheet: 125954d1319430372-dynamic-sumif-ranges-based-on-hlookup-criteria-dynamic-sum-if-range
Sheet: Summary Sheet

 |  | Actual | Actual | Actual | Actual | Actual
 |  | 08/2011 | 09/2011 | 10/2011 | 11/2011 | 12/2011
 | A
 | B
 | K
 | D
 | Z
 | F
 | Y
 | H
 | I
 | J
 | K
 | L
Spreadsheet: 743117d1628236159-getting-exact-value-from-an-if-function-for-another-if-function-sample-vlookup-excel
Sheet: Sheet1

a
a | 1 | 2 | 3 | 4 | 5
b | 6 | 7 | 8 | 9 | 10
c | 11
d | 16
e | 21
Spreadsheet: 288be6de-b83e-44e6-ad7b-ab4a2b681656
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
 |  |  | SOUTHARD FIRE DEPARTMENT #1 |  |  |  |  |  |  |  | SOUTHARD FIRE DEPARTMENT #1
 |  |  | Truck Trip Sheet |  |  |  |  |  |  |  | Truck Trip Sheet
Date: |  |  |  | Call #: |  |  |  | Date: |  |  |  | Call #:
Incident Type: |  |  |  |  |  |  |  | Incident Type:
Location: |  |  |  |  |  |  |  | Location:
Time Out: |  |  | Time Return: |  |  |  |  | Time Out: |  |  | Time Return:
 | Hours |  |  | Milage |  |  |  |  | Hours |  |  | Milage
 |  |  | In |  |  |  |  |  |  |  | In
 |  |  | Out |  |  |  |  |  |  |  | Out
 |  | Hours | Total |  |  | [NAME] |  |  |  | Hours | Total |  |  | [NAME]
Check -> |  | Fuel | Water |  | Equip. |  |  | Check -> |  | Fuel | Water |  | Equip.
Driver: |  |  |  | # of Men: |  |  |  | Driver: |  |  |  | # of Men:
Residence or Vehicle Information: |  |  |  |  |  |  |  | Residence or Vehicle Information:
Remarks: |  |  |  |  |  |  |  | Remarks:
Pump Time Hours: |  |  |  |  |  |  |  | Pump Time Hours:
Spreadsheet: 849824d1700207213-optimal-resource-allocation-allocation
Sheet: Sheet1

Table 1 (tandrd specs) |  |  |  |  |  |  |  |  |  |  | table2 (actual Prodion) |  |  |  | Table 3 (actual total material consumptions) |  |  |  |  |  |  |  |  | Table 4 (Actual consumptionss)
Prod | Initial batch size | Material 1 | Material 2 | Material 3 | Material 5 | Material 6 | Material 7 | Material 8 | End batch size |  | Prod | Initial size | end size |  | Material 1 | Material 2 | Material 3 | Material 4 | Material 5 | Material 6 | Material 7 | Material 8 |  | Prod | Initial batch size | Material 1 | Material 2 | Material 3 | Material 5 | Material 6 | Material 7 | Material 8 | End batch size
Prod1 | 900 | 87 | 112 | 187 |  | 268 |  | 247 | 1417 |  | Prod1 | 660 | 1174 |  | 225 | 125 | 500 | 604 | 424 | 180 | 0 | 954 |  | Prod1 | 660 |  |  |  |  |  |  |  | 1174
Prod2 | 1012 | 75 | 80 | 77 | 78 |  |  | 220 | 1519 |  | Prod2 | 1255 | 2220 |  |  |  |  |  |  |  |  |  |  | Prod2 | 1255 |  |  |  |  |  |  |  | 2220
Prod3 | 1333 | 210 | 185 | 231 |  |  | 337.2 | 280 | 1906
Prod4 | 999.49 | 87 | 112 | 187 |  | 268 |  | 247 | 1610
Spreadsheet: 51536d1251199856-extracting-information-based-on-drop-down-selection-drop_down_sol
Sheet: FrontPage

Select the Type | Marketing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Advertising
Campaign 1 | 100 |  | When I select the type from drop down, only relevant campaigns to that type along with the budget, gets displayed over here. Example is shown: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Promotion
Campaign 4 | 290 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Events
Campaign 6 | 238 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training
Campaign 7 | 300
Select the Type | Advertising |  | When I select the type from drop down, only relevant campaigns to that type along with the budget, gets displayed over here. Example is shown:
Campaign 2 | 150
Campaign 6 | 245
Spreadsheet: 852837d1702810904-data-relocation-from-worksheet-to-worksheet-example
Sheet: Orchard

 | Orchard
Date | Payee | Description | Amount
 | P.G.&E. Veladao | Ag Pump Electricity, dates covering  11/23/22-12/22/22 | 62.63
44950 | [NAME]  0420 | Loan Reimbursement | 40000
44956 | AT&T | landline phone service  (1/17/23 - 2/16/23) | 128.91
44962 | P.G.&E. Veladao | Ag Pump Electricity, dates covering  12/23/22-1/24/23 | 68.91
44962 | Verizon | Cell Phone covering   12/26/22 - 1/25/23  Inv. 9556 | 185.66
44970 | Mid Valley Ag | Inv. 19964254, Strip spray Oakdale | 2615.5
 |  | Total
Spreadsheet: 377096d1423789830-find-value-that-doesnt-match-and-bring-back-column-heading-150213-data-file
Sheet: Year 2

PersID | PosCode | Org1 | Org2 | Org3 | Non-Matching Value from Year 1 | Location of non-matching value from Year 1 | Header
1001 | 21 | 8 | A1 | SS1 |  |  |  | Drag these formula in columns F, G, H down as far as needed
1002 | 21 | 9 | A2 | AQ1
1003 | 22 | 11 | B3 | D34
1004 | 23 | 12 | B2 | DW4
1005 | 23 | 22 | C1 | SS2
1006 |  | 8 | A1 | SS1
1007 |  | 9 | A2 | AQ1
1008 |  | 11 | B3 | D34
1009 |  | 12 | B2 | DW4
1010 |  | 22 | C1 | SS2
1011 |  | 8 | A1 | SS1
1012 |  | 9 | A2 | AQ1
1013 |  | 11 | B3 | D34
1014 |  | 12 | B2 | DW4
1015 |  | 22 | C1 | [NAME]
PersID | PosCode | Org1 | Org2 | Org3 | Result Expected
1001 | 21 | 8 | A1 | SS1
1002 | 21 | 9 | A2 | AQ1 | Org 3
1003 | 22 | 11 | B3 | D34 | Org 2
1004 | 23 | 12 | B2 | DW4 | Org 3
1005 | 23 | 22 | C1 | SS2 | Org 1
1006 | 24 | 8 | A1 | SS1
Spreadsheet: 119863d1314802249-form-to-enter-data-into-excel-sheet-ncmr
Sheet: Sheet1

NCMR ID | Added By | Added By Date | Nexx Part# | [NAME] | Nexx Part Description | NCMR Qty | JO | SN | INV | Nexx Inventory On Hand | Nexx Inventory Chk | [NAME] | Supplier Number | Manufacturer Part Number | Manufacturer Serial Number | Nonconformity | Disposition | Comments | Comments/Additional Details | PO | PO Date | Date Received
111 | [NAME] | 2011-07-07 00:00:00 | K11111111 | 1 | Some Stuff Here | 1 | 11111 | 111 |  | 0 | 0 | Some Company Here | 11223344 | K11111111 | N/A | A complaint Here | A possible Resolution | Comments | More Comments | 12334455 | 2011-01-01 00:00:00 | 2011-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Be Specific | Initiator
Spreadsheet: jeffrey_a_shankman__13789__Global Hot List 1005
Sheet: Hotlist - Identified 

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Results based on activity through October 5, 2000
 |  | Fourth Quarter 2000 |  |  | First Quarter 2001 |  |  | Second Quarter 2001 |  |  | Third Quarter 2001 |  |  | TOTAL
 | Liquids | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | Talisman Crude | 3000 |  | Dow / Tosco | 2000 |  |  |  |  | [NAME] | 2800
 |  |  |  |  | Enron Global Risk Markets | 900
 |  |  |  |  | Peerless | 500
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
Coal | Origination & Finance | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | SynFuel - AIG | 25000 |  | SynFuel - Pacificorp | 50000
 |  | Cline-Panther | 5000 |  | CMS | 30000
 |  | British Energy - UK | 5000 |  | DPR | 5000
 |  | Jupiter / Eagle Energy | 5000 |  | AES - UK | 5000
 |  | BEWAG - Germany | 1000 |  | M&G UK | 1000
 |  | Coellerici | 500 |  | RR Marketing JV - USA | 0
 |  | [NAME] | 500
 |  | DRS | 500
 |  | ETOL-UK | 500
 |  | ENV - Germany | 300
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
 | Emissions | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
 | Weather | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | SMUD | 500 |  | Harvard Fund | 250
 |  | Washington  Gas | 75 |  | [NAME] | 100
 |  | Energy West | 40 |  | Griffin | 25
 |  | IPC | 25
 |  | Cornerstone | 10
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
Global | Risk Markets | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | Project MI - 3 | 15000 |  |  |  |  | Project Taft | 10000
 |  | Project Mensa | 9000
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
 | Transportation | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
 | LNG | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
 | Middle East | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
 | Puerto Rico | Deal | Value |  | Deal | Value |  | Deal | Value |  | Deal | Value
 |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | SUBTOTAL |  |  | TOTAL
 |  | TOTALS |  |  | TOTALS |  |  | TOTALS |  |  | TOTALS |  |  | TOTALS
Spreadsheet: 805074d1668522276-getting-formula-to-work-when-data-is-replaced-test-deleting-values
Sheet: Test

Column A | Column B | [NAME] | [NAME] |  | Process
2 | 3 |  |  |  | First, select A2:[NAME]
4 | 6 |  |  |  | Then, press the Delete Key on the keyboard.
6 | 9
8 | 12 |  |  |  | What happens?
10 | 15 |  |  |  | Do the formulae work but show zeroes?
12 | 18
14 | 21 |  |  |  | Now, restore the data
16 | 24 |  |  |  | …  either use Undo
18 | 27 |  |  |  | … or copy from the Data Copy sheet
20 | 30
22 | 33 |  |  |  | Then, select A2:[NAME] again
24 | 36 |  |  |  | BUT, this time, Select "Delete" on the Home Ribbon
26 | 39 |  |  |  | And now choose "Delete cells …"
28 | 42 |  |  |  | And pick "Shift cells up" and OK
30 | 45
32 | 48 |  |  |  | What happens?
34 | 51 |  |  |  | Do you see #REF! in all the formula cells?
36 | 54 |  |  |  | Does FormulaText show =#[NAME] ?
38 | 57
Spreadsheet: 233093d1367608834-pasting-3-lines-of-data-example
Sheet: Desired way

Title | First Name | Surname | Home Phone | Work Phone | Mobile | House Number | Road/ Street | Address 2 | Town | County | Postcode | Date Of Birth | Account Number | Body Style | Registration Date | Vehicle Description | Extended warranty expiry Date | Last Service Date | Engine size | Next service Date | Next service Mileage | Registration Number | Vehile Type | [NAME] | Colour | [NAME]
{{1_TITLE}} | {{1_FIRSTNAM}} | {{1_SURNAME}} | {{1_PHONE_1}} | {{1_PHONE_2}} | {{1_PHONE_4}} | {{1_ADDRESS_1}} | {{1_ADDRESS_2}} | {{1_ADDRESS_3}} | {{1_ADDRESS_4}} | {{1_ADDRESS_5}} | {{1_POSTCODE}} | {{1_DOB}} | {{2_ACCNO}} | {{2_STYLE}} | {{2_REGDATE}} | {{2_DESC}} | {{2_WAREXTDT}} | {{2_LASTSERV}} | {{2_CC}} | {{2_NEXTSERV}} | {{2_NEXTSMIL}} | {{2_REGNO}} | {{2_TYPE}} | {{2_VARIANT}} | {{2_COLOUR}} | {{1_EMAIL}}
Spreadsheet: 850056d1700456867-icon-shapes-for-complete-in-progress-and-incomplete-status-conditional-formatting
Sheet: Sheet1

Name | Status | Icon |  |  |  | Note | Number
A | Completed |  |  |  |  | Completed | 1
B | In Progress |  |  |  |  | In Progress | 0
C | Incomplete |  |  |  |  | Incomplete | -1
D | Completed
E | Completed
F | In Progress
G | Completed
H | Incomplete
Spreadsheet: 109272d1306182550-comparing-grades-and-using-conditional-formatting-grades-vs-targets
Sheet: Sheet1

Forename | Surname | Grade | Grade Values | Target | Target Values | On Target?
asd | asd | A |  | A
dsa | dsa | A |  | #
wer | efwrgf | A |  | C
sdfgs | srgrf | B |  | A
awef | kuyuk | C |  | C
sdfr | fhtjkt | C |  | A
 |  |  |  |  |  |  |  | Lookup
 |  |  |  |  |  |  |  | # | 58
 |  |  |  |  |  |  |  | A | 52
 |  |  |  |  |  |  |  | B | 46
 |  |  |  |  |  |  |  | C | 40
 |  |  |  |  |  |  |  | D | 34
 |  |  |  |  |  |  |  | E | 28
 |  |  |  |  |  |  |  | F | 22
 |  |  |  |  |  |  |  | G | 16
 |  |  |  |  |  |  |  | U | 0
 |  |  |  |  |  |  |  |  | \
Spreadsheet: 224231d1364494258-find-differences-between-2-excel-spreadsheets-sample-from-032713
Sheet: Sheet1

[NAME] | SERVICE_DT_TM | CDM | ORDER_ID | C_CHARGE_TYPE_DISP | orderid combo | C_INSTITUTION_DISP | C_DEPARTMENT_DISP
10021 AP [NAME] performed without imag | 10/04/11 | 407000281 | 493894215 | DEBIT |  | Sharp Grossmont | SGH Lab
10021 AP [NAME] performed without imag | 10/10/11 | 407000281 | 498322517 | DEBIT |  | Sharp Grossmont | SGH Lab
10021 AP [NAME] performed without imag | 10/18/11 | 407000281 | 505542083 | DEBIT |  | Sharp Grossmont | SGH Lab
10021 AP [NAME] performed without imag | 10/18/11 | 407000281 | 505543910 | DEBIT |  | Sharp Grossmont | SGH Lab
10021 AP [NAME] performed without imag | 10/20/11 | 407000281 | 507250026 | DEBIT |  | Sharp Grossmont | SGH Lab
10021 AP [NAME] performed without imag | 10/25/11 | 407000281 | 512610762 | DEBIT |  | Sharp Grossmont | SGH Lab
17-d Hydroxyprogesterone - ARUP | 10/07/11 | 406590105 | 495147414 | DEBIT |  | Sharp Memorial | SMH Lab
17-d Hydroxyprogesterone - ARUP | 10/13/11 | 406590105 | 501135208 | DEBIT |  | SRS Mira Mesa | SRS MM Lab
17-d Hydroxyprogesterone - ARUP | 10/14/11 | 406590105 | 500981290 | DEBIT |  | Sharp Memorial | SMH Lab
17-d Hydroxyprogesterone - ARUP | 10/14/11 | 406590105 | 502371579 | DEBIT |  | SRS Downtown | SRS DT Lab
17-d Hydroxyprogesterone - ARUP | 10/17/11 | 406590105 | 504476486 | DEBIT |  | SRS San Carlos | RSC Laboratory
17-d Hydroxyprogesterone - ARUP | 10/18/11 | 406590105 | 505644322 | DEBIT |  | Sharp Memorial | SMH Lab
17-d Hydroxyprogesterone - ARUP | 10/19/11 | 406590105 | 506516750 | DEBIT |  | SRS Otay Ranch | SRS OR Lab
17-d Hydroxyprogesterone - ARUP | 10/20/11 | 406590105 | 507223815 | DEBIT |  | Sharp Grossmont | SGH Lab
17-d Hydroxyprogesterone - ARUP | 10/24/11 | 406590105 | 508192736 | DEBIT |  | Sharp Memorial | SMH Lab
17-d Hydroxyprogesterone - ARUP | 10/24/11 | 406590105 | 510448385 | DEBIT |  | [NAME] | SRS EC Laboratory
17-d Hydroxyprogesterone - ARUP | 10/24/11 | 406590105 | 510492475 | DEBIT |  | SRS La Mesa | SRS LM Lab
17-d Hydroxyprogesterone - ARUP | 10/25/11 | 406590105 | 511902075 | DEBIT |  | SRS Downtown | SRS DT Lab
17-d Hydroxyprogesterone - ARUP | 10/25/11 | 406590105 | 511568523 | DEBIT |  | SRS [NAME] | SRS CV Lab
17-d Hydroxyprogesterone - ARUP | 10/26/11 | 406590105 | 512774631 | DEBIT |  | Sharp Memorial | SMH Lab
17-d Hydroxyprogesterone - ARUP | 10/27/11 | 406590105 | 513330374 | DEBIT |  | SRS Mira Mesa | SRS MM Lab
17-d Hydroxyprogesterone - ARUP | 10/28/11 | 406590105 | 515463254 | DEBIT |  | Sharp Memorial | SMH Lab
17-d Hydroxyprogesterone - ARUP | 10/28/11 | 406590105 | 515463254 | CREDIT |  | Sharp Memorial | SMH Lab
17-d Hydroxyprogesterone - ARUP | 10/29/11 | 406590105 | 515225652 | DEBIT |  | SRS [NAME] | SRS CV Lab
17-d Hydroxyprogesterone - ARUP | 10/31/11 | 406590105 | 516687893 | DEBIT |  | Sharp Memorial | SMH Lab
17-d Hydroxyprogesterone - ARUP | 10/31/11 | 406590105 | 516868972 | DEBIT |  | SRS La Mesa | SRS LM Lab
Spreadsheet: eric_saibi__9867__101701
Sheet: Duane Arnold 01

Owner Name |  | Alliant-IES Utilities Incorporated
Station Name |  | [NAME]
Unit Name |  | [NAME] 01
NERC Region |  | MAIN
State |  | IA
Fuel Type |  | Nuclear
Capacity |  | 597 MW
Start Date |  | 2001-10-17 00:00:00
End Date |  | 2001-10-20 00:00:00
Comments |  | Tripped-Electrical Problems
SIC |  | 4911
Plant ID |  | 1012744
Unit ID |  | 1004913
Outage ID |  | 18671
Spreadsheet: 851796d1701933178-need-help-with-adding-multiple-leaves-for-an-employee-employee-attendance-record-2023-aligw
Sheet: Employee Leave Tracker

 | Employee leave tracker
 | Employee name | Start date | End date | Type of leave | Days
 | [NAME] |  |  | Sick leave
 | ABDULNABI |  |  | Sick leave
 | ABINASH
 | ARJUN NEPALI
 | BISHOK
 | C.SENTHIL
 | FAROOQ
 | GOURAKHA BAHADUR RAI |  |  | Vacation
 | HARI NARAYAN
 | HARI NATH KANWAR
 | HARIS FAJRI
 | IMRAN [NAME]
 | JIWAN BHAIYA
 | MAHADEV PARIYAR |  |  | Other
 | MD KHUSHAL |  |  | Other
 | MOHAMAD SALMAN
 | MOHAMMAD FIROZ |  |  | Sick leave
 | MUHAMMED SINAN |  |  | Other
 | N.AYYAPPAN
 | N.SELVAM
 | NIYASUDEEN
 | [NAME]
 | PURNA DANGI |  |  | Vacation
 | RAHUL C.M
 | RAHUL P
 | RAM GURUNG
 | ROSHAN RAI |  |  | Sick leave
 | SAIDUL HAQUE
 | SAILALO |  |  | Vacation
 | THOUFEEQ BASHEER
 | VINOD KUMAR
 | YADAV GAJUREL
 | [NAME] | 2023-01-25 00:00:00 | 2023-01-26 00:00:00 | Bereavement
Spreadsheet: 200c3cfb-3ae3-4381-90e2-02f0083788c0
Sheet: Sheet1

Supplementary Table S2: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
overrepresented [NAME] categories
[NAME] (GO) Molecular Function categories overrepresented in proteins in cohesive modules when compared to proteins in all modules.
GO-ID | p-value | [NAME] | # selected | # total | Description
3740 | 1.3674e-21 | 1.2143e-18 | 174 | 216 | structural constituent of ribosome
16491 | 1.381e-19 | 6.1316e-17 | 144 | 175 | oxidoreductase activity
16874 | 1.7271e-12 | 5.1122e-10 | 89 | 108 | ligase activity
5198 | 7.8785e-12 | 1.749e-09 | 212 | 310 | structural molecule activity
4812 | 1.4818e-11 | 1.8797e-09 | 36 | 36 | aminoacyl-tRNA ligase activity
16875 | 1.4818e-11 | 1.8797e-09 | 36 | 36 | ligase activity, forming carbon-oxygen bonds
16876 | 1.4818e-11 | 1.8797e-09 | 36 | 36 | ligase activity, forming aminoacyl-tRNA and related compounds
45182 | 2.5646e-09 | 2.8467e-07 | 42 | 46 | translation regulator activity
16614 | 1.5061e-08 | 1.486e-06 | 51 | 60 | oxidoreductase activity, acting on CH-OH group of donors
3824 | 1.9966e-08 | 1.773e-06 | 696 | 1237 | catalytic activity
8135 | 6.4359e-08 | 5.1504e-06 | 34 | 37 | translation factor activity, nucleic acid binding
16616 | 6.96e-08 | 5.1504e-06 | 46 | 54 | oxidoreductase activity, acting on the CH-OH group of donors, NAD or NADP as acceptor
15078 | 5.5987e-06 | 0.00038244 | 24 | 26 | hydrogen ion transporter activity
30515 | 1.0378e-05 | 0.00065827 | 23 | 25 | snoRNA binding
3745 | 1.9172e-05 | 0.001135 | 22 | 24 | translation initiation factor activity
16879 | 5.27e-05 | 0.0029249 | 44 | 58 | ligase activity, forming carbon-nitrogen bonds
19829 | 6.4847e-05 | 0.0033873 | 14 | 14 | cation-transporting ATPase activity
16903 | 7.728e-05 | 0.0037134 | 17 | 18 | oxidoreductase activity, acting on the aldehyde or oxo group of donors
16829 | 7.9454e-05 | 0.0037134 | 48 | 65 | lyase activity
15077 | 9.622500000000001e-05 | 0.0042724 | 24 | 28 | monovalent inorganic cation transporter activity
46961 | 0.00012942 | 0.005223999999999999 | 13 | 13 | hydrogen-transporting ATPase activity, rotational mechanism
16645 | 0.00012942 | 0.005223999999999999 | 13 | 13 | oxidoreductase activity, acting on the CH-NH group of donors
16835 | 0.00048644 | 0.018399 | 21 | 25 | carbon-oxygen lyase activity
16646 | 0.00051501 | 0.018399 | 11 | 11 | oxidoreductase activity, acting on the CH-NH group of donors, NAD or NADP as acceptor
16620 | 0.00051799 | 0.018399 | 14 | 15 | oxidoreductase activity, acting on the aldehyde or oxo group of donors, NAD or NADP as acceptor
46912 | 0.0010268 | 0.035069 | 10 | 10 | transferase activity, transferring acyl groups, acyl groups converted into alkyl on transfer
16765 | 0.001238 | 0.040718 | 23 | 29 | transferase activity, transferring alkyl or [NAME] (other than methyl) groups
4842 | 0.0013317 | 0.042234 | 21 | 26 | ubiquitin-protein ligase activity
Spreadsheet: 850159d1700541495-formula-for-identify-top-75-percentage-and-its-average-top-75
Sheet: Sheet1

DIV | NUM | PRICE | CONTRI | SUM | average
AA | 1 | 2.2305761 | 0.25
AA | 2 | 1.9826327 | 0.1128001311022451
AA | 3 | 1.5937878 | 0.0906771449846251
AA | 4 | 1.3153554 | 0.0748359802428589
AA | 5 | 1.0388263 | 0.12
AA | 6 | 0.8675439 | 0.04
AA | 7 | 0.6685939 | 0.07
AA | 8 | 0.5918046 | 0.03069004492848541
AA | 9 | 0.5394239 | 0.03069004492848541
AA | 10 | 0.5176282 | 0.02944999788524578
AA | 11 | 0.5096999 | 0.02899892428022659
AA | 12 | 0.4879966 | 0.02776413425313213
AA | 13 | 0.4669618 | 0.0265673779413304
AA | 14 | 0.3817897 | 0.02172158676364352
AA | 15 | 0.376922 | 0.02144464328431606
AA | 16 | 0.3234115 | 0.02
DIV | NUM | PRICE | CONTRI | SUM | average
BB | 1 | 2.2305761 | 0.1269066511984466
BB | 2 | 1.9826327 | 0.1128001311022451
BB | 3 | 1.5937878 | 0.0906771449846251
BB | 4 | 1.3153554 | 0.0748359802428589
BB | 5 | 1.0388263 | 0.05910310206850727
BB | 6 | 0.9933398 | 0.05651518794634926
BB | 7 | 0.8675439 | 0.09
BB | 8 | 0.6685939 | 0.1
BB | 9 | 0.5918046 | 0.03367019845224569
BB | 10 | 0.5394239 | 0.01
BB | 11 | 0.5176282 | 0.04
BB | 12 | 0.5096999 | 0.02899892428022659
BB | 13 | 0.4879966 | 0.02776413425313213
BB | 14 | 0.4669618 | 0.0265673779413304
BB | 15 | 0.3817897 | 0.02172158676364352
BB | 16 | 0.376922 | 0.02144464328431606
BB | 17 | 0.3284382 | 0.01868620043389044
BB | 18 | 0.3284382 | 0.04
BB | 19 | 0.3284382 | 0.01868620043389044