tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: judy_townsend__17757__TETCOIMB
Sheet: Oct'01

TETCO MAY IMBALANCES
Gas Day | Scheduled Imbalances-oc710 |  |  |  |  | Interconnect Cuts/Judy Imbalances |  |  |  |  | Allocated Imbalances (2 day lag) |  |  |  |  | Total-cb05 |  |  |  |  | Gas Day |  | Transport
 | STX | ETX | WLA | ELA | M1 | STX | ETX | WLA | ELA | M1 | STX | ETX | WLA | ELA | M1 | STX | ETX | WLA | ELA | M1 |  |  | STX | ETX | WLA | ELA
1 | 194 | 144 | -5441 |  |  |  |  |  | -1855 |  | 0 | -996 | 0 | 0 |  |  |  |  |  |  | 1
2 | 872 | 285 | 641 | -4677 |  |  |  |  | 1000 |  | 0 | -1113 | 0 | 0 |  |  |  |  |  |  | 2
3 | 113 | -15 | -525 | 86 |  | 392 |  | 1855 | 1310 | -1 | 0 | -1056 | 0 | 0 |  |  |  |  |  |  | 3
4 | -1025 | -15 | 652 | -138 |  |  | 1 | 3 | -5057 |  | 0 | -973 | 0 | 0 |  |  |  |  |  |  | 4
5 | -1363 | -15 | 283 | 281 |  |  |  | 1 | -298 |  | 0 | 5 | 0 | 0 |  |  |  |  |  |  | 5
6 | -367 | 800 | 715 | 142 |  | -99 |  |  | 129 |  | 333 | -781 | 0 | 0 |  |  |  |  |  |  | 6
7 | -367 | 800 | 715 | 142 |  | -99 |  |  | 129 |  | 1 | -1069 | 0 | 0 |  |  |  |  |  |  | 7
8 | -367 | 800 | 715 | 142 |  | -99 |  |  | 129 |  | 1 | -576 | 0 | 0 |  |  |  |  |  |  | 8
9 | 382 | -3889 | -1085 | 328 |  |  |  |  | 81 |  | 0 | -291 | 0 | 0 |  |  |  |  |  |  | 9
10 | 87 |  | 687 | 119 |  |  | -978 |  | -7179 | -1 | 0 | -89 | 0 | 0 |  |  |  |  |  |  | 10
11 | -922 |  | -870 | -589 |  |  | 94 |  | -5664 |  | 0 | -304 | 0 | 0 |  |  |  |  |  |  | 11
12 | 78 | -31 | 78 | -318 |  |  |  | 120 | 1 |  | 0 | -181 | 0 | 0 |  |  |  |  |  |  | 12
13 | -668 | -39 | -113 | -1900 |  |  |  |  | -75 |  | 0 | -117 | -1 | 0 |  |  |  |  |  |  | 13
14 | -668 | -39 | -113 | -1900 |  |  |  |  | -75 |  | 0 | -233 | -1 | 0 |  |  |  |  |  |  | 14
15 | -668 | -39 | -113 | -1900 |  |  |  |  | -75 |  | 0 | 68 | -1 | 0 |  |  |  |  |  |  | 15
16 | -257 | -39 | -972 | -688 |  |  | -714 | -1 | 1 |  | 0 | 45 | 0 | 0 |  |  |  |  |  |  | 16
17 | -1348 | -515 | 754 | -867 |  | 4 | 1 |  |  | -1 |  |  |  |  |  |  |  |  |  |  | 17
18 | 151 | 85 | 2046 | 1048 |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
FILE NAME:  O:\logistics\capacity\east\ne\TETCOIMB |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage |  | 0.25 | 0.25 | 1.18 | 0.11
Spreadsheet: 202354d1356527129-transpose-filldown-transpose_filldown-copy2
Sheet: Example 2 Your solution

3 | 2
2 | 5
1 | 6
4 | 8
6 | 6
7 | 3
2 | 2
1 | 1
3 | 5
Spreadsheet: 157735d1337859972-autofill-list-in-tab-l-from-tab-a-autofill-list-in-tab-l-from-tab-a
Sheet: tab L

INFORMATIONSBLAD
CPQ Nr |  |  | A-nr |  |  | DOP-nr |  |  | [NAME] |  | Skapare |  | Datum
95123-1
AGGREGAT: |  |  |  | ML Super Classic
Jämför gammal order: |  |  |  |  | DOP666
ARBETSTIMMAR
AE Elec E |  |  |  | 1
AE Mech E |  |  |  | 10000
AE Riskanalys |  |  |  | 0
AE Manual |  |  |  | 0
[NAME] |  |  |  | 10001
Plåt |  |  |  | 0
Test |  |  |  | 0
Test ställtid |  |  |  | 0
[NAME] |  |  |  | 1000
Elpanel |  |  |  | 0.5
Värmare |  |  |  | 0
Agg.mont |  |  |  | 0
Summa WS |  |  |  | 1000.5
I want the information from tab A to show up below
Note that the number of rows in tab A is dynamic, therefore the field below must be dynamic.
Antal | Artikel |  |  |  | Struktur |  | Beskrivning |  |  |  |  |  |  | Kommentar
c A | col B |  |  |  | col D |  | col E |  |  |  |  |  |  | col H
X | [NAME] förändringar
Spreadsheet: 91235d1290992742-creating-a-15-minute-planner-desired
Sheet: Sheet1

 | Start Date
Monday | 2010-11-22 00:00:00 | 08:00:00 | 08:15:00 | 08:30 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00
10000 | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 1 hour Darling | #N/A | #N/A | #N/A | #N/A | #N/A
20000 | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
30000 | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Tuesday | 2010-11-23 00:00:00 | 08:00:00 | 08:15:00 | 08:30 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:15:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00
 | [NAME] | #N/A | #N/A | #N/A | #N/A | 1 hour Mr [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 1 hour [NAME] |  |  |  | #N/A | #N/A
 | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I removed 3 x #N/A manually to enable the full display over the time period
Wednesday | 2010-11-24 00:00:00 | 08:00:00 | 08:15:00 | 08:30 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:15:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 12:45:00 | 13:00:00 | 13:15:00
 | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | [NAME] | #N/A | #N/A | #N/A | #N/A | 1 hour [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | [NAME] | #N/A | #N/A | #N/A | #N/A | 1 hour [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | 1 hour Miss [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | 1 hour Mr Fleming | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 880223d1727863162-help-with-vertical-to-horizontal-sorting-sorting-help
Sheet: Sheet1

 | Table 1 |  |  | Table 2
 | Part # | Gauge |  | Part # | Gauge
 | 1 | A |  | 1 | A | B | C | D
 | 1 | B |  | 2 | A | B | C | D
 | 1 | C |  | 3 | A | B | C | D
 | 1 | D |  | 4 | A | B | C | D
 | 2 | A |  | 5 | A | B | C | D
 | 2 | B |  | 6 | A | B | C | D
 | 2 | C |  | 7 | A | B | C | D
 | 2 | D |  | 8 | A | B | C | D
 | 3 | A |  | 9 | A | B | C | D
 | 3 | B |  | 10 | A | B | C | D
 | 3 | C
 | 3 | D
 | 4 | A
 | 4 | B
 | 4 | C
 | 4 | D
 | 5 | A
 | 5 | B
 | 5 | C
 | 5 | D
 | 6 | A
 | 6 | B
 | 6 | C
 | 6 | D
 | 7 | A
 | 7 | B
 | 7 | C
 | 7 | D
 | 8 | A
 | 8 | B
 | 8 | C
 | 8 | D
 | 9 | A
 | 9 | B
 | 9 | C
 | 9 | D
 | 10 | A
 | 10 | B
 | 10 | C
 | 10 | D
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 115 | 240
2 | 58 | 240
3 | 44 | 240
4 | 2 | 240
5 | 35 | 240
6 | 41 | 240
7 | 245 | 240
8 | 171 | 240
9 | 114 | 240
10 | 149 | 240
11 | 171 | 240
12 | 143 | 240
13 | 2 | 240
14 | 184 | 240
15 | 146 | 240
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 173805.23
2001-12-15 00:00:00
CBS Volume
 |  |  | 76238
Spreadsheet: 114051d1309919602-format-as-a-table-filter-problem-createvalidationlist
Sheet: Sheet1

Name | Task |  |  |  |  |  | Name |  |  |  |  |  | Name
[NAME] | Task 1 | >>> | Copy Column A over to Column H >> |  |  |  | [NAME] | >> Delete Duplicates from H and it looks like >>> |  |  |  |  | [NAME] | <<You are left with this List
Fred | Task 2 |  |  |  |  |  | Fred |  |  |  |  |  | Fred | << Use this list in a Data Validation for
[NAME] | Task 3 |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] | << Column A rows 2 and down.
[NAME] | Task 4 |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
[NAME] | Task 5 |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
[NAME] | Task 6 |  |  |  |  |  | [NAME]
Fred | Task 7 |  |  |  |  |  | Fred |  |  |  |  |  |  | Now if you click on a Cell in Col A
[NAME] | Task 8 |  |  |  |  |  | [NAME] |  |  |  |  |  |  | It will let you pick one of the above names.
[NAME] | Task 9 |  |  |  |  |  | [NAME]
[NAME] | Task 10 |  |  |  |  |  | [NAME]
[NAME] | Task 11 |  |  |  |  |  | [NAME]
Fred | Task 12 |  |  |  |  |  | Fred
[NAME] | Task 13 |  |  |  |  |  | [NAME]
[NAME] | Task 14 |  |  |  |  |  | [NAME]
[NAME] | Task 15 |  |  |  |  |  | [NAME]
[NAME] | Task 16 |  |  |  |  |  | [NAME]
Fred | Task 17 |  |  |  |  |  | Fred
[NAME] | Task 18 |  |  |  |  |  | [NAME]
[NAME] | Task 19 |  |  |  |  |  | [NAME]
[NAME] | Task 20 |  |  |  |  |  | [NAME]
[NAME] | Task 21 |  |  |  |  |  | [NAME]
Fred | Task 22 |  |  |  |  |  | Fred
[NAME] | Task 23 |  |  |  |  |  | [NAME]
[NAME] | Task 24 |  |  |  |  |  | [NAME]
[NAME] | Task 25 |  |  |  |  |  | [NAME]
Spreadsheet: 110481d1307118783-excel-2007-autohide-row-if-all-cells-in-range-read-x-chores
Sheet: CHORE LIST

 |  |  |  | BOB | SUE | GEORGE | FRANK | HELEN | / | S3
# | TASK | REFERENCE | SUSPENSE |  |  |  |  |  | DUE | [NAME]
1 | Clean Room | List | 190800MAY2011 | NA | X | X | X | X |  | S6
2 | Do [NAME] | List | 051700MAY2011 | / | / | / | / | / |  | CSM
3 | Wash Dishes | List | 200800MAY2011 | DUE | DUE | X | DUE | X |  | BC
 |  |  | [NAME] | X
 |  |  | PENDING | /
 |  |  | OVERDUE | DUE
 |  |  | NOT APPLICABLE | NA
Spreadsheet: 857057d1706140058-quick-help-with-an-if-and-formula-i-think-aaa-sample-1
Sheet: RSVP

[NAME] | Reimers
[NAME] | Reimers
[NAME] | Reimers
Tiara | Pack
Jessica | [NAME]
[NAME] | Greene
[NAME] | Manor
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Hong
[NAME] | Hong
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Dr. Salwa

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation after deducting 5% Admin | 0.5
 |  | Labs after deducting 5% Admin | 0.1
 |  | Procedure in Clinics after deducting consumables and 5% Admin | 0.4
 |  | OR in Clinics after deducting OR Fees and 5% Admin | 0.4
 |  | OR in Clinics after deducting OR Fees and 5% Admin (Machine Contract) | 0.8
Doctor Calculation
 |  | Consultation Revenue | 0
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Referral Revenue | 0
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | LAB Revenue | 0
 |  | [NAME] (65%)
 |  | Clinics Share (35%)
 |  | Amount to be Paid
 |  | Procedure in the Clinics Revenue | 0
 |  | Consumables
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | OR in the Clinics Revenue | 0
 |  | OR Fees
 |  | Extra Consumables in OR | 0
 |  | [NAME] fee 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Less: Marketing (50/50) | 0
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | Sr. Finance Manager |  | .......................
 |  |  |  |  |  |  |  | Operations Report on FEB - 2020
 |  |  |  |  |  |  |  | # | Day/Date | Time | Patient Name and file number |  | [NAME] | Surgeon | Anesthesia | Amount
 |  |  |  |  |  |  |  | 1 | Saturday 29-02-2020 | At 12:25 pm he tooks         1 hr & 5 mins | [NAME] 10057203 |  | Posterior repair and [NAME] filler | Dr Salwa | Local | 2000
Spreadsheet: 107dbd88-a1ee-4607-a3b4-09a0e27af626
Sheet: Sheet1

Description of Table S8.  Raw data for mitochondrial motility assays. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
The frequency of sustained mitochondrial movements was obtained for wild type, a puf3D strain, an aim21D strain, and three chemical exposures as described in the “Mitochondrial Tracking Microscopy” section of the Methods.  Due to the size of this table, it is only available online.
Minute of Observation | wild-type | puf3D | aim21D | [NAME] | NaF | NaN3
1 | 0 | 0 | 0 | 2 | 0 | 0
2 | 2 | 0 | 0 | 5 | 0 | 0
3 | 0 | 0 | 0 | 0 | 0 | 0
4 | 0 | 0 | 0 | 0 | 1 | 0
5 | 3 | 0 | 0 | 0 | 0 | 0
6 | 2 | 1 | 0 | 0 | 0 | 0
7 | 0 | 1 | 0 | 1 | 0 | 0
8 | 0 | 0 | 0 | 0 | 0 | 0
9 | 1 | 0 | 0 | 0 |  | 0
10 | 0 | 1 | 0 | 2 |  | 0
11 | 0 | 1 | 2 | 0 |  | 1
12 | 0 | 0 | 0 | 0 |  | 0
13 | 0 | 1 | 0 | 0
14 | 2 | 0 | 1 | 0
15 | 0 | 2 | 0 | 2
16 | 0 | 2 | 1 | 2
17 | 1 | 0 | 0 | 2
18 | 1 | 1 | 0 | 1
19 | 0 | 1 | 3 | 1
20 | 1 | 0 | 0 | 4
21 | 1 | 0 | 0
22 | 0 | 0 | 0
23 | 4 | 0 | 3
24 | 4 | 0 | 1
25 | 2 | 2 | 0
26 | 1 | 1 | 0
27 | 2 | 0 | 1
28 | 0 | 0 | 0
29 | 0 | 2 | 0
30 | 0 | 1 | 0
31 | 0 | 1 | 0
32 | 0 | 1 | 0
33 | 1 | 1 | 0
34 | 0 | 1 | 1
35 | 1 | 0 | 1
36 | 0 | 0 | 0
37 | 0 | 0 | 1
38 | 0 | 0 | 0
39 | 0 | 1 | 0
40 | 0 | 2 | 1
41 | 2 | 0 | 0
42 | 1 | 0 | 1
43 | 3 | 0 | 0
44 | 1 | 0 | 0
45 | 0 | 0 | 0
46 | 0 | 1 | 0
47 | 0 | 2 | 0
48 | 1 | 1 | 1
49 | 1 | 0 | 0
50 | 1 | 1 | 0
51 | 0 | 2 | 1
52 | 0 | 2 | 0
53 | 1 | 0 | 1
54 | 0 | 1 | 1
55 | 0 | 0 | 0
56 | 0 | 0 | 1
57 | 0 |  | 0
58 | 0 |  | 0
59 | 0 |  | 0
60 | 4 |  | 0
61 | 3 |  | 0
62 | 5 |  | 0
63 | 4 |  | 0
64 | 4 |  | 1
65 | 3 |  | 0
66 | 1 |  | 1
67 | 0 |  | 0
68 | 1 |  | 0
69 | 1
70 | 0
71 | 0
72 | 0
73 | 2
74 | 1
75 | 1
76 | 1
77 | 2
78 | 0
 | wild-type | puf3D | aim21D | [NAME] | NaF | NaN3
Avg. Events per minute | 0.9358974358974359 | 0.6071428571428571 | 0.3529411764705883 | 1.1 | 0.125 | 0.08333333333333333
Standard Error | 0.1440803781732266 | 0.09762960559524322 | 0.08050735160306251 | 0.3236307187293307 | 0.125 | 0.08333333333333333
Spreadsheet: 771474fb-a62a-4736-866d-14c24d542b08
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38648864 | 2013-11-21 23:19:23 | AXIS | 0 | 1 | 6 | 1403431 | player1403431 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38649156 | 2013-11-21 23:51:16 | ALLIES | 1 | 6 | 5 | 1403431 | player1403431 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38661918 | 2013-11-22 22:47:03 | AXIS | 1 | 6 | 1 | 1447927 | player1447927 | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
38662468 | 2013-11-22 23:12:24 | ALLIES | 1 | 6 | 2 | 1447927 | player1447927 | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
38687834 | 2013-11-24 16:20:39 | AXIS | 1 | 5 | 2 | 240776 | DoctorSchizzo | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
38688082 | 2013-11-24 16:40:55 | ALLIES | 1 | 5 | 2 | 240776 | DoctorSchizzo | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
38694307 | 2013-11-24 23:19:09 | ALLIES | 1 | 6 | 3 | 1449090 | player1449090 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
38709279 | 2013-11-26 00:15:37 | AXIS | 1 | 6 | 2 | 668571 | Jf Orion | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
38709693 | 2013-11-26 01:04:27 | ALLIES | 1 | 6 | 4 | 668571 | Jf Orion | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
38721615 | 2013-11-26 22:32:05 | ALLIES | 1 | 5 | 4 | 678541 | Sauron93 | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
38722132 | 2013-11-26 22:51:53 | AXIS | 0 | 0 | 5 | 678541 | Sauron93 | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
38764828 | 2013-11-30 01:12:54 | ALLIES | 0 | 5 | 7 | 1451993 | player1451993 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
38765129 | 2013-11-30 01:39:41 | AXIS | 1 | 7 | 5 | 1451993 | player1451993 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
38775250 | 2013-11-30 19:56:28 | ALLIES | 0 | 4 | 6 | 1351059 | misterfunny | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
38775633 | 2013-11-30 20:22:59 | AXIS | 1 | 6 | 2 | 1360620 | Factotem | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
38775840 | 2013-11-30 20:51:17 | ALLIES | 0 | 4 | 6 | 1360620 | Factotem | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
38835182 | 2013-12-04 22:38:14 | AXIS | 1 | 7 | 3 | 890726 | jcpast78 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
38835485 | 2013-12-04 22:56:48 | ALLIES | 0 | 3 | 7 | 890726 | jcpast78 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
Spreadsheet: 200859d1355782328-matching-multiple-cells-to-different-tabs-on-a-worksheet-index-of-employees-solution
Sheet: East

 | 2 | 3 | 4 | 5
 | East
 | Division | Last Name | First Name | Employee ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 1a88c9c1-50eb-4531-817f-c4e7ba5cfcdc
Sheet: Sheet1

Unnamed: 0 | Write a brief description of what the trip will and will not cover: | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | A. # of days abroad |  |  | NOTE: When preparing a budget, plan for expenses based on a low number of students (e.g. 6-10). It is better to quote too high a price than too low.
 | B. # of enrolled students plus the instructor(s) - when students pay for that trip
 | C. # of enrolled students
 | D. # of other participants (i.e. guests, family members)
 | Dollar price of the host country's currency (additional 7% of the currency rate is recommended to account for any fluctuations)
 | Short-term Study/Travel Course Budget
 | Course Title:
 | Dates:
 | Academic Department:
 | Account:
 | Primary Expenses
 |  | Per participant | For 10 participants | For 20 participants | For 30 participants
 | Transportation to and from airport in the US
 | Transportation (international air)
 | Transportation in country (in-country flights, metro, bus, train, etc.,)
 | Transportation(other)
 | Lodging (location 1)
 | Lodging (location 2)
 | Lodging (location 3)
 | Lodging (location 4)
 | Meals (number and type)
 | Mandetory Medical Insurance (including Political & Natural Disaster Evacuation coverage) - $2.34 per day must be multiplied by number of travel days[NOTE: Quoted benefits and rates are in effect until September 1, 2014 and are subject to change thereafter] | 2.34 | 23.4 | 46.8 | 70.19999999999999
 | Mandatory Trip Interruption/Cancellation, Trip Delay, Baggage Delay & Lost Baggage Fee | 68.63 | 686.3 | 1372.6 | 2058.9
 | Honoraria, fees
 | Events (i.e. tickets, admissions, excursions, etc.)
 | Contingency fee per student (non-refundable) | 30 | 300 | 600 | 900
 | Other: Explain
 | E. TOTAL EXPENSES | 100.97 | 1009.7 | 2019.4 | 3029.099999999999
 | Additional Expenses
 | International cell phone rental [e.g.  6-25 day rental through Telestial (www.telestial.com) - a regular cell phone starts with $3.50/day and a Satellite Phone is as low as $3.99/day if you are traveling to a remote location where cell phone service may not be available. You will most likely need to buy additional airtime for your SIM card.]
 | Incidentals (i.e. gratuities)
 | Discretionary cash
 | Administrative fees (i.e. service fees to the tour company)
 | Other: Explain
 | F. TOTAL ADDITIONAL EXPENSES
 | G. TOTAL DIRECT STUDENT EXPENSES
 | Note: Instructors do not typically pay the cost of their travel expenses, but rather bill that expense into the total cost per student. This figure will be determined by dividing the total expenses by the number of enrolled students.
 | (E. total expenses X B. number of participants + F. additional expenses) / C. number of enrolled students  = G. total direct student expenses
Spreadsheet: 712210d1610112422-combine-data-from-multiple-sheets-on-one-sheet-cert-jobs-wip-copy
Sheet: Data

Employee Login | 14491 | 8683 | 17211 | 69975 | 88153 | 63373 | 73429 | Shift Pattern
melacolq | pass | pass | pass | pass | pass | pass | 73429 | NT6-0000
[NAME] | pass | pass | pass | pass | pass | pass | 73429 | MG6-1800
iriomaia | fail | fail | fail | fail | fail | fail | 73429 | MM2-1800
marvelad | pass | pass | pass | pass | pass | pass | 73429 | MG7-1800
melisahc | fail | fail | fail | fail | fail | fail | 73429 | DT5-0845
melisahc | fail | fail | fail | fail | fail | fail
Spreadsheet: 859205d1707670069-refer-to-visible-cell-only-example
Sheet: Worksheet 1

 | FY20 | FY20 | FY20 | FY20 | FY20 | FY21 | FY21 | FY21 | FY21 | FY21 | FY22 | FY22 | FY22 | FY22 | FY22
 | Jul-Sep | Oct-Dec | Jan-Mar | Apr-Jun | [NAME] | Jul-Sep | Oct-Dec | Jan-Mar | Apr-Jun | [NAME] | Jul-Sep | Oct-Dec | Jan-Mar | Apr-Jun | [NAME]
Data Series 1 | 26 | 792 | 541 | 387 |  | 128 | 293 | 188 | 107 |  | 885 | 293 | 643 | 724
Data Series 2 | 502 | 313 | 136 | 682 |  | 965 | 724 | 877 | 965 |  | 701 | 162 | 544 | 678
Data Series 3 | 390 | 977 | 935 | 772 |  | 234 | 844 | 461 | 523 |  | 827 | 206 | 11 | 853
Data Series 4 | 807 | 698 | 359 | 412 |  | 304 | 925 | 430 | 582 |  | 929 | 53 | 310 | 438
Spreadsheet: 330596d1404808981-how-to-delete-blank-lines-delete-blank-lines
Sheet: Sheet1

No | GR | Ticket No | Weight
319 |  | 4772 | 479
319 |  | 4774 | 300
319 |  | 4774 | 188
746 |  | 4772 | 458
746 |  | 4780 | 399
746 |  | 4780 | 300
418 |  | 4780 | 188
418 |  | 4780 | 489
418 |  | 4780 | 350
782 |  | 4780 | 103
782 |  | 4752 | 208.5
782 |  | 4752 | 407
782 |  | 4780 | 78
782 |  | 4791 | 250
575 |  | 4758 | 458.5
575 |  | 4758 | 395.5
575 |  | 4760 | 131
575 |  | 4760 | 457.5
575 |  | 4760 | 429.5
575 |  | 4759 | 279.5
575 |  | 4759 | 460.5
575 |  | 4759 | 170
243 |  | 4554 | 243.5
243 |  | 4554 | 221
243 |  | 4555 | 298
534 |  | 4595 | 458.5
534 |  | 4601 | 416.5
534 |  | 4595 | 452
534 |  | 4601 | 279
246 |  | 4764 | 449.5
246 |  | 4761 | 48
246 |  | 4763 | 119
246 |  | 4761 | 275
246A |  | 4761 | 194
246A |  | 4764 | 218
569 |  | 4546 | 405
569 |  | 4561 | 428.5
569 |  | 4559 | 85
569 |  | 4562 | 385
569 |  | 4631 | 135
569 |  | 4356 | 380
569 |  | 4631 | 153.5
557 |  | 4245 | 274.5
557 |  | 4610 | 446.5
557 |  | 4610 | 312.5
219 | 614187 |  | 383
219 | 614177 |  | 379
219 | 614177 |  | 398
219 | 614163 |  | 260
219A | 614163 |  | 20
219A | 616152 |  | 357
219A | 616152 |  | 375
219A | 614152 |  | 376
219A | 614187 |  | 395
Spreadsheet: 101446d1299573628-excel-2007-conditional-time-formula-mobile-phone-breakdown-2011-details-removed
Sheet: Sheet1

 |  |  |  |  | Pre Bundle Cost | Post Bundle Cost | Pre Bundle Cost | Post Bundle Cost
Mobile Number | User | Location Charge | No. of Voice Calls | No. of Texts | Texts | Texts | Calls 19.00 - 07.00 Mon -Fri & 19.00 - 07.00 Fri -Mon (Including BH) | Calls 19.00 - 07.00 Mon -Fri & 19.00 - 07.00 Fri -Mon (Including BH) | [NAME] | Shared Charges | [NAME] | Cost for User