tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: bddad603-d836-4a65-b9df-dce6ccde43f9
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
43038769 | 2014-09-06 04:52:53 | ALLIES | 0 | 3 | 6 | 631697 | JAParker | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43038942 | 2014-09-06 05:19:05 | AXIS | 0 | 5 | 6 | 631697 | JAParker | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43049039 | 2014-09-06 22:34:19 | AXIS | 1 | 6 | 4 | 20796 | Titanos | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43049521 | 2014-09-06 22:52:52 | ALLIES | 0 | 4 | 6 | 20796 | Titanos | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43059245 | 2014-09-07 15:57:41 | AXIS | 1 | 6 | 2 | 242664 | Nygaard | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43059812 | 2014-09-07 16:29:34 | ALLIES | 0 | 5 | 6 | 242664 | Nygaard | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43061332 | 2014-09-07 18:44:46 | AXIS | 1 | 6 | 1 | 1240009 | Yossarian44 | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
43061961 | 2014-09-07 19:22:52 | ALLIES | 0 | 3 | 6 | 1240009 | Yossarian44 | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
Spreadsheet: 34792d1232132629-percent-increase-issues-percent-rent-increase
Sheet: Rent

Square feet | 1000
Base Rent | 21.5
Bumps | 0.03
 |  | Manual Rounding
 | Fixed | Calculator | Calculator |  | Using |  | Using |  | Using |  | Using
Year | Bump | 3 Decimal | 2 Decimal | <-- Rent | Fixed | <-- Rent | No Rounding | <-- Rent | Roundup 2 | <-- Rent | Roundup 3 | <-- Rent
1 | 0.03 | 21.5 | 21.5 | 21500 | 21.50 | 21500 | 21.5 | 21500 | 21.5 | 21500 | 21.5 | 21500
2 | 0.03 | 22.145 | 22.14 | 22140 | 22.15 | 22150 | 22.145 | 22145 | 22.15 | 22150 | 22.145 | 22145
3 | 0.03 | 22.814 | 22.8 | 22800 | 22.81 | 22810 | 22.80935 | 22809.35 | 22.81 | 22810 | 22.81 | 22810
4 | 0.03 | 23.494 | 23.48 | 23480 | 23.49 | 23490 | 23.4936305 | 23493.6305 | 23.5 | 23500 | 23.494 | 23494
5 | 0.03 | 24.194 | 24.18 | 24180 | 24.19 | 24190 | 24.198439415 | 24198.439415 | 24.2 | 24200 | 24.199 | 24199
6 | 0.03 | 24.915 | 24.9 | 24900 | 24.92 | 24920 | 24.92439259745 | 24924.39259745 | 24.93 | 24930 | 24.925 | 24925
7 | 0.03 | 25.667 | 25.64 | 25640 | 25.67 | 25670 | 25.6721243753735 | 25672.1243753735 | 25.68 | 25680 | 25.673 | 25673
8 | 0.03 | 26.44 | 26.4 | 26400 | 26.44 | 26440 | 26.44228810663471 | 26442.28810663471 | 26.45 | 26450 | 26.443 | 26443
9 | 0.03 | 27.233 | 27.19 | 27190 | 27.23 | 27230 | 27.23555674983375 | 27235.55674983375 | 27.24 | 27240 | 27.236 | 27236
10 | 0.03 | 28.046 | 28 | 28000 | 28.05 | 28050 | 28.05262345232876 | 28052.62345232876 | 28.06 | 28060 | 28.053 | 28053
11 | 0.03 | 28.891 | 28.84 | 28840 | 28.89 | 28890 | 28.89420215589862 | 28894.20215589862 | 28.9 | 28900 | 28.895 | 28895
12 | 0.03 | 29.756 | 29.7 | 29700 | 29.76 | 29760 | 29.76102822057558 | 29761.02822057558 | 29.77 | 29770 | 29.762 | 29762
13 | 0.03 | 30.652 | 30.59 | 30590 | 30.65 | 30650 | 30.65385906719285 | 30653.85906719285 | 30.66 | 30660 | 30.654 | 30654
14 | 0.03 | 31.569 | 31.5 | 31500 | 31.57 | 31570 | 31.57347483920864 | 31573.47483920864 | 31.58 | 31580 | 31.574 | 31574
15 | 0.03 | 32.517 | 32.44 | 32440 | 32.52 | 32520 | 32.52067908438489 | 32520.67908438489 | 32.53 | 32530 | 32.521 | 32521
 |  |  |  | 399300 |  | 399840 |  | 399876.6485638813 |  | 399960 |  | 399884
Spreadsheet: 841267d1693466490-if-partial-match-between-2-cells-then-return-true-partialmatch-formula
Sheet: Sheet1

 | PM A | PM B | CHECK PM | Desired Result in column D
 | [NAME] |  |  | False
 | Attila S P M | CHC.ATTILA |  | True
 | [NAME] | CHC.DARREN |  | True
 | [NAME] | CHC.DARREN |  | False
 |  | CHC.JACK |  | False
Spreadsheet: darrell_schoolcraft__7470__MARKET2001
Sheet: JUNE01

 |  |  |  | PERCENT
POI | SCHEDULED | ACTUAL | DEVIATION | [NAME]
71374 | 11780 | 12106
71393 | 3518 | 3558
71461 | 11888 | 12004
71463 | 3617 | 3707
71464 | 7300 | 9326
71465 | 5845 | 6065
71466 | 4812 | 5086
TOTAL
Spreadsheet: 820343d1678041323-running-balance-of-two-columns-using-lambda-functions-book1
Sheet: Sheet1

 |  |  | Out | In
 |  |  | 100 | 42
 |  |  | 95 | 97 | 56
 |  |  | 74 | 77 | 53
 |  |  | 10 | 84 | -21
 |  |  | 145 | 38 | 86
 |  |  | 35 | 86 | 35
 |  |  | 20 | 7 | 48
 |  |  | 79 | 70 | 57
 |  |  | 60 | 12 | 105
 |  |  | 48 | 86 | 67
 |  |  | 31 | 72 | 26
 |  |  | 48 | 8 | 66
 |  |  | 62 | 74 | 54
 |  |  | 7 | 48 | 13
Spreadsheet: 755644d1637004227-using-nested-if-and-or-statements-and-maybe-indirect-waitlist-therapist-list
Sheet: Master

OTs | PTs | Speech | Nutrition |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
Anais | Alexa | [NAME] | [NAME] |  | 07:30:00
[NAME] | Britany | [NAME] |  |  | 08:15:00 |  | "=IF(and(OR(Tanya!B2="weekly",Tanya!B2="e/o week"),Tanya!A1, IF(OR(Anais!B2="weekly",Anais!B2="e/o week"),Anais!A1,"")))"
[NAME] | Carol | [NAME] |  |  | 09:00:00
Ellie | [NAME] | [NAME] |  |  | 09:45:00
Holly |  | Joy |  |  | 10:30:00
Jade |  | Leah |  |  | 11:15:00
[NAME] |  | [NAME] |  |  | 12:00:00
[NAME] |  |  |  |  | 01:00:00
[NAME] |  |  |  |  | 01:45:00
Tanya |  |  |  |  | 02:30:00
 |  |  |  |  | 03:15:00
 |  |  |  |  | 04:00:00
 |  |  |  |  | 04:45:00
 |  |  |  |  | 05:30:00
Spreadsheet: 53385d1253269221-find-the-difference-between-date-and-time-date
Sheet: Sheet1

Open Date | First Response Date
09/01/2008, 2:28 PM | 11/01/2008,9:29 PM
11/01/2008, 9:15:00 AM | 11/01/2008,  9:31:00 AM
14/01/2008, 1:38 PM | 14/01/2008, 4:06 PM |  |  | #N/A
15/01/2008, 1:00 PM | 16/01/2008, 4:31 AM
16/01/2008, 11:03 AM | 17/01/2008, 12:01 AM
16/01/2008, 10:40 AM | 16/01/2008, 10:42 AM
16/01/2008, 11:02 AM | 16/01/2008, 11:12 AM
18/01/2008, 3:13 PM | 19/01/2008, 4:38 AM
22/01/2008, 7:22 PM | 23/01/2008, 10:54 AM
24/01/2008, 4:39 PM | 24/01/2008, 5:09 PM
24/01/2008, 2:09 PM | 24/01/2008, 4:16 PM
24/01/2008, 10:00 AM | 24/01/2008, 11:04 AM
25/01/2008, 10:15 PM | 25/01/2008, 10:36 PM
25/01/2008, 10:13 AM | 25/01/2008, 10:36 PM
29/01/2008, 3:04 PM | 29/01/2008, 7:52 PM
29/01/2008, 3:49 PM | 30/01/2008, 3:41 PM
Spreadsheet: 874188d1720745373-conditional-formatting-cell-not-copy-properly-absolute-vs-relative-cell-reference-cond-format-issue
Sheet: New

Employee: | [NAME] | [NAME] |  | Training Requirement
Employee Level: | P3 | P6 |  | P3 | P4 | P5 | P6
Required Proficiency Level in Welding: | 2 | 2 |  | 1 | 2 | 3 | 4
Required Proficiency in Machining: | 2 | 2 |  | 1 | 2 | 3 | 4
Summary of Problem:
[NAME] (cell B1) employee level is P3 (cell B2)
As a Level P3 (cell B2), [NAME] required proficiency in Welding is a Level 1 (cell E3)
I have applied Conditional Formatting to cell B3 that works properly… if [NAME]'s proficiency (cell B3) meets or exceeds the requirement (cell e3), then the cell turns green; otherwise it is red (does not meet the requirement)
My problem:  When I copy my formula (=B3>=HLOOKUP(B2,$E$2:$H$100,ROW()-1,FALSE) to other cells, the formula does not change… both "B3" and "b2" remain the same - I need them to update depending on the cell (e.g. the formula in Cell C2 should be =c3>=HLOOKUP(c2,$E$2:$H$100,ROW()-1,FALSE)
Can you help?  Thank you!!!
Spreadsheet: 2d03c69f-5869-4c2a-b58c-e304f05aa5cf
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 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Wholesale Trade: Sales and Inventories
 |  | 42: Total [NAME], Except Manufacturers' Sales Branches and Offices: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2013
 |  | Data Extracted on: March 8, 2014 (6:13 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 138830 | 132921 | 150672 | 146927 | 141749 | 150869 | 150768 | 147079 | 152030 | 158307 | 145676 | 151302
1993 | 140824 | 138267 | 159749 | 154677 | 153693 | 158043 | 152798 | 159014 | 158768 | 160576 | 156357 | 155449
1994 | 143826 | 143069 | 171413 | 157193 | 163090 | 168454 | 157254 | 177898 | 172066 | 176341 | 171870 | 172425
1995 | 165397 | 161211 | 186778 | 170025 | 185818 | 186564 | 172384 | 191076 | 181621 | 193246 | 184672 | 180188
1996 | 178477 | 176150 | 189303 | 189906 | 195454 | 185356 | 193212 | 196149 | 190873 | 209454 | 189016 | 190993
1997 | 186983 | 181571 | 200205 | 198723 | 200357 | 199810 | 200632 | 195457 | 206341 | 215636 | 188397 | 203733
1998 | 187750 | 183337 | 211184 | 204583 | 198874 | 210701 | 204982 | 199128 | 207425 | 212915 | 196656 | 209585
1999 | 184434 | 188602 | 225471 | 212372 | 211738 | 226910 | 215120 | 223078 | 226580 | 226868 | 225903 | 232083
2000 | 208053 | 218632 | 248659 | 222637 | 243460 | 247509 | 226260 | 246918 | 236862 | 248451 | 236370 | 230743
2001 | 229917 | 217231 | 245078 | 229085 | 244303 | 234330 | 228826 | 242911 | 223722 | 243615 | 227250 | 218884
2002 | 220173 | 210596 | 234089 | 237757 | 244150 | 234015 | 241943 | 245497 | 237792 | 255957 | 235200 | 238359
2003 | 235174 | 223885 | 251546 | 246386 | 244130 | 248362 | 252090 | 245444 | 255103 | 270656 | 240271 | 263198
2004 | 242352 | 244228 | 293553 | 277602 | 268938 | 286906 | 272669 | 285219 | 285668 | 286559 | 286381 | 295045
2005 | 266359 | 267299 | 315635 | 295367 | 299864 | 311151 | 289152 | 321789 | 319033 | 320282 | 310566 | 312826
2006 | 298102 | 289656 | 343521 | 311503 | 341292 | 346421 | 319057 | 353369 | 329286 | 342856 | 327941 | 323500
2007 | 319799 | 303872 | 355022 | 342331 | 364874 | 358504 | 345511 | 370222 | 343925 | 384891 | 364601 | 348237
2008 | 359515 | 347020 | 377426 | 389109 | 395499 | 405983 | 403310 | 385984 | 385870 | 382213 | 307241 | 320578
2009 | 286965 | 277083 | 310080 | 304921 | 299644 | 322612 | 315333 | 310779 | 321656 | 329795 | 314202 | 332953
2010 | 301654 | 299905 | 363792 | 352350 | 341324 | 361275 | 345270 | 358057 | 357794 | 363074 | 363972 | 372988
2011 | 350190 | 339512 | 417668 | 391446 | 398281 | 409712 | 379345 | 417407 | 403021 | 402033 | 394328 | 399033
2012 | 381593 | 381742 | 429221 | 413660 | 430742 | 409907 | 397833 | 423533 | 396139 | 434531 | 415466 | 403232
2013 | 404321 | 379756 | 422920 | 430308 | 447367 | 420336 | 431139 | 436021 | 422582 | 462357 | 426631 | 440961
Spreadsheet: 118823d1314033991-index-match-more-then-one-value-log
Sheet: 1

[NAME] |  | Phil/Darwin |  | Darrel/Metalcare |  | Shawn/Noella |  | [NAME] |  | 2011-08-20 00:00:00
Construction Complete |  | Hydro Prep |  | QC/Metalcare Hydro Release Date |  | NDE Release Dates |  | Sent to Suncor
Verified Construction Complete | 2011-08-21 00:00:00 | Hydro prep | 2011-08-21 00:00:00 | [NAME] for Hydro | 2011-08-20 00:00:00 | Hydro to Josh/James/NDE | 2011-08-20 00:00:00 | Josh/James to Suncor | 2011-08-08 00:00:00
Row Labels |  | Row Labels |  | Row Labels |  | Row Labels |  | Row Labels
64-007-NG-HT-002 |  | 56-001-N-HT-001 |  | 64-005-FG-HT-002 |  | 64-028-BD-VT-002 |  | 64-028-CW-VT-001
64-016-MC-HT-003 |  | Grand Total |  | Grand Total |  | Grand Total |  | Grand Total
64-227-K-HT-005
Grand Total
Spreadsheet: 9efb8742-aef2-48f2-87cf-00e5805400cc
Sheet: Sheet1

Betreft verslagjaar | ALGEMENE GEGEVENS
2011
Hoofdverz. Gebied
Statutaire [NAME]
Dossiernummer [NAME]
Station Call
Correspondentieadres
[NAME]. PC
Corr. Plaats
Vestigingsadres
Vest. PC
Vest. Plaats
Vest. Provincie
Vest. Telefoon
Vest. Fax
Vest. E-mailadres
Website instelling
[NAME]
Voorz. Telefoon
[NAME]
Secr. Telefoon
Penningmeester
[NAME]. Telefoon
Contact [NAME]
Contact Telefoon
Contact E-mailadres
Overige
Spreadsheet: 692325d1598280168-vlookup-formula-for-stock-control-ef-4015-components-register-lece-
Sheet: EF 4015 register

Components | Product | Component Lot Number | Released from production | Components in Stock | [NAME]
Component 1 | Product 1 | 1001 | YES | formula here should say AVAILABLE'
Component 2 | Product 1 | 1002 | YES
Component 3 | Product 1 | 1003 | YES
Component 4 | Product 1 | 1004 | YES | formula here should say NOT AVAILABLE'
Component 5 | Product 2 | 1005 | NO | formula here should say NOT AVAILABLE'
Component 6 | Product 2 | 1006 | NO
Component 7 | Product 2 | 1007 | NO
Spreadsheet: 181463d1348051777-calculate-time-difference-time-issue
Sheet: Sheet1

Date/Time Logged | Date/Time Resolved | Time to Resolve HH:MM:SS | Comment
2012-08-01 08:27:50 | 2012-08-06 08:54:03 |  | I work this out to be 48:54:03 i.e. 3 x full working days @ 10 hours per day plus 9½ hours for Saturday plus 9 hours for Sunday plus 24  minutes and 3 seconds for the Monday
2012-08-01 08:30:25 | 2012-08-01 09:06:17 |  | This is correct
2012-08-01 08:32:03 | 2012-08-01 11:31:59 |  | This is correct
2012-08-01 08:52:38 | 2012-08-01 09:46:18 |  | This is correct
2012-08-01 08:53:58 | 2012-08-01 13:41:30 |  | This is correct
2012-08-01 09:13:13 | 2012-08-01 09:14:10 |  | This is correct
2012-08-01 09:18:55 | 2012-08-02 10:23:36 |  | This is correct
2012-08-01 09:31:36 | 2012-08-01 09:31:49 |  | This is correct
2012-08-01 09:34:11 | 2012-08-01 13:09:21 |  | This is correct
2012-08-01 09:35:54 | 2012-08-01 13:00:00 |  | This is correct
2012-08-01 09:45:41 | 2012-08-01 09:46:04 |  | This is correct
2012-08-01 09:47:02 | 2012-08-01 09:47:24 |  | This is correct
2012-08-01 09:47:45 | 2012-08-01 09:48:17 |  | This is correct
2012-08-01 09:48:18 | 2012-08-01 13:47:19 |  | This is correct
2012-08-01 09:48:57 | 2012-08-02 11:22:22 |  | This is correct
2012-08-01 09:53:32 | 2012-08-09 12:45:03 |  | I think this should be 81:21:31, i.e. [NAME] for the 1st August plus 10 hours per day for 2/3/6/7/8 August, plus 04:15:03 for 9th August plus 18:30:00 for Saturday and Sunday
2012-08-01 09:57:02 | 2012-08-01 11:31:01 |  | This is correct
2012-08-01 09:58:48 | 2012-08-09 14:02:54 |  | I think this should be 82:34:07, i.e. 8:31:12 for the 1st August plus 10 hours per day for 2/3/6/7/8 August, plus 05:32:54 for 9th August plus 18:30:00 for Saturday and Sunday
2012-08-01 10:15:52 | 2012-08-01 10:17:23 |  | This is correct
2012-08-01 10:23:57 | 2012-08-01 11:27:41 |  | This is correct
2012-08-01 10:27:58 | 2012-08-01 11:59:31 |  | This is correct
2012-08-01 10:28:56 | 2012-08-01 14:13:47 |  | This is correct
2012-08-01 10:30:08 | 2012-08-01 14:10:03 |  | This is correct
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Power Logistics (2)

 | Power Logistics
 | 2002 Plan
 |  |  |  |  |  |  |  | Energy Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  | 0 | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 35214
ENAOUTSV | Outside Services | 0 |  |  |  |  | 0 | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | 0 | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  |  | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  |  | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  | 0 | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  | 0 | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 13 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  | 1 | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: AMI

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
AMINOLEAN ST W 12/12Z CN | 11054 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** Friday 7/21
AMINOLEAN C LM 12/12Z CN | 11055
AMINOLEAN B OR 12/12Z CN | 11056
AMINOLEAN BERY 12/12Z CN | 11053
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
AMINOLEAN ST W 12/12Z CN | 11054
AMINOLEAN C LM 12/12Z CN | 11055
AMINOLEAN B OR 12/12Z CN | 11056
AMINOLEAN BERY 12/12Z CN | 11053
Spreadsheet: 818330d1676744145-excel-formula-client-profiles-copy-
Sheet: dBase

Client Name | Location City | Location State | Business Description | Key Person 1 | Title 1 | Ownership % 1 | Key Person 2 | Title 2 | Ownership % 2 | Key Person 3 | Title 3 | Ownership % 3 | Key Person 4 | Title 4 | Ownership % 4 | Key Person 5 | Title 5 | Ownership % 5 | Entity Type | Tax Return | Software 1 | Access 1 | Software 2 | Access 2 | Software 3 | Access 3 | Services 1 | Services 2 | Services 3 | Services 4 | Services 5 | Services 6 | Services 7 | Services 8 | Services 9 | Services 10 | Payroll Provider | Tax Preparer | Tax Preparer Contact | Auditor | Audit Contact
Client 1 | Cincinnati | Ohio | P&C insurance sales. | [NAME] | Shareholder | 100 | [NAME] |  |  | Art |  |  |  |  |  |  |  |  | S Corporation | 1120S S Corporation | Quickbooks Online (QBO) | Online |  |  |  |  | Bookkeeping | Financial Statements | Year End Close | 1099's |  |  |  |  |  |  | ADP | Burke & Schindler | Jake
Client 2 | Omaha | Nebraska | [NAME] fast food sub restaurant. | [NAME] | Shareholder | 50 | Todd | Shareholder | 25 | [NAME] | Shareholder | 25 | Samantha |  |  |  |  |  | S Corporation | 1120S S Corporation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fermann Staun & Company | [NAME]
Client 3 | Cincinnati | Ohio | [NAME] fast food sub restaurant. | [NAME] | Shareholder | 81 | [NAME] | Shareholder | 19 | Mark | General Manager |  |  |  |  |  |  |  | Partnership | 1065 Partnership |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Burke & Schindler | Jake
Client 4 | Cincinnati | Ohio | Sports Bar | [NAME] | Shareholder | 50 | Nicole | Shareholder | 25 | [NAME] | Shareholder | 15 | Stephen | Shareholder | 10 |  |  |  | Partnership | 1065 Partnership |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Burke & Schindler | Jake
Spreadsheet: 673450d1587393145-sort-multiple-columns-using-custom-buttons-all-forum-topics-final-spreadsheet
Sheet: TOPICS

 |  | T
 |  | TOPICS | FORUM CATEGORY | REPLIES | VOICES | AUTHOR | DATE TOPIC CREATED | LAST ACTIVITY DATE | ATTACHMENTS | TOPIC I.D.#
Spreadsheet: 56210d1256302921-row-data-lookup-sort-query-book1-1-
Sheet: Sheet1

 |  | SHEET1
 |  | Name | CustID | Lines | Cases | Time Out | Time In | Time |  | NAME DATA
 |  | [NAME] | ABC | 5 | 22 | 12:12:00 | 13:19:00 | 01:07:00 | 1 | ADAM
 |  | DAVE | ABC | 1 | 5 | 13:20:00 | 13:30:00 | 00:10:00 | 1 | DAVE
 |  | [NAME] | DEF | 7 | 59 | 12:25:00 | 14:45:00 | 02:20:00 | 2 | [NAME]
 |  | DAVE | DEF | 1 | 10 | 10:00:00 | 12:00:00 | 02:00:00 | 2 | MIKE
 |  | TERRY | DEF | 1 | 12 | 13:05:00 | 13:33:00 | 00:28:00 | 2 | TERRY
 |  | DAVE | ABC | 1 | 4 | 13:05:00 | 13:33:00 | 00:28:00 | 2
 |  | ########
 |  | Name column is data validated to a list of names as on right
Spreadsheet: 840488d1692779404-formula-to-calculate-hours-by-a-rate-based-on-a-criteria-being-met-sample1
Sheet: Sheet1

 |  |  |  |  | Week 1 | Week 2 | Week 3 | Week 4
 |  |  |  | Type | hours | hours | hours | hours | rate
 |  |  |  | Actual | 25 | 45 | 36 | 36 | 103
 |  |  |  | Forecast | 36 | 12 | 18 | 45 | 103
 |  |  |  | Actual | 18 | 45 | 45 | 12 | 64
 |  |  |  | Forecast | 45 | 48 | 12 | 45 | 64
 |  |  |  | Actual | 12 | 10 | 45 | 48 | 89
 |  |  |  | Forecast | 45 | 36 | 48 | 10 | 89
 |  |  |  | Actual | 48 | 18 | 10 | 36 | 65
 |  |  |  | Forecast | 10 | 36 | 36 | 18 | 65
 |  |  |  | Total Forecast | 11243 | 9852 | 9234 | 9575
Spreadsheet: 167856d1342121930-count-the-maximum-number-consecutive-maximumduplicatesinarow
Sheet: Foglio1

NOME | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38
ROMA | N | N | N | N |  |  | N | N | N |  |  | N | N | N | N | N | N | N |  |  |  |  |  |  |  |  | N | N | N | N | N |  |  | N |  | N | N |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < -- FORMULA
Spreadsheet: 0c9d9840-714e-4d3d-858b-8d6f48686ce5
Sheet: Sheet1

CONTRACT NO. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
ITEM NO.
PLAN QUANTITY =
DATE | AEB # | BI-WEEKLY | ACCUM | AEB # | ACCUM | PAYMENT
 | TOTAL | TOTAL | TOTAL | PAY TOTAL | PAY TOTAL | NO.
11/23/08-12/06/08 | 14 | 14 | 14 | 14 | 14 | 32
12/07/08-12/20/08 | 7 | 7 | 21 | 7 |  | 33
12/21/08-01/03/09 | 7 | 7 | 28 | 7 |  | 34
1/04/09-1/17/09 | 14 | 14 | 42 | 14 |  | 35
1/18/09-1/31/09 | 14 | 14 | 56 | 14 |  | 36
2/01/09-2/14/09 | 14 | 14 | 70 | 14 |  | 37
2/15/09-2/28/09 |  | 0 | 70 |  |  | 38
3/01/09-3/14/09 |  | 0 | 70 |  |  | 39
3/15/09-3/28/09 | 7 | 7 | 77 | 7 |  | 40
3/29/09-4/11/09 | 7 | 7 | 84 | 7 |  | 41
4/12/09-4/25/09 | 14 | 14 | 98 | 14 |  | 42
4/26/09-5/09/09 | 14 | 14 | 112 | 14 |  | 43
FINAL TOTAL
Spreadsheet: 169446d1342848363-transfer-data-between-sheets-example
Sheet: Matching Categories

Division | Name | Price | QTY |  | My Cat Name
DOG FLEA POWDERS | A+ ANSWERS FROZEN DOG | 4.12 | 15 |  | Flea & Tick
DOG HEALTH - BEHAVIOR AIDS | A+ ANSWERS FROZEN DOG | 4.93 | 20 |  | Dog Health Care
DOG HEALTH - SKIN & COAT AIDS | A+ ANSWERS FROZEN DOG | 4.57 | 35 |  | Dog Health Care
[NAME] |  | 5.99 | 66 |  | Dog Grooming
POND SUPPLIES | POND PUMP | 10.99 | 6
Spreadsheet: 673413d1587374925-if-or-not-multiple-with-left-function-excel-eg
Sheet: Sheet1

 | Check starts with 0 |  |  |  | Check starts with any of 01/02/03/04/05/06/070/08/09
[PHONE] |  |  |  | [PHONE] | ??
[PHONE] |  |  |  | [PHONE]
[PHONE] |  |  |  | [PHONE]
[PHONE] |  |  |  | [PHONE]
[PHONE] |  |  |  | [PHONE]
[PHONE] |  |  |  | [PHONE]
[PHONE] |  |  |  | [PHONE]
[PHONE] |  |  |  | [PHONE]
[PHONE] |  |  |  | [PHONE]
Spreadsheet: 232158d1367343093-sumif-help-clean
Sheet: Rate Card

 | Vendor | Rate 1 | Rate 2 | Rate 3 | Rate 4 | Rate 5 | Rate 6 | Rate 7 | Rate 8 | Rate 9 | Rate 10
 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | - | 93443 | 93443
Cross_Currency Fixed-Fixed | - | 2283 | 2283
Cross_Currency Fixed-Float | - | 5880 | 5880
TOTAL | - | 101606 | 101606
Spreadsheet: 685172d1593774797-vlookup-formula-for-stock-control-stock-control-v1
Sheet: Lot register

Product | Component 1 | Component 2 | Component 3 | Component 4 | Component 5 | Component 6 | Component 7 | Component 8 | Component 9 | Component 10 | Component 11 | Component 12 | Component 13 | Component 14 | Component 15 | Component 16 | Component 17 | Component 18 | Component 19 | Component 20 | Component 21 | Component 22
Procedure Pack |  |  | 102 | 103
Handle |  |  |  |  | 104 | 105 | 106 | 107 | 108