tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 597714d1542027089-need-to-round-to-two-decimal-places-using-excel-2010-to-specification-astm-e-29-interpolation-with-rounding-astme29-sample
Sheet: Sheet1

THERMOCOUPLE or FIELD INST ERROR TO CORRECTION FACTORS
FILL COLUMNS D (ERROR) AND F (CORRECTION) IN MANUALLY FROM CALIBRATION CERT
 | ºC |  | ERROR |  | [NAME]
 | 0 |  | -0.13 |  | 0.13
 | 100 |  | -0.25 |  | 0.25
 | 200 |  | -0.46 |  | 0.46
 | 300 |  | -0.69 |  | 0.69
 | 400 |  | -0.74 |  | 0.74
 | 500 |  | -0.64 |  | 0.64
 | 600 |  | -0.5 |  | 0.5
 | 700 |  | 0.4 |  | -0.4
 | 800 |  | 1.09 |  | -1.09
 | 900 |  | 1.68 |  | -1.68
 | 1000 |  | 2.34 |  | -2.34
 | 1100 |  | 2.68 |  | -2.68
Spreadsheet: 847506d1698403110-extract-data-only-if-the-date-is-equal-to-workday-1-excel1
Sheet: Sheet1

 |  |  |  |  | Sales Date | Sales
 | Amount |  |  |  | 2023-10-20 00:00:00 | 246.14
 |  |  |  |  | 2023-10-20 00:00:00 | 39.7
 |  |  |  |  | 2023-10-19 00:00:00 | 53.03
 |  |  |  |  | 2023-10-20 00:00:00 | 152.9
 |  |  |  |  | 2023-10-18 00:00:00 | -40.93
 |  |  |  |  | 2023-10-19 00:00:00 | -408.69
 |  |  |  |  | 2023-10-26 00:00:00 | -911.25
 |  |  |  |  | 2023-10-20 00:00:00 | -86.14
 |  |  |  |  | 2023-10-23 00:00:00 | -129.77
 |  |  |  |  | 2023-10-31 00:00:00 | -423.8
 |  |  |  |  | 2023-11-02 00:00:00 | 158
 |  |  |  |  | 2023-09-20 00:00:00 | 53.21
 |  |  |  |  | 2023-11-04 00:00:00 | 100
 |  |  |  |  | 2023-10-26 00:00:00 | 50
Spreadsheet: 130637d1322499043-combine-data-from-two-sheets-example
Sheet: 2

Categories | part | call | price | eta date
ddu | 4x5d4 | 1233232459 | 1210 | 2012-11-01 00:00:00
aip | 4x5d6 | 123ewew461 | 3 | 2012-11-01 00:00:00
dnu | 4x5d1 | 123456 | 232 | 2012-11-01 00:00:00
dwu | 4x5d3 | 123wew458 | 7 | 2012-11-01 00:00:00
ais | 4x5d7 | 123462 | 4375 | 2012-11-01 00:00:00
adu | 4x5d5 | 123we460 | 300 | 2012-11-01 00:00:00
zwp | 4x5d10 | 123465 | 35434 | 2012-11-01 00:00:00
dsu | 4x5d2 | 3232 | 565 | 2012-11-01 00:00:00
Spreadsheet: 118906d1314093429-can-i-use-color-as-criteria-for-sumif-trap-qualifiers
Sheet: Sheet1

W.A.  STATE   ISSF   TRAP   QUALIFIER   SERIES
SHOOTERS NAME | WAGC | WAGC | CMT | WAGC | WAGC | CMT | CMT | CMT | ELIGIBLE | STATE TITLE | TOTAL
 | 2011-02-06 00:00:00 | 2011-03-13 00:00:00 | 2011-04-10 00:00:00 | 2011-05-01 00:00:00 | 2011-05-29 00:00:00 | 2011-07-24 00:00:00 | 2011-09-03 00:00:00 | 2011-09-04 00:00:00 | SCORES | 2011-10-22 00:00:00 | Sort
A. SNOOKE |  | 86 | 76 | 90 |  | 87 |  |  | 263
E. HARRIS |  | 76 | 81 | 88 |  | 93 |  |  | 262
P. PIERRE | 82 |  | 83 | 84 | 81 |  |  |  | 249
M. LA VERTU |  | 82 |  | 83 |  | 84 |  |  | 249
R. DAY | 70 | 75 | 70 | 81 |  | 76 |  |  | 232
[NAME] |  | 78 | 68 |  |  | 72 |  |  | 218
K. WAKELING |  | 65 | 70
M. WALKER |  |  | 62 |  |  | 77
P. BOYLSON |  | 73
[NAME] |  | 82 |  | 82
C. GILBERT |  | 70
G. HYDER | 70 | 75
M. KOSIVICH |  | 32
D. BOZURIC | 75 |  |  | 75 | 70
G. HOUGHTON | 65 |  |  |  |  | 72
B. VODDEN | 81 |  |  |  |  | 76
D. PAGE | 49 |  |  | 70
[NAME] | 74
A. TRAINOR | 60
[NAME] | 81
D. CARROLL |  |  |  | 81
[NAME] |  |  |  | 84
D. BLAKE |  |  |  | 53
[NAME] |  |  |  | 82 |  | 68
F. PEREIRA |  |  |  | 78 | 71
D. FOX |  |  |  | 83
[NAME] |  |  |  | 54
[NAME] |  |  |  | 51 | 53
ANDO |  |  |  | 29
[NAME] |  |  |  | 69
[NAME] |  |  |  |  |  | 85
C. VODDEN |  |  |  |  |  | 83
[NAME] |  |  |  |  |  | 62
T. DONOVAN |  |  |  |  |  | 54
[NAME] |  |  |  |  | 38
[NAME] |  |  |  |  | 70
[NAME] |  |  |  |  | 85
D. DICKSON |  |  |  |  | 67
[NAME] |  |  |  |  | 56
Spreadsheet: ac8d3009-9cf7-474f-9719-54c9d059eb78
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7652 | 50531 | Moises | Osuna | ESP | 71 | [NAME] | 00:06:23 | 03:40:58 | 00:07:52 | 03:25:07 | 1 | 08:53:26
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: EAST-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | 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
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10051 | -22403.68
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
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10051 | 22403.68
23 | Fuel:
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -99955 |  |  |  |  |  |  |  |  |  |  |  |  | 10051
25 |  | Demand
 | 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 |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 56264d1256391775-printing-with-filters-filter_print
Sheet: Sheet1

Department | Filter?
Dept1
Dept2
Dept3
Department | Name
Dept1 | [NAME]
Dept2 | [NAME]
Dept3 | [NAME]
Dept1 | [NAME]
Dept2 | [NAME]
Dept3 | [NAME]
Dept1 | [NAME]
Dept2 | [NAME]
Dept3 | Halley
Dept1 | [NAME]
Dept2 | [NAME]
Dept3 | [NAME]
Dept1 | [NAME]
Dept2 | [NAME]
Dept3 | [NAME]
Spreadsheet: 675736d1588443781-merge-cells-based-on-value-of-another-cell-fl
Sheet: SF2

 | LEARNER'S NAME |  |  | (2nd row for date, 1st row for day-count) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total for the Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H |  | CS
 | Last Name | First Name | Middle Name
 |  |  |  | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | M | T | W | TH | F | ABSENT | TARDY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INDEPENDENCE DAY |  | TYPHOON YOLANDA
 | MALE  | TOTAL Per Day
 | FEMALE  | TOTAL Per Day
 | Combined TOTAL PER DAY
Spreadsheet: 0f97f254-5169-46ea-a47b-748448458ae2
Sheet: Sheet1

Table 7--Peanuts:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  | Domestic |  | Seed & |  |  | Ending
Aug. 1 | stocks | Imports | Production | Total |  | food | Crush | residual | Exports | Total | stocks
 |  |  |  | Million pounds
2009/10 | 2130.1 | 71.9723171085282 | 3691.65 | 5893.722317108528 |  | 2674.875 | 434.61607 | 363.2314112794811 | 592.2518358290467 | 4064.974317108528 | 1828.748
2010/111 | 1828.748 | 64.5919124166918 | 4156.84 | 6050.179912416692 |  | 2839.7 | 586.553 | 502.4034567803826 | 605.5844556363093 | 4534.240912416692 | 1515.939
2011/122 | 1515.939 | 80 | 3648.5 | 5244.439 |  | 2860 | 425 | 373.4390000000003 | 525 | 4183.439 | 1061
1 Estimated.  2 Forecast.
Sources: Crop Production and Peanut Stocks and Processing, National Agricultural Statistics Service,
U.S. Department of Agriculture and Census Bureau, U.S. Department of Commerce.
Last update: | 2011-12-13 14:52:48.570000
Spreadsheet: 2833c41a-7642-4469-870d-f8664f10bfa4
Sheet: Sheet1

Nurse Manager Eligibility Documentation
Note:  Before beginning to enter data, create one line for each unit to be entered.  If additional lines are needed for a Unit Type, right click on a row number within that unit type and select "Insert".  Enter one unit per line.
Unit Type | Units | Name (Last, First) | Highest Nursing Degree | Job Title
Medical
Surgical
Med-Surg
Oncology
Step Down
Critical Care
Labor & Delivery
Ante/Post Partum
NICU
Pediatrics
PICU
Operating Room(s)
PACU
Amb. Procedure
Psych.
Rehab.
Ambulatory
Emergency Department
Specialty Practice
Acuity Adaptable
All Others
Spreadsheet: 155246d1336741363-an-auto-sorting-table-in-ms-excel-2010-copy-of-em2012bet
Sheet: Flag

 |  | A2
 |  | A3
 |  | A4
 |  | A5
 |  | A6
 |  | A7
 |  | A8
 |  | A9
 |  | A10
 |  | A11
 |  | A12
 |  | A13
 |  | A14
 |  | A15
 |  | A16
 |  | A17
Spreadsheet: kate_symes__19111__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-16 00:00:00 |  | 228.61 | 26144 | 118.81 | 10960
 | 2001-04-15 00:00:00 |  |  |  |  |  | 118.69 | 32280
 | 2001-04-14 00:00:00 |  | 156.91 | 19840 | 95.93 | 14120
 | 2001-04-13 00:00:00 |  | 156.91 | 19840 | 95.93 | 14120
 | 2001-04-12 00:00:00 |  | 176.32 | 27632 | 107.12 | 14896
 | 2001-04-11 00:00:00 |  | 178.5 | 21120 | 115.45 | 16912
 | 2001-04-10 00:00:00 |  | 181.91 | 26368 | 109.27 | 11712
 | 2001-04-09 00:00:00 |  | 157.87 | 22000 | 113.76 | 15928
 | 2001-04-08 00:00:00 |  |  |  |  |  | 113.77 | 45888
 | 2001-04-07 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-06 00:00:00 |  | 161.06 | 25232 | 100.79 | 16136
 | 2001-04-05 00:00:00 |  | 224.86 | 22592 | 122.93 | 16784
 | 2001-04-04 00:00:00 |  | 237.5 | 23824 | 129.77 | 12120
 | 2001-04-03 00:00:00 |  | 232.96 | 14960 | 120.77 | 12904
 | 2001-04-02 00:00:00 |  | 224.92 | 23056 | 133.39 | 11728
 | 2001-04-01 00:00:00 |  |  |  |  |  | 133.75 | 35784
 | 2001-03-31 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-30 00:00:00 |  | 169.38 | 25360 | 94.21 | 6472
 | 2001-03-29 00:00:00 |  | 163.49 | 34064 | 92.05 | 9080
 | 2001-03-28 00:00:00 |  | 131.03 | 22992 | 87.22 | 10736
 | 2001-03-27 00:00:00 |  | 120.72 | 26752 | 75.21 | 10280
 | 2001-03-26 00:00:00 |  | 281.51 | 17824 | 146.38 | 12680
 | 2001-03-25 00:00:00 |  |  |  |  |  | 146.56 | 32640
 | 2001-03-24 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-23 00:00:00 |  | 237.5 | 15296 | 143.54 | 10280
 | 2001-03-22 00:00:00 |  | 279.47 | 27312 | 173.78 | 5920
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
Spreadsheet: 2ddf94d2-7022-4c36-b723-59da763c4a98
Sheet: Other - Rural Housing & TX VET

 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-12-09 09:49:03.080000
Product: FMHA Rural Housing |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.5 | 100.45 | 100.45 | 100.325 | 99.95 |  | Price adjustments are cumulative
4.375 | 100.45 | 100.45 | 100.325 | 99.95
4.25 | 100.45 | 100.45 | 100.325 | 99.95 |  | and are added to price quote
4.125 | 98.625 | 98.625 | 98.5 | 98.125
4 | 98.25 | 98.25 | 98.125 |  |  | Credit Score Adjustment
 |  |  |  |  |  | 640 - 659 | -0.375
 |  |  |  |  |  | 660 - 719 | 0
 |  |  |  |  |  | 720 + | 0.125
 |  |  |  |  |  | Prices Do Not Include SRP
 |  |  |  |  |  | SRPs
 |  |  |  |  |  | See Government [NAME]
 |  |  |  |  |  | Expiration Dates
 |  |  |  |  |  | 15 Day | 2013-12-24 09:49:03.080000
 |  |  |  |  |  | 30 Day | 2014-01-08 09:49:03.080000
 |  |  |  |  |  | 45 Day | 2014-01-23 09:49:03.080000
 |  |  |  |  |  | 60 Day | 2014-02-07 09:49:03.080000
 |  |  |  |  |  | See Product Matrix for Complete Details
Spreadsheet: 812583d1673264493-logic-against-unique-id-to-update-status-column-logic
Sheet: Sheet1

Invoice No. | Status | Validation Date
51451578211 | Pending | 2023-01-02 00:00:00
51451578211 | Pending
51451578211 | Pending
5131896721 | Resolved | 2023-01-09 00:00:00
59084576320 | Pending | 2023-01-04 00:00:00
59084576320 | Pending | 2023-01-04 00:00:00
59084576320 | Pending
51318967313 | Resolved | 2023-01-09 00:00:00
51318967313 | Resolved | 2023-01-09 00:00:00
51318967313 | Resolved | 2023-01-09 00:00:00
51318967313 | Resolved | 2023-01-09 00:00:00
51318967313 | Resolved | 2023-01-09 00:00:00
51318967313 | Resolved | 2023-01-09 00:00:00
51318967313 | Resolved | 2023-01-09 00:00:00
51318967313 | Resolved | 2023-01-09 00:00:00
51318967313 | Resolved | 2023-01-09 00:00:00
Spreadsheet: 138996d1328032514-excel-2008-bypassing-the-3-conditional-formatting-limit-in-office-08-mac_vacation_planner_final
Sheet: Dec

 |  | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00 | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-21 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-28 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00
Week # |  | 14 |  |  |  |  |  |  | 15 |  |  |  |  |  |  | 16 |  |  |  |  |  |  | 17 |  |  |  |  |  |  | 18
 |  | 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
 | Total January | 2012-04-01 00:00:00 | 2012-04-02 00:00:00 | 2012-04-03 00:00:00 | 2012-04-04 00:00:00 | 2012-04-05 00:00:00 | 2012-04-06 00:00:00 | 2012-04-07 00:00:00 | 2012-04-08 00:00:00 | 2012-04-09 00:00:00 | 2012-04-10 00:00:00 | 2012-04-11 00:00:00 | 2012-04-12 00:00:00 | 2012-04-13 00:00:00 | 2012-04-14 00:00:00 | 2012-04-15 00:00:00 | 2012-04-16 00:00:00 | 2012-04-17 00:00:00 | 2012-04-18 00:00:00 | 2012-04-19 00:00:00 | 2012-04-20 00:00:00 | 2012-04-21 00:00:00 | 2012-04-22 00:00:00 | 2012-04-23 00:00:00 | 2012-04-24 00:00:00 | 2012-04-25 00:00:00 | 2012-04-26 00:00:00 | 2012-04-27 00:00:00 | 2012-04-28 00:00:00 | 2012-04-29 00:00:00 | 2012-04-30 00:00:00
 |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon
Peppina | 0
Peppinb | 0
Peppinc | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
0 | 0
Spreadsheet: 3b7be270-5c85-4c37-a0ac-a12bd74f2214
Sheet: Table 1.6

Monthly Statistical Bulletin
1.6 ANZ job advertisements
Month | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Advertisements (a) (b) – number
July
August
September
October
November
December
January
February
March
April
May
June
Annual average
Annual change (b) – per cent
July
August
September
October
November
December
January
February
March
April
May
June
Annual average
(a) Average total number of newspaper and internet job advertisements per week.
(b) Monthly figures have been seasonally adjusted. |  |  |  |  |  |  |  | Update
Source: ANZ Banking Group, Job advertisements series media release
Spreadsheet: 125123d1318884364-excel-2008-help-with-if-formula-sample
Sheet: Computational Perameters

 | FFP RATES |  |  | CPFF RATES
Person | Rate | O/H | Fringe | Rate | O/H | Fringe
[NAME] | 84.62 |  |  | 84.62
[NAME] | 84.62 |  |  | 84.62
[NAME] | 72.11 |  |  | 72.11
Spreadsheet: 89681d1289437282-days360-function-book1
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6
 | 2010-01-22 00:00:00 | 2010-03-24 00:00:00 | 2010-06-21 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
1 | 62
2 | 87
3 | -39771
4 | 0
5 | 0
Spreadsheet: 781144d1653024103-how-to-use-multiple-formula-at-one-cell-example-book
Sheet: Shipment Summary

Shipment ID | Shipping Fee | Misc Fee | Total Fee | Total Quantity | # of pallet | Shipment Weight | Total Weight of shipment
20000 | 293.75 |  |  | 2841 | 6 | 5058 | 4518
30000 | 119.43 | 250 |  | 660 | 1 | 710 | 1080
40000 | 440.31 |  |  | 3670 | 9 | 8682 | 6272
50000 | 119.94 |  |  | 100 | 1 | 420 | 200
60000 | 433.32 | 300 |  | 4509 | 10 | 7441 | 7137
Total
Spreadsheet: 840034d1692369785-help-extracting-values-where-text-contains-sql-or-db-and-put-in-a-new-column-samplespreadsheet-1-aligw
Sheet: Sheet1

 | Raw Data |  |  | Comments |  |  | Output Data
 |  | Servername |  | Want a method or formula for extracting ONLY the server names |  |  |  | [NAME]
 |  | server1 |  | that contain text 'db' OR 'SQL'
 |  | dbserver10 |  | Those names should be combined into a single column / list (called [NAME]) |  |  |  | dbserver13
 |  | [NAME] |  |  |  |  |  | sqlserver5
 |  | dbserver13 |  | It needs to be dynamic, so when people fill out the server names |  |  |  | [NAME]
 |  | sqlserver5 |  | column, it will work out / change the database list automatically. |  |  |  | sqlserver23
 |  | [NAME]
 |  | webserver1
 |  | webserver2
 |  | [NAME]
 |  | sqlserver23
 |  | appserver5
Spreadsheet: 837105d1689855121-multiple-if-formulas-policy
Sheet: Summary

Policy Implementation Summary
Manager Responsible | Service | Policies Implemented | Overall % Policies Implemented | Aggression & Violence 2018
Spreadsheet: 101456d1299588800-obtaining-data-from-separate-tabs-squidg-report
Sheet: TOTAL Shipments

EXAMPLE
2011
Week:
 | Reference Year to Date W/ending 10th April
 | Year to Date |  | Year to Date |  | Year to Date |  | Weekly Total |  | Weekly Total |  | Weekly Total |  | Weekly Total |  | Year to Date |  | Year to Date |  | Year to Date |  | Year to Date
 | Australia |  | US |  | UK |  | Australia |  | US |  | UK |  | All locations |  | Australia |  | US |  | UK |  | All locations
Opening Balance | 174 |  | 615 |  | 0 |  | 105 |  | 926 |  | 651 |  | 1682 |  | 226 |  | 483 |  | 1072 |  | 1781
New Tokens Received from RSA | 0 |  | 1985 |  | 2000 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 1000 |  | 0 |  | 1000
Replacement Tokens Received from RSA | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
30 Second tokens received | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
[NAME] | 6 |  | 2 |  | 61 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3 |  | 178 |  | 60 |  | 241
[NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
Expire tokens |  |  |  |  |  |  |  |  | 0 |  | 0
Total Tokens | 180 |  | 2602 |  | 2061 |  | 105 |  | 926 |  | 651 |  | 1682 |  | 229 |  | 1661 |  | 1132 |  | 3022
Total Tokens Sent | 91 |  | 1853 |  | 1853 |  | 8 |  | 122 |  | 230 |  | 360 |  | 130 |  | 889 |  | 708 |  | 1727
iLink | 78 |  | 1823 | 0.9838100377765785 | 1836 |  | 2 | 0.25 | 121 | 0.9918032786885246 | 230 | 1 | 353 | 0.9805555555555555 | 124 | 0.9538461538461539 | 779 | 0.876265466816648 | 672 | 0.9491525423728814 | 1575 | 0.9119861030689056
ISP | 1 |  | 2 | 0.001079330814894765 | 3 |  | 5 | 0.625 | 1 | 0.008264462809917356 |  | 0 | 6 | 0.01666666666666667 | 5 | 0.03846153846153846 | 1 | 0.001124859392575928 | 7 | 0.009887005649717515 | 13 | 0.007527504342790967
SAP | 1 |  | 21 | 0.01133297355639504 | 6 |  | 1 | 0.125 | 0 | 0 | 0 | 0 | 1 | 0.002777777777777778 | 1 | 0.007692307692307693 | 2 | 0.002249718785151856 | 1 | 0.001412429378531073 | 4 | 0.00231615518239722
CMS | 3 |  | 8 | 0.004317323259579061 | 8 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 Secs | 9 |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Check Totals | 92 |  | 1854 | 1.000539665407447 | 1853 |  | 8 | 1 | 122 | 1.000067741498442 | 230 | 1 | 360 | 1 | 130 | 1 | 782 | 0.8796400449943758 | 680 | 0.96045197740113 | 1592 | 0.9218297625940938
Total Tokens On-Hand | 89 |  | 749 |  | 208 |  | 97 |  | 804 |  | 421 |  | 1322 |  | 99 |  | 772 |  | 424 |  | 1295
Total 30-Second Tokens On-Hand | 14 |  | 0 |  | 0 |  | 0 |  | 25 |  | 0 |  | 25 |  | 10 |  | 0 |  | 0 |  | 10
Total 60-Second Tokens On-Hand | 75 |  | 749 |  | 208 |  | 97 |  | 779 |  | 421 |  | 1297 |  | 89 |  | 772 |  | 424 |  | 1285
What I want is to obtain information automatically  everytime I make a new Column. At the moment it only updates from Column P. If I make one next week it will still update from column P and not the latest one,
Spreadsheet: 701405d1603744182-formula-if-countif-gives-error-message-too-many-argument-forum-sample-2
Sheet: Feuil2

 |  | Phone 1 | Phone 2 |  |  | Ordered |  | Available
Poco X3 | Redmi Note 9 Pro Max | In Progress | YES |  |  | Mi 10 Ultra |  | Redmi Note 9 Pro Max
Mi 10 Ultra | Samsung Galaxy Note 20 Ultra | In Progress | Samsung Galaxy Note 20 Ultra |  |  | Poco X3 |  | iPhone 11 Pro Max
Samsung Galaxy S20 Ultra | iPhone 11 Pro Max | Samsung Galaxy S20 Ultra | YES
Spreadsheet: 847912d1698755488-bulk-substitute-in-a-spilling-array-cannot-split-v2-aligw
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array) |  |  | spilling array with bulk substitute
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty
 |  |  |  |  |  |  | split (via substituted range O2#) - works |  |  |  | AliGW
 |  |  |  |  |  |  | ID | Size | Label |  | ID | Size | Label
Spreadsheet: 454127d1459661401-overdue-days-calculation-due-sheet-calculator
Sheet: Sheet3

S.NO | DATE | PAID UP STOCK | PARTICULAR | DUE DATE | AMOUNT | PAYMENT RECEIVED | SATTELMENT | OVERDUE DAYS | INTEREST | BALANCE
1 | 2016-04-01 00:00:00 |  | INVOICE |  | 1000000 |  |  |  |  |  | YES |  | INVOICE
2 | 2016-04-05 00:00:00 |  | PAYMENT RECEIVED |  |  | 1000000 |  |  |  |  | NO |  | PAYMENT RECEIVED
3 | 2016-04-07 00:00:00 |  | INVOICE |  | 1000000 |  |  |  |  |  | NA |  | DEBIT NOTE
4 | 2016-04-12 00:00:00 |  | INVOICE |  | 200000 |  |  |  |  |  |  |  | CREDIT NOTE
5 | 2016-04-13 00:00:00 |  | PAYMENT RECEIVED |  |  | 200000
7
8
9
10
11
12
Spreadsheet: 273909d1382963839-vlookup-with-multiple-outcomes-hessing
Sheet: Sheet1

Materials | Values
Material1 | 62
Material1 | 46
Material4 | 41 |  |  | Count
Material1 | 39 |  | Material3
Material1 | 54
Material2 | 8
Material2 | 86
Material4 | 91
Material3 | 10
Material4 | 53
Material1 | 45
Material3 | 92
Material2 | 1
Material2 | 87
Material1 | 42
Material4 | 89
Material1 | 25
Material1 | 61
Material4 | 22
Material2 | 88
Material1 | 80
Material2 | 32
Material1 | 56
Material2 | 79
Material4 | 7
Material3 | 78
Material3 | 70
Material1 | 24
Material2 | 90