tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: West Wing- Sun

Hour
Ending
Pacific | West Wing | APS(T) | PNM | WALC(t) | SRP | SRP | From CISO | WALC | SRP | To ISO | Balance
Standard | phys. pos. | PV/WW | Purch | From Mead | Transmission | Purch | STSW | (T) to [NAME] | Sale | ST-SW |  |  | Hour | Total | Total
(PST) |  |  |  | 78 MW | 100 MW |  |  | 78 MW |  |  |  |  | Ending | To PX | From PX
100 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 100 |  |  | -1
200 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 200 |  |  | -1
300 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 300 |  |  | -1
400 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 400 |  |  | -1
500 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 500 |  |  | -1
600 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 600 |  |  | -1
700 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 700 |  |  | -1
800 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 800 |  |  | -1
900 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 900 |  |  | -1
1000 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1000 |  |  | -1
1100 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1100 |  |  | -1
1200 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1200 |  |  | -1
1300 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1300 |  |  | -1
1400 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1400 |  |  | -1
1500 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1500 |  |  | -1
1600 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1600 |  |  | -1
1700 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1700 |  |  | -1
1800 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1800 |  |  | -1
1900 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 1900 |  |  | -1
2000 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 2000 |  |  | -1
2100 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 2100 |  |  | -1
2200 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 2200 |  |  | -1
2300 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 2300 |  |  | -1
2400 |  | 0 |  | 0 | 0 |  |  | 0 |  |  |  |  | 2400 |  |  | -1
 |  |  |  |  |  |  |  |  |  |  |  |  | Totals
Spreadsheet: 043b820a-db5f-4161-8b19-d1b12d8c4399
Sheet: HT17

Team | Tournament | PPB
St. Anselm's | Rider Bowl | 23.47
Dorman B | Wofford Free | 22.84
Dorman A | Wofford Free | 22.39
Ezell-Harding A | Dennis Haskins Open | 22.3
Georgetown Day | Rider Bowl | 21.83
Charter A | Rider Bowl | 19.43
Spartanburg A | Wofford Free | 18.6
Westview | Triton Spring Lower | 18.38
Wissahickon | Rider Bowl | 18.06
Southside A | Wofford Free | 17.41
Seneca | Wofford Free | 16.33
Dan-A-Man | Rider Bowl | 16.02
Charter B | Rider Bowl | 15.44
Station Camp | Dennis Haskins Open | 15.15
Knox West A | Dennis Haskins Open | 14.89
Rossview | Dennis Haskins Open | 14.35
[NAME] | Triton Spring Lower | 13.95
Ezell-Harding B | Dennis Haskins Open | 13.91
Lincoln Co | Dennis Haskins Open | 13.83
Dorman C | Wofford Free | 12.96
TP C | Triton Spring Lower | 12.89
Augusta Christian | Wofford Free | 12.62
Webb A | Dennis Haskins Open | 12.15
RB B | Triton Spring Lower | 12.13
Hardin Valley B | Dennis Haskins Open | 12.12
Hardin Valley A | Dennis Haskins Open | 12.05
Freedom A | Wofford Free | 11.93
[NAME] | Rider Bowl | 11.84
St. Thomas More | Rider Bowl | 11.5
Freedom B | Wofford Free | 11.47
CCA B | Triton Spring Lower | 11.4
Concord | Rider Bowl | 11.22
Knox West B | Dennis Haskins Open | 11.14
White Co | Dennis Haskins Open | 10.71
Mauldin A | Wofford Free | 10.36
[NAME] | Rider Bowl | 10.29
Ezell-Harding C | Dennis Haskins Open | 10.18
RB C | Triton Spring Lower | 10.17
[NAME] A | Dennis Haskins Open | 10
Southside B | Wofford Free | 10
Ezell-Harding D | Dennis Haskins Open | 9.8
[NAME] | Wofford Free | 9.78
[NAME] A | Wofford Free | 9.46
Montgomery | Triton Spring Lower | 9.13
Freedom C | Wofford Free | 8.89
[NAME] | Dennis Haskins Open | 8.67
LJ B | Triton Spring Lower | 8.65
Webb B | Dennis Haskins Open | 8.6
[NAME] A | Dennis Haskins Open | 8.57
CSAS | Dennis Haskins Open | 8.4
[NAME] B | Dennis Haskins Open | 8.18
Ringgold A | Dennis Haskins Open | 8.06
Gibbs A | Dennis Haskins Open | 7.27
NW Whitfield A | Dennis Haskins Open | 7.24
Dorman D | Wofford Free | 7.18
Spartanburg B | Wofford Free | 6.92
Oneida A | Dennis Haskins Open | 6.3
Gibbs B | Dennis Haskins Open | 5.83
[NAME] B | Wofford Free | 5.56
Oneida B | Dennis Haskins Open | 5
Ninety-Six | Wofford Free | 5
[NAME] | Dennis Haskins Open | 3.33
NW Whitfield B | Dennis Haskins Open | 3
Chapman | Wofford Free | 2.86
[NAME] A | Dennis Haskins Open | 2.5
Ringgold B | Dennis Haskins Open | 2.5
Spreadsheet: 8d0b0ffd-905e-48c7-931c-11395a4fe666
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Wines offered in GBP per case of 12 bottles, 24 half-bottles or 6 magnums, unless otherwise indicated. 21 September 2014.  Wines lying in bond at London City Bond. E&O.E.  Prices exclude duty and VAT.  For all enquiries, please contact us at [EMAIL]
Region | Producer | Vintage | Wine | Condition | Cs | Bt | GBP Sell | Per | Size | Units | GBP/bt
[NAME] | - | 2001 | Cantegril | - | 14 | 8 | 130 | CS | 75cl | 176 | 10.83
[NAME] | - | 2009 | Carmes de Rieussec  (2nd wine of Rieussec) | - | 2 | - | 150 | CS | 75cl | 24 | 12.5
[NAME] | - | 2010 | Climens | - | 2 | - | 640 | CS | 75cl | 24 | 53.33
[NAME] | - | 2009 | Climens | - | 1 | - | 580 | CS | 37.5cl | 24 | 24.17
[NAME] | - | 2006 | Climens | - | - | 6 | 330 | CS | 75cl | 6 | 27.5
[NAME] | - | 2005 | Climens | - | 4 | - | 550 | CS | 37.5cl | 96 | 22.92
[NAME] | - | 2001 | Climens | - | 2 | 6 | 2000 | CS | 75cl | 30 | 166.67
[NAME] | - | 1990 | Climens | - | 1 | 10 | 1100 | CS | 75cl | 22 | 91.67
[NAME] | - | 1989 | Climens | - | 1 | - | 820 | CS | 75cl | 12 | 68.33
[NAME] | - | 1988 | Climens | - | 1 | - | 880 | CS | 75cl | 12 | 73.33
[NAME] | - | 2007 | [NAME] | - | 2 | - | 290 | CS | 75cl | 24 | 24.17
[NAME] | - | 2002 | [NAME] | - | - | 6 | 200 | CS | 75cl | 6 | 16.67
[NAME] | - | 2010 | [NAME] | - | - | 6 | 275 | CS | 75cl | 6 | 22.92
[NAME] | - | 2009 | [NAME] | - | 2 | - | 290 | CS | 75cl | 24 | 24.17
[NAME] | - | 2009 | [NAME] | - | 4 | - | 300 | CS | 37.5cl | 96 | 12.5
[NAME] | - | 2005 | [NAME] | - | 2 | - | 230 | CS | 75cl | 24 | 19.17
[NAME] | - | 2010 | [NAME] | - | 6 | - | 220 | CS | 75cl | 72 | 18.33
[NAME] | - | 2009 | [NAME] | - | 3 | - | 220 | CS | 37.5cl | 72 | 9.17
[NAME] | - | 2010 | Guiraud | - | - | 6 | 280 | CS | 75cl | 6 | 23.33
[NAME] | - | 2007 | Malle | - | 4 | - | 230 | CS | 75cl | 48 | 19.17
[NAME] | - | 2009 | [NAME] | - | 2 | - | 240 | CS | 75cl | 24 | 20
[NAME] | - | 2009 | Rieussec | - | 8 | - | 325 | CS | 75cl | 96 | 27.08
[NAME] | - | 2007 | Rieussec | - | 4 | - | 310 | CS | 75cl | 48 | 25.83
[NAME] | - | 2006 | Rieussec | - | 26 | 1 | 310 | CS | 75cl | 313 | 25.83
[NAME] | - | 2005 | Rieussec | - | 5 | - | 340 | CS | 37.5cl | 120 | 14.17
[NAME] | - | 2010 | Suduiraut | - | - | 6 | 390 | CS | 75cl | 6 | 32.5
[NAME] | - | 2007 | Suduiraut | - | 4 | - | 340 | CS | 75cl | 48 | 28.33
[NAME] | - | 2005 | Tour Blanche | - | 4 | - | 320 | CS | 37.5cl | 96 | 13.33
[NAME] | - | 2011 | Yquem | - | - | 6 | 2800 | CS | 75cl | 6 | 233.33
[NAME] | - | 2011 | Yquem | - | - | 12 | 2600 | CS | 37.5cl | 12 | 108.33
[NAME] | - | 2006 | Yquem | - | 4 | - | 1940 | CS | 75cl | 48 | 161.67
[NAME] | - | 2003 | Yquem | - | 1 | - | 1500 | CS | 37.5cl | 24 | 62.5
[NAME] | - | 2001 | Yquem | - | - | 12 | 4600 | CS | 37.5cl | 12 | 191.67
[NAME] | - | 1995 | Yquem | - | 5 | - | 1480 | CS | 75cl | 60 | 123.33
[NAME] | - | 1988 | Yquem | - | 1 | - | 3000 | CS | 75cl | 12 | 250
Spreadsheet: 00ac9c8f-c5e5-4f47-a380-0773b5acb618
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413770V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 5867abbc-029c-4e38-9071-d0424167866c
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
43628651 | 2014-10-18 07:01:12 | ALLIES | 0 | 3 | 5 | 1007284 | Temple58 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43628822 | 2014-10-18 07:24:53 | AXIS | 1 | 5 | 1 | 1007284 | Temple58 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43642782 | 2014-10-19 06:25:35 | ALLIES | 0 | 2 | 5 | 603439 | MickeyScott01 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43642903 | 2014-10-19 06:51:13 | AXIS | 1 | 5 | 4 | 603439 | MickeyScott01 | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43757709 | 2014-10-27 03:29:42 | ALLIES | 1 | 5 | 3 | 1074409 | ATTappman | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43758049 | 2014-10-27 04:03:55 | AXIS | 0 | 3 | 5 | 1074409 | ATTappman | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43813009 | 2014-10-31 03:49:39 | AXIS | 1 | 6 | 3 | 1074409 | ATTappman | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
43813173 | 2014-10-31 04:11:30 | ALLIES | 1 | 6 | 5 | 1074409 | ATTappman | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
43825702 | 2014-11-01 03:11:03 | AXIS | 1 | 6 | 2 | 631697 | JAParker | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
43825803 | 2014-11-01 03:36:02 | ALLIES | 0 | 5 | 6 | 631697 | JAParker | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
Spreadsheet: 764501d1642772395-problem-comparing-differing-numerical-ranges-comparitive-mark-example
Sheet: Sheet1

Group 1 | Group 2 |  |  |  | Comparitive Mark Output
98.84615384615384 | 73.2191390991211 |  |  |  | Group 1 Average | Group 2 Average
91.1651728553137 | 76.42401123046875
98.98305084745763 | 79.15064239501953
97 | 76.14583587646484
97.38562091503267 | 76.14583587646484
98.87640449438203 | 76.0658950805664
98.50523168908819 | 73.71666717529297
100 | 79.55745697021484
93.65384615384616 | 75.625
100 | 77.60948944091797
97.74266365688487 | 77.99458312988281
98.37837837837837 | 76.55228424072266
100 | 80.43553161621094
98.52941176470588 | 76.73228454589844
99.70282317979198 | 79.85133361816406
93.24522760646109 | 74.96975708007812
89.95363214837712 | 75.55640411376953
96.35416666666667 | 75.7622299194336
95.74468085106383 | 80.1224136352539
100 | 78.1505355834961
99.75579975579976 | 74.439453125
Spreadsheet: 862012d1709817341-populate-new-or-dropped-data-excel1
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 2
Month | Product ID | Product Name | Branch Name |  |  | Month | Product ID | Product Name | Branch Name | Status
Dec | 123456 | Product1 | Branch 1 |  |  | Jan | 123460 | Product5 | Branch 5 | [NAME]
Dec | 123457 | Product2 | Branch 2 |  |  | Jan | 123461 | Product6 | Branch 5 | New
Dec | 123458 | Product3 | Branch 3 |  |  | Feb | 123462 | Product7 | Branch 5 | New
Dec | 123459 | Product4 | Branch 4 |  |  | Mar | 123462 | Product8 | Branch 5 | New
Dec | 123460 | Product5 | Branch 5 |  |  | Apr | 123457 | Product2 | Branch 2 | [NAME]
Dec | 123456 | Product1 | Branch 1
Jan | 123457 | Product2 | Branch 2
Jan | 123458 | Product3 | Branch 3
Jan | 123459 | Product4 | Branch 4
Jan | 123461 | Product6 | Branch 5
Feb | 123457 | Product2 | Branch 2
Feb | 123458 | Product3 | Branch 3
Feb | 123459 | Product4 | Branch 4
Feb | 123462 | Product7 | Branch 5
Mar | 123457 | Product2 | Branch 2
Mar | 123458 | Product3 | Branch 3
Mar | 123459 | Product4 | Branch 4
Mar | 123462 | Product7 | Branch 5
Mar | 123462 | Product8 | Branch 5
Apr | 123458 | Product3 | Branch 3
Apr | 123459 | Product4 | Branch 4
Apr | 123462 | Product7 | Branch 5
Apr | 123462 | Product8 | Branch 5
Spreadsheet: 837230d1689950050-show-different-sheets-on-one-page-according-to-dropdown-selection-test_workbook
Sheet: June

Month | CW | First Name | Last Name | Hours driven | hours parked (in h) | Activities | Comments | Comments 2
June
June | 23 | [NAME] | Smith | 25
 |  | [NAME] | [NAME] | 32 | 34
 |  | [NAME] | [NAME] | 40 |  |  | Test
 |  | [NAME] | Bauer | 27
 |  | [NAME] | Parker | 32
June | 24 | [NAME] | Smith | 7 |  | Accident
 |  | [NAME] | [NAME] | 32
 |  | [NAME] | [NAME] | 40 | 7 |  | Test2
 |  | [NAME] | Bauer | 52
 |  | [NAME] | Parker | 38.75
June | 25 | [NAME] | Smith | 16
 |  | [NAME] | [NAME] | 40 | 12
 |  | [NAME] | [NAME] | 16 |  |  |  | ill
 |  | [NAME] | Bauer | 40
 |  | [NAME] | Parker | 0
June | 26 | [NAME] | Smith | 27.25 | 4 | Sick
 |  | [NAME] | [NAME] | 32 | 1 | Nothing |  | Holiday
 |  | [NAME] | [NAME] | 0
 |  | [NAME] | Bauer | 32
 |  | [NAME] | Parker | 40 | 12 | Service
June | 27 | [NAME] | Smith | 12 | 1 | Service |  | Workshop
 |  | [NAME] | [NAME] | 12
 |  | [NAME] | [NAME] | 12
 |  | [NAME] | Bauer | 54
 |  | [NAME] | Parker | 16 | 16 | Service
Total June |  | [NAME] | Smith
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | Bauer
 |  | [NAME] | Parker
Spreadsheet: 206526d1358206440-more-than-your-basic-if-statement-pool-2013
Sheet: Sheet1

2013
 |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 | January | February | March | April | May | June | July | August | September | October | November | December |  | Totals
 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
2013 Actual
A | 1800000
B | 70000
C | 13000 | 1000
Total
2013 Budget
A | 2000000
B | 75000
C | 15000 | 5000
Total
Incentive Calculation:
Spreadsheet: 218049d1362319321-formula-that-factors-odds-stupid-little-calculator-oeldere-
Sheet: Sheet1

Positions | Submittals |  | Calc | Should Be
1 | 0 |  |  | 1
1 | 1 |  |  | 0.5
3 | 1 |  |  | 3
1 | 3 |  |  | 0.3
5 | 5 |  |  | 0.5
10 | 5 |  |  | 2
Spreadsheet: 806948d1669690261-distribution-of-data-base-on-dates-with-mutiple-duplicates-collection-vs-deposites-excelforum-file
Sheet: COLLECTION

POST DATE |  | DB LC
2017-03-01 00:00:00 |  | 10211.5
2017-04-01 00:00:00 |  | 23747
2017-04-01 00:00:00 |  | 10331.16
2017-05-01 00:00:00 |  | 19255
2017-05-01 00:00:00 |  | 5268.81
2017-06-01 00:00:00 |  | 30453
2017-06-01 00:00:00 |  | 9366.52
2017-09-01 00:00:00 |  | 32036.2
2017-09-01 00:00:00 |  | 4650
2017-09-01 00:00:00 |  | 14979
2017-09-01 00:00:00 |  | 5782.05
2017-10-01 00:00:00 |  | 13576
2017-11-01 00:00:00 |  | 5787
2017-11-01 00:00:00 |  | 9118
2017-11-01 00:00:00 |  | 5598.97
2017-12-01 00:00:00 |  | 18881
2017-12-01 00:00:00 |  | 12020
2017-12-01 00:00:00 |  | 5045.29
Spreadsheet: dutch_quigley__9447__customer17
Sheet: Sheet1

 |  | MMBtu per Month
2001-11-01 00:00:00 |  | 12700
2001-12-02 00:00:00 |  | 17300
2002-01-01 00:00:00 |  | 19000
2002-02-01 00:00:00 |  | 17000
2002-03-01 00:00:00 |  | 5300
2002-04-01 00:00:00 |  | 4000
2002-05-01 00:00:00 |  | 3200
2002-06-01 00:00:00 |  | 2570
2002-07-01 00:00:00 |  | 2730
2002-08-01 00:00:00 |  | 2240
2002-09-01 00:00:00 |  | 2475
2002-10-01 00:00:00 |  | 3800
Total:
Spreadsheet: 65754d1266426755-changing-horizontal-data-to-be-shown-vertically-book1-1-
Sheet: Sheet2

 |  | Q1 | Q2 | Q3 | Q4
 | 2008 | 5 | 10 | 2 | 3
 | 2009 | 6 | 8 | 12 | 14
 | 2010 | 3 | 5 | 2 | 9
 | 2008 Q1 | 2008 Q2 | 2008 Q3 | 2008 Q4 | 2009 Q1 | 2009 Q2 | 2009 Q3 | 2009 Q4 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 Q4
 | 10 | 2 | 3 | 5 | 8 | 12 | 14 | 6 | 5 | 2 | 9 | 3
For example:
 |  | Q1 | Q2 | Q3 | Q4
[NAME] | 2008 | 5 | 10 | 2 | 3
[NAME] | 2009 | 6 | 8 | 12 | 14
[NAME] | 2010 | 3 | 5 | 2 | 9
[NAME] | 2008 | 2 | 3 | 4 | 5
[NAME] | 2009 | 10 | 11 | 1 | 0
[NAME] | 2010 | 7 | 8 | 9 | 6
[NAME] | 2008 | 5 | 10 | 2 | 3
[NAME] | 2009 | 6 | 8 | 12 | 14
[NAME] | 2010 | 3 | 5 | 2 | 9
Betty | 2008 | 2 | 3 | 4 | 5
Betty | 2009 | 10 | 11 | 1 | 0
Betty | 2010 | 7 | 8 | 9 | 6
Below is the information I have right now in my spreadsheet.  I need to the formula to look at the information in the above example and pull it down to the correct corresponding cell.
 | 2008 Q1 | 2008 Q2 | 2008 Q3 | 2008 Q4 | 2009 Q1 | 2009 Q2 | 2009 Q3 | 2009 Q4 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 Q4
[NAME]
[NAME]
[NAME]
Betty
Spreadsheet: 297544d1392436994-how-can-we-create-a-search-engine-where-we-can-have-a-cell-no-containing-searched-value-advanced-filter-using-like-criteria
Sheet: Sheet1

SEARCH | jo |  |  | DATE | NAME | [NAME]
COUNT
DATE | NAME | [NAME]
2014-01-28 00:00:00 | [NAME] | [NAME] |  |  |  |  |  | HI,
 | [NAME] ferrell | [NAME]
2014-01-28 00:00:00 | [NAME] | [EMAIL]
 | [NAME] | [EMAIL] |  |  |  |  |  | I've used an Advanced Filter on your data
 | [NAME] | [NAME]
 | [NAME] | [EMAIL]
 | [NAME] | [EMAIL]
 | Nathan tanner | [EMAIL]
 | [NAME] jones | [EMAIL] |  |  |  |  |  | Click in F2 and G2 to see the exact formula.
 | [NAME] hales | [EMAIL]
 | [NAME] | [EMAIL]
 | Santos castillo rodriguez | [NAME]
 | Elnur gasimov | [EMAIL]
2014-01-28 00:00:00 | [NAME] | [EMAIL]
 |  |  |  |  |  |  |  | You will need to do an Advanced Filter of the data from A3 down to C 1000 (last row)
 |  |  |  |  |  |  |  | You will need to make your criteria range E1 to G3
 |  |  |  |  |  |  |  | Clear the Advanced filter after you are done.
Spreadsheet: 872386d1718789223-sort-and-transpose-paradiser-sort-and-transpose-aligw
Sheet: Sheet2

Date | Particulars | Voucher Type | Entry No. | Ref. No. | ID | Value | Gross | Local VDS |  |  |  |  | USD
2023-08-18 00:00:00 | Kaline Trading Company Pvt.Ltd | Cont | JVN00203 | [NAME] | 609543911 |  | 1351.76 | 155.51 | Repair & Maintance-Electricals | 1196.25
2023-08-18 00:00:00 | Mata Hardware | Cont | [NAME] | Ma-2 | 300069242 |  | 776.83 | 89.37 | Repair & Maintenance Building | 687.46
2023-08-18 00:00:00 | Phonex Machinery & Tools | Cont | [NAME] | Ma-5 | 104224739 |  | 1988.8 | 228.8 | Combule | 1760
2023-08-20 00:00:00 | Elastics Lights & Electric Centre | Cont | JVN00211 | Ma-9 | 301647984 |  | 1887.1 | 217.1 | Repair & Maintance-Electricals | 1670
2023-08-20 00:00:00 | Mother dairy | Cont | JVN00212 | Ma-10 | 302009099 |  | 5190.02 | 597.08 | Combule | 4592.94
2023-08-20 00:00:00 | [NAME] | Cont | JVN00213 | Ma-11 | 300072334 |  | 1074.63 | 123.63 | Combule | 951
2023-08-20 00:00:00 | Nividea | Cont | [NAME] | Ma-12 | 305501703 |  | 10341.76 | 1189.76 | Repair and Maintenance-Plant and [NAME] | 9152
2023-08-18 00:00:00 | Myslef Freight Services Pvt Ltd | Cont | JVN00301 | [NAME] | [PHONE] |  | 586.22 | 67.44 | MBL MC 003ILUI230803002 | 518.78 | Jamal MC 57132 | 551
2023-08-18 00:00:00 | [NAME] | Cont | JVN00331** | Ma-114 | 609544808 |  | 52418.38 | 6111.56 | Freight [NAME] | 47012 | USD Payable-Int. @1.5% |  | -705.18
 | Kaline Trading Company Pvt.Ltd | Cont | JVN00203 | [NAME] | 609543911 | 0 | 1351.76 | 155.51 | Repair & Maintance-Electricals | 1196.25
45156 | Mata Hardware | Cont | [NAME] | Ma-2 | 300069242 | 0 | 776.83 | 89.37 | Repair & Maintenance Building |  | -687.46
45156 | Phonex Machinery & Tools | Cont | [NAME] | Ma-5 | 104224739 | 0 | 1988.8 | 228.8 | Combule | 1760
45158 | Elastics Lights & Electric Centre | Cont | JVN00211 | Ma-9 | 301647984 | 0 | 1887.1 | 217.1 | Repair & Maintance-Electricals | 1670
45158 | Mother dairy | Cont | JVN00212 | Ma-10 | 302009099 | 0 | 5190.02 | 597.08 | Combule | 4592.94
45158 | [NAME] | Cont | JVN00213 | Ma-11 | 300072334 | 0 | 1074.63 | 123.63 | Combule | 951
45158 | Nividea | Cont | [NAME] | Ma-12 | 305501703 | 0 | 10341.76 | 1189.76 | Repair and Maintenance-Plant and [NAME] | 9152
45156 | Myslef Freight Services Pvt Ltd | Cont | JVN00301 | [NAME] | [PHONE] | 0 | 586.22 | 67.44 | MBL MC 003ILUI230803002 | 518.78 |  | Jamal MC 57132 | 551
45156 | [NAME] | Cont | JVN00331** | Ma-114 | 609544808 | 0 | 52418.38 | 6111.56 | Freight [NAME] | 47012 |  | USD Payable-Int. @1.5% |  | -705.18
Spreadsheet: 768059d1644821230-tables-referencing-main-table-cant-use-sort-tabels
Sheet: UPOGIBANJE

 | UPOGIBANJE
 |  |  |  |  |  | STRANKA:
 |  |  |  |  |  | Risba št.: |  |  |  |  |  |  |  |  |  |  |  | KOSOV:
 |  |  |  |  |  | Ime : |  |  | DELNO IZREZANE KOSE VPIŠI PRI SKICI
IME | POZ. | DEB. | ŠIRINA | DOLŽINA | KOS. | SKUPAJ KOSOV | Material | OPOMBA | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | KONČANO/IME | DATUM | LIST
Spreadsheet: john_lavorato__16470__John Lavorato Transfer Info and Summary - 3
Sheet: Sheet1

Summary of Payments made to [NAME]
Reconciliation for Invoicing and Payroll Purposes
Transferred to Houston April 16th but remained on Canada Payroll until June 15th.
April 16-30th |  | Regular Pay | 12122.5 | paid by auto deposit
 |  | Add'l @ 21% | 2600.85
 |  | Comm/Serv All | 262.5
 |  | TOTAL:
 |  | Net Pay: | 7713.52 | lower than May 1-15th due to parking tben
 |  | Expense Payment: | 3095.37 | adjustment done at year end
 |  | Total Deposit:
May 1-15th |  | Regular Pay | 12122.5 | paid by auto deposit
 |  | Add'l @ 21% | 2600.85
 |  | Comm/Serv All | 262.5
 |  | TOTAL:
 |  | Net Pay: | 7795.37 | adjusted due to removal of parking tben
May 16-31th |  | Regular Pay | 12122.5 | paid by auto deposit
 |  | Add'l @ 21% | 2600.85
 |  | Comm/Serv All | 262.5
 |  | TOTAL:
 |  | Net Pay: | 7795.37
 |  | Expense Payment: | 9357.47
 |  | Total Deposit:
June 14th |  | Vacation Pay | 12308.56 | paid by auto deposit
 |  | Net Pay: | 7329.23
June 1-15th |  | Regular | 12122.5
 |  | Add'l @ 21% | 2600.85
 |  | Comm/Serv All | 262.5
 |  | TOTAL: | 14985.85
 |  | NET: | 7823 | paid by manual cheque
 |  |  |  | deposited by [NAME] on June 14th
 |  |  |  | $27.63 higher due to removal of AHC and Life tbens
Sign-On Payment |  | USD | 100000 | f/x rate of: | 1.4978
June 1st |  | CAD
 |  | less taxes: | -65903.2
 |  | NET:
 |  | converted to USD: |  | paid by manual cheque
June 2nd |  | USD | 21000 | f/x rate of: | 1.4978
 |  | CAD
 |  | less taxes: | -13839.67
 |  | NET:
 |  | converted to USD: |  | paid by manual cheque
Retroactive Payment re: Sign On
US Agreement: |  |  | per pay period: |  | 12500
 |  |  | f/x rate: |  | 1.4978
 |  |  | total per pay:
 |  |  | 4 Pay periods owing:
 |  |  | plus 21% gross up:
 |  |  | plus comm/serv all
 |  |  | TOTAL OWING:
Total paid for regular salary (Apr 16-June 15): |  |  |  |  | -59943.4
Retroactive Payment made on June 14th: |  |  |  |  | -14296.6
:this was done by manual cheque and deposited manually June 14th
TOTAL PAYMENT OWING RE: SIGN-ON AGREEMENT:
tax rate: |  |  |  |  | 0.44 | paid by manual cheque
less tax: |  |  |  |  |  | deposited to TD account
NET PAYMENT: |  |  |  |  |  | on June 20th