tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94792d1294556829-index-match-data-validation-and-named-ranges-in-the-attached-file-scm-employees_1
Sheet: Transportation

Name | SAC # | Job Title | Position Grade | Current Grade | Date - Last Promotion | Rating - 2009 | Rating - 2010 | Experience (in Company) | Experience (in the Division) | Secondary School | Diploma | Degree | English Level | CDC Status | Other Comments
YMY | 22743 | Manager | 19 | 19 | 2007-04-01 00:00:00 | 2 | ? |  |  | X |  |  | 5 | Achieved
FSM | 22706 | Supt. | 18 | 18 | 2010-07-01 00:00:00 | 1 | ? |  |  |  |  |  | 5 | Achieved
YAS | 22573 | Supv. | 17 | 17 | 2010-07-01 00:00:00 | 1 | ? |  |  | x |  |  | 5 | Achieved
MHD | 22727 | [NAME] | 9 | 9 | 2010-05-01 00:00:00 | ? | ? |  |  | x |  |  | 5 | Achieved
GMO | 22679 | Inspector | 9 | 9 | 2009-04-01 00:00:00 | 2 | ? |  |  | x |  |  | 4.5 | Inprogress
MMQ | 22783 | [NAME] | 9 | 9 | 2009-04-01 00:00:00 | 2+ | ? |  |  | x |  |  | 5 | Achieved
MSA | 22670 | [NAME] | 9 | 9 | 2009-04-01 00:00:00 | 2 | ? |  |  | x |  |  | 5 | Inprogress
KSS | 22810 | [NAME] | 9 | 7 | 2009-04-01 00:00:00 | 2- | ? |  |  | x |  |  | 5 | Inprogress
TGO | 22691 | [NAME] | 9 | 4 | 2008-10-01 00:00:00 | 2- | ? |  |  | x |  |  | 5 | Inprogress
Spreadsheet: 1e6cce0b-2348-4966-bb3f-8a6a81c01091
Sheet: Customers1

Contact Name | Address | City | Postal Code | Country | Phone
Ana Trujillo | [NAME] [NAME] | México D.F. | 5021 | Mexico | (5) 555-4729
[NAME] | Mataderos  2312 | México D.F. | 5023 | Mexico | (5) 555-3932
Christina Berglund | Berguvsvägen  8 | Luleå | S-958 22 | Sweden | 0921-12 34 65
[NAME] | 24, place [NAME] | Strasbourg | 67000 | France | 88.60.15.31
[NAME] | 120 [NAME]. | London | WA1 1DP | UK | (171) 555-7788
Georg Pipps | Geislweg 14 | [NAME] | 5020 | Austria | 6562-9722
[NAME] | Calle Dr. [NAME] 321 | México D.F. | 5033 | Mexico | (5) 552-3745
Hanna Moos | [NAME]. 57 | Mannheim | 68306 | Germany | 0621-08460
[NAME] | Mehrheimerstr. 369 | Köln | 50739 | Germany | [PHONE]
[NAME] | Mehrheimerstr. 369 | Köln | 50739 | Germany | [PHONE]
[NAME] | Taucherstraße 10 | Cunewalde | 1307 | Germany | 0372-035188
Isabel [NAME] | Estrada da [NAME] 58 | [NAME] | 1756 | Portugal | (1) 356-5634
[NAME] | [NAME]. 57 | Berlin | 12209 | Germany | [PHONE]
[NAME] | 265, boulevard [NAME] | Paris | 75012 | France | (1) 42.34.22.66
Hanna Moos | [NAME]. 57 | Mannheim | 68306 | Germany | 0621-08460
[NAME] | Av. del Libertador 900 | [NAME] | 1010 | Argentina | (1) 123-5555
[NAME] | 120 [NAME]. | London | WA1 1DP | UK | (171) 555-7788
[NAME] | [NAME]. 57 | Berlin | 12209 | Germany | [PHONE]
[NAME] | 120 [NAME]. | London | WA1 1DP | UK | (171) 555-7788
Spreadsheet: 695255d1600109689-how-to-find-latest-date-using-max-formula-matching-p-n-and-partial-text-find-latest-date-using-index-match-and-partial-word
Sheet: Summary

 | EOP
Number
5775-3-00
5776-3-00
5789-3-00
5790-3-00
5707-3-00
5707-3-97
5708-3-00
5708-3-97
5789-3-97
0039-4-97
5325-5-00
5790-3-97
4801-3-00
4827-3-00
4828-3-00
4802-3-00
5325-4-00
0010-4-00
Spreadsheet: lisa_gang__22245__EPE_APRIL_2002
Sheet: APRIL (2)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-04-02 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS
Pacific | Mountain | SALE
Standard | Standard | EPMI
Time | Time | 22.25
 |  | ON GOING DAILY
 |  | 3/1/02-3/31/02
 |  | EPMI TAG#41793 |  |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL
2400 | 0100 | 25
0100 | 0200 | 0
0200 | 0300 | 0
0300 | 0400 | 0
0400 | 0500 | 0
0500 | 0600 | 0
0600 | 0700 | 0
0700 | 0800 | 0
0800 | 0900 | 0
0900 | 1000 | 0
1000 | 1100 | 0
1100 | 1200 | 0
1200 | 1300 | 0
1300 | 1400 | 0
1400 | 1500 | 0
1500 | 1600 | 0
1600 | 1700 | 0
1700 | 1800 | 0
1800 | 1900 | 0
1900 | 2000 | 0
2000 | 2100 | 0
2100 | 2200 | 0
2200 | 2300 | 0
2300 | 2400 | 0
2400 | 0100 | 0
 | MST Total |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  | TOTAL SALES | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C
 |  | EPMI
 |  | AZPS(T)FC3/PPD2
 |  | WALC(T)PPD2/COOLIDGE
 |  | CRSP(L)COOLIDGE
Spreadsheet: 858714d1707298481-creating-a-button-to-flick-between-forecast-and-actuals-new-forecasting-template-draft-to-share-v2
Sheet: Revenue

 | PROJECT
 |  |  | Baseline | Held by GMA
 |  |  | Budget | Original total spend estimate?
 |  |  | Forecast | Completed by the PMs |  |  |  |  |  |  |  | How do we deal with baseline vs the latest approved
 |  |  | Actual | Held by finance
 |  |  |  |  |  |  |  |  |  |  | 23/24
 | Expenditure Category | Account codes | Actuals to Date | AFC | 23/24 Forecast | 24/25 Forecast | 25/26 Forecast | 26/27 Forecast | 27/28 Forecast | 28/29 Forecast |  | March | April | May | June | July | August | September | October | November | December | January | February
 | Staff Costs |  |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | Agency Staff |  |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | Seconded Staff |  |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | Employee Costs |  |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | Direct Transport Costs |  |  |  |  |  |  |  |  |  |  | 1 | 23 | 3 | 3 | 3
 | [NAME]
 | [NAME], Lease & Rental |  |  |  |  |  |  |  |  |  |  | OBC | OBC | OBC | FBC | FBC | Delivery
 | Public Transport - Staff & Members
 | Public Transport - Service Travel Costs
 | Travel Costs
 | Equipment, Furniture & Materials |  |  |  |  |  |  |  |  |  |  |  |  | Forecast
 | Events & Catering
 | Printing, Stationery & Office Supplies |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | Advertising
 | Communications & Marketing
 | Digital
 | Publicity & Events
 | Services
 | Fees
 | Consultants
 | Expenses - Conferences
 | Subscriptions
 | Insurance
 | External and Company Training
 | Supplies & Services
 | Other Local Authorities
 | Transport Operators
 | Grants
 | Central Support Recharges
 | Departmental Recharges
 | Support Services
Spreadsheet: 467695d1466838098-calculate-daily-totals-for-ongoing-log-with-various-updates-each-day-logbook2
Sheet: Sheet2

Actual log: |  |  |  |  | Result
15 | June 18 | 2016 at 12:13PM |  | June 18
8 | June 19 | 2016 at 06:42PM |  | June 19
10 | June 19 | 2016 at 07:12PM |  | June 20
17 | June 20 | 2016 at 08:17AM |  | June 21
15 | June 20 | 2016 at 08:29AM
20 | June 20 | 2016 at 09:48AM
22 | June 21 | 2016 at 02:16PM
Rather clumsy but it works
1) Selecting original range B2:B8, then using "Text to Columns" with comma as delimeter to separate month and date from rest of data in B column.
2) Then copy separated B2:B8 range to [NAME] and using "Remove Duplicates" on the E2:E8 range to get unique values.
3) Finding required sum using SUMIF formula in column F
Spreadsheet: 77825d1278328805-range-lookups-with-overlapping-entries-and-extra-check-vakantie-2010
Sheet: Vakantie

# | Name | MONTH
 | [NAME] |  |  | 2009-12-28 00:00:00
 | [NAME] |  |  | 2009-12-28 00:00:00
 | [NAME] |  |  | 2009-12-28 00:00:00
 | Marcel Stegehuis |  |  | 2009-12-28 00:00:00
 | Sietske Witvoet |  |  | 2009-12-28 00:00:00
Spreadsheet: 65874d1266513827-total-number-unique-to-only-one-set-left-uniquenumber
Sheet: Sheet1

 |  | A. Table
 | A-data | 544 | 44 | 864 | 364 | 974 | 584 | 84 | 804 | 304 | 946 | 566 | 66 | 876 | 376 | 986 | 506 | 6 | 847 | 347 | 967 | 577 | 77 | 887 | 387 | 907 | 549 | 49 | 869 | 369 | 979 | 589 | 89 | 809 | 309 | 940 | 560 | 60 | 870 | 370 | 980 | 500 | 0
 | B-data | 844 | 344 | 964 | 574 | 74 | 884 | 384 | 904 | 546 | 46 | 866 | 366 | 976 | 586 | 86 | 806 | 306 | 947 | 567 | 67 | 877 | 377 | 987 | 507 | 7 | 849 | 349 | 969 | 579 | 79 | 889 | 389 | 909 | 540 | 40 | 860 | 360 | 970 | 580 | 80 | 800 | 300
 | C-data | 944 | 564 | 64 | 874 | 374 | 984 | 504 | 4 | 846 | 346 | 966 | 576 | 76 | 886 | 386 | 906 | 547 | 47 | 867 | 367 | 977 | 587 | 87 | 807 | 307 | 949 | 569 | 69 | 879 | 379 | 989 | 509 | 9 | 840 | 340 | 960 | 570 | 70 | 880 | 380 | 900
 | Total = | 125 | set
 |  | B. table
 |  | 544 | 584 | 66 | 6 |  | 77 | 49 | 309 | 844 |  | 384 | 586 | 877 | 849 |  | 389 | 80 | 386 | 569 |  | 880
 |  | 44 | 84 | 876 | 847 |  | 887 | 369 | 870 | 344 |  | 546 | 86 | 377 | 349 |  | 909 | 300 | 906 | 379 |  | 380
 |  | 864 | 304 | 376 | 347 |  | 387 | 979 | 370 | 574 |  | 46 | 306 | 987 | 969 |  | 540 | 944 | 977 | 989
 |  | 364 | 946 | 986 | 967 |  | 907 | 589 | 500 | 74 |  | 866 | 567 | 507 | 579 |  | 40 | 966 | 587 | 509
 |  | 974 | 566 | 506 | 577 |  | 549 | 89 | 0 | 884 |  | 366 | 67 | 7 | 889 |  | 580 | 886 | 949 | 9
 | Total = | 82 | set
1 | From A. table too many number set (3digit numberic).
2 | I'll need automatic calculate and push only one set into B.table
 | For exsample A.table have same digit of 3 set (yellow hilight)
 |  | 086 , 806 , 860
 |  | The 3 digit number is same.
 |  | " 0 "
 |  | " 6 "
 |  | " 8 "
 | Than automatic push only one set are " 086 " into B.Table automatic.
3 | if some set have same 2 set also push only once.(Pink Hilight)
4 | If some set have not same set can push direct into B. table. (blue white hilight)
Spreadsheet: 02a5dd6b-a009-4490-aeaa-64a25f44f7c1
Sheet: Sheet1

OPERATING
 | FY2012 | FY2012 | FY2012 | FY2013 | FY2013 | FY2013 | FY2013 | FY2013 | FY2014 | FY2014 | FY2014
 | Actual | Actual | Actual | Budget | Budget | Actual | Actual | Net | [NAME] | [NAME]
 | Revenue | Expenses | net | Revenue | Expenses | Revenue | Expenses | to date | Budget | Budget | [NAME]
 |  |  |  |  |  | to date | to date |  | Revenue | Expenses | Net
Membership activities
Administration |  | 228017 |  | 0 | 235020 | 1747 | 56396 |  |  | 239819
Membership Promotion |  | 2457 |  | 0 | 2000 |  | 0 |  |  | 2000
Governance Support |  | 9655 |  | 0 | 8850 |  | 2317 |  |  | 8850
Dues | 179766 | 3321 |  | 187898 | 3905 | 44174 | 779 |  | 187898 | 3416
MW & Annual Conference | 0 | 3694 |  | 0 | 6300 | 0 | 205 |  | 0 | 6300
External Relations | 13500 | 19843 |  | 13500 | 21205 | 0 | 0 |  | 13500 | 21205
Technology Grants | 0 | 0 |  | 0 | 500 | 0 | 0 |  | 0 | 500
Friends of LITA/LITA Now | 575 | 16 |  | 300 | 0 | 0 | 0 |  | 300 | 0
Subtotal
Publications
ITAL | 23964 | 31937 |  | 5500 | 8097 | 1214 | 1299 |  | 5500 | 8097
Classified ads | 14288 | 1783 |  | 15000 | 1800 | 4742 | 122 |  | 15000 | 1800
Nonperiodical Pubs. | 1741 | 1723 |  | 2800 | 1857 | 0 | 0 | 0 | 2800 | 1839
Subtotal
Education
Pre-conferences | 41923 | 21290 |  | 23850 | 14031 | 0 | 0 | 0 |  | 13722
MW Workshop | 3770 | 4011 |  | 22305 | 13638 | 0 | 0 | 0 |  | 13347
Forum | 117658 | 100707 |  | 103913 | 103893 | 110637 | 84467 |  | 103913 | 102542
Institutes | 0 | 247 |  | 22800 | 14508 | 0 | 0 | 0 | 22800 | 14360
Web CE | 32613 | 8995 |  | 69900 | 29074 | 9645 | 2521 |  | 69900 | 28620
Subtotal
TOTAL
Spreadsheet: 675961d1588586180-countifs-with-condition-and-interval-range-timedouble-etaf
Sheet: Sheet1

Name | Time
BOB | 10:00:00
MARY | 11:00:00
GEORGE | 12:00:00
BOB | 13:00:00
MARY | 11:15:00
GEORGE | 13:15:00
BOB | 13:30:00
MARY | 11:25:00
BOB
MARY
GEORGE
BOB
MARY
Spreadsheet: 115600d1311172613-data-validation-and-dynamic-named-ranges-copy-of-book2dv
Sheet: Background Info

Month |  |  |  | Month |  |  | Month |  |  | Month
January One |  |  |  | January One |  |  | February One |  |  | March One
February One
March One |  |  |  | Month | Contact |  | Month | Contact |  | Month | Contact
 |  |  |  | January One | [NAME] |  | February One | [NAME] |  | March One | [NAME]
 |  |  |  | January One | [NAME] |  | February One | [NAME] |  | March One | [NAME]
 |  |  |  | January One | [NAME] |  | February One | [NAME]
 |  |  |  |  |  |  | February One | [NAME]
Spreadsheet: 881806d1729993726-how-to-have-return-results-of-a-function-split-across-multiple-lines-testfile
Sheet: Agent Charges

Agent Charges
 |  |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges. (Done)
Assesorial Charges by Agent: |  |  | AGT-2
 | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | Agent | Agent Total Chgs | Carrier | Ocean Freight (Collect) | VGM/Solas (weighing)Handling Fee | FOB | Liability | Wharfage Tax | Warehouse Charge | AMS Security Fee | ISF 10+2 | THC/ Handling @ Origin | Pick-up/ Trucking Charge | [NAME]
2023-09-26 00:00:00 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | AGT-2 | 1016.48 | ZIM | 285.13 | 37.32 | 136.44 | 6.93 | 0 | 12.06 | 100.65 | 85.52 | 154.4 | 188.6 | 9.43
2023-10-04 00:00:00 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL | AGT-2 | 902.24 | ZIM | 234.44 | 36.88 | 134.81 | 6.84 | 7.95 | 0 | 99.45 | 84.5 | 101.71 | 186.34 | 9.32
2023-08-04 00:00:00 | Client-2 | 10 | Shanghai | NY | Boston | 1-pallet | 84 | 0 | LCL | AGT-2 | 0 | Ever | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: e7051b1c-6284-45ae-823d-b0cb74d55a9e
Sheet: Enter Team Data Here

Team | OPR |  | Avg OPR |  | Team List | OPR | CP | RS as R1 | RS as R2 | RS as R3 | RS as B1 | RS as B2 | RS as B3 | QS as R1 | QS as R2 | QS as R3 | QS as B1 | QS as B2 | QS as B3 | RS | QS | QS+CP |  | Do not sort!
27 | 28.4371
27 | 20.4626
27 | 16.1615
27 | 12.9691
51 | 24.8475
51 | 23.5172
51 | 16.4507
58 | 18.6124
78 | 20.2057
78 | 7.4487
85 | 15.8779
85 | 15.067
85 | 9.47308
116 | 10.6337
120 | 5.14786
120 | 4.31
178 | 0.509376
192 | 15.6912
192 | 9.70106
207 | 8.8962
233 | 24.7061
233 | 11.5036
244 | 12.6533
244 | 6.46537
244 | 3.27345
244 | 1.05
254 | 34.6386
254 | 24.1605
279 | 9.4822
288 | 10.3197
288 | 8.66281
288 | 7.85554
288 | 1.41835
293 | 4.60646
293 | 4.04142
341 | 38.6389
341 | 35.3801
341 | 33.0896
341 | 32.3701
415 | 5.13583
415 | 2.56
433 | 7.94257
433 | 6.23578
433 | 3.56527
461 | 12.3981
461 | 11.0055
503 | 12.3483
503 | 11.1098
503 | 6.26449
525 | 22.6185
525 | 15.3935
537 | 11.8866
537 | 11.2448
564 | 4.08928
571 | 4.35045
597 | 5.17926
597 | 8.68
604 | 10.375
604 | 9.92857
624 | 35.1112
624 | 22.6676
694 | 19.1199
694 | 15.2251
702 | 16.6572
702 | 7.32902
706 | 9.42203
830 | 17.3237
830 | 15.0587
830 | 4.21072
836 | 24.1654
836 | 14.4398
932 | 4.48727
932 | 4.37482
971 | 29.8324
971 | 21.0766
987 | 39.6831
987 | 26.3315
1033 | 2.32
1143 | 9.72518
1143 | 7.29678
1266 | 11.6777
1266 | 9.71904
1319 | 17.171
1319 | 2.2246
1319 | 1.74487
1391 | 13.0409
1391 | 10.5056
1391 | 5.09465
1477 | 26.5212
1477 | 23.1283
1477 | 22.8183
1501 | 12.4556
1501 | 11.1724
1507 | 30.5656
1507 | 29.7801
1511 | 18.4498
1511 | 12.381
1649 | 3.32179
1678 | 26.0799
1678 | 20.4106
1683 | 10.164
1690 | 13.4712
1741 | 20.393
1741 | 3.79298
1764 | 12.8275
1764 | 2.03301
1778 | 2.85233
1817 | 6.73501
1817 | 3.63899
1828 | 17.1834
1828 | 2.33236
1885 | 12.1818
1885 | 10.2076
1912 | 12.7694
1985 | 22.7234
1985 | 13.5436
1986 | 30.4368
1986 | 25.7881
2102 | 6.96778
2102 | 5.54962
2130 | 7.13207
2164 | 8.81375
2164 | 2.51
2180 | 19.6235
2180 | 15.7885
2180 | 13.7109
2474 | 34.7337
2474 | 25.8932
2474 | 24.3594
2474 | 17.0974
2500 | 2.22997
2500 | 0.47
2522 | 12.4255
2522 | 10.3504
2591 | 12.9435
2591 | 8.68236
2591 | 5.06394
2626 | 13.7548
2626 | 11.8771
2757 | 3.16
2844 | 4.29555
2844 | 1.67106
2881 | 11.9548
2914 | 8.07947
2914 | 3.44
2960 | 19.6602
2960 | 9.40928
3098 | 32.2912
3098 | 13.8113
3098 | 12.7798
3115 | 1.88893
3115 | 0.732792
3132 | 3.37147
3205 | 23.9137
3288 | 19.9129
3288 | 0.101536
3419 | 15.3802
3419 | 11.0532
3528 | 23.7081
3528 | 19.3405
3711 | 7.05543
3711 | 6.6258
3807 | 3.83976
3847 | 7.82894
3847 | 5.20637
3860 | 0.97
3880 | 10.0093
3929 | 17.4597
3929 | 10.1867
3929 | 10.1572
3936 | 7.91694
3940 | 14.5514
3940 | 10.1906
3941 | 3.31
3950 | 5.80187
3951 | 9.51805
3965 | 10.8113
3970 | 18.4285
3970 | 8.45398
4069 | 15.8092
4069 | 11.6622
4130 | 6.09383
4130 | 3.04737
4161 | 10.1102
4203 | 1.99718
4226 | 6.79982
4253 | 4.11087
4265 | 7.44503
4269 | 5.97547
Spreadsheet: 219408d1362752495-top-3-sold-products-and-qyty-by-customer-from-list-top-3-in-list-formula
Sheet: Sheet1

Customer Name | Product | Totals
A | 1 | 3
A |  | 10
A |  | 3
A |  | 1 |  |  | Desired Results
A |  | 2
A |  | 6 |  |  | Customer | Product | Totals
A |  | 2 |  |  | A | 2 | 10
A |  | 3 |  |  | A | 6 | 6
A |  | 1 |  |  | A | 1 | 3 | Tie - Take the 1st product
A |  | 1 |  |  | B | 7 | 14
A |  | 2 |  |  | B | 10 | 10
A |  | 2 |  |  | B | 14 | 5
B | 1 | 1 |  |  | C | 10 | 83
B |  | 6 |  |  | C | 12 | 72
B |  | 5 |  |  | C | 21 | 61
B |  | 8
B |  | 9
B |  | 3
B |  | 14
B |  | 3
B |  | 1
B |  | 10
B |  | 2
B |  | 3
B |  | 1
B |  | 5
C | 1 | 20
C |  | 8
C |  | 1
C |  | 1
C |  | 2
C |  | 2
C |  | 6
C |  | 3
C |  | 2
C |  | 83
C |  | 10
C |  | 72
C |  | 4
C |  | 10
C |  | 8
C |  | 14
C |  | 2
C |  | 1
C |  | 60
C |  | 5
C |  | 61
C |  | 4
Spreadsheet: benjamin_rogers__1173__Wilton_New - GE 7EA
Sheet: Interest During Construction

IDC Calculations
CARRYING COST OF TURBINES, TRANSFORMERS AND CIRCUIT BREAKERS
Turbine Cost |  | 213856
Base Rate
Term (Months) |  | 18
Monthly Rate
Financing Fee (Basis Points) |  | 0.0035
Drawdown Schedule |  | 1
0=Straightline, 1=Custom
Calculated IDC
Month | Percent [NAME] | Principal | Cumulative Principal | Monthly Interest | Cumulative Interest
0 |  | 6800 |  | 340
1 |  | 1250 |  | 46.41
 |  | 32884.8 |  | 139.384
 |  | 20
 |  | 1446.361
 |  | 30919.397
 |  | 10044.547
 |  | 9792.047
 |  | 15659.711
 |  | 12089.106
 |  | 10704.618
 |  | 15374.165
 |  | 17067.04
 |  | 7600.065
 |  | 6350.065
 |  | 9935.065
 |  | 7830.065
 |  | 6071.548
 |  | 12016.962
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Spreadsheet: 48431d1247650139-multiple_lookup-multiple_lookup
Sheet: Data-Backup

Campaign | Q1 | Q2 | Q3 | Q4 | Target | Actual | CACP | DD | RP | OO | GL | Growth | Revenue | Customers | Regions | Agreements | Partners
EUP | 0.2999999996988894 | 0.2999999996988894 | 0.2000000003011107 | 0.2000000003011107 | 26500 | 100 | 0.2500000000503529 | 0.2 | 0.2500000000503529 | 0.1999999999194354 | 0.1 | 0.2500000000503529 | 56565 | 30 | 7 | 1000 | 120
GSI | 0.2500000000503529 | 0.2999999999798589 | 0.2500000000503529 | 0.1999999999194354 | 100000 | 200 | 0.33 | 0.67 |  |  |  | 0.33 | 345689 | 1200 | 10 | 2000 | 130
BA | 0.2999999996104125 | 0.2999999996104125 | 0.2000000003895875 | 0.2000000003895875 | 300000 | 500 | 0.2 | 0.25 | 0.3 | 0.15 | 0.1 | 0.2 | 300000 | 100 | 33 | 3000 | 500
BI | 0.3 | 0.3 | 0.2 | 0.2 | 345689 | 450 | 0.5 |  | 0.2 |  | 0.3 | 0.5 | 100200 | 189 | 45 | 3456 | 260
WWP | 0.1500000000458848 | 0.2500000002294238 | 0.2999999998623458 | 0.2999999998623458 | 709090 | 700 | 0.4 | 0.3 | 0.1 | 0.1 | 0.1 | 0.4 | 345689 | 300 | 23 | 2345 | 278
BMO | 0.25 | 0.25 | 0.25 | 0.25 | 56565 | 450 | 0.25 | 0.4 | 0.25 | 0.1 |  | 0.25 | 56565 | 400 | 12 | 6789 | 134
EDU | 0.25 | 0.25 | 0.25 | 0.25 | 100200 | 20 | 0.25 | 0.25 | 0.1 | 0.2 | 0.2 | 0.25 | 100200 | 550 | 4 | 4567 | 167
[NAME] | 0.1500000001193177 | 0.2999999997362451 | 0.3500000000690787 | 0.2000000000753586 | 300000 | 330 | 0.56 |  | 0.32 | 0.32 |  | 0.56 | 300000 | 756 | 8 | 3456 | 18
Collab | 0.1499999999951359 | 0.2999999999902719 | 0.2500000000243203 | 0.2999999999902719 | 456000 | 500 | 0.8 | 0.1 | 0.1 |  |  | 0.8 | 300000 | 436 | 10 | 1234 | 189
Spreadsheet: 271889d1382098755-calculating-shift-premium-hours-shift-calculator-example
Sheet: Warehouse Time Sheet

 | Shift |  | No [NAME] | [NAME] 10% | [NAME] 20%
 | Start |  | 06:00:00 | 18:00:00 | 22:00:00
 | End |  | 18:00:00 | 22:00:00 | 06:00:00
 | Rate |  | 0 | 0.87 | 1.73
 |  |  |  |  |  |  |  |  |  |  |  | Calculated Premium |  |  |  |  | Premium Actual
 | Name |  |  |  |  | Emp Number | Start | End | Total Daily Hours | Manual Prem @ 10% | Manual Prem @ 20% | No [NAME] | [NAME] 10% | [NAME] 20% | Total Premium Hours |  | No [NAME] | [NAME] 10% | [NAME] 20% | Total Premium Hours
 |  |  |  |  |  |  | 08:00:00 | 20:00:00 |  |  |  |  |  |  |  |  | 10:00:00 | 02:00:00 | 00:00:00
 |  |  |  |  |  |  | 09:00:00 | 20:00:00 |  |  |  |  |  |  |  |  | 09:00:00 | 02:00:00 | 00:00:00
 |  |  |  |  |  |  | 01:00:00 | 09:30:00 |  |  |  |  |  |  |  |  | 03:30:00 | 00:00:00 | 05:00:00
 |  |  |  |  |  |  | 19:00:00 | 20:00:00 |  |  |  |  |  |  |  |  | 00:00:00 | 01:00:00 | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00
 | No [NAME] |  | `=IF(OR(ISTEXT(H8),ISTEXT(I8)),SUM(J8-SUM(K8:L8)),SUM(IF(H8>I8,TRUE,FALSE)*MEDIAN(0,I8-$D$3,1/3)+MAX(0,MIN($D$4,I8+IF(H8>I8,TRUE,FALSE))-MAX($D$3,H8))))
 | [NAME] 10% |  | `=FLOOR(SUM(IF(H8>I8,TRUE,FALSE)*MEDIAN(0,I8-$E$3,1/3)+MAX(0,MIN($E$4,I8+IF(H8>I8,TRUE,FALSE))-MAX($E$3,H8))),"00:30")
 | [NAME] 20% |  | `=IF(OR(ISTEXT(H8),ISTEXT(I8)),IF(L8="",0,L8),SUM(MOD(I8-H8,1)-M8-N8))
Spreadsheet: 1d3b7e75-1438-4a41-8430-d84e6c120571
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
UBF SERVICES, INC. |  |  |  |  |  |  | Disbursement Request No.
Box 900
Buffalo, NY  14226-0900
UBFS, INC. REQUEST FOR DISBURSEMENT
Charge UBFS, Inc. Account #
 |  |  |  |  |  |  |  | Date
IT IS HEREBY REQUESTED THAT A CHECK IN THE AMOUNT OF $
BE ISSUED TO THE ORDER OF |  |  |  |  |  |  |  | SSN#
U.S. CITIZEN |  |  | RESIDENT ALIEN |  |  | NON-RESIDENT ALIEN |  | VISA TYPE
AT THE FOLLOWING ADDRESS
ATTACH ORIGINAL RECEIPTS/INVOICE-NO.
AND DOCUMENT ALL PERTINENT INFORMATION INCLUDING BUSINESS PURPOSE, BENEFIT TO UB, PARTICIPANTS AND THEIR BUSINESS RELATIONSHIP, DATE, ETC.
UB BUSINESS PURPOSE:
PLEASE MAIL CHECK TO: |  |  |  |  |  |  |  | Supplier #
 |  |  |  |  |  |  |  | [NAME].
 |  |  |  |  |  |  |  | Ship To
 |  |  |  |  |  |  |  | Expense Code
 |  |  |  |  |  |  |  | Taxable
Approval |  | Date Paid
 |  |  |  |  | Recommended By: | Recommended By:
Date |  | Check No.
 |  |  |  |  | Authorized Signature: | Authorized Signature:
Spreadsheet: 75157d1275676713-if-functions-and-working-inbetween-work-sheets-for-football-free-kicks-game-state-times
Sheet: Sheet1

 | game | draw | home | away | 1st half | 2nd half
[NAME] | 1 | 35 | 38 | 17 | draw | home
Liverpool v Manchester United | 2 | 65 | 25 | 0 | draw | home
Arsenal v Chelsea | 3 | 41 | 0 | 49 | away | away
[NAME] | 4 | 66 |  | 24 | draw | draw
Liverpool V Arsenal | 5 | 49 | 9 | 32 | home | away
Birmingham City v [NAME] | 6 | 12 | 78 |  | home | home
[NAME] v Manchester City | 7 | 37 | 53 |  | home | home
Portsmouth V Liverpool | 8 | 33 | 57 |  | home | home
[NAME] | 9 | 15 | 75 |  | home | home
Hull City v Manchester United | 10 | 58 |  | 32 | away | away
[NAME] | 11 | 11 | 79 |  | home | home
Arsenal v Aston Villa | 12 | 65 | 35 |  | draw | home
[NAME] v Manchester City | 13 | 33 |  | 67 | away | away
[NAME] v Liverpool | 14 | 90 |  | 0 | draw | away
Portsmouth v Arsenal | 15 | 28 |  | 62 | away | away
Stoke City v Liverpool | 16 | 57 |  | 33 | draw | draw
[NAME] v Westham United | 17 | 90 |  |  | draw | draw
[NAME] v Fulham | 18 | 27 | 63 |  | home | home
[NAME] | 19 | 7 | 83 |  | home | home
Manchester City v Portsmouth | 20 | 40 | 50 |  | home | home
Arsenal v Manchester United | 21 | 33 |  | 67 | away | away
Liverpool v Everton | 22 | 55 | 35 |  | draw | home
Birmingham City v [NAME] | 23 | 47 | 5 | 38 | away | home
Chelsea V Arsenal | 24 | 23 | 67 |  | home | home
Manchester City v [NAME] | 25 | 31 | 59 |  | home | home
Arsenal v Liverpool | 26 | 72 | 18 |  | draw | home
[NAME] | 27 | 73 | 14 | 3 | draw | home
[NAME] | 28 | 34 | 34 | 22 | draw | home
[NAME] v [NAME] | 29 | 27 |  | 63 | away | away
 |  | 1254 | 877 | 509
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: Compendex(EI)

Compendex (Engineering Index)
2010-2011
COUNTER-Compliant?: | Yes (R2)
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
Compendex
Sessions | 40 | 54 | 91 | 409 | 86 | 60 | 30 | 48 | 68 | 59 | 48 | 62
Searches | 146 | 198 | 339 | 3319 | 325 | 187 | 162 | 136 | 198 | 199 | 189 | 281 |  | 17805