tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 16 Dec 19 - 20 Dec 19

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2019-12-16 00:00:00 | 2019-12-17 00:00:00 | 2019-12-18 00:00:00 | 2019-12-19 00:00:00 | 2019-12-20 00:00:00 | 2019-12-21 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 16/12/2019 - 20/12/2019
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | Deliveries | *** | ✓ |  | 0.2 | 0.8 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | *** |  | 0.2 | 0.8 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Nathan | ✓
[NAME] | ✓ | *** | ✓ | ✓ | *** |  | 0.4 | 0.6 |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | *** |  | 0.2 | 0.8 |  | [NAME] | ❌
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Tyson | ❌
Will | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
[NAME] |  |  |  |  |  |  |  |  |  | [NAME]
Daniel - Jaydee Roofing | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Daniel - Jaydee Roofing | ❌
Sharn - Valley Art Roofing |  |  |  |  |  |  |  |  |  | Sharn - Valley Art Roofing
Edge Protection [NAME] |  |  | 16/12/2019 - 20/12/2019 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 16/12/2019 - 20/12/2019
Blum |  |  | ✓ |  |  |  |  |  |  | Dameon | ✓
Northlink |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
63 Waterloo Road |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | Nathan | ❌
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | N/A
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Daniel - Jaydee Roofing | ❌
 |  |  |  |  |  |  |  |  |  | Sharn - Valley Art Roofing
Spreadsheet: 730592d1619782205-need-help-merging-info-from-two-tables-report-template-test
Sheet: Project X

 | PROGRAM Info (changes infrequently) |  |  |  | OVERALL STATUS |  |  | MILESTONES |  |  |  |  | ACCOMPLISHMENTS |  |  | RISKS & ISSUES |  |  |  |  |  | NEXT STEPS
 | Project ID | Project Name | Department | Project Manager | Target Completion Date | Status | Percent Complete | Weekly Update Section | Name | Due Date | Status | Health | Weekly Update Section | Name | Due Date | Weekly Update Section | Name | Due Date | Priority (Impact & Probability) | Status | Mitigations | Weekly Update Section | Name | Due Date | Status
 | 12 |  |  |  |  |  |  | <Milestones> | Text | Date | Status | [NAME] R- OffTrack A - At Risk G - On Track | <Recent Accomplishments> | Text | Date | <Key Issues / Risks> | Text | Date | Low /  Medium / High | Status Dropdown | Text | <Next Steps> | Text | Date | Status Dropdown
Spreadsheet: 725225d1616593749-help-on-data-lookup-example-2
Sheet: DATA

Ref | Surname | Forename | Payment Type | Pay Total
48 | One | Employee | Ops Bonus | 0
48 | One | Employee | Bank Hol Top Up | 0
48 | One | Employee | Furlough Top Up | 173.54
48 | One | Employee | 80% Furlough Pay | 1134.13
48 | One | Employee | Box Bonus | 0
48 | One | Employee | Overtime 1.5 | 0
48 | One | Employee | Salary | 887.98
48 | One | Employee | Cost of Net Payments | 0
48 | One | Employee | [NAME] | 0
48 | One | Employee | Overtime 1 | 0
48 | One | Employee | Savings scheme payout | 0
48 | One | Employee | Employee of the Quarter | 0
48 | One | Employee | Unpaid Time Off | 0
48 | One | Employee | Back Pay | 0
48 | One | Employee | Average Working Hours | 0
48 | One | Employee | 20% Holiday Top Up | 0
48 | One | Employee | Salary | 100
48 | One | Employee | [NAME] | 0
109 | Two | Staff | Back Pay | 0
109 | Two | Staff | [NAME] | 0
109 | Two | Staff | Salary | 0
109 | Two | Staff | Cost of Net Payments | 0
109 | Two | Staff | Long Service Bonus | 0
109 | Two | Staff | Salary | 312.18
109 | Two | Staff | Furlough Top Up | 98.4
109 | Two | Staff | 20% Holiday Top Up | 0
109 | Two | Staff | Bank Hol Top Up | 0
109 | Two | Staff | Overtime 1 | 0
109 | Two | Staff | Ops Bonus | 0
109 | Two | Staff | 80% Furlough Pay | 1112.7
109 | Two | Staff | Employee of the Quarter | 0
109 | Two | Staff | Average Working Hours | 0
Spreadsheet: 0a0fbe0a-6c9f-47e7-9fa4-ebc6d91b3cf0
Sheet: Staff Training

STAFF TRAINING
Include travel related costs for attendance at staff training as well as any costs incurred to conduct training.
Attach copies of training report forms and agendas when required training is held. The records will maintained in your organization's management plan.
Examples of training supplies include paper, brochures, folders, handouts, etc.
Date(s) of Training | Title and Description of Training Session | Facility Rental | Training Supplies | Equipment Costs | Registation Fees | Milage Cost | Lodging | Meals | Other | Total Cost Staff Training | % Allocated to CACFP | Total  Cost to CACFP
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  | Total Staff Training
Spreadsheet: 26b74ebf-a1bd-4cc3-9abc-8275f34d4081
Sheet: Milk Price Calculation Shee (2

When utilizing the Pricing Program, use the milk price calculation form to determine the price of milk charged to students.
Milk Price Calculation:
Milk Varieties | Amount of Milk Purchased for One Month Period                                         (Enter the Number of Half Pints Purchased) | Cost Per Half Pint of Milk | Cost for Each Type of Milk for the Month
 | 0 | 0
 | 0 | 0
Totals:
Weighted Average Cost:
Optional Handling Charge: (+$.05)
Current Reimbursement Rate for School Year 14-15: (+$.23)
Price Charged per Half Pint (Round to the nearest nickel):
Final Price Charged to Students :
Spreadsheet: 837ec7f8-0011-4203-ac7e-9ae879020f1f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Class1
GOCCID | Pvalue | OddsRatio | ExpCount | Count | Size | Term
GO:0031224 | 5.492099913353731e-05 | 1.47519176750216 | 136.527443691231 | 175 | 1007 | intrinsic to membrane
GO:0016021 | 0.000117194665437784 | 1.45231481481481 | 133.68029739777 | 170 | 986 | integral to membrane
GO:0071944 | 0.000176606077090271 | 1.48790736079481 | 101.954952984911 | 134 | 752 | cell periphery
GO:0044425 | 0.000259981795850225 | 1.39410840793532 | 164.45659304614 | 201 | 1213 | membrane part
GO:0042613 | 0.000335058880564048 | Inf | 0.542313579706976 | 4 | 4 | MHC class II protein complex
GO:0005792 | 0.0004762788857823201 | 2.29193403561026 | 14.1001530723814 | 27 | 104 | microsome
GO:0005886 | 0.000495497351878766 | 1.4510233621471 | 98.8366499015963 | 128 | 729 | plasma membrane
GO:0042598 | 0.000899336296334778 | 2.17650365373806 | 14.6424666520883 | 27 | 108 | [NAME]
Class2
GOCCID | Pvalue | OddsRatio | ExpCount | Count | Size | Term
GO:0005576 | 1.46719139550165e-07 | 2.17664319248826 | 41.5552153947081 | 74 | 296 | extracellular region
GO:0005615 | 1.99607007745644e-06 | 2.50889870998567 | 21.9007216269407 | 44 | 156 | extracellular space
GO:0044421 | 1.59070593272053e-05 | 2.15751584578706 | 27.2355127924776 | 49 | 194 | extracellular region part
Class3
No GO with an adjusted p-value < 0.001
Spreadsheet: 883742d1732429418-filtering-a-list-down-to-display-only-items-with-annual-due-dates-matching-current-month-bigpapamurf-sampleannual-1-spill-365-aligw
Sheet: Summary

Summary
 | Monthly Expenses (UFCU)
 | Fixed Expenses |  | Monthly Payment | Due Date |  | Monthly Memberships & Fees |  | Monthly Payment | Due Date |  | Annual Memberships & Fees |  | Annual Payment | Due Date
Spreadsheet: 120527d1315352315-maintaining-a-list-on-a-new-tab-based-on-multiple-criteria-question
Sheet: master

Age | Team | First | Last | Accepted  Invitation | Billed | Paid
7 | D | [NAME] | [NAME]
7 | D | [NAME] | pky | y | y
7 | D | George | noneili
7 | D | [NAME] | njasid
7 | D | [NAME] | kioihjwend | y | y | y
7 | D | [NAME] | lksaienfdo
7 | D | [NAME] | iiiwuuusmlkjhds | y | y
7 | D | Nat | [NAME] | y | y
7 | D | [NAME] | justttinlew
7 | D | [NAME] | dsaione
7 | D | [NAME] | spankyteou
8 | C | [NAME] | carsondufunbsports | y | y
11 | C | [NAME] | asdlijwas | y | y | y
8 | C | [NAME] | iawelknmcdsa | y | y | y
9 | C | [NAME] | aieacloa
8 | C | Eamon | aiemdalo
6 | C | Eli | dsaiwnmfcd | y | y | y
8 | C | Grant | cdowec | y | y | y
Spreadsheet: 160228d1339011860-excel-2007-how-to-create-an-average-formula-with-numbers-and-letters-excel-2011-mac-attendance
Sheet: Sheet1

1 | 1 | A | NA | 1 |  | 0.6
0 | 1 | 0 | 1 | A |  | 0.4
1 | # | 1 | 1 | ### |  | 0.6
0 | 1 | # | ### | 1 |  | 0.4
1 | 1 | 1 | 1 | 1 |  | 1
1 | 1 | 1 | na | 1 |  | 0.8
1 | 1 | A | NA | 1 |  | 0.6
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Spreadsheet: 788224d1658333000-finding-sections-of-a-string-of-variable-length-plate-size-proxy-file-v2
Sheet: Job Items

Section |  |  |  |  |  |  |  |  |  | [NAME] | Quantiy | Total Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plate size | Repetative Plates (Gus, Fin) | Plates (end Plates) | Plates Loose | Total Fin Plates | Total End Plates | Loose fin plates | loose end plates |  |  |  |  | Holes of different sizes/types |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total plate cost
plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x100x10 | 4 | 4 | 0 |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 1 | 1
plates |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x10 | 3 | 4 | 0 | 4 |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<    my old code with none of the fluff, yours should give the same value for the same size plate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100x200x30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<   your code
Spreadsheet: errol_mclaughlin_jr__10842__Gas stub period testing sample
Sheet: Sheet1

Deal Number | Book
VG7039.1 | NG-Price
VE4647.1 | NG-Price
VF8079.1 | NG-Price
VN0269.1 | G-Daily-Est
VQ2686.1 | FT-NY
VS3468.1 | NG-Price
VS3551.1 | NG-Price
VY6145.1 | NG-Price
Y32917.1 | NG-Price
Y37195.1 | NG-Price
Y51726.1 | NG-Price
Sitara_Deal_Id
827308 | Mid Central South
862053 | Gulf 3
865594 | New York
887103 | Im West
888501 | Gulf 1
911074 | Mkt Central CG
920032 | CNG
1015257 | Mkt Central CG
1048646 | Mkt Central CG
1066288 | Mid Central South
Spreadsheet: 55293d1255445379-automatically-creating-subtotals-based-on-non-sorted-categories-travel-expenses-template-1-
Sheet: Expense report

 | Expense report
 | PURPOSE: | [NAME] |  |  | Projects |  |  |  |  | Trip Dates | 20/09/2009
 |  |  |  |  |  |  |  |  |  |  | 23/09/2009
 | EMPLOYEE INFORMATION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense Cateogries
 | Name |  |  |  | Billable | Yes | Country |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public transport
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Car rental
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Internet
 | Date | Project | Value | Currency | Category | Comments | Conversion Rate | Total in Nis |  | Expense Cateogries | Total |  |  |  |  |  |  |  |  |  |  | Hotel
 | 20/09/2009 |  | 98 | EUR | Hotel | 1 night | 4 | 392 |  | Public transport | 0 |  |  |  |  |  |  |  |  |  |  | Airfare
 | 21/09/2009 |  |  | EUR | Hotel | 1 night |  | 0 |  | Car rental | 0 |  |  |  |  |  |  |  |  |  |  | Meals
 | 22/09/2009 |  |  | EUR | Hotel | 1 night |  | 0 |  | Internet | 0 |  |  |  |  |  |  |  |  |  |  | Other
 | 21/09/2009 |  | 2.8 | EUR | Public transport |  |  | 0 |  | Hotel | 392
 | 20/09/2009 |  | 830.2 | NIS | Airfare |  | 3.809998 | 3163.0603396 |  | Airfare | 3163.0603396
 |  |  |  |  |  |  |  | 0 |  | Meals | 0
 |  |  |  |  |  |  |  | 0 |  | Other | 0
 |  |  |  |  |  |  |  | 0 |  |  | 3555.0603396
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0 |  |  | Dinka
 |  |  |  |  |  |  |  | 0 |  |  | Registered User   Join Date: 13 Oct 2009
 |  |  |  |  |  |  |  | 3555.0603396 |  |  | Location: Israel
 |  |  |  |  | NOTES: |  |  |  |  |  | MS Office Version:Excel 2003
 |  |  |  |  |  |  |  |  |  |  | Posts: 1
 |  |  |  |  |  |  |  |  |  |  | Automatically creating subtotals based on non sorted categories
 |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/703089-automatically-creating-subtotals-based-on-non-sorted-categories.html
 |  |  |  |  |  |  |  |  |  |  | Hi,
 |  |  |  |  |  |  |  |  |  |  | I have a travel expenses spreadsheet, I need to be able to do the following:
 |  |  |  |  |  |  |  |  |  |  | 1. Enter and display information row by row (like in the spreadsheet attached)
 |  |  |  |  |  |  |  |  |  |  | 2. Be able to easily aggregate the information by expense category, meaning: total Hotel, total meals, total X for expense categories that are not 0.
 |  |  |  |  |  |  |  |  |  |  | Do you have any idea how to make 2 happen automatically when having 1?
 |  |  |  |  |  |  |  |  |  |  | Thank you!
Spreadsheet: 148749d1333547333-vlookup-based-on-2-or-more-criteria-sample
Sheet: Sheet2

Category | Life | Life 2 | Life 3
1 | 00:45:00 | 00:50:00 | 00:55:00
2 | 01:02:00 | 01:07:00 | 01:12:00
3 | 01:19:00 | 01:24:00 | 01:29:00
4 | 01:36:00 | 01:41:00 | 01:46:00
5 | 01:53:00 | 01:58:00 | 02:03:00
6 | 02:10:00 | 02:15:00 | 02:20:00
7 | 02:27:00 | 02:32:00 | 02:37:00
8 | 02:44:00 | 02:49:00 | 02:54:00
9 | 03:01:00 | 03:06:00 | 03:11:00
10 | 03:18:00 | 03:23:00 | 03:28:00
Spreadsheet: barry_tycholiz__827__Retention Payments
Sheet: Business Unit Payment

 |  |  |  | Payment Amount |  | 70000000
 |  |  |  | Power |  | Gas |  |  | Canada |  | Other
 |  |  | Headcount |  | Headcount |  |  | Headcount
 |  |  |  | East Power | 12 | East Gas |  |  | Gas/Power/Trading
 |  |  |  | West Power | 15 | Central Gas
 |  |  |  |  | 19 | West Gas
 |  |  |  |  | 19 | Fin Trading
 |  |  |  |  | 8 | Texas
 |  |  |  |  |  | Total Orig & Trading
 |  |  |  |  | 20 | [NAME]'s
 |  |  |  |  | 3 | Structuring
 |  |  |  |  | 5 | Weather
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Master

 | Houston
 |  | Gas Trading |  | (including NGLs) |  |  |  |  |  | 43
 |  | Gas Origination (includes Mexico) |  |  |  |  |  |  |  | 35
 |  | Admins |  |  |  |  |  |  |  | 12
 |  | Power Trading |  |  |  |  |  |  |  | 43
 |  | Power Origination |  |  |  |  |  |  |  | 14
 |  | Development Systems |  |  |  |  |  |  |  | 3
 |  | Admins |  |  |  |  |  |  |  | 4
 | Portland |  |  |  | Portland added 1-not sure if trading or orig |  |  |  |  | 1
 |  | Power Trading |  |  |  |  |  |  |  | 23
 |  | Power Origination |  |  |  |  |  |  |  | 13
 |  | Admins |  |  |  |  |  |  |  | 6
 | Canada |  |  |  | Canada added 11-not sure if trading or orig |  |  |  |  | 11
 |  | Trading |  |  |  |  |  |  |  | 11
 |  | Origination |  |  |  |  |  |  |  | 15
 |  | Admins |  |  |  |  |  |  |  | 5
 | Fundamentals
 |  | Houston (includes Competitor Analysis = 3) |  |  |  |  |  |  |  | 23
 |  | Portland |  |  |  |  |  |  |  | 7
 | Structuring
 |  | Houston |  |  |  |  |  |  |  | 3 | No Number Recommended
 |  | Portland |  |  |  |  |  |  |  | 2
 | Weather |  |  |  |  |  |  |  |  | 5 | No Number Recommended
 | Market Risk & Research |  |  |  |  |  |  |  |  | 11
 | Credit |  |  |  |  |  |  |  |  | 15
 | Regulatory Affairs |  |  |  |  |  |  |  |  | 9
 | Energy Operations
 |  | Gas Logistics |  |  |  |  |  |  |  | 32
 |  | Gas Book Running |  |  |  |  |  |  |  | 41
 |  | Gas Settlements |  |  |  |  |  |  |  | 21
 |  | Gas Volume Management |  |  |  |  |  |  |  | 7
 |  | Documentation |  |  |  |  |  |  |  | 30
 |  | Power Logistics |  |  |  |  |  |  |  | 14
 |  | Power Book Running |  |  |  |  |  |  |  | 11 | No Number Recommended
 |  | Power Settlements & Confirms |  |  |  |  |  |  |  | 9 | No Number Recommended
 |  | Power Volume Management |  |  |  |  |  |  |  | 13 |  |  | No Houston Dollars Recommended
 |  | Financial Settlements |  |  |  |  |  |  |  | 9
 |  | Management |  |  |  |  |  |  |  | 2
 | Technology
 |  | Infrastructure |  |  |  |  |  |  |  | 61
 |  | Development |  |  |  |  |  |  |  | 39
 |  | Software Ops & Maintenance |  |  |  |  |  |  |  | 77
 |  | Fundamentals |  |  |  |  |  |  |  | 8
 |  | DBA/livelink |  |  |  |  |  |  |  | 12
 |  | Management & Admins |  |  |  |  |  |  |  | 6
 | OOC |  |  |  |  |  |  |  |  | 4
 | EnronOnline |  |  |  |  |  |  |  |  | 44
 | HR |  |  |  |  |  |  |  |  | 13
 | Legal |  |  |  |  |  |  |  |  | 22
 | Accounting |  |  |  |  |  |  |  |  | 44
 | Transaction Support |  |  |  |  |  |  |  |  | 2 | No Number Recommended
 | Cash Operations |  |  |  |  |  |  |  |  | 6 |  |  | Only One Recommendation
 | SAP |  |  |  |  |  |  |  |  | -
 | [NAME] (including Legal but not HR) |  |  |  |  |  |  |  |  | 33
Spreadsheet: 738154d1624875196-accounting-functions-for-4-4-5-calendar-ac-4-4-5
Sheet: Sheet1

 |  | Start (w/b) | End (last day)
2021-01-04 00:00:00 | 1 | 2021-01-04 00:00:00 |  | 4
 | 2 |  |  | 4
 | 3 |  |  | 5
 | 4 |  |  | 4
 | 5 |  |  | 4
 | 6 |  |  | 5
 | 7 |  |  | 4
 | 8 |  |  | 4
 | 9 |  |  | 5
 | 10 |  |  | 4
 | 11 |  |  | 4
 | 12 |  |  | 5
Spreadsheet: 748091d1631885438-convert-xlookup-function-to-work-with-older-excel-versions-sample-workbook-mcc
Sheet: Attendance

First Name | Surname | [NAME] | Year Group | House Group | Tutor Class | Gender | Target Group | [NAME] | FME | Care | EMA | Action Taken
Pupil | 1 |  |  | Red | 1AS
Pupil | 2 |  |  | Red | 1AS
Pupil | 3 |  |  | [NAME] | 1AS
Pupil | 4 |  |  | [NAME] | 1AS
Pupil | 5 |  |  | Red | 1AS
Pupil | 6 |  |  | Red | 1AS
Pupil | 7 |  |  | Blue | 1B1
Pupil | 8 |  |  | Blue | 1B1
Pupil | 9 |  |  | Blue | 1B1
Pupil | 10 |  |  | Blue | 1B1
Pupil | 11 |  |  | Blue | 1B1
Pupil | 12 |  |  | Blue | 1B1
Pupil | 13 |  |  | Blue | 1B1
Pupil | 14 |  |  | Blue | 1B1
Pupil | 15 |  |  | Blue | 1B1
Pupil | 16 |  |  | Blue | 1B1
Pupil | 17 |  |  | Blue | 1B1
Pupil | 18 |  |  | Blue | 1B1
Pupil | 19 |  |  | Blue | 1B1
Pupil | 20 |  |  | Blue | 1B1
Spreadsheet: 036f0a3b-c70a-4ccc-83fb-d4d101a910de
Sheet: Sheet1

Water Quality Animal Concentration Tool
* Animal concentration factor = (A*M)*D
A = number of animals (assumes all are in the same animal sector as defined by the EPA)
M= Animal Sector multiplier
D = The total number of days in one calander year the animals are confined in the facility
* If more than one animal sector uses the facility, determine the Animal concentration factor for each sector then add together
Animal Sector | Multiplier (M) | # of Animals (A) | Days (D) | Animal Concentration Factor
Cattle or cow/calf pairs | 1
Mature dairy cattle | 1.4
veal calves | 1
swine (weighing over 55 lbs) | 0.4
Swine (weighing less than 55 lbs) | 0.1
horses | 2
sheep or lambs | 0.1
turkeys | 0.018
laying hens or broilers (liquid manure handling systems) | 0.033
chickens other than laying hens (other than liquid manure handling systems) | 0.008
laying hens (other than liquid manure handling systems) | 0.012
ducks (other than liquid manure handling systems) | 0.033
ducks ( liquid manure handling systems) | 0.2
Spreadsheet: 768147d1644853100-checking-to-see-if-multiple-values-from-one-list-exist-in-the-other-test-54-ans-1-
Sheet: Sheet1

Product | Match
apples
pears
bananas
kiwi
watermelon
grapes ft. cats
strawberries:pears
raspberries f/ coconut
blueberries & onions
avocado
spinach
tomatoes
potato
[NAME]
onions
courgettes
cucumber
lettuce
coconut
peppers
potato feat. Apples And pears
onions, cauliflower
apples & pears
ants, bats, cats
Spreadsheet: 788386d1658430491-find-particular-value-in-cell-after-a-certain-cell-value-example
Sheet: Valve

Valve
SALES PER EMPLOYEE
- Factory | -2.437961379310345 | -1.232678571428571 | -3.148943076923078 | -2.682687692307692 | -0.282624 | -2.4243936 | -5.508445 | -0.006135000000000002 | -7.210175 | 1.7466288 | -3.796889999999999 | -1.376235
- Fixed Support | -35.35044 | -17.2575 | -40.93626 | -34.87494 | -3.5328 | -30.30492 | -66.10134 | -0.07362000000000002 | -86.52210000000001 | 21.83286 | -45.56267999999999 | -16.51482
- Total Sales Per Employee | -2.280673548387097 | -1.1505 | -2.924018571428572 | -2.491067142857143 | -0.2616888888888889 | -2.244808888888889 | -5.084718461538461 | -0.005663076923076924 | -6.655546153846155 | 1.617248888888889 | -3.504821538461538 | -1.270370769230769
INVESTMENT
- Depreciation | 6.913789999999999 | 6.91374 | 6.815060000000001 | 6.96769 | 6.96786 | 6.968019999999999 | 6.967569999999999 | 6.96779 | 6.96788 | 6.88034 | 6.88029 | 7.334629999999999
Percent To Sales | -1.173471673902786 | -2.403734028683181 | -0.9988787446630445 | -1.198744427947403 | -11.83400135869565 | -1.379581929270891 | -0.6324443649705134 | -567.8720456397716 | -0.4831977032457603 | 1.890821449869601 | -0.9060428403245815 | -2.664744756527773
- Capital Spending (INPUT DATA) | 0 | 21 | 6 | -2 | 37 | 4 | 33 | -1 | 0 | 3 | 2 | 0
Spreadsheet: 859311d1707739497-find-results-from-multiple-columns-where-2-columns-will-be-greater-than-1-or-at-least-1-new-microsoft-excel-worksheet
Sheet: Sheet1

Retailer Name | JFB Shampoo | [NAME] | [NAME] | JFB Cream | RESULT
[NAME] | 1 | 0 | 0 | 0 | 0 |  | here the intention is that all columns might be Zero, but 2 columns need to atleast 1 or greater than 1 for Resulting 1
[NAME] | 2 | 1 |  |  | 1
[NAME] | 1 | 1 | 1 | 1 | 1
[NAME] | 1 | 0 | 0 | 1 | 1
[NAME] | 5 |  |  |  | 0
Sayem Store | 1 | 1 | 1 | 0 | 1
Spreadsheet: sara_shackleton__36407__PHONE_LIST
Sheet: ext. Bahia office

[NAME] do [NAME].
SALVADOR OFFICE
Av. [NAME], 450 - 19º andar - Conj. - 1901 - Salvador - Bahia - Brasil - CEP 41820-020                       Tel. 55 71 341 -7310    Fax. 55 71 341-7315
STAFF & SUPPORT TELEPHONE
NAME | DEPARTMENT | CELL PHONES
Mário Trindade | Institutional Relations | (071) 9142-7310
[NAME] | Region Directory | (071) 9145-8410
Taciana Amaral | Administrative Supervision | (071) 9141-8010
RECEPTIONIST | GENERAL | FAX
[NAME] | (071) 341-7310 | (071) 341-7315
Spreadsheet: 88625d1288395351-bg-color-every-other-group-based-on-criteria-alternate-shading-of-grouped-rows
Sheet: Sheet1

ID# | Name | BC Helper
123 | [NAME] | 1
123 | [NAME] | 1
245 | [NAME] | 2
554 | [NAME] | 1
554 | [NAME] | 1
554 | [NAME] | 1
442 | [NAME] | 2
442 | [NAME] | 2
Spreadsheet: darrell_schoolcraft__7786__imbalsumm0107
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 44045 | 39043
2 | 48392 | 43656
3 | 60040 | 58397
4 | 52770 | 47992
5 | 46964 | 48492
6 | 54280 | 54491
7 | 50994 | 46207
8 | 50704 | 46207
9 | 49822 | 46207
10 | 51841 | 47207
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00
2001-07-10 00:00:00