tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 188838d1351005182-calculating-value-between-two-points-solar
Sheet: Sept

 |  | Service Dates: |  | 2011-09-01 00:00:00 |  |  | thru | 2011-10-01 00:00:00
 | PG&E RATES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | Baseline |  | 1.01 | 1.3 | 131-200% |  | 201-300% |  | 301%+
 | 1083.078 |  | 1083.078 | 1408.0014 | 1408.0014 | 2166.156 | 2166.156 | 3249.234 | 3249.234
 | 0.12845 |  | 0.14602 |  | 0.29561 |  | 0.33561 |  | 0.33561
 | 2004.66 |  | #N/A |  |  | 596.6586 |  | 0
 | RATE CHARGES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5 |  |  |  |  |  | 324.9234000000001
 | 257.498577 |  | #N/A |  | 89.25415997399998 |  | 0 |  | 0
 | Total Consumed |  |  | PG&E |  |  |  | Solar
 | 2004.66 |  |  | 1462 |  |  |  | 542.6600000000001
 | Total Charges |  |  | PG&E |  |  |  | Solar Savings
 |  |  |  | Billed |  | Min
 | #N/A |  |  | 202.95 |  | 4.58 |  | #N/A
 |  |  |  |  | 207.53
 | Date | Solar | Date | Solar | Date | Solar
 | 2012-09-01 00:00:00 | 19.53 | 2012-09-12 00:00:00 | 17.9 | 2012-09-22 00:00:00 | 12.32 |  | Solar | 542.6600000000001
 | 2012-09-02 00:00:00 | 19.11 | 2012-09-13 00:00:00 | 18.52 | 2012-09-23 00:00:00 | 17.75
 | 2012-09-03 00:00:00 | 18.89 | 2012-09-14 00:00:00 | 18.1 | 2012-09-24 00:00:00 | 17.9
 | 2012-09-04 00:00:00 | 19.97 | 2012-09-15 00:00:00 | 18.72 | 2012-09-25 00:00:00 | 18.62 | [NAME] |  | 0.9196118733941946
 | 2012-09-05 00:00:00 | 6.63 | 2012-09-16 00:00:00 | 18.95 | 2012-09-26 00:00:00 | 17.7 | Estimate |  | 590.0967741935484
 | 2012-09-06 00:00:00 | 11 | 2012-09-17 00:00:00 | 18.5 | 2012-09-27 00:00:00 | 17.34 | Actual |  | 542.6600000000001
 | 2012-09-07 00:00:00 | 17.84 | 2012-09-18 00:00:00 | 19.17 | 2012-09-28 00:00:00 | 17.61 | Estimate
 | 2012-09-08 00:00:00 | 17.93 | 2012-09-19 00:00:00 | 19 | 2012-09-29 00:00:00 | 18.72 |  |  | Sep | Oct
 | 2012-09-09 00:00:00 | 18.3 | 2012-09-20 00:00:00 | 18.8 | 2012-09-30 00:00:00 | 18.2 | Proposed Prod |  | 573 | 530
 | 2012-09-10 00:00:00 | 17.2 | 2012-09-21 00:00:00 | 16.65 | 2012-10-01 00:00:00 | 18.06 | Days |  | 30 | 31
 | 2012-09-11 00:00:00 | 17.73 |  |  |  |  | Per Day |  | 19.1 | 17.09677419354839
 |  |  |  |  |  |  | Billed Days |  | 30 | 1
 |  |  |  |  |  |  | Total |  | 573 | 17.09677419354839
 |  |  |  |  |  |  |  | T2 | 921.5820000000001
 |  |  |  |  |  |  |  |  | 0.01757
 |  |  |  |  |  |  |  | T3 | 596.6586
 |  |  |  |  |  |  |  |  | 0.14959
 |  |  |  |  |  |  |  | T4 | -161.4959999999999
 |  |  |  |  |  |  |  |  | 0.04000000000000004
Spreadsheet: 4b21f7e0-e782-435d-aab5-7e4b54907df9
Sheet: Cabrillo

REGIONAL DIRECTORY 2014/2015
CABRILLO UNIFIED SCHOOL DISTRICT
Dr. [NAME], Superintendent | [NAME], Assistant [NAME] | Leach Crystal, Chief Business Offical
498 [NAME] | 498 [NAME] | 498 [NAME]
Half Moon Bay, CA 94019 | Half Moon Bay, CA 94019 | Half Moon Bay, CA 94019
O: [PHONE] | O: (650) 712-7107 | O: [PHONE]
F: [PHONE] | F: (650) 726-0279 | F: [PHONE]
[EMAIL] | [NAME] | [EMAIL]
[NAME], Account Technician II. | TBD, [NAME] | [NAME], Administrative Asst.
498 [NAME]. | 498 [NAME] | 498 Kelley Ave.
Half Moon Bay, CA  94019 | Half Moon Bay, CA 94019 | Half Moon Bay, CA  94019
O: [PHONE] | O: [PHONE] | O:  [PHONE]
C: N/A | C: [PHONE] | C:
F: [PHONE] | F: [PHONE] | F: [PHONE]
[EMAIL] |  | [EMAIL]
[NAME], [NAME] | [NAME], PreKinder Educator (MESRP) | Cristal Hernandez, Advocate
498 [NAME] | 498 [NAME] | 498 Kelley Ave.
Half Moon Bay, CA 94019 | Half Moon Bay, CA 94019 | Half Moon Bay, CA  94019
O: [PHONE] | O: [PHONE] | O:  [PHONE]
C: [PHONE] | C: N/A | F: [PHONE]
F: [PHONE] | F: [PHONE] | [NAME]
[NAME] | [NAME]
[NAME], Paraprofessional/ [NAME] Teacher Aid
498 [NAME]
Half Moon Bay, CA 94019
O: [PHONE]
[EMAIL]
Spreadsheet: 155078d1336663204-calculating-the-plane-of-a-physical-object-bestfit_data_results
Sheet: Sheet1

Probe # | X | Y | Z | Differential
14 | -185.95 | 1.54 | -0.28 | -0.09131033166439512
15 | -106.58 | 11.45 | -0.39 | 0.06115680440351745
16 | 30.38 | 11.68 | -0.44 | 0.1973255574008045
17 | 97.24 | 11.68 | -0.18 | -0.02052338085833455
18 | 189.1 | -56.27 | 0.01 | -0.1007027651719765
19 | 191.01 | -142.63 | 0.1 | -0.1235260374420867
21 | 174.23 | -264.83 | 0.05 | 0.00924684460410341
23 | 106.28 | -337.86 | 0 | 0.07219814376229972
24 | 30.38 | -353.42 | -0.09 | 0.1262346971265199
25 | -93.88 | -353.42 | 0.06 | -0.102103175520321
26 | -195.48 | -337.92 | -0.09 | -0.02799635664013084
Calculated plane | -0.0007639252392619583 | 0.0006304360586683107 | -0.2529043464756994
 | 0.0006304360586683107 | -0.0007639252392619583 | -1 | -0.2529043464756994
 | 0.0006304357494297552 | -0.0007639248645449124 | -0.9999995094846633 | -0.2529042224222388
Spreadsheet: 777081d1650128414-searchable-dropdown-values-not-updating-if-modified-test-dashboard-6
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | ACTIVITY | LAST BILLED
10
9 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
8 | Drinkland |  |  |  |  |  |  |  |  |  |  | Active
7 | Air & Chaleur |  |  |  |  |  |  |  |  |  |  | Inactive
6 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
5 | A.A. [NAME] |  |  |  |  |  |  |  |  |  |  | Active
4 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
3 | J-R Bat |  |  |  |  |  |  |  |  |  |  | Active
2 | Gremibel |  |  |  |  |  |  |  |  |  |  | Active
1 | DRL Express |  |  |  |  |  |  |  |  |  |  | Active
Spreadsheet: 106347d1303519715-help-with-autofilling-cells-auto-timesheet2204-1-1freezepane-master
Sheet: Info

 |  | NIL
 |  | SA1
 |  | SA2
 |  | SA3
 |  | SA4
 |  | SA5
 |  | SA6
 |  | SA7
 |  | SA8
 |  | SA9
 |  | [NAME]
 |  | SA11
 |  | SA12
 |  | SA13
 |  | SA14
 |  | SA15
 |  | SA16
 |  | SA17
 |  | SA18
 |  | SA19
 |  | SA20
 |  | SA21
 |  | SA22
 |  | SA23
 |  | SA24
 |  | SA25
 |  | SA26
 |  | SA27
 |  | SA28
 |  | IJ1
 |  | IJ2
 |  | IJ3
 |  | IJ4
 |  | IJ5
 |  | IJ6
 |  | IJ7
 |  | IJ8
 |  | IJ9
 |  | IJ10
 |  | IJ11
 |  | IJ12
 |  | IJ13
 |  | IJ14
 |  | IJ15
 |  | IJ16
 |  | IJ17
 |  | IJ18
 |  | IJ19
 |  | IJ20
 |  | IJ21
 |  | IJ22
 |  | IJ23
 |  | IJ24
 |  | IJ25
 |  | IJ26
 |  | IJ27
 |  | IJ28
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | 0 | 11 | 11
Europe/North America | 0 | 11 | 11
Index | 8366 | 56 | 8422
Europe/Other | 3728.5 | 26 | 3754.5
North America/Asia | 4637.5 | 30 | 4667.5
Other | 11 | 18 | 29
TOTAL | 8377 | 85 | 8462
Spreadsheet: 121112d1315853439-subtotaling-data-with-a-sum-and-count-for-multiple-criteria-multiple-subtotalt
Sheet: Sheet1

name | fac | Year | Month | IP_OP | MarginWBadDebt
[NAME] | UT | 2010 | 10 | I | 15
[NAME] | UT | 2010 | 11 | I | 11
[NAME] | UT | 2010 | 11 | O | 1
[NAME] | UT | 2010 | 12 | I | 15
[NAME] | UT | 2010 | 12 | O | 15
[NAME] | UT | 2011 | 1 | I | 11
[NAME] | UT | 2011 | 2 | I | 1
[NAME] | UT | 2011 | 3 | I | 5
[NAME] | UT | 2011 | 4 | I | 3
[NAME] | UT | 2011 | 5 | I | 4
[NAME] | UT | 2011 | 6 | I | 1
[NAME] | UT | 2011 | 7 | I | 1
[NAME] | TX | 2010 | 10 | I | 5
[NAME] | TX | 2010 | 10 | O | 5
[NAME] | TX | 2010 | 11 | I | 1
[NAME] | TX | 2010 | 11 | O | 58
[NAME] | TX | 2010 | 12 | I | 58
[NAME] | TX | 2010 | 12 | O | 417
[NAME] | TX | 2011 | 1 | I | 100
[NAME] | TX | 2011 | 1 | O | 250
[NAME] | TX | 2011 | 2 | I | 345
Spreadsheet: 383afe4f-b445-4b29-8a58-1903c34f23aa
Sheet: Sheet1

Supplemental Table 5: Genes less-induced at d45+ in AGM blood  (AGM blood time ANOVA) | Unnamed: 1 | Unnamed: 2
Accession # | Primary Sequence Name | Sequence Description
NM_005101 | ISG15 | ISG15 ubiquitin-like modifier
NM_005532 | IFI27 | interferon, alpha-inducible protein 27
NM_001001887 | IFIT1 | Homo sapiens interferon-induced protein with tetratricopeptide repeats 1 (IFIT1), transcript variant 2, mRNA.
NM_001549 | IFIT3 | interferon-induced protein with tetratricopeptide repeats 3
NM_002462 | MX1 | myxovirus (influenza virus) resistance 1, interferon-inducible protein p78 (mouse)
NM_030643 | APOL4 | apolipoprotein L, 4
NM_002053 | GBP1 | guanylate binding protein 1, interferon-inducible, 67kDa
XM_166305 | KRM_1_04889
NM_021991 | JUP | [NAME]
NM_002346 | LY6E | [NAME] 6 complex, locus E
NM_014349 | APOL3 | apolipoprotein L, 3
NM_024119 | DHX58 | [NAME] (Asp-Glu-X-His) box polypeptide 58
NM_002463 | MX2 | myxovirus (influenza virus) resistance 2 (mouse)
NM_016816 | OAS1 | 2',5'-oligoadenylate synthetase 1, 40/46kDa
NM_003733 | OASL | 2'-5'-oligoadenylate synthetase-like
NM_001013000 | HERC6 | Hect domain and RLD 6
NM_003661 | APOL1 | apolipoprotein L, 1
NM_017414 | USP18 | ubiquitin specific peptidase 18
NM_001565 | CXCL10 | chemokine (C-X-C motif) ligand 10
NM_017523 | XAF1 | XIAP associated factor-1
NM_001002264 | EPSTI1 | epithelial stromal interaction 1 (breast)
NM_052942 | GBP5 | guanylate binding protein 5
NM_022147 | RTP4 | receptor (chemosensory) transporter protein 4
NM_020350 | AGTRAP | angiotensin II receptor-associated protein
NM_005533 | IFI35 | interferon-induced protein 35
NM_002201 | ISG20 | interferon stimulated exonuclease gene 20kDa
Spreadsheet: 881567d1729676665-creation-of-duplicate-rules-in-conditional-formatting-wip-cf-help
Sheet: 2023

Orders | Layout Name | Pts No. | R type concrete cast | Deep type concrete cast & Drilled | Order Delivered
January
2014373846 | [NAME] | 44AB | c | cdc | d
2014375582 | [NAME] | 56AB | c | cdc | d
2014583667 | [NAME] | 705AB/704AB | c | cdc | d
2014460574 | Cardiff Bay | 8009AB | c | cdc | d
2014458753 | Cardiff Bay | 8008AB | c | cdc | d
2014431718 | Rhymney | 9402 | c | cdc | d
2014405140 | Carstairs Junction | 324AB | c | cdc | d
2014488538 | Carstairs Junction | 300AB | c | cdc | d
2014532261 | Carstairs Junction | 319 | c | cdc | d
2014491252 | Carstairs Junction | 322 | c | cdc | d
2014526018 | Moorthorpe | 2252 | c | cdc | d
2014518411 | Moorthorpe | 2254 | c | cdc | d
2014525025 | Moorthorpe | 2257AB/2259 | c | cdc | d
2014610540 | Basingstoke Great West Jcn | 2520 | c | cdc | d
2014610637 | Colchester | 3069 | c | cdc | d
February
2014563591 | Carstairs Junction | 310AB | c | cdc | d
2014616653 | [NAME] | 2308 | c | cdc | d
2014619560 | Aberbeeg | 8918 | c | cdc | d
2014617279 | Carstairs Junction | 311 | c | cdc | d
2014650412 | Carstairs Junction | 312 | c | cdc | d
2014675423 | Worting Junction | 2541AB | c | cdc | d
2014574954 | Carstairs Junction | 303AB | c | cdc | d
2014641364 | Carstairs Junction | 304 | c | cdc | d
2014649022 | Carstairs Junction | 308 | c | cdc | d
2014652622 | Carstairs Junction | 301 | c | cdc | d
2014661616 | [NAME] | 872AB | c | cdc | d
2014667790 | Holywell to Seghill | 3402 | c | cdc | d
2014642778 | Holywell to Seghill | 3403 | c | cdc | d
2014646408 | Carstairs Junction | 305A | c | cdc | d
2014683673 | Carstairs Junction | 305B | c | cdc | d
2014717297 | [NAME] | 9404 | c | cdc | d
Spreadsheet: 683182d1592546907-invert-table-by-content-from-people-assigned-to-a-task-to-tasks-assigned-to-a-person-sample
Sheet: Sheet1

task | responsible 1 | responsible 2 | responsible 3 |  |  |  |  | person | task 1 | task 2 | task 3
buy groccery | [NAME] | [NAME] |  |  |  |  |  | [NAME] | buy groccery | eat food
cook food | [NAME] |  |  |  | ---> auto update ---> |  |  | [NAME] | cook food | eat food
eat food | [NAME] | [NAME] |  |  |  |  |  | [NAME] | buy groccery
Spreadsheet: 857926d1706779997-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-01-feb-v1
Sheet: Drop Downs

Dispatch Employee List |  |  |  |  |  |  |  | Description | Fund |  | Description | Dept |  | Description | S/C | Rate |  | Acct |  | Earnings IDs | Description | Action
PSID | Rcd | Name | Shift | Base | UA | Straight |  | [NAME] | 48541 |  | Police | 43425 |  | Regular OT | 0 | OTPR |  | 601933 |  | OTPR | Overtime 1.5 Paid | Include in OT Column
11111 | 0 | BRANT | Day | 4000 | No |  |  | [NAME] | 90000 |  | Parking | 43426 |  | [NAME]. | 0 | OTPR |  | 601935 |  | OTST | Overtime [NAME] | Include in Reg Hours Column
22222 | 0 | CALDERA | Day | 4280 | No |  |  | Parking | 47205 |  | [NAME] | 63491 |  | COVID 19 | 0 | OTPR |  |  |  | HG6 | Holiday Worked Paid | Include in Hol Column
33333 | 0 | CEE-SUMNER | Day | 5250 | No |  |  | [NAME] | 46715 |  | Preview Day | 62493 |  | [NAME] | 42508 | OTST |  |  |  | CTO | Overtime Credited | Include in CTO Column
66666 | 0 | COSTA | Grave | 6395 | Yes |  |  | Peach [NAME] | 496E5 |  | Feria de Educacion | 62485 |  | RAD - 49631 | 42504 | OTPR |  |  |  | HOL(W) CTO | Holiday Worked Credited | Include in CTO Column
44444 | 0 | JENKS | Grave | 4100 | No |  |  | Vintage Days | 496F6 |  | Peach [NAME] | 35309 |  | Training | 42513 | OTPR |  |  |  | RDO HOL PD | Holiday RDO - Paid | Not included for calculation
55555 | 0 | SANCHEZ | Swing | 5500 | Yes |  |  |  |  |  | Fire Watch | 84145 |  | Investigations | 42503 | OTPR |  |  |  | RDO HOL CTO | Holiday RDO - CTO | Not included for calculation
 |  |  |  |  |  |  |  |  |  |  | Vintage Days | 63491 |  | Striking Activities | 42512 | OTPR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-WASTE OT | 42605 | OTPR
 |  |  |  |  |  |  |  |  |  |  | SD Earnings ID | Rate |  | Library Services | 42517 | OTPR
 |  |  |  |  |  |  |  |  |  |  | SHE08 | 0.23 |  | Shuttle Service | 42637 | OTPR
 |  |  |  |  |  |  |  |  |  |  | SHGRV | 2.3 |  | [NAME] | 0 | OTPR
 |  |  |  |  |  |  |  |  |  |  | SHN08 | 2.2 |  | Chicano Youth Conference | 48509 | OTPR
 |  |  |  |  |  |  |  |  |  |  | SHSWG | 1.35 |  | Feria de Educacion | 48511 | OTPR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Peach [NAME] | 30903 | OTPR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Vintage Days | 0 | OTPR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Description | CMS | TRN | Amount | Acct
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Adv Post | PC8 | 8ST8 | 450 | 601934
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Community Relations | SX | 8ST9 | 100 | 601937
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Crime Prevention | SX | 8ST9 | 100 | 601937
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRU | SX | 8ST9 | 100 | 601937
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Detective | SX | 8ST9 | 200 | 601937
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Detective - Evidence | SX | 8ST9 | 300 | 601937
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Motor | SX | 8ST9 | 200 | 601937
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Post | PC0 | 8ST0 | 200 | 601934
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Range Master | SX | 8ST9 | 100 | 601937
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 19 - table 1

Reconciliation - Profit to EBITDA | 4Q10 | 4Q11 | YTD 10 | YTD 11
Profit - Ambev holders | 2585.798000000003 | 3032.492 | 7561.387000000001 | 8640.996
Non-controlling interest | 26.988 | 31.718 | 57.846 | 78.788
Income tax expense | 570.456 | 940.992 | 2084.45 | 2521.995
Profit before taxes | 3183.242000000003 | 4005.202 | 9703.683 | 11241.779
Share of results of associates | -0.157 | -0.251 | -0.184 | -0.479
Net finance results | 75.398 | 90.959 | 319.4110000000001 | 468.1439999999999
Special items | 66.528 | 13.492 | 150.825 | -23.104
Normalized EBIT | 3325.011000000003 | 4109.402 | 10173.735 | 11686.34
Depreciation & amortization - total | 496.581 | 396.735 | 1567.213 | 1454.738
(-) Depreciation & amortization - special items | 0.411 | 0 | -33.916 | 0
Normalized EBITDA | 3822.003000000003 | 4506.137 | 11707.032 | 13141.078
Spreadsheet: joe_parks__14998__BridgeDPR0524
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 2711.733556899998 | 4714.733556899998 | 10005.7335569
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 2711.733556899998 | 4714.733556899998 | 10005.7335569
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 831738d1685859851-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-individual
Sheet: COM

Example | Code | From Date | To Date | Days | Connected Load | Load | Rate/Month | Calculation method used for reference | Remarks
1 | COM | 2022-01-11 00:00:00 |  |  |  | 10 |  | (50*G2*E2)/30 | here 50 is the rate for the from load 1 to load 10, 30 is the days of one month
2 | COM | 2022-09-22 00:00:00 |  | 65 |  | 40 |  | ((10*50*E3)+(85*E3*(G3-10)))/30 | here 10 is load, 50 is rate for upto 10 load, 85 is rate for load greater than 10
3 | COM | 2023-03-20 00:00:00 |  | 59 |  | 75 |  | ((10*50*E4)+(85*E4*(G4-10)))/30 | here 10 is load, 50 is rate for upto 10 load, 85 is rate for load greater than 10
Spreadsheet: 798abb06-2e43-42d0-abc2-1a202172fb04
Sheet: Sheet1

Programa | 21  CALI ES  NUESTRA GENTE | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Macroproyecto | Código indicador | Meta | Indicador | Unidad de medida | Variables | [NAME] | [NAME] |  | 2008 | 2009 | 2010 | 2011 | Fuente de información | Responsable
 |  |  |  |  |  |  | 2007
21.1  SEMBRANDO ESPERANZA | 211302 | A diciembre de 2011, se aumenta la atención Integral de 160 a 240 limitados | Discapacitados atendidos | Número | V = Discapacitados atendidos | Vi | 160 | Programado | 50 | 60 | 70 | 80 | SDTBS, SCT | SDTBS
21.2  NUEVA GENERACIÓN, NUEVA OPCIÓN | 212103 | En el período 2008-2011, se desarrollan 12 eventos anuales por cada grupo poblacional (Niños, Jóvenes, [NAME]) | Eventos por grupos poblacionales | Número | V = Eventos por grupos poblacionales | Vi | 0 | Programado | 36 | 36 | 36 | 36 | SCT | SCT
 | 212104 | A junio de 2011 se han implementado las fases de la campaña institucional [NAME] en Cali con voluntariado juvenil y [NAME] empresa privada | [NAME] campaña [NAME] creo en Cali | % | V = Avance en la campaña [NAME] creo en Cali | Vi | 0 | Programado | 25 | 50 | 75 | 100 | SCT | SCT
21.3  LA SABIDURÍA, PATRIMONIO DE TODOS | 213301 | A diciembre de 2011, se publican 50 cronicas sobre saberes de adulto mayor | Crónicas apoyadas | Numero | V = Crónicas apoyadas | Vi | 0 | Programado | 10 | 12 | 13 | 15 | SCT | SCT
Spreadsheet: 108059d1305155969-index-formula-with-if-excel-forum-example-18
Sheet: Sheet1

 |  |  |  | Expected Result in yellow….I just need a name of a person one time if their primary number (>50%) is 1.
Person | # |  | 1 Persons Across | [NAME] | [NAME] | Fred | [NAME]
[NAME] | 1
[NAME] | 2 |  |  | What formula goes in F2 that can be dragged across to I2 (Looking at Data table A2:B24)?
[NAME] | 2
[NAME] | 2
[NAME] | 1
Fred | 2
[NAME] | 1
[NAME] | 2
Fred | 1
Fred | 1
[NAME] | 2
[NAME] | 1
[NAME] | 2
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 2
[NAME] | 2
Fred | 1
Spreadsheet: 768288d1644916860-copy-data-from-a-master-sheet-smart_d1006
Sheet: Feb

 | SHEET | PRODUCT | PRICE |  |  |  |  |  |  |  |  |  |  |  |  | NOTES
 |  | Product Feb Sold | 9.99 | 0 | 0 | 0 | 31267759 | Karoq SE L 1.5 TSI 150 PS 6G Man | Emerald Green Metallic | Black | 0 | In Transit from Factory | 0 | 0 | 0 | [NAME]
 | Feb | [NAME]. | 9.99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Resevered Feb
Spreadsheet: 885140d1734556879-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-original
Sheet: BookRefTeamA

Team A
Surname | First name | Number | [NAME] | Task A | Part of Task A completed | Blind column, just to filter for "TR" task A | Next part of Task A | x1 | Task B | Part of Task B completed | Blind column, just to filter for "TR" task B | Next part of Task B | x2 | Task C | Part of Task C completed | Blind column, just to filter for "TR" task C | Next part of Task C | [NAME] | Task D | Part of Task D completed | Blind column, just to filter for "TR" task D | Next part of Task D
 |  |  |  | M06 | ADV |  |  |  | M25 | ADV |  |  |  | M16 | BSC-SF |  |  |  | M11 | BSC-TR2
 |  |  |  | M07 | ADV |  |  |  | M16 | ADV
 |  |  |  | M15 | X |  |  |  | M05 | X |  |  |  | M04 | X
 |  |  |  | M22 | BSC-SF |  |  |  | M05 | X |  |  |  | M45 | X
 |  |  |  | M15 | BSC |  |  |  | M05 | X |  |  |  | M09 | BSC-SF
Spreadsheet: mark_taylor__24964__methanol plant allowances DERCs ERCs
Sheet: Summary

 |  | Methanol Plant NOx Allowances, Discrete Emission Reduction Credits (DERCs), and Emission Reduction Credits (ERCs)
 |  |  | 2008 | NOx | NOx | VOC | VOC | CO | PM
FIN | EPN | Description | NOx Allowances | DERCs | ERCs | DERCs | ERCs | DERCs | DERCs
C106 | 101 | Ammonia Treatment
C219 | 016 | Low-Pressure Methanol Off-Gas
C221 | 016 | Water Column Reflux
C222 | 016 | Light Ends Column Vent
E138 | 102 | [NAME], South
F101A | 032/033 | [NAME]
FL2 | 016 | Flare, E (1)
F-MEOH | F113 | [NAME]
K101 | 053 | K101 Leak Gas
K101A | 027 | Comp. Engine, 5500 hp
K101B | 028 | Comp. Engine, 5500 hp
K101C | 029 | Comp. Engine, 5500 hp
K110 | 026 | Air Comp. Engine, 265 hp
T206 | 103 | [NAME], North
 |  | TOTAL
Spreadsheet: 825649d1681453943-a-formula-to-show-the-current-date-and-bank-holidays-book1-3-
Sheet: Sheet1

 | Rota
 | 2024 |  | Today's Date:
 | Important Dates
 | Date | Description
 |  | New Year's Day
 |  | Good Friday
 |  | Easter Monday
 |  | Early May bank holiday
 |  | Bank holiday for the coronation of King [NAME]
 |  | Spring bank holiday
 |  | Summer bank holiday
 |  | Christmas Day
 |  | Boxing Day
Spreadsheet: 759995d1639884803-an-alternate-for-nested-if-assign-value-based-on-multiple-conditions-vj-raj-
Sheet: Summary

Part | Group | Std Cost | LPP | Delta | On Hand | 2022 Req | Excess | On Order | Last Purchase Date | Month and Year | Suggested Std Cost | LPP<[NAME] | 2022 Req=0 | On Order=0 | Group=B | Purchase Date >= 7/1/2021 | Purchase Date >= 12/31/2021 |  | [NAME]
101 | Group A | 2 | 1 |  | 10 | 20 |  | 0 | 2021-12-02 00:00:00 |  |  |  |  |  |  |  |  | [NAME]
102 | Group A | 3 | 6 |  | 5 | 4 |  | 2 | 2021-01-01 00:00:00
103 | Group B | 4 | 7 |  | 4 | 2 |  | 2 | 2021-06-25 00:00:00
104 | Group B | 5 | 8 |  | 6 | 10 |  | 10 | 2021-02-04 00:00:00
105 | Group C | 12 | 15 |  | 80 | 100 |  | 50 | 2021-03-15 00:00:00
106 | Group C | 15 | 15 |  | 100 | 50 |  | 0 | 2021-08-05 00:00:00
107 | Group D | 4 | 6 |  | 20 | 30 |  | 0 | 2021-09-21 00:00:00 |  |  |  |  |  |  |  |  | LPP
108 | Group D | 8 | 10 |  | 15 | 20 |  | 10 | 2021-02-02 00:00:00
109 | Group E | 7 | 9 |  | 200 | 250 |  | 100 | 2021-07-08 00:00:00
110 | Group E | 50 | 65 |  | 10 | 8 |  | 0 | 2021-11-21 00:00:00 |  |  |  |  |  |  |  |  | LPP
 |  |  | List of criteria:
- If LPP<[NAME] cost and (2022 Req = 0,On Order=0), return LPP
- if LPP>Std cost and (2022 Req=0, On Order=0), return [NAME] cost
- if LPP>Std and (2022 Req<>0, On Order=0), return LPP
- If LPP<[NAME] and (2022Req=0, On Order<>0, group = Group B), return LPP, if group<>Group B but everything else is TRUE, return [NAME])
- If LPP>Std and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return LPP
- If LPP<[NAME] and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return the LPP or [NAME] (which ever is the highest)
 |  |  |  |  |  |  | << 1st condition is LPP<[NAME] so that the "highest" must be [NAME].
Spreadsheet: 855978d1705404967-dynamic-array-for-cumulative-count-book1-fast
Sheet: Sheet1

Item | Old School | Tocol
Spreadsheet: 862153d1709908197-reverse-calculation-net-to-gross-v2a
Sheet: tax tables

annual tax rate schedule
annual taxable income | rate | PwC flat tax reduction | marginal tax addition
0 | 0.15 | 0 | 0
53359 | 0.15 | 0
106717 | 0.205 | 0
165430 | 0.26 | 0
235675 | 0.29 | 0
https://answers.microsoft.com/en-us/msoffice/forum/all/calculate-gross-payment-based-on-net/ddf87d85-adf2-4c6d-9d69-3f9bae1c4750