tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 26d59c4b-58fb-49d5-95af-185510be1965
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 17. COMMERCIAL FINANCE COMMITMENTS, Fixed Loans By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2414226J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414227K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414228L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414229R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414230X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2414231A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414232C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2414233F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414234J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414235K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414236L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414237R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414238T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL FIXED LOANS ; |  |  | Original | A2414239V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 239724d1370000681-conditional-formatting-highlight-row-based-on-duplicates-in-different-columns-0aacftester-sheet
Sheet: Sheet1

Forename | Surname | Client ID | Date of Matter |  | Client ID Checked
[NAME] | Flamingo | 235 | 2012-06-14 00:00:00 |  | 196
Mungo | Moose | 236 | 2012-06-15 00:00:00 |  | 197
Quasemodo | Quail | 237 | 2012-06-16 00:00:00 |  | 198
[NAME] | Hippo | 238 | 2012-06-17 00:00:00 |  | 199
[NAME] | Lemur | 239 | 2012-06-18 00:00:00 |  | 200
[NAME] | [NAME] | 240 | 2012-06-19 00:00:00 |  | 235
[NAME] | Giraffe | 241 | 2012-06-20 00:00:00 |  | 240
Spreadsheet: 42853d1241498942-hours-demographic-hours-demographic
Sheet: Sheet2

Employee | Time In | Time Out | Hours | 1st Shift | 2nd Shift | 3rd Shift
[NAME] | 06:10:00 | 2009-01-01 13:59:00 | 2009-01-01 07:49:00 | 01:49:00 | 06:00:00 | 1900-01-01 00:00:00
[NAME] | 07:30:00 | 2009-01-02 08:30:00 | 2009-01-02 01:00:00 | 00:29:00 | 00:31:00 | 1900-01-01 00:00:00
[NAME] | 08:30:00 | 20:15:00 | 11:45:00 | 1900-01-01 00:00:00 | 07:29:00 | 04:16:00
 | 06:00:00 | 07:00:00 | 01:00:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Shift Start |  |  |  | 1900-01-01 00:00:00 | 08:00:00 | 16:00:00
Shift End |  |  |  | 07:59:00 | 15:59:00 | 23:59:00
So I'm working on a project that involves breaking down my employees hours into shifts 0000 - 07:59(3rd shift) / 08:00 - 15:59(1st shift) / 16:00 - 23:59(2nd shift) and I'm using a basic time clock where I punch in the time in and time out and it generates a total hours worked for the day.
What can I do to have excel break it down into those 3 shifts? Here's an example:
A B C D E F G
1 Employee Time In Time Out Hours 1st shift 2nd shift 3rd shift
[NAME] | 8:00 | 1:49
What formulas would I need to calculate E2 / F2 / G2 from the data in B2 / C2 / D2?
Spreadsheet: 788251d1658344364-extracting-specific-data-from-cells-into-columns-sample
Sheet: Exportify

[NAME] | Line Item Properties | CustomText | Font | Color
#15690
#15689
#15688
#15687
#15686 | custom_text: SANCHO_x000D_ font: Eras_x000D_ Color: Red | SANCHO | Eras | Red
#15681 | custom_text: Betty White_x000D_ font: Kembara_x000D_ Color: Black | [NAME] | [NAME] | Black
#15680 | Color: Purple
#15680 | Color: White
#15679 | custom_text: Red Five_x000D_ font: Jedi_x000D_ Color: Red
Spreadsheet: 711534d1609774353-summation-of-data-validated-list-date-changes-results-workbook-2
Sheet: SUMMARY 

 | DECEMBER |  |  |  | INTERRUPTION COUNT |  |  |  |  |  |  |  |  | NO OF HOURS LOST DUE TO |  |  |  |  |  |  |  |  | AVAILABILITY |  |  | SUMMARY
ZONE | NAME OF [NAME] | STATUS | MAX. LOAD | AV. LOAD | EF | OC | IMB | EMG | LS | LSG | SG | TX LIMIT | TOTAL | EF | OC | IMB | EMG | LS | LSG | SG | TX LIMIT | TOTAL | EXPECTED | ACHIEVED | CHECKER | FORCED OUTAGES | FORCED OUTAGES DURATION | LOAD SHEDDING COUNT | LOAD SHEDDING DURATION | STATION GUARANTEE COUNT | STATION GUARANTEE DURATION | TX INTERRUPTION COUNT | TX INTERRUPTION DURATION | LEGENDS | MEANING
 | IGI | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | IMB | IMBALANCE
 | AGMA | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | EMG | EMERGENCY
 | OLO | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | LS | LOAD SHEDDING
 | ASA | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | SG | STATION GUARANTEE
 | TBO | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | LSG | LOAD SHEDDING GUARANTEE
 | [NAME] | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | TX LIMIT | [NAME]
 | GIN | ACTIVE |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | EF | EARTH FAULTH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OC | OVER CURRENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SS | STATION SERVICES
TOTAL
Spreadsheet: 807130d1669756705-calculating-of-days-between-events-in-non-sequential-table-max-days-without-profit
Sheet: Sheet1

 | Open | Close | Profit | Days w/o Profit | Answer should be:
 | 2021-08-31 00:00:00 | 2021-08-31 00:00:00 | 80.22007588836506
 | 2021-09-01 00:00:00 | 2021-09-04 00:00:00 | 0
 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 0
 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 | 0
 | 2021-09-07 00:00:00 | 2021-09-07 00:00:00 | 0
 | 2021-09-10 00:00:00 | 2021-09-10 00:00:00 | 0
 | 2021-09-14 00:00:00 | 2021-09-14 00:00:00 | 0
 | 2021-09-15 00:00:00 | 2021-09-15 00:00:00 | 0
 | 2021-09-16 00:00:00 | 2021-09-18 00:00:00 | 21416.51493560476 |  | 0 | (Not sure about this. Although a trade which opened on the 17th closed on the 18th at 0 profit, so the correct answer could be 1)
 | 2021-09-17 00:00:00 | 2021-09-17 00:00:00 | 0
 | 2021-09-20 00:00:00 | 2021-09-20 00:00:00 | 100.4660950411429 |  | 0
 | 2021-09-21 00:00:00 | 2021-10-01 00:00:00 | 0
 | 2021-09-22 00:00:00 | 2021-10-02 00:00:00 | 0
Spreadsheet: vkaminski__40915__LJM Simulation3
Sheet: Raptor 4

Asset(s) Contributed | Type | Units |  | Contributed Share Price | Mkt. Price | Portfolio Value | Drift | [NAME] | Volatility | [NAME] | Terminal Value
ENE (Waterfall) | Forward | 6326045 |  | 84.88
Promissory Note
Cash
Total
Hedged Exposures
Collar on ENE
Raptor 4 Call Price | 112.418
Raptor 4 Put Price | 83
Spreadsheet: 455771d1460488423-vlookup-not-working-no-n-a-no-error-just-not-functioning-vlookup-example
Sheet: CPI

Client | CPI: Record Type indicator |  | Sales Organization | Distribution Channel |  | Customer number | Ship-to party | Material number used by customer |  |  | Material Number |  | Plant (Own or External) | Base Unit of Measure
MANDT | ZREC_TYPE |  | VKORG | VTWEG |  | KUNNR | KUNWE | [NAME] |  |  | MATNR |  | WERKS | [NAME]
 | 1 Customer ship-to load | Legacy Sales Org | ZPRO Order Sales Org | ZPRO Order Dist Channel | Legacy Customer Number | ZPRO Order Customer | ZPRO Order Ship To | ZPRO Order Customer Material Number | Material | Material entered | ZPRO Order MATNR | G3 MATERIAL NUMBER | ZPRO Order WERKS | From Material Master
020 | 1 | C361 | 0565 | 10 | 10350 | 10350 |  |  | 124245 | 124245 | 124245 |  | 4361 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 130905 | 130905 | 130905 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 130977 | 130977 | 130977 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 131142 | 131142 | 131142 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 131142 | 131142 | 131142 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 133753 | 133753 | 133753 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 134142 | 134142 | 134142 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 134156 | 134156 | 134156 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 134166 | 134166 | 134166 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 134292 | 134292 | 134292 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 145725 | 145725 | 145725 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 146511 | 146511 | 146511 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 146514 | 146514 | 146514 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 146790 | 146790 | 146790 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 147123 | 147123 | 147123 |  | 4531 | KG
020 | 1 | C531 | 5500 | 10 | 10350 | 10350 |  |  | 152021 | 152021 | 152021 |  | 4531 | KG
Spreadsheet: 767768d1644610154-create-a-summary-sheet-to-include-data-their-from-multiple-sheets-dummy-workbook
Sheet: Sheet4

 | Date | Time | Item | PO Number | Quantity  Ordered | Quantity  Delivered | Booking  Reference Number | STATUS
FEBRUARY | 2022-02-03 00:00:00 | 12:00 | Red Cedar | 449296 | 8000 | 8000 | 21435 | DELIVERED
 | 2022-02-10 00:00:00 | 12:00 | Red Cedar | 449296 | 8000 | 8000 | 21687 | DELIVERED
 | 2022-02-10 00:00:00 | 13:00 | Red Cedar | 449686 | 800 |  | 21845 | NOT DELIVERED
Spreadsheet: 1899e66a-f04c-407c-97f3-fa92d7770a67
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | FORM GC2 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  |  |  |  |  |  |  | Rev 02/29/2008
BUDGET REVISION REQUEST
Grant & Contract Accounts (Fund 12)
Date of Request: |  |  |  | Account Start Date:
Principal Investigator: |  |  |  | Account End Date:
Business Unit | Budget Account |  | Department | Program | Class | Proj/Grt | Present Budget | Revision Amount | Revised Budget Amount
 |  |  |  |  |  |  |  |  |  |  |  | 0502 - Salaries and Benefits
 |  |  |  |  |  |  |  |  |  |  |  | 0508 - Current Expense
 |  |  |  |  |  |  |  |  |  |  |  | 0511 - Capital Outlay
 |  |  |  |  |  |  |  |  |  |  |  | 0506 - Utilities
 |  |  |  |  |  |  |  |  |  |  |  | 51100 - Scholarships
 |  |  |  |  |  |  |  |  |  |  |  | 0513 - Indirect Cost
 |  |  |  |  |  |  |  |  |  |  |  | Other -
 |  |  |  |  |  | TOTALS | 0 | 0 | 0
Justification/Remarks: Please provide an explanation of the need for the requested action in relation to the programmatic effectiveness
of the project.  If the action is a budget revision request indicate why funds are available in the current budget and how the anticipated
expenditure(s) will directly benefit the project.  All budget requests should be approved prior to expenditure.  If sponsor approval or
other approval is required, please attach the approval documentation.
 |  | [NAME]:
 |  | Principal Investigator
 |  | Business Dean/Director
 |  | President/Director
 |  | Sponsored Projects Administration
 |  | Submit To: | Sponsored Projects Accounting
 |  |  | 300 North Main Street, Versailles, Kentucky 40383
 |  |  | Fax:  [PHONE]  [EMAIL]
Spreadsheet: 161438d1339519655-help-with-filling-in-a-list-from-different-tabs-maybe-index-function-summarysheetexample
Sheet: Brandon

Advertising Executive: | [NAME]
Designer: | [NAME]
Issue Date:
Advertiser | Slug | Special Placement?* | Size & Inches |  |  | Type of Ad |  |  | Color |  | Proof? | Price |  |  | Notes/Comments
 |  |  | Col. | Inch | Total Inches | CR | M | PU (specify date) | Color | 2nd Color (only for 2 spot color) |  | Already Paid | [NAME] | Trade
test1 |  |  | 4 | 4 |  |  |  |  | Spot Cyan | Spot Magenta
test2 |  |  | 5 | 5 |  |  |  |  | Black & White
test3 |  |  | 8 | 2 |  |  |  |  | Spot Green
*You must fill in this column if your ad is a full page ad |  |  |  |  |  |  |  |  | Color Options |  |  | Summary
 |  |  |  |  |  |  |  |  |  | Black & White |  | Total Inches:
 |  |  |  |  |  |  |  |  |  | Spot Cyan |  | Total Ads:
 |  |  |  |  |  |  |  |  |  | Spot Magenta |  | Total Ad Cost:
 |  |  |  |  |  |  |  |  |  | Spot Yellow |  | Flash:
 |  |  |  |  |  |  |  |  |  | Spot Green |  | Within 10% of flash?
 |  |  |  |  |  |  |  |  |  | Spot Red
 |  |  |  |  |  |  |  |  |  | Full Color
Spreadsheet: 327792d1403689374-comparing-cells-with-a-reference-source-and-skip-blanks-example
Sheet: Sheet1

Code No | 4021 | <- Cell to refer
 | No 1 | No 2 | No 3 | No 4 | Result
Case 1 | 4021 |  |  |  | OK
Case 2 | 4021 | 4021 |  |  | OK
Case 3 | 4021 | 4021 | 4021 |  | OK
Case 4 | 4021 | 4021 | 4021 | 4021 | OK
Case 5 | - | - | - | - | -
Case 6 | 4021 | 4022 |  |  | NG
Spreadsheet: 107297d1304502191-lookup-from-different-workbooks-20110425
Sheet: 20110425

ORACLE TIME & LABOR
 | Template Name : ABC
 | In the START_HEADER - STOP_HEADER section you can:
 | 1. Select an overriding approver from the POSSIBLE VALUES list.
 | 2. Enter comments being careful not to use a comma - enclose all details containing comma within double quotes.
In the START_TEMPLATE - STOP_TEMPLATE section you can:
 | 1. Delete an entire timecard line entry. Use the delete line function in the spreadsheet.
 | 2. Modify/Edit an hours entered.  Make your entry in the appropriate cell.
 | 3. Insert a new entry - above the STOP_TEMPLATE (reserved line).
 | Use the insert line function in the spreadsheet.
 | 4. Select POSSIBLE VALUES corresponding to the appropriate column headings.
 | 5. Enter comments being careful not to use a comma - enclose all details containing comma within double quotes.
 | DO NOT Make entries outside of the START_HEADER - STOP_HEADER or
 | START_TEMPLATE - STOP_TEMPLATE section.
 | DO NOT delete/edit the ORACLE RESERVED section.
START_HEADER
STOP_HEADER
START_TEMPLATE
Project/ABC Code | Task | Pay Code | Mon | Tue | Wed | Thu | Fri | Sat | Sun | END_COLUMN
NPS-AP001 | 16 | Basic Hours (HOURS) |  | 6.92 | 7.08 | 4.75
ABE | 2 | Absence (Hours) | 7.4 |  |  |  | 7.4
EGM5.1.1 | 200 | Basic Hours (HOURS) |  |  |  | 1
STOP_TEMPLATE
###############################
ORACLE RESERVED SECTION
###############################
START_ORACLE
A|PROJECTS|Attribute1|A|PROJECTS|Attribute2|A|OTL_ALIAS_1|Attribute1|D|D|D|D|D|D|D
321070
NO_HEADER
STOP_ORACLE | END
Spreadsheet: 89463d1289256945-list-values-formulaically-with-no-gaps-puzzle3
Sheet: Sheet1

 | aa.123 | [NAME] | cr.123
 | aa.1234 | bc.12 | [NAME]
 | ae.12 | bd.123
 | af.12
 | aa.123
 | ar.12345 | bb.123 |  | dt.1
 | af.12345 | bj.12 |  | do.1234
 | aj.123 | bj.1234 |  | di.1
 |  | bb.12
 |  | bb.12
 |  | bu.12
 |  | bm.1
Spreadsheet: 845612d1697046922-paste-vertically-to-excel-cells-of-horizontal-numbers-copied-from-webpage-horizontal-to-vertical-paste
Sheet: Sheet1

211001 , 211101 , 211201 , 211301 , 211503 , 211601 , 211701 , 211801 , 213801 , 214501
211901 , 212001 , 212101 , 212201 , 214001 |  |  |  |  |  |  |  |  |  |  | 211101
212305 , 212407 , 212505 , 212609 |  |  |  |  |  |  |  |  |  |  | 211201
212701 , 212801 , 212901 , 213001 , 213101 , 213201 , 213301 , 213401 , 213501 , 213601 , 213701 , 214401 |  |  |  |  |  |  |  |  |  |  | 211301
 |  |  |  |  |  |  |  |  |  |  | 211503
 |  |  |  |  |  |  |  |  |  |  | 211601
 |  |  |  |  |  |  |  |  |  |  | 211701
 |  |  |  |  |  |  |  |  |  |  | 211801
 |  |  |  |  |  |  |  |  |  |  | 213801
 |  |  |  |  |  |  |  |  |  |  | 214501
 |  |  |  |  |  |  |  |  |  |  | 211901
 |  |  |  |  |  |  |  |  |  |  | 212001
 |  |  |  |  |  |  |  |  |  |  | 212101
 |  |  |  |  |  |  |  |  |  |  | 212201
 |  |  |  |  |  |  |  |  |  |  | 214001
 |  |  |  |  |  |  |  |  |  |  | 212305
 |  |  |  |  |  |  |  |  |  |  | 212407
 |  |  |  |  |  |  |  |  |  |  | 212505
 |  |  |  |  |  |  |  |  |  |  | 212609
 |  |  |  |  |  |  |  |  |  |  | 212701
 |  |  |  |  |  |  |  |  |  |  | 212801
 |  |  |  |  |  |  |  |  |  |  | 212901
 |  |  |  |  |  |  |  |  |  |  | 213001
 |  |  |  |  |  |  |  |  |  |  | 213101
 |  |  |  |  |  |  |  |  |  |  | 213201
 |  |  |  |  |  |  |  |  |  |  | 213301
 |  |  |  |  |  |  |  |  |  |  | 213401
 |  |  |  |  |  |  |  |  |  |  | 213501
 |  |  |  |  |  |  |  |  |  |  | 213601
 |  |  |  |  |  |  |  |  |  |  | 213701
 |  |  |  |  |  |  |  |  |  |  | 214401
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Cash Treasury

Cash Treasury
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90006289 | [NAME], BARBARA A | Staff Acctg | SPECJR-CS
90005978 | HARALSON, NANCY L | Mgr Acctg | MGR-CS
90143440 | KROGMEIER, [NAME] | [NAME] | DIR-CS
90011686 | MYERS, THOMAS M | [NAME] | DIRSR-CS
90006856 | SOLIS, ALICIA Z | SR CLERK | ADMSR-CS
90006619 | STOKES, CYNTHIA L | [NAME] | ASSTSR-CS
 |  | Employees
Spreadsheet: sally_beck__33824__global standards daily reporting
Sheet: D 02

Quantitative Standards
Daily Exception Reports
Reports Supporting Quantitative Standards C
Note: | Can be used to capture all disputes.
Report D 02:
Purpose: | To capture disputes over 30 days (although can be used to track all disputes).
Trade Date | Deal # | Commodity | Counterparty | Description of deal | Description of item in dispute | Estimated P&L impact to GL gain / (loss) state currency | Key contact
2000-08-25 00:00:00 | Sample | Copper concentrates | ABC Co. | Purchase of 9,000 MT copper concentrate from mine. | Both buyer and seller assayed material.  Assays differ by (.95 to .98) quality copper. | Not yet determined | [NAME]
Spreadsheet: 699628d1602683185-quadratic-equation-of-the-line-linest
Sheet: Folha1

 | Your data - at least 4 points
 | x | 1 | 2 | 3 | 4
 | y | 1 | 3 | 9 | 32
 |  |  | -10.99999999999998 | 19.83333333333329 | -9.999999999999964
 | Your data transposed (at least 4 points) |  |  |  |  |  |  |  |  | Numerical method
 | x | y |  | Coeficients |  |  |  |  |  | For only 4 points - 3rd order polynomial
 | 1 | 1 |  |  | -10.99999999999998 | 19.83333333333329 | -9.999999999999964 |  |  | [NAME]
 | 2 | 3 |  |  |  |  |  |  |  | a_2 | 19.83333333333333
 | 3 | 9 |  |  |  |  |  |  |  | a_1 | -11
 | 4 | 32 |  |  |  |  |  |  |  | a_0 | 2.166666666666666
Spreadsheet: 737307d1624348398-different-pay-rates-for-different-hours-during-the-day-different-pay-rates-for-different-hours-during-the-day
Sheet: Award

Date: | 2013-05-13 00:00:00
Standard Time: | 06:30:00 | 18:00:00 | Rate: | 21.41 |  |  |  |  | spread of hours is 6.30 - 23.00 Monday to Sunday
Time @ 1.25 | 18:00:00 | 23:00:00 | Rate:
Time @ 1.5 | 1 day, 0:00:00 | 08:30:00 | Rate:
Saturday @ 1.25 | 6:30:00 | 23:00:00 | Rate: | 26.76
Sunday @ 2 | 6:30:00 | 09:00:00 | Rate:
Sunday @ 1l5 | 9:00:00 | 23:00:00 | Rate:
Day | Start Time | Finish Time | Standard hrs | Hrs @ 1.25 | Hrs @ 1.5 | Hrs @ 2
 |  |  |  |  |  |  |  |  | need help with formula for Saturday - all day is 1.25
 |  |  |  |  |  |  | Total |  | need help with formula for Sunday 6.30-9.00 x 2, 9.00-23.00 x 1.5
 |  | Sub Totals:
 |  |  |  |  |  |  |  |  | forgeting totally about overtime.
Spreadsheet: 34538d1231849157-using-a-range-as-a-search-value-terry
Sheet: Sheet2

Suname | Phone | Address | Last Done | Gap Period | Reminder |  |  |  |  |  | 335
[NAME] | 07712 345678 | A | 2007-12-25 00:00:00 | One Year | 2008-11-24 00:00:00 |  |  |  | 2009-01-13 00:00:00 |  | 160
Jones | 01234 567890 | B | 2007-11-25 00:00:00 | One Year | 2008-10-25 00:00:00
Edwards | 01987 654321 | C | 2008-02-13 00:00:00 | One Year | 2009-01-13 00:00:00
Smith | 04567 890123 | D | 2008-07-24 00:00:00 | One Year | 2009-06-24 00:00:00
Spreadsheet: 2965b295-e9d3-4374-92ee-6a9c3b8a628f
Sheet: Sheet1

Table S3. PLS model statistics for combined gene sets | 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
amino acid | [NAME] | Loadings on LV 1 (17.75%) | Loadings on LV 2 (17.80%) | Loadings on LV 3 (16.49%) | Loadings on LV 4 (15.38%) | Loadings on LV 5 (4.34%) | Q Residuals (28.24%) | Hotelling T^2 (71.76%) | Weights on LV 1 (17.75%) | Weights on LV 2 (17.80%) | Weights on LV 3 (16.49%) | Weights on LV 4 (15.38%) | Weights on LV 5 (4.34%) | Reg Vector for Expression
Ala | GCA | 0.318057 | -0.35842 | 0.0829528 | -0.0845264 | -0.375181 | 15.752 | 0.308009 | 0.0113204 | -0.0389326 | -0.0373801 | -0.0447421 | -0.0850463 | -0.297825
Ala | GCG | 0.13844 | 0.0783851 | -0.310174 | 0.0950918 | 0.399461 | 34.1877 | 0.29719 | 0.0099401 | -0.00285208 | -0.0321233 | -0.00879884 | 0.0299327 | -0.00405766
Ala | GCT | -0.279447 | 0.104115 | 0.213215 | 0.262298 | -0.451202 | 21.5623 | 0.394012 | -0.010135 | 0.0336756 | 0.0742192 | 0.068524 | -0.0207993 | 0.288083
Asp | GAC | 0.0298308 | 0.409155 | -0.306118 | -0.0884966 | 0.0948153 | 17.7011 | 0.118121 | 0.0108628 | 0.0239057 | -0.0313674 | -0.0263442 | 0.0135805 | 0.0301567
Asp | GAT | -0.30051 | -0.184434 | 0.179591 | -0.022244 | 0.129495 | 34.6181 | 0.0856559 | -0.0318538 | -0.0227042 | 0.00808635 | 0.00473148 | 0.00834241 | -0.20218
Gln | CAA | 0.387923 | -0.153802 | 0.342589 | -0.177706 | 0.119684 | 9.82909 | 0.148519 | 0.0369467 | 0.0175757 | 0.0424871 | 0.0111909 | -0.0130384 | 0.346535
Gly | GGA | -0.139319 | -0.188921 | 0.257275 | -0.351911 | 0.345728 | 19.5451 | 0.284527 | -0.0206305 | -0.0270099 | -0.0121816 | -0.0353048 | 0.018095 | -0.251042
Leu | CTT | -0.0640669 | 0.0649835 | 0.411491 | -0.339855 | -0.0710535 | 17.3563 | 0.1294 | 0.0024284 | 0.0210815 | 0.0385514 | -0.00666553 | -0.0227968 | 0.119416
Leu | TTG | 0.0302761 | 0.339025 | 0.249977 | -0.390886 | 0.0394795 | 10.9591 | 0.137284 | 0.0184275 | 0.0450757 | 0.0300368 | -0.0153596 | -0.0140739 | 0.250808
Lys | AAG | -0.00108616 | 0.419934 | 0.0540859 | -0.331474 | 0.133995 | 15.4074 | 0.142416 | 0.0161994 | 0.0457887 | 0.0175415 | -0.010063 | 0.0431627 | 0.287137
Phe | TTC | -0.309913 | 0.175658 | -0.0821154 | 0.241506 | 0.344329 | 26.008 | 0.25759 | -0.016078 | 0.023744 | 0.0397797 | 0.0588473 | 0.0794753 | 0.2513
Pro | CCG | 0.0974109 | 0.214525 | -0.343491 | 0.374828 | -0.0249417 | 14.1326 | 0.130363 | 0.0170816 | 0.0263555 | 0.00855571 | 0.0413169 | 0.0252319 | 0.281039
Ser | AGC | 0.486211 | -0.290396 | 0.0346033 | 0.150081 | 0.205851 | 3.78345 | 0.195672 | 0.0411362 | 0.00748794 | 0.0404916 | 0.0556172 | 0.106694 | 0.545288
Ser | AGT | -0.18885 | -0.195282 | 0.318319 | -0.387654 | 0.36788 | 7.06635 | 0.341473 | -0.0211727 | -0.0175146 | 0.0138592 | -0.00785951 | 0.106243 | -0.0257858
[NAME] | ACG | 0.39733 | -0.314537 | 0.282735 | -0.0384151 | 0.12255 | 6.28498 | 0.152375 | 0.0331853 | 0.00490711 | 0.0459759 | 0.0333709 | 0.0406403 | 0.395413