tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__33825__Quick Review of Commodity Logic
Sheet: Direct Expense

E N R O N   NETWORKS
2 0 0 1   P L A N |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D I R E C T   E X P E N S E S
 | SAP PROFIT CENTER: |  | 10733
 | PROFIT CENTER OWNER: |  | [NAME]
 | SAP COST CENTER/PROJECT: |  | 102838 |  |  |  |  |  |  |  |  |  | DUE DATE: | 2000-09-26 00:00:00
 | COST CENTER/PROJECT OWNER: |  | [NAME] |  |  |  |  |  |  |  |  |  | E-mail to [NAME] (3-4389)
 |  |  |  |  |  |  |  |  |  |  |  |  | or [NAME] (3-7805)
SAP COST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual
ELEMENT | DIRECT EXPENSES |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Expense
52000500 | Salaries & Wages
52000500 | Special Pays |  |  |  | 30000
 | Subtotal Compensation
52001000 | Benefits
59003000 | Payroll Taxes
 | Subtotal Benefits and Payroll Taxes
52003000 | Conferences & Training
52004000 | Employee Memberships & Dues
52003000 | Overtime/Working Meals
52503500 | Pager/Cellular Expenses
52004500 | Travel
52002000 | Tuition Reimbursement
52002500 | Other Employee Expenses
 | Subtotal Employee Expenses
52004500 | Campus Recruiting
54005000 | Employment Ads
54005000 | Interview Expenses
54005000 | Recruiting Agency Fees
52004500 | Relocation Expenses
54005000 | Other Recruiting & Relocation Expenses |  | 0
 | Subtotal Recruiting & Relocations
52508000 | Professional Consultants/Contractors
52507500 | Temporaries
52508000 | Other Outside Services
 | Subtotal Outside Services
52504000 | Company Membership & Dues
52508500 | Non-Real Time Market Data
53600000 | Office Supplies
52508100 | Postage & Freight Expense
52508500 | Real Time Market Data
52508500 | Subscriptions & Periodicals
53600000 | Other Supplies and Expenses
 | Subtotal Supplies and Expense
52500500 | Advertising & Promotions
52003500 | Client Entertainment
52003500 | Customer Meetings
52500500 | Other Marketing
 | Subtotal Marketing
52504100 | Charitable Contributions
53801000 | Rent - Office, Warehouse, & Tower
53800000 | Equipment Rental
 | Subtotal Rent (3rd Party)
52504500 | Technology(Input section below) |  | 7000 | 7000 | 7000 | 3500
54000000 | Transportation |  | 0
52502000 | Corporate IT
52502500 | Corporate Rent
54005000 | A&A Allocation
54005000 | Other Expenses
 | Subtotal Cash Expenses
57200000 | Depreciation
57000000 | Amortization
 | Subtotal Noncash Expenses
59099900 | Taxes Other than Income
 | TOTAL DIRECT EXPENSES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual
 |  |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Expense
Technology [NAME]
Hardware
Software
Licenses/Fees
Total
Spreadsheet: 690208d1596955194-filtering-subaccount-in-accounting-software-filtering-subaccounts-3-
Sheet: accounts

ეს ბლანქზე უნდა მოფილტრო და საბოლოო ანგარიშები ამოვა.
Accounts |  |  | Type |  | Description | Closing balance | [NAME]
1000 |  |  | აქტ |  | [NAME] | 1104840.05
1100 |  |  | აქტ |  | ნაღდი ფული სალაროში | 7116.72
1110 |  | 1 | აქტ |  | ნაღდი ფული ეროვნულ ვალუტაში | 7116.72
1200 |  |  | აქტ |  | ფული საბანკო ანგარიშებზე | 34703.46
1210 |  |  | აქტ |  | ეროვნული ვალუტა რეზიდენტ ბანკში | 24373.54
1210 2 |  | 1 | აქტ |  | ბანკი ქართუ | 19373.54
1210 3 |  | 1 | აქტ |  | ბიზნეს ბარათი ქართუ | 0
1210 1 |  | 1 | აქტ |  | საქართველოს ბანკი | 5000
1220 |  |  | აქტ |  | უცხოური ვალუტა რეზიდენტ ბანკში | 10329.92
1220 2 |  | 1 | აქტ |  | ბანკი ქართუ EUR | 0
1220 3 |  | 1 | აქტ |  | ბანქი ქართუს ბიზნეს ბარათი USD | 0
1220 6 |  | 1 | აქტ |  | ბიზნეს ბარათი EUR | 0
1220 1 |  | 1 | აქტ |  | ქართუ ბანკი USD | 10329.92
1400 |  |  | აქტ |  | მოკლევადიანი მოთხოვნები | 548383.37
1410 |  |  | აქტ |  | მოთხოვნები მიწოდებიდან და მომსახურებიდან | 529335.07
1410 1422 |  | 1 | აქტ |  | CITY AND CO LTD, 404398077 | 111
1410 1422 3 |  |  |  |  |  | 11 |  | This must'not be selected as it has subaccount.
1410 1422 3 4 |  |  |  |  |  | 10
1410 14223 |  |  |  |  |  | 212
1410 1399 |  | 1 | აქტ |  | [NAME] მალიბუ ფლაუერს, 405229015 | 2
Spreadsheet: 0a3354a0-0890-44bd-a508-d6e7c890ae93
Sheet: College - AVTS Calculator

.
 |  |  |  |  |  |  | Return to Index
Enrolled Minutes Calculator
College - AVTS
Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday
 | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins
 |  |  | 0:00:00 |  |  |  | 0:00:00 |  |  |  | 0:00:00 |  |  |  | 0:00:00
 |  |  | 0:00:00 |  |  |  | 0:00:00 |  |  |  | 0:00:00 |  |  |  | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
 |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes
 |  | Minutes per Day
Spreadsheet: 69210121-827c-407e-84fe-4230a558bb0e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2689 | 6001 | Sarka | [NAME] | CZE | 0 | 00:27:24 | 00:00:00 | 00:25:23 | 00:00:00 | [NAME] | 1 | 01:21:40
2689 | 19464 | Natalia | Lovece | ARG | 0 | 00:34:45 | 00:00:00 | 00:39:54 | 00:00:00 | 00:36:57 | 2 | 01:51:36
2689 | 19466 | Analia | Villalba | ARG | 0 | 00:32:54 | 00:00:00 | 00:45:11 | 00:00:00 | 01:14:15 | 3 | 02:32:20
Spreadsheet: 60870825-2c35-4ec5-b97c-807730be81f1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6986 | 46826 | Ching | [NAME] | MAC | 56 | 00:20:36 | 00:00:00 | 00:40:52 | 00:00:00 | 00:10:49 | 1 | 01:12:18
6986 | 28118 | [NAME] | [NAME] | HKG | 55 | 00:21:09 | 00:00:00 | 00:40:17 | 00:00:00 | 00:12:46 | 2 | 01:14:14
6986 | 47056 | Suwan | Pimsachee | THA | 0 | 00:23:02 | 00:00:00 | 00:42:44 | 00:00:00 | 00:14:15 | 3 | 01:20:04
6986 | 47057 | Lei | [NAME] | MAC | 0 | 00:23:18 | 00:00:00 | 00:43:23 | 00:00:00 | 00:14:45 | 4 | 01:21:26
Spreadsheet: 138219d1327574798-excel-2007-pivot-chart-cant-filter-values-sample
Sheet: Chart tables

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row Labels | Idle assets | Under Repair | Awaiting  for deployment | Awaiting  for destruction | To be sold | Unknwnown location
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February | 1600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | March | 436
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | April | 475
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May | 436
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June | 647
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | July | 473
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August | 360
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September | 754
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October | 360 | 113 | 100 | 19 | 120 | 150
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November | 754
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December | 1050
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 8345 | 113 | 100 | 19 | 120 | 150
Spreadsheet: 710259d1608812761-need-a-change-in-if-formula-to-get-the-exact-result-in-house-production-tracking-with-completion-
Sheet: STOCK

DATE | QUALITY | WIDTH | METER
 | BASKET N FLEUR | 135
 | PAISLEY | 135 | 200
 | PAISLEY | 125 | 100
 | SOLITAIRE | 135 | 500
Spreadsheet: 174268d1344981282-calendar-and-forecasts-template-1-1-1-
Sheet: JULY EXPENSES

July
Recurring Expenses
Number of direct debits |  | 5 |  | Number of consisent payments
 |  | £ |  |  |  | £
2012-07-09 00:00:00 | KELVIN PARTNERSHIP | 90 |  | 2012-07-09 00:00:00 | PAUL SEATON | 100
2012-07-16 00:00:00 | CARDSAVE | 32.4 |  | 2012-07-05 00:00:00 | [NAME] | 364
2012-07-16 00:00:00 | SAGE PAY EUROPE | 24 |  | 2012-07-25 00:00:00 | PAUL SEATON | 100
2012-07-19 00:00:00 | STREAMLINE | 20 |  | 2012-07-30 00:00:00 | AREZOO FARZIN | 1100
2012-07-26 00:00:00 | Safe storage | 240
2012-07-24 00:00:00 | SAFESTORE store room and insurance | 285.97
 | Total |  |  |  | Total
 |  |  | Total
Spreadsheet: 93895d1293658320-formula-for-sport-rankings-cagrapplerrankings2010
Sheet: 160

Ranking | First Name | Last Name | School | Section | Grade
1 | [NAME] | Hammond | Bakersfield | CS | 12 | 2010 CIF 1
2 | Vincent | Waldhauser | Oak Ridge | SJ | 12 | 2010 CIF 2
3 | [NAME] | Wilson | Mcnair | SJ | 11 | 2010 CIF 4
4 | Bradley | [NAME] | [NAME] | SS | 12 | 2010 CIF 5
5 | Trent | Noon | Oakdale | SJ | 12 | 2010 CIF 7
6 | Dillon | [NAME] | Red Bluff | NS | 12 | 2010 CIF 8
7 | Bret | Schumann | Orland | NS | 12 | zink 1
8 | Blake | Thompson | Clovis | CS | 12 | zink 2
9 | Alfredo | Nava-Arroyo | Santiago | SS | 12 | reno 3
10 | [NAME] | Heagney | Poway | SD | 12 | reno 7
11 | [NAME] | Call | [NAME] | SJ | 12 | reno t12
Spreadsheet: 47447d1246472154-find-text-format-row-help-combining-codes-sample
Sheet: Sheet2

Name | Address | City | State | Cash | Credit | %cash
A | 123 | NY | NY | 12 | 247 | 0.048582995951417
A | 456 | NY | NY | 2407 | 2642 | 0.9110522331566995
A | 789 | NY | NY | 234 | 23423 | 0.009990180591726081
A | 1 | NY | NY | 2629 | 2864 | 0.9179469273743017
A | 2 | NY | NY | 234 | 1244 | 0.1881028938906752
A Total |  |  |  | 5516 | 30420 | 2.075675230964819
B | 3 | NY | NY | 2629 | 12444 | 0.2112664738026358
B | 5 | NY | NY | 423 | 658 | 0.6428571428571429
B | 6 | NY | NY | 234 | 245 | 0.9551020408163265
B Total |  |  |  | 3286 | 13347 | 1.809225657476105
C | 2 | NY | NY | 2629 | 2864 | 0.9179469273743017
C Total |  |  |  | 2629 | 2864 | 0.9179469273743017
D | 5 | NY | NY | 234 | 469 | 0.4989339019189765
D | 2 | NY | NY | 2629 | 12444 | 0.2112664738026358
D | 5 | NY | NY | 234 | 342 | 0.6842105263157895
D Total |  |  |  | 3097 | 13255 | 1.394410902037402
E | 2 | NY | NY | 2629 | 2864 | 0.9179469273743017
E Total |  |  |  | 2629 | 2864 | 0.9179469273743017
Grand Total |  |  |  | 17157 | 62750 | 7.115205645226929
Spreadsheet: 164216d1340694588-vlookup-multiple-sheets-plist
Sheet:  Bak

 | Section Size |  | ft/m | PRICE
 | Thickness mm | [NAME]   [NAME]
item |  |  |  | Company A | Company B | Company C | Company D | Company E
bak | 19.0 | 150.0 | 20'/6m | 148 | 147 |  |  | 144
bak | 25.0 | 150.0 | 20'/6m |  |  |  | 198
bak | 12.0 | 25.0 | 20'/6m |  |  |  |  | 16
Spreadsheet: 754602d1636372729-if-value-is-0-hide-the-result-in-a-cell-nascondere-8-
Sheet: Foglio1

 | 100
gen | 0 | 0 |  |  |  |  | if B3= 0 hide the result in G3
feb | 0 | 0 |  |  |  |  | if B4= 0 hide the result in G4
[NAME] | 0 | 0 |  |  |  |  | if B5= 0 hide the result in G5
apr | 0 | 0 |  |  |  |  | etc..
mag | 0 | 0 |  |  |  |  | etc..
[NAME] | 0 | 0 |  |  |  |  | etc..
lug | 50 | 150 |  | 30 |  |  | etc..
ago | 0 | 0 |  |  |  |  | etc..
set | 0 | 0 |  |  |  |  | etc..
ott | 0 | 0 |  |  |  |  | etc..
nov | 0 | 0 |  |  |  |  | etc..
dic | 0 | 0 |  |  |  |  | etc..
Spreadsheet: 85958d1285944499-error-with-if-statement-oct-march-1011-termtime-only
Sheet: October

 | YOUTH ASSOCIATION SOUTH YORKSHIRE - STAFF TIMESHEET
 | Name
 | Date | Start AM | Finish | Start PM | Finish | Holiday | Sick | Total | Project/Location/Outputs
Monday | 2010-10-04 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2010-10-05 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2010-10-06 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2010-10-07 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2010-10-08 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2010-10-11 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2010-10-12 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2010-10-13 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2010-10-14 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2010-10-15 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2010-10-18 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Tuesday | 2010-10-19 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Wednesday | 2010-10-20 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Thursday | 2010-10-21 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Friday | 2010-10-22 00:00:00 | 12:00:00 |  |  | 17:00:00 |  |  | 5.000000000000001
Saturday | Weekend |  |  |  |  |  |  | 0
Sunday | Total |  |  |  |  | 0 | 0 | 25
Monday | 2010-10-25 00:00:00 |  |  |  |  |  |  | 0 | Half term
Tuesday | 2010-10-26 00:00:00 |  |  |  |  |  |  | 0 | Half term
Wednesday | 2010-10-27 00:00:00 |  |  |  |  |  |  | 0 | Half term
Thursday | 2010-10-28 00:00:00 |  |  |  |  |  |  | 0 | Half term
Friday | 2010-10-29 00:00:00 |  |  |  |  |  |  | 0 | Half term
Saturday | Weekend |  |  |  |  |  |  | 0 | Half term
Sunday | Total |  |  |  |  | 0 | 0 | 0
 |  |  |  |  | Total | 0 | 0 | 75.00000000000001
 |  |  |  |  | Please print off, sign and
 |  |  |  |  | submit this timesheet by Friday 6th November
 | Signed | ………………………………………
 | Date | ………………………………………
 | Notes/Comments
Spreadsheet: 111048d1307549715-iterative-calculation-issues-v3-returns-analysis
Sheet: Returns Analysis

Enterproid Returns Analysis
June 2011
 | Exit Price | 125000000
 |  | Investment | FD % Ownership | [NAME] | [NAME] | Total Return | Cash-on-Cash | [NAME] to Common?
 | Series Seed Investment | 2002951.55851 | 0.3115681910244302 | 1
 | Series A Investment | 10000000 | 0.2222222222222222 | 3
 | Common | 0 | 0.4662095867533476
 | Seies Seed Liq Preference
 | Series A Liq Preference
 | Proceeds Remaining to Common
 | [NAME]
 | Seed Return
 | Series A Return
Spreadsheet: 1a02e5be-3a5d-44b3-a225-ae91879cf9f0
Sheet: Sheet1

VOLLEYBALL REPORTING FORM | 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
Date: |  |  | School:
Visitor:
Home:
 |  |  |  |  | Individual Statistics
Player |  |  | Games |  | Kills |  | Assists |  | [NAME] |  | Blocks |  | Aces
Record:
Spreadsheet: 764053d1642546624-find-last-entry-in-row-with-empty-cells-test-3
Sheet: TEST

 |  |  |  | DATE | PO | DATE | PO | DATE | PO | DATE | PO
 |  |  |  | 2021-02-23 00:00:00 | ERIC-23022021-01 | 2021-03-15 00:00:00 | ERIC-15032021-03 | 2021-05-01 00:00:00 | ERIC-01052021-02 | 2021-09-22 00:00:00 | ERIC-22092021-06
 | CODE | [NAME] | LAST PRICE | QTY | PRICE | QTY | PRICE | QTY | PRICE | QTY | PRICE
 | AAA-0001 | TUBE ABS 2'' X 12' |  | 250 | 2.25 |  |  | 300 | 2.75
 | AAA-0002 | TUBE ABS 3'' X 12' |  |  |  | 125 | 2.35
 | AAA-0003 | TUBE ABS 4'' X 12' |  | 175 | 4 |  |  |  |  | 225 | 5.64
 | AAA-0004 | TUBE ABS 5'' X 12' |  |  |  |  |  | 75 | 6.35 | 75 | 6.55
 | AAA-0005 | TUBE ABS 6'' X 12' |  | 10 | 12 | 150 | 6.75
 | AAA-0006 | TUBE ABS 7'' X 12' |  |  |  |  |  |  |  | 50 | 14
Spreadsheet: chris_germany__1969__MARGAS
Sheet: feb02

sold gas to txu at the prices below
2002-02-01 00:00:00 | 13000 | 2.05
2002-02-02 00:00:00 | 13000 | 2.11
2002-02-03 00:00:00 | 13000 | 2.11
2002-02-04 00:00:00 | 13000 | 2.11
2002-02-05 00:00:00 | 13000 | 2.05
2002-02-05 00:00:00 | 22000 | 2.03
2002-02-06 00:00:00 | 45000 | 2.05
2002-02-07 00:00:00 | 13000 | 2.01
2002-02-08 00:00:00 | 45000 | 2.04
2002-02-09 00:00:00 | 13715 | 2.07
2002-02-09 00:00:00 | 31285 | 2.05
2002-02-10 00:00:00 | 13715 | 2.07
2002-02-10 00:00:00 | 31285 | 2.05
2002-02-11 00:00:00 | 13715 | 2.07
2002-02-11 00:00:00 | 31285 | 2.05
2002-02-12 00:00:00 | 45000 | 2.08
2002-02-13 00:00:00 | 45000 | 2.24
2002-02-14 00:00:00 | 45000 | 2.21
2002-02-15 00:00:00 | 45000 | 2.1
2002-02-16 00:00:00 | 45000 | 2
2002-02-17 00:00:00 | 45000 | 2
2002-02-18 00:00:00 | 45000 | 2
2002-02-19 00:00:00 | 45000 | 2
2002-02-20 00:00:00 | 45000 | 2.08
2002-02-21 00:00:00 | 45000 | 2.27
2002-02-22 00:00:00 | 45000 | 2.19
2002-02-23 00:00:00 | 45000 | 2.16
2002-02-24 00:00:00 | 45000 | 2.16
2002-02-25 00:00:00 | 45000 | 2.16
2002-02-26 00:00:00 | 45000 | 2.32
2002-02-27 00:00:00 | 45000 | 2.32
2002-02-28 00:00:00 | 45000 | 2.3
Spreadsheet: 271352d1381918704-looking-for-a-formula-possibly-v-or-h-lookup-or-match-test2
Sheet: Outstanding Jobs

Asset | Remedial Work Order | Description | [NAME] Date
2001 | ABC001 | Job A
2002 | ABC002 | Job B
2003 | ABC003 | Job C
2004 | ABC004 | Job D
2005 | ABC005 | Job E
2006 | ABC006 | Job F
2007 | ABC007 | Job G
Spreadsheet: 186969d1350310062-is-there-anyway-that-i-could-filter-my-spreadsheet-without-unmixing-the-cells-a-second-example-of-my-attempt
Sheet: Plan1

Name of The Institution | Name of The 1st Resp. | Date of Reg. 1st Resp. | Name of the 2nd Resp | Date of Reg. 2nd | Operators
ANATEL | [NAME] | 2012-10-10 00:00:00 | [NAME] | 2012-10-11 00:00:00 | X | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 |  |  |  |  |  | Sun. | Mon. | Tue. | Wed. | Thu. | Fri. | Sat. |  | Sun. | Mon. | Tue. | Wed. | Thu. | Fri. | Sat. |  | Sun. | Mon. | Tue. | Wed. | Thu. | Fri. | Sat.
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  |  | 1 | 2 | 3 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  |  |  | 14 | 15 | 16 | 17 | 18 | 19 | 20 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  |  |  |  |  | 21 | 22 | 23 | 24 | 25 | 26 | 27 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 |  |  |  |  |  | 28 | 29 | 30 | 31 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 |  |  | 23/30 | 24/31 | 25 | 26 | 27 | 28 | 29
Spreadsheet: 108931d1305844430-index-and-match-matching-with-one-more-item-item-a-and-b-account-manager-mutual-fund-sales
Sheet: Table

District | Team | Employee Name | Staff ID | Product | Group | Sales  Volume | Sales  Value | Transfer from fund to other fund Volume# | Transfer fund to LT MF Value | Sales Volume YTD | Sales Value YTD | Transfer from fund to other fund  Volume# [NAME] | Transfer fund to LT MF  Value YTD
11111 | Team 1 | [NAME] | Ab12 | Long Term Mutual Fund | MIP | 1 | 100 | 3 | 500 | 80 | 9000 | 15 | 1000
 |  | [NAME] | Ab12 |  | Others | 2 | 700 | 5 | 700 | 90 | 8999 | 23 | 2000
 |  | [NAME] | [NAME] | Long Term Mutual Fund | Others | 1 | 800 | 6 | 599 | 70 | 7888 | 80 | 2000
 |  | [NAME] | Ab15 | Money market | MIP | 3 | 900 | 8 | 660 | 80 | 6700 | 70 | 1500
 | Team 2 | [NAME] | 2003 | Long Term Mutual Fund | Others | 13 | 600 | 6 | 800 | 25 | 8000 | 80 | 6000
 |  | [NAME] | 2003 |  | MIP | 11 | 222 | 5 | 200 | 40 | 8000 | 70 | 8099
 | Team 3 | [NAME] | 2008 | Money market | others | 4 | 500 | 5 | 700 | 88 | 8800 | 90 | 7000
 | Team 3 | [NAME] weatherhead | 2099 | Long Term Mutual Fund | others | 4 | 500 | 5 | 700 | 88 | 8800 | 90 | 3000
 |  | [NAME] weatherhead | 2099 |  | MIP | 2 | 500 | 8 | 800 | 99 | 7000 | 100 | 90000
 |  | [NAME] weatherhead | 2099 | Money market | others | 10 | 200 | 8 | 800 | 99 | 7000 | 60 | 8000
Spreadsheet: 24117d1214237538-sorting-offset-vlookup-nms2130sample
Sheet: Sheet1

555222 | NICK |  |  | 555222 | 555235 | 555248 | 555261 | 555274 | 555287 | 555300 | 555313 | 555326 | 555339 | 555352 | 555365 | 555378 | 555391 | 555404 | 555417 | 555430 | 555443 | 555456 | 555469 | 555482 | 555495 | 555508
555235 | NICK |  |  | NICK | NICK | NICK | NICK | NICK | NICK | NED | NED | NED | NED | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | MARY | MARY | MARY | OSCAR | OSCAR | OSCAR | OSCAR | OSCAR
555248 | NICK
555261 | NICK
555274 | NICK
555287 | NICK
555300 | NED
555313 | NED |  |  | RESULTS DESIRED:
555326 | NED
555339 | NED |  |  | 555222 | 555235 | 555248 | 555261 | 555274 | 555287
555352 | [NAME] |  |  | NICK | NICK | NICK | NICK | NICK | NICK
555365 | [NAME]
555378 | [NAME]
555391 | [NAME] |  |  | 555300 | 555313 | 555326 | 555339
555404 | [NAME] |  |  | NED | NED | NED | NED
555417 | MARY
555430 | MARY
555443 | MARY |  |  | 555352 | 555365 | 555378 | 555391 | 555404
555456 | OSCAR |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
555469 | OSCAR
555482 | OSCAR
555495 | OSCAR |  |  | 555417 | 555430 | 555443
555508 | OSCAR |  |  | MARY | MARY | MARY
 |  |  |  | 555456 | 555469 | 555482 | 555495 | 555508
 |  |  |  | OSCAR | OSCAR | OSCAR | OSCAR | OSCAR
Spreadsheet: 882472d1730862571-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r2
Sheet: Dec

Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | Travel mileage (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | What was training subject 3? (select from drop down list) | Training subject 3 (if appropriate) - how much time (hours) did you train on this today? | Ad-hoc fee - If you completed approved training or a service that is not on the list or is ad-hoc briefly summarise here. Include as much detail as is needed. | Rate | Count | Value
[NAME] | [NAME] | I have completed today's training | 2022-12-01 00:00:00 | Student to Trainer |  |  | MS Word | 2 |  |  |  |  |  | 31.5
[NAME] | Amanda [NAME] | I have completed today's training | 2022-12-05 00:00:00 | Remote training via Zoom video conferencing |  |  | [NAME] | 1 | Windows | 0.5 |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-12-06 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 2 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed a TNA | 2022-12-07 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 50 | 1 | 50
[NAME] | Amanda [NAME] | I have completed today's training | 2022-12-07 00:00:00 | Remote training via Zoom video conferencing |  |  | Windows | 1 | Keyboarding | 0.5 |  |  |  | 31.5
[NAME] | [NAME] | I am notifying a non-attendance | 2022-12-08 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 30 | 1 | 30
[NAME] | Amanda [NAME] | I have completed today's training | 2022-12-12 00:00:00 | Remote training via Zoom video conferencing |  |  | Keyboarding | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-12-13 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 2 |  |  |  |  |  | 31.5
[NAME] | Amanda [NAME] | I have completed today's training | 2022-12-14 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Word | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I am notifying a non-attendance | 2022-12-15 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 30 | 1 | 30
[NAME] | Amanda [NAME] | I have completed today's training | 2022-12-19 00:00:00 | Remote training via Zoom video conferencing |  |  | [NAME] | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2022-12-20 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1 | Google Drive | 1 |  |  |  | 31.5