tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 314d0348-f612-491f-bcec-217c2ca62e63
Sheet: Budget Spreadsheet

Program; Term 20XX: Director
Program Dates: Month XX, 20XX to Month XX, 20XX
ORG: TBD
 |  |  | Number of faculty supported by participants |  |  |  | USD to 1 Foreign Currency
Classes: |  |  | 2 |  |  |  | 1.45 |  |  |  | Number of rooms | 9
 |  |  |  |  |  |  |  |  |  |  | People per room | 2 |  | *Please only enter one price (in USD or foreign currency) for each hotel.
 |  |  | Number of anticipated participants |  |  |  | Activities & Excursions | Foreign Currency per ticket | Cost Per Person |  | Accommodations | Dates | # of nights | Foreign Currency per room per night* | Total Cost (foreign currency to USD) | USD Cost per room per night* | Total cost
 |  |  | 10
Budget Item | Foreign Currency | USD | Per Person Expense | Practicum Stay
[NAME] |  |  |  |  | The [NAME]. stipend amount is $2000.00
Faculty Benefits |  | 0
[NAME] |  | 545 |  |  | (Depart $270)  (Arrival $270) for up to 14
Airfare (per person) |  | 0
Airport Transfers | 0 | 0
Housing (total cost; fac/dir & students) |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | Total
Meals (per person)
Activities & Excursions (per person) |  |  |  |  |  |  |  |  |  |  | Participant Meals | # of meals you wish to include | Amount permitted per meal |  |  | Cost Per Person
On-site transportation (coach) |  | 0 |  |  |  |  |  |  |  |  | Breakfast |  | 8
Coach [NAME] |  | 0
Tips |  | 0 |  |  |  |  |  |  |  |  | Lunch |  | 9
Phone Charges |  |  |  |  |  |  |  |  |  |  | Dinner |  | 19
Contingencies |  |  | 25 |  | 10% minimum to be included by EAO |  |  |  |  |  | Total
Director & Faculty Airfare |  | 0
Director & Faculty Insurance |  | 37.14 |  |  |  |  |  |  |  |  | Director & Faculty Stipend | # of students | Amount allotted per student |  |  | Stipend
Director & Faculty Daily Meals |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 0
Director& Faculty Activities
Director & Faculty Local Transportation |  | 0 |  |  |  |  | Total cost per person |  |  |  | Director & Faculty Meals | # of meals you wish to include | Amount permitted per meal |  |  | Cost Per Person
Director & Faculty to/from US Airport |  | 0 |  |  |  |  | Phone Usage Charges |  |  |  | Breakfast |  | 8
Director & Faculty Graduation Sashes ($30 each) |  |  |  |  |  |  | Phone ($35 If phone is not returned) |  |  |  | Lunch |  | 9
 |  |  |  |  |  |  | SimCard ($25 If SimCard is not returned) |  |  |  | Dinner |  | 19
Total Individual Expenses |  |  |  |  |  |  | Mandatory Minutes and Phone Rental |  |  |  | Total
 |  |  |  |  |  |  | Additional Credit (when account drops below $20, $30 credit will automatically be credited and be billed to the assigned individual's account. Alternate option to take your own phone and receive the MSU Cell Phone Stipend of $64.
 |  |  |  |  |  |  | Total
Advertised Program Price |  | $????? |  |  |  |  | Note:  Students are required to buy insurance for themselves as part of their applications on Horizon's through CISI.  The insurance is $37.14 per person.  There is a link in the Horizon's post acceptance application that explains to students how to complete this portion of the application.
Spreadsheet: 7b69e848-eaed-418d-a82d-7aab843f474e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
4563 | 10545 | Urmas | Utar | EST | 127 | 00:12:26 | 00:00:31 | 00:14:47 | 00:00:48 | 00:14:18 | 1 | 00:42:53
4563 | 21534 | Volodymyr | Fotyniuk | UKR | 0 | 00:13:24 | 00:00:49 | 00:15:34 | 00:01:06 | [NAME] | 2 | 00:44:51
4563 | 21820 | Milan | Celerin | SVK | 125 | 00:13:31 | 00:00:31 | 00:16:29 | 00:00:48 | 00:16:41 | 3 | 00:48:04
4563 | 28256 | [NAME] | Moiseev | RUS | 128 | 00:14:22 | 00:00:34 | 00:16:04 | 00:01:10 | 00:15:59 | 4 | 00:48:13
4563 | 28357 | Jan | Gombala | SVK | 126 | [NAME] | [NAME] | 00:20:09 | 00:01:23 | 00:17:33 | 5 | 00:56:18
Spreadsheet: 99462d1298068983-help-using-lookup-for-multiple-positions-in-fantasy-baseball-draft-bb-dft2
Sheet: 2B

Column1 | First name | Last Name | Team | Owner |  | Position | My Team
1 | [NAME] | Cano, | NY-A |  |  | C
2 | Chase | Utley, | PHI |  |  | 1B
3 | Dustin | Pedroia, | BOS |  |  | 2B
4 | [NAME] | Phillips, | CIN |  |  | 3B
5 | [NAME] | Uggla, | ATL |  |  | SS
6 | Ian | Kinsler, | TEX |  |  | OF
7 | [NAME] | Weeks, | MIL |  |  | OF
8 | Kelly | [NAME], | AZ |  |  | OF
9 | Martin | Prado, | ATL |  |  | Util
10 | [NAME] | [NAME], | BAL |  |  | Util
11 | [NAME] | Beckham, | CHI-A |  |  | BN
12 | [NAME] | Aviles, | KC |  |  | BN
13 | Chone | Figgins, | SEA |  |  | BN
14 | [NAME] | Walker, | PIT |  |  | BN
15 | [NAME] | [NAME], | ANA |  |  | SP
16 | [NAME] | Zobrist, | TB |  |  | SP
17 | [NAME] | Eckstein, |  |  |  | SP
18 | Felipe | Lopez, | TB |  |  | SP
19 | Juan | Uribe, | LA |  |  | RP
20 | [NAME] | Sanchez, | SF |  |  | RP
21 | Orlando | Hudson, | SD |  |  | P
22 | [NAME] | Infante, | FLA
23 | [NAME] | [NAME], | COL
24 | Maicer | Izturis, | ANA
25 | Clint | Barmes, | HOU
26 | Skip | Schumaker, | STL
27 | Sean | Rodriguez, | TB
28 | Mark | Ellis, | OAK
29 | Tsuyoshi | Nishioka, | MIN
30 | Blake | DeWitt, | CHI-N
31 | [NAME] | Getz, | KC
32 | [NAME] | Espinosa, | WAS
33 | Scott | Sizemore, | DET
34 | [NAME] | Keppinger, | HOU
35 | [NAME] | Castillo, | NY-N
36 | [NAME] | [NAME], | DET
37 | [NAME] | Hall, | HOU
38 | [NAME] | Carroll, | LA
39 | Adam | [NAME], | SEA
40 | Adam | Rosales, | OAK
41 | [NAME] | Nix, | CLE
42 | [NAME] | [NAME], | CIN
43 | Dustin | Ackley, | SEA
44 | Brett | [NAME], | TOR
45 | Logan | Forsythe, | SD
46 | [NAME] | Kipnis, | CLE
Spreadsheet: 877363d1724176064-increment-data-sample2
Sheet: Sheet2

DATE RECEIVED | DATE INSPECTED | INSP | ITEM | [NAME] | VENDOR | PO/JOB# | QTY | Additional Process Reqd?
2024-08-15 00:00:00 | 2024-08-20 00:00:00 | CT | A050553-018 | Element, 20K | EXACT | PHMR2045 | 15 | Y
2024-08-15 00:00:00 | 2024-08-20 00:00:00 | CT | A620084-0030 | Pressure Adapter/Diaphragm Assy | KEREK | PHCPA2424 | 20 | Y
Spreadsheet: 543911d1508668376-linking-data-without-using-arrays-transpose-linking-data-without-using
Sheet: Sheet7

 |  | Company A |  | Company B |  | Company C |  | Company D
 |  | City 1 | City 2 | City 1 | City 2 | City 1 | City 2 | City 1 | City 2
 | 2017-10-01 00:00:00
 | 2017-10-02 00:00:00
 | 2017-10-03 00:00:00
 | 2017-10-04 00:00:00
 | 2017-10-05 00:00:00
 | 2017-10-06 00:00:00
 | 2017-10-07 00:00:00
 | 2017-10-08 00:00:00
 | 2017-10-09 00:00:00
 | 2017-10-10 00:00:00
Spreadsheet: 853410d1703265217-allow-excel-to-read-a-rounded-number-as-a-whole-number-in-a-table-round-up-error-in-lookup-table-v2-withj-suggested-formula
Sheet: Sheet1

Mathematics |  |  |  |  | School xx
Subject | UK  Years | Result |  |  | Mathematics
Phase 2  Pr imary | 1 | 4 |  |  | Attainment
 | 2 | 2 |  | Phase 2
 | 3 | 4 |  | Phase 3 |  | Good
 | 4 | 3 |  | Phase 4 |  | Weak
 | 5 | 2
 | 6 | 2 |  | Overall |  | Acceptable
Phase 3 Secondary | 7 | 4
 | 8 | 2 |  |  | 1 | Very Weak
 | 9 | 4 |  |  | 2 | Weak
 | 10 | 6 |  |  | 3 | Acceptable
 | 11 | 5 |  |  | 4 | Good
Phase 4 Post 16 | 12 | 3 |  |  | 5 | Very Good
 | 13 | 1 |  |  | 6 | Outstanding
Spreadsheet: b998ff1f-3132-419a-8e3c-f8007d9a4f18
Sheet: Sheet1

IRN | District | County | Awarded | Disbursed | Org Type
43497 | Alliance City | [NAME] | 493586.94 | 37496.65 | Public District
43539 | Barberton City | Summit | 246793.47 | 0 | Public District
43562 | Bedford City | Cuyahoga | 246793.47 | 22428.5 | Public District
47787 | [NAME] | [NAME] | 246793.47 | 25502.05 | Public District
43687 | Bucyrus City | Crawford | 246793.47 | 25000 | Public District
43711 | Canton City | [NAME] | 987173.88 | 173033.94 | Public District
43752 | Cincinnati City | [NAME] | 493586.94 | 73324.85 | Public District
43794 | Cleveland Heights-University Heights City | Cuyahoga | 246793.47 | 19804.31 | Public District
43802 | Columbus City School District | Franklin | 987173.88 | 9236.3 | Public District
43844 | Dayton City | Montgomery | 246793.47 | 16594.21 | Public District
43943 | Elyria City Schools | Lorain | 493586.94 | 96927.85 | Public District
43950 | Euclid City | Cuyahoga | 780380.41 | 111887.61 | Public District
43992 | Fostoria City | Seneca | 493586.94 | 42473.89 | Public District
44024 | Galion City | Crawford | 246793.47 | 35484.79 | Public District
46979 | [NAME] | Franklin | 246793.47 | 13500 | Public District
44222 | Lima City | [NAME] | 493586.94 | 46000.45 | Public District
48777 | Morgan Local | Morgan | 246793.47 | 29427.56 | Public District
45542 | Newcomerstown Exempted Village | Tuscarawas | 246793.47 | 33117.77 | Public District
47365 | Northwest Local | [NAME] | 246793.47 | 30358.75 | Public District
44685 | Ravenna City | Portage | 246793.47 | 48123 | Public District
46078 | Ripley-Union-Lewis-Huntington Local | [NAME] | 493586.94 | 63441 | Public District
44743 | Sandusky City | Erie | 493586.94 | 68031.75 | Public District
47738 | South Central Local | Huron | 246793.47 | 31463.79 | Public District
44800 | South-Western City | Franklin | 246793.47 | 21177.67 | Public District
44818 | Springfield City | [NAME] | 246793.47 | 10000 | Public District
44719 | St Bernard-Elmwood Place City | [NAME] | 246793.47 | 40000 | Public District
633 | Summit Academy Secondary School - Toledo | Lucas | 246793.47 | 43987.65 | Community School
48694 | Trotwood-Madison City | Montgomery | 246793.47 | 0 | Public District
44941 | Urbana City | Champaign | 246793.47 | 0 | Public District
50393 | Vinton County Local | Vinton | 246796.47 | 40935.87 | Public District
46060 | Western Brown Local | [NAME] | 493586.94 | 89468 | Public District
45666 | Windham Exempted Village | Portage | 246793.47 | 40002.48 | Public District
 |  |  | 11886089.56 | 1338230.69
Spreadsheet: 0a7885bb-aad2-459f-a53d-7e560ed729c8
Sheet: WithPerformance

Combined Bidder Activity Summary Report - October 2014  (Projects bid opened from July 2013 to October 2014, as of 11/12/2014)
Bid Month-YR | Engineer's Estimate | [NAME] | Low Bid vs. EE | Avg. Number of Bidders | Number of Projects Bid Opened | No. of  Projects Under 10% of EE | No. of Projects in ±10% of EE | No. of Projects Over 10% of EE | No. of Projects Within 110% of EE | Percent of  Projects Within ±10% of EE
2013-07-13 00:00:00 | 101578652.05 | 102192668.35 |  | 4.857142857 | 14 | 7 | 3 | 4
Aug-13 | 67879300.28 | 61238911.23 |  | 6 | 20 | 9 | 8 | 3
Sept-13 | 204165819.49 | 173258066.06 |  | 6.8846 | 26 | 18 | 5 | 3
Oct-13 | 162182345.53 | 146432319.92 |  | 5.3103 | 29 | 10 | 16 | 3
Nov-13 | 165502932.37 | 144277480.63 |  | 7.467 | 15 | 8 | 6 | 1
2013-12-12 00:00:00 | 124415660.37 | 119060555.57 |  | 6.9231 | 13 | 4 | 6 | 3
Jan-14 | 140813434.82 | 137191609 |  | 7.571428571 | 28 | 13 | 9 | 6
2014-02-14 00:00:00 | 92385807 | 83500057 |  | 6.6 | 27 | 10 | 13 | 4
2014-03-14 00:00:00 | 210853414 | 184251324 |  | 6.4 | 56 | 29 | 23 | 4
2014-04-01 00:00:00 | 231265534 | 205255562 |  | 5.5 | 62 | 31 | 25 | 6
2014-05-01 00:00:00 | 140508630 | 134448039 |  | 4.8 | 57 | 31 | 18 | 8
2014-06-14 00:00:00 | 231614414 | 221901164 |  | 5 | 20 | 5 | 12 | 3
Jul 13 to Jun 14
2014-07-01 00:00:00 | 139737164 | 127414388 |  | 5.6 | 24 | 11 | 12 | 2
Aug-14 | 124065598 | 126398804.1 |  | 4.913043478 | 23 | 8 | 11 | 4
* Sept-14 | 129474741 | 117369440 |  | 7 | 21 | 10 | 9 | 2
2014-10-01 00:00:00 | 448449163 | 407260041 |  | 5.4 | 60 | 26 | 30 | 4
2014-11-01 00:00:00
2014-12-01 00:00:00
2015-01-01 00:00:00
2015-02-01 00:00:00
2015-03-01 00:00:00
2015-04-01 00:00:00
2015-05-01 00:00:00
2015-06-01 00:00:00
Jul 14 - Jun 15
Total
Note: 1) "*", numbers may be different from that in the previous report due to bid rank change(s); 2) Rejected projects are not included in calculations.
Spreadsheet: 704065d1605337933-in-a-summary-sheet-different-ways-sum-up-all-values-as-per-criteria-from-multiple-sheets-sum-up-all-amounts-as-per-different-criterias
Sheet: Jan

Date | Name | Amount
2020-01-01 00:00:00 | ABC | 100
2020-01-02 00:00:00 | BCD | 20
2020-01-01 00:00:00 | ABV | 65
2020-01-01 00:00:00 | ASD | 25
2020-01-01 00:00:00 | ASD | 145
2020-01-02 00:00:00 | ABC | 100
2020-01-02 00:00:00 | BCD | 20
2020-01-02 00:00:00 | ABV | 65
2020-03-03 00:00:00 | ASD | 25
2020-03-03 00:00:00 | ASD | 145
Spreadsheet: 79a4076a-ff4e-4abb-a475-095b68f23ca7
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0002665 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Chatham | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 50060 | 31616 | 00610 | 00625 | 00620 | 00400 | 70300 | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Total [NAME] | Nitrate | pH | Total Dissolved Solids | Total Suspended Solids
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | mg/L | su | mg/L | mg/L
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab
Monthly Limit: |  |  | 28626
Daily Limit:
Sample Frequency: |  |  | [NAME] | 4 x Year | 4 x Year |  | 4 x Year | 4 x Year | 4 x Year | 4 x Year |  | 4 x Year | 4 x Year
Spreadsheet: 167914d1342155754-how-is-grand-total-of-an-average-column-calculated-in-a-pivot-table-average-of-showing-pt-values
Sheet: Pivot

 |  |  |  | <- | Averages of what's being displayed - this is what I require
K1 | (All)
K2 | (All)
K3 | (All)
Row Labels | Average of Result 1 | Average of Result 2 | Average of Result 3
BF2A\15\07 | 20.16 | 10.3 | 0.38
BY1A\39\21 | 20.17000000000001 | 15.8 | 0.4000000000000001
BY1A\40\21 | 20.27999999999999 | 15.8 | 0.4000000000000001
PF1A\15\09 | 16.78 | 8.8 | 0.36
PF1A\15\10 | 17.03 | 8.8 | 0.36
PF1A\15\11 | 17.22 | 8.8 | 0.37
PF1A\15\12 | 17.22 | 13.4 | 0.37
PF1A\15\13 | 17.22 | 8.9 | 0.37
PF1A\15\14 | 17.22 | 9.1 | 0.36
PF1A\15\15 | 17.22 | 9.4 | 0.36
UAB\36\09 | 19.73 | 9.3 | 0.66
UAB\37\09 | 19.4 | 9.1 | 0.65
ULD\22\22 | 14.6 | 9.4 | 0.84
ULD\22\24 | 17 | 9.4 | 0.91
ULD\36\05 | 19.93 | 9.4 | 0.71
(blank)
Spreadsheet: 134440d1325282499-help-formatting-numbers-sales-raffle-spreadsheet
Sheet: Sheet2

 |  |  | 2.236542901471141
 |  |  | -1.530520292939843
 |  |  | -1.122161444756986
 |  |  | 3.731560950460708
 |  |  | 1.430585960017803
 |  |  | -4.592213432469753
 |  |  | -1.643695118999795
 |  |  | -3.748420665420849
 |  |  | -3.307443473103511
 |  |  | 1.332631003261939
 |  |  | 4.817496874195182
 |  |  | 0.5079410716019161
 |  |  | 1.776380322756381
 |  |  | 0.9061040337298643
 |  |  | -1.790764177894646
 |  |  | 3.897498039088427
 |  |  | 3.583076197563217
 |  |  | -0.0781839212813984
 |  |  | -4.494630903131858
 |  |  | -0.432231169806554
 |  |  | -2.625590752449343
 |  |  | -1.661931015092712
 |  |  | 3.01449593222765
 |  |  | -0.1917160049376831
 |  |  | 2.538408690739102
 |  |  | 2.307248852460084
Spreadsheet: 169563d1342952048-problem-with-if-or-within-my-time-sheet-or-perhaps-its-just-too-early-wages
Sheet: August

 |  |  |  |  |  |  |  | 0.3333333333333333 | 30 mins | 0.02083333333333333
DAY | IN | OUT | num | numn |  | Tot | OT | O.T |  | 1.5 Time | Double
Wed | 06:00:00 | 14:30:00
Thu | 06:00:00 | 14:30:00
Fri | 06:00:00 | 14:30:00
Sat | 06:00:00 | 14:30:00
Sun | 06:00:00 | 14:30:00
Mon | 06:00:00 | 14:30:00
Tue | 06:00:00 | 14:30:00
Wed | 06:00:00 | 14:30:00
Thu | 06:00:00 | 14:30:00
Fri | 06:00:00 | 14:30:00
Sat | 06:00:00 | 14:30:00
Sun | 06:00:00 | 14:30:00
Mon | 06:00:00 | 14:30:00
Tue | 06:00:00 | 14:30:00
Wed | 06:00:00 | 14:30:00
Thu | 06:00:00 | 14:30:00
Fri | 06:00:00 | 14:30:00
Sat | 06:00:00 | 14:30:00
Sun | 06:00:00 | 14:30:00
Mon | 06:00:00 | 14:30:00
Tue | 06:00:00 | 14:30:00
Wed | 06:00:00 | 14:30:00
Thu | 06:00:00 | 14:30:00
Fri | 06:00:00 | 14:30:00
Sat | 06:00:00 | 14:30:00
Sun | 06:00:00 | 14:30:00
Mon | 06:00:00 | 14:30:00
Tue | 06:00:00 | 14:30:00
Wed | 06:00:00 | 14:30:00
Thu | 06:00:00 | 14:30:00
Fri | 06:00:00 | 14:30:00
Spreadsheet: 677766d1589500629-having-trouble-getting-a-correct-percentage-in-pivot-chart-sample-workbook
Sheet: Sample Pivot

Campus | (All)
Gender | (All)
ATSI | (All)
 | Column Labels
Values | 2019 | Grand Total
Sum of AOD | 2 | 2
Sum of MH1 | 13 | 13
Sum of MH2 | 6 | 6
Sum of YJ | 15 | 15
Sum of H | 6 | 6
Sum of FD | 4 | 4
Sum of CP | 15 | 15
Sum of SB | 10 | 10
Sum of SA | 6 | 6
Sum of AD | 8 | 8
Sum of PSD | 2 | 2
Sum of YP | 2 | 2
Sum of FV | 0 | 0
Spreadsheet: 861297d1709210145-finding-matches-from-different-sheets-and-gathering-them-in-one-sheet-sample_etaf
Sheet: Full list

Employee # | First Name | Middle Name | Last Name | Work Email | Location | Department | Job Title | Reporting to | Hire Date | Termination Date | Training1 | Training2 |  | Training1 | Training2
1 | [NAME] | [NAME] | [NAME] | [EMAIL] | NY | Dep1 | Title1 | Manager1 | 2023-08-01 00:00:00 |  | Group1 | Completed
2 | [NAME] | Green | [NAME] | [EMAIL] | London | Dep2 | Title2 | Manager2 | 2024-02-05 00:00:00 |  |  | Completed
3 | Gloria | [NAME] | [NAME] | [EMAIL] | Berlin | Dep3 | Title3 | Manager3 | 2023-08-01 00:00:00 | 2023-12-04 00:00:00 |  | Completed
4 | Anette | J. | Steinrot | [EMAIL] | Paris | Dep4 | Title4 | Manager4 | 2023-07-03 00:00:00 |  | Group2
Spreadsheet: 695364d1600175439-multiple-criteria-sumifs-tally-23
Sheet: sheet3

[NAME] |  |  |  |  | Price per Kilo Summary |  |  |  |  |  |  |  |  | Price per Kilo Summary
Species | Presentation | Boxes | Total (Kg) |  | Species | Grade | Presenattion | Boxes | Lowest (Kg) Price | Highest (Kg) Price | [NAME] |  |  | Species | Grade | Presenation | Boxes | Lowest (Kg) Price | Highest (Kg) Price | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HAD | 4 | WF | 5 | 2.9 | 2.9 | 2.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HAD | 4 | GH | 45 | 2.75 | 2.9 | 2.83
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ANF | 4 | GH | 4 | 4 | 4 | 4
Spreadsheet: 849267d1699806136-repeat-a-formula-x-times-dynamic-and-automatic-change-leader
Sheet: Input Sheet

This [NAME] looks far more complex that it actually is, I have colour coded the heading to make it easier to understand.
Green = Pasted/ typed data (no formulas)
Yellow = [NAME] I'm looking to turn into automatic dynamic
Red = Helper columns for column F
Orange = Automatic dynamic
This sheet produces data in the 'File to Save' Sheet which is used by another program to update certain names to a new leader. (In this example moving them to Troy's Team)
Pasted Name List | Pasted Position | Leader For Name List | Typed Name (or Partial Name) | Name in Full From Column A | Details of Typed Names | Already With Troy Helper | Duplicate Below This Row | Duplicate Above This Row | [NAME] | Blank in Column A Helper | Column Blank For 'K2' onwards | Names to Process | Current Group | Move To Troy
[NAME] | Leader |  | [NAME]
[NAME] | Member 1 | [NAME] | [NAME] | [NAME] |  | False |  |  | False | False |  | [NAME] | [NAME] | Troy
[NAME] | Member 2 | [NAME] | [NAME] | Sandy |  | False |  |  | False | False |  | Sandy | Sandy | Troy
Sandy | Leader | Sandy | Jo | Joy |  | False |  |  | False | False |  | Joy | Mark | Troy
Troy | Leader | Troy | [NAME] | Winston |  | False |  |  | False | False |  | Winston | Mark | Troy
[NAME] | Member 1 | Troy | [NAME] | [NAME] |  | False |  |  | False | False |  | [NAME] | [NAME] | Troy
Dwane | Member 2 | Troy | Winston | Winston |  | False |  |  | False | False |  | Winston | Mark | Troy
Shona | Member 3 | Troy | Rachel | #[NAME]! |  | False |  |  | True | False |  |  | #[NAME]! | #[NAME]!
Toni | Member 4 | Troy | [NAME] | [NAME] |  | True |  |  | False | False |  |  | Troy
[NAME] | Leader | [NAME] | [NAME] | [NAME] |  | False |  |  | False | False |  | [NAME] | [NAME] | Troy
Marvin | Member 1 | [NAME] | Rachel | #[NAME]! |  | False |  |  | True | False |  |  | #[NAME]! | #[NAME]!
Mark | Leader | Mark |  |  |  | False |  |  | False | True
Joy | Member 1 | Mark |  |  |  | False |  |  | False | True
Winston | Member 2 | Mark |  |  |  | False |  |  | False | True
Bella-Anne | Leader | Bella-Anne |  |  |  | False |  |  | False | True
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: GF Recon

 | DSA | FY 2010 | FY 2011
 | [NAME] | 2400000 | 3600000
 | IDEA MOE
 | Early Childhood Education | -26109 | -58191
 | RPDP | 7897804
 |  | GOV | LEG |  | GOV | LEG |  | BIENNIAL
 |  | FY 2010 | FY2010 | DIFF | FY 2011 | FY 2011 | DIFF | TOTAL
 | SLOT TAX | 36173569.3266 | 35888197 |  | 36571478.5891926 | 36554830
 | PERM SCHOOL FUND | 14631920 | 13100000 |  | 14924558 | 13100000
 | FEDERAL LEASE REVENUE | 9198446 | 10706000 |  | 9474399 | 10706000
 | REAL PROPERTY TRANS TAX AB 458 |  | 1000000 |  | 0 | 1000000
Spreadsheet: 89996d1289756021-formula-required-to-sum-groups-of-figures-budget-2010-public
Sheet: 11C

 | Opening Balance |  |  |  | Bank |  | Cash |  |  | Deposits | Withdrawals | Income | Expenditure | P/L | Current Balance
 | 564.64
 | 2010-11-01 00:00:00 | LO | CO | Loan from [NAME]
 |  | DO | CO | Alton Towers |  |  | 15
 |  | PE | CO | Petrol |  |  | 15
 |  | DO | CO | Car Park |  |  | 5
 |  | FF | CO | Food @ AT |  |  | 5
 | 2010-11-02 00:00:00 |  |  | None
 | 2010-11-03 00:00:00 |  |  | None
 | 2010-11-04 00:00:00 | O2 | BO | o2 Topup | 15
 |  | VE | BO | [NAME] (£17.63) | 50
 |  | VE | BI | [NAME] |  | 32.37
 |  | VE | BO | Bike Insurance | 63.7
 |  | PE | BO | Petrol (Total @ Fiveways) | 5.37
 | 2010-11-05 00:00:00 | DO | CO | [NAME] |  |  | 5
 |  | WI |  | Withdrawal |  |  |  |  |  |  | 10
 |  | VE | BO | MOT + Repairs | 78.42
 | 2010-11-06 00:00:00 | FF | CO | Sandwich & Hot Chocolate |  |  | 5
 |  | DO | CO | Newspaper |  |  | 0.7
 |  | DO | CO | [NAME] |  |  | 4
 |  | DO | CO | Sparklers |  |  | 5
 |  | FF | BO | 2 Coffees + 2 Wkds - Dog & Partridge | 10.6
 |  | PO | CO | Poker - Cash Game |  |  | 15
 |  | WI |  | Withdrawal |  |  |  |  |  |  | 200
 | 2010-11-07 00:00:00 |  |  | None
 | 2010-11-08 00:00:00 |  |  | None
 | 2010-11-09 00:00:00 | HA | CO | [NAME] |  |  | 29.5
 |  | PO | CO | Poker - Rake |  |  | 2
 |  | PO | CO | [NAME] In |  |  | 10
 |  | PO | CO | Poker Top Up |  |  | 10
 |  | PO | CO | Poker - Cash Game |  |  |  | 45
 |  | IT | BO | iTunes - Cut The Rope + Angry Birds + Barbra Streisand + Trainyard | 4.26
 |  | EL | BO | Eon | 35
 | 2010-11-10 00:00:00 | HA | CO | Haircut |  |  | 16.5
 |  | GR | BO | Tesco Groceries | 63.81
 |  | PO | CO | Poker Registration |  |  | 1
 |  | PO | CO | [NAME] In |  |  | 5
 |  | PO | CO | [NAME] In |  |  | 5
 |  | FF | CO | Coke @ Crown |  |  | 2.2
 |  | FF | CO | Chips & Sausage |  |  | 2.3
 |  | AC | BO | VistaPrint | 4.24
 | 2010-11-11 00:00:00 | WE | CO | Weed |  |  | 20
 |  | FO | CO | Football |  |  | 23
 |  | WE | BO | Lighter | 1.99
 |  | PE | BO | Petrol | 8.6
 |  | AC | BO | VistaPrint | 4.24
 | 2010-11-12 00:00:00 | FF | CO | Mcdonalds |  |  | 2.28
 |  | IT | BO | Wonders of the solar system (hardback) | 14.99
 |  | WE | CO | Bong |  |  | 20
 |  | WE | BO | Grinder | 11.99
 |  | GU | CO | [NAME] |  |  | 45
 |  | DO | CO | [NAME] |  |  | 4
 |  | DO | CO | Cinema |  |  | 7.1
 |  | FF | CO | Tea - Hot Chocolate + Nachos |  |  | 9.9
 | 2010-11-13 00:00:00 | ES | CI | ESA |  |  |  | 193.7
 |  | PO | CO | Poker Crown - Buy In |  |  | 5
 |  | PO | CO | Poker Crown - Rebuy |  |  | 15
 |  | PO | CO | Poker Crown - Add-on |  |  | 10
 |  | FF | CO | Half pint of coke |  |  | 1.2
 | 2010-11-14 00:00:00
Spreadsheet: 297677d1392510087-converting-data-table-into-summary-for-sales-performance-excel-help-please
Sheet: Data Table

Submission Date | Client Name | [NAME] | Status | Loan Amount
2014-01-22 00:00:00 | a | Jake | Approved | 100
2014-01-23 00:00:00 | b | Jake | Declined
2014-01-24 00:00:00 | c | [NAME] | In review
2014-01-25 00:00:00 | d | [NAME] | Funded | 250
2014-01-26 00:00:00 | e | [NAME] | Funded | 390
2014-01-27 00:00:00 | f | [NAME] | Declined
2014-01-28 00:00:00 | g | [NAME] | Approved | 125
2014-01-29 00:00:00 | h | [NAME] | Approved | 150
2014-01-30 00:00:00 | i | [NAME] | Refused | 200
Spreadsheet: 777706d1650558055-serpentine-numbers-in-a-table-formula-serpentine
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10