tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 817982d1676538725-get-specific-word-in-cell-example
Sheet: Sheet1

Front Bolt On Big Brake Kit CAR70 Black W/DBA 400x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R | Black | 400x32[NAME]
Front Bolt On Big Brake Kit CAR70 Grey W/DBA 400x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R | Grey | 400x32[NAME]
Front Bolt On Big Brake Kit CAR70 Red W/DBA 400x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R | Red | 400x32[NAME]
Front Bolt On Big Brake Kit CAR70 Black W/DBA 410x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R | Black | 410x32mm
Front Bolt On Big Brake Kit CR6380 355x32mm - VW Golf Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R |  | 355x32mm
Front Bolt On Big Brake Kit CR6380 380x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R |  | 380x32mm
Front Bolt On Big Brake Kit CAR69 Black W/DBA 355x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R | Black | 355x32mm
Front Bolt On Big Brake Kit CAR69 Grey W/DBA 355x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R | Grey | 355x32mm
Front Bolt On Big Brake Kit CAR69 Red W/DBA 355x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Front Bolt On Big Brake Kit CAR98 Silver 332x28mm Non-Floating - VW Golf Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Front Bolt On Big Brake Kit CAR89 TA6 355x32mm - VW Golf Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Front Bolt On Big Brake Kit CAR89 TA6 380x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake Kit CAR98 Silver 355x28[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake [NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake Kit CAR36 343x28mm - VW Golf Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake Kit CAR69 Black W/DBA 355x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake Kit CAR69 Grey W/DBA 355x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake Kit CAR69 Red W/DBA 355x32[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake Kit CAR98 Silver 343x28mm - VW Golf Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake Kit CAR49 TA4 355x28[NAME] Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Rear Bolt On Big Brake Kit CAR49 TA4 343x28mm - VW Golf Mk5/Mk6/Mk7/Mk7.5 Inc GTI, R
Spreadsheet: 122989d1317286764-asset-use-priority-solution-needed-assetpriority
Sheet: Sheet1

 |  | Inputs
 |  | Opening Balances |  | Priority | Amount | Check
 | 1 | Account 1 | $ | 3 | 1000
 | 2 | Account 2 | $ | 2 | 500
 | 3 | Account 3 | $ | 1 | 50000
 |  | Master Check
 |  | Calculations
 |  | Period Start
 |  | Period End |  |  |  | 2010-12-31 00:00:00
 |  | Cost to be funded.
 |  | Costs | $ |  |  |  | 2000 | 0 | 0 | 0 | 0 | 0
 |  | Funding
 |  | Account 1
 |  | Remaining Cost
 |  | Account 2
 |  | Remaining Cost
 |  | Account 3
 |  | Remaining Cost
 |  | Accounts
 | 1
 |  | Balance B/f
 |  | Drawdowns
 |  | Balance C/f
 | 2
 |  | Balance B/f
 |  | Drawdowns
 |  | Balance C/f
 | 3
 |  | Balance B/f
 |  | Drawdowns
 |  | Balance C/f
Spreadsheet: phillip_m_love__30650__9906_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPL |  | Texas-EGM |  | Storage |  | Transport |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1346250
2 |  | Liquidations |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  | -1346250 |  | -79467
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  | 15000 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 279317
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  | 56264 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -252973
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -6483 |  | 6483
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1475
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -14655
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance |  |  |  | -21750
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  | -100000 |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 9954543
37 |  | [NAME]
38 |  | Interdesk Charges |  |  |  |  |  | 224706
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 749823d1633027523-multi-selection-drop-down-list-with-cost-calculation-list-calc-sample
Sheet: Sheet1

No. | Item | Qty | Accessories | Acc Price
1 | b30 | 2 | Woble 4, Woble 5
 | b30 | 3 | Woble 1, Woble 2, Woble 3
Access List | Discrip | Vendor | Manuf | Cost | Retail
Woble 1 | Access | ABC | DEF | 50
Woble 2 | Access | ABC | DEF | 51
Woble 3 | Access | ABC | DEF | 60
Woble 4 | Access | HAL | GHI | 55
Woble 5 | Access | HAL | GHI | 40
Spreadsheet: 800978d1666019096-extract-values-from-table-according-to-specific-criteria-lookup-if
Sheet: Sheet1

 | Analyte: | HETE | cell type: | M2 | stimulus: | SACM |  |  |  |  |  |  |  |  | cell type | cpd | stimulus | conc | HETE | HEPE | PGE | PGF
 | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 |  |  |  | a | M2 | 1 | SACM | 0.3 | 2345 | 8645 | 3123 | 231
 | 0.3 | 3 | 0.3 | 3 | 0.3 | 3 | 0.3 | 3 | 0.3 | 3 |  |  |  | a | M2 | 1 | SACM | 3 | 345 | 53445 | 234 | 384
a | 2345 | 345 |  |  |  |  |  |  |  |  |  |  |  | a | M1 | 2 | SACM | 0.3 | 45234 | 434 | 535 | 345
b | 8 |  |  |  |  |  |  |  |  |  |  |  |  | a | M1 | 2 | SACM | 3 | 345 | 245 | 2 | 8648
c |  | 345 |  |  |  |  |  |  |  |  |  |  |  | a | M1 | 3 | SACM | 0.3 | 534 | 8534 | 4 | 864
d |  |  |  |  |  |  |  |  |  |  |  |  |  | b | M1 | 1 | SACM | 0.3 | 8 | 38 | 89876 | 3
e |  |  |  |  |  |  |  |  |  |  |  |  |  | b | M2 | 1 | nothing | 3 | 64 | 86 | 4 | 486
f |  |  |  |  |  |  |  |  |  |  |  |  |  | b | M1 | 2 | nothing | 0.3 | 123 | 834 | 3 | 864
 |  |  |  |  |  |  |  |  |  |  |  |  |  | b | M1 | 2 | nothing | 3 | 432 | 546 | 38 | 84898
 |  |  |  |  |  |  |  |  |  |  |  |  |  | b | M1 | 3 | nothing | 0.3 | 344 | 45638 | 435 | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  | c | M2 | 1 | SACM | 0.3 | 654 | 345 | 8 | 521
 |  |  |  |  |  |  |  |  |  |  |  |  |  | c | M2 | 1 | A23187 | 3 | 3453 | 345 | 385 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | c | M2 | 2 | SACM | 3 | 345 | 345 | 345 | 456
 |  |  |  |  |  |  |  |  |  |  |  |  |  | c | PBMC | 2 | A23187 | 3 | 4534 | 45 | 876123 | 2485
 |  |  |  |  |  |  |  |  |  |  |  |  |  | c | PBMC | 3 | A23187 | 0.3
Spreadsheet: 876995d1723697856-vstack-assistance-test
Sheet: TEST

[NAME] | [NAME] | Animal | Duration | Start | Days | End | Diff | Days Passed | Days Left | PRIORITY | STATUS | % DONE | DEADLINE | Todays Date | Progress | AT RISK | RISK ISSUE
Simpson | ABC | Dog | 12 weeks | 2024-05-22 00:00:00 | 84 | 2024-08-14 00:00:00 | 72 | 72 | 12 | High | In Progress | 0.5 |  | 2024-08-02 00:00:00 | 0.8571428571428571
Jetsons | DEF | Cat | 12 weeks | 2024-05-22 00:00:00 | 84 | 2024-08-14 00:00:00 | 84 | 84 | 0 |  | Complete | 1 |  | 2024-08-02 00:00:00 | 100%
Simpson | GHI | Dog | 12 weeks | 2024-05-22 00:00:00 | 84 | 2024-08-14 00:00:00 | 84 | 84 | 0 |  | Complete | 1 | 2024-07-19 00:00:00 | 2024-08-02 00:00:00 | 100%
Jetsons | JKL | Dog | 3 weeks | 2024-07-22 00:00:00 | 21 | 2024-08-12 00:00:00 | 11 | 11 | 10 |  | In Progress | 0 | 2024-07-22 00:00:00 | 2024-08-02 00:00:00 | 0.5238095238095238 | True | Permissions to access
Flintstones | MNO | Dog | 4 weeks | 2024-08-05 00:00:00 | 28 | 2024-09-02 00:00:00 | -3 | 0 | 28 | High | Not Started | 0 | 2024-09-17 00:00:00 | 2024-08-02 00:00:00 | 0
Flintstones | PQR | Cat | 1 week | 2024-08-05 00:00:00 | 7 | 2024-08-12 00:00:00 | -3 | 0 | 7 |  | Not Started | 0 |  | 2024-08-02 00:00:00 | 0 | TRUE | [NAME]
Jones | STU | Dog | 2 weeks | 2024-08-12 00:00:00 | 14 | 2024-08-26 00:00:00 | -10 | 0 | 14 |  | Not Started | 0 | 2024-08-26 00:00:00 | 2024-08-02 00:00:00 | 0
Jones | VWY | Cat | 1 week | 2024-08-26 00:00:00 | 7 | 2024-09-02 00:00:00 | -24 | 0 | 7 |  | Not Started | 0 | 2024-08-26 00:00:00 | 2024-08-02 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | If Animal = Dog, return [NAME], [NAME] in a list only
Spreadsheet: 211559d1359814811-sorting-based-on-matching-characteristics-binsort1_unique
Sheet: Sheet1

Object | [NAME] | Color | Shape
1 | 1 | blue | circle
2 | 1 | red | square
3 | 1 | blue | circle
4 | 2 | green | triangle
5 | 2 | blue | circle
6 | 2 | red | triangle
7 | 3 | yellow | circle
8 | 3 | green | triangle
9 | 3 | blue | circle
Spreadsheet: 837266d1689971306-v-xlookup-to-identify-date-range-overlaps-between-2-sheets-test_call_data
Sheet: Clockings

code | InClock | OutClock
12244 | 2023-07-16 19:05:00 | 2023-07-16 20:35:00
125405 | 2023-07-17 16:53:00 | 2023-07-18 06:54:00
123982 | 2023-07-17 22:09:00 | 2023-07-17 23:52:00
148457 | 2023-07-17 22:20:00 | 2023-07-18 00:18:00
124058 | 2023-07-18 15:30:00 | 2023-07-18 18:49:00
107348 | 2023-07-18 22:00:00 | 2023-07-19 07:00:00
155702 | 2023-07-18 22:52:00 | 2023-07-19 02:22:00
107348 | 2023-07-22 08:00:00 | 2023-07-22 20:00:00
Spreadsheet: 794613d1662140047-need-more-solutions-for-slow-calculations-solutions-for-faster-calculation
Sheet: Sheet1

 | Return to single specific value according to the specific items
 |  |  |  |  |  |  |  |  | tomatoes | <<---- key in any fruit names in the list
 | Date | Inv-numbers | fruit | fruit | fruit | fruit
 | 2015-05-01 00:00:00 | 1 | oranges | grapefruits | tomatoes | limes
 | 2015-05-02 00:00:00 | 2 | nectarines | rockmelons | peaches | plums |  |  |  | Solution 1
 | 2015-05-03 00:00:00 | 3 | bananas | tomatoes | apples | tomatoes |  |  |  | ([NAME]: no need array formula CLRL+Shift+Enter)
 | 2015-05-04 00:00:00 | 4 | strawberries | raspberries | blueberries | kiwifruit |  |  |  | (Cons: take so long time in calculation if the data is big)
 | 2015-05-05 00:00:00 | 5 | apples | pears | oranges | apples |  |  |  | Inv-numbers
 | 2015-05-06 00:00:00 | 6 | watermelons | rockmelons | honeydew | bananas
 | 2015-05-07 00:00:00 | 7 | apples | avocados | apples | nectarines
 | 2015-05-08 00:00:00 | 8 | raspberries | blueberries | peaches | plums
 | 2015-05-09 00:00:00 | 9 | bananas | apricots | peaches | tomatoes
 | 2015-05-10 00:00:00 | 10 | tomatoes | tomatoes | watermelons | tomatoes
Spreadsheet: df4f866b-e74b-430f-8cf6-8c76f0784ab4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8727 | 53418 | Gill | Fullen | GBR | 128 | 00:38:39 | 00:01:37 | 04:54:10 | 00:02:02 | 02:16:58 | 1 | 07:53:28
8727 | 11567 | Sophie | Chabut | FRA | 126 | 00:41:54 | 00:01:19 | 05:06:39 | [NAME] | 02:53:08 | 2 | 08:44:30
8727 | 57007 | Claudia | Schlindwein | GER | 127 | [NAME] | [NAME] | 05:06:19 | 00:02:14 | 02:51:27 | 3 | 08:46:03
8727 | 68259 | [NAME] | Peretto | ITA | 129 | 00:44:02 | 00:02:02 | 05:21:06 | 00:05:01 | 02:49:03 | 4 | 09:01:16
8727 | 78540 | Laure | Le Bihan | FRA | 130 | 00:42:37 | 00:01:45 | 05:04:07 | 00:02:41 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 707922d1607537206-if-a-match-then-enter-corresponding-value-sumif-etaf
Sheet: Sheet1

CUST ID | TOTAL
CUST1
CUST2
CUST3
CUST4
CUST5
CUST6
CUST7
CUST8
CUST9
Spreadsheet: mary_fischer__25435__May Monthly Logs
Sheet: SCADA

GE Wind Maintenance Corp.
Site:     FENNER
DATE:  6/01/02
SCADA MALFUNCTION LOG MAY 2002
Pad |  | Date | Date | Time | Time | Elapsed
Location | Description - Fault Indication/Activity | Begin | End | Begin | End | Hours
 | NONE
Scada problems that result in the loss of data which could effect availability.
Spreadsheet: 829971d1684587326-sequential-transactions-based-on-data-in-another-field-sequential-transactions2
Sheet: Sheet1

Existing Results |  |  | Desired Results |  |  |  | Results w/Formula |  |  | [NAME] in Col H
Transaction # | Item # |  | Transaction # | Item # |  |  | Transaction # | Item #
1 | 1 |  | 1 | 1 |  |  | 1 | 1
1 | 2 |  | 1 | 2 |  |  | 1 | 2
1 | 3 |  | 1 | 3 |  |  | 1 | 3
3 | 1 |  | 2 | 1 |  |  | 3 | 1
5 | 1 |  | 3 | 1 |  |  | 5 | 1
5 | 2 |  | 3 | 2 |  |  | 5 | 2
7 | 1 |  | 4 | 1 |  |  | 7 | 1
7 | 2 |  | 4 | 2 |  |  | 7 | 2
In the Existing Results, the |  |  | Would like the Transaction # to be |  |  |  | Result in H6 should be 2 since Item # in cell I6 changed to 1
Transaction # is not sequential |  |  | sequential every time the Item # |  |  |  | Result in H7 should be 3 since Item # in cell I7 changed to 1
 |  |  | changes to "1" |  |  |  | Result in H8 should be 3 since Item # in cell I8 did not change
 |  |  |  |  |  |  | Result in H9 should be 4 since Item # in cell I8 changed to 1
 |  |  |  |  |  |  | Result in H10 should be 5 since Item # in cell I10 did not change
 |  |  |  |  |  |  | Would like the Transaction # in Col H to be
 |  |  |  |  |  |  | sequential (1,2,3,4,5) every time the Item #
 |  |  |  |  |  |  | changes to "1"
Spreadsheet: 539190d1506003331-keeping-only-relevant-data-example
Sheet: Current Data

 |  | Name | Company
 | P001 | Red | Company A
 | P002 | Blue | Company A
 | P003 | Pink | Company A
 | P004 | Purple | Company A
 | P005 | Yellow | Company B
 | P006 | White | Company B
 | P007 | Black | Company C
Spreadsheet: 103630d1301376940-text-function-codes-and-devices
Sheet: Sheet1

 |  |  |  |  |  | codes (Combined Data)
 |  | Devices |  |  |  | app_4square_120x20_ar_101 |  | app_4square_120x20_en_101 |  | app_4square_168x28_ar_101 |  | app_4square_120x20_ar_101
 |  | 5228 |  |  | 1 | app_4square_120x20_ 5228_ar_101 | 1 | app_4square_120x20_5228_en_101 | 1 | app_4square_168x28_5228_ar_101 | 1 | app_4square_120x20_5228_ar_101
 |  | 5230 |  |  | 2 | app_4square_120x20_ 5230_ar_101 | 2 |  | 2 |  | 2
 |  | 5233 |  |  | 3 | app_4square_120x20_ 5223_ar_101 | 3 |  | 3 |  | 3
 |  | 5235 |  |  | 4 | app_4square_120x20_ 5235_ar_101 | 4 |  | 4 |  | 4
 |  | 5250 |  |  |  |  |  |  |  |  | 5
 |  | 5530
 |  | 5800
 |  | C6-00
 |  | C6-01
 |  | C7-00
 |  | N8-00
 |  | N97
 |  | N97 mini
 |  | X6
 |  | E7
 |  | 6120
 |  | 6700
Spreadsheet: 780359d1652424450-text-to-multiple-column-with-formulas-forum_upload
Sheet: Forum Q

Input | Output 1 | Output 2
TEC List | BC Act | EPBC Act
Not listed
Listed BC Act,E: Sandhill Pine Woodland in the Riverina, Murray-Darling Depression and NSW South Western Slopes bioregions (Part) ;
Listed BC Act,E: Allocasuarina luehmannii Woodland in the Riverina and Murray-Darling Depression Bioregions (Equivalent) wholly subset of ; Listed EPBC Act,E: Buloke Woodlands of the Riverina and Murray-Darling Depression Bioregions (Part) ;
Listed BC Act,CE: Artesian Springs Ecological Community in the Great Artesian Basin (Part) ; Listed BC Act,E: Myall Woodland in the Darling Riverine Plains, [NAME], Cobar Peneplain, Murray-Darling Depression, Riverina and NSW South Western Slopes bioregions (Part) ; Listed EPBC Act,E: Weeping Myall Woodlands (Equivalent) ;
Listed BC Act,E: Sandhill Pine Woodland in the Riverina, Murray-Darling Depression and NSW South Western Slopes bioregions (Part) ; Listed BC Act,E: [NAME] melvillei Shrubland in the Riverina and Murray-Darling Depression bioregions (Part) ;
Not listed
Spreadsheet: 778122d1650877429-would-like-to-ask-a-simple-way-to-organize-data-by-different-row-values-template-ans
Sheet: Sheet2

x\y | -0.02191 | -0.02206 | -0.02221 | -0.02236 | -0.02251 | -0.02266 | -0.02281 | -0.02296 | -0.02311 | -0.02326 | -0.02341 | -0.02356 | -0.02371 | -0.02386 | -0.02401 | -0.02416 | -0.02431 | -0.02446 | -0.02461 | -0.02476 | -0.02491 | -0.02506 | -0.02521 | -0.02536 | -0.02551 | -0.02566 | -0.02581 | -0.02596 | -0.02611 | -0.02626 | -0.02641 | -0.02656 | -0.02671 | -0.02686 | -0.02701 | -0.02716 | -0.02731 | -0.02746 | -0.02761 | -0.02776 | -0.02791 | -0.02806 | -0.02821 | -0.02836 | -0.02851 | -0.02866 | -0.02881 | -0.02896 | -0.02911 | -0.02926 | -0.02941 | -0.02956 | -0.02971 | -0.02986 | -0.03001 | -0.03016 | -0.03031 | -0.03046 | -0.03061 | -0.03076 | -0.03091 | -0.03106 | -0.03121 | -0.03136 | -0.03151 | -0.03166 | -0.03181 | -0.03196 | -0.03211 | -0.03226 | -0.03241 | -0.03256 | -0.03271 | -0.03286 | -0.03301 | -0.03316 | -0.03331
0.02
0.02025
0.0205
0.02075
0.021
0.02125
0.0215
0.02175
0.022
0.02225
0.0225
0.02275
0.023
0.02325
0.0235
0.02375
0.024
0.02425
0.0245
0.02475
0.025
0.02525
0.0255
0.02575
0.026
0.02625
0.0265
0.02675
0.027
0.02725
0.0275
0.02775
0.028
0.02825
0.0285
0.02875
0.029
0.02925
0.0295
0.02975
0.03
0.03025
0.0305
0.03075
0.031
0.03125
0.0315
0.03175
0.032
0.03225
0.0325
0.03275
0.033
0.03325
0.0335
0.03375
0.034
0.03425
0.0345
0.03475
0.035
0.03525
0.0355
0.03575
0.036
0.03625
0.0365
0.03675
0.037
0.03725
0.0375
0.03775
0.038
0.03825
0.0385
0.03875
0.039
Spreadsheet: 702177d1604136758-need-formula-to-merge-data-table-data-table-merge
Sheet: Sheet4

SIZE |  | AA | DD | EE
COLOUR | QUALITY
1 | A | 10 | 9 | 8
2 | B | 8 | 6 | 7
3 | C | 7 | 5 | 22
4 | D | 6 | 4 | 33
5 | E | 5 | 3 | 44
6 | F | 4 | 2 | 36
7 | G | 3 | 1 | 11
1 | B | 5 | 3 | 44
2 | A | 5 | 3 | 44
3 | D | 5 | 3 | 44
Spreadsheet: 793747d1661684738-multi-level-sort-cells-have-mixed-text-and-number-alphanumeric-sorting-aligw
Sheet: Sheet1

C1
C2
[NAME]
C11
D1
D2
D3
D4
D5
D6
D10
D11
D12
T1
T2
T10
T21
Spreadsheet: 790771d1659984540-totalling-columns-dependent-upon-text-day-team-flexi-sheet
Sheet: Aug 22

'[NAME] |  |  |  |  |  |  |  |  | Name
FLEXIBLE WORKING HOURS RECORD |  |  |  |  |  |  |  |  | Month | August | 2022
 |  |  |  |  |  | Hours brought forward
 | MORNING |  | AFTERNOON |  | Credit | Debit | Excess | Excess |  | Totals
 | Start | Finish | Start | Finish | Hours | Hours | or [NAME] | > 10 hrs | Comments | Daily | Toil
2022-08-01 00:00:00 |  |  |  |  | 7:00:00 | 0:00:00 |  |  | Public Holiday
2022-08-02 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-03 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-04 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-05 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-08 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-09 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-10 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-11 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-12 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-15 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-16 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-17 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-18 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-19 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-22 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-23 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-24 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-25 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-26 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-29 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-30 00:00:00 |  |  |  |  |  | 0:00:00
2022-08-31 00:00:00 |  |  |  |  |  | 0:00:00
Signed |  |  |  |  |  | Date |  |  | Net Hours Worked this period
Approved |  |  |  |  |  | Date |  |  | Flexitime credit/debit carried forward
 |  |  |  |  |  |  |  |  | Toil this month
 |  | Annual Leave remaining from previous month |  |  |  |  |  |  | Toil from previous month
 |  | Annual Leave taken this month |  |  |  |  |  |  | Toil taken |  | 00:00:00
 |  | Total Annual Leave remaining |  |  |  |  |  |  | Total toil
Spreadsheet: 68574d1269129818-subtotals-with-countif-example-version-1-
Sheet: DS Apps

 |  | 0 | 0
 |  | 0 | 3
0 |  |  | N
6
Item # | Name & Version | Is this app an OS? | Is this app a SAP Landscape app?
0 | Agentry Server 5.1 | N | N
0 | Auto Port Aggregation product J4240AA |  | Y
0 | Excel
1 | Ironport | Y | N
2 | [NAME] 5.2 | Y | N
3 | Word |  | N
Spreadsheet: 685826d1594215375-list-top-xx-names-with-values-top-5-results
Sheet: Sheet1

Name | Score | Previous Weeks score |  |  |  | Top 5 Scores
Contestant 1 | 3 | 0 |  |  |  | Contestant 15 | 29
[NAME] | 7 | 4 |  |  |  | Contestant 12 | 28
Contestant 3 | 3 | 0 |  |  |  | Contestant 24 | 27
[NAME] | 8 | 5 |  |  |  | Contestant 6 | 26
Contestant 5 | 23 | 20 |  |  |  | Contestant 11 | 25
Contestant 6 | 26 | 23
Contestant 7 | 12 | 9
Contestant 8 | 14 | 11
Contestant 9 | 2 | -1
Contestant 10 | 19 | 16 |  |  |  |  |  |  |  |  | Need this automating based on score
Contestant 11 | 25 | 22
Contestant 12 | 28 | 22
Contestant 13 | 21 | 18
Contestant 14 | 17 | 14
Contestant 15 | 29 | 10
Contestant 16 | 14 | 9
Contestant 17 | 2 | -1
Contestant 18 | 2 | -1
Contestant 19 | 14 | 15
Contestant 20 | 7 | 4
Contestant 21 | 5 | 2
Contestant 22 | 18 | 16
Contestant 23 | 24 | 21
Contestant 24 | 27 | 24
Contestant 25 | 3 | 14
Contestant 26 | 16 | 13
Contestant 27 | 18 | 15
Contestant 28 | 5 | 20
Contestant 29 | 2 | 4
Contestant 30 | 10 | 7
Spreadsheet: 3ab3136b-9cc2-4fa8-a6be-3a275b1dbb52
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 3/8/2014 12:03:57 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 790016d1659507193-split-cell-and-create-duplicate-rows-using-the-split-data-book1
Sheet: Sheet1

Name | Location | Computer | IP Addresses
Name1 | Location1 | Computer1 | 192.168.1.2, 192.168.1.3
[NAME] | Location2 | Computer2 | 192.168.1.5, 192.168.1.6,192.168.1.7
Name3 | Location3 | Computer3 | 192.168.1.10
Spreadsheet: 92242d1291860351-is-there-a-formula-function-to-consolidate-data-into-one-line-lmsloman-example
Sheet: Sheet1

Name | Account Number | Line # | Payment Amount | Credit Amount
[NAME] | 123456 | 1 | 20
[NAME] | 123456 | 1 | 0 | 15
[NAME] | 987654 | 2 | 50
[NAME] | 987654 | 2 | 0 | 100
[NAME] | 548634 | 6 | 966
[NAME] | 548634 | 6 | 0 | 6354
[NAME] | 458995 | 18 | 691
[NAME] | 458995 | 18 | 0 | 5487
Gomer Pyle | 654558 | 3 | 48
Gomer Pyle | 654558 | 3 |  | 100
[NAME] | 745558 | 1 | 12
[NAME] | 636654 | 3 | 69
[NAME] | 548872 | 9 | 65
[NAME] | 548872 | 9 |  | 1254
Spreadsheet: 838683d1691251574-countif-multiple-variations-of-products-sample-data-redbullgivesuwind-
Sheet: Sheet1

 |  |  |  | Customers who buy All | 2026
 |  |  | Unique Customers |  | 12 | 1234 | 1234567
 | 2026 | Product 1
 |  | Product 2
 | 2027 | Product 1
 |  | Product 2
 |  | Product 3
 |  | Product 4
 | 2028 | Product 1
 |  | Product 2
 |  | Product 3
 |  | Product 4
 |  | Product 5
 |  | Product 6
 |  | Product 7
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W91QUZ-09-A-0004-9L05

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W91QUZ-09-A-0004 9L05 |  |  | 1P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rejected
10251077 |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | Waiting 103
RETURN
Spreadsheet: 812055d1672932789-formula-to-show-the-reporting-month-instead-of-the-actual-month-based-on-week-number-reportingmonthsample2-1-
Sheet: Sheet1

Created By | Actual Month | Reporting Month | Week#
2022-11-28 00:00:00
2022-12-01 00:00:00
2023-12-05 00:00:00
2023-01-30 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00
2023-05-29 00:00:00
2023-06-02 00:00:00
2023-07-31 00:00:00
2023-08-03 00:00:00
2023-09-01 00:00:00
2023-10-31 00:00:00
2023-11-03 00:00:00
2023-12-01 00:00:00