tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0dd0bf64-ba53-4c4b-95f6-5f67a9edf1ca
Sheet: Sheet1

ตารางสอบปลายภาคเรียนที่ 1 / 2555 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | ระดับ  ปวช. 1
 | วันที่ 1  ตุลาคม  2555
เวลา |  |  | 08.00 - 09.30 น. | 09.30 - 11.00 น. | พักรับประทานอาหารกลางวัน | 13.00 - 14.30 น. | 14.30 - 15.30 น.
ระดับ | เลขที่ | ห้องสอบ
ปวช.1/1 | 1 - 25 | 121 | การบัญชีเบื้องต้น 1 | ธุรกิจทั่วไป |  | อังกฤษเพื่อการสื่อสาร 1 | เพศศึกษา
 | 26 - 37 | 122
ปวช.1/2 | 1 - 25 | 125 | การบัญชีเบื้องต้น 1 | ธุรกิจทั่วไป |  | อังกฤษเพื่อการสื่อสาร 1 | เพศศึกษา
 | 26 - 38 | 126
ปวช.1/3 | 1 - 25 | 132 | การบัญชีเบื้องต้น 1 | ธุรกิจทั่วไป |  | อังกฤษเพื่อการสื่อสาร 1 | เพศศึกษา
 | 26 - 34 | 133
ปวช.1/4 | 1 - 25 | 134 | การบัญชีเบื้องต้น 1 | ธุรกิจทั่วไป |  | อังกฤษเพื่อการสื่อสาร 1 | เพศศึกษา
 | 26 - 35 | 133
ตารางสอบปลายภาคเรียนที่ 1 / 2555
 | ระดับ  ปวช. 1
 | วันที่ 3  ตุลาคม  2555
เวลา |  |  | 08.00 - 09.30 น. | 09.30 - 11.00 น. | พักรับประทานอาหารกลางวัน | 13.00 - 14.30 น. | 14.30 - 15.30 น.
ระดับ | เลขที่ | ห้องสอบ
ปวช.1/1 | 1 - 25 | 121 | คณิตศาสตร์ประยุกต์ 1 | การขาย 1 |  | วิทยาศาสตร์พื้นฐาน | ภาษาไทยเพื่ออาชีพ 1
 | 26 - 37 | 122
ปวช.1/2 | 1 - 25 | 125 | คณิตศาสตร์ประยุกต์ 1 | การขาย 1 |  | วิทยาศาสตร์พื้นฐาน | ภาษาไทยเพื่ออาชีพ 1
 | 26 - 38 | 126
ปวช.1/3 | 1 - 25 | 132 | คณิตศาสตร์ประยุกต์ 1 | การขาย 1 |  | วิทยาศาสตร์พื้นฐาน | ภาษาไทยเพื่ออาชีพ 1
 | 26 - 34 | 133
ปวช.1/4 | 1 - 25 | 134 | คณิตศาสตร์ประยุกต์ 1 | การขาย 1 |  | วิทยาศาสตร์พื้นฐาน | ภาษาไทยเพื่ออาชีพ 1
 | 26 - 35 | 133
Spreadsheet: 34476d1231780963-day-and-column-data-book1
Sheet: collect

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
544 | v1 | v1 | v1 | v1 | v1 | v2 | v3
55 | v2 | v2 | v2 | v2 | v2 | v2 | v3
222 | v3 | v3 | v1 | v1 | v2 | v3 | v4
555 | v3 | v3 | v1 | v1 | v2 | v3 | v4
777 | v2 | v2 | v2 | v2 | v2 | v2 | v3
1567 | v3 | v3 | v1 | v1 | v2 | v3 | v4
1544 | v1 | v1 | v1 | v1 | v1 | v2 | v3
558 | v2 | v2 | v2 | v2 | v2 | v2 | v3
477 | v3 | v3 | v1 | v1 | v2 | v3 | v4
Spreadsheet: 865051d1712145821-return-date-for-multiple-payments-for-multiple-invoices-excel-work-file-ans
Sheet: Sheet1

Year | Period Number | Billed Balance | Payment Total | Paid in Full (Y/N) | # of Payments | Payment Date | Days to Pay |  |  | Invoice Periond Information
2024 | 10 | 42484.35 |  | Yes |  |  |  |  |  | Period | Begin Date | End Date | Billing Date | Payment Due Date
2024 | 11 | 40076.92 |  | Yes |  |  |  |  |  | 10 | 2024-01-30 00:00:00 | 2024-02-05 00:00:00
2024 | 12 | 39273.91 |  | Yes |  |  |  |  |  | 11 | 2024-02-06 00:00:00 | 2024-02-12 00:00:00
2024 | 13 | 40331.66 |  | Yes |  |  |  |  |  | 12 | 2024-02-13 00:00:00 | 2024-02-19 00:00:00
 |  |  |  |  |  |  |  |  |  | 13 | 2024-02-20 00:00:00 | 2024-02-26 00:00:00
 |  | [NAME] | PAYMENT_AMT
 |  | 2024-02-08 00:00:00 | -42484.35
 |  | 2024-02-15 00:00:00 | -40076.92
 |  | 2024-02-22 00:00:00 | -39273.91
 |  | 2024-02-29 00:00:00 | -40331.66
 |  | 2024-03-07 00:00:00 | -46740.46
 |  | 2024-03-14 00:00:00 | -43275.51
 |  | 2024-03-21 00:00:00 | -47508.06
 |  | 2024-03-28 00:00:00 | -46796.76
Spreadsheet: 275768d1383642523-how-to-use-more-than-2-values-in-vookup-as-inputs-parameters-sample-ans
Sheet: Sheet1

 | Sale Quantity in numbers (Cumulative)
 |  | Sale Quantity
[NAME] | Customer name | Month1 | Month2 | Month3 | Month4 | [NAME] Between Months | Customer name
USA | Cust1 | 5000 | 5500 | 6500 | 7500 | 1000 |  |  | Slight changes done in A column
USA | Cust2 | 4000 | 4500 | 5000 | 5500 | 500 |  |  | Helper column G is used
USA | Cust3 | 4000 |  |  |  | 0 | Cust1 |  | ARRAY formulas are used
UK | Cust3 |  | 6000 | 8000 | 8500 | 2000
UK | Cust4 | 2000 | 3500 | 4500 | 5000 | 1500
UK | Cust5 | 3500 | 4000 |  |  | 500 | Cust3
India | Cust5 |  |  | 2250 | 3000 | 750
India | Cust6 | 1500 | 2000 | 3000 | 3500 | 1000
India | Cust7 | 2250 | 4000 | 5500 | 7250 | 1750 | Cust7
 | My Question:
 | Given the location and the quantity (Please note that the quantity can be same value or in
 | between values given in column C6 to F14 e.g. 6000  which would fall in E7 for Loc USA)
 | as inputs can we findout the customer name and in which month the sale quantity falls
Spreadsheet: 696490d1600853829-cashflow-formula-needed-for-partial-paymen-base-on-date-book2
Sheet: Payment Term

Type | Payment | Term
A Sponser | 0.4 | 0 |  | 0= Day when sign contract
A Sponser | 0.4 | 30
A Sponser | 0.2 | 90
B Sponser | 0.5 | 0
B Sponser | 0.5 | 90
C Sponser | 0.4 | 0
C Sponser | 0.3 | 30
C Sponser | 0.3 | 60
D Sponser | 1 | 0
Spreadsheet: 166698d1341741982-vlookup-to-impress-my-boss-example_1
Sheet: June

Products | Revenue | Product | May Revenue | May Products
x019281 | 104204 | 8523
x2597211 | 59137 | 8771
x9906821 | 855497 | 9865
x9213320 | 479638 | 1912
x6583257 | 283776 | 2326
x8539221 | 81221 | 5328
[NAME] | 957388 | 4091
x10108100 | 399242 | 3799
x9000769 | 936489 | 2021
x2557358 | 940520 | 1414
x3215868 | 147513 | 7086
[NAME] | 885397 | 4412
x10066927 | 348125 | 10501
x6547815 | 241615 | 3538
x182423 | 807921 | 5043
x7706548 | 192498 | 2488
[NAME] | 908151 | 6634
x396345 | 250353 | 5250
x8790141 | 221175 | 2649
x1419959 | 77221 | 2148
x2776728 | 120056 | 3280
x1055856 | 920275 | 6223
x8402480 | 917054 | 8455
x9019400 | 777882 | 1783
[NAME] | 660393 | 7636
x8930845 | 461766 | 6943
x8252790 | 589653 | 3549
x2818482 | 968428 | 4483
x9885446 | 259805 | 5585
x7443669 | 211150 | 6187
x8191171 | 515176 | 2348
x6751973 | 763077 | 5478
x5725039 | 261431 | 8005
x9425472 | 370877 | 4630
x3617826 | 839244 | 5227
x8630255 | 785510 | 3850
x5923195 | 240104 | 4746
x5423416 | 330663 | 2613
x217128 | 443194 | 9794
x8848922 | 678232 | 2156
x6852243 | 900976 | 3507
x9023526 | 77496 | 6372
x5807964 | 789670 | 2601
x9346757 | 708720 | 6743
x2019950 | 619283 | 6292
x4459038 | 763515 | 3147
x7216414 | 301591 | 2303
x7037127 | 796663 | 10751
x7861271 | 732369 | 7179
x3014623 | 426782 | 2017
x2968083 | 773790 | 10783
x9506183 | 221996 | 6506
x999498 | 461317 | 10599
x8891982 | 825517 | 1957
x2572541 | 520878 | 7483
x2287391 | 618447 | 8905
x7389590 | 485557 | 5625
x4828249 | 820607 | 7333
x4674573 | 191930 | 1738
x5506219 | 108045 | 7276
x2992861 | 284482 | 2578
x8281798 | 404084 | 4293
x2477640 | 279728 | 1847
x6925780 | 452019 | 7409
x6245786 | 910081 | 10429
x4030139 | 380779 | 1900
x1614954 | 893557 | 2785
x4059280 | 766997 | 7969
x3060307 | 86545 | 8532
x8565149 | 497708 | 5519
x1416149 | 716930 | 9663
x4850608 | 966240 | 6300
x6856407 | 510766 | 1855
x2026520 | 82178 | 9907
x143505 | 884952 | 2880
x9456835 | 629215 | 7801
x3651915 | 66140 | 1378
x6448893 | 571190 | 9512
x1461774 | 887924 | 2024
x7302843 | 371615 | 6177
x8520097 | 125314 | 8942
x3100702 | 258692 | 7403
x6452270 | 288365 | 1533
x102714 | 512452 | 9556
x6603751 | 771815 | 6936
[NAME] | 167364 | 9100
x6220988 | 294892 | 8369
x8132410 | 947150 | 7669
x1378961 | 228832 | 4082
x6933846 | 825220 | 1165
x3331464 | 896797 | 3920
x2985443 | 441849 | 7257
x8662778 | 125126 | 4655
x5167164 | 539653 | 9749
x5157474 | 908256 | 2861
x3551750 | 577141 | 3106
x8843342 | 643987 | 10721
x6690268 | 676513 | 5960
[NAME] | 846796 | 10865
[NAME] | 222843 | 5566
x3254260 | 847141 | 1321
x1549515 | 513121 | 6597
[NAME] | 672950 | 7585
x9172154 | 433013 | 4930
x5952909 | 326286 | 1890
x5532817 | 117460 | 2830
Spreadsheet: 93500d1293061818-help-with-sum-only-if-meets-both-criteria-hrs-per-area-2
Sheet: Sheet1

 |  | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | 2009-05-03 00:00:00 | 2009-05-04 00:00:00 | 2009-05-05 00:00:00 | 2009-05-06 00:00:00 | 2009-05-07 00:00:00 | 2009-05-08 00:00:00 | 2009-05-09 00:00:00 | 2009-05-10 00:00:00 | 2009-05-11 00:00:00 | 2009-05-12 00:00:00 | 2009-05-13 00:00:00 | 2009-05-14 00:00:00 | 2009-05-15 00:00:00 | 2009-05-16 00:00:00 | 2009-05-17 00:00:00 | 2009-05-18 00:00:00 | 2009-05-19 00:00:00 | 2009-05-20 00:00:00 | 2009-05-21 00:00:00 | 2009-05-22 00:00:00 | 2009-05-23 00:00:00 | 2009-05-24 00:00:00 | 2009-05-25 00:00:00 | 2009-05-26 00:00:00 | 2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 2009-05-29 00:00:00 | 2009-05-30 00:00:00 | 2009-05-31 00:00:00 | TOTALS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % breakdown per area
C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
C2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
TA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
Total hours: |  | 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 | #N/A
Spreadsheet: 682827d1592343740-best-approach-for-cross-referencing-another-table-book1
Sheet: Sheet1

Sales: |  |  |  | Total Sales Per Region:
Sales person | Sales Month | Customer ID |  | North | East | South | West
Person A | 2019-01-01 00:00:00 | 3546
Person A | 2019-02-01 00:00:00 | 2345
Person C | 2019-04-01 00:00:00 | 6534 |  | How can I get the total sales per region by looping through sales
Person D | 2019-04-01 00:00:00 | 3488 |  | and cross referencing each sales person's region from the other table?
Person B | 2019-07-01 00:00:00 | 854
Person B | 2019-09-01 00:00:00 | 6542
Person B | 2019-10-01 00:00:00 | 7066
Sales team:
Sales person | Region | Team | # Sales | < I don't want this 'Sales' column in this table
Person A | East | X |  | but not figured out how to get regional sales totals
Person B | West | X |  | without duplicating data from the other table
Person C | West | Y
Person D | North | Z
Person E | South | Y
Spreadsheet: 845842d1697176996-dashboard-to-pull-off-a-users-name-from-todays-date-rota
Sheet: Rota

 | Field Services
 | 2023
 | Today's Date: |  |  |  |  |  | 2023-10-07 00:00:00 | 2023-10-08 00:00:00 | 2023-10-09 00:00:00 | 2023-10-10 00:00:00 | 2023-10-11 00:00:00 | 2023-10-12 00:00:00 | 2023-10-13 00:00:00 | 2023-10-14 00:00:00 | 2023-10-15 00:00:00
 | Employee name | Sick | Entitled | C F/W | Used | Left
 | Graeme |  | 25 | 5 |  |  |  |  |  |  |  | OFF
 |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Trevor |  | 25 |  |  |  |  |  |  |  |  | OFF | OFF
 |  |  |  |  |  |  |  |  |  |  |  | OFF | OFF
 | Hugo |  | 25 |  |  |  |  |  |  |  |  |  | OFF
 |  |  |  |  |  |  |  |  |  |  |  |  | OFF
 | [NAME] |  | 25 |  |  |  |  |  |  |  |  | OFF
 |  |  |  |  |  |  |  |  |  |  |  | OFF
 | [NAME] |  | 25
 | [NAME] |  | 25
 | [NAME] |  | 25 |  |  |  |  |  |  |  |  |  |  | OFF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | OFF
 | Kaspars |  | 25
 | [NAME] |  | 25
 | [NAME] |  | 25
 | Archie |  | 25
 | [NAME] |  | 25
 | [NAME] |  | 25
 | Qaseem |  | 25
 | [NAME] |  | 25
 | [NAME] |  | 25
 | Ray |  | 25
 | Louis |  | 25
 | [NAME] |  | 25
 | [NAME] |  | 25
 | [NAME] |  | 25
 | [NAME] |  | 25
 | [NAME] |  | 25
 | Justin |  | 25
 | Leigh |  | 25
 | [NAME] |  | 25
 | Pyrus |  | 25
 | CODES | LEAVE | Annual Leave
 |  | HOLIDAY | Holiday
 |  | SICK | Sick
 |  | OFF | Office
 | Important Dates
 | Date | Description
 |  | New Year's Day
 |  | Good Friday
 |  | Easter Monday
 |  | Early May bank holiday
 |  | Bank holiday for the coronation of King [NAME]
 |  | Spring bank holiday
 |  | Summer bank holiday
 |  | Christmas Day
 |  | Boxing Day
Spreadsheet: 77249a08-5987-43eb-aa58-849bce8c574f
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/15/2008 | Men's Basketball | ELON | W, 92-47
11/20/2008 | Men's Basketball | LONGWOOD | W, 86-54
11/25/2008 | Men's Basketball | vs. Delaware State (Charleston, W.Va.) | W, 76-42
11/28/2008 | Men's Basketball | vs. Iowa (Las Vegas, Nev.) | W, 87-68
11/29/2008 | Men's Basketball | vs. Kentucky (Las Vegas, Nev.) | L, 43-54
12/03/2008 | Men's Basketball | at Mississippi | W, 80-78
12/06/2008 | Men's Basketball | CLEVELAND STATE | W, 53-43
12/09/2008 | Men's Basketball | vs. [NAME] (New York, N.Y.) | L, 65-68
12/13/2008 | Men's Basketball | at Duquesne | W, 68-63
12/20/2008 | Men's Basketball | MIAMI (OHIO) | W, 82-46
12/23/2008 | Men's Basketball | RADFORD | W, 89-54
12/27/2008 | Men's Basketball | at Ohio State | W, 76-48
01/03/2009 | Men's Basketball | at Seton Hall | W, 92-66
01/06/2009 | Men's Basketball | CONNECTICUT | L, 55-61
01/10/2009 | Men's Basketball | at Marquette | L, 53075
01/14/2009 | Men's Basketball | vs. [NAME] (Charleston, W.Va.) | W, 87-76
01/17/2009 | Men's Basketball | USF | W, 62-59
01/22/2009 | Men's Basketball | at Georgetown | W, 75-58
01/25/2009 | Men's Basketball | PITT | L, 67-79
01/28/2009 | Men's Basketball | ST. [NAME]'S | W, 75-52
[NAME] | Men's Basketball | at Louisville | L, 63-69
[NAME] | Men's Basketball | at Syracuse | L, 61-74
[NAME] | Men's Basketball | PROVIDENCE | W, 86-59
02/09/2009 | Men's Basketball | at Pitt | L, 59-70
02/13/2009 | Men's Basketball | VILLANOVA | W, 93-72
02/18/2009 | Men's Basketball | NOTRE DAME | W, 79-68
02/22/2009 | Men's Basketball | at Rutgers | W, 74-56
02/26/2009 | Men's Basketball | at Cincinnati | L, 61-65
03/01/2009 | Men's Basketball | at USF | W, 64-50
[NAME] | Men's Basketball | DEPAUL | W, 82-63
03/07/2009 | Men's Basketball | LOUISVILLE | L, 59-62
03/11/2009 | Men's Basketball | vs. Notre Dame (Big East Tournament) | W, 74-62
03/12/2009 | Men's Basketball | vs. Pitt (Big East Tournament) | W, 74-60
03/13/2009 | Men's Basketball | vs. Syracuse (Big East Tournament) | L, 69-74 (OT)
03/20/2009 | Men's Basketball | vs. [NAME] (NCAA) | L, 60-68
Spreadsheet: 34187d1231340325-need-help-linkning-and-if-sample-for-review-from-martin
Sheet: Sheet1

interest | 0.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | myrange
 | year | price today
Investment | 1 | 1000
Energy costs |  | 100
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Present value factor
Investement cost
energy costs
Present value of investment:
Investering3
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 146096d1331898831-graph-detail-book2
Sheet: Sheet1

 |  |  |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00
 |  |  | SALES | 6340.1 | 7573
 |  |  | MATERIALS | 2895.7 | 3332.4
 |  |  | LABOUR | 598.2 | 637.7
 |  |  | COS Overhead | 1826.4 | 1766.8
 |  |  | D&L | 430 | 456.8
 |  |  | SELLING Exp | 530.6 | 532.2
 |  |  | G&A | 669.7 | 988.5
 |  |  | OP. Profit | -610.5 | -141.4
 |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | Sales Jan 12 | Sales Feb 12 | P&L Jan | P&L Feb
 | MATERIALS | 2895.7 | 3332.4
 | LABOUR | 598.2 | 637.7
 | COS Overhead | 1826.4 | 1766.8
 | D&L | 430 | 456.8
 | SELLING Exp | 530.6 | 532.2
 | G&A | 669.7 | 988.5
 | Sales |  |  | 6340.1 | 7573
 | Profit / Loss
Spreadsheet: 216571d1361813859-find-and-replace-book2
Sheet: Sheet1

What The column is |  | What the column Needs to be
145802 |  | 146522
145802 |  | 146522
145802 |  | 146522
145802 |  | 146522
145802 |  | 146522
145802 |  | 146522
145802 |  | 146522
145803 |  | 146523
145803 |  | 146523
145803 |  | 146523
145803 |  | 146523
145803 |  | 146523
145803 |  | 146523
145803 |  | 146523
145804 |  | 146524
145804 |  | 146524
145804 |  | 146524
145804 |  | 146524
145804 |  | 146524
145804 |  | 146524
145804 |  | 146524
145805 |  | 146525
145805 |  | 146525
145805 |  | 146525
145805 |  | 146525
Spreadsheet: 9b14efcc-6187-410e-aec4-825b2f9b0f62
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Das Tragen einer Burka und anderen [NAME] wird im öffentlichen [NAME] verboten.
 | Welche Staatsbürgerschaft haben [NAME]?
Antwort | Schweizer/Schweizerin
[NAME] | 0.74
Neutral / Weiss nicht | 0.1
[NAME] | 0.15
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 377605d1424088659-formula-for-weighted-average-oeldere-377603d1424088422-formula-for-weighted-average-w-a
Sheet: Sheet2

Please calculate the weightage average
before proceeding the calculation, Is weightage distributed correctly?
Category | Marks | Weightage
Test1 | 70 | 0.5
Test2 | 90 | 0.1
Test3 | 80 | 0.2
Test4 | 60 | 0.3
Weighted Average
Spreadsheet: 0c840358-2b7a-40ad-925a-bcf5fb331d7f
Sheet: Invoices Billed & Paid

Date | Invoice # | Description | Amount | Invoice total | Databases total
2009-09-28 00:00:00 |  | Amount carried over from 2008-2009 |  |  | 488370.25
2009-07-28 00:00:00 | 1129 | 2009-1010 Databases and e-resources | 1094862.71 | 1094862.71 | 1094862.71
2009-08-18 00:00:00 | 1140 | 2009-2010 Annual Membership | 60943.53 | 60943.53
2010-03-29 00:00:00 | 1165 | Reconciliation 09-10 | 71696.33 | 71696.33 | 71696.33
2010-04-26 00:00:00 | 1167 | Prepay for 2011 | 573000 | 573000 | 573000
2010-05-13 00:00:00 | 1170 | [NAME] purchase | 156569 | 156569 | 156569
2010-06-10 00:00:00 | 1176 | [NAME] & Francis 1 X purchase | 24475.5 | 24475.5 | 24475.5
Total paid by URI
Total [NAME] by HELIN 2009/2010 |  |  |  |  | 1836980.39
Total Databases Invoiced & Paid by URI 2009/2010 |  |  |  |  | 2408973.79
Total URI has on deposit with HELIN
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-13

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-13 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: 155103d1336669442-merge-multiple-spreadsheets-easily-copy-of-chm104l6-3-09-12
Sheet: JDA_Data

POG # | LINE | Part Number | CAPACITY
CHM104L6 | POG | CHM104L6 | 1
CHM104L6 | PVF | 3012 | 8
CHM104L6 | PVF | 3012UV | 7
CHM104L6 | QST | 306 | 1
CHM104L6 | QST | 307 | 1
CHM104L6 | QST | 308 | 4
CHM104L6 | QST | 310 | 1
CHM104L6 | QST | 310H | 1
CHM104L6 | QST | 310L | 1
CHM104L6 | QST | 311 | 2
CHM104L6 | QST | 312 | 1
CHM104L6 | QST | 320 | 1
CHM104L6 | QST | 322 | 1
CHM104L6 | QST | 323 | 1
CHM104L6 | QST | 325 | 1
CHM104L6 | QST | 332 | 1
CHM104L6 | QST | 340 | 1
CHM104L6 | QST | 343 | 1
CHM104L6 | QST | 345 | 2
CHM104L6 | QST | 347 | 4
CHM104L6 | QST | 350 | 1
CHM104L6 | QST | 372 | 1
CHM104L6 | QST | 374CS | 1
CHM104L6 | QST | 375CS | 1
CHM104L6 | QST | 376CS | 1
CHM104L6 | QST | 401GCS | 1
CHM104L6 | QST | 401P | 2
CHM104L6 | QST | 418 | 1
CHM104L6 | QST | 422 | 1
CHM104L6 | QST | 423 | 1
CHM104L6 | QST | 425 | 1
CHM104L6 | QST | 429 | 1
CHM104L6 | QST | 432 | 1
CHM104L6 | QST | 433CS | 1
CHM104L6 | QST | 436 | 1
CHM104L6 | QST | 438 | 1
CHM104L6 | QST | 439 | 1
CHM104L6 | QST | 461 | 1
CHM104L6 | QST | 760 | 1
CHM104L6 | QST | CA-1 | 1
CHM104L6 | QST | CQS-11 | 1
CHM104L6 | QST | E-100UV | 1
CHM104L6 | QST | GEZ-1HD | 1
CHM104L6 | QST | GPH-6 | 1
CHM104L6 | QST | GPL-5 | 1
CHM104L6 | QST | [NAME] | 1
CHM104L6 | QST | LR-14 | 1
CHM104L6 | QST | [NAME] | 1
CHM104L6 | QST | P-150UV | 1
CHM104L6 | QST | P-100UV | 1
CHM104L6 | QST | P-46UV | 1
CHM104L6 | QST | PY-7 | 1
CHM104L6 | QST | TH-27 | 1
CHM104L6 | QST | VA-1L | 1
CHM104L6 | QST | VA-LH11 | 1
Spreadsheet: 866916d1713824068-formula-to-insert-text-into-a-table-looking-at-time-location-sample-1b-tms
Sheet: Sheet1

 |  | [NAME]
TIME |  | L-1 |  | L-2 |  | [NAME] |  | L-4 |  | [NAME] |  | L-6 |  | L-7 |  | L-8
9:00 - 9:59 |  | 22585(9:26) |  |  |  |  |  | 54487(9:48) |  |  |  |  |  |  |  | 22484(9:58)
12:00 - 12:59 |  |  |  | 74485(12:00) |  |  |  |  |  |  |  | 44125(12:44)
14:00-14:59 |  |  |  |  |  | 33226(14:22)
18:00-18:59 |  |  |  |  |  |  |  |  |  | 66598(18:22)
23:00-23:59 |  |  |  |  |  |  |  |  |  |  |  |  |  | 41145(23:16)
02:00-02:59 |  | 63352(2:12)
04:00-04:59 |  |  |  | 77894(4:01) |  |  |  | 22568(4:28) |  |  |  |  |  |  |  | 52289(4:49)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | Time | Location | Rte #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:26:00 | L-1 | 22585(9:26)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:48:00 | L-4 | 54487(9:48)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:58:00 | L-8 | 22484(9:58)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | L-2 | 74485(12:00)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:44:00 | L-6 | 44125(12:44)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:22:00 | [NAME] | 33226(14:22)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:22:00 | [NAME] | 66598(18:22)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:16:00 | L-7 | 41145(23:16)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:12:00 | L-1 | 63352(2:12)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:01:00 | L-2 | 77894(4:01)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:28:00 | L-4 | 22568(4:28)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 04:49:00 | L-8 | 52289(4:49)
Spreadsheet: 4bc4f9b5-aca5-4b26-bff2-a6715f54d2e7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
4111 | 5369 | Kiyomi | Niwata | JPN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 00:31:49
4111 | 5467 | Vendula | Frintova | CZE | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | [NAME]
4111 | 17660 | [NAME] | Crowley | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 00:32:23
4111 | 5565 | Misato | Takagi | JPN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 00:33:05
4111 | 6386 | Aoi | Kuramoto | JPN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 00:33:34
4111 | 7915 | Long | Hoi | MAC | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | 00:34:11
4111 | 6726 | Yi-Wen | Wang | TPE | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | 00:36:45